summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--Changelog-Trunk.txt2
-rw-r--r--sql-files/main.sql6
-rw-r--r--sql-files/upgrade_svn5607.sql1
3 files changed, 6 insertions, 3 deletions
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 <NPC_name> (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';