* common/Database.cpp: Fix referrential integrity now that inherited
tables are not being used. Removes FIXMEs relating to that and
the database maintenance code which have now been fixed.
* common/Database.cpp: Re-enable referential integrity on relational
tables. Clean up the query generation code.
* server/Persistance.cpp: Correct the table names used for the
relation used to store character ownership.
* common/const.h: Add a constant for the name length limit of
rule IDs and property names.
* common/Database.cpp: Use the name length constant for database
fields that will store the name.
* server/EntityFactory.cpp: Check class names do not violate a
32 character limit before installing them, so they never get
as far as the database limit.
* common/Database.cpp: Modify the rules table so it limits
the ID to the right size.
* common/Database.cpp: Handle things correctly if scheduling an update
or insert query while the database is offline. Just ignore it and
keep the query queued.
* common/Database.cpp: Fix a problem where existing database tables
weren't added to the set for maintenance cycles. This should fix a
lot of major performance issues.
* common/Database.cpp: Add the new storage tables to those that
are vacuumed regularly. Add an index to the name of properties
to make them massively more efficient to update.
* common/Database.cpp: Add queries which purge the world state on
startup to prevent the tables from getting clogged up. Fix the
syntax of the query which removes deleted entity rows.
* common/Database.cpp, common/Database.h: Add method to remove
entities from the database store. Remove the foreign key index
constraint from the LOC column.
* common/Database.cpp: Add the location data to the database
insert query.
* server/Persistance.cpp: Modify the entity database table so it
has the right columns.
* server/StorageManager.cpp: Correctly check the orientation
valid flag before using it.
* common/Database.cpp, common/Database.h: Modify the Entity database
functions to include a chunk of text for location data.
* server/StorageManager.cpp: Implement naive storage of location
data to the database.
* common/Database.cpp: Implement updating modified properties.
* server/StorageManager.cpp: Tweak test properties values
so we can tell if one has been updated.
