aboutsummaryrefslogtreecommitdiffstats
path: root/standalone/src/main/assembly/resources/dbscripts/mysql
diff options
context:
space:
mode:
Diffstat (limited to 'standalone/src/main/assembly/resources/dbscripts/mysql')
-rw-r--r--standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql6
1 files changed, 3 insertions, 3 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 dfb33597..a8f7c21f 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
@@ -120,7 +120,7 @@ ALTER TABLE `performance_commoneventheader` ADD INDEX `performance_commoneventhe
-- ----------------------------
DROP TABLE IF EXISTS `service_instances`;
CREATE TABLE `service_instances` (
- `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
+ `id` varchar(100) 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,
@@ -128,6 +128,6 @@ CREATE TABLE `service_instances` (
`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;
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;