server/test/unittest_schema2sql.py
changeset 10443 2d3834df64ab
parent 10204 f8ccae1e271d
child 10444 fb7c1013189e
--- 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'))
 );