Mercurial > hg > LightPIT / file diff

     1.1 --- a/setup/postgres/psql_create_tables.sql	Fri Dec 30 13:21:09 2022 +0100
     1.2 +++ b/setup/postgres/psql_create_tables.sql	Fri Dec 30 19:04:34 2022 +0100
     1.3 @@ -149,3 +149,21 @@
     1.4      comment   text    not null
     1.5  );
     1.6  
     1.7 +create type relation_type as enum (
     1.8 +    'RelatesTo',
     1.9 +    'TogetherWith',
    1.10 +    'Before',
    1.11 +    'SubtaskOf',
    1.12 +    'Blocks',
    1.13 +    'Tests',
    1.14 +    'Duplicates'
    1.15 +    );
    1.16 +
    1.17 +create table lpit_issue_relation
    1.18 +(
    1.19 +    from_issue integer       not null references lpit_issue (issueid) on delete cascade,
    1.20 +    to_issue   integer       not null references lpit_issue (issueid) on delete cascade,
    1.21 +    type       relation_type not null
    1.22 +);
    1.23 +
    1.24 +create unique index lpit_issue_relation_unique on lpit_issue_relation (from_issue, to_issue, type);