LightPIT: setup/postgres/psql_create_tables.sql@fecda0f466e6 (annotated)

setup/postgres/psql_create_tables.sql@fecda0f466e6 (annotated)

Sun, 10 May 2020 10:58:31 +0200

adds data model for projects and versions

 -- This script creates the module management tables
 --
 create table lpit_user (
     userid          serial          primary key,
     username        varchar(50)     not null unique,
     mail            varchar(50),
     lastname        varchar(50),
     givenname       varchar(50)
 );
 create table lpit_project (
     id              serial          primary key,
     name            varchar(20)     not null unique,
     description     varchar(200),
     repoUrl         varchar(50),
     owner           integer         references lpit_user(userid)
 );
 create type version_status as enum (
     'Future',
     'Unreleased',
     'Released',
     'LTS',
     'Deprecated'
 );
 create table lpit_version (
     id              serial          primary key,
     project         integer         not null references lpit_project(id),
     name            varchar(20)     not null,
     ordinal         integer         not null default 0,
     status          version_status  not null default 'Future'
 );