Added changes in datamodel to ddl

Added 'tinderbox' table to keep track of tinderboxes compiling packages

You can safely ignore changes in comments

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