annotate update/core-update.v1.2.2-v1.2.3.sql @ 160:cc520b58e8ec
Added reference from "suggestion" to "draft_id"; Changed reference from "supporter" to "draft_id" to DELETE NO ACTION
| author |
jbe |
| date |
Sat Jun 04 22:11:07 2011 +0200 (2011-06-04) |
| parents |
1af482e378a1 |
| children |
|
| rev |
line source |
|
jbe@63
|
1 BEGIN;
|
|
jbe@63
|
2
|
|
jbe@63
|
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
|
|
jbe@63
|
4 SELECT * FROM (VALUES ('1.2.3', 1, 2, 3))
|
|
jbe@63
|
5 AS "subquery"("string", "major", "minor", "revision");
|
|
jbe@63
|
6
|
|
jbe@63
|
7 CREATE TABLE "rendered_draft" (
|
|
jbe@63
|
8 PRIMARY KEY ("draft_id", "format"),
|
|
jbe@63
|
9 "draft_id" INT8 REFERENCES "draft" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
jbe@63
|
10 "format" TEXT,
|
|
jbe@63
|
11 "content" TEXT NOT NULL );
|
|
jbe@63
|
12
|
|
jbe@63
|
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)';
|
|
jbe@63
|
14
|
|
jbe@63
|
15 COMMIT;
|