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"