From f62ce0c0bae2c1b674aca5c1d7918ec97d9a7a74 Mon Sep 17 00:00:00 2001 From: Haru Date: Thu, 17 Jul 2014 21:32:55 +0200 Subject: Fixed minor issues in the sql files from 3ecf877b Signed-off-by: Haru --- sql-files/logs.sql | 36 ++++++++++++++++++------------------ sql-files/main.sql | 22 +++++++++++----------- 2 files changed, 29 insertions(+), 29 deletions(-) (limited to 'sql-files') diff --git a/sql-files/logs.sql b/sql-files/logs.sql index 3d5f56710..fe875ec62 100644 --- a/sql-files/logs.sql +++ b/sql-files/logs.sql @@ -1,22 +1,22 @@ -- PickLog Types --- (M)onsters Drop --- (P)layers Drop/Take --- Mobs Drop (L)oot Drop/Take --- Players (T)rade Give/Take --- Players (V)ending Sell/Take --- (S)hop Sell/Take --- (N)PC Give/Take --- (C)onsumable Items --- (A)dministrators Create/Delete --- Sto(R)age --- (G)uild Storage --- (E)mail attachment --- (B)uying Store --- Pr(O)duced Items/Ingredients --- Auct(I)oned Items --- (X) Other --- (D) Stolen from mobs --- (U) MVP Prizes +-- (M)onsters Drop +-- (P)layers Drop/Take +-- Mobs Drop (L)oot Drop/Take +-- Players (T)rade Give/Take +-- Players (V)ending Sell/Take +-- (S)hop Sell/Take +-- (N)PC Give/Take +-- (C)onsumable Items +-- (A)dministrators Create/Delete +-- Sto(R)age +-- (G)uild Storage +-- (E)mail attachment +-- (B)uying Store +-- Pr(O)duced Items/Ingredients +-- Auct(I)oned Items +-- (X) Other +-- (D) Stolen from mobs +-- (U) MVP Prizes -- -- Table structure for table `atcommandlog` diff --git a/sql-files/main.sql b/sql-files/main.sql index 22cba1660..68b7fb52a 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -271,12 +271,12 @@ CREATE TABLE IF NOT EXISTS `friends` ( -- CREATE TABLE IF NOT EXISTS `hotkey` ( - `char_id` INT(11) NOT NULL, - `hotkey` TINYINT(2) UNSIGNED NOT NULL, - `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `itemskill_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', - `skill_lvl` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', - PRIMARY KEY (`char_id`,`hotkey`) + `char_id` INT(11) NOT NULL, + `hotkey` TINYINT(2) UNSIGNED NOT NULL, + `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `itemskill_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `skill_lvl` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`char_id`,`hotkey`) ) ENGINE=MyISAM; -- @@ -485,16 +485,16 @@ CREATE TABLE IF NOT EXISTS `homunculus` ( ) ENGINE=MyISAM; -- --- Table structure for table `INTerlog` +-- Table structure for table `interlog` -- -CREATE TABLE IF NOT EXISTS `INTerlog` ( +CREATE TABLE IF NOT EXISTS `interlog` ( `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `log` VARCHAR(255) NOT NULL DEFAULT '' ) ENGINE=MyISAM; -- --- Table structure for table `INTerreg` +-- Table structure for table `interreg` -- CREATE TABLE IF NOT EXISTS `interreg` ( @@ -566,7 +566,7 @@ CREATE TABLE IF NOT EXISTS `login` ( ) ENGINE=MyISAM AUTO_INCREMENT=2000000; -- added standard accounts for servers, VERY INSECURE!!! --- inserted INTo the table called login which is above +-- inserted into the table called login which is above INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','athena@athena.com'); @@ -710,7 +710,7 @@ CREATE TABLE IF NOT EXISTS `pet` ( `level` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', `egg_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0', `equip` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', - `INTimate` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0', + `intimate` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0', `hungry` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0', `rename_flag` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', `incubate` INT(11) UNSIGNED NOT NULL DEFAULT '0', -- cgit v1.2.3-70-g09d2