From 46585960fd6f58ecf3ab6990cfe6870718345bb7 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Mon, 27 May 2019 10:58:07 -0300 Subject: Fix options on picklog table (using Malindou Update System) --- npc/003-3/malindou.txt | 13 +++++++++++++ sql-files/logs.sql | 10 +++++----- 2 files changed, 18 insertions(+), 5 deletions(-) diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt index 0db36d497..d6869a68e 100644 --- a/npc/003-3/malindou.txt +++ b/npc/003-3/malindou.txt @@ -343,7 +343,20 @@ OnInit: debugmes "* Shovel Update"; debugmes ""; } + // Current UPDATE value: Seg mai 27 10:57:02 -03 2019 + // Shovel Update + if ($UPDATE < 1558965422) { + query_sql("ALTER TABLE picklog MODIFY COLUMN `opt_val0` SMALLINT(5) NOT NULL DEFAULT '0';"); + query_sql("ALTER TABLE picklog MODIFY COLUMN `opt_val1` SMALLINT(5) NOT NULL DEFAULT '0';"); + query_sql("ALTER TABLE picklog MODIFY COLUMN `opt_val2` SMALLINT(5) NOT NULL DEFAULT '0';"); + query_sql("ALTER TABLE picklog MODIFY COLUMN `opt_val3` SMALLINT(5) NOT NULL DEFAULT '0';"); + query_sql("ALTER TABLE picklog MODIFY COLUMN `opt_val4` SMALLINT(5) NOT NULL DEFAULT '0';"); + $UPDATE=1558965422; + debugmes ""; + debugmes "* picklog options Update"; + debugmes ""; + } diff --git a/sql-files/logs.sql b/sql-files/logs.sql index 6edf385a2..bee14f4b4 100644 --- a/sql-files/logs.sql +++ b/sql-files/logs.sql @@ -153,15 +153,15 @@ CREATE TABLE IF NOT EXISTS `picklog` ( `card2` INT(11) NOT NULL DEFAULT '0', `card3` INT(11) NOT NULL DEFAULT '0', `opt_idx0` smallint(5) unsigned NOT NULL default '0', - `opt_val0` smallint(5) unsigned NOT NULL default '0', + `opt_val0` smallint(5) NOT NULL default '0', `opt_idx1` smallint(5) unsigned NOT NULL default '0', - `opt_val1` smallint(5) unsigned NOT NULL default '0', + `opt_val1` smallint(5) NOT NULL default '0', `opt_idx2` smallint(5) unsigned NOT NULL default '0', - `opt_val2` smallint(5) unsigned NOT NULL default '0', + `opt_val2` smallint(5) NOT NULL default '0', `opt_idx3` smallint(5) unsigned NOT NULL default '0', - `opt_val3` smallint(5) unsigned NOT NULL default '0', + `opt_val3` smallint(5) NOT NULL default '0', `opt_idx4` smallint(5) unsigned NOT NULL default '0', - `opt_val4` smallint(5) unsigned NOT NULL default '0', + `opt_val4` smallint(5) NOT NULL default '0', `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `map` VARCHAR(11) NOT NULL DEFAULT '', PRIMARY KEY (`id`), -- cgit v1.2.3-60-g2f50