public static function checkColumn($table, $colum, $type, $default = false, $resetType = false)
{
$ehztyhugkvw = "colum";
${"GLOBALS"}["dgynoonp"] = "table";
${"GLOBALS"}["jclyabjwwyg"] = "resetType";
global $adb;
${"GLOBALS"}["lmlixtkzk"] = "result";
if (!\Workflow\DbCheck::existTable(${${"GLOBALS"}["dgynoonp"]})) {
return false;
}
${${"GLOBALS"}["lmlixtkzk"]} = $adb->query("SHOW COLUMNS FROM `" . ${${"GLOBALS"}["rkciyixds"]} . "` LIKE '" . ${$ehztyhugkvw} . "'");
${${"GLOBALS"}["fdpssjepgg"]} = $adb->num_rows(${${"GLOBALS"}["mvyuejx"]}) ? true : false;
if (${${"GLOBALS"}["fdpssjepgg"]} == false) {
$qywtoe = "colum";
$fvgect = "default";
${"GLOBALS"}["qfykztjfwn"] = "colum";
echo "Add column '" . ${${"GLOBALS"}["rkciyixds"]} . "'.'" . ${$qywtoe} . "'<br>";
$adb->query("ALTER TABLE `" . ${${"GLOBALS"}["rkciyixds"]} . "` ADD `" . ${${"GLOBALS"}["qfykztjfwn"]} . "` " . ${${"GLOBALS"}["phkafcwyo"]} . " NOT NULL" . (${${"GLOBALS"}["dqmubcyqohqb"]} !== false ? " DEFAULT '" . ${$fvgect} . "'" : ""), false);
} elseif (${${"GLOBALS"}["jclyabjwwyg"]} == true) {
${${"GLOBALS"}["eaulupt"]} = strtolower(html_entity_decode($adb->query_result(${${"GLOBALS"}["mvyuejx"]}, 0, "type"), ENT_QUOTES));
${${"GLOBALS"}["eaulupt"]} = str_replace(" ", "", ${${"GLOBALS"}["eaulupt"]});
if (${${"GLOBALS"}["eaulupt"]} != strtolower(str_replace(" ", "", ${${"GLOBALS"}["phkafcwyo"]}))) {
$zwhgmqncy = "colum";
$lceffvyvez = "type";
$oomxuzd = "sql";
${${"GLOBALS"}["ztjqjrf"]} = "ALTER TABLE `" . ${${"GLOBALS"}["rkciyixds"]} . "` CHANGE `" . ${$zwhgmqncy} . "` `" . ${${"GLOBALS"}["cqojoiyxp"]} . "` " . ${$lceffvyvez} . ";";
$adb->query(${$oomxuzd});
}
}
return ${${"GLOBALS"}["fdpssjepgg"]};
}
}
if (!\Workflow\DbCheck::existTable("vtiger_wf_http_limits_value")) {
echo "Create table vtiger_wf_http_limits_value ... ok<br>";
$adb->query("CREATE TABLE IF NOT EXISTS `vtiger_wf_http_limits_value` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `limit_id` int(10) unsigned NOT NULL,\n `mode` enum('all','trigger','id') NOT NULL,\n `value` varchar(64) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `mode` (`mode`,`value`)\n ) ENGINE = INNODB;");
}
if (!\Workflow\DbCheck::existTable("vtiger_wf_objects")) {
echo "Create table vtiger_wf_objects ... ok<br>";
$adb->query("CREATE TABLE IF NOT EXISTS `vtiger_wf_objects` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `x` int(11) NOT NULL,\n `y` int(11) NOT NULL,\n `type` VARCHAR( 12 ) NOT NULL,\n `content` text NOT NULL,\n `workflow_id` int(11) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `workflow_id` (`workflow_id`)\n ) ENGINE=INNODB ;");
}
if (!\Workflow\DbCheck::existTable("vtiger_wf_repository")) {
${"GLOBALS"}["polhtlrmg"] = "initRepository";
echo "Create table vtiger_wf_repository ... ok<br>";
$adb->query("CREATE TABLE IF NOT EXISTS `vtiger_wf_repository` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(128) NOT NULL,\n `url` varchar(256) NOT NULL,\n `licenseCode` varchar(40) NOT NULL,\n `last_update` datetime NOT NULL,\n `messages` text NOT NULL,\n `available_status` varchar(64) NOT NULL,\n `status` varchar(12) NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB;");
${${"GLOBALS"}["polhtlrmg"]} = true;
}
if (!\Workflow\DbCheck::existTable("vtiger_wf_repository_types")) {
echo "Create table vtiger_wf_repository_types ... ok<br>";
$adb->query("CREATE TABLE IF NOT EXISTS `vtiger_wf_repository_types` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `repos_id` int(11) NOT NULL,\n `min_version` double NOT NULL,\n `name` varchar(64) NOT NULL,\n `version` int(10) unsigned NOT NULL,\n `last_update` datetime NOT NULL,\n `url` varchar(255) NOT NULL,\n `checksum` text NOT NULL,\n `mode` varchar(16) NOT NULL,\n `autoinstall` tinyint(4) NOT NULL,\n `status` varchar(12) NOT NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY `repos_id` (`repos_id`,`name`)\n ) ENGINE=InnoDB");
}
${${"GLOBALS"}["trksdsce"]} = "SELECT * FROM vtiger_wf_config";
$xwumsixdl = "result";
${${"GLOBALS"}["kkktjzvrc"]} = $adb->query(${${"GLOBALS"}["trksdsce"]});
if ($adb->num_rows(${$wnwmzpt}) == 0) {
$adb->query("INSERT INTO `vtiger_wf_config` (`id`, `version`, `license`, `last_hash`, `config`) VALUES (1, " . Workflow2::VERSION . ", 'free', 'free', '');");
}
${"GLOBALS"}["gegcyny"] = "sql";
if ($adb->num_rows(${$xwumsixdl}) > 1) {
$adb->query("DELETE FROM `vtiger_wf_config` ORDER BY license LIMIT " . ($adb->num_rows(${${"GLOBALS"}["kkktjzvrc"]}) - 1));
}
\Workflow\DbCheck::checkColumn("vtiger_wf_messages", "target", "ENUM( 'record', 'user' )", "record");
\Workflow\DbCheck::checkColumn("vtiger_wf_repository", "messages", "text");