annotate update/core-update.v1.2.2-v1.2.3.sql @ 299:dbd237d86a8a
merge: In function "lock_issue"("issue"."id"): Instead of accquiring a table-level EXCLUSIVE lock, use a table-level SHARE lock in combination with row-level SHARE locks
author |
jbe |
date |
Tue Sep 25 13:37:27 2012 +0200 (2012-09-25) |
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;
|