X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/822759075cf43cfc99262186830aa329f4034667..b27e74eaac38bbd3a207e80bb16cb0581d871d26:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index d9b0b1ff3..42e9733b1 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -788,7 +788,9 @@ CREATE TABLE redactions ( title character varying(255), description text, created_at timestamp without time zone NOT NULL, - updated_at timestamp without time zone NOT NULL + updated_at timestamp without time zone NOT NULL, + user_id bigint NOT NULL, + description_format format_enum DEFAULT 'markdown'::format_enum NOT NULL ); @@ -2071,6 +2073,14 @@ ALTER TABLE ONLY oauth_tokens ADD CONSTRAINT oauth_tokens_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id); +-- +-- Name: redactions_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY redactions + ADD CONSTRAINT redactions_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id); + + -- -- Name: relation_members_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- @@ -2251,6 +2261,8 @@ INSERT INTO schema_migrations (version) VALUES ('20120318201948'); INSERT INTO schema_migrations (version) VALUES ('20120328090602'); +INSERT INTO schema_migrations (version) VALUES ('20120404205604'); + INSERT INTO schema_migrations (version) VALUES ('21'); INSERT INTO schema_migrations (version) VALUES ('22');