Database creation sqlite - Dawn-of-Light/DOLSharp GitHub Wiki

The data storage for the DOL server requires a database : the one which will be created here is via Sqlite.

On Windows 10

The first step is install Sqlite tool on your system.

Go into the Eve-of-Darkness/public-db github repo.

Check the latest release defined for this repo and download the file named "public-db.sqlite.sql.7z"

Extract this archive in a dedicated directory.

A file named "public-db.sqlite.sql" should be created in this folder once the extraction is completed.

Populate the "dol" database with this file by launching the below sqlite command :

sqlite3.exe dol.sqlite3.db 

In the sql prompt type :

.dbconfig dqs_ddl on
.dbconfig dqs_dml on
.read public-db.sqlite.sql
.quit

[!NOTE] After a few minutes, your database is populated with all the data for NPC, items, spells, etc which are used by the DOL server.

---

On MacOS or Linux

The first step is install Sqlite tool on your system.

Then to populate the database, you need first to go into the Eve-of-Darkness/public-db github repo.

Check the latest release defined for this repo and download the file named "public-db.sqlite.sql.7z"

Extract this archive in a dedicated directory : 7z x public-db.sqlite.sql.7z

A file named "public-db.sqlite.sql" should be created in this folder once the extraction is completed.

Populate the "dol" database with this file by launching the below sqlite command :

sqlite3 dol.sqlite3.db 

In the sql prompt type :

.dbconfig dqs_ddl on
.dbconfig dqs_dml on
.read public-db.sqlite.sql
.quit

[!NOTE] After a few minutes, your database is populated with all the data for NPC, items, spells, etc which are used by the DOL server.