Mercurial > ~dholland > hg > swallowtail > index.cgi

annotate database/schema/classify.sql @ 8:68cc276ac118

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SQL material from old tree, split up for accessibility.
author David A. Holland
date Sun, 19 Feb 2012 19:54:48 -0500
parents
children d42c0db81e28
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
1 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
2 -- Classification.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
3 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
4 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
5 -- Sorting and classifying bug reports usefully is a nontrivial
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
6 -- problem. For this reason, rather than bake in any particular
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
7 -- taxonomy, we allow multiple arbitrary classification schemes,
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
8 -- all of which are created equal. (Administratively, some will
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
9 -- be more equal than others, but that does not concern the
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
10 -- database.)
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
11 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
12 -- The classification schemes/taxonomies that already exist or are
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
13 -- projected to be wanted, as of this writing, are:
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
14 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
15 -- 1. The old GNATS system of categories. A PR has one category, which
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
16 -- is taken from a fixed list of keywords, currently these:
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
17 -- bin install kern lib misc pkg port-* security standards
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
18 -- toolchain xsrc y2k
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
19 -- Also the old "class" field.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
20 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
21 -- 2. The old GNATS severity and priority fields, which are still
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
22 -- useful despite being broad.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
23 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
24 -- 3. The nearest man page to where the problem appears to be. This is
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
25 -- FreeBSD's idea and seems to work fairly well for many things.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
26 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
27 -- 4. The taxonomy dholland uses in the out-of-gnats PR lists, which
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
28 -- is related to the previous (it uses man pages for drivers and
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
29 -- programs) but is three-layer hierarchical.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
30 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
31 -- 5. Assorted flat tags (e.g. PRs releng considers critical for the
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
32 -- 6.0 release), or equivalently, arbitrary hand-maintained lists.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
33 -- It is anticipated that every developer will be able to make their
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
34 -- own lists.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
35 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
36 -- 6. Properties derivable from other data that behave like flat tags
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
37 -- (e.g. "PRs in feedback more than 6 months") - these should not be
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
38 -- stored as tags in the database but it may be desirable to be able
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
39 -- to present them the same way as tags.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
40 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
41 -- 7. Other hierarchical schemes that have yet to be invented.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
42 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
43 -- Some of these classification schemes have additional special
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
44 -- semantics.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
45 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
46 -- It is furthermore assumed that new classification schemes will be
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
47 -- added on the fly, not frequently, but frequently enough that the
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
48 -- list of schemes should not be hard-coded into programs that access
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
49 -- the database.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
50 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
51 -- This creates something of a problem; encoding hierarchical data in
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
52 -- SQL is fun enough when the hierarchy is fixed. We need to be able
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
53 -- to handle hierarchical data whose layout hasn't been invented yet,
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
54 -- and that's really pushing it.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
55 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
56 -- Arbitrary flat tags we can do. For the rest, I think we need to set
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
57 -- up a system that allows, essentially, extensions to the schema,
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
58 -- which can be arbitrary SQL, and which provide views that allow
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
59 -- nonspecialized client software to read (and maybe update, but maybe
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
60 -- not) the available material in a standardized way.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
61 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
62 -- We will then have to have an additional set of views that take the
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
63 -- union of all the extensions; these views will need to be recreated
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
64 -- when a new classification scheme is added.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
65 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
66
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
67 -- Tags.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
68 CREATE TABLE tags (
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
69 name text primary key,
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
70 confidential boolean not null
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
71 -- XXX should have an owner
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
72 )
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
73 WITHOUT OIDS;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
74
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
75 CREATE TABLE has_tags (
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
76 pr bigint not null references PRs (id),
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
77 tag text not null references tags (name),
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
78 )
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
79 WITHOUT OIDS;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
80
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
81 -- Classifications.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
82 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
83 -- Each classification scheme should define whatever tables and
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
84 -- goop it needs. It should also define a text view, as follows
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
85 -- assuming the scheme is called "foo":
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
86 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
87 -- . The name of the view should be "foo_classification_text".
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
88 -- . The view should produce tuples (scheme, order, pr, value).
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
89 -- . The types should be (text, int, bigint, text).
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
90 -- . The "scheme" column should be the scheme name, suitable
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
91 -- for display, e.g. "Foo".
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
92 -- . The "order" column should contain the canonical display
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
93 -- order number for this scheme. Used with ORDER BY ASCENDING
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
94 -- to get things to appear in a consistent order.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
95 -- . The "pr" column should have pr numbers.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
96 -- . The "value" column should have a text representation of the
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
97 -- value.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
98 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
99 -- Choose the canonical display order number for a new scheme based on
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
100 -- the existing values in use. See below for the numbers used by the
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
101 -- built-in schemes.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
102 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
103 -- Ideally it should be possible to update the value through the text
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
104 -- view. Ideally it would also be possible to insert through it, but
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
105 -- that will never work... have to think about how to handle that
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
106 -- best. (XXX?)
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
107 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
108
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
109 --------------------------------------------------------------
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
110
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
111 -- The "category" classification.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
112 -- Each PR has one category that must be taken from the list in the
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
113 -- categories table. The category is used to select the default
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
114 -- responsible entity for incoming PRs.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
115 CREATE TABLE has_categories (
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
116 pr bigint unique not null references PRs (id),
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
117 category text not null references categories (name)
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
118 )
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
119 WITHOUT OIDS;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
120
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
121 CREATE VIEW category_classification_text AS
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
122 SELECT "Category" as scheme, 100 as order, pr, category as value
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
123 FROM has_categories
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
124 ;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
125
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
126 -- The "class" classification.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
127 -- Each PR has one class that must be taken from the list in the
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
128 -- classes table.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
129 CREATE TABLE has_classes (
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
130 pr bigint unique not null references PRs (id),
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
131 class text not null references classes (name)
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
132 )
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
133 WITHOUT OIDS;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
134
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
135 CREATE VIEW class_classification_text AS
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
136 SELECT "Class" as scheme, 200 as order, pr, class as value
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
137 FROM has_classes
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
138 ;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
139
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
140 -- The "severity" classification.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
141 -- Each PR has one severity that must be taken from the list in the
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
142 -- severities table.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
143 CREATE TABLE has_severities (
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
144 pr bigint unique not null references PRs (id),
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
145 severity text not null references severities (name)
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
146 )
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
147 WITHOUT OIDS;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
148
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
149 CREATE VIEW severity_classification_text AS
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
150 SELECT "Severity" as scheme, 300 as order, pr, severity as value
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
151 FROM has_severities
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
152 ;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
153
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
154 -- The "priority" classification.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
155 -- Each PR has one priority that must be taken from the list in the
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
156 -- priorities table.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
157 CREATE TABLE has_priorities (
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
158 pr bigint unique not null references PRs (id),
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
159 priority text not null references priorities (name)
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
160 )
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
161 WITHOUT OIDS;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
162
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
163 CREATE VIEW priority_classification_text AS
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
164 SELECT "Priority" as scheme, 400 as order, pr, priority as value
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
165 FROM has_priorities
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
166 ;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
167
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
168 --------------------------------------------------------------
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
169
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
170 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
171 -- The collected view of all classifications.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
172 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
173 -- (This does not include tags, as tags should be presented
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
174 -- differently.)
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
175 --
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
176 CREATE VIEW classification_text AS
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
177 SELECT * from category_classification_text
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
178 UNION SELECT * from class_classification_text
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
179 UNION SELECT * from severity_classification_text
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
180 UNION SELECT * from priority_classification_text
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
181 ;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
182