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
| #------------------------------------------------------------
# Script MySQL.
#------------------------------------------------------------
#------------------------------------------------------------
# Table: MOT
#------------------------------------------------------------
CREATE TABLE MOT(
ID_mot Int Auto_increment NOT NULL ,
Mot Varchar (25) NOT NULL
,CONSTRAINT MOT_Idx INDEX (Mot)
,CONSTRAINT MOT_PK PRIMARY KEY (ID_mot)
)ENGINE=InnoDB;
#------------------------------------------------------------
# Table: DEFINITION
#------------------------------------------------------------
CREATE TABLE DEFINITION(
ID_mot Int NOT NULL ,
ID_def Int NOT NULL ,
Definition Varchar (255) NOT NULL
,CONSTRAINT DEFINITION_PK PRIMARY KEY (ID_mot,ID_def)
,CONSTRAINT DEFINITION_MOT_FK FOREIGN KEY (ID_mot) REFERENCES MOT(ID_mot)
)ENGINE=InnoDB;
#------------------------------------------------------------
# Table: TYPE
#------------------------------------------------------------
CREATE TABLE TYPE(
ID_type Int Auto_increment NOT NULL ,
code_type Smallint NOT NULL ,
libelle_type Varchar (25) NOT NULL ,
ordre_type Smallint NOT NULL
,CONSTRAINT TYPE_PK PRIMARY KEY (ID_type)
)ENGINE=InnoDB;
#------------------------------------------------------------
# Table: Typer
#------------------------------------------------------------
CREATE TABLE Typer(
ID_type Int NOT NULL ,
ID_mot Int NOT NULL
,CONSTRAINT Typer_PK PRIMARY KEY (ID_type,ID_mot)
,CONSTRAINT Typer_TYPE_FK FOREIGN KEY (ID_type) REFERENCES TYPE(ID_type)
,CONSTRAINT Typer_MOT0_FK FOREIGN KEY (ID_mot) REFERENCES MOT(ID_mot)
)ENGINE=InnoDB; |
Partager