1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129
| -- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- <a href="http://www.phpmyadmin.net" target="_blank">http://www.phpmyadmin.net</a>
--
-- Serveur: nebil.xxx.titi.fr
-- Généré le : Samedi 29 Juillet 2006 à 23:21
-- Version du serveur: 5.0.23
-- Version de PHP: 4.4.2
--
-- Base de données: `zuzu`
--
-- --------------------------------------------------------
--
-- Structure de la table `annonce`
--
CREATE TABLE `annonce` (
`id` tinyint(5) NOT NULL auto_increment,
`cat` tinyint(3) NOT NULL,
`souscat` char(4) collate latin1_general_ci NOT NULL,
`annee` char(4) collate latin1_general_ci NOT NULL,
`prix` varchar(7) collate latin1_general_ci NOT NULL,
`kilometrage` varchar(6) collate latin1_general_ci NOT NULL,
`carburant` tinyint(1) NOT NULL,
`carrosserie_type` tinyint(2) NOT NULL,
`carrosserie_couleur` tinyint(2) NOT NULL,
`vehicule_type` tinyint(1) NOT NULL,
`puissance` smallint(3) NOT NULL,
`transmission` smallint(1) NOT NULL,
`date_annonce` char(8) collate latin1_general_ci NOT NULL,
`accident` tinyint(1) NOT NULL,
`clim` tinyint(1) NOT NULL,
`clim_auto` tinyint(1) NOT NULL,
`cuir` tinyint(1) NOT NULL,
`vitr_elec` tinyint(1) NOT NULL,
`gps` tinyint(1) NOT NULL,
`sieg_elec` tinyint(1) NOT NULL,
`toi_ouvran` tinyint(1) NOT NULL,
`sieg_chauf` tinyint(1) NOT NULL,
`radio_cd` tinyint(1) NOT NULL,
`radio_cass` tinyint(1) NOT NULL,
`abs` tinyint(1) NOT NULL,
`bag_cond` tinyint(1) NOT NULL,
`bag_pass` tinyint(1) NOT NULL,
`bag_lat` tinyint(1) NOT NULL,
`lamp_xenon` tinyint(1) NOT NULL,
`verou_cent` tinyint(1) NOT NULL,
`alarm` tinyint(1) NOT NULL,
`anti_dem` tinyint(1) NOT NULL,
`anti_pat` tinyint(1) NOT NULL,
`cont_dyn` tinyint(1) NOT NULL,
`quatrex4` tinyint(1) NOT NULL,
`tuning` tinyint(1) NOT NULL,
`jante_allia` tinyint(1) NOT NULL,
`ordi_bord` tinyint(1) NOT NULL,
`radar_recul` tinyint(1) NOT NULL,
`feux_anti` tinyint(1) NOT NULL,
`direct_assis` tinyint(1) NOT NULL,
`regul_vites` tinyint(1) NOT NULL,
`garantie` tinyint(1) NOT NULL,
`offre_pro` tinyint(1) NOT NULL,
`offre_parti` tinyint(1) NOT NULL,
`uniquement_avec_photo` tinyint(1) NOT NULL,
`pays` varchar(15) collate latin1_general_ci NOT NULL,
`cp` tinyint(5) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=16 ;
-- --------------------------------------------------------
--
-- Structure de la table `images`
--
CREATE TABLE `images` (
`IdImage` tinyint(3) NOT NULL,
`Commentaire` varchar(50) collate latin1_general_ci NOT NULL,
`Alt` varchar(20) collate latin1_general_ci NOT NULL,
`Path` varchar(20) collate latin1_general_ci NOT NULL,
`Pathminiature` varchar(20) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`IdImage`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Structure de la table `membre`
--
CREATE TABLE `membre` (
`id` tinyint(5) NOT NULL auto_increment,
`nom` varchar(15) collate latin1_general_ci NOT NULL,
`prenom` varchar(15) collate latin1_general_ci NOT NULL,
`adresse` varchar(50) collate latin1_general_ci NOT NULL,
`cp` char(5) collate latin1_general_ci NOT NULL,
`pays` char(1) collate latin1_general_ci NOT NULL,
`tel` char(10) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `script_categorie`
--
CREATE TABLE `script_categorie` (
`id_cat` int(5) NOT NULL auto_increment,
`designation` varchar(50) collate latin1_general_ci NOT NULL,
UNIQUE KEY `designation` (`designation`),
KEY `id_cat` (`id_cat`)
) ENGINE=MyISAM AUTO_INCREMENT=121 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=121 ;
-- --------------------------------------------------------
--
-- Structure de la table `script_sous_categorie`
--
CREATE TABLE `script_sous_categorie` (
`id_scat` int(5) NOT NULL auto_increment,
`idcat` int(5) NOT NULL default '0',
`designation` varchar(50) collate latin1_general_ci NOT NULL default '',
KEY `idcat` (`idcat`),
KEY `id_scat_2` (`id_scat`)
) ENGINE=MyISAM AUTO_INCREMENT=1134 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1134 ; |
Partager