Author: goneri-guest
Date: 2007-07-18 09:53:14 +0000 (Wed, 18 Jul 2007)
New Revision: 3433
Modified:
people/goneri/SvnBuildStat-WWW/schema-pg.sql
Log:
update the schema
Modified: people/goneri/SvnBuildStat-WWW/schema-pg.sql
===================================================================
--- people/goneri/SvnBuildStat-WWW/schema-pg.sql 2007-07-17 15:03:43 UTC
(rev 3432)
+++ people/goneri/SvnBuildStat-WWW/schema-pg.sql 2007-07-18 09:53:14 UTC
(rev 3433)
@@ -24,6 +24,8 @@
LANGUAGE sql;
+ALTER FUNCTION public.lindacount(integer) OWNER TO svnbuildstat;
+
--
-- Name: lindaerrcount(integer); Type: FUNCTION; Schema: public; Owner:
svnbuildstat
--
@@ -33,6 +35,8 @@
LANGUAGE sql;
+ALTER FUNCTION public.lindaerrcount(integer) OWNER TO svnbuildstat;
+
--
-- Name: lintiancount(integer); Type: FUNCTION; Schema: public; Owner:
svnbuildstat
--
@@ -42,6 +46,8 @@
LANGUAGE sql;
+ALTER FUNCTION public.lintiancount(integer) OWNER TO svnbuildstat;
+
--
-- Name: lintianerrcount(integer); Type: FUNCTION; Schema: public; Owner:
svnbuildstat
--
@@ -51,6 +57,8 @@
LANGUAGE sql;
+ALTER FUNCTION public.lintianerrcount(integer) OWNER TO svnbuildstat;
+
--
-- Name: arch_id_seq; Type: SEQUENCE; Schema: public; Owner: svnbuildstat
--
@@ -62,6 +70,8 @@
CACHE 1;
+ALTER TABLE public.arch_id_seq OWNER TO svnbuildstat;
+
SET default_tablespace = '';
SET default_with_oids = false;
@@ -76,6 +86,8 @@
);
+ALTER TABLE public.arch OWNER TO svnbuildstat;
+
--
-- Name: bug; Type: TABLE; Schema: public; Owner: svnbuildstat; Tablespace:
--
@@ -88,6 +100,8 @@
);
+ALTER TABLE public.bug OWNER TO svnbuildstat;
+
--
-- Name: build_id_seq; Type: SEQUENCE; Schema: public; Owner: svnbuildstat
--
@@ -99,6 +113,8 @@
CACHE 1;
+ALTER TABLE public.build_id_seq OWNER TO svnbuildstat;
+
--
-- Name: build; Type: TABLE; Schema: public; Owner: svnbuildstat; Tablespace:
--
@@ -130,6 +146,8 @@
);
+ALTER TABLE public.build OWNER TO svnbuildstat;
+
--
-- Name: build_linda; Type: TABLE; Schema: public; Owner: svnbuildstat;
Tablespace:
--
@@ -140,6 +158,8 @@
);
+ALTER TABLE public.build_linda OWNER TO svnbuildstat;
+
--
-- Name: build_lintian; Type: TABLE; Schema: public; Owner: svnbuildstat;
Tablespace:
--
@@ -150,6 +170,8 @@
);
+ALTER TABLE public.build_lintian OWNER TO svnbuildstat;
+
--
-- Name: host_id_seq; Type: SEQUENCE; Schema: public; Owner: svnbuildstat
--
@@ -161,6 +183,8 @@
CACHE 1;
+ALTER TABLE public.host_id_seq OWNER TO svnbuildstat;
+
--
-- Name: host; Type: TABLE; Schema: public; Owner: svnbuildstat; Tablespace:
--
@@ -173,6 +197,8 @@
);
+ALTER TABLE public.host OWNER TO svnbuildstat;
+
--
-- Name: linda_id_seq; Type: SEQUENCE; Schema: public; Owner: svnbuildstat
--
@@ -184,6 +210,8 @@
CACHE 1;
+ALTER TABLE public.linda_id_seq OWNER TO svnbuildstat;
+
--
-- Name: linda; Type: TABLE; Schema: public; Owner: svnbuildstat; Tablespace:
--
@@ -195,6 +223,8 @@
);
+ALTER TABLE public.linda OWNER TO svnbuildstat;
+
--
-- Name: lintian_id_seq; Type: SEQUENCE; Schema: public; Owner: svnbuildstat
--
@@ -206,6 +236,8 @@
CACHE 1;
+ALTER TABLE public.lintian_id_seq OWNER TO svnbuildstat;
+
--
-- Name: lintian; Type: TABLE; Schema: public; Owner: svnbuildstat;
Tablespace:
--
@@ -217,6 +249,8 @@
);
+ALTER TABLE public.lintian OWNER TO svnbuildstat;
+
--
-- Name: maintainer_id_seq; Type: SEQUENCE; Schema: public; Owner: svnbuildstat
--
@@ -228,6 +262,8 @@
CACHE 1;
+ALTER TABLE public.maintainer_id_seq OWNER TO svnbuildstat;
+
--
-- Name: maintainer; Type: TABLE; Schema: public; Owner: svnbuildstat;
Tablespace:
--
@@ -239,6 +275,8 @@
);
+ALTER TABLE public.maintainer OWNER TO svnbuildstat;
+
--
-- Name: package_id_seq; Type: SEQUENCE; Schema: public; Owner: svnbuildstat
--
@@ -250,6 +288,8 @@
CACHE 1;
+ALTER TABLE public.package_id_seq OWNER TO svnbuildstat;
+
--
-- Name: package; Type: TABLE; Schema: public; Owner: svnbuildstat;
Tablespace:
--
@@ -265,10 +305,16 @@
svndebrelease text,
uri text,
isuptodate boolean,
- upstreamrelease character varying(200)
+ upstreamrelease character varying(200),
+ isnative boolean DEFAULT false,
+ lastcheck timestamp without time zone,
+ iswatchfilebroken boolean,
+ lastbuildstart timestamp without time zone
);
+ALTER TABLE public.package OWNER TO svnbuildstat;
+
--
-- Name: package_maintainer; Type: TABLE; Schema: public; Owner: svnbuildstat;
Tablespace:
--
@@ -279,6 +325,8 @@
);
+ALTER TABLE public.package_maintainer OWNER TO svnbuildstat;
+
--
-- Name: repository_id_seq; Type: SEQUENCE; Schema: public; Owner: svnbuildstat
--
@@ -290,6 +338,8 @@
CACHE 1;
+ALTER TABLE public.repository_id_seq OWNER TO svnbuildstat;
+
--
-- Name: repository; Type: TABLE; Schema: public; Owner: svnbuildstat;
Tablespace:
--
@@ -300,10 +350,13 @@
name text,
tarballlayout text,
enabled boolean DEFAULT true,
- rev integer
+ rev integer,
+ lastcheck timestamp without time zone
);
+ALTER TABLE public.repository OWNER TO svnbuildstat;
+
--
-- Name: severity_id_seq; Type: SEQUENCE; Schema: public; Owner: svnbuildstat
--
@@ -315,6 +368,8 @@
CACHE 1;
+ALTER TABLE public.severity_id_seq OWNER TO svnbuildstat;
+
--
-- Name: severity; Type: TABLE; Schema: public; Owner: svnbuildstat;
Tablespace:
--
@@ -325,15 +380,29 @@
);
+ALTER TABLE public.severity OWNER TO svnbuildstat;
+
--
-- Name: viewpackage; Type: VIEW; Schema: public; Owner: svnbuildstat
--
CREATE VIEW viewpackage AS
- SELECT DISTINCT build.id, count(build.id) AS builded,
lintiancount(build.id) AS lintiancount, lintianerrcount(build.id) AS
lintianerrcount, lindacount(build.id) AS lindacount, lindaerrcount(build.id) AS
lindaerrcount, bool_or(build.buildisok) AS buildisok, package.id AS package_id,
package.name, package.repository_id, package.isindebian, package.isuptodate,
count(bug.bug_id) AS count FROM ((package LEFT JOIN build build ON
(((package.id = build.package_id) AND (package.rev = (build.rev)::text)))) LEFT
JOIN bug ON ((package.id = bug.package_id))) GROUP BY package.id, package.name,
package.repository_id, build.id, package.isindebian, package.isuptodate ORDER
BY build.id, count(build.id), lintiancount(build.id),
lintianerrcount(build.id), lindacount(build.id), lindaerrcount(build.id),
bool_or(build.buildisok), package.id, package.name, package.repository_id,
package.isindebian, package.isuptodate, count(bug.bug_id);
+ SELECT DISTINCT count(build.id) AS builded, max(lintiancount(build.id)) AS
lintiancount, max(lintianerrcount(build.id)) AS lintianerrcount,
max(lindacount(build.id)) AS lindacount, max(lindaerrcount(build.id)) AS
lindaerrcount, bool_or(build.buildisok) AS buildisok,
bool_or(build.piupartsisok) AS piupartsisok, max(build."time") AS
lastbuilddate, package.id AS package_id, package.name, package.repository_id,
package.isindebian, package.isuptodate, package.tarballuri, package.uri,
package.isnative, package.iswatchfilebroken, count(bug.bug_id) AS bugcount,
max(bug.severity_id) AS bugmaxseverity, package.istarballpresent,
package.svndebrelease, package.lastbuildstart FROM ((package LEFT JOIN build
build ON ((((package.id = build.package_id) AND (package.rev =
(build.rev)::text)) AND (build.isbuildinprogress = false)))) LEFT JOIN bug ON
((package.id = bug.package_id))) GROUP BY package.id, package.name,
package.repository_id, package.isindebian, package.isuptodate,
package.istarballpresent, package.tarballuri, package.uri,
package.svndebrelease, package.isnative, package.iswatchfilebroken,
package.lastbuildstart ORDER BY count(build.id), max(lintiancount(build.id)),
max(lintianerrcount(build.id)), max(lindacount(build.id)),
max(lindaerrcount(build.id)), bool_or(build.buildisok),
bool_or(build.piupartsisok), max(build."time"), package.id, package.name,
package.repository_id, package.isindebian, package.isuptodate,
package.tarballuri, package.uri, package.isnative, package.iswatchfilebroken,
count(bug.bug_id), max(bug.severity_id), package.istarballpresent,
package.svndebrelease, package.lastbuildstart;
+ALTER TABLE public.viewpackage OWNER TO svnbuildstat;
+
--
+-- Name: viewtobuild; Type: VIEW; Schema: public; Owner: svnbuildstat
+--
+
+CREATE VIEW viewtobuild AS
+ SELECT viewpackage.package_id FROM viewpackage WHERE
((viewpackage.istarballpresent = true) OR (viewpackage.isnative = true)) ORDER
BY viewpackage.builded, (viewpackage.lastbuildstart IS NOT NULL),
viewpackage.lastbuildstart, viewpackage.lastbuilddate;
+
+
+ALTER TABLE public.viewtobuild OWNER TO svnbuildstat;
+
+--
-- Name: arch_arch_key; Type: CONSTRAINT; Schema: public; Owner: svnbuildstat;
Tablespace:
--
_______________________________________________
Pkg-games-commits mailing list
[email protected]
http://lists.alioth.debian.org/mailman/listinfo/pkg-games-commits
