OpenStack Study: 48b6f43f7471_service_type.py

**** CubicPower OpenStack Study ****

def upgrade(active_plugins=None, options=None):

    if not migration.should_run(active_plugins, migration_for_plugins):

        return

    op.create_table(

        u'servicetypes',

        sa.Column(u'tenant_id', sa.String(255), nullable=True),

        sa.Column(u'id', sa.String(36), nullable=False),

        sa.Column(u'name', sa.String(255), nullable=True),

        sa.Column(u'description', sa.String(255), nullable=True),

        sa.Column(u'default', sa.Boolean(),

                  autoincrement=False, nullable=False),

        sa.Column(u'num_instances', sa.Integer(),

                  autoincrement=False, nullable=True),

        sa.PrimaryKeyConstraint(u'id'))

    op.create_table(

        u'servicedefinitions',

        sa.Column(u'id', sa.String(36), nullable=False),

        sa.Column(u'service_class', sa.String(length=255),

                  nullable=False),

        sa.Column(u'plugin', sa.String(255), nullable=True),

        sa.Column(u'driver', sa.String(255), nullable=True),

        sa.Column(u'service_type_id', sa.String(36),

                  nullable=False),

        sa.ForeignKeyConstraint(['service_type_id'], [u'servicetypes.id'],

                                name=u'servicedefinitions_ibfk_1'),

        sa.PrimaryKeyConstraint(u'id', u'service_class', u'service_type_id'))

**** CubicPower OpenStack Study ****

def downgrade(active_plugins=None, options=None):

    if not migration.should_run(active_plugins, migration_for_plugins):

        return

    op.drop_table(u'servicedefinitions')

    op.drop_table(u'servicetypes')