liquid_feedback_core

changeset 601:aa0620c9c4df

Added explicit names for text search indices
author jbe
date Fri Feb 07 10:52:20 2020 +0100 (2020-02-07)
parents f61caa45de94
children 9570aeabf4fc
files core.sql
line diff
     1.1 --- a/core.sql	Thu Feb 06 21:33:01 2020 +0100
     1.2 +++ b/core.sql	Fri Feb 07 10:52:20 2020 +0100
     1.3 @@ -8,7 +8,7 @@
     1.4  CREATE EXTENSION IF NOT EXISTS conflux;
     1.5  
     1.6  CREATE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('4.1.0', 4, 1, 0))
     1.8 +  SELECT * FROM (VALUES ('4.2.0', 4, 2, 0))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11  
    1.12 @@ -1836,16 +1836,15 @@
    1.13      $1."name",
    1.14      $1."identification"
    1.15    )) $$;
    1.16 -CREATE INDEX ON "member" USING gin
    1.17 +CREATE INDEX "member_to_tsvector_idx" ON "member" USING gin
    1.18    (("to_tsvector"("member".*)));
    1.19  
    1.20 -
    1.21  CREATE FUNCTION "to_tsvector"("member_profile") RETURNS TSVECTOR
    1.22    LANGUAGE SQL IMMUTABLE AS $$ SELECT to_tsvector(concat_ws(' ',
    1.23      $1."statement",
    1.24      $1."profile_text_data"
    1.25    )) $$;
    1.26 -CREATE INDEX ON "member_profile" USING gin
    1.27 +CREATE INDEX "member_profile_to_tsvector_idx" ON "member_profile" USING gin
    1.28    (("to_tsvector"("member_profile".*)));
    1.29  
    1.30  CREATE FUNCTION "to_tsvector"("unit") RETURNS TSVECTOR
    1.31 @@ -1853,7 +1852,7 @@
    1.32      $1."name",
    1.33      $1."description"
    1.34    )) $$;
    1.35 -CREATE INDEX ON "unit" USING gin
    1.36 +CREATE INDEX "unit_to_tsvector_idx" ON "unit" USING gin
    1.37    (("to_tsvector"("unit".*)));
    1.38  
    1.39  CREATE FUNCTION "to_tsvector"("area") RETURNS TSVECTOR
    1.40 @@ -1861,7 +1860,7 @@
    1.41      $1."name",
    1.42      $1."description"
    1.43    )) $$;
    1.44 -CREATE INDEX ON "area" USING gin
    1.45 +CREATE INDEX "area_to_tsvector_idx" ON "area" USING gin
    1.46    (("to_tsvector"("area".*)));
    1.47  
    1.48  CREATE FUNCTION "to_tsvector"("initiative") RETURNS TSVECTOR
    1.49 @@ -1869,14 +1868,14 @@
    1.50      $1."name",
    1.51      $1."content"
    1.52    )) $$;
    1.53 -CREATE INDEX ON "initiative" USING gin
    1.54 +CREATE INDEX "initiative_to_tsvector_idx" ON "initiative" USING gin
    1.55    (("to_tsvector"("initiative".*)));
    1.56  
    1.57  CREATE FUNCTION "to_tsvector"("draft") RETURNS TSVECTOR
    1.58    LANGUAGE SQL IMMUTABLE AS $$ SELECT to_tsvector(concat_ws(' ',
    1.59      $1."content"
    1.60    )) $$;
    1.61 -CREATE INDEX ON "draft" USING gin
    1.62 +CREATE INDEX "draft_to_tsvector_idx" ON "draft" USING gin
    1.63    (("to_tsvector"("draft".*)));
    1.64  
    1.65  CREATE FUNCTION "to_tsvector"("suggestion") RETURNS TSVECTOR
    1.66 @@ -1884,14 +1883,14 @@
    1.67      $1."name",
    1.68      $1."content"
    1.69    )) $$;
    1.70 -CREATE INDEX ON "suggestion" USING gin
    1.71 +CREATE INDEX "suggestion_to_tsvector_idx" ON "suggestion" USING gin
    1.72    (("to_tsvector"("suggestion".*)));
    1.73  
    1.74  CREATE FUNCTION "to_tsvector"("direct_voter") RETURNS TSVECTOR
    1.75    LANGUAGE SQL IMMUTABLE AS $$ SELECT to_tsvector(concat_ws(' ',
    1.76      $1."comment"
    1.77    )) $$;
    1.78 -CREATE INDEX ON "direct_voter" USING gin
    1.79 +CREATE INDEX "direct_voter_to_tsvector_idx" ON "direct_voter" USING gin
    1.80    (("to_tsvector"("direct_voter".*)));
    1.81  
    1.82  

Impressum / About Us