setup/postgres/psql_create_tables.sql

changeset 350
c676c200534d
parent 348
1dc9c405e9e2
equal deleted inserted replaced
349:41cf84e10aeb 350:c676c200534d
196 create table lpit_issue_variant_status 196 create table lpit_issue_variant_status
197 ( 197 (
198 issueid integer not null references lpit_issue (issueid), 198 issueid integer not null references lpit_issue (issueid),
199 variant integer not null references lpit_variant (id), 199 variant integer not null references lpit_variant (id),
200 status issue_status not null default 'InSpecification', 200 status issue_status not null default 'InSpecification',
201 outdated boolean not null default false,
201 primary key (issueid, variant) 202 primary key (issueid, variant)
202 ); 203 );

mercurial