castle_manor_procure.sql 436 B

12345678910
  1. CREATE TABLE IF NOT EXISTS `castle_manor_procure` (
  2. `castle_id` INT NOT NULL DEFAULT '0',
  3. `crop_id` int(11) NOT NULL DEFAULT '0',
  4. `can_buy` int(11) NOT NULL DEFAULT '0',
  5. `start_buy` int(11) NOT NULL DEFAULT '0',
  6. `price` int(11) NOT NULL DEFAULT '0',
  7. `reward_type` int(11) NOT NULL DEFAULT '0',
  8. `period` INT NOT NULL DEFAULT '1',
  9. PRIMARY KEY (`castle_id`,`crop_id`,`period`)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;