1.1 --- a/setup/postgres/psql_create_tables.sql Sun May 10 10:11:37 2020 +0200
1.2 +++ b/setup/postgres/psql_create_tables.sql Sun May 10 10:58:31 2020 +0200
1.3 @@ -1,9 +1,34 @@
1.4 -- This script creates the module management tables
1.5 --
1.6
1.7 -create table lpitcore_user (
1.8 +create table lpit_user (
1.9 userid serial primary key,
1.10 username varchar(50) not null unique,
1.11 + mail varchar(50),
1.12 lastname varchar(50),
1.13 givenname varchar(50)
1.14 );
1.15 +
1.16 +create table lpit_project (
1.17 + id serial primary key,
1.18 + name varchar(20) not null unique,
1.19 + description varchar(200),
1.20 + repoUrl varchar(50),
1.21 + owner integer references lpit_user(userid)
1.22 +);
1.23 +
1.24 +create type version_status as enum (
1.25 + 'Future',
1.26 + 'Unreleased',
1.27 + 'Released',
1.28 + 'LTS',
1.29 + 'Deprecated'
1.30 +);
1.31 +
1.32 +create table lpit_version (
1.33 + id serial primary key,
1.34 + project integer not null references lpit_project(id),
1.35 + name varchar(20) not null,
1.36 + ordinal integer not null default 0,
1.37 + status version_status not null default 'Future'
1.38 +);
