From 3c105796dffaa37da1029fe7c8da981fbe33c860 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 수, 23 2월 2022 15:03:44 +0900
Subject: [PATCH] - 업체 카테고리 대분류 및 중분류 수정

---
 src/main/resources/migration/V1_8__alter_data.sql |    9 +++++++++
 1 files changed, 9 insertions(+), 0 deletions(-)

diff --git a/src/main/resources/migration/V1_8__alter_data.sql b/src/main/resources/migration/V1_8__alter_data.sql
new file mode 100644
index 0000000..e9728ec
--- /dev/null
+++ b/src/main/resources/migration/V1_8__alter_data.sql
@@ -0,0 +1,9 @@
+
+/* �뾽泥� 移댄뀒怨좊━ ��遺꾨쪟/以묐럽瑜� �빆紐� �닔�젙 */
+INSERT INTO `company_field_category` (`id`, `type_category`, `parent_id`, `use_value`, `description`, `register_id`, `modify_id`, `register_date`, `modify_date`) VALUES
+(121, 'PARENTSECTOR', null, '�슫�닔 諛� 李쎄퀬�뾽 遺꾨쪟', '', 1, 1, NOW(), NOW());
+
+UPDATE `company_field_category` SET parent_id=121 WHERE id=67;
+UPDATE `company_field_category` SET parent_id=121 WHERE id=68;
+UPDATE `company_field_category` SET parent_id=121 WHERE id=69;
+UPDATE `company_field_category` SET parent_id=121 WHERE id=70;
\ No newline at end of file

--
Gitblit v1.8.0