-- --------------------------------------------------------
-- 호스트:                          192.168.0.64
-- 서버 버전:                        10.1.13-MariaDB - Source distribution
-- 서버 OS:                        Linux
-- HeidiSQL 버전:                  10.1.0.5464
-- --------------------------------------------------------

/*!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' */;


-- 테이블 owl_en_1.5.attached_file 구조 내보내기
CREATE TABLE IF NOT EXISTS `attached_file` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `issue_id` bigint(20) DEFAULT NULL,
    `workspace_id` bigint(20) DEFAULT NULL,
    `name` varchar(4000) DEFAULT '',
    `path` varchar(4000) DEFAULT NULL,
    `file_type` varchar(10) DEFAULT NULL,
    `size` bigint(20) DEFAULT NULL,
    `content_type` 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',
    `aws_key` varchar(255) DEFAULT 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 */;

-- 테이블 owl_en_1.5.custom_field 구조 내보내기
CREATE TABLE IF NOT EXISTS `custom_field` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `workspace_id` bigint(20) NOT NULL,
    `name` varchar(15) NOT NULL,
    `custom_field_type` varchar(50) NOT NULL,
    `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',
    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 */;

-- 테이블 owl_en_1.5.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',
    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 */;

-- 테이블 owl_en_1.5.issue 구조 내보내기
CREATE TABLE IF NOT EXISTS `issue` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    `issue_status_id` bigint(20) DEFAULT NULL,
    `issue_type_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 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 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 `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 */;

-- 테이블 owl_en_1.5.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',
    `workspace_id` bigint(20) NOT NULL,
    `description` varchar(300) DEFAULT NULL COMMENT 'description',
    `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 `issueIdIndex` (`issue_id`),
    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 */;

-- 테이블 owl_en_1.5.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,
    `issue_type_custom_field_id` bigint(20) NOT NULL,
    `custom_field_id` bigint(20) NOT NULL,
    `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',
    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 */;

-- 테이블 owl_en_1.5.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,
    `register_id` bigint(20) DEFAULT NULL,
    `register_date` timestamp NULL DEFAULT NULL,
    `modify_id` bigint(20) DEFAULT NULL,
    `modify_date` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `issueIdIndex` (`issue_id`),
    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 */;

-- 테이블 owl_en_1.5.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',
    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 */;

-- 테이블 owl_en_1.5.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',
    `issue_status_ids` text NOT NULL,
    `register_id` bigint(20) NOT NULL,
    `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    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 구조 내보내기
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,
    `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 `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 구조 내보내기
