1. kazuko TSUCHITANI
  2. box

Wiki

Clone wiki

box / table change history

2016/04/22 アトリビュート グループ設定,説明2を追加 

ALTER TABLE `gl_databox_def_field` ADD `description2` MEDIUMTEXT NOT NULL AFTER `dfid` ,
ADD `fieldgroupno` INT( 2 ) NOT NULL AFTER `description2` 
ALTER TABLE `gl_userbox_def_field` ADD `description2` MEDIUMTEXT NOT NULL AFTER `dfid` ,
ADD `fieldgroupno` INT( 2 ) NOT NULL AFTER `description2` 

2016/03/10 グループ  テンプレートディレクトリ, 表示制限(一般), 編集制限(ユーザー)を追加

ALTER TABLE `gl_databox_def_group` ADD `defaulttemplatesdirectory` VARCHAR( 40 ) NOT NULL DEFAULT '' AFTER `input_type` ,
ADD `allow_display` BINARY( 1 ) DEFAULT '0' AFTER `defaulttemplatesdirectory` ,
ADD `allow_edit` BINARY( 1 ) DEFAULT '0' AFTER `allow_display` 
ALTER TABLE `gl_userbox_def_group` ADD `defaulttemplatesdirectory` VARCHAR( 40 ) NOT NULL DEFAULT '' AFTER `input_type` ,
ADD `allow_display` BINARY( 1 ) DEFAULT '0' AFTER `defaulttemplatesdirectory` ,
ADD `allow_edit` BINARY( 1 ) DEFAULT '0' AFTER `allow_display` 

2015/03/06

ALTER TABLE `gl_databox_base` ADD `cache_time` INT( 11 ) NOT NULL DEFAULT '0' AFTER `trackbackcode` 
ALTER TABLE `gl_userbox_base` ADD `cache_time` INT( 11 ) NOT NULL DEFAULT '0' AFTER `trackbackcode` 

移行時、過去のデータの一括変更が必要なら別途更新してください。 -1 = 常にキャッシュし、エディターで記事を更新・保存した場合に限り、キャッシュを再生成します。3600 = 1時間, 86400 = 1日 0=キャッシュしない

update `gl_databox_base` set `cache_time` = '-1'
update `gl_userbox_base` set `cache_time` = '-1'

2014/12/26

ALTER TABLE `gl_databox_addition` CHANGE `value` `value` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
UPDATE `gl_databox_addition` SET `value` = NULL WHERE `value` = ""
ALTER TABLE `gl_userbox_addition` CHANGE `value` `value` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
UPDATE `gl_userbox_addition` SET `value` = NULL WHERE `value` = ""

2014/02/28

ALTER TABLE `gl_databox_def_field` ADD `initial_value` MEDIUMTEXT NOT NULL AFTER `searchtarget` ,
ADD `range_start` MEDIUMTEXT NOT NULL AFTER `initial_value` ,
ADD `range_end` MEDIUMTEXT NOT NULL AFTER `range_start` ,
ADD `dfid` TINYINT( 3 ) NOT NULL DEFAULT '0' AFTER `range_end` 
ALTER TABLE `gl_databox_def_category` ADD `allow_display` BINARY( 1 ) NOT NULL DEFAULT '0' AFTER `categorygroup_id` 
ALTER TABLE `gl_userbox_def_field` ADD `initial_value` MEDIUMTEXT NOT NULL AFTER `searchtarget` ,
ADD `range_start` MEDIUMTEXT NOT NULL AFTER `initial_value` ,
ADD `range_end` MEDIUMTEXT NOT NULL AFTER `range_start` ,
ADD `dfid` TINYINT( 3 ) NOT NULL DEFAULT '0' AFTER `range_end` 
ALTER TABLE `gl_userbox_def_category` ADD `allow_display` BINARY( 1 ) NOT NULL DEFAULT '0' AFTER `categorygroup_id` 

2013/05/31

ALTER TABLE `gl_databox_base` 
ADD `trackbackcode` TINYINT( 4 ) NOT NULL DEFAULT '0' AFTER `fieldset_id` 
ALTER TABLE `gl_userbox_base` 
ADD `trackbackcode` TINYINT( 4 ) NOT NULL DEFAULT '0' AFTER `fieldset_id` 

2013/02/13

ALTER TABLE `gl_databox_def_field` 
CHANGE `textconv` `textconv` BINARY( 2 ) NULL DEFAULT '0' 
ALTER TABLE `gl_databox_def_field` 
CHANGE `textcheck` `textcheck` BINARY( 2 ) NULL DEFAULT '0' 
ALTER TABLE `gl_userbox_def_field` 
CHANGE `textconv` `textconv` BINARY( 2 ) NULL DEFAULT '0' 
ALTER TABLE `gl_userbox_def_field` 
CHANGE `textcheck` `textcheck` BINARY( 2 ) NULL DEFAULT '0' 

