diff options
| author | Paradox924X <Paradox924X@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2010-02-09 20:26:42 +0000 |
|---|---|---|
| committer | Paradox924X <Paradox924X@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2010-02-09 20:26:42 +0000 |
| commit | 0034a439b74142f27a93b422ef66eaa90ddb7ab3 (patch) | |
| tree | 560d2c8f405398602ab425d3c97ab3acd3c96d65 /sql-files | |
| parent | 321fad2e5e3ceff3f624d124565b22ca9868db9f (diff) | |
| download | hercules-0034a439b74142f27a93b422ef66eaa90ddb7ab3.tar.gz hercules-0034a439b74142f27a93b422ef66eaa90ddb7ab3.tar.bz2 hercules-0034a439b74142f27a93b422ef66eaa90ddb7ab3.tar.xz hercules-0034a439b74142f27a93b422ef66eaa90ddb7ab3.zip | |
Expanded range for cached and stored-in-db guild member exp (devotion) from uint32 to uint64. (bugreport:3983)
Capped value when sending to client to INT_MAX to prevent confusion.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14242 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 2 | ||||
| -rw-r--r-- | sql-files/upgrade_svn14241.sql | 1 |
2 files changed, 2 insertions, 1 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index 2e1663416..f67bfd2d8 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -182,7 +182,7 @@ CREATE TABLE IF NOT EXISTS `guild` ( `connect_member` tinyint(6) unsigned NOT NULL default '0', `max_member` tinyint(6) unsigned NOT NULL default '0', `average_lv` smallint(6) unsigned NOT NULL default '1', - `exp` int(11) unsigned NOT NULL default '0', + `exp` bigint(20) unsigned NOT NULL default '0', `next_exp` int(11) unsigned NOT NULL default '0', `skill_point` tinyint(11) unsigned NOT NULL default '0', `mes1` varchar(60) NOT NULL default '', diff --git a/sql-files/upgrade_svn14241.sql b/sql-files/upgrade_svn14241.sql new file mode 100644 index 000000000..2c1b9c5f7 --- /dev/null +++ b/sql-files/upgrade_svn14241.sql @@ -0,0 +1 @@ +ALTER TABLE `guild` MODIFY COLUMN `exp` bigint(20) unsigned NOT NULL default '0';
\ No newline at end of file |