81 issueid integer references lpit_issue(issueid), |
81 issueid integer references lpit_issue(issueid), |
82 versionid integer references lpit_version(versionid), |
82 versionid integer references lpit_version(versionid), |
83 primary key (issueid, versionid) |
83 primary key (issueid, versionid) |
84 ); |
84 ); |
85 |
85 |
86 |
86 create table lpit_issue_comment ( |
|
87 commentid serial primary key, |
|
88 issueid integer not null references lpit_issue(issueid), |
|
89 userid integer references lpit_user(userid), |
|
90 created timestamp with time zone not null default now(), |
|
91 updated timestamp with time zone not null default now(), |
|
92 updatecount integer not null default 0, |
|
93 comment text not null |
|
94 ); |