--- schema: procedures: {} tables: ai_battle_summary: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - attacking_empire_id match_type: '' name: ai_battle_summary_fk_attacking_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - defending_empire_id match_type: '' name: ai_battle_summary_fk_defending_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: attack_spy_hours: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attack_spy_hours order: 6 size: - 11 attack_victories: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attack_victories order: 4 size: - 11 attacking_empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_empire_id order: 2 size: - 11 defending_empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_empire_id order: 3 size: - 11 defense_victories: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_victories order: 5 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 indices: - fields: - attacking_empire_id name: ai_battle_summary_idx_attacking_empire_id options: [] type: NORMAL - fields: - defending_empire_id name: ai_battle_summary_idx_defending_empire_id options: [] type: NORMAL name: ai_battle_summary options: [] order: 34 ai_scratch_pad: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - ai_empire_id match_type: '' name: ai_scratch_pad_fk_ai_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: ai_empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ai_empire_id order: 2 size: - 11 body_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: body_id order: 3 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 pad: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: pad order: 4 size: - 0 indices: - fields: - ai_empire_id name: ai_scratch_pad_idx_ai_empire_id options: [] type: NORMAL name: ai_scratch_pad options: [] order: 35 alliance: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - leader_id match_type: '' name: alliance_fk_leader_id on_delete: SET NULL on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: announcements: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: announcements order: 6 size: - 0 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 7 size: - 0 description: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: description order: 5 size: - 0 forum_uri: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: forum_uri order: 4 size: - 255 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 image: data_type: varchar default_value: default is_nullable: 0 is_primary_key: 0 is_unique: 0 name: image order: 9 size: - 255 leader_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: leader_id order: 3 size: - 11 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 stash: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: stash order: 8 size: - 0 indices: - fields: - leader_id name: alliance_idx_leader_id options: [] type: NORMAL name: alliance options: [] order: 29 alliance_invite: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - alliance_id match_type: '' name: alliance_invite_fk_alliance_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: alliance type: FOREIGN KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: alliance_invite_fk_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: alliance_id order: 2 size: - 0 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 4 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 indices: - fields: - alliance_id name: alliance_invite_idx_alliance_id options: [] type: NORMAL - fields: - empire_id name: alliance_invite_idx_empire_id options: [] type: NORMAL name: alliance_invite options: [] order: 36 alliance_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: alliance_id order: 3 size: - 0 alliance_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: alliance_name order: 4 size: - 30 average_building_level: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_building_level order: 17 size: - 5 - 2 average_empire_size: data_type: bigint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_empire_size order: 13 size: - 0 average_empire_size_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_empire_size_rank order: 14 size: - 0 average_university_level: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_university_level order: 15 size: - 5 - 2 building_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: building_count order: 16 size: - 0 colony_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: colony_count order: 10 size: - 0 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 defense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate order: 21 size: - 6 - 6 defense_success_rate_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate_rank order: 22 size: - 11 dirtiest: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest order: 23 size: - 11 dirtiest_rank: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_rank order: 24 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 influence: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: influence order: 8 size: - 0 influence_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: influence_rank order: 9 size: - 0 member_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: member_count order: 5 size: - 0 offense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate order: 19 size: - 6 - 6 offense_success_rate_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate_rank order: 20 size: - 11 population: data_type: bigint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population order: 11 size: - 0 population_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population_rank order: 12 size: - 0 space_station_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: space_station_count order: 6 size: - 0 space_station_count_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: space_station_count_rank order: 7 size: - 0 spy_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_count order: 18 size: - 11 indices: - fields: - average_empire_size_rank name: idx_average_empire_size_rank options: [] type: NORMAL - fields: - offense_success_rate_rank name: idx_offense_success_rate_rank options: [] type: NORMAL - fields: - defense_success_rate_rank name: idx_defense_success_rate_rank options: [] type: NORMAL - fields: - dirtiest_rank name: idx_dirtiest_rank options: [] type: NORMAL - fields: - population_rank name: idx_population_rank options: [] type: NORMAL - fields: - influence_rank name: idx_influence_rank options: [] type: NORMAL name: alliance_log options: [] order: 1 api_key: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 email: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: email order: 7 size: - 255 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 ip_address: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: ip_address order: 6 size: - 15 name: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: name order: 5 size: - 30 private_key: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: private_key order: 4 size: - 36 public_key: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: public_key order: 3 size: - 36 indices: - fields: - private_key name: idx_private_key options: [] type: NORMAL - fields: - public_key name: idx_public_key options: [] type: NORMAL name: api_key options: [] order: 2 battle_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: attacked_body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacked_body_id order: 18 size: - 11 attacked_body_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacked_body_name order: 19 size: - 30 attacked_empire_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: attacked_empire_id order: 20 size: - 11 attacked_empire_name: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: attacked_empire_name order: 21 size: - 30 attacking_body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_body_id order: 5 size: - 11 attacking_body_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_body_name order: 6 size: - 30 attacking_empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_empire_id order: 3 size: - 11 attacking_empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_empire_name order: 4 size: - 30 attacking_number: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_number order: 9 size: - 11 attacking_type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_type order: 8 size: - 60 attacking_unit_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_unit_name order: 7 size: - 60 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 defending_body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_body_id order: 12 size: - 11 defending_body_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_body_name order: 13 size: - 30 defending_empire_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: defending_empire_id order: 10 size: - 11 defending_empire_name: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: defending_empire_name order: 11 size: - 30 defending_number: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_number order: 16 size: - 11 defending_type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_type order: 15 size: - 60 defending_unit_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_unit_name order: 14 size: - 60 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 victory_to: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: victory_to order: 17 size: - 8 indices: - fields: - date_stamp name: idx_datestamp options: [] type: NORMAL - fields: - attacking_empire_id name: idx_attacking_empire_id options: [] type: NORMAL - fields: - attacking_empire_name name: idx_attacking_empire_name options: [] type: NORMAL - fields: - attacking_body_id name: idx_attacking_body_id options: [] type: NORMAL - fields: - attacking_body_name name: idx_attacking_body_name options: [] type: NORMAL - fields: - defending_empire_id name: idx_defending_empire_id options: [] type: NORMAL - fields: - defending_empire_name name: idx_defending_empire_name options: [] type: NORMAL - fields: - defending_body_id name: idx_defending_body_id options: [] type: NORMAL - fields: - defending_body_name name: idx_defending_body_name options: [] type: NORMAL name: battle_log options: [] order: 3 body: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - alliance_id match_type: '' name: body_fk_alliance_id on_delete: SET NULL on_update: '' options: [] reference_fields: - id reference_table: alliance type: FOREIGN KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: body_fk_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - star_id match_type: '' name: body_fk_star_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY fields: algae_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: algae_production_hour order: 84 size: - 0 algae_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: algae_stored order: 108 size: - 0 alliance_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: alliance_id order: 7 size: - 0 anthracite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: anthracite_hour order: 60 size: - 0 anthracite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: anthracite_stored order: 40 size: - 0 apple_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: apple_production_hour order: 72 size: - 0 apple_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: apple_stored order: 96 size: - 0 bauxite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bauxite_hour order: 53 size: - 0 bauxite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bauxite_stored order: 33 size: - 0 bean_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bean_production_hour order: 90 size: - 0 bean_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bean_stored order: 93 size: - 0 beetle_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: beetle_production_hour order: 89 size: - 0 beetle_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: beetle_stored order: 113 size: - 0 beryl_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: beryl_hour order: 65 size: - 0 beryl_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: beryl_stored order: 45 size: - 0 boost_enabled: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: boost_enabled order: 114 size: - 0 bread_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bread_production_hour order: 77 size: - 0 bread_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bread_stored order: 101 size: - 0 burger_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: burger_production_hour order: 87 size: - 0 burger_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: burger_stored order: 111 size: - 0 chalcopyrite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chalcopyrite_hour order: 49 size: - 0 chalcopyrite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chalcopyrite_stored order: 29 size: - 0 cheese_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: cheese_production_hour order: 91 size: - 0 cheese_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: cheese_stored order: 92 size: - 0 chip_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chip_production_hour order: 79 size: - 0 chip_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chip_stored order: 103 size: - 0 chromite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chromite_hour order: 48 size: - 0 chromite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chromite_stored order: 28 size: - 0 cider_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: cider_production_hour order: 75 size: - 0 cider_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: cider_stored order: 99 size: - 0 class: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: class order: 9 size: - 255 corn_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: corn_production_hour order: 74 size: - 0 corn_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: corn_stored order: 98 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: empire_id order: 13 size: - 0 energy_capacity: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_capacity order: 22 size: - 0 energy_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_hour order: 20 size: - 0 energy_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_stored order: 21 size: - 0 fluorite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fluorite_hour order: 64 size: - 0 fluorite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fluorite_stored order: 44 size: - 0 food_capacity: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: food_capacity order: 68 size: - 0 food_consumption_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: food_consumption_hour order: 69 size: - 0 fungus_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fungus_production_hour order: 86 size: - 0 fungus_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fungus_stored order: 110 size: - 0 galena_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: galena_hour order: 50 size: - 0 galena_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: galena_stored order: 30 size: - 0 goethite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: goethite_hour order: 54 size: - 0 goethite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: goethite_stored order: 34 size: - 0 gold_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gold_hour order: 51 size: - 0 gold_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gold_stored order: 31 size: - 0 gypsum_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gypsum_hour order: 56 size: - 0 gypsum_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gypsum_stored order: 36 size: - 0 halite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: halite_hour order: 55 size: - 0 halite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: halite_stored order: 35 size: - 0 happiness: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: happiness order: 16 size: - 0 happiness_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: happiness_hour order: 15 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 kerogen_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: kerogen_hour order: 58 size: - 0 kerogen_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: kerogen_stored order: 38 size: - 0 lapis_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: lapis_production_hour order: 70 size: - 0 lapis_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: lapis_stored order: 94 size: - 0 last_tick: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: last_tick order: 14 size: - 0 magnetite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: magnetite_hour order: 66 size: - 0 magnetite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: magnetite_stored order: 46 size: - 0 max_berth: data_type: tinyint default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: max_berth order: 120 size: - 0 meal_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: meal_production_hour order: 83 size: - 0 meal_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: meal_stored order: 107 size: - 0 methane_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: methane_hour order: 59 size: - 0 methane_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: methane_stored order: 39 size: - 0 milk_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: milk_production_hour order: 82 size: - 0 milk_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: milk_stored order: 106 size: - 0 monazite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: monazite_hour order: 63 size: - 0 monazite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: monazite_stored order: 43 size: - 0 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 needs_recalc: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: needs_recalc order: 115 size: - 0 needs_surface_refresh: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: needs_surface_refresh order: 116 size: - 0 neutral_entry: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: neutral_entry order: 124 size: - 0 notes: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: notes order: 125 size: - 0 orbit: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: orbit order: 8 size: - 0 ore_capacity: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ore_capacity order: 26 size: - 0 ore_consumption_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ore_consumption_hour order: 67 size: - 0 pancake_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: pancake_production_hour order: 81 size: - 0 pancake_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: pancake_stored order: 105 size: - 0 pie_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: pie_production_hour order: 80 size: - 0 pie_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: pie_stored order: 104 size: - 0 plots_available: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: plots_available order: 118 size: - 0 potato_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: potato_production_hour order: 71 size: - 0 potato_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: potato_stored order: 95 size: - 0 propaganda_boost: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: propaganda_boost order: 123 size: - 0 restrict_coverage: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: restrict_coverage order: 117 size: - 0 root_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: root_production_hour order: 73 size: - 0 root_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: root_stored order: 97 size: - 0 rutile_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: rutile_hour order: 47 size: - 0 rutile_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: rutile_stored order: 27 size: - 0 shake_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: shake_production_hour order: 88 size: - 0 shake_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: shake_stored order: 112 size: - 0 size: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: size order: 10 size: - 0 soup_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: soup_production_hour order: 78 size: - 0 soup_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: soup_stored order: 102 size: - 0 star_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: star_id order: 6 size: - 0 sulfur_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: sulfur_hour order: 61 size: - 0 sulfur_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: sulfur_stored order: 41 size: - 0 surface_version: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: surface_version order: 119 size: - 0 syrup_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: syrup_production_hour order: 85 size: - 0 syrup_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: syrup_stored order: 109 size: - 0 trona_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: trona_hour order: 57 size: - 0 trona_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: trona_stored order: 37 size: - 0 unhappy: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: unhappy order: 122 size: - 0 unhappy_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: unhappy_date order: 121 size: - 0 uraninite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: uraninite_hour order: 52 size: - 0 uraninite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: uraninite_stored order: 32 size: - 0 usable_as_starter: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: usable_as_starter order: 11 size: - 0 usable_as_starter_enabled: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: usable_as_starter_enabled order: 12 size: - 0 waste_capacity: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_capacity order: 19 size: - 0 waste_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_hour order: 17 size: - 0 waste_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_stored order: 18 size: - 0 water_capacity: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_capacity order: 25 size: - 0 water_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_hour order: 23 size: - 0 water_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_stored order: 24 size: - 0 wheat_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: wheat_production_hour order: 76 size: - 0 wheat_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: wheat_stored order: 100 size: - 0 x: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: x order: 3 size: - 11 y: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: y order: 4 size: - 11 zircon_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zircon_hour order: 62 size: - 0 zircon_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zircon_stored order: 42 size: - 0 zone: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 5 size: - 16 indices: - fields: - alliance_id name: body_idx_alliance_id options: [] type: NORMAL - fields: - empire_id name: body_idx_empire_id options: [] type: NORMAL - fields: - star_id name: body_idx_star_id options: [] type: NORMAL - fields: - x - y name: idx_x_y options: [] type: NORMAL - fields: - zone name: idx_zone options: [] type: NORMAL - fields: - name name: idx_name options: [] type: NORMAL - fields: - class name: idx_class options: [] type: NORMAL - fields: - usable_as_starter name: idx_usable_as_starter options: [] type: NORMAL - fields: - usable_as_starter_enabled name: idx_usable_as_starter_enabled options: [] type: NORMAL - fields: - usable_as_starter_enabled - usable_as_starter name: idx_planet_search options: [] type: NORMAL name: body options: [] order: 32 building: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: building_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 3 size: - 11 class: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: class order: 7 size: - 255 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 2 size: - 0 efficiency: data_type: int default_value: 100 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: efficiency order: 15 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 is_upgrading: data_type: bit default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_upgrading order: 10 size: - 0 is_working: data_type: bit default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_working order: 13 size: - 0 last_check: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: last_check order: 16 size: - 0 level: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level order: 6 size: - 11 upgrade_ends: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: upgrade_ends order: 9 size: - 0 upgrade_started: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: upgrade_started order: 8 size: - 0 work: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: work order: 14 size: - 0 work_ends: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: work_ends order: 12 size: - 0 work_started: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: work_started order: 11 size: - 0 x: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: x order: 4 size: - 11 y: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: y order: 5 size: - 11 indices: - fields: - body_id name: building_idx_body_id options: [] type: NORMAL - fields: - x - y name: idx_x_y options: [] type: NORMAL - fields: - class name: idx_class options: [] type: NORMAL - fields: - is_upgrading name: idx_is_upgrading options: [] type: NORMAL - fields: - is_working name: idx_is_working options: [] type: NORMAL name: building options: [] order: 37 captcha: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: created order: 5 size: - 0 guid: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: guid order: 4 size: - 36 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 riddle: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: riddle order: 2 size: - 12 solution: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: solution order: 3 size: - 5 indices: [] name: captcha options: [] order: 4 cargo_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 5 size: - 0 data: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: data order: 7 size: - 0 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 message: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: message order: 6 size: - 255 object_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: object_id order: 4 size: - 0 object_type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: object_type order: 3 size: - 255 indices: [] name: cargo_log options: [] order: 5 colony_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: average_building_level: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_building_level order: 11 size: - 5 - 2 average_spy_success_rate: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_spy_success_rate order: 20 size: - 6 - 6 body_id: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 31 size: - 11 building_count: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: building_count order: 10 size: - 0 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 defense_success_rate: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate order: 23 size: - 6 - 6 defense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate_delta order: 24 size: - 6 - 6 dirtiest: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest order: 25 size: - 11 dirtiest_delta: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_delta order: 26 size: - 11 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 energy_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_hour order: 14 size: - 11 food_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: food_hour order: 13 size: - 11 happiness_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: happiness_hour order: 18 size: - 11 highest_building_level: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: highest_building_level order: 12 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 influence: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: influence order: 28 size: - 11 is_space_station: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_space_station order: 27 size: - 11 offense_success_rate: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate order: 21 size: - 6 - 6 offense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate_delta order: 22 size: - 6 - 6 ore_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ore_hour order: 16 size: - 11 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 5 size: - 11 planet_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_name order: 6 size: - 30 population: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population order: 7 size: - 11 population_delta: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population_delta order: 9 size: - 11 population_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population_rank order: 8 size: - 11 spy_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_count order: 19 size: - 11 waste_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_hour order: 15 size: - 11 water_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_hour order: 17 size: - 11 x: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: x order: 29 size: - 11 y: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: y order: 30 size: - 11 zone: data_type: varchar default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 32 size: - 16 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - population_rank name: idx_population_rank options: [] type: NORMAL - fields: - planet_id name: idx_planet_id options: [] type: NORMAL - fields: - planet_name name: idx_planet_name options: [] type: NORMAL name: colony_log options: [] order: 6 config: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 value: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: value order: 3 size: - 256 indices: - fields: - name name: c_idx_key options: [] type: NORMAL name: config options: [] order: 7 economy_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: date default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 in_mission: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_mission order: 15 size: - 0 in_other: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_other order: 16 size: - 0 in_purchase: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_purchase order: 9 size: - 0 in_redemption: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_redemption order: 11 size: - 0 in_trade: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_trade order: 10 size: - 0 in_tutorial: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_tutorial order: 14 size: - 0 in_vein: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_vein order: 12 size: - 0 in_vote: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_vote order: 13 size: - 0 out_boost: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_boost order: 17 size: - 0 out_building: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_building order: 24 size: - 0 out_delete: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_delete order: 26 size: - 0 out_glyph: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_glyph order: 22 size: - 0 out_mission: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_mission order: 18 size: - 0 out_other: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_other order: 27 size: - 0 out_party: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_party order: 23 size: - 0 out_recycle: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_recycle order: 19 size: - 0 out_ship: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_ship order: 20 size: - 0 out_spy: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_spy order: 21 size: - 0 out_trade: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_trade order: 25 size: - 0 purchases_100: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: purchases_100 order: 5 size: - 0 purchases_1300: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: purchases_1300 order: 8 size: - 0 purchases_200: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: purchases_200 order: 6 size: - 0 purchases_30: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: purchases_30 order: 4 size: - 0 purchases_600: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: purchases_600 order: 7 size: - 0 total_users: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: total_users order: 3 size: - 0 indices: - fields: - date_stamp name: idx_date_stamp options: [] type: NORMAL name: economy_log options: [] order: 8 empire: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - name match_type: '' name: name on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: UNIQUE - deferrable: 1 expression: '' fields: - alliance_id match_type: '' name: empire_fk_alliance_id on_delete: SET NULL on_update: CASCADE options: [] reference_fields: - id reference_table: alliance type: FOREIGN KEY - deferrable: 1 expression: '' fields: - home_planet_id match_type: '' name: empire_fk_home_planet_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - latest_message_id match_type: '' name: empire_fk_latest_message_id on_delete: SET NULL on_update: '' options: [] reference_fields: - id reference_table: message type: FOREIGN KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: alliance_id order: 35 size: - 0 building_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: building_boost order: 33 size: - 0 city: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: city order: 14 size: - 100 country: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: country order: 15 size: - 100 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 4 size: - 0 deception_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: deception_affinity order: 41 size: - 0 description: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: description order: 7 size: - 0 dont_replace_excavator: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dont_replace_excavator order: 67 size: - 0 email: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: email order: 13 size: - 255 energy_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_boost order: 31 size: - 0 environmental_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: environmental_affinity order: 47 size: - 0 essentia_free: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: essentia_free order: 20 size: - 11 - 1 essentia_game: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: essentia_game order: 21 size: - 11 - 1 essentia_paid: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: essentia_paid order: 22 size: - 11 - 1 farming_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: farming_affinity order: 44 size: - 0 food_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: food_boost order: 28 size: - 0 growth_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: growth_affinity order: 50 size: - 0 happiness_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: happiness_boost order: 32 size: - 0 home_planet_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: home_planet_id order: 9 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 in_stasis: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_stasis order: 70 size: - 0 is_admin: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_admin order: 55 size: - 0 is_isolationist: data_type: tinyint default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_isolationist order: 26 size: - 0 is_mission_curator: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_mission_curator order: 56 size: - 0 last_login: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: last_login order: 19 size: - 0 latest_message_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: latest_message_id order: 68 size: - 0 management_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: management_affinity order: 43 size: - 0 manufacturing_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: manufacturing_affinity order: 40 size: - 0 max_orbit: data_type: tinyint default_value: 3 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: max_orbit order: 39 size: - 0 min_orbit: data_type: tinyint default_value: 3 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: min_orbit order: 38 size: - 0 mining_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: mining_affinity order: 45 size: - 0 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 1 name: name order: 2 size: - 30 notes: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: notes order: 8 size: - 0 ore_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ore_boost order: 30 size: - 0 outlaw: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: outlaw order: 72 size: - 0 outlaw_date: data_type: datetime default_value: 2010-10-03 18:17:26 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: outlaw_date order: 73 size: - 0 password: data_type: char default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: password order: 11 size: - 43 password_recovery_key: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: password_recovery_key order: 18 size: - 36 player_name: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: player_name order: 17 size: - 100 political_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: political_affinity order: 48 size: - 0 research_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: research_affinity order: 42 size: - 0 science_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: science_affinity order: 46 size: - 0 self_destruct_active: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: self_destruct_active order: 6 size: - 0 self_destruct_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: self_destruct_date order: 5 size: - 0 sitter_password: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: sitter_password order: 12 size: - 30 skip_attack_messages: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_attack_messages order: 63 size: - 0 skip_excavator_artifact: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_artifact order: 64 size: - 0 skip_excavator_destroyed: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_destroyed order: 65 size: - 0 skip_excavator_glyph: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_glyph order: 59 size: - 0 skip_excavator_plan: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_plan order: 60 size: - 0 skip_excavator_replace_msg: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_replace_msg order: 66 size: - 0 skip_excavator_resources: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_resources order: 58 size: - 0 skip_found_nothing: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_found_nothing order: 57 size: - 0 skip_happiness_warnings: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_happiness_warnings order: 54 size: - 0 skip_incoming_ships: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_incoming_ships order: 69 size: - 0 skip_medal_messages: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_medal_messages order: 51 size: - 0 skip_pollution_warnings: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_pollution_warnings order: 52 size: - 0 skip_probe_detected: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_probe_detected order: 62 size: - 0 skip_resource_warnings: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_resource_warnings order: 53 size: - 0 skip_spy_recovery: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_spy_recovery order: 61 size: - 0 skype: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: skype order: 16 size: - 100 species_description: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: species_description order: 37 size: - 0 species_name: data_type: varchar default_value: Human is_nullable: 0 is_primary_key: 0 is_unique: 0 name: species_name order: 36 size: - 30 spy_training_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_training_boost order: 34 size: - 0 stage: data_type: varchar default_value: new is_nullable: 0 is_primary_key: 0 is_unique: 0 name: stage order: 3 size: - 30 status_message: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: status_message order: 10 size: - 255 storage_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: storage_boost order: 27 size: - 0 timeout: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: timeout order: 71 size: - 0 trade_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: trade_affinity order: 49 size: - 0 tutorial_scratch: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: tutorial_scratch order: 25 size: - 0 tutorial_stage: data_type: varchar default_value: explore_the_ui is_nullable: 0 is_primary_key: 0 is_unique: 0 name: tutorial_stage order: 24 size: - 30 university_level: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: university_level order: 23 size: - 0 water_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_boost order: 29 size: - 0 indices: - fields: - alliance_id name: empire_idx_alliance_id options: [] type: NORMAL - fields: - home_planet_id name: empire_idx_home_planet_id options: [] type: NORMAL - fields: - latest_message_id name: empire_idx_latest_message_id options: [] type: NORMAL - fields: - self_destruct_active - self_destruct_date name: idx_self_destruct options: [] type: NORMAL - fields: - password_recovery_key name: idx_password_recovery_key options: [] type: NORMAL - fields: - last_login - self_destruct_active name: idx_inactives options: [] type: NORMAL - fields: - name - is_admin name: idx_admins options: [] type: NORMAL name: empire options: [] order: 33 empire_admin_notes: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: creator: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: creator order: 6 size: - 30 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 notes: data_type: text default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: notes order: 5 size: - 0 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL name: empire_admin_notes options: [] order: 9 empire_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: alliance_id order: 33 size: - 0 alliance_name: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: alliance_name order: 34 size: - 30 average_building_level: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_building_level order: 15 size: - 5 - 2 building_count: data_type: smallint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: building_count order: 12 size: - 0 colony_count: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: colony_count order: 5 size: - 0 colony_count_delta: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: colony_count_delta order: 6 size: - 0 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 defense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate order: 27 size: - 6 - 6 defense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate_delta order: 29 size: - 6 - 6 defense_success_rate_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate_rank order: 28 size: - 11 dirtiest: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest order: 30 size: - 11 dirtiest_delta: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_delta order: 32 size: - 11 dirtiest_rank: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_rank order: 31 size: - 11 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 empire_size: data_type: bigint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_size order: 9 size: - 11 empire_size_delta: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_size_delta order: 10 size: - 11 empire_size_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_size_rank order: 11 size: - 11 energy_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_hour order: 18 size: - 11 food_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: food_hour order: 17 size: - 11 happiness_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: happiness_hour order: 22 size: - 11 highest_building_level: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: highest_building_level order: 16 size: - 3 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 influence: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: influence order: 36 size: - 11 offense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate order: 24 size: - 6 - 6 offense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate_delta order: 26 size: - 6 - 6 offense_success_rate_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate_rank order: 25 size: - 11 ore_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ore_hour order: 20 size: - 11 population: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population order: 7 size: - 11 population_delta: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population_delta order: 8 size: - 11 space_station_count: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: space_station_count order: 35 size: - 11 spy_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_count order: 23 size: - 11 university_level: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: university_level order: 13 size: - 0 university_level_rank: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: university_level_rank order: 14 size: - 0 waste_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_hour order: 19 size: - 11 water_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_hour order: 21 size: - 11 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - empire_size_rank name: idx_empire_size_rank options: [] type: NORMAL - fields: - university_level_rank name: idx_university_level_rank options: [] type: NORMAL - fields: - offense_success_rate_rank name: idx_offense_success_rate_rank options: [] type: NORMAL - fields: - defense_success_rate_rank name: idx_defense_success_rate_rank options: [] type: NORMAL - fields: - dirtiest_rank name: idx_dirtiest_rank options: [] type: NORMAL name: empire_log options: [] order: 10 empire_name_change_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 old_empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: old_empire_name order: 5 size: - 30 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL name: empire_name_change_log options: [] order: 11 empire_rpc_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 limits: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: limits order: 6 size: - 11 rpc: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: rpc order: 5 size: - 11 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL name: empire_rpc_log options: [] order: 12 essentia_code: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: amount: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: amount order: 3 size: - 11 - 1 code: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: code order: 2 size: - 36 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 4 size: - 0 description: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: description order: 5 size: - 50 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 7 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 used: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: used order: 6 size: - 0 indices: - fields: - code name: idx_code options: [] type: NORMAL name: essentia_code options: [] order: 13 essentia_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: amount: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: amount order: 6 size: - 11 - 1 api_key: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: api_key order: 5 size: - 40 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 description: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: description order: 7 size: - 90 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 from_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: from_id order: 9 size: - 11 from_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: from_name order: 10 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 transaction_id: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: transaction_id order: 8 size: - 36 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - api_key name: idx_api_key options: [] type: NORMAL - fields: - transaction_id name: idx_transaction_id options: [] type: NORMAL - fields: - empire_id - description - amount name: idx_essentiacode options: [] type: NORMAL name: essentia_log options: [] order: 14 excavators: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: excavators_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: excavators_fk_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - planet_id match_type: '' name: excavators_fk_planet_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 3 size: - 11 date_landed: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_landed order: 5 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 4 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 2 size: - 11 indices: - fields: - body_id name: excavators_idx_body_id options: [] type: NORMAL - fields: - empire_id name: excavators_idx_empire_id options: [] type: NORMAL - fields: - planet_id name: excavators_idx_planet_id options: [] type: NORMAL name: excavators options: [] order: 51 fleet: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: fleet_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - foreign_body_id match_type: '' name: fleet_fk_foreign_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - foreign_star_id match_type: '' name: fleet_fk_foreign_star_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY fields: berth_level: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: berth_level order: 20 size: - 0 body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 2 size: - 0 combat: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: combat order: 12 size: - 0 date_available: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_available order: 6 size: - 0 date_started: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_started order: 5 size: - 0 direction: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: direction order: 16 size: - 3 fleet_speed: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fleet_speed order: 19 size: - 0 foreign_body_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: foreign_body_id order: 17 size: - 0 foreign_star_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: foreign_star_id order: 18 size: - 0 hold_size: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: hold_size order: 13 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 mark: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: mark order: 3 size: - 10 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 9 size: - 30 payload: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: payload order: 14 size: - 0 roundtrip: data_type: bit default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: roundtrip order: 15 size: - 0 shipyard_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: shipyard_id order: 4 size: - 0 speed: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: speed order: 10 size: - 0 stealth: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: stealth order: 11 size: - 0 task: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: task order: 8 size: - 30 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 7 size: - 30 indices: - fields: - body_id name: fleet_idx_body_id options: [] type: NORMAL - fields: - foreign_body_id name: fleet_idx_foreign_body_id options: [] type: NORMAL - fields: - foreign_star_id name: fleet_idx_foreign_star_id options: [] type: NORMAL name: fleet options: [] order: 38 glyph: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: glyph_fk_body_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 2 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 quantity: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: quantity order: 4 size: - 0 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 3 size: - 20 indices: - fields: - body_id name: glyph_idx_body_id options: [] type: NORMAL name: glyph options: [] order: 39 invite: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - invitee_id match_type: '' name: invite_fk_invitee_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - inviter_id match_type: '' name: invite_fk_inviter_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: accept_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: accept_date order: 8 size: - 0 code: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: code order: 6 size: - 36 email: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: email order: 5 size: - 255 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 invite_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: invite_date order: 7 size: - 0 invitee_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: invitee_id order: 4 size: - 0 inviter_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: inviter_id order: 2 size: - 0 zone: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 3 size: - 16 indices: - fields: - invitee_id name: invite_idx_invitee_id options: [] type: NORMAL - fields: - inviter_id name: invite_idx_inviter_id options: [] type: NORMAL name: invite options: [] order: 40 laws: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - star_id match_type: '' name: laws_fk_star_id on_delete: SET NULL on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY - deferrable: 1 expression: '' fields: - station_id match_type: '' name: laws_fk_station_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: date_enacted: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_enacted order: 7 size: - 0 description: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: description order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 scratch: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: scratch order: 6 size: - 0 star_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: star_id order: 8 size: - 0 station_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: station_id order: 3 size: - 11 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 5 size: - 30 indices: - fields: - star_id name: laws_idx_star_id options: [] type: NORMAL - fields: - station_id name: laws_idx_station_id options: [] type: NORMAL - fields: - date_enacted name: idx_date_enacted options: [] type: NORMAL name: laws options: [] order: 41 login_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: api_key: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: api_key order: 5 size: - 36 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 extended: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: extended order: 9 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 ip_address: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: ip_address order: 7 size: - 15 is_sitter: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_sitter order: 10 size: - 1 log_out_date: data_type: datetime default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: log_out_date order: 8 size: - 0 session_id: data_type: char default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: session_id order: 6 size: - 36 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - api_key name: idx_api_key options: [] type: NORMAL - fields: - session_id name: idx_session_id options: [] type: NORMAL name: login_log options: [] order: 15 lottery_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: api_key: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: api_key order: 5 size: - 40 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 ip_address: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: ip_address order: 7 size: - 15 url: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: url order: 6 size: - 255 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - api_key name: idx_api_key options: [] type: NORMAL - fields: - url name: idx_url options: [] type: NORMAL - fields: - ip_address name: idx_ip_address options: [] type: NORMAL name: lottery_log options: [] order: 16 market: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: market_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - ship_id match_type: '' name: market_fk_ship_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: ships type: FOREIGN KEY fields: ask: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ask order: 6 size: - 11 - 1 body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 3 size: - 0 date_offered: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_offered order: 2 size: - 0 has_energy: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_energy order: 10 size: - 0 has_food: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_food order: 11 size: - 0 has_glyph: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_glyph order: 16 size: - 0 has_ore: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_ore order: 13 size: - 0 has_plan: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_plan order: 17 size: - 0 has_prisoner: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_prisoner order: 15 size: - 0 has_ship: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_ship order: 14 size: - 0 has_waste: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_waste order: 12 size: - 0 has_water: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_water order: 9 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 max_university: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: max_university order: 22 size: - 0 offer_cargo_space_needed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offer_cargo_space_needed order: 8 size: - 0 payload: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: payload order: 7 size: - 0 ship_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: ship_id order: 5 size: - 0 speed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: speed order: 20 size: - 0 trade_range: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: trade_range order: 21 size: - 0 transfer_type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: transfer_type order: 4 size: - 16 x: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: x order: 18 size: - 0 y: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: y order: 19 size: - 0 indices: - fields: - body_id name: market_idx_body_id options: [] type: NORMAL - fields: - ship_id name: market_idx_ship_id options: [] type: NORMAL - fields: - body_id - transfer_type name: idx_market_zone options: [] type: NORMAL name: market options: [] order: 52 medals: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: medals_fk_empire_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: datestamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: datestamp order: 5 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 public: data_type: bit default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: public order: 4 size: - 0 times_earned: data_type: int default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_earned order: 6 size: - 11 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 2 size: - 30 indices: - fields: - empire_id name: medals_idx_empire_id options: [] type: NORMAL name: medals options: [] order: 42 mercenary_market: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: mercenary_market_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: ask: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ask order: 5 size: - 11 - 1 body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 3 size: - 0 cost: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: cost order: 6 size: - 11 - 1 date_offered: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_offered order: 2 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 payload: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: payload order: 7 size: - 0 ship_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ship_id order: 4 size: - 0 indices: - fields: - body_id name: mercenary_market_idx_body_id options: [] type: NORMAL name: mercenary_market options: [] order: 43 message: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - to_id match_type: '' name: message_fk_to_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - from_id match_type: '' name: message_fk_from_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: attachments: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: attachments order: 16 size: - 0 body: data_type: mediumtext default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: body order: 4 size: - 0 date_sent: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_sent order: 5 size: - 0 from_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: from_id order: 6 size: - 11 from_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: from_name order: 7 size: - 30 has_archived: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_archived order: 14 size: - 0 has_read: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_read order: 12 size: - 0 has_replied: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_replied order: 13 size: - 0 has_trashed: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_trashed order: 15 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 in_reply_to: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: in_reply_to order: 2 size: - 11 recipients: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: recipients order: 10 size: - 0 repeat_check: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: repeat_check order: 17 size: - 30 subject: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: subject order: 3 size: - 64 tag: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: tag order: 11 size: - 15 to_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: to_id order: 8 size: - 11 to_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: to_name order: 9 size: - 30 indices: - fields: - to_id name: message_idx_to_id options: [] type: NORMAL - fields: - from_id name: message_idx_from_id options: [] type: NORMAL - fields: - repeat_check - date_sent name: idx_repeat_check_date_sent options: [] type: NORMAL - fields: - has_archived - has_read - to_id - date_sent name: idx_recent_messages options: [] type: NORMAL - fields: - has_archived - to_id - date_sent name: idx_inbox_only options: [] type: NORMAL - fields: - has_trashed - to_id - date_sent name: idx_trash_only options: [] type: NORMAL name: message options: [] order: 30 mining_platforms: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - asteroid_id match_type: '' name: mining_platforms_fk_asteroid_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - planet_id match_type: '' name: mining_platforms_fk_planet_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: anthracite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: anthracite_hour order: 17 size: - 11 asteroid_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: asteroid_id order: 3 size: - 11 bauxite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bauxite_hour order: 10 size: - 11 beryl_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: beryl_hour order: 22 size: - 11 chalcopyrite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chalcopyrite_hour order: 6 size: - 11 chromite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chromite_hour order: 5 size: - 11 fluorite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fluorite_hour order: 21 size: - 11 galena_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: galena_hour order: 7 size: - 11 goethite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: goethite_hour order: 11 size: - 11 gold_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gold_hour order: 8 size: - 11 gypsum_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gypsum_hour order: 13 size: - 11 halite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: halite_hour order: 12 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 kerogen_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: kerogen_hour order: 15 size: - 11 magnetite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: magnetite_hour order: 23 size: - 11 methane_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: methane_hour order: 16 size: - 11 monazite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: monazite_hour order: 20 size: - 11 percent_ship_capacity: data_type: int default_value: -1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: percent_ship_capacity order: 24 size: - 0 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 2 size: - 11 rutile_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: rutile_hour order: 4 size: - 11 sulfur_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: sulfur_hour order: 18 size: - 11 trona_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: trona_hour order: 14 size: - 11 uraninite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: uraninite_hour order: 9 size: - 11 zircon_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zircon_hour order: 19 size: - 11 indices: - fields: - asteroid_id name: mining_platforms_idx_asteroid_id options: [] type: NORMAL - fields: - planet_id name: mining_platforms_idx_planet_id options: [] type: NORMAL name: mining_platforms options: [] order: 44 mission: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_posted: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_posted order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 max_university_level: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: max_university_level order: 5 size: - 0 mission_file_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: mission_file_name order: 2 size: - 100 scratch: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: scratch order: 6 size: - 0 zone: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 3 size: - 16 indices: - fields: - zone - date_posted name: idx_zone_date_posted options: [] type: NORMAL name: mission options: [] order: 17 mission_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: complete_uni_level: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: complete_uni_level order: 7 size: - 0 completes: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: completes order: 6 size: - 0 filename: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: filename order: 2 size: - 255 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 incompletes: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: incompletes order: 9 size: - 0 offers: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offers order: 3 size: - 0 seconds_to_complete: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: seconds_to_complete order: 8 size: - 0 skip_uni_level: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_uni_level order: 5 size: - 0 skips: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skips order: 4 size: - 0 indices: [] name: mission_log options: [] order: 18 news: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_posted: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_posted order: 4 size: - 0 headline: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: headline order: 2 size: - 140 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 zone: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 3 size: - 16 indices: - fields: - zone - date_posted name: idx_zone_date_posted options: [] type: NORMAL - fields: - date_posted name: idx_date_posted options: [] type: NORMAL name: news options: [] order: 19 noexist_with_empire_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL name: noexist_with_empire_log options: [] order: 22 plan: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: plan_fk_body_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 2 size: - 11 class: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: class order: 3 size: - 255 extra_build_level: data_type: tinyint default_value: 0 is_nullable: 1 is_primary_key: 0 is_unique: 0 name: extra_build_level order: 5 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 level: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level order: 4 size: - 0 quantity: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: quantity order: 6 size: - 11 indices: - fields: - body_id name: plan_idx_body_id options: [] type: NORMAL name: plan options: [] order: 45 probes: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - alliance_id match_type: '' name: probes_fk_alliance_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: alliance type: FOREIGN KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: probes_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: probes_fk_empire_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - star_id match_type: '' name: probes_fk_star_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: star type: FOREIGN KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: alliance_id order: 5 size: - 0 body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 4 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 2 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 star_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: star_id order: 3 size: - 0 virtual: data_type: int default_value: 0 is_nullable: 1 is_primary_key: 0 is_unique: 0 name: virtual order: 6 size: - 0 indices: - fields: - alliance_id name: probes_idx_alliance_id options: [] type: NORMAL - fields: - body_id name: probes_idx_body_id options: [] type: NORMAL - fields: - empire_id name: probes_idx_empire_id options: [] type: NORMAL - fields: - star_id name: probes_idx_star_id options: [] type: NORMAL name: probes options: [] order: 53 promotion: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: end_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: end_date order: 3 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 max_purchase: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: max_purchase order: 6 size: - 0 min_purchase: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: min_purchase order: 5 size: - 0 payload: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: payload order: 7 size: - 0 start_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: start_date order: 2 size: - 0 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 4 size: - 30 indices: [] name: promotion options: [] order: 23 propositions: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - proposed_by_id match_type: '' name: propositions_fk_proposed_by_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - station_id match_type: '' name: propositions_fk_station_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: date_ends: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_ends order: 7 size: - 0 description: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: description order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 proposed_by_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: proposed_by_id order: 8 size: - 11 scratch: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: scratch order: 6 size: - 0 station_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: station_id order: 3 size: - 11 status: data_type: varchar default_value: Pending is_nullable: 0 is_primary_key: 0 is_unique: 0 name: status order: 9 size: - 10 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 5 size: - 30 indices: - fields: - proposed_by_id name: propositions_idx_proposed_by_id options: [] type: NORMAL - fields: - station_id name: propositions_idx_station_id options: [] type: NORMAL - fields: - status - date_ends name: idx_status_date_ends options: [] type: NORMAL name: propositions options: [] order: 54 rpc_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: api_key: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: api_key order: 5 size: - 40 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 module: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: module order: 6 size: - 255 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - api_key name: idx_api_key options: [] type: NORMAL - fields: - module name: idx_module options: [] type: NORMAL name: rpc_log options: [] order: 24 schedule: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: args: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: args order: 9 size: - 0 delivery: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: delivery order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 job_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: job_id order: 3 size: - 11 parent_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: parent_id order: 7 size: - 11 parent_table: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: parent_table order: 6 size: - 30 priority: data_type: int default_value: 1000 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: priority order: 5 size: - 11 queue: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: queue order: 2 size: - 30 task: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: task order: 8 size: - 30 indices: [] name: schedule options: [] order: 25 ships: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: ships_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - foreign_body_id match_type: '' name: ships_fk_foreign_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - foreign_star_id match_type: '' name: ships_fk_foreign_star_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY fields: berth_level: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: berth_level order: 19 size: - 0 body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 2 size: - 0 combat: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: combat order: 11 size: - 0 date_available: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_available order: 5 size: - 0 date_started: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_started order: 4 size: - 0 direction: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: direction order: 15 size: - 3 fleet_speed: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fleet_speed order: 18 size: - 0 foreign_body_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: foreign_body_id order: 16 size: - 0 foreign_star_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: foreign_star_id order: 17 size: - 0 hold_size: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: hold_size order: 12 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 8 size: - 30 number_of_docks: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: number_of_docks order: 20 size: - 0 payload: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: payload order: 13 size: - 0 roundtrip: data_type: bit default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: roundtrip order: 14 size: - 0 shipyard_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: shipyard_id order: 3 size: - 0 speed: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: speed order: 9 size: - 0 stealth: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: stealth order: 10 size: - 0 task: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: task order: 7 size: - 30 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 6 size: - 30 indices: - fields: - body_id name: ships_idx_body_id options: [] type: NORMAL - fields: - foreign_body_id name: ships_idx_foreign_body_id options: [] type: NORMAL - fields: - foreign_star_id name: ships_idx_foreign_star_id options: [] type: NORMAL - fields: - type name: idx_shiptype options: [] type: NORMAL name: ships options: [] order: 46 sitter_auths: constraints: - deferrable: 1 expression: '' fields: - baby_id - sitter_id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - baby_id match_type: '' name: sitter_auths_fk_baby_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - sitter_id match_type: '' name: sitter_auths_fk_sitter_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: baby_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 1 is_unique: 0 name: baby_id order: 1 size: - 0 expiry: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: expiry order: 3 size: - 0 sitter_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 1 is_unique: 0 name: sitter_id order: 2 size: - 0 indices: - fields: - baby_id name: sitter_auths_idx_baby_id options: [] type: NORMAL - fields: - sitter_id name: sitter_auths_idx_sitter_id options: [] type: NORMAL name: sitter_auths options: [] order: 47 spies: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: spies_fk_empire_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - from_body_id match_type: '' name: spies_fk_from_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - on_body_id match_type: '' name: spies_fk_on_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: available_on: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: available_on order: 8 size: - 0 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 11 size: - 0 defense: data_type: int default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense order: 10 size: - 0 defense_mission_count: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_mission_count order: 13 size: - 0 defense_mission_successes: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_mission_successes order: 15 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 2 size: - 0 from_body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: from_body_id order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 intel_xp: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: intel_xp order: 24 size: - 0 level: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level order: 28 size: - 0 mayhem_xp: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: mayhem_xp order: 25 size: - 0 name: data_type: varchar default_value: Agent Null is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 3 size: - 30 next_task: data_type: varchar default_value: Idle is_nullable: 0 is_primary_key: 0 is_unique: 0 name: next_task order: 29 size: - 30 offense: data_type: int default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense order: 9 size: - 0 offense_mission_count: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_mission_count order: 12 size: - 0 offense_mission_successes: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_mission_successes order: 14 size: - 0 on_body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: on_body_id order: 5 size: - 0 politics_xp: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: politics_xp order: 26 size: - 0 seeds_planted: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: seeds_planted order: 18 size: - 0 spies_captured: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_captured order: 20 size: - 0 spies_killed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_killed order: 19 size: - 0 spies_turned: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_turned order: 21 size: - 0 started_assignment: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: started_assignment order: 7 size: - 0 task: data_type: varchar default_value: Idle is_nullable: 0 is_primary_key: 0 is_unique: 0 name: task order: 6 size: - 30 theft_xp: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: theft_xp order: 27 size: - 0 things_destroyed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: things_destroyed order: 22 size: - 0 things_stolen: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: things_stolen order: 23 size: - 0 times_captured: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_captured order: 16 size: - 0 times_turned: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_turned order: 17 size: - 0 indices: - fields: - empire_id name: spies_idx_empire_id options: [] type: NORMAL - fields: - from_body_id name: spies_idx_from_body_id options: [] type: NORMAL - fields: - on_body_id name: spies_idx_on_body_id options: [] type: NORMAL name: spies options: [] order: 55 spy_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: age: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: age order: 19 size: - 11 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 defense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate order: 14 size: - 6 - 6 defense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate_delta order: 15 size: - 6 - 6 dirtiest: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest order: 28 size: - 11 dirtiest_delta: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_delta order: 30 size: - 11 dirtiest_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_rank order: 29 size: - 11 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 level: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level order: 9 size: - 11 level_delta: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level_delta order: 11 size: - 11 level_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level_rank order: 10 size: - 11 offense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate order: 12 size: - 6 - 6 offense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate_delta order: 13 size: - 6 - 6 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 8 size: - 11 planet_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_name order: 7 size: - 30 seeds_planted: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: seeds_planted order: 22 size: - 11 spies_captured: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_captured order: 24 size: - 11 spies_killed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_killed order: 23 size: - 11 spies_turned: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_turned order: 25 size: - 11 spy_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_id order: 6 size: - 11 spy_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_name order: 5 size: - 30 success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: success_rate order: 16 size: - 6 - 6 success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: success_rate_delta order: 18 size: - 6 - 6 success_rate_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: success_rate_rank order: 17 size: - 11 things_destroyed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: things_destroyed order: 26 size: - 11 things_stolen: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: things_stolen order: 27 size: - 11 times_captured: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_captured order: 20 size: - 11 times_turned: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_turned order: 21 size: - 11 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - level_rank name: idx_level_rank options: [] type: NORMAL - fields: - success_rate_rank name: idx_success_rate_rank options: [] type: NORMAL - fields: - dirtiest_rank name: idx_dirtiest_rank options: [] type: NORMAL - fields: - planet_id name: idx_planet_id options: [] type: NORMAL - fields: - planet_name name: idx_planet_name options: [] type: NORMAL - fields: - spy_id name: idx_spy_id options: [] type: NORMAL - fields: - spy_name name: idx_spy_name options: [] type: NORMAL name: spy_log options: [] order: 26 star: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - station_id match_type: '' name: star_fk_station_id on_delete: SET NULL on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: color: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: color order: 6 size: - 7 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 influence: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: influence order: 8 size: - 0 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 needs_recalc: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: needs_recalc order: 9 size: - 0 station_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: station_id order: 7 size: - 0 x: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: x order: 3 size: - 11 y: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: y order: 4 size: - 11 zone: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 5 size: - 16 indices: - fields: - station_id name: star_idx_station_id options: [] type: NORMAL - fields: - needs_recalc name: idx_recalc options: [] type: NORMAL name: star options: [] order: 31 stationinfluence: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - alliance_id match_type: '' name: stationinfluence_fk_alliance_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: alliance type: FOREIGN KEY - deferrable: 1 expression: '' fields: - star_id match_type: '' name: stationinfluence_fk_star_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY - deferrable: 1 expression: '' fields: - station_id match_type: '' name: stationinfluence_fk_station_id on_delete: CASCADE on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: alliance_id order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 influence: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: influence order: 7 size: - 0 oldinfluence: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: oldinfluence order: 5 size: - 0 oldstart: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: oldstart order: 6 size: - 0 star_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: star_id order: 3 size: - 0 started_influence: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: started_influence order: 8 size: - 0 station_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: station_id order: 2 size: - 0 indices: - fields: - alliance_id name: stationinfluence_idx_alliance_id options: [] type: NORMAL - fields: - star_id name: stationinfluence_idx_star_id options: [] type: NORMAL - fields: - station_id name: stationinfluence_idx_station_id options: [] type: NORMAL name: stationinfluence options: [] order: 48 supply_chain: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - building_id match_type: '' name: supply_chain_fk_building_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: building type: FOREIGN KEY - deferrable: 1 expression: '' fields: - planet_id match_type: '' name: supply_chain_fk_planet_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - target_id match_type: '' name: supply_chain_fk_target_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: building_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: building_id order: 3 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 percent_transferred: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: percent_transferred order: 7 size: - 11 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 2 size: - 11 resource_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: resource_hour order: 5 size: - 11 resource_type: data_type: varchar default_value: '' is_nullable: 0 is_primary_key: 0 is_unique: 0 name: resource_type order: 6 size: - 0 stalled: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: stalled order: 8 size: - 11 target_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: target_id order: 4 size: - 11 indices: - fields: - building_id name: supply_chain_idx_building_id options: [] type: NORMAL - fields: - planet_id name: supply_chain_idx_planet_id options: [] type: NORMAL - fields: - target_id name: supply_chain_idx_target_id options: [] type: NORMAL name: supply_chain options: [] order: 56 survey: constraints: - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: survey_fk_empire_id on_delete: CASCADE on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: choice: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: choice order: 2 size: - 0 comment: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: comment order: 3 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 1 is_unique: 0 name: empire_id order: 1 size: - 0 indices: [] name: survey options: [] order: 49 taxes: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: taxes_fk_empire_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - station_id match_type: '' name: taxes_fk_station_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 2 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 paid_0: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_0 order: 10 size: - 11 paid_1: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_1 order: 9 size: - 11 paid_2: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_2 order: 8 size: - 11 paid_3: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_3 order: 7 size: - 11 paid_4: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_4 order: 6 size: - 11 paid_5: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_5 order: 5 size: - 11 paid_6: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_6 order: 4 size: - 11 station_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: station_id order: 3 size: - 11 indices: - fields: - empire_id name: taxes_idx_empire_id options: [] type: NORMAL - fields: - station_id name: taxes_idx_station_id options: [] type: NORMAL name: taxes options: [] order: 57 viral_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: abandons: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: abandons order: 8 size: - 0 accepts: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: accepts order: 6 size: - 0 active_duration: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: active_duration order: 9 size: - 0 creates: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: creates order: 4 size: - 0 date_stamp: data_type: date default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 deletes: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: deletes order: 7 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 invites: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: invites order: 5 size: - 0 total_users: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: total_users order: 3 size: - 0 indices: - fields: - date_stamp name: idx_date_stamp options: [] type: NORMAL name: viral_log options: [] order: 27 votes: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: votes_fk_empire_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - proposition_id match_type: '' name: votes_fk_proposition_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: propositions type: FOREIGN KEY fields: empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 proposition_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: proposition_id order: 2 size: - 0 vote: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: vote order: 4 size: - 0 indices: - fields: - empire_id name: votes_idx_empire_id options: [] type: NORMAL - fields: - proposition_id name: votes_idx_proposition_id options: [] type: NORMAL name: votes options: [] order: 58 waste_chain: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - planet_id match_type: '' name: waste_chain_fk_planet_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - star_id match_type: '' name: waste_chain_fk_star_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY fields: id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 percent_transferred: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: percent_transferred order: 5 size: - 11 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 2 size: - 11 star_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: star_id order: 3 size: - 11 waste_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_hour order: 4 size: - 11 indices: - fields: - planet_id name: waste_chain_idx_planet_id options: [] type: NORMAL - fields: - star_id name: waste_chain_idx_star_id options: [] type: NORMAL name: waste_chain options: [] order: 50 weekly_medal_winner: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 medal_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: medal_id order: 5 size: - 0 medal_image: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: medal_image order: 8 size: - 50 medal_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: medal_name order: 6 size: - 50 times_earned: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_earned order: 7 size: - 0 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL name: weekly_medal_winner options: [] order: 28 triggers: stationinfluence_cleanup: action: UPDATE star s SET s.needs_recalc = 1 WHERE s.id = OLD.star_id; database_events: - delete fields: ~ name: stationinfluence_cleanup on_table: stationinfluence order: 1 perform_action_when: after scope: row views: {} translator: add_drop_table: 1 filename: ~ no_comments: 0 parser_args: sources: - AIBattleSummary - AIScratchPad - Alliance - AllianceInvite - ApiKey - Building - Building::Archaeology - Building::Capitol - Building::CloakingLab - Building::DeployedBleeder - Building::Development - Building::DistributionCenter - Building::Embassy - Building::Energy - Building::Energy::Fission - Building::Energy::Fusion - Building::Energy::Geo - Building::Energy::Hydrocarbon - Building::Energy::Reserve - Building::Energy::Singularity - Building::Energy::Waste - Building::EntertainmentDistrict - Building::Espionage - Building::Food - Building::Food::Algae - Building::Food::Apple - Building::Food::Bean - Building::Food::Beeldeban - Building::Food::Bread - Building::Food::Burger - Building::Food::Cheese - Building::Food::Chip - Building::Food::Cider - Building::Food::Corn - Building::Food::CornMeal - Building::Food::Dairy - Building::Food::Lapis - Building::Food::Malcud - Building::Food::Pancake - Building::Food::Pie - Building::Food::Potato - Building::Food::Reserve - Building::Food::Root - Building::Food::Shake - Building::Food::Soup - Building::Food::Syrup - Building::Food::Wheat - Building::GasGiantLab - Building::GeneticsLab - Building::IntelTraining - Building::Intelligence - Building::LCOTa - Building::LCOTb - Building::LCOTc - Building::LCOTd - Building::LCOTe - Building::LCOTf - Building::LCOTg - Building::LCOTh - Building::LCOTi - Building::LuxuryHousing - Building::MayhemTraining - Building::MercenariesGuild - Building::MissionCommand - Building::Module - Building::Module::ArtMuseum - Building::Module::CulinaryInstitute - Building::Module::IBS - Building::Module::OperaHouse - Building::Module::Parliament - Building::Module::PoliceStation - Building::Module::StationCommand - Building::Module::Warehouse - Building::MunitionsLab - Building::Network19 - Building::Observatory - Building::Ore - Building::Ore::Mine - Building::Ore::Ministry - Building::Ore::Refinery - Building::Ore::Storage - Building::Oversight - Building::Park - Building::Permanent - Building::Permanent::AlgaePond - Building::Permanent::AmalgusMeadow - Building::Permanent::Beach1 - Building::Permanent::Beach10 - Building::Permanent::Beach11 - Building::Permanent::Beach12 - Building::Permanent::Beach13 - Building::Permanent::Beach2 - Building::Permanent::Beach3 - Building::Permanent::Beach4 - Building::Permanent::Beach5 - Building::Permanent::Beach6 - Building::Permanent::Beach7 - Building::Permanent::Beach8 - Building::Permanent::Beach9 - Building::Permanent::BeeldebanNest - Building::Permanent::BlackHoleGenerator - Building::Permanent::CitadelOfKnope - Building::Permanent::CrashedShipSite - Building::Permanent::Crater - Building::Permanent::DentonBrambles - Building::Permanent::EssentiaVein - Building::Permanent::Fissure - Building::Permanent::GasGiantPlatform - Building::Permanent::GeoThermalVent - Building::Permanent::GratchsGauntlet - Building::Permanent::GreatBallOfJunk - Building::Permanent::Grove - Building::Permanent::HallsOfVrbansk - Building::Permanent::InterDimensionalRift - Building::Permanent::JunkHengeSculpture - Building::Permanent::KalavianRuins - Building::Permanent::KasternsKeep - Building::Permanent::Lagoon - Building::Permanent::Lake - Building::Permanent::LapisForest - Building::Permanent::LibraryOfJith - Building::Permanent::MalcudField - Building::Permanent::MassadsHenge - Building::Permanent::MetalJunkArches - Building::Permanent::NaturalSpring - Building::Permanent::OracleOfAnid - Building::Permanent::PantheonOfHagness - Building::Permanent::PyramidJunkSculpture - Building::Permanent::Ravine - Building::Permanent::RockyOutcrop - Building::Permanent::Sand - Building::Permanent::SpaceJunkPark - Building::Permanent::TempleOfTheDrajilites - Building::Permanent::TerraformingPlatform - Building::Permanent::TheDillonForge - Building::Permanent::Volcano - Building::PilotTraining - Building::PlanetaryCommand - Building::PoliticsTraining - Building::Propulsion - Building::SAW - Building::SSLa - Building::SSLb - Building::SSLc - Building::SSLd - Building::Security - Building::Shipyard - Building::SpacePort - Building::Stockpile - Building::SubspaceSupplyDepot - Building::SupplyPod - Building::TerraformingLab - Building::TheftTraining - Building::ThemePark - Building::Trade - Building::Transporter - Building::University - Building::Waste - Building::Waste::Digester - Building::Waste::Exchanger - Building::Waste::Recycling - Building::Waste::Sequestration - Building::Waste::Treatment - Building::Water - Building::Water::AtmosphericEvaporator - Building::Water::Production - Building::Water::Purification - Building::Water::Reclamation - Building::Water::Storage - Captcha - Config - Empire - EssentiaCode - Excavators - Fleet - Fleet::Barge - Fleet::Bleeder - Fleet::CargoShip - Fleet::ColonyShip - Fleet::Detonator - Fleet::Dory - Fleet::Drone - Fleet::Excavator - Fleet::Fighter - Fleet::Freighter - Fleet::Galleon - Fleet::GasGiantSettlementPlatformShip - Fleet::Hulk - Fleet::HulkFast - Fleet::HulkHuge - Fleet::MiningPlatformShip - Fleet::ObservatorySeeker - Fleet::Placebo - Fleet::Placebo2 - Fleet::Placebo3 - Fleet::Placebo4 - Fleet::Placebo5 - Fleet::Placebo6 - Fleet::Probe - Fleet::Scanner - Fleet::Scow - Fleet::ScowFast - Fleet::ScowLarge - Fleet::ScowMega - Fleet::SecurityMinistrySeeker - Fleet::ShortRangeColonyShip - Fleet::SmugglerShip - Fleet::Snark - Fleet::Snark2 - Fleet::Snark3 - Fleet::SpacePortSeeker - Fleet::SpaceStation - Fleet::SpyPod - Fleet::SpyShuttle - Fleet::Stake - Fleet::SupplyPod - Fleet::SupplyPod2 - Fleet::SupplyPod3 - Fleet::SupplyPod4 - Fleet::Surveyor - Fleet::Sweeper - Fleet::TerraformingPlatformShip - Fleet::Thud - Glyph - Invite - Laws - Laws::BHGNeutralized - Laws::BHGPassport - Laws::MembersOnlyColonization - Laws::MembersOnlyExcavation - Laws::MembersOnlyMiningRights - Laws::MembersOnlyStations - Laws::Taxation - Laws::Writ - Log - Log::Alliance - Log::Battles - Log::Cargo - Log::Colony - Log::Economy - Log::Empire - Log::EmpireAdminNotes - Log::EmpireNameChange - Log::EmpireRPC - Log::Essentia - Log::Login - Log::Lottery - Log::Mission - Log::RPC - Log::Spies - Log::Viral - Log::WeeklyMedalWinner - Log::WithEmpire - Map - Map::Body - Map::Body::Asteroid - Map::Body::Asteroid::A1 - Map::Body::Asteroid::A10 - Map::Body::Asteroid::A11 - Map::Body::Asteroid::A12 - Map::Body::Asteroid::A13 - Map::Body::Asteroid::A14 - Map::Body::Asteroid::A15 - Map::Body::Asteroid::A16 - Map::Body::Asteroid::A17 - Map::Body::Asteroid::A18 - Map::Body::Asteroid::A19 - Map::Body::Asteroid::A2 - Map::Body::Asteroid::A20 - Map::Body::Asteroid::A21 - Map::Body::Asteroid::A22 - Map::Body::Asteroid::A23 - Map::Body::Asteroid::A24 - Map::Body::Asteroid::A25 - Map::Body::Asteroid::A26 - Map::Body::Asteroid::A3 - Map::Body::Asteroid::A4 - Map::Body::Asteroid::A5 - Map::Body::Asteroid::A6 - Map::Body::Asteroid::A7 - Map::Body::Asteroid::A8 - Map::Body::Asteroid::A9 - Map::Body::Planet - Map::Body::Planet::GasGiant - Map::Body::Planet::GasGiant::G1 - Map::Body::Planet::GasGiant::G2 - Map::Body::Planet::GasGiant::G3 - Map::Body::Planet::GasGiant::G4 - Map::Body::Planet::GasGiant::G5 - Map::Body::Planet::P1 - Map::Body::Planet::P10 - Map::Body::Planet::P11 - Map::Body::Planet::P12 - Map::Body::Planet::P13 - Map::Body::Planet::P14 - Map::Body::Planet::P15 - Map::Body::Planet::P16 - Map::Body::Planet::P17 - Map::Body::Planet::P18 - Map::Body::Planet::P19 - Map::Body::Planet::P2 - Map::Body::Planet::P20 - Map::Body::Planet::P21 - Map::Body::Planet::P22 - Map::Body::Planet::P23 - Map::Body::Planet::P24 - Map::Body::Planet::P25 - Map::Body::Planet::P26 - Map::Body::Planet::P27 - Map::Body::Planet::P28 - Map::Body::Planet::P29 - Map::Body::Planet::P3 - Map::Body::Planet::P30 - Map::Body::Planet::P31 - Map::Body::Planet::P32 - Map::Body::Planet::P33 - Map::Body::Planet::P34 - Map::Body::Planet::P35 - Map::Body::Planet::P36 - Map::Body::Planet::P37 - Map::Body::Planet::P38 - Map::Body::Planet::P39 - Map::Body::Planet::P4 - Map::Body::Planet::P40 - Map::Body::Planet::P5 - Map::Body::Planet::P6 - Map::Body::Planet::P7 - Map::Body::Planet::P8 - Map::Body::Planet::P9 - Map::Body::Planet::Station - Map::Star - Map::StarLite - Market - Medals - MercenaryMarket - Message - MiningPlatforms - Mission - News - Plan - Probes - Promotion - Promotion::Bonus50 - Promotion::BonusEssentia - Promotion::ECode50 - Promotion::EssentiaCode - Promotion::Valentine50 - Propositions - Propositions::AbandonStation - Propositions::BHGNeutralized - Propositions::BHGPassport - Propositions::BroadcastOnNetwork19 - Propositions::DemolishModule - Propositions::DowngradeModule - Propositions::ElectNewLeader - Propositions::EnactWrit - Propositions::EvictExcavator - Propositions::EvictMiningPlatform - Propositions::ExpelMember - Propositions::FireBfg - Propositions::ForeignAid - Propositions::InductMember - Propositions::InstallModule - Propositions::MembersOnlyColonization - Propositions::MembersOnlyExcavation - Propositions::MembersOnlyMiningRights - Propositions::MembersOnlyStations - Propositions::RenameAsteroid - Propositions::RenameStar - Propositions::RenameStation - Propositions::RenameUninhabited - Propositions::RepairModule - Propositions::RepealLaw - Propositions::Taxation - Propositions::TransferStationOwnership - Propositions::UpgradeModule - Schedule - Ships - Ships::AttackGroup - Ships::Barge - Ships::Bleeder - Ships::CargoShip - Ships::ColonyShip - Ships::Detonator - Ships::Dory - Ships::Drone - Ships::Excavator - Ships::Fighter - Ships::FissureSealer - Ships::Freighter - Ships::Galleon - Ships::GasGiantSettlementPlatformShip - Ships::Hulk - Ships::HulkFast - Ships::HulkHuge - Ships::MiningPlatformShip - Ships::ObservatorySeeker - Ships::Placebo - Ships::Placebo2 - Ships::Placebo3 - Ships::Placebo4 - Ships::Placebo5 - Ships::Placebo6 - Ships::Probe - Ships::Scanner - Ships::Scow - Ships::ScowFast - Ships::ScowLarge - Ships::ScowMega - Ships::SecurityMinistrySeeker - Ships::ShortRangeColonyShip - Ships::SmugglerShip - Ships::Snark - Ships::Snark2 - Ships::Snark3 - Ships::SpacePortSeeker - Ships::SpaceStation - Ships::SpyPod - Ships::SpyShuttle - Ships::Stake - Ships::SupplyPod - Ships::SupplyPod2 - Ships::SupplyPod3 - Ships::SupplyPod4 - Ships::SupplyPod5 - Ships::Surveyor - Ships::Sweeper - Ships::TerraformingPlatformShip - Ships::Thud - SitterAuths - Spies - StationInfluence - SupplyChain - Survey - Taxes - Votes - WasteChain parser_type: SQL::Translator::Parser::DBIx::Class producer_args: {} producer_type: SQL::Translator::Producer::YAML show_warnings: 0 trace: 0 version: 1.66