Rick Hays
0ee1c5b006
Updated DB Schema with current table structure. Signed-off-by: Rick Hays <rhays@haysgang.com>
47 lines
1.0 KiB
Plaintext
47 lines
1.0 KiB
Plaintext
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);
|
|
|