| 123456789101112131415161718192021222324 |
- ALTER TABLE `characters`
- ADD KEY `account_name` (`account_name`),
- ADD KEY `char_name` (`char_name`),
- ADD KEY `online` (`online`);
- ALTER TABLE `clan_subpledges`
- ADD KEY `leader_id` (`leader_id`);
- ALTER TABLE `clanhall`
- ADD KEY `ownerId` (`ownerId`);
- ALTER TABLE `clan_wars`
- ADD KEY `clan1` (`clan1`),
- ADD KEY `clan2` (`clan2`);
- ALTER TABLE `items`
- DROP KEY `key_owner_id`,
- DROP KEY `key_loc`,
- DROP KEY `key_item_id`,
- DROP KEY `key_time_of_use`,
- ADD KEY `owner_id` (`owner_id`),
- ADD KEY `item_id` (`item_id`),
- ADD KEY `loc` (`loc`),
- ADD KEY `time_of_use` (`time_of_use`);
|
