diff options
| author |   guochuyicmri <guochuyi@chinamobile.com> | 2018-10-23 17:21:59 +0800 |
|---|---|---|
| committer | guochuyicmri <guochuyi@chinamobile.com> | 2018-10-23 17:22:15 +0800 |
| commit | 1873741f068ceebd273177d33134876907091483 (patch) | |
| tree | 486b8e2625848cecabe9228624ad431c5575db5b /standalone/src/main/assembly/resources/dbscripts | |
| parent | 589ae248e7b707803ee2259a45856fe72ff11f71 (diff) | |
modify e2e serviceInstancelist
Change-Id: Ib3f7b509e9815aa582c1248ccbf5622854b2c9cd
Issue-ID: USECASEUI-164
Signed-off-by: guochuyicmri <guochuyi@chinamobile.com>
Diffstat (limited to 'standalone/src/main/assembly/resources/dbscripts')
| -rw-r--r-- | standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql | 15 |
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; |