liquid_feedback_core
view update/core-update.v1.2.2-v1.2.3.sql @ 78:4fc1779a9c98
add test policies
the test policies have values that move them quickly to the target area for frontend development
the test policies have values that move them quickly to the target area for frontend development
| author | Daniel Poelzleithner <poelzi@poelzi.org> |
|---|---|
| date | Mon Oct 04 14:24:29 2010 +0200 (2010-10-04) |
| parents | 1af482e378a1 |
| children |
line source
1 BEGIN;
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
4 SELECT * FROM (VALUES ('1.2.3', 1, 2, 3))
5 AS "subquery"("string", "major", "minor", "revision");
7 CREATE TABLE "rendered_draft" (
8 PRIMARY KEY ("draft_id", "format"),
9 "draft_id" INT8 REFERENCES "draft" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
10 "format" TEXT,
11 "content" TEXT NOT NULL );
13 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)';
15 COMMIT;