summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql-files/logs.sql36
-rw-r--r--sql-files/main.sql22
2 files changed, 29 insertions, 29 deletions
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',