here's a dump of the mysql database
# phpMyAdmin MySQL-Dump
# version 2.3.2
#
http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Feb 14, 2003 at 11:36 AM
# Server version: 3.23.54
# PHP Version: 4.3.0
# Database : `FS2Open`
# --------------------------------------------------------
#
# Table structure for table `Missions`
#
CREATE TABLE Missions (
FileName text,
CRC32 int(11) default NULL,
Type tinytext,
Players tinyint(4) default NULL,
Description text,
Mod tinytext NOT NULL
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `Pilot`
#
CREATE TABLE Pilot (
UserName tinytext,
PilotName tinytext,
Points bigint(20) unsigned NOT NULL default '0',
Missions int(10) unsigned NOT NULL default '0',
Time bigint(20) unsigned NOT NULL default '0',
LastFlight timestamp(14) NOT NULL,
Kills int(10) unsigned NOT NULL default '0',
Assists int(10) unsigned NOT NULL default '0',
FriendlyKills int(10) unsigned NOT NULL default '0',
PriShots int(10) unsigned NOT NULL default '0',
PriHits int(10) unsigned NOT NULL default '0',
PriFHits int(10) unsigned NOT NULL default '0',
SecShots int(10) unsigned NOT NULL default '0',
SecHits int(10) unsigned NOT NULL default '0',
SecFHist int(10) unsigned NOT NULL default '0',
KillsType blob
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `Tables`
#
CREATE TABLE Tables (
FileName tinytext NOT NULL,
CRC32 int(11) NOT NULL default '0',
Mod tinytext NOT NULL
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `UserAccounts`
#
CREATE TABLE UserAccounts (
UserName tinytext,
PassWord tinytext,
Email tinytext,
Squadron tinytext
) TYPE=MyISAM;