X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/a4561fe89b9a899a8c4e1bae3434f3e2b445d269..45618726efd410f721d3406b341533168ced6f11:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index e6165e9e7..031b89aa5 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -3,6 +3,7 @@ -- SET statement_timeout = 0; +SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; @@ -1797,6 +1798,13 @@ CREATE INDEX gpx_files_visible_visibility_idx ON gpx_files USING btree (visible, CREATE UNIQUE INDEX index_client_applications_on_key ON client_applications USING btree (key); +-- +-- Name: index_note_comments_on_body; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- + +CREATE INDEX index_note_comments_on_body ON note_comments USING gin (to_tsvector('english'::regconfig, body)); + + -- -- Name: index_note_comments_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace: -- @@ -2466,6 +2474,8 @@ INSERT INTO schema_migrations (version) VALUES ('20130328184137'); INSERT INTO schema_migrations (version) VALUES ('20131212124700'); +INSERT INTO schema_migrations (version) VALUES ('20140115192822'); + INSERT INTO schema_migrations (version) VALUES ('21'); INSERT INTO schema_migrations (version) VALUES ('22');