drop table if exists `jihadKills`;
create table `jihadKills` (
	id 	bigint AUTO_INCREMENT PRIMARY KEY,
	tstamp	timestamp,

	srcID	int not null,
	killID	int not null,

	name		char(100),
	corp		char(100),
	alliance	char(100),
	ship		char(100),
	damage		integer,
	system		char(100),
	ktime		datetime,

	unique key	ids (killID,srcID)
	);

drop table if exists `jihadKillers`;
create table `jihadKillers` (
	id 	bigint AUTO_INCREMENT PRIMARY KEY,
	tstamp	timestamp,

	srcID	int not null,
	killID	int not null,

	name		char(100),
	security	float,
	alliance	char(100),
	corp		char(100),
	ship		char(100),
	weapon		char(100),
	damage		integer,

	unique key	ids (killID,srcID,name)
	);

drop table if exists `jihadKillmails`;
create table `jihadKillmails` (
	id 	bigint AUTO_INCREMENT PRIMARY KEY,
	tstamp	timestamp,

	srcID	int not null,
	killID	int not null,

	mail	text,

	unique key	ids (killID,srcID)
	);