Mercurial Mercurial > pub > hg > cubicweb / comparison
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
server/test/unittest_schema2sql.py
changeset 10202 aaabcb64f77f
parent 10201 989bbadbcd8d
child 10204 f8ccae1e271d
equal deleted inserted replaced
10201:989bbadbcd8d 10202:aaabcb64f77f 
   157  debian_handler varchar(6)
 
   157  debian_handler varchar(6)
 
   158 );
 
   158 );
 
   159 
   159 
   160 
   160 
   161 CREATE TABLE concerne_relation (
 
   161 CREATE TABLE concerne_relation (
 
   162   eid_from INTEGER NOT NULL,
 
   162   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   163   eid_to INTEGER NOT NULL,
 
   163   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   164   CONSTRAINT concerne_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   164   CONSTRAINT concerne_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   165 );
 
   165 );
 
   166 
   166 
   167 CREATE INDEX concerne_relation_from_idx ON concerne_relation(eid_from);
 
   167 CREATE INDEX concerne_relation_from_idx ON concerne_relation(eid_from);
 
   168 CREATE INDEX concerne_relation_to_idx ON concerne_relation(eid_to);
 
   168 CREATE INDEX concerne_relation_to_idx ON concerne_relation(eid_to);
 
   169 
   169 
   170 CREATE TABLE division_of_relation (
 
   170 CREATE TABLE division_of_relation (
 
   171   eid_from INTEGER NOT NULL,
 
   171   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   172   eid_to INTEGER NOT NULL,
 
   172   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   173   CONSTRAINT division_of_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   173   CONSTRAINT division_of_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   174 );
 
   174 );
 
   175 
   175 
   176 CREATE INDEX division_of_relation_from_idx ON division_of_relation(eid_from);
 
   176 CREATE INDEX division_of_relation_from_idx ON division_of_relation(eid_from);
 
   177 CREATE INDEX division_of_relation_to_idx ON division_of_relation(eid_to);
 
   177 CREATE INDEX division_of_relation_to_idx ON division_of_relation(eid_to);
 
   178 
   178 
   179 CREATE TABLE evaluee_relation (
 
   179 CREATE TABLE evaluee_relation (
 
   180   eid_from INTEGER NOT NULL,
 
   180   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   181   eid_to INTEGER NOT NULL,
 
   181   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   182   CONSTRAINT evaluee_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   182   CONSTRAINT evaluee_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   183 );
 
   183 );
 
   184 
   184 
   185 CREATE INDEX evaluee_relation_from_idx ON evaluee_relation(eid_from);
 
   185 CREATE INDEX evaluee_relation_from_idx ON evaluee_relation(eid_from);
 
   186 CREATE INDEX evaluee_relation_to_idx ON evaluee_relation(eid_to);
 
   186 CREATE INDEX evaluee_relation_to_idx ON evaluee_relation(eid_to);
 
   187 
   187 
   188 CREATE TABLE next_state_relation (
 
   188 CREATE TABLE next_state_relation (
 
   189   eid_from INTEGER NOT NULL,
 
   189   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   190   eid_to INTEGER NOT NULL,
 
   190   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   191   CONSTRAINT next_state_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   191   CONSTRAINT next_state_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   192 );
 
   192 );
 
   193 
   193 
   194 CREATE INDEX next_state_relation_from_idx ON next_state_relation(eid_from);
 
   194 CREATE INDEX next_state_relation_from_idx ON next_state_relation(eid_from);
 
   195 CREATE INDEX next_state_relation_to_idx ON next_state_relation(eid_to);
 
   195 CREATE INDEX next_state_relation_to_idx ON next_state_relation(eid_to);
 
   196 
   196 
   197 CREATE TABLE obj_wildcard_relation (
 
   197 CREATE TABLE obj_wildcard_relation (
 
   198   eid_from INTEGER NOT NULL,
 
   198   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   199   eid_to INTEGER NOT NULL,
 
   199   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   200   CONSTRAINT obj_wildcard_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   200   CONSTRAINT obj_wildcard_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   201 );
 
   201 );
 
   202 
   202 
   203 CREATE INDEX obj_wildcard_relation_from_idx ON obj_wildcard_relation(eid_from);
 
   203 CREATE INDEX obj_wildcard_relation_from_idx ON obj_wildcard_relation(eid_from);
 
   204 CREATE INDEX obj_wildcard_relation_to_idx ON obj_wildcard_relation(eid_to);
 
   204 CREATE INDEX obj_wildcard_relation_to_idx ON obj_wildcard_relation(eid_to);
 
   205 
   205 
   206 CREATE TABLE require_permission_relation (
 
   206 CREATE TABLE require_permission_relation (
 
   207   eid_from INTEGER NOT NULL,
 
   207   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   208   eid_to INTEGER NOT NULL,
 
   208   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   209   CONSTRAINT require_permission_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   209   CONSTRAINT require_permission_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   210 );
 
   210 );
 
   211 
   211 
   212 CREATE INDEX require_permission_relation_from_idx ON require_permission_relation(eid_from);
 
   212 CREATE INDEX require_permission_relation_from_idx ON require_permission_relation(eid_from);
 
   213 CREATE INDEX require_permission_relation_to_idx ON require_permission_relation(eid_to);
 
   213 CREATE INDEX require_permission_relation_to_idx ON require_permission_relation(eid_to);
 
   214 
   214 
   215 CREATE TABLE state_of_relation (
 
   215 CREATE TABLE state_of_relation (
 
   216   eid_from INTEGER NOT NULL,
 
   216   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   217   eid_to INTEGER NOT NULL,
 
   217   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   218   CONSTRAINT state_of_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   218   CONSTRAINT state_of_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   219 );
 
   219 );
 
   220 
   220 
   221 CREATE INDEX state_of_relation_from_idx ON state_of_relation(eid_from);
 
   221 CREATE INDEX state_of_relation_from_idx ON state_of_relation(eid_from);
 
   222 CREATE INDEX state_of_relation_to_idx ON state_of_relation(eid_to);
 
   222 CREATE INDEX state_of_relation_to_idx ON state_of_relation(eid_to);
 
   223 
   223 
   224 CREATE TABLE subcompany_of_relation (
 
   224 CREATE TABLE subcompany_of_relation (
 
   225   eid_from INTEGER NOT NULL,
 
   225   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   226   eid_to INTEGER NOT NULL,
 
   226   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   227   CONSTRAINT subcompany_of_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   227   CONSTRAINT subcompany_of_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   228 );
 
   228 );
 
   229 
   229 
   230 CREATE INDEX subcompany_of_relation_from_idx ON subcompany_of_relation(eid_from);
 
   230 CREATE INDEX subcompany_of_relation_from_idx ON subcompany_of_relation(eid_from);
 
   231 CREATE INDEX subcompany_of_relation_to_idx ON subcompany_of_relation(eid_to);
 
   231 CREATE INDEX subcompany_of_relation_to_idx ON subcompany_of_relation(eid_to);
 
   232 
   232 
   233 CREATE TABLE subdivision_of_relation (
 
   233 CREATE TABLE subdivision_of_relation (
 
   234   eid_from INTEGER NOT NULL,
 
   234   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   235   eid_to INTEGER NOT NULL,
 
   235   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   236   CONSTRAINT subdivision_of_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   236   CONSTRAINT subdivision_of_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   237 );
 
   237 );
 
   238 
   238 
   239 CREATE INDEX subdivision_of_relation_from_idx ON subdivision_of_relation(eid_from);
 
   239 CREATE INDEX subdivision_of_relation_from_idx ON subdivision_of_relation(eid_from);
 
   240 CREATE INDEX subdivision_of_relation_to_idx ON subdivision_of_relation(eid_to);
 
   240 CREATE INDEX subdivision_of_relation_to_idx ON subdivision_of_relation(eid_to);
 
   241 
   241 
   242 CREATE TABLE subj_wildcard_relation (
 
   242 CREATE TABLE subj_wildcard_relation (
 
   243   eid_from INTEGER NOT NULL,
 
   243   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   244   eid_to INTEGER NOT NULL,
 
   244   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   245   CONSTRAINT subj_wildcard_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   245   CONSTRAINT subj_wildcard_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   246 );
 
   246 );
 
   247 
   247 
   248 CREATE INDEX subj_wildcard_relation_from_idx ON subj_wildcard_relation(eid_from);
 
   248 CREATE INDEX subj_wildcard_relation_from_idx ON subj_wildcard_relation(eid_from);
 
   249 CREATE INDEX subj_wildcard_relation_to_idx ON subj_wildcard_relation(eid_to);
 
   249 CREATE INDEX subj_wildcard_relation_to_idx ON subj_wildcard_relation(eid_to);
 
   250 
   250 
   251 CREATE TABLE sym_rel_relation (
 
   251 CREATE TABLE sym_rel_relation (
 
   252   eid_from INTEGER NOT NULL,
 
   252   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   253   eid_to INTEGER NOT NULL,
 
   253   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   254   CONSTRAINT sym_rel_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   254   CONSTRAINT sym_rel_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   255 );
 
   255 );
 
   256 
   256 
   257 CREATE INDEX sym_rel_relation_from_idx ON sym_rel_relation(eid_from);
 
   257 CREATE INDEX sym_rel_relation_from_idx ON sym_rel_relation(eid_from);
 
   258 CREATE INDEX sym_rel_relation_to_idx ON sym_rel_relation(eid_to);
 
   258 CREATE INDEX sym_rel_relation_to_idx ON sym_rel_relation(eid_to);
 
   259 
   259 
   260 CREATE TABLE travaille_relation (
 
   260 CREATE TABLE travaille_relation (
 
   261   eid_from INTEGER NOT NULL,
 
   261   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   262   eid_to INTEGER NOT NULL,
 
   262   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   263   CONSTRAINT travaille_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   263   CONSTRAINT travaille_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   264 );
 
   264 );
 
   265 
   265 
   266 CREATE INDEX travaille_relation_from_idx ON travaille_relation(eid_from);
 
   266 CREATE INDEX travaille_relation_from_idx ON travaille_relation(eid_from);
 
   267 CREATE INDEX travaille_relation_to_idx ON travaille_relation(eid_to);
 
   267 CREATE INDEX travaille_relation_to_idx ON travaille_relation(eid_to);
 
   268 
   268 
   269 CREATE TABLE works_for_relation (
 
   269 CREATE TABLE works_for_relation (
 
   270   eid_from INTEGER NOT NULL,
 
   270   eid_from INTEGER NOT NULL REFERENCES entities (eid),
 
   271   eid_to INTEGER NOT NULL,
 
   271   eid_to INTEGER NOT NULL REFERENCES entities (eid),
 
   272   CONSTRAINT works_for_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   272   CONSTRAINT works_for_relation_p_key PRIMARY KEY(eid_from, eid_to)
 
   273 );
 
   273 );
 
   274 
   274 
   275 CREATE INDEX works_for_relation_from_idx ON works_for_relation(eid_from);
 
   275 CREATE INDEX works_for_relation_from_idx ON works_for_relation(eid_from);
 
   276 CREATE INDEX works_for_relation_to_idx ON works_for_relation(eid_to);
 
   276 CREATE INDEX works_for_relation_to_idx ON works_for_relation(eid_to);
cubicweb