From b2b9e785e10c8fd59c3fcee8c8fda2aeb86be8c3 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 월, 27 12월 2021 13:34:22 +0900
Subject: [PATCH] Merge branch 'master' of http://192.168.0.25:9001/r/owl-kisa
---
src/main/resources/migration/V1_1__Initial_Setup.sql | 849 +++++++++++++++++++++++++++++++++++++-------------------
1 files changed, 562 insertions(+), 287 deletions(-)
diff --git a/src/main/resources/migration/V1_1__Initial_Setup.sql b/src/main/resources/migration/V1_1__Initial_Setup.sql
index 6474c42..a21fd2a 100644
--- a/src/main/resources/migration/V1_1__Initial_Setup.sql
+++ b/src/main/resources/migration/V1_1__Initial_Setup.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
--- �샇�뒪�듃: 192.168.0.64
--- �꽌踰� 踰꾩쟾: 10.1.13-MariaDB - Source distribution
--- �꽌踰� OS: Linux
--- HeidiSQL 踰꾩쟾: 10.1.0.5464
+-- �샇�뒪�듃: 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 */;
@@ -11,8 +11,21 @@
/*!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.api_token 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `api_token` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(50) NOT NULL,
+ `app_name` varchar(50) NOT NULL,
+ `token` varchar(1024) NOT 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 `userIdIndex` (`user_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.attached_file 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.attached_file 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `attached_file` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`issue_id` bigint(20) DEFAULT NULL,
@@ -27,16 +40,34 @@
`modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
`modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
`aws_key` varchar(255) DEFAULT NULL,
+ `attached_type` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `issueIdIndex` (`issue_id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.attached_file:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `attached_file` DISABLE KEYS */;
-/*!40000 ALTER TABLE `attached_file` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.company_field 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `company_field` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(50) NOT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT 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,
+ `url` varchar(255) DEFAULT NULL,
+ `isp_id` bigint(20) DEFAULT NULL,
+ `hosting_id` bigint(20) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `urlIndex` (`url`),
+ KEY `ispIdIndex` (`isp_id`),
+ KEY `hostingIdIndex` (`hosting_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.custom_field 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.custom_field 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `custom_field` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
@@ -45,34 +76,160 @@
`default_value` varchar(100) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ `use_flag` varchar(1) NOT NULL DEFAULT 'Y',
+ `required_data` varchar(1) NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.custom_field:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `custom_field` DISABLE KEYS */;
-/*!40000 ALTER TABLE `custom_field` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.custom_field_api_default 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `custom_field_api_default` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(11) NOT NULL,
+ `issue_type_id` bigint(11) NOT NULL,
+ `custom_field_id` bigint(11) NOT NULL,
+ `custom_field_value` varchar(300) NOT 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 `userIdIndex` (`user_id`) USING BTREE,
+ KEY `issueTypeIdIndex` (`issue_type_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.custom_field_value 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.custom_field_api_overlap 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `custom_field_api_overlap` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(11) NOT NULL,
+ `issue_type_id` bigint(11) NOT NULL,
+ `custom_field_id` bigint(11) NOT 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,
+ `project_id` bigint(20) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `userIdIndex` (`user_id`) USING BTREE,
+ KEY `issueTypeIdIndex` (`issue_type_id`) USING BTREE,
+ KEY `projectIdIndex` (`project_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.custom_field_value 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `custom_field_value` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`custom_field_id` bigint(20) NOT NULL,
`value` varchar(100) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `customFieldIdIndex` (`custom_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.custom_field_value:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `custom_field_value` DISABLE KEYS */;
-/*!40000 ALTER TABLE `custom_field_value` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.department 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `department` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `department_name` varchar(50) NOT NULL,
+ `department_description` varchar(255) DEFAULT 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
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.email_template 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `email_template` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `title` varchar(255) NOT NULL,
+ `template` mediumtext NOT 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
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.event 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `event` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `start_date` varchar(10) DEFAULT NULL COMMENT 'start_date',
+ `end_date` varchar(10) DEFAULT NULL COMMENT 'end_date',
+ `status` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.faq 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `faq` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `status` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.guide 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `guide` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `status` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.hosting_field 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `hosting_field` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `code` varchar(50) NOT NULL,
+ `name` varchar(50) NOT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT 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,
+ `url` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.isp_field 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `isp_field` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `code` varchar(50) NOT NULL,
+ `name` varchar(50) NOT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT 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,
+ `url` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.issue 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`issue_status_id` bigint(20) DEFAULT NULL,
@@ -81,7 +238,7 @@
`priority_id` bigint(20) DEFAULT NULL,
`severity_id` bigint(20) DEFAULT NULL,
`title` varchar(300) DEFAULT NULL,
- `description` mediumtext COMMENT 'description',
+ `description` mediumtext DEFAULT NULL COMMENT 'description',
`reverse_index` bigint(20) DEFAULT NULL,
`issue_number` bigint(20) DEFAULT NULL,
`start_date` varchar(20) DEFAULT NULL,
@@ -90,17 +247,40 @@
`register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
`modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
`modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ `workflow_status_id` bigint(20) DEFAULT NULL,
+ `parent_issue_id` bigint(11) DEFAULT NULL,
+ `is_api` varchar(1) NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`),
KEY `projectIdIndex` (`project_id`),
KEY `reverseIndex` (`reverse_index`),
KEY `issueTypeIdIndex` (`issue_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_api_default 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_api_default` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(11) NOT NULL,
+ `issue_type_id` bigint(11) NOT NULL,
+ `issue_status_id` bigint(20) DEFAULT NULL,
+ `project_id` bigint(20) DEFAULT NULL,
+ `priority_id` bigint(20) DEFAULT NULL,
+ `severity_id` bigint(20) DEFAULT NULL,
+ `title` varchar(300) DEFAULT NULL,
+ `description` mediumtext DEFAULT NULL COMMENT 'description',
+ `reverse_index` bigint(20) DEFAULT NULL,
+ `issue_number` bigint(20) DEFAULT NULL,
+ `start_date` varchar(20) DEFAULT NULL,
+ `complete_date` varchar(20) DEFAULT 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 `userIdIndex` (`user_id`) USING BTREE,
+ KEY `issueTypeIdIndex` (`issue_type_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_comment 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_comment 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_comment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`issue_id` bigint(20) NOT NULL COMMENT 'issue_id',
@@ -115,11 +295,26 @@
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='issue_comment';
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_comment:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_comment` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_comment` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_company 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_company` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
+ `issue_id` bigint(20) NOT NULL,
+ `company_id` bigint(20) DEFAULT NULL,
+ `name` varchar(50) DEFAULT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ `url` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `companyIdIndex` (`company_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_custom_field_value 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_custom_field_value 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_custom_field_value` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`issue_id` bigint(20) NOT NULL,
@@ -128,25 +323,38 @@
`use_value` mediumtext NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `customFieldIdIndex` (`custom_field_id`),
KEY `issueTypeCustomFieldIdIndex` (`issue_type_custom_field_id`),
KEY `issueIdIndex` (`issue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_custom_field_value:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_custom_field_value` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_custom_field_value` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_department 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_department` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `department_id` bigint(20) NOT NULL,
+ `issue_id` bigint(20) NOT NULL,
+ `workspace_id` bigint(20) NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`id`),
+ KEY `departmentIdAndIssueIdIndex` (`department_id`,`issue_id`),
+ KEY `issueIdIndex` (`issue_id`),
+ KEY `workspaceIdIndex` (`workspace_id`),
+ KEY `departmentIdIndex` (`department_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_history 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_history 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`issue_id` bigint(20) DEFAULT NULL,
`project_id` bigint(20) DEFAULT NULL,
`issue_history_type` varchar(10) NOT NULL,
- `description` mediumtext,
+ `description` mediumtext DEFAULT NULL,
`register_id` bigint(20) DEFAULT NULL,
`register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) DEFAULT NULL,
@@ -156,67 +364,123 @@
KEY `projectIdIndex` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_history:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_history` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_history` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_hosting 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_hosting` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
+ `issue_id` bigint(20) NOT NULL,
+ `hosting_id` bigint(20) DEFAULT NULL,
+ `name` varchar(50) DEFAULT NULL,
+ `code` varchar(50) DEFAULT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ `url` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `hostingIdIndex` (`hosting_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_number_generator 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_isp 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_isp` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
+ `issue_id` bigint(20) NOT NULL,
+ `isp_id` bigint(20) DEFAULT NULL,
+ `name` varchar(50) DEFAULT NULL,
+ `code` varchar(50) DEFAULT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ `url` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `ispIdIndex` (`isp_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.issue_number_generator 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_number_generator` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) NOT NULL,
`number` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `projectIdIndex` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_number_generator:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_number_generator` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_number_generator` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_relation 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_relation` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `issue_id` bigint(20) NOT NULL,
+ `relation_issue_id` bigint(20) NOT NULL DEFAULT -1,
+ `relation_issue_type` int(20) NOT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `issueId` (`issue_id`) USING BTREE,
+ KEY `relationIssueId` (`relation_issue_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_risk 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_reservation 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_reservation` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `issue_id` bigint(20) DEFAULT NULL,
+ `workspace_id` bigint(20) DEFAULT NULL,
+ `reservation` varchar(10) DEFAULT NULL,
+ `issue_reservation_type` varchar(10) DEFAULT 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`),
+ KEY `workspaceIdIndex` (`workspace_id`),
+ KEY `issueIdIndex` (`issue_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.issue_risk 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_risk` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`issue_id` bigint(20) NOT NULL,
`workspace_id` bigint(20) NOT NULL,
- `change_assignee_count` bigint(20) NOT NULL DEFAULT '0',
- `change_issue_status_count` bigint(20) NOT NULL DEFAULT '0',
+ `change_assignee_count` bigint(20) NOT NULL DEFAULT 0,
+ `change_issue_status_count` bigint(20) NOT NULL DEFAULT 0,
`issue_status_ids` text NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ `change_department_count` bigint(20) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `issueIdIndex` (`issue_id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_risk:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_risk` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_risk` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_search 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_search 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_search` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
- `conditions` mediumtext,
+ `conditions` mediumtext DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `workspaceIdAndUserIdIndex` (`workspace_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_search:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_search` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_search` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_status 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_status 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) DEFAULT NULL,
@@ -233,30 +497,25 @@
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_status:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_status` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_status` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_table_config 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_table_config 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_table_config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`issue_table_configs` mediumtext CHARACTER SET utf8 NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
+ `issue_type_id` bigint(20) NOT NULL,
+ `issue_table_type` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `workspaceIdAndUserIdIndex` (`workspace_id`,`user_id`),
- KEY `workspaceIdIndex` (`workspace_id`)
+ KEY `workspaceIdIndex` (`workspace_id`),
+ KEY `issueTableTypeIndex` (`issue_table_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_table_config:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_table_config` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_table_config` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_type 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_type 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_type` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
@@ -264,31 +523,47 @@
`name` varchar(15) NOT NULL,
`description` mediumtext NOT NULL,
`color` varchar(255) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
+ `project_id` bigint(11) DEFAULT NULL,
+ `use_partner` bigint(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `workspaceIdIndex` (`workspace_id`),
KEY `workflowIdIndex` (`workflow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_type:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_type` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_type` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_type_api_end_status 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_type_api_end_status` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(20) DEFAULT NULL,
+ `project_id` bigint(20) DEFAULT NULL,
+ `issue_type_id` bigint(20) DEFAULT NULL,
+ `issue_status_id` bigint(20) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ PRIMARY KEY (`id`),
+ KEY `userIdIndex` (`user_id`),
+ KEY `projectIdIndex` (`project_id`),
+ KEY `issueTypeIdIndex` (`issue_type_id`),
+ KEY `issueStatusIdIndex` (`issue_status_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_type_custom_field 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_type_custom_field 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_type_custom_field` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) NOT NULL,
`issue_type_id` bigint(20) NOT NULL,
`custom_field_id` bigint(20) NOT NULL,
`field_option` varchar(10) NOT NULL,
- `position` bigint(20) NOT NULL DEFAULT '0',
+ `position` bigint(20) NOT NULL DEFAULT 0,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `projectIdIndex` (`project_id`),
KEY `issueTypeIdIndex` (`issue_type_id`),
@@ -296,20 +571,16 @@
KEY `projectIdAndIssueTypeIdIndex` (`project_id`,`issue_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_type_custom_field:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_type_custom_field` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_type_custom_field` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_user 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_user 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
- `user_id` bigint(20) NULL,
+ `user_id` bigint(20) DEFAULT NULL,
`issue_id` bigint(20) NOT NULL,
`workspace_id` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `userIdAndIssueIdIndex` (`user_id`,`issue_id`),
KEY `issueIdIndex` (`issue_id`),
@@ -317,35 +588,14 @@
KEY `userIdIndex` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_department 援ъ“ �궡蹂대궡湲�
-CREATE TABLE IF NOT EXISTS `issue_department` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `department_id` bigint(20) NOT NULL,
- `issue_id` bigint(20) NOT NULL,
- `workspace_id` bigint(20) NOT NULL,
- `register_id` bigint(20) NOT NULL,
- `modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`),
- KEY `departmentIdAndIssueIdIndex` (`department_id`,`issue_id`),
- KEY `issueIdIndex` (`issue_id`),
- KEY `workspaceIdIndex` (`workspace_id`),
- KEY `departmentIdIndex` (`department_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_user:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_user` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_user` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_version_control 援ъ“ �궡蹂대궡湲�
-CREATE TABLE IF NOT EXISTS `issue_version_control` (
+-- �뀒�씠釉� dev_db.issue_version 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_version` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) DEFAULT NULL,
`project_id` bigint(20) DEFAULT NULL,
`issue_id` bigint(20) DEFAULT NULL,
`version` bigint(20) DEFAULT NULL,
- `content` mediumtext,
+ `content` mediumtext DEFAULT NULL,
`register_id` bigint(20) DEFAULT NULL,
`register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) DEFAULT NULL,
@@ -356,25 +606,19 @@
KEY `projectIdIndex` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_version_control:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_version_control` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_version_control` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.login_history 援ъ“ �궡蹂대궡湲�
-CREATE TABLE IF NOT EXISTS `login_history` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `user_id` bigint(20) NOT NULL COMMENT 'user_id',
- `login_date` timestamp NULL DEFAULT NULL COMMENT 'login_date',
- `logout_date` timestamp NULL DEFAULT NULL COMMENT 'logout_date',
- `login_ip` varchar(20) NOT NULL COMMENT 'login_ip',
+-- �뀒�씠釉� dev_db.notice 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `notice` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='login_history';
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.login_history:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `login_history` DISABLE KEYS */;
-/*!40000 ALTER TABLE `login_history` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.payment 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.payment 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `payment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) DEFAULT NULL,
@@ -389,11 +633,7 @@
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.payment:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `payment` DISABLE KEYS */;
-/*!40000 ALTER TABLE `payment` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.payment_history 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.payment_history 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `payment_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
@@ -404,19 +644,15 @@
`merchant_uid` varchar(255) NOT NULL,
`payment_result` varchar(10) NOT NULL,
`payment_response` mediumtext NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.payment_history:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `payment_history` DISABLE KEYS */;
-/*!40000 ALTER TABLE `payment_history` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.permission 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.permission 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `permission` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
@@ -427,7 +663,7 @@
`modify_id` bigint(20) NOT NULL,
`modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.permission:~12 rows (���왂�쟻) �궡蹂대궡湲�
/*!40000 ALTER TABLE `permission` DISABLE KEYS */;
@@ -443,7 +679,8 @@
(9, '�씠�뒋 �긽�깭 �넻�빀 沅뚰븳', 'ISSUE_STATUS_TOTAL', '01', 1, '2018-05-03 15:06:31', 1, '2018-05-03 15:06:32'),
(10, '�썙�겕�뵆濡쒖슦 �넻�빀 沅뚰븳', 'WORKFLOW_TOTAL', '01', 1, '2018-05-03 15:07:09', 1, '2018-05-03 15:07:10'),
(11, '�씠�뒋 �쑀�삎 �넻�빀 沅뚰븳', 'ISSUE_TYPE_TOTAL', '01', 1, '2018-05-03 15:07:35', 1, '2018-05-03 15:07:36'),
-(12, '�궗�슜�옄 �젙�쓽 �븘�뱶 �넻�빀 沅뚰븳', 'CUSTOM_FIELD_TOTAL', '01', 1, '2018-05-03 15:07:55', 1, '2018-05-03 15:07:56');
+(12, '�궗�슜�옄 �젙�쓽 �븘�뱶 �넻�빀 沅뚰븳', 'CUSTOM_FIELD_TOTAL', '01', 1, '2018-05-03 15:07:55', 1, '2018-05-03 15:07:56'),
+(13, '怨듭��궗�빆 議고쉶 沅뚰븳', 'NOTICE_READ', '01', 1, '2018-05-03 15:07:55', 1, '2018-05-03 15:07:56');
/*!40000 ALTER TABLE `permission` ENABLE KEYS */;
-- �뀒�씠釉� owl_en_1.5.priority 援ъ“ �궡蹂대궡湲�
@@ -460,18 +697,14 @@
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.priority:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `priority` DISABLE KEYS */;
-/*!40000 ALTER TABLE `priority` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.project 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.project 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `project` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `workspace_id` bigint(20) NOT NULL DEFAULT '0',
+ `workspace_id` bigint(20) NOT NULL DEFAULT 0,
`name` varchar(50) NOT NULL COMMENT 'name',
`project_key` varchar(10) NOT NULL,
`project_type` varchar(50) NOT NULL,
- `description` mediumtext COMMENT 'description',
+ `description` mediumtext DEFAULT NULL COMMENT 'description',
`status` varchar(2) NOT NULL DEFAULT '01' COMMENT '01:�솢�꽦, 02:鍮꾪솢�꽦',
`start_date` varchar(10) DEFAULT NULL COMMENT 'start_date',
`end_date` varchar(10) DEFAULT NULL COMMENT 'end_date',
@@ -484,95 +717,103 @@
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='project';
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.project:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `project` DISABLE KEYS */;
-/*!40000 ALTER TABLE `project` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.project_closure 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `project_closure` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `project_id` bigint(20) NOT NULL,
+ `parent_project_id` bigint(20) NOT NULL DEFAULT -1,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `projectIdIndex` (`project_id`) USING BTREE,
+ KEY `parentProjectIdIndex` (`parent_project_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.project_role 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.project_role 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `project_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) NOT NULL,
`name` varchar(50) NOT NULL,
`role_type` varchar(2) NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `projectIdIndex` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.project_role:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `project_role` DISABLE KEYS */;
-/*!40000 ALTER TABLE `project_role` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.project_role_department 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `project_role_department` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `project_role_id` bigint(20) NOT NULL,
+ `department_id` bigint(20) NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`id`),
+ KEY `projectRoleIdAndDepartmentIdIndex` (`project_role_id`,`department_id`),
+ KEY `departmentIdIndex` (`department_id`),
+ KEY `projectRoleIdIndex` (`project_role_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.project_role_permission 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.project_role_permission 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `project_role_permission` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_role_id` bigint(20) NOT NULL,
`permission_id` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `projectRoleIdIndex` (`project_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.project_role_permission:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `project_role_permission` DISABLE KEYS */;
-/*!40000 ALTER TABLE `project_role_permission` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.project_role_user 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.project_role_user 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `project_role_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_role_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `projectRoleIdAndUserIdIndex` (`project_role_id`,`user_id`),
KEY `userIdIndex` (`user_id`),
KEY `projectRoleIdIndex` (`project_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.project_role_department 援ъ“ �궡蹂대궡湲�
-CREATE TABLE IF NOT EXISTS `project_role_department` (
+-- �뀒�씠釉� dev_db.qna 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `qna` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
- `project_role_id` bigint(20) NOT NULL,
- `department_id` bigint(20) NOT NULL,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`),
- KEY `projectRoleIdAndDepartmentIdIndex` (`project_role_id`,`department_id`),
- KEY `departmentIdIndex` (`department_id`),
- KEY `projectRoleIdIndex` (`project_role_id`)
+ PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.project_role_department 援ъ“ �궡蹂대궡湲�
-CREATE TABLE IF NOT EXISTS `project_role_department` (
+-- �뀒�씠釉� dev_db.qna_answer 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `qna_answer` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
- `project_role_id` bigint(20) NOT NULL,
- `department_id` bigint(20) NULL,
+ `ask_id` bigint(20) NOT NULL,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`),
- KEY `projectRoleIdAndDepartmentIdIndex` (`project_role_id`,`department_id`),
- KEY `departmentIdIndex` (`department_id`),
- KEY `projectRoleIdIndex` (`project_role_id`)
+ PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.project_role_user:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `project_role_user` DISABLE KEYS */;
-/*!40000 ALTER TABLE `project_role_user` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.reservation_disable_user 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.reservation_disable_user 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `reservation_disable_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`payment_id` bigint(20) DEFAULT NULL,
@@ -585,29 +826,37 @@
KEY `paymentIdIndex` (`payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.reservation_disable_user:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `reservation_disable_user` DISABLE KEYS */;
-/*!40000 ALTER TABLE `reservation_disable_user` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.schema_version 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `schema_version` (
+ `installed_rank` int(11) NOT NULL,
+ `version` varchar(50) DEFAULT NULL,
+ `description` varchar(200) NOT NULL,
+ `type` varchar(20) NOT NULL,
+ `script` varchar(1000) NOT NULL,
+ `checksum` int(11) DEFAULT NULL,
+ `installed_by` varchar(100) NOT NULL,
+ `installed_on` timestamp NOT NULL DEFAULT current_timestamp(),
+ `execution_time` int(11) NOT NULL,
+ `success` tinyint(1) NOT NULL,
+ PRIMARY KEY (`installed_rank`),
+ KEY `schema_version_s_idx` (`success`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- �뀒�씠釉� owl_en_1.5.severity 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.severity 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `severity` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
`name` varchar(50) NOT NULL,
`position` bigint(20) NOT NULL,
`color` varchar(255) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.severity:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `severity` DISABLE KEYS */;
-/*!40000 ALTER TABLE `severity` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.system_email 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.system_email 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `system_email` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`send_address` varchar(50) NOT NULL,
@@ -616,16 +865,12 @@
`send_yn` varchar(2) NOT NULL DEFAULT 'N',
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.system_email:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `system_email` DISABLE KEYS */;
-/*!40000 ALTER TABLE `system_email` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.system_role 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.system_role 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `system_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
@@ -635,13 +880,15 @@
`modify_id` bigint(20) NOT NULL,
`modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.system_role:~2 rows (���왂�쟻) �궡蹂대궡湲�
/*!40000 ALTER TABLE `system_role` DISABLE KEYS */;
INSERT INTO `system_role` (`id`, `name`, `role_type`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
(1, '�씪諛� �궗�슜�옄 �뿭�븷', '01', 1, '2017-12-29 21:37:15', 1, '2017-12-29 21:37:16'),
-(2, '�썙�겕�뒪�럹�씠�뒪 愿�由ъ옄 �뿭�븷', '02', 1, '2017-12-29 21:37:27', 1, '2017-12-29 21:37:28');
+(2, '�썙�겕�뒪�럹�씠�뒪 愿�由ъ옄 �뿭�븷', '02', 1, '2017-12-29 21:37:27', 1, '2017-12-29 21:37:28'),
+(3, '�봽濡쒖젥�듃 �궗�슜�옄 �뿭�븷', '03', 1, '2017-12-29 21:37:15', 1, '2017-12-29 21:37:15'),
+(4, '�봽濡쒖젥�듃 愿�由ъ옄 �뿭�븷', '04', 1, '2017-12-29 21:37:15', 1, '2017-12-29 21:37:15');
/*!40000 ALTER TABLE `system_role` ENABLE KEYS */;
-- �뀒�씠釉� owl_en_1.5.system_role_permission 援ъ“ �궡蹂대궡湲�
@@ -654,7 +901,7 @@
`modify_id` bigint(20) NOT NULL,
`modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.system_role_permission:~18 rows (���왂�쟻) �궡蹂대궡湲�
/*!40000 ALTER TABLE `system_role_permission` DISABLE KEYS */;
@@ -676,7 +923,9 @@
(15, 2, 9, 1, '2018-05-08 15:52:13', 1, '2018-05-08 15:52:14'),
(16, 2, 10, 1, '2018-05-08 15:52:20', 1, '2018-05-08 15:52:21'),
(17, 2, 11, 1, '2018-05-08 15:52:28', 1, '2018-05-08 15:52:28'),
-(18, 2, 12, 1, '2018-05-08 15:52:35', 1, '2018-05-08 15:52:36');
+(18, 2, 12, 1, '2018-05-08 15:52:35', 1, '2018-05-08 15:52:36'),
+(19, 1, 13, 1, '2019-06-12 12:06:35', 1, '2019-06-12 12:06:37'),
+(20, 2, 13, 1, '2019-06-12 12:06:47', 1, '2019-06-12 12:06:49');
/*!40000 ALTER TABLE `system_role_permission` ENABLE KEYS */;
-- �뀒�씠釉� owl_en_1.5.system_role_user 援ъ“ �궡蹂대궡湲�
@@ -693,11 +942,7 @@
KEY `systemRoleidIndex` (`system_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.system_role_user:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `system_role_user` DISABLE KEYS */;
-/*!40000 ALTER TABLE `system_role_user` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.user 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
@@ -715,14 +960,29 @@
`register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
`modify_date` timestamp NULL DEFAULT NULL,
- PRIMARY KEY (`id`)
+ `licensekey` varchar(255) DEFAULT NULL,
+ `last_project_id` bigint(20) DEFAULT 0,
+ `last_issue_type_id` bigint(20) DEFAULT 0,
+ `last_login_date` timestamp NULL DEFAULT NULL,
+ `level_id` bigint(11) DEFAULT NULL,
+ `insert_type` varchar(1) NOT NULL DEFAULT 'N',
+ PRIMARY KEY (`id`),
+ KEY `levelIdIndex` (`level_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.user_department 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `user_department` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `department_id` bigint(11) DEFAULT NULL,
+ `user_id` bigint(11) DEFAULT 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
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.user_invite 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user_invite 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user_invite` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
@@ -730,35 +990,41 @@
`status` varchar(10) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user_invite:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user_invite` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user_invite` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.user_invite_project 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user_invite_project 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user_invite_project` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_invite_id` bigint(20) NOT NULL,
`project_id` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `userInviteIdIndex` (`user_invite_id`),
KEY `projectIdIndex` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user_invite_project:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user_invite_project` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user_invite_project` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.user_level 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `user_level` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `level_name` varchar(50) NOT NULL,
+ `permission` int(11) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ `default_yn` varchar(1) NOT NULL DEFAULT 'N',
+ `basic_user` varchar(1) NOT NULL DEFAULT 'N',
+ PRIMARY KEY (`id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.user_like_issue 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user_like_issue 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user_like_issue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
@@ -766,35 +1032,27 @@
`workspace_id` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `userIdIndex` (`user_id`),
KEY `issueIdIndex` (`issue_id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user_like_issue:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user_like_issue` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user_like_issue` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.user_with_draw 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user_with_draw 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user_with_draw` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account` varchar(200) NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `accountIndex` (`account`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user_with_draw:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user_with_draw` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user_with_draw` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.user_workspace 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user_workspace 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user_workspace` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) DEFAULT NULL,
@@ -802,39 +1060,64 @@
`manager_yn` varchar(2) NOT NULL DEFAULT 'N',
`use_yn` varchar(2) NOT NULL DEFAULT 'N',
`disable_position` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `userIdIndex` (`user_id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user_workspace:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user_workspace` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user_workspace` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.workflow 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.workflow 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `workflow` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
`name` varchar(50) NOT NULL,
- `description` mediumtext,
+ `description` mediumtext DEFAULT NULL,
`project_type` varchar(50) DEFAULT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.workflow:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `workflow` DISABLE KEYS */;
-/*!40000 ALTER TABLE `workflow` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.workflow_department 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `workflow_department` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `workflow_id` bigint(11) DEFAULT NULL,
+ `issue_status_id` bigint(11) DEFAULT NULL,
+ `department_id` bigint(11) DEFAULT 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 `workflowIdIndex` (`workflow_id`) USING BTREE,
+ KEY `issueStatusIdIndex` (`issue_status_id`) USING BTREE,
+ KEY `departmentIdIndex` (`department_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.workflow_transition 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.workflow_status 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `workflow_status` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `project_id` bigint(20) DEFAULT NULL,
+ `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
+ `first_yn` varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N',
+ `last_yn` varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N',
+ `progress` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT '吏꾪뻾瑜�',
+ `color` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '0',
+ `position` bigint(20) NOT NULL DEFAULT 0,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ PRIMARY KEY (`id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.workflow_transition 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `workflow_transition` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workflow_id` bigint(20) NOT NULL,
@@ -847,9 +1130,9 @@
`correct_x` bigint(20) DEFAULT NULL,
`correct_y` bigint(20) DEFAULT NULL,
`direct` varchar(2) NOT NULL DEFAULT 'N',
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `workflowIdIndex` (`workflow_id`),
@@ -857,31 +1140,23 @@
KEY `targetIssueStatusIdIndex` (`target_issue_status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.workflow_transition:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `workflow_transition` DISABLE KEYS */;
-/*!40000 ALTER TABLE `workflow_transition` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.workspace 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.workspace 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `workspace` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`max_user` bigint(20) NOT NULL,
- `start_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `expire_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `start_date` timestamp NULL DEFAULT NULL,
+ `expire_date` timestamp NULL DEFAULT NULL,
`storage_size` bigint(20) NOT NULL,
`use_traffic` bigint(20) DEFAULT NULL,
`service_type` varchar(10) DEFAULT NULL,
- `register_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.workspace:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `workspace` DISABLE KEYS */;
-/*!40000 ALTER TABLE `workspace` ENABLE KEYS */;
-
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
\ No newline at end of file
--
Gitblit v1.8.0