CREATE TABLE `#DB_MAIN_PREFIX#log` (
  `click_id` int(11) NOT NULL AUTO_INCREMENT,
  `click_time` datetime NOT NULL,
  `shorturl` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `referrer` varchar(200) NOT NULL,
  `user_agent` varchar(255) NOT NULL,
  `ip_address` varchar(41) NOT NULL,
  `country_code` char(2) NOT NULL,
  PRIMARY KEY (`click_id`),
  KEY `shorturl` (`shorturl`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE `#DB_MAIN_PREFIX#options` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(64) NOT NULL DEFAULT '',
  `option_value` longtext NOT NULL,
  PRIMARY KEY (`option_id`,`option_name`),
  KEY `option_name` (`option_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5;

INSERT INTO `#DB_MAIN_PREFIX#options` VALUES
(1, 'version', '1.7'),
(2, 'db_version', '482'),
(3, 'next_id', '1'),
(4, 'core_version_checks', 'O:8:"stdClass":4:{s:15:"failed_attempts";i:0;s:12:"last_attempt";i:1404806352;s:11:"last_result";O:8:"stdClass":2:{s:6:"latest";s:3:"1.7";s:6:"zipurl";s:54:"https://api.github.com/repos/YOURLS/YOURLS/zipball/1.7";}s:15:"version_checked";s:3:"1.7";}');

CREATE TABLE `#DB_MAIN_PREFIX#url` (
  `keyword` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `url` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `title` text,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(41) NOT NULL,
  `clicks` int(10) unsigned NOT NULL,
  PRIMARY KEY (`keyword`),
  KEY `timestamp` (`timestamp`),
  KEY `ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `#DB_MAIN_PREFIX#url` VALUES
('yourlsblog', 'http://blog.yourls.org/', 'YOURLS'' Blog', '#DATE#', '127.0.0.1', 0),
('yourls', 'http://yourls.org/', 'YOURLS: Your Own URL Shortener', '#DATE#', '127.0.0.1', 0),
('ozh', 'http://ozh.org/', 'ozh.org', '#DATE#', '127.0.0.1', 0);