Skip to content

Releases: stfc2/Database

Added key indexes

14 Oct 13:57
Compare
Choose a tag to compare

Added key index for tables:

  • alliance_taxes
  • ships

Fixed tables indexes

14 Oct 13:55
Compare
Choose a tag to compare

Some tables had duplicated keys while others didn't have any.

Some COMMENT options in CREATE TABLE commands had a wrong syntax.

Increased building queue length

14 Oct 09:09
Compare
Choose a tag to compare

Increased the queue length for "Buildings" menu. The length of the queue can be varied changing the value of
BUILDING_QUEUE_LEN constant defined in the file UI/game/include/global.php.

In order to work properly the minimum required version of the UI is v1.2.9, and the minimum required version of the Scheduler is v1.1.6.

Added structures for Settlers NPC

14 Oct 08:57
Compare
Choose a tag to compare

Added to the DB the following tables:

  • settlers_events
  • settlers_relations

Added to config table the following fields:

  • settler_tmp_1
  • settler_tmp_2
  • settler_tmp_3
  • settler_tmp_4

Added to planets table the following fields:

  • best_mood
  • best_mood_user
  • best_mood_planet

Added to ships table the following fields:

  • awayteam
  • awayteamplanet_id

Added to user table the following fields:

  • user_charted
  • user_first_contact
  • user_settler_made
  • user_settler_best
  • user_tform_planets

to implement last version of Settlers NPC.

Added structures for Borg NPC

14 Oct 08:22
Compare
Choose a tag to compare

Added to the DB the following tables:

  • borg_bot
  • borg_npc_target
  • borg_target
  • future_human_reward

Added field npc_last_action to the following table:

  • planets
  • ship_fleets

to implement last version of Borg NPC.

First release published

13 Oct 13:39
Compare
Choose a tag to compare
Pre-release

This is an "historical" version of the database structure more or less matching the original version.