diff options
author | sunqi310 <sun.qi310@zte.com.cn> | 2016-09-05 15:13:04 +0800 |
---|---|---|
committer | sunqi310 <sun.qi310@zte.com.cn> | 2016-09-05 15:13:04 +0800 |
commit | 5edea6a0cdff009f7a4f9326cc0359d229f9397a (patch) | |
tree | 31412b35f868a8e7df4be85315c2c91d2bb3466e /catalog-core/distribution/catalog-standalone/src/main/assembly/dbscripts/mysql | |
parent | b3b6d5db55af94b0472ec4c407ef3ecf2ac5c2ae (diff) |
add init db scripts
Change-Id: I565142502e1740666fa810c82ce927ed8a43ce35
Signed-off-by: sunqi310 <sun.qi310@zte.com.cn>
Diffstat (limited to 'catalog-core/distribution/catalog-standalone/src/main/assembly/dbscripts/mysql')
-rw-r--r-- | catalog-core/distribution/catalog-standalone/src/main/assembly/dbscripts/mysql/openo-common_tosca-catalog-createobj.sql | 95 |
1 files changed, 95 insertions, 0 deletions
diff --git a/catalog-core/distribution/catalog-standalone/src/main/assembly/dbscripts/mysql/openo-common_tosca-catalog-createobj.sql b/catalog-core/distribution/catalog-standalone/src/main/assembly/dbscripts/mysql/openo-common_tosca-catalog-createobj.sql new file mode 100644 index 00000000..308a416a --- /dev/null +++ b/catalog-core/distribution/catalog-standalone/src/main/assembly/dbscripts/mysql/openo-common_tosca-catalog-createobj.sql @@ -0,0 +1,95 @@ +-- +-- 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. +-- + +/******************drop old database and user***************************/ +use mysql; +drop database IF EXISTS catalog; +delete from user where User='catalog'; +FLUSH PRIVILEGES; + +/******************create new database and user***************************/ +create database catalog CHARACTER SET utf8; + +GRANT ALL PRIVILEGES ON catalog.* TO 'catalog'@'%' IDENTIFIED BY 'catalog' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON mysql.* TO 'catalog'@'%' IDENTIFIED BY 'catalog' WITH GRANT OPTION; + +GRANT ALL PRIVILEGES ON catalog.* TO 'catalog'@'localhost' IDENTIFIED BY 'catalog' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON mysql.* TO 'catalog'@'localhost' IDENTIFIED BY 'catalog' WITH GRANT OPTION; +FLUSH PRIVILEGES; + +use catalog; +set Names 'utf8'; +/******************delete old table and create new***************************/ +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) +); + |