From ca39b5ed07acd0edf4326f12bfbdf7b55cf7b0a2 Mon Sep 17 00:00:00 2001 From: shentao Date: Mon, 25 Sep 2017 17:36:36 +0800 Subject: Upload createDB script for usecase-ui Change-Id: Ib431b7027b17a5cecfbc7cba4623e7a30d152d90 Issue-Id: USECASEUI-8 Signed-off-by: shentao --- resources/dbscripts/mysql/usecase-ui-createobj.sql | 111 +++++++++++++++++++++ 1 file changed, 111 insertions(+) create mode 100644 resources/dbscripts/mysql/usecase-ui-createobj.sql (limited to 'resources/dbscripts/mysql/usecase-ui-createobj.sql') diff --git a/resources/dbscripts/mysql/usecase-ui-createobj.sql b/resources/dbscripts/mysql/usecase-ui-createobj.sql new file mode 100644 index 00000000..7a55c72b --- /dev/null +++ b/resources/dbscripts/mysql/usecase-ui-createobj.sql @@ -0,0 +1,111 @@ +-- +-- Copyright (C) 2017 CMCC, Inc. and others. 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. +-- + +use usercaseui; + +SET FOREIGN_KEY_CHECKS=0; +-- ---------------------------- +-- Table structure for alarms_additionalinformation +-- ---------------------------- +DROP TABLE IF EXISTS `alarms_additionalinformation`; +CREATE TABLE `alarms_additionalinformation` ( + `name` varchar(50) NOT NULL, + `value` varchar(500) NOT NULL, + `eventId` varchar(30) NOT NULL, + `createTime` datetime NOT NULL, + `updateTime` datetime NOT NULL, + PRIMARY KEY (`name`,`eventId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for alarms_commoneventheader +-- ---------------------------- +DROP TABLE IF EXISTS `alarms_commoneventheader`; +CREATE TABLE `alarms_commoneventheader` ( + `version` varchar(10) NOT NULL, + `eventName` varchar(50) NOT NULL, + `domain` varchar(30) NOT NULL, + `eventId` varchar(30) NOT NULL, + `eventType` varchar(30) NOT NULL, + `nfcNamingCode` varchar(30) DEFAULT NULL, + `nfNamingCode` varchar(30) DEFAULT NULL, + `sourceId` varchar(50) NOT NULL, + `sourceName` varchar(50) NOT NULL, + `reportingEntityId` varchar(30) NOT NULL, + `reportingEntityName` varchar(30) NOT NULL, + `priority` varchar(20) NOT NULL, + `startEpochMicrosec` varchar(20) NOT NULL, + `lastEpochMicroSec` varchar(20) NOT NULL, + `sequence` varchar(10) NOT NULL, + `faultFieldsVersion` varchar(10) NOT NULL, + `eventServrity` varchar(30) NOT NULL, + `eventSourceType` varchar(30) NOT NULL, + `eventCategory` varchar(30) NOT NULL, + `alarmCondition` varchar(400) NOT NULL, + `specificProblem` varchar(400) NOT NULL, + `vfStatus` varchar(10) NOT NULL, + `alarmInterfaceA` varchar(40) NOT NULL, + `status` varchar(11) NOT NULL, + `createTime` datetime NOT NULL, + `updateTime` datetime NOT NULL, + PRIMARY KEY (`eventId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for performance_additionalinformation +-- ---------------------------- +DROP TABLE IF EXISTS `performance_additionalinformation`; +CREATE TABLE `performance_additionalinformation` ( + `name` varchar(50) NOT NULL, + `value` varchar(500) NOT NULL, + `eventId` varchar(30) NOT NULL, + `createTime` datetime NOT NULL, + `updateTime` datetime NOT NULL, + PRIMARY KEY (`name`,`eventId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for performance_commoneventheader +-- ---------------------------- +DROP TABLE IF EXISTS `performance_commoneventheader`; +CREATE TABLE `performance_commoneventheader` ( + `version` varchar(10) NOT NULL, + `eventName` varchar(50) NOT NULL, + `domain` varchar(30) NOT NULL, + `eventId` varchar(30) NOT NULL, + `eventType` varchar(30) NOT NULL, + `nfcNamingCode` varchar(30) DEFAULT NULL, + `nfNamingCode` varchar(30) DEFAULT NULL, + `sourceId` varchar(50) NOT NULL, + `sourceName` varchar(50) NOT NULL, + `reportingEntityId` varchar(30) NOT NULL, + `reportingEntityName` varchar(30) NOT NULL, + `priority` varchar(20) NOT NULL, + `startEpochMicrosec` varchar(20) NOT NULL, + `lastEpochMicroSec` varchar(20) NOT NULL, + `sequence` varchar(10) NOT NULL, + `measurementsForVfScalingVersion` varchar(10) NOT NULL, + `measurementInterval` varchar(10) NOT NULL, + `createTime` datetime NOT NULL, + `updateTime` datetime NOT NULL, + PRIMARY KEY (`eventId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Init Records +-- ---------------------------- +INSERT INTO `alarms_additionalinformation` VALUES ('name', 'value', 'eventId', '2017-09-19 11:12:34', '2017-09-19 11:12:34'); +INSERT INTO `alarms_commoneventheader` VALUES ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '2017-09-04 15:25:11', '2017-09-11 15:25:19'); -- cgit 1.2.3-korg