Mercurial > hg > LightPIT / file diff

     1.1 --- a/setup/postgres/psql_create_tables.sql	Fri Oct 09 19:06:51 2020 +0200
     1.2 +++ b/setup/postgres/psql_create_tables.sql	Fri Oct 09 19:07:05 2020 +0200
     1.3 @@ -83,4 +83,12 @@
     1.4      primary key (issueid, versionid)
     1.5  );
     1.6  
     1.7 -
     1.8 +create table lpit_issue_comment (
     1.9 +    commentid       serial          primary key,
    1.10 +    issueid         integer         not null references lpit_issue(issueid),
    1.11 +    userid          integer         references lpit_user(userid),
    1.12 +    created         timestamp       with time zone not null default now(),
    1.13 +    updated         timestamp       with time zone not null default now(),
    1.14 +    updatecount     integer         not null default 0,
    1.15 +    comment         text            not null
    1.16 +);