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
|
DROP TABLE IF EXISTS Nom_Table_Fille;
CREATE TABLE IF NOT EXISTS Nom_Table_Fille
(
Champ1 VARCHAR(20) NOT NULL,
Champ2 INT NOT NULL,
Champ3 SMALLINT NOT NULL DEFAULT '0',
UNIQUE KEY (Champ1,Champ2)
) TYPE=INNODB;
DROP TABLE IF EXISTS Nom_Table_Mere1;
CREATE TABLE IF NOT EXISTS Nom_Table_Mere1
(
Champ1 VARCHAR(20) NOT NULL,
Champ2 VARCHAR(1) NOT NULL DEFAULT 'S',
Champ3 VARCHAR(30) NOT NULL,
Champ4 VARCHAR(10) NOT NULL,
Champ5 VARCHAR(50) DEFAULT '0',
Champ6 VARCHAR(1) NOT NULL DEFAULT 'D',
Champ7 TINYINT NOT NULL DEFAULT '1',
PRIMARY KEY (Champ1),
UNIQUE (Champ3)
) TYPE=INNODB;
DROP TABLE IF EXISTS Nom_Table_Mere2;
CREATE TABLE IF NOT EXISTS Nom_Table_Mere2
(
Champ1 INT NOT NULL,
Champ2 VARCHAR(30) NOT NULL,
Champ3 VARCHAR(30) NOT NULL,
PRIMARY KEY (Champ1),
UNIQUE KEY (Champ2,Champ3)
) TYPE=INNODB; |
Partager