diff options
| author | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-03-14 21:30:24 +0000 |
|---|---|---|
| committer | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-03-14 21:30:24 +0000 |
| commit | fd3e05f2efdfb6844cb213658213d782cbbd9af2 (patch) | |
| tree | 0f9aa4919f23f8d1941a40776a64226186ef8ce7 | |
| parent | 94b5924852ac0c230317cecc0970cf652bae62f3 (diff) | |
| download | hercules-fd3e05f2efdfb6844cb213658213d782cbbd9af2.tar.gz hercules-fd3e05f2efdfb6844cb213658213d782cbbd9af2.tar.bz2 hercules-fd3e05f2efdfb6844cb213658213d782cbbd9af2.tar.xz hercules-fd3e05f2efdfb6844cb213658213d782cbbd9af2.zip | |
- 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
| -rw-r--r-- | Changelog-Trunk.txt | 2 | ||||
| -rw-r--r-- | sql-files/main.sql | 6 | ||||
| -rw-r--r-- | sql-files/upgrade_svn5607.sql | 1 |
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';
|