clans.json

[{
	"score": "14",
	"clan_kills": "2",
	"civilian_kills": "2",
	"deaths": "0",
	"name": "West Road Allance",
	"color_tag": "WRA"
}, {
	"score": "-3",
	"clan_kills": "0",
	"civilian_kills": "1",
	"deaths": "4",
	"name": "Team Stooge",
	"color_tag": "TS"
}]

player.json

[{
	"name": "Bluuefuzzy",
	"clan_name": "West Road Allance",
	"score": "18"
}, {
	"name": "C45Y",
	"clan_name": "Team Stooge",
	"score": "-1"
}]

schema.sql

CREATE TABLE `sc_players` ( 
	`id` bigint(20), 
	`name` varchar(16) NOT NULL, 
	`leader` tinyint(1) default '0', 
	`tag` varchar(25) NOT NULL, 
	`friendly_fire` tinyint(1) default '0', 
	`neutral_kills` int(11) default NULL, 
	`rival_kills` int(11) default NULL, 
	`civilian_kills` int(11) default NULL, 
	`deaths` int(11) default NULL, 
	`last_seen` bigint NOT NULL, 
	`join_date` bigint NOT NULL, 
	`trusted` tinyint(1) default '0', 
	`flags` text NOT NULL, 
	`packed_past_clans` text, 
	uuid VARCHAR( 255 ) DEFAULT NULL, 

	PRIMARY KEY  (`id`), UNIQUE (`name`)
);

CREATE UNIQUE INDEX `uq_player_uuid` ON `sc_players` (`uuid`);

CREATE TABLE `sc_kills` ( 
	`kill_id` bigint(20), 
	`attacker` varchar(16) NOT NULL, 
	`attacker_tag` varchar(16) NOT NULL, 
	`victim` varchar(16) NOT NULL, 
	`victim_tag` varchar(16) NOT NULL, 
	`kill_type` varchar(1) NOT NULL, 
	attacker_uuid VARCHAR( 255 ) DEFAULT NULL, 
	victim_uuid VARCHAR( 255 ) DEFAULT NULL, 

	PRIMARY KEY  (`kill_id`)
);

CREATE TABLE `sc_clans` ( 
	`id` bigint(20), 
	`verified` tinyint(1) default '0', 
	`tag` varchar(25) NOT NULL, 
	`color_tag` varchar(25) NOT NULL, 
	`name` varchar(100) NOT NULL, 
	`friendly_fire` tinyint(1) default '0', 
	`founded` bigint NOT NULL, 
	`last_used` bigint NOT NULL, 
	`packed_allies` text NOT NULL, 
	`packed_rivals` text NOT NULL, 
	`packed_bb` mediumtext NOT NULL, 
	`cape_url` varchar(255) NOT NULL, 
	`flags` text NOT NULL, 
	`balance` double(64,2) default 0.0,  

	PRIMARY KEY  (`id`), UNIQUE (`tag`)
);

timeline.json

[{
	"attacker": "Bluuefuzzy",
	"kill_type": "c",
	"name": "West Road Allance",
	"victim": "C45Y"
}, {
	"attacker": "Bluuefuzzy",
	"kill_type": "c",
	"name": "West Road Allance",
	"victim": "ProbablyNotC45Y"
}, {
	"attacker": "Bluuefuzzy",
	"kill_type": "n",
	"name": "West Road Allance",
	"victim": "C45Y"
}, {
	"attacker": "Bluuefuzzy",
	"kill_type": "n",
	"name": "West Road Allance",
	"victim": "C45Y"
}, {
	"attacker": "C45Y",
	"kill_type": "c",
	"name": "Team Stooge",
	"victim": "ProbablyNotC45Y"
}]