-
Notifications
You must be signed in to change notification settings - Fork 15
Recommended DB schema changes
Daniel Speichert edited this page Jul 19, 2014
·
2 revisions
Changes against schema.sql:
-
Create
towns
table that is synchronized with towns from the map on each TFS start.town_id
inplayers
andhouses
will not have foreign keys or if they will, will not CASCADE DELETE. -
Add foreign key in table
houses
forowner
toplayers
. It makes sense to require that the owner is a valid player in database. Do not CASCADE DELETE. -
Add foreign key in table
houses
forhighest_bidder
toplayers
. It makes sense to require that the highest bidder is a valid player in database. Do not CASCADE DELETE. -
Rename
creationdata
column tocreated_at
inguilds
table. -
Change collation from default/unspecified to utf8_unicode_ci/latin2. Not useful for Tibia Client but OTClient supports ISO/latin2.
-
Put bug reports into database.