1
# vim: tabstop=4 shiftwidth=4 softtabstop=4
3
# Copyright 2012 Openstack, LLC.
6
# Licensed under the Apache License, Version 2.0 (the "License"); you may
7
# not use this file except in compliance with the License. You may obtain
8
# a copy of the License at
10
# http://www.apache.org/licenses/LICENSE-2.0
12
# Unless required by applicable law or agreed to in writing, software
13
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
14
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
15
# License for the specific language governing permissions and limitations
18
from sqlalchemy import Boolean, Column, DateTime, ForeignKey
19
from sqlalchemy import Integer, MetaData, String, Table, Text
22
def upgrade(migrate_engine):
24
meta.bind = migrate_engine
25
instance_actions = Table('instance_actions', meta, autoload=True)
26
instance_actions.drop()
29
def downgrade(migrate_engine):
31
meta.bind = migrate_engine
33
instances = Table('instances', meta, autoload=True,
34
autoload_with=migrate_engine)
36
instance_actions = Table('instance_actions', meta,
37
Column('created_at', DateTime(timezone=False)),
38
Column('updated_at', DateTime(timezone=False)),
39
Column('deleted_at', DateTime(timezone=False)),
40
Column('deleted', Boolean(create_constraint=True, name=None)),
41
Column('id', Integer(), primary_key=True, nullable=False),
44
ForeignKey('instances.id')),
46
String(length=255, convert_unicode=False,
48
unicode_error=None, _warn_on_bytestring=False)),
50
Text(length=None, convert_unicode=False,
52
unicode_error=None, _warn_on_bytestring=False)),
54
instance_actions.create()