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 71 72 73 74 75 76 77 78 79 80 81 82 83
| #------------------------------------------------------------
# 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 Char (5) NOT NULL ,
libelle_type Varchar (25) NOT NULL ,
ordre_type TinyINT NOT NULL
,CONSTRAINT TYPE_PK PRIMARY KEY (ID_type)
)ENGINE=InnoDB;
#------------------------------------------------------------
# Table: GENRE
#------------------------------------------------------------
CREATE TABLE GENRE(
ID_genre Int Auto_increment NOT NULL ,
code_genre Char (1) NOT NULL ,
libelle_genre Char (8) NOT NULL ,
ordre_genre TinyINT NOT NULL
,CONSTRAINT GENRE_PK PRIMARY KEY (ID_genre)
)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;
#------------------------------------------------------------
# Table: Qualifier
#------------------------------------------------------------
CREATE TABLE Qualifier(
ID_mot Int NOT NULL ,
ID_genre Int NOT NULL
,CONSTRAINT Qualifier_PK PRIMARY KEY (ID_mot,ID_genre)
,CONSTRAINT Qualifier_MOT_FK FOREIGN KEY (ID_mot) REFERENCES MOT(ID_mot)
,CONSTRAINT Qualifier_GENRE0_FK FOREIGN KEY (ID_genre) REFERENCES GENRE(ID_genre)
)ENGINE=InnoDB; |
Partager