

/*
Table struture for google_advertisement
*/

CREATE TABLE google_advertisement (
  srno bigint(18) NOT NULL auto_increment,
  ad_title varchar(200) default NULL,
  descr varchar(200) default NULL,
  image varchar(200) default NULL,
  true_link varchar(200) default NULL,
  mirror_link varchar(200) default NULL,
  PRIMARY KEY  (srno)
) TYPE=MyISAM;

/*
Table struture for google_keyword_advertisement
*/

CREATE TABLE google_keyword_advertisement (
  srno bigint(18) NOT NULL auto_increment,
  group_id bigint(18) default NULL,
  ad_id bigint(18) default NULL,
  PRIMARY KEY  (srno)
) TYPE=MyISAM;

/*
Table struture for google_keyword_group
*/

CREATE TABLE google_keyword_group (
  srno bigint(18) NOT NULL auto_increment,
  groupname varchar(255) NOT NULL default '',
  link varchar(255) NOT NULL default '',
  linktext varchar(255) NOT NULL default '',
  PRIMARY KEY  (srno)
) TYPE=MyISAM;

/*
Table struture for google_keywords
*/

CREATE TABLE google_keywords (
  srno bigint(18) NOT NULL auto_increment,
  keyword varchar(200) NOT NULL default '',
  groupid bigint(18) NOT NULL default '0',
  folder bigint(20) NOT NULL default '0',
  PRIMARY KEY  (srno)
) TYPE=MyISAM;

/*
Table struture for google_parse_status
*/

CREATE TABLE google_parse_status (
  srno bigint(18) NOT NULL auto_increment,
  keyword_id bigint(18) default NULL,
  parsed tinyint(1) default NULL,
  complete tinyint(1) default NULL,
  pages_parsed bigint(18) default NULL,
  group_id bigint(18) default NULL,
  PRIMARY KEY  (srno)
) TYPE=MyISAM;

CREATE TABLE `ct_click_referer` (
  `clickid` int(10) NOT NULL default '0',
  `referer` varchar(100) NOT NULL default '',
  `date` date default NULL,
  `useragent` varchar(50) NOT NULL default '',
  `ip` varchar(20) NOT NULL default '0',
  `time` time NOT NULL default '00:00:00'
) TYPE=MyISAM;

/*
Table structure for ct_clicks
*/

CREATE TABLE `ct_clicks` (
  `clickid` int(10) NOT NULL auto_increment,
  `url` varchar(150) NOT NULL default '',
  `status` varchar(10) default NULL,
  `count` int(7) NOT NULL default '0',
  `notes` varchar(100) default NULL,
  PRIMARY KEY  (`clickid`)
) TYPE=MyISAM;

/*
Table structure for ct_user_clicks
*/

CREATE TABLE `ct_user_clicks` (
  `email` varchar(30) NOT NULL default '',
  `clickid` int(10) NOT NULL default '0'
) TYPE=MyISAM;

