);
---
--- Name: builders_history; Type: TABLE; Schema: public; Owner: -
---
-
-CREATE TABLE public.builders_history (
- id integer NOT NULL,
- builder_id integer NOT NULL,
- action text NOT NULL,
- user_id integer,
- "time" timestamp without time zone NOT NULL
-);
-
-
---
--- Name: builders_history_id_seq; Type: SEQUENCE; Schema: public; Owner: -
---
-
-CREATE SEQUENCE public.builders_history_id_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
---
--- Name: builders_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
---
-
-ALTER SEQUENCE public.builders_history_id_seq OWNED BY public.builders_history.id;
-
-
--
-- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER SEQUENCE public.builds_comments_id_seq OWNED BY public.builds_comments.id;
---
--- Name: builds_history; Type: TABLE; Schema: public; Owner: -
---
-
-CREATE TABLE public.builds_history (
- id integer NOT NULL,
- build_id integer NOT NULL,
- action text NOT NULL,
- user_id integer,
- "time" timestamp without time zone NOT NULL,
- bug_id integer
-);
-
-
---
--- Name: builds_history_id_seq; Type: SEQUENCE; Schema: public; Owner: -
---
-
-CREATE SEQUENCE public.builds_history_id_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
---
--- Name: builds_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
---
-
-ALTER SEQUENCE public.builds_history_id_seq OWNED BY public.builds_history.id;
-
-
--
-- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
);
---
--- Name: jobs_history; Type: TABLE; Schema: public; Owner: -
---
-
-CREATE TABLE public.jobs_history (
- job_id integer NOT NULL,
- action text NOT NULL,
- state text,
- user_id integer,
- "time" timestamp without time zone NOT NULL,
- builder_id integer,
- test_job_id integer
-);
-
-
--
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER SEQUENCE public.mirrors_checks_id_seq OWNED BY public.mirrors_checks.id;
---
--- Name: mirrors_history; Type: TABLE; Schema: public; Owner: -
---
-
-CREATE TABLE public.mirrors_history (
- id integer NOT NULL,
- mirror_id integer NOT NULL,
- action text NOT NULL,
- user_id integer,
- "time" timestamp without time zone NOT NULL
-);
-
-
---
--- Name: mirrors_history_id_seq; Type: SEQUENCE; Schema: public; Owner: -
---
-
-CREATE SEQUENCE public.mirrors_history_id_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
-
-
---
--- Name: mirrors_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
---
-
-ALTER SEQUENCE public.mirrors_history_id_seq OWNED BY public.mirrors_history.id;
-
-
--
-- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER SEQUENCE public.repositories_builds_id_seq OWNED BY public.repositories_builds.id;
---
--- Name: repositories_history; Type: TABLE; Schema: public; Owner: -
---
-
-CREATE TABLE public.repositories_history (
- build_id bigint NOT NULL,
- action text NOT NULL,
- from_repo_id integer,
- to_repo_id integer,
- user_id integer,
- "time" timestamp without time zone NOT NULL
-);
-
-
--
-- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
ALTER TABLE ONLY public.builders ALTER COLUMN id SET DEFAULT nextval('public.builders_id_seq'::regclass);
---
--- Name: builders_history id; Type: DEFAULT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.builders_history ALTER COLUMN id SET DEFAULT nextval('public.builders_history_id_seq'::regclass);
-
-
--
-- Name: builds id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.builds_comments ALTER COLUMN id SET DEFAULT nextval('public.builds_comments_id_seq'::regclass);
---
--- Name: builds_history id; Type: DEFAULT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.builds_history ALTER COLUMN id SET DEFAULT nextval('public.builds_history_id_seq'::regclass);
-
-
--
-- Name: distributions id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY public.mirrors_checks ALTER COLUMN id SET DEFAULT nextval('public.mirrors_checks_id_seq'::regclass);
---
--- Name: mirrors_history id; Type: DEFAULT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.mirrors_history ALTER COLUMN id SET DEFAULT nextval('public.mirrors_history_id_seq'::regclass);
-
-
--
-- Name: packages id; Type: DEFAULT; Schema: public; Owner: -
--
ADD CONSTRAINT idx_2197954_primary PRIMARY KEY (id);
---
--- Name: builders_history idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.builders_history
- ADD CONSTRAINT idx_2197982_primary PRIMARY KEY (id);
-
-
--
-- Name: builds_bugs_updates idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: -
--
ADD CONSTRAINT idx_2198018_primary PRIMARY KEY (id);
---
--- Name: builds_history idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.builds_history
- ADD CONSTRAINT idx_2198027_primary PRIMARY KEY (id);
-
-
--
-- Name: images_types idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: -
--
ADD CONSTRAINT idx_2198115_primary PRIMARY KEY (id);
---
--- Name: mirrors_history idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.mirrors_history
- ADD CONSTRAINT idx_2198126_primary PRIMARY KEY (id);
-
-
--
-- Name: packages_properties idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE public.filelists CLUSTER ON filelists_pkg_id;
---
--- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: -
---
-
-CREATE INDEX idx_2197982_builder_id ON public.builders_history USING btree (builder_id);
-
-
--
-- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX idx_2198018_user_id ON public.builds_comments USING btree (user_id);
---
--- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: -
---
-
-CREATE INDEX idx_2198080_job_id ON public.jobs_history USING btree (job_id);
-
-
--
-- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX idx_2198189_build_id ON public.repositories_builds USING btree (build_id);
---
--- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: -
---
-
-CREATE INDEX idx_2198193_build_id ON public.repositories_history USING btree (build_id);
-
-
--
-- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: -
--
ADD CONSTRAINT builder_stats_builder_id FOREIGN KEY (builder_id) REFERENCES public.builders(id);
---
--- Name: builders_history builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.builders_history
- ADD CONSTRAINT builders_history_builder_id FOREIGN KEY (builder_id) REFERENCES public.builders(id);
-
-
---
--- Name: builders_history builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.builders_history
- ADD CONSTRAINT builders_history_user_id FOREIGN KEY (user_id) REFERENCES public.users(id);
-
-
--
-- Name: builds builds_build_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ADD CONSTRAINT builds_comments_user_id FOREIGN KEY (user_id) REFERENCES public.users(id);
---
--- Name: builds_history builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.builds_history
- ADD CONSTRAINT builds_history_build_id FOREIGN KEY (build_id) REFERENCES public.builds(id);
-
-
---
--- Name: builds_history builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.builds_history
- ADD CONSTRAINT builds_history_user_id FOREIGN KEY (user_id) REFERENCES public.users(id);
-
-
--
-- Name: builds builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ADD CONSTRAINT jobs_buildroots_job_id FOREIGN KEY (job_id) REFERENCES public.jobs(id);
---
--- Name: jobs_history jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.jobs_history
- ADD CONSTRAINT jobs_history_builder_id FOREIGN KEY (builder_id) REFERENCES public.builders(id);
-
-
---
--- Name: jobs_history jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.jobs_history
- ADD CONSTRAINT jobs_history_job_id FOREIGN KEY (job_id) REFERENCES public.jobs(id);
-
-
---
--- Name: jobs_history jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.jobs_history
- ADD CONSTRAINT jobs_history_test_job_id FOREIGN KEY (test_job_id) REFERENCES public.jobs(id);
-
-
---
--- Name: jobs_history jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.jobs_history
- ADD CONSTRAINT jobs_history_user_id FOREIGN KEY (user_id) REFERENCES public.users(id);
-
-
--
-- Name: jobs_packages jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ADD CONSTRAINT mirrors_checks_mirror_id FOREIGN KEY (mirror_id) REFERENCES public.mirrors(id);
---
--- Name: mirrors_history mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.mirrors_history
- ADD CONSTRAINT mirrors_history_mirror_id FOREIGN KEY (mirror_id) REFERENCES public.mirrors(id);
-
-
---
--- Name: mirrors_history mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.mirrors_history
- ADD CONSTRAINT mirrors_history_user_id FOREIGN KEY (user_id) REFERENCES public.users(id);
-
-
--
-- Name: packages packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ADD CONSTRAINT repositories_distro_id FOREIGN KEY (distro_id) REFERENCES public.distributions(id);
---
--- Name: repositories_history repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.repositories_history
- ADD CONSTRAINT repositories_history_build_id FOREIGN KEY (build_id) REFERENCES public.builds(id);
-
-
---
--- Name: repositories_history repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.repositories_history
- ADD CONSTRAINT repositories_history_from_repo_id FOREIGN KEY (from_repo_id) REFERENCES public.repositories(id);
-
-
---
--- Name: repositories_history repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.repositories_history
- ADD CONSTRAINT repositories_history_to_repo_id FOREIGN KEY (to_repo_id) REFERENCES public.repositories(id);
-
-
---
--- Name: repositories_history repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.repositories_history
- ADD CONSTRAINT repositories_history_user_id FOREIGN KEY (user_id) REFERENCES public.users(id);
-
-
--
-- Name: repositories repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--