Add a new type of autoinstall - a preseeded Debian autoinstall.

[invirt/packages/invirt-database.git] / python / database / models.py

diff --git a/python/database/models.py b/python/database/models.py
index 06e7f3d..c1b31b6 100644 (file)
--- a/python/database/models.py
+++ b/python/database/models.py
@@ -42,7 +42,7 @@ session = orm.scoped_session(orm.sessionmaker(transactional=False, autoflush=Fal
 
 machine_table = Table('machines', meta,
        Column('machine_id', Integer, primary_key=True, nullable=False),
-       Column('name', String, nullable=False),
+       Column('name', String, nullable=False, unique=True),
        Column('description', String, nullable=False),
        Column('memory', Integer, nullable=False),
        Column('owner', String, nullable=False),
@@ -91,7 +91,8 @@ autoinstalls_table = Table('autoinstalls', meta,
        Column('type_id', String, ForeignKey('types.type_id'), nullable=False),
        Column('distribution', String, nullable=False),
        Column('mirror', String, nullable=False),
-       Column('arch', String, nullable=False))
+       Column('arch', String, nullable=False),
+       Column('preseed', Boolean, nullable=False, default=False))
 
 owners_table = Table('owners', meta,
        Column('owner_id', String, primary_key=True, nullable=False),
@@ -109,8 +110,9 @@ builds_table = Table('builds', meta,
        Column('commit', String, nullable=False),
        Column('version', String, nullable=True, default=None),
        Column('principal', String, nullable=False),
-       Column('succeeded', Boolean, nullable=False),
+       Column('succeeded', Boolean, nullable=True),
        Column('failed_stage', String, nullable=True, default=None),
+       Column('traceback', String, nullable=True, default=None),
        Column('inserted_at', DateTime, nullable=False, default=datetime.datetime.utcnow))
 
 machine_access_table = Table('machine_access', meta,