CREATE TABLE IF NOT EXISTS gen9computergeneratedteams (
	species_id TEXT PRIMARY KEY,
	wins NUMBER NOT NULL,
	losses NUMBER NOT NULL,
	level NUMBER NOT NULL
);

CREATE INDEX IF NOT EXISTS gen9computergeneratedteams_species_id_level ON gen9computergeneratedteams(species_id, level);

CREATE TABLE IF NOT EXISTS gen9_historical_levels (
	species_id TEXT NOT NULL,
	level NUMBER NOT NULL,
	timestamp NUMBER NOT NULL
);
PRAGMA journal_mode=WAL;
