diff options
Diffstat (limited to 'gentoobrowse/datasources/schema.sql')
| -rw-r--r-- | gentoobrowse/datasources/schema.sql | 907 |
1 files changed, 0 insertions, 907 deletions
diff --git a/gentoobrowse/datasources/schema.sql b/gentoobrowse/datasources/schema.sql deleted file mode 100644 index 119d5bc..0000000 --- a/gentoobrowse/datasources/schema.sql +++ /dev/null @@ -1,907 +0,0 @@ --- PostgreSQL database dump -SET statement_timeout = 0; -SET lock_timeout = 0; -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = on; -SET check_function_bodies = false; -SET client_min_messages = warning; --- Name: gentoobrowse; Type: SCHEMA; Schema: -; Owner: gentoo -CREATE SCHEMA gentoobrowse; -ALTER SCHEMA gentoobrowse OWNER TO gentoo; -SET search_path = gentoobrowse, pg_catalog; --- Name: ebuildversion; Type: TYPE; Schema: gentoobrowse; Owner: gentoo -CREATE TYPE ebuildversion AS ( - ver bigint[], - versuffix character(1), - suffix bigint, - suffixnum bigint, - revision bigint -); -ALTER TYPE ebuildversion OWNER TO gentoo; --- Name: filterspec; Type: TYPE; Schema: gentoobrowse; Owner: gentoo -CREATE TYPE filterspec AS ( - part integer, - pattern text -); -ALTER TYPE filterspec OWNER TO gentoo; -SET default_tablespace = ''; -SET default_with_oids = false; --- Name: bugs; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE bugs ( - bugid integer NOT NULL, - severity text NOT NULL, - status text NOT NULL, - summary text NOT NULL, - firstseen timestamp without time zone DEFAULT now() NOT NULL -); -ALTER TABLE bugs OWNER TO gentoo; --- Name: TABLE bugs; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE bugs IS 'Import of Gentoo Bugs bug list from snapshots'; --- Name: bugfts(bugs); Type: FUNCTION; Schema: gentoobrowse; Owner: gentoo -CREATE FUNCTION bugfts(b bugs) RETURNS tsvector - LANGUAGE plpgsql IMMUTABLE - AS $$ -BEGIN - RETURN TO_TSVECTOR('english', regexp_replace(b.summary, '-[0-9][^ ]*', '', 'g')); -END -$$; -ALTER FUNCTION gentoobrowse.bugfts(b bugs) OWNER TO gentoo; --- Name: ebuildfilter(text); Type: FUNCTION; Schema: gentoobrowse; Owner: gentoo -CREATE FUNCTION ebuildfilter(atomspec text) RETURNS SETOF integer - LANGUAGE plpgsql - AS $_$ -declare - op text; - cat text; - pkg text; - ver gentoobrowse.ebuildversion; -begin -if (atomspec like '=%*') then - atomspec = '~' || substr(atomspec, 2, length(atomspec) - 2); -end if; -op = (regexp_matches(atomspec, '^([^a-z]*)'))[1]; -cat = (regexp_matches(atomspec, '^[^a-z]*([^/]+)/'))[1]; -pkg = (regexp_matches(atomspec, '/(.+?)((-[0-9])|$)'))[1]; -ver = ebuildversion_constructor((regexp_matches(atomspec, '-([0-9]+.*)$'))[1]); -return query select ebuildid -from ebuilds e, packages p, categories c -where e.packageid = p.packageid -and p.categoryid = c.categoryid -and p.name = pkg -and c.name = cat -and case - when op = '=' then e.versioninst = ver - when op = '>=' then e.versioninst >= ver - when op = '<=' then e.versioninst <= ver - when op = '<' then e.versioninst < ver - when op = '>' then e.versioninst > ver - when op = '~' then e.versioninst ~ ver - when op = '' then true - else false -end -; -end; -$_$; -ALTER FUNCTION gentoobrowse.ebuildfilter(atomspec text) OWNER TO gentoo; --- Name: ebuildversion_constructor(text); Type: FUNCTION; Schema: gentoobrowse; Owner: gentoo -CREATE FUNCTION ebuildversion_constructor(val text) RETURNS ebuildversion - LANGUAGE plpgsql IMMUTABLE - AS $_$ -declare - v ebuildversion; - s text; -begin - v.ver = string_to_array((regexp_matches(val, '^([0-9.]+)'))[1], '.')::bigint[]; - v.versuffix = (regexp_matches(val, '[0-9]([a-z])'))[1]; - v.versuffix = coalesce(v.versuffix, '@'); - s = (regexp_matches(val, '_([a-z]+)'))[1]; - case - when s = 'alpha' then v.suffix = -4; - when s = 'beta' then v.suffix = -3; - when s = 'pre' then v.suffix = -2; - when s = 'rc' then v.suffix = -1; - when s = 'p' then v.suffix = 1; - else v.suffix = 0; - end case; - v.suffixnum = (regexp_matches(val, '_[a-z]+([0-9]+)'))[1]; - v.suffixnum = coalesce(v.suffixnum, 0); - v.revision = (regexp_matches(val, '-r([0-9]+)$'))[1]; - v.revision = coalesce(v.revision, 0); - return v; -end; -$_$; -ALTER FUNCTION gentoobrowse.ebuildversion_constructor(val text) OWNER TO gentoo; --- Name: ebuildversionrange(ebuildversion, ebuildversion); Type: FUNCTION; Schema: gentoobrowse; Owner: gentoo -CREATE FUNCTION ebuildversionrange(a ebuildversion, b ebuildversion) RETURNS boolean - LANGUAGE plpgsql - AS $$begin --- If spec if longer, can't match -if (array_length(a.ver, 1) < array_length(b.ver, 1)) then - return false; -end if; --- Otherwise, they have to start the same -if (position(array_to_string(b.ver, '.') in array_to_string(a.ver, '.')) != 1) then - return false; -end if; -if (a.ver = b.ver) then - if (a.versuffix != b.versuffix and b.versuffix != '@') then - return false; - end if; - if (a.suffix != b.suffix and b.suffix != 0) then - return false; - end if; - if (a.suffixnum != b.suffixnum and b.suffixnum != 0) then - return false; - end if; - if (a.revision != b.revision and b.revision != 0) then - return false; - end if; - return true; -else - return ((b.versuffix = '@' - and b.suffix = 0 - and b.suffixnum = 0 - and b.revision = 0) or b is null); -end if; -end -$$; -ALTER FUNCTION gentoobrowse.ebuildversionrange(a ebuildversion, b ebuildversion) OWNER TO gentoo; --- Name: ebuildversiontotext(ebuildversion); Type: FUNCTION; Schema: gentoobrowse; Owner: gentoo -CREATE FUNCTION ebuildversiontotext(v ebuildversion) RETURNS text - LANGUAGE plpgsql - AS $_$ -declare -str text; -begin -str = array_to_string($1.ver, '.'); -if ($1.versuffix != '@') then - str = str || $1.versuffix; -end if; -if ($1.suffix != 0) then -str = str || ( - case - when $1.suffix = -4 then '_alpha' - when $1.suffix = -3 then '_beta' - when $1.suffix = -2 then '_pre' - when $1.suffix = -1 then '_rc' - when $1.suffix = 1 then '_p' - end ); - str = str || $1.suffixnum; -end if; -if ($1.revision != 0) then - str = str || '-r' || $1.revision; -end if; -return str; -end; -$_$; -ALTER FUNCTION gentoobrowse.ebuildversiontotext(v ebuildversion) OWNER TO gentoo; --- Name: namedpackages(text); Type: FUNCTION; Schema: gentoobrowse; Owner: gentoo -CREATE FUNCTION namedpackages(str text) RETURNS text[] - LANGUAGE plpgsql IMMUTABLE - AS $$ -declare - pkgs text[]; - p record; -begin - for p in select regexp_matches(str, '([[:alnum:]]+-[[:alnum:]]+/(?:-?[_[:alpha:]+][[:alnum:]+]+)+)', 'g') as p - loop - pkgs = array_append(pkgs, p.p[1]); - end loop; - return pkgs; -end -$$; -ALTER FUNCTION gentoobrowse.namedpackages(str text) OWNER TO gentoo; --- Name: packages; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE packages ( - packageid integer NOT NULL, - categoryid integer NOT NULL, - name text NOT NULL, - firstseen timestamp without time zone DEFAULT now() NOT NULL, - description text NOT NULL, - summary text, - maintainer text, - herd text, - image text, - maintainername text -); -ALTER TABLE packages OWNER TO gentoo; --- Name: TABLE packages; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE packages IS 'Packages as summarised from their ebuilds'; --- Name: packagefts(packages); Type: FUNCTION; Schema: gentoobrowse; Owner: gentoo -CREATE FUNCTION packagefts(p packages) RETURNS tsvector - LANGUAGE plpgsql IMMUTABLE - AS $$ -BEGIN - RETURN (SETWEIGHT(TO_TSVECTOR('english', p.name), 'A') || - SETWEIGHT(TO_TSVECTOR('english', p.description), 'B') || - SETWEIGHT(TO_TSVECTOR('english', COALESCE(p.summary, '')), 'C')); -END -$$; -ALTER FUNCTION gentoobrowse.packagefts(p packages) OWNER TO gentoo; --- Name: pathpartsmatchesspecs(text[], filterspec[]); Type: FUNCTION; Schema: gentoobrowse; Owner: gentoo -CREATE FUNCTION pathpartsmatchesspecs(pathparts text[], spec filterspec[]) RETURNS boolean - LANGUAGE plpgsql - AS $$ -DECLARE - i integer; - p integer; -BEGIN - p := array_upper(pathparts, 1); - FOR i IN 1 .. array_upper(spec, 1) LOOP - IF (p < spec[i].part) THEN RETURN FALSE; END IF; - IF (spec[i].part <= 0) THEN - IF (pathparts[p - spec[i].part] NOT LIKE spec[i].pattern) THEN RETURN FALSE; END IF; - ELSE - IF (pathparts[spec[i].part] NOT LIKE spec[i].pattern) THEN RETURN FALSE; END IF; - END IF; - END LOOP; - RETURN TRUE; -END; -$$; -ALTER FUNCTION gentoobrowse.pathpartsmatchesspecs(pathparts text[], spec filterspec[]) OWNER TO gentoo; --- Name: sum(tsvector); Type: AGGREGATE; Schema: gentoobrowse; Owner: postgres -CREATE AGGREGATE sum(tsvector) ( - SFUNC = tsvector_concat, - STYPE = tsvector -); -ALTER AGGREGATE gentoobrowse.sum(tsvector) OWNER TO postgres; --- Name: ~; Type: OPERATOR; Schema: gentoobrowse; Owner: gentoo -CREATE OPERATOR ~ ( - PROCEDURE = ebuildversionrange, - LEFTARG = ebuildversion, - RIGHTARG = ebuildversion -); -ALTER OPERATOR gentoobrowse.~ (ebuildversion, ebuildversion) OWNER TO gentoo; --- Name: ~; Type: OPERATOR; Schema: gentoobrowse; Owner: gentoo -CREATE OPERATOR ~ ( - PROCEDURE = pathpartsmatchesspecs, - LEFTARG = text[], - RIGHTARG = filterspec[] -); -ALTER OPERATOR gentoobrowse.~ (text[], filterspec[]) OWNER TO gentoo; --- Name: categories; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE categories ( - categoryid integer NOT NULL, - name text, - summary text -); -ALTER TABLE categories OWNER TO gentoo; --- Name: TABLE categories; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE categories IS 'Gentoo defined package categories'; --- Name: ebuild_archs; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE ebuild_archs ( - ebuildid integer NOT NULL, - arch text NOT NULL -); -ALTER TABLE ebuild_archs OWNER TO gentoo; --- Name: TABLE ebuild_archs; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE ebuild_archs IS 'Architectures an ebuild is suitable for'; --- Name: ebuild_deps; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE ebuild_deps ( - ebuildid integer NOT NULL, - packageid integer NOT NULL, - versionspec text NOT NULL, - flags text NOT NULL, - op character varying(4) NOT NULL, - slot text NOT NULL -); -ALTER TABLE ebuild_deps OWNER TO gentoo; --- Name: TABLE ebuild_deps; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE ebuild_deps IS 'The dependencies of ebuilds (includes blocks, etc)'; --- Name: ebuild_masks; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE ebuild_masks ( - setno integer NOT NULL, - ebuildid integer NOT NULL -); -ALTER TABLE ebuild_masks OWNER TO gentoo; --- Name: ebuild_rdeps; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE ebuild_rdeps ( - ebuildid integer NOT NULL, - packageid integer NOT NULL, - versionspec text NOT NULL, - flags text NOT NULL, - op character varying(4) NOT NULL, - slot text NOT NULL -); -ALTER TABLE ebuild_rdeps OWNER TO gentoo; --- Name: ebuild_uses; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE ebuild_uses ( - ebuildid integer NOT NULL, - use text NOT NULL -); -ALTER TABLE ebuild_uses OWNER TO gentoo; --- Name: TABLE ebuild_uses; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE ebuild_uses IS 'Use flags affecting ebuilds'; --- Name: ebuilds; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE ebuilds ( - ebuildid integer NOT NULL, - packageid integer NOT NULL, - version text NOT NULL, - versioninst ebuildversion NOT NULL, - slot text NOT NULL, - license text, - firstseen timestamp without time zone NOT NULL, - moddate timestamp without time zone NOT NULL, - repoid integer NOT NULL -); -ALTER TABLE ebuilds OWNER TO gentoo; --- Name: TABLE ebuilds; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE ebuilds IS 'Ebuilds :-)'; --- Name: files; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE files ( - filename text NOT NULL, - fileid integer NOT NULL, - moddate timestamp without time zone NOT NULL, - firstseen timestamp without time zone DEFAULT now() NOT NULL, - cachedat timestamp without time zone, - filetypeid integer NOT NULL, - repoid integer NOT NULL, - filesize integer NOT NULL, - pathparts text[] NOT NULL, - encoding text -); -ALTER TABLE files OWNER TO gentoo; --- Name: filecontent(files); Type: FUNCTION; Schema: gentoobrowse; Owner: gentoo -CREATE FUNCTION filecontent(f files) RETURNS text - LANGUAGE plpgsql IMMUTABLE - AS $$ -begin - return CONVERT_FROM(PG_READ_BINARY_FILE(f.filename), COALESCE(f.encoding, 'utf-8')); -end -$$; -ALTER FUNCTION gentoobrowse.filecontent(f files) OWNER TO gentoo; --- Name: filetypes; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE filetypes ( - filetypeid integer NOT NULL, - description text NOT NULL, - spec filterspec[] NOT NULL -); -ALTER TABLE filetypes OWNER TO gentoo; --- Name: TABLE filetypes; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE filetypes IS 'What kind of file is this?... metadata, changelog, etc'; --- Name: license; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE license ( - name text NOT NULL, - legalbumph text NOT NULL -); -ALTER TABLE license OWNER TO gentoo; --- Name: masksets; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE masksets ( - setno integer NOT NULL, - person text, - email text NOT NULL, - dateadded date NOT NULL, - message text NOT NULL, - n smallint NOT NULL -); -ALTER TABLE masksets OWNER TO gentoo; --- Name: masksets_setno_seq; Type: SEQUENCE; Schema: gentoobrowse; Owner: gentoo -CREATE SEQUENCE masksets_setno_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; -ALTER TABLE masksets_setno_seq OWNER TO gentoo; --- Name: masksets_setno_seq; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo -ALTER SEQUENCE masksets_setno_seq OWNED BY masksets.setno; --- Name: news; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE news ( - newsid text NOT NULL, - title text NOT NULL, - posted date NOT NULL, - authorname text, - authoremail text, - atomspec text[], - body text[] NOT NULL, - urls text[] -); -ALTER TABLE news OWNER TO gentoo; --- Name: newsfts(news); Type: FUNCTION; Schema: gentoobrowse; Owner: gentoo -CREATE FUNCTION newsfts(n news) RETURNS tsvector - LANGUAGE plpgsql IMMUTABLE - AS $$ -BEGIN - RETURN SUM(t) FROM (SELECT TO_TSVECTOR('english', UNNEST(n.body)) t) a; -END -$$; -ALTER FUNCTION gentoobrowse.newsfts(n news) OWNER TO gentoo; --- Name: package_bugs; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE package_bugs ( - packageid integer NOT NULL, - bugid integer NOT NULL, - firstseen timestamp without time zone DEFAULT now() NOT NULL -); -ALTER TABLE package_bugs OWNER TO gentoo; --- Name: TABLE package_bugs; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE package_bugs IS 'Association of bugs to products by bug description'; --- Name: package_changelogs; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE package_changelogs ( - packageid integer NOT NULL, - date date NOT NULL, - n smallint NOT NULL, - person text, - email text, - comment text, - repoid integer NOT NULL -); -ALTER TABLE package_changelogs OWNER TO gentoo; --- Name: package_urls; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE package_urls ( - packageid integer NOT NULL, - url text NOT NULL -); -ALTER TABLE package_urls OWNER TO gentoo; --- Name: TABLE package_urls; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE package_urls IS 'URLs associated with a given package'; --- Name: repos; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE repos ( - repoid integer NOT NULL, - name text NOT NULL -); -ALTER TABLE repos OWNER TO gentoo; --- Name: repos_repoid_seq; Type: SEQUENCE; Schema: gentoobrowse; Owner: gentoo -CREATE SEQUENCE repos_repoid_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; -ALTER TABLE repos_repoid_seq OWNER TO gentoo; --- Name: repos_repoid_seq; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo -ALTER SEQUENCE repos_repoid_seq OWNED BY repos.repoid; --- Name: seq_categoryid; Type: SEQUENCE; Schema: gentoobrowse; Owner: gentoo -CREATE SEQUENCE seq_categoryid - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; -ALTER TABLE seq_categoryid OWNER TO gentoo; --- Name: seq_categoryid; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo -ALTER SEQUENCE seq_categoryid OWNED BY categories.categoryid; --- Name: seq_fileid; Type: SEQUENCE; Schema: gentoobrowse; Owner: gentoo -CREATE SEQUENCE seq_fileid - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; -ALTER TABLE seq_fileid OWNER TO gentoo; --- Name: seq_fileid; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo -ALTER SEQUENCE seq_fileid OWNED BY files.fileid; --- Name: seq_packageid; Type: SEQUENCE; Schema: gentoobrowse; Owner: gentoo -CREATE SEQUENCE seq_packageid - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; -ALTER TABLE seq_packageid OWNER TO gentoo; --- Name: seq_packageid; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo -ALTER SEQUENCE seq_packageid OWNED BY packages.packageid; --- Name: use_global; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE use_global ( - use text NOT NULL, - description text -); -ALTER TABLE use_global OWNER TO gentoo; --- Name: use_group; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE use_group ( - usegroupid integer NOT NULL, - use text NOT NULL, - description text NOT NULL -); -ALTER TABLE use_group OWNER TO gentoo; --- Name: use_groups; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE use_groups ( - usegroupid integer NOT NULL, - name text NOT NULL -); -ALTER TABLE use_groups OWNER TO gentoo; --- Name: use_groups_usegroupid_seq; Type: SEQUENCE; Schema: gentoobrowse; Owner: gentoo -CREATE SEQUENCE use_groups_usegroupid_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; -ALTER TABLE use_groups_usegroupid_seq OWNER TO gentoo; --- Name: use_groups_usegroupid_seq; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo -ALTER SEQUENCE use_groups_usegroupid_seq OWNED BY use_groups.usegroupid; --- Name: use_local; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE use_local ( - packageid integer NOT NULL, - use text NOT NULL, - description text NOT NULL -); -ALTER TABLE use_local OWNER TO gentoo; --- Name: user_ebuild_emails; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE user_ebuild_emails ( - userid integer NOT NULL, - ebuildid integer NOT NULL, - sentat timestamp without time zone NOT NULL -); -ALTER TABLE user_ebuild_emails OWNER TO gentoo; --- Name: user_packages; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE user_packages ( - userid integer NOT NULL, - packageid integer NOT NULL, - trackedsince timestamp without time zone DEFAULT now() NOT NULL -); -ALTER TABLE user_packages OWNER TO gentoo; --- Name: TABLE user_packages; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE user_packages IS 'Lists packages that registered users are interested in'; --- Name: users; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE users ( - userid integer NOT NULL, - username text NOT NULL, - userrealname text NOT NULL, - userpassword text NOT NULL, - useremail text NOT NULL, - verifyguid uuid -); -ALTER TABLE users OWNER TO gentoo; --- Name: TABLE users; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo -COMMENT ON TABLE users IS 'Registered users'; --- Name: users_userid_seq; Type: SEQUENCE; Schema: gentoobrowse; Owner: gentoo -CREATE SEQUENCE users_userid_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; -ALTER TABLE users_userid_seq OWNER TO gentoo; --- Name: users_userid_seq; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo -ALTER SEQUENCE users_userid_seq OWNED BY users.userid; --- Name: categoryid; Type: DEFAULT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY categories ALTER COLUMN categoryid SET DEFAULT nextval('seq_categoryid'::regclass); --- Name: fileid; Type: DEFAULT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY files ALTER COLUMN fileid SET DEFAULT nextval('seq_fileid'::regclass); --- Name: setno; Type: DEFAULT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY masksets ALTER COLUMN setno SET DEFAULT nextval('masksets_setno_seq'::regclass); --- Name: packageid; Type: DEFAULT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY packages ALTER COLUMN packageid SET DEFAULT nextval('seq_packageid'::regclass); --- Name: repoid; Type: DEFAULT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY repos ALTER COLUMN repoid SET DEFAULT nextval('repos_repoid_seq'::regclass); --- Name: usegroupid; Type: DEFAULT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY use_groups ALTER COLUMN usegroupid SET DEFAULT nextval('use_groups_usegroupid_seq'::regclass); --- Name: userid; Type: DEFAULT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY users ALTER COLUMN userid SET DEFAULT nextval('users_userid_seq'::regclass); --- Name: license_pkey; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY license - ADD CONSTRAINT license_pkey PRIMARY KEY (name); --- Name: pk_bugs; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY bugs - ADD CONSTRAINT pk_bugs PRIMARY KEY (bugid); --- Name: pk_ebuild; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY ebuilds - ADD CONSTRAINT pk_ebuild PRIMARY KEY (ebuildid); --- Name: pk_ebuildarch; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY ebuild_archs - ADD CONSTRAINT pk_ebuildarch PRIMARY KEY (ebuildid, arch); -ALTER TABLE ebuild_archs CLUSTER ON pk_ebuildarch; --- Name: pk_ebuilddeps; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY ebuild_deps - ADD CONSTRAINT pk_ebuilddeps PRIMARY KEY (ebuildid, packageid, versionspec, flags, slot, op); -ALTER TABLE ebuild_deps CLUSTER ON pk_ebuilddeps; --- Name: pk_ebuildmasks; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY ebuild_masks - ADD CONSTRAINT pk_ebuildmasks PRIMARY KEY (ebuildid, setno); --- Name: pk_ebuildrdeps; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY ebuild_rdeps - ADD CONSTRAINT pk_ebuildrdeps PRIMARY KEY (ebuildid, packageid, versionspec, flags, slot, op); -ALTER TABLE ebuild_rdeps CLUSTER ON pk_ebuildrdeps; --- Name: pk_ebuilduses; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY ebuild_uses - ADD CONSTRAINT pk_ebuilduses PRIMARY KEY (ebuildid, use); -ALTER TABLE ebuild_uses CLUSTER ON pk_ebuilduses; --- Name: pk_fileclass; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY filetypes - ADD CONSTRAINT pk_fileclass PRIMARY KEY (filetypeid); --- Name: pk_files; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY files - ADD CONSTRAINT pk_files PRIMARY KEY (fileid); --- Name: pk_news; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY news - ADD CONSTRAINT pk_news PRIMARY KEY (newsid); --- Name: pk_package_changelogs; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY package_changelogs - ADD CONSTRAINT pk_package_changelogs PRIMARY KEY (packageid, date, n, repoid); -ALTER TABLE package_changelogs CLUSTER ON pk_package_changelogs; --- Name: pk_packagebugs; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY package_bugs - ADD CONSTRAINT pk_packagebugs PRIMARY KEY (packageid, bugid); -ALTER TABLE package_bugs CLUSTER ON pk_packagebugs; --- Name: pk_packagemasksets; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY masksets - ADD CONSTRAINT pk_packagemasksets PRIMARY KEY (setno); --- Name: pk_packages; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY packages - ADD CONSTRAINT pk_packages PRIMARY KEY (packageid); --- Name: pk_pkggroup; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY categories - ADD CONSTRAINT pk_pkggroup PRIMARY KEY (categoryid); --- Name: pk_pkgurls; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY package_urls - ADD CONSTRAINT pk_pkgurls PRIMARY KEY (packageid, url); -ALTER TABLE package_urls CLUSTER ON pk_pkgurls; --- Name: pk_usegroup; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY use_groups - ADD CONSTRAINT pk_usegroup PRIMARY KEY (usegroupid); --- Name: pk_userebuildemails; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY user_ebuild_emails - ADD CONSTRAINT pk_userebuildemails PRIMARY KEY (userid, ebuildid); --- Name: pk_userpackages; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY user_packages - ADD CONSTRAINT pk_userpackages PRIMARY KEY (userid, packageid); -ALTER TABLE user_packages CLUSTER ON pk_userpackages; --- Name: pk_users; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY users - ADD CONSTRAINT pk_users PRIMARY KEY (userid); --- Name: repos_pkey; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY repos - ADD CONSTRAINT repos_pkey PRIMARY KEY (repoid); --- Name: uni_ebuild_pkgverrepo; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY ebuilds - ADD CONSTRAINT uni_ebuild_pkgverrepo UNIQUE (packageid, version, repoid); -ALTER TABLE ebuilds CLUSTER ON uni_ebuild_pkgverrepo; --- Name: uni_files_filename; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY files - ADD CONSTRAINT uni_files_filename UNIQUE (filename); --- Name: uni_pkg_name; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY packages - ADD CONSTRAINT uni_pkg_name UNIQUE (categoryid, name); -ALTER TABLE packages CLUSTER ON uni_pkg_name; --- Name: uni_pkggroup_group; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY categories - ADD CONSTRAINT uni_pkggroup_group UNIQUE (name); --- Name: uni_useremail; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY users - ADD CONSTRAINT uni_useremail UNIQUE (useremail); --- Name: uni_username; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY users - ADD CONSTRAINT uni_username UNIQUE (username); --- Name: use_global_pkey; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY use_global - ADD CONSTRAINT use_global_pkey PRIMARY KEY (use); --- Name: use_group_pkey; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY use_group - ADD CONSTRAINT use_group_pkey PRIMARY KEY (usegroupid, use); --- Name: use_local_pkey; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY use_local - ADD CONSTRAINT use_local_pkey PRIMARY KEY (packageid, use); -ALTER TABLE use_local CLUSTER ON use_local_pkey; --- Name: idx_bug_fts; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_bug_fts ON bugs USING gin (bugfts(bugs.*)); --- Name: idx_bugs_firstseen; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_bugs_firstseen ON bugs USING btree (firstseen DESC); --- Name: idx_bugs_summarypackages; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_bugs_summarypackages ON bugs USING gin (namedpackages(summary)); --- Name: idx_ebuilddeps_package; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_ebuilddeps_package ON ebuild_deps USING btree (packageid); --- Name: idx_ebuildrdeps_package; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_ebuildrdeps_package ON ebuild_rdeps USING btree (packageid); --- Name: idx_ebuilds_firstseen; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_ebuilds_firstseen ON ebuilds USING btree (firstseen); --- Name: idx_ebuilduses_use; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_ebuilduses_use ON ebuild_uses USING btree (use); --- Name: idx_news_fts; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_news_fts ON news USING gin (newsfts(news.*)); --- Name: idx_news_posted; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_news_posted ON news USING btree (posted); --- Name: idx_package_name; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_package_name ON packages USING btree (name); --- Name: idx_packagebugs_bug; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_packagebugs_bug ON package_bugs USING btree (bugid); --- Name: idx_packages_fts; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_packages_fts ON packages USING gin (packagefts(packages.*)); --- Name: idx_packages_herd; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_packages_herd ON packages USING btree (herd); --- Name: idx_uselocal_use; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_uselocal_use ON use_local USING btree (use); --- Name: idx_userpackages_package; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX idx_userpackages_package ON user_packages USING btree (packageid); --- Name: uni_masksets_dateaddedn; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE INDEX uni_masksets_dateaddedn ON masksets USING btree (dateadded, n); --- Name: fk_ebuild_pkg; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY ebuilds - ADD CONSTRAINT fk_ebuild_pkg FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_ebuild_repo; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY ebuilds - ADD CONSTRAINT fk_ebuild_repo FOREIGN KEY (repoid) REFERENCES repos(repoid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_ebuildarch_file; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY ebuild_archs - ADD CONSTRAINT fk_ebuildarch_file FOREIGN KEY (ebuildid) REFERENCES ebuilds(ebuildid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_ebuilddeps_ebuild; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY ebuild_deps - ADD CONSTRAINT fk_ebuilddeps_ebuild FOREIGN KEY (ebuildid) REFERENCES ebuilds(ebuildid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_ebuilddeps_pkg; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY ebuild_deps - ADD CONSTRAINT fk_ebuilddeps_pkg FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_ebuildmasks_ebuild; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY ebuild_masks - ADD CONSTRAINT fk_ebuildmasks_ebuild FOREIGN KEY (ebuildid) REFERENCES ebuilds(ebuildid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_ebuildmasks_maskset; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY ebuild_masks - ADD CONSTRAINT fk_ebuildmasks_maskset FOREIGN KEY (setno) REFERENCES masksets(setno) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_ebuildrdeps_ebuild; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY ebuild_rdeps - ADD CONSTRAINT fk_ebuildrdeps_ebuild FOREIGN KEY (ebuildid) REFERENCES ebuilds(ebuildid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_ebuildrdeps_pkg; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY ebuild_rdeps - ADD CONSTRAINT fk_ebuildrdeps_pkg FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_ebuilduses_file; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY ebuild_uses - ADD CONSTRAINT fk_ebuilduses_file FOREIGN KEY (ebuildid) REFERENCES ebuilds(ebuildid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_files_type; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY files - ADD CONSTRAINT fk_files_type FOREIGN KEY (filetypeid) REFERENCES filetypes(filetypeid) ON UPDATE CASCADE; --- Name: fk_packagebugs_bug; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY package_bugs - ADD CONSTRAINT fk_packagebugs_bug FOREIGN KEY (bugid) REFERENCES bugs(bugid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_packagebugs_package; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY package_bugs - ADD CONSTRAINT fk_packagebugs_package FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_packagechangelogs_package; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY package_changelogs - ADD CONSTRAINT fk_packagechangelogs_package FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_packagechangelogs_repo; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY package_changelogs - ADD CONSTRAINT fk_packagechangelogs_repo FOREIGN KEY (repoid) REFERENCES repos(repoid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_packageurls_package; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY package_urls - ADD CONSTRAINT fk_packageurls_package FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_pkg_grp; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY packages - ADD CONSTRAINT fk_pkg_grp FOREIGN KEY (categoryid) REFERENCES categories(categoryid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_pkgurls_pkg; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY package_urls - ADD CONSTRAINT fk_pkgurls_pkg FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_usegroup_groupid; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY use_group - ADD CONSTRAINT fk_usegroup_groupid FOREIGN KEY (usegroupid) REFERENCES use_groups(usegroupid) ON DELETE CASCADE; --- Name: fk_uselocal_package; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY use_local - ADD CONSTRAINT fk_uselocal_package FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_userebuildemails_ebuild; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY user_ebuild_emails - ADD CONSTRAINT fk_userebuildemails_ebuild FOREIGN KEY (ebuildid) REFERENCES ebuilds(ebuildid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_userebuildemails_user; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY user_ebuild_emails - ADD CONSTRAINT fk_userebuildemails_user FOREIGN KEY (userid) REFERENCES users(userid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_userpackage_package; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY user_packages - ADD CONSTRAINT fk_userpackage_package FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_userpackage_user; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY user_packages - ADD CONSTRAINT fk_userpackage_user FOREIGN KEY (userid) REFERENCES users(userid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_userpackages_package; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY user_packages - ADD CONSTRAINT fk_userpackages_package FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: gentoobrowse; Type: ACL; Schema: -; Owner: gentoo -REVOKE ALL ON SCHEMA gentoobrowse FROM PUBLIC; -REVOKE ALL ON SCHEMA gentoobrowse FROM gentoo; -GRANT USAGE ON SCHEMA gentoobrowse TO apache; -GRANT USAGE ON SCHEMA gentoobrowse TO gentoo; --- Name: bugs; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE bugs FROM PUBLIC; -REVOKE ALL ON TABLE bugs FROM gentoo; -GRANT ALL ON TABLE bugs TO gentoo; -GRANT SELECT ON TABLE bugs TO apache; --- Name: packages; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE packages FROM PUBLIC; -REVOKE ALL ON TABLE packages FROM gentoo; -GRANT ALL ON TABLE packages TO gentoo; -GRANT SELECT ON TABLE packages TO apache; --- Name: categories; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE categories FROM PUBLIC; -REVOKE ALL ON TABLE categories FROM gentoo; -GRANT ALL ON TABLE categories TO gentoo; -GRANT SELECT ON TABLE categories TO apache; --- Name: ebuild_archs; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE ebuild_archs FROM PUBLIC; -REVOKE ALL ON TABLE ebuild_archs FROM gentoo; -GRANT ALL ON TABLE ebuild_archs TO gentoo; -GRANT SELECT ON TABLE ebuild_archs TO apache; --- Name: ebuild_deps; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE ebuild_deps FROM PUBLIC; -REVOKE ALL ON TABLE ebuild_deps FROM gentoo; -GRANT ALL ON TABLE ebuild_deps TO gentoo; -GRANT SELECT ON TABLE ebuild_deps TO apache; --- Name: ebuild_masks; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE ebuild_masks FROM PUBLIC; -REVOKE ALL ON TABLE ebuild_masks FROM gentoo; -GRANT ALL ON TABLE ebuild_masks TO gentoo; -GRANT SELECT ON TABLE ebuild_masks TO apache; --- Name: ebuild_rdeps; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE ebuild_rdeps FROM PUBLIC; -REVOKE ALL ON TABLE ebuild_rdeps FROM gentoo; -GRANT ALL ON TABLE ebuild_rdeps TO gentoo; -GRANT SELECT ON TABLE ebuild_rdeps TO apache; --- Name: ebuild_uses; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE ebuild_uses FROM PUBLIC; -REVOKE ALL ON TABLE ebuild_uses FROM gentoo; -GRANT ALL ON TABLE ebuild_uses TO gentoo; -GRANT SELECT ON TABLE ebuild_uses TO apache; --- Name: ebuilds; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE ebuilds FROM PUBLIC; -REVOKE ALL ON TABLE ebuilds FROM gentoo; -GRANT ALL ON TABLE ebuilds TO gentoo; -GRANT SELECT ON TABLE ebuilds TO apache; --- Name: files; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE files FROM PUBLIC; -REVOKE ALL ON TABLE files FROM gentoo; -GRANT ALL ON TABLE files TO gentoo; -GRANT SELECT ON TABLE files TO apache; --- Name: filetypes; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE filetypes FROM PUBLIC; -REVOKE ALL ON TABLE filetypes FROM gentoo; -GRANT ALL ON TABLE filetypes TO gentoo; -GRANT SELECT ON TABLE filetypes TO apache; --- Name: masksets; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE masksets FROM PUBLIC; -REVOKE ALL ON TABLE masksets FROM gentoo; -GRANT ALL ON TABLE masksets TO gentoo; -GRANT SELECT ON TABLE masksets TO apache; --- Name: package_bugs; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE package_bugs FROM PUBLIC; -REVOKE ALL ON TABLE package_bugs FROM gentoo; -GRANT ALL ON TABLE package_bugs TO gentoo; -GRANT SELECT ON TABLE package_bugs TO apache; --- Name: package_changelogs; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE package_changelogs FROM PUBLIC; -REVOKE ALL ON TABLE package_changelogs FROM gentoo; -GRANT ALL ON TABLE package_changelogs TO gentoo; -GRANT SELECT ON TABLE package_changelogs TO apache; --- Name: package_urls; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE package_urls FROM PUBLIC; -REVOKE ALL ON TABLE package_urls FROM gentoo; -GRANT ALL ON TABLE package_urls TO gentoo; -GRANT SELECT ON TABLE package_urls TO apache; --- Name: repos; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE repos FROM PUBLIC; -REVOKE ALL ON TABLE repos FROM gentoo; -GRANT ALL ON TABLE repos TO gentoo; -GRANT SELECT ON TABLE repos TO apache; --- Name: use_global; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE use_global FROM PUBLIC; -REVOKE ALL ON TABLE use_global FROM gentoo; -GRANT ALL ON TABLE use_global TO gentoo; -GRANT SELECT ON TABLE use_global TO apache; --- Name: use_group; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE use_group FROM PUBLIC; -REVOKE ALL ON TABLE use_group FROM gentoo; -GRANT ALL ON TABLE use_group TO gentoo; -GRANT SELECT ON TABLE use_group TO apache; --- Name: use_groups; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE use_groups FROM PUBLIC; -REVOKE ALL ON TABLE use_groups FROM gentoo; -GRANT ALL ON TABLE use_groups TO gentoo; -GRANT SELECT ON TABLE use_groups TO apache; --- Name: use_local; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE use_local FROM PUBLIC; -REVOKE ALL ON TABLE use_local FROM gentoo; -GRANT ALL ON TABLE use_local TO gentoo; -GRANT SELECT ON TABLE use_local TO apache; --- Name: user_ebuild_emails; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE user_ebuild_emails FROM PUBLIC; -REVOKE ALL ON TABLE user_ebuild_emails FROM gentoo; -GRANT ALL ON TABLE user_ebuild_emails TO gentoo; -GRANT SELECT ON TABLE user_ebuild_emails TO apache; --- Name: user_packages; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE user_packages FROM PUBLIC; -REVOKE ALL ON TABLE user_packages FROM gentoo; -GRANT ALL ON TABLE user_packages TO gentoo; -GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE user_packages TO apache; --- Name: users; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE users FROM PUBLIC; -REVOKE ALL ON TABLE users FROM gentoo; -GRANT ALL ON TABLE users TO gentoo; -GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE users TO apache; --- Name: users_userid_seq; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON SEQUENCE users_userid_seq FROM PUBLIC; -REVOKE ALL ON SEQUENCE users_userid_seq FROM gentoo; -GRANT ALL ON SEQUENCE users_userid_seq TO gentoo; -GRANT ALL ON SEQUENCE users_userid_seq TO apache; --- PostgreSQL database dump complete |