liquid_feedback_core

changeset 259:620ec5751a1b

Removed "issue_comment"
author jbe
date Sun Jul 15 19:14:39 2012 +0200 (2012-07-15)
parents 8809f1202ee0
children 878f84407290
files core.sql
line diff
     1.1 --- a/core.sql	Wed Jun 20 23:08:12 2012 +0200
     1.2 +++ b/core.sql	Sun Jul 15 19:14:39 2012 +0200
     1.3 @@ -7,7 +7,7 @@
     1.4  BEGIN;
     1.5  
     1.6  CREATE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('2.0.11', 2, 0, 11))
     1.8 +  SELECT * FROM (VALUES ('2.1.0', 2, 1, 0))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11  
    1.12 @@ -1038,39 +1038,6 @@
    1.13  COMMENT ON COLUMN "vote"."grade"    IS 'Values smaller than zero mean reject, values greater than zero mean acceptance, zero or missing row means abstention. Preferences are expressed by different positive or negative numbers.';
    1.14  
    1.15  
    1.16 -CREATE TABLE "issue_comment" (
    1.17 -        PRIMARY KEY ("issue_id", "member_id"),
    1.18 -        "issue_id"              INT4            REFERENCES "issue" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.19 -        "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.20 -        "changed"               TIMESTAMPTZ     NOT NULL DEFAULT now(),
    1.21 -        "formatting_engine"     TEXT,
    1.22 -        "content"               TEXT            NOT NULL,
    1.23 -        "text_search_data"      TSVECTOR );
    1.24 -CREATE INDEX "issue_comment_member_id_idx" ON "issue_comment" ("member_id");
    1.25 -CREATE INDEX "issue_comment_text_search_data_idx" ON "issue_comment" USING gin ("text_search_data");
    1.26 -CREATE TRIGGER "update_text_search_data"
    1.27 -  BEFORE INSERT OR UPDATE ON "issue_comment"
    1.28 -  FOR EACH ROW EXECUTE PROCEDURE
    1.29 -  tsvector_update_trigger('text_search_data', 'pg_catalog.simple', "content");
    1.30 -
    1.31 -COMMENT ON TABLE "issue_comment" IS 'Place to store free comments of members related to issues';
    1.32 -
    1.33 -COMMENT ON COLUMN "issue_comment"."changed" IS 'Time the comment was last changed';
    1.34 -
    1.35 -
    1.36 -CREATE TABLE "rendered_issue_comment" (
    1.37 -        PRIMARY KEY ("issue_id", "member_id", "format"),
    1.38 -        FOREIGN KEY ("issue_id", "member_id")
    1.39 -          REFERENCES "issue_comment" ("issue_id", "member_id")
    1.40 -          ON DELETE CASCADE ON UPDATE CASCADE,
    1.41 -        "issue_id"              INT4,
    1.42 -        "member_id"             INT4,
    1.43 -        "format"                TEXT,
    1.44 -        "content"               TEXT            NOT NULL );
    1.45 -
    1.46 -COMMENT ON TABLE "rendered_issue_comment" IS 'This table may be used by frontends to cache "rendered" issue comments (e.g. HTML output generated from wiki text)';
    1.47 -
    1.48 -
    1.49  CREATE TABLE "voting_comment" (
    1.50          PRIMARY KEY ("issue_id", "member_id"),
    1.51          "issue_id"              INT4            REFERENCES "issue" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.52 @@ -4283,8 +4250,6 @@
    1.53            "closed"          = NULL,
    1.54            "ranks_available" = FALSE
    1.55            WHERE "id" = "issue_id_p";
    1.56 -        DELETE FROM "issue_comment"
    1.57 -          WHERE "issue_id" = "issue_id_p";
    1.58          DELETE FROM "voting_comment"
    1.59            WHERE "issue_id" = "issue_id_p";
    1.60          DELETE FROM "delegating_voter"

Impressum / About Us