equal
deleted
inserted
replaced
35 |
35 |
36 EXPECTED_DATA_NO_DROP = """ |
36 EXPECTED_DATA_NO_DROP = """ |
37 CREATE TABLE Affaire( |
37 CREATE TABLE Affaire( |
38 sujet varchar(128), |
38 sujet varchar(128), |
39 ref varchar(12), |
39 ref varchar(12), |
40 inline_rel integer |
40 inline_rel integer REFERENCES entities (eid) |
41 ); |
41 ); |
42 CREATE INDEX affaire_inline_rel_idx ON Affaire(inline_rel); |
42 CREATE INDEX affaire_inline_rel_idx ON Affaire(inline_rel); |
43 |
43 |
44 CREATE TABLE Company( |
44 CREATE TABLE Company( |
45 name text |
45 name text |
66 CREATE TABLE Eetype( |
66 CREATE TABLE Eetype( |
67 name varchar(64) UNIQUE NOT NULL, |
67 name varchar(64) UNIQUE NOT NULL, |
68 description text, |
68 description text, |
69 meta boolean, |
69 meta boolean, |
70 final boolean, |
70 final boolean, |
71 initial_state integer |
71 initial_state integer REFERENCES entities (eid) |
72 ); |
72 ); |
73 CREATE INDEX eetype_name_idx ON Eetype(name); |
73 CREATE INDEX eetype_name_idx ON Eetype(name); |
74 CREATE INDEX eetype_initial_state_idx ON Eetype(initial_state); |
74 CREATE INDEX eetype_initial_state_idx ON Eetype(initial_state); |
75 |
75 |
76 CREATE TABLE Employee( |
76 CREATE TABLE Employee( |