summaryrefslogtreecommitdiff
path: root/npc/003-3/malindou.txt
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2019-05-27 10:58:07 -0300
committerJesusaves <cpntb1@ymail.com>2019-05-27 10:58:07 -0300
commit46585960fd6f58ecf3ab6990cfe6870718345bb7 (patch)
treee1bbd9eaf89ce752c3993a1da63d4d7e0cd3862d /npc/003-3/malindou.txt
parent5a5cbc24bf12022491901d7a995473527c15f919 (diff)
downloadserverdata-46585960fd6f58ecf3ab6990cfe6870718345bb7.tar.gz
serverdata-46585960fd6f58ecf3ab6990cfe6870718345bb7.tar.bz2
serverdata-46585960fd6f58ecf3ab6990cfe6870718345bb7.tar.xz
serverdata-46585960fd6f58ecf3ab6990cfe6870718345bb7.zip
Fix options on picklog table (using Malindou Update System)
Diffstat (limited to 'npc/003-3/malindou.txt')
-rw-r--r--npc/003-3/malindou.txt13
1 files changed, 13 insertions, 0 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 "";
+ }