comparison: setup/postgres/psql_create_tables.sql
setup/postgres/psql_create_tables.sql
- changeset 225
- 87328572e36f
- parent 206
- fe4de34822a5
- child 227
- f0ede8046b59
equal
deleted
inserted
replaced
| 224:da975b1f188d | 225:87328572e36f |
|---|---|
| 34 versionid serial primary key, | 34 versionid serial primary key, |
| 35 project integer not null references lpit_project (projectid), | 35 project integer not null references lpit_project (projectid), |
| 36 name text not null, | 36 name text not null, |
| 37 node text not null, | 37 node text not null, |
| 38 ordinal integer not null default 0, | 38 ordinal integer not null default 0, |
| 39 status version_status not null default 'Future' | 39 status version_status not null default 'Future', |
| 40 release date, | |
| 41 eol date | |
| 40 ); | 42 ); |
| 41 | 43 |
| 42 create unique index lpit_version_node_unique on lpit_version (project, node); | 44 create unique index lpit_version_node_unique on lpit_version (project, node); |
| 43 | 45 |
| 44 create table lpit_component | 46 create table lpit_component |
