Euroblitz

Internet Custom Templates and Scripts
5

Use the Code # button instead of quote to avoid unwanted smilies :wink:

CREATE TABLE IF NOT EXISTS `bo_hourly` (
  `time` INTEGER(15) NOT NULL,
  `strikes` INTEGER(6) NOT NULL,
  `st_strikes` INTEGER(8) NOT NULL,
  UNIQUE KEY `time` (`time`)
);# MySQL returned an empty result set (i.e. zero rows).


CREATE TABLE IF NOT EXISTS `bo_stat` (
  `date` date NOT NULL,
  `strikes` mediumint(11) unsigned NOT NULL DEFAULT '0',
  `maxdist` INTEGER(6) NOT NULL DEFAULT '0',
  `mindist` int(6) NOT NULL DEFAULT '999999',
  `maxstrikes` mediumint(11) unsigned NOT NULL DEFAULT '0',
  `maxtime` INTEGER(15) unsigned NOT NULL DEFAULT '0',
  `maxusers` INTEGER(6) NOT NULL DEFAULT '0',
  `st_strikes` INTEGER(8) NOT NULL,
  `st_mindist` INTEGER(6) NOT NULL DEFAULT '999999',
  `st_maxdist` INTEGER(6) NOT NULL DEFAULT '0',
  `st_max` INTEGER(6) NOT NULL,
  `st_maxtime` INTEGER(15) NOT NULL,
  KEY `time` (`date`)
);# MySQL returned an empty result set (i.e. zero rows).