From da977fe546163a310ade61bb90ca5f3dd7d7ffe6 Mon Sep 17 00:00:00 2001
From: wyu <kknd09321@nate.com>
Date: 화, 09 11월 2021 12:46:05 +0900
Subject: [PATCH] ISP, Hoting 데이터베이스 수정
---
src/main/resources/migration/V1_11__Alter_Table.sql | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/src/main/resources/migration/V1_11__Alter_Table.sql b/src/main/resources/migration/V1_11__Alter_Table.sql
index b49db13..461b734 100644
--- a/src/main/resources/migration/V1_11__Alter_Table.sql
+++ b/src/main/resources/migration/V1_11__Alter_Table.sql
@@ -12,8 +12,9 @@
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-CREATE TABLE `isp`(
+CREATE TABLE `isp_field`(
`id` BIGINT(11) AUTO_INCREMENT,
+ `code` varchar (50) NOT NULL,
`name` VARCHAR(50) NOT NULL,
`manager` VARCHAR(50) NULL,
`tel` VARCHAR (50) NULL,
@@ -27,8 +28,9 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-CREATE TABLE `hosting`(
+CREATE TABLE `hosting_field`(
`id` BIGINT(11) AUTO_INCREMENT,
+ `code` varchar (50) NOT NULL,
`name` VARCHAR(50) NOT NULL,
`manager` VARCHAR(50) NULL,
`tel` VARCHAR (50) NULL,
--
Gitblit v1.8.0