castle_manor_production.sql 467 B

123456789
  1. CREATE TABLE IF NOT EXISTS `castle_manor_production` (
  2. `castle_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  3. `seed_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  4. `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  5. `start_amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  6. `price` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  7. `next_period` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
  8. PRIMARY KEY (`castle_id`, `seed_id`, `next_period`)
  9. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;