Since SQLite is a file based database, we ship a set of release files fully configured with a database file that is already loaded with default data. All you have to do is setup the web, make the Data folder writable and you're ready to go. You can edit the content of the site after you login.

The instructions below are only here in case you want to create your own database instead of using the one included.

The preconfigured db, mojoportal.db, is located at WebRoot/Data/sqlitedb/
In the same folder you will also find the sqlite3.exe command line tool for Windows.

Open a command prompt and cd into this folder

To create a new database:

type sqlite3.exe yournewdbname.db

next while at the sqlite prompt type:

.read createtables.sql

this will run the script to create the tables.

Control C will exit the sqlite prompt.

You'll need to put the full path to
this file in the SqliteConnectionString in the Web.config.