diff options
author | 2009-07-06 11:24:47 +0200 | |
---|---|---|
committer | 2009-07-06 11:24:47 +0200 | |
commit | 4d360cecc19a264307f3733d871623e442a73ba3 (patch) | |
tree | 10b414a592a8f3c2d8d01d70e00fa346afad9dcd /doc | |
parent | Quick hack to enable dep resolution (diff) | |
download | collagen-4d360cecc19a264307f3733d871623e442a73ba3.tar.gz collagen-4d360cecc19a264307f3733d871623e442a73ba3.tar.bz2 collagen-4d360cecc19a264307f3733d871623e442a73ba3.zip |
Added changes in datamodel to ddl
Added 'tinderbox' table to keep track of tinderboxes compiling packages
You can safely ignore changes in comments
Diffstat (limited to 'doc')
-rw-r--r-- | doc/ddl.sql | 111 |
1 files changed, 75 insertions, 36 deletions
diff --git a/doc/ddl.sql b/doc/ddl.sql index 39a2b93..a9cc00f 100644 --- a/doc/ddl.sql +++ b/doc/ddl.sql @@ -7,7 +7,7 @@ SET check_function_bodies = false; SET client_min_messages = warning; -- --- Name: collagen; Type: DATABASE; Schema: -; Owner: w0rm +-- Name: collagen; Type: DATABASE; Schema: -; Owner: postgres -- CREATE DATABASE collagen WITH TEMPLATE = template0 ENCODING = 'UTF8'; @@ -71,7 +71,7 @@ CREATE TABLE custom_fields_lists ( -- --- Name: file_id_seq; Type: SEQUENCE; Schema: public; Owner: w0rm +-- Name: file_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE file_id_seq @@ -85,7 +85,7 @@ CREATE SEQUENCE file_id_seq SET default_with_oids = false; -- --- Name: file; Type: TABLE; Schema: public; Owner: w0rm; Tablespace: +-- Name: file; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE file ( @@ -117,7 +117,7 @@ CREATE TABLE filetype ( -- --- Name: package_id_seq; Type: SEQUENCE; Schema: public; Owner: w0rm +-- Name: package_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE package_id_seq @@ -128,7 +128,7 @@ CREATE SEQUENCE package_id_seq -- --- Name: package; Type: TABLE; Schema: public; Owner: w0rm; Tablespace: +-- Name: package; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE package ( @@ -138,7 +138,7 @@ CREATE TABLE package ( -- --- Name: packagecategory_id_seq; Type: SEQUENCE; Schema: public; Owner: w0rm +-- Name: packagecategory_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE packagecategory_id_seq @@ -149,7 +149,7 @@ CREATE SEQUENCE packagecategory_id_seq -- --- Name: packagecategory; Type: TABLE; Schema: public; Owner: w0rm; Tablespace: +-- Name: packagecategory; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE packagecategory ( @@ -159,7 +159,7 @@ CREATE TABLE packagecategory ( -- --- Name: packageproperties_seq_id; Type: SEQUENCE; Schema: public; Owner: w0rm +-- Name: packageproperties_seq_id; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE packageproperties_seq_id @@ -171,18 +171,19 @@ CREATE SEQUENCE packageproperties_seq_id -- --- Name: packageproperties; Type: TABLE; Schema: public; Owner: w0rm; Tablespace: +-- Name: packageproperties; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE packageproperties ( id integer DEFAULT nextval('packageproperties_seq_id'::regclass) NOT NULL, packageversion_id integer NOT NULL, - profile_id integer NOT NULL + profile_id integer NOT NULL, + tinderbox_id integer ); -- --- Name: packageproperties_file; Type: TABLE; Schema: public; Owner: w0rm; Tablespace: +-- Name: packageproperties_file; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE packageproperties_file ( @@ -195,7 +196,7 @@ CREATE TABLE packageproperties_file ( -- --- Name: packageproperties_useflag; Type: TABLE; Schema: public; Owner: w0rm; Tablespace: +-- Name: packageproperties_useflag; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE packageproperties_useflag ( @@ -205,7 +206,7 @@ CREATE TABLE packageproperties_useflag ( -- --- Name: packageversion_id_seq; Type: SEQUENCE; Schema: public; Owner: w0rm +-- Name: packageversion_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE packageversion_id_seq @@ -216,7 +217,7 @@ CREATE SEQUENCE packageversion_id_seq -- --- Name: packageversion; Type: TABLE; Schema: public; Owner: w0rm; Tablespace: +-- Name: packageversion; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE packageversion ( @@ -228,7 +229,7 @@ CREATE TABLE packageversion ( -- --- Name: packageversion_packageversion; Type: TABLE; Schema: public; Owner: w0rm; Tablespace: +-- Name: packageversion_packageversion; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE packageversion_packageversion ( @@ -260,7 +261,29 @@ CREATE TABLE portageprofile ( -- --- Name: useflag; Type: TABLE; Schema: public; Owner: w0rm; Tablespace: +-- Name: tinderbox_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres +-- + +CREATE SEQUENCE tinderbox_id_seq + START WITH 1 + INCREMENT BY 1 + NO MAXVALUE + NO MINVALUE + CACHE 1; + + +-- +-- Name: tinderbox; Type: TABLE; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE TABLE tinderbox ( + id integer DEFAULT nextval('tinderbox_id_seq'::regclass) NOT NULL, + ip inet +); + + +-- +-- Name: useflag; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE useflag ( @@ -278,7 +301,7 @@ ALTER TABLE ONLY attachment -- --- Name: PK_file; Type: CONSTRAINT; Schema: public; Owner: w0rm; Tablespace: +-- Name: PK_file; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY file @@ -294,7 +317,7 @@ ALTER TABLE ONLY filetype -- --- Name: PK_packageproperties; Type: CONSTRAINT; Schema: public; Owner: w0rm; Tablespace: +-- Name: PK_packageproperties; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY packageproperties_file @@ -302,7 +325,7 @@ ALTER TABLE ONLY packageproperties_file -- --- Name: PK_packageproperties_useflag; Type: CONSTRAINT; Schema: public; Owner: w0rm; Tablespace: +-- Name: PK_packageproperties_useflag; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY packageproperties_useflag @@ -310,7 +333,7 @@ ALTER TABLE ONLY packageproperties_useflag -- --- Name: PK_packageversion_packageversion; Type: CONSTRAINT; Schema: public; Owner: w0rm; Tablespace: +-- Name: PK_packageversion_packageversion; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY packageversion_packageversion @@ -326,7 +349,15 @@ ALTER TABLE ONLY portageprofile -- --- Name: pk_package; Type: CONSTRAINT; Schema: public; Owner: w0rm; Tablespace: +-- Name: PK_tinderbox; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: +-- + +ALTER TABLE ONLY tinderbox + ADD CONSTRAINT "PK_tinderbox" PRIMARY KEY (id); + + +-- +-- Name: pk_package; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY package @@ -334,7 +365,7 @@ ALTER TABLE ONLY package -- --- Name: pk_packagecategory; Type: CONSTRAINT; Schema: public; Owner: w0rm; Tablespace: +-- Name: pk_packagecategory; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY packagecategory @@ -342,7 +373,7 @@ ALTER TABLE ONLY packagecategory -- --- Name: pk_packageproperties; Type: CONSTRAINT; Schema: public; Owner: w0rm; Tablespace: +-- Name: pk_packageproperties; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY packageproperties @@ -350,7 +381,7 @@ ALTER TABLE ONLY packageproperties -- --- Name: pk_packageversion; Type: CONSTRAINT; Schema: public; Owner: w0rm; Tablespace: +-- Name: pk_packageversion; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY packageversion @@ -358,7 +389,7 @@ ALTER TABLE ONLY packageversion -- --- Name: pk_useflag; Type: CONSTRAINT; Schema: public; Owner: w0rm; Tablespace: +-- Name: pk_useflag; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY useflag @@ -374,7 +405,7 @@ ALTER TABLE ONLY attachment -- --- Name: FK_packageproperties_file_f_id; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageproperties_file_f_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageproperties_file @@ -382,7 +413,7 @@ ALTER TABLE ONLY packageproperties_file -- --- Name: FK_packageproperties_file_filetype_id; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageproperties_file_filetype_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageproperties_file @@ -390,7 +421,7 @@ ALTER TABLE ONLY packageproperties_file -- --- Name: FK_packageproperties_file_pp_id; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageproperties_file_pp_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageproperties_file @@ -398,7 +429,7 @@ ALTER TABLE ONLY packageproperties_file -- --- Name: FK_packageproperties_packagerversion_id; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageproperties_packagerversion_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageproperties @@ -406,7 +437,7 @@ ALTER TABLE ONLY packageproperties -- --- Name: FK_packageproperties_profile; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageproperties_profile; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageproperties @@ -414,7 +445,15 @@ ALTER TABLE ONLY packageproperties -- --- Name: FK_packageproperties_useflag_pp_id; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageproperties_tinderbox; Type: FK CONSTRAINT; Schema: public; Owner: postgres +-- + +ALTER TABLE ONLY packageproperties + ADD CONSTRAINT "FK_packageproperties_tinderbox" FOREIGN KEY (tinderbox_id) REFERENCES tinderbox(id); + + +-- +-- Name: FK_packageproperties_useflag_pp_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageproperties_useflag @@ -422,7 +461,7 @@ ALTER TABLE ONLY packageproperties_useflag -- --- Name: FK_packageproperties_useflag_u_id; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageproperties_useflag_u_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageproperties_useflag @@ -430,7 +469,7 @@ ALTER TABLE ONLY packageproperties_useflag -- --- Name: FK_packageversion_dependency_id; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageversion_dependency_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageversion_packageversion @@ -438,7 +477,7 @@ ALTER TABLE ONLY packageversion_packageversion -- --- Name: FK_packageversion_package; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageversion_package; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageversion @@ -446,7 +485,7 @@ ALTER TABLE ONLY packageversion -- --- Name: FK_packageversion_packagecategory_id; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageversion_packagecategory_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageversion @@ -454,7 +493,7 @@ ALTER TABLE ONLY packageversion -- --- Name: FK_packageversion_packageversion_id; Type: FK CONSTRAINT; Schema: public; Owner: w0rm +-- Name: FK_packageversion_packageversion_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY packageversion_packageversion |