commit: 208581e198518f70fa2bfad0e01418eed8b345a1
Author: Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Sun Aug 21 08:43:00 2022 +0000
Commit: Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Sun Aug 21 08:43:00 2022 +0000
URL:
https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=208581e1
Add gentoo ci db schema
Signed-off-by: Magnus Granberg <zorry <AT> gentoo.org>
sql/gentoo_ci_schema.sql | 1525 ++++++++++++++++++++++++++++++++++++++++++++++
1 file changed, 1525 insertions(+)
diff --git a/sql/gentoo_ci_schema.sql b/sql/gentoo_ci_schema.sql
new file mode 100644
index 0000000..f1725fa
--- /dev/null
+++ b/sql/gentoo_ci_schema.sql
@@ -0,0 +1,1525 @@
+--
+-- PostgreSQL database dump
+--
+
+-- Dumped from database version 13.3
+-- Dumped by pg_dump version 13.5
+
+-- Started on 2022-08-21 10:37:12 CEST
+
+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;
+
+--
+-- TOC entry 2475 (class 1262 OID 155811)
+-- Name: gentoo-ci; Type: DATABASE; Schema: -; Owner: buildbot
+--
+
+CREATE DATABASE "gentoo-ci" WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE
= 'sv_SE.utf8';
+
+
+ALTER DATABASE "gentoo-ci" OWNER TO buildbot;
+
+\connect -reuse-previous=on "dbname='gentoo-ci'"
+
+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;
+
+--
+-- TOC entry 655 (class 1247 OID 155813)
+-- 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;
+
+--
+-- TOC entry 658 (class 1247 OID 155824)
+-- 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;
+
+--
+-- TOC entry 661 (class 1247 OID 155834)
+-- 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;
+
+--
+-- TOC entry 664 (class 1247 OID 155844)
+-- 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;
+
+--
+-- TOC entry 667 (class 1247 OID 155868)
+-- 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;
+
+--
+-- TOC entry 761 (class 1247 OID 550221)
+-- 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;
+
+--
+-- TOC entry 670 (class 1247 OID 155874)
+-- 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;
+
+--
+-- TOC entry 673 (class 1247 OID 155882)
+-- 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;
+
+--
+-- TOC entry 777 (class 1247 OID 1708870)
+-- Name: repositorys_method; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE public.repositorys_method AS ENUM (
+ 'clobber',
+ 'fresh',
+ 'clean',
+ 'copy'
+);
+
+
+ALTER TYPE public.repositorys_method OWNER TO postgres;
+
+--
+-- TOC entry 774 (class 1247 OID 1708856)
+-- Name: repositorys_mode; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE public.repositorys_mode AS ENUM (
+ 'full',
+ 'incremental'
+);
+
+
+ALTER TYPE public.repositorys_mode OWNER TO postgres;
+
+--
+-- TOC entry 676 (class 1247 OID 155890)
+-- Name: repositorys_type; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.repositorys_type AS ENUM (
+ 'gitpuller',
+ 'git',
+ 'gitlab'
+);
+
+
+ALTER TYPE public.repositorys_type OWNER TO buildbot;
+
+--
+-- TOC entry 679 (class 1247 OID 155894)
+-- 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;
+
+--
+-- TOC entry 767 (class 1247 OID 698031)
+-- 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;
+
+--
+-- TOC entry 758 (class 1247 OID 488393)
+-- Name: workers_type; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.workers_type AS ENUM (
+ 'default',
+ 'local',
+ 'latent',
+ 'chroot',
+ 'docker'
+);
+
+
+ALTER TYPE public.workers_type OWNER TO buildbot;
+
+SET default_tablespace = '';
+
+SET default_table_access_method = heap;
+
+--
+-- TOC entry 200 (class 1259 OID 155903)
+-- 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;
+
+--
+-- TOC entry 201 (class 1259 OID 155906)
+-- 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;
+
+--
+-- TOC entry 202 (class 1259 OID 155909)
+-- 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;
+
+--
+-- TOC entry 203 (class 1259 OID 155915)
+-- 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;
+
+--
+-- TOC entry 204 (class 1259 OID 155918)
+-- 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;
+
+--
+-- TOC entry 205 (class 1259 OID 155921)
+-- 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;
+
+--
+-- TOC entry 2477 (class 0 OID 0)
+-- Dependencies: 205
+-- 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;
+
+
+--
+-- TOC entry 206 (class 1259 OID 155923)
+-- 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;
+
+--
+-- TOC entry 207 (class 1259 OID 155929)
+-- 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;
+
+--
+-- TOC entry 208 (class 1259 OID 155933)
+-- 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;
+
+--
+-- TOC entry 2478 (class 0 OID 0)
+-- Dependencies: 208
+-- 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;
+
+
+--
+-- TOC entry 209 (class 1259 OID 155935)
+-- 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;
+
+--
+-- TOC entry 210 (class 1259 OID 155938)
+-- 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;
+
+--
+-- TOC entry 2479 (class 0 OID 0)
+-- Dependencies: 210
+-- 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;
+
+
+--
+-- TOC entry 211 (class 1259 OID 155940)
+-- 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;
+
+--
+-- TOC entry 212 (class 1259 OID 155943)
+-- 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;
+
+--
+-- TOC entry 2480 (class 0 OID 0)
+-- Dependencies: 212
+-- 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;
+
+
+--
+-- TOC entry 213 (class 1259 OID 155945)
+-- 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;
+
+--
+-- TOC entry 214 (class 1259 OID 155948)
+-- 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;
+
+--
+-- TOC entry 2481 (class 0 OID 0)
+-- Dependencies: 214
+-- 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;
+
+
+--
+-- TOC entry 215 (class 1259 OID 155950)
+-- 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;
+
+--
+-- TOC entry 216 (class 1259 OID 155953)
+-- 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;
+
+--
+-- TOC entry 2482 (class 0 OID 0)
+-- Dependencies: 216
+-- 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;
+
+
+--
+-- TOC entry 217 (class 1259 OID 155955)
+-- 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;
+
+--
+-- TOC entry 218 (class 1259 OID 155958)
+-- 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;
+
+--
+-- TOC entry 2483 (class 0 OID 0)
+-- Dependencies: 218
+-- 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;
+
+
+--
+-- TOC entry 230 (class 1259 OID 550229)
+-- Name: projects_portages_package; Type: TABLE; Schema: public; Owner:
buildbot
+--
+
+CREATE TABLE public.projects_portages_package (
+ id bigint 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;
+
+--
+-- TOC entry 219 (class 1259 OID 155960)
+-- 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;
+
+--
+-- TOC entry 220 (class 1259 OID 155963)
+-- 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;
+
+--
+-- TOC entry 2484 (class 0 OID 0)
+-- Dependencies: 220
+-- 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;
+
+
+--
+-- TOC entry 229 (class 1259 OID 484107)
+-- Name: projects_workers; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects_workers (
+ id bigint NOT NULL,
+ project_uuid character varying(36),
+ worker_uuid character varying(36)
+);
+
+
+ALTER TABLE public.projects_workers OWNER TO buildbot;
+
+--
+-- TOC entry 221 (class 1259 OID 155965)
+-- 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;
+
+--
+-- TOC entry 222 (class 1259 OID 155971)
+-- 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;
+
+--
+-- TOC entry 223 (class 1259 OID 155978)
+-- 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;
+
+--
+-- TOC entry 2485 (class 0 OID 0)
+-- Dependencies: 223
+-- 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;
+
+
+--
+-- TOC entry 224 (class 1259 OID 155980)
+-- 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;
+
+--
+-- TOC entry 225 (class 1259 OID 155988)
+-- 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;
+
+--
+-- TOC entry 2486 (class 0 OID 0)
+-- Dependencies: 225
+-- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
buildbot
+--
+
+ALTER SEQUENCE public.users_uid_seq OWNED BY public.users.uid;
+
+
+--
+-- TOC entry 226 (class 1259 OID 155990)
+-- 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;
+
+--
+-- TOC entry 227 (class 1259 OID 155996)
+-- 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;
+
+--
+-- TOC entry 232 (class 1259 OID 702199)
+-- 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;
+
+--
+-- TOC entry 231 (class 1259 OID 698041)
+-- 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;
+
+--
+-- TOC entry 228 (class 1259 OID 484104)
+-- Name: workers; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.workers (
+ uuid character varying(36),
+ enable boolean,
+ type public.workers_type
+);
+
+
+ALTER TABLE public.workers OWNER TO buildbot;
+
+--
+-- TOC entry 2228 (class 2604 OID 155999)
+-- 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);
+
+
+--
+-- TOC entry 2230 (class 2604 OID 156000)
+-- 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);
+
+
+--
+-- TOC entry 2231 (class 2604 OID 156001)
+-- 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);
+
+
+--
+-- TOC entry 2232 (class 2604 OID 156002)
+-- 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);
+
+
+--
+-- TOC entry 2233 (class 2604 OID 156003)
+-- 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);
+
+
+--
+-- TOC entry 2234 (class 2604 OID 156004)
+-- 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);
+
+
+--
+-- TOC entry 2235 (class 2604 OID 156005)
+-- 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);
+
+
+--
+-- TOC entry 2236 (class 2604 OID 156006)
+-- 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);
+
+
+--
+-- TOC entry 2238 (class 2604 OID 156007)
+-- 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);
+
+
+--
+-- TOC entry 2241 (class 2604 OID 156008)
+-- 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);
+
+
+--
+-- TOC entry 2244 (class 2606 OID 156010)
+-- Name: categorys categorys_pkey; Type: CONSTRAINT; Schema: public; Owner:
buildbot
+--
+
+ALTER TABLE ONLY public.categorys
+ ADD CONSTRAINT categorys_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2246 (class 2606 OID 156012)
+-- Name: categorys categorys_unique; Type: CONSTRAINT; Schema: public; Owner:
buildbot
+--
+
+ALTER TABLE ONLY public.categorys
+ ADD CONSTRAINT categorys_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2248 (class 2606 OID 156014)
+-- Name: keywords keywords_pkey; Type: CONSTRAINT; Schema: public; Owner:
buildbot
+--
+
+ALTER TABLE ONLY public.keywords
+ ADD CONSTRAINT keywords_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2250 (class 2606 OID 156016)
+-- Name: keywords keywords_unique; Type: CONSTRAINT; Schema: public; Owner:
buildbot
+--
+
+ALTER TABLE ONLY public.keywords
+ ADD CONSTRAINT keywords_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2252 (class 2606 OID 156018)
+-- 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);
+
+
+--
+-- TOC entry 2254 (class 2606 OID 156020)
+-- Name: packages packages_pkey; Type: CONSTRAINT; Schema: public; Owner:
buildbot
+--
+
+ALTER TABLE ONLY public.packages
+ ADD CONSTRAINT packages_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2256 (class 2606 OID 156022)
+-- Name: packages packages_unique; Type: CONSTRAINT; Schema: public; Owner:
buildbot
+--
+
+ALTER TABLE ONLY public.packages
+ ADD CONSTRAINT packages_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2258 (class 2606 OID 156024)
+-- 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);
+
+
+--
+-- TOC entry 2260 (class 2606 OID 156026)
+-- 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);
+
+
+--
+-- TOC entry 2266 (class 2606 OID 156028)
+-- 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);
+
+
+--
+-- TOC entry 2268 (class 2606 OID 156030)
+-- 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);
+
+
+--
+-- TOC entry 2270 (class 2606 OID 156032)
+-- 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);
+
+
+--
+-- TOC entry 2272 (class 2606 OID 156034)
+-- 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);
+
+
+--
+-- TOC entry 2274 (class 2606 OID 156036)
+-- 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);
+
+
+--
+-- TOC entry 2276 (class 2606 OID 156038)
+-- 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);
+
+
+--
+-- TOC entry 2262 (class 2606 OID 156040)
+-- Name: projects projects_pkey; Type: CONSTRAINT; Schema: public; Owner:
buildbot
+--
+
+ALTER TABLE ONLY public.projects
+ ADD CONSTRAINT projects_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2316 (class 2606 OID 550233)
+-- 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);
+
+
+--
+-- TOC entry 2278 (class 2606 OID 156042)
+-- 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);
+
+
+--
+-- TOC entry 2280 (class 2606 OID 156044)
+-- 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);
+
+
+--
+-- TOC entry 2282 (class 2606 OID 156046)
+-- 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);
+
+
+--
+-- TOC entry 2284 (class 2606 OID 156048)
+-- 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);
+
+
+--
+-- TOC entry 2286 (class 2606 OID 156050)
+-- 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);
+
+
+--
+-- TOC entry 2288 (class 2606 OID 156052)
+-- 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);
+
+
+--
+-- TOC entry 2290 (class 2606 OID 156054)
+-- 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);
+
+
+--
+-- TOC entry 2292 (class 2606 OID 156056)
+-- 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);
+
+
+--
+-- TOC entry 2264 (class 2606 OID 156058)
+-- Name: projects projects_unique; Type: CONSTRAINT; Schema: public; Owner:
buildbot
+--
+
+ALTER TABLE ONLY public.projects
+ ADD CONSTRAINT projects_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2314 (class 2606 OID 484111)
+-- 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);
+
+
+--
+-- TOC entry 2298 (class 2606 OID 156060)
+-- 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);
+
+
+--
+-- TOC entry 2300 (class 2606 OID 156062)
+-- 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);
+
+
+--
+-- TOC entry 2294 (class 2606 OID 156064)
+-- Name: repositorys repositorys_pkey; Type: CONSTRAINT; Schema: public;
Owner: buildbot
+--
+
+ALTER TABLE ONLY public.repositorys
+ ADD CONSTRAINT repositorys_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2296 (class 2606 OID 156066)
+-- Name: repositorys repositorys_unique; Type: CONSTRAINT; Schema: public;
Owner: buildbot
+--
+
+ALTER TABLE ONLY public.repositorys
+ ADD CONSTRAINT repositorys_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2302 (class 2606 OID 156068)
+-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.users
+ ADD CONSTRAINT users_pkey PRIMARY KEY (uid);
+
+
+--
+-- TOC entry 2304 (class 2606 OID 156070)
+-- Name: users users_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.users
+ ADD CONSTRAINT users_unique UNIQUE (uid);
+
+
+--
+-- TOC entry 2310 (class 2606 OID 156072)
+-- 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);
+
+
+--
+-- TOC entry 2312 (class 2606 OID 156074)
+-- 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);
+
+
+--
+-- TOC entry 2318 (class 2606 OID 698703)
+-- 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);
+
+
+--
+-- TOC entry 2306 (class 2606 OID 156076)
+-- Name: versions versions_pkey; Type: CONSTRAINT; Schema: public; Owner:
buildbot
+--
+
+ALTER TABLE ONLY public.versions
+ ADD CONSTRAINT versions_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2308 (class 2606 OID 156078)
+-- Name: versions versions_unique; Type: CONSTRAINT; Schema: public; Owner:
buildbot
+--
+
+ALTER TABLE ONLY public.versions
+ ADD CONSTRAINT versions_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2319 (class 2606 OID 156079)
+-- 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;
+
+
+--
+-- TOC entry 2321 (class 2606 OID 156084)
+-- 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;
+
+
+--
+-- TOC entry 2336 (class 2606 OID 156089)
+-- 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;
+
+
+--
+-- TOC entry 2328 (class 2606 OID 156094)
+-- 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;
+
+
+--
+-- TOC entry 2330 (class 2606 OID 156099)
+-- 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;
+
+
+--
+-- TOC entry 2335 (class 2606 OID 156104)
+-- 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;
+
+
+--
+-- TOC entry 2322 (class 2606 OID 156109)
+-- 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;
+
+
+--
+-- TOC entry 2338 (class 2606 OID 550234)
+-- 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;
+
+
+--
+-- TOC entry 2323 (class 2606 OID 156114)
+-- 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;
+
+
+--
+-- TOC entry 2325 (class 2606 OID 156119)
+-- 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;
+
+
+--
+-- TOC entry 2326 (class 2606 OID 156124)
+-- 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;
+
+
+--
+-- TOC entry 2327 (class 2606 OID 156129)
+-- 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;
+
+
+--
+-- TOC entry 2329 (class 2606 OID 156134)
+-- 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;
+
+
+--
+-- TOC entry 2331 (class 2606 OID 156139)
+-- 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;
+
+
+--
+-- TOC entry 2332 (class 2606 OID 156144)
+-- 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;
+
+
+--
+-- TOC entry 2333 (class 2606 OID 156149)
+-- 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;
+
+
+--
+-- TOC entry 2334 (class 2606 OID 156154)
+-- 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;
+
+
+--
+-- TOC entry 2320 (class 2606 OID 156159)
+-- 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;
+
+
+--
+-- TOC entry 2324 (class 2606 OID 156164)
+-- 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;
+
+
+--
+-- TOC entry 2337 (class 2606 OID 156169)
+-- 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;
+
+
+--
+-- TOC entry 2339 (class 2606 OID 698046)
+-- 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);
+
+
+--
+-- TOC entry 2476 (class 0 OID 0)
+-- Dependencies: 3
+-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
+--
+
+REVOKE ALL ON SCHEMA public FROM postgres;
+GRANT ALL ON SCHEMA public TO buildbot;
+
+
+-- Completed on 2022-08-21 10:37:13 CEST
+
+--
+-- PostgreSQL database dump complete
+--
+
