diff options
| author | Dastgir <dastgirpojee@rocketmail.com> | 2014-09-01 16:57:17 +0530 |
|---|---|---|
| committer | Dastgir <dastgirpojee@rocketmail.com> | 2014-09-02 20:51:43 +0530 |
| commit | 435d888eb176e63394aeb5942deaca89e2a4d654 (patch) | |
| tree | 58b12013ab2d102642767bac496390d0146aeec2 | |
| parent | 2461d8005cd13d8ddbe0e091612d3570f41cebc3 (diff) | |
| download | hercules-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.
| -rw-r--r-- | sql-files/main.sql | 7 | ||||
| -rw-r--r-- | sql-files/upgrades/2014-09-01--16-53.sql | 5 | ||||
| -rw-r--r-- | sql-files/upgrades/index.txt | 1 |
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 |