fBeHazzT

1package database
2
3func ResetTables() error {
4	dbh, err := NewDBHandler()
5	if err != nil {
6		return err
7	}
8
9	_, err = dbh.Connection.Exec(`drop table games;
10delete from users;
11delete from players;
12CREATE TABLE IF NOT EXISTS games (
13                                     game_id INTEGER PRIMARY KEY AUTOINCREMENT,
14                                     game_json TEXT,
15                                     player_id INTEGER,
16                                     startmove_time INTEGER,
17                                     players_json TEXT,
18                                     red_spawn INTEGER,
19                                     green_spawn INTEGER,
20                                     blue_spawn INTEGER,
21                                     state INTEGER);`)
22	return err
23}