Colin Watson has proposed merging lp:~cjwatson/launchpad/db-archive-file-history into lp:launchpad/db-devel.
Commit message: Add ArchiveFile.date_created and ArchiveFile.date_superseded. Requested reviews: Stuart Bishop (stub): db Launchpad code reviewers (launchpad-reviewers): db Related bugs: Bug #1765933 in Launchpad itself: "Allow building livefses against a view of the archive at a fixed point in time" https://bugs.launchpad.net/launchpad/+bug/1765933 For more details, see: https://code.launchpad.net/~cjwatson/launchpad/db-archive-file-history/+merge/343750 See bug 1765933 for rationale. -- Your team Launchpad code reviewers is requested to review the proposed merge of lp:~cjwatson/launchpad/db-archive-file-history into lp:launchpad/db-devel.
=== added file 'database/schema/patch-2209-74-1.sql' --- database/schema/patch-2209-74-1.sql 1970-01-01 00:00:00 +0000 +++ database/schema/patch-2209-74-1.sql 2018-04-21 11:12:28 +0000 @@ -0,0 +1,13 @@ +-- Copyright 2018 Canonical Ltd. This software is licensed under the +-- GNU Affero General Public License version 3 (see the file LICENSE). + +SET client_min_messages=ERROR; + +ALTER TABLE ArchiveFile + ADD COLUMN date_created timestamp without time zone, + ADD COLUMN date_superseded timestamp without time zone; + +COMMENT ON COLUMN ArchiveFile.date_created IS 'The date when this file was created.'; +COMMENT ON COLUMN ArchiveFile.date_superseded IS 'The date when this file was removed or superseded by a newer version.'; + +INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 74, 1);
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : launchpad-reviewers@lists.launchpad.net Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
