launchpad-reviewers team mailing list archive

[Celso Providelo <celso.providelo@xxxxxxxxxxxxx>]

Celso Providelo has proposed merging lp:~cprov/launchpad/db-add-cric-take2 into lp:launchpad.

Commit message:
Creates CodeReviewInlineComment[,Draft] tables as part of the BranchMergeProposal inline comments feature

Requested reviews:
  William Grant (wgrant)

For more details, see:
https://code.launchpad.net/~cprov/launchpad/db-add-cric-take2/+merge/201714

Creates CodeReviewInlineComment[,Draft] tables as part of the BranchMergeProposal inline comments feature.
-- 
https://code.launchpad.net/~cprov/launchpad/db-add-cric-take2/+merge/201714
Your team Launchpad code reviewers is subscribed to branch lp:launchpad.

=== added file 'database/schema/patch-2209-54-0.sql'
--- database/schema/patch-2209-54-0.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-54-0.sql	2014-01-15 05:28:36 +0000
@@ -0,0 +1,28 @@
+-- Copyright 2013 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+CREATE TABLE codereviewinlinecomment (
+    previewdiff integer NOT NULL REFERENCES previewdiff,
+    person integer NOT NULL REFERENCES person,
+    comment integer PRIMARY KEY REFERENCES codereviewmessage,
+    comments text NOT NULL
+);
+
+CREATE INDEX codereviewinlinecomment__person__idx ON
+    codereviewinlinecomment(person);
+CREATE INDEX codereviewinlinecomment__previewdiff__idx ON
+    codereviewinlinecomment(previewdiff);
+
+CREATE TABLE codereviewinlinecommentdraft (
+    previewdiff integer NOT NULL REFERENCES previewdiff,
+    person integer NOT NULL REFERENCES person,
+    comments text NOT NULL,
+    PRIMARY KEY (previewdiff, person)
+);
+
+CREATE INDEX codereviewinlinecommentdraft__person__idx ON
+    codereviewinlinecommentdraft(person);
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 54, 0);

=== modified file 'database/schema/security.cfg'
--- database/schema/security.cfg	2013-12-04 08:46:38 +0000
+++ database/schema/security.cfg	2014-01-15 05:28:36 +0000
@@ -169,6 +169,8 @@
 public.codeimportjob                    = SELECT, INSERT, UPDATE, DELETE
 public.codeimportmachine                = SELECT, INSERT, UPDATE
 public.codeimportresult                 = SELECT, INSERT, UPDATE, DELETE
+public.codereviewinlinecomment          = SELECT, INSERT, UPDATE, DELETE
+public.codereviewinlinecommentdraft     = SELECT, INSERT, UPDATE, DELETE
 public.codereviewmessage                = SELECT, INSERT, DELETE
 public.codereviewvote                   = SELECT, INSERT, UPDATE, DELETE
 public.combinedbugsummary               = SELECT