This eighth post in the Milestone 2 database structure series describes the elements used to store ship designs – whether they are provided by the game as “defaults” or customised by players – and ships, as well as fleets and their current state (which, since there is no Hyperspace stand-by for now, is limited to [...]
Archive of entries posted on January 2011
Milestone 2 – Database contents – Empires & alliances
This post, the seventh in a series about Milestone 2′s database structure, describes the elements that are used to store information about empires. This includes the description of an empire itself, information about planets owned or visited by an empire, and diplomatic relations (enemies, allies and alliances).
Milestone 2 – Database contents – Universe
This sixth post from the Milestone 2 database structure series describes the information that is associated with the universe: the map and the objects that are on it, as well as the description of a planet’s surface and operation.
Milestone 2 – Database contents – Naming
This fifth post from the Milestone 2 database structure series describes the elements of the naming system. This system is used to store all names that may be modified by players (empires, alliances and “map objects”) and will be visible by everyone. Using a separate component for this makes administration a little easier.
Milestone 2 – Database contents – Administration
This fourth post about Milestone 2′s database structure describes all administration-related information. This includes administrative accounts (which are tied to, but separate from user accounts), the administration log, and of course the banhammer.
Milestone 2 – Database contents – Users
This third, and rather late, post about Milestone 2′s database structure describes the various elements that are part of the user account storage and management system. This includes accounts themselves, of course; however, a lot more is needed to fully describe the state of an account, and there is additional information to retain – for [...]