Wed, 07 Aug 2024 18:43:15 +0200
fix regression for issue #404
where a partially loaded project
object was insufficient to render
the issue view
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, |
242
b7f3e972b13c
#109 add comment history
Mike Becker <universe@uap-core.de>
parents:
241
diff
changeset
|
116 | 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
|
117 | 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
|
118 | 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
|
119 | ); |
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 | 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
|
122 | ( |
239
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
123 | 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
|
124 | component text, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
125 | status issue_status not null, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
126 | category issue_category not null, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
127 | description text, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
128 | assignee text, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
129 | eta date, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
130 | affected text, |
9365c7fb0240
#109 add assignee filter to rss feed
Mike Becker <universe@uap-core.de>
parents:
232
diff
changeset
|
131 | resolved text |
232
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
132 | ); |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
133 | |
206
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
134 | create table lpit_issue_comment |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
135 | ( |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
136 | commentid serial primary key, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
137 | 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
|
138 | userid integer references lpit_user (userid), |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
139 | 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
|
140 | 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
|
141 | updatecount integer not null default 0, |
fe4de34822a5
#133 changes all varchar columns to text
Mike Becker <universe@uap-core.de>
parents:
187
diff
changeset
|
142 | comment text not null |
124 | 143 | ); |
232
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
144 | |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
145 | 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
|
146 | ( |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
147 | 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
|
148 | 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
|
149 | comment text not null |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
150 | ); |
296e12ff8d1c
#109 adds Stasi that collects intel for the feed
Mike Becker <universe@uap-core.de>
parents:
231
diff
changeset
|
151 | |
263
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
152 | create type relation_type as enum ( |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
153 | 'RelatesTo', |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
154 | 'TogetherWith', |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
155 | 'Before', |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
156 | 'SubtaskOf', |
268 | 157 | 'DefectOf', |
263
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
158 | 'Blocks', |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
159 | 'Tests', |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
160 | 'Duplicates' |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
161 | ); |
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 | create table lpit_issue_relation |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
164 | ( |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
165 | 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
|
166 | 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
|
167 | type relation_type not null |
aa22103809cd
#29 add possibility to relate issues
Mike Becker <universe@uap-core.de>
parents:
252
diff
changeset
|
168 | ); |
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 | 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
|
171 | |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
172 | create table lpit_commit_ref |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
173 | ( |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
174 | 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
|
175 | commit_hash text not null, |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
176 | commit_brief text not null |
671c1c8fbf1c
add full support for commit references - fixes #276
Mike Becker <universe@uap-core.de>
parents:
268
diff
changeset
|
177 | ); |
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 | create unique index lpit_commit_ref_unique on lpit_commit_ref (issueid, commit_hash); |