From 8d44e1b2d606aabe455fbda136ba375e4c1ef8fd Mon Sep 17 00:00:00 2001 From: Mohamed Larabi Date: Mon, 25 Nov 2013 17:53:23 +0100 Subject: [PATCH] DB Migration: fix 003_sliver_allocations.py --- .../migrations/versions/003_sliver_allocations.py | 15 +++++++++++---- 1 file changed, 11 insertions(+), 4 deletions(-) diff --git a/sfa/storage/migrations/versions/003_sliver_allocations.py b/sfa/storage/migrations/versions/003_sliver_allocations.py index 21c8511d..c1534db5 100644 --- a/sfa/storage/migrations/versions/003_sliver_allocations.py +++ b/sfa/storage/migrations/versions/003_sliver_allocations.py @@ -1,13 +1,20 @@ -from sqlalchemy import Table, MetaData, Column, ForeignKey +from sqlalchemy import Table, MetaData, Column from sqlalchemy import Integer, String -from sfa.storage.model import SliverAllocation metadata=MetaData() +sliver_allocation_table = \ + Table ( 'sliver_allocation', metadata, + Column('sliver_id', String, primary_key=True), + Column('client_id', String), + Column('component_id', String), + Column('slice_urn', String), + Column('allocation_state', String), + ) def upgrade(migrate_engine): metadata.bind = migrate_engine - SliverAllocation.create() + sliver_allocation_table.create() def downgrade(migrate_engine): metadata.bind = migrate_engine - SliverAllocation.drop() + sliver_allocation_table.drop() -- 2.43.0