create table Log
(
    id       INTEGER
        primary key autoincrement,
    IP       text not null,
    City     text not null,
    State    text not null,
    Country  text not null,
    DateTime date
);

create table plays
(
    id           INTEGER
        primary key autoincrement,
    UserID       text not null,
    UserName     text not null,
    IP           text not null,
    PlayerPick   text not null,
    ComputerPick text not null,
    Result       text not null,
    DateTime     date
);

create table users
(
    id          INTEGER
        primary key autoincrement,
    UserName    text not null,
    Wins        int default 0 not null,
    Loses       int default 0 not null,
    Ties        int default 0 not null,
    IP          text not null,
    City        text not null,
    State       text not null,
    Country     text not null,
    CountryCode text not null,
    FlagURL     text not null,
    DateCreated date,
    DateUpdated date,
    DateDeleted date
);

create unique index users_UserName
    on users (UserName);