summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
diff options
context:
space:
mode:
authorskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-03-14 21:30:24 +0000
committerskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-03-14 21:30:24 +0000
commitfd3e05f2efdfb6844cb213658213d782cbbd9af2 (patch)
tree0f9aa4919f23f8d1941a40776a64226186ef8ce7 /sql-files/main.sql
parent94b5924852ac0c230317cecc0970cf652bae62f3 (diff)
downloadhercules-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
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r--sql-files/main.sql6
1 files changed, 3 insertions, 3 deletions
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',