From: Tom Hughes Date: Wed, 26 Mar 2025 16:11:10 +0000 (+0000) Subject: Correct structure.sql X-Git-Tag: live~25^2 X-Git-Url: https://git.openstreetmap.org./rails.git/commitdiff_plain/842394f2f2fd15ce3f1c3a8599ad44ca44112403 Correct structure.sql --- diff --git a/db/structure.sql b/db/structure.sql index 5b0aecd41..48036fd8e 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -1368,38 +1368,6 @@ CREATE TABLE public.schema_migrations ( ); --- --- Name: social_links; Type: TABLE; Schema: public; Owner: - --- - -CREATE TABLE public.social_links ( - id bigint NOT NULL, - user_id bigint NOT NULL, - url character varying, - created_at timestamp(6) without time zone NOT NULL, - updated_at timestamp(6) without time zone NOT NULL -); - - --- --- Name: social_links_id_seq; Type: SEQUENCE; Schema: public; Owner: - --- - -CREATE SEQUENCE public.social_links_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: social_links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - --- - -ALTER SEQUENCE public.social_links_id_seq OWNED BY public.social_links.id; - - -- -- Name: user_blocks; Type: TABLE; Schema: public; Owner: - -- @@ -1489,9 +1457,9 @@ CREATE TABLE public.user_preferences ( CREATE TABLE public.user_roles ( id integer NOT NULL, user_id bigint NOT NULL, + role public.user_role_enum NOT NULL, created_at timestamp without time zone, updated_at timestamp without time zone, - role public.user_role_enum NOT NULL, granter_id bigint NOT NULL ); @@ -1794,13 +1762,6 @@ ALTER TABLE ONLY public.redactions ALTER COLUMN id SET DEFAULT nextval('public.r ALTER TABLE ONLY public.reports ALTER COLUMN id SET DEFAULT nextval('public.reports_id_seq'::regclass); --- --- Name: social_links id; Type: DEFAULT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.social_links ALTER COLUMN id SET DEFAULT nextval('public.social_links_id_seq'::regclass); - - -- -- Name: user_blocks id; Type: DEFAULT; Schema: public; Owner: - -- @@ -2165,14 +2126,6 @@ ALTER TABLE ONLY public.schema_migrations ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version); --- --- Name: social_links social_links_pkey; Type: CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.social_links - ADD CONSTRAINT social_links_pkey PRIMARY KEY (id); - - -- -- Name: user_blocks user_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -2699,13 +2652,6 @@ CREATE INDEX index_reports_on_issue_id ON public.reports USING btree (issue_id); CREATE INDEX index_reports_on_user_id ON public.reports USING btree (user_id); --- --- Name: index_social_links_on_user_id; Type: INDEX; Schema: public; Owner: - --- - -CREATE INDEX index_social_links_on_user_id ON public.social_links USING btree (user_id); - - -- -- Name: index_user_blocks_on_creator_id_and_id; Type: INDEX; Schema: public; Owner: - -- @@ -3101,14 +3047,6 @@ ALTER TABLE ONLY public.user_mutes ADD CONSTRAINT fk_rails_591dad3359 FOREIGN KEY (owner_id) REFERENCES public.users(id); --- --- Name: social_links fk_rails_6034fd4f62; Type: FK CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.social_links - ADD CONSTRAINT fk_rails_6034fd4f62 FOREIGN KEY (user_id) REFERENCES public.users(id); - - -- -- Name: oauth_access_tokens fk_rails_732cb83ab7; Type: FK CONSTRAINT; Schema: public; Owner: - -- @@ -3517,7 +3455,6 @@ INSERT INTO "schema_migrations" (version) VALUES ('20250212160355'), ('20250206202905'), ('20250121191749'), -('20250106113207'), ('20250105154621'), ('20250104140952'), ('20241023004427'),