summaryrefslogtreecommitdiff
path: root/sql-files/upgrades
diff options
context:
space:
mode:
authorDastgir <dastgirpojee@rocketmail.com>2014-09-01 16:57:17 +0530
committerDastgir <dastgirpojee@rocketmail.com>2014-09-02 20:51:43 +0530
commit435d888eb176e63394aeb5942deaca89e2a4d654 (patch)
tree58b12013ab2d102642767bac496390d0146aeec2 /sql-files/upgrades
parent2461d8005cd13d8ddbe0e091612d3570f41cebc3 (diff)
downloadhercules-435d888eb176e63394aeb5942deaca89e2a4d654.tar.gz
hercules-435d888eb176e63394aeb5942deaca89e2a4d654.tar.bz2
hercules-435d888eb176e63394aeb5942deaca89e2a4d654.tar.xz
hercules-435d888eb176e63394aeb5942deaca89e2a4d654.zip
Fixes wrong data type in SQL for base_exp,base_drop and base_death.
Diffstat (limited to 'sql-files/upgrades')
-rw-r--r--sql-files/upgrades/2014-09-01--16-53.sql5
-rw-r--r--sql-files/upgrades/index.txt1
2 files changed, 6 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);
diff --git a/sql-files/upgrades/index.txt b/sql-files/upgrades/index.txt
index ab8ee772d..a31eff539 100644
--- a/sql-files/upgrades/index.txt
+++ b/sql-files/upgrades/index.txt
@@ -23,3 +23,4 @@
2014-04-07--22-04.sql
2014-04-26--10-00.sql
2014-05-17--00-06.sql
+2014-09-01--16-53.sql