123456789 |
- CREATE TABLE IF NOT EXISTS `castle_manor_production` (
- `castle_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
- `seed_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `start_amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `price` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `next_period` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
- PRIMARY KEY (`castle_id`, `seed_id`, `next_period`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|