rQTZYbvq

1use db2;
2
3CREATE TABLE IF NOT EXISTS DriversLicence (
4  release_date DATE NULL DEFAULT NULL,
5  id INT(11) NOT NULL AUTO_INCREMENT,
6  PRIMARY KEY (id))
7  ENGINE = InnoDB
8  AUTO_INCREMENT = 5
9  DEFAULT CHARACTER SET = utf8;
10
11CREATE TABLE IF NOT EXISTS Person (
12  id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
13  name VARCHAR(20) NOT NULL DEFAULT '',
14  country VARCHAR(20) NULL DEFAULT NULL,
15  liicence_id INT(11) NOT NULL,
16  PRIMARY KEY (id, liicence_id),
17  INDEX fk_Person_DriversLicence_idx (liicence_id ASC),
18  CONSTRAINT fk_Person_DriversLicence
19  FOREIGN KEY (liicence_id)
20  REFERENCES DriversLicence (id)
21    ON DELETE NO ACTION
22    ON UPDATE NO ACTION)
23  ENGINE = InnoDB
24  AUTO_INCREMENT = 6
25  DEFAULT CHARACTER SET = utf8;
26
27CREATE TABLE IF NOT EXISTS Children (
28  id INT(11) NOT NULL AUTO_INCREMENT,
29  name VARCHAR(45) DEFAULT 'slug',
30  parent_id INT(11) UNSIGNED NOT NULL,
31  PRIMARY KEY (id, parent_id),
32  INDEX fk_Children_Person1_idx (parent_id ASC),
33  CONSTRAINT fk_Children_Person1
34  FOREIGN KEY (parent_id)
35  REFERENCES Person (id)
36    ON DELETE NO ACTION
37    ON UPDATE NO ACTION)
38  ENGINE = InnoDB;