From 7b8c80815c7adda6f1e1f6508fd80938ae122861 Mon Sep 17 00:00:00 2001 From: fujinhua Date: Tue, 16 Apr 2019 10:52:34 +0800 Subject: [PATCH] Add db migrations py for vnflcm Change-Id: Ia31eb38e9a66db44250da0450fb17b2fced13207 Issue-ID: VFC-1306 Signed-off-by: fujinhua --- lcm/lcm/pub/database/migrations/0001_initial.py | 359 ++++++++++++++++++++++++ lcm/lcm/pub/database/migrations/__init__.py | 13 + 2 files changed, 372 insertions(+) create mode 100644 lcm/lcm/pub/database/migrations/0001_initial.py create mode 100644 lcm/lcm/pub/database/migrations/__init__.py diff --git a/lcm/lcm/pub/database/migrations/0001_initial.py b/lcm/lcm/pub/database/migrations/0001_initial.py new file mode 100644 index 00000000..159c12d1 --- /dev/null +++ b/lcm/lcm/pub/database/migrations/0001_initial.py @@ -0,0 +1,359 @@ +# Copyright 2019 ZTE Corporation. +# +# 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. +# Generated by Django 1.11.9 on 2019-04-16 02:51 +from __future__ import unicode_literals + +from django.db import migrations, models + + +class Migration(migrations.Migration): + + initial = True + + dependencies = [ + ] + + operations = [ + migrations.CreateModel( + name='CPInstModel', + fields=[ + ('cpinstanceid', models.CharField(db_column=b'CPINSTANCEID', max_length=255, primary_key=True, serialize=False)), + ('cpdid', models.CharField(db_column=b'CPDID', max_length=255)), + ('cpinstancename', models.CharField(db_column=b'CPINSTANCENAME', max_length=255)), + ('vlinstanceid', models.CharField(db_column=b'VLINSTANCEID', max_length=255)), + ('ownertype', models.IntegerField(db_column=b'OWNERTYPE')), + ('ownerid', models.CharField(db_column=b'OWNERID', max_length=255)), + ('relatedtype', models.IntegerField(db_column=b'RELATEDTYPE')), + ('relatedvl', models.CharField(blank=True, db_column=b'RELATEDVL', max_length=255, null=True)), + ('relatedcp', models.CharField(blank=True, db_column=b'RELATEDCP', max_length=255, null=True)), + ('relatedport', models.CharField(blank=True, db_column=b'RELATEDPORT', max_length=255, null=True)), + ], + options={ + 'db_table': 'CPINST', + }, + ), + migrations.CreateModel( + name='FlavourInstModel', + fields=[ + ('flavourid', models.CharField(db_column=b'FLAVOURID', max_length=255, primary_key=True, serialize=False)), + ('vimid', models.CharField(db_column=b'VIMID', max_length=255)), + ('resourceid', models.CharField(db_column=b'RESOURCEID', max_length=255)), + ('name', models.CharField(db_column=b'NAME', max_length=255)), + ('tenant', models.CharField(db_column=b'TENANT', max_length=255, null=True)), + ('vcpu', models.IntegerField(db_column=b'VCPU', null=True)), + ('memory', models.IntegerField(db_column=b'MEMORY', null=True)), + ('disk', models.IntegerField(db_column=b'DISK', null=True)), + ('ephemeral', models.IntegerField(db_column=b'EPHEMERAL', null=True)), + ('swap', models.IntegerField(db_column=b'SWAP', null=True)), + ('isPublic', models.IntegerField(db_column=b'ISPUBLIC', null=True)), + ('extraspecs', models.TextField(db_column=b'EXTRASPECS', max_length=4096)), + ('instid', models.CharField(db_column=b'INSTID', max_length=255)), + ('create_time', models.CharField(blank=True, db_column=b'CREATETIME', max_length=200, null=True)), + ('is_predefined', models.IntegerField(db_column=b'ISPREDEFINED', default=0, null=True)), + ], + options={ + 'db_table': 'FLAVOURINST', + }, + ), + migrations.CreateModel( + name='JobModel', + fields=[ + ('jobid', models.CharField(db_column=b'JOBID', max_length=255, primary_key=True, serialize=False)), + ('jobtype', models.CharField(db_column=b'JOBTYPE', max_length=255)), + ('jobaction', models.CharField(db_column=b'JOBACTION', max_length=255)), + ('resid', models.CharField(db_column=b'RESID', max_length=255)), + ('status', models.IntegerField(blank=True, db_column=b'STATUS', null=True)), + ('starttime', models.CharField(blank=True, db_column=b'STARTTIME', max_length=255, null=True)), + ('endtime', models.CharField(blank=True, db_column=b'ENDTIME', max_length=255, null=True)), + ('progress', models.IntegerField(blank=True, db_column=b'PROGRESS', null=True)), + ('user', models.CharField(blank=True, db_column=b'USER', max_length=255, null=True)), + ('parentjobid', models.CharField(blank=True, db_column=b'PARENTJOBID', max_length=255, null=True)), + ('resname', models.CharField(blank=True, db_column=b'RESNAME', max_length=255, null=True)), + ], + options={ + 'db_table': 'JOB', + }, + ), + migrations.CreateModel( + name='JobStatusModel', + fields=[ + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('indexid', models.IntegerField(db_column=b'INDEXID')), + ('jobid', models.CharField(db_column=b'JOBID', max_length=255)), + ('status', models.CharField(db_column=b'STATUS', max_length=255)), + ('progress', models.IntegerField(blank=True, db_column=b'PROGRESS', null=True)), + ('descp', models.TextField(db_column=b'DESCP', max_length=1024)), + ('errcode', models.CharField(blank=True, db_column=b'ERRCODE', max_length=255, null=True)), + ('addtime', models.CharField(blank=True, db_column=b'ADDTIME', max_length=255, null=True)), + ], + options={ + 'db_table': 'JOB_STATUS', + }, + ), + migrations.CreateModel( + name='NetworkInstModel', + fields=[ + ('networkid', models.CharField(db_column=b'NETWORKID', max_length=255, primary_key=True, serialize=False)), + ('vimid', models.CharField(db_column=b'VIMID', max_length=255)), + ('resourceid', models.CharField(db_column=b'RESOURCEID', max_length=255)), + ('insttype', models.IntegerField(db_column=b'INSTTYPE')), + ('instid', models.CharField(db_column=b'INSTID', max_length=255)), + ('name', models.CharField(db_column=b'NAME', max_length=255)), + ('tenant', models.CharField(db_column=b'TENANT', max_length=255, null=True)), + ('is_predefined', models.IntegerField(db_column=b'ISPREDEFINED', default=0, null=True)), + ('desc', models.CharField(db_column=b'DESC', max_length=255, null=True)), + ('vendor', models.CharField(db_column=b'VENDOR', max_length=255, null=True)), + ('bandwidth', models.IntegerField(db_column=b'BANDWIDTH', null=True)), + ('mtu', models.IntegerField(db_column=b'MTU', null=True)), + ('network_type', models.CharField(db_column=b'NETWORKTYPE', max_length=255, null=True)), + ('segmentid', models.CharField(db_column=b'SEGMENTID', max_length=255, null=True)), + ('networkqos', models.CharField(db_column=b'NETWORKQOS', max_length=255, null=True)), + ('create_time', models.CharField(blank=True, db_column=b'CREATETIME', max_length=200, null=True)), + ('physicalNetwork', models.CharField(db_column=b'PHYNETWORK', max_length=255, null=True)), + ('is_shared', models.IntegerField(db_column=b'ISSHARED', default=0, null=True)), + ('vlantrans', models.IntegerField(db_column=b'VLANTRANS', null=True)), + ('routerExternal', models.IntegerField(db_column=b'ROUTEREXTERNAL', default=0, null=True)), + ('nodeId', models.CharField(db_column=b'NODEID', max_length=255, null=True)), + ], + options={ + 'db_table': 'NETWORKINST', + }, + ), + migrations.CreateModel( + name='NfInstModel', + fields=[ + ('nfinstid', models.CharField(db_column=b'NFINSTID', max_length=200, primary_key=True, serialize=False)), + ('nf_name', models.CharField(blank=True, db_column=b'NFNAME', max_length=100, null=True)), + ('vnfminstid', models.CharField(db_column=b'VNFMINSTID', max_length=255)), + ('package_id', models.CharField(blank=True, db_column=b'PACKAGEID', max_length=200, null=True)), + ('status', models.CharField(blank=True, db_column=b'STATUS', max_length=20, null=True)), + ('flavour_id', models.CharField(blank=True, db_column=b'FLAVOURID', max_length=200, null=True)), + ('location', models.CharField(blank=True, db_column=b'LOCATION', max_length=200, null=True)), + ('version', models.CharField(db_column=b'VERSION', max_length=255, null=True)), + ('vendor', models.CharField(blank=True, db_column=b'VENDOR', max_length=255, null=True)), + ('netype', models.CharField(db_column=b'NETYPE', max_length=255, null=True)), + ('vnfd_model', models.TextField(blank=True, db_column=b'VNFDMODEL', max_length=20000, null=True)), + ('input_params', models.TextField(blank=True, db_column=b'INPUTPARAMS', max_length=2000, null=True)), + ('create_time', models.CharField(blank=True, db_column=b'CREATETIME', max_length=200, null=True)), + ('lastuptime', models.CharField(blank=True, db_column=b'LASTUPTIME', max_length=200, null=True)), + ('nf_desc', models.CharField(blank=True, db_column=b'VNFINSTANCEDESC', max_length=200, null=True)), + ('vnfdid', models.CharField(blank=True, db_column=b'VNFDID', max_length=200, null=True)), + ('vnfSoftwareVersion', models.CharField(blank=True, db_column=b'VNFSOFTWAREVER', max_length=200, null=True)), + ('vnfConfigurableProperties', models.TextField(blank=True, db_column=b'VNFCONFIGURABLEPROPERTIES', max_length=20000, null=True)), + ('localizationLanguage', models.CharField(db_column=b'LOCALIZATIONLANGUAGE', max_length=255, null=True)), + ('operationState', models.CharField(db_column=b'OPERATIONSTATE', max_length=255, null=True)), + ('resInfo', models.TextField(blank=True, db_column=b'RESINFO', max_length=20000, null=True)), + ('vimInfo', models.TextField(blank=True, db_column=b'VIMINFO', max_length=20000, null=True)), + ], + options={ + 'db_table': 'NFINST', + }, + ), + migrations.CreateModel( + name='NfvoRegInfoModel', + fields=[ + ('nfvoid', models.CharField(db_column=b'NFVOID', max_length=255, primary_key=True, serialize=False)), + ('vnfminstid', models.CharField(db_column=b'VNFMINSTID', max_length=255)), + ('apiurl', models.CharField(db_column=b'URL', max_length=255)), + ('nfvouser', models.CharField(db_column=b'USERNAME', max_length=255, null=True)), + ('nfvopassword', models.CharField(db_column=b'PASSWD', max_length=255, null=True)), + ('authtype', models.IntegerField(db_column=b'AUTHTYPE', default=2)), + ('clientcert', models.CharField(db_column=b'CLIENTCERT', max_length=255, null=True)), + ('servercert', models.CharField(db_column=b'SERVERCERT', max_length=255, null=True)), + ('regtime', models.CharField(db_column=b'REGTIME', max_length=255)), + ], + options={ + 'db_table': 'NFVOREGINFO', + }, + ), + migrations.CreateModel( + name='PortInstModel', + fields=[ + ('portid', models.CharField(db_column=b'PORTID', max_length=255, primary_key=True, serialize=False)), + ('networkid', models.CharField(db_column=b'NETWORKID', max_length=255)), + ('subnetworkid', models.CharField(db_column=b'SUBNETWORKID', max_length=255, null=True)), + ('vimid', models.CharField(db_column=b'VIMID', max_length=255)), + ('resourceid', models.CharField(db_column=b'RESOURCEID', max_length=255)), + ('name', models.CharField(db_column=b'NAME', max_length=255, null=True)), + ('insttype', models.IntegerField(db_column=b'INSTTYPE')), + ('instid', models.CharField(db_column=b'INSTID', max_length=255)), + ('cpinstanceid', models.CharField(db_column=b'CPINSTANCEID', max_length=255, null=True)), + ('bandwidth', models.CharField(db_column=b'BANDWIDTH', max_length=255, null=True)), + ('operationalstate', models.CharField(db_column=b'OPERATIONALSTATE', max_length=255, null=True)), + ('ipaddress', models.CharField(db_column=b'IPADDRESS', max_length=255)), + ('macaddress', models.CharField(db_column=b'MACADDRESS', max_length=255)), + ('nicorder', models.CharField(db_column=b'NICORDER', max_length=255)), + ('floatipaddress', models.CharField(db_column=b'FLOATIPADDRESS', max_length=255, null=True)), + ('serviceipaddress', models.CharField(db_column=b'SERVICEIPADDRESS', max_length=255, null=True)), + ('typevirtualnic', models.CharField(db_column=b'TYPEVIRTUALNIC', max_length=255, null=True)), + ('sfcencapsulation', models.CharField(db_column=b'SFCENCAPSULATION', max_length=255, null=True)), + ('direction', models.CharField(db_column=b'DIRECTION', max_length=255, null=True)), + ('tenant', models.CharField(db_column=b'TENANT', max_length=255, null=True)), + ('interfacename', models.CharField(blank=True, db_column=b'INTERFACENAME', max_length=255, null=True)), + ('vmid', models.CharField(blank=True, db_column=b'VMID', max_length=255, null=True)), + ('create_time', models.CharField(blank=True, db_column=b'CREATETIME', max_length=200, null=True)), + ('securityGroups', models.CharField(db_column=b'SECURITYGROUPS', max_length=255)), + ('is_predefined', models.IntegerField(db_column=b'ISPREDEFINED', default=0, null=True)), + ('nodeId', models.CharField(db_column=b'NODEID', max_length=255, null=True)), + ], + options={ + 'db_table': 'PORTINST', + }, + ), + migrations.CreateModel( + name='StorageInstModel', + fields=[ + ('storageid', models.CharField(db_column=b'STORAGEID', max_length=255, primary_key=True, serialize=False)), + ('vimid', models.CharField(db_column=b'VIMID', max_length=255)), + ('resourceid', models.CharField(db_column=b'RESOURCEID', max_length=255)), + ('insttype', models.IntegerField(db_column=b'INSTTYPE')), + ('instid', models.CharField(db_column=b'INSTID', max_length=255)), + ('name', models.CharField(db_column=b'NAME', max_length=255, null=True)), + ('storagetype', models.CharField(db_column=b'STORAGETYPE', max_length=255)), + ('size', models.CharField(db_column=b'SIZE', max_length=255)), + ('tenant', models.CharField(db_column=b'TENANT', max_length=50, null=True)), + ('is_predefined', models.IntegerField(db_column=b'ISPREDEFINED', default=0, null=True)), + ('create_time', models.CharField(blank=True, db_column=b'CREATETIME', max_length=200, null=True)), + ('nodeId', models.CharField(db_column=b'NODEID', max_length=255, null=True)), + ], + options={ + 'db_table': 'STORAGEINST', + }, + ), + migrations.CreateModel( + name='SubNetworkInstModel', + fields=[ + ('subnetworkid', models.CharField(db_column=b'SUBNETWORKID', max_length=255, primary_key=True, serialize=False)), + ('vimid', models.CharField(db_column=b'VIMID', max_length=255)), + ('resourceid', models.CharField(db_column=b'RESOURCEID', max_length=255)), + ('networkid', models.CharField(db_column=b'NETWORKID', max_length=255)), + ('insttype', models.IntegerField(db_column=b'INSTTYPE')), + ('instid', models.CharField(db_column=b'INSTID', max_length=255)), + ('name', models.CharField(db_column=b'NAME', max_length=255)), + ('ipversion', models.IntegerField(db_column=b'IPVERSION', null=True)), + ('gatewayip', models.CharField(db_column=b'GATEWAYIP', max_length=255, null=True)), + ('isdhcpenabled', models.IntegerField(db_column=b'ISDHCPENABLED', null=True)), + ('cidr', models.CharField(db_column=b'CIDR', max_length=255)), + ('vdsname', models.CharField(db_column=b'VDSNAME', max_length=255, null=True)), + ('operationalstate', models.CharField(db_column=b'OPERATIONALSTATE', max_length=255, null=True)), + ('tenant', models.CharField(db_column=b'TENANT', max_length=255, null=True)), + ('is_predefined', models.IntegerField(db_column=b'ISPREDEFINED', default=0, null=True)), + ('create_time', models.CharField(blank=True, db_column=b'CREATETIME', max_length=200, null=True)), + ('dnsNameservers', models.TextField(db_column=b'DNSNAMESERVERS', max_length=1024)), + ('hostRoutes', models.TextField(db_column=b'HOSTROUTES', max_length=1024)), + ('allocationPools', models.TextField(db_column=b'ALLOCATIONPOOLS', max_length=1024)), + ], + options={ + 'db_table': 'SUBNETWORKINST', + }, + ), + migrations.CreateModel( + name='SubscriptionModel', + fields=[ + ('subscription_id', models.CharField(db_column=b'SUBSCRIPTIONID', max_length=255, primary_key=True, serialize=False)), + ('callback_uri', models.CharField(db_column=b'CALLBACKURI', max_length=255)), + ('auth_info', models.TextField(blank=True, db_column=b'AUTHINFO', max_length=20000, null=True)), + ('notification_types', models.TextField(db_column=b'NOTIFICATIONTYPES', null=True)), + ('operation_types', models.TextField(db_column=b'OPERATIONTYPES', null=True)), + ('operation_states', models.TextField(db_column=b'OPERATIONSTATES', null=True)), + ('vnf_instance_filter', models.TextField(db_column=b'VNFINSTANCEFILTER', null=True)), + ('links', models.TextField(db_column=b'LINKS', max_length=20000)), + ], + options={ + 'db_table': 'SUBSCRIPTION', + }, + ), + migrations.CreateModel( + name='VLInstModel', + fields=[ + ('vlinstanceid', models.CharField(db_column=b'VLINSTANCEID', max_length=255, primary_key=True, serialize=False)), + ('vldid', models.CharField(db_column=b'VLDID', max_length=255)), + ('vlinstancename', models.CharField(blank=True, db_column=b'VLINSTANCENAME', max_length=255, null=True)), + ('ownertype', models.IntegerField(db_column=b'OWNERTYPE')), + ('ownerid', models.CharField(db_column=b'OWNERID', max_length=255)), + ('relatednetworkid', models.CharField(blank=True, db_column=b'RELATEDNETWORKID', max_length=255, null=True)), + ('relatedsubnetworkid', models.CharField(blank=True, db_column=b'RELATEDSUBNETWORKID', max_length=255, null=True)), + ('vltype', models.IntegerField(db_column=b'VLTYPE', default=0)), + ('vimid', models.CharField(db_column=b'VIMID', max_length=255)), + ('tenant', models.CharField(db_column=b'TENANT', max_length=50)), + ], + options={ + 'db_table': 'VLINST', + }, + ), + migrations.CreateModel( + name='VmInstModel', + fields=[ + ('vmid', models.CharField(db_column=b'VMID', max_length=255, primary_key=True, serialize=False)), + ('vimid', models.CharField(db_column=b'VIMID', max_length=255)), + ('tenant', models.CharField(db_column=b'TENANT', max_length=255, null=True)), + ('resourceid', models.CharField(db_column=b'RESOURCEID', max_length=255)), + ('vmname', models.CharField(db_column=b'VMNAME', max_length=255)), + ('nic_array', models.CharField(db_column=b'NICARRAY', max_length=255)), + ('metadata', models.CharField(db_column=b'METADATA', max_length=255)), + ('volume_array', models.CharField(db_column=b'VOLUMEARRAY', max_length=255)), + ('server_group', models.CharField(db_column=b'SERVERGROUP', max_length=255)), + ('availability_zone', models.CharField(db_column=b'AVAILABILITYZONE', max_length=255)), + ('flavor_id', models.CharField(db_column=b'FLAVORID', max_length=255)), + ('security_groups', models.CharField(db_column=b'SECURITYGROUPS', max_length=255)), + ('operationalstate', models.CharField(db_column=b'OPERATIONALSTATE', max_length=255, null=True)), + ('insttype', models.IntegerField(db_column=b'INSTTYPE')), + ('is_predefined', models.IntegerField(db_column=b'ISPREDEFINED', default=0, null=True)), + ('create_time', models.CharField(blank=True, db_column=b'CREATETIME', max_length=200, null=True)), + ('instid', models.CharField(db_column=b'INSTID', max_length=255)), + ('nodeId', models.CharField(db_column=b'NODEID', max_length=255, null=True)), + ], + options={ + 'db_table': 'VMINST', + }, + ), + migrations.CreateModel( + name='VNFCInstModel', + fields=[ + ('vnfcinstanceid', models.CharField(db_column=b'VNFCINSTANCEID', max_length=255, primary_key=True, serialize=False)), + ('vduid', models.CharField(db_column=b'VDUID', max_length=255)), + ('vdutype', models.CharField(db_column=b'VDUTYPE', max_length=255)), + ('instid', models.CharField(db_column=b'NFINSTID', max_length=255)), + ('vmid', models.CharField(db_column=b'VMID', max_length=255)), + ('is_predefined', models.IntegerField(db_column=b'ISPREDEFINED', default=0, null=True)), + ], + options={ + 'db_table': 'VNFCINST', + }, + ), + migrations.CreateModel( + name='VNFLcmOpOccModel', + fields=[ + ('id', models.CharField(db_column=b'ID', max_length=255, primary_key=True, serialize=False)), + ('operation_state', models.CharField(db_column=b'OPERATIONSTATE', max_length=30)), + ('state_entered_time', models.CharField(db_column=b'STATEENTEREDTIME', max_length=30)), + ('start_time', models.CharField(db_column=b'STARTTIME', max_length=30)), + ('vnf_instance_id', models.CharField(db_column=b'VNFINSTANCEID', max_length=255)), + ('grant_id', models.CharField(db_column=b'GRANTID', max_length=255, null=True)), + ('operation', models.CharField(db_column=b'OPERATION', max_length=30)), + ('is_automatic_invocation', models.CharField(db_column=b'ISAUTOMATICINVOCATION', max_length=5)), + ('operation_params', models.TextField(db_column=b'OPERATIONPARAMS')), + ('is_cancel_pending', models.CharField(db_column=b'ISCANCELPENDING', max_length=5)), + ('cancel_mode', models.TextField(db_column=b'CANCELMODE', null=True)), + ('error', models.TextField(db_column=b'ERROR', null=True)), + ('resource_changes', models.TextField(db_column=b'RESOURCECHANGES', null=True)), + ('changed_info', models.TextField(db_column=b'CHANGEDINFO', null=True)), + ('changed_ext_connectivity', models.TextField(db_column=b'CHANGEDEXTCONNECTIVITY', null=True)), + ('links', models.TextField(db_column=b'LINKS')), + ], + options={ + 'db_table': 'VNFLCMOPOCCS', + }, + ), + ] diff --git a/lcm/lcm/pub/database/migrations/__init__.py b/lcm/lcm/pub/database/migrations/__init__.py new file mode 100644 index 00000000..0c847b7d --- /dev/null +++ b/lcm/lcm/pub/database/migrations/__init__.py @@ -0,0 +1,13 @@ +# Copyright 2019 ZTE Corporation. +# +# 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. -- 2.16.6