From 435d888eb176e63394aeb5942deaca89e2a4d654 Mon Sep 17 00:00:00 2001 From: Dastgir Date: Mon, 1 Sep 2014 16:57:17 +0530 Subject: Fixes wrong data type in SQL for base_exp,base_drop and base_death. --- sql-files/main.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'sql-files/main.sql') 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` -- cgit v1.2.3-70-g09d2