From 464e2317e377cd82f570170ab6adc15d005ff148 Mon Sep 17 00:00:00 2001 From: wyu <kknd09321@nate.com> Date: 월, 08 11월 2021 18:56:36 +0900 Subject: [PATCH] 업체 관리 백엔드 수정 --- src/main/resources/migration/V1_11__Alter_Table.sql | 10 ++++++---- 1 files changed, 6 insertions(+), 4 deletions(-) diff --git a/src/main/resources/migration/V1_11__Alter_Table.sql b/src/main/resources/migration/V1_11__Alter_Table.sql index 85df95e..b8631f1 100644 --- a/src/main/resources/migration/V1_11__Alter_Table.sql +++ b/src/main/resources/migration/V1_11__Alter_Table.sql @@ -1,9 +1,11 @@ -CREATE TABLE `company`( +CREATE TABLE `company_field`( `id` BIGINT(11) AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, - `tel` VARCHAR (50) NOT NULL, - `email` VARCHAR (255) NOT NULL, - `memo` VARCHAR(255) 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, -- Gitblit v1.8.0