comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 175
- 1e6f2aace666
- parent 138
- e2aa673dd473
- child 187
- 0bf35031a918
equal
deleted
inserted
replaced
| 174:690a9aad3f16 | 175:1e6f2aace666 |
|---|---|
| 11 | 11 |
| 12 create table lpit_project ( | 12 create table lpit_project ( |
| 13 projectid serial primary key, | 13 projectid serial primary key, |
| 14 name varchar(20) not null unique, | 14 name varchar(20) not null unique, |
| 15 node varchar(20) not null unique, | 15 node varchar(20) not null unique, |
| 16 ordinal integer not null default 0, | |
| 16 description varchar(200), | 17 description varchar(200), |
| 17 repoUrl varchar(50), | 18 repoUrl varchar(50), |
| 18 owner integer references lpit_user(userid) | 19 owner integer references lpit_user(userid) |
| 19 ); | 20 ); |
| 20 | 21 |
