Index: trunk/packages/invirt-database/debian/changelog
===================================================================
--- trunk/packages/invirt-database/debian/changelog	(revision 2516)
+++ trunk/packages/invirt-database/debian/changelog	(revision 2535)
@@ -1,2 +1,8 @@
+invirt-database (0.2.2) unstable; urgency=low
+
+  * Add builds table for storing build history.
+
+ -- Evan Broder <broder@mit.edu>  Sun, 25 Oct 2009 18:45:23 -0400
+
 invirt-database (0.2.1) unstable; urgency=low
 
Index: trunk/packages/invirt-database/python/database/models.py
===================================================================
--- trunk/packages/invirt-database/python/database/models.py	(revision 2516)
+++ trunk/packages/invirt-database/python/database/models.py	(revision 2535)
@@ -5,4 +5,6 @@
 from sqlalchemy.ext.sessioncontext import SessionContext
 from sqlalchemy.ext.assignmapper import assign_mapper
+
+import datetime
 
 from invirt.database import record
@@ -21,4 +23,5 @@
            'owners_table',
            'admins_table',
+           'builds_table',
            'Machine',
            'MachineAccess',
@@ -31,4 +34,5 @@
            'Owner',
            'Admin',
+           'Build',
            'or_',
            ]
@@ -99,4 +103,15 @@
        Column('vms_quota_active', Integer, nullable=True, default=None))
 
+builds_table = Table('builds', meta,
+       Column('build_id', Integer, primary_key=True, nullable=False),
+       Column('package', String, nullable=False),
+       Column('pocket', String, nullable=False),
+       Column('commit', String, nullable=False),
+       Column('version', String, nullable=True, default=None),
+       Column('principal', String, nullable=False),
+       Column('succeeded', Boolean, nullable=False),
+       Column('failed_stage', String, nullable=True, default=None),
+       Column('inserted_at', DateTime, nullable=False, default=datetime.datetime.utcnow))
+
 machine_access_table = Table('machine_access', meta,
        Column('machine_id', Integer, ForeignKey('machines.machine_id', ondelete='CASCADE'), nullable=False, index=True),
@@ -134,4 +149,7 @@
     _identity_field = 'user'
 
+class Build(record.Record):
+    _identity_field = 'build_id'
+
 from invirt.database.owner import Owner
 
@@ -151,4 +169,5 @@
 session.mapper(Owner, owners_table)
 session.mapper(Admin, admins_table)
+session.mapper(Build, builds_table)
 
 def clear_cache():