So I just created a refresh, and heres what I did to get to the latest and greatest DB.
db_dump.sql to start
then source load_bots
then source load_player
then you need to source the following from the serverSource/utils/sql/svn (the repo that has the server source)
1711_account_restricted_aa.sql (creates the creation_time column and solves the UNIX_TIMESTAMP() issue)
1723_required_sql_corruption.sql (I needed this to spawn bots)
Then I sourced everything from 1908 up to the last which is 1977. Some of these are optional, and you don't need them.
I have a "1977_wothbots_dump" that I now use to refresh my dev project, or to run comparison queries. If you're interested I can put it up somewhere for you. It's like 160 megs tho.
|