comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 367
- 0a9065936aac
- parent 360
- f60ecdc0431f
equal
deleted
inserted
replaced
| 366:b351e70ab325 | 367:0a9065936aac |
|---|---|
| 1 create table lpit_user | 1 create table lpit_user |
| 2 ( | 2 ( |
| 3 userid serial primary key, | 3 userid serial primary key, |
| 4 username text not null unique, | 4 username text not null unique, |
| 5 mail text, | 5 mail text, |
| 6 lastname text, | 6 lastname text, |
| 7 givenname text | 7 givenname text, |
| 8 knows_updates_until timestamp with time zone | |
| 8 ); | 9 ); |
| 9 | 10 |
| 10 create type vcstype as enum ('None', 'Mercurial', 'Git'); | 11 create type vcstype as enum ('None', 'Mercurial', 'Git'); |
| 11 | 12 |
| 12 create table lpit_project | 13 create table lpit_project |
