· 8 years ago · Apr 09, 2018, 09:12 PM
1CREATE TABLE IF NOT EXISTS VOL(
2NUMVOL smallint(6) primary key NOT NULL auto_increment,
3NUMPIL smallint(6) NOT NULL,
4NUMAV smallint(6) NOT NULL,
5DATE_VOL DATE NOT NULL,
6HEURE_DEP TIME NOT NULL,
7HEURE_ARR TIME NOT NULL,
8VILLE_DEP VARCHAR(32) NOT NULL,
9VILLE_ARR VARCHAR(32) NOT NULL,
10CONSTRAINT NUMPIL Foreign Key(NUMPIL) references PILOTE(NUMPIL),
11CONSTRAINT NUMAV Foreign Key(NUMAV) references PILOTE(NUMAV)
12)