Releases: stfc2/Database
Added key indexes
Fixed tables indexes
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
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
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
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
This is an "historical" version of the database structure more or less matching the original version.