path: root/sql/gentoo_ci_schema.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 13.3
-- Dumped by pg_dump version 13.5

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: email_proxied; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.email_proxied AS ENUM (
    'no',
    'yes',
    'proxy'
);


ALTER TYPE public.email_proxied OWNER TO buildbot;

--
-- Name: email_type; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.email_type AS ENUM (
    'person',
    'project',
    'unknown'
);


ALTER TYPE public.email_type OWNER TO buildbot;

--
-- Name: projects_builds_status; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.projects_builds_status AS ENUM (
    'failed',
    'completed',
    'in-progress',
    'waiting',
    'warning'
);


ALTER TYPE public.projects_builds_status OWNER TO buildbot;

--
-- Name: projects_pattern_search_type; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.projects_pattern_search_type AS ENUM (
    'in',
    'startswith',
    'endswith',
    'search'
);


ALTER TYPE public.projects_pattern_search_type OWNER TO buildbot;

--
-- Name: projects_pattern_status; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.projects_pattern_status AS ENUM (
    'info',
    'warning',
    'error',
    'ignore'
);


ALTER TYPE public.projects_pattern_status OWNER TO buildbot;

--
-- Name: projects_pattern_type; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.projects_pattern_type AS ENUM (
    'info',
    'qa',
    'compile',
    'configure',
    'install',
    'postinst',
    'prepare',
    'setup',
    'test',
    'unpack',
    'ignore',
    'issues',
    'misc',
    'elog',
    'pretend'
);


ALTER TYPE public.projects_pattern_type OWNER TO buildbot;

--
-- Name: projects_portage_directorys; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.projects_portage_directorys AS ENUM (
    'make.profile',
    'repos.conf'
);


ALTER TYPE public.projects_portage_directorys OWNER TO buildbot;

--
-- Name: projects_portage_package_directorys; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.projects_portage_package_directorys AS ENUM (
    'use',
    'accept_keywords',
    'exclude',
    'env'
);


ALTER TYPE public.projects_portage_package_directorys OWNER TO buildbot;

--
-- Name: projects_repositorys_pkgcheck; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.projects_repositorys_pkgcheck AS ENUM (
    'package',
    'full',
    'none'
);


ALTER TYPE public.projects_repositorys_pkgcheck OWNER TO buildbot;

--
-- Name: projects_status; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.projects_status AS ENUM (
    'stable',
    'all',
    'unstable'
);


ALTER TYPE public.projects_status OWNER TO buildbot;

--
-- Name: repositorys_method; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.repositorys_method AS ENUM (
    'clobber',
    'fresh',
    'clean',
    'copy'
);


ALTER TYPE public.repositorys_method OWNER TO buildbot;

--
-- Name: repositorys_mode; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.repositorys_mode AS ENUM (
    'full',
    'incremental'
);


ALTER TYPE public.repositorys_mode OWNER TO buildbot;

--
-- Name: repositorys_type; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.repositorys_type AS ENUM (
    'git',
    'gitlab'
);


ALTER TYPE public.repositorys_type OWNER TO buildbot;

--
-- Name: versions_keywords_status; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.versions_keywords_status AS ENUM (
    'stable',
    'unstable',
    'negative',
    'all'
);


ALTER TYPE public.versions_keywords_status OWNER TO buildbot;

--
-- Name: versions_metadata_type; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.versions_metadata_type AS ENUM (
    'iuse',
    'properties',
    'required use',
    'restrict',
    'keyword'
);


ALTER TYPE public.versions_metadata_type OWNER TO buildbot;

--
-- Name: workers_config_type; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.workers_config_type AS ENUM (
    'cap_add',
    'security_opt'
);


ALTER TYPE public.workers_config_type OWNER TO buildbot;

--
-- Name: workers_images_type; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.workers_images_type AS ENUM (
    'docker'
);


ALTER TYPE public.workers_images_type OWNER TO buildbot;

--
-- Name: workers_type; Type: TYPE; Schema: public; Owner: buildbot
--

CREATE TYPE public.workers_type AS ENUM (
    'default',
    'local',
    'latent',
    'chroot',
    'docker',
    'log',
    'build'
);


