From 1f2adf107c39557a78283c21a345cadea4ab87f3 Mon Sep 17 00:00:00 2001 From: ultramage Date: Tue, 9 Oct 2007 20:09:15 +0000 Subject: 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 --- sql-files/logs.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'sql-files/logs.sql') 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`), -- cgit v1.2.3-70-g09d2