From 75a8e41680a4dba3692812ab17aa5be4fb2488fe Mon Sep 17 00:00:00 2001 From: 이민희 <mhlee@maprex.co.kr> Date: 화, 11 1월 2022 10:23:22 +0900 Subject: [PATCH] 업체 카테고리 테이블 생성 쿼리 --- src/main/resources/migration/V1_3__insert_new_data.sql | 155 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 155 insertions(+), 0 deletions(-) diff --git a/src/main/resources/migration/V1_3__insert_new_data.sql b/src/main/resources/migration/V1_3__insert_new_data.sql new file mode 100644 index 0000000..7e83ca9 --- /dev/null +++ b/src/main/resources/migration/V1_3__insert_new_data.sql @@ -0,0 +1,155 @@ +-- -------------------------------------------------------- +-- �샇�뒪�듃: 127.0.0.1 +-- �꽌踰� 踰꾩쟾: 10.5.8-MariaDB - mariadb.org binary distribution +-- �꽌踰� OS: Win64 +-- HeidiSQL 踰꾩쟾: 11.0.0.5919 +-- -------------------------------------------------------- + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET NAMES utf8 */; +/*!50503 SET NAMES utf8mb4 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; + +-- �뀒�씠釉� dev_db.company_field_category 援ъ“ �궡蹂대궡湲� +CREATE TABLE IF NOT EXISTS `company_field_category` ( + `id` bigint(11) NOT NULL AUTO_INCREMENT, + `type_category` varchar(50) NOT NULL, + `parent_id` bigint(11) NULL, + `use_value` varchar(255) NOT NULL, + `description` varchar(255) NULL, + `register_id` bigint(20) NOT NULL, + `register_date` timestamp NULL DEFAULT NULL, + `modify_id` bigint(20) NOT NULL, + `modify_date` timestamp NULL DEFAULT NULL, + PRIMARY KEY (`id`) USING BTREE, + KEY `typeCategoryIndex` (`type_category`) USING BTREE + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; + +INSERT INTO `company_field_category` (`id`, `type_category`, `parent_id`, `use_value`, `description`, `register_id`, `modify_id`, `register_date`, `modify_date`) VALUES +(1, 'COMPANYTYPE', null, '��湲곗뾽', '', 1, 1, NOW(), NOW()), +(2, 'COMPANYTYPE', null, '以묎껄湲곗뾽', '', 1, 1, NOW(), NOW()), +(3, 'COMPANYTYPE', null, '以묒냼湲곗뾽', '', 1, 1, NOW(), NOW()), +(4, 'COMPANYTYPE', null, '鍮꾩쁺由�', '', 1, 1, NOW(), NOW()), +(5, 'PARENTSECTOR', null, '�냽�뾽, �엫�뾽 諛� �뼱�뾽', '', 1, 1, NOW(), NOW()), +(6, 'PARENTSECTOR', null, '愿묒뾽', '', 1, 1, NOW(), NOW()), +(7, 'PARENTSECTOR', null, '�젣議곗뾽', '', 1, 1, NOW(), NOW()), +(8, 'PARENTSECTOR', null, '�쟾湲�, 媛��뒪, 利앷린 諛� 怨듦린 議곗젅 怨듦툒�뾽', '', 1, 1, NOW(), NOW()), +(9, 'PARENTSECTOR', null, '�닔�룄, �븯�닔 諛� �룓湲곕Ъ 泥섎━, �썝猷� �옱�깮�뾽', '', 1, 1, NOW(), NOW()), +(10, 'PARENTSECTOR', null, '嫄댁꽕�뾽', '', 1, 1, NOW(), NOW()), +(11, 'PARENTSECTOR', null, '�룄留� 諛� �냼留ㅼ뾽', '', 1, 1, NOW(), NOW()), +(12, 'PARENTSECTOR', null, '�닕諛� 諛� �쓬�떇�젏�뾽', '', 1, 1, NOW(), NOW()), +(13, 'PARENTSECTOR', null, '�젙蹂댄넻�떊�뾽', '', 1, 1, NOW(), NOW()), +(14, 'PARENTSECTOR', null, '湲덉쑖 諛� 蹂댄뿕�뾽', '', 1, 1, NOW(), NOW()), +(15, 'PARENTSECTOR', null, '遺��룞�궛�뾽', '', 1, 1, NOW(), NOW()), +(16, 'PARENTSECTOR', null, '�쟾臾�, 怨쇳븰 諛� 湲곗닠 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(17, 'PARENTSECTOR', null, '�궗�뾽�떆�꽕 愿�由�, �궗�뾽 吏��썝 諛� �엫�� �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(18, 'PARENTSECTOR', null, '怨듦났 �뻾�젙, 援�諛� 諛� �궗�쉶蹂댁옣 �뻾�젙', '', 1, 1, NOW(), NOW()), +(19, 'PARENTSECTOR', null, '援먯쑁 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(20, 'PARENTSECTOR', null, '蹂닿굔�뾽 諛� �궗�쉶蹂듭� �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(21, 'PARENTSECTOR', null, '�삁�닠, �뒪�룷痢� 諛� �뿬媛�愿��젴 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(22, 'PARENTSECTOR', null, '�삊�쉶 諛� �떒泥�, �닔由� 諛� 湲고� 媛쒖씤 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(23, 'PARENTSECTOR', null, '媛�援� �궡 怨좎슜�솢�룞 諛� �떖由� 遺꾨쪟�릺吏� �븡�� �옄媛� �냼鍮� �깮�궛�솢�룞', '', 1, 1, NOW(), NOW()), +(24, 'PARENTSECTOR', null, '援��젣 諛� �쇅援�湲곌�', '', 1, 1, NOW(), NOW()), +(25, 'CHILDSECTOR', 5, '�냽�뾽', '', 1, 1, NOW(), NOW()), +(26, 'CHILDSECTOR', 5, '�엫�뾽', '', 1, 1, NOW(), NOW()), +(27, 'CHILDSECTOR', 5, '�뼱�뾽', '', 1, 1, NOW(), NOW()), +(28, 'CHILDSECTOR', 6, '�꽍�깂, �썝�쑀 諛� 泥쒖뿰媛��뒪 愿묒뾽', '', 1, 1, NOW(), NOW()), +(29, 'CHILDSECTOR', 6, '湲덉냽 愿묒뾽', '', 1, 1, NOW(), NOW()), +(30, 'CHILDSECTOR', 6, '鍮꾧툑�냽愿묐Ъ 愿묒뾽; �뿰猷뚯슜 �젣�쇅', '', 1, 1, NOW(), NOW()), +(31, 'CHILDSECTOR', 6, '愿묒뾽 吏��썝 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(32, 'CHILDSECTOR', 7, '�떇猷뚰뭹 �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(33, 'CHILDSECTOR', 7, '�쓬猷� �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(34, 'CHILDSECTOR', 7, '�떞諛� �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(35, 'CHILDSECTOR', 7, '�꽟�쑀�젣�뭹 �젣議곗뾽; �쓽蹂� �젣�쇅', '', 1, 1, NOW(), NOW()), +(36, 'CHILDSECTOR', 7, '�쓽蹂�, �쓽蹂� �븸�꽭�꽌由� 諛� 紐⑦뵾�젣�뭹 �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(37, 'CHILDSECTOR', 7, '媛�二�, 媛�諛� 諛� �떊諛� �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(38, 'CHILDSECTOR', 7, '紐⑹옱 諛� �굹臾댁젣�뭹 �젣議곗뾽; 媛�援� �젣�쇅', '', 1, 1, NOW(), NOW()), +(39, 'CHILDSECTOR', 7, '�럡�봽, 醫낆씠 諛� 醫낆씠�젣�뭹 �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(40, 'CHILDSECTOR', 7, '�씤�뇙 諛� 湲곕줉留ㅼ껜 蹂듭젣�뾽', '', 1, 1, NOW(), NOW()), +(41, 'CHILDSECTOR', 7, '肄뷀겕�뒪, �뿰�깂 諛� �꽍�쑀�젙�젣�뭹 �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(42, 'CHILDSECTOR', 7, '�솕�븰 臾쇱쭏 諛� �솕�븰�젣�뭹 �젣議곗뾽; �쓽�빟�뭹 �젣�쇅', '', 1, 1, NOW(), NOW()), +(43, 'CHILDSECTOR', 7, '�쓽猷뚯슜 臾쇱쭏 諛� �쓽�빟�뭹 �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(44, 'CHILDSECTOR', 7, '怨좊Т 諛� �뵆�씪�뒪�떛�젣�뭹 �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(45, 'CHILDSECTOR', 7, '鍮꾧툑�냽 愿묐Ъ�젣�뭹 �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(46, 'CHILDSECTOR', 7, '1李� 湲덉냽 �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(47, 'CHILDSECTOR', 7, '湲덉냽 媛�怨듭젣�뭹 �젣議곗뾽; 湲곌퀎 諛� 媛�援� �젣�쇅', '', 1, 1, NOW(), NOW()), +(48, 'CHILDSECTOR', 7, '�쟾�옄 遺��뭹, 而댄벂�꽣, �쁺�긽, �쓬�뼢 諛� �넻�떊�옣鍮� �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(49, 'CHILDSECTOR', 7, '�쓽猷�, �젙諛�, 愿묓븰 湲곌린 諛� �떆怨� �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(50, 'CHILDSECTOR', 7, '�쟾湲곗옣鍮� �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(51, 'CHILDSECTOR', 7, '湲고� 湲곌퀎 諛� �옣鍮� �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(52, 'CHILDSECTOR', 7, '�옄�룞李� 諛� �듃�젅�씪�윭 �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(53, 'CHILDSECTOR', 7, '湲고� �슫�넚�옣鍮� �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(54, 'CHILDSECTOR', 7, '媛�援� �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(55, 'CHILDSECTOR', 7, '湲고� �젣�뭹 �젣議곗뾽', '', 1, 1, NOW(), NOW()), +(56, 'CHILDSECTOR', 7, '�궛�뾽�슜 湲곌퀎 諛� �옣鍮� �닔由ъ뾽', '', 1, 1, NOW(), NOW()), +(57, 'CHILDSECTOR', 8, '�쟾湲�, 媛��뒪, 利앷린 諛� 怨듦린 議곗젅 怨듦툒�뾽', '', 1, 1, NOW(), NOW()), +(58, 'CHILDSECTOR', 9, '�닔�룄�뾽', '', 1, 1, NOW(), NOW()), +(59, 'CHILDSECTOR', 9, '�븯�닔, �룓�닔 諛� 遺꾨눊 泥섎━�뾽', '', 1, 1, NOW(), NOW()), +(60, 'CHILDSECTOR', 9, '�룓湲곕Ъ �닔吏�, �슫諛�, 泥섎━ 諛� �썝猷� �옱�깮�뾽', '', 1, 1, NOW(), NOW()), +(61, 'CHILDSECTOR', 9, '�솚寃� �젙�솕 諛� 蹂듭썝�뾽', '', 1, 1, NOW(), NOW()), +(62, 'CHILDSECTOR', 10, '醫낇빀 嫄댁꽕�뾽', '', 1, 1, NOW(), NOW()), +(63, 'CHILDSECTOR', 10, '�쟾臾몄쭅蹂� 怨듭궗�뾽', '', 1, 1, NOW(), NOW()), +(64, 'CHILDSECTOR', 11, '�옄�룞李� 諛� 遺��뭹 �뙋留ㅼ뾽', '', 1, 1, NOW(), NOW()), +(65, 'CHILDSECTOR', 11, '�룄留� 諛� �긽�뭹 以묎컻�뾽', '', 1, 1, NOW(), NOW()), +(66, 'CHILDSECTOR', 11, '�냼留ㅼ뾽; �옄�룞李� �젣�쇅', '', 1, 1, NOW(), NOW()), +(67, 'CHILDSECTOR', 11, '�쑁�긽 �슫�넚 諛� �뙆�씠�봽�씪�씤 �슫�넚�뾽', '', 1, 1, NOW(), NOW()), +(68, 'CHILDSECTOR', 11, '�닔�긽 �슫�넚�뾽', '', 1, 1, NOW(), NOW()), +(69, 'CHILDSECTOR', 11, '�빆怨� �슫�넚�뾽', '', 1, 1, NOW(), NOW()), +(70, 'CHILDSECTOR', 11, '李쎄퀬 諛� �슫�넚愿��젴 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(71, 'CHILDSECTOR', 12, '�닕諛뺤뾽', '', 1, 1, NOW(), NOW()), +(72, 'CHILDSECTOR', 12, '�쓬�떇�젏 諛� 二쇱젏�뾽', '', 1, 1, NOW(), NOW()), +(73, 'CHILDSECTOR', 13, '異쒗뙋�뾽', '', 1, 1, NOW(), NOW()), +(74, 'CHILDSECTOR', 13, '�쁺�긽�냽�삤�뵒�삤 湲곕줉臾� �젣�옉 諛� 諛곌툒�뾽', '', 1, 1, NOW(), NOW()), +(75, 'CHILDSECTOR', 13, '諛⑹넚�뾽', '', 1, 1, NOW(), NOW()), +(76, 'CHILDSECTOR', 13, '而댄벂�꽣 �봽濡쒓렇�옒諛�, �떆�뒪�뀥 �넻�빀 諛� 愿�由ъ뾽', '', 1, 1, NOW(), NOW()), +(77, 'CHILDSECTOR', 13, '�젙蹂댁꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(78, 'CHILDSECTOR', 14, '湲덉쑖�뾽', '', 1, 1, NOW(), NOW()), +(79, 'CHILDSECTOR', 14, '蹂댄뿕 諛� �뿰湲덉뾽', '', 1, 1, NOW(), NOW()), +(80, 'CHILDSECTOR', 14, '湲덉쑖 諛� 蹂댄뿕愿��젴 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(81, 'CHILDSECTOR', 15, '遺��룞�궛�뾽', '', 1, 1, NOW(), NOW()), +(82, 'CHILDSECTOR', 16, '�뿰援ш컻諛쒖뾽', '', 1, 1, NOW(), NOW()), +(83, 'CHILDSECTOR', 16, '�쟾臾� �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(84, 'CHILDSECTOR', 16, '嫄댁텞 湲곗닠, �뿏吏��땲�뼱留� 諛� 湲고� 怨쇳븰湲곗닠 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(85, 'CHILDSECTOR', 16, '湲고� �쟾臾�, 怨쇳븰 諛� 湲곗닠 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(86, 'CHILDSECTOR', 17, '�궗�뾽�떆�꽕 愿�由� 諛� 議곌꼍 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(87, 'CHILDSECTOR', 17, '�궗�뾽 吏��썝 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(88, 'CHILDSECTOR', 17, '�엫���뾽; 遺��룞�궛 �젣�쇅', '', 1, 1, NOW(), NOW()), +(89, 'CHILDSECTOR', 18, '怨듦났 �뻾�젙, 援�諛� 諛� �궗�쉶蹂댁옣 �뻾�젙', '', 1, 1, NOW(), NOW()), +(90, 'CHILDSECTOR', 19, '援먯쑁 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(91, 'CHILDSECTOR', 20, '蹂닿굔�뾽', '', 1, 1, NOW(), NOW()), +(92, 'CHILDSECTOR', 20, '�궗�쉶蹂듭� �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(93, 'CHILDSECTOR', 21, '李쎌옉, �삁�닠 諛� �뿬媛�愿��젴 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(94, 'CHILDSECTOR', 21, '�뒪�룷痢� 諛� �삤�씫愿��젴 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(95, 'CHILDSECTOR', 22, '�삊�쉶 諛� �떒泥�', '', 1, 1, NOW(), NOW()), +(96, 'CHILDSECTOR', 22, '媛쒖씤 諛� �냼鍮꾩슜�뭹 �닔由ъ뾽', '', 1, 1, NOW(), NOW()), +(97, 'CHILDSECTOR', 22, '湲고� 媛쒖씤 �꽌鍮꾩뒪�뾽', '', 1, 1, NOW(), NOW()), +(98, 'CHILDSECTOR', 23, '媛�援� �궡 怨좎슜�솢�룞', '', 1, 1, NOW(), NOW()), +(99, 'CHILDSECTOR', 23, '�떖由� 遺꾨쪟�릺吏� �븡�� �옄媛� �냼鍮꾨�� �쐞�븳 媛�援ъ쓽 �옱�솕 諛� �꽌鍮꾩뒪 �깮�궛�솢�룞', '', 1, 1, NOW(), NOW()), +(100, 'CHILDSECTOR', 24, '援��젣 諛� �쇅援�湲곌�', '', 1, 1, NOW(), NOW()), +(101, 'REGION', null, '�꽌�슱', '', 1, 1, NOW(), NOW()), +(102, 'REGION', null, '寃쎄린', '', 1, 1, NOW(), NOW()), +(103, 'REGION', null, '�씤泥�', '', 1, 1, NOW(), NOW()), +(104, 'REGION', null, '媛뺤썝', '', 1, 1, NOW(), NOW()), +(105, 'REGION', null, '異⑸궓', '', 1, 1, NOW(), NOW()), +(106, 'REGION', null, '���쟾', '', 1, 1, NOW(), NOW()), +(107, 'REGION', null, '�꽭醫�', '', 1, 1, NOW(), NOW()), +(108, 'REGION', null, '異⑸턿', '', 1, 1, NOW(), NOW()), +(109, 'REGION', null, '遺��궛', '', 1, 1, NOW(), NOW()), +(110, 'REGION', null, '�슱�궛', '', 1, 1, NOW(), NOW()), +(111, 'REGION', null, '��援�', '', 1, 1, NOW(), NOW()), +(112, 'REGION', null, '寃쎈턿', '', 1, 1, NOW(), NOW()), +(113, 'REGION', null, '寃쎈궓', '', 1, 1, NOW(), NOW()), +(114, 'REGION', null, '�쟾�궓', '', 1, 1, NOW(), NOW()), +(115, 'REGION', null, '愿묒＜', '', 1, 1, NOW(), NOW()), +(116, 'REGION', null, '�쟾遺�', '', 1, 1, NOW(), NOW()), +(117, 'REGION', null, '�젣二�', '', 1, 1, NOW(), NOW()), +(118, 'STATUS', null, '�뿰�씫泥섏뾾�쓬', '', 1, 1, NOW(), NOW()), +(119, 'STATUS', null, '�셿�쟾鍮꾪삊議�', '', 1, 1, NOW(), NOW()), +(120, 'STATUS', null, '吏곸젒�엯�젰', '', 1, 1, NOW(), NOW()); + +ALTER TABLE `company_field` ADD COLUMN `company_type_id` bigint(11) NULL; +ALTER TABLE `company_field` ADD COLUMN `parent_sector_id` bigint(11) NULL; +ALTER TABLE `company_field` ADD COLUMN `child_sector_id` bigint(11) NULL; +ALTER TABLE `company_field` ADD COLUMN `region_id` bigint(11) NULL; +ALTER TABLE `company_field` ADD COLUMN `status_id` bigint(11) NULL; \ No newline at end of file -- Gitblit v1.8.0