From bea07d3ad5c832426680325f1112538feda04e50 Mon Sep 17 00:00:00 2001
From: wyu <kknd09321@nate.com>
Date: 화, 09 11월 2021 10:08:43 +0900
Subject: [PATCH] ISP, Hosting 백엔드 추가 및 부서 수정
---
src/main/resources/migration/V1_11__Alter_Table.sql | 31 ++++++++++++++++++++++++++++++-
1 files changed, 30 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/migration/V1_11__Alter_Table.sql b/src/main/resources/migration/V1_11__Alter_Table.sql
index b8631f1..b49db13 100644
--- a/src/main/resources/migration/V1_11__Alter_Table.sql
+++ b/src/main/resources/migration/V1_11__Alter_Table.sql
@@ -11,4 +11,33 @@
`modify_date` TIMESTAMP NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-/* �씠硫붿씪�� ID 媛믪쑝濡� 諛쏄퀬 �뿰�씫泥섎룄 user�뿉 phone�뿉�꽌 諛쏆쑝硫� �릺怨�*/
\ No newline at end of file
+
+CREATE TABLE `isp`(
+ `id` BIGINT(11) AUTO_INCREMENT,
+ `name` VARCHAR(50) NOT NULL,
+ `manager` VARCHAR(50) NULL,
+ `tel` VARCHAR (50) NULL,
+ `email` VARCHAR (255) NULL,
+ `memo` VARCHAR(255) NULL,
+ `register_id` BIGINT(20) NOT NULL,
+ `register_date` TIMESTAMP NULL,
+ `modify_id` BIGINT(20) NOT NULL,
+ `modify_date` TIMESTAMP NULL,
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+
+CREATE TABLE `hosting`(
+ `id` BIGINT(11) AUTO_INCREMENT,
+ `name` VARCHAR(50) NOT NULL,
+ `manager` VARCHAR(50) NULL,
+ `tel` VARCHAR (50) NULL,
+ `email` VARCHAR (255) NULL,
+ `memo` VARCHAR(255) NULL,
+ `register_id` BIGINT(20) NOT NULL,
+ `register_date` TIMESTAMP NULL,
+ `modify_id` BIGINT(20) NOT NULL,
+ `modify_date` TIMESTAMP NULL,
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
--
Gitblit v1.8.0