diff options
author | leak <leakzx@googlemail.com> | 2011-03-19 00:23:35 +0100 |
---|---|---|
committer | leak <leakzx@googlemail.com> | 2011-03-19 00:23:35 +0100 |
commit | 6eb5014182a63640e3e3d2a4460aecde83f4d63f (patch) | |
tree | 3da00de74f4d8ce91e0d78d8a3cac37e9f0b9abc | |
parent | 74ae0228493b9ffbb853afd27eac33d105eabc73 (diff) |
SQL: Lost changes in character base sql
-rw-r--r-- | sql/base/characters_database.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index c87c8fa091b..6bbb7c0c078 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -724,7 +724,7 @@ CREATE TABLE `character_inventory` ( `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier', PRIMARY KEY (`item`), - UNIQUE KEY (`guid`,`bag`,`slot`), + UNIQUE KEY `guid` (`guid`,`bag`,`slot`), KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1285,10 +1285,10 @@ DROP TABLE IF EXISTS `game_event_condition_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_condition_save` ( - `event_id` smallint(5) unsigned NOT NULL, + `eventEntry` tinyint(3) unsigned NOT NULL, `condition_id` int(10) unsigned NOT NULL DEFAULT '0', `done` float DEFAULT '0', - PRIMARY KEY (`event_id`,`condition_id`) + PRIMARY KEY (`eventEntry`,`condition_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1309,10 +1309,10 @@ DROP TABLE IF EXISTS `game_event_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_save` ( - `event_id` smallint(5) unsigned NOT NULL, + `eventEntry` tinyint(3) unsigned NOT NULL, `state` tinyint(3) unsigned NOT NULL DEFAULT '1', `next_start` int(10) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`event_id`) + PRIMARY KEY (`eventEntry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; |