X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/a7cdd1faaf1de132fa556944bc86831ebdfe8886..b19eea5a71ff3fa6259df25bc0726bd1e152d89b:/services/api/db/structure.sql diff --git a/services/api/db/structure.sql b/services/api/db/structure.sql index 9bb059c2a9..889ffa7486 100644 --- a/services/api/db/structure.sql +++ b/services/api/db/structure.sql @@ -227,73 +227,6 @@ CREATE SEQUENCE public.collections_id_seq ALTER SEQUENCE public.collections_id_seq OWNED BY public.collections.id; --- --- Name: commit_ancestors; Type: TABLE; Schema: public; Owner: - --- - -CREATE TABLE public.commit_ancestors ( - id integer NOT NULL, - repository_name character varying(255), - descendant character varying(255) NOT NULL, - ancestor character varying(255) NOT NULL, - "is" boolean DEFAULT false NOT NULL, - created_at timestamp without time zone NOT NULL, - updated_at timestamp without time zone NOT NULL -); - - --- --- Name: commit_ancestors_id_seq; Type: SEQUENCE; Schema: public; Owner: - --- - -CREATE SEQUENCE public.commit_ancestors_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: commit_ancestors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - --- - -ALTER SEQUENCE public.commit_ancestors_id_seq OWNED BY public.commit_ancestors.id; - - --- --- Name: commits; Type: TABLE; Schema: public; Owner: - --- - -CREATE TABLE public.commits ( - id integer NOT NULL, - repository_name character varying(255), - sha1 character varying(255), - message character varying(255), - created_at timestamp without time zone NOT NULL, - updated_at timestamp without time zone NOT NULL -); - - --- --- Name: commits_id_seq; Type: SEQUENCE; Schema: public; Owner: - --- - -CREATE SEQUENCE public.commits_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - --- - -ALTER SEQUENCE public.commits_id_seq OWNED BY public.commits.id; - - -- -- Name: container_requests; Type: TABLE; Schema: public; Owner: - -- @@ -1267,20 +1200,6 @@ ALTER TABLE ONLY public.authorized_keys ALTER COLUMN id SET DEFAULT nextval('pub ALTER TABLE ONLY public.collections ALTER COLUMN id SET DEFAULT nextval('public.collections_id_seq'::regclass); --- --- Name: commit_ancestors id; Type: DEFAULT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.commit_ancestors ALTER COLUMN id SET DEFAULT nextval('public.commit_ancestors_id_seq'::regclass); - - --- --- Name: commits id; Type: DEFAULT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.commits ALTER COLUMN id SET DEFAULT nextval('public.commits_id_seq'::regclass); - - -- -- Name: container_requests id; Type: DEFAULT; Schema: public; Owner: - -- @@ -1461,22 +1380,6 @@ ALTER TABLE ONLY public.collections ADD CONSTRAINT collections_pkey PRIMARY KEY (id); --- --- Name: commit_ancestors commit_ancestors_pkey; Type: CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.commit_ancestors - ADD CONSTRAINT commit_ancestors_pkey PRIMARY KEY (id); - - --- --- Name: commits commits_pkey; Type: CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.commits - ADD CONSTRAINT commits_pkey PRIMARY KEY (id); - - -- -- Name: container_requests container_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -1917,20 +1820,6 @@ CREATE INDEX index_collections_on_trash_at ON public.collections USING btree (tr CREATE UNIQUE INDEX index_collections_on_uuid ON public.collections USING btree (uuid); --- --- Name: index_commit_ancestors_on_descendant_and_ancestor; Type: INDEX; Schema: public; Owner: - --- - -CREATE UNIQUE INDEX index_commit_ancestors_on_descendant_and_ancestor ON public.commit_ancestors USING btree (descendant, ancestor); - - --- --- Name: index_commits_on_repository_name_and_sha1; Type: INDEX; Schema: public; Owner: - --- - -CREATE UNIQUE INDEX index_commits_on_repository_name_and_sha1 ON public.commits USING btree (repository_name, sha1); - - -- -- Name: index_container_requests_on_container_uuid; Type: INDEX; Schema: public; Owner: - -- @@ -3125,6 +3014,8 @@ INSERT INTO "schema_migrations" (version) VALUES ('20190214214814'), ('20190322174136'), ('20190422144631'), -('20190523180148'); +('20190523180148'), +('20190808145904'), +('20190809135453');