ALTER TYPE public.workers_type OWNER TO buildbot;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: categorys; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.categorys (
    uuid character varying(36) NOT NULL,
    name character varying(100) NOT NULL
);


ALTER TABLE public.categorys OWNER TO buildbot;

--
-- Name: emails; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.emails (
    id integer DEFAULT nextval('public.packages_metadata_id_seq'::regclass) NOT NULL,
    email character varying(255)
);


ALTER TABLE public.emails OWNER TO buildbot;

--
-- Name: emails_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.emails_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.emails_id_seq OWNER TO buildbot;

--
-- Name: emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.emails_id_seq OWNED BY public.emails.id;


--
-- Name: keywords; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.keywords (
    id integer NOT NULL,
    name character varying(50) NOT NULL
);


ALTER TABLE public.keywords OWNER TO buildbot;

--
-- Name: migrate_version; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.migrate_version (
    repository_id character varying(250) NOT NULL,
    repository_path text,
    version integer
);


ALTER TABLE public.migrate_version OWNER TO buildbot;

--
-- Name: nodes; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.nodes (
    name character varying,
    docker_host_url character varying,
    enable boolean,
    uuid character varying(36) NOT NULL,
    bin_host_url character varying
);


ALTER TABLE public.nodes OWNER TO buildbot;

--
-- Name: nodes_workers; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.nodes_workers (
    id integer NOT NULL,
    worker_uuid character varying(36),
    node_uuid character varying(36)
);


ALTER TABLE public.nodes_workers OWNER TO buildbot;

--
-- Name: packages; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.packages (
    name character varying(100) NOT NULL,
    category_uuid character varying(36),
    repository_uuid character varying(36),
    deleted boolean,
    deleted_at integer,
    uuid character varying(36) NOT NULL
);


ALTER TABLE public.packages OWNER TO buildbot;

--
-- Name: packages_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.packages_emails_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.packages_emails_id_seq OWNER TO buildbot;

--
-- Name: packages_emails; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.packages_emails (
    id integer DEFAULT nextval('public.packages_emails_id_seq'::regclass) NOT NULL,
    package_uuid character varying,
    email_id integer,
    mail_type public.email_type,
    proxied public.email_proxied
);


ALTER TABLE public.packages_emails OWNER TO buildbot;

--
-- Name: packages_metadata_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.packages_metadata_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.packages_metadata_id_seq OWNER TO buildbot;

--
-- Name: packages_metadata; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.packages_metadata (
    id integer DEFAULT nextval('public.packages_metadata_id_seq'::regclass) NOT NULL,
    package_uuid character varying(36),
    sha256 character varying
);


ALTER TABLE public.packages_metadata OWNER TO buildbot;

--
-- Name: portages_makeconf; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.portages_makeconf (
    id integer NOT NULL,
    variable character varying(50) NOT NULL
);


ALTER TABLE public.portages_makeconf OWNER TO buildbot;

--
-- Name: portages_makeconf_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.portages_makeconf_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.portages_makeconf_id_seq OWNER TO buildbot;

--
-- Name: portages_makeconf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.portages_makeconf_id_seq OWNED BY public.portages_makeconf.id;


--
-- Name: projects; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.projects (
    uuid character varying(36) NOT NULL,
    name character varying(50) NOT NULL,
    description text,
    profile character varying(255) NOT NULL,
    profile_repository_uuid character varying(36) NOT NULL,
    keyword_id integer,
    status public.projects_status,
    auto boolean,
    enabled boolean,
    created_by integer NOT NULL,
    use_default boolean,
    image character varying(255),
    git_project_name character varying(255)
);


ALTER TABLE public.projects OWNER TO buildbot;

--
-- Name: projects_builds; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.projects_builds (
    id integer NOT NULL,
    project_uuid character varying(36),
    version_uuid character varying(36),
    build_id integer NOT NULL,
    buildbot_build_id integer DEFAULT 0,
    status public.projects_builds_status,
    requested boolean,
    created_at integer,
    updated_at integer,
    deleted_at integer,
    deleted boolean
);


ALTER TABLE public.projects_builds OWNER TO buildbot;

--
-- Name: projects_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.projects_builds_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.projects_builds_id_seq OWNER TO buildbot;

