eq2_database_schema

[kouhei]

I am tring to find the sql for the database. I tried doing a search for database schemas. Is there a link to the sql files.

[alfa]

For now the only way to get database is to run server with correct DB options (server will download and create/update your DB

[Diamente]

Assuming you have your own server setup, you can always get a (basic) schema by doing

Code: Select all

mysqldump --no-data eq2 -uroot -p[your mysql root password] > c:\eq2_database.sql

Until we get some code and database development information into the Wiki, this is the best bet for getting an idea of the schema.
Also note that the database schema is still in as much of an Alpha stage as the Emulator code itself, so it may change frequently. Until we get pretty steady with the way the database is designed, we will probably hold off on a fancy "official" schema in the Wiki.