# MySQL dump
# Generated by MySQLMan 1.09 (http://gossamer-threads.com/scripts/)
# Host: localhost    Database: clientpromotion_com_beta 
#--------------------------------------------------------

#
# Table structure for table 'ADMIN_SESSION'
#
CREATE TABLE ADMIN_SESSION (
  SESSION_KEY varchar(15)  DEFAULT '' NOT NULL ,
  EXPIRATION_TIME datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
  IP_ADDRESS varchar(15)  DEFAULT '' NOT NULL ,
  PRIMARY KEY (SESSION_KEY)
);

#
# Table structure for table 'CLIENT'
#
CREATE TABLE CLIENT (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  USERNAME varchar(30)  DEFAULT '' NOT NULL ,
  PASSWORD varchar(32)  DEFAULT '' NOT NULL ,
  LAST_NAME varchar(50)  DEFAULT '' NOT NULL ,
  FIRST_NAME varchar(50)  DEFAULT '' NOT NULL ,
  EMAIL varchar(60)  DEFAULT '' NOT NULL ,
  COMPANY varchar(30)    ,
  PHONE varchar(30)    ,
  FAX varchar(30)    ,
  ADDRESS varchar(50)    ,
  CITY varchar(30)    ,
  STATE varchar(30)    ,
  ZIP varchar(15)    ,
  COUNTRY varchar(30)    ,
  ACCOUNT_STATUS varchar(20)  DEFAULT 'active' NOT NULL ,
  ACCOUNT_GROUP varchar(15)  DEFAULT 'default' NOT NULL ,
  ACCOUNT_SIGNUP_DATE datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
  ACCOUNT_LAST_RENEWAL_DATE datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
  BILLING_ID varchar(25)  DEFAULT '0'  ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'CLIENT_ACTION'
#
CREATE TABLE CLIENT_ACTION (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  DATE datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
  IP_ADDRESS varchar(15)  DEFAULT '' NOT NULL ,
  TOOL varchar(50)  DEFAULT '' NOT NULL ,
  CLIENT_ID int(11)  DEFAULT '0' NOT NULL ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'CLIENT_ACTIVITY'
#
CREATE TABLE CLIENT_ACTIVITY (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  ACTION blob  DEFAULT '' NOT NULL ,
  DATE datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
  IP_ADDRESS varchar(15)    ,
  REFERER varchar(80)    ,
  CLIENT_ID int(11)  DEFAULT '0' NOT NULL ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'CLIENT_LINK_PARTNER'
#
CREATE TABLE CLIENT_LINK_PARTNER (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  PARTNER_SITE_NAME varchar(50)  DEFAULT '' NOT NULL ,
  PARTNER_SITE_URL varchar(150)  DEFAULT '' NOT NULL ,
  PARTNER_SITE_EMAIL varchar(50)  DEFAULT '' NOT NULL ,
  CLIENT_LINK varchar(150)    ,
  CLIENT_LINK_LOCATION varchar(150)    ,
  PARTNER_LINK varchar(150)    ,
  PARTNER_LINK_LOCATION varchar(150)    ,
  CLIENT_LINK_PARTNER_CAMPAIGN_ID int(11)  DEFAULT '0' NOT NULL ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'CLIENT_LINK_PARTNER_CAMPAIGN'
#
CREATE TABLE CLIENT_LINK_PARTNER_CAMPAIGN (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  NAME varchar(20)  DEFAULT '' NOT NULL ,
  PROPOSITION_SUBJECT varchar(50)  DEFAULT '' NOT NULL ,
  PROPOSITION_BODY blob  DEFAULT '' NOT NULL ,
  CLIENT_SITE_ID int(11)  DEFAULT '0' NOT NULL ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'CLIENT_LINK_PARTNER_POTENTIAL'
#
CREATE TABLE CLIENT_LINK_PARTNER_POTENTIAL (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  PARTNER_SITE_NAME varchar(50)  DEFAULT '' NOT NULL ,
  PARTNER_SITE_URL varchar(150)  DEFAULT '' NOT NULL ,
  PARTNER_SITE_EMAIL varchar(50)  DEFAULT '' NOT NULL ,
  EMAILED enum('y','n')  DEFAULT 'n'  ,
  CLIENT_LINK_PARTNER_CAMPAIGN_ID int(11)  DEFAULT '0' NOT NULL ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'CLIENT_SESSION'
#
CREATE TABLE CLIENT_SESSION (
  SESSION_KEY varchar(15)  DEFAULT '' NOT NULL ,
  EXPIRATION_TIME datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
  IP_ADDRESS varchar(15)  DEFAULT '' NOT NULL ,
  CLIENT_ID int(11)  DEFAULT '0' NOT NULL ,
  PRIMARY KEY (SESSION_KEY)
);

#
# Table structure for table 'CLIENT_SITE'
#
CREATE TABLE CLIENT_SITE (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  NAME varchar(25)  DEFAULT '' NOT NULL ,
  ROOT_URL varchar(60)  DEFAULT '' NOT NULL ,
  CLIENT_ID int(11)  DEFAULT '0' NOT NULL ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'CLIENT_SITE_COMPETITION'
#
CREATE TABLE CLIENT_SITE_COMPETITION (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  ROOT_URL varchar(60)    ,
  CLIENT_SITE_ID int(11)    ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'CLIENT_SITE_PAGE'
#
CREATE TABLE CLIENT_SITE_PAGE (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  URL varchar(150)  DEFAULT '' NOT NULL ,
  CONTENT blob    ,
  LAST_CRAWLED datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
  CLIENT_SITE_ID int(11)  DEFAULT '0' NOT NULL ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'CLIENT_SITE_SEARCHENGINE_RANKING'
#
CREATE TABLE CLIENT_SITE_SEARCHENGINE_RANKING (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  DATE date    ,
  KEYWORD_PHRASE varchar(50)    ,
  RANKING int(11)    ,
  URL_MATCH varchar(100)    ,
  CLIENT_SITE_ID int(11)    ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'CLIENT_SITE_STATISTICS'
#
CREATE TABLE CLIENT_SITE_STATISTICS (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  DATE datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
  PAGE_CALLING varchar(250)    ,
  REQUEST_METHOD varchar(5)    ,
  HTTP_REFERER varchar(250)    ,
  HTTP_USER_AGENT varchar(150)    ,
  IP_ADDRESS varchar(15)  DEFAULT '' NOT NULL ,
  CLIENT_SITE_ID int(11)    ,
  PRIMARY KEY (ID),
  KEY referrer_index (HTTP_REFERER)
);

#
# Table structure for table 'CLIENT_SITE_STATISTICS_DAILY_TOTALS'
#
CREATE TABLE CLIENT_SITE_STATISTICS_DAILY_TOTALS (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  DATE date  DEFAULT '0000-00-00' NOT NULL ,
  TOTAL_VISITORS int(11)  DEFAULT '0' NOT NULL ,
  TOTAL_HITS int(11)  DEFAULT '0' NOT NULL ,
  CLIENT_SITE_ID int(11)  DEFAULT '0' NOT NULL ,
  PRIMARY KEY (ID)
);

#
# Table structure for table 'IP_COUNTRY'
#
CREATE TABLE IP_COUNTRY (
  START_IP_DECIMAL int(11)    ,
  END_IP_DECIMAL int(11)    ,
  COUNTRY_ABBREVIATION char(3)    ,
  COUNTRY varchar(60)    
);

#
# Table structure for table 'SYSTEM_ACTIVITY'
#
CREATE TABLE SYSTEM_ACTIVITY (
  ID int(11)  DEFAULT '' NOT NULL auto_increment,
  ACTION blob  DEFAULT '' NOT NULL ,
  DATE datetime  DEFAULT '0000-00-00 00:00:00' NOT NULL ,
  MESSAGE blob    ,
  PRIMARY KEY (ID)
);

# ----------- Dump ends -----------