--
-- Name: projects_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.projects_builds_id_seq OWNED BY public.projects_builds.id;


--
-- Name: projects_emerge_options; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.projects_emerge_options (
    id integer NOT NULL,
    project_uuid character varying(36),
    oneshot boolean,
    depclean boolean,
    preserved_libs boolean
);


ALTER TABLE public.projects_emerge_options OWNER TO buildbot;

--
-- Name: projects_emerge_options_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.projects_emerge_options_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.projects_emerge_options_id_seq OWNER TO buildbot;

--
-- Name: projects_emerge_options_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.projects_emerge_options_id_seq OWNED BY public.projects_emerge_options.id;


--
-- Name: projects_pattern; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.projects_pattern (
    id integer NOT NULL,
    project_uuid character varying(36),
    search character varying(100) NOT NULL,
    start integer,
    "end" integer,
    type public.projects_pattern_type,
    status public.projects_pattern_status,
    search_type public.projects_pattern_search_type
);


ALTER TABLE public.projects_pattern OWNER TO buildbot;

--
-- Name: projects_pattern_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.projects_pattern_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.projects_pattern_id_seq OWNER TO buildbot;

--
-- Name: projects_pattern_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.projects_pattern_id_seq OWNED BY public.projects_pattern.id;


--
-- Name: projects_portage; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.projects_portage (
    id integer NOT NULL,
    project_uuid character varying(36),
    directorys public.projects_portage_directorys,
    value character varying(255) NOT NULL
);


ALTER TABLE public.projects_portage OWNER TO buildbot;

--
-- Name: projects_portage_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.projects_portage_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.projects_portage_id_seq OWNER TO buildbot;

--
-- Name: projects_portage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.projects_portage_id_seq OWNED BY public.projects_portage.id;


--
-- Name: projects_portages_env; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.projects_portages_env (
    id integer NOT NULL,
    project_uuid character varying(36),
    makeconf_id integer,
    name character varying(50) NOT NULL,
    value character varying(255) NOT NULL
);


ALTER TABLE public.projects_portages_env OWNER TO buildbot;

--
-- Name: projects_portages_env_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.projects_portages_env_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.projects_portages_env_id_seq OWNER TO buildbot;

--
-- Name: projects_portages_env_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.projects_portages_env_id_seq OWNED BY public.projects_portages_env.id;


--
-- Name: projects_portages_makeconf; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.projects_portages_makeconf (
    id integer NOT NULL,
    project_uuid character varying(36),
    makeconf_id integer,
    value character varying(255) NOT NULL
);


ALTER TABLE public.projects_portages_makeconf OWNER TO buildbot;

--
-- Name: projects_portages_makeconf_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.projects_portages_makeconf_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.projects_portages_makeconf_id_seq OWNER TO buildbot;

--
-- Name: projects_portages_makeconf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.projects_portages_makeconf_id_seq OWNED BY public.projects_portages_makeconf.id;


--
-- Name: projects_portages_package; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.projects_portages_package (
    id integer NOT NULL,
    project_uuid character varying(36),
    directory public.projects_portage_package_directorys,
    package character varying(50),
    value character varying(10)
);


ALTER TABLE public.projects_portages_package OWNER TO buildbot;

--
-- Name: projects_repositorys; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.projects_repositorys (
    id integer NOT NULL,
    project_uuid character varying(36),
    repository_uuid character varying(36),
    auto boolean,
    pkgcheck public.projects_repositorys_pkgcheck,
    build boolean,
    test boolean,
    test_mr boolean
);


ALTER TABLE public.projects_repositorys OWNER TO buildbot;

--
-- Name: projects_repositorys_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.projects_repositorys_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.projects_repositorys_id_seq OWNER TO buildbot;

--
-- Name: projects_repositorys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.projects_repositorys_id_seq OWNED BY public.projects_repositorys.id;


--
-- Name: projects_workers; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.projects_workers (
    id integer NOT NULL,
    project_uuid character varying(36),
    worker_uuid character varying(36)
);


ALTER TABLE public.projects_workers OWNER TO buildbot;

