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')