2013/02/06

ALTER TABLE `gl_databox_def_field` 
ADD `textcheck` BINARY( 1 )  DEFAULT 0 AFTER `allow_edit` ,
ADD `textconv` BINARY( 1 )  DEFAULT 0 AFTER `textcheck`,
ADD `searchtarget` BINARY( 1 )  DEFAULT 0 AFTER `textconv` ;
ALTER TABLE `gl_userbox_def_field` 
ADD `textcheck` BINARY( 1 )  DEFAULT 0 AFTER `allow_edit` ,
ADD `textconv` BINARY( 1 )  DEFAULT 0 AFTER `textcheck`,
ADD `searchtarget` BINARY( 1 )  DEFAULT 0 AFTER `textconv` ;

2012/12/26

ALTER TABLE `gl_databox_mst` 
    ADD `udatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
   ,ADD  `uuid` mediumint(8) NOT NULL
ALTER TABLE `gl_userbox_mst` 
  ADD `udatetime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP 
  ,ADD `uuid` MEDIUMINT( 8 ) NOT NULL ;

2012/09/11

ALTER TABLE `gl_databox_def_fieldset` 
    ADD `defaulttemplatesdirectory` VARCHAR( 40 ) NOT NULL AFTER `description`
    ,ADD `layout` VARCHAR( 16 ) NOT NULL 
    AFTER `defaulttemplatesdirectory` 
//属性セットテーブル
CREATE TABLE `gl_userbox_def_fieldset` (
  `fieldset_id` int(11) NOT NULL,
  `name` varchar(64) NOT NULL,
  `description` mediumtext,
  `defaulttemplatesdirectory` varchar(40) NOT NULL,
  `layout` varchar(16) NOT NULL,
  `udatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `uuid` mediumint(8) NOT NULL,
  PRIMARY KEY (`fieldset_id`)
) ENGINE=MyISAM
INSERT INTO `gl_userbox_def_fieldset` (
`fieldset_id` 
)
VALUES (
'0'
)
//属性セット 属性関連
CREATE TABLE `gl_userbox_def_fieldset_assignments` (
  `seq` int(11) NOT NULL AUTO_INCREMENT,
  `fieldset_id` int(11) NOT NULL,
  `field_id` int(11) NOT NULL,
  PRIMARY KEY (`seq`),
  KEY `fieldset_id` (`fieldset_id`)
) ENGINE=MyISAM
//属性セット グループ関連
CREATE TABLE `gl_userbox_def_fieldset_group` (
  `seq` int(11) NOT NULL AUTO_INCREMENT,
  `fieldset_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`seq`),
  KEY `fieldset_id` (`fieldset_id`)
) ENGINE=MyISAM

ALTER TABLE `gl_userbox_base`
  ADD `fieldset_id` int(11) NOT NULL default 0 AFTER `orderno`
//属性セットテーブル
CREATE TABLE `gl_databox_def_fieldset` (
  `fieldset_id` int(11) NOT NULL,
  `name` varchar(64) NOT NULL,
  `description` mediumtext,
  `defaulttemplatesdirectory` varchar(40) NOT NULL,
  `layout` varchar(16) NOT NULL,
  `udatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `uuid` mediumint(8) NOT NULL,
  PRIMARY KEY (`fieldset_id`)
) ENGINE=MyISAM

INSERT INTO `gl_databox_def_fieldset` (
`fieldset_id` 
)
VALUES (
'0'
)
//属性セット 属性関連
CREATE TABLE `gl_databox_def_fieldset_assignments` (
  `seq` int(11) NOT NULL AUTO_INCREMENT,
  `fieldset_id` int(11) NOT NULL,
  `field_id` int(11) NOT NULL,
  PRIMARY KEY (`seq`),
  KEY `fieldset_id` (`fieldset_id`)
) ENGINE=MyISAM
//属性セット グループ関連
CREATE TABLE `gl_databox_def_fieldset_group` (
  `seq` int(11) NOT NULL AUTO_INCREMENT,
  `fieldset_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`seq`),
  KEY `fieldset_id` (`fieldset_id`)
) ENGINE=MyISAM

ALTER TABLE `gl_databox_base`
  ADD `fieldset_id` int(11) NOT NULL default 0 AFTER `orderno`

ALTER TABLE `gl_databox_def_group` ADD `input_type` BINARY( 1 ) NOT NULL AFTER `parent_flg` 

ALTER TABLE `gl_userbox_def_group` ADD `input_type` BINARY( 1 ) NOT NULL AFTER `parent_flg` 

Updated