launchpad-reviewers team mailing list archive

[Robert Collins <robertc@xxxxxxxxxxxxxxxxx>]

Robert Collins has proposed merging lp:~lifeless/launchpad/subunit into lp:launchpad/db-devel.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)


Add storage space for subunit streams; will do things with it next cycle.
-- 
https://code.launchpad.net/~lifeless/launchpad/subunit/+merge/42023
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~lifeless/launchpad/subunit into lp:launchpad/db-devel.

=== modified file 'database/schema/comments.sql'
--- database/schema/comments.sql	2010-11-27 07:17:00 +0000
+++ database/schema/comments.sql	2010-11-27 20:01:57 +0000
@@ -136,6 +136,14 @@
 COMMENT ON COLUMN SeriesSourcePackageBranch.registrant IS 'The person who registered this link.';
 COMMENT ON COLUMN SeriesSourcePackageBranch.date_created IS 'The date this link was created.';
 
+-- SubunitStream
+
+COMMENT ON TABLE SubunitStream IS 'Raw gz compressed subunit streams.';
+COMMENT ON COLUMN SubunitStream.uploader IS 'The account used to upload the stream.';
+COMMENT ON COLUMN SubunitStream.date_created IS 'The date of the upload.';
+COMMENT ON COLUMN SubunitStream.branch IS 'The branch which the stream was created on/for/with.';
+COMMENT ON COLUMN SubunitStream.stream IS 'The library file alias which contains the stream content.';
+
 -- BranchSubscription
 
 COMMENT ON TABLE BranchSubscription IS 'An association between a person or team and a bazaar branch.';

=== added file 'database/schema/patch-2208-99-0.sql'
--- database/schema/patch-2208-99-0.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2208-99-0.sql	2010-11-27 20:01:57 +0000
@@ -0,0 +1,15 @@
+SET client_min_messages=ERROR;
+
+CREATE TABLE SubunitStream (
+    id           SERIAL PRIMARY KEY,
+    uploader     INTEGER NOT NULL REFERENCES Person(id),
+    date_created timestamp without time zone NOT NULL
+        DEFAULT (CURRENT_TIMESTAMP AT TIME ZONE 'UTC'),
+    branch       INTEGER NOT NULL REFERENCES Branch(id),
+    stream       INTEGER NOT NULL REFERENCES LibraryFileAlias(id)
+);
+
+CREATE INDEX SubunitStream__uploader_created__idx ON SubunitStream(uploader, date_created);
+CREATE INDEX SubunitStream__branch_created__idx ON SubunitStream(branch, date_created);
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 99, 0);

=== modified file 'database/schema/security.cfg'
--- database/schema/security.cfg	2010-11-21 20:46:19 +0000
+++ database/schema/security.cfg	2010-11-27 20:01:57 +0000
@@ -281,6 +281,7 @@
 public.staticdiff                       = SELECT, INSERT, UPDATE
 public.structuralsubscription           = SELECT, INSERT, UPDATE, DELETE
 public.suggestivepotemplate             = SELECT, INSERT, DELETE
+public.subunitstream                    = SELECT, INSERT, UPDATE, DELETE
 public.temporaryblobstorage             = SELECT, INSERT, DELETE
 public.translationgroup                 = SELECT, INSERT, UPDATE
 public.translationimportqueueentry      = SELECT, INSERT, UPDATE, DELETE