equal
deleted
inserted
replaced
63 name varchar(100) NOT NULL |
63 name varchar(100) NOT NULL |
64 ); |
64 ); |
65 CREATE INDEX epermission_name_idx ON EPermission(name); |
65 CREATE INDEX epermission_name_idx ON EPermission(name); |
66 |
66 |
67 CREATE TABLE Eetype( |
67 CREATE TABLE Eetype( |
68 name varchar(64) UNIQUE NOT NULL, |
68 name varchar(64) NOT NULL, |
69 description text, |
69 description text, |
70 meta boolean, |
70 meta boolean, |
71 final boolean, |
71 final boolean, |
72 initial_state integer REFERENCES entities (eid) |
72 initial_state integer REFERENCES entities (eid) |
73 ); |
73 ); |
74 CREATE INDEX eetype_name_idx ON Eetype(name); |
74 CREATE INDEX eetype_name_idx ON Eetype(name); |
|
75 ALTER TABLE Eetype ADD CONSTRAINT eetype_name_key UNIQUE(name); |
75 CREATE INDEX eetype_initial_state_idx ON Eetype(initial_state); |
76 CREATE INDEX eetype_initial_state_idx ON Eetype(initial_state); |
76 |
77 |
77 CREATE TABLE Employee( |
78 CREATE TABLE Employee( |
78 ); |
79 ); |
79 |
80 |
120 CREATE UNIQUE INDEX unique_98da0f9de8588baa8966f0b1a6f850a3 ON Salaried(nom,prenom); |
121 CREATE UNIQUE INDEX unique_98da0f9de8588baa8966f0b1a6f850a3 ON Salaried(nom,prenom); |
121 |
122 |
122 CREATE TABLE Societe( |
123 CREATE TABLE Societe( |
123 nom varchar(64), |
124 nom varchar(64), |
124 web varchar(128), |
125 web varchar(128), |
125 tel integer UNIQUE, |
126 tel integer, |
126 fax integer, |
127 fax integer, |
127 rncs varchar(32), |
128 rncs varchar(32), |
128 ad1 varchar(128), |
129 ad1 varchar(128), |
129 ad2 varchar(128), |
130 ad2 varchar(128), |
130 ad3 varchar(128), |
131 ad3 varchar(128), |
131 cp varchar(12), |
132 cp varchar(12), |
132 ville varchar(32) |
133 ville varchar(32) |
133 , CONSTRAINT cstra0a1deaa997dcd5f9b83a77654d7c287 CHECK(fax <= tel) |
134 , CONSTRAINT cstra0a1deaa997dcd5f9b83a77654d7c287 CHECK(fax <= tel) |
134 ); |
135 ); |
|
136 ALTER TABLE Societe ADD CONSTRAINT societe_tel_key UNIQUE(tel); |
135 |
137 |
136 CREATE TABLE State( |
138 CREATE TABLE State( |
137 eid integer PRIMARY KEY REFERENCES entities (eid), |
139 eid integer PRIMARY KEY REFERENCES entities (eid), |
138 name varchar(256) NOT NULL, |
140 name varchar(256) NOT NULL, |
139 description text |
141 description text |