| ITSERVICES\rb7147 | e0addf5 | 2017-04-25 11:46:00 -0400 | [diff] [blame] | 1 | ALTER TABLE PolicyEntity DROP CONSTRAINT FK_PolicyEntity_configurationDataId |
| 2 | ALTER TABLE PolicyEntity DROP CONSTRAINT FK_PolicyEntity_actionBodyId |
| 3 | ALTER TABLE PdpEntity DROP CONSTRAINT FK_PdpEntity_groupKey |
| 4 | ALTER TABLE FunctionDefinition DROP CONSTRAINT FK_FunctionDefinition_return_datatype |
| 5 | ALTER TABLE Attribute DROP CONSTRAINT FK_Attribute_category |
| 6 | ALTER TABLE Attribute DROP CONSTRAINT FK_Attribute_constraint_type |
| 7 | ALTER TABLE Attribute DROP CONSTRAINT FK_Attribute_created_by |
| 8 | ALTER TABLE Attribute DROP CONSTRAINT FK_Attribute_modified_by |
| 9 | ALTER TABLE Attribute DROP CONSTRAINT FK_Attribute_datatype |
| 10 | ALTER TABLE ConstraintValues DROP CONSTRAINT FK_ConstraintValues_attribute_id |
| 11 | ALTER TABLE FunctionArguments DROP CONSTRAINT FK_FunctionArguments_function_id |
| 12 | ALTER TABLE FunctionArguments DROP CONSTRAINT FK_FunctionArguments_datatype_id |
| 13 | ALTER TABLE ActionPolicyDict DROP CONSTRAINT FK_ActionPolicyDict_modified_by |
| 14 | ALTER TABLE ActionPolicyDict DROP CONSTRAINT FK_ActionPolicyDict_created_by |
| 15 | ALTER TABLE DecisionSettings DROP CONSTRAINT FK_DecisionSettings_created_by |
| 16 | ALTER TABLE DecisionSettings DROP CONSTRAINT FK_DecisionSettings_datatype |
| 17 | ALTER TABLE DecisionSettings DROP CONSTRAINT FK_DecisionSettings_modified_by |
| 18 | ALTER TABLE MicroServiceModels DROP CONSTRAINT FK_MicroServiceModels_imported_by |
| 19 | ALTER TABLE AttributeAssignment DROP CONSTRAINT FK_AttributeAssignment_OBADVICE_id |
| 20 | ALTER TABLE BRMSParamTemplate DROP CONSTRAINT FK_BRMSParamTemplate_created_by |
| 21 | ALTER TABLE ClosedLoopD2Services DROP CONSTRAINT FK_ClosedLoopD2Services_modified_by |
| 22 | ALTER TABLE ClosedLoopD2Services DROP CONSTRAINT FK_ClosedLoopD2Services_created_by |
| 23 | ALTER TABLE ClosedLoopSite DROP CONSTRAINT FK_ClosedLoopSite_modified_by |
| 24 | ALTER TABLE ClosedLoopSite DROP CONSTRAINT FK_ClosedLoopSite_created_by |
| 25 | ALTER TABLE DescriptiveScope DROP CONSTRAINT FK_DescriptiveScope_created_by |
| 26 | ALTER TABLE DescriptiveScope DROP CONSTRAINT FK_DescriptiveScope_modified_by |
| 27 | ALTER TABLE EcompName DROP CONSTRAINT FK_EcompName_created_by |
| 28 | ALTER TABLE EcompName DROP CONSTRAINT FK_EcompName_modified_by |
| 29 | ALTER TABLE ObadviceExpressions DROP CONSTRAINT FK_ObadviceExpressions_obadvice_id |
| 30 | ALTER TABLE ObadviceExpressions DROP CONSTRAINT FK_ObadviceExpressions_attribute_id |
| 31 | ALTER TABLE PEPOptions DROP CONSTRAINT FK_PEPOptions_modified_by |
| 32 | ALTER TABLE PEPOptions DROP CONSTRAINT FK_PEPOptions_created_by |
| 33 | ALTER TABLE PIPConfigParams DROP CONSTRAINT FK_PIPConfigParams_PIP_ID |
| 34 | ALTER TABLE PIPConfiguration DROP CONSTRAINT FK_PIPConfiguration_TYPE |
| 35 | ALTER TABLE PIPResolver DROP CONSTRAINT FK_PIPResolver_PIP_ID |
| 36 | ALTER TABLE PIPResolverParams DROP CONSTRAINT FK_PIPResolverParams_ID_RESOLVER |
| 37 | ALTER TABLE roles DROP CONSTRAINT FK_roles_loginid |
| 38 | ALTER TABLE TERM DROP CONSTRAINT FK_TERM_modified_by |
| 39 | ALTER TABLE TERM DROP CONSTRAINT FK_TERM_created_by |
| 40 | ALTER TABLE VarbindDictionary DROP CONSTRAINT FK_VarbindDictionary_modified_by |
| 41 | ALTER TABLE VarbindDictionary DROP CONSTRAINT FK_VarbindDictionary_created_by |
| 42 | ALTER TABLE VNFType DROP CONSTRAINT FK_VNFType_modified_by |
| 43 | ALTER TABLE VNFType DROP CONSTRAINT FK_VNFType_created_by |
| 44 | ALTER TABLE VSCLAction DROP CONSTRAINT FK_VSCLAction_modified_by |
| 45 | ALTER TABLE VSCLAction DROP CONSTRAINT FK_VSCLAction_created_by |
| 46 | ALTER TABLE PolicyGroupEntity DROP CONSTRAINT FK_PolicyGroupEntity_policyId |
| 47 | ALTER TABLE PolicyGroupEntity DROP CONSTRAINT FK_PolicyGroupEntity_groupKey |
| 48 | DROP TABLE PolicyEntity |
| 49 | DROP TABLE ConfigurationDataEntity |
| 50 | DROP TABLE PolicyDBDaoEntity |
| 51 | DROP TABLE GroupEntity |
| 52 | DROP TABLE PdpEntity |
| 53 | DROP TABLE ActionBodyEntity |
| 54 | DROP TABLE DatabaseLockEntity |
| 55 | DROP TABLE PolicyVersion |
| 56 | DROP TABLE POLICYSCORE |
| 57 | DROP TABLE FunctionDefinition |
| 58 | DROP TABLE Attribute |
| 59 | DROP TABLE Category |
| 60 | DROP TABLE ConstraintType |
| 61 | DROP TABLE ConstraintValues |
| 62 | DROP TABLE Datatype |
| 63 | DROP TABLE FunctionArguments |
| 64 | DROP TABLE UserInfo |
| 65 | DROP TABLE ActionPolicyDict |
| 66 | DROP TABLE DecisionSettings |
| 67 | DROP TABLE MicroServiceModels |
| 68 | DROP TABLE actionlist |
| 69 | DROP TABLE AddressGroup |
| 70 | DROP TABLE AttributeAssignment |
| 71 | DROP TABLE BRMSParamTemplate |
| 72 | DROP TABLE ClosedLoopD2Services |
| 73 | DROP TABLE ClosedLoopSite |
| 74 | DROP TABLE DCAEUsers |
| 75 | DROP TABLE DCAEuuid |
| 76 | DROP TABLE DescriptiveScope |
| 77 | DROP TABLE EcompName |
| 78 | DROP TABLE EnforcingType |
| 79 | DROP TABLE GlobalRoleSettings |
| 80 | DROP TABLE GroupPolicyScopeList |
| 81 | DROP TABLE GroupServiceList |
| 82 | DROP TABLE MicroServiceConfigName |
| 83 | DROP TABLE MicroServiceLocation |
| 84 | DROP TABLE Obadvice |
| 85 | DROP TABLE ObadviceExpressions |
| 86 | DROP TABLE PEPOptions |
| 87 | DROP TABLE PIPConfigParams |
| 88 | DROP TABLE PIPConfiguration |
| 89 | DROP TABLE PIPResolver |
| 90 | DROP TABLE PIPResolverParams |
| 91 | DROP TABLE PIPType |
| 92 | DROP TABLE PolicyAlgorithms |
| 93 | DROP TABLE policy_manangement |
| 94 | DROP TABLE PolicyScopeService |
| 95 | DROP TABLE PolicyScopeType |
| 96 | DROP TABLE PolicyScopeResource |
| 97 | DROP TABLE PolicyScopeClosedLoop |
| 98 | DROP TABLE portlist |
| 99 | DROP TABLE protocollist |
| 100 | DROP TABLE RemoteCatalogValues |
| 101 | DROP TABLE roles |
| 102 | DROP TABLE RuleAlgorithms |
| 103 | DROP TABLE securityzone |
| 104 | DROP TABLE servicegroup |
| 105 | DROP TABLE SystemLogDB |
| 106 | DROP TABLE TERM |
| 107 | DROP TABLE VarbindDictionary |
| 108 | DROP TABLE VMType |
| 109 | DROP TABLE VNFType |
| 110 | DROP TABLE VSCLAction |
| 111 | DROP TABLE zone |
| 112 | DROP TABLE BackUpMonitorEntity |
| 113 | DROP TABLE StateManagementEntity |
| 114 | DROP TABLE ForwardProgressEntity |
| 115 | DROP TABLE ResourceRegistrationEntity |
| 116 | DROP TABLE IntegrityAuditEntity |
| 117 | DROP TABLE PolicyGroupEntity |
| 118 | DELETE FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN' |