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

Proposed by Colin Watson
Status: Merged
Approved by: Colin Watson
Approved revision: 37158ea5d99dad58617f8ab9b1e5206280f666df
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: 18 lines (+12/-0)
1 file modified
database/schema/patch-2211-00-1.sql (+12/-0)
Reviewer Review Type Date Requested Status
Colin Watson (community) Approve
Review via email: mp+430884@code.launchpad.net

Commit message

Merge db-stable 37158ea5d9 (Apply several comment changes from comments.sql)

To post a comment you must log in.
Revision history for this message
Otto Co-Pilot (otto-copilot) wrote :
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
1diff --git a/database/schema/patch-2211-00-1.sql b/database/schema/patch-2211-00-1.sql
2new file mode 100644
3index 0000000..2b05897
4--- /dev/null
5+++ b/database/schema/patch-2211-00-1.sql
6@@ -0,0 +1,12 @@
7+-- Copyright 2022 Canonical Ltd. This software is licensed under the
8+-- GNU Affero General Public License version 3 (see the file LICENSE).
9+
10+SET client_min_messages=ERROR;
11+
12+COMMENT ON TABLE public.builder IS 'Builder: This table stores the build-worker registry and status information as: name, url, trusted, builderok, builderaction, failnotes.';
13+COMMENT ON COLUMN public.builder.builderok IS 'Should a builder fail for any reason, from out-of-disk-space to not responding to the buildd manager, the builderok flag is set to false and the failnotes column is filled with a reason.';
14+COMMENT ON COLUMN public.builder.url IS 'The url to the build worker. There may be more than one build worker on a given host so this url includes the port number to use. The default port number for a build worker is 8221';
15+COMMENT ON COLUMN public.builder.version IS 'The version of launchpad-buildd on the worker.';
16+COMMENT ON COLUMN public.buildqueue.logtail IS 'The tail end of the log of the current build. This is updated regularly as the buildd manager polls the buildd workers. Once the build is complete; the full log will be lodged with the librarian and linked into the build table.';
17+
18+INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 00, 1);

Subscribers

People subscribed via source and target branches

to status/vote changes: