Riye2cgU

1drop table if exists turns;
2drop table if exists games;
3drop table if exists players;
4
5create table if not exists turns (
6    games_id integer not null, 
7    player_id integer not null,
8    turn text not null,
9    tstamp datetime default current_timestamp
10);
11
12create table if not exists games (
13    player_id integer not null,
14    player_id2 integer,
15    tstamp datetime default current_timestamp
16);
17
18create table if not exists players (
19    create_tstamp datetime default current_timestamp,
20    login_tstamp datetime default current_timestamp
21);