From f62ce0c0bae2c1b674aca5c1d7918ec97d9a7a74 Mon Sep 17 00:00:00 2001
From: Haru <haru@dotalux.com>
Date: Thu, 17 Jul 2014 21:32:55 +0200
Subject: Fixed minor issues in the sql files from 3ecf877b

Signed-off-by: Haru <haru@dotalux.com>
---
 sql-files/main.sql | 22 +++++++++++-----------
 1 file changed, 11 insertions(+), 11 deletions(-)

(limited to 'sql-files/main.sql')

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

