Add migration 18 - create the image_locations table
This migration simply creates the new image_locations table. It does not yet use the table for anything. Related to bp multiple-image-locations Change-Id: I1536c9276bc807aac26849e37556b465e8b5c9eb
This commit is contained in:
parent
f071f5a80f
commit
b0360709bd
|
@ -0,0 +1,64 @@
|
|||
# vim: tabstop=4 shiftwidth=4 softtabstop=4
|
||||
|
||||
# Copyright 2013 OpenStack Foundation
|
||||
# All Rights Reserved.
|
||||
#
|
||||
# Licensed under the Apache License, Version 2.0 (the "License"); you may
|
||||
# not use this file except in compliance with the License. You may obtain
|
||||
# a copy of the License at
|
||||
#
|
||||
# http://www.apache.org/licenses/LICENSE-2.0
|
||||
#
|
||||
# Unless required by applicable law or agreed to in writing, software
|
||||
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
|
||||
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
|
||||
# License for the specific language governing permissions and limitations
|
||||
# under the License.
|
||||
|
||||
import sqlalchemy
|
||||
|
||||
from glance.db.sqlalchemy.migrate_repo import schema
|
||||
|
||||
|
||||
def upgrade(migrate_engine):
|
||||
meta = sqlalchemy.schema.MetaData(migrate_engine)
|
||||
|
||||
#NOTE(bcwaldon): load the images table for the ForeignKey below
|
||||
sqlalchemy.Table('images', meta, autoload=True)
|
||||
|
||||
image_locations_table = sqlalchemy.Table(
|
||||
'image_locations', meta,
|
||||
sqlalchemy.Column('id',
|
||||
schema.Integer(),
|
||||
primary_key=True,
|
||||
nullable=False),
|
||||
sqlalchemy.Column('image_id',
|
||||
schema.String(36),
|
||||
sqlalchemy.ForeignKey('images.id'),
|
||||
nullable=False,
|
||||
index=True),
|
||||
sqlalchemy.Column('value',
|
||||
schema.Text(),
|
||||
nullable=False),
|
||||
sqlalchemy.Column('created_at',
|
||||
schema.DateTime(),
|
||||
nullable=False),
|
||||
sqlalchemy.Column('updated_at',
|
||||
schema.DateTime()),
|
||||
sqlalchemy.Column('deleted_at',
|
||||
schema.DateTime()),
|
||||
sqlalchemy.Column('deleted',
|
||||
schema.Boolean(),
|
||||
nullable=False,
|
||||
default=False,
|
||||
index=True),
|
||||
)
|
||||
|
||||
schema.create_tables([image_locations_table])
|
||||
|
||||
|
||||
def downgrade(migrate_engine):
|
||||
meta = sqlalchemy.schema.MetaData(migrate_engine)
|
||||
image_locations_table = sqlalchemy.Table('image_locations', meta,
|
||||
autoload=True)
|
||||
schema.drop_tables([image_locations_table])
|
Loading…
Reference in New Issue