CREATE TABLE IF NOT EXISTS `issue_status` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `workspace_id` bigint(20) DEFAULT NULL,
    `issue_status_type` varchar(50) DEFAULT NULL,
    `name` varchar(20) NOT NULL DEFAULT '',
    `default_yn` varchar(1) NOT NULL DEFAULT 'N',
    `color` varchar(255) NOT NULL,
    `position` bigint(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`),
    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 구조 내보내기
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,
    `modify_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`),
    KEY `workspaceIdAndUserIdIndex` (`workspace_id`,`user_id`),
    KEY `workspaceIdIndex` (`workspace_id`)
    ) 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 구조 내보내기
CREATE TABLE IF NOT EXISTS `issue_type` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `workspace_id` bigint(20) NOT NULL,
    `workflow_id` bigint(20) NOT NULL,
    `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_id` bigint(20) NOT NULL,
    `modify_id` bigint(20) NOT NULL,
    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 */;

-- 테이블 owl_en_1.5.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',
    `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 `projectIdIndex` (`project_id`),
    KEY `issueTypeIdIndex` (`issue_type_id`),
    KEY `customFieldIdIndex` (`custom_field_id`),
    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 구조 내보내기
CREATE TABLE IF NOT EXISTS `issue_user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_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 `userIdAndIssueIdIndex` (`user_id`,`issue_id`),
    KEY `issueIdIndex` (`issue_id`),
    KEY `workspaceIdIndex` (`workspace_id`),
    KEY `userIdIndex` (`user_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` (
    `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,
    `register_id` bigint(20) DEFAULT NULL,
    `register_date` timestamp NULL DEFAULT NULL,
    `modify_id` bigint(20) DEFAULT NULL,
    `modify_date` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `issueIdIndex` (`issue_id`),
    KEY `workspaceIdIndex` (`workspace_id`),
    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',
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='login_history';

-- 테이블 데이터 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 구조 내보내기
CREATE TABLE IF NOT EXISTS `payment` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `workspace_id` bigint(20) DEFAULT NULL,
    `type` varchar(10) DEFAULT NULL,
    `price` bigint(20) DEFAULT NULL,
    `buy_user` bigint(20) DEFAULT NULL,
    `register_date` timestamp NULL DEFAULT NULL,
    `register_id` bigint(20) DEFAULT NULL,
    `modify_date` timestamp NULL DEFAULT NULL,
    `modify_id` bigint(20) DEFAULT NULL,
    PRIMARY KEY (`id`),
    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 구조 내보내기
CREATE TABLE IF NOT EXISTS `payment_history` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `workspace_id` bigint(20) NOT NULL,
    `type` varchar(10) DEFAULT NULL,
    `price` bigint(20) DEFAULT NULL,
    `buy_user` bigint(20) DEFAULT NULL,
    `customer_uid` varchar(255) NOT NULL,
    `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_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `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 구조 내보내기
CREATE TABLE IF NOT EXISTS `permission` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    `action` varchar(50) NOT NULL,
    `role_type` varchar(2) 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`)
    ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;

-- 테이블 데이터 owl_en_1.5.permission:~12 rows (대략적) 내보내기
/*!40000 ALTER TABLE `permission` DISABLE KEYS */;
INSERT INTO `permission` (`id`, `name`, `action`, `role_type`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
(1, '프로젝트 조회 권한', 'PROJECT_READ', '01', 1, '2017-12-29 21:38:48', 1, '2017-12-29 21:38:51'),
(2, '프로젝트 참여자 권한', 'PROJECT_JOIN', '03', 1, '2018-01-03 10:11:42', 1, '2018-01-03 10:11:43'),
(3, '프로젝트 관리자 권한', 'PROJECT_MANAGER', '04', 1, '2018-01-03 10:11:42', 1, '2018-01-03 10:11:43'),
(4, '이슈 통합 권한', 'ISSUE_TOTAL', '01', 1, '2018-02-23 12:24:06', 1, '2018-02-23 12:24:07'),
(5, '워크스페이스 관리자 권한', 'WORKSPACE_MANAGER', '02', 1, '2018-02-23 12:24:06', 1, '2018-02-23 12:25:42'),
(6, '대시보드 통합 권한', 'DASHBOARD_TOTAL', '01', 1, '2018-05-03 15:04:44', 1, '2018-05-03 15:04:47'),
(7, '사용자 조회 권한', 'USER_READ', '01', 1, '2018-05-03 15:04:44', 1, '2018-05-03 15:04:47'),
(8, '사용자 통합 권한', 'USER_TOTAL', '02', 1, '2018-05-03 15:04:44', 1, '2018-05-03 15:04:47'),
(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');
/*!40000 ALTER TABLE `permission` ENABLE KEYS */;

-- 테이블 owl_en_1.5.priority 구조 내보내기
CREATE TABLE IF NOT EXISTS `priority` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `workspace_id` bigint(20) NOT NULL,
    `name` varchar(1000) NOT NULL DEFAULT '',
    `position` int(11) DEFAULT NULL,
    `color` 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',
    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 구조 내보내기
CREATE TABLE IF NOT EXISTS `project` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    `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',
    `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',
    `default_yn` varchar(2) NOT NULL DEFAULT 'N',
    `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 `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 */;

-- 테이블 owl_en_1.5.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,
    `modify_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    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 */;

-- 테이블 owl_en_1.5.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,
    `modify_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    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 구조 내보내기
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,
    `modify_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    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_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 구조 내보내기
CREATE TABLE IF NOT EXISTS `reservation_disable_user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `payment_id` bigint(20) DEFAULT NULL,
    `user_ids` varchar(255) DEFAULT NULL,
    `register_id` bigint(20) DEFAULT NULL,
    `register_date` timestamp NULL DEFAULT NULL,
    `modify_id` bigint(20) DEFAULT NULL,
    `modify_date` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    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 */;

-- 테이블 owl_en_1.5.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_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 구조 내보내기
CREATE TABLE IF NOT EXISTS `system_email` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `send_address` varchar(50) NOT NULL,
    `email_type` varchar(255) DEFAULT NULL,
    `parameter` mediumtext NOT NULL,
    `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',
    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 구조 내보내기
CREATE TABLE IF NOT EXISTS `system_role` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    `role_type` varchar(2) 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`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 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');
/*!40000 ALTER TABLE `system_role` ENABLE KEYS */;

-- 테이블 owl_en_1.5.system_role_permission 구조 내보내기
CREATE TABLE IF NOT EXISTS `system_role_permission` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `system_role_id` bigint(20) NOT NULL,
    `permission_id` bigint(20) 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`)
    ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;

