[gentoo-commits] dev/zorry:master commit in: buildhost/

[Magnus Granberg]

commit:     34da8ef69fef9613e388db883bf16fdf7a8f712b
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Fri Apr  1 15:18:20 2011 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Fri Apr  1 15:18:20 2011 +0000
URL:        http://git.overlays.gentoo.org/gitweb/?p=dev/zorry.git;a=commit;h=34da8ef6

update the db core

---
 buildhost/buildhost.sql | 1895 +++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 1735 insertions(+), 160 deletions(-)

diff --git a/buildhost/buildhost.sql b/buildhost/buildhost.sql
index 698754f..f5d5c3c 100644
--- a/buildhost/buildhost.sql
+++ b/buildhost/buildhost.sql
@@ -1,172 +1,1747 @@
--- phpMyAdmin SQL Dump
--- version 3.3.8.1
--- http://www.phpmyadmin.net
 --
--- Värd: localhost
--- Skapad: 20 december 2010 kl 03:05
--- Serverversion: 5.1.51
--- PHP-version: 5.3.3-pl1-gentoo
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = off;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+SET escape_string_warning = off;
+
+--
+-- Name: buildhost; Type: COMMENT; Schema: -; Owner: pgadmin
+--
+
+COMMENT ON DATABASE buildhost IS 'The main db for the buildhost';
+
+
+--
+-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
+--
+
+CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
+
+
+ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Name: ebuild_package; Type: TYPE; Schema: public; Owner: pgadmin
+--
+
+CREATE TYPE ebuild_package AS (
+	ebuild integer,
+	package integer
+);
+
+
+ALTER TYPE public.ebuild_package OWNER TO pgadmin;
+
+--
+-- Name: comparearrays(anyarray, anyarray); Type: FUNCTION; Schema: public; Owner: pgadmin
+--
+
+CREATE FUNCTION comparearrays(oldarray anyarray, newarray anyarray) RETURNS anyarray
+    LANGUAGE plpgsql IMMUTABLE
+    AS $$
+  DECLARE 
+  returnArray oldArray%TYPE;
+
+  BEGIN
+--figure out if the new array contians the old one if that is true do nothing if not iterate over the old array and remove those that isnt in the new one.
+  IF oldArray <@ newArray=FALSE THEN
+    FOR i IN array_lower(oldArray,1)..array_upper(oldArray,1) LOOP
+      IF newArray@> ARRAY[oldArray[i]] = FALSE THEN
+	SELECT array_append(returnArray, oldArray[i]) into returnArray;
+      END IF;
+    END LOOP;
+   END IF;
+    RETURN returnArray;
+  END;
+
+$$;
+
+
+ALTER FUNCTION public.comparearrays(oldarray anyarray, newarray anyarray) OWNER TO pgadmin;
+
+--
+-- Name: insert_buildqueue(integer, character varying, character varying[], boolean[], text); Type: FUNCTION; Schema: public; Owner: pgadmin
+--
+
+CREATE FUNCTION insert_buildqueue(ebuildid integer, buildhost character varying, inuseflags character varying[], inenabled boolean[], message text) RETURNS integer
+    LANGUAGE plpgsql
+    AS $$
+  DECLARE
+    oldQid INTEGER[];
+    result BOOLEAN;
+    ret INTEGER;
+
+  BEGIN
+    -- find out if the buildhost haves the ebuild in the query
+    SELECT ARRAY(SELECT queue_id FROM buildqueue WHERE ebuild_id=ebuildID AND config=buildhost) INTO oldQid;
+    -- if not NULL check if the useflags have changed if there is any "new" useflags
+    IF inUseFlags IS NOT NULL AND array_lower(oldQid,1) IS NOT NULL THEN
+      --add the new useflags to a temp table
+      CREATE TEMPORARY TABLE mid(
+	useflag VARCHAR(128) NOT NULL,
+	enabled BOOLEAN NOT NULL
+      );
+      
+      FOR i IN array_lower(inUseFlags,1)..array_upper(inUseFlags,1) LOOP
+	INSERT INTO mid(useflag,enabled) VALUES(inUseFlags[i], inEnabled[i]);
+      END LOOP;
+
+
+    -- finally check if the useflags have changed since the queued version
+      FOR i IN array_lower(oldQid,1)..array_upper(oldQid,1) LOOP
+	PERFORM useflag,enabled FROM mid EXCEPT SELECT useflag,enabled FROM ebuildQueuedWithUses WHERE queue_id=oldQid[i] ORDER BY useflag;
+	ret:=oldQid[i];
+	IF NOT FOUND THEN
+	  PERFORM useflag,enabled FROM ebuildQueuedWithUses WHERE queue_id=oldQid[i] EXCEPT SELECT useflag,enabled FROM mid ORDER BY useflag;
+	  IF FOUND THEN
+	    result:=TRUE;
+	    EXIT;  
+	  END IF;
+	ELSE
+	  result:=TRUE;
+	  EXIT;
+	END IF;
+      END LOOP;
+    -- if result is null the useflags havent changed then dont add the ebuild to the queue
+      IF result IS TRUE THEN
+	INSERT INTO buildqueue(ebuild_id,config,post_message,timestamp) VALUES(ebuildID,buildhost,message,now()) RETURNING queue_id INTO ret;
+	FOR i IN array_lower(inUseFlags,1)..array_upper(inUseFlags,1) LOOP
+	  INSERT INTO useflags(useflag) SELECT inUseFlags[i] WHERE inUseFlags[i] NOT IN(SELECT useflag FROM useflags);
+	  INSERT INTO ebuildQueuedWithUses(useflag,enabled,queue_id) VALUES(inUseFlags[i],inEnabled[i],ret);
+	END LOOP;	
+      END IF;
+      DROP TABLE mid;
+    ELSE
+    --insert a new build with out hassle
+      IF inUseFlags IS NOT NULL THEN -- (oldQid IS EMPTY)
+	INSERT INTO buildqueue(ebuild_id,config,post_message,timestamp) VALUES(ebuildID,buildhost,message,now()) RETURNING queue_id INTO ret;
+	FOR i IN array_lower(inUseFlags,1)..array_upper(inUseFlags,1) LOOP
+	    INSERT INTO useflags(useflag) SELECT inUseFlags[i] WHERE inUseFlags[i] NOT IN(SELECT useflag FROM useflags);
+	    INSERT INTO ebuildQueuedWithUses(useflag,enabled,queue_id) VALUES(inUseFlags[i],inEnabled[i],ret);
+	END LOOP;
+	
+      ELSE
+	-- corner case if the ebuild haves 0 useflags
+	IF array_lower(oldQid,1) IS NULL THEN
+	  INSERT INTO buildqueue(ebuild_id,config,post_message,timestamp) VALUES(ebuildID,buildhost,message,now())RETURNING queue_id INTO ret;	
+
+	ELSE
+	  FOR i IN array_lower(oldQid,1)..array_upper(oldQid,1) LOOP
+	    SElECT queue_id FROM buildqueue WHERE queue_id=oldQid[i] AND queue_id NOT IN(SELECT queue_id FROM ebuildQueuedWithUses WHERE queue_id=oldQid[i]) INTO ret;
+	    IF FOUND THEN
+	      result=TRUE;
+	      EXIT;
+	    END IF;
+	  END LOOP;
+
+	  IF result IS NOT TRUE THEN
+	    -- double corner case where an ebuild exists in the queue with one or more useflags and we are adding a new build with NO useflags
+	    INSERT INTO buildqueue(ebuild_id,config,useflags,post_message,timestamp) VALUES(ebuildID,buildhost,NULL,message,now())RETURNING queue_id INTO ret;
+	  END IF;
+	
+	END IF;	
+      END IF; 
+    END IF;
+    RETURN ret;
+  END;
+$$;
+
+
+ALTER FUNCTION public.insert_buildqueue(ebuildid integer, buildhost character varying, inuseflags character varying[], inenabled boolean[], message text) OWNER TO pgadmin;
+
+--
+-- Name: insert_ebuild(character varying, character varying, character varying, character varying, character varying, text, text, text, text, character varying, text, text, text, text, text, text, text, character varying, text, text, boolean); Type: FUNCTION; Schema: public; Owner: pgadmin
+--
+
+CREATE FUNCTION insert_ebuild(incategory character varying, inpackage_name character varying, inebuild_version character varying, inlive_version character varying, inebuild_checksum character varying, inebuild_text text, independ text, inrdepend text, inpdepend text, inslot character varying, insrc_url text, inhomepage text, inlicense text, indescription text, ininherited text, inrequired_use text, inprovides text, ineapi character varying, inproperties text, indefined_phases text, inactive boolean) RETURNS integer[]
+    LANGUAGE plpgsql
+    AS $$
+  DECLARE
+    act BOOLEAN;
+    ebuild_package INTEGER[];
+    var INTEGER;
+
+  BEGIN
+  --check if the category exists if not create it
+    INSERT INTO categories(category) SELECT inCategory 
+      WHERE incategory NOT IN(
+	SELECT category FROM categories WHERE category=inCategory);
+
+    --check if the package exists if not create it
+    ebuild_package[0]:= package_id FROM packages WHERE category=inCategory AND package_name=inPackage_name;
+    
+    IF ebuild_package[0] ISNULL THEN
+      INSERT INTO packages VALUES(DEFAULT, inCategory, inPackage_name) RETURNING package_id INTO var;
+      ebuild_package[0]:=var;
+    END IF;
+
+    IF inActive IS NULL OR inActive IS TRUE THEN
+      act=TRUE;
+    END IF;
+
+    --insert the new ebuild and put new ebuild ID into a variable and return it
+    INSERT INTO ebuilds(package_id,ebuild_version,live_version,ebuild_checksum,ebuild_text,depend,rdepend,pdepend,slot,src_url,homepage,license,description,inherited,required_use,provides,eapi,properties,defined_phases,active)
+    VALUES(ebuild_package[0],inEbuild_version,inLive_version,inEbuild_checksum,inEbuild_text,inDepend,inRdepend,inPdepend,inSlot,inSrc_url,inHomepage,inLicense,inDescription,inInherited,inRequired_use,inProvides,inEapi,inProperties,inDefined_phases,act) 
+    RETURNING id INTO var;
+    ebuild_package[1]:=var;
+-- if the ebuild was added as active add the current time to the timestamp field
+    
+    IF act IS TRUE THEN
+      UPDATE ebuilds SET timestamp=now() WHERE id=ebuild_package[1]; 
+    END IF;
+
+    RETURN ebuild_package;
+  END;
+$$;
+
+
+ALTER FUNCTION public.insert_ebuild(incategory character varying, inpackage_name character varying, inebuild_version character varying, inlive_version character varying, inebuild_checksum character varying, inebuild_text text, independ text, inrdepend text, inpdepend text, inslot character varying, insrc_url text, inhomepage text, inlicense text, indescription text, ininherited text, inrequired_use text, inprovides text, ineapi character varying, inproperties text, indefined_phases text, inactive boolean) OWNER TO pgadmin;
+
+--
+-- Name: updateiuse(integer, character varying[]); Type: FUNCTION; Schema: public; Owner: pgadmin
+--
+
+CREATE FUNCTION updateiuse(ebuildid integer, iniuses character varying[]) RETURNS void
+    LANGUAGE plpgsql
+    AS $$
+  DECLARE
+   oldIuses VARCHAR[];
+   deletIuses VARCHAR[];
+   explicitNewIuses VARCHAR[];
+
+  BEGIN
+
+-- add iuses to the ebuild in question
+
+    IF inIuses IS NOT NULL THEN 
+    --find all the old iuses (if any) that needs to be deleted
+      SELECT ARRAY(SELECT iuse FROM ebuildHavesIuses WHERE ebuild=ebuildID) INTO oldIuses;
+    
+
+      -- IF there is any old iuses we need to find those that needs to be removed (because of updated ebuild etc).
+      IF oldIuses IS NOT NULL THEN
+	SELECT compareArrays(oldIuses,inIuses)INTO deletIuses;
+	IF deletIuses IS NOT NULL THEN
+	  FOR i IN array_lower(deletIuses,1)..array_upper(deletIuses,1) LOOP
+	    DELETE FROM ebuildHavesIuses WHERE ebuild=ebuildID AND iuse=deletIuses[i];
+	  END LOOP;
+	END IF;
+	-- Find all the new iuses that isnt present in the oldIuses array.
+	SELECT compareArrays(inIuses,oldIuses) INTO explicitNewIuses;
+      END IF;
+
+      -- Time to add the new iuses (if any) to the iuses table and
+      -- Then add the new iuses to the ebuildHavesIuses table.
+	IF explicitNewIuses IS NOT NULL THEN
+	  FOR i IN array_lower(explicitNewIuses,1)..array_upper(explicitNewIuses,1) LOOP
+	    INSERT INTO iuses(iuse) SELECT explicitNewIuses[i] 
+	      WHERE explicitNewIuses[i] NOT IN(
+		SELECT iuse FROM iuses WHERE iuse=explicitNewIuses[i]);
+	
+	      INSERT INTO ebuildHavesIuses(ebuild,iuse) VALUES(ebuildID, explicitNewIuses[i]);
+	  END LOOP;
+	END IF;
+    ELSE
+    -- if inIuses is NULL simply delete all isuses 
+      DELETE FROM ebuildHavesIuses WHERE ebuild=ebuildID;
+    END IF;
+  END;
+
+$$;
+
+
+ALTER FUNCTION public.updateiuse(ebuildid integer, iniuses character varying[]) OWNER TO pgadmin;
+
+--
+-- Name: updatekeywords(integer, character varying[]); Type: FUNCTION; Schema: public; Owner: pgadmin
+--
+
+CREATE FUNCTION updatekeywords(ebuildid integer, inkeywords character varying[]) RETURNS void
+    LANGUAGE plpgsql
+    AS $$
+  DECLARE
+   oldKeywords VARCHAR[];
+   deletKeywords VARCHAR[];
+   explicitNewKeywords VARCHAR[];
+
+  BEGIN
+
+    IF inKeywords IS NOT NULL THEN 
+    --find all the old keywords (if any) that needs to be deleted
+      SELECT ARRAY(SELECT keyword FROM ebuildHavesKeywords WHERE ebuild_id=ebuildID) INTO oldKeywords;
+
+      -- IF there is any old keywords we need to find those that needs to be removed (because of updated ebuild etc).
+      IF oldKeywords IS NOT NULL THEN
+	SELECT compareArrays(oldKeywords,inKeywords)INTO deletKeywords;
+	IF deletKeywords IS NOT NULL THEN
+	  FOR i IN array_lower(deletKeywords,1)..array_upper(deletKeywords,1) LOOP
+	    DELETE FROM ebuildHavesKeywords WHERE ebuild_id=ebuildID AND keyword=deletKeywords[i];
+	  END LOOP;
+	END IF;
+	-- Find all the new restrictions that isnt present in the oldKeywords array.
+	SELECT compareArrays(inKeywords,oldKeywords) INTO explicitNewKeywords;
+      END IF;
+
+
+	-- Add the new keywords to the ebuildHavesIuses table.
+	IF explicitNewKeywords IS NOT NULL THEN
+	  FOR i IN array_lower(explicitNewKeywords,1)..array_upper(explicitNewKeywords,1) LOOP
+	      INSERT INTO ebuildHavesKeywords(ebuild_id,keyword) VALUES(ebuildID, explicitNewKeywords[i]);
+	  END LOOP;
+	END IF;
+    ELSE
+      --if inkeywords is NULL then remove all keywords from the ebuild
+      DELETE FROM ebuildHavesKeywords WHERE ebuild_id=ebuildID;
+    END IF;
+  END;
+
+$$;
+
+
+ALTER FUNCTION public.updatekeywords(ebuildid integer, inkeywords character varying[]) OWNER TO pgadmin;
+
+--
+-- Name: updaterestrictions(integer, character varying[]); Type: FUNCTION; Schema: public; Owner: pgadmin
+--
+
+CREATE FUNCTION updaterestrictions(ebuildid integer, inrestrictions character varying[]) RETURNS void
+    LANGUAGE plpgsql
+    AS $$
+  DECLARE
+   oldRestrictions VARCHAR[];
+   deletRestrictions VARCHAR[];
+   explicitNewRestrictions VARCHAR[];
+
+  BEGIN
+
+    IF inRestrictions IS NOT NULL THEN
+    --find all the old restrictions (if any) that needs to be deleted
+      SELECT ARRAY(SELECT restriction FROM ebuildHavesRestrictions WHERE ebuild_id=ebuildID) INTO oldRestrictions;
+
+      -- IF there is any old restrictions we need to find those that needs to be removed (because of updated ebuild etc).
+      IF oldRestrictions IS NOT NULL THEN
+	SELECT compareArrays(oldRestrictions,inRestrictions)INTO deletRestrictions;
+	IF deletRestrictions IS NOT NULL THEN
+	  FOR i IN array_lower(deletRestrictions,1)..array_upper(deletRestrictions,1) LOOP
+	    DELETE FROM ebuildHavesRestrictions WHERE ebuild_id=ebuildID AND restriction=deletRestrictions[i];
+	  END LOOP;
+	END IF;
+	-- Find all the new restrictions that isnt present in the oldRestrictions array.
+	SELECT compareArrays(inRestrictions,oldRestrictions) INTO explicitNewRestrictions;
+      END IF;
+
+
+	-- Add the new restriction to the ebuildHavesRestrictions table.
+	IF explicitNewRestrictions IS NOT NULL THEN
+	  FOR i IN array_lower(explicitNewRestrictions,1)..array_upper(explicitNewRestrictions,1) LOOP
+	       INSERT INTO restrictions(restriction_name) SELECT explicitNewRestrictions[i] 
+		WHERE explicitNewRestrictions[i] NOT IN(
+		  SELECT restriction_name FROM restrictions WHERE restriction_name=explicitNewRestrictions[i]);
+	      INSERT INTO ebuildHavesRestrictions(ebuild_id,restriction) VALUES(ebuildID, explicitNewRestrictions[i]);
+	  END LOOP;
+	END IF;
+    ELSE
+      --delete all restrictions if any on the ebuild
+	DELETE FROM ebuildHavesRestrictions WHERE ebuild_id=ebuildID;
+    END IF;
+  END;
+
+$$;
+
+
+ALTER FUNCTION public.updaterestrictions(ebuildid integer, inrestrictions character varying[]) OWNER TO pgadmin;
+
+SET default_tablespace = '';
+
+SET default_with_oids = false;
+
+--
+-- Name: buildlog; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE buildlog (
+    build_id integer NOT NULL,
+    ebuild_id integer,
+    config character varying(100),
+    "timestamp" timestamp without time zone NOT NULL,
+    error_summary text,
+    build_error text,
+    logfilename text
+);
+
+
+ALTER TABLE public.buildlog OWNER TO pgadmin;
+
+--
+-- Name: buildlog_build_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE buildlog_build_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.buildlog_build_id_seq OWNER TO pgadmin;
+
+--
+-- Name: buildlog_build_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE buildlog_build_id_seq OWNED BY buildlog.build_id;
+
+
+--
+-- Name: buildqueue; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE buildqueue (
+    queue_id integer NOT NULL,
+    ebuild_id integer,
+    config character varying(100),
+    post_message text,
+    "timestamp" timestamp without time zone
+);
+
+
+ALTER TABLE public.buildqueue OWNER TO pgadmin;
+
+--
+-- Name: buildqueue_queue_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE buildqueue_queue_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.buildqueue_queue_id_seq OWNER TO pgadmin;
+
+--
+-- Name: buildqueue_queue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE buildqueue_queue_id_seq OWNED BY buildqueue.queue_id;
+
+
+--
+-- Name: categories; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE categories (
+    category character varying(30) NOT NULL
+);
+
+
+ALTER TABLE public.categories OWNER TO pgadmin;
+
+--
+-- Name: categories_meta; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE categories_meta (
+    category character varying(30) NOT NULL,
+    metadata_xml_checksum character varying(70) NOT NULL,
+    metadata_xml_text text NOT NULL
+);
+
+
+ALTER TABLE public.categories_meta OWNER TO pgadmin;
+
+--
+-- Name: configs; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE configs (
+    id character varying(100) NOT NULL,
+    profile character varying(30) NOT NULL,
+    arch character varying(10) NOT NULL,
+    default_config boolean DEFAULT false NOT NULL,
+    make_conf_text text NOT NULL,
+    make_conf_checksum character varying(80) NOT NULL,
+    active boolean DEFAULT false NOT NULL,
+    config_error text,
+    updateing boolean DEFAULT false NOT NULL,
+    auto boolean DEFAULT true NOT NULL
+);
+
+
+ALTER TABLE public.configs OWNER TO pgadmin;
+
+--
+-- Name: ebuildbuildwithuses; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE ebuildbuildwithuses (
+    id integer NOT NULL,
+    useflag character varying(128),
+    enabled boolean NOT NULL,
+    build_id integer
+);
+
+
+ALTER TABLE public.ebuildbuildwithuses OWNER TO pgadmin;
+
+--
+-- Name: ebuildbuildwithuses_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE ebuildbuildwithuses_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.ebuildbuildwithuses_id_seq OWNER TO pgadmin;
+
+--
+-- Name: ebuildbuildwithuses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE ebuildbuildwithuses_id_seq OWNED BY ebuildbuildwithuses.id;
+
+
+--
+-- Name: ebuildhavesiuses; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE ebuildhavesiuses (
+    id integer NOT NULL,
+    ebuild integer,
+    iuse character varying(128)
+);
+
+
+ALTER TABLE public.ebuildhavesiuses OWNER TO pgadmin;
+
+--
+-- Name: ebuildhavesiuses_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE ebuildhavesiuses_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.ebuildhavesiuses_id_seq OWNER TO pgadmin;
+
+--
+-- Name: ebuildhavesiuses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE ebuildhavesiuses_id_seq OWNED BY ebuildhavesiuses.id;
+
+
+--
+-- Name: ebuildhaveskeywords; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE ebuildhaveskeywords (
+    id integer NOT NULL,
+    ebuild_id integer,
+    keyword character varying(25)
+);
+
+
+ALTER TABLE public.ebuildhaveskeywords OWNER TO pgadmin;
+
+--
+-- Name: ebuildhaveskeywords_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE ebuildhaveskeywords_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.ebuildhaveskeywords_id_seq OWNER TO pgadmin;
+
+--
+-- Name: ebuildhaveskeywords_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE ebuildhaveskeywords_id_seq OWNED BY ebuildhaveskeywords.id;
+
+
+--
+-- Name: ebuildhavesrestrictions; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE ebuildhavesrestrictions (
+    ebuildtorestriction_id integer NOT NULL,
+    ebuild_id integer,
+    restriction character varying(20)
+);
+
+
+ALTER TABLE public.ebuildhavesrestrictions OWNER TO pgadmin;
+
+--
+-- Name: ebuildhavesrestrictions_ebuildtorestriction_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE ebuildhavesrestrictions_ebuildtorestriction_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.ebuildhavesrestrictions_ebuildtorestriction_id_seq OWNER TO pgadmin;
+
+--
+-- Name: ebuildhavesrestrictions_ebuildtorestriction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE ebuildhavesrestrictions_ebuildtorestriction_id_seq OWNED BY ebuildhavesrestrictions.ebuildtorestriction_id;
+
+
+--
+-- Name: ebuildqueuedwithuses; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE ebuildqueuedwithuses (
+    id integer NOT NULL,
+    useflag character varying(128),
+    enabled boolean NOT NULL,
+    queue_id integer
+);
+
+
+ALTER TABLE public.ebuildqueuedwithuses OWNER TO pgadmin;
+
+--
+-- Name: ebuildqueuedwithuses_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE ebuildqueuedwithuses_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.ebuildqueuedwithuses_id_seq OWNER TO pgadmin;
+
+--
+-- Name: ebuildqueuedwithuses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE ebuildqueuedwithuses_id_seq OWNED BY ebuildqueuedwithuses.id;
+
+
+--
+-- Name: ebuilds; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE ebuilds (
+    id integer NOT NULL,
+    package_id integer,
+    ebuild_version character varying(30) NOT NULL,
+    live_version character varying(30) NOT NULL,
+    ebuild_checksum character varying(70) NOT NULL,
+    ebuild_text text,
+    depend text,
+    rdepend text,
+    pdepend text,
+    slot character varying(30),
+    src_url text NOT NULL,
+    homepage text NOT NULL,
+    license text,
+    description text NOT NULL,
+    inherited text,
+    required_use text,
+    provides text,
+    eapi character varying(5) NOT NULL,
+    properties text,
+    defined_phases text,
+    "timestamp" timestamp without time zone,
+    active boolean NOT NULL
+);
+
+
+ALTER TABLE public.ebuilds OWNER TO pgadmin;
+
+--
+-- Name: ebuilds_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE ebuilds_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.ebuilds_id_seq OWNER TO pgadmin;
+
+--
+-- Name: ebuilds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE ebuilds_id_seq OWNED BY ebuilds.id;
+
+
+--
+-- Name: iuses; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE iuses (
+    iuse character varying(128) NOT NULL
+);
+
+
+ALTER TABLE public.iuses OWNER TO pgadmin;
+
+--
+-- Name: keywords; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE keywords (
+    keyword character varying(25) NOT NULL
+);
+
+
+ALTER TABLE public.keywords OWNER TO pgadmin;
+
+--
+-- Name: manifest; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE manifest (
+    id integer NOT NULL,
+    package_id integer,
+    manifest text NOT NULL,
+    checksum character varying(70) NOT NULL
+);
+
+
+ALTER TABLE public.manifest OWNER TO pgadmin;
+
+--
+-- Name: manifest_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE manifest_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.manifest_id_seq OWNER TO pgadmin;
+
+--
+-- Name: manifest_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE manifest_id_seq OWNED BY manifest.id;
+
+
+--
+-- Name: packages; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE packages (
+    package_id integer NOT NULL,
+    category character varying(30),
+    package_name character varying(75) NOT NULL
+);
+
+
+ALTER TABLE public.packages OWNER TO pgadmin;
+
+--
+-- Name: packages_meta; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE packages_meta (
+    package_id integer NOT NULL,
+    changelog_text text,
+    changelog_checksum character varying(70),
+    metadata_text text,
+    metadata_checksum character varying(70)
+);
+
+
+ALTER TABLE public.packages_meta OWNER TO pgadmin;
+
+--
+-- Name: packages_package_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE packages_package_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.packages_package_id_seq OWNER TO pgadmin;
+
+--
+-- Name: packages_package_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE packages_package_id_seq OWNED BY packages.package_id;
+
+
+--
+-- Name: qa_problems; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE qa_problems (
+    id integer NOT NULL,
+    problem text NOT NULL,
+    build_id integer
+);
+
+
+ALTER TABLE public.qa_problems OWNER TO pgadmin;
+
+--
+-- Name: qa_problems_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE qa_problems_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.qa_problems_id_seq OWNER TO pgadmin;
+
+--
+-- Name: qa_problems_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE qa_problems_id_seq OWNED BY qa_problems.id;
+
+
+--
+-- Name: repoman_problems; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE repoman_problems (
+    id integer NOT NULL,
+    problem text NOT NULL,
+    build_id integer
+);
+
+
+ALTER TABLE public.repoman_problems OWNER TO pgadmin;
+
+--
+-- Name: repoman_problems_id_seq; Type: SEQUENCE; Schema: public; Owner: pgadmin
+--
+
+CREATE SEQUENCE repoman_problems_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.repoman_problems_id_seq OWNER TO pgadmin;
+
+--
+-- Name: repoman_problems_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgadmin
+--
+
+ALTER SEQUENCE repoman_problems_id_seq OWNED BY repoman_problems.id;
+
+
+--
+-- Name: restrictions; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE restrictions (
+    restriction_name character varying(20) NOT NULL
+);
+
+
+ALTER TABLE public.restrictions OWNER TO pgadmin;
+
+--
+-- Name: useflags; Type: TABLE; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE TABLE useflags (
+    useflag character varying(128) NOT NULL
+);
+
+
+ALTER TABLE public.useflags OWNER TO pgadmin;
+
+--
+-- Name: build_id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE buildlog ALTER COLUMN build_id SET DEFAULT nextval('buildlog_build_id_seq'::regclass);
+
+
+--
+-- Name: queue_id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE buildqueue ALTER COLUMN queue_id SET DEFAULT nextval('buildqueue_queue_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ebuildbuildwithuses ALTER COLUMN id SET DEFAULT nextval('ebuildbuildwithuses_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ebuildhavesiuses ALTER COLUMN id SET DEFAULT nextval('ebuildhavesiuses_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ebuildhaveskeywords ALTER COLUMN id SET DEFAULT nextval('ebuildhaveskeywords_id_seq'::regclass);
+
+
+--
+-- Name: ebuildtorestriction_id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ebuildhavesrestrictions ALTER COLUMN ebuildtorestriction_id SET DEFAULT nextval('ebuildhavesrestrictions_ebuildtorestriction_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ebuildqueuedwithuses ALTER COLUMN id SET DEFAULT nextval('ebuildqueuedwithuses_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ebuilds ALTER COLUMN id SET DEFAULT nextval('ebuilds_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE manifest ALTER COLUMN id SET DEFAULT nextval('manifest_id_seq'::regclass);
+
+
+--
+-- Name: package_id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE packages ALTER COLUMN package_id SET DEFAULT nextval('packages_package_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE qa_problems ALTER COLUMN id SET DEFAULT nextval('qa_problems_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE repoman_problems ALTER COLUMN id SET DEFAULT nextval('repoman_problems_id_seq'::regclass);
+
+
+--
+-- Name: buildlog_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY buildlog
+    ADD CONSTRAINT buildlog_pkey PRIMARY KEY (build_id);
+
+
+--
+-- Name: buildqueue_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY buildqueue
+    ADD CONSTRAINT buildqueue_pkey PRIMARY KEY (queue_id);
+
+
+--
+-- Name: categories_meta_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY categories_meta
+    ADD CONSTRAINT categories_meta_pkey PRIMARY KEY (category);
+
+
+--
+-- Name: categories_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY categories
+    ADD CONSTRAINT categories_pkey PRIMARY KEY (category);
+
+
+--
+-- Name: configs_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY configs
+    ADD CONSTRAINT configs_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: ebuildbuildwithuses_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY ebuildbuildwithuses
+    ADD CONSTRAINT ebuildbuildwithuses_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: ebuildhavesiuses_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY ebuildhavesiuses
+    ADD CONSTRAINT ebuildhavesiuses_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: ebuildhaveskeywords_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY ebuildhaveskeywords
+    ADD CONSTRAINT ebuildhaveskeywords_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: ebuildhavesrestrictions_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY ebuildhavesrestrictions
+    ADD CONSTRAINT ebuildhavesrestrictions_pkey PRIMARY KEY (ebuildtorestriction_id);
+
+
+--
+-- Name: ebuildqueuedwithuses_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY ebuildqueuedwithuses
+    ADD CONSTRAINT ebuildqueuedwithuses_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: ebuilds_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY ebuilds
+    ADD CONSTRAINT ebuilds_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: iuses_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY iuses
+    ADD CONSTRAINT iuses_pkey PRIMARY KEY (iuse);
+
+
+--
+-- Name: keywords_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY keywords
+    ADD CONSTRAINT keywords_pkey PRIMARY KEY (keyword);
+
+
+--
+-- Name: manifest_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY manifest
+    ADD CONSTRAINT manifest_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: packages_meta_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY packages_meta
+    ADD CONSTRAINT packages_meta_pkey PRIMARY KEY (package_id);
+
+
+--
+-- Name: packages_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY packages
+    ADD CONSTRAINT packages_pkey PRIMARY KEY (package_id);
+
+
+--
+-- Name: qa_problems_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY qa_problems
+    ADD CONSTRAINT qa_problems_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: repoman_problems_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY repoman_problems
+    ADD CONSTRAINT repoman_problems_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: restrictions_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY restrictions
+    ADD CONSTRAINT restrictions_pkey PRIMARY KEY (restriction_name);
+
+
+--
+-- Name: useflags_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+ALTER TABLE ONLY useflags
+    ADD CONSTRAINT useflags_pkey PRIMARY KEY (useflag);
+
+
+--
+-- Name: ebuilbuildwithuses_buildlog_idx; Type: INDEX; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE INDEX ebuilbuildwithuses_buildlog_idx ON ebuildbuildwithuses USING btree (build_id);
+
+
+--
+-- Name: ebuils_package_id_idx; Type: INDEX; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE INDEX ebuils_package_id_idx ON ebuilds USING btree (package_id);
+
+
+--
+-- Name: packages_category_idx; Type: INDEX; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE INDEX packages_category_idx ON packages USING btree (category);
+
+
+--
+-- Name: packages_name_idx; Type: INDEX; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE INDEX packages_name_idx ON packages USING btree (package_name);
+
+
+--
+-- Name: qa_problems_buildlog_idx; Type: INDEX; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE INDEX qa_problems_buildlog_idx ON qa_problems USING btree (build_id);
+
+
+--
+-- Name: repoman_problems_buildlog_idx; Type: INDEX; Schema: public; Owner: pgadmin; Tablespace: 
+--
+
+CREATE INDEX repoman_problems_buildlog_idx ON repoman_problems USING btree (build_id);
+
+
+--
+-- Name: buildlog_config_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY buildlog
+    ADD CONSTRAINT buildlog_config_fkey FOREIGN KEY (config) REFERENCES configs(id);
+
+
+--
+-- Name: buildlog_ebuild_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY buildlog
+    ADD CONSTRAINT buildlog_ebuild_id_fkey FOREIGN KEY (ebuild_id) REFERENCES ebuilds(id);
+
+
+--
+-- Name: buildqueue_config_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY buildqueue
+    ADD CONSTRAINT buildqueue_config_fkey FOREIGN KEY (config) REFERENCES configs(id);
+
+
+--
+-- Name: buildqueue_ebuild_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY buildqueue
+    ADD CONSTRAINT buildqueue_ebuild_id_fkey FOREIGN KEY (ebuild_id) REFERENCES ebuilds(id);
+
+
+--
+-- Name: categories_meta_category_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY categories_meta
+    ADD CONSTRAINT categories_meta_category_fkey FOREIGN KEY (category) REFERENCES categories(category);
+
+
+--
+-- Name: ebuildbuildwithuses_build_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuildbuildwithuses
+    ADD CONSTRAINT ebuildbuildwithuses_build_id_fkey FOREIGN KEY (build_id) REFERENCES buildlog(build_id);
+
+
+--
+-- Name: ebuildbuildwithuses_useflag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuildbuildwithuses
+    ADD CONSTRAINT ebuildbuildwithuses_useflag_fkey FOREIGN KEY (useflag) REFERENCES useflags(useflag);
+
+
+--
+-- Name: ebuildhavesiuses_ebuild_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuildhavesiuses
+    ADD CONSTRAINT ebuildhavesiuses_ebuild_fkey FOREIGN KEY (ebuild) REFERENCES ebuilds(id);
+
+
+--
+-- Name: ebuildhavesiuses_iuse_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuildhavesiuses
+    ADD CONSTRAINT ebuildhavesiuses_iuse_fkey FOREIGN KEY (iuse) REFERENCES iuses(iuse);
+
+
+--
+-- Name: ebuildhaveskeywords_ebuild_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuildhaveskeywords
+    ADD CONSTRAINT ebuildhaveskeywords_ebuild_id_fkey FOREIGN KEY (ebuild_id) REFERENCES ebuilds(id);
+
+
+--
+-- Name: ebuildhaveskeywords_keyword_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuildhaveskeywords
+    ADD CONSTRAINT ebuildhaveskeywords_keyword_fkey FOREIGN KEY (keyword) REFERENCES keywords(keyword);
+
+
+--
+-- Name: ebuildhavesrestrictions_ebuild_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuildhavesrestrictions
+    ADD CONSTRAINT ebuildhavesrestrictions_ebuild_id_fkey FOREIGN KEY (ebuild_id) REFERENCES ebuilds(id);
+
+
+--
+-- Name: ebuildhavesrestrictions_restriction_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuildhavesrestrictions
+    ADD CONSTRAINT ebuildhavesrestrictions_restriction_fkey FOREIGN KEY (restriction) REFERENCES restrictions(restriction_name);
+
+
+--
+-- Name: ebuildqueuedwithuses_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuildqueuedwithuses
+    ADD CONSTRAINT ebuildqueuedwithuses_queue_id_fkey FOREIGN KEY (queue_id) REFERENCES buildqueue(queue_id);
+
+
+--
+-- Name: ebuildqueuedwithuses_useflag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuildqueuedwithuses
+    ADD CONSTRAINT ebuildqueuedwithuses_useflag_fkey FOREIGN KEY (useflag) REFERENCES useflags(useflag);
+
+
+--
+-- Name: ebuilds_package_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY ebuilds
+    ADD CONSTRAINT ebuilds_package_id_fkey FOREIGN KEY (package_id) REFERENCES packages(package_id);
+
+
+--
+-- Name: manifest_package_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY manifest
+    ADD CONSTRAINT manifest_package_id_fkey FOREIGN KEY (package_id) REFERENCES packages(package_id);
+
+
+--
+-- Name: packages_category_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY packages
+    ADD CONSTRAINT packages_category_fkey FOREIGN KEY (category) REFERENCES categories(category);
+
+
+--
+-- Name: packages_meta_package_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY packages_meta
+    ADD CONSTRAINT packages_meta_package_id_fkey FOREIGN KEY (package_id) REFERENCES packages(package_id);
+
+
+--
+-- Name: qa_problems_build_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY qa_problems
+    ADD CONSTRAINT qa_problems_build_id_fkey FOREIGN KEY (build_id) REFERENCES buildlog(build_id);
+
+
+--
+-- Name: repoman_problems_build_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: pgadmin
+--
+
+ALTER TABLE ONLY repoman_problems
+    ADD CONSTRAINT repoman_problems_build_id_fkey FOREIGN KEY (build_id) REFERENCES buildlog(build_id);
+
+
+--
+-- Name: public; Type: ACL; Schema: -; Owner: postgres
+--
+
+REVOKE ALL ON SCHEMA public FROM PUBLIC;
+REVOKE ALL ON SCHEMA public FROM postgres;
+GRANT ALL ON SCHEMA public TO postgres;
+GRANT ALL ON SCHEMA public TO PUBLIC;
+GRANT ALL ON SCHEMA public TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: comparearrays(anyarray, anyarray); Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON FUNCTION comparearrays(oldarray anyarray, newarray anyarray) FROM PUBLIC;
+REVOKE ALL ON FUNCTION comparearrays(oldarray anyarray, newarray anyarray) FROM pgadmin;
+GRANT ALL ON FUNCTION comparearrays(oldarray anyarray, newarray anyarray) TO pgadmin;
+GRANT ALL ON FUNCTION comparearrays(oldarray anyarray, newarray anyarray) TO PUBLIC;
+GRANT ALL ON FUNCTION comparearrays(oldarray anyarray, newarray anyarray) TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: insert_buildqueue(integer, character varying, character varying[], boolean[], text); Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON FUNCTION insert_buildqueue(ebuildid integer, buildhost character varying, inuseflags character varying[], inenabled boolean[], message text) FROM PUBLIC;
+REVOKE ALL ON FUNCTION insert_buildqueue(ebuildid integer, buildhost character varying, inuseflags character varying[], inenabled boolean[], message text) FROM pgadmin;
+GRANT ALL ON FUNCTION insert_buildqueue(ebuildid integer, buildhost character varying, inuseflags character varying[], inenabled boolean[], message text) TO pgadmin;
+GRANT ALL ON FUNCTION insert_buildqueue(ebuildid integer, buildhost character varying, inuseflags character varying[], inenabled boolean[], message text) TO PUBLIC;
+GRANT ALL ON FUNCTION insert_buildqueue(ebuildid integer, buildhost character varying, inuseflags character varying[], inenabled boolean[], message text) TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: updateiuse(integer, character varying[]); Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON FUNCTION updateiuse(ebuildid integer, iniuses character varying[]) FROM PUBLIC;
+REVOKE ALL ON FUNCTION updateiuse(ebuildid integer, iniuses character varying[]) FROM pgadmin;
+GRANT ALL ON FUNCTION updateiuse(ebuildid integer, iniuses character varying[]) TO pgadmin;
+GRANT ALL ON FUNCTION updateiuse(ebuildid integer, iniuses character varying[]) TO PUBLIC;
+GRANT ALL ON FUNCTION updateiuse(ebuildid integer, iniuses character varying[]) TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: updatekeywords(integer, character varying[]); Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON FUNCTION updatekeywords(ebuildid integer, inkeywords character varying[]) FROM PUBLIC;
+REVOKE ALL ON FUNCTION updatekeywords(ebuildid integer, inkeywords character varying[]) FROM pgadmin;
+GRANT ALL ON FUNCTION updatekeywords(ebuildid integer, inkeywords character varying[]) TO pgadmin;
+GRANT ALL ON FUNCTION updatekeywords(ebuildid integer, inkeywords character varying[]) TO PUBLIC;
+GRANT ALL ON FUNCTION updatekeywords(ebuildid integer, inkeywords character varying[]) TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: updaterestrictions(integer, character varying[]); Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON FUNCTION updaterestrictions(ebuildid integer, inrestrictions character varying[]) FROM PUBLIC;
+REVOKE ALL ON FUNCTION updaterestrictions(ebuildid integer, inrestrictions character varying[]) FROM pgadmin;
+GRANT ALL ON FUNCTION updaterestrictions(ebuildid integer, inrestrictions character varying[]) TO pgadmin;
+GRANT ALL ON FUNCTION updaterestrictions(ebuildid integer, inrestrictions character varying[]) TO PUBLIC;
+GRANT ALL ON FUNCTION updaterestrictions(ebuildid integer, inrestrictions character varying[]) TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: buildlog; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE buildlog FROM PUBLIC;
+REVOKE ALL ON TABLE buildlog FROM pgadmin;
+GRANT ALL ON TABLE buildlog TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,UPDATE ON TABLE buildlog TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: buildlog_build_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE buildlog_build_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE buildlog_build_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE buildlog_build_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE buildlog_build_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: buildqueue; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE buildqueue FROM PUBLIC;
+REVOKE ALL ON TABLE buildqueue FROM pgadmin;
+GRANT ALL ON TABLE buildqueue TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE buildqueue TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: buildqueue_queue_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE buildqueue_queue_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE buildqueue_queue_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE buildqueue_queue_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE buildqueue_queue_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: categories; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE categories FROM PUBLIC;
+REVOKE ALL ON TABLE categories FROM pgadmin;
+GRANT ALL ON TABLE categories TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE categories TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: categories_meta; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE categories_meta FROM PUBLIC;
+REVOKE ALL ON TABLE categories_meta FROM pgadmin;
+GRANT ALL ON TABLE categories_meta TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE categories_meta TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: configs; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE configs FROM PUBLIC;
+REVOKE ALL ON TABLE configs FROM pgadmin;
+GRANT ALL ON TABLE configs TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE configs TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuildbuildwithuses; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE ebuildbuildwithuses FROM PUBLIC;
+REVOKE ALL ON TABLE ebuildbuildwithuses FROM pgadmin;
+GRANT ALL ON TABLE ebuildbuildwithuses TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE ebuildbuildwithuses TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuildbuildwithuses_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE ebuildbuildwithuses_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE ebuildbuildwithuses_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE ebuildbuildwithuses_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE ebuildbuildwithuses_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuildhavesiuses; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE ebuildhavesiuses FROM PUBLIC;
+REVOKE ALL ON TABLE ebuildhavesiuses FROM pgadmin;
+GRANT ALL ON TABLE ebuildhavesiuses TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE ebuildhavesiuses TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuildhavesiuses_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE ebuildhavesiuses_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE ebuildhavesiuses_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE ebuildhavesiuses_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE ebuildhavesiuses_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuildhaveskeywords; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE ebuildhaveskeywords FROM PUBLIC;
+REVOKE ALL ON TABLE ebuildhaveskeywords FROM pgadmin;
+GRANT ALL ON TABLE ebuildhaveskeywords TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE ebuildhaveskeywords TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuildhaveskeywords_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE ebuildhaveskeywords_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE ebuildhaveskeywords_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE ebuildhaveskeywords_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE ebuildhaveskeywords_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuildhavesrestrictions; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE ebuildhavesrestrictions FROM PUBLIC;
+REVOKE ALL ON TABLE ebuildhavesrestrictions FROM pgadmin;
+GRANT ALL ON TABLE ebuildhavesrestrictions TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE ebuildhavesrestrictions TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuildhavesrestrictions_ebuildtorestriction_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE ebuildhavesrestrictions_ebuildtorestriction_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE ebuildhavesrestrictions_ebuildtorestriction_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE ebuildhavesrestrictions_ebuildtorestriction_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE ebuildhavesrestrictions_ebuildtorestriction_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuildqueuedwithuses; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE ebuildqueuedwithuses FROM PUBLIC;
+REVOKE ALL ON TABLE ebuildqueuedwithuses FROM pgadmin;
+GRANT ALL ON TABLE ebuildqueuedwithuses TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE ebuildqueuedwithuses TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuildqueuedwithuses_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE ebuildqueuedwithuses_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE ebuildqueuedwithuses_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE ebuildqueuedwithuses_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE ebuildqueuedwithuses_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: ebuilds; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE ebuilds FROM PUBLIC;
+REVOKE ALL ON TABLE ebuilds FROM pgadmin;
+GRANT ALL ON TABLE ebuilds TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE ebuilds TO buildhost WITH GRANT OPTION;
 
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
+--
+-- Name: ebuilds_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE ebuilds_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE ebuilds_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE ebuilds_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE ebuilds_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: iuses; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE iuses FROM PUBLIC;
+REVOKE ALL ON TABLE iuses FROM pgadmin;
+GRANT ALL ON TABLE iuses TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE iuses TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: keywords; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE keywords FROM PUBLIC;
+REVOKE ALL ON TABLE keywords FROM pgadmin;
+GRANT ALL ON TABLE keywords TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE keywords TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: manifest; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE manifest FROM PUBLIC;
+REVOKE ALL ON TABLE manifest FROM pgadmin;
+GRANT ALL ON TABLE manifest TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE manifest TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: manifest_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE manifest_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE manifest_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE manifest_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE manifest_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: packages; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE packages FROM PUBLIC;
+REVOKE ALL ON TABLE packages FROM pgadmin;
+GRANT ALL ON TABLE packages TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE packages TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: packages_meta; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE packages_meta FROM PUBLIC;
+REVOKE ALL ON TABLE packages_meta FROM pgadmin;
+GRANT ALL ON TABLE packages_meta TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE packages_meta TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: packages_package_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE packages_package_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE packages_package_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE packages_package_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE packages_package_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: qa_problems; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE qa_problems FROM PUBLIC;
+REVOKE ALL ON TABLE qa_problems FROM pgadmin;
+GRANT ALL ON TABLE qa_problems TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE qa_problems TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: qa_problems_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE qa_problems_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE qa_problems_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE qa_problems_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE qa_problems_id_seq TO buildhost WITH GRANT OPTION;
 
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
 
 --
--- Databas: `buildhost`
+-- Name: repoman_problems; Type: ACL; Schema: public; Owner: pgadmin
 --
 
--- --------------------------------------------------------
+REVOKE ALL ON TABLE repoman_problems FROM PUBLIC;
+REVOKE ALL ON TABLE repoman_problems FROM pgadmin;
+GRANT ALL ON TABLE repoman_problems TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE repoman_problems TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: repoman_problems_id_seq; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON SEQUENCE repoman_problems_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE repoman_problems_id_seq FROM pgadmin;
+GRANT ALL ON SEQUENCE repoman_problems_id_seq TO pgadmin;
+GRANT SELECT,UPDATE ON SEQUENCE repoman_problems_id_seq TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: restrictions; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE restrictions FROM PUBLIC;
+REVOKE ALL ON TABLE restrictions FROM pgadmin;
+GRANT ALL ON TABLE restrictions TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE restrictions TO buildhost WITH GRANT OPTION;
+
+
+--
+-- Name: useflags; Type: ACL; Schema: public; Owner: pgadmin
+--
+
+REVOKE ALL ON TABLE useflags FROM PUBLIC;
+REVOKE ALL ON TABLE useflags FROM pgadmin;
+GRANT ALL ON TABLE useflags TO pgadmin;
+GRANT SELECT,INSERT,REFERENCES,DELETE,UPDATE ON TABLE useflags TO buildhost WITH GRANT OPTION;
+
 
 --
--- Struktur för tabell `buildlog`
+-- PostgreSQL database dump complete
 --
 
-CREATE TABLE IF NOT EXISTS `buildlog` (
-  `categories` varchar(20) NOT NULL,
-  `package` varchar(50) NOT NULL,
-  `ebuild_version` varchar(30) NOT NULL,
-  `qa` text NOT NULL,
-  `repoman` text NOT NULL,
-  `build` text NOT NULL,
-  `buildlog_name` varchar(50) NOT NULL,
-  `useflags` text NOT NULL,
-  `config` varchar(20) NOT NULL,
-  `hosts` varchar(30) NOT NULL,
-  `index2` int(20) NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (`index2`),
-  KEY `ebuild_version` (`ebuild_version`),
-  KEY `packages` (`package`),
-  KEY `categories` (`categories`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Struktur för tabell `buildqueru`
---
-
-CREATE TABLE IF NOT EXISTS `buildqueru` (
-  `categories` varchar(20) NOT NULL,
-  `package` varchar(50) NOT NULL,
-  `ebuild_version` varchar(30) NOT NULL,
-  `ebuild_version_checksum` varchar(70) NOT NULL,
-  `use_flags` text NOT NULL,
-  `use_checksum` varchar(70) NOT NULL,
-  `config` varchar(20) NOT NULL,
-  `hosts` varchar(50) NOT NULL,
-  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  `index2` int(20) NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (`index2`),
-  KEY `package` (`package`),
-  KEY `ebuild_version` (`ebuild_version`),
-  KEY `category` (`categories`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Struktur för tabell `categories`
---
-
-CREATE TABLE IF NOT EXISTS `categories` (
-  `categories` varchar(30) NOT NULL,
-  `metadata_xml_checksum` varchar(70) NOT NULL,
-  `metadata_xml_text` text NOT NULL,
-  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  `active` tinyint(1) NOT NULL DEFAULT '1',
-  `index2` int(20) NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (`index2`),
-  KEY `categories` (`categories`),
-  KEY `checksum` (`metadata_xml_checksum`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Struktur för tabell `configs`
---
-
-CREATE TABLE IF NOT EXISTS `configs` (
-  `profiles` varchar(30) NOT NULL,
-  `arch` varchar(20) NOT NULL,
-  `config` varchar(20) NOT NULL,
-  `hosts` varchar(30) NOT NULL,
-  `default_config` tinyint(1) NOT NULL DEFAULT '0',
-  `make_conf_text` mediumtext NOT NULL,
-  `make_conf_checksum` varchar(80) NOT NULL,
-  `active` tinyint(1) NOT NULL DEFAULT '0',
-  `config_error` text NOT NULL,
-  `updateing` tinyint(1) NOT NULL DEFAULT '0',
-  `index2` int(20) NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (`index2`),
-  KEY `config` (`config`),
-  KEY `profiles` (`profiles`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Struktur för tabell `ebuild`
---
-
-CREATE TABLE IF NOT EXISTS `ebuild` (
-  `categories` varchar(20) NOT NULL,
-  `package` varchar(50) NOT NULL,
-  `ebuild_version` varchar(30) NOT NULL,
-  `ebuild_checksum` varchar(70) NOT NULL,
-  `ebuild_text` mediumtext NOT NULL,
-  `depend` text NOT NULL,
-  `rdepend` text NOT NULL,
-  `slot` varchar(15) NOT NULL,
-  `src_url` mediumtext NOT NULL,
-  `restricted` text NOT NULL,
-  `homepage` text NOT NULL,
-  `license` text NOT NULL,
-  `description` text NOT NULL,
-  `keywords` text NOT NULL,
-  `inherited` text NOT NULL,
-  `iuse` text NOT NULL,
-  `required_use` text NOT NULL,
-  `pdepend` text NOT NULL,
-  `provide` text NOT NULL,
-  `eapi` varchar(5) NOT NULL,
-  `properties` text NOT NULL,
-  `defined_phases` text NOT NULL,
-  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  `active` tinyint(1) NOT NULL DEFAULT '1',
-  `index2` int(20) NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (`index2`),
-  KEY `package` (`package`),
-  KEY `ebuild_version` (`ebuild_version`),
-  KEY `category` (`categories`),
-  KEY `ebuild_checksum` (`ebuild_checksum`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Struktur för tabell `package`
---
-
-CREATE TABLE IF NOT EXISTS `package` (
-  `categories` varchar(20) NOT NULL,
-  `package` varchar(50) NOT NULL,
-  `manifest_checksum` varchar(70) NOT NULL,
-  `changelog_checksum` varchar(70) NOT NULL,
-  `changelog_text` mediumtext NOT NULL,
-  `metadata_xml_checksum` varchar(70) NOT NULL,
-  `metadata_xml_text` text NOT NULL,
-  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  `active` tinyint(1) NOT NULL DEFAULT '1',
-  `index2` int(20) NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (`index2`),
-  KEY `category` (`categories`),
-  KEY `changelog_checksum` (`changelog_checksum`),
-  KEY `metadata_xml_checksum` (`metadata_xml_checksum`),
-  KEY `package` (`package`),
-  KEY `manifest_checksum` (`manifest_checksum`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8;