Tue, 14 Jan 2025 20:12:25 +0100
add author to issue history and RSS feed - fixes #463
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
1 | create table lpit_user |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
2 | ( |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
3 | userid serial primary key, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
4 | username text not null unique, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
5 | mail text, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
6 | lastname text, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
7 | givenname text |
20
bd1a76c91d5b
module synchronization with database
Mike Becker <universe@uap-core.de>
parents:
16
diff
changeset
|
8 | ); |
37
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
9 | |
284
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
10 | create type vcstype as enum ('None', 'Mercurial', 'Git'); |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
11 | |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
12 | create table lpit_project |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
13 | ( |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
14 | projectid serial primary key, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
15 | name text not null unique, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
16 | node text not null unique, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
17 | ordinal integer not null default 0, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
18 | description text, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
19 | repoUrl text, |
284
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
20 | vcs vcstype not null default 'None'::vcstype, |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
21 | owner integer references lpit_user (userid) |
37
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
22 | ); |
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
23 | |
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
24 | create type version_status as enum ( |
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
25 | 'Future', |
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
26 | 'Unreleased', |
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
27 | 'Released', |
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
28 | 'LTS', |
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
29 | 'Deprecated' |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
30 | ); |
37
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
31 | |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
32 | create table lpit_version |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
33 | ( |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
34 | versionid serial primary key, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
35 | project integer not null references lpit_project (projectid), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
36 | name text not null, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
37 | node text not null, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
38 | ordinal integer not null default 0, |
225
87328572e36f
#159 adds release and eol dates
Mike Becker <universe@uap-core.de>
parents:
206
diff
changeset
|
39 | status version_status not null default 'Future', |
87328572e36f
#159 adds release and eol dates
Mike Becker <universe@uap-core.de>
parents:
206
diff
changeset
|
40 | release date, |
87328572e36f
#159 adds release and eol dates
Mike Becker <universe@uap-core.de>
parents:
206
diff
changeset
|
41 | eol date |
37
fecda0f466e6
adds data model for projects and versions
Mike Becker <universe@uap-core.de>
parents:
36
diff
changeset
|
42 | ); |
62
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
43 | |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
44 | create unique index lpit_version_node_unique on lpit_version (project, node); |
127 | 45 | |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
46 | create table lpit_component |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
47 | ( |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
48 | id serial primary key, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
49 | project integer not null references lpit_project (projectid), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
50 | name text not null, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
51 | node text not null, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
52 | color char(6) not null default '000000', |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
53 | ordinal integer not null default 0, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
54 | description text, |
227
f0ede8046b59
#162 adds active flag to component
Mike Becker <universe@uap-core.de>
parents:
225
diff
changeset
|
55 | lead integer references lpit_user (userid), |
f0ede8046b59
#162 adds active flag to component
Mike Becker <universe@uap-core.de>
parents:
225
diff
changeset
|
56 | active boolean not null default true |
127 | 57 | ); |
58 | ||
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
59 | create unique index lpit_component_node_unique on lpit_component (project, node); |
138
e2aa673dd473
adds custom node names - fixes #27
Mike Becker <universe@uap-core.de>
parents:
128
diff
changeset
|
60 | |
62
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
61 | create type issue_status as enum ( |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
62 | 'InSpecification', |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
63 | 'ToDo', |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
64 | 'Scheduled', |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
65 | 'InProgress', |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
66 | 'InReview', |
252
90f5e12c7623
add issue status 'Ready'
Mike Becker <universe@uap-core.de>
parents:
242
diff
changeset
|
67 | 'Ready', |
62
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
68 | 'Done', |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
69 | 'Rejected', |
81 | 70 | 'Withdrawn', |
71 | 'Duplicate' | |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
72 | ); |
62
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
73 | |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
74 | create type issue_category as enum ( |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
75 | 'Feature', |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
76 | 'Improvement', |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
77 | 'Bug', |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
78 | 'Task', |
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
79 | 'Test' |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
80 | ); |
62
833e0385572a
adds data model for issues
Mike Becker <universe@uap-core.de>
parents:
37
diff
changeset
|
81 | |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
82 | create table lpit_issue_phases |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
83 | ( |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
84 | status issue_status primary key, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
85 | phase integer not null |
81 | 86 | ); |
87 | ||
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
88 | create table lpit_issue |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
89 | ( |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
90 | issueid serial primary key, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
91 | project integer not null references lpit_project (projectid), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
92 | component integer references lpit_component (id), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
93 | status issue_status not null default 'InSpecification', |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
94 | category issue_category not null default 'Feature', |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
95 | subject text not null, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
96 | description text, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
97 | assignee integer references lpit_user (userid), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
98 | created timestamp with time zone not null default now(), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
99 | updated timestamp with time zone not null default now(), |
231
dcb1d5a7ea3a
#163 removes multi selection for versions
Mike Becker <universe@uap-core.de>
parents:
227
diff
changeset
|
100 | eta date, |
dcb1d5a7ea3a
#163 removes multi selection for versions
Mike Becker <universe@uap-core.de>
parents:
227
diff
changeset
|
101 | affected integer references lpit_version (versionid), |
dcb1d5a7ea3a
#163 removes multi selection for versions
Mike Becker <universe@uap-core.de>
parents:
227
diff
changeset
|
102 | resolved integer references lpit_version (versionid) |
75
33b6843fdf8a
adds the ability to create and edit issues
Mike Becker <universe@uap-core.de>
parents:
62
diff
changeset
|
103 | ); |
33b6843fdf8a
adds the ability to create and edit issues
Mike Becker <universe@uap-core.de>
parents:
62
diff
changeset
|
104 | |
232
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
105 | create type issue_history_event as enum ( |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
106 | 'New', |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
107 | 'Update', |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
108 | 'NewComment', |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
109 | 'UpdateComment' |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
110 | ); |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
111 | |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
112 | create table lpit_issue_history_event |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
113 | ( |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
114 | eventid serial primary key, |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
115 | issueid integer not null references lpit_issue (issueid) on delete cascade, |
345
7a515768c481
add author to issue history and RSS feed - fixes #463
Mike Becker <universe@uap-core.de>
parents:
284
diff
changeset
|
116 | userid integer null references lpit_user (userid) on delete set null, |
242
b7f3e972b13c
#109 add comment history
Mike Becker <universe@uap-core.de>
parents:
241
diff
changeset
|
117 | subject text not null, |
232
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
118 | time timestamp with time zone not null default now(), |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
119 | type issue_history_event not null |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
120 | ); |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
121 | |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
122 | create table lpit_issue_history_data |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
123 | ( |
239
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
124 | eventid integer not null references lpit_issue_history_event (eventid) on delete cascade, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
125 | component text, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
126 | status issue_status not null, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
127 | category issue_category not null, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
128 | description text, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
129 | assignee text, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
130 | eta date, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
131 | affected text, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
132 | resolved text |
232
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
133 | ); |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
134 | |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
135 | create table lpit_issue_comment |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
136 | ( |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
137 | commentid serial primary key, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
138 | issueid integer not null references lpit_issue (issueid), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
139 | userid integer references lpit_user (userid), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
140 | created timestamp with time zone not null default now(), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
141 | updated timestamp with time zone not null default now(), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
142 | updatecount integer not null default 0, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
143 | comment text not null |
124 | 144 | ); |
232
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
145 | |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
146 | create table lpit_issue_comment_history |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
147 | ( |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
148 | commentid integer not null references lpit_issue_comment (commentid) on delete cascade, |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
149 | eventid integer not null references lpit_issue_history_event (eventid) on delete cascade, |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
150 | comment text not null |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
151 | ); |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
152 | |
263
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
153 | create type relation_type as enum ( |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
154 | 'RelatesTo', |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
155 | 'TogetherWith', |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
156 | 'Before', |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
157 | 'SubtaskOf', |
268 | 158 | 'DefectOf', |
263
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
159 | 'Blocks', |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
160 | 'Tests', |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
161 | 'Duplicates' |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
162 | ); |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
163 | |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
164 | create table lpit_issue_relation |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
165 | ( |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
166 | from_issue integer not null references lpit_issue (issueid) on delete cascade, |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
167 | to_issue integer not null references lpit_issue (issueid) on delete cascade, |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
168 | type relation_type not null |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
169 | ); |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
170 | |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
171 | create unique index lpit_issue_relation_unique on lpit_issue_relation (from_issue, to_issue, type); |
284
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
172 | |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
173 | create table lpit_commit_ref |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
174 | ( |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
175 | issueid integer not null references lpit_issue (issueid) on delete cascade, |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
176 | commit_hash text not null, |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
177 | commit_brief text not null |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
178 | ); |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
179 | |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
180 | create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); |