Location: PHPKode > projects > Cdub's Logs > cdubs-logs/sql.txt
copy and paste the following into your sql database :




CREATE TABLE `cdub_visitors` (
  `id` int(11) NOT NULL auto_increment,
  `ip` text NOT NULL,
  `ref` text NOT NULL,
  `browse` text NOT NULL,
  `hits` text NOT NULL,
  `fvisit` text NOT NULL,
  `lvisit` text NOT NULL,
  `nic` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
CREATE TABLE `cdub_vips` (
  `id` int(11) NOT NULL auto_increment,
  `vip` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=15 ;
INSERT INTO `cdub_vips` VALUES (1, '12.84.15.15');
CREATE TABLE `cdub_pagviews` (
  `id` int(11) NOT NULL auto_increment,
  `ip` text NOT NULL,
  `page` text NOT NULL,
  `date` text NOT NULL,
  `nic` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
CREATE TABLE `cdub_logs_views` (
  `id` int(11) NOT NULL auto_increment,
  `views` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
INSERT INTO `cdub_logs_views` VALUES (1, '1');
Return current item: Cdub's Logs