liquid_feedback_core
changeset 63:1af482e378a1 v1.2.3
Added "rendered_draft" table for caching
(Version number updated to v1.2.3, update script included)
(Version number updated to v1.2.3, update script included)
author | jbe |
---|---|
date | Sat Jul 24 16:40:51 2010 +0200 (2010-07-24) |
parents | bc01495a4afa |
children | 6dba5c0eb0ec |
files | core.sql update/core-update.v1.2.2-v1.2.3.sql |
line diff
1.1 --- a/core.sql Tue Jul 20 00:59:06 2010 +0200 1.2 +++ b/core.sql Sat Jul 24 16:40:51 2010 +0200 1.3 @@ -6,7 +6,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('1.2.2', 1, 2, 2)) 1.8 + SELECT * FROM (VALUES ('1.2.3', 1, 2, 3)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -513,6 +513,15 @@ 1.13 COMMENT ON COLUMN "draft"."content" IS 'Text of the draft in a format depending on the field "formatting_engine"'; 1.14 1.15 1.16 +CREATE TABLE "rendered_draft" ( 1.17 + PRIMARY KEY ("draft_id", "format"), 1.18 + "draft_id" INT8 REFERENCES "draft" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.19 + "format" TEXT, 1.20 + "content" TEXT NOT NULL ); 1.21 + 1.22 +COMMENT ON TABLE "rendered_draft" IS 'This table may be used by frontends to cache "rendered" drafts (e.g. HTML output generated from wiki text)'; 1.23 + 1.24 + 1.25 CREATE TABLE "suggestion" ( 1.26 UNIQUE ("initiative_id", "id"), -- index needed for foreign-key on table "opinion" 1.27 "initiative_id" INT4 NOT NULL REFERENCES "initiative" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
2.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 2.2 +++ b/update/core-update.v1.2.2-v1.2.3.sql Sat Jul 24 16:40:51 2010 +0200 2.3 @@ -0,0 +1,15 @@ 2.4 +BEGIN; 2.5 + 2.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS 2.7 + SELECT * FROM (VALUES ('1.2.3', 1, 2, 3)) 2.8 + AS "subquery"("string", "major", "minor", "revision"); 2.9 + 2.10 +CREATE TABLE "rendered_draft" ( 2.11 + PRIMARY KEY ("draft_id", "format"), 2.12 + "draft_id" INT8 REFERENCES "draft" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 2.13 + "format" TEXT, 2.14 + "content" TEXT NOT NULL ); 2.15 + 2.16 +COMMENT ON TABLE "rendered_draft" IS 'This table may be used by frontends to cache "rendered" drafts (e.g. HTML output generated from wiki text)'; 2.17 + 2.18 +COMMIT;