rendered paste body
drop table player_stats;
CREATE TABLE player_stats (
stat_key varchar(255) NOT NULL default '',
score varchar(20) default NULL,
score_opposing varchar(20) default NULL,
score_attempts smallint default NULL,
score_attempts_opposing smallint default NULL,
score_percentage decimal(4,3) default NULL,
score_percentage_opposing decimal(4,3) default NULL,
events_played smallint default NULL,
events_started smallint default NULL,
time_played_event varchar(15) default NULL,
time_played_total varchar(15) default NULL,
time_played_event_average varchar(15) default NULL
)
within dbSportMaps/core.def, change section to:
[player_stats]
score:VARCHAR
score_opposing:VARCHAR
score_attempts:SMALLINT
score_attempts_opposing:SMALLINT
score_percentage:SMALLINT
score_percentage_opposing:SMALLINT
events_played:SMALLINT
events_started:SMALLINT
time_played_event:VARCHAR
time_played_total:VARCHAR
time_played_event_average:VARCHAR