summaryrefslogtreecommitdiff
path: root/sql-files/upgrades/2014-09-01--16-53.sql
diff options
context:
space:
mode:
authorMichieru <Michieru@users.noreply.github.com>2014-09-16 14:37:19 +0200
committerMichieru <Michieru@users.noreply.github.com>2014-09-16 14:37:19 +0200
commit807e5b26b5d532a79d147e7710fe326ca95b50ce (patch)
treea75c05eee70c19177fe2ccfbf4bfeabe0b84f169 /sql-files/upgrades/2014-09-01--16-53.sql
parent93df826a51e57710c62c3809b4181c67d7ef6ae1 (diff)
parent435d888eb176e63394aeb5942deaca89e2a4d654 (diff)
downloadhercules-807e5b26b5d532a79d147e7710fe326ca95b50ce.tar.gz
hercules-807e5b26b5d532a79d147e7710fe326ca95b50ce.tar.bz2
hercules-807e5b26b5d532a79d147e7710fe326ca95b50ce.tar.xz
hercules-807e5b26b5d532a79d147e7710fe326ca95b50ce.zip
Merge pull request #333 from dastgir/SQLFix
Fixes wrong data type in SQL for base_exp,base_drop and base_death.
Diffstat (limited to 'sql-files/upgrades/2014-09-01--16-53.sql')
-rw-r--r--sql-files/upgrades/2014-09-01--16-53.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql-files/upgrades/2014-09-01--16-53.sql b/sql-files/upgrades/2014-09-01--16-53.sql
new file mode 100644
index 000000000..9827c002d
--- /dev/null
+++ b/sql-files/upgrades/2014-09-01--16-53.sql
@@ -0,0 +1,5 @@
+#1409590380
+ALTER TABLE `account_data` CHANGE `base_exp` `base_exp` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
+CHANGE `base_drop` `base_drop` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
+CHANGE `base_death` `base_death` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100';
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1409590380);