From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1Q5hR9-00061m-5p for garchives@archives.gentoo.org; Fri, 01 Apr 2011 16:43:03 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id EF59C1C027; Fri, 1 Apr 2011 16:42:40 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by pigeon.gentoo.org (Postfix) with ESMTP id 575C81C024 for ; Fri, 1 Apr 2011 16:42:40 +0000 (UTC) Received: from pelican.gentoo.org (unknown [66.219.59.40]) (using TLSv1 with cipher ADH-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTPS id AA4601B4035 for ; Fri, 1 Apr 2011 16:42:39 +0000 (UTC) Received: from localhost.localdomain (localhost [127.0.0.1]) by pelican.gentoo.org (Postfix) with ESMTP id 169EB8006D for ; Fri, 1 Apr 2011 16:42:39 +0000 (UTC) From: "Magnus Granberg" To: gentoo-commits@lists.gentoo.org Content-type: text/plain; charset=UTF-8 Reply-To: gentoo-dev@lists.gentoo.org, "Magnus Granberg" Message-ID: <34da8ef69fef9613e388db883bf16fdf7a8f712b.zorry@gentoo> Subject: [gentoo-commits] dev/zorry:master commit in: buildhost/ X-VCS-Repository: dev/zorry X-VCS-Files: buildhost/buildhost.sql X-VCS-Directories: buildhost/ X-VCS-Committer: zorry X-VCS-Committer-Name: Magnus Granberg X-VCS-Revision: 34da8ef69fef9613e388db883bf16fdf7a8f712b Date: Fri, 1 Apr 2011 16:42:39 +0000 (UTC) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-commits@lists.gentoo.org Content-Transfer-Encoding: quoted-printable X-Archives-Salt: X-Archives-Hash: f4c6b743ae7cfd3043c68c6e6dd9a0bd commit: 34da8ef69fef9613e388db883bf16fdf7a8f712b Author: Magnus Granberg gentoo org> AuthorDate: Fri Apr 1 15:18:20 2011 +0000 Commit: Magnus Granberg gentoo org> CommitDate: Fri Apr 1 15:18:20 2011 +0000 URL: http://git.overlays.gentoo.org/gitweb/?p=3Ddev/zorry.git;a=3D= commit;h=3D34da8ef6 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=C3=A4rd: 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 =3D 0; +SET client_encoding =3D 'UTF8'; +SET standard_conforming_strings =3D off; +SET check_function_bodies =3D false; +SET client_min_messages =3D warning; +SET escape_string_warning =3D 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 =3D 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: publ= ic; Owner: pgadmin +-- + +CREATE FUNCTION comparearrays(oldarray anyarray, newarray anyarray) RETU= RNS anyarray + LANGUAGE plpgsql IMMUTABLE + AS $$ + DECLARE=20 + returnArray oldArray%TYPE; + + BEGIN +--figure out if the new array contians the old one if that is true do no= thing if not iterate over the old array and remove those that isnt in the= new one. + IF oldArray <@ newArray=3DFALSE THEN + FOR i IN array_lower(oldArray,1)..array_upper(oldArray,1) LOOP + IF newArray@> ARRAY[oldArray[i]] =3D 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 tex= t) 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=3Debuil= dID AND config=3Dbuildhost) INTO oldQid; + -- if not NULL check if the useflags have changed if there is any "n= ew" 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 + ); + =20 + 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 versi= on + FOR i IN array_lower(oldQid,1)..array_upper(oldQid,1) LOOP + PERFORM useflag,enabled FROM mid EXCEPT SELECT useflag,enabled FROM ebu= ildQueuedWithUses WHERE queue_id=3DoldQid[i] ORDER BY useflag; + ret:=3DoldQid[i]; + IF NOT FOUND THEN + PERFORM useflag,enabled FROM ebuildQueuedWithUses WHERE queue_id=3Dol= dQid[i] EXCEPT SELECT useflag,enabled FROM mid ORDER BY useflag; + IF FOUND THEN + result:=3DTRUE; + EXIT; =20 + END IF; + ELSE + result:=3DTRUE; + EXIT; + END IF; + END LOOP; + -- if result is null the useflags havent changed then dont add the e= build 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(inU= seFlags[i],inEnabled[i],ret); + END LOOP;=09 + 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(i= nUseFlags[i],inEnabled[i],ret); + END LOOP; +=09 + 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) VALUE= S(ebuildID,buildhost,message,now())RETURNING queue_id INTO ret;=09 + + ELSE + FOR i IN array_lower(oldQid,1)..array_upper(oldQid,1) LOOP + SElECT queue_id FROM buildqueue WHERE queue_id=3DoldQid[i] AND queu= e_id NOT IN(SELECT queue_id FROM ebuildQueuedWithUses WHERE queue_id=3Dol= dQid[i]) INTO ret; + IF FOUND THEN + result=3DTRUE; + 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,times= tamp) VALUES(ebuildID,buildhost,NULL,message,now())RETURNING queue_id INT= O ret; + END IF; +=09 + END IF;=09 + END IF;=20 + END IF; + RETURN ret; + END; +$$; + + +ALTER FUNCTION public.insert_buildqueue(ebuildid integer, buildhost char= acter varying, inuseflags character varying[], inenabled boolean[], messa= ge text) OWNER TO pgadmin; + +-- +-- Name: insert_ebuild(character varying, character varying, character v= arying, character varying, character varying, text, text, text, text, cha= racter varying, text, text, text, text, text, text, text, character varyi= ng, text, text, boolean); Type: FUNCTION; Schema: public; Owner: pgadmin +-- + +CREATE FUNCTION insert_ebuild(incategory character varying, inpackage_na= me character varying, inebuild_version character varying, inlive_version = character varying, inebuild_checksum character varying, inebuild_text tex= t, independ text, inrdepend text, inpdepend text, inslot character varyin= g, insrc_url text, inhomepage text, inlicense text, indescription text, i= ninherited text, inrequired_use text, inprovides text, ineapi character v= arying, inproperties text, indefined_phases text, inactive boolean) RETUR= NS 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=20 + WHERE incategory NOT IN( + SELECT category FROM categories WHERE category=3DinCategory); + + --check if the package exists if not create it + ebuild_package[0]:=3D package_id FROM packages WHERE category=3DinCa= tegory AND package_name=3DinPackage_name; + =20 + IF ebuild_package[0] ISNULL THEN + INSERT INTO packages VALUES(DEFAULT, inCategory, inPackage_name) R= ETURNING package_id INTO var; + ebuild_package[0]:=3Dvar; + END IF; + + IF inActive IS NULL OR inActive IS TRUE THEN + act=3DTRUE; + END IF; + + --insert the new ebuild and put new ebuild ID into a variable and re= turn it + INSERT INTO ebuilds(package_id,ebuild_version,live_version,ebuild_ch= ecksum,ebuild_text,depend,rdepend,pdepend,slot,src_url,homepage,license,d= escription,inherited,required_use,provides,eapi,properties,defined_phases= ,active) + VALUES(ebuild_package[0],inEbuild_version,inLive_version,inEbuild_ch= ecksum,inEbuild_text,inDepend,inRdepend,inPdepend,inSlot,inSrc_url,inHome= page,inLicense,inDescription,inInherited,inRequired_use,inProvides,inEapi= ,inProperties,inDefined_phases,act)=20 + RETURNING id INTO var; + ebuild_package[1]:=3Dvar; +-- if the ebuild was added as active add the current time to the timesta= mp field + =20 + IF act IS TRUE THEN + UPDATE ebuilds SET timestamp=3Dnow() WHERE id=3Debuild_package[1];= =20 + END IF; + + RETURN ebuild_package; + END; +$$; + + +ALTER FUNCTION public.insert_ebuild(incategory character varying, inpack= age_name character varying, inebuild_version character varying, inlive_ve= rsion character varying, inebuild_checksum character varying, inebuild_te= xt text, independ text, inrdepend text, inpdepend text, inslot character = varying, insrc_url text, inhomepage text, inlicense text, indescription t= ext, ininherited text, inrequired_use text, inprovides text, ineapi chara= cter varying, inproperties text, indefined_phases text, inactive boolean)= OWNER TO pgadmin; + +-- +-- Name: updateiuse(integer, character varying[]); Type: FUNCTION; Schem= a: 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=20 + --find all the old iuses (if any) that needs to be deleted + SELECT ARRAY(SELECT iuse FROM ebuildHavesIuses WHERE ebuild=3Debui= ldID) INTO oldIuses; + =20 + + -- IF there is any old iuses we need to find those that needs to b= e 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=3DebuildID AND iuse=3Ddel= etIuses[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(explicitNewIuse= s,1) LOOP + INSERT INTO iuses(iuse) SELECT explicitNewIuses[i]=20 + WHERE explicitNewIuses[i] NOT IN( + SELECT iuse FROM iuses WHERE iuse=3DexplicitNewIuses[i]); +=09 + INSERT INTO ebuildHavesIuses(ebuild,iuse) VALUES(ebuildID, explic= itNewIuses[i]); + END LOOP; + END IF; + ELSE + -- if inIuses is NULL simply delete all isuses=20 + DELETE FROM ebuildHavesIuses WHERE ebuild=3DebuildID; + END IF; + END; + +$$; + + +ALTER FUNCTION public.updateiuse(ebuildid integer, iniuses character var= ying[]) OWNER TO pgadmin; + +-- +-- Name: updatekeywords(integer, character varying[]); Type: FUNCTION; S= chema: public; Owner: pgadmin +-- + +CREATE FUNCTION updatekeywords(ebuildid integer, inkeywords character va= rying[]) RETURNS void + LANGUAGE plpgsql + AS $$ + DECLARE + oldKeywords VARCHAR[]; + deletKeywords VARCHAR[]; + explicitNewKeywords VARCHAR[]; + + BEGIN + + IF inKeywords IS NOT NULL THEN=20 + --find all the old keywords (if any) that needs to be deleted + SELECT ARRAY(SELECT keyword FROM ebuildHavesKeywords WHERE ebuild_= id=3DebuildID) INTO oldKeywords; + + -- IF there is any old keywords we need to find those that needs t= o 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) L= OOP + DELETE FROM ebuildHavesKeywords WHERE ebuild_id=3DebuildID AND keyw= ord=3DdeletKeywords[i]; + END LOOP; + END IF; + -- Find all the new restrictions that isnt present in the oldKeywords a= rray. + 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(explicitNewK= eywords,1) LOOP + INSERT INTO ebuildHavesKeywords(ebuild_id,keyword) VALUES(ebuildI= D, explicitNewKeywords[i]); + END LOOP; + END IF; + ELSE + --if inkeywords is NULL then remove all keywords from the ebuild + DELETE FROM ebuildHavesKeywords WHERE ebuild_id=3DebuildID; + END IF; + END; + +$$; + + +ALTER FUNCTION public.updatekeywords(ebuildid integer, inkeywords charac= ter varying[]) OWNER TO pgadmin; + +-- +-- Name: updaterestrictions(integer, character varying[]); Type: FUNCTIO= N; Schema: public; Owner: pgadmin +-- + +CREATE FUNCTION updaterestrictions(ebuildid integer, inrestrictions char= acter 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=3DebuildID) INTO oldRestrictions; + + -- IF there is any old restrictions we need to find those that nee= ds to be removed (because of updated ebuild etc). + IF oldRestrictions IS NOT NULL THEN + SELECT compareArrays(oldRestrictions,inRestrictions)INTO deletRestricti= ons; + IF deletRestrictions IS NOT NULL THEN + FOR i IN array_lower(deletRestrictions,1)..array_upper(deletRestricti= ons,1) LOOP + DELETE FROM ebuildHavesRestrictions WHERE ebuild_id=3DebuildID AND = restriction=3DdeletRestrictions[i]; + END LOOP; + END IF; + -- Find all the new restrictions that isnt present in the oldRestrictio= ns array. + SELECT compareArrays(inRestrictions,oldRestrictions) INTO explicitNewRe= strictions; + 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(explicit= NewRestrictions,1) LOOP + INSERT INTO restrictions(restriction_name) SELECT explicitNewRes= trictions[i]=20 + WHERE explicitNewRestrictions[i] NOT IN( + SELECT restriction_name FROM restrictions WHERE restriction_name=3De= xplicitNewRestrictions[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=3DebuildID; + END IF; + END; + +$$; + + +ALTER FUNCTION public.updaterestrictions(ebuildid integer, inrestriction= s character varying[]) OWNER TO pgadmin; + +SET default_tablespace =3D ''; + +SET default_with_oids =3D false; + +-- +-- Name: buildlog; Type: TABLE; Schema: public; Owner: pgadmin; Tablespa= ce:=20 +-- + +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: p= gadmin +-- + +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; Tables= pace:=20 +-- + +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: publi= c; Owner: pgadmin +-- + +ALTER SEQUENCE buildqueue_queue_id_seq OWNED BY buildqueue.queue_id; + + +-- +-- Name: categories; Type: TABLE; Schema: public; Owner: pgadmin; Tables= pace:=20 +-- + +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; T= ablespace:=20 +-- + +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; Tablespac= e:=20 +-- + +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: pgadmi= n; Tablespace:=20 +-- + +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; Own= er: 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: pu= blic; Owner: pgadmin +-- + +ALTER SEQUENCE ebuildbuildwithuses_id_seq OWNED BY ebuildbuildwithuses.i= d; + + +-- +-- Name: ebuildhavesiuses; Type: TABLE; Schema: public; Owner: pgadmin; = Tablespace:=20 +-- + +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: publi= c; Owner: pgadmin +-- + +ALTER SEQUENCE ebuildhavesiuses_id_seq OWNED BY ebuildhavesiuses.id; + + +-- +-- Name: ebuildhaveskeywords; Type: TABLE; Schema: public; Owner: pgadmi= n; Tablespace:=20 +-- + +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; Own= er: 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: pu= blic; Owner: pgadmin +-- + +ALTER SEQUENCE ebuildhaveskeywords_id_seq OWNED BY ebuildhaveskeywords.i= d; + + +-- +-- Name: ebuildhavesrestrictions; Type: TABLE; Schema: public; Owner: pg= admin; Tablespace:=20 +-- + +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: SEQUE= NCE; 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 OW= NER TO pgadmin; + +-- +-- Name: ebuildhavesrestrictions_ebuildtorestriction_id_seq; Type: SEQUE= NCE OWNED BY; Schema: public; Owner: pgadmin +-- + +ALTER SEQUENCE ebuildhavesrestrictions_ebuildtorestriction_id_seq OWNED = BY ebuildhavesrestrictions.ebuildtorestriction_id; + + +-- +-- Name: ebuildqueuedwithuses; Type: TABLE; Schema: public; Owner: pgadm= in; Tablespace:=20 +-- + +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; Ow= ner: 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: p= ublic; Owner: pgadmin +-- + +ALTER SEQUENCE ebuildqueuedwithuses_id_seq OWNED BY ebuildqueuedwithuses= .id; + + +-- +-- Name: ebuilds; Type: TABLE; Schema: public; Owner: pgadmin; Tablespac= e:=20 +-- + +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:= =20 +-- + +CREATE TABLE iuses ( + iuse character varying(128) NOT NULL +); + + +ALTER TABLE public.iuses OWNER TO pgadmin; + +-- +-- Name: keywords; Type: TABLE; Schema: public; Owner: pgadmin; Tablespa= ce:=20 +-- + +CREATE TABLE keywords ( + keyword character varying(25) NOT NULL +); + + +ALTER TABLE public.keywords OWNER TO pgadmin; + +-- +-- Name: manifest; Type: TABLE; Schema: public; Owner: pgadmin; Tablespa= ce:=20 +-- + +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; Tablespa= ce:=20 +-- + +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; Tab= lespace:=20 +-- + +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: publi= c; Owner: pgadmin +-- + +ALTER SEQUENCE packages_package_id_seq OWNED BY packages.package_id; + + +-- +-- Name: qa_problems; Type: TABLE; Schema: public; Owner: pgadmin; Table= space:=20 +-- + +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: pgad= min +-- + +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; Ow= ner: pgadmin +-- + +ALTER SEQUENCE qa_problems_id_seq OWNED BY qa_problems.id; + + +-- +-- Name: repoman_problems; Type: TABLE; Schema: public; Owner: pgadmin; = Tablespace:=20 +-- + +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: publi= c; Owner: pgadmin +-- + +ALTER SEQUENCE repoman_problems_id_seq OWNED BY repoman_problems.id; + + +-- +-- Name: restrictions; Type: TABLE; Schema: public; Owner: pgadmin; Tabl= espace:=20 +-- + +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; Tablespa= ce:=20 +-- + +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('buildq= ueue_queue_id_seq'::regclass); + + +-- +-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin +-- + +ALTER TABLE ebuildbuildwithuses ALTER COLUMN id SET DEFAULT nextval('ebu= ildbuildwithuses_id_seq'::regclass); + + +-- +-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin +-- + +ALTER TABLE ebuildhavesiuses ALTER COLUMN id SET DEFAULT nextval('ebuild= havesiuses_id_seq'::regclass); + + +-- +-- Name: id; Type: DEFAULT; Schema: public; Owner: pgadmin +-- + +ALTER TABLE ebuildhaveskeywords ALTER COLUMN id SET DEFAULT nextval('ebu= ildhaveskeywords_id_seq'::regclass); + + +-- +-- Name: ebuildtorestriction_id; Type: DEFAULT; Schema: public; Owner: p= gadmin +-- + +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('eb= uildqueuedwithuses_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_se= q'::regclass); + + +-- +-- Name: package_id; Type: DEFAULT; Schema: public; Owner: pgadmin +-- + +ALTER TABLE packages ALTER COLUMN package_id SET DEFAULT nextval('packag= es_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('repoma= n_problems_id_seq'::regclass); + + +-- +-- Name: buildlog_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin= ; Tablespace:=20 +-- + +ALTER TABLE ONLY buildlog + ADD CONSTRAINT buildlog_pkey PRIMARY KEY (build_id); + + +-- +-- Name: buildqueue_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadm= in; Tablespace:=20 +-- + +ALTER TABLE ONLY buildqueue + ADD CONSTRAINT buildqueue_pkey PRIMARY KEY (queue_id); + + +-- +-- Name: categories_meta_pkey; Type: CONSTRAINT; Schema: public; Owner: = pgadmin; Tablespace:=20 +-- + +ALTER TABLE ONLY categories_meta + ADD CONSTRAINT categories_meta_pkey PRIMARY KEY (category); + + +-- +-- Name: categories_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadm= in; Tablespace:=20 +-- + +ALTER TABLE ONLY categories + ADD CONSTRAINT categories_pkey PRIMARY KEY (category); + + +-- +-- Name: configs_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin;= Tablespace:=20 +-- + +ALTER TABLE ONLY configs + ADD CONSTRAINT configs_pkey PRIMARY KEY (id); + + +-- +-- Name: ebuildbuildwithuses_pkey; Type: CONSTRAINT; Schema: public; Own= er: pgadmin; Tablespace:=20 +-- + +ALTER TABLE ONLY ebuildbuildwithuses + ADD CONSTRAINT ebuildbuildwithuses_pkey PRIMARY KEY (id); + + +-- +-- Name: ebuildhavesiuses_pkey; Type: CONSTRAINT; Schema: public; Owner:= pgadmin; Tablespace:=20 +-- + +ALTER TABLE ONLY ebuildhavesiuses + ADD CONSTRAINT ebuildhavesiuses_pkey PRIMARY KEY (id); + + +-- +-- Name: ebuildhaveskeywords_pkey; Type: CONSTRAINT; Schema: public; Own= er: pgadmin; Tablespace:=20 +-- + +ALTER TABLE ONLY ebuildhaveskeywords + ADD CONSTRAINT ebuildhaveskeywords_pkey PRIMARY KEY (id); + + +-- +-- Name: ebuildhavesrestrictions_pkey; Type: CONSTRAINT; Schema: public;= Owner: pgadmin; Tablespace:=20 +-- + +ALTER TABLE ONLY ebuildhavesrestrictions + ADD CONSTRAINT ebuildhavesrestrictions_pkey PRIMARY KEY (ebuildtores= triction_id); + + +-- +-- Name: ebuildqueuedwithuses_pkey; Type: CONSTRAINT; Schema: public; Ow= ner: pgadmin; Tablespace:=20 +-- + +ALTER TABLE ONLY ebuildqueuedwithuses + ADD CONSTRAINT ebuildqueuedwithuses_pkey PRIMARY KEY (id); + + +-- +-- Name: ebuilds_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin;= Tablespace:=20 +-- + +ALTER TABLE ONLY ebuilds + ADD CONSTRAINT ebuilds_pkey PRIMARY KEY (id); + + +-- +-- Name: iuses_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin; T= ablespace:=20 +-- + +ALTER TABLE ONLY iuses + ADD CONSTRAINT iuses_pkey PRIMARY KEY (iuse); + + +-- +-- Name: keywords_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin= ; Tablespace:=20 +-- + +ALTER TABLE ONLY keywords + ADD CONSTRAINT keywords_pkey PRIMARY KEY (keyword); + + +-- +-- Name: manifest_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin= ; Tablespace:=20 +-- + +ALTER TABLE ONLY manifest + ADD CONSTRAINT manifest_pkey PRIMARY KEY (id); + + +-- +-- Name: packages_meta_pkey; Type: CONSTRAINT; Schema: public; Owner: pg= admin; Tablespace:=20 +-- + +ALTER TABLE ONLY packages_meta + ADD CONSTRAINT packages_meta_pkey PRIMARY KEY (package_id); + + +-- +-- Name: packages_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin= ; Tablespace:=20 +-- + +ALTER TABLE ONLY packages + ADD CONSTRAINT packages_pkey PRIMARY KEY (package_id); + + +-- +-- Name: qa_problems_pkey; Type: CONSTRAINT; Schema: public; Owner: pgad= min; Tablespace:=20 +-- + +ALTER TABLE ONLY qa_problems + ADD CONSTRAINT qa_problems_pkey PRIMARY KEY (id); + + +-- +-- Name: repoman_problems_pkey; Type: CONSTRAINT; Schema: public; Owner:= pgadmin; Tablespace:=20 +-- + +ALTER TABLE ONLY repoman_problems + ADD CONSTRAINT repoman_problems_pkey PRIMARY KEY (id); + + +-- +-- Name: restrictions_pkey; Type: CONSTRAINT; Schema: public; Owner: pga= dmin; Tablespace:=20 +-- + +ALTER TABLE ONLY restrictions + ADD CONSTRAINT restrictions_pkey PRIMARY KEY (restriction_name); + + +-- +-- Name: useflags_pkey; Type: CONSTRAINT; Schema: public; Owner: pgadmin= ; Tablespace:=20 +-- + +ALTER TABLE ONLY useflags + ADD CONSTRAINT useflags_pkey PRIMARY KEY (useflag); + + +-- +-- Name: ebuilbuildwithuses_buildlog_idx; Type: INDEX; Schema: public; O= wner: pgadmin; Tablespace:=20 +-- + +CREATE INDEX ebuilbuildwithuses_buildlog_idx ON ebuildbuildwithuses USIN= G btree (build_id); + + +-- +-- Name: ebuils_package_id_idx; Type: INDEX; Schema: public; Owner: pgad= min; Tablespace:=20 +-- + +CREATE INDEX ebuils_package_id_idx ON ebuilds USING btree (package_id); + + +-- +-- Name: packages_category_idx; Type: INDEX; Schema: public; Owner: pgad= min; Tablespace:=20 +-- + +CREATE INDEX packages_category_idx ON packages USING btree (category); + + +-- +-- Name: packages_name_idx; Type: INDEX; Schema: public; Owner: pgadmin;= Tablespace:=20 +-- + +CREATE INDEX packages_name_idx ON packages USING btree (package_name); + + +-- +-- Name: qa_problems_buildlog_idx; Type: INDEX; Schema: public; Owner: p= gadmin; Tablespace:=20 +-- + +CREATE INDEX qa_problems_buildlog_idx ON qa_problems USING btree (build_= id); + + +-- +-- Name: repoman_problems_buildlog_idx; Type: INDEX; Schema: public; Own= er: pgadmin; Tablespace:=20 +-- + +CREATE INDEX repoman_problems_buildlog_idx ON repoman_problems USING btr= ee (build_id); + + +-- +-- Name: buildlog_config_fkey; Type: FK CONSTRAINT; Schema: public; Owne= r: 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; O= wner: pgadmin +-- + +ALTER TABLE ONLY buildlog + ADD CONSTRAINT buildlog_ebuild_id_fkey FOREIGN KEY (ebuild_id) REFER= ENCES ebuilds(id); + + +-- +-- Name: buildqueue_config_fkey; Type: FK CONSTRAINT; Schema: public; Ow= ner: pgadmin +-- + +ALTER TABLE ONLY buildqueue + ADD CONSTRAINT buildqueue_config_fkey FOREIGN KEY (config) REFERENCE= S 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) REF= ERENCES ebuilds(id); + + +-- +-- Name: categories_meta_category_fkey; Type: FK CONSTRAINT; Schema: pub= lic; 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: publ= ic; Owner: pgadmin +-- + +ALTER TABLE ONLY ebuildhavesiuses + ADD CONSTRAINT ebuildhavesiuses_ebuild_fkey FOREIGN KEY (ebuild) REF= ERENCES 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) REFEREN= CES 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 (ebuil= d_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; Sc= hema: public; Owner: pgadmin +-- + +ALTER TABLE ONLY ebuildhavesrestrictions + ADD CONSTRAINT ebuildhavesrestrictions_ebuild_id_fkey FOREIGN KEY (e= build_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 (usefla= g) REFERENCES useflags(useflag); + + +-- +-- Name: ebuilds_package_id_fkey; Type: FK CONSTRAINT; Schema: public; O= wner: pgadmin +-- + +ALTER TABLE ONLY ebuilds + ADD CONSTRAINT ebuilds_package_id_fkey FOREIGN KEY (package_id) REFE= RENCES 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) REF= ERENCES packages(package_id); + + +-- +-- Name: packages_category_fkey; Type: FK CONSTRAINT; Schema: public; Ow= ner: pgadmin +-- + +ALTER TABLE ONLY packages + ADD CONSTRAINT packages_category_fkey FOREIGN KEY (category) REFEREN= CES categories(category); + + +-- +-- Name: packages_meta_package_id_fkey; Type: FK CONSTRAINT; Schema: pub= lic; 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) REFE= RENCES buildlog(build_id); + + +-- +-- Name: repoman_problems_build_id_fkey; Type: FK CONSTRAINT; Schema: pu= blic; 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; O= wner: pgadmin +-- + +REVOKE ALL ON FUNCTION comparearrays(oldarray anyarray, newarray anyarra= y) FROM PUBLIC; +REVOKE ALL ON FUNCTION comparearrays(oldarray anyarray, newarray anyarra= y) 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 cha= racter varying, inuseflags character varying[], inenabled boolean[], mess= age text) FROM PUBLIC; +REVOKE ALL ON FUNCTION insert_buildqueue(ebuildid integer, buildhost cha= racter varying, inuseflags character varying[], inenabled boolean[], mess= age text) FROM pgadmin; +GRANT ALL ON FUNCTION insert_buildqueue(ebuildid integer, buildhost char= acter varying, inuseflags character varying[], inenabled boolean[], messa= ge text) TO pgadmin; +GRANT ALL ON FUNCTION insert_buildqueue(ebuildid integer, buildhost char= acter varying, inuseflags character varying[], inenabled boolean[], messa= ge text) TO PUBLIC; +GRANT ALL ON FUNCTION insert_buildqueue(ebuildid integer, buildhost char= acter varying, inuseflags character varying[], inenabled boolean[], messa= ge text) TO buildhost WITH GRANT OPTION; + + +-- +-- Name: updateiuse(integer, character varying[]); Type: ACL; Schema: pu= blic; Owner: pgadmin +-- + +REVOKE ALL ON FUNCTION updateiuse(ebuildid integer, iniuses character va= rying[]) FROM PUBLIC; +REVOKE ALL ON FUNCTION updateiuse(ebuildid integer, iniuses character va= rying[]) FROM pgadmin; +GRANT ALL ON FUNCTION updateiuse(ebuildid integer, iniuses character var= ying[]) TO pgadmin; +GRANT ALL ON FUNCTION updateiuse(ebuildid integer, iniuses character var= ying[]) TO PUBLIC; +GRANT ALL ON FUNCTION updateiuse(ebuildid integer, iniuses character var= ying[]) TO buildhost WITH GRANT OPTION; + + +-- +-- Name: updatekeywords(integer, character varying[]); Type: ACL; Schema= : public; Owner: pgadmin +-- + +REVOKE ALL ON FUNCTION updatekeywords(ebuildid integer, inkeywords chara= cter varying[]) FROM PUBLIC; +REVOKE ALL ON FUNCTION updatekeywords(ebuildid integer, inkeywords chara= cter varying[]) FROM pgadmin; +GRANT ALL ON FUNCTION updatekeywords(ebuildid integer, inkeywords charac= ter varying[]) TO pgadmin; +GRANT ALL ON FUNCTION updatekeywords(ebuildid integer, inkeywords charac= ter varying[]) TO PUBLIC; +GRANT ALL ON FUNCTION updatekeywords(ebuildid integer, inkeywords charac= ter varying[]) TO buildhost WITH GRANT OPTION; + + +-- +-- Name: updaterestrictions(integer, character varying[]); Type: ACL; Sc= hema: public; Owner: pgadmin +-- + +REVOKE ALL ON FUNCTION updaterestrictions(ebuildid integer, inrestrictio= ns character varying[]) FROM PUBLIC; +REVOKE ALL ON FUNCTION updaterestrictions(ebuildid integer, inrestrictio= ns character varying[]) FROM pgadmin; +GRANT ALL ON FUNCTION updaterestrictions(ebuildid integer, inrestriction= s character varying[]) TO pgadmin; +GRANT ALL ON FUNCTION updaterestrictions(ebuildid integer, inrestriction= s character varying[]) TO PUBLIC; +GRANT ALL ON FUNCTION updaterestrictions(ebuildid integer, inrestriction= s 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 WIT= H GRANT OPTION; + + +-- +-- Name: buildlog_build_id_seq; Type: ACL; Schema: public; Owner: pgadmi= n +-- + +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 buil= dhost WITH GRANT OPTION; + + +-- +-- Name: buildqueue_queue_id_seq; Type: ACL; Schema: public; Owner: pgad= min +-- + +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 WIT= H 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 buil= dhost 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 buildho= st 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 ebuildbuildwithuse= s TO buildhost WITH GRANT OPTION; + + +-- +-- Name: ebuildbuildwithuses_id_seq; Type: ACL; Schema: public; Owner: p= gadmin +-- + +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 T= O buildhost WITH GRANT OPTION; + + +-- +-- Name: ebuildhavesiuses_id_seq; Type: ACL; Schema: public; Owner: pgad= min +-- + +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 WIT= H 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 ebuildhaveskeyword= s TO buildhost WITH GRANT OPTION; + + +-- +-- Name: ebuildhaveskeywords_id_seq; Type: ACL; Schema: public; Owner: p= gadmin +-- + +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: pgad= min +-- + +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 ebuildhavesrestric= tions TO buildhost WITH GRANT OPTION; + + +-- +-- Name: ebuildhavesrestrictions_ebuildtorestriction_id_seq; Type: ACL; = Schema: public; Owner: pgadmin +-- + +REVOKE ALL ON SEQUENCE ebuildhavesrestrictions_ebuildtorestriction_id_se= q FROM PUBLIC; +REVOKE ALL ON SEQUENCE ebuildhavesrestrictions_ebuildtorestriction_id_se= q FROM pgadmin; +GRANT ALL ON SEQUENCE ebuildhavesrestrictions_ebuildtorestriction_id_seq= TO pgadmin; +GRANT SELECT,UPDATE ON SEQUENCE ebuildhavesrestrictions_ebuildtorestrict= ion_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 ebuildqueuedwithus= es 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 buildho= st WITH GRANT OPTION; =20 -SET SQL_MODE=3D"NO_AUTO_VALUE_ON_ZERO"; =20 +-- +-- 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 O= PTION; + + +-- +-- 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 buildh= ost 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 buildh= ost 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 buildh= ost 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 b= uildhost WITH GRANT OPTION; + + +-- +-- Name: packages_package_id_seq; Type: ACL; Schema: public; Owner: pgad= min +-- + +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 WIT= H 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 bui= ldhost 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 GRA= NT OPTION; =20 -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=3D@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=3D@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=3D@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; =20 -- --- Databas: `buildhost` +-- Name: repoman_problems; Type: ACL; Schema: public; Owner: pgadmin -- =20 --- -------------------------------------------------------- +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 T= O buildhost WITH GRANT OPTION; + + +-- +-- Name: repoman_problems_id_seq; Type: ACL; Schema: public; Owner: pgad= min +-- + +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 WIT= H 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 bu= ildhost 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 buildh= ost WITH GRANT OPTION; + =20 -- --- Struktur f=C3=B6r tabell `buildlog` +-- PostgreSQL database dump complete -- =20 -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=3DMyISAM DEFAULT CHARSET=3Dutf8; - --- -------------------------------------------------------- - --- --- Struktur f=C3=B6r 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 CUR= RENT_TIMESTAMP, - `index2` int(20) NOT NULL AUTO_INCREMENT, - PRIMARY KEY (`index2`), - KEY `package` (`package`), - KEY `ebuild_version` (`ebuild_version`), - KEY `category` (`categories`) -) ENGINE=3DMyISAM DEFAULT CHARSET=3Dutf8; - --- -------------------------------------------------------- - --- --- Struktur f=C3=B6r 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 CUR= RENT_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=3DMyISAM DEFAULT CHARSET=3Dutf8; - --- -------------------------------------------------------- - --- --- Struktur f=C3=B6r 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=3DMyISAM DEFAULT CHARSET=3Dutf8; - --- -------------------------------------------------------- - --- --- Struktur f=C3=B6r 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 CUR= RENT_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=3DMyISAM DEFAULT CHARSET=3Dutf8; - --- -------------------------------------------------------- - --- --- Struktur f=C3=B6r 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 CUR= RENT_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=3DMyISAM DEFAULT CHARSET=3Dutf8;