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
| CREATE TABLE vehicules (
`id` INT(10) NOT NULL,
`marque_id` INT(10) NOT NULL,
`moteur_id` INT(10) NOT NULL,
`modele_id` INT(10) NOT NULL,
`type_id` INT(10) NOT NULL,
`description` TEXT,
`photo` TEXT,
`prix` FLOAT,
`tel` TEXT,
PRIMARY KEY (`id`)
);
CREATE TABLE marque(
`id` INT(10) NOT NULL,
`description` TEXT,
PRIMARY KEY( `id` )
);
CREATE TABLE type(
`id` INT(10) NOT NULL,
`description` TEXT,
PRIMARY KEY( `id` )
);
CREATE TABLE moteur(
`id` INT(10) NOT NULL,
`description` TEXT,
PRIMARY KEY( `id` )
);
CREATE TABLE modele(
`id` INT(10) NOT NULL,
`description` TEXT,
PRIMARY KEY( `id` )
); |
Partager