Created
November 6, 2015 19:54
-
-
Save trozet/8d720674483b01f927a4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Copyright 2015 OpenStack Foundation | |
| # | |
| # 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. | |
| # | |
| """description of revision | |
| Revision ID: 471b465518c2 | |
| Revises: 5958429bcb3c | |
| Create Date: 2015-11-06 19:09:03.467483 | |
| """ | |
| # revision identifiers, used by Alembic. | |
| revision = '471b465518c2' | |
| down_revision = '5958429bcb3c' | |
| from alembic import op | |
| import sqlalchemy as sa | |
| from sqlalchemy.dialects import mysql | |
| from tacker.db import migration | |
| def upgrade(active_plugins=None, options=None): | |
| ### commands auto generated by Alembic - please adjust! ### | |
| op.drop_table('servicecontexts') | |
| op.drop_table('devicetemplates') | |
| op.drop_table('deviceattributes') | |
| op.drop_table('servicetypes') | |
| op.drop_table('proxyserviceports') | |
| op.drop_table('proxymgmtports') | |
| op.drop_table('sfccattributes') | |
| op.drop_table('aclmatchcriterias') | |
| op.drop_table('devicetemplateattributes') | |
| op.drop_table('sfcclassifiers') | |
| op.drop_table('deviceservicecontexts') | |
| op.drop_table('devices') | |
| op.drop_table('serviceinstances') | |
| op.drop_table('sfcattributes') | |
| op.drop_table('sfcs') | |
| op.drop_table('servicedevicebindings') | |
| ### end Alembic commands ### | |
| def downgrade(active_plugins=None, options=None): | |
| ### commands auto generated by Alembic - please adjust! ### | |
| op.create_table('servicedevicebindings', | |
| sa.Column('service_instance_id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('device_id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.ForeignKeyConstraint(['device_id'], [u'devices.id'], name=u'servicedevicebindings_ibfk_2'), | |
| sa.ForeignKeyConstraint(['service_instance_id'], [u'serviceinstances.id'], name=u'servicedevicebindings_ibfk_1'), | |
| sa.PrimaryKeyConstraint('service_instance_id', 'device_id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('sfcs', | |
| sa.Column('tenant_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('id', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('name', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('description', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('instance_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('status', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('infra_driver', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('symmetrical', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), | |
| sa.Column('chain', sa.BLOB(), nullable=True), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('sfcattributes', | |
| sa.Column('id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('sfc_id', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('key', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('value', mysql.VARCHAR(length=4096), nullable=True), | |
| sa.ForeignKeyConstraint(['sfc_id'], [u'sfcs.id'], name=u'sfcattributes_ibfk_1'), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('serviceinstances', | |
| sa.Column('tenant_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('name', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('service_type_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('service_table_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('managed_by_user', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True), | |
| sa.Column('mgmt_driver', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('mgmt_url', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('status', mysql.VARCHAR(length=255), nullable=False), | |
| sa.ForeignKeyConstraint(['service_type_id'], [u'servicetypes.id'], name=u'serviceinstances_ibfk_1'), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('devices', | |
| sa.Column('id', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('tenant_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('name', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('template_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('instance_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('mgmt_url', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('status', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('description', mysql.VARCHAR(length=255), server_default=sa.text(u"''"), nullable=True), | |
| sa.ForeignKeyConstraint(['template_id'], [u'devicetemplates.id'], name=u'devices_ibfk_1'), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('deviceservicecontexts', | |
| sa.Column('id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('device_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('network_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('subnet_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('port_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('router_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('role', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('index', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), | |
| sa.ForeignKeyConstraint(['device_id'], [u'devices.id'], name=u'deviceservicecontexts_ibfk_1'), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('sfcclassifiers', | |
| sa.Column('tenant_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('id', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('name', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('description', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('instance_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('status', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('infra_driver', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('chain_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('devicetemplateattributes', | |
| sa.Column('id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('template_id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('key', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('value', mysql.MEDIUMTEXT(), nullable=True), | |
| sa.ForeignKeyConstraint(['template_id'], [u'devicetemplates.id'], name=u'devicetemplateattributes_ibfk_1'), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('aclmatchcriterias', | |
| sa.Column('id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('sfcc_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('source_mac', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('dest_mac', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('ethertype', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('source_ip_prefix', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('dest_ip_prefix', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('source_port', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), | |
| sa.Column('dest_port', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), | |
| sa.Column('protocol', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), | |
| sa.ForeignKeyConstraint(['sfcc_id'], [u'sfcclassifiers.id'], name=u'aclmatchcriterias_ibfk_1'), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('sfccattributes', | |
| sa.Column('id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('sfcc_id', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('key', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('value', mysql.VARCHAR(length=4096), nullable=True), | |
| sa.ForeignKeyConstraint(['sfcc_id'], [u'sfcclassifiers.id'], name=u'sfccattributes_ibfk_1'), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('proxymgmtports', | |
| sa.Column('device_id', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('port_id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('dst_transport_url', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('svr_proxy_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('svr_ns_proxy_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('clt_proxy_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('clt_ns_proxy_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.PrimaryKeyConstraint('device_id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('proxyserviceports', | |
| sa.Column('service_instance_id', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('svr_proxy_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('svr_ns_proxy_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('clt_proxy_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('clt_ns_proxy_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.PrimaryKeyConstraint('service_instance_id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('servicetypes', | |
| sa.Column('tenant_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('template_id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('service_type', mysql.VARCHAR(length=255), nullable=False), | |
| sa.ForeignKeyConstraint(['template_id'], [u'devicetemplates.id'], name=u'servicetypes_ibfk_1'), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('deviceattributes', | |
| sa.Column('id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('device_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('key', mysql.VARCHAR(length=255), nullable=False), | |
| sa.Column('value', mysql.VARCHAR(length=4096), nullable=True), | |
| sa.ForeignKeyConstraint(['device_id'], [u'devices.id'], name=u'deviceattributes_ibfk_1'), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('devicetemplates', | |
| sa.Column('id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('tenant_id', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('name', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('description', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('infra_driver', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('mgmt_driver', mysql.VARCHAR(length=255), nullable=True), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| op.create_table('servicecontexts', | |
| sa.Column('id', mysql.VARCHAR(length=36), nullable=False), | |
| sa.Column('service_instance_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('network_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('subnet_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('port_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('router_id', mysql.VARCHAR(length=36), nullable=True), | |
| sa.Column('role', mysql.VARCHAR(length=255), nullable=True), | |
| sa.Column('index', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), | |
| sa.ForeignKeyConstraint(['service_instance_id'], [u'serviceinstances.id'], name=u'servicecontexts_ibfk_1'), | |
| sa.PrimaryKeyConstraint('id'), | |
| mysql_default_charset=u'utf8', | |
| mysql_engine=u'InnoDB' | |
| ) | |
| ### end Alembic commands ### |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment