comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 436
- a07662e829c0
- parent 367
- 0a9065936aac
equal
deleted
inserted
replaced
| 435:5e36330f954b | 436:a07662e829c0 |
|---|---|
| 14 ( | 14 ( |
| 15 projectid serial primary key, | 15 projectid serial primary key, |
| 16 name text not null unique, | 16 name text not null unique, |
| 17 node text not null unique, | 17 node text not null unique, |
| 18 ordinal integer not null default 0, | 18 ordinal integer not null default 0, |
| 19 hidden boolean not null default false, | |
| 19 description text, | 20 description text, |
| 20 repoUrl text, | 21 repoUrl text, |
| 21 vcs vcstype not null default 'None'::vcstype, | 22 vcs vcstype not null default 'None'::vcstype, |
| 22 owner integer references lpit_user (userid) | 23 owner integer references lpit_user (userid) |
| 23 ); | 24 ); |
