diff options
Diffstat (limited to 'sql-files/upgrade_svn10575_log.sql')
| -rw-r--r-- | sql-files/upgrade_svn10575_log.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn10575_log.sql b/sql-files/upgrade_svn10575_log.sql new file mode 100644 index 000000000..d6b4dd680 --- /dev/null +++ b/sql-files/upgrade_svn10575_log.sql @@ -0,0 +1,11 @@ +ALTER TABLE `picklog` CHANGE `type` `type` ENUM( 'M', 'P', 'L', 'T', 'V', 'S', 'N', 'C', 'A', 'R', 'G' ) NOT NULL DEFAULT 'P'; +ALTER TABLE `zenylog` CHANGE `type` `type` ENUM( 'M', 'T', 'V', 'S', 'N', 'A' ) NOT NULL DEFAULT 'S'; +ALTER TABLE `chatlog` CHANGE `type` `type` ENUM( 'W', 'P', 'G' ) NOT NULL DEFAULT 'W'; + +ALTER TABLE `picklog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL; +ALTER TABLE `zenylog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL; +ALTER TABLE `branchlog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL; +ALTER TABLE `mvplog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL; +ALTER TABLE `atcommandlog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL; +ALTER TABLE `npclog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL; +ALTER TABLE `chatlog` CHANGE `src_map` `src_map` VARCHAR( 11 ) NOT NULL; |