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
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
