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)
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;

Impressum / About Us