upgrade_20190309.sql 309 B

123456789101112
  1. ALTER TABLE `pet`
  2. ADD COLUMN `autofeed` tinyint(2) NOT NULL default '0' AFTER `incubate`;
  3. UPDATE `inventory` `i`
  4. INNER JOIN `char` `c`
  5. ON `i`.`char_id` = `c`.`char_id` AND `c`.`pet_id` <> '0'
  6. SET `i`.`attribute` = '1'
  7. WHERE
  8. `i`.`card0` = '256'
  9. AND
  10. ( `i`.`card1` | ( `i`.`card2` << 16 ) ) = `c`.`pet_id`
  11. ;