comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 187
- 0bf35031a918
- parent 175
- 1e6f2aace666
- child 206
- fe4de34822a5
equal
deleted
inserted
replaced
| 186:05eec764facd | 187:0bf35031a918 |
|---|---|
| 9 givenname varchar(50) | 9 givenname varchar(50) |
| 10 ); | 10 ); |
| 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(50) 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 ordinal integer not null default 0, |
| 17 description varchar(200), | 17 description varchar(200), |
| 18 repoUrl varchar(50), | 18 repoUrl varchar(50), |
| 19 owner integer references lpit_user(userid) | 19 owner integer references lpit_user(userid) |
