equal
deleted
inserted
replaced
50 dt2 timestamp, |
50 dt2 timestamp, |
51 d1 date, |
51 d1 date, |
52 d2 date, |
52 d2 date, |
53 t1 time, |
53 t1 time, |
54 t2 time |
54 t2 time |
55 , CONSTRAINT cstr67c656afbcbfadd4be34d75656a2521a CHECK(d1 <= CAST(clock_timestamp() AS DATE)) |
55 , CONSTRAINT cstrf6a3dad792ba13c2cddcf61a2b737c00 CHECK(d1 <= CAST(clock_timestamp() AS DATE)) |
56 ); |
56 ); |
57 |
57 |
58 CREATE TABLE Division( |
58 CREATE TABLE Division( |
59 name text |
59 name text |
60 ); |
60 ); |
95 tel integer, |
95 tel integer, |
96 fax integer, |
96 fax integer, |
97 datenaiss date, |
97 datenaiss date, |
98 test boolean, |
98 test boolean, |
99 salary float |
99 salary float |
100 , CONSTRAINT cstrdedefafc86dc831341c33547388c25bb CHECK(promo IN ('bon', 'pasbon')) |
100 , CONSTRAINT cstr151c2116c0c09de13fded0619d5b4aac CHECK(promo IN ('bon', 'pasbon')) |
101 ); |
101 ); |
102 CREATE UNIQUE INDEX unique_e6c2d219772dbf1715597f7d9a6b3892 ON Person(nom,prenom); |
102 CREATE UNIQUE INDEX unique_e6c2d219772dbf1715597f7d9a6b3892 ON Person(nom,prenom); |
103 |
103 |
104 CREATE TABLE Salaried( |
104 CREATE TABLE Salaried( |
105 nom varchar(64) NOT NULL, |
105 nom varchar(64) NOT NULL, |
113 tel integer, |
113 tel integer, |
114 fax integer, |
114 fax integer, |
115 datenaiss date, |
115 datenaiss date, |
116 test boolean, |
116 test boolean, |
117 salary float |
117 salary float |
118 , CONSTRAINT cstrb62a1623de9e9b92eb552706b6ce0890 CHECK(promo IN ('bon', 'pasbon')) |
118 , CONSTRAINT cstr069569cf1791dba1a2726197c53aeb44 CHECK(promo IN ('bon', 'pasbon')) |
119 ); |
119 ); |
120 CREATE UNIQUE INDEX unique_98da0f9de8588baa8966f0b1a6f850a3 ON Salaried(nom,prenom); |
120 CREATE UNIQUE INDEX unique_98da0f9de8588baa8966f0b1a6f850a3 ON Salaried(nom,prenom); |
121 |
121 |
122 CREATE TABLE Societe( |
122 CREATE TABLE Societe( |
123 nom varchar(64), |
123 nom varchar(64), |
128 ad1 varchar(128), |
128 ad1 varchar(128), |
129 ad2 varchar(128), |
129 ad2 varchar(128), |
130 ad3 varchar(128), |
130 ad3 varchar(128), |
131 cp varchar(12), |
131 cp varchar(12), |
132 ville varchar(32) |
132 ville varchar(32) |
133 , CONSTRAINT cstraf91cb60287eec6d5c1175075edcccc0 CHECK(fax <= tel) |
133 , CONSTRAINT cstra0a1deaa997dcd5f9b83a77654d7c287 CHECK(fax <= tel) |
134 ); |
134 ); |
135 |
135 |
136 CREATE TABLE State( |
136 CREATE TABLE State( |
137 eid integer PRIMARY KEY REFERENCES entities (eid), |
137 eid integer PRIMARY KEY REFERENCES entities (eid), |
138 name varchar(256) NOT NULL, |
138 name varchar(256) NOT NULL, |
157 long_desc text NOT NULL, |
157 long_desc text NOT NULL, |
158 author varchar(100) NOT NULL, |
158 author varchar(100) NOT NULL, |
159 author_email varchar(100) NOT NULL, |
159 author_email varchar(100) NOT NULL, |
160 mailinglist varchar(100), |
160 mailinglist varchar(100), |
161 debian_handler varchar(6) |
161 debian_handler varchar(6) |
162 , CONSTRAINT cstree063a486aa92d4f721ced56c819f38a CHECK(license IN ('GPL', 'ZPL')) |
162 , CONSTRAINT cstrbffed5ce7306d65a0db51182febd4a7b CHECK(license IN ('GPL', 'ZPL')) |
163 , CONSTRAINT cstrafb4b6de5d50b5a2eca60b33b7acf59b CHECK(debian_handler IN ('machin', 'bidule')) |
163 , CONSTRAINT cstr2238b33d09bf7c441e0888be354c2444 CHECK(debian_handler IN ('machin', 'bidule')) |
164 ); |
164 ); |
165 |
165 |
166 |
166 |
167 CREATE TABLE concerne_relation ( |
167 CREATE TABLE concerne_relation ( |
168 eid_from INTEGER NOT NULL REFERENCES entities (eid), |
168 eid_from INTEGER NOT NULL REFERENCES entities (eid), |