
/*ݱ `cfstat_admin` ıṹ*/

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 '',
  `title` varchar(50) NOT NULL default '',
  `regstate` tinyint(1) NOT NULL default '-1',
  `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 'BFE7F1',
  `allsearch` text NOT NULL,
  `otherset` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `admin` (`admin`)
) TYPE=MyISAM;

/*ݱ `cfstat_admin` */

insert into `cfstat_admin` values (1,'admin','21232f297a57a5a743894a0e4a801fc3','˷ûPHPͳϵͳ',-1,60,'2007-11-09',0,'BFE7F1','3721.com,p|google.com,q|soso.com,w|iask.com,k|sogou.com,query|zhongsou.com,word;w|yahoo.com,p|msn.com,q|tom.com,word|google.cn,q|baidu.com,wd;kw;word','');

/*ݱ `cfstat_alexa_day` ıṹ*/

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`)
) TYPE=MyISAM;

/*ݱ `cfstat_alexa_day` */

/*ݱ `cfstat_count_day` ıṹ*/

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`)
) TYPE=MyISAM;

/*ݱ `cfstat_count_day` */

/*ݱ `cfstat_count_hour` ıṹ*/

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`)
) TYPE=MyISAM;

/*ݱ `cfstat_count_hour` */

/*ݱ `cfstat_ly_day` ıṹ*/

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`)
) TYPE=MyISAM;

/*ݱ `cfstat_ly_day` */

/*ݱ `cfstat_search_day` ıṹ*/

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`)
) TYPE=MyISAM;

/*ݱ `cfstat_search_day` */

/*ݱ `cfstat_search_set` ıṹ*/

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`)
) TYPE=MyISAM;

/*ݱ `cfstat_search_set` */

insert into `cfstat_search_set` values (1,'ٶ','baidu.com','wd;kw;word'),(6,'google','google.cn','q'),(7,'tom','tom.com','word'),(8,'msn','msn.com','q'),(9,'Ż','yahoo.com','p'),(10,'й','zhongsou.com','word;w'),(11,'Ѻѹ','sogou.com','query'),(12,'iask','iask.com','k'),(13,'soso','soso.com','w'),(14,'google','google.com','q'),(15,'3721','3721.com','p');

/*ݱ `cfstat_searchkeyword_day` ıṹ*/

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 '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`,`siteflag`,`keyword`,`adddate`)
) TYPE=MyISAM;

/*ݱ `cfstat_searchkeyword_day` */

/*ݱ `cfstat_user` ıṹ*/

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 '',
  `email` varchar(50) NOT NULL default '',
  `qq` varchar(50) NOT NULL default '',
  `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 '0000-00-00',
  `countershow` tinyint(1) NOT NULL default '1',
  `style` int(12) NOT NULL default '1',
  `otherset` text,
  `cookies` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `cookies` (`cookies`)
) TYPE=MyISAM;

/*ݱ `cfstat_user` */

insert into `cfstat_user` values (1,'qqcf','2b87724f92b8e739d0ac37c8b036b6c1','aa@aa.com','-','aa','aa',429,426,263,'2006-06-09',3,4,'','3d5fed4ecc0bbee777edee3ee85eae94');

/*ݱ `cfstat_visit_last` ıṹ*/

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 '',
  `addtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `ly` varchar(255) NOT NULL default '',
  `currweb` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

/*ݱ `cfstat_visit_last` */

/*ݱ `cfstat_web_day` ıṹ*/

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',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`,`weburl`,`adddate`)
) TYPE=MyISAM;

/*ݱ `cfstat_web_day` */
