ESEA Sample Problem

-- Host: localhost Database: esea

-- Server version 5.5.42-log

DROP TABLE IF EXISTS maps;

CREATE TABLE maps (

id int(11) unsigned NOT NULL AUTO_INCREMENT,

name varchar(32) DEFAULT NULL,

PRIMARY KEY (id),

UNIQUE KEY unqiue_name (name),

KEY map_id_index (id)

) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS match_results;

CREATE TABLE match_results (

match_id int(11) unsigned NOT NULL,

team_id int(11) unsigned NOT NULL,

score int(11) DEFAULT NULL,

status int(11) NOT NULL,

KEY mr_id_index (match_id),

KEY mr_ti_index (team_id),

KEY mr_status_index (status)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS matches;

CREATE TABLE matches (

id int(11) unsigned NOT NULL AUTO_INCREMENT,

date datetime NOT NULL,

map int(11) unsigned NOT NULL,

PRIMARY KEY (id),

KEY m_id_index (id),

KEY m_date_index (date)

) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS statuses;

CREATE TABLE statuses (

id int(11) unsigned NOT NULL AUTO_INCREMENT,

name varchar(16) NOT NULL DEFAULT '',

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS teams;

CREATE TABLE teams (

id int(11) unsigned NOT NULL AUTO_INCREMENT,

name varchar(64) NOT NULL DEFAULT '',

PRIMARY KEY (id),

UNIQUE KEY unique_name (name),

KEY t_id_index (id)

) ENGINE=InnoDB AUTO_INCREMENT=2001 DEFAULT CHARSET=utf8;