summaryrefslogtreecommitdiff
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
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.
-rw-r--r--sql-files/main.sql7
-rw-r--r--sql-files/upgrades/2014-09-01--16-53.sql5
-rw-r--r--sql-files/upgrades/index.txt1
3 files changed, 10 insertions, 3 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql
index 68b7fb52a..934b406a8 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -5,9 +5,9 @@
CREATE TABLE IF NOT EXISTS `account_data` (
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`bank_vault` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `base_exp` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100',
- `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100',
- `base_death` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100',
+ `base_exp` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
+ `base_drop` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
+ `base_death` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '100',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
@@ -805,6 +805,7 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1395789302); -- 2014-03-25--23-5
INSERT INTO `sql_updates` (`timestamp`) VALUES (1396893866); -- 2014-04-07--22-04.sql
INSERT INTO `sql_updates` (`timestamp`) VALUES (1398477600); -- 2014-04-26--10-00.sql
INSERT INTO `sql_updates` (`timestamp`) VALUES (1400256139); -- 2014-05-17--00-06.sql
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1409590380); -- 2014-09-01--16-53.sql
--
-- Table structure for table `sstatus`
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