summaryrefslogtreecommitdiffstats
path: root/standalone
diff options
context:
space:
mode:
authorguochuyicmri <guochuyi@chinamobile.com>2018-10-23 17:21:59 +0800
committerguochuyicmri <guochuyi@chinamobile.com>2018-10-23 17:22:15 +0800
commit1873741f068ceebd273177d33134876907091483 (patch)
tree486b8e2625848cecabe9228624ad431c5575db5b /standalone
parent589ae248e7b707803ee2259a45856fe72ff11f71 (diff)
modify e2e serviceInstancelist
Change-Id: Ib3f7b509e9815aa582c1248ccbf5622854b2c9cd Issue-ID: USECASEUI-164 Signed-off-by: guochuyicmri <guochuyi@chinamobile.com>
Diffstat (limited to 'standalone')
-rw-r--r--standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql
index 2730887d..dfb33597 100644
--- a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql
+++ b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql
@@ -115,4 +115,19 @@ CREATE TABLE `performance_commoneventheader` (
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `performance_commoneventheader` ADD INDEX `performance_commoneventheader_index` (`sourceId`);
+-- ----------------------------
+-- Table structure for service_instances
+-- ----------------------------
+DROP TABLE IF EXISTS `service_instances`;
+CREATE TABLE `service_instances` (
+ `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
+ `serviceInstanceId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
+ `customerId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
+ `serviceType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
+ `serviceDomain` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
+ `operationId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
+ `parentServiceInstanceId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
+ `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;