--
-- Name: repositorys; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.repositorys (
    name character varying(255) NOT NULL,
    description text,
    url character varying(255),
    auto boolean,
    enabled boolean,
    ebuild boolean,
    type public.repositorys_type,
    uuid character varying(36) NOT NULL,
    branch character varying(255),
    mode public.repositorys_mode,
    method public.repositorys_method,
    alwaysuselatest boolean,
    merge boolean,
    sshprivatekey character varying(50),
    sshhostkey character varying(50)
);


ALTER TABLE public.repositorys OWNER TO buildbot;

--
-- Name: repositorys_gitpullers; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.repositorys_gitpullers (
    id integer NOT NULL,
    repository_uuid character varying(36),
    project character varying(255) NOT NULL,
    url character varying(255) NOT NULL,
    branches character varying(255) NOT NULL,
    poll_interval integer NOT NULL,
    poll_random_delay_min integer NOT NULL,
    poll_random_delay_max integer NOT NULL,
    updated_at integer DEFAULT 0
);


ALTER TABLE public.repositorys_gitpullers OWNER TO buildbot;

--
-- Name: repositorys_gitpullers_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.repositorys_gitpullers_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.repositorys_gitpullers_id_seq OWNER TO buildbot;

--
-- Name: repositorys_gitpullers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.repositorys_gitpullers_id_seq OWNED BY public.repositorys_gitpullers.id;


--
-- Name: users; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.users (
    uid integer NOT NULL,
    email character varying(255) NOT NULL,
    bb_username character varying(128) DEFAULT NULL::character varying,
    bb_password character varying(128) DEFAULT NULL::character varying
);


ALTER TABLE public.users OWNER TO buildbot;

--
-- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.users_uid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.users_uid_seq OWNER TO buildbot;

--
-- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
--

ALTER SEQUENCE public.users_uid_seq OWNED BY public.users.uid;


--
-- Name: versions; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.versions (
    uuid character varying(36) NOT NULL,
    name character varying(255) NOT NULL,
    package_uuid character varying(36),
    file_hash character varying(255) NOT NULL,
    commit_id character varying(255) NOT NULL,
    deleted boolean,
    deleted_at integer
);


ALTER TABLE public.versions OWNER TO buildbot;

--
-- Name: versions_keywords; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.versions_keywords (
    uuid character varying(36) NOT NULL,
    keyword_id integer NOT NULL,
    version_uuid character varying(36),
    status public.versions_keywords_status
);


ALTER TABLE public.versions_keywords OWNER TO buildbot;

--
-- Name: versions_metadata_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
--

CREATE SEQUENCE public.versions_metadata_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 2147483647
    CACHE 1;


ALTER TABLE public.versions_metadata_id_seq OWNER TO buildbot;

--
-- Name: versions_metadata; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.versions_metadata (
    version_uuid character varying(36),
    metadata public.versions_metadata_type,
    value character varying(255),
    id integer DEFAULT nextval('public.versions_metadata_id_seq'::regclass) NOT NULL
);


ALTER TABLE public.versions_metadata OWNER TO buildbot;

--
-- Name: workers; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.workers (
    uuid character varying(36) NOT NULL,
    enable boolean,
    type public.workers_type,
    flavor_id integer,
    image_id integer
);


ALTER TABLE public.workers OWNER TO buildbot;

--
-- Name: workers_configs; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.workers_configs (
    id integer NOT NULL,
    worker_uuid character varying(36),
    type public.workers_config_type,
    value character varying
);


ALTER TABLE public.workers_configs OWNER TO buildbot;

--
-- Name: workers_flavers; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.workers_flavers (
    id integer NOT NULL,
    name character varying,
    ram integer,
    cpu integer
);


ALTER TABLE public.workers_flavers OWNER TO buildbot;

--
-- Name: workers_images; Type: TABLE; Schema: public; Owner: buildbot
--

CREATE TABLE public.workers_images (
    id integer NOT NULL,
    name character varying,
    tag character varying,
    dockerfile character varying,
    bootstrap_tag character varying,
    type public.workers_images_type
);


ALTER TABLE public.workers_images OWNER TO buildbot;


--
-- Name: portages_makeconf id; Type: DEFAULT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.portages_makeconf ALTER COLUMN id SET DEFAULT nextval('public.portages_makeconf_id_seq'::regclass);


