diff options
author | Liam Fallon <liam.fallon@est.tech> | 2022-02-11 11:01:30 +0000 |
---|---|---|
committer | Gerrit Code Review <gerrit@onap.org> | 2022-02-11 11:01:30 +0000 |
commit | 355bc6f553089e93e87c64e85c435c13ce6fcf88 (patch) | |
tree | 2f178775a4dbf43e68c56194a4fcf961240ada08 /feature-state-management/src/main/feature/db | |
parent | 950fe7dcd47cf4ab7b09b46bbef992f1d5b7fe0d (diff) | |
parent | 1bab60c2a752ad50844465d6db1f28b8a8d776ff (diff) |
Merge "remove unused state-management related modules"
Diffstat (limited to 'feature-state-management/src/main/feature/db')
-rw-r--r-- | feature-state-management/src/main/feature/db/statemanagement/sql/18020-statemanagement.upgrade.sql | 74 |
1 files changed, 0 insertions, 74 deletions
diff --git a/feature-state-management/src/main/feature/db/statemanagement/sql/18020-statemanagement.upgrade.sql b/feature-state-management/src/main/feature/db/statemanagement/sql/18020-statemanagement.upgrade.sql deleted file mode 100644 index f73f992b..00000000 --- a/feature-state-management/src/main/feature/db/statemanagement/sql/18020-statemanagement.upgrade.sql +++ /dev/null @@ -1,74 +0,0 @@ -/*- - * ============LICENSE_START======================================================= - * feature-state-management - * ================================================================================ - * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. - * ================================================================================ - * 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. - * ============LICENSE_END========================================================= - */ - -set foreign_key_checks=0; - -CREATE TABLE if not exists statemanagement.StateManagementEntity -( - id int not null auto_increment, - resourceName varchar(100) not null, - adminState varchar(20) not null, - opstate varchar(20) not null, - availStatus varchar(20), - standbyStatus varchar(20), - created_date timestamp not null default current_timestamp, - modifiedDate timestamp not null, - primary key(id), - unique key resource(resourceName) -); - -CREATE TABLE if not exists statemanagement.ResourceRegistrationEntity -( - resourceRegistrationId bigint not null auto_increment, - resourceName varchar(100) not null, - resourceURL varchar(255) not null, - site varchar(50), - nodetype varchar(50), - created_date timestamp not null default current_timestamp, - last_updated timestamp not null, - primary key (resourceRegistrationId), - unique key resource (resourceName), - unique key id_resource_url (resourceURL) -); - -CREATE TABLE if not exists statemanagement.ForwardProgressEntity -( - forwardProgressId bigint not null auto_increment, - resourceName varchar(100) not null, - fpc_count bigint not null, - created_date timestamp not null default current_timestamp, - last_updated timestamp not null, - primary key (forwardProgressId), - unique key resource_key (resourceName) -); - -CREATE TABLE if not exists statemanagement.sequence -( -SEQ_NAME VARCHAR(50) NOT NULL, -SEQ_COUNT DECIMAL(38,0), -PRIMARY KEY (SEQ_NAME) -); - --- Will only insert a record if none exists: -INSERT INTO statemanagement.SEQUENCE (SEQ_NAME,SEQ_COUNT) -SELECT * FROM (SELECT 'SEQ_GEN',1) AS tmp -WHERE NOT EXISTS(select SEQ_NAME from statemanagement.SEQUENCE where SEQ_NAME = 'SEQ_GEN') LIMIT 1; - -set foreign_key_checks=1;
\ No newline at end of file |