INSERT INTO `cot_config` (`config_owner`, `config_cat`, `config_order`, `config_name`, `config_type`, `config_value`, `config_default`, `config_variants`, `config_text`) VALUES
(
'core'
,
'main'
,
'08'
,
'loggerlevel'
,2,
'sec+adm+ext'
,
'sec+adm+ext'
,
'none,sec,adm,ext,sec+adm,sec+ext,adm+ext,sec+adm+ext,all'
,
''
);
ALTER TABLE `cot_logger` MODIFY `log_group` varchar(64) DEFAULT
'adm'
;
ALTER TABLE `cot_logger` ADD `log_uid` int UNSIGNED NOT NULL DEFAULT
'0'
;
ALTER TABLE `cot_logger` ADD `log_type` varchar(32) DEFAULT
''
;
ALTER TABLE `cot_logger` ADD `log_status` varchar(24) DEFAULT
''
;
ALTER TABLE `cot_logger` ADD `log_uri` varchar(255) DEFAULT
''
;
UPDATE `cot_logger` SET `log_group` =
'forums'
WHERE `log_group` =
'for'
;
UPDATE `cot_logger` SET `log_group` =
'users'
WHERE `log_group` =
'usr'
;
UPDATE `cot_logger` SET `log_group` =
'page'
WHERE `log_group` =
'pag'
;