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
|
CREATE TABLE comparateur_marque (
id_marque int(10) NOT NULL auto_increment,
nom varchar(50) NOT NULL,
adresse1 varchar(100) NOT NULL,
adresse2 varchar(100) NOT NULL,
cp varchar(7) NOT NULL,
ville varchar(50) NOT NULL,
pays varchar(50) NOT NULL,
tel varchar(20) NOT NULL,
fax varchar(20) NOT NULL,
email varchar(50) NOT NULL,
web varchar(50) NOT NULL,
logo varchar(200) NOT NULL,
PRIMARY KEY (id_marque),
KEY nom (nom)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE comparateur_type (
id_type int(5) NOT NULL auto_increment,
`type` varchar(50) NOT NULL,
image varchar(100) NOT NULL,
parent int(3) NOT NULL default '0',
PRIMARY KEY (id_type)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE comparateur_velo (
id_velo int(5) NOT NULL auto_increment,
id_marque int(10) NOT NULL,
id_type int(10) NOT NULL,
modele varchar(100) NOT NULL,
ref varchar(100) NOT NULL,
cadre varchar(250) NOT NULL,
amortisseur varchar(250) NOT NULL,
fourche varchar(250) NOT NULL,
direction varchar(250) NOT NULL,
boitier varchar(250) NOT NULL,
pedalier varchar(250) NOT NULL,
pedale varchar(250) NOT NULL,
potence varchar(250) NOT NULL,
tige_selle varchar(250) NOT NULL,
cintre varchar(250) NOT NULL,
der_av varchar(250) NOT NULL,
der_ar varchar(250) NOT NULL,
frein varchar(250) NOT NULL,
manette varchar(250) NOT NULL,
selle varchar(250) NOT NULL,
roue varchar(250) NOT NULL,
cassette varchar(250) NOT NULL,
pneu varchar(250) NOT NULL,
chaine varchar(250) NOT NULL,
poids float(3,2) NOT NULL,
taille varchar(250) NOT NULL,
technologie text NOT NULL,
description text NOT NULL,
prix float(9,2) NOT NULL,
photo varchar(200) NOT NULL,
annee year(4) NOT NULL,
date_ajout datetime NOT NULL,
date_modif datetime NOT NULL,
afficher tinyint(1) NOT NULL,
geometrie varchar(200) NOT NULL,
moyeux varchar(250) NOT NULL,
rayon varchar(250) NOT NULL,
levier_frein varchar(250) NOT NULL,
PRIMARY KEY (id_velo),
KEY id_marque (id_marque,id_type,prix,photo,afficher)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
Partager