protected override void CreateTable()
{
using (var rCommand = Connection.CreateCommand())
{
rCommand.CommandText = "CREATE TABLE IF NOT EXISTS sortie_map(" +
"id INTEGER PRIMARY KEY NOT NULL, " +
"is_event_map BOOLEAN NOT NULL);" +
"CREATE TABLE IF NOT EXISTS sortie_map_hp(" +
"id INTEGER PRIMARY KEY NOT NULL, " +
"difficulty INTEGER NOT NULL, " +
"hp INTEGER NOT NULL);" +
"CREATE TABLE IF NOT EXISTS sortie(" +
"id INTEGER PRIMARY KEY NOT NULL, " +
"map INTEGER NOT NULL REFERENCES sortie_map(id), " +
"difficulty INTEGER, " +
"return_time INTEGER, " +
"return_reason INTEGER, " +
"map_hp INTEGER);" +
"CREATE TABLE IF NOT EXISTS sortie_node(" +
"map INTEGER NOT NULL REFERENCES sortie_map(id), " +
"id INTEGER NOT NULL, " +
"type INTEGER NOT NULL, " +
"subtype INTEGER NOT NULL, " +
"PRIMARY KEY(map, id)) WITHOUT ROWID;" +
"CREATE TABLE IF NOT EXISTS sortie_detail(" +
"id INTEGER NOT NULL REFERENCES sortie(id), " +
"step INTEGER NOT NULL, " +
"node INTEGER NOT NULL, " +
"extra_info INTEGER, " +
"PRIMARY KEY(id, step)) WITHOUT ROWID;";
rCommand.ExecuteNonQuery();
}
}