summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-10-09 20:09:15 +0000
committerultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-10-09 20:09:15 +0000
commit1f2adf107c39557a78283c21a345cadea4ab87f3 (patch)
tree8e7cfc0d16c97f709e2a261be54d95fd8b60dd91
parentc7f85f773385bb61a6eedcf8d8206ee14386377e (diff)
downloadhercules-1f2adf107c39557a78283c21a345cadea4ab87f3.tar.gz
hercules-1f2adf107c39557a78283c21a345cadea4ab87f3.tar.bz2
hercules-1f2adf107c39557a78283c21a345cadea4ab87f3.tar.xz
hercules-1f2adf107c39557a78283c21a345cadea4ab87f3.zip
Added upgrade_svn11388.sql to correct some log table column widths (for example, atcommandlog only stored first 50 chars)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11388 54d463be-8e91-2dee-dedb-b68131a5f0ec
-rw-r--r--Changelog-Trunk.txt1
-rw-r--r--sql-files/logs.sql8
-rw-r--r--sql-files/upgrade_svn11388.sql5
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