--
-- Name: projects_builds id; Type: DEFAULT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_builds ALTER COLUMN id SET DEFAULT nextval('public.projects_builds_id_seq'::regclass);


--
-- Name: projects_emerge_options id; Type: DEFAULT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_emerge_options ALTER COLUMN id SET DEFAULT nextval('public.projects_emerge_options_id_seq'::regclass);


--
-- Name: projects_pattern id; Type: DEFAULT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_pattern ALTER COLUMN id SET DEFAULT nextval('public.projects_pattern_id_seq'::regclass);


--
-- Name: projects_portage id; Type: DEFAULT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portage ALTER COLUMN id SET DEFAULT nextval('public.projects_portage_id_seq'::regclass);


--
-- Name: projects_portages_env id; Type: DEFAULT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_env ALTER COLUMN id SET DEFAULT nextval('public.projects_portages_env_id_seq'::regclass);


--
-- Name: projects_portages_makeconf id; Type: DEFAULT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_makeconf ALTER COLUMN id SET DEFAULT nextval('public.projects_portages_makeconf_id_seq'::regclass);


--
-- Name: projects_repositorys id; Type: DEFAULT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_repositorys ALTER COLUMN id SET DEFAULT nextval('public.projects_repositorys_id_seq'::regclass);


--
-- Name: repositorys_gitpullers id; Type: DEFAULT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.repositorys_gitpullers ALTER COLUMN id SET DEFAULT nextval('public.repositorys_gitpullers_id_seq'::regclass);


--
-- Name: users uid; Type: DEFAULT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.users ALTER COLUMN uid SET DEFAULT nextval('public.users_uid_seq'::regclass);


--
-- Name: categorys categorys_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.categorys
    ADD CONSTRAINT categorys_pkey PRIMARY KEY (uuid);


--
-- Name: categorys categorys_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.categorys
    ADD CONSTRAINT categorys_unique UNIQUE (uuid);


--
-- Name: emails email_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.emails
    ADD CONSTRAINT email_pkey PRIMARY KEY (id);


--
-- Name: keywords keywords_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.keywords
    ADD CONSTRAINT keywords_pkey PRIMARY KEY (id);


--
-- Name: keywords keywords_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.keywords
    ADD CONSTRAINT keywords_unique UNIQUE (id);


--
-- Name: migrate_version migrate_version_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.migrate_version
    ADD CONSTRAINT migrate_version_pkey PRIMARY KEY (repository_id);


--
-- Name: nodes nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.nodes
    ADD CONSTRAINT nodes_pkey PRIMARY KEY (uuid);


--
-- Name: nodes_workers nodes_workers_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.nodes_workers
    ADD CONSTRAINT nodes_workers_pkey PRIMARY KEY (id);


--
-- Name: packages_emails packages_emails_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.packages_emails
    ADD CONSTRAINT packages_emails_pkey PRIMARY KEY (id);


--
-- Name: packages_metadata packages_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.packages_metadata
    ADD CONSTRAINT packages_metadata_pkey PRIMARY KEY (id);


--
-- Name: packages packages_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.packages
    ADD CONSTRAINT packages_pkey PRIMARY KEY (uuid);


--
-- Name: packages packages_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.packages
    ADD CONSTRAINT packages_unique UNIQUE (uuid);


--
-- Name: portages_makeconf portages_makeconf_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.portages_makeconf
    ADD CONSTRAINT portages_makeconf_pkey PRIMARY KEY (id);


--
-- Name: portages_makeconf portages_makeconf_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.portages_makeconf
    ADD CONSTRAINT portages_makeconf_unique UNIQUE (id);


--
-- Name: projects_builds projects_builds_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_builds
    ADD CONSTRAINT projects_builds_pkey PRIMARY KEY (id);


--
-- Name: projects_builds projects_builds_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_builds
    ADD CONSTRAINT projects_builds_unique UNIQUE (id);


--
-- Name: projects_emerge_options projects_emerge_options_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_emerge_options
    ADD CONSTRAINT projects_emerge_options_pkey PRIMARY KEY (id);


