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 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'npc/003-3/malindou.txt') 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 ""; + } -- cgit v1.2.3-60-g2f50