# HG changeset patch
# User jbe
# Date 1342372479 -7200
# Node ID 620ec5751a1bc9a4618ab75b21bf2a6350f65ad0
# Parent  8809f1202ee0408af0c0f846da68fb1f7a10efbf
Removed "issue_comment"

diff -r 8809f1202ee0 -r 620ec5751a1b core.sql
--- a/core.sql	Wed Jun 20 23:08:12 2012 +0200
+++ b/core.sql	Sun Jul 15 19:14:39 2012 +0200
@@ -7,7 +7,7 @@
 BEGIN;
 
 CREATE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('2.0.11', 2, 0, 11))
+  SELECT * FROM (VALUES ('2.1.0', 2, 1, 0))
   AS "subquery"("string", "major", "minor", "revision");
 
 
@@ -1038,39 +1038,6 @@
 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.';
 
 
-CREATE TABLE "issue_comment" (
-        PRIMARY KEY ("issue_id", "member_id"),
-        "issue_id"              INT4            REFERENCES "issue" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-        "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
-        "changed"               TIMESTAMPTZ     NOT NULL DEFAULT now(),
-        "formatting_engine"     TEXT,
-        "content"               TEXT            NOT NULL,
-        "text_search_data"      TSVECTOR );
-CREATE INDEX "issue_comment_member_id_idx" ON "issue_comment" ("member_id");
-CREATE INDEX "issue_comment_text_search_data_idx" ON "issue_comment" USING gin ("text_search_data");
-CREATE TRIGGER "update_text_search_data"
-  BEFORE INSERT OR UPDATE ON "issue_comment"
-  FOR EACH ROW EXECUTE PROCEDURE
-  tsvector_update_trigger('text_search_data', 'pg_catalog.simple', "content");
-
-COMMENT ON TABLE "issue_comment" IS 'Place to store free comments of members related to issues';
-
-COMMENT ON COLUMN "issue_comment"."changed" IS 'Time the comment was last changed';
-
-
-CREATE TABLE "rendered_issue_comment" (
-        PRIMARY KEY ("issue_id", "member_id", "format"),
-        FOREIGN KEY ("issue_id", "member_id")
-          REFERENCES "issue_comment" ("issue_id", "member_id")
-          ON DELETE CASCADE ON UPDATE CASCADE,
-        "issue_id"              INT4,
-        "member_id"             INT4,
-        "format"                TEXT,
-        "content"               TEXT            NOT NULL );
-
-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)';
-
-
 CREATE TABLE "voting_comment" (
         PRIMARY KEY ("issue_id", "member_id"),
         "issue_id"              INT4            REFERENCES "issue" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
@@ -4283,8 +4250,6 @@
           "closed"          = NULL,
           "ranks_available" = FALSE
           WHERE "id" = "issue_id_p";
-        DELETE FROM "issue_comment"
-          WHERE "issue_id" = "issue_id_p";
         DELETE FROM "voting_comment"
           WHERE "issue_id" = "issue_id_p";
         DELETE FROM "delegating_voter"