CREATE TABLE `blog_mycpt_backref` ( `id` varchar(5) binary NOT NULL default '', `referer` varchar(255) NOT NULL default '', `cpt` int(11) NOT NULL default '1', PRIMARY KEY (`id`), KEY `navigateur` (`referer`) ) TYPE=MyISAM; # -------------------------------------------------------- CREATE TABLE `blog_mycpt_browser` ( `id` varchar(5) binary NOT NULL default '', `navigateur` varchar(255) NOT NULL default '', `cpt` int(11) NOT NULL default '1', PRIMARY KEY (`id`), KEY `navigateur` (`navigateur`) ) TYPE=MyISAM; # -------------------------------------------------------- CREATE TABLE `blog_mycpt_info` ( `dth` int(11) NOT NULL default '0', `dth_human` varchar(20) NOT NULL default '', `visite` int(11) NOT NULL default '0', `page` int(11) NOT NULL default '0', `img` int(11) NOT NULL default '0', PRIMARY KEY (`dth`), KEY `visite` (`visite`) ) TYPE=MyISAM; # -------------------------------------------------------- CREATE TABLE `blog_mycpt_ip` ( `dth` int(11) NOT NULL default '0', `dth_human` varchar(20) NOT NULL default '', `ip_remote` varchar(30) NOT NULL default '', `ip_client` varchar(30) NOT NULL default '', `ip_proxy` varchar(30) NOT NULL default '', `server` varchar(255) NOT NULL default '', `script` varchar(255) NOT NULL default '', `request_uri` varchar(255) NOT NULL default '', `uri` varchar(255) NOT NULL default '', KEY `dth` (`dth`), KEY `ip_client` (`ip_remote`,`ip_client`,`ip_proxy`,`server`) ) TYPE=MyISAM; # -------------------------------------------------------- CREATE TABLE `blog_mycpt_stats` ( `dth` int(11) NOT NULL default '0', `dth_human` varchar(20) NOT NULL default '', `visite` int(11) NOT NULL default '0', `page` int(11) NOT NULL default '0', `server` varchar(255) NOT NULL default '', `script` varchar(255) NOT NULL default '', `request_uri` varchar(255) NOT NULL default '', `uri` varchar(255) NOT NULL default '', KEY `visite` (`visite`), KEY `server` (`server`), KEY `script` (`script`), KEY `dth` (`dth`) ) TYPE=MyISAM;