-- 테이블 데이터 owl_en_1.5.system_role_permission:~18 rows (대략적) 내보내기
/*!40000 ALTER TABLE `system_role_permission` DISABLE KEYS */;
INSERT INTO `system_role_permission` (`id`, `system_role_id`, `permission_id`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
(1, 1, 1, 1, '2018-05-08 15:46:30', 1, '2018-05-08 15:46:31'),
(2, 1, 4, 1, '2018-05-08 15:46:37', 1, '2018-05-08 15:46:38'),
(3, 1, 6, 1, '2018-05-08 15:46:47', 1, '2018-05-08 15:46:48'),
(4, 1, 7, 1, '2018-05-08 15:46:59', 1, '2018-05-08 15:47:00'),
(5, 1, 9, 1, '2018-05-08 15:47:06', 1, '2018-05-08 15:47:07'),
(6, 1, 10, 1, '2018-05-08 15:47:14', 1, '2018-05-08 15:47:15'),
(7, 1, 11, 1, '2018-05-08 15:47:21', 1, '2018-05-08 15:47:22'),
(8, 1, 12, 1, '2018-05-08 15:47:29', 1, '2018-05-08 15:47:30'),
(9, 2, 1, 1, '2018-05-08 15:51:30', 1, '2018-05-08 15:51:31'),
(10, 2, 4, 1, '2018-05-08 15:51:37', 1, '2018-05-08 15:51:37'),
(11, 2, 5, 1, '2018-05-08 15:51:43', 1, '2018-05-08 15:51:43'),
(12, 2, 6, 1, '2018-05-08 15:51:49', 1, '2018-05-08 15:51:50'),
(13, 2, 7, 1, '2018-05-08 15:51:57', 1, '2018-05-08 15:51:57'),
(14, 2, 8, 1, '2018-05-08 15:52:04', 1, '2018-05-08 15:52:04'),
(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');
/*!40000 ALTER TABLE `system_role_permission` ENABLE KEYS */;

-- 테이블 owl_en_1.5.system_role_user 구조 내보내기
CREATE TABLE IF NOT EXISTS `system_role_user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `system_role_id` bigint(20) NOT NULL,
    `user_id` bigint(20) 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`),
    KEY `userIdIndex` (`user_id`),
    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 구조 내보내기
CREATE TABLE IF NOT EXISTS `user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    `account` varchar(50) DEFAULT NULL,
    `password` varchar(200) DEFAULT NULL,
    `profile` varchar(200) DEFAULT NULL,
    `status` varchar(2) NOT NULL DEFAULT '02',
    `phone` varchar(20) DEFAULT NULL,
    `social_type` varchar(10) DEFAULT NULL,
    `last_workspace_id` bigint(20) DEFAULT NULL,
    `reservation_notify_time` varchar(20) DEFAULT NULL,
    `language` varchar(10) NOT NULL,
    `aws_key` 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`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- 테이블 데이터 owl_en_1.5.user:~0 rows (대략적) 내보내기
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
/*!40000 ALTER TABLE `user` ENABLE KEYS */;

-- 테이블 owl_en_1.5.user_invite 구조 내보내기
CREATE TABLE IF NOT EXISTS `user_invite` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `workspace_id` bigint(20) NOT NULL,
    `email` varchar(255) NOT NULL,
    `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',
    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 구조 내보내기
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',
    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 */;

-- 테이블 owl_en_1.5.user_like_issue 구조 내보내기
CREATE TABLE IF NOT EXISTS `user_like_issue` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_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 `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 구조 내보내기
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,
    `modify_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    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 구조 내보내기
CREATE TABLE IF NOT EXISTS `user_workspace` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) DEFAULT NULL,
    `workspace_id` bigint(20) DEFAULT NULL,
    `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_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `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 구조 내보내기
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,
    `project_type` varchar(50) DEFAULT NULL,
    `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `register_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `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 */;

-- 테이블 owl_en_1.5.workflow_transition 구조 내보내기
CREATE TABLE IF NOT EXISTS `workflow_transition` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `workflow_id` bigint(20) NOT NULL,
    `source_issue_status_id` bigint(20) NOT NULL,
    `target_issue_status_id` bigint(20) NOT NULL,
    `source_x` bigint(20) DEFAULT NULL,
    `source_y` bigint(20) DEFAULT NULL,
    `target_x` bigint(20) DEFAULT NULL,
    `target_y` bigint(20) DEFAULT NULL,
    `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_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `modify_id` bigint(20) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `workflowIdIndex` (`workflow_id`),
    KEY `sourceIssueStatusIdIndex` (`source_issue_status_id`),
    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 구조 내보내기
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',
    `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_id` bigint(20) NOT NULL,
    `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `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 */;