2.3.2
 変更なし

2.3.1
 変更なし

2.3.0
USE `xxxxxxx_jgw_gw`;
ALTER TABLE gw_edit_link_pieces ADD mode integer AFTER state;
UPDATE gw_edit_link_pieces SET mode = 1;
ALTER TABLE gw_admin_messages ADD mode integer;
UPDATE gw_admin_messages SET mode = 1;

2.2.0
USE `xxxxxxx_jgw_gw`;
ALTER TABLE gwboard_renewal_groups ADD start_date datetime;

USE `xxxxxxx_jgw_core`;
CREATE TABLE IF NOT EXISTS `system_group_change_dates` (
  id int(11) NOT NULL AUTO_INCREMENT,
  created_at datetime,
  created_user text,
  created_group text,
  updated_at datetime,
  updated_user text,
  updated_group text,
  deleted_at datetime,
  deleted_user text,
  deleted_group text,
  start_at datetime,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;

2.1.2
 変更なし


2.1.1
 変更なし

2.1.0
USE `xxxxxxx_jgw_gw`;
CREATE TABLE IF NOT EXISTS `gw_prop_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `state` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sort_no` int(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
  ) DEFAULT CHARSET=utf8;

  INSERT INTO `gw_prop_types` (`id`, `state`, `name`, `sort_no`, `created_at`, `updated_at`, `deleted_at`) VALUES
  (100, 'public', '公用車', 100, NULL, NULL, NULL),
  (200, 'public', '会議室', 200, NULL, NULL, NULL),
  (300, 'public', '一般備品', 300, NULL, NULL, NULL);

CREATE TABLE IF NOT EXISTS `gw_workflow_controls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unid` int(11) DEFAULT NULL,
  `content_id` int(11) DEFAULT NULL,
  `state` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `recognized_at` datetime DEFAULT NULL,
  `published_at` datetime DEFAULT NULL,
  `default_published` int(11) DEFAULT NULL,
  `doc_body_size_capacity` int(11) DEFAULT NULL,
  `doc_body_size_currently` int(11) DEFAULT NULL,
  `upload_graphic_file_size_capacity` int(11) DEFAULT NULL,
  `upload_graphic_file_size_capacity_unit` varchar(255) DEFAULT NULL,
  `upload_document_file_size_capacity` int(11) DEFAULT NULL,
  `upload_document_file_size_capacity_unit` varchar(255) DEFAULT NULL,
  `upload_graphic_file_size_max` int(11) DEFAULT NULL,
  `upload_document_file_size_max` int(11) DEFAULT NULL,
  `upload_graphic_file_size_currently` decimal(17,0) DEFAULT NULL,
  `upload_document_file_size_currently` decimal(17,0) DEFAULT NULL,
  `commission_limit` int(11) DEFAULT NULL,
  `create_section` varchar(255) DEFAULT NULL,
  `create_section_flag` varchar(255) DEFAULT NULL,
  `addnew_forbidden` tinyint(1) DEFAULT NULL,
  `edit_forbidden` tinyint(1) DEFAULT NULL,
  `draft_forbidden` tinyint(1) DEFAULT NULL,
  `delete_forbidden` tinyint(1) DEFAULT NULL,
  `attachfile_index_use` tinyint(1) DEFAULT NULL,
  `importance` int(11) DEFAULT NULL,
  `form_name` varchar(255) DEFAULT NULL,
  `banner` text,
  `banner_position` varchar(255) DEFAULT NULL,
  `left_banner` text,
  `left_menu` text,
  `left_index_use` varchar(1) DEFAULT NULL,
  `left_index_pattern` int(11) DEFAULT NULL,
  `left_index_bg_color` varchar(255) DEFAULT NULL,
  `default_mode` varchar(255) DEFAULT NULL,
  `other_system_link` text,
  `preview_mode` tinyint(1) DEFAULT NULL,
  `wallpaper_id` int(11) DEFAULT NULL,
  `wallpaper` text,
  `css` text,
  `font_color` text,
  `icon_id` int(11) DEFAULT NULL,
  `icon` text,
  `sort_no` int(11) DEFAULT NULL,
  `caption` text,
  `view_hide` tinyint(1) DEFAULT NULL,
  `categoey_view` tinyint(1) DEFAULT NULL,
  `categoey_view_line` int(11) DEFAULT NULL,
  `monthly_view` tinyint(1) DEFAULT NULL,
  `monthly_view_line` int(11) DEFAULT NULL,
  `group_view` tinyint(1) DEFAULT NULL,
  `one_line_use` int(11) DEFAULT NULL,
  `notification` int(11) DEFAULT NULL,
  `restrict_access` tinyint(1) DEFAULT NULL,
  `upload_system` int(11) DEFAULT NULL,
  `limit_date` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `category1_name` varchar(255) DEFAULT NULL,
  `category2_name` varchar(255) DEFAULT NULL,
  `category3_name` varchar(255) DEFAULT NULL,
  `recognize` int(11) DEFAULT NULL,
  `createdate` text,
  `createrdivision_id` varchar(20) DEFAULT NULL,
  `createrdivision` text,
  `creater_id` varchar(20) DEFAULT NULL,
  `creater` text,
  `editdate` text,
  `editordivision_id` varchar(20) DEFAULT NULL,
  `editordivision` text,
  `editor_id` varchar(20) DEFAULT NULL,
  `editor` text,
  `default_limit` int(11) DEFAULT NULL,
  `dbname` varchar(255) DEFAULT NULL,
  `admingrps` text,
  `admingrps_json` text,
  `adms` text,
  `adms_json` text,
  `dsp_admin_name` text,
  `editors` text,
  `editors_json` text,
  `readers` text,
  `readers_json` text,
  `sueditors` text,
  `sueditors_json` text,
  `sureaders` text,
  `sureaders_json` text,
  `help_display` text,
  `help_url` text,
  `help_admin_url` text,
  `notes_field01` text,
  `notes_field02` text,
  `notes_field03` text,
  `notes_field04` text,
  `notes_field05` text,
  `notes_field06` text,
  `notes_field07` text,
  `notes_field08` text,
  `notes_field09` text,
  `notes_field10` text,
  `docslast_updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
)   DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gw_workflow_docs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,

  `state` text,
  `title` text,
  `body` mediumtext,
  `expired_at` datetime DEFAULT NULL,
  `applied_at` datetime DEFAULT NULL,

  `creater_id` varchar(20) DEFAULT NULL,
  `creater_name` varchar(20) DEFAULT NULL,
  `creater_gname` varchar(20) DEFAULT NULL,

  `attachmentfile` int(11) DEFAULT NULL,


  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gw_workflow_route_steps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,

  `doc_id` int(11) DEFAULT NULL,

  `number` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`)
)   DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gw_workflow_route_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,

  `step_id` int(11) DEFAULT NULL,
  `decided_at` datetime DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `comment` text,

  `user_id` int(11) DEFAULT NULL,
  `user_name` text,
  `user_gname` text,

  PRIMARY KEY (`id`)
)   DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gw_workflow_custom_routes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,

  `owner_uid` int(11) DEFAULT NULL,

  `sort_no` int(11) DEFAULT NULL,
  `state` text,
  `name` text,

  PRIMARY KEY (`id`)
)   DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gw_workflow_custom_route_steps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,

  `custom_route_id` int(11) DEFAULT NULL,

  `number` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`)
)   DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gw_workflow_custom_route_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,

  `step_id` int(11) DEFAULT NULL,

  `user_id` int(11) DEFAULT NULL,
  `user_name` text,
  `user_gname` text,

  PRIMARY KEY (`id`)
)   DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `gwworkflow_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unid` int(11) DEFAULT NULL,
  `content_id` int(11) DEFAULT NULL,
  `state` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `recognized_at` datetime DEFAULT NULL,
  `published_at` datetime DEFAULT NULL,
  `latest_updated_at` datetime DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `title_id` int(11) DEFAULT NULL,
  `content_type` varchar(255) DEFAULT NULL,
  `filename` text,
  `memo` text,
  `size` int(11) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `db_file_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
)   DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gw_workflow_itemdeletes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unid` int(11) DEFAULT NULL,
  `content_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `admin_code` varchar(255) DEFAULT NULL,
  `title_id` int(11) DEFAULT NULL,
  `board_title` text,
  `board_state` varchar(255) DEFAULT NULL,
  `board_view_hide` varchar(255) DEFAULT NULL,
  `board_sort_no` int(11) DEFAULT NULL,
  `public_doc_count` int(11) DEFAULT NULL,
  `void_doc_count` int(11) DEFAULT NULL,
  `dbname` varchar(255) DEFAULT NULL,
  `limit_date` varchar(255) DEFAULT NULL,
  `board_limit_date` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
)   DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gw_workflow_mail_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unid` int(11) DEFAULT NULL,
  `notifying` BOOLEAN,
  PRIMARY KEY (`id`)
)   DEFAULT CHARSET=utf8;


INSERT INTO `gw_workflow_controls` (`id`, `unid`, `content_id`, `state`, `created_at`, `updated_at`, `recognized_at`, `published_at`, `default_published`, `doc_body_size_capacity`, `doc_body_size_currently`, `upload_graphic_file_size_capacity`, `upload_graphic_file_size_capacity_unit`, `upload_document_file_size_capacity`, `upload_document_file_size_capacity_unit`, `upload_graphic_file_size_max`, `upload_document_file_size_max`, `upload_graphic_file_size_currently`, `upload_document_file_size_currently`, `commission_limit`, `create_section`, `create_section_flag`, `addnew_forbidden`, `edit_forbidden`, `draft_forbidden`, `delete_forbidden`, `attachfile_index_use`, `importance`, `form_name`, `banner`, `banner_position`, `left_banner`, `left_menu`, `left_index_use`, `left_index_pattern`, `left_index_bg_color`, `default_mode`, `other_system_link`, `preview_mode`, `wallpaper_id`, `wallpaper`, `css`, `font_color`, `icon_id`, `icon`, `sort_no`, `caption`, `view_hide`, `categoey_view`, `categoey_view_line`, `monthly_view`, `monthly_view_line`, `group_view`, `one_line_use`, `notification`, `restrict_access`, `upload_system`, `limit_date`, `name`, `title`, `category`, `category1_name`, `category2_name`, `category3_name`, `recognize`, `createdate`, `createrdivision_id`, `createrdivision`, `creater_id`, `creater`, `editdate`, `editordivision_id`, `editordivision`, `editor_id`, `editor`, `default_limit`, `dbname`, `admingrps`, `admingrps_json`, `adms`, `adms_json`, `dsp_admin_name`, `editors`, `editors_json`, `readers`, `readers_json`, `sueditors`, `sueditors_json`, `sureaders`, `sureaders_json`, `help_display`, `help_url`, `help_admin_url`, `notes_field01`, `notes_field02`, `notes_field03`, `notes_field04`, `notes_field05`, `notes_field06`, `notes_field07`, `notes_field08`, `notes_field09`, `notes_field10`, `docslast_updated_at`) VALUES
(1, NULL, NULL, 'public', '2013-05-20 10:00:00', '2013-05-20 10:00:00', NULL, NULL, 7, 100, 0, 10, 'GB', 10, 'GB', 5, 5, 0, 0, 200, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '', 1, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 3, 'use', NULL, 'ワークフロー', NULL, NULL, NULL, NULL, 0, '2010-11-19 10:55', '698', '秘書広報課', 'gwbbs', 'admin', '2010-11-25 17:13', '698', '秘書広報課', 'gwbbs', 'admin', 200, NULL, '--- !map:HashWithIndifferentAccess \ngid: "3"\n', '[]', '--- !map:HashWithIndifferentAccess \ngid: "36"\n', '[]', '', '--- !map:HashWithIndifferentAccess \ngid: "3"\n', '[["", "0", "制限なし"]]', '--- !map:HashWithIndifferentAccess \ngid: "0"\n', '[["", "0", "制限なし"]]', '--- !map:HashWithIndifferentAccess \ngid: "36"\n', '[]', '--- !map:HashWithIndifferentAccess \ngid: "36"\n', '[]', '1', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `gw_edit_link_pieces` (`id`, `uid`, `class_created`, `published`, `state`, `level_no`, `parent_id`, `name`, `sort_no`, `tab_keys`, `display_auth_priv`, `role_name_id`, `display_auth`, `block_icon_id`, `block_css_id`, `link_url`, `remark`, `icon_path`, `link_div_class`, `class_external`, `ssoid`, `class_sso`, `field_account`, `field_pass`, `css_id`, `deleted_at`, `deleted_user`, `deleted_group`, `updated_at`, `updated_user`, `updated_group`, `created_at`, `created_user`, `created_group`) VALUES
(1507, NULL, 1, 'opened', 'enabled', 4, 1485, 'ワークフロー',     10, 0, NULL, NULL, '', 2,    NULL, '/gwworkflow',                     NULL, '', NULL, 1, NULL, 1, '', '', 0, NULL, NULL, NULL, '2013-05-27 17:27:50', NULL, NULL, '2013-05-27 17:27:50', 'システム管理者', '秘書広報課');


USE `xxxxxxx_jgw_core`;

INSERT INTO `system_roles` (`id`, `table_name`, `priv_name`, `idx`, `class_id`, `uid`, `priv`, `created_at`, `updated_at`, `role_name_id`, `priv_user_id`, `group_id`) VALUES
(18,'gwworkflow','admin',1,1,'5194',1,'2012-08-23 19:54:19','2012-08-23 19:54:19',41,1,698);



2.0.1
  USE `xxxxxxx_jgw_gw`;
  CREATE TABLE `gw_plus_updates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doc_id` varchar(255) DEFAULT NULL,
  `post_id` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `project_users` text,
  `project_users_json` text,
  `project_id` varchar(255) DEFAULT NULL,
  `project_code` varchar(255) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `title` text,
  `doc_updated_at` datetime DEFAULT NULL,
  `author` text,
  `project_url` text,
  `body` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
  ) DEFAULT CHARSET=utf8;

  #下記はJoruriPlus+へのSSO設定となります。optionsの値（'localhost'）は該当するシステムのホスト名に変更してください。
  INSERT INTO `gw_user_properties` (`class_id`, `uid`, `name`, `type_name`, `options`, `created_at`, `updated_at`) VALUES
  ( 3, '0', 'plus_sso', 'sso', 'localhost', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());

2.0.0
  * 新規リリース