--
-- Name: projects_emerge_options projects_emerge_options_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_emerge_options
    ADD CONSTRAINT projects_emerge_options_unique UNIQUE (id);


--
-- Name: projects_pattern projects_pattern_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_pattern
    ADD CONSTRAINT projects_pattern_pkey PRIMARY KEY (id);


--
-- Name: projects_pattern projects_pattern_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_pattern
    ADD CONSTRAINT projects_pattern_unique UNIQUE (id);


--
-- Name: projects projects_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT projects_pkey PRIMARY KEY (uuid);


--
-- Name: projects_portages_package projects_portage_package_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_package
    ADD CONSTRAINT projects_portage_package_pkey PRIMARY KEY (id);


--
-- Name: projects_portage projects_portage_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portage
    ADD CONSTRAINT projects_portage_pkey PRIMARY KEY (id);


--
-- Name: projects_portage projects_portage_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portage
    ADD CONSTRAINT projects_portage_unique UNIQUE (id);


--
-- Name: projects_portages_env projects_portages_env_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_env
    ADD CONSTRAINT projects_portages_env_pkey PRIMARY KEY (id);


--
-- Name: projects_portages_env projects_portages_env_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_env
    ADD CONSTRAINT projects_portages_env_unique UNIQUE (id);


--
-- Name: projects_portages_makeconf projects_portages_makeconf_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_makeconf
    ADD CONSTRAINT projects_portages_makeconf_pkey PRIMARY KEY (id);


--
-- Name: projects_portages_makeconf projects_portages_makeconf_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_makeconf
    ADD CONSTRAINT projects_portages_makeconf_unique UNIQUE (id);


--
-- Name: projects_repositorys projects_repositorys_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_repositorys
    ADD CONSTRAINT projects_repositorys_pkey PRIMARY KEY (id);


--
-- Name: projects_repositorys projects_repositorys_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_repositorys
    ADD CONSTRAINT projects_repositorys_unique UNIQUE (id);


--
-- Name: projects projects_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT projects_unique UNIQUE (uuid);


--
-- Name: projects_workers projects_workers_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_workers
    ADD CONSTRAINT projects_workers_pkey PRIMARY KEY (id);


--
-- Name: repositorys_gitpullers repositorys_gitpullers_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.repositorys_gitpullers
    ADD CONSTRAINT repositorys_gitpullers_pkey PRIMARY KEY (id);


--
-- Name: repositorys_gitpullers repositorys_gitpullers_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.repositorys_gitpullers
    ADD CONSTRAINT repositorys_gitpullers_unique UNIQUE (id);


--
-- Name: repositorys repositorys_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.repositorys
    ADD CONSTRAINT repositorys_pkey PRIMARY KEY (uuid);


--
-- Name: repositorys repositorys_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.repositorys
    ADD CONSTRAINT repositorys_unique UNIQUE (uuid);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (uid);


--
-- Name: users users_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_unique UNIQUE (uid);


--
-- Name: versions_keywords versions_keywords_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.versions_keywords
    ADD CONSTRAINT versions_keywords_pkey PRIMARY KEY (uuid);


--
-- Name: versions_keywords versions_keywords_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.versions_keywords
    ADD CONSTRAINT versions_keywords_unique UNIQUE (uuid);


--
-- Name: versions_metadata versions_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.versions_metadata
    ADD CONSTRAINT versions_metadata_pkey PRIMARY KEY (id);


--
-- Name: versions versions_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.versions
    ADD CONSTRAINT versions_pkey PRIMARY KEY (uuid);


--
-- Name: versions versions_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.versions
    ADD CONSTRAINT versions_unique UNIQUE (uuid);


--
-- Name: workers_configs workers_configs_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.workers_configs
    ADD CONSTRAINT workers_configs_pkey PRIMARY KEY (id);


--
-- Name: workers_flavers workers_flavers_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.workers_flavers
    ADD CONSTRAINT workers_flavers_pkey PRIMARY KEY (id);


--
-- Name: workers_images workers_images_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.workers_images
    ADD CONSTRAINT workers_images_pkey PRIMARY KEY (id);


--
-- Name: workers workers_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.workers
    ADD CONSTRAINT workers_pkey PRIMARY KEY (uuid);


