From fa5ef07cce130ddb2463fd6c280877f191c3327a Mon Sep 17 00:00:00 2001 From: Debian wanna-build admins Date: Mon, 14 Mar 2011 05:00:54 +0000 Subject: [PATCH] Auto-committed schema changes. --- schema/wanna-build.sql | 33 ++------------------------------- 1 file changed, 2 insertions(+), 31 deletions(-) diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql index 6b3e29c..6e1d02d 100644 --- a/schema/wanna-build.sql +++ b/schema/wanna-build.sql @@ -2638,37 +2638,8 @@ SET search_path = public, pg_catalog; -- Name: distribution_architectures; Type: VIEW; Schema: public; Owner: wbadm -- -CREATE VIEW distribution_architectures AS ((((((((((((( - SELECT DISTINCT packages.distribution, 'alpha'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM alpha.packages group by packages.distribution - UNION - SELECT DISTINCT packages.distribution, 'amd64'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM amd64.packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'arm'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM arm.packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'armel'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM armel.packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'hppa'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM hppa.packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'hurd-i386'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM "hurd-i386".packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'i386'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM i386.packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'ia64'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM ia64.packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'kfreebsd-amd64'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM "kfreebsd-amd64".packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'kfreebsd-i386'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM "kfreebsd-i386".packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'mips'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM mips.packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'mipsel'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM mipsel.packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'powerpc'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM powerpc.packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 's390'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM s390.packages group by packages.distribution - ) UNION - SELECT DISTINCT packages.distribution, 'sparc'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM sparc.packages group by packages.distribution - ; +CREATE VIEW distribution_architectures AS + (((((((((((((SELECT DISTINCT packages.distribution, 'alpha'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM alpha.packages GROUP BY packages.distribution UNION SELECT DISTINCT packages.distribution, 'amd64'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM amd64.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'arm'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM arm.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'armel'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM armel.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'hppa'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM hppa.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'hurd-i386'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM "hurd-i386".packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'i386'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM i386.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'ia64'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM ia64.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'kfreebsd-amd64'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM "kfreebsd-amd64".packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'kfreebsd-i386'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM "kfreebsd-i386".packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'mips'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM mips.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'mipsel'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM mipsel.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'powerpc'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM powerpc.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 's390'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM s390.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'sparc'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM sparc.packages GROUP BY packages.distribution; ALTER TABLE public.distribution_architectures OWNER TO wbadm; -- 2.39.2