open qoob framework

db.sql

--
-- Database: `qoob`
--

-- --------------------------------------------------------

--
-- Table structure for table `stats`
--

CREATE TABLE IF NOT EXISTS `stats` (
  `auto_id` int(255) NOT NULL AUTO_INCREMENT,
  `time` int(255) NOT NULL,
  `domain` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `uri` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `url_checksum` int(10) NOT NULL,
  `verb` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ajax` int(1) NOT NULL,
  `status` int(3) NOT NULL DEFAULT '200',
  `referer` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `referer_domain` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `referer_checksum` int(10) NOT NULL,
  `browser` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `version` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `platform` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `useragent` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `ipaddress` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `hostname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`auto_id`),
  KEY `url_checksum` (`url_checksum`,`referer_checksum`,`browser`,`platform`,`type`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;