root/trunk/AE-go_GameServer/sql/au_server_gs.sql

24132440
189
  `itemLocation` TINYINT(1) DEFAULT '0',
189
  `itemLocation` TINYINT(1) DEFAULT '0',
190
  `enchant` TINYINT(1) DEFAULT '0',
190
  `enchant` TINYINT(1) DEFAULT '0',
191
  `itemSkin`  int(11) NOT NULL DEFAULT 0,
191
  `itemSkin`  int(11) NOT NULL DEFAULT 0,
192
  `fusionedItem` INT(11) NOT NULL DEFAULT '0',
192
  PRIMARY KEY (`itemUniqueId`),
193
  PRIMARY KEY (`itemUniqueId`),
193
  KEY `item_owner`(`itemOwner`),
194
  KEY `item_owner`(`itemOwner`),
194
  KEY `item_location`(`itemLocation`),
195
  KEY `item_location`(`itemLocation`),
...
...
431
  PRIMARY KEY (`player_id`) )
432
  PRIMARY KEY (`player_id`) )
432
ENGINE = MyISAM DEFAULT CHARSET=UTF8;
433
ENGINE = MyISAM DEFAULT CHARSET=UTF8;
433
434
435
434
-- ----------------------------
436
-- ----------------------------
435
-- `siege_locations`
437
-- `siege_locations`
436
-- ----------------------------
438
-- ----------------------------