--
drop table if exists `cfstat_admin`;
--
CREATE TABLE `cfstat_admin` (
  `id` int(12) NOT NULL auto_increment,
  `admin` varchar(50) NOT NULL default '',
  `pwd` varchar(50) NOT NULL default '',
  `systitle` varchar(50) NOT NULL,
  `regstate` tinyint(1) NOT NULL default '-1',
  `regadmincheck` tinyint(1) NOT NULL default '0',
  `styletotal` int(12) NOT NULL default '60',
  `lastdeldate` date NOT NULL default '2000-01-01',
  `skintype` int(12) NOT NULL default '0',
  `skincolor` varchar(50) NOT NULL default 'C9DDF0|F3F9FE',
  `smtpaddress` varchar(50) NOT NULL,
  `smtpuser` varchar(50) NOT NULL,
  `smtppassword` varchar(50) NOT NULL,
  `allsearch` text NOT NULL,
  `otherset` text NOT NULL,
  `admincode` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `admin` (`admin`),
  UNIQUE KEY `admincode` (`admincode`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_alexa_day`;
--
CREATE TABLE `cfstat_alexa_day` (
  `id` int(12) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `ipcounter` int(12) NOT NULL default '1',
  `adddate` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`,`adddate`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_count_day`;
--
CREATE TABLE `cfstat_count_day` (
  `id` int(12) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `mycounter` int(12) NOT NULL default '1',
  `ipcounter` int(12) NOT NULL default '1',
  `adddate` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`,`adddate`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_count_hour`;
--
CREATE TABLE `cfstat_count_hour` (
  `id` int(12) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `mycounter` int(12) NOT NULL default '1',
  `ipcounter` int(12) default '1',
  `adddate` date default '0000-00-00',
  `addhour` int(12) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`,`adddate`,`addhour`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_gbook`;
--
CREATE TABLE `cfstat_gbook` (
  `id` int(12) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL,
  `content` text NOT NULL,
  `contact` text NOT NULL,
  `ly` varchar(255) NOT NULL,
  `currweb` varchar(255) NOT NULL,
  `addtime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_ipaddress`;
--
CREATE TABLE `cfstat_ipaddress` (
  `id` int(11) NOT NULL auto_increment,
  `ip_1` bigint(10) NOT NULL default '0',
  `ip_2` bigint(10) NOT NULL default '0',
  `area` varchar(255) default NULL,
  `area_2` varchar(255) default NULL,
  `area_3` varchar(255) default NULL,
  `area_4` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ip_1` (`ip_1`,`ip_2`)
) ENGINE=MyISAM AUTO_INCREMENT=25319 DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_ly_day`;
--
CREATE TABLE `cfstat_ly_day` (
  `id` int(12) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `ip` varchar(50) NOT NULL default '',
  `lyhead` varchar(255) NOT NULL default '',
  `mycounter` int(12) NOT NULL default '1',
  `ipcounter` int(12) NOT NULL default '1',
  `ly` varchar(255) NOT NULL default '',
  `adddate` date NOT NULL default '0000-00-00',
  `addtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `lasttime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`,`lyhead`,`adddate`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_search_day`;
--
CREATE TABLE `cfstat_search_day` (
  `id` int(12) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `siteflag` varchar(50) NOT NULL default '',
  `mycounter` int(12) NOT NULL default '1',
  `ipcounter` int(12) NOT NULL default '1',
  `adddate` date NOT NULL default '2000-01-01',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`,`siteflag`,`adddate`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_search_set`;
--
CREATE TABLE `cfstat_search_set` (
  `id` int(12) NOT NULL auto_increment,
  `sitedesc` varchar(50) NOT NULL default '',
  `siteflag` varchar(50) NOT NULL default '',
  `keywordflag` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `siteflag` (`siteflag`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_searchkeyword_day`;
--
CREATE TABLE `cfstat_searchkeyword_day` (
  `id` int(12) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `siteflag` varchar(50) NOT NULL default '',
  `keyword` varchar(50) NOT NULL default '',
  `mycounter` int(12) NOT NULL default '1',
  `ipcounter` int(12) NOT NULL default '1',
  `adddate` date NOT NULL default '0000-00-00',
  `addtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `lasttime` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastly` varchar(255) NOT NULL default '',
  `indexcode` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `indexcode` (`indexcode`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_upfile`;
--
CREATE TABLE `cfstat_upfile` (
  `id` int(11) NOT NULL auto_increment,
  `filename` varchar(50) default NULL,
  `filesizenum` int(11) default '0',
  `addtime` datetime default '2000-01-01 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `filename` (`filename`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_user`;
--
CREATE TABLE `cfstat_user` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `pwd` varchar(50) NOT NULL default '',
  `pwd_view` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `qq` varchar(50) NOT NULL,
  `pagename` varchar(50) NOT NULL default '',
  `pageurl` varchar(50) NOT NULL default '',
  `showtotal` int(12) NOT NULL default '0',
  `realshowtotal` int(12) NOT NULL default '0',
  `realiptotal` int(12) NOT NULL default '0',
  `adddate` date NOT NULL default '2000-01-01',
  `countershow` tinyint(1) NOT NULL default '1',
  `style` int(12) NOT NULL default '1',
  `imgfilename` varchar(50) NOT NULL default 'default.jpg',
  `imgselftext` varchar(2000) NOT NULL default '',
  `gbookstate` smallint(1) NOT NULL default '-1',
  `userstate` smallint(1) NOT NULL default '-1',
  `otherset` text NOT NULL,
  `usercode` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `usercode` (`usercode`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_visit_last`;
--
CREATE TABLE `cfstat_visit_last` (
  `id` int(12) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `ip` varchar(50) NOT NULL default '',
  `pvtotal` int(12) NOT NULL default '1',
  `ly` varchar(255) NOT NULL default '',
  `currweb` varchar(255) NOT NULL default '',
  `addtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `lasttime` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastmicrotime` varchar(50) NOT NULL default '',
  `screenwidth` int(12) NOT NULL default '0',
  `screenheight` int(12) NOT NULL default '0',
  `screencolordepth` int(12) NOT NULL default '0',
  `ostype` varchar(50) NOT NULL default '',
  `browsertype` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312;

--
drop table if exists `cfstat_web_day`;
--
CREATE TABLE `cfstat_web_day` (
  `id` int(12) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `weburl` varchar(255) NOT NULL default '',
  `mycounter` int(12) NOT NULL default '1',
  `adddate` date NOT NULL default '0000-00-00',
  `addtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `lasttime` datetime NOT NULL default '0000-00-00 00:00:00',
  `indexcode` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `indexcode` (`indexcode`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;
--
INSERT INTO `cfstat_admin` VALUES ('1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '˷ûPHPͳϵͳ', '-1', '0', '60', '2009-07-29', '0', 'C9DDF0|F3F9FE', 'smtp.qq.com', 'a@qq.com', 'b', 'bing.com,q|yodao.com,q;lq|msn.com;live.com,q|yahoo.com;yahoo.cn;yahoo.com.cn,p|soso.com,w|sogou.com,query|zhongsou.com,word;w|google.com;google.cn;g.cn,q|baidu.com;baidu.com.cn;baidu.cn,wd;kw;word', '', '625997dcf606aba9b002664b14a3bd39');
--
insert  into `cfstat_search_set`(`id`,`sitedesc`,`siteflag`,`keywordflag`) values (1,'ٶ','baidu.com;baidu.com.cn;baidu.cn','wd;kw;word'),(16,'','yodao.com','q;lq'),(9,'google','google.com;google.cn;g.cn','q'),(10,'й','zhongsou.com','word;w'),(11,'ѹ','sogou.com','query'),(13,'soso','soso.com','w'),(14,'Ż','yahoo.com;yahoo.cn;yahoo.com.cn','p'),(15,'msn','msn.com;live.com','q'),(17,'΢Ӧ','bing.com','q');
--
insert  into `cfstat_upfile`(`id`,`filename`,`filesizenum`,`addtime`) values (10,'sys-img-1248770767.jpg',21677,'2008-01-01 00:00:00'),(11,'sys-img-1248770771.jpg',16968,'2008-01-01 00:00:00'),(12,'sys-img-1248770777.jpg',15850,'2008-01-01 00:00:00'),(13,'sys-img-1248770781.jpg',21154,'2008-01-01 00:00:00'),(14,'sys-img-1248770784.jpg',18084,'2008-01-01 00:00:00'),(15,'sys-img-1248770789.jpg',18214,'2008-01-01 00:00:00'),(16,'sys-img-1248770793.jpg',16432,'2008-01-01 00:00:00'),(17,'sys-img-1248770797.jpg',17970,'2008-01-01 00:00:00'),(20,'sys-img-1248772650.jpg',11469,'2008-01-01 00:00:00'),(21,'sys-img-292684185.jpg',28000,'2009-01-01 00:00:00'),(22,'sys-img-292684277.jpg',11000,'2009-01-01 00:00:00'),(23,'sys-img-292684317.jpg',20000,'2009-01-01 00:00:00'),(24,'sys-img-292684349.jpg',14000,'2009-01-01 00:00:00'),(25,'sys-img-292684416.jpg',35000,'2009-01-01 00:00:00'),(26,'sys-img-292684425.jpg',25000,'2009-01-01 00:00:00'),(27,'sys-img-292684438.jpg',31000,'2009-01-01 00:00:00'),(28,'sys-img-292684443.jpg',26000,'2009-01-01 00:00:00'),(29,'sys-img-292684450.jpg',38000,'2009-01-01 00:00:00'),(30,'sys-img-292684456.jpg',34000,'2009-01-01 00:00:00'),(31,'sys-img-292684463.jpg',32000,'2009-01-01 00:00:00'),(32,'sys-img-292684469.jpg',46000,'2009-01-01 00:00:00'),(33,'sys-img-292684474.jpg',34000,'2009-01-01 00:00:00'),(34,'sys-img-292684510.jpg',17000,'2009-01-01 00:00:00'),(35,'sys-img-292684515.jpg',34000,'2009-01-01 00:00:00'),(36,'sys-img-292684526.jpg',9000,'2009-01-01 00:00:00'),(37,'sys-img-296129735.jpg',34000,'2009-01-01 00:00:00'),(38,'sys-img-296129743.jpg',14000,'2009-01-01 00:00:00'),(39,'sys-img-296129767.jpg',48000,'2009-01-01 00:00:00'),(40,'sys-img-296129774.jpg',50000,'2009-01-01 00:00:00'),(41,'sys-img-296129783.jpg',41000,'2009-01-01 00:00:00'),(42,'sys-img-296129920.jpg',7000,'2009-01-01 00:00:00'),(43,'sys-img-296129925.jpg',39000,'2009-01-01 00:00:00'),(44,'sys-img-296129931.jpg',42000,'2009-01-01 00:00:00'),(45,'sys-img-296129986.jpg',44000,'2009-01-01 00:00:00'),(46,'sys-img-296130164.jpg',39000,'2009-01-01 00:00:00'),(47,'sys-img-296130285.jpg',31000,'2009-01-01 00:00:00'),(48,'sys-img-296130289.jpg',44000,'2009-01-01 00:00:00'),(49,'sys-img-296130322.jpg',34000,'2009-01-01 00:00:00'),(50,'sys-img-296130332.jpg',34000,'2009-01-01 00:00:00'),(51,'sys-img-303338023.jpg',4000,'2009-01-01 00:00:00'),(52,'sys-img-303338061.jpg',5000,'2009-01-01 00:00:00'),(53,'sys-img-303338067.jpg',3000,'2009-01-01 00:00:00'),(54,'sys-img-303338072.jpg',4000,'2009-01-01 00:00:00');
--
INSERT INTO `cfstat_user` VALUES ('1', 'qqcf', '2b87724f92b8e739d0ac37c8b036b6c1', '2b87724f92b8e739d0ac37c8b036b6c1', '178575@qq.com', '', '˷ԭ', 'http://www.qqcf.com', '101256', '2012', '301', '2006-06-09', '1', '4', 'default.jpg', '\r\nܷ:{imgcounter} \r\nPV:{todaytotal} \r\nIP:{todayiptotal} \r\nPV:{yesterdaytotal} \r\nIP:{yesterdayiptotal} \r\nIP:{ip} ', '-1', '-1', '', '3d5fed4ecc0bbee777edee3ee85eae94');