Database changes for autoinstalls

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

diff --git a/sipb_xen_database/models.py b/sipb_xen_database/models.py
index 1d8b83f..ee207f6 100644 (file)
--- a/sipb_xen_database/models.py
+++ b/sipb_xen_database/models.py
@@ -28,6 +28,7 @@ ctx = SessionContext(create_session)
 machine_table = Table('machines', meta,
        Column('machine_id', Integer, primary_key=True, nullable=False),
        Column('name', String, nullable=False),
+       Column('description', String, nullable=False),
        Column('memory', Integer, nullable=False),
        Column('owner', String, nullable=False),
        Column('contact', String, nullable=False),
@@ -64,7 +65,9 @@ cdroms_table = Table('cdroms', meta,
 autoinstalls_table = Table('autoinstalls', meta,
        Column('autoinstall_id', String, primary_key=True, nullable=False),
        Column('description', String, nullable=False),
-       Column('type_id', String, ForeignKey('types.type_id'), nullable=False))
+       Column('type_id', String, ForeignKey('types.type_id'), nullable=False),
+       Column('distribution', String, nullable=False),
+       Column('mirror', String, nullable=False))
 
 machine_access_table = Table('machine_access', meta,
        Column('machine_id', Integer, ForeignKey('machines.machine_id'), nullable=False, index=True),