2 SET search_path = public;
4 -- Create new all-in-one tables.
6 CREATE TABLE packages (
7 architecture character varying NOT NULL,
8 package character varying NOT NULL,
9 distribution character varying NOT NULL REFERENCES distributions(distribution),
11 state character varying,
12 section character varying,
13 priority character varying,
14 installed_version character varying,
15 previous_state character varying,
16 state_change timestamp without time zone,
17 notes character varying,
18 builder character varying,
21 binary_nmu_version integer,
22 binary_nmu_changelog character varying,
23 failed_category character varying,
26 depends character varying,
27 rel character varying,
29 extra_depends character varying,
30 extra_conflicts character varying,
31 build_arch_all boolean DEFAULT false,
32 PRIMARY KEY (architecture, package, distribution)
34 CREATE INDEX packages_distribution_package ON packages (distribution, package); -- For the stored procedure "query_source_package".
35 CREATE INDEX packages_arch_dist_state ON packages (architecture, distribution, upper(state)); -- For wanna-build's list query.
36 ALTER TABLE packages OWNER TO wbadm;
37 REVOKE ALL ON packages FROM PUBLIC;
39 CREATE TABLE pkg_history (
40 architecture character varying NOT NULL,
41 package character varying NOT NULL,
42 distribution character varying NOT NULL REFERENCES distributions(distribution),
43 version debversion NOT NULL,
44 "timestamp" timestamp without time zone NOT NULL,
45 result character varying NOT NULL,
48 builder character varying,
49 PRIMARY KEY (architecture, package, distribution, version, "timestamp")
51 CREATE INDEX pkg_history_timestamp on pkg_history (timestamp); -- For the global view "lastlog".
52 ALTER TABLE pkg_history OWNER TO wbadm;
53 REVOKE ALL ON pkg_history FROM PUBLIC;
55 CREATE TABLE transactions (
56 architecture character varying,
57 package character varying,
58 distribution character varying,
60 action character varying,
61 prevstate character varying,
62 state character varying,
63 real_user character varying,
64 set_user character varying,
65 "time" timestamp without time zone
67 ALTER TABLE transactions OWNER TO wbadm;
68 REVOKE ALL ON transactions FROM PUBLIC;
71 architecture character varying NOT NULL,
72 username character varying NOT NULL,
73 distribution character varying NOT NULL,
74 last_seen timestamp without time zone,
75 PRIMARY KEY (architecture, username, distribution)
77 ALTER TABLE users OWNER TO wbadm;
78 REVOKE ALL ON users FROM PUBLIC;
82 LOCK TABLE "alpha".packages IN EXCLUSIVE MODE;
83 LOCK TABLE "amd64".packages IN EXCLUSIVE MODE;
84 LOCK TABLE "arm".packages IN EXCLUSIVE MODE;
85 LOCK TABLE "armel".packages IN EXCLUSIVE MODE;
86 LOCK TABLE "hppa".packages IN EXCLUSIVE MODE;
87 LOCK TABLE "hurd-i386".packages IN EXCLUSIVE MODE;
88 LOCK TABLE "i386".packages IN EXCLUSIVE MODE;
89 LOCK TABLE "ia64".packages IN EXCLUSIVE MODE;
90 LOCK TABLE "kfreebsd-amd64".packages IN EXCLUSIVE MODE;
91 LOCK TABLE "kfreebsd-i386".packages IN EXCLUSIVE MODE;
92 LOCK TABLE "mips".packages IN EXCLUSIVE MODE;
93 LOCK TABLE "mipsel".packages IN EXCLUSIVE MODE;
94 LOCK TABLE "powerpc".packages IN EXCLUSIVE MODE;
95 LOCK TABLE "s390".packages IN EXCLUSIVE MODE;
96 LOCK TABLE "sparc".packages IN EXCLUSIVE MODE;
98 LOCK TABLE "alpha".pkg_history IN EXCLUSIVE MODE;
99 LOCK TABLE "amd64".pkg_history IN EXCLUSIVE MODE;
100 LOCK TABLE "arm".pkg_history IN EXCLUSIVE MODE;
101 LOCK TABLE "armel".pkg_history IN EXCLUSIVE MODE;
102 LOCK TABLE "hppa".pkg_history IN EXCLUSIVE MODE;
103 LOCK TABLE "hurd-i386".pkg_history IN EXCLUSIVE MODE;
104 LOCK TABLE "i386".pkg_history IN EXCLUSIVE MODE;
105 LOCK TABLE "ia64".pkg_history IN EXCLUSIVE MODE;
106 LOCK TABLE "kfreebsd-amd64".pkg_history IN EXCLUSIVE MODE;
107 LOCK TABLE "kfreebsd-i386".pkg_history IN EXCLUSIVE MODE;
108 LOCK TABLE "mips".pkg_history IN EXCLUSIVE MODE;
109 LOCK TABLE "mipsel".pkg_history IN EXCLUSIVE MODE;
110 LOCK TABLE "powerpc".pkg_history IN EXCLUSIVE MODE;
111 LOCK TABLE "s390".pkg_history IN EXCLUSIVE MODE;
112 LOCK TABLE "sparc".pkg_history IN EXCLUSIVE MODE;
114 LOCK TABLE "alpha".transactions IN EXCLUSIVE MODE;
115 LOCK TABLE "amd64".transactions IN EXCLUSIVE MODE;
116 LOCK TABLE "arm".transactions IN EXCLUSIVE MODE;
117 LOCK TABLE "armel".transactions IN EXCLUSIVE MODE;
118 LOCK TABLE "hppa".transactions IN EXCLUSIVE MODE;
119 LOCK TABLE "hurd-i386".transactions IN EXCLUSIVE MODE;
120 LOCK TABLE "i386".transactions IN EXCLUSIVE MODE;
121 LOCK TABLE "ia64".transactions IN EXCLUSIVE MODE;
122 LOCK TABLE "kfreebsd-amd64".transactions IN EXCLUSIVE MODE;
123 LOCK TABLE "kfreebsd-i386".transactions IN EXCLUSIVE MODE;
124 LOCK TABLE "mips".transactions IN EXCLUSIVE MODE;
125 LOCK TABLE "mipsel".transactions IN EXCLUSIVE MODE;
126 LOCK TABLE "powerpc".transactions IN EXCLUSIVE MODE;
127 LOCK TABLE "s390".transactions IN EXCLUSIVE MODE;
128 LOCK TABLE "sparc".transactions IN EXCLUSIVE MODE;
130 LOCK TABLE "alpha".users IN EXCLUSIVE MODE;
131 LOCK TABLE "amd64".users IN EXCLUSIVE MODE;
132 LOCK TABLE "arm".users IN EXCLUSIVE MODE;
133 LOCK TABLE "armel".users IN EXCLUSIVE MODE;
134 LOCK TABLE "hppa".users IN EXCLUSIVE MODE;
135 LOCK TABLE "hurd-i386".users IN EXCLUSIVE MODE;
136 LOCK TABLE "i386".users IN EXCLUSIVE MODE;
137 LOCK TABLE "ia64".users IN EXCLUSIVE MODE;
138 LOCK TABLE "kfreebsd-amd64".users IN EXCLUSIVE MODE;
139 LOCK TABLE "kfreebsd-i386".users IN EXCLUSIVE MODE;
140 LOCK TABLE "mips".users IN EXCLUSIVE MODE;
141 LOCK TABLE "mipsel".users IN EXCLUSIVE MODE;
142 LOCK TABLE "powerpc".users IN EXCLUSIVE MODE;
143 LOCK TABLE "s390".users IN EXCLUSIVE MODE;
144 LOCK TABLE "sparc".users IN EXCLUSIVE MODE;
146 -- Copy the old data into the new all-in-one tables.
148 INSERT INTO packages SELECT 'alpha' AS architecture, * FROM "alpha".packages;
149 INSERT INTO packages SELECT 'amd64' AS architecture, * FROM "amd64".packages;
150 INSERT INTO packages SELECT 'arm' AS architecture, * FROM "arm".packages;
151 INSERT INTO packages SELECT 'armel' AS architecture, * FROM "armel".packages;
152 INSERT INTO packages SELECT 'hppa' AS architecture, * FROM "hppa".packages;
153 INSERT INTO packages SELECT 'hurd-i386' AS architecture, * FROM "hurd-i386".packages;
154 INSERT INTO packages SELECT 'i386' AS architecture, * FROM "i386".packages;
155 INSERT INTO packages SELECT 'ia64' AS architecture, * FROM "ia64".packages;
156 INSERT INTO packages SELECT 'kfreebsd-amd64' AS architecture, * FROM "kfreebsd-amd64".packages;
157 INSERT INTO packages SELECT 'kfreebsd-i386' AS architecture, * FROM "kfreebsd-i386".packages;
158 INSERT INTO packages SELECT 'mips' AS architecture, * FROM "mips".packages;
159 INSERT INTO packages SELECT 'mipsel' AS architecture, * FROM "mipsel".packages;
160 INSERT INTO packages SELECT 'powerpc' AS architecture, * FROM "powerpc".packages;
161 INSERT INTO packages SELECT 's390' AS architecture, * FROM "s390".packages;
162 INSERT INTO packages SELECT 'sparc' AS architecture, * FROM "sparc".packages;
164 INSERT INTO pkg_history SELECT 'alpha' AS architecture, * FROM "alpha".pkg_history;
165 INSERT INTO pkg_history SELECT 'amd64' AS architecture, * FROM "amd64".pkg_history;
166 INSERT INTO pkg_history SELECT 'arm' AS architecture, * FROM "arm".pkg_history;
167 INSERT INTO pkg_history SELECT 'armel' AS architecture, * FROM "armel".pkg_history;
168 INSERT INTO pkg_history SELECT 'hppa' AS architecture, * FROM "hppa".pkg_history;
169 INSERT INTO pkg_history SELECT 'hurd-i386' AS architecture, * FROM "hurd-i386".pkg_history;
170 INSERT INTO pkg_history SELECT 'i386' AS architecture, * FROM "i386".pkg_history;
171 INSERT INTO pkg_history SELECT 'ia64' AS architecture, * FROM "ia64".pkg_history;
172 INSERT INTO pkg_history SELECT 'kfreebsd-amd64' AS architecture, * FROM "kfreebsd-amd64".pkg_history;
173 INSERT INTO pkg_history SELECT 'kfreebsd-i386' AS architecture, * FROM "kfreebsd-i386".pkg_history;
174 INSERT INTO pkg_history SELECT 'mips' AS architecture, * FROM "mips".pkg_history;
175 INSERT INTO pkg_history SELECT 'mipsel' AS architecture, * FROM "mipsel".pkg_history;
176 INSERT INTO pkg_history SELECT 'powerpc' AS architecture, * FROM "powerpc".pkg_history;
177 INSERT INTO pkg_history SELECT 's390' AS architecture, * FROM "s390".pkg_history;
178 INSERT INTO pkg_history SELECT 'sparc' AS architecture, * FROM "sparc".pkg_history;
180 INSERT INTO transactions SELECT 'alpha' AS architecture, * FROM "alpha".transactions;
181 INSERT INTO transactions SELECT 'amd64' AS architecture, * FROM "amd64".transactions;
182 INSERT INTO transactions SELECT 'arm' AS architecture, * FROM "arm".transactions;
183 INSERT INTO transactions SELECT 'armel' AS architecture, * FROM "armel".transactions;
184 INSERT INTO transactions SELECT 'hppa' AS architecture, * FROM "hppa".transactions;
185 INSERT INTO transactions SELECT 'hurd-i386' AS architecture, * FROM "hurd-i386".transactions;
186 INSERT INTO transactions SELECT 'i386' AS architecture, * FROM "i386".transactions;
187 INSERT INTO transactions SELECT 'ia64' AS architecture, * FROM "ia64".transactions;
188 INSERT INTO transactions SELECT 'kfreebsd-amd64' AS architecture, * FROM "kfreebsd-amd64".transactions;
189 INSERT INTO transactions SELECT 'kfreebsd-i386' AS architecture, * FROM "kfreebsd-i386".transactions;
190 INSERT INTO transactions SELECT 'mips' AS architecture, * FROM "mips".transactions;
191 INSERT INTO transactions SELECT 'mipsel' AS architecture, * FROM "mipsel".transactions;
192 INSERT INTO transactions SELECT 'powerpc' AS architecture, * FROM "powerpc".transactions;
193 INSERT INTO transactions SELECT 's390' AS architecture, * FROM "s390".transactions;
194 INSERT INTO transactions SELECT 'sparc' AS architecture, * FROM "sparc".transactions;
196 INSERT INTO users SELECT 'alpha' AS architecture, * FROM "alpha".users;
197 INSERT INTO users SELECT 'amd64' AS architecture, * FROM "amd64".users;
198 INSERT INTO users SELECT 'arm' AS architecture, * FROM "arm".users;
199 INSERT INTO users SELECT 'armel' AS architecture, * FROM "armel".users;
200 INSERT INTO users SELECT 'hppa' AS architecture, * FROM "hppa".users;
201 INSERT INTO users SELECT 'hurd-i386' AS architecture, * FROM "hurd-i386".users;
202 INSERT INTO users SELECT 'i386' AS architecture, * FROM "i386".users;
203 INSERT INTO users SELECT 'ia64' AS architecture, * FROM "ia64".users;
204 INSERT INTO users SELECT 'kfreebsd-amd64' AS architecture, * FROM "kfreebsd-amd64".users;
205 INSERT INTO users SELECT 'kfreebsd-i386' AS architecture, * FROM "kfreebsd-i386".users;
206 INSERT INTO users SELECT 'mips' AS architecture, * FROM "mips".users;
207 INSERT INTO users SELECT 'mipsel' AS architecture, * FROM "mipsel".users;
208 INSERT INTO users SELECT 'powerpc' AS architecture, * FROM "powerpc".users;
209 INSERT INTO users SELECT 's390' AS architecture, * FROM "s390".users;
210 INSERT INTO users SELECT 'sparc' AS architecture, * FROM "sparc".users;
212 -- Copy done, that's fine. Some statistics follow…
214 SELECT COUNT(*) FROM packages;
215 SELECT COUNT(*) FROM pkg_history;
216 SELECT COUNT(*) FROM transactions;
217 SELECT COUNT(*) FROM users;
219 -- Now analyze the new tables to help the query planner.
223 ANALYZE transactions;
226 -- Redefine the global views.
228 DROP VIEW distribution_architectures_statistics;
229 DROP VIEW distribution_architectures;
231 SELECT DISTINCT packages.distribution, packages.architecture
232 INTO distribution_architectures
234 ALTER TABLE distribution_architectures ADD PRIMARY KEY (distribution, architecture);
235 ALTER TABLE distribution_architectures OWNER TO wbadm;
236 REVOKE ALL ON distribution_architectures FROM PUBLIC;
237 GRANT SELECT ON distribution_architectures TO PUBLIC;
240 ADD CONSTRAINT distribution_architecture_fkey
241 FOREIGN KEY (distribution, architecture)
242 REFERENCES distribution_architectures (distribution, architecture);
244 CREATE OR REPLACE VIEW distribution_architectures_statistics AS
245 SELECT DISTINCT packages.distribution, packages.architecture, sum(
247 WHEN packages.state::text = 'Needs-Build'::text THEN 1
249 END) AS needsbuild, sum(
251 WHEN packages.state_change < (now() - '1 day'::interval) AND (packages.state::text = 'Built'::text OR packages.state::text = 'Uploaded'::text) THEN 1
255 GROUP BY packages.distribution, packages.architecture;
256 ALTER TABLE distribution_architectures OWNER TO wbadm;
257 REVOKE ALL ON distribution_architectures FROM PUBLIC;
258 GRANT SELECT ON distribution_architectures TO PUBLIC;
261 CREATE OR REPLACE VIEW lastlog AS
262 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.architecture FROM pkg_history NATURAL JOIN distributions WHERE distributions.public = 't' ORDER BY pkg_history."timestamp" DESC LIMIT 25;
263 ALTER TABLE lastlog OWNER TO wbadm;
264 REVOKE ALL ON lastlog FROM PUBLIC;
265 GRANT SELECT ON lastlog TO PUBLIC;
268 CREATE OR REPLACE VIEW log AS
269 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.architecture FROM pkg_history NATURAL JOIN distributions WHERE distributions.public = 't' ORDER BY pkg_history."timestamp" DESC;
270 ALTER TABLE log OWNER TO wbadm;
271 REVOKE ALL ON log FROM PUBLIC;
272 GRANT SELECT ON log TO PUBLIC;
274 DROP VIEW packages_all;
275 CREATE OR REPLACE VIEW packages_all AS
276 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.architecture FROM packages NATURAL JOIN distributions WHERE distributions.public = 't';
277 ALTER TABLE packages_all OWNER TO wbadm;
278 REVOKE ALL ON packages_all FROM PUBLIC;
279 GRANT SELECT ON packages_all TO PUBLIC;
281 CREATE OR REPLACE VIEW packages_public AS
282 SELECT * FROM packages NATURAL JOIN distributions WHERE distributions.public = 't';
283 ALTER TABLE packages_public OWNER TO wbadm;
284 REVOKE ALL ON packages_public FROM PUBLIC;
285 GRANT SELECT ON packages_public TO PUBLIC;
287 -- Redefine the global functions.
289 CREATE OR REPLACE FUNCTION query_source_package(param_dist character varying, param_srcpkg character varying) RETURNS SETOF record
293 RETURN QUERY SELECT packages.architecture, packages.package, packages.distribution, packages.version::character varying, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM packages_public packages WHERE distribution = param_dist AND package = param_srcpkg;
297 -- Redefine the architecture-specific public views. We need that because
298 -- the version column changed its type.
300 DROP VIEW "alpha_public".packages;
301 DROP VIEW "alpha_public".pkg_history;
302 DROP VIEW "alpha_public".transactions;
303 DROP VIEW "amd64_public".packages;
304 DROP VIEW "amd64_public".pkg_history;
305 DROP VIEW "amd64_public".transactions;
306 DROP VIEW "arm_public".packages;
307 DROP VIEW "arm_public".pkg_history;
308 DROP VIEW "arm_public".transactions;
309 DROP VIEW "armel_public".packages;
310 DROP VIEW "armel_public".pkg_history;
311 DROP VIEW "armel_public".transactions;
312 DROP VIEW "hppa_public".packages;
313 DROP VIEW "hppa_public".pkg_history;
314 DROP VIEW "hppa_public".transactions;
315 DROP VIEW "hurd-i386_public".packages;
316 DROP VIEW "hurd-i386_public".pkg_history;
317 DROP VIEW "hurd-i386_public".transactions;
318 DROP VIEW "i386_public".packages;
319 DROP VIEW "i386_public".pkg_history;
320 DROP VIEW "i386_public".transactions;
321 DROP VIEW "ia64_public".packages;
322 DROP VIEW "ia64_public".pkg_history;
323 DROP VIEW "ia64_public".transactions;
324 DROP VIEW "kfreebsd-amd64_public".packages;
325 DROP VIEW "kfreebsd-amd64_public".pkg_history;
326 DROP VIEW "kfreebsd-amd64_public".transactions;
327 DROP VIEW "kfreebsd-i386_public".packages;
328 DROP VIEW "kfreebsd-i386_public".pkg_history;
329 DROP VIEW "kfreebsd-i386_public".transactions;
330 DROP VIEW "mips_public".packages;
331 DROP VIEW "mips_public".pkg_history;
332 DROP VIEW "mips_public".transactions;
333 DROP VIEW "mipsel_public".packages;
334 DROP VIEW "mipsel_public".pkg_history;
335 DROP VIEW "mipsel_public".transactions;
336 DROP VIEW "powerpc_public".packages;
337 DROP VIEW "powerpc_public".pkg_history;
338 DROP VIEW "powerpc_public".transactions;
339 DROP VIEW "s390_public".packages;
340 DROP VIEW "s390_public".pkg_history;
341 DROP VIEW "s390_public".transactions;
342 DROP VIEW "sparc_public".packages;
343 DROP VIEW "sparc_public".pkg_history;
344 DROP VIEW "sparc_public".transactions;
346 -- Redefine the architecture-specific public views.
348 CREATE OR REPLACE VIEW "alpha_public".packages AS
349 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'alpha';
350 CREATE OR REPLACE VIEW "alpha_public".pkg_history AS
351 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'alpha';
352 CREATE OR REPLACE VIEW "alpha_public".transactions AS
353 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'alpha';
354 CREATE OR REPLACE VIEW "alpha_public".users AS
355 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'alpha';
356 ALTER TABLE "alpha_public".packages OWNER TO wbadm;
357 ALTER TABLE "alpha_public".pkg_history OWNER TO wbadm;
358 ALTER TABLE "alpha_public".transactions OWNER TO wbadm;
359 ALTER TABLE "alpha_public".users OWNER TO wbadm;
360 REVOKE ALL ON "alpha_public".packages FROM PUBLIC;
361 REVOKE ALL ON "alpha_public".pkg_history FROM PUBLIC;
362 REVOKE ALL ON "alpha_public".transactions FROM PUBLIC;
363 REVOKE ALL ON "alpha_public".users FROM PUBLIC;
364 GRANT SELECT ON "alpha_public".packages TO PUBLIC;
365 GRANT SELECT ON "alpha_public".pkg_history TO PUBLIC;
366 GRANT SELECT ON "alpha_public".transactions TO PUBLIC;
367 GRANT SELECT ON "alpha_public".users TO PUBLIC;
368 CREATE OR REPLACE VIEW "amd64_public".packages AS
369 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'amd64';
370 CREATE OR REPLACE VIEW "amd64_public".pkg_history AS
371 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'amd64';
372 CREATE OR REPLACE VIEW "amd64_public".transactions AS
373 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'amd64';
374 CREATE OR REPLACE VIEW "amd64_public".users AS
375 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'amd64';
376 ALTER TABLE "amd64_public".packages OWNER TO wbadm;
377 ALTER TABLE "amd64_public".pkg_history OWNER TO wbadm;
378 ALTER TABLE "amd64_public".transactions OWNER TO wbadm;
379 ALTER TABLE "amd64_public".users OWNER TO wbadm;
380 REVOKE ALL ON "amd64_public".packages FROM PUBLIC;
381 REVOKE ALL ON "amd64_public".pkg_history FROM PUBLIC;
382 REVOKE ALL ON "amd64_public".transactions FROM PUBLIC;
383 REVOKE ALL ON "amd64_public".users FROM PUBLIC;
384 GRANT SELECT ON "amd64_public".packages TO PUBLIC;
385 GRANT SELECT ON "amd64_public".pkg_history TO PUBLIC;
386 GRANT SELECT ON "amd64_public".transactions TO PUBLIC;
387 GRANT SELECT ON "amd64_public".users TO PUBLIC;
388 CREATE OR REPLACE VIEW "arm_public".packages AS
389 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'arm';
390 CREATE OR REPLACE VIEW "arm_public".pkg_history AS
391 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'arm';
392 CREATE OR REPLACE VIEW "arm_public".transactions AS
393 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'arm';
394 CREATE OR REPLACE VIEW "arm_public".users AS
395 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'arm';
396 ALTER TABLE "arm_public".packages OWNER TO wbadm;
397 ALTER TABLE "arm_public".pkg_history OWNER TO wbadm;
398 ALTER TABLE "arm_public".transactions OWNER TO wbadm;
399 ALTER TABLE "arm_public".users OWNER TO wbadm;
400 REVOKE ALL ON "arm_public".packages FROM PUBLIC;
401 REVOKE ALL ON "arm_public".pkg_history FROM PUBLIC;
402 REVOKE ALL ON "arm_public".transactions FROM PUBLIC;
403 REVOKE ALL ON "arm_public".users FROM PUBLIC;
404 GRANT SELECT ON "arm_public".packages TO PUBLIC;
405 GRANT SELECT ON "arm_public".pkg_history TO PUBLIC;
406 GRANT SELECT ON "arm_public".transactions TO PUBLIC;
407 GRANT SELECT ON "arm_public".users TO PUBLIC;
408 CREATE OR REPLACE VIEW "armel_public".packages AS
409 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'armel';
410 CREATE OR REPLACE VIEW "armel_public".pkg_history AS
411 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'armel';
412 CREATE OR REPLACE VIEW "armel_public".transactions AS
413 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'armel';
414 CREATE OR REPLACE VIEW "armel_public".users AS
415 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'armel';
416 ALTER TABLE "armel_public".packages OWNER TO wbadm;
417 ALTER TABLE "armel_public".pkg_history OWNER TO wbadm;
418 ALTER TABLE "armel_public".transactions OWNER TO wbadm;
419 ALTER TABLE "armel_public".users OWNER TO wbadm;
420 REVOKE ALL ON "armel_public".packages FROM PUBLIC;
421 REVOKE ALL ON "armel_public".pkg_history FROM PUBLIC;
422 REVOKE ALL ON "armel_public".transactions FROM PUBLIC;
423 REVOKE ALL ON "armel_public".users FROM PUBLIC;
424 GRANT SELECT ON "armel_public".packages TO PUBLIC;
425 GRANT SELECT ON "armel_public".pkg_history TO PUBLIC;
426 GRANT SELECT ON "armel_public".transactions TO PUBLIC;
427 GRANT SELECT ON "armel_public".users TO PUBLIC;
428 CREATE OR REPLACE VIEW "hppa_public".packages AS
429 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'hppa';
430 CREATE OR REPLACE VIEW "hppa_public".pkg_history AS
431 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'hppa';
432 CREATE OR REPLACE VIEW "hppa_public".transactions AS
433 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'hppa';
434 CREATE OR REPLACE VIEW "hppa_public".users AS
435 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'hppa';
436 ALTER TABLE "hppa_public".packages OWNER TO wbadm;
437 ALTER TABLE "hppa_public".pkg_history OWNER TO wbadm;
438 ALTER TABLE "hppa_public".transactions OWNER TO wbadm;
439 ALTER TABLE "hppa_public".users OWNER TO wbadm;
440 REVOKE ALL ON "hppa_public".packages FROM PUBLIC;
441 REVOKE ALL ON "hppa_public".pkg_history FROM PUBLIC;
442 REVOKE ALL ON "hppa_public".transactions FROM PUBLIC;
443 REVOKE ALL ON "hppa_public".users FROM PUBLIC;
444 GRANT SELECT ON "hppa_public".packages TO PUBLIC;
445 GRANT SELECT ON "hppa_public".pkg_history TO PUBLIC;
446 GRANT SELECT ON "hppa_public".transactions TO PUBLIC;
447 GRANT SELECT ON "hppa_public".users TO PUBLIC;
448 CREATE OR REPLACE VIEW "hurd-i386_public".packages AS
449 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'hurd-i386';
450 CREATE OR REPLACE VIEW "hurd-i386_public".pkg_history AS
451 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'hurd-i386';
452 CREATE OR REPLACE VIEW "hurd-i386_public".transactions AS
453 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'hurd-i386';
454 CREATE OR REPLACE VIEW "hurd-i386_public".users AS
455 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'hurd-i386';
456 ALTER TABLE "hurd-i386_public".packages OWNER TO wbadm;
457 ALTER TABLE "hurd-i386_public".pkg_history OWNER TO wbadm;
458 ALTER TABLE "hurd-i386_public".transactions OWNER TO wbadm;
459 ALTER TABLE "hurd-i386_public".users OWNER TO wbadm;
460 REVOKE ALL ON "hurd-i386_public".packages FROM PUBLIC;
461 REVOKE ALL ON "hurd-i386_public".pkg_history FROM PUBLIC;
462 REVOKE ALL ON "hurd-i386_public".transactions FROM PUBLIC;
463 REVOKE ALL ON "hurd-i386_public".users FROM PUBLIC;
464 GRANT SELECT ON "hurd-i386_public".packages TO PUBLIC;
465 GRANT SELECT ON "hurd-i386_public".pkg_history TO PUBLIC;
466 GRANT SELECT ON "hurd-i386_public".transactions TO PUBLIC;
467 GRANT SELECT ON "hurd-i386_public".users TO PUBLIC;
468 CREATE OR REPLACE VIEW "i386_public".packages AS
469 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'i386';
470 CREATE OR REPLACE VIEW "i386_public".pkg_history AS
471 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'i386';
472 CREATE OR REPLACE VIEW "i386_public".transactions AS
473 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'i386';
474 CREATE OR REPLACE VIEW "i386_public".users AS
475 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'i386';
476 ALTER TABLE "i386_public".packages OWNER TO wbadm;
477 ALTER TABLE "i386_public".pkg_history OWNER TO wbadm;
478 ALTER TABLE "i386_public".transactions OWNER TO wbadm;
479 ALTER TABLE "i386_public".users OWNER TO wbadm;
480 REVOKE ALL ON "i386_public".packages FROM PUBLIC;
481 REVOKE ALL ON "i386_public".pkg_history FROM PUBLIC;
482 REVOKE ALL ON "i386_public".transactions FROM PUBLIC;
483 REVOKE ALL ON "i386_public".users FROM PUBLIC;
484 GRANT SELECT ON "i386_public".packages TO PUBLIC;
485 GRANT SELECT ON "i386_public".pkg_history TO PUBLIC;
486 GRANT SELECT ON "i386_public".transactions TO PUBLIC;
487 GRANT SELECT ON "i386_public".users TO PUBLIC;
488 CREATE OR REPLACE VIEW "ia64_public".packages AS
489 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'ia64';
490 CREATE OR REPLACE VIEW "ia64_public".pkg_history AS
491 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'ia64';
492 CREATE OR REPLACE VIEW "ia64_public".transactions AS
493 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'ia64';
494 CREATE OR REPLACE VIEW "ia64_public".users AS
495 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'ia64';
496 ALTER TABLE "ia64_public".packages OWNER TO wbadm;
497 ALTER TABLE "ia64_public".pkg_history OWNER TO wbadm;
498 ALTER TABLE "ia64_public".transactions OWNER TO wbadm;
499 ALTER TABLE "ia64_public".users OWNER TO wbadm;
500 REVOKE ALL ON "ia64_public".packages FROM PUBLIC;
501 REVOKE ALL ON "ia64_public".pkg_history FROM PUBLIC;
502 REVOKE ALL ON "ia64_public".transactions FROM PUBLIC;
503 REVOKE ALL ON "ia64_public".users FROM PUBLIC;
504 GRANT SELECT ON "ia64_public".packages TO PUBLIC;
505 GRANT SELECT ON "ia64_public".pkg_history TO PUBLIC;
506 GRANT SELECT ON "ia64_public".transactions TO PUBLIC;
507 GRANT SELECT ON "ia64_public".users TO PUBLIC;
508 CREATE OR REPLACE VIEW "kfreebsd-amd64_public".packages AS
509 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'kfreebsd-amd64';
510 CREATE OR REPLACE VIEW "kfreebsd-amd64_public".pkg_history AS
511 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'kfreebsd-amd64';
512 CREATE OR REPLACE VIEW "kfreebsd-amd64_public".transactions AS
513 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'kfreebsd-amd64';
514 CREATE OR REPLACE VIEW "kfreebsd-amd64_public".users AS
515 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'kfreebsd-amd64';
516 ALTER TABLE "kfreebsd-amd64_public".packages OWNER TO wbadm;
517 ALTER TABLE "kfreebsd-amd64_public".pkg_history OWNER TO wbadm;
518 ALTER TABLE "kfreebsd-amd64_public".transactions OWNER TO wbadm;
519 ALTER TABLE "kfreebsd-amd64_public".users OWNER TO wbadm;
520 REVOKE ALL ON "kfreebsd-amd64_public".packages FROM PUBLIC;
521 REVOKE ALL ON "kfreebsd-amd64_public".pkg_history FROM PUBLIC;
522 REVOKE ALL ON "kfreebsd-amd64_public".transactions FROM PUBLIC;
523 REVOKE ALL ON "kfreebsd-amd64_public".users FROM PUBLIC;
524 GRANT SELECT ON "kfreebsd-amd64_public".packages TO PUBLIC;
525 GRANT SELECT ON "kfreebsd-amd64_public".pkg_history TO PUBLIC;
526 GRANT SELECT ON "kfreebsd-amd64_public".transactions TO PUBLIC;
527 GRANT SELECT ON "kfreebsd-amd64_public".users TO PUBLIC;
528 CREATE OR REPLACE VIEW "kfreebsd-i386_public".packages AS
529 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'kfreebsd-i386';
530 CREATE OR REPLACE VIEW "kfreebsd-i386_public".pkg_history AS
531 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'kfreebsd-i386';
532 CREATE OR REPLACE VIEW "kfreebsd-i386_public".transactions AS
533 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'kfreebsd-i386';
534 CREATE OR REPLACE VIEW "kfreebsd-i386_public".users AS
535 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'kfreebsd-i386';
536 ALTER TABLE "kfreebsd-i386_public".packages OWNER TO wbadm;
537 ALTER TABLE "kfreebsd-i386_public".pkg_history OWNER TO wbadm;
538 ALTER TABLE "kfreebsd-i386_public".transactions OWNER TO wbadm;
539 ALTER TABLE "kfreebsd-i386_public".users OWNER TO wbadm;
540 REVOKE ALL ON "kfreebsd-i386_public".packages FROM PUBLIC;
541 REVOKE ALL ON "kfreebsd-i386_public".pkg_history FROM PUBLIC;
542 REVOKE ALL ON "kfreebsd-i386_public".transactions FROM PUBLIC;
543 REVOKE ALL ON "kfreebsd-i386_public".users FROM PUBLIC;
544 GRANT SELECT ON "kfreebsd-i386_public".packages TO PUBLIC;
545 GRANT SELECT ON "kfreebsd-i386_public".pkg_history TO PUBLIC;
546 GRANT SELECT ON "kfreebsd-i386_public".transactions TO PUBLIC;
547 GRANT SELECT ON "kfreebsd-i386_public".users TO PUBLIC;
548 CREATE OR REPLACE VIEW "mips_public".packages AS
549 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'mips';
550 CREATE OR REPLACE VIEW "mips_public".pkg_history AS
551 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'mips';
552 CREATE OR REPLACE VIEW "mips_public".transactions AS
553 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'mips';
554 CREATE OR REPLACE VIEW "mips_public".users AS
555 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'mips';
556 ALTER TABLE "mips_public".packages OWNER TO wbadm;
557 ALTER TABLE "mips_public".pkg_history OWNER TO wbadm;
558 ALTER TABLE "mips_public".transactions OWNER TO wbadm;
559 ALTER TABLE "mips_public".users OWNER TO wbadm;
560 REVOKE ALL ON "mips_public".packages FROM PUBLIC;
561 REVOKE ALL ON "mips_public".pkg_history FROM PUBLIC;
562 REVOKE ALL ON "mips_public".transactions FROM PUBLIC;
563 REVOKE ALL ON "mips_public".users FROM PUBLIC;
564 GRANT SELECT ON "mips_public".packages TO PUBLIC;
565 GRANT SELECT ON "mips_public".pkg_history TO PUBLIC;
566 GRANT SELECT ON "mips_public".transactions TO PUBLIC;
567 GRANT SELECT ON "mips_public".users TO PUBLIC;
568 CREATE OR REPLACE VIEW "mipsel_public".packages AS
569 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'mipsel';
570 CREATE OR REPLACE VIEW "mipsel_public".pkg_history AS
571 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'mipsel';
572 CREATE OR REPLACE VIEW "mipsel_public".transactions AS
573 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'mipsel';
574 CREATE OR REPLACE VIEW "mipsel_public".users AS
575 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'mipsel';
576 ALTER TABLE "mipsel_public".packages OWNER TO wbadm;
577 ALTER TABLE "mipsel_public".pkg_history OWNER TO wbadm;
578 ALTER TABLE "mipsel_public".transactions OWNER TO wbadm;
579 ALTER TABLE "mipsel_public".users OWNER TO wbadm;
580 REVOKE ALL ON "mipsel_public".packages FROM PUBLIC;
581 REVOKE ALL ON "mipsel_public".pkg_history FROM PUBLIC;
582 REVOKE ALL ON "mipsel_public".transactions FROM PUBLIC;
583 REVOKE ALL ON "mipsel_public".users FROM PUBLIC;
584 GRANT SELECT ON "mipsel_public".packages TO PUBLIC;
585 GRANT SELECT ON "mipsel_public".pkg_history TO PUBLIC;
586 GRANT SELECT ON "mipsel_public".transactions TO PUBLIC;
587 GRANT SELECT ON "mipsel_public".users TO PUBLIC;
588 CREATE OR REPLACE VIEW "powerpc_public".packages AS
589 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'powerpc';
590 CREATE OR REPLACE VIEW "powerpc_public".pkg_history AS
591 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'powerpc';
592 CREATE OR REPLACE VIEW "powerpc_public".transactions AS
593 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'powerpc';
594 CREATE OR REPLACE VIEW "powerpc_public".users AS
595 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'powerpc';
596 ALTER TABLE "powerpc_public".packages OWNER TO wbadm;
597 ALTER TABLE "powerpc_public".pkg_history OWNER TO wbadm;
598 ALTER TABLE "powerpc_public".transactions OWNER TO wbadm;
599 ALTER TABLE "powerpc_public".users OWNER TO wbadm;
600 REVOKE ALL ON "powerpc_public".packages FROM PUBLIC;
601 REVOKE ALL ON "powerpc_public".pkg_history FROM PUBLIC;
602 REVOKE ALL ON "powerpc_public".transactions FROM PUBLIC;
603 REVOKE ALL ON "powerpc_public".users FROM PUBLIC;
604 GRANT SELECT ON "powerpc_public".packages TO PUBLIC;
605 GRANT SELECT ON "powerpc_public".pkg_history TO PUBLIC;
606 GRANT SELECT ON "powerpc_public".transactions TO PUBLIC;
607 GRANT SELECT ON "powerpc_public".users TO PUBLIC;
608 CREATE OR REPLACE VIEW "s390_public".packages AS
609 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 's390';
610 CREATE OR REPLACE VIEW "s390_public".pkg_history AS
611 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 's390';
612 CREATE OR REPLACE VIEW "s390_public".transactions AS
613 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 's390';
614 CREATE OR REPLACE VIEW "s390_public".users AS
615 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 's390';
616 ALTER TABLE "s390_public".packages OWNER TO wbadm;
617 ALTER TABLE "s390_public".pkg_history OWNER TO wbadm;
618 ALTER TABLE "s390_public".transactions OWNER TO wbadm;
619 ALTER TABLE "s390_public".users OWNER TO wbadm;
620 REVOKE ALL ON "s390_public".packages FROM PUBLIC;
621 REVOKE ALL ON "s390_public".pkg_history FROM PUBLIC;
622 REVOKE ALL ON "s390_public".transactions FROM PUBLIC;
623 REVOKE ALL ON "s390_public".users FROM PUBLIC;
624 GRANT SELECT ON "s390_public".packages TO PUBLIC;
625 GRANT SELECT ON "s390_public".pkg_history TO PUBLIC;
626 GRANT SELECT ON "s390_public".transactions TO PUBLIC;
627 GRANT SELECT ON "s390_public".users TO PUBLIC;
628 CREATE OR REPLACE VIEW "sparc_public".packages AS
629 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages NATURAL JOIN public.distributions WHERE distributions.public = 't' AND packages.architecture = 'sparc';
630 CREATE OR REPLACE VIEW "sparc_public".pkg_history AS
631 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history NATURAL JOIN public.distributions WHERE distributions.public = 't' AND pkg_history.architecture = 'sparc';
632 CREATE OR REPLACE VIEW "sparc_public".transactions AS
633 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions NATURAL JOIN public.distributions WHERE distributions.public = 't' AND transactions.architecture = 'sparc';
634 CREATE OR REPLACE VIEW "sparc_public".users AS
635 SELECT users.username, users.distribution, users.last_seen FROM public.users NATURAL JOIN public.distributions WHERE distributions.public = 't' AND users.architecture = 'sparc';
636 ALTER TABLE "sparc_public".packages OWNER TO wbadm;
637 ALTER TABLE "sparc_public".pkg_history OWNER TO wbadm;
638 ALTER TABLE "sparc_public".transactions OWNER TO wbadm;
639 ALTER TABLE "sparc_public".users OWNER TO wbadm;
640 REVOKE ALL ON "sparc_public".packages FROM PUBLIC;
641 REVOKE ALL ON "sparc_public".pkg_history FROM PUBLIC;
642 REVOKE ALL ON "sparc_public".transactions FROM PUBLIC;
643 REVOKE ALL ON "sparc_public".users FROM PUBLIC;
644 GRANT SELECT ON "sparc_public".packages TO PUBLIC;
645 GRANT SELECT ON "sparc_public".pkg_history TO PUBLIC;
646 GRANT SELECT ON "sparc_public".transactions TO PUBLIC;
647 GRANT SELECT ON "sparc_public".users TO PUBLIC;
649 -- Drop the architecture-specific tables.
651 DROP TABLE "alpha".packages;
652 DROP TABLE "alpha".pkg_history;
653 DROP TABLE "alpha".transactions;
654 DROP TABLE "alpha".users;
655 DROP TABLE "amd64".packages;
656 DROP TABLE "amd64".pkg_history;
657 DROP TABLE "amd64".transactions;
658 DROP TABLE "amd64".users;
659 DROP TABLE "arm".packages;
660 DROP TABLE "arm".pkg_history;
661 DROP TABLE "arm".transactions;
662 DROP TABLE "arm".users;
663 DROP TABLE "armel".packages;
664 DROP TABLE "armel".pkg_history;
665 DROP TABLE "armel".transactions;
666 DROP TABLE "armel".users;
667 DROP TABLE "hppa".packages;
668 DROP TABLE "hppa".pkg_history;
669 DROP TABLE "hppa".transactions;
670 DROP TABLE "hppa".users;
671 DROP TABLE "hurd-i386".packages;
672 DROP TABLE "hurd-i386".pkg_history;
673 DROP TABLE "hurd-i386".transactions;
674 DROP TABLE "hurd-i386".users;
675 DROP TABLE "i386".packages;
676 DROP TABLE "i386".pkg_history;
677 DROP TABLE "i386".transactions;
678 DROP TABLE "i386".users;
679 DROP TABLE "ia64".packages;
680 DROP TABLE "ia64".pkg_history;
681 DROP TABLE "ia64".transactions;
682 DROP TABLE "ia64".users;
683 DROP TABLE "kfreebsd-amd64".packages;
684 DROP TABLE "kfreebsd-amd64".pkg_history;
685 DROP TABLE "kfreebsd-amd64".transactions;
686 DROP TABLE "kfreebsd-amd64".users;
687 DROP TABLE "kfreebsd-i386".packages;
688 DROP TABLE "kfreebsd-i386".pkg_history;
689 DROP TABLE "kfreebsd-i386".transactions;
690 DROP TABLE "kfreebsd-i386".users;
691 DROP TABLE "mips".packages;
692 DROP TABLE "mips".pkg_history;
693 DROP TABLE "mips".transactions;
694 DROP TABLE "mips".users;
695 DROP TABLE "mipsel".packages;
696 DROP TABLE "mipsel".pkg_history;
697 DROP TABLE "mipsel".transactions;
698 DROP TABLE "mipsel".users;
699 DROP TABLE "powerpc".packages;
700 DROP TABLE "powerpc".pkg_history;
701 DROP TABLE "powerpc".transactions;
702 DROP TABLE "powerpc".users;
703 DROP TABLE "s390".packages;
704 DROP TABLE "s390".pkg_history;
705 DROP TABLE "s390".transactions;
706 DROP TABLE "s390".users;
707 DROP TABLE "sparc".packages;
708 DROP TABLE "sparc".pkg_history;
709 DROP TABLE "sparc".transactions;
710 DROP TABLE "sparc".users;
712 -- Redefine the architecture-specific tables.
714 CREATE OR REPLACE VIEW "alpha".packages AS
715 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
716 FROM public.packages packages
717 WHERE packages.architecture = 'alpha';
718 ALTER TABLE "alpha".packages OWNER TO wbadm;
719 REVOKE ALL ON "alpha".packages FROM PUBLIC;
720 GRANT SELECT ON "alpha".packages TO wb_security;
721 GRANT SELECT, INSERT, UPDATE ON "alpha".packages TO wb_all;
722 CREATE OR REPLACE RULE packages_insert AS
723 ON INSERT TO "alpha".packages DO INSTEAD
724 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
725 VALUES ('alpha', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
726 CREATE OR REPLACE RULE packages_update AS
727 ON UPDATE TO "alpha".packages DO INSTEAD
728 UPDATE public.packages p
729 SET version = new.version,
731 section = new.section,
732 priority = new.priority,
733 installed_version = new.installed_version,
734 previous_state = new.previous_state,
735 state_change = new.state_change,
737 builder = new.builder,
739 old_failed = new.old_failed,
740 binary_nmu_version = new.binary_nmu_version,
741 binary_nmu_changelog = new.binary_nmu_changelog,
742 failed_category = new.failed_category,
743 permbuildpri = new.permbuildpri,
744 buildpri = new.buildpri,
745 depends = new.depends,
747 bd_problem = new.bd_problem,
748 extra_depends = new.extra_depends,
749 extra_conflicts = new.extra_conflicts,
750 build_arch_all = new.build_arch_all
751 WHERE p.architecture = 'alpha' AND
752 p.package = old.package AND
753 p.distribution = old.distribution;
754 CREATE OR REPLACE RULE packages_delete AS
755 ON DELETE TO "alpha".packages DO INSTEAD
756 DELETE FROM public.packages p
757 WHERE p.architecture = 'alpha' AND
758 p.package = old.package AND
759 p.distribution = old.distribution;
761 CREATE OR REPLACE VIEW "amd64".packages AS
762 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
763 FROM public.packages packages
764 WHERE packages.architecture = 'amd64';
765 ALTER TABLE "amd64".packages OWNER TO wbadm;
766 REVOKE ALL ON "amd64".packages FROM PUBLIC;
767 GRANT SELECT ON "amd64".packages TO wb_security;
768 GRANT SELECT, INSERT, UPDATE ON "amd64".packages TO wb_all;
769 CREATE OR REPLACE RULE packages_insert AS
770 ON INSERT TO "amd64".packages DO INSTEAD
771 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
772 VALUES ('amd64', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
773 CREATE OR REPLACE RULE packages_update AS
774 ON UPDATE TO "amd64".packages DO INSTEAD
775 UPDATE public.packages p
776 SET version = new.version,
778 section = new.section,
779 priority = new.priority,
780 installed_version = new.installed_version,
781 previous_state = new.previous_state,
782 state_change = new.state_change,
784 builder = new.builder,
786 old_failed = new.old_failed,
787 binary_nmu_version = new.binary_nmu_version,
788 binary_nmu_changelog = new.binary_nmu_changelog,
789 failed_category = new.failed_category,
790 permbuildpri = new.permbuildpri,
791 buildpri = new.buildpri,
792 depends = new.depends,
794 bd_problem = new.bd_problem,
795 extra_depends = new.extra_depends,
796 extra_conflicts = new.extra_conflicts,
797 build_arch_all = new.build_arch_all
798 WHERE p.architecture = 'amd64' AND
799 p.package = old.package AND
800 p.distribution = old.distribution;
801 CREATE OR REPLACE RULE packages_delete AS
802 ON DELETE TO "amd64".packages DO INSTEAD
803 DELETE FROM public.packages p
804 WHERE p.architecture = 'amd64' AND
805 p.package = old.package AND
806 p.distribution = old.distribution;
808 CREATE OR REPLACE VIEW "arm".packages AS
809 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
810 FROM public.packages packages
811 WHERE packages.architecture = 'arm';
812 ALTER TABLE "arm".packages OWNER TO wbadm;
813 REVOKE ALL ON "arm".packages FROM PUBLIC;
814 GRANT SELECT ON "arm".packages TO wb_security;
815 GRANT SELECT, INSERT, UPDATE ON "arm".packages TO wb_all;
816 CREATE OR REPLACE RULE packages_insert AS
817 ON INSERT TO "arm".packages DO INSTEAD
818 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
819 VALUES ('arm', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
820 CREATE OR REPLACE RULE packages_update AS
821 ON UPDATE TO "arm".packages DO INSTEAD
822 UPDATE public.packages p
823 SET version = new.version,
825 section = new.section,
826 priority = new.priority,
827 installed_version = new.installed_version,
828 previous_state = new.previous_state,
829 state_change = new.state_change,
831 builder = new.builder,
833 old_failed = new.old_failed,
834 binary_nmu_version = new.binary_nmu_version,
835 binary_nmu_changelog = new.binary_nmu_changelog,
836 failed_category = new.failed_category,
837 permbuildpri = new.permbuildpri,
838 buildpri = new.buildpri,
839 depends = new.depends,
841 bd_problem = new.bd_problem,
842 extra_depends = new.extra_depends,
843 extra_conflicts = new.extra_conflicts,
844 build_arch_all = new.build_arch_all
845 WHERE p.architecture = 'arm' AND
846 p.package = old.package AND
847 p.distribution = old.distribution;
848 CREATE OR REPLACE RULE packages_delete AS
849 ON DELETE TO "arm".packages DO INSTEAD
850 DELETE FROM public.packages p
851 WHERE p.architecture = 'arm' AND
852 p.package = old.package AND
853 p.distribution = old.distribution;
855 CREATE OR REPLACE VIEW "armel".packages AS
856 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
857 FROM public.packages packages
858 WHERE packages.architecture = 'armel';
859 ALTER TABLE "armel".packages OWNER TO wbadm;
860 REVOKE ALL ON "armel".packages FROM PUBLIC;
861 GRANT SELECT ON "armel".packages TO wb_security;
862 GRANT SELECT, INSERT, UPDATE ON "armel".packages TO wb_all;
863 CREATE OR REPLACE RULE packages_insert AS
864 ON INSERT TO "armel".packages DO INSTEAD
865 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
866 VALUES ('armel', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
867 CREATE OR REPLACE RULE packages_update AS
868 ON UPDATE TO "armel".packages DO INSTEAD
869 UPDATE public.packages p
870 SET version = new.version,
872 section = new.section,
873 priority = new.priority,
874 installed_version = new.installed_version,
875 previous_state = new.previous_state,
876 state_change = new.state_change,
878 builder = new.builder,
880 old_failed = new.old_failed,
881 binary_nmu_version = new.binary_nmu_version,
882 binary_nmu_changelog = new.binary_nmu_changelog,
883 failed_category = new.failed_category,
884 permbuildpri = new.permbuildpri,
885 buildpri = new.buildpri,
886 depends = new.depends,
888 bd_problem = new.bd_problem,
889 extra_depends = new.extra_depends,
890 extra_conflicts = new.extra_conflicts,
891 build_arch_all = new.build_arch_all
892 WHERE p.architecture = 'armel' AND
893 p.package = old.package AND
894 p.distribution = old.distribution;
895 CREATE OR REPLACE RULE packages_delete AS
896 ON DELETE TO "armel".packages DO INSTEAD
897 DELETE FROM public.packages p
898 WHERE p.architecture = 'armel' AND
899 p.package = old.package AND
900 p.distribution = old.distribution;
902 CREATE OR REPLACE VIEW "hppa".packages AS
903 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
904 FROM public.packages packages
905 WHERE packages.architecture = 'hppa';
906 ALTER TABLE "hppa".packages OWNER TO wbadm;
907 REVOKE ALL ON "hppa".packages FROM PUBLIC;
908 GRANT SELECT ON "hppa".packages TO wb_security;
909 GRANT SELECT, INSERT, UPDATE ON "hppa".packages TO wb_all;
910 CREATE OR REPLACE RULE packages_insert AS
911 ON INSERT TO "hppa".packages DO INSTEAD
912 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
913 VALUES ('hppa', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
914 CREATE OR REPLACE RULE packages_update AS
915 ON UPDATE TO "hppa".packages DO INSTEAD
916 UPDATE public.packages p
917 SET version = new.version,
919 section = new.section,
920 priority = new.priority,
921 installed_version = new.installed_version,
922 previous_state = new.previous_state,
923 state_change = new.state_change,
925 builder = new.builder,
927 old_failed = new.old_failed,
928 binary_nmu_version = new.binary_nmu_version,
929 binary_nmu_changelog = new.binary_nmu_changelog,
930 failed_category = new.failed_category,
931 permbuildpri = new.permbuildpri,
932 buildpri = new.buildpri,
933 depends = new.depends,
935 bd_problem = new.bd_problem,
936 extra_depends = new.extra_depends,
937 extra_conflicts = new.extra_conflicts,
938 build_arch_all = new.build_arch_all
939 WHERE p.architecture = 'hppa' AND
940 p.package = old.package AND
941 p.distribution = old.distribution;
942 CREATE OR REPLACE RULE packages_delete AS
943 ON DELETE TO "hppa".packages DO INSTEAD
944 DELETE FROM public.packages p
945 WHERE p.architecture = 'hppa' AND
946 p.package = old.package AND
947 p.distribution = old.distribution;
949 CREATE OR REPLACE VIEW "hurd-i386".packages AS
950 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
951 FROM public.packages packages
952 WHERE packages.architecture = 'hurd-i386';
953 ALTER TABLE "hurd-i386".packages OWNER TO wbadm;
954 REVOKE ALL ON "hurd-i386".packages FROM PUBLIC;
955 GRANT SELECT ON "hurd-i386".packages TO wb_security;
956 GRANT SELECT, INSERT, UPDATE ON "hurd-i386".packages TO wb_all;
957 CREATE OR REPLACE RULE packages_insert AS
958 ON INSERT TO "hurd-i386".packages DO INSTEAD
959 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
960 VALUES ('hurd-i386', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
961 CREATE OR REPLACE RULE packages_update AS
962 ON UPDATE TO "hurd-i386".packages DO INSTEAD
963 UPDATE public.packages p
964 SET version = new.version,
966 section = new.section,
967 priority = new.priority,
968 installed_version = new.installed_version,
969 previous_state = new.previous_state,
970 state_change = new.state_change,
972 builder = new.builder,
974 old_failed = new.old_failed,
975 binary_nmu_version = new.binary_nmu_version,
976 binary_nmu_changelog = new.binary_nmu_changelog,
977 failed_category = new.failed_category,
978 permbuildpri = new.permbuildpri,
979 buildpri = new.buildpri,
980 depends = new.depends,
982 bd_problem = new.bd_problem,
983 extra_depends = new.extra_depends,
984 extra_conflicts = new.extra_conflicts,
985 build_arch_all = new.build_arch_all
986 WHERE p.architecture = 'hurd-i386' AND
987 p.package = old.package AND
988 p.distribution = old.distribution;
989 CREATE OR REPLACE RULE packages_delete AS
990 ON DELETE TO "hurd-i386".packages DO INSTEAD
991 DELETE FROM public.packages p
992 WHERE p.architecture = 'hurd-i386' AND
993 p.package = old.package AND
994 p.distribution = old.distribution;
996 CREATE OR REPLACE VIEW "i386".packages AS
997 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
998 FROM public.packages packages
999 WHERE packages.architecture = 'i386';
1000 ALTER TABLE "i386".packages OWNER TO wbadm;
1001 REVOKE ALL ON "i386".packages FROM PUBLIC;
1002 GRANT SELECT ON "i386".packages TO wb_security;
1003 GRANT SELECT, INSERT, UPDATE ON "i386".packages TO wb_all;
1004 CREATE OR REPLACE RULE packages_insert AS
1005 ON INSERT TO "i386".packages DO INSTEAD
1006 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
1007 VALUES ('i386', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
1008 CREATE OR REPLACE RULE packages_update AS
1009 ON UPDATE TO "i386".packages DO INSTEAD
1010 UPDATE public.packages p
1011 SET version = new.version,
1013 section = new.section,
1014 priority = new.priority,
1015 installed_version = new.installed_version,
1016 previous_state = new.previous_state,
1017 state_change = new.state_change,
1019 builder = new.builder,
1020 failed = new.failed,
1021 old_failed = new.old_failed,
1022 binary_nmu_version = new.binary_nmu_version,
1023 binary_nmu_changelog = new.binary_nmu_changelog,
1024 failed_category = new.failed_category,
1025 permbuildpri = new.permbuildpri,
1026 buildpri = new.buildpri,
1027 depends = new.depends,
1029 bd_problem = new.bd_problem,
1030 extra_depends = new.extra_depends,
1031 extra_conflicts = new.extra_conflicts,
1032 build_arch_all = new.build_arch_all
1033 WHERE p.architecture = 'i386' AND
1034 p.package = old.package AND
1035 p.distribution = old.distribution;
1036 CREATE OR REPLACE RULE packages_delete AS
1037 ON DELETE TO "i386".packages DO INSTEAD
1038 DELETE FROM public.packages p
1039 WHERE p.architecture = 'i386' AND
1040 p.package = old.package AND
1041 p.distribution = old.distribution;
1043 CREATE OR REPLACE VIEW "ia64".packages AS
1044 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
1045 FROM public.packages packages
1046 WHERE packages.architecture = 'ia64';
1047 ALTER TABLE "ia64".packages OWNER TO wbadm;
1048 REVOKE ALL ON "ia64".packages FROM PUBLIC;
1049 GRANT SELECT ON "ia64".packages TO wb_security;
1050 GRANT SELECT, INSERT, UPDATE ON "ia64".packages TO wb_all;
1051 CREATE OR REPLACE RULE packages_insert AS
1052 ON INSERT TO "ia64".packages DO INSTEAD
1053 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
1054 VALUES ('ia64', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
1055 CREATE OR REPLACE RULE packages_update AS
1056 ON UPDATE TO "ia64".packages DO INSTEAD
1057 UPDATE public.packages p
1058 SET version = new.version,
1060 section = new.section,
1061 priority = new.priority,
1062 installed_version = new.installed_version,
1063 previous_state = new.previous_state,
1064 state_change = new.state_change,
1066 builder = new.builder,
1067 failed = new.failed,
1068 old_failed = new.old_failed,
1069 binary_nmu_version = new.binary_nmu_version,
1070 binary_nmu_changelog = new.binary_nmu_changelog,
1071 failed_category = new.failed_category,
1072 permbuildpri = new.permbuildpri,
1073 buildpri = new.buildpri,
1074 depends = new.depends,
1076 bd_problem = new.bd_problem,
1077 extra_depends = new.extra_depends,
1078 extra_conflicts = new.extra_conflicts,
1079 build_arch_all = new.build_arch_all
1080 WHERE p.architecture = 'ia64' AND
1081 p.package = old.package AND
1082 p.distribution = old.distribution;
1083 CREATE OR REPLACE RULE packages_delete AS
1084 ON DELETE TO "ia64".packages DO INSTEAD
1085 DELETE FROM public.packages p
1086 WHERE p.architecture = 'ia64' AND
1087 p.package = old.package AND
1088 p.distribution = old.distribution;
1090 CREATE OR REPLACE VIEW "kfreebsd-amd64".packages AS
1091 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
1092 FROM public.packages packages
1093 WHERE packages.architecture = 'kfreebsd-amd64';
1094 ALTER TABLE "kfreebsd-amd64".packages OWNER TO wbadm;
1095 REVOKE ALL ON "kfreebsd-amd64".packages FROM PUBLIC;
1096 GRANT SELECT ON "kfreebsd-amd64".packages TO wb_security;
1097 GRANT SELECT, INSERT, UPDATE ON "kfreebsd-amd64".packages TO wb_all;
1098 CREATE OR REPLACE RULE packages_insert AS
1099 ON INSERT TO "kfreebsd-amd64".packages DO INSTEAD
1100 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
1101 VALUES ('kfreebsd-amd64', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
1102 CREATE OR REPLACE RULE packages_update AS
1103 ON UPDATE TO "kfreebsd-amd64".packages DO INSTEAD
1104 UPDATE public.packages p
1105 SET version = new.version,
1107 section = new.section,
1108 priority = new.priority,
1109 installed_version = new.installed_version,
1110 previous_state = new.previous_state,
1111 state_change = new.state_change,
1113 builder = new.builder,
1114 failed = new.failed,
1115 old_failed = new.old_failed,
1116 binary_nmu_version = new.binary_nmu_version,
1117 binary_nmu_changelog = new.binary_nmu_changelog,
1118 failed_category = new.failed_category,
1119 permbuildpri = new.permbuildpri,
1120 buildpri = new.buildpri,
1121 depends = new.depends,
1123 bd_problem = new.bd_problem,
1124 extra_depends = new.extra_depends,
1125 extra_conflicts = new.extra_conflicts,
1126 build_arch_all = new.build_arch_all
1127 WHERE p.architecture = 'kfreebsd-amd64' AND
1128 p.package = old.package AND
1129 p.distribution = old.distribution;
1130 CREATE OR REPLACE RULE packages_delete AS
1131 ON DELETE TO "kfreebsd-amd64".packages DO INSTEAD
1132 DELETE FROM public.packages p
1133 WHERE p.architecture = 'kfreebsd-amd64' AND
1134 p.package = old.package AND
1135 p.distribution = old.distribution;
1137 CREATE OR REPLACE VIEW "kfreebsd-i386".packages AS
1138 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
1139 FROM public.packages packages
1140 WHERE packages.architecture = 'kfreebsd-i386';
1141 ALTER TABLE "kfreebsd-i386".packages OWNER TO wbadm;
1142 REVOKE ALL ON "kfreebsd-i386".packages FROM PUBLIC;
1143 GRANT SELECT ON "kfreebsd-i386".packages TO wb_security;
1144 GRANT SELECT, INSERT, UPDATE ON "kfreebsd-i386".packages TO wb_all;
1145 CREATE OR REPLACE RULE packages_insert AS
1146 ON INSERT TO "kfreebsd-i386".packages DO INSTEAD
1147 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
1148 VALUES ('kfreebsd-i386', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
1149 CREATE OR REPLACE RULE packages_update AS
1150 ON UPDATE TO "kfreebsd-i386".packages DO INSTEAD
1151 UPDATE public.packages p
1152 SET version = new.version,
1154 section = new.section,
1155 priority = new.priority,
1156 installed_version = new.installed_version,
1157 previous_state = new.previous_state,
1158 state_change = new.state_change,
1160 builder = new.builder,
1161 failed = new.failed,
1162 old_failed = new.old_failed,
1163 binary_nmu_version = new.binary_nmu_version,
1164 binary_nmu_changelog = new.binary_nmu_changelog,
1165 failed_category = new.failed_category,
1166 permbuildpri = new.permbuildpri,
1167 buildpri = new.buildpri,
1168 depends = new.depends,
1170 bd_problem = new.bd_problem,
1171 extra_depends = new.extra_depends,
1172 extra_conflicts = new.extra_conflicts,
1173 build_arch_all = new.build_arch_all
1174 WHERE p.architecture = 'kfreebsd-i386' AND
1175 p.package = old.package AND
1176 p.distribution = old.distribution;
1177 CREATE OR REPLACE RULE packages_delete AS
1178 ON DELETE TO "kfreebsd-i386".packages DO INSTEAD
1179 DELETE FROM public.packages p
1180 WHERE p.architecture = 'kfreebsd-i386' AND
1181 p.package = old.package AND
1182 p.distribution = old.distribution;
1184 CREATE OR REPLACE VIEW "mips".packages AS
1185 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
1186 FROM public.packages packages
1187 WHERE packages.architecture = 'mips';
1188 ALTER TABLE "mips".packages OWNER TO wbadm;
1189 REVOKE ALL ON "mips".packages FROM PUBLIC;
1190 GRANT SELECT ON "mips".packages TO wb_security;
1191 GRANT SELECT, INSERT, UPDATE ON "mips".packages TO wb_all;
1192 CREATE OR REPLACE RULE packages_insert AS
1193 ON INSERT TO "mips".packages DO INSTEAD
1194 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
1195 VALUES ('mips', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
1196 CREATE OR REPLACE RULE packages_update AS
1197 ON UPDATE TO "mips".packages DO INSTEAD
1198 UPDATE public.packages p
1199 SET version = new.version,
1201 section = new.section,
1202 priority = new.priority,
1203 installed_version = new.installed_version,
1204 previous_state = new.previous_state,
1205 state_change = new.state_change,
1207 builder = new.builder,
1208 failed = new.failed,
1209 old_failed = new.old_failed,
1210 binary_nmu_version = new.binary_nmu_version,
1211 binary_nmu_changelog = new.binary_nmu_changelog,
1212 failed_category = new.failed_category,
1213 permbuildpri = new.permbuildpri,
1214 buildpri = new.buildpri,
1215 depends = new.depends,
1217 bd_problem = new.bd_problem,
1218 extra_depends = new.extra_depends,
1219 extra_conflicts = new.extra_conflicts,
1220 build_arch_all = new.build_arch_all
1221 WHERE p.architecture = 'mips' AND
1222 p.package = old.package AND
1223 p.distribution = old.distribution;
1224 CREATE OR REPLACE RULE packages_delete AS
1225 ON DELETE TO "mips".packages DO INSTEAD
1226 DELETE FROM public.packages p
1227 WHERE p.architecture = 'mips' AND
1228 p.package = old.package AND
1229 p.distribution = old.distribution;
1231 CREATE OR REPLACE VIEW "mipsel".packages AS
1232 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
1233 FROM public.packages packages
1234 WHERE packages.architecture = 'mipsel';
1235 ALTER TABLE "mipsel".packages OWNER TO wbadm;
1236 REVOKE ALL ON "mipsel".packages FROM PUBLIC;
1237 GRANT SELECT ON "mipsel".packages TO wb_security;
1238 GRANT SELECT, INSERT, UPDATE ON "mipsel".packages TO wb_all;
1239 CREATE OR REPLACE RULE packages_insert AS
1240 ON INSERT TO "mipsel".packages DO INSTEAD
1241 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
1242 VALUES ('mipsel', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
1243 CREATE OR REPLACE RULE packages_update AS
1244 ON UPDATE TO "mipsel".packages DO INSTEAD
1245 UPDATE public.packages p
1246 SET version = new.version,
1248 section = new.section,
1249 priority = new.priority,
1250 installed_version = new.installed_version,
1251 previous_state = new.previous_state,
1252 state_change = new.state_change,
1254 builder = new.builder,
1255 failed = new.failed,
1256 old_failed = new.old_failed,
1257 binary_nmu_version = new.binary_nmu_version,
1258 binary_nmu_changelog = new.binary_nmu_changelog,
1259 failed_category = new.failed_category,
1260 permbuildpri = new.permbuildpri,
1261 buildpri = new.buildpri,
1262 depends = new.depends,
1264 bd_problem = new.bd_problem,
1265 extra_depends = new.extra_depends,
1266 extra_conflicts = new.extra_conflicts,
1267 build_arch_all = new.build_arch_all
1268 WHERE p.architecture = 'mipsel' AND
1269 p.package = old.package AND
1270 p.distribution = old.distribution;
1271 CREATE OR REPLACE RULE packages_delete AS
1272 ON DELETE TO "mipsel".packages DO INSTEAD
1273 DELETE FROM public.packages p
1274 WHERE p.architecture = 'mipsel' AND
1275 p.package = old.package AND
1276 p.distribution = old.distribution;
1278 CREATE OR REPLACE VIEW "powerpc".packages AS
1279 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
1280 FROM public.packages packages
1281 WHERE packages.architecture = 'powerpc';
1282 ALTER TABLE "powerpc".packages OWNER TO wbadm;
1283 REVOKE ALL ON "powerpc".packages FROM PUBLIC;
1284 GRANT SELECT ON "powerpc".packages TO wb_security;
1285 GRANT SELECT, INSERT, UPDATE ON "powerpc".packages TO wb_all;
1286 CREATE OR REPLACE RULE packages_insert AS
1287 ON INSERT TO "powerpc".packages DO INSTEAD
1288 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
1289 VALUES ('powerpc', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
1290 CREATE OR REPLACE RULE packages_update AS
1291 ON UPDATE TO "powerpc".packages DO INSTEAD
1292 UPDATE public.packages p
1293 SET version = new.version,
1295 section = new.section,
1296 priority = new.priority,
1297 installed_version = new.installed_version,
1298 previous_state = new.previous_state,
1299 state_change = new.state_change,
1301 builder = new.builder,
1302 failed = new.failed,
1303 old_failed = new.old_failed,
1304 binary_nmu_version = new.binary_nmu_version,
1305 binary_nmu_changelog = new.binary_nmu_changelog,
1306 failed_category = new.failed_category,
1307 permbuildpri = new.permbuildpri,
1308 buildpri = new.buildpri,
1309 depends = new.depends,
1311 bd_problem = new.bd_problem,
1312 extra_depends = new.extra_depends,
1313 extra_conflicts = new.extra_conflicts,
1314 build_arch_all = new.build_arch_all
1315 WHERE p.architecture = 'powerpc' AND
1316 p.package = old.package AND
1317 p.distribution = old.distribution;
1318 CREATE OR REPLACE RULE packages_delete AS
1319 ON DELETE TO "powerpc".packages DO INSTEAD
1320 DELETE FROM public.packages p
1321 WHERE p.architecture = 'powerpc' AND
1322 p.package = old.package AND
1323 p.distribution = old.distribution;
1325 CREATE OR REPLACE VIEW "s390".packages AS
1326 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
1327 FROM public.packages packages
1328 WHERE packages.architecture = 's390';
1329 ALTER TABLE "s390".packages OWNER TO wbadm;
1330 REVOKE ALL ON "s390".packages FROM PUBLIC;
1331 GRANT SELECT ON "s390".packages TO wb_security;
1332 GRANT SELECT, INSERT, UPDATE ON "s390".packages TO wb_all;
1333 CREATE OR REPLACE RULE packages_insert AS
1334 ON INSERT TO "s390".packages DO INSTEAD
1335 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
1336 VALUES ('s390', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
1337 CREATE OR REPLACE RULE packages_update AS
1338 ON UPDATE TO "s390".packages DO INSTEAD
1339 UPDATE public.packages p
1340 SET version = new.version,
1342 section = new.section,
1343 priority = new.priority,
1344 installed_version = new.installed_version,
1345 previous_state = new.previous_state,
1346 state_change = new.state_change,
1348 builder = new.builder,
1349 failed = new.failed,
1350 old_failed = new.old_failed,
1351 binary_nmu_version = new.binary_nmu_version,
1352 binary_nmu_changelog = new.binary_nmu_changelog,
1353 failed_category = new.failed_category,
1354 permbuildpri = new.permbuildpri,
1355 buildpri = new.buildpri,
1356 depends = new.depends,
1358 bd_problem = new.bd_problem,
1359 extra_depends = new.extra_depends,
1360 extra_conflicts = new.extra_conflicts,
1361 build_arch_all = new.build_arch_all
1362 WHERE p.architecture = 's390' AND
1363 p.package = old.package AND
1364 p.distribution = old.distribution;
1365 CREATE OR REPLACE RULE packages_delete AS
1366 ON DELETE TO "s390".packages DO INSTEAD
1367 DELETE FROM public.packages p
1368 WHERE p.architecture = 's390' AND
1369 p.package = old.package AND
1370 p.distribution = old.distribution;
1372 CREATE OR REPLACE VIEW "sparc".packages AS
1373 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all
1374 FROM public.packages packages
1375 WHERE packages.architecture = 'sparc';
1376 ALTER TABLE "sparc".packages OWNER TO wbadm;
1377 REVOKE ALL ON "sparc".packages FROM PUBLIC;
1378 GRANT SELECT ON "sparc".packages TO wb_security;
1379 GRANT SELECT, INSERT, UPDATE ON "sparc".packages TO wb_all;
1380 CREATE OR REPLACE RULE packages_insert AS
1381 ON INSERT TO "sparc".packages DO INSTEAD
1382 INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all)
1383 VALUES ('sparc', new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
1384 CREATE OR REPLACE RULE packages_update AS
1385 ON UPDATE TO "sparc".packages DO INSTEAD
1386 UPDATE public.packages p
1387 SET version = new.version,
1389 section = new.section,
1390 priority = new.priority,
1391 installed_version = new.installed_version,
1392 previous_state = new.previous_state,
1393 state_change = new.state_change,
1395 builder = new.builder,
1396 failed = new.failed,
1397 old_failed = new.old_failed,
1398 binary_nmu_version = new.binary_nmu_version,
1399 binary_nmu_changelog = new.binary_nmu_changelog,
1400 failed_category = new.failed_category,
1401 permbuildpri = new.permbuildpri,
1402 buildpri = new.buildpri,
1403 depends = new.depends,
1405 bd_problem = new.bd_problem,
1406 extra_depends = new.extra_depends,
1407 extra_conflicts = new.extra_conflicts,
1408 build_arch_all = new.build_arch_all
1409 WHERE p.architecture = 'sparc' AND
1410 p.package = old.package AND
1411 p.distribution = old.distribution;
1412 CREATE OR REPLACE RULE packages_delete AS
1413 ON DELETE TO "sparc".packages DO INSTEAD
1414 DELETE FROM public.packages p
1415 WHERE p.architecture = 'sparc' AND
1416 p.package = old.package AND
1417 p.distribution = old.distribution;
1420 --# SELECT rel, priority, state_change, permbuildpri, section, buildpri, failed, state, binary_nmu_changelog, bd_problem, version, package, distribution, installed_version, notes, builder, old_failed, previous_state, binary_nmu_version, depends, extract(days from date_trunc('days', now() - state_change)) as state_days, floor(extract(epoch from now()) - extract(epoch from state_change)) as state_time, (SELECT max(build_time) FROM pkg_history WHERE pkg_history.package = packages.package AND pkg_history.distribution = packages.distribution AND result = 'successful' AND pkg_history.architecture = 'amd64') AS successtime, (SELECT max(build_time) FROM pkg_history WHERE pkg_history.package = packages.package AND pkg_history.distribution = packages.distribution AND pkg_history.architecture = 'amd64') AS anytime, extra_depends, extra_conflicts, build_arch_all FROM packages WHERE package = 'gobby' AND distribution = 'sid';
1422 --# SELECT rel, priority, state_change, permbuildpri, section, buildpri, failed, state, binary_nmu_changelog, bd_problem, version, package, distribution, installed_version, notes, builder, old_failed, previous_state, binary_nmu_version, depends, extract(days from date_trunc('days', now() - state_change)) as state_days, floor(extract(epoch from now()) - extract(epoch from state_change)) as state_time, successtime.build_time as successtime, anytime.build_time as anytime, extra_depends, extra_conflicts FROM packages left join ( select distinct on (package, distribution) build_time, package, distribution from pkg_history where architecture = 'amd64' and result = 'successful' order by package, distribution, timestamp ) as successtime using (package, distribution) left join ( select distinct on (package, distribution) build_time, package, distribution from pkg_history where architecture = 'amd64' order by package, distribution, timestamp desc ) as anytime using (package, distribution) WHERE TRUE AND ( architecture = 'amd64' ) AND ( distribution = 'sid' ) AND upper(state) = 'NEEDS-BUILD';
1424 --# SELECT rel, priority, state_change, permbuildpri, section, buildpri, failed, state, binary_nmu_changelog, bd_problem, version, package, distribution, installed_version, notes, builder, old_failed, previous_state, binary_nmu_version, depends, extract(days from date_trunc('days', now() - state_change)) as state_days, floor(extract(epoch from now()) - extract(epoch from state_change)) as state_time, successtime.build_time as successtime, anytime.build_time as anytime, extra_depends, extra_conflicts FROM packages left join ( select distinct on (package, distribution) build_time, package, distribution from pkg_history where architecture = 'amd64' and result = 'successful' order by package, distribution, timestamp ) as successtime using (package, distribution) left join ( select distinct on (package, distribution) build_time, package, distribution from pkg_history where architecture = 'amd64' order by package, distribution, timestamp desc ) as anytime using (package, distribution) WHERE TRUE AND ( architecture = 'amd64' ) AND ( distribution = 'sid' ) AND upper(state) = 'INSTALLED';
1426 --SELECT rel, priority, state_change, permbuildpri, section, buildpri, failed, state, binary_nmu_changelog, bd_problem, version, package, distribution, installed_version, notes, builder, old_failed, previous_state, binary_nmu_version, depends, extract(days from date_trunc('days', now() - state_change)) as state_days, floor(extract(epoch from now()) - extract(epoch from state_change)) as state_time, (SELECT max(build_time) FROM "amd64_public".pkg_history WHERE pkg_history.package = packages.package AND pkg_history.distribution = packages.distribution AND result = 'successful') AS successtime, (SELECT max(build_time) FROM "amd64_public".pkg_history WHERE pkg_history.package = packages.package AND pkg_history.distribution = packages.distribution ) AS anytime, extra_depends, extra_conflicts, build_arch_all FROM "amd64_public".packages WHERE package = 'gobby' AND distribution = 'sid';
1427 --SELECT rel, priority, state_change, permbuildpri, section, buildpri, failed, state, binary_nmu_changelog, bd_problem, version, package, distribution, installed_version, notes, builder, old_failed, previous_state, binary_nmu_version, depends, extract(days from date_trunc('days', now() - state_change)) as state_days, floor(extract(epoch from now()) - extract(epoch from state_change)) as state_time, successtime.build_time as successtime, anytime.build_time as anytime, extra_depends, extra_conflicts FROM "amd64_public".packages left join ( select distinct on (package, distribution) build_time, package, distribution from "amd64_public".pkg_history where result = 'successful' order by package, distribution, timestamp ) as successtime using (package, distribution) left join ( select distinct on (package, distribution) build_time, package, distribution from "amd64_public".pkg_history order by package, distribution, timestamp desc ) as anytime using (package, distribution) WHERE TRUE AND ( distribution = 'sid' ) AND upper(state) = 'NEEDS-BUILD';
1428 --SELECT rel, priority, state_change, permbuildpri, section, buildpri, failed, state, binary_nmu_changelog, bd_problem, version, package, distribution, installed_version, notes, builder, old_failed, previous_state, binary_nmu_version, depends, extract(days from date_trunc('days', now() - state_change)) as state_days, floor(extract(epoch from now()) - extract(epoch from state_change)) as state_time, successtime.build_time as successtime, anytime.build_time as anytime, extra_depends, extra_conflicts FROM "amd64_public".packages left join ( select distinct on (package, distribution) build_time, package, distribution from "amd64_public".pkg_history where result = 'successful' order by package, distribution, timestamp ) as successtime using (package, distribution) left join ( select distinct on (package, distribution) build_time, package, distribution from "amd64_public".pkg_history order by package, distribution, timestamp desc ) as anytime using (package, distribution) WHERE TRUE AND ( distribution = 'sid' ) AND upper(state) = 'INSTALLED';
1429 CREATE OR REPLACE VIEW "alpha".pkg_history AS
1430 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1431 FROM public.pkg_history
1432 WHERE pkg_history.architecture = 'alpha';
1433 ALTER TABLE "alpha".pkg_history OWNER TO wbadm;
1434 REVOKE ALL ON "alpha".pkg_history FROM PUBLIC;
1435 GRANT SELECT ON "alpha".pkg_history TO wb_security;
1436 GRANT SELECT, INSERT, UPDATE ON "alpha".pkg_history TO wb_all;
1437 CREATE OR REPLACE RULE pkg_history_insert AS
1438 ON INSERT TO "alpha".pkg_history DO INSTEAD
1439 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1440 VALUES ('alpha', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1441 CREATE OR REPLACE RULE pkg_history_update AS
1442 ON UPDATE TO "alpha".pkg_history DO INSTEAD
1443 UPDATE public.pkg_history p
1444 SET result = new.result,
1445 build_time = new.build_time,
1446 disk_space = new.disk_space
1447 WHERE p.architecture = 'alpha' AND
1448 p.package = old.package AND
1449 p.distribution = old.distribution AND
1450 p.version = old.version AND
1451 p.timestamp = old.timestamp;
1452 CREATE OR REPLACE RULE pkg_history_delete AS
1453 ON DELETE TO "alpha".pkg_history DO INSTEAD
1454 DELETE FROM public.pkg_history p
1455 WHERE p.architecture = 'alpha' AND
1456 p.package = old.package AND
1457 p.distribution = old.distribution AND
1458 p.version = old.version AND
1459 p.timestamp = old.timestamp;
1461 CREATE OR REPLACE VIEW "amd64".pkg_history AS
1462 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1463 FROM public.pkg_history
1464 WHERE pkg_history.architecture = 'amd64';
1465 ALTER TABLE "amd64".pkg_history OWNER TO wbadm;
1466 REVOKE ALL ON "amd64".pkg_history FROM PUBLIC;
1467 GRANT SELECT ON "amd64".pkg_history TO wb_security;
1468 GRANT SELECT, INSERT, UPDATE ON "amd64".pkg_history TO wb_all;
1469 CREATE OR REPLACE RULE pkg_history_insert AS
1470 ON INSERT TO "amd64".pkg_history DO INSTEAD
1471 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1472 VALUES ('amd64', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1473 CREATE OR REPLACE RULE pkg_history_update AS
1474 ON UPDATE TO "amd64".pkg_history DO INSTEAD
1475 UPDATE public.pkg_history p
1476 SET result = new.result,
1477 build_time = new.build_time,
1478 disk_space = new.disk_space
1479 WHERE p.architecture = 'amd64' AND
1480 p.package = old.package AND
1481 p.distribution = old.distribution AND
1482 p.version = old.version AND
1483 p.timestamp = old.timestamp;
1484 CREATE OR REPLACE RULE pkg_history_delete AS
1485 ON DELETE TO "amd64".pkg_history DO INSTEAD
1486 DELETE FROM public.pkg_history p
1487 WHERE p.architecture = 'amd64' AND
1488 p.package = old.package AND
1489 p.distribution = old.distribution AND
1490 p.version = old.version AND
1491 p.timestamp = old.timestamp;
1493 CREATE OR REPLACE VIEW "arm".pkg_history AS
1494 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1495 FROM public.pkg_history
1496 WHERE pkg_history.architecture = 'arm';
1497 ALTER TABLE "arm".pkg_history OWNER TO wbadm;
1498 REVOKE ALL ON "arm".pkg_history FROM PUBLIC;
1499 GRANT SELECT ON "arm".pkg_history TO wb_security;
1500 GRANT SELECT, INSERT, UPDATE ON "arm".pkg_history TO wb_all;
1501 CREATE OR REPLACE RULE pkg_history_insert AS
1502 ON INSERT TO "arm".pkg_history DO INSTEAD
1503 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1504 VALUES ('arm', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1505 CREATE OR REPLACE RULE pkg_history_update AS
1506 ON UPDATE TO "arm".pkg_history DO INSTEAD
1507 UPDATE public.pkg_history p
1508 SET result = new.result,
1509 build_time = new.build_time,
1510 disk_space = new.disk_space
1511 WHERE p.architecture = 'arm' AND
1512 p.package = old.package AND
1513 p.distribution = old.distribution AND
1514 p.version = old.version AND
1515 p.timestamp = old.timestamp;
1516 CREATE OR REPLACE RULE pkg_history_delete AS
1517 ON DELETE TO "arm".pkg_history DO INSTEAD
1518 DELETE FROM public.pkg_history p
1519 WHERE p.architecture = 'arm' AND
1520 p.package = old.package AND
1521 p.distribution = old.distribution AND
1522 p.version = old.version AND
1523 p.timestamp = old.timestamp;
1525 CREATE OR REPLACE VIEW "armel".pkg_history AS
1526 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1527 FROM public.pkg_history
1528 WHERE pkg_history.architecture = 'armel';
1529 ALTER TABLE "armel".pkg_history OWNER TO wbadm;
1530 REVOKE ALL ON "armel".pkg_history FROM PUBLIC;
1531 GRANT SELECT ON "armel".pkg_history TO wb_security;
1532 GRANT SELECT, INSERT, UPDATE ON "armel".pkg_history TO wb_all;
1533 CREATE OR REPLACE RULE pkg_history_insert AS
1534 ON INSERT TO "armel".pkg_history DO INSTEAD
1535 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1536 VALUES ('armel', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1537 CREATE OR REPLACE RULE pkg_history_update AS
1538 ON UPDATE TO "armel".pkg_history DO INSTEAD
1539 UPDATE public.pkg_history p
1540 SET result = new.result,
1541 build_time = new.build_time,
1542 disk_space = new.disk_space
1543 WHERE p.architecture = 'armel' AND
1544 p.package = old.package AND
1545 p.distribution = old.distribution AND
1546 p.version = old.version AND
1547 p.timestamp = old.timestamp;
1548 CREATE OR REPLACE RULE pkg_history_delete AS
1549 ON DELETE TO "armel".pkg_history DO INSTEAD
1550 DELETE FROM public.pkg_history p
1551 WHERE p.architecture = 'armel' AND
1552 p.package = old.package AND
1553 p.distribution = old.distribution AND
1554 p.version = old.version AND
1555 p.timestamp = old.timestamp;
1557 CREATE OR REPLACE VIEW "hppa".pkg_history AS
1558 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1559 FROM public.pkg_history
1560 WHERE pkg_history.architecture = 'hppa';
1561 ALTER TABLE "hppa".pkg_history OWNER TO wbadm;
1562 REVOKE ALL ON "hppa".pkg_history FROM PUBLIC;
1563 GRANT SELECT ON "hppa".pkg_history TO wb_security;
1564 GRANT SELECT, INSERT, UPDATE ON "hppa".pkg_history TO wb_all;
1565 CREATE OR REPLACE RULE pkg_history_insert AS
1566 ON INSERT TO "hppa".pkg_history DO INSTEAD
1567 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1568 VALUES ('hppa', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1569 CREATE OR REPLACE RULE pkg_history_update AS
1570 ON UPDATE TO "hppa".pkg_history DO INSTEAD
1571 UPDATE public.pkg_history p
1572 SET result = new.result,
1573 build_time = new.build_time,
1574 disk_space = new.disk_space
1575 WHERE p.architecture = 'hppa' AND
1576 p.package = old.package AND
1577 p.distribution = old.distribution AND
1578 p.version = old.version AND
1579 p.timestamp = old.timestamp;
1580 CREATE OR REPLACE RULE pkg_history_delete AS
1581 ON DELETE TO "hppa".pkg_history DO INSTEAD
1582 DELETE FROM public.pkg_history p
1583 WHERE p.architecture = 'hppa' AND
1584 p.package = old.package AND
1585 p.distribution = old.distribution AND
1586 p.version = old.version AND
1587 p.timestamp = old.timestamp;
1589 CREATE OR REPLACE VIEW "hurd-i386".pkg_history AS
1590 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1591 FROM public.pkg_history
1592 WHERE pkg_history.architecture = 'hurd-i386';
1593 ALTER TABLE "hurd-i386".pkg_history OWNER TO wbadm;
1594 REVOKE ALL ON "hurd-i386".pkg_history FROM PUBLIC;
1595 GRANT SELECT ON "hurd-i386".pkg_history TO wb_security;
1596 GRANT SELECT, INSERT, UPDATE ON "hurd-i386".pkg_history TO wb_all;
1597 CREATE OR REPLACE RULE pkg_history_insert AS
1598 ON INSERT TO "hurd-i386".pkg_history DO INSTEAD
1599 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1600 VALUES ('hurd-i386', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1601 CREATE OR REPLACE RULE pkg_history_update AS
1602 ON UPDATE TO "hurd-i386".pkg_history DO INSTEAD
1603 UPDATE public.pkg_history p
1604 SET result = new.result,
1605 build_time = new.build_time,
1606 disk_space = new.disk_space
1607 WHERE p.architecture = 'hurd-i386' AND
1608 p.package = old.package AND
1609 p.distribution = old.distribution AND
1610 p.version = old.version AND
1611 p.timestamp = old.timestamp;
1612 CREATE OR REPLACE RULE pkg_history_delete AS
1613 ON DELETE TO "hurd-i386".pkg_history DO INSTEAD
1614 DELETE FROM public.pkg_history p
1615 WHERE p.architecture = 'hurd-i386' AND
1616 p.package = old.package AND
1617 p.distribution = old.distribution AND
1618 p.version = old.version AND
1619 p.timestamp = old.timestamp;
1621 CREATE OR REPLACE VIEW "i386".pkg_history AS
1622 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1623 FROM public.pkg_history
1624 WHERE pkg_history.architecture = 'i386';
1625 ALTER TABLE "i386".pkg_history OWNER TO wbadm;
1626 REVOKE ALL ON "i386".pkg_history FROM PUBLIC;
1627 GRANT SELECT ON "i386".pkg_history TO wb_security;
1628 GRANT SELECT, INSERT, UPDATE ON "i386".pkg_history TO wb_all;
1629 CREATE OR REPLACE RULE pkg_history_insert AS
1630 ON INSERT TO "i386".pkg_history DO INSTEAD
1631 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1632 VALUES ('i386', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1633 CREATE OR REPLACE RULE pkg_history_update AS
1634 ON UPDATE TO "i386".pkg_history DO INSTEAD
1635 UPDATE public.pkg_history p
1636 SET result = new.result,
1637 build_time = new.build_time,
1638 disk_space = new.disk_space
1639 WHERE p.architecture = 'i386' AND
1640 p.package = old.package AND
1641 p.distribution = old.distribution AND
1642 p.version = old.version AND
1643 p.timestamp = old.timestamp;
1644 CREATE OR REPLACE RULE pkg_history_delete AS
1645 ON DELETE TO "i386".pkg_history DO INSTEAD
1646 DELETE FROM public.pkg_history p
1647 WHERE p.architecture = 'i386' AND
1648 p.package = old.package AND
1649 p.distribution = old.distribution AND
1650 p.version = old.version AND
1651 p.timestamp = old.timestamp;
1653 CREATE OR REPLACE VIEW "ia64".pkg_history AS
1654 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1655 FROM public.pkg_history
1656 WHERE pkg_history.architecture = 'ia64';
1657 ALTER TABLE "ia64".pkg_history OWNER TO wbadm;
1658 REVOKE ALL ON "ia64".pkg_history FROM PUBLIC;
1659 GRANT SELECT ON "ia64".pkg_history TO wb_security;
1660 GRANT SELECT, INSERT, UPDATE ON "ia64".pkg_history TO wb_all;
1661 CREATE OR REPLACE RULE pkg_history_insert AS
1662 ON INSERT TO "ia64".pkg_history DO INSTEAD
1663 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1664 VALUES ('ia64', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1665 CREATE OR REPLACE RULE pkg_history_update AS
1666 ON UPDATE TO "ia64".pkg_history DO INSTEAD
1667 UPDATE public.pkg_history p
1668 SET result = new.result,
1669 build_time = new.build_time,
1670 disk_space = new.disk_space
1671 WHERE p.architecture = 'ia64' AND
1672 p.package = old.package AND
1673 p.distribution = old.distribution AND
1674 p.version = old.version AND
1675 p.timestamp = old.timestamp;
1676 CREATE OR REPLACE RULE pkg_history_delete AS
1677 ON DELETE TO "ia64".pkg_history DO INSTEAD
1678 DELETE FROM public.pkg_history p
1679 WHERE p.architecture = 'ia64' AND
1680 p.package = old.package AND
1681 p.distribution = old.distribution AND
1682 p.version = old.version AND
1683 p.timestamp = old.timestamp;
1685 CREATE OR REPLACE VIEW "kfreebsd-amd64".pkg_history AS
1686 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1687 FROM public.pkg_history
1688 WHERE pkg_history.architecture = 'kfreebsd-amd64';
1689 ALTER TABLE "kfreebsd-amd64".pkg_history OWNER TO wbadm;
1690 REVOKE ALL ON "kfreebsd-amd64".pkg_history FROM PUBLIC;
1691 GRANT SELECT ON "kfreebsd-amd64".pkg_history TO wb_security;
1692 GRANT SELECT, INSERT, UPDATE ON "kfreebsd-amd64".pkg_history TO wb_all;
1693 CREATE OR REPLACE RULE pkg_history_insert AS
1694 ON INSERT TO "kfreebsd-amd64".pkg_history DO INSTEAD
1695 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1696 VALUES ('kfreebsd-amd64', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1697 CREATE OR REPLACE RULE pkg_history_update AS
1698 ON UPDATE TO "kfreebsd-amd64".pkg_history DO INSTEAD
1699 UPDATE public.pkg_history p
1700 SET result = new.result,
1701 build_time = new.build_time,
1702 disk_space = new.disk_space
1703 WHERE p.architecture = 'kfreebsd-amd64' AND
1704 p.package = old.package AND
1705 p.distribution = old.distribution AND
1706 p.version = old.version AND
1707 p.timestamp = old.timestamp;
1708 CREATE OR REPLACE RULE pkg_history_delete AS
1709 ON DELETE TO "kfreebsd-amd64".pkg_history DO INSTEAD
1710 DELETE FROM public.pkg_history p
1711 WHERE p.architecture = 'kfreebsd-amd64' AND
1712 p.package = old.package AND
1713 p.distribution = old.distribution AND
1714 p.version = old.version AND
1715 p.timestamp = old.timestamp;
1717 CREATE OR REPLACE VIEW "kfreebsd-i386".pkg_history AS
1718 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1719 FROM public.pkg_history
1720 WHERE pkg_history.architecture = 'kfreebsd-i386';
1721 ALTER TABLE "kfreebsd-i386".pkg_history OWNER TO wbadm;
1722 REVOKE ALL ON "kfreebsd-i386".pkg_history FROM PUBLIC;
1723 GRANT SELECT ON "kfreebsd-i386".pkg_history TO wb_security;
1724 GRANT SELECT, INSERT, UPDATE ON "kfreebsd-i386".pkg_history TO wb_all;
1725 CREATE OR REPLACE RULE pkg_history_insert AS
1726 ON INSERT TO "kfreebsd-i386".pkg_history DO INSTEAD
1727 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1728 VALUES ('kfreebsd-i386', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1729 CREATE OR REPLACE RULE pkg_history_update AS
1730 ON UPDATE TO "kfreebsd-i386".pkg_history DO INSTEAD
1731 UPDATE public.pkg_history p
1732 SET result = new.result,
1733 build_time = new.build_time,
1734 disk_space = new.disk_space
1735 WHERE p.architecture = 'kfreebsd-i386' AND
1736 p.package = old.package AND
1737 p.distribution = old.distribution AND
1738 p.version = old.version AND
1739 p.timestamp = old.timestamp;
1740 CREATE OR REPLACE RULE pkg_history_delete AS
1741 ON DELETE TO "kfreebsd-i386".pkg_history DO INSTEAD
1742 DELETE FROM public.pkg_history p
1743 WHERE p.architecture = 'kfreebsd-i386' AND
1744 p.package = old.package AND
1745 p.distribution = old.distribution AND
1746 p.version = old.version AND
1747 p.timestamp = old.timestamp;
1749 CREATE OR REPLACE VIEW "mips".pkg_history AS
1750 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1751 FROM public.pkg_history
1752 WHERE pkg_history.architecture = 'mips';
1753 ALTER TABLE "mips".pkg_history OWNER TO wbadm;
1754 REVOKE ALL ON "mips".pkg_history FROM PUBLIC;
1755 GRANT SELECT ON "mips".pkg_history TO wb_security;
1756 GRANT SELECT, INSERT, UPDATE ON "mips".pkg_history TO wb_all;
1757 CREATE OR REPLACE RULE pkg_history_insert AS
1758 ON INSERT TO "mips".pkg_history DO INSTEAD
1759 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1760 VALUES ('mips', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1761 CREATE OR REPLACE RULE pkg_history_update AS
1762 ON UPDATE TO "mips".pkg_history DO INSTEAD
1763 UPDATE public.pkg_history p
1764 SET result = new.result,
1765 build_time = new.build_time,
1766 disk_space = new.disk_space
1767 WHERE p.architecture = 'mips' AND
1768 p.package = old.package AND
1769 p.distribution = old.distribution AND
1770 p.version = old.version AND
1771 p.timestamp = old.timestamp;
1772 CREATE OR REPLACE RULE pkg_history_delete AS
1773 ON DELETE TO "mips".pkg_history DO INSTEAD
1774 DELETE FROM public.pkg_history p
1775 WHERE p.architecture = 'mips' AND
1776 p.package = old.package AND
1777 p.distribution = old.distribution AND
1778 p.version = old.version AND
1779 p.timestamp = old.timestamp;
1781 CREATE OR REPLACE VIEW "mipsel".pkg_history AS
1782 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1783 FROM public.pkg_history
1784 WHERE pkg_history.architecture = 'mipsel';
1785 ALTER TABLE "mipsel".pkg_history OWNER TO wbadm;
1786 REVOKE ALL ON "mipsel".pkg_history FROM PUBLIC;
1787 GRANT SELECT ON "mipsel".pkg_history TO wb_security;
1788 GRANT SELECT, INSERT, UPDATE ON "mipsel".pkg_history TO wb_all;
1789 CREATE OR REPLACE RULE pkg_history_insert AS
1790 ON INSERT TO "mipsel".pkg_history DO INSTEAD
1791 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1792 VALUES ('mipsel', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1793 CREATE OR REPLACE RULE pkg_history_update AS
1794 ON UPDATE TO "mipsel".pkg_history DO INSTEAD
1795 UPDATE public.pkg_history p
1796 SET result = new.result,
1797 build_time = new.build_time,
1798 disk_space = new.disk_space
1799 WHERE p.architecture = 'mipsel' AND
1800 p.package = old.package AND
1801 p.distribution = old.distribution AND
1802 p.version = old.version AND
1803 p.timestamp = old.timestamp;
1804 CREATE OR REPLACE RULE pkg_history_delete AS
1805 ON DELETE TO "mipsel".pkg_history DO INSTEAD
1806 DELETE FROM public.pkg_history p
1807 WHERE p.architecture = 'mipsel' AND
1808 p.package = old.package AND
1809 p.distribution = old.distribution AND
1810 p.version = old.version AND
1811 p.timestamp = old.timestamp;
1813 CREATE OR REPLACE VIEW "powerpc".pkg_history AS
1814 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1815 FROM public.pkg_history
1816 WHERE pkg_history.architecture = 'powerpc';
1817 ALTER TABLE "powerpc".pkg_history OWNER TO wbadm;
1818 REVOKE ALL ON "powerpc".pkg_history FROM PUBLIC;
1819 GRANT SELECT ON "powerpc".pkg_history TO wb_security;
1820 GRANT SELECT, INSERT, UPDATE ON "powerpc".pkg_history TO wb_all;
1821 CREATE OR REPLACE RULE pkg_history_insert AS
1822 ON INSERT TO "powerpc".pkg_history DO INSTEAD
1823 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1824 VALUES ('powerpc', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1825 CREATE OR REPLACE RULE pkg_history_update AS
1826 ON UPDATE TO "powerpc".pkg_history DO INSTEAD
1827 UPDATE public.pkg_history p
1828 SET result = new.result,
1829 build_time = new.build_time,
1830 disk_space = new.disk_space
1831 WHERE p.architecture = 'powerpc' AND
1832 p.package = old.package AND
1833 p.distribution = old.distribution AND
1834 p.version = old.version AND
1835 p.timestamp = old.timestamp;
1836 CREATE OR REPLACE RULE pkg_history_delete AS
1837 ON DELETE TO "powerpc".pkg_history DO INSTEAD
1838 DELETE FROM public.pkg_history p
1839 WHERE p.architecture = 'powerpc' AND
1840 p.package = old.package AND
1841 p.distribution = old.distribution AND
1842 p.version = old.version AND
1843 p.timestamp = old.timestamp;
1845 CREATE OR REPLACE VIEW "s390".pkg_history AS
1846 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1847 FROM public.pkg_history
1848 WHERE pkg_history.architecture = 's390';
1849 ALTER TABLE "s390".pkg_history OWNER TO wbadm;
1850 REVOKE ALL ON "s390".pkg_history FROM PUBLIC;
1851 GRANT SELECT ON "s390".pkg_history TO wb_security;
1852 GRANT SELECT, INSERT, UPDATE ON "s390".pkg_history TO wb_all;
1853 CREATE OR REPLACE RULE pkg_history_insert AS
1854 ON INSERT TO "s390".pkg_history DO INSTEAD
1855 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1856 VALUES ('s390', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1857 CREATE OR REPLACE RULE pkg_history_update AS
1858 ON UPDATE TO "s390".pkg_history DO INSTEAD
1859 UPDATE public.pkg_history p
1860 SET result = new.result,
1861 build_time = new.build_time,
1862 disk_space = new.disk_space
1863 WHERE p.architecture = 's390' AND
1864 p.package = old.package AND
1865 p.distribution = old.distribution AND
1866 p.version = old.version AND
1867 p.timestamp = old.timestamp;
1868 CREATE OR REPLACE RULE pkg_history_delete AS
1869 ON DELETE TO "s390".pkg_history DO INSTEAD
1870 DELETE FROM public.pkg_history p
1871 WHERE p.architecture = 's390' AND
1872 p.package = old.package AND
1873 p.distribution = old.distribution AND
1874 p.version = old.version AND
1875 p.timestamp = old.timestamp;
1877 CREATE OR REPLACE VIEW "sparc".pkg_history AS
1878 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
1879 FROM public.pkg_history
1880 WHERE pkg_history.architecture = 'sparc';
1881 ALTER TABLE "sparc".pkg_history OWNER TO wbadm;
1882 REVOKE ALL ON "sparc".pkg_history FROM PUBLIC;
1883 GRANT SELECT ON "sparc".pkg_history TO wb_security;
1884 GRANT SELECT, INSERT, UPDATE ON "sparc".pkg_history TO wb_all;
1885 CREATE OR REPLACE RULE pkg_history_insert AS
1886 ON INSERT TO "sparc".pkg_history DO INSTEAD
1887 INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space)
1888 VALUES ('sparc', new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
1889 CREATE OR REPLACE RULE pkg_history_update AS
1890 ON UPDATE TO "sparc".pkg_history DO INSTEAD
1891 UPDATE public.pkg_history p
1892 SET result = new.result,
1893 build_time = new.build_time,
1894 disk_space = new.disk_space
1895 WHERE p.architecture = 'sparc' AND
1896 p.package = old.package AND
1897 p.distribution = old.distribution AND
1898 p.version = old.version AND
1899 p.timestamp = old.timestamp;
1900 CREATE OR REPLACE RULE pkg_history_delete AS
1901 ON DELETE TO "sparc".pkg_history DO INSTEAD
1902 DELETE FROM public.pkg_history p
1903 WHERE p.architecture = 'sparc' AND
1904 p.package = old.package AND
1905 p.distribution = old.distribution AND
1906 p.version = old.version AND
1907 p.timestamp = old.timestamp;
1909 CREATE OR REPLACE VIEW "alpha".users AS
1910 SELECT users.username, users.distribution, users.last_seen
1912 WHERE users.architecture = 'alpha';
1913 ALTER TABLE "alpha".users OWNER TO wbadm;
1914 REVOKE ALL ON "alpha".users FROM PUBLIC;
1915 GRANT SELECT ON "alpha".users TO wb_security;
1916 GRANT SELECT, INSERT, UPDATE ON "alpha".users TO wb_all;
1917 CREATE OR REPLACE RULE users_insert AS
1918 ON INSERT TO "alpha".users DO INSTEAD
1919 INSERT INTO public.users (architecture, username, distribution, last_seen)
1920 VALUES ('alpha', new.username, new.distribution, new.last_seen);
1921 CREATE OR REPLACE RULE users_update AS
1922 ON UPDATE TO "alpha".users DO INSTEAD
1923 UPDATE public.users u
1924 SET last_seen = new.last_seen
1925 WHERE u.architecture = 'alpha' AND
1926 u.distribution = old.distribution AND
1927 u.username = old.username;
1928 CREATE OR REPLACE RULE users_delete AS
1929 ON DELETE TO "alpha".users DO INSTEAD
1930 DELETE FROM public.users u
1931 WHERE u.architecture = 'alpha' AND
1932 u.distribution = old.distribution AND
1933 u.username = old.username;
1935 CREATE OR REPLACE VIEW "amd64".users AS
1936 SELECT users.username, users.distribution, users.last_seen
1938 WHERE users.architecture = 'amd64';
1939 ALTER TABLE "amd64".users OWNER TO wbadm;
1940 REVOKE ALL ON "amd64".users FROM PUBLIC;
1941 GRANT SELECT ON "amd64".users TO wb_security;
1942 GRANT SELECT, INSERT, UPDATE ON "amd64".users TO wb_all;
1943 CREATE OR REPLACE RULE users_insert AS
1944 ON INSERT TO "amd64".users DO INSTEAD
1945 INSERT INTO public.users (architecture, username, distribution, last_seen)
1946 VALUES ('amd64', new.username, new.distribution, new.last_seen);
1947 CREATE OR REPLACE RULE users_update AS
1948 ON UPDATE TO "amd64".users DO INSTEAD
1949 UPDATE public.users u
1950 SET last_seen = new.last_seen
1951 WHERE u.architecture = 'amd64' AND
1952 u.distribution = old.distribution AND
1953 u.username = old.username;
1954 CREATE OR REPLACE RULE users_delete AS
1955 ON DELETE TO "amd64".users DO INSTEAD
1956 DELETE FROM public.users u
1957 WHERE u.architecture = 'amd64' AND
1958 u.distribution = old.distribution AND
1959 u.username = old.username;
1961 CREATE OR REPLACE VIEW "arm".users AS
1962 SELECT users.username, users.distribution, users.last_seen
1964 WHERE users.architecture = 'arm';
1965 ALTER TABLE "arm".users OWNER TO wbadm;
1966 REVOKE ALL ON "arm".users FROM PUBLIC;
1967 GRANT SELECT ON "arm".users TO wb_security;
1968 GRANT SELECT, INSERT, UPDATE ON "arm".users TO wb_all;
1969 CREATE OR REPLACE RULE users_insert AS
1970 ON INSERT TO "arm".users DO INSTEAD
1971 INSERT INTO public.users (architecture, username, distribution, last_seen)
1972 VALUES ('arm', new.username, new.distribution, new.last_seen);
1973 CREATE OR REPLACE RULE users_update AS
1974 ON UPDATE TO "arm".users DO INSTEAD
1975 UPDATE public.users u
1976 SET last_seen = new.last_seen
1977 WHERE u.architecture = 'arm' AND
1978 u.distribution = old.distribution AND
1979 u.username = old.username;
1980 CREATE OR REPLACE RULE users_delete AS
1981 ON DELETE TO "arm".users DO INSTEAD
1982 DELETE FROM public.users u
1983 WHERE u.architecture = 'arm' AND
1984 u.distribution = old.distribution AND
1985 u.username = old.username;
1987 CREATE OR REPLACE VIEW "armel".users AS
1988 SELECT users.username, users.distribution, users.last_seen
1990 WHERE users.architecture = 'armel';
1991 ALTER TABLE "armel".users OWNER TO wbadm;
1992 REVOKE ALL ON "armel".users FROM PUBLIC;
1993 GRANT SELECT ON "armel".users TO wb_security;
1994 GRANT SELECT, INSERT, UPDATE ON "armel".users TO wb_all;
1995 CREATE OR REPLACE RULE users_insert AS
1996 ON INSERT TO "armel".users DO INSTEAD
1997 INSERT INTO public.users (architecture, username, distribution, last_seen)
1998 VALUES ('armel', new.username, new.distribution, new.last_seen);
1999 CREATE OR REPLACE RULE users_update AS
2000 ON UPDATE TO "armel".users DO INSTEAD
2001 UPDATE public.users u
2002 SET last_seen = new.last_seen
2003 WHERE u.architecture = 'armel' AND
2004 u.distribution = old.distribution AND
2005 u.username = old.username;
2006 CREATE OR REPLACE RULE users_delete AS
2007 ON DELETE TO "armel".users DO INSTEAD
2008 DELETE FROM public.users u
2009 WHERE u.architecture = 'armel' AND
2010 u.distribution = old.distribution AND
2011 u.username = old.username;
2013 CREATE OR REPLACE VIEW "hppa".users AS
2014 SELECT users.username, users.distribution, users.last_seen
2016 WHERE users.architecture = 'hppa';
2017 ALTER TABLE "hppa".users OWNER TO wbadm;
2018 REVOKE ALL ON "hppa".users FROM PUBLIC;
2019 GRANT SELECT ON "hppa".users TO wb_security;
2020 GRANT SELECT, INSERT, UPDATE ON "hppa".users TO wb_all;
2021 CREATE OR REPLACE RULE users_insert AS
2022 ON INSERT TO "hppa".users DO INSTEAD
2023 INSERT INTO public.users (architecture, username, distribution, last_seen)
2024 VALUES ('hppa', new.username, new.distribution, new.last_seen);
2025 CREATE OR REPLACE RULE users_update AS
2026 ON UPDATE TO "hppa".users DO INSTEAD
2027 UPDATE public.users u
2028 SET last_seen = new.last_seen
2029 WHERE u.architecture = 'hppa' AND
2030 u.distribution = old.distribution AND
2031 u.username = old.username;
2032 CREATE OR REPLACE RULE users_delete AS
2033 ON DELETE TO "hppa".users DO INSTEAD
2034 DELETE FROM public.users u
2035 WHERE u.architecture = 'hppa' AND
2036 u.distribution = old.distribution AND
2037 u.username = old.username;
2039 CREATE OR REPLACE VIEW "hurd-i386".users AS
2040 SELECT users.username, users.distribution, users.last_seen
2042 WHERE users.architecture = 'hurd-i386';
2043 ALTER TABLE "hurd-i386".users OWNER TO wbadm;
2044 REVOKE ALL ON "hurd-i386".users FROM PUBLIC;
2045 GRANT SELECT ON "hurd-i386".users TO wb_security;
2046 GRANT SELECT, INSERT, UPDATE ON "hurd-i386".users TO wb_all;
2047 CREATE OR REPLACE RULE users_insert AS
2048 ON INSERT TO "hurd-i386".users DO INSTEAD
2049 INSERT INTO public.users (architecture, username, distribution, last_seen)
2050 VALUES ('hurd-i386', new.username, new.distribution, new.last_seen);
2051 CREATE OR REPLACE RULE users_update AS
2052 ON UPDATE TO "hurd-i386".users DO INSTEAD
2053 UPDATE public.users u
2054 SET last_seen = new.last_seen
2055 WHERE u.architecture = 'hurd-i386' AND
2056 u.distribution = old.distribution AND
2057 u.username = old.username;
2058 CREATE OR REPLACE RULE users_delete AS
2059 ON DELETE TO "hurd-i386".users DO INSTEAD
2060 DELETE FROM public.users u
2061 WHERE u.architecture = 'hurd-i386' AND
2062 u.distribution = old.distribution AND
2063 u.username = old.username;
2065 CREATE OR REPLACE VIEW "i386".users AS
2066 SELECT users.username, users.distribution, users.last_seen
2068 WHERE users.architecture = 'i386';
2069 ALTER TABLE "i386".users OWNER TO wbadm;
2070 REVOKE ALL ON "i386".users FROM PUBLIC;
2071 GRANT SELECT ON "i386".users TO wb_security;
2072 GRANT SELECT, INSERT, UPDATE ON "i386".users TO wb_all;
2073 CREATE OR REPLACE RULE users_insert AS
2074 ON INSERT TO "i386".users DO INSTEAD
2075 INSERT INTO public.users (architecture, username, distribution, last_seen)
2076 VALUES ('i386', new.username, new.distribution, new.last_seen);
2077 CREATE OR REPLACE RULE users_update AS
2078 ON UPDATE TO "i386".users DO INSTEAD
2079 UPDATE public.users u
2080 SET last_seen = new.last_seen
2081 WHERE u.architecture = 'i386' AND
2082 u.distribution = old.distribution AND
2083 u.username = old.username;
2084 CREATE OR REPLACE RULE users_delete AS
2085 ON DELETE TO "i386".users DO INSTEAD
2086 DELETE FROM public.users u
2087 WHERE u.architecture = 'i386' AND
2088 u.distribution = old.distribution AND
2089 u.username = old.username;
2091 CREATE OR REPLACE VIEW "ia64".users AS
2092 SELECT users.username, users.distribution, users.last_seen
2094 WHERE users.architecture = 'ia64';
2095 ALTER TABLE "ia64".users OWNER TO wbadm;
2096 REVOKE ALL ON "ia64".users FROM PUBLIC;
2097 GRANT SELECT ON "ia64".users TO wb_security;
2098 GRANT SELECT, INSERT, UPDATE ON "ia64".users TO wb_all;
2099 CREATE OR REPLACE RULE users_insert AS
2100 ON INSERT TO "ia64".users DO INSTEAD
2101 INSERT INTO public.users (architecture, username, distribution, last_seen)
2102 VALUES ('ia64', new.username, new.distribution, new.last_seen);
2103 CREATE OR REPLACE RULE users_update AS
2104 ON UPDATE TO "ia64".users DO INSTEAD
2105 UPDATE public.users u
2106 SET last_seen = new.last_seen
2107 WHERE u.architecture = 'ia64' AND
2108 u.distribution = old.distribution AND
2109 u.username = old.username;
2110 CREATE OR REPLACE RULE users_delete AS
2111 ON DELETE TO "ia64".users DO INSTEAD
2112 DELETE FROM public.users u
2113 WHERE u.architecture = 'ia64' AND
2114 u.distribution = old.distribution AND
2115 u.username = old.username;
2117 CREATE OR REPLACE VIEW "kfreebsd-amd64".users AS
2118 SELECT users.username, users.distribution, users.last_seen
2120 WHERE users.architecture = 'kfreebsd-amd64';
2121 ALTER TABLE "kfreebsd-amd64".users OWNER TO wbadm;
2122 REVOKE ALL ON "kfreebsd-amd64".users FROM PUBLIC;
2123 GRANT SELECT ON "kfreebsd-amd64".users TO wb_security;
2124 GRANT SELECT, INSERT, UPDATE ON "kfreebsd-amd64".users TO wb_all;
2125 CREATE OR REPLACE RULE users_insert AS
2126 ON INSERT TO "kfreebsd-amd64".users DO INSTEAD
2127 INSERT INTO public.users (architecture, username, distribution, last_seen)
2128 VALUES ('kfreebsd-amd64', new.username, new.distribution, new.last_seen);
2129 CREATE OR REPLACE RULE users_update AS
2130 ON UPDATE TO "kfreebsd-amd64".users DO INSTEAD
2131 UPDATE public.users u
2132 SET last_seen = new.last_seen
2133 WHERE u.architecture = 'kfreebsd-amd64' AND
2134 u.distribution = old.distribution AND
2135 u.username = old.username;
2136 CREATE OR REPLACE RULE users_delete AS
2137 ON DELETE TO "kfreebsd-amd64".users DO INSTEAD
2138 DELETE FROM public.users u
2139 WHERE u.architecture = 'kfreebsd-amd64' AND
2140 u.distribution = old.distribution AND
2141 u.username = old.username;
2143 CREATE OR REPLACE VIEW "kfreebsd-i386".users AS
2144 SELECT users.username, users.distribution, users.last_seen
2146 WHERE users.architecture = 'kfreebsd-i386';
2147 ALTER TABLE "kfreebsd-i386".users OWNER TO wbadm;
2148 REVOKE ALL ON "kfreebsd-i386".users FROM PUBLIC;
2149 GRANT SELECT ON "kfreebsd-i386".users TO wb_security;
2150 GRANT SELECT, INSERT, UPDATE ON "kfreebsd-i386".users TO wb_all;
2151 CREATE OR REPLACE RULE users_insert AS
2152 ON INSERT TO "kfreebsd-i386".users DO INSTEAD
2153 INSERT INTO public.users (architecture, username, distribution, last_seen)
2154 VALUES ('kfreebsd-i386', new.username, new.distribution, new.last_seen);
2155 CREATE OR REPLACE RULE users_update AS
2156 ON UPDATE TO "kfreebsd-i386".users DO INSTEAD
2157 UPDATE public.users u
2158 SET last_seen = new.last_seen
2159 WHERE u.architecture = 'kfreebsd-i386' AND
2160 u.distribution = old.distribution AND
2161 u.username = old.username;
2162 CREATE OR REPLACE RULE users_delete AS
2163 ON DELETE TO "kfreebsd-i386".users DO INSTEAD
2164 DELETE FROM public.users u
2165 WHERE u.architecture = 'kfreebsd-i386' AND
2166 u.distribution = old.distribution AND
2167 u.username = old.username;
2169 CREATE OR REPLACE VIEW "mips".users AS
2170 SELECT users.username, users.distribution, users.last_seen
2172 WHERE users.architecture = 'mips';
2173 ALTER TABLE "mips".users OWNER TO wbadm;
2174 REVOKE ALL ON "mips".users FROM PUBLIC;
2175 GRANT SELECT ON "mips".users TO wb_security;
2176 GRANT SELECT, INSERT, UPDATE ON "mips".users TO wb_all;
2177 CREATE OR REPLACE RULE users_insert AS
2178 ON INSERT TO "mips".users DO INSTEAD
2179 INSERT INTO public.users (architecture, username, distribution, last_seen)
2180 VALUES ('mips', new.username, new.distribution, new.last_seen);
2181 CREATE OR REPLACE RULE users_update AS
2182 ON UPDATE TO "mips".users DO INSTEAD
2183 UPDATE public.users u
2184 SET last_seen = new.last_seen
2185 WHERE u.architecture = 'mips' AND
2186 u.distribution = old.distribution AND
2187 u.username = old.username;
2188 CREATE OR REPLACE RULE users_delete AS
2189 ON DELETE TO "mips".users DO INSTEAD
2190 DELETE FROM public.users u
2191 WHERE u.architecture = 'mips' AND
2192 u.distribution = old.distribution AND
2193 u.username = old.username;
2195 CREATE OR REPLACE VIEW "mipsel".users AS
2196 SELECT users.username, users.distribution, users.last_seen
2198 WHERE users.architecture = 'mipsel';
2199 ALTER TABLE "mipsel".users OWNER TO wbadm;
2200 REVOKE ALL ON "mipsel".users FROM PUBLIC;
2201 GRANT SELECT ON "mipsel".users TO wb_security;
2202 GRANT SELECT, INSERT, UPDATE ON "mipsel".users TO wb_all;
2203 CREATE OR REPLACE RULE users_insert AS
2204 ON INSERT TO "mipsel".users DO INSTEAD
2205 INSERT INTO public.users (architecture, username, distribution, last_seen)
2206 VALUES ('mipsel', new.username, new.distribution, new.last_seen);
2207 CREATE OR REPLACE RULE users_update AS
2208 ON UPDATE TO "mipsel".users DO INSTEAD
2209 UPDATE public.users u
2210 SET last_seen = new.last_seen
2211 WHERE u.architecture = 'mipsel' AND
2212 u.distribution = old.distribution AND
2213 u.username = old.username;
2214 CREATE OR REPLACE RULE users_delete AS
2215 ON DELETE TO "mipsel".users DO INSTEAD
2216 DELETE FROM public.users u
2217 WHERE u.architecture = 'mipsel' AND
2218 u.distribution = old.distribution AND
2219 u.username = old.username;
2221 CREATE OR REPLACE VIEW "powerpc".users AS
2222 SELECT users.username, users.distribution, users.last_seen
2224 WHERE users.architecture = 'powerpc';
2225 ALTER TABLE "powerpc".users OWNER TO wbadm;
2226 REVOKE ALL ON "powerpc".users FROM PUBLIC;
2227 GRANT SELECT ON "powerpc".users TO wb_security;
2228 GRANT SELECT, INSERT, UPDATE ON "powerpc".users TO wb_all;
2229 CREATE OR REPLACE RULE users_insert AS
2230 ON INSERT TO "powerpc".users DO INSTEAD
2231 INSERT INTO public.users (architecture, username, distribution, last_seen)
2232 VALUES ('powerpc', new.username, new.distribution, new.last_seen);
2233 CREATE OR REPLACE RULE users_update AS
2234 ON UPDATE TO "powerpc".users DO INSTEAD
2235 UPDATE public.users u
2236 SET last_seen = new.last_seen
2237 WHERE u.architecture = 'powerpc' AND
2238 u.distribution = old.distribution AND
2239 u.username = old.username;
2240 CREATE OR REPLACE RULE users_delete AS
2241 ON DELETE TO "powerpc".users DO INSTEAD
2242 DELETE FROM public.users u
2243 WHERE u.architecture = 'powerpc' AND
2244 u.distribution = old.distribution AND
2245 u.username = old.username;
2247 CREATE OR REPLACE VIEW "s390".users AS
2248 SELECT users.username, users.distribution, users.last_seen
2250 WHERE users.architecture = 's390';
2251 ALTER TABLE "s390".users OWNER TO wbadm;
2252 REVOKE ALL ON "s390".users FROM PUBLIC;
2253 GRANT SELECT ON "s390".users TO wb_security;
2254 GRANT SELECT, INSERT, UPDATE ON "s390".users TO wb_all;
2255 CREATE OR REPLACE RULE users_insert AS
2256 ON INSERT TO "s390".users DO INSTEAD
2257 INSERT INTO public.users (architecture, username, distribution, last_seen)
2258 VALUES ('s390', new.username, new.distribution, new.last_seen);
2259 CREATE OR REPLACE RULE users_update AS
2260 ON UPDATE TO "s390".users DO INSTEAD
2261 UPDATE public.users u
2262 SET last_seen = new.last_seen
2263 WHERE u.architecture = 's390' AND
2264 u.distribution = old.distribution AND
2265 u.username = old.username;
2266 CREATE OR REPLACE RULE users_delete AS
2267 ON DELETE TO "s390".users DO INSTEAD
2268 DELETE FROM public.users u
2269 WHERE u.architecture = 's390' AND
2270 u.distribution = old.distribution AND
2271 u.username = old.username;
2273 CREATE OR REPLACE VIEW "sparc".users AS
2274 SELECT users.username, users.distribution, users.last_seen
2276 WHERE users.architecture = 'sparc';
2277 ALTER TABLE "sparc".users OWNER TO wbadm;
2278 REVOKE ALL ON "sparc".users FROM PUBLIC;
2279 GRANT SELECT ON "sparc".users TO wb_security;
2280 GRANT SELECT, INSERT, UPDATE ON "sparc".users TO wb_all;
2281 CREATE OR REPLACE RULE users_insert AS
2282 ON INSERT TO "sparc".users DO INSTEAD
2283 INSERT INTO public.users (architecture, username, distribution, last_seen)
2284 VALUES ('sparc', new.username, new.distribution, new.last_seen);
2285 CREATE OR REPLACE RULE users_update AS
2286 ON UPDATE TO "sparc".users DO INSTEAD
2287 UPDATE public.users u
2288 SET last_seen = new.last_seen
2289 WHERE u.architecture = 'sparc' AND
2290 u.distribution = old.distribution AND
2291 u.username = old.username;
2292 CREATE OR REPLACE RULE users_delete AS
2293 ON DELETE TO "sparc".users DO INSTEAD
2294 DELETE FROM public.users u
2295 WHERE u.architecture = 'sparc' AND
2296 u.distribution = old.distribution AND
2297 u.username = old.username;
2299 CREATE OR REPLACE VIEW "alpha".transactions AS
2300 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2301 FROM public.transactions
2302 WHERE architecture = 'alpha';
2303 ALTER TABLE "alpha".transactions OWNER TO wbadm;
2304 REVOKE ALL ON "alpha".transactions FROM PUBLIC;
2305 GRANT SELECT ON "alpha".transactions TO wb_security;
2306 GRANT SELECT, INSERT ON "alpha".transactions TO wb_all;
2307 CREATE OR REPLACE RULE transactions_insert AS
2308 ON INSERT TO "alpha".transactions DO INSTEAD
2309 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2310 VALUES ('alpha', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2312 CREATE OR REPLACE VIEW "amd64".transactions AS
2313 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2314 FROM public.transactions
2315 WHERE architecture = 'amd64';
2316 ALTER TABLE "amd64".transactions OWNER TO wbadm;
2317 REVOKE ALL ON "amd64".transactions FROM PUBLIC;
2318 GRANT SELECT ON "amd64".transactions TO wb_security;
2319 GRANT SELECT, INSERT ON "amd64".transactions TO wb_all;
2320 CREATE OR REPLACE RULE transactions_insert AS
2321 ON INSERT TO "amd64".transactions DO INSTEAD
2322 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2323 VALUES ('amd64', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2325 CREATE OR REPLACE VIEW "arm".transactions AS
2326 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2327 FROM public.transactions
2328 WHERE architecture = 'arm';
2329 ALTER TABLE "arm".transactions OWNER TO wbadm;
2330 REVOKE ALL ON "arm".transactions FROM PUBLIC;
2331 GRANT SELECT ON "arm".transactions TO wb_security;
2332 GRANT SELECT, INSERT ON "arm".transactions TO wb_all;
2333 CREATE OR REPLACE RULE transactions_insert AS
2334 ON INSERT TO "arm".transactions DO INSTEAD
2335 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2336 VALUES ('arm', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2338 CREATE OR REPLACE VIEW "armel".transactions AS
2339 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2340 FROM public.transactions
2341 WHERE architecture = 'armel';
2342 ALTER TABLE "armel".transactions OWNER TO wbadm;
2343 REVOKE ALL ON "armel".transactions FROM PUBLIC;
2344 GRANT SELECT ON "armel".transactions TO wb_security;
2345 GRANT SELECT, INSERT ON "armel".transactions TO wb_all;
2346 CREATE OR REPLACE RULE transactions_insert AS
2347 ON INSERT TO "armel".transactions DO INSTEAD
2348 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2349 VALUES ('armel', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2351 CREATE OR REPLACE VIEW "hppa".transactions AS
2352 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2353 FROM public.transactions
2354 WHERE architecture = 'hppa';
2355 ALTER TABLE "hppa".transactions OWNER TO wbadm;
2356 REVOKE ALL ON "hppa".transactions FROM PUBLIC;
2357 GRANT SELECT ON "hppa".transactions TO wb_security;
2358 GRANT SELECT, INSERT ON "hppa".transactions TO wb_all;
2359 CREATE OR REPLACE RULE transactions_insert AS
2360 ON INSERT TO "hppa".transactions DO INSTEAD
2361 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2362 VALUES ('hppa', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2364 CREATE OR REPLACE VIEW "hurd-i386".transactions AS
2365 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2366 FROM public.transactions
2367 WHERE architecture = 'hurd-i386';
2368 ALTER TABLE "hurd-i386".transactions OWNER TO wbadm;
2369 REVOKE ALL ON "hurd-i386".transactions FROM PUBLIC;
2370 GRANT SELECT ON "hurd-i386".transactions TO wb_security;
2371 GRANT SELECT, INSERT ON "hurd-i386".transactions TO wb_all;
2372 CREATE OR REPLACE RULE transactions_insert AS
2373 ON INSERT TO "hurd-i386".transactions DO INSTEAD
2374 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2375 VALUES ('hurd-i386', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2377 CREATE OR REPLACE VIEW "i386".transactions AS
2378 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2379 FROM public.transactions
2380 WHERE architecture = 'i386';
2381 ALTER TABLE "i386".transactions OWNER TO wbadm;
2382 REVOKE ALL ON "i386".transactions FROM PUBLIC;
2383 GRANT SELECT ON "i386".transactions TO wb_security;
2384 GRANT SELECT, INSERT ON "i386".transactions TO wb_all;
2385 CREATE OR REPLACE RULE transactions_insert AS
2386 ON INSERT TO "i386".transactions DO INSTEAD
2387 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2388 VALUES ('i386', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2390 CREATE OR REPLACE VIEW "ia64".transactions AS
2391 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2392 FROM public.transactions
2393 WHERE architecture = 'ia64';
2394 ALTER TABLE "ia64".transactions OWNER TO wbadm;
2395 REVOKE ALL ON "ia64".transactions FROM PUBLIC;
2396 GRANT SELECT ON "ia64".transactions TO wb_security;
2397 GRANT SELECT, INSERT ON "ia64".transactions TO wb_all;
2398 CREATE OR REPLACE RULE transactions_insert AS
2399 ON INSERT TO "ia64".transactions DO INSTEAD
2400 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2401 VALUES ('ia64', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2403 CREATE OR REPLACE VIEW "kfreebsd-amd64".transactions AS
2404 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2405 FROM public.transactions
2406 WHERE architecture = 'kfreebsd-amd64';
2407 ALTER TABLE "kfreebsd-amd64".transactions OWNER TO wbadm;
2408 REVOKE ALL ON "kfreebsd-amd64".transactions FROM PUBLIC;
2409 GRANT SELECT ON "kfreebsd-amd64".transactions TO wb_security;
2410 GRANT SELECT, INSERT ON "kfreebsd-amd64".transactions TO wb_all;
2411 CREATE OR REPLACE RULE transactions_insert AS
2412 ON INSERT TO "kfreebsd-amd64".transactions DO INSTEAD
2413 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2414 VALUES ('kfreebsd-amd64', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2416 CREATE OR REPLACE VIEW "kfreebsd-i386".transactions AS
2417 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2418 FROM public.transactions
2419 WHERE architecture = 'kfreebsd-i386';
2420 ALTER TABLE "kfreebsd-i386".transactions OWNER TO wbadm;
2421 REVOKE ALL ON "kfreebsd-i386".transactions FROM PUBLIC;
2422 GRANT SELECT ON "kfreebsd-i386".transactions TO wb_security;
2423 GRANT SELECT, INSERT ON "kfreebsd-i386".transactions TO wb_all;
2424 CREATE OR REPLACE RULE transactions_insert AS
2425 ON INSERT TO "kfreebsd-i386".transactions DO INSTEAD
2426 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2427 VALUES ('kfreebsd-i386', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2429 CREATE OR REPLACE VIEW "mips".transactions AS
2430 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2431 FROM public.transactions
2432 WHERE architecture = 'mips';
2433 ALTER TABLE "mips".transactions OWNER TO wbadm;
2434 REVOKE ALL ON "mips".transactions FROM PUBLIC;
2435 GRANT SELECT ON "mips".transactions TO wb_security;
2436 GRANT SELECT, INSERT ON "mips".transactions TO wb_all;
2437 CREATE OR REPLACE RULE transactions_insert AS
2438 ON INSERT TO "mips".transactions DO INSTEAD
2439 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2440 VALUES ('mips', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2442 CREATE OR REPLACE VIEW "mipsel".transactions AS
2443 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2444 FROM public.transactions
2445 WHERE architecture = 'mipsel';
2446 ALTER TABLE "mipsel".transactions OWNER TO wbadm;
2447 REVOKE ALL ON "mipsel".transactions FROM PUBLIC;
2448 GRANT SELECT ON "mipsel".transactions TO wb_security;
2449 GRANT SELECT, INSERT ON "mipsel".transactions TO wb_all;
2450 CREATE OR REPLACE RULE transactions_insert AS
2451 ON INSERT TO "mipsel".transactions DO INSTEAD
2452 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2453 VALUES ('mipsel', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2455 CREATE OR REPLACE VIEW "powerpc".transactions AS
2456 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2457 FROM public.transactions
2458 WHERE architecture = 'powerpc';
2459 ALTER TABLE "powerpc".transactions OWNER TO wbadm;
2460 REVOKE ALL ON "powerpc".transactions FROM PUBLIC;
2461 GRANT SELECT ON "powerpc".transactions TO wb_security;
2462 GRANT SELECT, INSERT ON "powerpc".transactions TO wb_all;
2463 CREATE OR REPLACE RULE transactions_insert AS
2464 ON INSERT TO "powerpc".transactions DO INSTEAD
2465 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2466 VALUES ('powerpc', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2468 CREATE OR REPLACE VIEW "s390".transactions AS
2469 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2470 FROM public.transactions
2471 WHERE architecture = 's390';
2472 ALTER TABLE "s390".transactions OWNER TO wbadm;
2473 REVOKE ALL ON "s390".transactions FROM PUBLIC;
2474 GRANT SELECT ON "s390".transactions TO wb_security;
2475 GRANT SELECT, INSERT ON "s390".transactions TO wb_all;
2476 CREATE OR REPLACE RULE transactions_insert AS
2477 ON INSERT TO "s390".transactions DO INSTEAD
2478 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2479 VALUES ('s390', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);
2481 CREATE OR REPLACE VIEW "sparc".transactions AS
2482 SELECT package, distribution, version, action, prevstate, state, real_user, set_user, "time"
2483 FROM public.transactions
2484 WHERE architecture = 'sparc';
2485 ALTER TABLE "sparc".transactions OWNER TO wbadm;
2486 REVOKE ALL ON "sparc".transactions FROM PUBLIC;
2487 GRANT SELECT ON "sparc".transactions TO wb_security;
2488 GRANT SELECT, INSERT ON "sparc".transactions TO wb_all;
2489 CREATE OR REPLACE RULE transactions_insert AS
2490 ON INSERT TO "sparc".transactions DO INSTEAD
2491 INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time")
2492 VALUES ('sparc', new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new.time);