From fd3e05f2efdfb6844cb213658213d782cbbd9af2 Mon Sep 17 00:00:00 2001 From: skotlex Date: Tue, 14 Mar 2006 21:30:24 +0000 Subject: - Fixed the average_lv column size specification. Thanks to Joshuaali (upgrade_svn5607.sql) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5603 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/main.sql | 6 +++--- sql-files/upgrade_svn5607.sql | 1 + 2 files changed, 4 insertions(+), 3 deletions(-) create mode 100644 sql-files/upgrade_svn5607.sql (limited to 'sql-files') diff --git a/sql-files/main.sql b/sql-files/main.sql index 49f056e6c..f60f36594 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -34,8 +34,8 @@ CREATE TABLE `char` ( `char_num` tinyint(1) NOT NULL default '0', `name` varchar(30) NOT NULL default '', `class` smallint(6) unsigned NOT NULL default '0', - `base_level` smallint(20) unsigned NOT NULL default '1', - `job_level` smallint(20) unsigned NOT NULL default '1', + `base_level` smallint(6) unsigned NOT NULL default '1', + `job_level` smallint(6) unsigned NOT NULL default '1', `base_exp` bigint(20) unsigned NOT NULL default '0', `job_exp` bigint(20) unsigned NOT NULL default '0', `zeny` int(11) unsigned NOT NULL default '0', @@ -143,7 +143,7 @@ CREATE TABLE `guild` ( `guild_lv` tinyint(6) unsigned NOT NULL default '0', `connect_member` tinyint(6) unsigned NOT NULL default '0', `max_member` tinyint(6) unsigned NOT NULL default '0', - `average_lv` tinyint(6) unsigned NOT NULL default '0', + `average_lv` smallint(6) unsigned NOT NULL default '1', `exp` int(11) unsigned NOT NULL default '0', `next_exp` int(11) unsigned NOT NULL default '0', `skill_point` tinyint(11) unsigned NOT NULL default '0', diff --git a/sql-files/upgrade_svn5607.sql b/sql-files/upgrade_svn5607.sql new file mode 100644 index 000000000..7c3f88527 --- /dev/null +++ b/sql-files/upgrade_svn5607.sql @@ -0,0 +1 @@ +ALTER TABLE `guild` MODIFY `average_lv` smallint(6) unsigned NOT NULL default '1'; -- cgit v1.2.3-60-g2f50