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