liquid_feedback_core

diff update/core-update.v1.2.2-v1.2.3.sql @ 63:1af482e378a1

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
children
line diff
     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/update/core-update.v1.2.2-v1.2.3.sql	Sat Jul 24 16:40:51 2010 +0200
     1.3 @@ -0,0 +1,15 @@
     1.4 +BEGIN;
     1.5 +
     1.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.7 +  SELECT * FROM (VALUES ('1.2.3', 1, 2, 3))
     1.8 +  AS "subquery"("string", "major", "minor", "revision");
     1.9 +
    1.10 +CREATE TABLE "rendered_draft" (
    1.11 +        PRIMARY KEY ("draft_id", "format"),
    1.12 +        "draft_id"              INT8            REFERENCES "draft" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.13 +        "format"                TEXT,
    1.14 +        "content"               TEXT            NOT NULL );
    1.15 +
    1.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)';
    1.17 +
    1.18 +COMMIT;

Impressum / About Us