# HG changeset patch # User jbe # Date 1279982451 -7200 # Node ID 1af482e378a133754c124ec01f371f20749a966d # Parent bc01495a4afaa1a960312057f3466355106f8ce8 Added "rendered_draft" table for caching (Version number updated to v1.2.3, update script included) diff -r bc01495a4afa -r 1af482e378a1 core.sql --- a/core.sql Tue Jul 20 00:59:06 2010 +0200 +++ b/core.sql Sat Jul 24 16:40:51 2010 +0200 @@ -6,7 +6,7 @@ BEGIN; CREATE VIEW "liquid_feedback_version" AS - SELECT * FROM (VALUES ('1.2.2', 1, 2, 2)) + SELECT * FROM (VALUES ('1.2.3', 1, 2, 3)) AS "subquery"("string", "major", "minor", "revision"); @@ -513,6 +513,15 @@ COMMENT ON COLUMN "draft"."content" IS 'Text of the draft in a format depending on the field "formatting_engine"'; +CREATE TABLE "rendered_draft" ( + PRIMARY KEY ("draft_id", "format"), + "draft_id" INT8 REFERENCES "draft" ("id") ON DELETE CASCADE ON UPDATE CASCADE, + "format" TEXT, + "content" TEXT NOT NULL ); + +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)'; + + CREATE TABLE "suggestion" ( UNIQUE ("initiative_id", "id"), -- index needed for foreign-key on table "opinion" "initiative_id" INT4 NOT NULL REFERENCES "initiative" ("id") ON DELETE CASCADE ON UPDATE CASCADE, diff -r bc01495a4afa -r 1af482e378a1 update/core-update.v1.2.2-v1.2.3.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/update/core-update.v1.2.2-v1.2.3.sql Sat Jul 24 16:40:51 2010 +0200 @@ -0,0 +1,15 @@ +BEGIN; + +CREATE OR REPLACE VIEW "liquid_feedback_version" AS + SELECT * FROM (VALUES ('1.2.3', 1, 2, 3)) + AS "subquery"("string", "major", "minor", "revision"); + +CREATE TABLE "rendered_draft" ( + PRIMARY KEY ("draft_id", "format"), + "draft_id" INT8 REFERENCES "draft" ("id") ON DELETE CASCADE ON UPDATE CASCADE, + "format" TEXT, + "content" TEXT NOT NULL ); + +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)'; + +COMMIT;