diff options
| author | Michieru <Michieru@users.noreply.github.com> | 2014-09-16 14:37:19 +0200 |
|---|---|---|
| committer | Michieru <Michieru@users.noreply.github.com> | 2014-09-16 14:37:19 +0200 |
| commit | 807e5b26b5d532a79d147e7710fe326ca95b50ce (patch) | |
| tree | a75c05eee70c19177fe2ccfbf4bfeabe0b84f169 | |
| parent | 93df826a51e57710c62c3809b4181c67d7ef6ae1 (diff) | |
| parent | 435d888eb176e63394aeb5942deaca89e2a4d654 (diff) | |
| download | hercules-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.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 |