diff options
| author | Jesusaves <cpntb1@ymail.com> | 2019-05-27 10:58:07 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2019-05-27 10:58:07 -0300 |
| commit | 46585960fd6f58ecf3ab6990cfe6870718345bb7 (patch) | |
| tree | e1bbd9eaf89ce752c3993a1da63d4d7e0cd3862d | |
| parent | 5a5cbc24bf12022491901d7a995473527c15f919 (diff) | |
| download | serverdata-46585960fd6f58ecf3ab6990cfe6870718345bb7.tar.gz serverdata-46585960fd6f58ecf3ab6990cfe6870718345bb7.tar.bz2 serverdata-46585960fd6f58ecf3ab6990cfe6870718345bb7.tar.xz serverdata-46585960fd6f58ecf3ab6990cfe6870718345bb7.zip | |
Fix options on picklog table (using Malindou Update System)
| -rw-r--r-- | npc/003-3/malindou.txt | 13 | ||||
| -rw-r--r-- | 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`), |