From 6c26afae8b63eb3cb032d0057aed3ca0d25d3830 Mon Sep 17 00:00:00 2001 From: 이민희 <mhlee@maprex.co.kr> Date: 화, 15 2월 2022 14:32:59 +0900 Subject: [PATCH] - migration 5,6파일 합침 db초기화 필요 --- /dev/null | 4 ---- src/main/resources/migration/V1_5__alter_data.sql | 4 +--- 2 files changed, 1 insertions(+), 7 deletions(-) diff --git a/src/main/resources/migration/V1_5__alter_data.sql b/src/main/resources/migration/V1_5__alter_data.sql index 96f5948..218b91c 100644 --- a/src/main/resources/migration/V1_5__alter_data.sql +++ b/src/main/resources/migration/V1_5__alter_data.sql @@ -1,6 +1,4 @@ /* ISP, �샇�뒪�똿�쓽 肄붾뱶 KEY 遺��뿬 */ ALTER TABLE `isp_field` ADD UNIQUE INDEX `codeIndex` (`code`) USING BTREE; -ALTER TABLE `hosting_field` ADD UNIQUE INDEX `codeIndex` (`code`) USING BTREE; -ALTER TABLE `issue_isp` ADD UNIQUE INDEX `codeIndex` (`code`) USING BTREE; -ALTER TABLE `issue_hosting` ADD UNIQUE INDEX `codeIndex` (`code`) USING BTREE; \ No newline at end of file +ALTER TABLE `hosting_field` ADD UNIQUE INDEX `codeIndex` (`code`) USING BTREE; \ No newline at end of file diff --git a/src/main/resources/migration/V1_6__alter_data.sql b/src/main/resources/migration/V1_6__alter_data.sql deleted file mode 100644 index 80ff2a3..0000000 --- a/src/main/resources/migration/V1_6__alter_data.sql +++ /dev/null @@ -1,4 +0,0 @@ - -/* ISP, �샇�뒪�똿�쓽 肄붾뱶 KEY �젣嫄� */ -ALTER TABLE `issue_isp` DROP INDEX IF EXISTS `codeIndex`; -ALTER TABLE `issue_hosting` DROP INDEX IF EXISTS `codeIndex`; \ No newline at end of file -- Gitblit v1.8.0