X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fwanna-build.sql;h=ba6b0f58df0efa30467e5ed6136fa602614208dc;hb=c7027081dd29d75e2aaa237ed5ea7f1b42f15880;hp=574673217327a77656c664d5de8f24ab00b8c29a;hpb=d3a10f8a3ee8780bcc4d163eb9cbea99023529df;p=wannabuild.git diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql index 5746732..ba6b0f5 100644 --- a/schema/wanna-build.sql +++ b/schema/wanna-build.sql @@ -939,7 +939,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -956,7 +957,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -1001,7 +1003,7 @@ SET search_path = alpha_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM alpha.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 alpha.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE alpha_public.packages OWNER TO wbadm; @@ -1065,7 +1067,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -1082,7 +1085,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -1127,7 +1131,7 @@ SET search_path = amd64_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM amd64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 amd64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE amd64_public.packages OWNER TO wbadm; @@ -1191,7 +1195,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -1208,7 +1213,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -1253,7 +1259,7 @@ SET search_path = arm_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM arm.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 arm.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE arm_public.packages OWNER TO wbadm; @@ -1317,7 +1323,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -1334,7 +1341,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -1379,7 +1387,7 @@ SET search_path = armel_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM armel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 armel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE armel_public.packages OWNER TO wbadm; @@ -1443,7 +1451,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -1460,7 +1469,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -1505,7 +1515,7 @@ SET search_path = hppa_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM hppa.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 hppa.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE hppa_public.packages OWNER TO wbadm; @@ -1569,7 +1579,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -1586,7 +1597,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -1631,7 +1643,7 @@ SET search_path = "hurd-i386_public", pg_catalog; -- CREATE VIEW packages AS - 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 FROM "hurd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 "hurd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE "hurd-i386_public".packages OWNER TO wbadm; @@ -1695,7 +1707,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -1712,7 +1725,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -1757,7 +1771,7 @@ SET search_path = i386_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM i386.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 i386.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE i386_public.packages OWNER TO wbadm; @@ -1821,7 +1835,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -1838,7 +1853,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -1883,7 +1899,7 @@ SET search_path = ia64_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM ia64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 ia64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE ia64_public.packages OWNER TO wbadm; @@ -1947,7 +1963,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -1964,7 +1981,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -2009,7 +2027,7 @@ SET search_path = "kfreebsd-amd64_public", pg_catalog; -- CREATE VIEW packages AS - 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 FROM "kfreebsd-amd64".packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 "kfreebsd-amd64".packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE "kfreebsd-amd64_public".packages OWNER TO wbadm; @@ -2073,7 +2091,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -2090,7 +2109,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -2135,7 +2155,7 @@ SET search_path = "kfreebsd-i386_public", pg_catalog; -- CREATE VIEW packages AS - 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 FROM "kfreebsd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 "kfreebsd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE "kfreebsd-i386_public".packages OWNER TO wbadm; @@ -2199,7 +2219,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -2216,7 +2237,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -2261,7 +2283,7 @@ SET search_path = mips_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM mips.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 mips.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE mips_public.packages OWNER TO wbadm; @@ -2325,7 +2347,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -2342,7 +2365,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -2387,7 +2411,7 @@ SET search_path = mipsel_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM mipsel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 mipsel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE mipsel_public.packages OWNER TO wbadm; @@ -2451,7 +2475,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -2468,7 +2493,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -2513,7 +2539,7 @@ SET search_path = powerpc_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM powerpc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 powerpc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE powerpc_public.packages OWNER TO wbadm; @@ -2591,7 +2617,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -2626,7 +2653,8 @@ CREATE TABLE packages ( rel character varying, bd_problem text, extra_depends character varying, - extra_conflicts character varying + extra_conflicts character varying, + build_arch_all boolean DEFAULT false NOT NULL ); @@ -2639,11 +2667,21 @@ SET search_path = public, pg_catalog; -- 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; + (((((((((((((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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled 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, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM sparc.packages GROUP BY packages.distribution; ALTER TABLE public.distribution_architectures OWNER TO wbadm; +-- +-- Name: distribution_architectures_statistics; Type: VIEW; Schema: public; Owner: wbadm +-- + +CREATE VIEW distribution_architectures_statistics AS + SELECT distribution_architectures.distribution, distribution_architectures.architecture, distribution_architectures.needsbuild, distribution_architectures.notinstalled FROM distribution_architectures; + + +ALTER TABLE public.distribution_architectures_statistics OWNER TO wbadm; + -- -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace: -- @@ -2652,7 +2690,10 @@ 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, + suppress_successful_logs boolean DEFAULT false NOT NULL ); @@ -2671,7 +2712,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -2702,7 +2744,8 @@ CREATE TABLE pkg_history ( "timestamp" timestamp without time zone NOT NULL, result character varying NOT NULL, build_time integer, - disk_space bigint + disk_space bigint, + builder character varying ); @@ -2742,16 +2785,6 @@ CREATE VIEW log AS ALTER TABLE public.log OWNER TO wbadm; --- --- Name: log_v2; Type: VIEW; Schema: public; Owner: pkern --- - -CREATE VIEW log_v2 AS - (((((((((((((SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'alpha'::character varying AS architecture FROM alpha_public.pkg_history UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'amd64'::character varying AS architecture FROM amd64_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'arm'::character varying AS architecture FROM arm_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'armel'::character varying AS architecture FROM armel_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'hppa'::character varying AS architecture FROM hppa_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'hurd-i386'::character varying AS architecture FROM "hurd-i386_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'i386'::character varying AS architecture FROM i386_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'ia64'::character varying AS architecture FROM ia64_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'kfreebsd-amd64'::character varying AS architecture FROM "kfreebsd-amd64_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'kfreebsd-i386'::character varying AS architecture FROM "kfreebsd-i386_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'mips'::character varying AS architecture FROM mips_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'mipsel'::character varying AS architecture FROM mipsel_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'powerpc'::character varying AS architecture FROM powerpc_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 's390'::character varying AS architecture FROM s390_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'sparc'::character varying AS architecture FROM sparc_public.pkg_history ORDER BY 4 DESC; - - -ALTER TABLE public.log_v2 OWNER TO pkern; - SET search_path = s390_public, pg_catalog; -- @@ -2759,7 +2792,7 @@ SET search_path = s390_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM s390.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 s390.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE s390_public.packages OWNER TO wbadm; @@ -2771,7 +2804,7 @@ SET search_path = sparc_public, pg_catalog; -- CREATE VIEW packages AS - 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 FROM sparc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); + 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 sparc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text); ALTER TABLE sparc_public.packages OWNER TO wbadm; @@ -4445,6 +4478,7 @@ REVOKE ALL ON TABLE pkg_history FROM wbadm; GRANT ALL ON TABLE pkg_history TO wbadm; GRANT ALL ON TABLE pkg_history TO alpha; GRANT SELECT ON TABLE pkg_history TO wb_security; +GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all; -- @@ -5604,6 +5638,16 @@ GRANT ALL ON TABLE distribution_architectures TO wbadm; GRANT SELECT ON TABLE distribution_architectures TO PUBLIC; +-- +-- Name: distribution_architectures_statistics; Type: ACL; Schema: public; Owner: wbadm +-- + +REVOKE ALL ON TABLE distribution_architectures_statistics FROM PUBLIC; +REVOKE ALL ON TABLE distribution_architectures_statistics FROM wbadm; +GRANT ALL ON TABLE distribution_architectures_statistics TO wbadm; +GRANT SELECT ON TABLE distribution_architectures_statistics TO PUBLIC; + + -- -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm -- @@ -5686,16 +5730,6 @@ GRANT ALL ON TABLE log TO wbadm; GRANT SELECT ON TABLE log TO PUBLIC; --- --- Name: log_v2; Type: ACL; Schema: public; Owner: pkern --- - -REVOKE ALL ON TABLE log_v2 FROM PUBLIC; -REVOKE ALL ON TABLE log_v2 FROM pkern; -GRANT ALL ON TABLE log_v2 TO pkern; -GRANT SELECT ON TABLE log_v2 TO PUBLIC; - - SET search_path = s390_public, pg_catalog; --