setup/postgres/psql_create_tables.sql

changeset 242
b7f3e972b13c
parent 241
1ca4f27cefe8
child 252
90f5e12c7623
     1.1 --- a/setup/postgres/psql_create_tables.sql	Sat Nov 27 12:12:20 2021 +0100
     1.2 +++ b/setup/postgres/psql_create_tables.sql	Sat Nov 27 13:03:57 2021 +0100
     1.3 @@ -112,6 +112,7 @@
     1.4  (
     1.5      eventid serial primary key,
     1.6      issueid integer                  not null references lpit_issue (issueid) on delete cascade,
     1.7 +    subject text                     not null,
     1.8      time    timestamp with time zone not null default now(),
     1.9      type    issue_history_event      not null
    1.10  );
    1.11 @@ -122,7 +123,6 @@
    1.12      component         text,
    1.13      status            issue_status   not null,
    1.14      category          issue_category not null,
    1.15 -    subject           text           not null,
    1.16      description       text,
    1.17      assignee          text,
    1.18      eta               date,

mercurial