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