diff options
Diffstat (limited to 'catalog-core/distribution/catalog-standalone/src/main/assembly/conf/catalog-resource-createObj-mysql.sql')
-rw-r--r-- | catalog-core/distribution/catalog-standalone/src/main/assembly/conf/catalog-resource-createObj-mysql.sql | 75 |
1 files changed, 0 insertions, 75 deletions
diff --git a/catalog-core/distribution/catalog-standalone/src/main/assembly/conf/catalog-resource-createObj-mysql.sql b/catalog-core/distribution/catalog-standalone/src/main/assembly/conf/catalog-resource-createObj-mysql.sql deleted file mode 100644 index d49e60ba..00000000 --- a/catalog-core/distribution/catalog-standalone/src/main/assembly/conf/catalog-resource-createObj-mysql.sql +++ /dev/null @@ -1,75 +0,0 @@ --- --- Copyright 2016 [ZTE] and others. --- --- 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. --- - -use catalog; -DROP TABLE IF EXISTS catalog_package_table; - -CREATE TABLE catalog_package_table ( - CSARID VARCHAR(200) NOT NULL, - DOWNLOADURI VARCHAR(200) NULL, - SIZE VARCHAR(100) NULL, - FORMAT VARCHAR(100) NULL, - CREATETIME VARCHAR(100) NULL, - DELETIONPENDING VARCHAR(100) NULL, - MODIFYTIME VARCHAR(100) NULL, - OPERATIONALSTATE VARCHAR(100) NULL, - USAGESTATE VARCHAR(100) NULL, - ONBOARDSTATE VARCHAR(100) NULL, - NAME VARCHAR(100) NULL, - VERSION VARCHAR(20) NULL, - PROVIDER VARCHAR(300) NULL, - TYPE VARCHAR(300) NULL, - PROCESSSTATE VARCHAR(100) NULL, - CONSTRAINT CATALOG_PACKAGE_TABLE_OID PRIMARY KEY(CSARID) -); - -DROP TABLE IF EXISTS catalog_service_template_table; -CREATE TABLE catalog_service_template_table ( - SERVICETEMPLATEID VARCHAR(200) NOT NULL, - TEMPLATENAME VARCHAR(100) NULL, - TYPE VARCHAR(50) NULL, - VENDOR VARCHAR(100) NULL, - VERSION VARCHAR(20) NULL, - CSARID VARCHAR(100) NULL, - INPUTS LONGTEXT NULL, - ROWDATA LONGTEXT NULL, - OPERATIONS LONGTEXT NULL, - DOWNLOADURI VARCHAR(200) NULL, - - CONSTRAINT CATALOG_SERVICE_TEMPLATE_TABLE_OID PRIMARY KEY(SERVICETEMPLATEID) -); - -DROP TABLE IF EXISTS catalog_node_template_table; -CREATE TABLE catalog_node_template_table ( - NODETEMPLATEID VARCHAR(200) NOT NULL, - NAME VARCHAR(100) NULL, - SERVICETEMPLATEID VARCHAR(200) NULL, - TYPE VARCHAR(50) NULL, - PROPERTIES LONGTEXT NULL, - RELATIONSHIPS LONGTEXT NULL, - - CONSTRAINT catalog_node_template_table PRIMARY KEY(NODETEMPLATEID) -); -DROP TABLE IF EXISTS catalog_model_substitution_mapping_table; -CREATE TABLE catalog_model_substitution_mapping_table ( - MAPPINGID VARCHAR(200) NOT NULL, - NODETYPE VARCHAR(100) NULL, - SERVICETEMPLATEID VARCHAR(200) NULL, - REQUIREMENTS LONGTEXT NULL, - CAPABILITIES LONGTEXT NULL, - - CONSTRAINT catalog_model_substitution_mapping_table PRIMARY KEY(MAPPINGID) -); |