X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/53817fa9e8d955df0891d156f21b7269b4ed08fc..f0e76d90add15e8bec6a4350f69f2a06f168574b:/db/structure.sql?ds=sidebyside diff --git a/db/structure.sql b/db/structure.sql index 4998bc694..294fda4c8 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -1304,8 +1304,8 @@ ALTER SEQUENCE public.oauth_tokens_id_seq OWNED BY public.oauth_tokens.id; CREATE TABLE public.redactions ( id integer NOT NULL, - title character varying, - description text, + title character varying NOT NULL, + description text NOT NULL, created_at timestamp without time zone, updated_at timestamp without time zone, user_id bigint NOT NULL, @@ -1532,38 +1532,6 @@ CREATE SEQUENCE public.user_roles_id_seq ALTER SEQUENCE public.user_roles_id_seq OWNED BY public.user_roles.id; --- --- Name: user_tokens; Type: TABLE; Schema: public; Owner: - --- - -CREATE TABLE public.user_tokens ( - id bigint NOT NULL, - user_id bigint NOT NULL, - token character varying NOT NULL, - expiry timestamp without time zone NOT NULL, - referer text -); - - --- --- Name: user_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: - --- - -CREATE SEQUENCE public.user_tokens_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: user_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - --- - -ALTER SEQUENCE public.user_tokens_id_seq OWNED BY public.user_tokens.id; - - -- -- Name: users; Type: TABLE; Schema: public; Owner: - -- @@ -1882,13 +1850,6 @@ ALTER TABLE ONLY public.user_mutes ALTER COLUMN id SET DEFAULT nextval('public.u ALTER TABLE ONLY public.user_roles ALTER COLUMN id SET DEFAULT nextval('public.user_roles_id_seq'::regclass); --- --- Name: user_tokens id; Type: DEFAULT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.user_tokens ALTER COLUMN id SET DEFAULT nextval('public.user_tokens_id_seq'::regclass); - - -- -- Name: users id; Type: DEFAULT; Schema: public; Owner: - -- @@ -2280,14 +2241,6 @@ ALTER TABLE ONLY public.user_roles ADD CONSTRAINT user_roles_pkey PRIMARY KEY (id); --- --- Name: user_tokens user_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.user_tokens - ADD CONSTRAINT user_tokens_pkey PRIMARY KEY (id); - - -- -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -2901,20 +2854,6 @@ CREATE INDEX user_id_idx ON public.friends USING btree (friend_user_id); CREATE UNIQUE INDEX user_roles_id_role_unique ON public.user_roles USING btree (user_id, role); --- --- Name: user_tokens_token_idx; Type: INDEX; Schema: public; Owner: - --- - -CREATE UNIQUE INDEX user_tokens_token_idx ON public.user_tokens USING btree (token); - - --- --- Name: user_tokens_user_id_idx; Type: INDEX; Schema: public; Owner: - --- - -CREATE INDEX user_tokens_user_id_idx ON public.user_tokens USING btree (user_id); - - -- -- Name: users_auth_idx; Type: INDEX; Schema: public; Owner: - -- @@ -3490,14 +3429,6 @@ ALTER TABLE ONLY public.user_roles ADD CONSTRAINT user_roles_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id); --- --- Name: user_tokens user_tokens_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.user_tokens - ADD CONSTRAINT user_tokens_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id); - - -- -- Name: way_nodes way_nodes_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- @@ -3581,6 +3512,9 @@ INSERT INTO "schema_migrations" (version) VALUES ('23'), ('22'), ('21'), +('20240307181018'), +('20240307180830'), +('20240228205723'), ('20240117185445'), ('20231213182102'), ('20231206141457'), @@ -3665,3 +3599,4 @@ INSERT INTO "schema_migrations" (version) VALUES ('11'), ('10'), ('1'); +