|
1102
by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs |
1 |
/*
|
2 |
SOYUZ SAMPLE DATA
|
|
|
8687.15.9
by Karl Fogel
Add the copyright header block to more files (everything under database/). |
3 |
|
4 |
Copyright 2009 Canonical Ltd. This software is licensed under the
|
|
5 |
GNU Affero General Public License version 3 (see the file LICENSE).
|
|
6 |
||
|
1102
by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs |
7 |
This is some sample data for the Soyuz App components.
|
8 |
This requires the default data to be inserted first.
|
|
9 |
*/
|
|
10 |
||
11 |
/*
|
|
12 |
Sample data for Soyuz
|
|
13 |
*/
|
|
14 |
||
15 |
||
16 |
-- Component
|
|
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
17 |
INSERT INTO Component (name) VALUES ('main'); |
18 |
INSERT INTO Component (name) VALUES ('restricted'); |
|
19 |
INSERT INTO Component (name) VALUES ('universe'); |
|
|
1102
by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs |
20 |
|
21 |
-- Section
|
|
22 |
||
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
23 |
INSERT INTO Section (name) VALUES ('base'); |
24 |
INSERT INTO Section (name) VALUES ('web'); |
|
25 |
INSERT INTO Section (name) VALUES ('editors'); |
|
26 |
INSERT INTO Section (name) VALUES ('admin'); |
|
27 |
INSERT INTO Section (name) VALUES ('comm'); |
|
28 |
INSERT INTO Section (name) VALUES ('debian-installer'); |
|
29 |
INSERT INTO Section (name) VALUES ('devel'); |
|
30 |
INSERT INTO Section (name) VALUES ('doc'); |
|
31 |
INSERT INTO Section (name) VALUES ('games'); |
|
32 |
INSERT INTO Section (name) VALUES ('gnome'); |
|
33 |
INSERT INTO Section (name) VALUES ('graphics'); |
|
34 |
INSERT INTO Section (name) VALUES ('interpreters'); |
|
35 |
INSERT INTO Section (name) VALUES ('kde'); |
|
36 |
INSERT INTO Section (name) VALUES ('libdevel'); |
|
37 |
INSERT INTO Section (name) VALUES ('libs'); |
|
38 |
INSERT INTO Section (name) VALUES ('mail'); |
|
39 |
INSERT INTO Section (name) VALUES ('math'); |
|
40 |
INSERT INTO Section (name) VALUES ('misc'); |
|
41 |
INSERT INTO Section (name) VALUES ('net'); |
|
42 |
INSERT INTO Section (name) VALUES ('news'); |
|
43 |
INSERT INTO Section (name) VALUES ('oldlibs'); |
|
44 |
INSERT INTO Section (name) VALUES ('otherosfs'); |
|
45 |
INSERT INTO Section (name) VALUES ('perl'); |
|
46 |
INSERT INTO Section (name) VALUES ('python'); |
|
47 |
INSERT INTO Section (name) VALUES ('shells'); |
|
48 |
INSERT INTO Section (name) VALUES ('sound'); |
|
49 |
INSERT INTO Section (name) VALUES ('tex'); |
|
50 |
INSERT INTO Section (name) VALUES ('text'); |
|
51 |
INSERT INTO Section (name) VALUES ('translations'); |
|
52 |
INSERT INTO Section (name) VALUES ('utils'); |
|
53 |
INSERT INTO Section (name) VALUES ('x11'); |
|
54 |
INSERT INTO Section (name) VALUES ('electronics'); |
|
55 |
INSERT INTO Section (name) VALUES ('embedded'); |
|
56 |
INSERT INTO Section (name) VALUES ('hamradio'); |
|
57 |
INSERT INTO Section (name) VALUES ('science'); |
|
58 |
||
|
1102
by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs |
59 |
|
60 |
-- Schema
|
|
61 |
INSERT INTO schema (name, title, description, owner, extensible) VALUES |
|
62 |
('Mark schema', 'TITLE', 'description', |
|
63 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth'), |
|
64 |
TRUE); |
|
65 |
||
66 |
INSERT INTO Schema (name, title, description, owner, extensible) VALUES |
|
67 |
('schema', 'SCHEMA', 'description', |
|
68 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth'), |
|
69 |
TRUE); |
|
70 |
||
71 |
INSERT INTO Schema (name, title, description, owner, extensible) VALUES |
|
72 |
('trema', 'XCHEMA', 'description', |
|
73 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth'), |
|
74 |
TRUE); |
|
75 |
||
76 |
INSERT INTO Schema (name, title, description, owner, extensible) VALUES |
|
77 |
('enema', 'ENHEMA', 'description', |
|
78 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth'), |
|
79 |
TRUE); |
|
80 |
||
81 |
||
82 |
--Manifest
|
|
83 |
INSERT INTO Manifest (datecreated, owner) |
|
84 |
VALUES (timestamp '2004-06-29 00:00', |
|
85 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth') |
|
86 |
);
|
|
87 |
||
88 |
INSERT INTO Manifest (datecreated, owner) |
|
89 |
VALUES (timestamp '2004-06-30 00:00', |
|
90 |
(SELECT id FROM Person WHERE displayname = 'Steve Alexander') |
|
91 |
);
|
|
92 |
||
93 |
INSERT INTO Manifest (datecreated, owner) |
|
94 |
VALUES (timestamp '2004-07-01 00:00', |
|
95 |
(SELECT id FROM Person WHERE displayname = 'Andrew Bennetts') |
|
96 |
);
|
|
97 |
||
98 |
INSERT INTO Manifest (datecreated, owner) |
|
99 |
VALUES (timestamp '2004-07-02 00:00', |
|
100 |
(SELECT id FROM Person WHERE displayname = 'Dave Miller') |
|
101 |
);
|
|
102 |
||
103 |
INSERT INTO Manifest (datecreated, owner) |
|
104 |
VALUES (timestamp '2004-07-03 00:00', |
|
105 |
(SELECT id FROM Person WHERE displayname = 'James Blackwell') |
|
106 |
);
|
|
107 |
||
108 |
INSERT INTO Manifest (datecreated, owner) |
|
109 |
VALUES (timestamp '2004-07-04 00:00', |
|
110 |
(SELECT id FROM Person WHERE displayname = 'Christian Reis') |
|
111 |
);
|
|
112 |
||
113 |
INSERT INTO Manifest (datecreated, owner) |
|
114 |
VALUES (timestamp '2004-07-05 00:00', |
|
115 |
(SELECT id FROM Person WHERE displayname = 'Alexander Limi') |
|
116 |
);
|
|
117 |
||
118 |
||
119 |
/*
|
|
120 |
--CodeRelease
|
|
121 |
INSERT INTO CodeRelease (sourcepackagerelease, manifest)
|
|
122 |
VALUES ((SELECT id FROM SourcePackageRelease WHERE
|
|
123 |
dateuploaded = timestamp '2004-06-29 00:00'),
|
|
124 |
(SELECT id FROM Manifest WHERE datecreated = timestamp '2004-06-29 00:00'));
|
|
125 |
||
126 |
INSERT INTO CodeRelease (sourcepackagerelease, manifest)
|
|
127 |
VALUES ((SELECT id FROM SourcePackageRelease WHERE
|
|
128 |
dateuploaded = timestamp '2004-06-30 00:00'),
|
|
129 |
(SELECT id FROM Manifest WHERE datecreated = timestamp '2004-06-30 00:00'));
|
|
130 |
||
131 |
INSERT INTO CodeRelease (sourcepackagerelease, manifest)
|
|
132 |
VALUES ((SELECT id FROM SourcePackageRelease WHERE
|
|
133 |
dateuploaded = timestamp '2004-07-01 00:00'),
|
|
134 |
(SELECT id FROM Manifest WHERE datecreated = timestamp '2004-07-01 00:00'));
|
|
135 |
||
136 |
INSERT INTO CodeRelease (sourcepackagerelease, manifest)
|
|
137 |
VALUES ((SELECT id FROM SourcePackageRelease WHERE
|
|
138 |
dateuploaded = timestamp '2004-07-02 00:00'),
|
|
139 |
(SELECT id FROM Manifest WHERE datecreated = timestamp '2004-07-02 00:00'));
|
|
140 |
||
141 |
INSERT INTO CodeRelease (sourcepackagerelease, manifest)
|
|
142 |
VALUES ((SELECT id FROM SourcePackageRelease WHERE
|
|
143 |
dateuploaded = timestamp '2004-07-03 00:00'),
|
|
144 |
(SELECT id FROM Manifest WHERE datecreated = timestamp '2004-07-03 00:00'));
|
|
145 |
||
146 |
INSERT INTO CodeRelease (sourcepackagerelease, manifest)
|
|
147 |
VALUES ((SELECT id FROM SourcePackageRelease WHERE
|
|
148 |
dateuploaded = timestamp '2004-07-04 00:00'),
|
|
149 |
(SELECT id FROM Manifest WHERE datecreated = timestamp '2004-07-04 00:00'));
|
|
150 |
||
151 |
INSERT INTO CodeRelease (sourcepackagerelease, manifest)
|
|
152 |
VALUES ((SELECT id FROM SourcePackageRelease WHERE
|
|
153 |
dateuploaded = timestamp '2004-07-05 00:00'),
|
|
154 |
(SELECT id FROM Manifest WHERE datecreated = timestamp '2004-06-29 00:00'));
|
|
155 |
||
156 |
||
157 |
--ArchArchive
|
|
158 |
INSERT INTO ArchArchive (name, title, description, visible)
|
|
159 |
VALUES ('mozilla', 'Mozilla', 'text', false);
|
|
160 |
||
161 |
INSERT INTO ArchArchive (name, title, description, visible)
|
|
162 |
VALUES ('thunderbird', 'Thunderbid', 'text', false);
|
|
163 |
||
164 |
INSERT INTO ArchArchive (name, title, description, visible)
|
|
165 |
VALUES ('twisted', 'Twisted', 'text', false);
|
|
166 |
||
167 |
INSERT INTO ArchArchive (name, title, description, visible)
|
|
168 |
VALUES ('bugzila', 'Bugzila', 'text', false);
|
|
169 |
||
170 |
INSERT INTO ArchArchive (name, title, description, visible)
|
|
171 |
VALUES ('arch', 'Arch', 'text', false);
|
|
172 |
||
173 |
INSERT INTO ArchArchive (name, title, description, visible)
|
|
174 |
VALUES ('kiwi2', 'Kiwi2', 'text', false);
|
|
175 |
||
176 |
INSERT INTO ArchArchive (name, title, description, visible)
|
|
177 |
VALUES ('plone', 'Plone', 'text', false);
|
|
178 |
||
179 |
||
180 |
--Archnamespace
|
|
181 |
INSERT INTO Archnamespace (archarchive, category, visible)
|
|
182 |
VALUES (1, 'mozilla', true);
|
|
183 |
||
184 |
INSERT INTO Archnamespace (archarchive, category, visible)
|
|
185 |
VALUES (2, 'tunderbird', true);
|
|
186 |
||
187 |
INSERT INTO Archnamespace (archarchive, category, visible)
|
|
188 |
VALUES (3, 'twisted', true);
|
|
189 |
||
190 |
INSERT INTO Archnamespace (archarchive, category, visible)
|
|
191 |
VALUES (4, 'bugzila', true);
|
|
192 |
||
193 |
INSERT INTO Archnamespace (archarchive, category, visible)
|
|
194 |
VALUES (5, 'arch', true);
|
|
195 |
||
196 |
INSERT INTO Archnamespace (archarchive, category, visible)
|
|
197 |
VALUES (6, 'kiwi2', true);
|
|
198 |
||
199 |
INSERT INTO Archnamespace (archarchive, category, visible)
|
|
200 |
VALUES (7, 'plone', true);
|
|
201 |
||
202 |
||
203 |
--Branch
|
|
204 |
INSERT INTO Branch (archnamespace, title, description, owner)
|
|
205 |
VALUES ((SELECT id FROM ArchArchive WHERE name = 'mozilla'),
|
|
206 |
'Mozilla Firefox 0.9.1', 'text',
|
|
207 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth'));
|
|
208 |
||
209 |
INSERT INTO Branch (archnamespace, title, description, owner)
|
|
210 |
VALUES ((SELECT id FROM ArchArchive WHERE name = 'thunderbird'),
|
|
211 |
'Mozilla Thunderbird 0.9.1', 'text',
|
|
212 |
(SELECT id FROM Person WHERE displayname = 'Steve Alexander'));
|
|
213 |
||
214 |
INSERT INTO Branch (archnamespace, title, description, owner)
|
|
215 |
VALUES ((SELECT id FROM ArchArchive WHERE name = 'twisted'),
|
|
216 |
'Python Twisted 0.9.1', 'text',
|
|
217 |
(SELECT id FROM Person WHERE displayname = 'Andrew Bennetts'));
|
|
218 |
||
219 |
INSERT INTO Branch (archnamespace, title, description, owner)
|
|
220 |
VALUES ((SELECT id FROM ArchArchive WHERE name = 'bugzila'),
|
|
221 |
'Bugzila 0.9.1', 'text',
|
|
222 |
(SELECT id FROM Person WHERE displayname = 'Dave Miller'));
|
|
223 |
||
224 |
INSERT INTO Branch (archnamespace, title, description, owner)
|
|
225 |
VALUES ((SELECT id FROM ArchArchive WHERE name = 'arch'),
|
|
226 |
'Arch 0.9.1', 'text',
|
|
227 |
(SELECT id FROM Person WHERE displayname = 'James Blackwell'));
|
|
228 |
||
229 |
INSERT INTO Branch (archnamespace, title, description, owner)
|
|
230 |
VALUES ((SELECT id FROM ArchArchive WHERE name = 'kiwi2'),
|
|
231 |
'Kiwi2 0.9.1', 'text',
|
|
232 |
(SELECT id FROM Person WHERE displayname = 'Christian Reis'));
|
|
233 |
||
234 |
INSERT INTO Branch (archnamespace, title, description, owner)
|
|
235 |
VALUES ((SELECT id FROM ArchArchive WHERE name = 'plone'),
|
|
236 |
'Plone 0.9.1', 'text',
|
|
237 |
(SELECT id FROM Person WHERE displayname = 'Alexander Limi'));
|
|
238 |
||
239 |
*/
|
|
240 |
||
241 |
-- Label
|
|
242 |
INSERT INTO Label (schema, name, title, description) |
|
243 |
VALUES ((SELECT id FROM Schema WHERE name = 'Mark schema'), |
|
244 |
'blah', 'blah', 'blah'); |
|
245 |
-- ProcessorFamily
|
|
246 |
INSERT INTO ProcessorFamily (name, title, description, owner) |
|
247 |
VALUES ('x86', 'Intel 386 compatible chips', 'Bring back the 8086!', |
|
248 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth')); |
|
249 |
||
250 |
-- Processor
|
|
251 |
INSERT INTO Processor (family, name, title, description, owner) |
|
252 |
VALUES ((SELECT id FROM ProcessorFamily WHERE name = 'x86'), |
|
253 |
'386', 'Intel 386', |
|
254 |
'Intel 386 and its many derivatives and clones, the basic 32-bit chip in the x86 family', |
|
255 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth')); |
|
256 |
||
257 |
-- Distribution
|
|
258 |
INSERT INTO Distribution (name, title, description, domainname, owner) |
|
259 |
values ('ubuntu', 'Ubuntu', |
|
260 |
'Ubuntu is a new concept of GNU/Linux Distribution based on Debian GNU/Linux.', |
|
261 |
'domain', 1); |
|
262 |
||
263 |
INSERT INTO Distribution (name, title, description, domainname, owner) |
|
264 |
values ('redhat', 'Redhat Advanced Server', |
|
265 |
'Red Hat is a commercial distribution of GNU/Linux Operating System.', |
|
266 |
'domain', 1); |
|
267 |
||
268 |
INSERT INTO Distribution (name, title, description, domainname, owner) |
|
269 |
values ('debian', 'Debian GNU/Linux', |
|
270 |
'Debian GNU/Linux is a non commercial distribution of a GNU/Linux Operating System for many platforms.', |
|
271 |
'domain', 1); |
|
272 |
||
273 |
INSERT INTO Distribution (name, title, description, domainname, owner) |
|
274 |
values ('gentoo', 'The Gentoo Linux', |
|
275 |
'Gentoo is a very customizeable GNU/Linux Distribution', |
|
276 |
'domain', 1); |
|
277 |
||
278 |
INSERT INTO Distribution (name, title, description, domainname, owner) |
|
279 |
values ('porkypigpolka', 'Porky Pig Polka Distribution', |
|
280 |
'Should be near the Spork concept of GNU/Linux Distribution', |
|
281 |
'domain', 1); |
|
282 |
||
283 |
||
284 |
||
285 |
-- Distrorelease
|
|
286 |
INSERT INTO Distrorelease (name, title, description, distribution, version, |
|
287 |
datereleased, components, sections, releasestate, owner) |
|
288 |
values
|
|
289 |
('warty', 'Warty', 'This is the first stable release of Ubuntu', |
|
290 |
(SELECT id FROM Distribution WHERE name = 'ubuntu'), |
|
291 |
'1.0.0', |
|
292 |
'2004-08-20', |
|
293 |
1, 1, 3, 1); |
|
294 |
||
295 |
INSERT INTO Distrorelease (name, title, description, distribution, version, |
|
296 |
datereleased, components, sections, releasestate, owner) |
|
297 |
VALUES ('six', 'Six Six Six', |
|
298 |
'some text to describe the whole 666 release of RH', |
|
299 |
(SELECT id FROM Distribution WHERE name = 'redhat'), |
|
300 |
'6.0.1', |
|
301 |
'2004-03-21', |
|
302 |
1, 1, 4, 8); |
|
303 |
||
304 |
INSERT INTO Distrorelease (name, title, description, distribution, version, |
|
305 |
datereleased, components, sections, releasestate, parentrelease, |
|
306 |
owner) |
|
307 |
VALUES ('hoary', 'Hoary Crazy-Unstable', |
|
308 |
'Hoary is the next release of Ubuntu', |
|
309 |
(SELECT id FROM Distribution WHERE name = 'ubuntu'), |
|
310 |
'0.0.1', |
|
311 |
'2004-08-25', |
|
312 |
1, 1, 2, |
|
313 |
(SELECT id FROM Distrorelease WHERE name = 'warty'), |
|
314 |
1); |
|
315 |
||
316 |
INSERT INTO Distrorelease (name, title, description, distribution, version, |
|
317 |
datereleased, components, sections, releasestate, parentrelease, |
|
318 |
owner) |
|
319 |
VALUES ('7.0', 'Seven', |
|
320 |
'The release that we would not expect', |
|
321 |
(SELECT id FROM Distribution WHERE name = 'redhat'), |
|
322 |
'7.0.1', |
|
323 |
'2004-04-01', |
|
324 |
1, 1, 3, |
|
325 |
(SELECT id FROM Distrorelease WHERE name = 'six'), |
|
326 |
7); |
|
327 |
||
328 |
INSERT INTO Distrorelease (name, title, description, distribution, version, |
|
329 |
datereleased, components, sections, releasestate, parentrelease, |
|
330 |
owner) |
|
331 |
VALUES ('grumpy', 'G-R-U-M-P-Y', |
|
332 |
'Grumpy is far far away, but should be the third release of Ubuntu', |
|
333 |
(SELECT id FROM Distribution WHERE name = 'ubuntu'), |
|
334 |
'-0.0.1', |
|
335 |
'2004-08-29', |
|
336 |
1, 1, 1, |
|
337 |
(SELECT id FROM Distrorelease WHERE name = 'warty'), |
|
338 |
1); |
|
339 |
||
340 |
INSERT INTO Distrorelease (name, title, description, distribution, version, |
|
341 |
datereleased, components, sections, releasestate, owner) |
|
342 |
VALUES ('woody', 'WOODY', |
|
343 |
'WOODY is the current stable verison of Debian GNU/Linux', |
|
344 |
(SELECT id FROM Distribution WHERE name = 'debian'), |
|
345 |
'3.0', |
|
346 |
'2003-01-01', |
|
347 |
1, 1, 4, 2); |
|
348 |
||
349 |
INSERT INTO Distrorelease (name, title, description, distribution, version, |
|
350 |
datereleased, components, sections, releasestate, parentrelease, |
|
351 |
owner) |
|
352 |
VALUES ('sarge', 'Sarge', |
|
353 |
'Sarge is the FROZEN unstable version of Debian GNU/Linux.', |
|
354 |
(SELECT id FROM Distribution WHERE name = 'debian'), |
|
355 |
'3.1', |
|
356 |
'2004-09-29', |
|
357 |
1, 1, 3, |
|
358 |
(SELECT id FROM Distrorelease WHERE name = 'woody'), |
|
359 |
5); |
|
360 |
||
361 |
INSERT INTO Distrorelease (name, title, description, distribution, version, |
|
362 |
datereleased, components, sections, releasestate, parentrelease, |
|
363 |
owner) |
|
364 |
VALUES ('sid', 'Sid', |
|
365 |
'Sid is the CRAZY unstable version of Debian GNU/Linux.', |
|
366 |
(SELECT id FROM Distribution WHERE name = 'debian'), |
|
367 |
'3.2', |
|
368 |
'2004-12-29', |
|
369 |
1, 1, 1, |
|
370 |
(SELECT id FROM Distrorelease WHERE name = 'woody'), |
|
371 |
6); |
|
372 |
||
373 |
--Distroreleaserole Persons ?!
|
|
374 |
||
375 |
INSERT INTO Distroreleaserole (person, distrorelease, role) |
|
376 |
VALUES( |
|
377 |
(SELECT id from Person WHERE displayname = 'Mark Shuttleworth'), |
|
378 |
(SELECT id from Distrorelease WHERE name = 'warty'), |
|
379 |
1); |
|
380 |
INSERT INTO Distroreleaserole (person, distrorelease, role) |
|
381 |
VALUES( |
|
382 |
(SELECT id from Person WHERE displayname = 'Mark Shuttleworth'), |
|
383 |
(SELECT id from Distrorelease WHERE name = 'hoary'), |
|
384 |
1); |
|
385 |
INSERT INTO Distroreleaserole (person, distrorelease, role) |
|
386 |
VALUES( |
|
387 |
(SELECT id from Person WHERE displayname = 'Mark Shuttleworth'), |
|
388 |
(SELECT id from Distrorelease WHERE name = 'grumpy'), |
|
389 |
1); |
|
390 |
||
391 |
INSERT INTO Distroreleaserole (person, distrorelease, role) |
|
392 |
VALUES( |
|
393 |
(SELECT id from Person WHERE displayname = 'Steve Alexander'), |
|
394 |
(SELECT id from Distrorelease WHERE name = 'warty'), |
|
395 |
2); |
|
396 |
INSERT INTO Distroreleaserole (person, distrorelease, role) |
|
397 |
VALUES( |
|
398 |
(SELECT id from Person WHERE displayname = 'Steve Alexander'), |
|
399 |
(SELECT id from Distrorelease WHERE name = 'hoary'), |
|
400 |
2); |
|
401 |
INSERT INTO Distroreleaserole (person, distrorelease, role) |
|
402 |
VALUES( |
|
403 |
(SELECT id from Person WHERE displayname = 'Steve Alexander'), |
|
404 |
(SELECT id from Distrorelease WHERE name = 'grumpy'), |
|
405 |
3); |
|
406 |
||
407 |
-- Distroreleaserole Teams ?!
|
|
408 |
||
409 |
INSERT INTO Distroreleaserole (person, distrorelease, role) |
|
410 |
VALUES( |
|
411 |
(SELECT id from Person WHERE displayname = 'Warty Security Team'), |
|
412 |
(SELECT id from Distrorelease WHERE name = 'warty'), |
|
413 |
4); |
|
414 |
||
415 |
INSERT INTO Distroreleaserole (person, distrorelease, role) |
|
416 |
VALUES( |
|
417 |
(SELECT id from Person WHERE displayname = 'Warty Gnome Team'), |
|
418 |
(SELECT id from Distrorelease WHERE name = 'warty'), |
|
419 |
4); |
|
420 |
||
421 |
INSERT INTO Distroreleaserole (person, distrorelease, role) |
|
422 |
VALUES( |
|
423 |
(SELECT id from Person WHERE displayname = 'Hoary Gnome Team'), |
|
424 |
(SELECT id from Distrorelease WHERE name = 'hoary'), |
|
425 |
4); |
|
426 |
||
427 |
||
428 |
--Distributionrole Persons ?!
|
|
429 |
||
430 |
INSERT INTO Distributionrole (person, distribution, role) |
|
431 |
VALUES( |
|
432 |
(SELECT id from Person WHERE displayname = 'Mark Shuttleworth'), |
|
433 |
(SELECT id from Distribution WHERE name = 'ubuntu'), |
|
434 |
1); |
|
435 |
||
436 |
INSERT INTO Distributionrole (person, distribution, role) |
|
437 |
VALUES( |
|
438 |
(SELECT id from Person WHERE displayname = 'Steve Alexander'), |
|
439 |
(SELECT id from Distribution WHERE name = 'ubuntu'), |
|
440 |
1); |
|
441 |
||
442 |
INSERT INTO Distributionrole (person, distribution, role) |
|
443 |
VALUES( |
|
444 |
(SELECT id from Person WHERE displayname = 'Alexander Limi'), |
|
445 |
(SELECT id from Distribution WHERE name = 'ubuntu'), |
|
446 |
1); |
|
447 |
||
448 |
INSERT INTO Distributionrole (person, distribution, role) |
|
449 |
VALUES( |
|
450 |
(SELECT id from Person WHERE displayname = 'Andrew Bennetts'), |
|
451 |
(SELECT id from Distribution WHERE name = 'ubuntu'), |
|
452 |
1); |
|
453 |
||
454 |
INSERT INTO Distributionrole (person, distribution, role) |
|
455 |
VALUES( |
|
456 |
(SELECT id from Person WHERE displayname = 'Scott James Remnant'), |
|
457 |
(SELECT id from Distribution WHERE name = 'ubuntu'), |
|
458 |
1); |
|
459 |
||
460 |
-- DistributionRole Teams ?!
|
|
461 |
||
462 |
INSERT INTO Distributionrole (person, distribution, role) |
|
463 |
VALUES( |
|
464 |
(SELECT id from Person WHERE displayname = 'Ubuntu Team'), |
|
465 |
(SELECT id from Distribution WHERE name = 'ubuntu'), |
|
466 |
3); |
|
467 |
||
468 |
INSERT INTO Distributionrole (person, distribution, role) |
|
469 |
VALUES( |
|
470 |
(SELECT id from Person WHERE displayname = 'Ubuntu Gnome Team'), |
|
471 |
(SELECT id from Distribution WHERE name = 'ubuntu'), |
|
472 |
3); |
|
473 |
||
474 |
||
475 |
--DistroArchrelease
|
|
476 |
INSERT INTO Distroarchrelease(distrorelease, processorfamily, architecturetag, |
|
477 |
owner) VALUES |
|
478 |
((SELECT id FROM Distrorelease where name = 'warty'), |
|
479 |
(SELECT id from Processorfamily where name = 'x86'), |
|
480 |
'i386', |
|
481 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth') |
|
482 |
);
|
|
483 |
||
|
2663
by Canonical.com Patch Queue Manager
[r=stevea] Landing NominatedArchIndep changes. |
484 |
INSERT INTO Distroarchrelease(distrorelease, processorfamily, architecturetag, |
485 |
owner) VALUES |
|
486 |
((SELECT id FROM Distrorelease where name = 'hoary'), |
|
487 |
(SELECT id from Processorfamily where name = 'x86'), |
|
488 |
'i386', |
|
489 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth') |
|
490 |
);
|
|
491 |
||
492 |
INSERT INTO Distroarchrelease(distrorelease, processorfamily, architecturetag, |
|
493 |
owner) VALUES |
|
494 |
((SELECT id FROM Distrorelease where name = 'woody'), |
|
495 |
(SELECT id from Processorfamily where name = 'x86'), |
|
496 |
'i386', |
|
497 |
(SELECT id FROM Person WHERE displayname = 'Mark Shuttleworth') |
|
498 |
);
|
|
499 |
||
|
1102
by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs |
500 |
-- Build
|
501 |
||
502 |
INSERT INTO Build (datecreated, processor, distroarchrelease, buildstate) |
|
503 |
VALUES
|
|
504 |
('2004-08-24', |
|
505 |
(SELECT id FROM Processor where name = '386'), |
|
506 |
1, -- hardcoded ?!?! use query instead |
|
507 |
1 -- ?? |
|
508 |
);
|
|
509 |