|
8687.15.9
by Karl Fogel
Add the copyright header block to more files (everything under database/). |
1 |
-- Copyright 2009 Canonical Ltd. This software is licensed under the
|
2 |
-- GNU Affero General Public License version 3 (see the file LICENSE).
|
|
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
3 |
|
4 |
-- Autotest distrorelease
|
|
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
5 |
INSERT INTO Distrorelease (name, title, description, distribution, version, |
6 |
summary, datereleased, releasestatus, parentrelease, |
|
7 |
owner, displayname) |
|
8 |
VALUES ('breezy-autotest', 'Breezy Badger Autotest', |
|
9 |
'Autotest version of Breezy', |
|
10 |
(SELECT id FROM Distribution WHERE name = 'ubuntu'), |
|
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
11 |
'6.6.6', 'Autosync uploader test', |
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
12 |
'2005-12-01 10:00:00', 1, |
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
13 |
(SELECT id FROM Distrorelease WHERE name = 'warty'), |
|
9105.3.1
by Brad Crittenden
Changed sample data to remove sabdfl. |
14 |
(SELECT id FROM Person WHERE name = 'mark'), |
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
15 |
'Breezy Badger Autotest'); |
16 |
||
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
17 |
-- distroarchrelease for i386
|
18 |
INSERT INTO Distroarchrelease (distrorelease, processorfamily, |
|
19 |
architecturetag, owner, official) |
|
20 |
VALUES ( |
|
21 |
(SELECT id FROM Distrorelease WHERE name = 'breezy-autotest'), |
|
22 |
(SELECT id FROM ProcessorFamily WHERE name = 'x86') |
|
23 |
'i386', |
|
|
9105.3.1
by Brad Crittenden
Changed sample data to remove sabdfl. |
24 |
(SELECT id FROM Person WHERE name = 'mark'), |
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
25 |
true); |
26 |
||
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
27 |
-- section selection
|
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
28 |
INSERT INTO SectionSelection (distrorelease, section) |
29 |
VALUES( |
|
30 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
31 |
(SELECT id from Section where name = 'admin')); |
|
32 |
||
33 |
INSERT INTO SectionSelection (distrorelease, section) |
|
34 |
VALUES( |
|
35 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
36 |
(SELECT id from Section where name = 'base')); |
|
37 |
||
38 |
INSERT INTO SectionSelection (distrorelease, section) |
|
39 |
VALUES( |
|
40 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
41 |
(SELECT id from Section where name = 'comm')); |
|
42 |
||
43 |
INSERT INTO SectionSelection (distrorelease, section) |
|
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
44 |
VALUES( |
45 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
46 |
(SELECT id from Section where name = 'debian-installer')); |
47 |
||
48 |
INSERT INTO SectionSelection (distrorelease, section) |
|
49 |
VALUES( |
|
50 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
51 |
(SELECT id from Section where name = 'devel')); |
|
52 |
||
53 |
INSERT INTO SectionSelection (distrorelease, section) |
|
54 |
VALUES( |
|
55 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
56 |
(SELECT id from Section where name = 'doc')); |
|
57 |
||
58 |
INSERT INTO SectionSelection (distrorelease, section) |
|
59 |
VALUES( |
|
60 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
61 |
(SELECT id from Section where name = 'editors')); |
|
62 |
||
63 |
INSERT INTO SectionSelection (distrorelease, section) |
|
64 |
VALUES( |
|
65 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
66 |
(SELECT id from Section where name = 'games')); |
|
67 |
||
68 |
INSERT INTO SectionSelection (distrorelease, section) |
|
69 |
VALUES( |
|
70 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
71 |
(SELECT id from Section where name = 'gnome')); |
|
72 |
||
73 |
INSERT INTO SectionSelection (distrorelease, section) |
|
74 |
VALUES( |
|
75 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
76 |
(SELECT id from Section where name = 'graphics')); |
|
77 |
||
78 |
INSERT INTO SectionSelection (distrorelease, section) |
|
79 |
VALUES( |
|
80 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
81 |
(SELECT id from Section where name = 'interpreters')); |
|
82 |
||
83 |
INSERT INTO SectionSelection (distrorelease, section) |
|
84 |
VALUES( |
|
85 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
86 |
(SELECT id from Section where name = 'kde')); |
|
87 |
||
88 |
INSERT INTO SectionSelection (distrorelease, section) |
|
89 |
VALUES( |
|
90 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
91 |
(SELECT id from Section where name = 'libdevel')); |
|
92 |
||
93 |
INSERT INTO SectionSelection (distrorelease, section) |
|
94 |
VALUES( |
|
95 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
96 |
(SELECT id from Section where name = 'libs')); |
|
97 |
||
98 |
INSERT INTO SectionSelection (distrorelease, section) |
|
99 |
VALUES( |
|
100 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
101 |
(SELECT id from Section where name = 'mail')); |
|
102 |
||
103 |
INSERT INTO SectionSelection (distrorelease, section) |
|
104 |
VALUES( |
|
105 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
106 |
(SELECT id from Section where name = 'math')); |
|
107 |
||
108 |
INSERT INTO SectionSelection (distrorelease, section) |
|
109 |
VALUES( |
|
110 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
111 |
(SELECT id from Section where name = 'misc')); |
|
112 |
||
113 |
INSERT INTO SectionSelection (distrorelease, section) |
|
114 |
VALUES( |
|
115 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
116 |
(SELECT id from Section where name = 'net')); |
|
117 |
||
118 |
INSERT INTO SectionSelection (distrorelease, section) |
|
119 |
VALUES( |
|
120 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
121 |
(SELECT id from Section where name = 'news')); |
|
122 |
||
123 |
INSERT INTO SectionSelection (distrorelease, section) |
|
124 |
VALUES( |
|
125 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
126 |
(SELECT id from Section where name = 'oldlibs')); |
|
127 |
||
128 |
INSERT INTO SectionSelection (distrorelease, section) |
|
129 |
VALUES( |
|
130 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
131 |
(SELECT id from Section where name = 'otherosfs')); |
|
132 |
||
133 |
INSERT INTO SectionSelection (distrorelease, section) |
|
134 |
VALUES( |
|
135 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
136 |
(SELECT id from Section where name = 'perl')); |
|
137 |
||
138 |
INSERT INTO SectionSelection (distrorelease, section) |
|
139 |
VALUES( |
|
140 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
141 |
(SELECT id from Section where name = 'python')); |
|
142 |
||
143 |
INSERT INTO SectionSelection (distrorelease, section) |
|
144 |
VALUES( |
|
145 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
146 |
(SELECT id from Section where name = 'shells')); |
|
147 |
||
148 |
INSERT INTO SectionSelection (distrorelease, section) |
|
149 |
VALUES( |
|
150 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
151 |
(SELECT id from Section where name = 'sound')); |
|
152 |
||
153 |
INSERT INTO SectionSelection (distrorelease, section) |
|
154 |
VALUES( |
|
155 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
156 |
(SELECT id from Section where name = 'tex')); |
|
157 |
||
158 |
INSERT INTO SectionSelection (distrorelease, section) |
|
159 |
VALUES( |
|
160 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
161 |
(SELECT id from Section where name = 'text')); |
|
162 |
||
163 |
INSERT INTO SectionSelection (distrorelease, section) |
|
164 |
VALUES( |
|
165 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
166 |
(SELECT id from Section where name = 'utils')); |
|
167 |
||
168 |
INSERT INTO SectionSelection (distrorelease, section) |
|
169 |
VALUES( |
|
170 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
171 |
(SELECT id from Section where name = 'web')); |
|
172 |
||
173 |
INSERT INTO SectionSelection (distrorelease, section) |
|
174 |
VALUES( |
|
175 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
176 |
(SELECT id from Section where name = 'x11')); |
|
177 |
||
178 |
INSERT INTO SectionSelection (distrorelease, section) |
|
179 |
VALUES( |
|
180 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
181 |
(SELECT id from Section where name = 'electronics')); |
|
182 |
||
183 |
INSERT INTO SectionSelection (distrorelease, section) |
|
184 |
VALUES( |
|
185 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
186 |
(SELECT id from Section where name = 'embedded')); |
|
187 |
||
188 |
INSERT INTO SectionSelection (distrorelease, section) |
|
189 |
VALUES( |
|
190 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
191 |
(SELECT id from Section where name = 'hamradio')); |
|
192 |
||
193 |
INSERT INTO SectionSelection (distrorelease, section) |
|
194 |
VALUES( |
|
195 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
196 |
(SELECT id from Section where name = 'science')); |
|
197 |
||
198 |
INSERT INTO SectionSelection (distrorelease, section) |
|
199 |
VALUES( |
|
200 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
201 |
(SELECT id from Section where name = 'translations')); |
|
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
202 |
|
203 |
-- component selection
|
|
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
204 |
INSERT INTO ComponentSelection (distrorelease, component) |
205 |
VALUES( |
|
206 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
207 |
(SELECT id from Component where name = 'main')); |
|
208 |
||
209 |
INSERT INTO ComponentSelection (distrorelease, component) |
|
210 |
VALUES( |
|
211 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
212 |
(SELECT id from Component where name = 'restricted')); |
|
213 |
||
214 |
INSERT INTO ComponentSelection (distrorelease, component) |
|
215 |
VALUES( |
|
216 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
217 |
(SELECT id from Component where name = 'universe')); |
|
218 |
||
219 |
INSERT INTO ComponentSelection (distrorelease, component) |
|
220 |
VALUES( |
|
221 |
(SELECT id from distrorelease where name='breezy-autotest'), |
|
222 |
(SELECT id from Component where name = 'multiverse')); |
|
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
223 |
|
224 |
-- Grant upload permission for 'Uploader-Test Team' members
|
|
225 |
INSERT INTO DistroComponentUploader (distribution, component, uploader) |
|
226 |
VALUES ((SELECT id from Distribution where name = 'ubuntu') , |
|
227 |
(SELECT id from Component where name = 'main'), |
|
|
2865.2.8
by Celso Providelo
Add lucilleconfig in sampledata and fix minor bugs in publisher script. |
228 |
(SELECT id from Person where name = 'ubuntu-team')); |
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
229 |
|
230 |
INSERT INTO DistroComponentUploader (distribution, component, uploader) |
|
231 |
VALUES ((SELECT id from Distribution where name = 'ubuntu'), |
|
232 |
(SELECT id from Component where name = 'restricted'), |
|
|
2865.2.8
by Celso Providelo
Add lucilleconfig in sampledata and fix minor bugs in publisher script. |
233 |
(SELECT id from Person where name = 'ubuntu-team')); |
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
234 |
|
235 |
INSERT INTO DistroComponentUploader (distribution, component, uploader) |
|
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
236 |
VALUES ((SELECT id from Distribution where name = 'ubuntu'), |
|
2865.2.7
by Celso Providelo
Integrating DB tweaks required for upload-and-queue and breezy-autotest, renaming and fixing tests. |
237 |
(SELECT id from Component where name = 'universe'), |
|
2865.2.8
by Celso Providelo
Add lucilleconfig in sampledata and fix minor bugs in publisher script. |
238 |
(SELECT id from Person where name = 'ubuntu-team')); |
239 |
||
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
240 |
INSERT INTO DistroComponentUploader (distribution, component, uploader) |
241 |
VALUES ((SELECT id from Distribution where name = 'ubuntu'), |
|
242 |
(SELECT id from Component where name = 'multiverse'), |
|
243 |
(SELECT id from Person where name = 'ubuntu-team')); |
|
244 |
||
|
2865.2.8
by Celso Providelo
Add lucilleconfig in sampledata and fix minor bugs in publisher script. |
245 |
-- Lucille Config for Ubuntu distribution
|
246 |
UPDATE distribution set lucilleconfig = '[publishing] |
|
247 |
pendingremovalduration=5
|
|
248 |
root=/var/tmp/archive
|
|
249 |
archiveroot=/var/tmp/archive/ubuntu
|
|
250 |
poolroot=/var/tmp/archive/ubuntu/pool
|
|
251 |
distsroot=/var/tmp/archive/ubuntu/dists
|
|
252 |
overrideroot=/var/tmp/archive/ubuntu-overrides
|
|
253 |
cacheroot=/var/tmp/archive/ubuntu-cache
|
|
254 |
miscroot=/var/tmp/archive/ubuntu-misc
|
|
255 |
' WHERE name = 'ubuntu'; |
|
256 |
||
257 |
-- Lucille Config for Ubuntu Distroreleases
|
|
258 |
UPDATE distrorelease set lucilleconfig = '[publishing] |
|
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
259 |
components = main restricted universe multiverse
|
|
2865.2.8
by Celso Providelo
Add lucilleconfig in sampledata and fix minor bugs in publisher script. |
260 |
' WHERE name = 'breezy-autotest'; |
261 |
||
262 |
UPDATE distrorelease set lucilleconfig = '[publishing] |
|
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
263 |
components = main restricted universe multiverse
|
|
2865.2.8
by Celso Providelo
Add lucilleconfig in sampledata and fix minor bugs in publisher script. |
264 |
' WHERE name = 'warty'; |
265 |
||
266 |
UPDATE distrorelease set lucilleconfig = '[publishing] |
|
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
267 |
components = main restricted universe multiverse
|
|
2865.2.8
by Celso Providelo
Add lucilleconfig in sampledata and fix minor bugs in publisher script. |
268 |
' WHERE name = 'hoary'; |
269 |
||
270 |
UPDATE distrorelease set lucilleconfig = '[publishing] |
|
|
2865.2.37
by Celso Providelo
Fix buildd-monitor (correct builder RPC url), fix job ordering in slave-scanner (descend order), removing anoying trailing whitespaces. |
271 |
components = main restricted universe multiverse
|
|
2865.2.8
by Celso Providelo
Add lucilleconfig in sampledata and fix minor bugs in publisher script. |
272 |
' WHERE name = 'grumpy'; |