sgQMSr2Q

1DROP TABLE IF EXISTS start_matrix;
2DROP TABLE IF EXISTS end_matrix;
3DROP TABLE IF EXISTS experiment;
4
5CREATE TABLE experiment (
6  nr INT NOT NULL,
7  window_size SMALLINT NOT NULL,
8  local_size SMALLINT NOT NULL,
9  size SMALLINT NOT NULL,
10  PRIMARY KEY (nr)
11);
12
13CREATE TABLE start_matrix (
14  nr INT NOT NULL,
15  experiment INT NOT NULL,
16  positive_counts INT NOT NULL,
17  negative_counts INT NOT NULL,
18  positive_strengths INT NOT NULL,
19  negative_strengths INT NOT NULL,
20  PRIMARY KEY (nr, experiment),
21  CONSTRAINT fk_experiment_start
22    FOREIGN KEY (experiment)
23    REFERENCES experiment (nr)
24	  ON DELETE CASCADE
25    ON UPDATE CASCADE
26);
27
28CREATE TABLE end_matrix (
29  nr INT NOT NULL,
30  experiment INT NOT NULL,
31  positive_counts INT NOT NULL,
32  negative_counts INT NOT NULL,
33  positive_strengths INT NOT NULL,
34  negative_strengths INT NOT NULL,
35  steps INT NOT NULL,
36  PRIMARY KEY (nr, experiment),
37  CONSTRAINT fk_experiment_end
38    FOREIGN KEY (experiment)
39    REFERENCES experiment (nr)
40	  ON DELETE CASCADE
41    ON UPDATE CASCADE
42);