setup/postgres/psql_create_tables.sql

changeset 175
1e6f2aace666
parent 138
e2aa673dd473
child 187
0bf35031a918
--- a/setup/postgres/psql_create_tables.sql	Mon Jan 04 15:14:26 2021 +0100
+++ b/setup/postgres/psql_create_tables.sql	Mon Jan 04 15:25:59 2021 +0100
@@ -13,6 +13,7 @@
     projectid       serial          primary key,
     name            varchar(20)     not null unique,
     node            varchar(20)     not null unique,
+    ordinal         integer         not null default 0,
     description     varchar(200),
     repoUrl         varchar(50),
     owner           integer         references lpit_user(userid)

mercurial