diff options
| -rw-r--r-- | Changelog-Trunk.txt | 1 | ||||
| -rw-r--r-- | sql-files/logs.sql | 8 | ||||
| -rw-r--r-- | sql-files/upgrade_svn11388.sql | 5 |
3 files changed, 10 insertions, 4 deletions
diff --git a/Changelog-Trunk.txt b/Changelog-Trunk.txt index 1031c1a61..2427ed973 100644 --- a/Changelog-Trunk.txt +++ b/Changelog-Trunk.txt @@ -4,6 +4,7 @@ AS OF SVN REV. 5091, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES GO IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK. 2007/10/09 + * Added upgrade_svn11388.sql to correct some log column widths * Corrected string lengths according to bugreport:198 [ultramage] - CHATBOX_SIZE: 70 -> 70+1 - removed some too aggressive checks in clif_parse_globalmessage() diff --git a/sql-files/logs.sql b/sql-files/logs.sql index e6efe7438..0217c4fea 100644 --- a/sql-files/logs.sql +++ b/sql-files/logs.sql @@ -43,7 +43,7 @@ CREATE TABLE `branchlog` ( `branch_date` datetime NOT NULL default '0000-00-00 00:00:00', `account_id` int(11) NOT NULL default '0', `char_id` int(11) NOT NULL default '0', - `char_name` varchar(30) NOT NULL default '', + `char_name` varchar(25) NOT NULL default '', `map` varchar(11) NOT NULL default '', PRIMARY KEY (`branch_id`), INDEX (`account_id`), @@ -70,9 +70,9 @@ CREATE TABLE `atcommandlog` ( `atcommand_date` datetime NOT NULL default '0000-00-00 00:00:00', `account_id` int(11) unsigned NOT NULL default '0', `char_id` int(11) unsigned NOT NULL default '0', - `char_name` varchar(30) NOT NULL default '', + `char_name` varchar(25) NOT NULL default '', `map` varchar(11) NOT NULL default '', - `command` varchar(50) NOT NULL default '', + `command` varchar(255) NOT NULL default '', PRIMARY KEY (`atcommand_id`), INDEX (`account_id`), INDEX (`char_id`) @@ -85,7 +85,7 @@ CREATE TABLE `npclog` ( `npc_date` datetime NOT NULL default '0000-00-00 00:00:00', `account_id` int(11) unsigned NOT NULL default '0', `char_id` int(11) unsigned NOT NULL default '0', - `char_name` varchar(30) NOT NULL default '', + `char_name` varchar(25) NOT NULL default '', `map` varchar(11) NOT NULL default '', `mes` varchar(255) NOT NULL default '', PRIMARY KEY (`npc_id`), diff --git a/sql-files/upgrade_svn11388.sql b/sql-files/upgrade_svn11388.sql new file mode 100644 index 000000000..5393ca861 --- /dev/null +++ b/sql-files/upgrade_svn11388.sql @@ -0,0 +1,5 @@ +ALTER TABLE `atcommandlog` CHANGE `command` `command` VARCHAR( 255 ) NOT NULL;
+ALTER TABLE `atcommandlog` CHANGE `char_name` `char_name` VARCHAR( 25 ) NOT NULL;
+ALTER TABLE `branchlog` CHANGE `char_name` `char_name` VARCHAR( 25 ) NOT NULL;
+ALTER TABLE `npclog` CHANGE `char_name` `char_name` VARCHAR( 25 ) NOT NULL;
+
\ No newline at end of file |