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
| CREATE TABLE IF NOT EXISTS Categorie
(
IdCategorie int(2) UNSIGNED ZEROFILL NOT NULL auto_increment,
NameCategorie varchar(50) NOT NULL,
PRIMARY KEY(IdCategorie)
)TYPE=InnoDB;
CREATE TABLE IF NOT EXISTS SousCategorie
(
IdSousCategorie int(3) UNSIGNED ZEROFILL NOT NULL auto_increment,
NameSousCategorie varchar(50) NOT NULL,
Categorie_id int(2) UNSIGNED ZEROFILL NOT NULL,
index(Categorie_id),
PRIMARY KEY(IdSousCategorie),
FOREIGN KEY(Categorie_id) REFERENCES Categorie(IdCategorie) ON DELETE CASCADE ON UPDATE CASCADE
)TYPE=InnoDB;
CREATE TABLE IF NOT EXISTS Specialite
(
IdSpecialite int(3) UNSIGNED ZEROFILL NOT NULL auto_increment,
NameSpecialite varchar(50) NOT NULL,
NameDomaine varchar(50) NOT NULL,
SousCategorie_id int(3) UNSIGNED ZEROFILL NOT NULL,
index(SousCategorie_id),
PRIMARY KEY(IdSpecialite),
FOREIGN KEY(SousCategorie_id) REFERENCES SousCategorie(IdSousCategorie) ON DELETE CASCADE ON UPDATE CASCADE
)TYPE=InnoDB; |
Partager