protected override void CreateTable()
{
using (var rCommand = Connection.CreateCommand())
{
rCommand.CommandText =
"CREATE TABLE IF NOT EXISTS battle(" +
"id INTEGER PRIMARY KEY, " +
"rank INTEGER, " +
"dropped_ship INTEGER, " +
"mvp INTEGER, " +
"mvp_escort INTEGER);" +
"CREATE TABLE IF NOT EXISTS battle_dropped_item(" +
"id INTEGER PRIMARY KEY NOT NULL REFERENCES battle(id), " +
"item INTEGER NOT NULL);" +
"CREATE TABLE IF NOT EXISTS battle_participant(" +
"battle INTEGER NOT NULL REFERENCES battle(id), " +
"ship INTEGER NOT NULL, " +
"level INTEGER NOT NULL, " +
"PRIMARY KEY(battle, ship)) WITHOUT ROWID;";
rCommand.ExecuteNonQuery();
}
}