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