diff options
Diffstat (limited to 'devtools/processgamestats/ep1_gamestats.db')
| -rw-r--r-- | devtools/processgamestats/ep1_gamestats.db | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/devtools/processgamestats/ep1_gamestats.db b/devtools/processgamestats/ep1_gamestats.db new file mode 100644 index 0000000..a8b05dd --- /dev/null +++ b/devtools/processgamestats/ep1_gamestats.db @@ -0,0 +1,47 @@ +# create database gamestats; +# use gamestats; + +create table ep1 +( + UserID CHAR(16), + PRIMARY KEY( UserID ), + LastUpdate DATETIME, + KEY( LastUpdate ), + Version TINYINT, + Count INT, + Seconds INT, + HDR INT, + Captions INT, + Commentary INT, + Easy INT, + Medium INT, + Hard INT, + nonsteam TINYINT, + cybercafe TINYINT, + hl2_chapter TINYINT, + SecondsToCompleteGame INT, # Non-zero if user has completed game + HighestMap CHAR(16), + DXLevel INT, + Deaths INT, +) TYPE=MyISAM; + +create table ep1_maps +( + UserID CHAR(16), + MapName CHAR(16), + PRIMARY KEY( UserID,MapName ), + LastUpdate DATETIME, + KEY( LastUpdate ), + Version TINYINT, + Count INT, + Seconds INT, + HDR INT, + Captions INT, + Commentary INT, + Easy INT, + Medium INT, + Hard INT, + nonsteam TINYINT, + cybercafe TINYINT, + Deaths INT, +) TYPE=MyISAM;
\ No newline at end of file |