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

[PATCH 11/12] [db] Add an "arch" column to the builder table

 db/db.sql |    4 ++++
 1 files changed, 4 insertions(+), 0 deletions(-)

diff --git a/db/db.sql b/db/db.sql
index a237542..6703a5d 100644
--- a/db/db.sql
+++ b/db/db.sql
@@ -120,12 +120,16 @@ COMMENT ON COLUMN package_sections.section IS 'Section name';
 CREATE TABLE builders (
 	builder text
 	  CONSTRAINT builder_pkey PRIMARY KEY,
+	arch text
+	  CONSTRAINT builder_arch_fkey REFERENCES architectures(arch)
 	address text
 COMMENT ON TABLE builders IS 'buildd usernames (database users from _userinfo in old MLDBM db format)';
 COMMENT ON COLUMN builders.builder IS 'Username';
+COMMENT ON COLUMN builders.arch IS 'Buildd architecture';
 COMMENT ON COLUMN builders.address IS 'Remote e-mail address of the buildd user';
 CREATE TABLE sources (

Reply to: