CREATE TABLE browscap (
	parent varchar(64) NOT NULL default '',
	useragent varchar(255) NOT NULL default '',
	browser varchar(64) NOT NULL default '',
	version varchar(8) NOT NULL default '',
	majorver varchar(8) NOT NULL default '',
	minorver varchar(8) NOT NULL default '',
	platform varchar(8) NOT NULL default '',
	alpha tinyint(1) NOT NULL default '0',
	beta tinyint(1) NOT NULL default '0',
	win16 tinyint(1) NOT NULL default '0',
	win32 tinyint(1) NOT NULL default '0',
	win64 tinyint(1) NOT NULL default '0',
	frames tinyint(1) NOT NULL default '0',
	iframes tinyint(1) NOT NULL default '0',
	tables tinyint(1) NOT NULL default '0',
	cookies tinyint(1) NOT NULL default '0',
	backgroundsounds tinyint(1) NOT NULL default '0',
	authenticodeupdate varchar(8) NOT NULL default '',
	cdf tinyint(4) NOT NULL default '0',
	vbscript tinyint(1) NOT NULL default '0',
	javaapplets tinyint(1) NOT NULL default '0',
	javascript tinyint(1) NOT NULL default '0',
	activexcontrols tinyint(1) NOT NULL default '0',
	stripper tinyint(1) NOT NULL default '0',
	isbanned tinyint(1) NOT NULL default '0',
	wap tinyint(1) NOT NULL default '0',
	ismobiledevice tinyint(1) NOT NULL default '0',
	issyndicationreader tinyint(1) NOT NULL default '0',
	crawler tinyint(1) NOT NULL default '0',
	css tinyint(4) NOT NULL default '0',
	cssversion tinyint(4) NOT NULL default '0',
	supportscss tinyint(1) NOT NULL default '0',
	aolversion varchar(8) NOT NULL default '',
	aol tinyint(1) NOT NULL default '0',
	netclr tinyint(1) NOT NULL default '0',
	clrversion varchar(8) NOT NULL default '',
	internalid tinyint(4) NOT NULL default '0',
  	PRIMARY KEY  (useragent)
);


CREATE TABLE browscap_statistics (
  parent VARCHAR(255) NOT NULL,
  counter INT DEFAULT '0' NOT NULL,
  is_crawler TINYINT(1) DEFAULT '0' NOT NULL,
  PRIMARY KEY (parent)
);