def upgrade(active_plugins=None, options=None):
op.create_table('nsd',
sa.Column('tenant_id',
sa.String(length=64),
nullable=False),
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('name', sa.String(length=255), nullable=False),
sa.Column('description', sa.Text(), nullable=True),
sa.Column('vnfds', types.Json, nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
op.create_table('ns',
sa.Column('tenant_id',
sa.String(length=64),
nullable=False),
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('nsd_id', types.Uuid(length=36), nullable=True),
sa.Column('vim_id', sa.String(length=64), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.Column('description', sa.Text(), nullable=True),
sa.Column('vnf_ids', sa.TEXT(length=65535), nullable=True),
sa.Column('mgmt_urls',
sa.TEXT(length=65535),
nullable=True),
sa.Column('status', sa.String(length=64), nullable=False),
sa.Column('error_reason', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(
['nsd_id'],
['nsd.id'],
),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
op.create_table('nsd_attribute',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('nsd_id', types.Uuid(length=36), nullable=False),
sa.Column('key', sa.String(length=255), nullable=False),
sa.Column('value', sa.TEXT(length=65535), nullable=True),
sa.ForeignKeyConstraint(
['nsd_id'],
['nsd.id'],
),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
def upgrade(active_plugins=None, options=None):
op.add_column('ns',
sa.Column('vnffg_ids', sa.TEXT(length=65535), nullable=True))
op.add_column('vnffgs',
sa.Column('ns_id', types.Uuid(length=36), nullable=True))
op.create_foreign_key('vnffg_foreign_key', 'vnffgs', 'ns', ['ns_id'],
['id'])
def upgrade(active_plugins=None, options=None):
op.create_table('vnf_artifacts',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('package_uuid',
types.Uuid(length=36),
nullable=False),
sa.Column('artifact_path', sa.Text(), nullable=False),
sa.Column('algorithm', sa.String(64), nullable=False),
sa.Column('hash', sa.String(128), nullable=False),
sa.Column('_metadata', sa.JSON(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(
['package_uuid'],
['vnf_packages.id'],
),
mysql_engine='InnoDB')
def upgrade(active_plugins=None, options=None):
op.create_table('placement_constraint',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('vnf_instance_id',
types.Uuid(length=36),
nullable=False),
sa.Column('affinity_or_anti_affinity',
sa.String(length=255),
nullable=False),
sa.Column('scope', sa.String(length=255), nullable=False),
sa.Column('server_group_name',
sa.String(length=255),
nullable=False),
sa.Column('resource', sa.JSON(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
def upgrade(active_plugins=None, options=None):
op.alter_column('vnf_lcm_filters', 'subscription_uuid',
type_=types.Uuid(length=36), existing_type=sa.String(length=255),
nullable=False)
sta_str = "json_unquote(json_extract('filter','$.operationTypes'))"
op.add_column(
'vnf_lcm_filters',
sa.Column('operation_types',
sa.LargeBinary(length=65536),
sa.Computed(sta_str)))
op.add_column(
'vnf_lcm_filters',
sa.Column('operation_types_len',
sa.Integer,
sa.Computed("ifnull(json_length('operation_types'),0)")))
op.drop_column('vnf_lcm_filters', 'operation_states')
op.drop_column('vnf_lcm_filters', 'operation_states_len')
op.alter_column('vnf_lcm_op_occs', 'operation_state',
type_=sa.String(length=16), existing_type=sa.String(length=255))
op.alter_column('vnf_lcm_op_occs', 'operation',
type_=sa.String(length=16),existing_type=sa.String(length=255))
op.add_column('vnf_lcm_op_occs',
sa.Column('is_cancel_pending', sa.Boolean, nullable=False)),
op.add_column('vnf_lcm_op_occs',
sa.Column('resource_changes', sa.JSON(), nullable=True))
op.add_column('vnf_lcm_op_occs',
sa.Column('error_point', sa.Integer, nullable=True))
op.add_column('vnf_lcm_op_occs',
sa.Column('changed_info', sa.JSON(), nullable=True))
op.add_column('vnf_lcm_op_occs',
sa.Column('created_at', sa.DateTime(), nullable=False))
op.add_column('vnf_lcm_op_occs',
sa.Column('updated_at', sa.DateTime(), nullable=True))
op.add_column('vnf_lcm_op_occs',
sa.Column('deleted_at', sa.DateTime(), nullable=True))
pass
def upgrade(active_plugins=None, options=None):
op.add_column('vnf', sa.Column('server_id', types.Uuid(length=36), nullable=False))
op.create_table(
'server',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('status', sa.String(length=255), nullable=True),
sa.Column('role', sa.String(length=255), nullable=True),
sa.Column('description', sa.String(length=255), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB'
)
op.create_foreign_key("fk_server_id", "vnf", "server", ["server_id"], ["id"])
def upgrade(active_plugins=None, options=None):
op.create_table('vnf_instances',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('vnf_instance_name',
sa.String(length=255),
nullable=True,
default=""),
sa.Column('vnf_instance_description',
sa.String(length=1024),
nullable=True,
default=""),
sa.Column('vnfd_id', types.Uuid(length=36),
nullable=False),
sa.Column('vnf_provider',
sa.String(length=255),
nullable=False),
sa.Column('vnf_product_name',
sa.String(length=255),
nullable=False),
sa.Column('vnf_software_version',
sa.String(length=255),
nullable=False),
sa.Column('vnfd_version',
sa.String(length=255),
nullable=False),
sa.Column('instantiation_state',
sa.String(length=255),
nullable=False),
sa.Column('task_state',
sa.String(length=255),
nullable=True),
sa.Column('vim_connection_info', sa.JSON(), nullable=True),
sa.Column('tenant_id',
sa.String(length=64),
nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
op.create_table('vnf_instantiated_info',
sa.Column('id',
sa.Integer,
nullable=False,
autoincrement=True),
sa.Column('vnf_instance_id',
types.Uuid(length=36),
nullable=False),
sa.Column('flavour_id',
sa.String(length=255),
nullable=False),
sa.Column('ext_cp_info', sa.JSON(), nullable=True),
sa.Column('ext_virtual_link_info',
sa.JSON(),
nullable=True),
sa.Column('ext_managed_virtual_link_info',
sa.JSON(),
nullable=True),
sa.Column('vnfc_resource_info', sa.JSON(), nullable=True),
sa.Column('vnf_virtual_link_resource_info',
sa.JSON(),
nullable=True),
sa.Column('virtual_storage_resource_info',
sa.JSON(),
nullable=True),
sa.Column('vnf_state',
sa.String(length=255),
nullable=False),
sa.Column('instance_id',
sa.String(length=255),
nullable=True),
sa.Column('instantiation_level_id',
sa.String(length=255),
nullable=True),
sa.Column('additional_params', sa.JSON(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(
['vnf_instance_id'],
['vnf_instances.id'],
),
mysql_engine='InnoDB')
op.create_table('vnf_resources',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('vnf_instance_id',
types.Uuid(length=36),
nullable=False),
sa.Column('resource_name',
sa.String(length=255),
nullable=False),
sa.Column('resource_type',
sa.String(length=255),
nullable=False),
sa.Column('resource_identifier',
sa.String(length=255),
nullable=False),
sa.Column('resource_status',
sa.String(length=255),
nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(
['vnf_instance_id'],
['vnf_instances.id'],
),
mysql_engine='InnoDB')
def upgrade(active_plugins=None, options=None):
op.create_table('vnf_packages',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('onboarding_state',
sa.String(length=255),
nullable=False),
sa.Column('operational_state',
sa.String(length=255),
nullable=False),
sa.Column('usage_state',
sa.String(length=255),
nullable=False),
sa.Column('tenant_id',
sa.String(length=64),
nullable=False),
sa.Column('algorithm', sa.String(length=64),
nullable=True),
sa.Column('hash', sa.String(length=128), nullable=True),
sa.Column('location_glance_store',
sa.Text(),
nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
op.create_table('vnf_packages_user_data',
sa.Column('id',
sa.Integer,
nullable=False,
autoincrement=True),
sa.Column('package_uuid',
types.Uuid(length=36),
nullable=False),
sa.Column('key', sa.String(length=255), nullable=False),
sa.Column('value', sa.String(length=255), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(
['package_uuid'],
['vnf_packages.id'],
),
sa.Index('vnf_packages_user_data_key_idx', 'key'),
sa.Index('vnf_packages_user_data_value_idx', 'value'),
sa.UniqueConstraint(
'id',
'key',
'deleted',
name='uniq_vnf_packages_user_data0idid0key0deleted'),
mysql_engine='InnoDB')
op.create_table('vnf_package_vnfd',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('package_uuid',
types.Uuid(length=36),
nullable=False),
sa.Column('vnfd_id', types.Uuid(length=36),
nullable=False),
sa.Column('vnf_provider',
sa.String(length=255),
nullable=False),
sa.Column('vnf_product_name',
sa.String(length=255),
nullable=False),
sa.Column('vnf_software_version',
sa.String(length=255),
nullable=False),
sa.Column('vnfd_version',
sa.String(length=255),
nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(
['package_uuid'],
['vnf_packages.id'],
),
mysql_engine='InnoDB')
op.create_table('vnf_deployment_flavours',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('package_uuid',
types.Uuid(length=36),
nullable=False),
sa.Column('flavour_id',
sa.String(length=255),
nullable=False),
sa.Column('flavour_description', sa.Text(),
nullable=False),
sa.Column('instantiation_levels', sa.Text(),
nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(
['package_uuid'],
['vnf_packages.id'],
),
mysql_engine='InnoDB')
op.create_table('vnf_software_images',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('software_image_id',
sa.String(length=255),
nullable=False),
sa.Column('flavour_uuid',
types.Uuid(length=36),
nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.Column('provider',
sa.String(length=255),
nullable=False),
sa.Column('version', sa.String(length=255),
nullable=False),
sa.Column('algorithm',
sa.String(length=64),
nullable=False),
sa.Column('hash', sa.String(length=128), nullable=False),
sa.Column('container_format',
sa.String(length=20),
nullable=False),
sa.Column('disk_format',
sa.String(length=20),
nullable=False),
sa.Column('min_disk', sa.Integer, nullable=False),
sa.Column('min_ram', sa.Integer, nullable=False),
sa.Column('size', sa.BigInteger, nullable=False),
sa.Column('image_path', sa.Text(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(
['flavour_uuid'],
['vnf_deployment_flavours.id'],
),
mysql_engine='InnoDB')
op.create_table(
'vnf_software_image_metadata',
sa.Column('id', sa.Integer, nullable=False, autoincrement=True),
sa.Column('image_uuid', types.Uuid(length=36), nullable=False),
sa.Column('key', sa.String(length=255), nullable=False),
sa.Column('value', sa.String(length=255), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(
['image_uuid'],
['vnf_software_images.id'],
),
sa.Index('vnf_software_image_metadata_key_idx', 'key'),
sa.Index('vnf_software_image_metadata_value_idx', 'value'),
sa.UniqueConstraint(
'id',
'key',
'deleted',
name='uniq_vnf_software_image_metadata0idid0key0deleted'),
mysql_engine='InnoDB')
def upgrade(active_plugins=None, options=None):
op.create_table('vnf_lcm_subscriptions',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('callback_uri',
sa.String(length=255),
nullable=False),
sa.Column('subscription_authentication',
sa.JSON(),
nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
mysql_engine='InnoDB')
noti_str = "json_unquote(json_extract('filter','$.notificationTypes'))"
sta_str = "json_unquote(json_extract('filter','$.operationStates'))"
op.create_table(
'vnf_lcm_filters',
sa.Column('id', sa.Integer, autoincrement=True, nullable=False),
sa.Column('subscription_uuid', sa.String(length=36), nullable=False),
sa.Column('filter', sa.JSON(), nullable=False),
sa.Column('notification_types', sa.LargeBinary(length=65536),
sa.Computed(noti_str)),
sa.Column('notification_types_len', sa.Integer,
sa.Computed("ifnull(json_length('notification_types'),0)")),
sa.Column('operation_states', sa.LargeBinary(length=65536),
sa.Computed(sta_str)),
sa.Column('operation_states_len', sa.Integer,
sa.Computed("ifnull(json_length('operation_states'),0)")),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(
['subscription_uuid'],
['vnf_lcm_subscriptions.id'],
),
mysql_engine='InnoDB')
op.create_table('vnf_lcm_op_occs',
sa.Column('id', types.Uuid(length=36), nullable=False),
sa.Column('operation_state',
sa.String(length=255),
nullable=False),
sa.Column('state_entered_time',
sa.DateTime(),
nullable=False),
sa.Column('start_time', sa.DateTime(), nullable=False),
sa.Column('vnf_instance_id',
types.Uuid(length=36),
nullable=False),
sa.Column('operation',
sa.String(length=255),
nullable=False),
sa.Column('is_automatic_invocation',
sa.Boolean,
nullable=False),
sa.Column('operation_params', sa.JSON(), nullable=True),
sa.Column('error', sa.JSON(), nullable=True),
sa.Column('deleted', Boolean, default=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(
['vnf_instance_id'],
['vnf_instances.id'],
),
mysql_engine='InnoDB')
