Merge ~cjwatson/launchpad:merge-db-stable into launchpad:master

Proposed by Colin Watson
Status: Merged
Approved by: Colin Watson
Approved revision: 1b199484b39c2ace8463127221c392ff4462b7b0
Merge reported by: Otto Co-Pilot
Merged at revision: not available
Proposed branch: ~cjwatson/launchpad:merge-db-stable
Merge into: launchpad:master
Diff against target: 21 lines (+15/-0)
1 file modified
database/schema/patch-2210-25-0.sql (+15/-0)
Reviewer Review Type Date Requested Status
Colin Watson (community) Approve
Review via email: mp+398003@code.launchpad.net

Commit message

Merge db-stable 1b199484b3 (GitRepository repack thresholds)

To post a comment you must log in.
Revision history for this message
Colin Watson (cjwatson) wrote :

Deployed to the production database today.

review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
diff --git a/database/schema/patch-2210-25-0.sql b/database/schema/patch-2210-25-0.sql
0new file mode 1006440new file mode 100644
index 0000000..7397939
--- /dev/null
+++ b/database/schema/patch-2210-25-0.sql
@@ -0,0 +1,15 @@
1-- Copyright 2021 Canonical Ltd. This software is licensed under the
2-- GNU Affero General Public License version 3 (see the file LICENSE).
3
4SET client_min_messages=ERROR;
5
6ALTER TABLE GitRepository
7 ADD COLUMN loose_object_count integer,
8 ADD COLUMN pack_count integer,
9 ADD COLUMN date_last_repacked timestamp without time zone,
10 ADD COLUMN date_last_scanned timestamp without time zone;
11
12COMMENT ON COLUMN GitRepository.date_last_scanned IS 'The datetime that packs and loose_objects were last updated for this repository.';
13COMMENT ON COLUMN GitRepository.date_last_repacked IS 'The datetime that the last repack request was executed successfully on Turnip.';
14
15INSERT INTO LaunchpadDatabaseRevision VALUES (2210, 25, 0);

Subscribers

People subscribed via source and target branches

to status/vote changes: