summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
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/main.sql
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/main.sql')
-rw-r--r--sql-files/main.sql7
1 files changed, 4 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`