2 SET search_path = "alpha", public;
6 CREATE OR REPLACE VIEW pkg_history AS
7 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
9 WHERE pkg_history.architecture::text = 'alpha'::text;
11 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'alpha'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
13 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('alpha'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
15 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'alpha'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
17 GRANT ALL ON TABLE pkg_history TO wbadm;
18 GRANT SELECT ON TABLE pkg_history TO wb_security;
19 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
21 SET search_path = "amd64", public;
23 DROP VIEW pkg_history;
25 CREATE OR REPLACE VIEW pkg_history AS
26 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
28 WHERE pkg_history.architecture::text = 'amd64'::text;
30 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
32 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('amd64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
34 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
36 GRANT ALL ON TABLE pkg_history TO wbadm;
37 GRANT SELECT ON TABLE pkg_history TO wb_security;
38 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
40 SET search_path = "arm", public;
42 DROP VIEW pkg_history;
44 CREATE OR REPLACE VIEW pkg_history AS
45 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
47 WHERE pkg_history.architecture::text = 'arm'::text;
49 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'arm'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
51 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('arm'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
53 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'arm'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
55 GRANT ALL ON TABLE pkg_history TO wbadm;
56 GRANT SELECT ON TABLE pkg_history TO wb_security;
57 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
59 SET search_path = "armel", public;
61 DROP VIEW pkg_history;
63 CREATE OR REPLACE VIEW pkg_history AS
64 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
66 WHERE pkg_history.architecture::text = 'armel'::text;
68 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'armel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
70 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('armel'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
72 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'armel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
74 GRANT ALL ON TABLE pkg_history TO wbadm;
75 GRANT SELECT ON TABLE pkg_history TO wb_security;
76 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
78 SET search_path = "hppa", public;
80 DROP VIEW pkg_history;
82 CREATE OR REPLACE VIEW pkg_history AS
83 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
85 WHERE pkg_history.architecture::text = 'hppa'::text;
87 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'hppa'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
89 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('hppa'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
91 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'hppa'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
93 GRANT ALL ON TABLE pkg_history TO wbadm;
94 GRANT SELECT ON TABLE pkg_history TO wb_security;
95 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
97 SET search_path = "hurd-i386", public;
99 DROP VIEW pkg_history;
101 CREATE OR REPLACE VIEW pkg_history AS
102 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
104 WHERE pkg_history.architecture::text = 'hurd-i386'::text;
106 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'hurd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
108 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('hurd-i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
110 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'hurd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
112 GRANT ALL ON TABLE pkg_history TO wbadm;
113 GRANT SELECT ON TABLE pkg_history TO wb_security;
114 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
116 SET search_path = "i386", public;
118 DROP VIEW pkg_history;
120 CREATE OR REPLACE VIEW pkg_history AS
121 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
123 WHERE pkg_history.architecture::text = 'i386'::text;
125 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
127 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
129 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
131 GRANT ALL ON TABLE pkg_history TO wbadm;
132 GRANT SELECT ON TABLE pkg_history TO wb_security;
133 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
135 SET search_path = "ia64", public;
137 DROP VIEW pkg_history;
139 CREATE OR REPLACE VIEW pkg_history AS
140 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
142 WHERE pkg_history.architecture::text = 'ia64'::text;
144 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'ia64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
146 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('ia64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
148 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'ia64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
150 GRANT ALL ON TABLE pkg_history TO wbadm;
151 GRANT SELECT ON TABLE pkg_history TO wb_security;
152 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
154 SET search_path = "kfreebsd-amd64", public;
156 DROP VIEW pkg_history;
158 CREATE OR REPLACE VIEW pkg_history AS
159 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
161 WHERE pkg_history.architecture::text = 'kfreebsd-amd64'::text;
163 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'kfreebsd-amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
165 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('kfreebsd-amd64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
167 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'kfreebsd-amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
169 GRANT ALL ON TABLE pkg_history TO wbadm;
170 GRANT SELECT ON TABLE pkg_history TO wb_security;
171 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
173 SET search_path = "kfreebsd-i386", public;
175 DROP VIEW pkg_history;
177 CREATE OR REPLACE VIEW pkg_history AS
178 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
180 WHERE pkg_history.architecture::text = 'kfreebsd-i386'::text;
182 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'kfreebsd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
184 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('kfreebsd-i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
186 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'kfreebsd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
188 GRANT ALL ON TABLE pkg_history TO wbadm;
189 GRANT SELECT ON TABLE pkg_history TO wb_security;
190 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
192 SET search_path = "mips", public;
194 DROP VIEW pkg_history;
196 CREATE OR REPLACE VIEW pkg_history AS
197 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
199 WHERE pkg_history.architecture::text = 'mips'::text;
201 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'mips'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
203 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('mips'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
205 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'mips'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
207 GRANT ALL ON TABLE pkg_history TO wbadm;
208 GRANT SELECT ON TABLE pkg_history TO wb_security;
209 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
211 SET search_path = "mipsel", public;
213 DROP VIEW pkg_history;
215 CREATE OR REPLACE VIEW pkg_history AS
216 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
218 WHERE pkg_history.architecture::text = 'mipsel'::text;
220 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'mipsel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
222 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('mipsel'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
224 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'mipsel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
226 GRANT ALL ON TABLE pkg_history TO wbadm;
227 GRANT SELECT ON TABLE pkg_history TO wb_security;
228 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
230 SET search_path = "powerpc", public;
232 DROP VIEW pkg_history;
234 CREATE OR REPLACE VIEW pkg_history AS
235 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
237 WHERE pkg_history.architecture::text = 'powerpc'::text;
239 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'powerpc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
241 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('powerpc'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
243 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'powerpc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
245 GRANT ALL ON TABLE pkg_history TO wbadm;
246 GRANT SELECT ON TABLE pkg_history TO wb_security;
247 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
249 SET search_path = "s390", public;
251 DROP VIEW pkg_history;
253 CREATE OR REPLACE VIEW pkg_history AS
254 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
256 WHERE pkg_history.architecture::text = 's390'::text;
258 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 's390'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
260 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('s390'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
262 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 's390'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
264 GRANT ALL ON TABLE pkg_history TO wbadm;
265 GRANT SELECT ON TABLE pkg_history TO wb_security;
266 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
268 SET search_path = "sparc", public;
270 DROP VIEW pkg_history;
272 CREATE OR REPLACE VIEW pkg_history AS
273 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder
275 WHERE pkg_history.architecture::text = 'sparc'::text;
277 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'sparc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
279 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('sparc'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
281 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'sparc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
283 GRANT ALL ON TABLE pkg_history TO wbadm;
284 GRANT SELECT ON TABLE pkg_history TO wb_security;
285 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
287 SET search_path = "alpha_public", public;
289 DROP VIEW pkg_history;
291 CREATE OR REPLACE VIEW pkg_history AS
292 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
294 NATURAL JOIN distributions
295 WHERE distributions.public = true AND pkg_history.architecture::text = 'alpha'::text;
297 GRANT ALL ON TABLE pkg_history TO wbadm;
298 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
300 SET search_path = "amd64_public", public;
302 DROP VIEW pkg_history;
304 CREATE OR REPLACE VIEW pkg_history AS
305 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
307 NATURAL JOIN distributions
308 WHERE distributions.public = true AND pkg_history.architecture::text = 'amd64'::text;
310 GRANT ALL ON TABLE pkg_history TO wbadm;
311 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
313 SET search_path = "arm_public", public;
315 DROP VIEW pkg_history;
317 CREATE OR REPLACE VIEW pkg_history AS
318 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
320 NATURAL JOIN distributions
321 WHERE distributions.public = true AND pkg_history.architecture::text = 'arm'::text;
323 GRANT ALL ON TABLE pkg_history TO wbadm;
324 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
326 SET search_path = "armel_public", public;
328 DROP VIEW pkg_history;
330 CREATE OR REPLACE VIEW pkg_history AS
331 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
333 NATURAL JOIN distributions
334 WHERE distributions.public = true AND pkg_history.architecture::text = 'armel'::text;
336 GRANT ALL ON TABLE pkg_history TO wbadm;
337 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
339 SET search_path = "hppa_public", public;
341 DROP VIEW pkg_history;
343 CREATE OR REPLACE VIEW pkg_history AS
344 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
346 NATURAL JOIN distributions
347 WHERE distributions.public = true AND pkg_history.architecture::text = 'hppa'::text;
349 GRANT ALL ON TABLE pkg_history TO wbadm;
350 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
352 SET search_path = "hurd-i386_public", public;
354 DROP VIEW pkg_history;
356 CREATE OR REPLACE VIEW pkg_history AS
357 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
359 NATURAL JOIN distributions
360 WHERE distributions.public = true AND pkg_history.architecture::text = 'hurd-i386'::text;
362 GRANT ALL ON TABLE pkg_history TO wbadm;
363 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
365 SET search_path = "i386_public", public;
367 DROP VIEW pkg_history;
369 CREATE OR REPLACE VIEW pkg_history AS
370 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
372 NATURAL JOIN distributions
373 WHERE distributions.public = true AND pkg_history.architecture::text = 'i386'::text;
375 GRANT ALL ON TABLE pkg_history TO wbadm;
376 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
378 SET search_path = "ia64_public", public;
380 DROP VIEW pkg_history;
382 CREATE OR REPLACE VIEW pkg_history AS
383 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
385 NATURAL JOIN distributions
386 WHERE distributions.public = true AND pkg_history.architecture::text = 'ia64'::text;
388 GRANT ALL ON TABLE pkg_history TO wbadm;
389 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
391 SET search_path = "kfreebsd-amd64_public", public;
393 DROP VIEW pkg_history;
395 CREATE OR REPLACE VIEW pkg_history AS
396 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
398 NATURAL JOIN distributions
399 WHERE distributions.public = true AND pkg_history.architecture::text = 'kfreebsd-amd64'::text;
401 GRANT ALL ON TABLE pkg_history TO wbadm;
402 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
404 SET search_path = "kfreebsd-i386_public", public;
406 DROP VIEW pkg_history;
408 CREATE OR REPLACE VIEW pkg_history AS
409 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
411 NATURAL JOIN distributions
412 WHERE distributions.public = true AND pkg_history.architecture::text = 'kfreebsd-i386'::text;
414 GRANT ALL ON TABLE pkg_history TO wbadm;
415 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
417 SET search_path = "mips_public", public;
419 DROP VIEW pkg_history;
421 CREATE OR REPLACE VIEW pkg_history AS
422 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
424 NATURAL JOIN distributions
425 WHERE distributions.public = true AND pkg_history.architecture::text = 'mips'::text;
427 GRANT ALL ON TABLE pkg_history TO wbadm;
428 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
430 SET search_path = "mipsel_public", public;
432 DROP VIEW pkg_history;
434 CREATE OR REPLACE VIEW pkg_history AS
435 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
437 NATURAL JOIN distributions
438 WHERE distributions.public = true AND pkg_history.architecture::text = 'mipsel'::text;
440 GRANT ALL ON TABLE pkg_history TO wbadm;
441 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
443 SET search_path = "powerpc_public", public;
445 DROP VIEW pkg_history;
447 CREATE OR REPLACE VIEW pkg_history AS
448 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
450 NATURAL JOIN distributions
451 WHERE distributions.public = true AND pkg_history.architecture::text = 'powerpc'::text;
453 GRANT ALL ON TABLE pkg_history TO wbadm;
454 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
456 SET search_path = "s390_public", public;
458 DROP VIEW pkg_history;
460 CREATE OR REPLACE VIEW pkg_history AS
461 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
463 NATURAL JOIN distributions
464 WHERE distributions.public = true AND pkg_history.architecture::text = 's390'::text;
466 GRANT ALL ON TABLE pkg_history TO wbadm;
467 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
469 SET search_path = "sparc_public", public;
471 DROP VIEW pkg_history;
473 CREATE OR REPLACE VIEW pkg_history AS
474 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space
476 NATURAL JOIN distributions
477 WHERE distributions.public = true AND pkg_history.architecture::text = 'sparc'::text;
479 GRANT ALL ON TABLE pkg_history TO wbadm;
480 GRANT SELECT ON TABLE pkg_history TO PUBLIC;