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

[Adeodato Simó <dato@net.com.org.es>]

---
 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)
+	  NOT NULL,
 	address text
 	  NOT NULL
 );
 
 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 (
-- 
1.6.1.1.352.g2c729