--- a/server/test/unittest_schema2sql.py Tue Jun 23 10:05:34 2015 +0200
+++ b/server/test/unittest_schema2sql.py Mon May 18 11:36:07 2015 +0200
@@ -96,6 +96,7 @@
datenaiss date,
test boolean,
salary float
+, CONSTRAINT cstr41fe7db9ce1d5be95de2477e26590386 CHECK(promo IN ('bon', 'pasbon'))
);
CREATE UNIQUE INDEX unique_e6c2d219772dbf1715597f7d9a6b3892 ON Person(nom,prenom);
@@ -113,6 +114,7 @@
datenaiss date,
test boolean,
salary float
+, CONSTRAINT cstrc8556fcc665865217761cdbcd220cae0 CHECK(promo IN ('bon', 'pasbon'))
);
CREATE UNIQUE INDEX unique_98da0f9de8588baa8966f0b1a6f850a3 ON Salaried(nom,prenom);
@@ -127,6 +129,7 @@
ad3 varchar(128),
cp varchar(12),
ville varchar(32)
+, CONSTRAINT cstrc51dd462e9f6115506a0fe468d4c8114 CHECK(fax <= tel)
);
CREATE TABLE State(
@@ -155,6 +158,8 @@
author_email varchar(100) NOT NULL,
mailinglist varchar(100),
debian_handler varchar(6)
+, CONSTRAINT cstr70f766f834557c715815d76f0a0db956 CHECK(license IN ('GPL', 'ZPL'))
+, CONSTRAINT cstr831a117424d0007ae0278cc15f344f5e CHECK(debian_handler IN ('machin', 'bidule'))
);