Francesco Banconi has proposed merging lp:~frankban/launchpad/db-milestonetags-480123 into lp:launchpad/db-devel.
Requested reviews: Launchpad code reviewers (launchpad-reviewers) For more details, see: https://code.launchpad.net/~frankban/launchpad/db-milestonetags-480123/+merge/85876 -- https://code.launchpad.net/~frankban/launchpad/db-milestonetags-480123/+merge/85876 Your team Launchpad code reviewers is requested to review the proposed merge of lp:~frankban/launchpad/db-milestonetags-480123 into lp:launchpad/db-devel.
=== modified file 'database/sampledata/current-dev.sql' --- database/sampledata/current-dev.sql 2011-12-13 15:21:25 +0000 +++ database/sampledata/current-dev.sql 2011-12-15 15:03:41 +0000 @@ -1,6 +1,6 @@ -- Copyright 2010-2011 Canonical Ltd. This software is licensed under the -- GNU Affero General Public License version 3 (see the file LICENSE). --- Created using pg_dump (PostgreSQL) 8.4.8 +-- Created using pg_dump (PostgreSQL) 8.4.9 SET check_function_bodies = false; SET client_encoding = 'UTF8'; @@ -5752,6 +5752,13 @@ ALTER TABLE messagechunk ENABLE TRIGGER ALL; +ALTER TABLE milestonetag DISABLE TRIGGER ALL; + + + +ALTER TABLE milestonetag ENABLE TRIGGER ALL; + + ALTER TABLE mirror DISABLE TRIGGER ALL; === modified file 'database/sampledata/current.sql' --- database/sampledata/current.sql 2011-12-13 15:21:25 +0000 +++ database/sampledata/current.sql 2011-12-15 15:03:41 +0000 @@ -1,6 +1,6 @@ -- Copyright 2010-2011 Canonical Ltd. This software is licensed under the -- GNU Affero General Public License version 3 (see the file LICENSE). --- Created using pg_dump (PostgreSQL) 8.4.8 +-- Created using pg_dump (PostgreSQL) 8.4.9 SET check_function_bodies = false; SET client_encoding = 'UTF8'; @@ -5682,6 +5682,13 @@ ALTER TABLE messagechunk ENABLE TRIGGER ALL; +ALTER TABLE milestonetag DISABLE TRIGGER ALL; + + + +ALTER TABLE milestonetag ENABLE TRIGGER ALL; + + ALTER TABLE mirror DISABLE TRIGGER ALL; === modified file 'database/schema/comments.sql' --- database/schema/comments.sql 2011-11-17 13:06:30 +0000 +++ database/schema/comments.sql 2011-12-15 15:03:41 +0000 @@ -2425,3 +2425,8 @@ 'OpenId Identifiers that can be used to log into an Account.'; COMMENT ON COLUMN OpenIdIdentifier.identifier IS 'OpenId Identifier. This should be a URL, but is currently just a token that can be used to generate the Identity URL for the Canonical SSO OpenId Provider.'; + +-- MilestoneTag +COMMENT ON TABLE milestonetag IS 'Attaches simple text tags to a milestone.'; +COMMENT ON COLUMN milestonetag.milestone IS 'The milestone the tag is attached to.'; +COMMENT ON COLUMN milestonetag.tag IS 'The text representation of the tag.'; === added file 'database/schema/patch-2209-00-3.sql' --- database/schema/patch-2209-00-3.sql 1970-01-01 00:00:00 +0000 +++ database/schema/patch-2209-00-3.sql 2011-12-15 15:03:41 +0000 @@ -0,0 +1,19 @@ +-- Copyright 2011 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 milestonetag ( + id integer NOT NULL PRIMARY KEY, + milestone integer REFERENCES milestone ON DELETE CASCADE, + tag text NOT NULL, + CONSTRAINT valid_tag CHECK (valid_name(tag)) +); + +ALTER TABLE ONLY milestonetag + ADD CONSTRAINT milestonetag__tag__milestone__key UNIQUE (tag, milestone); + +CREATE INDEX milestonetag__milestones_idx ON milestonetag USING btree (milestone); +CREATE INDEX milestonetag__tags_idx ON milestonetag (tag); + +INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 0, 3); === modified file 'database/schema/security.cfg' --- database/schema/security.cfg 2011-12-15 11:15:05 +0000 +++ database/schema/security.cfg 2011-12-15 15:03:41 +0000 @@ -223,6 +223,7 @@ public.messageapproval = SELECT, INSERT, UPDATE, DELETE public.messagechunk = SELECT, INSERT public.milestone = SELECT, INSERT, UPDATE, DELETE +public.milestonetag = SELECT, INSERT, DELETE public.mirrorcdimagedistroseries = SELECT, INSERT, DELETE public.mirrordistroarchseries = SELECT, INSERT, DELETE, UPDATE public.mirrordistroseriessource = SELECT, INSERT, UPDATE, DELETE @@ -593,6 +594,7 @@ public.message = SELECT, INSERT public.messagechunk = SELECT, INSERT public.milestone = SELECT +public.milestonetag = SELECT public.person = SELECT, INSERT, UPDATE public.personlanguage = SELECT public.personsettings = SELECT, INSERT @@ -651,6 +653,7 @@ public.karmaaction = SELECT public.message = SELECT, INSERT public.messagechunk = SELECT, INSERT +public.milestonetag = SELECT public.person = SELECT public.revision = SELECT, INSERT, UPDATE public.revisionauthor = SELECT, INSERT, UPDATE @@ -864,6 +867,7 @@ public.message = SELECT, INSERT public.messagechunk = SELECT, INSERT public.milestone = SELECT +public.milestonetag = SELECT public.packagecopyjob = SELECT, INSERT, DELETE public.packagecopyrequest = SELECT, INSERT, UPDATE public.packagediff = SELECT, INSERT, UPDATE @@ -1303,6 +1307,7 @@ public.message = SELECT, INSERT public.messagechunk = SELECT, INSERT public.milestone = SELECT +public.milestonetag = SELECT public.packagebuild = SELECT, INSERT, UPDATE public.packagecopyjob = SELECT, INSERT public.packagediff = SELECT, INSERT, UPDATE, DELETE @@ -1406,6 +1411,7 @@ public.message = SELECT, INSERT public.messagechunk = SELECT, INSERT public.milestone = SELECT +public.milestonetag = SELECT public.packagebuild = SELECT, INSERT, UPDATE public.packagecopyjob = SELECT, INSERT, UPDATE public.packagediff = SELECT, UPDATE @@ -1504,6 +1510,7 @@ public.message = SELECT, INSERT public.messagechunk = SELECT, INSERT public.milestone = SELECT +public.milestonetag = SELECT public.person = SELECT public.personlanguage = SELECT public.personsettings = SELECT @@ -1708,6 +1715,7 @@ public.message = SELECT, INSERT public.messagechunk = SELECT, INSERT public.milestone = SELECT +public.milestonetag = SELECT, INSERT, DELETE public.packageset = SELECT public.packagesetgroup = SELECT public.packagesetinclusion = SELECT @@ -1948,6 +1956,7 @@ public.job = SELECT, INSERT, UPDATE public.message = SELECT, INSERT public.messagechunk = SELECT, INSERT +public.milestonetag = SELECT public.person = SELECT, INSERT public.personsettings = SELECT, INSERT public.product = SELECT, INSERT, UPDATE @@ -2148,6 +2157,7 @@ public.job = SELECT, INSERT, DELETE public.logintoken = SELECT, DELETE public.mailinglistsubscription = SELECT, DELETE +public.milestonetag = SELECT public.oauthnonce = SELECT, DELETE public.openidconsumerassociation = SELECT, DELETE public.openidconsumernonce = SELECT, 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
