[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
+ CONSTRAINT builder_pkey PRIMARY KEY,
+ address text
+ NOT NULL
);
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
--
1.6.1.1.352.g2c729
Reply to: