-- MySQL dump 10.13  Distrib 5.5.29, for Linux (i686)
--
-- Host: localhost    Database: cruisegroupie
-- ------------------------------------------------------
-- Server version	5.5.29

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `cl_ad_finder`
--

DROP TABLE IF EXISTS `cl_ad_finder`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ad_finder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `catids` text,
  `search_text` varchar(255) DEFAULT NULL,
  `price_min` double DEFAULT '0',
  `price_max` double DEFAULT '0',
  `listed_by` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT '0',
  `dynamic_fields` text,
  `timestamp` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `name` (`name`),
  KEY `search_text` (`search_text`),
  KEY `price_min` (`price_min`),
  KEY `price_max` (`price_max`),
  KEY `listed_by` (`listed_by`),
  KEY `enabled` (`enabled`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ad_finder`
--

LOCK TABLES `cl_ad_finder` WRITE;
/*!40000 ALTER TABLE `cl_ad_finder` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ad_finder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ad_finder_pending`
--

DROP TABLE IF EXISTS `cl_ad_finder_pending`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ad_finder_pending` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `ad_id` int(11) DEFAULT '0',
  `ad_name` varchar(255) DEFAULT NULL,
  `ad_finder_id` int(11) DEFAULT '0',
  `timestamp` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `ad_id` (`ad_id`),
  KEY `ad_name` (`ad_name`),
  KEY `ad_finder_id` (`ad_finder_id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ad_finder_pending`
--

LOCK TABLES `cl_ad_finder_pending` WRITE;
/*!40000 ALTER TABLE `cl_ad_finder_pending` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ad_finder_pending` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_address_book`
--

DROP TABLE IF EXISTS `cl_address_book`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_address_book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `addressee_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `addressee_id` (`addressee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_address_book`
--

LOCK TABLES `cl_address_book` WRITE;
/*!40000 ALTER TABLE `cl_address_book` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_address_book` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads`
--

DROP TABLE IF EXISTS `cl_ads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL DEFAULT '0',
  `pid` int(11) NOT NULL DEFAULT '0',
  `catid` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `ad_begin` int(11) NOT NULL DEFAULT '0',
  `ad_end` int(11) NOT NULL DEFAULT '0',
  `ad_modified` int(11) NOT NULL DEFAULT '0',
  `admin_comment` text,
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `price` double NOT NULL DEFAULT '0',
  `primary_photo` tinyint(1) NOT NULL DEFAULT '0',
  `photo_1` varchar(100) NOT NULL DEFAULT '',
  `photo_2` varchar(100) NOT NULL DEFAULT '',
  `photo_3` varchar(100) NOT NULL DEFAULT '',
  `photo_4` varchar(100) NOT NULL DEFAULT '',
  `photo_5` varchar(100) NOT NULL DEFAULT '',
  `photo_6` varchar(100) NOT NULL DEFAULT '',
  `contact_email` varchar(255) DEFAULT NULL,
  `contact_home` varchar(255) DEFAULT NULL,
  `contact_work` varchar(255) DEFAULT NULL,
  `contact_cell` varchar(255) DEFAULT NULL,
  `hits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `pid` (`pid`),
  KEY `catid` (`catid`),
  KEY `status` (`status`),
  KEY `ad_begin` (`ad_begin`),
  KEY `ad_end` (`ad_end`),
  KEY `ad_modified` (`ad_modified`),
  KEY `price` (`price`),
  KEY `primary_photo` (`primary_photo`),
  KEY `photo_1` (`photo_1`),
  KEY `photo_2` (`photo_2`),
  KEY `photo_3` (`photo_3`),
  KEY `photo_4` (`photo_4`),
  KEY `photo_5` (`photo_5`),
  KEY `photo_6` (`photo_6`),
  KEY `contact_email` (`contact_email`),
  KEY `contact_home` (`contact_home`),
  KEY `contact_work` (`contact_work`),
  KEY `contact_cell` (`contact_cell`),
  KEY `hits` (`hits`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `description` (`description`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads`
--

LOCK TABLES `cl_ads` WRITE;
/*!40000 ALTER TABLE `cl_ads` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_attributes`
--

DROP TABLE IF EXISTS `cl_ads_attributes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_attributes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) DEFAULT '0',
  `member_id` int(11) DEFAULT '0',
  `billing_plan_id` int(11) DEFAULT '0',
  `billing_fee_id` int(11) DEFAULT '0',
  `billing_percentage_id` int(11) DEFAULT '0',
  `billing_length_id` int(11) DEFAULT '0',
  `bold` tinyint(1) DEFAULT '0',
  `highlight` tinyint(1) DEFAULT '0',
  `thumbnail` tinyint(1) DEFAULT '0',
  `eye_catcher` tinyint(1) DEFAULT '0',
  `eye_catcher_id` int(11) DEFAULT '0',
  `featured` tinyint(1) DEFAULT '0',
  `counter` tinyint(1) DEFAULT '0',
  `counter_id` int(11) DEFAULT '0',
  `theme` tinyint(1) DEFAULT '0',
  `theme_id` int(11) DEFAULT '0',
  `layout` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`),
  KEY `member_id` (`member_id`),
  KEY `billing_plan_id` (`billing_plan_id`),
  KEY `billing_fee_id` (`billing_fee_id`),
  KEY `billing_percentage_id` (`billing_percentage_id`),
  KEY `billing_length_id` (`billing_length_id`),
  KEY `bold` (`bold`),
  KEY `highlight` (`highlight`),
  KEY `thumbnail` (`thumbnail`),
  KEY `eye_catcher` (`eye_catcher`),
  KEY `eye_catcher_id` (`eye_catcher_id`),
  KEY `featured` (`featured`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_attributes`
--

LOCK TABLES `cl_ads_attributes` WRITE;
/*!40000 ALTER TABLE `cl_ads_attributes` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_attributes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat1`
--

DROP TABLE IF EXISTS `cl_ads_cat1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field1` int(11) DEFAULT NULL,
  `field2` varchar(255) DEFAULT NULL,
  `field3` int(11) DEFAULT NULL,
  `field4` int(11) DEFAULT NULL,
  `field5` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat1`
--

LOCK TABLES `cl_ads_cat1` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat1` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat10`
--

DROP TABLE IF EXISTS `cl_ads_cat10`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat10` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field29` varchar(255) DEFAULT NULL,
  `field30` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat10`
--

LOCK TABLES `cl_ads_cat10` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat10` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat10` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat11`
--

DROP TABLE IF EXISTS `cl_ads_cat11`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat11` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field31` varchar(255) DEFAULT NULL,
  `field32` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat11`
--

LOCK TABLES `cl_ads_cat11` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat11` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat11` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat12`
--

DROP TABLE IF EXISTS `cl_ads_cat12`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat12` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field33` varchar(255) DEFAULT NULL,
  `field34` int(11) DEFAULT NULL,
  `field35` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat12`
--

LOCK TABLES `cl_ads_cat12` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat12` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat12` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat13`
--

DROP TABLE IF EXISTS `cl_ads_cat13`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat13` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat13`
--

LOCK TABLES `cl_ads_cat13` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat13` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat13` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat2`
--

DROP TABLE IF EXISTS `cl_ads_cat2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field6` varchar(255) DEFAULT NULL,
  `field7` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat2`
--

LOCK TABLES `cl_ads_cat2` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat2` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat3`
--

DROP TABLE IF EXISTS `cl_ads_cat3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field11` varchar(255) DEFAULT NULL,
  `field12` varchar(255) DEFAULT NULL,
  `field13` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat3`
--

LOCK TABLES `cl_ads_cat3` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat3` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat3` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat33`
--

DROP TABLE IF EXISTS `cl_ads_cat33`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat33` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field8` varchar(255) DEFAULT NULL,
  `field9` varchar(255) DEFAULT NULL,
  `field10` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat33`
--

LOCK TABLES `cl_ads_cat33` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat33` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat33` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat4`
--

DROP TABLE IF EXISTS `cl_ads_cat4`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat4` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field14` varchar(255) DEFAULT NULL,
  `field15` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat4`
--

LOCK TABLES `cl_ads_cat4` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat4` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat4` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat5`
--

DROP TABLE IF EXISTS `cl_ads_cat5`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat5` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field16` varchar(255) DEFAULT NULL,
  `field17` int(11) DEFAULT NULL,
  `field18` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat5`
--

LOCK TABLES `cl_ads_cat5` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat5` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat5` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat6`
--

DROP TABLE IF EXISTS `cl_ads_cat6`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat6` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field19` varchar(255) DEFAULT NULL,
  `field20` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat6`
--

LOCK TABLES `cl_ads_cat6` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat6` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat6` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat7`
--

DROP TABLE IF EXISTS `cl_ads_cat7`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat7` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field21` varchar(255) DEFAULT NULL,
  `field22` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat7`
--

LOCK TABLES `cl_ads_cat7` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat7` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat7` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat8`
--

DROP TABLE IF EXISTS `cl_ads_cat8`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat8` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field23` varchar(255) DEFAULT NULL,
  `field24` varchar(255) DEFAULT NULL,
  `field25` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat8`
--

LOCK TABLES `cl_ads_cat8` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat8` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat8` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_cat9`
--

DROP TABLE IF EXISTS `cl_ads_cat9`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_cat9` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL DEFAULT '0',
  `field26` varchar(255) DEFAULT NULL,
  `field27` int(11) DEFAULT NULL,
  `field28` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_cat9`
--

LOCK TABLES `cl_ads_cat9` WRITE;
/*!40000 ALTER TABLE `cl_ads_cat9` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_cat9` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_ads_fees`
--

DROP TABLE IF EXISTS `cl_ads_fees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_ads_fees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) DEFAULT '0',
  `member_id` int(11) DEFAULT '0',
  `fee_paid` tinyint(1) DEFAULT '0',
  `fee_timestamp` int(11) DEFAULT '0',
  `fee` double DEFAULT '0',
  `fee_total` double DEFAULT '0',
  `percentage_paid` tinyint(1) DEFAULT '0',
  `percentage_timestamp` int(11) DEFAULT '0',
  `percentage_fee` double DEFAULT '0',
  `percentage_fee_total` double DEFAULT '0',
  `length_paid` tinyint(1) DEFAULT '0',
  `length_timestamp` int(11) DEFAULT '0',
  `length_fee` double DEFAULT '0',
  `length_fee_total` double DEFAULT '0',
  `photo_1_paid` tinyint(1) DEFAULT '0',
  `photo_1_timestamp` int(11) DEFAULT '0',
  `photo_1_fee` double DEFAULT '0',
  `photo_2_paid` tinyint(1) DEFAULT '0',
  `photo_2_timestamp` int(11) DEFAULT '0',
  `photo_2_fee` double DEFAULT '0',
  `photo_3_paid` tinyint(1) DEFAULT '0',
  `photo_3_timestamp` int(11) DEFAULT '0',
  `photo_3_fee` double DEFAULT '0',
  `photo_4_paid` tinyint(1) DEFAULT '0',
  `photo_4_timestamp` int(11) DEFAULT '0',
  `photo_4_fee` double DEFAULT '0',
  `photo_5_paid` tinyint(1) DEFAULT '0',
  `photo_5_timestamp` int(11) DEFAULT '0',
  `photo_5_fee` double DEFAULT '0',
  `photo_6_paid` tinyint(1) DEFAULT '0',
  `photo_6_timestamp` int(11) DEFAULT '0',
  `photo_6_fee` double DEFAULT '0',
  `bold_paid` tinyint(1) DEFAULT '0',
  `bold_timestamp` int(11) DEFAULT '0',
  `bold_fee` double DEFAULT '0',
  `highlight_paid` tinyint(1) DEFAULT '0',
  `highlight_timestamp` int(11) DEFAULT '0',
  `highlight_fee` double DEFAULT '0',
  `thumbnail_paid` tinyint(1) DEFAULT '0',
  `thumbnail_timestamp` int(11) DEFAULT '0',
  `thumbnail_fee` double DEFAULT '0',
  `eye_catcher_paid` tinyint(1) DEFAULT '0',
  `eye_catcher_timestamp` int(11) DEFAULT '0',
  `eye_catcher_fee` double DEFAULT '0',
  `featured_paid` tinyint(1) DEFAULT '0',
  `featured_timestamp` int(11) DEFAULT '0',
  `featured_fee` double DEFAULT '0',
  `counter_paid` tinyint(1) DEFAULT '0',
  `counter_timestamp` int(11) DEFAULT '0',
  `counter_fee` double DEFAULT '0',
  `total` double DEFAULT '0',
  `total_new` double DEFAULT '0',
  `timestamp` int(11) DEFAULT '0',
  `paid` double DEFAULT '0',
  `paid_timestamp` int(11) DEFAULT '0',
  `theme_paid` tinyint(1) DEFAULT '0',
  `theme_timestamp` int(11) DEFAULT '0',
  `theme_fee` double DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`),
  KEY `member_id` (`member_id`),
  KEY `fee_paid` (`fee_paid`),
  KEY `fee_timestamp` (`fee_timestamp`),
  KEY `fee` (`fee`),
  KEY `fee_total` (`fee_total`),
  KEY `percentage_paid` (`percentage_paid`),
  KEY `percentage_timestamp` (`percentage_timestamp`),
  KEY `percentage_fee` (`percentage_fee`),
  KEY `percentage_fee_total` (`percentage_fee_total`),
  KEY `length_paid` (`length_paid`),
  KEY `length_timestamp` (`length_timestamp`),
  KEY `length_fee` (`length_fee`),
  KEY `length_fee_total` (`length_fee_total`),
  KEY `photo_1_paid` (`photo_1_paid`),
  KEY `photo_1_timestamp` (`photo_1_timestamp`),
  KEY `photo_1_fee` (`photo_1_fee`),
  KEY `photo_2_paid` (`photo_2_paid`),
  KEY `photo_2_timestamp` (`photo_2_timestamp`),
  KEY `photo_2_fee` (`photo_2_fee`),
  KEY `photo_3_paid` (`photo_3_paid`),
  KEY `photo_3_timestamp` (`photo_3_timestamp`),
  KEY `photo_3_fee` (`photo_3_fee`),
  KEY `photo_4_paid` (`photo_4_paid`),
  KEY `photo_4_timestamp` (`photo_4_timestamp`),
  KEY `photo_4_fee` (`photo_4_fee`),
  KEY `photo_5_paid` (`photo_5_paid`),
  KEY `photo_5_timestamp` (`photo_5_timestamp`),
  KEY `photo_5_fee` (`photo_5_fee`),
  KEY `photo_6_paid` (`photo_6_paid`),
  KEY `photo_6_timestamp` (`photo_6_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_ads_fees`
--

LOCK TABLES `cl_ads_fees` WRITE;
/*!40000 ALTER TABLE `cl_ads_fees` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_ads_fees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_allowable_tags`
--

DROP TABLE IF EXISTS `cl_allowable_tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_allowable_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_allowable_tags`
--

LOCK TABLES `cl_allowable_tags` WRITE;
/*!40000 ALTER TABLE `cl_allowable_tags` DISABLE KEYS */;
INSERT INTO `cl_allowable_tags` VALUES (1,'<span>',1),(2,'<div>',0),(3,'<br>',0),(4,'<ol>',2),(5,'<li>',3),(6,'<ul>',4);
/*!40000 ALTER TABLE `cl_allowable_tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_badwords`
--

DROP TABLE IF EXISTS `cl_badwords`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_badwords` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_badwords`
--

LOCK TABLES `cl_badwords` WRITE;
/*!40000 ALTER TABLE `cl_badwords` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_badwords` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_billing_history`
--

DROP TABLE IF EXISTS `cl_billing_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_billing_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT '0',
  `payment_method` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `balance` double DEFAULT '0',
  `balance_paid` double DEFAULT '0',
  `item_paid` text,
  `timestamp` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `payment_method` (`payment_method`),
  KEY `type` (`type`),
  KEY `balance` (`balance`),
  KEY `balance_paid` (`balance_paid`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_billing_history`
--

LOCK TABLES `cl_billing_history` WRITE;
/*!40000 ALTER TABLE `cl_billing_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_billing_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_billing_plans`
--

DROP TABLE IF EXISTS `cl_billing_plans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_billing_plans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `subscription` tinyint(1) DEFAULT '0',
  `subscription_fee` double DEFAULT '0',
  `subscription_length` int(11) DEFAULT '0',
  `subscription_ads` int(11) DEFAULT '0',
  `photo_1_fee` double DEFAULT '0',
  `photo_2_fee` double DEFAULT '0',
  `photo_3_fee` double DEFAULT '0',
  `photo_4_fee` double DEFAULT '0',
  `photo_5_fee` double DEFAULT '0',
  `photo_6_fee` double DEFAULT '0',
  `bold` tinyint(1) DEFAULT '0',
  `bold_fee` double DEFAULT '0',
  `highlight` tinyint(1) DEFAULT '0',
  `highlight_fee` double DEFAULT '0',
  `thumbnail` tinyint(1) DEFAULT '0',
  `thumbnail_fee` double DEFAULT '0',
  `eye_catcher` tinyint(1) DEFAULT '0',
  `eye_catcher_fee` double DEFAULT '0',
  `featured` tinyint(1) DEFAULT '0',
  `featured_fee` double DEFAULT '0',
  `counter` tinyint(1) DEFAULT '0',
  `counter_fee` double DEFAULT '0',
  `theme` tinyint(1) DEFAULT '0',
  `theme_fee` double DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `status` (`status`),
  KEY `subscription` (`subscription`),
  KEY `subscription_fee` (`subscription_fee`),
  KEY `subscription_length` (`subscription_length`),
  KEY `subscription_ads` (`subscription_ads`),
  KEY `photo_1_fee` (`photo_1_fee`),
  KEY `photo_2_fee` (`photo_2_fee`),
  KEY `photo_3_fee` (`photo_3_fee`),
  KEY `photo_4_fee` (`photo_4_fee`),
  KEY `photo_5_fee` (`photo_5_fee`),
  KEY `photo_6_fee` (`photo_6_fee`),
  KEY `bold` (`bold`),
  KEY `bold_fee` (`bold_fee`),
  KEY `highlight` (`highlight`),
  KEY `highlight_fee` (`highlight_fee`),
  KEY `thumbnail` (`thumbnail`),
  KEY `thumbnail_fee` (`thumbnail_fee`),
  KEY `eye_catcher` (`eye_catcher`),
  KEY `eye_catcher_fee` (`eye_catcher_fee`),
  KEY `featured` (`featured`),
  KEY `featured_fee` (`featured_fee`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_billing_plans`
--

LOCK TABLES `cl_billing_plans` WRITE;
/*!40000 ALTER TABLE `cl_billing_plans` DISABLE KEYS */;
INSERT INTO `cl_billing_plans` VALUES (1,'Default Billing Plan',1,0,0,0,0,0,0.25,0.25,0.25,0.25,0.25,1,0.5,1,1,1,0.25,1,0.75,1,9.95,1,0.25,1,0.5),(2,'Discount Plan',1,1,9.95,30,30,0,0.1,0.1,0.1,0.1,0.1,1,0.25,1,0.75,1,0.1,1,0.5,1,4.95,0,0,0,0);
/*!40000 ALTER TABLE `cl_billing_plans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_billing_plans_counters`
--

DROP TABLE IF EXISTS `cl_billing_plans_counters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_billing_plans_counters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `billing_plan_id` int(11) DEFAULT NULL,
  `counter_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `billing_plan_id` (`billing_plan_id`),
  KEY `counter_id` (`counter_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_billing_plans_counters`
--

LOCK TABLES `cl_billing_plans_counters` WRITE;
/*!40000 ALTER TABLE `cl_billing_plans_counters` DISABLE KEYS */;
INSERT INTO `cl_billing_plans_counters` VALUES (1,1,1,1),(2,1,2,1),(3,1,3,1),(4,1,4,1),(5,2,1,1),(6,2,2,1),(7,2,3,1),(8,2,4,1);
/*!40000 ALTER TABLE `cl_billing_plans_counters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_billing_plans_eye_catchers`
--

DROP TABLE IF EXISTS `cl_billing_plans_eye_catchers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_billing_plans_eye_catchers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `billing_plan_id` int(11) DEFAULT NULL,
  `eye_catcher_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `billing_plan_id` (`billing_plan_id`),
  KEY `eye_catcher_id` (`eye_catcher_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_billing_plans_eye_catchers`
--

LOCK TABLES `cl_billing_plans_eye_catchers` WRITE;
/*!40000 ALTER TABLE `cl_billing_plans_eye_catchers` DISABLE KEYS */;
INSERT INTO `cl_billing_plans_eye_catchers` VALUES (1,1,1,0),(2,1,2,0),(3,1,3,0),(4,1,4,0),(5,1,5,0),(6,2,1,1),(7,2,2,1),(8,2,3,1),(9,2,4,1),(10,2,5,1),(11,1,1,1),(12,1,2,1),(13,1,3,1),(14,1,4,1),(15,1,5,1);
/*!40000 ALTER TABLE `cl_billing_plans_eye_catchers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_billing_plans_fees`
--

DROP TABLE IF EXISTS `cl_billing_plans_fees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_billing_plans_fees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `billing_plan_id` int(11) DEFAULT NULL,
  `price_start` double DEFAULT '0',
  `price_end` double DEFAULT '0',
  `fee` double DEFAULT '0',
  `fee_renew` double DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `billing_plan_id` (`billing_plan_id`),
  KEY `price_start` (`price_start`),
  KEY `price_end` (`price_end`),
  KEY `fee` (`fee`),
  KEY `fee_renew` (`fee_renew`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_billing_plans_fees`
--

LOCK TABLES `cl_billing_plans_fees` WRITE;
/*!40000 ALTER TABLE `cl_billing_plans_fees` DISABLE KEYS */;
INSERT INTO `cl_billing_plans_fees` VALUES (1,1,0.01,0.99,0.25,0.2,0),(2,1,1,9.99,0.35,0.25,0),(3,1,10,24.99,0.6,0.45,0),(4,1,25,49.99,1.2,1,0),(5,1,50,199.99,2.4,1.8,0),(6,1,200,499.99,3.6,2.5,0),(7,1,500,1000000000,4.8,3,0),(8,2,0.01,0.99,0.1,0,1),(9,2,1,9.99,0.2,0,1),(10,2,10,24.99,0.3,0,1),(11,2,25,49.99,0.6,0,1),(12,2,50,199.99,1.2,0,1),(13,2,200,499.99,1.8,0,1),(14,2,500,1000000000,2.4,0,1),(15,1,0.01,0.99,0.25,0.2,1),(16,1,1,9.99,0.35,0.25,1),(17,1,10,24.99,0.6,0.45,1),(18,1,25,49.99,1.2,1,1),(19,1,50,199.99,2.4,1.8,1),(20,1,200,499.99,3.6,2.5,1),(21,1,500,1000000000,4.8,3,1);
/*!40000 ALTER TABLE `cl_billing_plans_fees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_billing_plans_lengths`
--

DROP TABLE IF EXISTS `cl_billing_plans_lengths`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_billing_plans_lengths` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `billing_plan_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `length` int(11) DEFAULT '0',
  `fee` double DEFAULT '0',
  `fee_renew` double DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `billing_plan_id` (`billing_plan_id`),
  KEY `name` (`name`),
  KEY `length` (`length`),
  KEY `fee` (`fee`),
  KEY `fee_renew` (`fee_renew`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_billing_plans_lengths`
--

LOCK TABLES `cl_billing_plans_lengths` WRITE;
/*!40000 ALTER TABLE `cl_billing_plans_lengths` DISABLE KEYS */;
INSERT INTO `cl_billing_plans_lengths` VALUES (1,1,'1 Day',1,0,0,0),(2,1,'3 Days',3,0,0,0),(3,1,'5 Days',5,0,0,0),(4,1,'7 Days',7,0,0,0),(5,1,'10 Days',10,0.4,0.2,0),(6,2,'1 Day',1,0,0,1),(7,2,'3 Days',3,0,0,1),(8,2,'5 Days',5,0,0,1),(9,2,'7 Days',7,0,0,1),(10,2,'10 Days',10,0.25,0,1),(11,1,'1 Day',1,0,0,1),(12,1,'3 Days',3,0,0,1),(13,1,'5 Days',5,0,0,1),(14,1,'7 Days',7,0,0,1),(15,1,'10 Days',10,0.4,0.2,1);
/*!40000 ALTER TABLE `cl_billing_plans_lengths` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_billing_plans_percentages`
--

DROP TABLE IF EXISTS `cl_billing_plans_percentages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_billing_plans_percentages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `billing_plan_id` int(11) DEFAULT NULL,
  `price_start` double DEFAULT '0',
  `price_end` double DEFAULT '0',
  `percentage` double DEFAULT '0',
  `percentage_renew` double DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `billing_plan_id` (`billing_plan_id`),
  KEY `price_start` (`price_start`),
  KEY `price_end` (`price_end`),
  KEY `percentage` (`percentage`),
  KEY `percentage_renew` (`percentage_renew`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_billing_plans_percentages`
--

LOCK TABLES `cl_billing_plans_percentages` WRITE;
/*!40000 ALTER TABLE `cl_billing_plans_percentages` DISABLE KEYS */;
INSERT INTO `cl_billing_plans_percentages` VALUES (1,1,0.01,25,5.25,2.75,0),(2,1,25.01,1000,2.75,1.25,0),(3,1,1000.01,1000000000,1.5,0.75,0),(4,2,0.01,25,1.5,0,1),(5,2,25.01,1000,1,0,1),(6,2,1000.01,1000000000,0.5,0,1),(7,1,0.01,25,5.25,2.75,1),(8,1,25.01,1000,2.75,1.25,1),(9,1,1000.01,1000000000,1.5,0.75,1);
/*!40000 ALTER TABLE `cl_billing_plans_percentages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_billing_plans_themes`
--

DROP TABLE IF EXISTS `cl_billing_plans_themes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_billing_plans_themes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `billing_plan_id` int(11) DEFAULT NULL,
  `theme_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `billing_plan_id` (`billing_plan_id`),
  KEY `theme_id` (`theme_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_billing_plans_themes`
--

LOCK TABLES `cl_billing_plans_themes` WRITE;
/*!40000 ALTER TABLE `cl_billing_plans_themes` DISABLE KEYS */;
INSERT INTO `cl_billing_plans_themes` VALUES (1,1,1,1),(2,1,2,1),(3,1,3,1),(4,1,4,1),(5,1,5,1),(6,1,6,1),(7,1,7,1),(8,2,1,1),(9,2,2,1),(10,2,3,1),(11,2,4,1),(12,2,5,1),(13,2,6,1),(14,2,7,1);
/*!40000 ALTER TABLE `cl_billing_plans_themes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_categories`
--

DROP TABLE IF EXISTS `cl_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `relative_order` int(5) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `billing_plan_id` int(11) NOT NULL DEFAULT '0',
  `ad_count` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `name` (`name`),
  KEY `relative_order` (`relative_order`),
  KEY `status` (`status`),
  KEY `billing_plan_id` (`billing_plan_id`),
  KEY `ad_count` (`ad_count`)
) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_categories`
--

LOCK TABLES `cl_categories` WRITE;
/*!40000 ALTER TABLE `cl_categories` DISABLE KEYS */;
INSERT INTO `cl_categories` VALUES (1,0,'Books',2,0,1,0),(2,0,'Cameras and Photography',3,0,1,0),(3,0,'Clothing and Shoes',4,0,1,0),(4,0,'Computers',5,0,1,0),(5,0,'DVDs and Movies',6,0,1,0),(6,0,'Electronics',7,0,1,0),(7,0,'Home and Garden',8,0,1,0),(8,0,'Jewelry and Watches',9,0,1,0),(9,0,'Music',10,0,1,0),(10,0,'Sporting Goods',11,0,1,0),(11,0,'Toys and Hobbies',12,0,1,0),(12,0,'Video Games',13,0,1,0),(13,0,'Everything Else',14,0,1,0),(14,1,'Accessories',1,0,1,0),(15,1,'Audiobooks',2,0,1,0),(16,1,'Children\'s Books',3,0,1,0),(17,1,'Fiction Books',4,0,1,0),(18,1,'Magazines',5,0,1,0),(19,1,'Nonfiction Books',6,0,1,0),(20,1,'Textbooks / Education',7,0,1,0),(21,1,'Other',8,0,1,0),(22,2,'Camcorder Accessories',1,0,1,0),(23,2,'Camcorders',2,0,1,0),(24,2,'Digital Camera Accessories',3,0,1,0),(25,2,'Digital Cameras',4,0,1,0),(26,2,'Film Camera Accessories',5,0,1,0),(27,2,'Film Cameras',6,0,1,0),(28,2,'Lenses and Filters',7,0,1,0),(29,2,'Lighting and Studio Equipment',8,0,1,0),(30,2,'Photo Albums and Archive Items',9,0,1,0),(31,2,'Tripods / Monopods',10,0,1,0),(32,2,'Other',11,0,1,0),(33,0,'Automobiles',1,0,1,0),(34,33,'Cars',1,1,1,0),(35,33,'Trucks',2,0,1,0),(36,33,'Motorcycles',3,0,1,0),(37,33,'Parts and Accessories',4,0,1,0),(38,33,'Other',5,0,1,0),(39,3,'Children\'s Clothes',1,0,1,0),(40,3,'Infants and Toddlers',2,0,1,0),(41,3,'Men\'s Accessories',3,0,1,0),(42,3,'Men\'s Clothing',4,0,1,0),(43,3,'Men\'s Shoes',5,0,1,0),(44,3,'Women\'s Accessories',6,0,1,0),(45,3,'Women\'s Clothing',7,0,1,0),(46,3,'Women\'s Shoes',8,0,1,0),(47,3,'Other',9,0,1,0),(48,4,'Apple / Macintosh',1,0,1,0),(49,4,'Desktop PC Components',2,0,1,0),(50,4,'Desktop PCs',3,0,1,0),(51,4,'Laptops',4,0,1,0),(52,4,'Monitors and Projectors',5,0,1,0),(53,4,'Networking',6,0,1,0),(54,4,'Printers and Scanners',7,0,1,0),(55,4,'Software',8,0,1,0),(56,4,'Other',9,0,1,0),(57,5,'DVD',1,0,1,0),(58,5,'Film',2,0,1,0),(59,5,'Laserdisc',3,0,1,0),(60,5,'VHS',4,0,1,0),(61,5,'Other Formats',5,0,1,0),(62,6,'Car Electronics',1,0,1,0),(63,6,'DVD Players and Recorders',3,0,1,0),(64,6,'Home Audio',4,0,1,0),(65,6,'Home Theater Projectors',5,0,1,0),(66,6,'MP3 Players',6,0,1,0),(67,6,'Portable Audio',7,0,1,0),(68,6,'Cell Phones',2,0,1,0),(69,6,'Televisions',8,0,1,0),(70,6,'VCRs',9,0,1,0),(71,6,'Other',10,0,1,0),(72,7,'Bath',1,0,1,0),(73,7,'Bedding',2,0,1,0),(74,7,'Dining and Bar',3,0,1,0),(75,7,'Food and Wine',4,0,1,0),(76,7,'Furniture',5,0,1,0),(77,7,'Gardening and Plants',6,0,1,0),(78,7,'Home Decor',7,0,1,0),(79,7,'Kitchen',8,0,1,0),(80,7,'Lighting',9,0,1,0),(81,7,'Major Appliances',10,0,1,0),(82,7,'Patio',11,0,1,0),(83,7,'Pools / Spas',12,0,1,0),(84,7,'Tools',13,0,1,0),(85,7,'Other',14,0,1,0),(86,8,'Body Jewelry',1,0,1,0),(87,8,'Bracelets',2,0,1,0),(88,8,'Children\'s Jewelry',3,0,1,0),(89,8,'Earrings',4,0,1,0),(90,8,'Ethnic / Tribal Jewelry',5,0,1,0),(91,8,'Jewelry Boxes',6,0,1,0),(92,8,'Loose Diamonds and Gemstones',7,0,1,0),(93,8,'Men\'s Jewelry',8,0,1,0),(94,8,'Necklaces and Pendants',9,0,1,0),(95,8,'Rings',10,0,1,0),(96,8,'Watches',11,0,1,0),(97,8,'Other',12,0,1,0),(98,9,'Accessories',1,0,1,0),(99,9,'Cassettes',2,0,1,0),(100,9,'CDs',3,0,1,0),(101,9,'DVD Audio',4,0,1,0),(102,9,'Instruments',5,0,1,0),(103,9,'Records',6,0,1,0),(104,9,'Super Audio CDs',7,0,1,0),(105,9,'Other',8,0,1,0),(106,10,'Baseball and Softball',1,0,1,0),(107,10,'Basketball',2,0,1,0),(108,10,'Camping / Hiking',3,0,1,0),(109,10,'Cycling',4,0,1,0),(110,10,'Exercise and Fitness',5,0,1,0),(111,10,'Fishing',6,0,1,0),(112,10,'Football',7,0,1,0),(113,10,'Golf',8,0,1,0),(114,10,'Hunting',9,0,1,0),(115,10,'Indoor Games',10,0,1,0),(116,10,'Martial Arts',11,0,1,0),(117,10,'Skateboarding',12,0,1,0),(118,10,'Soccer',13,0,1,0),(119,10,'Tennis / Raquetball',14,0,1,0),(120,10,'Other',15,0,1,0),(121,11,'Action Figures',1,0,1,0),(122,11,'Building Toys',2,0,1,0),(123,11,'Classic Toys',3,0,1,0),(124,11,'Diecast / Toy Vehicles',4,0,1,0),(125,11,'Educational',5,0,1,0),(126,11,'Games',6,0,1,0),(127,11,'Model RR / Trains',7,0,1,0),(128,11,'Models',8,0,1,0),(129,11,'Outdoor Toys',9,0,1,0),(130,11,'Radio Control',10,0,1,0),(131,11,'Stuffed Animals',11,0,1,0),(132,11,'Other',12,0,1,0),(133,12,'Accessories',1,0,1,0),(134,12,'Games',2,0,1,0),(135,12,'Systems',3,0,1,0),(136,12,'Other',4,0,1,0),(137,13,'Education and Learning',1,0,1,0),(138,13,'Gifts and Occasions',2,0,1,0),(139,13,'Information Products',3,0,1,0),(140,13,'Mature Audiences',4,0,1,0),(141,13,'Metaphysical',5,0,1,0),(142,13,'Religious Products',6,0,1,0),(143,13,'Weird Stuff',7,0,1,0),(144,13,'Other',8,0,1,0);
/*!40000 ALTER TABLE `cl_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_categories_fields`
--

DROP TABLE IF EXISTS `cl_categories_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_categories_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `catid` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(8) NOT NULL DEFAULT '',
  `r_table` varchar(50) NOT NULL DEFAULT '',
  `relative_order` int(5) NOT NULL DEFAULT '0',
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `search_enabled` tinyint(1) DEFAULT '0',
  `ad_finder_enabled` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cat_id` (`catid`),
  KEY `catid` (`catid`),
  KEY `name` (`name`),
  KEY `type` (`type`),
  KEY `r_table` (`r_table`),
  KEY `relative_order` (`relative_order`),
  KEY `required` (`required`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_categories_fields`
--

LOCK TABLES `cl_categories_fields` WRITE;
/*!40000 ALTER TABLE `cl_categories_fields` DISABLE KEYS */;
INSERT INTO `cl_categories_fields` VALUES (1,1,'Category','dropdown','',1,0,0,1,1),(2,1,'Author','input','',2,0,0,1,1),(3,1,'Publication Year','dropdown','',3,0,0,1,1),(4,1,'Format','dropdown','',4,0,0,1,1),(5,1,'Condition','dropdown','',5,0,0,1,1),(6,2,'Manufaturer','input','',1,0,0,1,1),(7,2,'Condition','dropdown','',2,0,0,1,1),(8,33,'Manufaturer','input','',1,0,0,1,1),(9,33,'Miles','input','',2,0,0,1,1),(10,33,'Condition','dropdown','',3,0,0,1,1),(11,3,'Brand','input','',1,0,0,1,1),(12,3,'Size','input','',2,0,0,1,1),(13,3,'Condition','dropdown','',3,0,0,1,1),(14,4,'Brand','input','',1,0,0,1,1),(15,4,'Condition','dropdown','',2,0,0,1,1),(16,5,'Title','input','',1,0,0,1,1),(17,5,'Rating','dropdown','',2,0,0,1,1),(18,5,'Condition','dropdown','',3,0,0,1,1),(19,6,'Brand','input','',1,0,0,1,1),(20,6,'Condition','dropdown','',2,0,0,1,1),(21,7,'Brand','input','',1,0,0,1,1),(22,7,'Condition','dropdown','',2,0,0,1,1),(23,8,'Brand','input','',1,0,0,1,1),(24,8,'Material','checkbox','',2,0,0,1,1),(25,8,'Condition','dropdown','',3,0,0,1,1),(26,9,'Artist','input','',1,0,0,1,1),(27,9,'Year','dropdown','',2,0,0,1,1),(28,9,'Condition','dropdown','',3,0,0,1,1),(29,10,'Brand','input','',1,0,0,1,1),(30,10,'Condition','dropdown','',2,0,0,1,1),(31,11,'Brand','input','',1,0,0,1,1),(32,11,'Condition','dropdown','',2,0,0,1,1),(33,12,'Brand','input','',1,0,0,1,1),(34,12,'MSRB Rating','dropdown','',2,0,0,1,1),(35,12,'Condition','dropdown','',3,0,0,1,1);
/*!40000 ALTER TABLE `cl_categories_fields` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_counters`
--

DROP TABLE IF EXISTS `cl_counters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_counters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `digit_0` varchar(255) DEFAULT NULL,
  `digit_1` varchar(255) DEFAULT NULL,
  `digit_2` varchar(255) DEFAULT NULL,
  `digit_3` varchar(255) DEFAULT NULL,
  `digit_4` varchar(255) DEFAULT NULL,
  `digit_5` varchar(255) DEFAULT NULL,
  `digit_6` varchar(255) DEFAULT NULL,
  `digit_7` varchar(255) DEFAULT NULL,
  `digit_8` varchar(255) DEFAULT NULL,
  `digit_9` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `digit_0` (`digit_0`),
  KEY `digit_1` (`digit_1`),
  KEY `digit_2` (`digit_2`),
  KEY `digit_3` (`digit_3`),
  KEY `digit_4` (`digit_4`),
  KEY `digit_5` (`digit_5`),
  KEY `digit_6` (`digit_6`),
  KEY `digit_7` (`digit_7`),
  KEY `digit_8` (`digit_8`),
  KEY `digit_9` (`digit_9`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_counters`
--

LOCK TABLES `cl_counters` WRITE;
/*!40000 ALTER TABLE `cl_counters` DISABLE KEYS */;
INSERT INTO `cl_counters` VALUES (1,'Text','text',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Hidden','hidden',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'Odometer','image','odometer/0.gif','odometer/1.gif','odometer/2.gif','odometer/3.gif','odometer/4.gif','odometer/5.gif','odometer/6.gif','odometer/7.gif','odometer/8.gif','odometer/9.gif'),(4,'Green','image','green/0.gif','green/1.gif','green/2.gif','green/3.gif','green/4.gif','green/5.gif','green/6.gif','green/7.gif','green/8.gif','green/9.gif');
/*!40000 ALTER TABLE `cl_counters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_countries`
--

DROP TABLE IF EXISTS `cl_countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `relative_order` (`relative_order`)
) ENGINE=MyISAM AUTO_INCREMENT=226 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_countries`
--

LOCK TABLES `cl_countries` WRITE;
/*!40000 ALTER TABLE `cl_countries` DISABLE KEYS */;
INSERT INTO `cl_countries` VALUES (1,'United States',0),(3,'Canada',0),(4,'United Kingdom',0),(5,'Afghanistan',0),(6,'Albania',0),(7,'Algeria',0),(8,'American Samoa',0),(9,'Andorra',0),(10,'Angola',0),(11,'Anguilla',0),(12,'Antigua and Barbuda',0),(13,'Argentina',0),(14,'Armenia',0),(15,'Aruba',0),(16,'Australia',0),(17,'Austria',0),(18,'Azerbaijan Republic',0),(19,'Bahamas',0),(20,'Bahrain',0),(21,'Bangladesh',0),(22,'Barbados',0),(23,'Belarus',0),(24,'Belgium',0),(25,'Belize',0),(26,'Benin',0),(27,'Bermuda',0),(28,'Bhutan',0),(29,'Bolivia',0),(30,'Bosnia and Herzegovina',0),(31,'Botswana',0),(32,'Brazil',0),(33,'British Virgin Islands',0),(34,'Brunei Darussalam',0),(35,'Bulgaria',0),(36,'Burkina Faso',0),(37,'Burma',0),(38,'Burundi',0),(39,'Cambodia',0),(40,'Cameroon',0),(41,'Canada',0),(42,'Cape Verde Islands',0),(43,'Cayman Islands',0),(44,'Central African Republic',0),(45,'Chad',0),(46,'Chile',0),(47,'China',0),(48,'Colombia',0),(49,'Comoros',0),(50,'Congo, Democratic Republic of the',0),(51,'Congo, Republic of the',0),(52,'Cook Islands',0),(53,'Costa Rica',0),(54,'Cote d Ivoire (Ivory Coast)',0),(55,'Croatia, Republic of',0),(56,'Cuba',0),(57,'Cyprus',0),(58,'Czech Republic',0),(59,'Denmark',0),(60,'Djibouti',0),(61,'Dominica',0),(62,'Dominican Republic',0),(63,'Ecuador',0),(64,'Egypt',0),(65,'El Salvador',0),(66,'Equatorial Guinea',0),(67,'Eritrea',0),(68,'Estonia',0),(69,'Ethiopia',0),(70,'Falkland Islands (Islas Malvinas)',0),(71,'Fiji',0),(72,'Finland',0),(73,'France',0),(74,'French Guiana',0),(75,'French Polynesia',0),(76,'Gabon Republic',0),(77,'Gambia',0),(78,'Georgia',0),(79,'Germany',0),(80,'Ghana',0),(81,'Gibraltar',0),(82,'Greece',0),(83,'Greenland',0),(84,'Grenada',0),(85,'Guadeloupe',0),(86,'Guam',0),(87,'Guatemala',0),(88,'Guernsey',0),(89,'Guinea',0),(90,'Guinea-Bissau',0),(91,'Guyana',0),(92,'Haiti',0),(93,'Honduras',0),(94,'Hong Kong',0),(95,'Hungary',0),(96,'Iceland',0),(97,'India',0),(98,'Indonesia',0),(99,'Iran',0),(100,'Iraq',0),(101,'Ireland',0),(102,'Israel',0),(103,'Italy',0),(104,'Jamaica',0),(105,'Jan Mayen',0),(106,'Japan',0),(107,'Jersey',0),(108,'Jordan',0),(109,'Kazakhstan',0),(110,'Kenya Coast Republic',0),(111,'Kiribati',0),(112,'Korea, North',0),(113,'Korea, South',0),(114,'Kuwait',0),(115,'Kyrgyzstan',0),(116,'Laos',0),(117,'Latvia',0),(118,'Lebanon',0),(119,'Liechtenstein',0),(120,'Lithuania',0),(121,'Luxembourg',0),(122,'Macau',0),(123,'Macedonia',0),(124,'Madagascar',0),(125,'Malawi',0),(126,'Malaysia',0),(127,'Maldives',0),(128,'Mali',0),(129,'Malta',0),(130,'Marshall Islands',0),(131,'Martinique',0),(132,'Mauritania',0),(133,'Mauritius',0),(134,'Mayotte',0),(135,'Mexico',0),(136,'Moldova',0),(137,'Monaco',0),(138,'Mongolia',0),(139,'Montserrat',0),(140,'Morocco',0),(141,'Mozambique',0),(142,'Namibia',0),(143,'Nauru',0),(144,'Nepal',0),(145,'Netherlands',0),(146,'Netherlands Antilles',0),(147,'New Caledonia',0),(148,'New Zealand',0),(149,'Nicaragua',0),(150,'Niger',0),(151,'Nigeria',0),(152,'Niue',0),(153,'Norway',0),(154,'Oman',0),(155,'Pakistan',0),(156,'Palau',0),(157,'Panama',0),(158,'Papua New Guinea',0),(159,'Paraguay',0),(160,'Peru',0),(161,'Philippines',0),(162,'Poland',0),(163,'Portugal',0),(164,'Puerto Rico',0),(165,'Qatar',0),(166,'Romania',0),(167,'Russian Federation',0),(168,'Rwanda',0),(169,'Saint Helena',0),(170,'Saint Kitts-Nevis',0),(171,'Saint Lucia',0),(172,'Saint Pierre and Miquelon',0),(173,'Saint Vincent and the Grenadines',0),(174,'San Marino',0),(175,'Saudi Arabia',0),(176,'Senegal',0),(177,'Seychelles',0),(178,'Sierra Leone',0),(179,'Singapore',0),(180,'Slovakia',0),(181,'Slovenia',0),(182,'Solomon Islands',0),(183,'Somalia',0),(184,'South Africa',0),(185,'Spain',0),(186,'Sri Lanka',0),(187,'Sudan',0),(188,'Suriname',0),(189,'Svalbard',0),(190,'Swaziland',0),(191,'Sweden',0),(192,'Switzerland',0),(193,'Syria',0),(194,'Tahiti',0),(195,'Taiwan',0),(196,'Tajikistan',0),(197,'Tanzania',0),(198,'Thailand',0),(199,'Togo',0),(200,'Tonga',0),(201,'Trinidad and Tobago',0),(202,'Tunisia',0),(203,'Turkey',0),(204,'Turkmenistan',0),(205,'Turks and Caicos Islands',0),(206,'Tuvalu',0),(207,'Uganda',0),(208,'Ukraine',0),(209,'United Arab Emirates',0),(212,'Uruguay',0),(213,'Uzbekistan',0),(214,'Vanuatu',0),(215,'Vatican City State',0),(216,'Venezuela',0),(217,'Vietnam',0),(218,'Virgin Islands (U.S.)',0),(219,'Wallis and Futuna',0),(220,'Western Sahara',0),(221,'Western Samoa',0),(222,'Yemen',0),(223,'Yugoslavia',0),(224,'Zambia',0),(225,'Zimbabwe',0);
/*!40000 ALTER TABLE `cl_countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_decline_reasons`
--

DROP TABLE IF EXISTS `cl_decline_reasons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_decline_reasons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `reason` text,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `relative_order` (`relative_order`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_decline_reasons`
--

LOCK TABLES `cl_decline_reasons` WRITE;
/*!40000 ALTER TABLE `cl_decline_reasons` DISABLE KEYS */;
INSERT INTO `cl_decline_reasons` VALUES (1,'Contains Contact Info','Your listing contains personal contact information.  These details are prohibbited from ads on our website.  Please remove this information and resubmit your ad.',1),(12,'Adult content','Your listing contains adult content. This is prohibited from our website, and your listing has been denied.',0),(13,'Duplicate listing','The listing you added was a duplicate. We have removed the listing.',0),(14,'Illegal content','The listing you submitted contains illegal content. This is prohibited from our website, and your listing has been rejeced.',0),(15,'Violation of TOS','The listing you added violated our Terms Of Service. Please review our TOS to become familiar with all site restrictions.',0);
/*!40000 ALTER TABLE `cl_decline_reasons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_eye_catchers`
--

DROP TABLE IF EXISTS `cl_eye_catchers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_eye_catchers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `filename` (`filename`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_eye_catchers`
--

LOCK TABLES `cl_eye_catchers` WRITE;
/*!40000 ALTER TABLE `cl_eye_catchers` DISABLE KEYS */;
INSERT INTO `cl_eye_catchers` VALUES (1,'Must Sell','must_sell.gif'),(2,'Great Deal','great_deal.gif'),(3,'Wow','wow.gif'),(4,'Hot Deal','hot_deal.gif'),(5,'Low Price','low_price.gif');
/*!40000 ALTER TABLE `cl_eye_catchers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_faq_questions`
--

DROP TABLE IF EXISTS `cl_faq_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_faq_questions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`),
  KEY `section_id` (`section_id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_faq_questions`
--

LOCK TABLES `cl_faq_questions` WRITE;
/*!40000 ALTER TABLE `cl_faq_questions` DISABLE KEYS */;
INSERT INTO `cl_faq_questions` VALUES (1,1,'How do I sign up?','Simply click the \"Register\" button.'),(2,1,'What is a username?','A username is your alias on the site. Your username is what other members will see when they access your profile instead of your real name. Username should be in a Alpha-numeric form but at least 4\r\ncharacters not exceeding 15 characters. Usernames must not have spaces or special characters such as (@--#%^&*+). If your username is taken try putting some numbers after the name (example: John123).'),(3,2,'Why can\'t I contact another member?','You must have a subscription in order to contact another member with a message or through IM. If you do not have a subscription you can buy one by clicking on the \"Billing\" link on the Members Menu. ');
/*!40000 ALTER TABLE `cl_faq_questions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_faq_sections`
--

DROP TABLE IF EXISTS `cl_faq_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_faq_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `relative_order` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_faq_sections`
--

LOCK TABLES `cl_faq_sections` WRITE;
/*!40000 ALTER TABLE `cl_faq_sections` DISABLE KEYS */;
INSERT INTO `cl_faq_sections` VALUES (1,'Registration',1,2),(2,'Contacting',1,1);
/*!40000 ALTER TABLE `cl_faq_sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_favorites`
--

DROP TABLE IF EXISTS `cl_favorites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_favorites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `favorite_id` int(11) DEFAULT NULL,
  `timestamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `favorite_id` (`favorite_id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_favorites`
--

LOCK TABLES `cl_favorites` WRITE;
/*!40000 ALTER TABLE `cl_favorites` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_favorites` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_feedback`
--

DROP TABLE IF EXISTS `cl_feedback`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT '0',
  `from_member_id` int(11) DEFAULT '0',
  `from_username` varchar(255) DEFAULT NULL,
  `score` tinyint(1) DEFAULT '0',
  `comment` varchar(255) DEFAULT NULL,
  `timestamp` int(11) DEFAULT '0',
  `approved` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `from_member_id` (`from_member_id`),
  KEY `from_username` (`from_username`),
  KEY `score` (`score`),
  KEY `comment` (`comment`),
  KEY `timestamp` (`timestamp`),
  KEY `approved` (`approved`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_feedback`
--

LOCK TABLES `cl_feedback` WRITE;
/*!40000 ALTER TABLE `cl_feedback` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_feedback` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_feedback_icons`
--

DROP TABLE IF EXISTS `cl_feedback_icons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_feedback_icons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `lower_limit` int(11) DEFAULT '0',
  `upper_limit` int(11) DEFAULT '0',
  `filename` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `lower_limit` (`lower_limit`),
  KEY `upper_limit` (`upper_limit`),
  KEY `filename` (`filename`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_feedback_icons`
--

LOCK TABLES `cl_feedback_icons` WRITE;
/*!40000 ALTER TABLE `cl_feedback_icons` DISABLE KEYS */;
INSERT INTO `cl_feedback_icons` VALUES (1,'Gold Star',10,24,'gold_star.gif'),(2,'Green Star',25,49,'green_star.gif'),(3,'Red Star',50,249,'red_star.gif'),(4,'Blue Star',250,1000000000,'blue_star.gif');
/*!40000 ALTER TABLE `cl_feedback_icons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field1`
--

DROP TABLE IF EXISTS `cl_field1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field1`
--

LOCK TABLES `cl_field1` WRITE;
/*!40000 ALTER TABLE `cl_field1` DISABLE KEYS */;
INSERT INTO `cl_field1` VALUES (1,'Action / Adventure',1),(2,'Architecture & Design',2),(3,'Business',3),(4,'Computers and Internet',4),(5,'Cooking / Food / Wine',5),(6,'Fantasy',6),(7,'Health and Fitness',7),(8,'Horror',8),(9,'Humor',9),(10,'Law and Government',10),(11,'Medicine',11),(12,'Mystery / Thriller',12),(13,'Romance',16),(14,'Reference',15),(15,'Philosophy',13),(16,'Psychology',14),(17,'Science Fiction',18),(18,'Science and Tech',17),(19,'Social Sciences',19),(20,'True Crime',20),(21,'Other',21);
/*!40000 ALTER TABLE `cl_field1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field10`
--

DROP TABLE IF EXISTS `cl_field10`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field10` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field10`
--

LOCK TABLES `cl_field10` WRITE;
/*!40000 ALTER TABLE `cl_field10` DISABLE KEYS */;
INSERT INTO `cl_field10` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field10` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field13`
--

DROP TABLE IF EXISTS `cl_field13`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field13` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field13`
--

LOCK TABLES `cl_field13` WRITE;
/*!40000 ALTER TABLE `cl_field13` DISABLE KEYS */;
INSERT INTO `cl_field13` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field13` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field15`
--

DROP TABLE IF EXISTS `cl_field15`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field15` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field15`
--

LOCK TABLES `cl_field15` WRITE;
/*!40000 ALTER TABLE `cl_field15` DISABLE KEYS */;
INSERT INTO `cl_field15` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field15` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field17`
--

DROP TABLE IF EXISTS `cl_field17`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field17` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field17`
--

LOCK TABLES `cl_field17` WRITE;
/*!40000 ALTER TABLE `cl_field17` DISABLE KEYS */;
INSERT INTO `cl_field17` VALUES (1,'G',1),(2,'PG',2),(3,'PG-13',3),(4,'R',4),(5,'NC-17',5),(6,'Other',6);
/*!40000 ALTER TABLE `cl_field17` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field18`
--

DROP TABLE IF EXISTS `cl_field18`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field18` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field18`
--

LOCK TABLES `cl_field18` WRITE;
/*!40000 ALTER TABLE `cl_field18` DISABLE KEYS */;
INSERT INTO `cl_field18` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field18` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field20`
--

DROP TABLE IF EXISTS `cl_field20`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field20` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field20`
--

LOCK TABLES `cl_field20` WRITE;
/*!40000 ALTER TABLE `cl_field20` DISABLE KEYS */;
INSERT INTO `cl_field20` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field20` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field22`
--

DROP TABLE IF EXISTS `cl_field22`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field22` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field22`
--

LOCK TABLES `cl_field22` WRITE;
/*!40000 ALTER TABLE `cl_field22` DISABLE KEYS */;
INSERT INTO `cl_field22` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field22` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field24`
--

DROP TABLE IF EXISTS `cl_field24`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field24` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field24`
--

LOCK TABLES `cl_field24` WRITE;
/*!40000 ALTER TABLE `cl_field24` DISABLE KEYS */;
INSERT INTO `cl_field24` VALUES (1,'Bronze',1),(2,'Silver',2),(3,'Gold',3),(4,'Platinum',4),(5,'Diamond',5),(6,'Other',6);
/*!40000 ALTER TABLE `cl_field24` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field25`
--

DROP TABLE IF EXISTS `cl_field25`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field25` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field25`
--

LOCK TABLES `cl_field25` WRITE;
/*!40000 ALTER TABLE `cl_field25` DISABLE KEYS */;
INSERT INTO `cl_field25` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field25` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field27`
--

DROP TABLE IF EXISTS `cl_field27`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field27` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field27`
--

LOCK TABLES `cl_field27` WRITE;
/*!40000 ALTER TABLE `cl_field27` DISABLE KEYS */;
INSERT INTO `cl_field27` VALUES (1,'2000 to Present',1),(2,'1995 to 1999',2),(3,'1990 to 1994',3),(4,'1985 to 1989',4),(5,'1980 to 1984',5),(6,'1975 to 1979',6),(7,'1970 to 1974',7),(8,'1960 to 1969',8),(9,'1950 to 1959',9),(10,'1949 and Earlier',10);
/*!40000 ALTER TABLE `cl_field27` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field28`
--

DROP TABLE IF EXISTS `cl_field28`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field28` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field28`
--

LOCK TABLES `cl_field28` WRITE;
/*!40000 ALTER TABLE `cl_field28` DISABLE KEYS */;
INSERT INTO `cl_field28` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field28` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field3`
--

DROP TABLE IF EXISTS `cl_field3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field3`
--

LOCK TABLES `cl_field3` WRITE;
/*!40000 ALTER TABLE `cl_field3` DISABLE KEYS */;
INSERT INTO `cl_field3` VALUES (1,'2000 to Present',1),(2,'1990 to 1999',2),(3,'1980 to 1989',3),(4,'1970 to 1979',4),(5,'1950 to 1969',5),(6,'1900 to 1949',6),(7,'1899 and Earlier',7);
/*!40000 ALTER TABLE `cl_field3` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field30`
--

DROP TABLE IF EXISTS `cl_field30`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field30` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field30`
--

LOCK TABLES `cl_field30` WRITE;
/*!40000 ALTER TABLE `cl_field30` DISABLE KEYS */;
INSERT INTO `cl_field30` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field30` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field32`
--

DROP TABLE IF EXISTS `cl_field32`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field32` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field32`
--

LOCK TABLES `cl_field32` WRITE;
/*!40000 ALTER TABLE `cl_field32` DISABLE KEYS */;
INSERT INTO `cl_field32` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field32` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field34`
--

DROP TABLE IF EXISTS `cl_field34`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field34` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field34`
--

LOCK TABLES `cl_field34` WRITE;
/*!40000 ALTER TABLE `cl_field34` DISABLE KEYS */;
INSERT INTO `cl_field34` VALUES (1,'E',1),(2,'T',2),(3,'M',3),(4,'AO',4);
/*!40000 ALTER TABLE `cl_field34` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field35`
--

DROP TABLE IF EXISTS `cl_field35`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field35` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field35`
--

LOCK TABLES `cl_field35` WRITE;
/*!40000 ALTER TABLE `cl_field35` DISABLE KEYS */;
INSERT INTO `cl_field35` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field35` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field4`
--

DROP TABLE IF EXISTS `cl_field4`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field4` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field4`
--

LOCK TABLES `cl_field4` WRITE;
/*!40000 ALTER TABLE `cl_field4` DISABLE KEYS */;
INSERT INTO `cl_field4` VALUES (1,'Hard Cover',1),(2,'Soft Cover',2),(3,'Other',3);
/*!40000 ALTER TABLE `cl_field4` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field5`
--

DROP TABLE IF EXISTS `cl_field5`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field5` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field5`
--

LOCK TABLES `cl_field5` WRITE;
/*!40000 ALTER TABLE `cl_field5` DISABLE KEYS */;
INSERT INTO `cl_field5` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field5` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_field7`
--

DROP TABLE IF EXISTS `cl_field7`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_field7` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_field7`
--

LOCK TABLES `cl_field7` WRITE;
/*!40000 ALTER TABLE `cl_field7` DISABLE KEYS */;
INSERT INTO `cl_field7` VALUES (1,'New',1),(2,'Used',2);
/*!40000 ALTER TABLE `cl_field7` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_image_types`
--

DROP TABLE IF EXISTS `cl_image_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_image_types` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `extension` varchar(25) NOT NULL DEFAULT '',
  `mime` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `extension` (`extension`),
  KEY `mime` (`mime`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_image_types`
--

LOCK TABLES `cl_image_types` WRITE;
/*!40000 ALTER TABLE `cl_image_types` DISABLE KEYS */;
INSERT INTO `cl_image_types` VALUES (1,'gif','image/gif'),(2,'jpeg','image/jpeg'),(3,'jpeg','image/pjpeg');
/*!40000 ALTER TABLE `cl_image_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_input_management`
--

DROP TABLE IF EXISTS `cl_input_management`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_input_management` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `filename` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `filename` (`filename`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_input_management`
--

LOCK TABLES `cl_input_management` WRITE;
/*!40000 ALTER TABLE `cl_input_management` DISABLE KEYS */;
INSERT INTO `cl_input_management` VALUES (1,'Countries List','countries'),(2,'States List','states'),(3,'Category','field1'),(4,'Publication Year','field3'),(5,'Format','field4'),(6,'Condition','field5'),(7,'Condition','field7'),(8,'Condition','field10'),(9,'Condition','field13'),(10,'Condition','field15'),(11,'Rating','field17'),(12,'Condition','field18'),(13,'Condition','field20'),(14,'Condition','field22'),(15,'Material','field24'),(16,'Condition','field25'),(17,'Year','field27'),(18,'Condition','field28'),(19,'Condition','field30'),(20,'Condition','field32'),(21,'MSRB Rating','field34'),(22,'Condition','field35');
/*!40000 ALTER TABLE `cl_input_management` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_members`
--

DROP TABLE IF EXISTS `cl_members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `address_1` varchar(255) DEFAULT NULL,
  `address_2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `zipcode` varchar(255) NOT NULL DEFAULT '',
  `longitude` double DEFAULT '0',
  `latitude` double DEFAULT '0',
  `phone` varchar(255) DEFAULT NULL,
  `ip_addr` varchar(255) DEFAULT NULL,
  `reg_date` int(11) DEFAULT NULL,
  `last_login` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `billing_plan_id` int(11) DEFAULT '0',
  `subscription_expiration` int(11) DEFAULT '0',
  `subscription_credits` int(11) DEFAULT '0',
  `balance` double DEFAULT '0',
  `balance_timestamp` int(11) DEFAULT '0',
  `balance_notification` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `password` (`password`),
  KEY `email` (`email`),
  KEY `first_name` (`first_name`),
  KEY `last_name` (`last_name`),
  KEY `address_1` (`address_1`),
  KEY `address_2` (`address_2`),
  KEY `city` (`city`),
  KEY `state` (`state`),
  KEY `country` (`country`),
  KEY `zipcode` (`zipcode`),
  KEY `longitude` (`longitude`),
  KEY `latitude` (`latitude`),
  KEY `phone` (`phone`),
  KEY `ip_addr` (`ip_addr`),
  KEY `reg_date` (`reg_date`),
  KEY `last_login` (`last_login`),
  KEY `status` (`status`),
  KEY `billing_plan_id` (`billing_plan_id`),
  KEY `subscription_expiration` (`subscription_expiration`),
  KEY `subscription_credits` (`subscription_credits`),
  KEY `balance` (`balance`),
  KEY `balance_timestamp` (`balance_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_members`
--

LOCK TABLES `cl_members` WRITE;
/*!40000 ALTER TABLE `cl_members` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_members_pending`
--

DROP TABLE IF EXISTS `cl_members_pending`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_members_pending` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `ip_addr` varchar(15) DEFAULT NULL,
  `timestamp` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `email` (`email`),
  KEY `ip_addr` (`ip_addr`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_members_pending`
--

LOCK TABLES `cl_members_pending` WRITE;
/*!40000 ALTER TABLE `cl_members_pending` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_members_pending` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_messages`
--

DROP TABLE IF EXISTS `cl_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender_id` int(11) NOT NULL DEFAULT '0',
  `recipient_id` int(11) NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `is_new` tinyint(1) NOT NULL DEFAULT '1',
  `show_in_inbox` tinyint(1) NOT NULL DEFAULT '1',
  `show_in_sent` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `id_2` (`id`),
  KEY `sender_id` (`sender_id`),
  KEY `recipient_id` (`recipient_id`),
  KEY `subject` (`subject`),
  KEY `timestamp` (`timestamp`),
  KEY `is_new` (`is_new`),
  KEY `show_in_inbox` (`show_in_inbox`),
  KEY `show_in_sent` (`show_in_sent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_messages`
--

LOCK TABLES `cl_messages` WRITE;
/*!40000 ALTER TABLE `cl_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_newsletters`
--

DROP TABLE IF EXISTS `cl_newsletters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_newsletters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) DEFAULT NULL,
  `message` text,
  PRIMARY KEY (`id`),
  KEY `subject` (`subject`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_newsletters`
--

LOCK TABLES `cl_newsletters` WRITE;
/*!40000 ALTER TABLE `cl_newsletters` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_newsletters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_payment_security`
--

DROP TABLE IF EXISTS `cl_payment_security`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_payment_security` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `item_id` text,
  `security_key` varchar(255) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `promo_id` int(11) DEFAULT '0',
  `discount` double DEFAULT '0',
  `timestamp` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `payment_method` (`payment_method`),
  KEY `type` (`type`),
  KEY `security_key` (`security_key`),
  KEY `amount` (`amount`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_payment_security`
--

LOCK TABLES `cl_payment_security` WRITE;
/*!40000 ALTER TABLE `cl_payment_security` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_payment_security` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_promo_codes`
--

DROP TABLE IF EXISTS `cl_promo_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_promo_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `promo_type` varchar(255) DEFAULT NULL,
  `discount_type` varchar(255) DEFAULT NULL,
  `amount` double DEFAULT '0',
  `min_balance` double DEFAULT '0',
  `uses` int(11) DEFAULT '0',
  `expiration` int(11) DEFAULT '0',
  `timestamp` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `code` (`code`),
  KEY `promo_type` (`promo_type`),
  KEY `discount_type` (`discount_type`),
  KEY `amount` (`amount`),
  KEY `min_balance` (`min_balance`),
  KEY `uses` (`uses`),
  KEY `expiration` (`expiration`),
  KEY `timestamp` (`timestamp`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_promo_codes`
--

LOCK TABLES `cl_promo_codes` WRITE;
/*!40000 ALTER TABLE `cl_promo_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_promo_codes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_questions`
--

DROP TABLE IF EXISTS `cl_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_questions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) DEFAULT '0',
  `member_id` int(11) DEFAULT '0',
  `question` text,
  `question_approved` tinyint(1) DEFAULT '0',
  `answer` text,
  `answer_approved` tinyint(1) DEFAULT '0',
  `public` tinyint(1) DEFAULT '0',
  `timestamp` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ad_id` (`ad_id`),
  KEY `member_id` (`member_id`),
  KEY `question_approved` (`question_approved`),
  KEY `answer_approved` (`answer_approved`),
  KEY `public` (`public`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_questions`
--

LOCK TABLES `cl_questions` WRITE;
/*!40000 ALTER TABLE `cl_questions` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_questions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_queue`
--

DROP TABLE IF EXISTS `cl_queue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text,
  `headers` text,
  `timestamp` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `email` (`email`),
  KEY `subject` (`subject`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_queue`
--

LOCK TABLES `cl_queue` WRITE;
/*!40000 ALTER TABLE `cl_queue` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_queue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_saved_searches`
--

DROP TABLE IF EXISTS `cl_saved_searches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_saved_searches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `search_name` varchar(255) DEFAULT NULL,
  `search_query` text,
  `search_sql_from` text,
  `search_sql_where` text,
  `cur_catid` int(11) DEFAULT '0',
  `timestamp` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `search_name` (`search_name`),
  KEY `cur_catid` (`cur_catid`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_saved_searches`
--

LOCK TABLES `cl_saved_searches` WRITE;
/*!40000 ALTER TABLE `cl_saved_searches` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_saved_searches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_states`
--

DROP TABLE IF EXISTS `cl_states`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `relative_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `name` (`name`),
  KEY `relative_order` (`relative_order`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_states`
--

LOCK TABLES `cl_states` WRITE;
/*!40000 ALTER TABLE `cl_states` DISABLE KEYS */;
INSERT INTO `cl_states` VALUES (1,NULL,'Alabama',1),(2,NULL,'Alaska',2),(3,NULL,'Arizona',3),(4,NULL,'Arkansas',4),(5,NULL,'California',5),(6,NULL,'Colorado',6),(7,NULL,'Connecticut',7),(8,NULL,'Delaware',8),(9,NULL,'Florida',9),(10,NULL,'Georgia',10),(11,NULL,'Hawaii',11),(12,NULL,'Idaho',12),(13,NULL,'Illinois',13),(14,NULL,'Indiana',14),(15,NULL,'Iowa',15),(16,NULL,'Kansas',16),(17,NULL,'Kentucky',17),(18,NULL,'Louisiana',18),(19,NULL,'Maine',19),(20,NULL,'Maryland',20),(21,NULL,'Massachusetts',21),(22,NULL,'Michigan',22),(23,NULL,'Minnesota',23),(24,NULL,'Mississippi',24),(25,NULL,'Missouri',25),(26,NULL,'Montana',26),(27,NULL,'Nebraska',27),(28,NULL,'Nevada',28),(29,NULL,'New Hampshire',29),(30,NULL,'New Jersey',30),(31,NULL,'New Mexico',31),(32,NULL,'New York',32),(33,NULL,'North Carolina',33),(34,NULL,'North Dakota',34),(35,NULL,'Ohio',35),(36,NULL,'Oklahoma',36),(37,NULL,'Oregon',37),(38,NULL,'Pennsylvania',38),(39,NULL,'Rhode Island',39),(40,NULL,'South Carolina',40),(41,NULL,'South Dakota',41),(42,NULL,'Tennessee',42),(43,NULL,'Texas',43),(44,NULL,'Utah',44),(45,NULL,'Vermont',45),(46,NULL,'Virginia',46),(47,NULL,'Washington',47),(48,NULL,'West Virginia',48),(49,NULL,'Wisconsin',49),(50,NULL,'Wyoming',50),(51,NULL,'Outside United States',51);
/*!40000 ALTER TABLE `cl_states` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_tell_friend`
--

DROP TABLE IF EXISTS `cl_tell_friend`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_tell_friend` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `email_count` int(11) DEFAULT NULL,
  `timestamp` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `email_count` (`email_count`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_tell_friend`
--

LOCK TABLES `cl_tell_friend` WRITE;
/*!40000 ALTER TABLE `cl_tell_friend` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_tell_friend` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_themes`
--

DROP TABLE IF EXISTS `cl_themes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_themes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `top_left` varchar(255) DEFAULT NULL,
  `top_right` varchar(255) DEFAULT NULL,
  `bottom_left` varchar(255) DEFAULT NULL,
  `bottom_right` varchar(255) DEFAULT NULL,
  `left_side` varchar(255) DEFAULT NULL,
  `right_side` varchar(255) DEFAULT NULL,
  `top` varchar(255) DEFAULT NULL,
  `bottom` varchar(255) DEFAULT NULL,
  `bgcolor` varchar(6) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `thumbnail` (`thumbnail`),
  KEY `top_left` (`top_left`),
  KEY `top_right` (`top_right`),
  KEY `bottom_left` (`bottom_left`),
  KEY `bottom_right` (`bottom_right`),
  KEY `left_side` (`left_side`),
  KEY `right_side` (`right_side`),
  KEY `top` (`top`),
  KEY `bottom` (`bottom`),
  KEY `bgcolor` (`bgcolor`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_themes`
--

LOCK TABLES `cl_themes` WRITE;
/*!40000 ALTER TABLE `cl_themes` DISABLE KEYS */;
INSERT INTO `cl_themes` VALUES (1,'Red Pattern','red_pattern/red_pattern_thumbnail.gif','red_pattern/red_pattern_top_left.gif','red_pattern/red_pattern_top_right.gif','red_pattern/red_pattern_bottom_left.gif','red_pattern/red_pattern_bottom_right.gif','red_pattern/red_pattern_left_side.gif','red_pattern/red_pattern_right_side.gif','red_pattern/red_pattern_top.gif','red_pattern/red_pattern_bottom.gif','FFFFFF',1),(2,'Picture Frames','picture_frames/picture_frames_thumbnail.gif','picture_frames/picture_frames_top_left.gif','picture_frames/picture_frames_top_right.gif','picture_frames/picture_frames_bottom_left.gif','picture_frames/picture_frames_bottom_right.gif','picture_frames/picture_frames_left_side.gif','picture_frames/picture_frames_right_side.gif','picture_frames/picture_frames_top.gif','picture_frames/picture_frames_bottom.gif','FFFFFF',1),(3,'Tires','tires/tires_thumbnail.gif','tires/tires_top_left.gif','tires/tires_top_right.gif','tires/tires_bottom_left.gif','tires/tires_bottom_right.gif','tires/tires_left_side.gif','tires/tires_right_side.gif','tires/tires_top.gif','tires/tires_bottom.gif','FFFFFF',1),(4,'Earth','earth/earth_thumbnail.gif','earth/earth_top_left.gif','earth/earth_top_right.gif','earth/earth_bottom_left.gif','earth/earth_bottom_right.gif','earth/earth_left_side.gif','earth/earth_right_side.gif','earth/earth_top.gif','earth/earth_bottom.gif','FFFFFF',1),(5,'Green Border','green_border/green_border_thumbnail.gif','green_border/green_border_top_left.gif','green_border/green_border_top_right.gif','green_border/green_border_bottom_left.gif','green_border/green_border_bottom_right.gif','green_border/green_border_left_side.gif','green_border/green_border_right_side.gif','green_border/green_border_top.gif','green_border/green_border_bottom.gif','FFFFFF',1),(6,'Real Estate','real_estate/real_estate_thumbnail.gif','real_estate/real_estate_top_left.gif','real_estate/real_estate_top_right.gif','real_estate/real_estate_bottom_left.gif','real_estate/real_estate_bottom_right.gif','real_estate/real_estate_left_side.gif','real_estate/real_estate_right_side.gif','real_estate/real_estate_top.gif','real_estate/real_estate_bottom.gif','FFFFFF',1),(7,'Red Blue Border','red_blue_border/red_blue_border_thumbnail.gif','red_blue_border/red_blue_border_top_left.gif','red_blue_border/red_blue_border_top_right.gif','red_blue_border/red_blue_border_bottom_left.gif','red_blue_border/red_blue_border_bottom_right.gif','red_blue_border/red_blue_border_left_side.gif','red_blue_border/red_blue_border_right_side.gif','red_blue_border/red_blue_border_top.gif','red_blue_border/red_blue_border_bottom.gif','FFFFFF',1);
/*!40000 ALTER TABLE `cl_themes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cl_watch_list`
--

DROP TABLE IF EXISTS `cl_watch_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cl_watch_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `ad_id` int(11) DEFAULT NULL,
  `timestamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  KEY `ad_id` (`ad_id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cl_watch_list`
--

LOCK TABLES `cl_watch_list` WRITE;
/*!40000 ALTER TABLE `cl_watch_list` DISABLE KEYS */;
/*!40000 ALTER TABLE `cl_watch_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webclassifieds_bd_scheduler`
--

DROP TABLE IF EXISTS `webclassifieds_bd_scheduler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `webclassifieds_bd_scheduler` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `timestamp` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `webclassifieds_bd_scheduler`
--

LOCK TABLES `webclassifieds_bd_scheduler` WRITE;
/*!40000 ALTER TABLE `webclassifieds_bd_scheduler` DISABLE KEYS */;
INSERT INTO `webclassifieds_bd_scheduler` VALUES (1,'scheduler',1217270441),(2,'ad_finder',1217270441);
/*!40000 ALTER TABLE `webclassifieds_bd_scheduler` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'cruisegroupie'
--

--
-- Dumping routines for database 'cruisegroupie'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-07-18  2:23:29
