From 46c321d044d6a2db44a22466624a1e7dc71d5935 Mon Sep 17 00:00:00 2001 From: Trey Morris Date: Wed, 29 Jun 2011 17:19:47 -0500 Subject: fixed incorrect assumption that nullable defaults to false --- nova/db/sqlalchemy/migrate_repo/versions/029_multi_nic.py | 6 +++--- nova/db/sqlalchemy/models.py | 4 ++-- 2 files changed, 5 insertions(+), 5 deletions(-) diff --git a/nova/db/sqlalchemy/migrate_repo/versions/029_multi_nic.py b/nova/db/sqlalchemy/migrate_repo/versions/029_multi_nic.py index 61cd8ae51..4a117bb11 100644 --- a/nova/db/sqlalchemy/migrate_repo/versions/029_multi_nic.py +++ b/nova/db/sqlalchemy/migrate_repo/versions/029_multi_nic.py @@ -38,11 +38,11 @@ virtual_interfaces = Table('virtual_interfaces', meta, unique=True), Column('network_id', Integer(), - ForeignKey('networks.id'), - nullable=True), + ForeignKey('networks.id')), Column('instance_id', Integer(), - ForeignKey('instances.id')), + ForeignKey('instances.id'), + nullable=False), mysql_engine='InnoDB') diff --git a/nova/db/sqlalchemy/models.py b/nova/db/sqlalchemy/models.py index 03bde4f99..fe899cc4f 100644 --- a/nova/db/sqlalchemy/models.py +++ b/nova/db/sqlalchemy/models.py @@ -568,11 +568,11 @@ class VirtualInterface(BASE, NovaBase): __tablename__ = 'virtual_interfaces' id = Column(Integer, primary_key=True) address = Column(String(255), unique=True) - network_id = Column(Integer, ForeignKey('networks.id'), nullable=True) + network_id = Column(Integer, ForeignKey('networks.id')) network = relationship(Network, backref=backref('virtual_interfaces')) # TODO(tr3buchet): cut the cord, removed foreign key and backrefs - instance_id = Column(Integer, ForeignKey('instances.id')) + instance_id = Column(Integer, ForeignKey('instances.id'), nullable=False) instance = relationship(Instance, backref=backref('virtual_interfaces')) -- cgit