diff options
author | 2022-02-10 13:34:40 -0600 | |
---|---|---|
committer | 2022-02-10 13:34:40 -0600 | |
commit | 1bab60c2a752ad50844465d6db1f28b8a8d776ff (patch) | |
tree | 0719fc7d89c0c2d1aad5e8432a19b5bc271fa150 /feature-state-management/src/main/feature/db/statemanagement/sql | |
parent | beb5cb32f7d1ccb08735ea3d5f77a8b2223857e4 (diff) |
remove unused state-management related modules
Issue-ID: POLICY-3922
Signed-off-by: jhh <jorge.hernandez-herrero@att.com>
Change-Id: Ie8164a482cce4598c621b58af612ab3a45d848ae
Diffstat (limited to 'feature-state-management/src/main/feature/db/statemanagement/sql')
-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 |