add resolver and upload archive to the distributions table

[wannabuild.git] / schema / wanna-build.sql

diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql
index 574673217327a77656c664d5de8f24ab00b8c29a..6b3e29c24078e446330fec6bd872a6f30b8517c9 100644 (file)
--- a/schema/wanna-build.sql
+++ b/schema/wanna-build.sql
@@ -2638,8 +2638,37 @@ 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 FROM alpha.packages UNION SELECT DISTINCT packages.distribution, 'amd64'::character varying AS architecture FROM amd64.packages) UNION SELECT DISTINCT packages.distribution, 'arm'::character varying AS architecture FROM arm.packages) UNION SELECT DISTINCT packages.distribution, 'armel'::character varying AS architecture FROM armel.packages) UNION SELECT DISTINCT packages.distribution, 'hppa'::character varying AS architecture FROM hppa.packages) UNION SELECT DISTINCT packages.distribution, 'hurd-i386'::character varying AS architecture FROM "hurd-i386".packages) UNION SELECT DISTINCT packages.distribution, 'i386'::character varying AS architecture FROM i386.packages) UNION SELECT DISTINCT packages.distribution, 'ia64'::character varying AS architecture FROM ia64.packages) UNION SELECT DISTINCT packages.distribution, 'kfreebsd-amd64'::character varying AS architecture FROM "kfreebsd-amd64".packages) UNION SELECT DISTINCT packages.distribution, 'kfreebsd-i386'::character varying AS architecture FROM "kfreebsd-i386".packages) UNION SELECT DISTINCT packages.distribution, 'mips'::character varying AS architecture FROM mips.packages) UNION SELECT DISTINCT packages.distribution, 'mipsel'::character varying AS architecture FROM mipsel.packages) UNION SELECT DISTINCT packages.distribution, 'powerpc'::character varying AS architecture FROM powerpc.packages) UNION SELECT DISTINCT packages.distribution, 's390'::character varying AS architecture FROM s390.packages) UNION SELECT DISTINCT packages.distribution, 'sparc'::character varying AS architecture FROM sparc.packages;
+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
+         ;
 
 
 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
@@ -2652,7 +2681,9 @@ CREATE TABLE distributions (
     distribution character varying NOT NULL,
     public boolean DEFAULT true NOT NULL,
     sort_order integer DEFAULT 0,
-    auto_dep_wait boolean DEFAULT true
+    auto_dep_wait boolean DEFAULT true,
+    build_dep_resolver character varying,
+    archive character varying
 );