F1qxVKMG

1CREATE TABLE IF NOT EXISTS Test ( 
2  IDtest INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
3  date_test1 DATE NOT NULL,
4  date_test2 DATE NOT NULL
5  ) ENGINE=InnoDB;
6
7CREATE TABLE IF NOT EXISTS Test2 ( 
8  IDtest2 INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
9  payload INT,
10  beginning DATE NOT NULL,
11  ending DATE NOT NULL,
12  istested BOOLEAN,
13  nought BOOLEAN,
14  test_idtest INT NOT NULL,
15  FOREIGN KEY (test_idtest) references Test (IDtest)
16  ) ENGINE=InnoDB;