summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/main.sql2
-rw-r--r--sql-files/upgrade_svn14241.sql1
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