[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[PATCH 05/12] [db] Add an "address" column to the builders table

This column is meant to store the address of the buildd software in the
remote machine, to which eg. ACCEPTED mails from dak should be sent to.

It should be stored in the database so that there is no duplication of
information between the DB (list of builders) and our aliases file (list
of builders and their addresses).
 db/db.sql |    5 ++++-
 1 files changed, 4 insertions(+), 1 deletions(-)

diff --git a/db/db.sql b/db/db.sql
index 2380145..6884498 100644
--- a/db/db.sql
+++ b/db/db.sql
@@ -145,11 +145,14 @@ INSERT INTO package_sections (name) VALUES ('x11');
 CREATE TABLE builders (
 	name text
+	  CONSTRAINT builder_pkey PRIMARY KEY,
+	address text
 COMMENT ON TABLE builders IS 'buildd usernames (database users from _userinfo in old MLDBM db format)';
 COMMENT ON COLUMN builders.name IS 'Username';
+COMMENT ON COLUMN builders.address IS 'Remote e-mail address of the buildd user';
 CREATE TABLE sources (
 	name text

Reply to: