summaryrefslogtreecommitdiff
path: root/sql-files
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
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')
-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