--
-- Name: packages category_uuid_fk; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.packages
    ADD CONSTRAINT category_uuid_fk FOREIGN KEY (category_uuid) REFERENCES public.categorys(uuid) NOT VALID;


--
-- Name: packages_emails email_id; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.packages_emails
    ADD CONSTRAINT email_id FOREIGN KEY (email_id) REFERENCES public.emails(id);


--
-- Name: projects keywords_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT keywords_fkey FOREIGN KEY (keyword_id) REFERENCES public.keywords(id) NOT VALID;


--
-- Name: versions_keywords keywords_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.versions_keywords
    ADD CONSTRAINT keywords_fkey FOREIGN KEY (keyword_id) REFERENCES public.keywords(id) NOT VALID;


--
-- Name: projects_portages_env makeconf_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_env
    ADD CONSTRAINT makeconf_fkey FOREIGN KEY (makeconf_id) REFERENCES public.portages_makeconf(id) NOT VALID;


--
-- Name: projects_portages_makeconf makeconf_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_makeconf
    ADD CONSTRAINT makeconf_fkey FOREIGN KEY (makeconf_id) REFERENCES public.portages_makeconf(id) NOT VALID;


--
-- Name: packages_emails package_uuid; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.packages_emails
    ADD CONSTRAINT package_uuid FOREIGN KEY (package_uuid) REFERENCES public.packages(uuid);


--
-- Name: packages_metadata package_uuid; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.packages_metadata
    ADD CONSTRAINT package_uuid FOREIGN KEY (package_uuid) REFERENCES public.packages(uuid) NOT VALID;


--
-- Name: versions packages_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.versions
    ADD CONSTRAINT packages_fkey FOREIGN KEY (package_uuid) REFERENCES public.packages(uuid) NOT VALID;


--
-- Name: projects profile_repositorys_uuid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT profile_repositorys_uuid_fkey FOREIGN KEY (profile_repository_uuid) REFERENCES public.repositorys(uuid) NOT VALID;


--
-- Name: projects_portages_package project_portage_package_pkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_package
    ADD CONSTRAINT project_portage_package_pkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;


--
-- Name: projects_builds projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_builds
    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;


--
-- Name: projects_emerge_options projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_emerge_options
    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;


--
-- Name: projects_pattern projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_pattern
    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;


--
-- Name: projects_portage projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portage
    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;


--
-- Name: projects_portages_env projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_env
    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;


--
-- Name: projects_portages_makeconf projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_portages_makeconf
    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;


--
-- Name: projects_repositorys projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_repositorys
    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;


--
-- Name: projects_repositorys repositorys_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_repositorys
    ADD CONSTRAINT repositorys_fkey FOREIGN KEY (repository_uuid) REFERENCES public.repositorys(uuid) NOT VALID;


--
-- Name: repositorys_gitpullers repositorys_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.repositorys_gitpullers
    ADD CONSTRAINT repositorys_fkey FOREIGN KEY (repository_uuid) REFERENCES public.repositorys(uuid) NOT VALID;


--
-- Name: packages repositorys_uuid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.packages
    ADD CONSTRAINT repositorys_uuid_fkey FOREIGN KEY (repository_uuid) REFERENCES public.repositorys(uuid) NOT VALID;


--
-- Name: projects_builds versions_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.projects_builds
    ADD CONSTRAINT versions_fkey FOREIGN KEY (version_uuid) REFERENCES public.versions(uuid) NOT VALID;


--
-- Name: versions_keywords versions_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.versions_keywords
    ADD CONSTRAINT versions_fkey FOREIGN KEY (version_uuid) REFERENCES public.versions(uuid) NOT VALID;


--
-- Name: versions_metadata versions_metadata_version_uuid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
--

ALTER TABLE ONLY public.versions_metadata
    ADD CONSTRAINT versions_metadata_version_uuid_fkey FOREIGN KEY (version_uuid) REFERENCES public.versions(uuid);


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildbot
--

REVOKE ALL ON SCHEMA public FROM buildbot;
GRANT ALL ON SCHEMA public TO buildbot;


--
-- PostgreSQL database dump complete
--