create table `bpo` (
	id      int AUTO_INCREMENT PRIMARY KEY,

	count	int,
	purpose	char(16),

	typeID	int,
	wantME	int,
	wantPE	int,
	batch	int,

	want	datetime,
	have	datetime,
	done	datetime,

	tstamp  timestamp,

	key      purpose (purpose),
	key      typeid (typeID)
);


create table `mapHighSec` (
	id      int AUTO_INCREMENT PRIMARY KEY,

	solarSystemID	int,
	isConnectedHighsec	int,
	jumpsFromJita	int,

	unique key      ss (solarSystemID)
);