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 --- Changelog-Trunk.txt | 2 ++ sql-files/main.sql | 6 +++--- sql-files/upgrade_svn5607.sql | 1 + 3 files changed, 6 insertions(+), 3 deletions(-) create mode 100644 sql-files/upgrade_svn5607.sql diff --git a/Changelog-Trunk.txt b/Changelog-Trunk.txt index 1803b22ab..9dcb793ed 100644 --- a/Changelog-Trunk.txt +++ b/Changelog-Trunk.txt @@ -5,6 +5,8 @@ IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK. EV GOES INTO TRUNK AND WILL BE MERGED INTO STABLE BY VALARIS AND WIZPUTER. -- VALARIS 2006/03/14 + * Fixed the average_lv column size specification for levels above 255. + Thanks to Joshuaali (upgrade_svn5607.sql) [Skotlex] * Updated @rura/@warp. Now you can use both "@warp mapname x y" and "@warp mapname,x,y". [LuzZza] * Added at-command @tonpc (warp to NPC). [LuzZza] 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-70-g09d2