ALTER TABLE custom_field modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE custom_field modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE custom_field_value modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE custom_field_value modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_custom_field_value modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_custom_field_value modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_number_generator modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_number_generator modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_reservation modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_reservation modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_risk modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_risk modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_search modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_search modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_table_config modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_table_config modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_type modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_type modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_type_custom_field modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_type_custom_field modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_user modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE issue_user modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE payment_history modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE payment_history modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE project_role modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE project_role modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE project_role_permission modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE project_role_permission modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE project_role_user modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE project_role_user modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE severity modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE severity modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE system_email modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE system_email modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE user_invite modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE user_invite modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE user_invite_project modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE user_invite_project modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE user_like_issue modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE user_like_issue modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE user_with_draw modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE user_with_draw modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE user_workspace modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE user_workspace modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE workflow modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE workflow modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE workflow_transition modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE workflow_transition modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE workspace modify register_date timestamp NULL DEFAULT NULL;
ALTER TABLE workspace modify modify_date timestamp NULL DEFAULT NULL;
ALTER TABLE workspace modify start_date timestamp NULL DEFAULT NULL;
ALTER TABLE workspace modify expire_date timestamp NULL DEFAULT NULL;

INSERT INTO `permission` (`name`, `action`, `role_type`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
	('공지사항 조회 권한', 'NOTICE_READ', '01', 1, '2019-06-12 12:05:23', 1, '2019-06-12 12:05:24');

INSERT INTO `system_role_permission` (`system_role_id`, `permission_id`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
	(1, 13, 1, '2019-06-12 12:06:35', 1, '2019-06-12 12:06:37'),
	(2, 13, 1, '2019-06-12 12:06:47', 1, '2019-06-12 12:06:49');
