Database Relationships

4 views

Skip to first unread message

Bodhis3mta3

unread,

Jul 2, 2014, 6:45:03 PM7/2/14

to towny-a...@googlegroups.com

First off, great plugin and thanks to the devs who keep it up to date. It works beautifully and I have no complaints.

I'm running the plugin against the SQL server and have it configured to backup on a daily basis. I keep a week's worth of .sql files then do some routine housekeeping. This works pretty well for me since I've had the VM crash once or twice; recovery is pretty swift and painless.

The thing is...once in a while some mayor inadvertently leaves their town (don't ask; they're not the brightest bunch and truth is its a chronic few). Its a bit of a nightmare to try and sift out their player info and get them restored. I've created a SQL query to parse out the info from the TOWNS and RESIDENTS tables by a JOIN on the residents field, but for the life of me can't see any relationship to the TOWNBLOCKS table. I'd like to be able to query the backups and export the info for ONE player. SO what do I JOIN on?