--
-- Host: zoogal.org    Database: zoogal_db
-- ------------------------------------------------------


--
-- Table structure for table `directory_save_data`
--

CREATE TABLE `directory_save_data` (
  `id` bigint(100) NOT NULL AUTO_INCREMENT,
  `schedule_id` bigint(100) NOT NULL,
  `project_id` bigint(100) NOT NULL,
  `link_id` bigint(100) NOT NULL,
  `confirm_link` text NOT NULL,
  `category_id` int(10) NOT NULL,
  `category_name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `directory_save_data`
--


--
-- Table structure for table `idx_admin_menu`
--

CREATE TABLE `idx_admin_menu` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `menu_title` varchar(255) DEFAULT NULL,
  `menu_url` varchar(255) DEFAULT NULL,
  `order_number` int(11) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_admin_menu`
--



--
-- Table structure for table `idx_bad_link`
--

CREATE TABLE `idx_bad_link` (
  `bad_link_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`bad_link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_bad_link`
--


--
-- Table structure for table `idx_badwords`
--

CREATE TABLE `idx_badwords` (
  `word` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_badwords`
--


--
-- Table structure for table `idx_blocked_domain`
--

CREATE TABLE `idx_blocked_domain` (
  `blocked_id` int(11) NOT NULL AUTO_INCREMENT,
  `blocked` varchar(255) DEFAULT NULL,
  `type` enum('domain','ip') DEFAULT NULL,
  PRIMARY KEY (`blocked_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_blocked_domain`
--

INSERT INTO `idx_blocked_domain` VALUES (1,'buydomains.com','domain'),(2,'this-domain-for-sale.com ','domain'),(3,'oversee.net','domain'),(4,'eNom','domain'),(5,'sedoparking.com','domain');

--
-- Table structure for table `idx_category`
--

CREATE TABLE `idx_category` (
  `category_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `image` varchar(100) DEFAULT NULL,
  `content` text,
  `visible` char(1) DEFAULT NULL,
  `links` mediumint(9) DEFAULT NULL,
  `meta_keyword` text,
  `meta_description` text,
  `permission` char(2) DEFAULT NULL,
  `registered_only` char(1) DEFAULT NULL,
  `header` text NOT NULL,
  `footer` text NOT NULL,
  `related` mediumint(6) NOT NULL DEFAULT '0',
  `page_title` varchar(200) NOT NULL DEFAULT '',
  `hits` int(11) NOT NULL DEFAULT '0',
  `order_num` smallint(6) NOT NULL DEFAULT '0',
  `basic_price` double unsigned NOT NULL DEFAULT '0',
  `premium_price` double unsigned NOT NULL DEFAULT '0',
  `sponsored_price` double unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_category`
--

INSERT INTO `idx_category` VALUES (1,0,'Arts & Humanities','','folder.gif','','1',13,'','','1','0','','',0,'',0,0,0,0,0),(2,0,'Automobile industry','','folder.gif','','1',36,'','','1','0','','',0,'',0,0,0,0,0),(3,0,'Business & Economy','','folder.gif','','1',137,'','','1','0','','',0,'',0,0,0,0,0),(4,0,'Careers','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(5,0,'Clothing & Fashion','','folder.gif','','1',10,'','','1','0','','',0,'',0,0,0,0,0),(6,0,'Mass Communications','','folder.gif','','1',24,'','','1','0','','',0,'',0,0,0,0,0),(7,0,'Computers & IT','','folder.gif','','1',19,'','','1','0','','',0,'',0,0,0,0,0),(8,0,'Construction Services','','folder.gif','','1',72,'','','1','0','','',0,'',0,0,0,0,0),(9,0,'Dental Health','','folder.gif','','1',36,'','','1','0','','',0,'',0,0,0,0,0),(10,0,'Education & Training','','folder.gif','','1',22,'','','1','0','','',0,'',0,0,0,0,0),(11,0,'Employment & Recruitment','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(12,0,'Gifts & Novelties','','folder.gif','','1',25,'','','1','0','','',0,'',0,0,0,0,0),(13,0,'Software & Hardware','','folder.gif','','1',11,'','','1','0','','',0,'',0,0,0,0,0),(14,0,'Health Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Industry','','folder.gif','','1',169,'','','1','0','','',0,'',0,0,0,0,0),(16,0,'Air Conditioning & Heating','','folder.gif','','1',56,'','','1','0','','',0,'',4,0,0,0,0),(17,0,'Home Decor & Garden','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement Services','','folder.gif','','1',293,'','','1','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Resorts','','folder.gif','','1',57,'','','1','0','','',0,'',1,0,0,0,0),(20,0,'Insurance Services','','folder.gif','','1',35,'','','1','0','','',0,'',0,0,0,0,0),(21,0,'Law Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers and Law Firms','','folder.gif','','1',162,'','','1','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & People','','folder.gif','','1',3,'','','1','0','','',0,'',0,0,0,0,0),(24,0,'Medicine  Facilities','','folder.gif','','1',12,'','','1','0','','',0,'',0,0,0,0,0),(25,0,'Financial Services','','folder.gif','','1',15,'','','1','0','','',0,'',0,0,0,0,0),(26,0,'News','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing & Plumbers','','folder.gif','','1',38,'','','1','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate Services','','folder.gif','','1',29,'','','1','0','','',0,'',0,0,0,0,0),(29,0,'Technology & Science','','folder.gif','','1',12,'','','1','0','','',0,'',0,0,0,0,0),(30,0,'SEO Services','','folder.gif','','1',23,'','','1','0','','',0,'',0,0,0,0,0),(31,0,'Shopping and Fashion','','folder.gif','','1',51,'','','1','0','','',0,'',0,0,0,0,0),(32,0,'Games & Sports','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(33,0,'Transport & Freight Forwarding','','folder.gif','','1',37,'','','1','0','','',0,'',0,0,0,0,0),(34,0,'Travel & Vacations','','folder.gif','','1',17,'','','1','0','','',0,'',0,0,0,0,0),(35,0,'Wedding Accessories','','folder.gif','','1',6,'','','1','0','','',0,'',0,0,0,0,0);

--
-- Table structure for table `idx_category_path`
--

CREATE TABLE `idx_category_path` (
  `category_id` mediumint(9) NOT NULL DEFAULT '0',
  `path` text,
  `path_with_url` text,
  `parents` text,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_category_path`
--

INSERT INTO `idx_category_path` VALUES (1,'Arts & Humanities','<a href=\"http://zoogal.org/arts-humanities/\" name=\"cat_1\" style=\"\">Arts & Humanities</a>',';0;'),(2,'Automobile industry','<a href=\"http://zoogal.org/automobile-industry/\" name=\"cat_2\" style=\"\">Automobile industry</a>',';0;'),(3,'Business & Economy','<a href=\"http://zoogal.org/business-economy/\" name=\"cat_3\" style=\"\">Business & Economy</a>',';0;'),(4,'Careers','<a href=\"http://zoogal.org/careers/\" name=\"cat_4\" style=\"\">Careers</a>',';0;'),(5,'Clothing & Fashion','<a href=\"http://zoogal.org/clothing-fashion/\" name=\"cat_5\" style=\"\">Clothing & Fashion</a>',';0;'),(6,'Mass Communications','<a href=\"http://zoogal.org/mass-communications/\" name=\"cat_6\" style=\"\">Mass Communications</a>',';0;'),(7,'Computers & IT','<a href=\"http://zoogal.org/computers-it/\" name=\"cat_7\" style=\"\">Computers & IT</a>',';0;'),(8,'Construction Services','<a href=\"http://zoogal.org/construction-services/\" name=\"cat_8\" style=\"\">Construction Services</a>',';0;'),(9,'Dental Health','<a href=\"http://zoogal.org/dental-health/\" name=\"cat_9\" style=\"\">Dental Health</a>',';0;'),(10,'Education & Training','<a href=\"http://zoogal.org/education-training/\" name=\"cat_10\" style=\"\">Education & Training</a>',';0;'),(11,'Employment & Recruitment','<a href=\"http://zoogal.org/employment-recruitment/\" name=\"cat_11\" style=\"\">Employment & Recruitment</a>',';0;'),(12,'Gifts & Novelties','<a href=\"http://zoogal.org/gifts-novelties/\" name=\"cat_12\" style=\"\">Gifts & Novelties</a>',';0;'),(13,'Software & Hardware','<a href=\"http://zoogal.org/software-hardware/\" name=\"cat_13\" style=\"\">Software & Hardware</a>',';0;'),(14,'Health Services','<a href=\"http://zoogal.org/health-services/\" name=\"cat_14\" style=\"\">Health Services</a>',';0;'),(15,'Healthcare Industry','<a href=\"http://zoogal.org/healthcare-industry/\" name=\"cat_15\" style=\"\">Healthcare Industry</a>',';0;'),(16,'Air Conditioning & Heating','<a href=\"http://zoogal.org/air-conditioning-heating/\" name=\"cat_16\" style=\"\">Air Conditioning & Heating</a>',';0;'),(17,'Home Decor & Garden','<a href=\"http://zoogal.org/home-decor-garden/\" name=\"cat_17\" style=\"\">Home Decor & Garden</a>',';0;'),(18,'Home Improvement Services','<a href=\"http://zoogal.org/home-improvement-services/\" name=\"cat_18\" style=\"\">Home Improvement Services</a>',';0;'),(19,'Hotels & Resorts','<a href=\"http://zoogal.org/hotels-resorts/\" name=\"cat_19\" style=\"\">Hotels & Resorts</a>',';0;'),(20,'Insurance Services','<a href=\"http://zoogal.org/insurance-services/\" name=\"cat_20\" style=\"\">Insurance Services</a>',';0;'),(21,'Law Services','<a href=\"http://zoogal.org/law-services/\" name=\"cat_21\" style=\"\">Law Services</a>',';0;'),(22,'Lawyers and Law Firms','<a href=\"http://zoogal.org/lawyers-and-law-firms/\" name=\"cat_22\" style=\"\">Lawyers and Law Firms</a>',';0;'),(23,'Lifestyle & People','<a href=\"http://zoogal.org/lifestyle-people/\" name=\"cat_23\" style=\"\">Lifestyle & People</a>',';0;'),(24,'Medicine  Facilities','<a href=\"http://zoogal.org/medicine-facilities/\" name=\"cat_24\" style=\"\">Medicine  Facilities</a>',';0;'),(25,'Financial Services','<a href=\"http://zoogal.org/financial-services/\" name=\"cat_25\" style=\"\">Financial Services</a>',';0;'),(26,'News','<a href=\"http://zoogal.org/news/\" name=\"cat_26\" style=\"\">News</a>',';0;'),(27,'Plumbing & Plumbers','<a href=\"http://zoogal.org/plumbing-plumbers/\" name=\"cat_27\" style=\"\">Plumbing & Plumbers</a>',';0;'),(28,'Real Estate Services','<a href=\"http://zoogal.org/real-estate-services/\" name=\"cat_28\" style=\"\">Real Estate Services</a>',';0;'),(29,'Technology & Science','<a href=\"http://zoogal.org/technology-science/\" name=\"cat_29\" style=\"\">Technology & Science</a>',';0;'),(30,'SEO Services','<a href=\"http://zoogal.org/seo-services/\" name=\"cat_30\" style=\"\">SEO Services</a>',';0;'),(31,'Shopping and Fashion','<a href=\"http://zoogal.org/shopping-and-fashion/\" name=\"cat_31\" style=\"\">Shopping and Fashion</a>',';0;'),(32,'Games & Sports','<a href=\"http://zoogal.org/games-sports/\" name=\"cat_32\" style=\"\">Games & Sports</a>',';0;'),(33,'Transport & Freight Forwarding','<a href=\"http://zoogal.org/transport-freight-forwarding/\" name=\"cat_33\" style=\"\">Transport & Freight Forwarding</a>',';0;'),(34,'Travel & Vacations','<a href=\"http://zoogal.org/travel-vacations/\" name=\"cat_34\" style=\"\">Travel & Vacations</a>',';0;'),(35,'Wedding Accessories','<a href=\"http://zoogal.org/wedding-accessories/\" name=\"cat_35\" style=\"\">Wedding Accessories</a>',';0;');

--
-- Table structure for table `idx_category_suggession`
--

CREATE TABLE `idx_category_suggession` (
  `id_cat_suggession` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `category_description` text,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id_cat_suggession`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_category_suggession`
--


--
-- Table structure for table `idx_checkurl`
--

CREATE TABLE `idx_checkurl` (
  `link_id` mediumint(9) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `live` char(1) NOT NULL DEFAULT '',
  `reciprocal_found` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_checkurl`
--


--
-- Table structure for table `idx_cronjobs`
--

CREATE TABLE `idx_cronjobs` (
  `cronjobs_id` int(11) NOT NULL AUTO_INCREMENT,
  `cronjobs_name` varchar(255) DEFAULT NULL,
  `filename` varchar(255) NOT NULL,
  `schedule` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
  `execution` varchar(1) NOT NULL,
  PRIMARY KEY (`cronjobs_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_cronjobs`
--

INSERT INTO `idx_cronjobs` VALUES (1,NULL,'clear_templates_c.php','1,*,*,*,*','0000-00-00 00:00:00',''),(2,NULL,'update_tag_cloud.php','*,24,*,*,*','0000-00-00 00:00:00',''),(3,NULL,'clear_rss_cache.php','*,24,*,*,*','0000-00-00 00:00:00','');

--
-- Table structure for table `idx_custom_field`
--

CREATE TABLE `idx_custom_field` (
  `field_name` varchar(32) NOT NULL DEFAULT '',
  `field_text` varchar(64) NOT NULL DEFAULT '',
  `field_type` enum('TEXT','TEXTAREA','SELECT','MULTISELECT','CHECKBOX','RADIO','FILE','IMAGE','DATE','DATETIME','RICHEDITOR') NOT NULL DEFAULT 'TEXT',
  `field_option` text NOT NULL,
  `field_img_width` int(10) unsigned NOT NULL DEFAULT '0',
  `field_img_height` int(10) unsigned NOT NULL DEFAULT '0',
  `field_file_size` int(10) unsigned NOT NULL DEFAULT '0',
  `field_file_extension` varchar(64) NOT NULL DEFAULT '',
  `required` char(1) NOT NULL DEFAULT '0',
  `searchable` char(1) NOT NULL DEFAULT '1',
  `permission` char(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_custom_field`
--

INSERT INTO `idx_custom_field` VALUES ('image','Image','IMAGE','',0,0,0,'','0','0','2'),('address','Address','TEXT','',0,0,0,'','0','0','0'),('city','City','TEXT','',0,0,0,'','0','0','0'),('state','State','TEXT','',0,0,0,'','0','0','0'),('country','Country','TEXT','',0,0,0,'','0','0','0'),('zip','Zip','TEXT','',0,0,0,'','0','0','0'),('phone','Phone','TEXT','',0,0,0,'','0','0','0'),('fax','Fax','TEXT','',0,0,0,'','0','0','0');

--
-- Table structure for table `idx_default_field`
--

CREATE TABLE `idx_default_field` (
  `field_name` varchar(64) NOT NULL,
  `required` char(1) NOT NULL,
  `visible` char(1) NOT NULL DEFAULT '1',
  `searchable` char(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_default_field`
--

INSERT INTO `idx_default_field` VALUES ('title','1','1','1'),('url','1','1','1'),('description','1','1','1'),('keywords','1','1','0'),('contact_name','1','1','1'),('email','1','1','1'),('reciprocal_url','0','0','1');

--
-- Table structure for table `idx_discount_coupon`
--

CREATE TABLE `idx_discount_coupon` (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_code` varchar(255) DEFAULT NULL,
  `coupon_value` varchar(50) DEFAULT NULL,
  `link_type` varchar(255) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `expired_date` date DEFAULT NULL,
  `expired_usage` int(11) DEFAULT NULL,
  `usage_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_discount_coupon`
--


--
-- Table structure for table `idx_editor`
--

CREATE TABLE `idx_editor` (
  `username` varchar(20) DEFAULT NULL,
  `category_id` mediumint(9) DEFAULT NULL,
  `category` char(1) DEFAULT NULL,
  `link` char(1) DEFAULT NULL,
  `review` char(1) DEFAULT NULL,
  `pick` char(1) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `date` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_editor`
--


--
-- Table structure for table `idx_email_template`
--

CREATE TABLE `idx_email_template` (
  `email_template_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `body` text,
  `altbody` text,
  PRIMARY KEY (`email_template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_email_template`
--



--
-- Table structure for table `idx_favorites`
--

CREATE TABLE `idx_favorites` (
  `favorite_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`favorite_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_favorites`
--

INSERT INTO `idx_favorites` VALUES (1,'domingostuard69v23','2011-10-18','My Favorites',NULL),(2,'romeodorseys41u29','2011-10-19','My Favorites',NULL),(3,'aaroj9hqco','2011-10-20','My Favorites',NULL),(4,'brucvwoywi','2011-10-21','My Favorites',NULL),(5,'desmondwilmey95r87','2011-10-31','My Favorites',NULL),(6,'thanhchaunceg22s94','2011-11-02','My Favorites',NULL),(7,'ryanapfksc','2011-11-25','My Favorites',NULL),(8,'dougqetwza','2011-12-21','My Favorites',NULL);

--
-- Table structure for table `idx_favorites_detail`
--

CREATE TABLE `idx_favorites_detail` (
  `favorite_id` int(11) DEFAULT NULL,
  `link_id` mediumint(9) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_favorites_detail`
--


--
-- Table structure for table `idx_hook_place`
--

CREATE TABLE `idx_hook_place` (
  `hook_place_id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) DEFAULT NULL,
  `hookname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_hook_place`
--


--
-- Table structure for table `idx_invoice`
--

CREATE TABLE `idx_invoice` (
  `invoice_id` varchar(10) NOT NULL DEFAULT '',
  `invoice_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `invoiced_to` text,
  `service` varchar(255) DEFAULT NULL,
  `description` text,
  `total` double(8,2) DEFAULT NULL,
  `comment` text,
  `paid` char(1) DEFAULT NULL,
  `paid_date` date DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_invoice`
--


--
-- Table structure for table `idx_invoice_config`
--

CREATE TABLE `idx_invoice_config` (
  `company` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `address` text,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `currency_symbol` varchar(255) DEFAULT '$',
  `currency_code` varchar(255) DEFAULT 'USD'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_invoice_config`
--

INSERT INTO `idx_invoice_config` VALUES ('Your website / Company','Billing Department','Your address','Your phone #','Billing<name@yourdomain.com>','$','USD');

--
-- Table structure for table `idx_link_temp`
--

CREATE TABLE `idx_link_temp` (
  `vid` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `spam` char(1) NOT NULL DEFAULT '0',
  `link_id` mediumint(9) DEFAULT NULL,
  `category_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `url` text NOT NULL,
  `description` text NOT NULL,
  `contact_name` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `hits` mediumint(9) DEFAULT NULL,
  `votes` smallint(6) DEFAULT NULL,
  `rating` float(4,2) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `bid` smallint(6) NOT NULL DEFAULT '0',
  `new` char(1) DEFAULT NULL,
  `hot` char(1) DEFAULT NULL,
  `top_rated` char(1) DEFAULT NULL,
  `pick` char(1) DEFAULT NULL,
  `password` varchar(20) DEFAULT NULL,
  `updated` char(1) DEFAULT NULL,
  `reviews` smallint(6) DEFAULT NULL,
  `avg_review` float(4,2) DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `official_review` text,
  `keywords` varchar(255) DEFAULT NULL,
  `cat1` mediumint(6) NOT NULL DEFAULT '0',
  `cat2` mediumint(6) NOT NULL DEFAULT '0',
  `suspended` char(1) NOT NULL DEFAULT '0',
  `reciprocal_url` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_temp`
--


--
-- Table structure for table `idx_link_temp_user`
--

CREATE TABLE `idx_link_temp_user` (
  `vid` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_temp_user`
--


--
-- Table structure for table `idx_link_user`
--

CREATE TABLE `idx_link_user` (
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_user`
--


--
-- Table structure for table `idx_mailing_list`
--

CREATE TABLE `idx_mailing_list` (
  `email` varchar(50) NOT NULL DEFAULT '',
  `code` varchar(4) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_mailing_list`
--


--
-- Table structure for table `idx_message`
--

CREATE TABLE `idx_message` (
  `message_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `body` text,
  `subject` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_message`
--


--
-- Table structure for table `idx_notification`
--

CREATE TABLE `idx_notification` (
  `username` varchar(20) NOT NULL DEFAULT '',
  `category_id` mediumint(9) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_notification`
--


--
-- Table structure for table `idx_pagerank`
--

CREATE TABLE `idx_pagerank` (
  `link_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `engine` char(1) NOT NULL DEFAULT '',
  `rank` tinyint(4) NOT NULL DEFAULT '0',
  `last_update` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`link_id`,`engine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pagerank`
--

INSERT INTO `idx_pagerank` VALUES (6,'g',0,'2012-02-15'),(4,'g',0,'2012-02-15'),(1,'g',0,'2012-02-15'),(11,'g',0,'2012-02-15'),(3,'g',0,'2012-01-21'),(12,'g',0,'2012-02-29'),(5,'g',0,'2011-12-29'),(16,'g',0,'2012-02-15'),(13,'g',0,'2012-02-15'),(10,'g',0,'2012-02-12'),(17,'g',0,'2012-01-24'),(8,'g',0,'2012-02-15'),(9,'g',0,'2012-02-15'),(15,'g',0,'2011-10-31'),(2,'g',0,'2012-02-11'),(7,'g',0,'2012-02-02'),(14,'g',0,'2011-12-15'),(18,'g',0,'2012-02-15'),(19,'g',0,'2011-11-08'),(68,'g',0,'2011-11-28'),(29,'g',0,'2011-11-28'),(74,'g',0,'2011-11-28'),(41,'g',0,'2011-11-28'),(21,'g',0,'2011-11-28'),(84,'g',0,'2011-11-28'),(79,'g',0,'2011-11-28'),(32,'g',0,'2011-11-28'),(23,'g',0,'2011-11-28'),(97,'g',0,'2011-11-28'),(104,'g',0,'2011-11-28'),(425,'g',0,'2011-11-28'),(474,'g',0,'2011-11-28'),(440,'g',0,'2011-11-28'),(58,'g',0,'2011-11-28'),(293,'g',0,'2011-11-28'),(361,'g',0,'2011-11-29'),(136,'g',0,'2011-11-29'),(365,'g',0,'2011-11-29'),(363,'g',0,'2011-11-29'),(371,'g',0,'2011-11-29'),(368,'g',0,'2011-11-29'),(366,'g',0,'2011-11-29'),(259,'g',0,'2011-11-29'),(241,'g',0,'2011-11-29'),(515,'g',0,'2011-11-29'),(331,'g',0,'2011-11-29'),(656,'g',0,'2011-11-29'),(59,'g',0,'2011-11-29'),(94,'g',0,'2011-11-29'),(48,'g',0,'2011-11-29'),(177,'g',0,'2011-11-29'),(173,'g',0,'2011-11-29'),(128,'g',0,'2011-11-29'),(164,'g',0,'2011-11-29'),(133,'g',0,'2011-11-29'),(478,'g',0,'2011-11-29'),(588,'g',0,'2011-11-29'),(631,'g',0,'2011-11-30'),(233,'g',0,'2011-11-30'),(47,'g',0,'2011-11-30'),(55,'g',0,'2011-11-30'),(376,'g',0,'2011-11-30'),(131,'g',0,'2011-11-30'),(111,'g',0,'2011-11-30'),(471,'g',0,'2011-11-30'),(134,'g',0,'2011-11-30'),(424,'g',0,'2011-11-30'),(446,'g',0,'2011-11-30'),(489,'g',0,'2011-11-30'),(219,'g',0,'2011-11-30'),(93,'g',0,'2011-11-30'),(223,'g',0,'2011-11-30'),(345,'g',0,'2011-11-30'),(771,'g',0,'2011-11-30'),(756,'g',0,'2011-11-30'),(392,'g',0,'2011-11-30'),(418,'g',0,'2011-11-30'),(254,'g',0,'2011-11-30'),(38,'g',0,'2011-11-30'),(335,'g',0,'2011-11-30'),(103,'g',0,'2011-11-30'),(62,'g',0,'2011-12-01'),(400,'g',0,'2011-12-01'),(64,'g',0,'2011-12-01'),(57,'g',0,'2011-12-01'),(42,'g',0,'2011-12-01'),(208,'g',0,'2011-12-01'),(39,'g',0,'2011-12-01'),(51,'g',0,'2011-12-01'),(753,'g',0,'2011-12-01'),(765,'g',0,'2011-12-01'),(415,'g',0,'2011-12-01'),(417,'g',0,'2011-12-01'),(318,'g',0,'2011-12-01'),(215,'g',0,'2011-12-01'),(170,'g',0,'2011-12-01'),(416,'g',0,'2011-12-01'),(49,'g',0,'2011-12-01'),(66,'g',0,'2011-12-01'),(245,'g',0,'2011-12-01'),(123,'g',0,'2011-12-01'),(780,'g',0,'2011-12-01'),(253,'g',0,'2011-12-01'),(627,'g',0,'2011-12-01'),(227,'g',0,'2011-12-01'),(182,'g',0,'2011-12-01'),(135,'g',0,'2011-12-01'),(257,'g',0,'2011-12-01'),(602,'g',0,'2011-12-01'),(561,'g',0,'2011-12-01'),(557,'g',0,'2011-12-01'),(960,'g',0,'2011-12-01'),(487,'g',0,'2011-12-01'),(246,'g',0,'2011-12-01'),(560,'g',0,'2011-12-01'),(696,'g',0,'2011-12-01'),(255,'g',0,'2011-12-01'),(1162,'g',0,'2011-12-03'),(448,'g',0,'2011-12-03'),(697,'g',0,'2011-12-03'),(1420,'g',0,'2011-12-03'),(1891,'g',0,'2011-12-03'),(2161,'g',0,'2011-12-03'),(964,'g',0,'2011-12-04'),(250,'g',0,'2011-12-04'),(1693,'g',0,'2011-12-04'),(73,'g',0,'2011-12-04'),(407,'g',0,'2011-12-04'),(67,'g',0,'2011-12-04'),(269,'g',0,'2011-12-04'),(220,'g',0,'2011-12-04'),(330,'g',0,'2011-12-05'),(201,'g',0,'2011-12-05'),(137,'g',0,'2011-12-05'),(205,'g',0,'2011-12-05'),(36,'g',0,'2011-12-05'),(35,'g',0,'2011-12-05'),(411,'g',0,'2011-12-05'),(461,'g',0,'2011-12-05'),(118,'g',0,'2011-12-05'),(263,'g',0,'2011-12-05'),(449,'g',0,'2011-12-05'),(119,'g',0,'2011-12-05'),(426,'g',0,'2011-12-05'),(441,'g',0,'2011-12-05'),(83,'g',0,'2011-12-05'),(20,'g',0,'2011-12-05'),(24,'g',0,'2011-12-05'),(132,'g',0,'2011-12-05'),(158,'g',0,'2011-12-05'),(126,'g',0,'2011-12-05'),(105,'g',0,'2011-12-05'),(116,'g',0,'2011-12-05'),(102,'g',0,'2011-12-05'),(22,'g',0,'2011-12-05'),(155,'g',0,'2011-12-05'),(122,'g',0,'2011-12-05'),(145,'g',0,'2011-12-05'),(141,'g',0,'2011-12-05'),(113,'g',0,'2011-12-05'),(112,'g',0,'2011-12-05'),(167,'g',0,'2011-12-05'),(229,'g',0,'2011-12-05'),(139,'g',0,'2011-12-05'),(405,'g',0,'2011-12-06'),(544,'g',0,'2011-12-06'),(2710,'g',0,'2011-12-06'),(2890,'g',0,'2011-12-06'),(2269,'g',0,'2011-12-06'),(71,'g',0,'2011-12-06'),(69,'g',0,'2011-12-06'),(40,'g',0,'2011-12-06'),(955,'g',0,'2011-12-06'),(54,'g',0,'2011-12-06'),(362,'g',0,'2011-12-06'),(2109,'g',0,'2011-12-06'),(1045,'g',0,'2011-12-06'),(2910,'g',0,'2011-12-06'),(52,'g',0,'2011-12-07'),(180,'g',0,'2011-12-07'),(445,'g',0,'2011-12-07'),(947,'g',0,'2011-12-07'),(326,'g',0,'2011-12-07'),(1378,'g',0,'2011-12-07'),(28,'g',0,'2011-12-07'),(459,'g',0,'2011-12-07'),(179,'g',0,'2011-12-07'),(396,'g',0,'2011-12-07'),(539,'g',0,'2011-12-07'),(1418,'g',0,'2011-12-07'),(101,'g',0,'2011-12-07'),(154,'g',0,'2011-12-07'),(475,'g',0,'2011-12-07'),(942,'g',0,'2011-12-07'),(87,'g',0,'2011-12-07'),(88,'g',0,'2011-12-07'),(354,'g',0,'2011-12-07'),(271,'g',0,'2011-12-07'),(46,'g',0,'2011-12-07'),(184,'g',0,'2011-12-07'),(44,'g',0,'2011-12-07'),(647,'g',0,'2011-12-07'),(98,'g',0,'2011-12-07'),(82,'g',0,'2011-12-07'),(325,'g',0,'2011-12-07'),(494,'g',0,'2011-12-07'),(110,'g',0,'2011-12-07'),(143,'g',0,'2011-12-07'),(26,'g',0,'2011-12-07'),(100,'g',0,'2011-12-07'),(106,'g',0,'2011-12-07'),(592,'g',0,'2011-12-07'),(600,'g',0,'2011-12-07'),(301,'g',0,'2011-12-07'),(2189,'g',0,'2011-12-07'),(546,'g',0,'2011-12-07'),(412,'g',0,'2011-12-07'),(541,'g',0,'2011-12-07'),(537,'g',0,'2011-12-07'),(485,'g',0,'2011-12-07'),(800,'g',0,'2011-12-07'),(27,'g',0,'2011-12-07'),(1671,'g',0,'2011-12-07'),(34,'g',0,'2011-12-07'),(204,'g',0,'2011-12-07'),(386,'g',0,'2011-12-07'),(30,'g',0,'2011-12-07'),(740,'g',0,'2011-12-07'),(1255,'g',0,'2011-12-07'),(56,'g',0,'2011-12-07'),(31,'g',0,'2011-12-07'),(161,'g',0,'2011-12-07'),(96,'g',0,'2011-12-07'),(399,'g',0,'2011-12-07'),(427,'g',0,'2011-12-07'),(109,'g',0,'2011-12-07'),(33,'g',0,'2011-12-07'),(589,'g',0,'2011-12-07'),(385,'g',0,'2011-12-07'),(538,'g',0,'2011-12-07'),(175,'g',0,'2011-12-07'),(510,'g',0,'2011-12-07'),(321,'g',0,'2011-12-07'),(590,'g',0,'2011-12-07'),(37,'g',0,'2011-12-07'),(488,'g',0,'2011-12-07'),(460,'g',0,'2011-12-07'),(159,'g',0,'2011-12-07'),(86,'g',0,'2011-12-07'),(25,'g',0,'2011-12-07'),(228,'g',0,'2011-12-07'),(432,'g',0,'2011-12-07'),(695,'g',0,'2011-12-07'),(244,'g',0,'2011-12-07'),(127,'g',0,'2011-12-07'),(497,'g',0,'2011-12-07'),(53,'g',0,'2011-12-07'),(60,'g',0,'2011-12-07'),(80,'g',0,'2011-12-07'),(81,'g',0,'2011-12-07'),(479,'g',0,'2011-12-07'),(196,'g',0,'2011-12-07'),(72,'g',0,'2011-12-07'),(721,'g',0,'2011-12-07'),(1146,'g',0,'2011-12-07'),(369,'g',0,'2011-12-07'),(2472,'g',0,'2011-12-07'),(130,'g',0,'2011-12-07'),(50,'g',0,'2011-12-07'),(75,'g',0,'2011-12-07'),(142,'g',0,'2011-12-07'),(1444,'g',0,'2011-12-07'),(444,'g',0,'2011-12-07'),(70,'g',0,'2011-12-07'),(43,'g',0,'2011-12-07'),(156,'g',0,'2011-12-07'),(506,'g',0,'2011-12-07'),(2991,'g',0,'2011-12-07'),(464,'g',0,'2011-12-07'),(1113,'g',0,'2011-12-07'),(591,'g',0,'2011-12-07'),(76,'g',0,'2011-12-07'),(108,'g',0,'2011-12-07'),(45,'g',0,'2011-12-07'),(91,'g',0,'2011-12-07'),(1369,'g',0,'2011-12-07'),(165,'g',0,'2011-12-07'),(793,'g',0,'2011-12-08'),(3175,'g',0,'2011-12-08'),(1522,'g',0,'2011-12-08'),(2323,'g',0,'2011-12-08'),(3816,'g',0,'2011-12-09'),(3544,'g',0,'2011-12-09'),(2963,'g',0,'2011-12-09'),(2692,'g',0,'2011-12-09'),(332,'g',0,'2011-12-10'),(2494,'g',0,'2011-12-10'),(3346,'g',0,'2011-12-10'),(752,'g',0,'2011-12-11'),(420,'g',0,'2011-12-11'),(419,'g',0,'2011-12-11'),(763,'g',0,'2011-12-11'),(431,'g',0,'2011-12-11'),(1059,'g',0,'2011-12-11'),(1032,'g',0,'2011-12-11'),(1049,'g',0,'2011-12-11'),(1129,'g',0,'2011-12-11'),(1106,'g',0,'2011-12-11'),(968,'g',0,'2011-12-11'),(1482,'g',0,'2011-12-11'),(2286,'g',0,'2011-12-11'),(1130,'g',0,'2011-12-11'),(1500,'g',0,'2011-12-11'),(1114,'g',0,'2011-12-11'),(1843,'g',0,'2011-12-11'),(1492,'g',0,'2011-12-11'),(1761,'g',0,'2011-12-11'),(1481,'g',0,'2011-12-11'),(1145,'g',0,'2011-12-11'),(1494,'g',0,'2011-12-11'),(1134,'g',0,'2011-12-11'),(1132,'g',0,'2011-12-11'),(1131,'g',0,'2011-12-11'),(1133,'g',0,'2011-12-11'),(1778,'g',0,'2011-12-11'),(2283,'g',0,'2011-12-11'),(1485,'g',0,'2011-12-11'),(1697,'g',0,'2011-12-11'),(4125,'g',0,'2012-02-16'),(4055,'g',0,'2012-02-12'),(4208,'g',0,'2011-12-12'),(4189,'g',0,'2011-12-12'),(4256,'g',0,'2011-12-12'),(4394,'g',0,'2011-12-12'),(4061,'g',0,'2012-02-12'),(4193,'g',0,'2011-12-12'),(4317,'g',0,'2011-12-12'),(4406,'g',0,'2011-12-12'),(4418,'g',0,'2011-12-12'),(4909,'g',0,'2011-12-12'),(4407,'g',0,'2011-12-12'),(4432,'g',0,'2011-12-12'),(4392,'g',0,'2011-12-12'),(4446,'g',0,'2011-12-12'),(4313,'g',0,'2011-12-12'),(4118,'g',0,'2012-02-16'),(4925,'g',0,'2011-12-12'),(4349,'g',0,'2011-12-12'),(4115,'g',0,'2012-02-15'),(4168,'g',0,'2012-02-15'),(4028,'g',0,'2012-02-13'),(4920,'g',0,'2011-12-12'),(4015,'g',0,'2011-12-12'),(4019,'g',0,'2011-12-12'),(4018,'g',0,'2011-12-12'),(4021,'g',0,'2011-12-12'),(4032,'g',0,'2011-12-12'),(4013,'g',0,'2012-02-02'),(4921,'g',0,'2011-12-12'),(4435,'g',0,'2011-12-13'),(4707,'g',0,'2011-12-13'),(4923,'g',0,'2011-12-14'),(4965,'g',0,'2012-02-13'),(4961,'g',0,'2011-12-14'),(4934,'g',0,'2011-12-14'),(4960,'g',0,'2011-12-14'),(4086,'g',0,'2011-12-14'),(4089,'g',0,'2011-12-14'),(4258,'g',0,'2011-12-14'),(4308,'g',0,'2011-12-14'),(4184,'g',0,'2011-12-14'),(4356,'g',0,'2011-12-14'),(4088,'g',0,'2011-12-14'),(4084,'g',0,'2011-12-14'),(4217,'g',0,'2011-12-14'),(4143,'g',0,'2012-02-15'),(4155,'g',0,'2011-12-14'),(4101,'g',0,'2012-02-16'),(4100,'g',0,'2012-02-13'),(4133,'g',0,'2012-02-15'),(4127,'g',0,'2012-02-15'),(4129,'g',0,'2011-12-14'),(4110,'g',0,'2012-02-15'),(4010,'g',0,'2012-02-15'),(4917,'g',0,'2011-12-14'),(4634,'g',0,'2012-02-02'),(4945,'g',0,'2012-02-02'),(4453,'g',0,'2012-02-02'),(4654,'g',0,'2011-12-15'),(4983,'g',0,'2012-02-15'),(4979,'g',0,'2012-02-15'),(4981,'g',0,'2012-02-15'),(4978,'g',0,'2012-02-13'),(4977,'g',0,'2011-12-15'),(4985,'g',0,'2012-02-15'),(4982,'g',0,'2012-02-15'),(4980,'g',0,'2012-02-15'),(4984,'g',0,'2012-02-15'),(4161,'g',0,'2011-12-17'),(4451,'g',0,'2012-02-15'),(4914,'g',0,'2011-12-17'),(4472,'g',0,'2012-02-16'),(4121,'g',0,'2011-12-17'),(4152,'g',0,'2011-12-17'),(4036,'g',0,'2011-12-17'),(4949,'g',0,'2012-02-15'),(4074,'g',0,'2012-02-15'),(4047,'g',0,'2011-12-17'),(4484,'g',0,'2012-02-15'),(4116,'g',0,'2011-12-17'),(4547,'g',0,'2012-03-03'),(4718,'g',0,'2011-12-17'),(4234,'g',0,'2012-03-03'),(4706,'g',0,'2011-12-17'),(4548,'g',0,'2012-03-03'),(4589,'g',0,'2011-12-17'),(4544,'g',0,'2012-03-03'),(4955,'g',0,'2012-03-03'),(4474,'g',0,'2012-03-03'),(4242,'g',0,'2012-03-03'),(4034,'g',0,'2012-02-15'),(4497,'g',0,'2012-02-15'),(4144,'g',0,'2012-02-15'),(4431,'g',0,'2011-12-17'),(4373,'g',0,'2011-12-17'),(4481,'g',0,'2011-12-17'),(4341,'g',0,'2011-12-17'),(4058,'g',0,'2012-02-13'),(4070,'g',0,'2012-02-15'),(4123,'g',0,'2012-02-15'),(4587,'g',0,'2012-02-15'),(4075,'g',0,'2012-02-16'),(4056,'g',0,'2011-12-17'),(4996,'g',0,'2011-12-17'),(4029,'g',0,'2011-12-17'),(4131,'g',0,'2012-02-15'),(4974,'g',0,'2011-12-17'),(4998,'g',0,'2011-12-17'),(4017,'g',0,'2011-12-17'),(4240,'g',0,'2012-02-12'),(4009,'g',0,'2011-12-17'),(4355,'g',0,'2012-02-15'),(4124,'g',0,'2012-02-15'),(4352,'g',0,'2012-02-16'),(4916,'g',0,'2011-12-17'),(4350,'g',0,'2012-02-15'),(4353,'g',0,'2012-02-15'),(4358,'g',0,'2011-12-17'),(4348,'g',0,'2012-02-15'),(4246,'g',0,'2012-02-13'),(4031,'g',0,'2012-02-15'),(4167,'g',0,'2012-02-15'),(4054,'g',0,'2012-02-15'),(4215,'g',0,'2012-02-15'),(4399,'g',0,'2011-12-17'),(4232,'g',0,'2012-02-13'),(4079,'g',0,'2012-02-13'),(4149,'g',0,'2012-02-15'),(4192,'g',0,'2012-02-15'),(4244,'g',0,'2011-12-17'),(4312,'g',0,'2011-12-17'),(4493,'g',0,'2011-12-17'),(4922,'g',0,'2011-12-17'),(4094,'g',0,'2011-12-17'),(4147,'g',0,'2012-02-15'),(4475,'g',0,'2011-12-18'),(4014,'g',0,'2012-02-15'),(4372,'g',0,'2012-02-12'),(4098,'g',0,'2012-02-15'),(4622,'g',0,'2011-12-18'),(4975,'g',0,'2011-12-18'),(4172,'g',0,'2011-12-18'),(4170,'g',0,'2012-02-16'),(4931,'g',0,'2011-12-18'),(4959,'g',0,'2011-12-18'),(4076,'g',0,'2012-02-16'),(4153,'g',0,'2011-12-18'),(4957,'g',0,'2011-12-18'),(4233,'g',0,'2012-02-15'),(4968,'g',0,'2011-12-18'),(4948,'g',0,'2012-02-15'),(4462,'g',0,'2011-12-18'),(4082,'g',0,'2011-12-18'),(4288,'g',0,'2012-02-13'),(4947,'g',0,'2011-12-18'),(4111,'g',0,'2012-02-15'),(4926,'g',0,'2011-12-18'),(4933,'g',0,'2011-12-18'),(4971,'g',0,'2012-02-15'),(4956,'g',0,'2012-02-15'),(4012,'g',0,'2011-12-18'),(4928,'g',0,'2011-12-18'),(4913,'g',0,'2011-12-18'),(4008,'g',0,'2011-12-18'),(4924,'g',0,'2011-12-18'),(4940,'g',0,'2011-12-18'),(4930,'g',0,'2011-12-18'),(4919,'g',0,'2011-12-18'),(4962,'g',0,'2012-02-13'),(4915,'g',0,'2011-12-18'),(4944,'g',0,'2011-12-18'),(4952,'g',0,'2011-12-18'),(4911,'g',0,'2011-12-18'),(4958,'g',0,'2012-02-13'),(4044,'g',0,'2012-02-15'),(4954,'g',0,'2011-12-18'),(4973,'g',0,'2012-02-13'),(4091,'g',0,'2012-02-13'),(4052,'g',0,'2012-02-15'),(4081,'g',0,'2011-12-18'),(4943,'g',0,'2012-02-15'),(4932,'g',0,'2011-12-18'),(4953,'g',0,'2012-02-15'),(4158,'g',0,'2012-02-16'),(4050,'g',0,'2012-02-15'),(4027,'g',0,'2012-02-13'),(4039,'g',0,'2011-12-18'),(4387,'g',0,'2012-02-15'),(4241,'g',0,'2012-02-15'),(4045,'g',0,'2012-02-15'),(4030,'g',0,'2012-02-15'),(4992,'g',0,'2012-01-24'),(4936,'g',0,'2011-12-19'),(4970,'g',0,'2012-02-15'),(4941,'g',0,'2011-12-19'),(4950,'g',0,'2011-12-19'),(4964,'g',0,'2011-12-19'),(4938,'g',0,'2011-12-19'),(4966,'g',0,'2012-02-15'),(4502,'g',0,'2012-02-12'),(4318,'g',0,'2012-02-15'),(4221,'g',0,'2011-12-19'),(4229,'g',0,'2012-02-15'),(4575,'g',0,'2012-02-15'),(4626,'g',0,'2012-02-15'),(4465,'g',0,'2012-02-16'),(4293,'g',0,'2011-12-20'),(4976,'g',0,'2012-02-15'),(4322,'g',0,'2012-02-15'),(4332,'g',0,'2012-02-13'),(4037,'g',0,'2012-02-15'),(4305,'g',0,'2012-02-15'),(4404,'g',0,'2011-12-22'),(4999,'g',0,'2012-02-15'),(4379,'g',0,'2012-02-16'),(4402,'g',0,'2012-02-15'),(4403,'g',0,'2012-02-15'),(4026,'g',0,'2011-12-22'),(4398,'g',0,'2012-02-15'),(4433,'g',0,'2012-02-12'),(4250,'g',0,'2011-12-22'),(4428,'g',0,'2012-02-15'),(4963,'g',0,'2012-02-15'),(4035,'g',0,'2012-02-16'),(4411,'g',0,'2012-02-12'),(4436,'g',0,'2012-02-15'),(4122,'g',0,'2012-02-15'),(4023,'g',0,'2012-02-16'),(4972,'g',0,'2012-02-12'),(4448,'g',0,'2011-12-22'),(4024,'g',0,'2012-02-16'),(4107,'g',0,'2012-02-15'),(4043,'g',0,'2012-02-15'),(4106,'g',0,'2012-02-15'),(4413,'g',0,'2012-02-15'),(4119,'g',0,'2012-02-15'),(4099,'g',0,'2011-12-22'),(4363,'g',0,'2012-02-16'),(4986,'g',0,'2012-02-15'),(4458,'g',0,'2012-02-12'),(4528,'g',0,'2012-03-04'),(4645,'g',0,'2011-12-22'),(5018,'g',0,'2012-02-15'),(4386,'g',0,'2012-03-04'),(4419,'g',0,'2012-03-04'),(4705,'g',0,'2011-12-22'),(4579,'g',0,'2012-02-12'),(4576,'g',0,'2012-02-15'),(4525,'g',0,'2012-02-15'),(4447,'g',0,'2012-02-15'),(4526,'g',0,'2012-02-15'),(4383,'g',0,'2012-02-13'),(4414,'g',0,'2012-02-15'),(4578,'g',0,'2012-02-15'),(4524,'g',0,'2012-02-15'),(4937,'g',0,'2011-12-22'),(4967,'g',0,'2011-12-22'),(4969,'g',0,'2011-12-22'),(4991,'g',0,'2011-12-22'),(5016,'g',0,'2011-12-22'),(4946,'g',0,'2011-12-22'),(4942,'g',0,'2011-12-22'),(4951,'g',0,'2011-12-22'),(4935,'g',0,'2011-12-22'),(4016,'g',0,'2011-12-22'),(5009,'g',0,'2012-02-13'),(4577,'g',0,'2012-02-15'),(4993,'g',0,'2012-02-15'),(4995,'g',0,'2012-02-15'),(4989,'g',0,'2012-02-15'),(4990,'g',0,'2012-02-15'),(5026,'g',0,'2012-01-24'),(4427,'g',0,'2012-02-15'),(5038,'g',0,'2011-12-23'),(5034,'g',0,'2011-12-23'),(5020,'g',0,'2012-02-02'),(5010,'g',0,'2011-12-23'),(5033,'g',0,'2011-12-23'),(5027,'g',0,'2012-02-15'),(4085,'g',0,'2012-02-02'),(4092,'g',0,'2012-02-02'),(4461,'g',0,'2011-12-23'),(4412,'g',0,'2012-02-15'),(4046,'g',0,'2012-02-02'),(4020,'g',0,'2012-02-02'),(4280,'g',0,'2012-02-15'),(4011,'g',0,'2012-02-02'),(5023,'g',0,'2012-02-15'),(4022,'g',0,'2011-12-24'),(4025,'g',0,'2011-12-24'),(5014,'g',0,'2012-02-15'),(5001,'g',0,'2012-02-15'),(4939,'g',0,'2011-12-24'),(5000,'g',0,'2011-12-24'),(5011,'g',0,'2012-02-15'),(4216,'g',0,'2011-12-26'),(4735,'g',0,'2011-12-26'),(4649,'g',0,'2011-12-26'),(4607,'g',0,'2011-12-26'),(4657,'g',0,'2011-12-26'),(4549,'g',0,'2011-12-26'),(4531,'g',0,'2011-12-26'),(4652,'g',0,'2011-12-26'),(5024,'g',0,'2012-02-16'),(5059,'g',0,'2011-12-27'),(5070,'g',0,'2011-12-27'),(5048,'g',0,'2011-12-27'),(5056,'g',0,'2011-12-27'),(4710,'g',0,'2011-12-27'),(4668,'g',0,'2011-12-27'),(4692,'g',0,'2011-12-27'),(5025,'g',0,'2012-02-15'),(4165,'g',0,'2011-12-27'),(4186,'g',0,'2011-12-27'),(5052,'g',0,'2012-02-02'),(4179,'g',0,'2011-12-28'),(4489,'g',0,'2011-12-28'),(5053,'g',0,'2012-02-15'),(4492,'g',0,'2011-12-28'),(4464,'g',0,'2011-12-28'),(4584,'g',0,'2011-12-28'),(4784,'g',0,'2011-12-28'),(4602,'g',0,'2011-12-28'),(4601,'g',0,'2011-12-28'),(4599,'g',0,'2011-12-28'),(4600,'g',0,'2011-12-28'),(4588,'g',0,'2011-12-28'),(4603,'g',0,'2011-12-28'),(4808,'g',0,'2011-12-28'),(4197,'g',0,'2011-12-28'),(4159,'g',0,'2011-12-28'),(4201,'g',0,'2011-12-28'),(4177,'g',0,'2011-12-28'),(4154,'g',0,'2011-12-28'),(4183,'g',0,'2011-12-28'),(4200,'g',0,'2011-12-28'),(4540,'g',0,'2011-12-28'),(4551,'g',0,'2011-12-28'),(4421,'g',0,'2011-12-28'),(4660,'g',0,'2011-12-28'),(4643,'g',0,'2011-12-28'),(4648,'g',0,'2011-12-28'),(4641,'g',0,'2011-12-28'),(4658,'g',0,'2011-12-28'),(4633,'g',0,'2011-12-28'),(4627,'g',0,'2011-12-28'),(4674,'g',0,'2011-12-28'),(4530,'g',0,'2011-12-28'),(4534,'g',0,'2011-12-28'),(4605,'g',0,'2011-12-28'),(4617,'g',0,'2011-12-28'),(4610,'g',0,'2011-12-28'),(4541,'g',0,'2011-12-28'),(4535,'g',0,'2011-12-28'),(4606,'g',0,'2011-12-28'),(4529,'g',0,'2011-12-28'),(4166,'g',0,'2011-12-28'),(5019,'g',0,'2011-12-28'),(4199,'g',0,'2011-12-28'),(4593,'g',0,'2011-12-28'),(4204,'g',0,'2011-12-28'),(4486,'g',0,'2011-12-28'),(4564,'g',0,'2011-12-28'),(4476,'g',0,'2011-12-28'),(4550,'g',0,'2011-12-28'),(4651,'g',0,'2011-12-28'),(4805,'g',0,'2011-12-28'),(4659,'g',0,'2011-12-28'),(4512,'g',0,'2011-12-28'),(4717,'g',0,'2011-12-28'),(4664,'g',0,'2011-12-28'),(4713,'g',0,'2011-12-28'),(4638,'g',0,'2011-12-28'),(4662,'g',0,'2011-12-28'),(5049,'g',0,'2012-02-15'),(4650,'g',0,'2011-12-28'),(4672,'g',0,'2011-12-28'),(4430,'g',0,'2011-12-28'),(4693,'g',0,'2011-12-28'),(4661,'g',0,'2011-12-28'),(4678,'g',0,'2011-12-28'),(4557,'g',0,'2011-12-28'),(4595,'g',0,'2011-12-28'),(4810,'g',0,'2011-12-28'),(4684,'g',0,'2011-12-28'),(4640,'g',0,'2011-12-28'),(4806,'g',0,'2011-12-28'),(4249,'g',0,'2011-12-28'),(4191,'g',0,'2011-12-28'),(4477,'g',0,'2011-12-28'),(4245,'g',0,'2011-12-28'),(4471,'g',0,'2011-12-28'),(4235,'g',0,'2011-12-28'),(4583,'g',0,'2011-12-28'),(4546,'g',0,'2011-12-28'),(5017,'g',0,'2011-12-28'),(4062,'g',0,'2011-12-28'),(4072,'g',0,'2011-12-28'),(5015,'g',0,'2011-12-28'),(4067,'g',0,'2011-12-28'),(4438,'g',0,'2011-12-28'),(4195,'g',0,'2011-12-28'),(4442,'g',0,'2011-12-28'),(4482,'g',0,'2011-12-28'),(4470,'g',0,'2011-12-28'),(4473,'g',0,'2011-12-28'),(4460,'g',0,'2011-12-28'),(4467,'g',0,'2011-12-28'),(4566,'g',0,'2011-12-28'),(4491,'g',0,'2011-12-28'),(4554,'g',0,'2011-12-28'),(4265,'g',0,'2011-12-28'),(4253,'g',0,'2011-12-28'),(4174,'g',0,'2011-12-28'),(4231,'g',0,'2011-12-28'),(4247,'g',0,'2011-12-28'),(4825,'g',0,'2011-12-28'),(4663,'g',0,'2011-12-28'),(4818,'g',0,'2011-12-28'),(4679,'g',0,'2011-12-28'),(4821,'g',0,'2011-12-28'),(4819,'g',0,'2011-12-28'),(4667,'g',0,'2011-12-28'),(4823,'g',0,'2011-12-28'),(4817,'g',0,'2011-12-28'),(4630,'g',0,'2011-12-28'),(4632,'g',0,'2011-12-28'),(4681,'g',0,'2011-12-28'),(4134,'g',0,'2011-12-28'),(4443,'g',0,'2011-12-28'),(4141,'g',0,'2011-12-28'),(4408,'g',0,'2011-12-28'),(4128,'g',0,'2011-12-28'),(4135,'g',0,'2011-12-28'),(4385,'g',0,'2011-12-28'),(4136,'g',0,'2011-12-28'),(4384,'g',0,'2011-12-28'),(5050,'g',0,'2012-02-15'),(4396,'g',0,'2011-12-28'),(4444,'g',0,'2011-12-28'),(4346,'g',0,'2011-12-28'),(4354,'g',0,'2011-12-28'),(4360,'g',0,'2011-12-28'),(4132,'g',0,'2011-12-29'),(4139,'g',0,'2011-12-29'),(4425,'g',0,'2011-12-29'),(4112,'g',0,'2011-12-29'),(4140,'g',0,'2011-12-29'),(4151,'g',0,'2011-12-29'),(4514,'g',0,'2011-12-29'),(4563,'g',0,'2011-12-29'),(4559,'g',0,'2011-12-29'),(4561,'g',0,'2011-12-29'),(4415,'g',0,'2011-12-29'),(4226,'g',0,'2011-12-29'),(4339,'g',0,'2011-12-29'),(4210,'g',0,'2011-12-29'),(4212,'g',0,'2011-12-29'),(4320,'g',0,'2011-12-29'),(4368,'g',0,'2011-12-29'),(4416,'g',0,'2011-12-29'),(4703,'g',0,'2011-12-29'),(4292,'g',0,'2011-12-29'),(4277,'g',0,'2011-12-29'),(4586,'g',0,'2011-12-29'),(4619,'g',0,'2011-12-29'),(4655,'g',0,'2011-12-29'),(4592,'g',0,'2011-12-29'),(4711,'g',0,'2011-12-29'),(4775,'g',0,'2011-12-29'),(4797,'g',0,'2011-12-29'),(4646,'g',0,'2011-12-29'),(4469,'g',0,'2011-12-29'),(4585,'g',0,'2011-12-29'),(4468,'g',0,'2011-12-29'),(4820,'g',0,'2011-12-29'),(4822,'g',0,'2011-12-29'),(4816,'g',0,'2011-12-29'),(4673,'g',0,'2011-12-29'),(4698,'g',0,'2011-12-29'),(5021,'g',0,'2012-02-15'),(4723,'g',0,'2011-12-29'),(4669,'g',0,'2011-12-29'),(4729,'g',0,'2011-12-29'),(4743,'g',0,'2011-12-29'),(4742,'g',0,'2011-12-29'),(4737,'g',0,'2011-12-29'),(4734,'g',0,'2011-12-29'),(4731,'g',0,'2011-12-29'),(4726,'g',0,'2011-12-29'),(4712,'g',0,'2011-12-29'),(4782,'g',0,'2011-12-29'),(4508,'g',0,'2011-12-29'),(4570,'g',0,'2011-12-29'),(4572,'g',0,'2011-12-29'),(4485,'g',0,'2011-12-29'),(4562,'g',0,'2011-12-29'),(4783,'g',0,'2011-12-29'),(4053,'g',0,'2011-12-29'),(4103,'g',0,'2011-12-29'),(4087,'g',0,'2011-12-29'),(4066,'g',0,'2011-12-29'),(4065,'g',0,'2011-12-29'),(4095,'g',0,'2011-12-29'),(4049,'g',0,'2011-12-29'),(4048,'g',0,'2011-12-29'),(4033,'g',0,'2011-12-29'),(4051,'g',0,'2011-12-29'),(4604,'g',0,'2011-12-29'),(4338,'g',0,'2011-12-29'),(4319,'g',0,'2011-12-29'),(4560,'g',0,'2011-12-29'),(4779,'g',0,'2011-12-29'),(4636,'g',0,'2011-12-29'),(4635,'g',0,'2011-12-29'),(4580,'g',0,'2011-12-29'),(4704,'g',0,'2011-12-29'),(4337,'g',0,'2011-12-29'),(4336,'g',0,'2011-12-29'),(4370,'g',0,'2011-12-29'),(4400,'g',0,'2011-12-29'),(4401,'g',0,'2011-12-29'),(4422,'g',0,'2011-12-29'),(4335,'g',0,'2011-12-29'),(4454,'g',0,'2011-12-29'),(4456,'g',0,'2011-12-29'),(4409,'g',0,'2011-12-29'),(4671,'g',0,'2011-12-29'),(4631,'g',0,'2011-12-29'),(4824,'g',0,'2011-12-29'),(4298,'g',0,'2011-12-29'),(4751,'g',0,'2011-12-29'),(4748,'g',0,'2011-12-29'),(4397,'g',0,'2011-12-29'),(4285,'g',0,'2011-12-29'),(4753,'g',0,'2011-12-29'),(4366,'g',0,'2011-12-29'),(4391,'g',0,'2011-12-29'),(4503,'g',0,'2011-12-29'),(4749,'g',0,'2011-12-29'),(4746,'g',0,'2011-12-29'),(4747,'g',0,'2011-12-29'),(4333,'g',0,'2011-12-29'),(4329,'g',0,'2011-12-29'),(4745,'g',0,'2011-12-29'),(4744,'g',0,'2011-12-29'),(4296,'g',0,'2011-12-29'),(4750,'g',0,'2011-12-29'),(4376,'g',0,'2011-12-29'),(4752,'g',0,'2011-12-29'),(4375,'g',0,'2011-12-29'),(4596,'g',0,'2011-12-29'),(4449,'g',0,'2011-12-29'),(4450,'g',0,'2011-12-29'),(4377,'g',0,'2011-12-29'),(4594,'g',0,'2011-12-29'),(4689,'g',0,'2011-12-29'),(4325,'g',0,'2011-12-29'),(4621,'g',0,'2011-12-29'),(4455,'g',0,'2011-12-29'),(4680,'g',0,'2011-12-29'),(4690,'g',0,'2011-12-29'),(4555,'g',0,'2011-12-29'),(4901,'g',0,'2011-12-29'),(4849,'g',0,'2011-12-29'),(4894,'g',0,'2011-12-29'),(5085,'g',0,'2012-02-15'),(4437,'g',0,'2011-12-29'),(4440,'g',0,'2011-12-29'),(4445,'g',0,'2011-12-29'),(4545,'g',0,'2011-12-29'),(4108,'g',0,'2011-12-29'),(4060,'g',0,'2011-12-29'),(4522,'g',0,'2011-12-29'),(4109,'g',0,'2011-12-29'),(4196,'g',0,'2012-02-15'),(4113,'g',0,'2011-12-29'),(4505,'g',0,'2011-12-29'),(4439,'g',0,'2011-12-29'),(4504,'g',0,'2011-12-29'),(4507,'g',0,'2011-12-29'),(4069,'g',0,'2011-12-29'),(4078,'g',0,'2011-12-29'),(4102,'g',0,'2011-12-30'),(4501,'g',0,'2011-12-30'),(4597,'g',0,'2011-12-30'),(4063,'g',0,'2011-12-30'),(4479,'g',0,'2011-12-30'),(4506,'g',0,'2011-12-30'),(4483,'g',0,'2011-12-30'),(4315,'g',0,'2011-12-30'),(4500,'g',0,'2011-12-30'),(4295,'g',0,'2011-12-30'),(4299,'g',0,'2011-12-30'),(4342,'g',0,'2011-12-30'),(4480,'g',0,'2011-12-30'),(4291,'g',0,'2011-12-30'),(4307,'g',0,'2011-12-30'),(4517,'g',0,'2011-12-30'),(4452,'g',0,'2011-12-30'),(4527,'g',0,'2011-12-30'),(4516,'g',0,'2011-12-30'),(4515,'g',0,'2011-12-30'),(4310,'g',0,'2011-12-30'),(4357,'g',0,'2012-02-21'),(4378,'g',0,'2011-12-30'),(4695,'g',0,'2011-12-30'),(4390,'g',0,'2011-12-30'),(4804,'g',0,'2011-12-30'),(4326,'g',0,'2011-12-30'),(4759,'g',0,'2011-12-30'),(4537,'g',0,'2011-12-30'),(4347,'g',0,'2011-12-30'),(4542,'g',0,'2011-12-30'),(4523,'g',0,'2011-12-30'),(4330,'g',0,'2011-12-30'),(4262,'g',0,'2011-12-30'),(4282,'g',0,'2011-12-30'),(4238,'g',0,'2011-12-30'),(4281,'g',0,'2011-12-30'),(4264,'g',0,'2011-12-30'),(4259,'g',0,'2011-12-30'),(4424,'g',0,'2011-12-30'),(4145,'g',0,'2011-12-30'),(4520,'g',0,'2011-12-30'),(4532,'g',0,'2011-12-30'),(4509,'g',0,'2011-12-30'),(4478,'g',0,'2011-12-30'),(4105,'g',0,'2011-12-30'),(4519,'g',0,'2011-12-30'),(4344,'g',0,'2011-12-30'),(4518,'g',0,'2011-12-30'),(4343,'g',0,'2011-12-30'),(4511,'g',0,'2011-12-30'),(4434,'g',0,'2011-12-30'),(4904,'g',0,'2011-12-30'),(4279,'g',0,'2011-12-30'),(4340,'g',0,'2011-12-30'),(4374,'g',0,'2011-12-30'),(4064,'g',0,'2011-12-30'),(4395,'g',0,'2011-12-30'),(4410,'g',0,'2011-12-30'),(4311,'g',0,'2011-12-30'),(4068,'g',0,'2011-12-30'),(4284,'g',0,'2011-12-30'),(4873,'g',0,'2011-12-30'),(4251,'g',0,'2011-12-30'),(4314,'g',0,'2011-12-30'),(4906,'g',0,'2011-12-30'),(4380,'g',0,'2011-12-30'),(4261,'g',0,'2011-12-30'),(4393,'g',0,'2011-12-30'),(4254,'g',0,'2011-12-30'),(4266,'g',0,'2011-12-30'),(4351,'g',0,'2011-12-30'),(4345,'g',0,'2011-12-30'),(4848,'g',0,'2011-12-30'),(4278,'g',0,'2011-12-30'),(4891,'g',0,'2011-12-30'),(4096,'g',0,'2011-12-30'),(4223,'g',0,'2011-12-30'),(4290,'g',0,'2011-12-30'),(4388,'g',0,'2011-12-30'),(4365,'g',0,'2011-12-30'),(4276,'g',0,'2011-12-30'),(4283,'g',0,'2011-12-30'),(4263,'g',0,'2011-12-30'),(4769,'g',0,'2011-12-30'),(4767,'g',0,'2011-12-30'),(4789,'g',0,'2011-12-30'),(4766,'g',0,'2011-12-30'),(4771,'g',0,'2011-12-30'),(4785,'g',0,'2011-12-30'),(5069,'g',0,'2012-02-15'),(5055,'g',0,'2012-02-13'),(5074,'g',0,'2012-02-15'),(5075,'g',0,'2012-02-15'),(5045,'g',0,'2012-02-15'),(5046,'g',0,'2012-02-15'),(4214,'g',0,'2011-12-30'),(4148,'g',0,'2011-12-30'),(4228,'g',0,'2011-12-30'),(4230,'g',0,'2011-12-30'),(4205,'g',0,'2011-12-30'),(4157,'g',0,'2011-12-30'),(4150,'g',0,'2011-12-30'),(4156,'g',0,'2011-12-30'),(4417,'g',0,'2011-12-30'),(4371,'g',0,'2011-12-30'),(4788,'g',0,'2011-12-30'),(4699,'g',0,'2011-12-30'),(4687,'g',0,'2011-12-30'),(4768,'g',0,'2011-12-30'),(4765,'g',0,'2011-12-30'),(4793,'g',0,'2011-12-30'),(4790,'g',0,'2011-12-30'),(4796,'g',0,'2011-12-30'),(4812,'g',0,'2011-12-30'),(4701,'g',0,'2011-12-30'),(4688,'g',0,'2011-12-30'),(4772,'g',0,'2011-12-30'),(4686,'g',0,'2011-12-30'),(4850,'g',0,'2011-12-30'),(4715,'g',0,'2011-12-30'),(4794,'g',0,'2011-12-30'),(4795,'g',0,'2011-12-30'),(4791,'g',0,'2011-12-30'),(4702,'g',0,'2011-12-30'),(4813,'g',0,'2011-12-30'),(4724,'g',0,'2011-12-30'),(4728,'g',0,'2011-12-30'),(4807,'g',0,'2011-12-30'),(4815,'g',0,'2011-12-30'),(4786,'g',0,'2011-12-30'),(4169,'g',0,'2011-12-30'),(4361,'g',0,'2011-12-30'),(4328,'g',0,'2011-12-30'),(5057,'g',0,'2012-02-15'),(5065,'g',0,'2011-12-30'),(4369,'g',0,'2011-12-30'),(4203,'g',0,'2011-12-30'),(4463,'g',0,'2011-12-30'),(4675,'g',0,'2011-12-30'),(4138,'g',0,'2011-12-30'),(4568,'g',0,'2011-12-30'),(4198,'g',0,'2011-12-30'),(4558,'g',0,'2011-12-30'),(4613,'g',0,'2011-12-30'),(4571,'g',0,'2011-12-30'),(5061,'g',0,'2012-02-15'),(5068,'g',0,'2012-02-13'),(5029,'g',0,'2012-02-15'),(5041,'g',0,'2012-02-15'),(4777,'g',0,'2011-12-31'),(4362,'g',0,'2011-12-31'),(4302,'g',0,'2011-12-31'),(4762,'g',0,'2011-12-31'),(4059,'g',0,'2011-12-31'),(4211,'g',0,'2011-12-31'),(4040,'g',0,'2011-12-31'),(4778,'g',0,'2011-12-31'),(4359,'g',0,'2011-12-31'),(4300,'g',0,'2011-12-31'),(4163,'g',0,'2011-12-31'),(4220,'g',0,'2011-12-31'),(5007,'g',0,'2011-12-31'),(4269,'g',0,'2011-12-31'),(4137,'g',0,'2011-12-31'),(4757,'g',0,'2011-12-31'),(4239,'g',0,'2011-12-31'),(5058,'g',0,'2012-02-15'),(5042,'g',0,'2012-02-15'),(5054,'g',0,'2012-02-15'),(4237,'g',0,'2011-12-31'),(4289,'g',0,'2011-12-31'),(4608,'g',0,'2011-12-31'),(4498,'g',0,'2011-12-31'),(4725,'g',0,'2011-12-31'),(4720,'g',0,'2011-12-31'),(4286,'g',0,'2011-12-31'),(4274,'g',0,'2011-12-31'),(4581,'g',0,'2011-12-31'),(4160,'g',0,'2011-12-31'),(4271,'g',0,'2011-12-31'),(4117,'g',0,'2011-12-31'),(4536,'g',0,'2011-12-31'),(4890,'g',0,'2011-12-31'),(4802,'g',0,'2011-12-31'),(4755,'g',0,'2011-12-31'),(5013,'g',0,'2012-02-12'),(5076,'g',0,'2012-02-15'),(5066,'g',0,'2011-12-31'),(4194,'g',0,'2012-01-01'),(4222,'g',0,'2012-01-01'),(4255,'g',0,'2012-01-01'),(4618,'g',0,'2012-01-01'),(4739,'g',0,'2012-01-01'),(4719,'g',0,'2012-01-01'),(4324,'g',0,'2012-01-01'),(4773,'g',0,'2012-01-01'),(4676,'g',0,'2012-01-01'),(4162,'g',0,'2012-01-01'),(4190,'g',0,'2012-01-01'),(4126,'g',0,'2012-01-01'),(4097,'g',0,'2012-01-01'),(4270,'g',0,'2012-01-01'),(4303,'g',0,'2012-01-01'),(4774,'g',0,'2012-01-01'),(4900,'g',0,'2012-01-01'),(4761,'g',0,'2012-01-01'),(5043,'g',0,'2012-02-15'),(5047,'g',0,'2012-02-15'),(5062,'g',0,'2012-01-01'),(5067,'g',0,'2012-01-01'),(5071,'g',0,'2012-01-01'),(4243,'g',0,'2012-01-01'),(4721,'g',0,'2012-01-01'),(4780,'g',0,'2012-01-01'),(4573,'g',0,'2012-01-01'),(4727,'g',0,'2012-01-01'),(4321,'g',0,'2012-01-01'),(4521,'g',0,'2012-01-01'),(4569,'g',0,'2012-01-01'),(4273,'g',0,'2012-01-01'),(4130,'g',0,'2012-01-01'),(4612,'g',0,'2012-01-01'),(4327,'g',0,'2012-01-01'),(4304,'g',0,'2012-01-01'),(4178,'g',0,'2012-01-01'),(4852,'g',0,'2012-01-01'),(4042,'g',0,'2012-01-01'),(4609,'g',0,'2012-01-01'),(4073,'g',0,'2012-01-01'),(4267,'g',0,'2012-01-01'),(4297,'g',0,'2012-01-01'),(4268,'g',0,'2012-01-01'),(4533,'g',0,'2012-01-01'),(5082,'g',0,'2012-02-15'),(4083,'g',0,'2012-01-01'),(4224,'g',0,'2012-01-01'),(4219,'g',0,'2012-01-01'),(4513,'g',0,'2012-01-01'),(4776,'g',0,'2012-01-01'),(4287,'g',0,'2012-01-01'),(4080,'g',0,'2012-01-01'),(4787,'g',0,'2012-01-01'),(4423,'g',0,'2012-01-01'),(5078,'g',0,'2012-02-12'),(4236,'g',0,'2012-01-01'),(4218,'g',0,'2012-01-02'),(4741,'g',0,'2012-01-02'),(4722,'g',0,'2012-01-02'),(4334,'g',0,'2012-01-02'),(4781,'g',0,'2012-01-02'),(4756,'g',0,'2012-01-02'),(4763,'g',0,'2012-01-02'),(4754,'g',0,'2012-01-02'),(5088,'g',0,'2012-02-16'),(4997,'g',0,'2012-02-15'),(5060,'g',0,'2012-02-13'),(4988,'g',0,'2012-02-15'),(5086,'g',0,'2012-02-15'),(5022,'g',0,'2012-01-02'),(4487,'g',0,'2012-01-02'),(4426,'g',0,'2012-01-02'),(4738,'g',0,'2012-01-02'),(4323,'g',0,'2012-01-02'),(5087,'g',0,'2012-02-15'),(5063,'g',0,'2012-02-13'),(4252,'g',0,'2012-01-02'),(4142,'g',0,'2012-01-02'),(4202,'g',0,'2012-01-02'),(5008,'g',0,'2012-01-02'),(4637,'g',0,'2012-01-02'),(4764,'g',0,'2012-01-02'),(4809,'g',0,'2012-01-02'),(5084,'g',0,'2012-01-02'),(5044,'g',0,'2012-02-13'),(5079,'g',0,'2012-02-15'),(5028,'g',0,'2012-02-15'),(5083,'g',0,'2012-02-15'),(4057,'g',0,'2012-01-02'),(4740,'g',0,'2012-01-02'),(4301,'g',0,'2012-01-02'),(4623,'g',0,'2012-01-02'),(4758,'g',0,'2012-01-02'),(5115,'g',0,'2012-03-03'),(5089,'g',0,'2012-02-15'),(4038,'g',0,'2012-01-02'),(4598,'g',0,'2012-01-02'),(4367,'g',0,'2012-01-02'),(4331,'g',0,'2012-01-02'),(5064,'g',0,'2012-02-15'),(5077,'g',0,'2012-02-13'),(5112,'g',0,'2012-02-15'),(5103,'g',0,'2012-02-15'),(5117,'g',0,'2012-02-12'),(5107,'g',0,'2012-02-13'),(5073,'g',0,'2012-02-15'),(5104,'g',0,'2012-02-15'),(5072,'g',0,'2012-02-15'),(4041,'g',0,'2012-01-03'),(4691,'g',0,'2012-01-03'),(4685,'g',0,'2012-01-03'),(4736,'g',0,'2012-01-03'),(4405,'g',0,'2012-01-03'),(4207,'g',0,'2012-01-03'),(4611,'g',0,'2012-01-03'),(4306,'g',0,'2012-01-03'),(4694,'g',0,'2012-01-03'),(4814,'g',0,'2012-01-03'),(4656,'g',0,'2012-01-03'),(4716,'g',0,'2012-01-03'),(4642,'g',0,'2012-01-03'),(4682,'g',0,'2012-01-03'),(4543,'g',0,'2012-01-03'),(4260,'g',0,'2012-01-03'),(4364,'g',0,'2012-01-03'),(4077,'g',0,'2012-01-03'),(4803,'g',0,'2012-01-03'),(4800,'g',0,'2012-01-03'),(4539,'g',0,'2012-01-03'),(4683,'g',0,'2012-01-03'),(4760,'g',0,'2012-01-03'),(4851,'g',0,'2012-01-03'),(5051,'g',0,'2012-02-15'),(4272,'g',0,'2012-01-03'),(4905,'g',0,'2012-01-03'),(5105,'g',0,'2012-02-15'),(5124,'g',0,'2012-02-15'),(5109,'g',0,'2012-01-04'),(5094,'g',0,'2012-01-04'),(5097,'g',0,'2012-01-04'),(5106,'g',0,'2012-01-04'),(5126,'g',0,'2012-01-04'),(5121,'g',0,'2012-01-04'),(5120,'g',0,'2012-01-04'),(5080,'g',0,'2012-02-15'),(5099,'g',0,'2012-02-13'),(5081,'g',0,'2012-02-12'),(5119,'g',0,'2012-02-15'),(5090,'g',0,'2012-01-05'),(5113,'g',0,'2012-02-15'),(5134,'g',0,'2012-02-16'),(5130,'g',0,'2012-01-07'),(5127,'g',0,'2012-01-07'),(5096,'g',0,'2012-01-08'),(5118,'g',0,'2012-01-08'),(5111,'g',0,'2012-01-08'),(5102,'g',0,'2012-01-08'),(5125,'g',0,'2012-01-08'),(5092,'g',0,'2012-02-12'),(5129,'g',0,'2012-02-15'),(5128,'g',0,'2012-02-15'),(5098,'g',0,'2012-02-13'),(5091,'g',0,'2012-02-16'),(5137,'g',0,'2012-01-08'),(5142,'g',0,'2012-01-08'),(5101,'g',0,'2012-01-08'),(5122,'g',0,'2012-01-08'),(5139,'g',0,'2012-01-08'),(5110,'g',0,'2012-02-15'),(5151,'g',0,'2012-01-09'),(5095,'g',0,'2012-02-13'),(5100,'g',0,'2012-02-12'),(5108,'g',0,'2012-02-15'),(5185,'g',0,'2012-01-09'),(5179,'g',0,'2012-01-09'),(5168,'g',0,'2012-01-09'),(5116,'g',0,'2012-02-15'),(5161,'g',0,'2012-01-11'),(5123,'g',0,'2012-02-13'),(5150,'g',0,'2012-01-11'),(5163,'g',0,'2012-01-11'),(5149,'g',0,'2012-01-11'),(5135,'g',0,'2012-01-12'),(5093,'g',0,'2012-02-15'),(5198,'g',0,'2012-01-12'),(5160,'g',0,'2012-01-12'),(5146,'g',0,'2012-01-13'),(5175,'g',0,'2012-01-13'),(5211,'g',0,'2012-01-13'),(5172,'g',0,'2012-01-13'),(5203,'g',0,'2012-01-13'),(5162,'g',0,'2012-01-13'),(5136,'g',0,'2012-02-15'),(5173,'g',0,'2012-01-13'),(5145,'g',0,'2012-01-14'),(5131,'g',0,'2012-01-14'),(5225,'g',0,'2012-01-14'),(5207,'g',0,'2012-01-14'),(5147,'g',0,'2012-01-14'),(5205,'g',0,'2012-02-16'),(5193,'g',0,'2012-01-15'),(5202,'g',0,'2012-01-15'),(5209,'g',0,'2012-01-15'),(5219,'g',0,'2012-01-15'),(5171,'g',0,'2012-01-15'),(5132,'g',0,'2012-01-16'),(5176,'g',0,'2012-01-16'),(5199,'g',0,'2012-01-16'),(5194,'g',0,'2012-01-16'),(5133,'g',0,'2012-01-16'),(5141,'g',0,'2012-01-16'),(5187,'g',0,'2012-01-16'),(5243,'g',0,'2012-01-16'),(5273,'g',0,'2012-01-16'),(5261,'g',0,'2012-01-16'),(5260,'g',0,'2012-01-16'),(5254,'g',0,'2012-01-16'),(5272,'g',0,'2012-01-16'),(5270,'g',0,'2012-01-16'),(5247,'g',0,'2012-01-16'),(5153,'g',0,'2012-01-16'),(5177,'g',0,'2012-01-16'),(5144,'g',0,'2012-01-16'),(5157,'g',0,'2012-01-17'),(5164,'g',0,'2012-01-17'),(5166,'g',0,'2012-01-17'),(5167,'g',0,'2012-01-17'),(5181,'g',0,'2012-01-17'),(5156,'g',0,'2012-01-17'),(5155,'g',0,'2012-01-17'),(5249,'g',0,'2012-01-17'),(5259,'g',0,'2012-01-17'),(5246,'g',0,'2012-01-17'),(5277,'g',0,'2012-01-17'),(5257,'g',0,'2012-01-17'),(5241,'g',0,'2012-01-17'),(5159,'g',0,'2012-01-19'),(5174,'g',0,'2012-01-19'),(5169,'g',0,'2012-01-19'),(5140,'g',0,'2012-01-19'),(5138,'g',0,'2012-01-19'),(5186,'g',0,'2012-01-19'),(5196,'g',0,'2012-01-19'),(5200,'g',0,'2012-01-19'),(5183,'g',0,'2012-01-19'),(5170,'g',0,'2012-01-19'),(5165,'g',0,'2012-01-19'),(5217,'g',0,'2012-03-03'),(5184,'g',0,'2012-01-19'),(5197,'g',0,'2012-01-19'),(5178,'g',0,'2012-01-19'),(5201,'g',0,'2012-01-19'),(5210,'g',0,'2012-01-19'),(5154,'g',0,'2012-01-19'),(5279,'g',0,'2012-01-20'),(5191,'g',0,'2012-01-20'),(5269,'g',0,'2012-01-20'),(5274,'g',0,'2012-01-20'),(5182,'g',0,'2012-01-20'),(5158,'g',0,'2012-01-20'),(5216,'g',0,'2012-01-20'),(5188,'g',0,'2012-01-20'),(5280,'g',0,'2012-01-20'),(5214,'g',0,'2012-01-20'),(5212,'g',0,'2012-01-20'),(5213,'g',0,'2012-01-20'),(5227,'g',0,'2012-01-20'),(5226,'g',0,'2012-01-20'),(5215,'g',0,'2012-01-20'),(5255,'g',0,'2012-01-20'),(5223,'g',0,'2012-01-20'),(5300,'g',0,'2012-01-20'),(5180,'g',0,'2012-01-21'),(5114,'g',0,'2012-01-21'),(5289,'g',0,'2012-01-21'),(5286,'g',0,'2012-01-21'),(5288,'g',0,'2012-01-21'),(5291,'g',0,'2012-01-21'),(5290,'g',0,'2012-01-21'),(5285,'g',0,'2012-01-21'),(5293,'g',0,'2012-01-21'),(5287,'g',0,'2012-01-21'),(5292,'g',0,'2012-01-21'),(5224,'g',0,'2012-01-21'),(5250,'g',0,'2012-01-21'),(5253,'g',0,'2012-01-21'),(5263,'g',0,'2012-01-21'),(5265,'g',0,'2012-01-21'),(5252,'g',0,'2012-01-21'),(5218,'g',0,'2012-01-21'),(5266,'g',0,'2012-01-21'),(5236,'g',0,'2012-01-21'),(5258,'g',0,'2012-01-21'),(5267,'g',0,'2012-01-22'),(5271,'g',0,'2012-01-22'),(5248,'g',0,'2012-01-22'),(5268,'g',0,'2012-01-22'),(5237,'g',0,'2012-01-22'),(5192,'g',0,'2012-01-22'),(5206,'g',0,'2012-01-22'),(5264,'g',0,'2012-01-22'),(5221,'g',0,'2012-01-22'),(5276,'g',0,'2012-01-22'),(5238,'g',0,'2012-01-22'),(5284,'g',0,'2012-01-22'),(5245,'g',0,'2012-02-21'),(5244,'g',0,'2012-01-23'),(5256,'g',0,'2012-01-23'),(5262,'g',0,'2012-01-23'),(5299,'g',0,'2012-01-23'),(5275,'g',0,'2012-01-24'),(5302,'g',0,'2012-01-24'),(5307,'g',0,'2012-01-24'),(5310,'g',0,'2012-01-24'),(5301,'g',0,'2012-01-24'),(5304,'g',0,'2012-01-25'),(5316,'g',0,'2012-01-25'),(5306,'g',0,'2012-01-25'),(5222,'g',0,'2012-03-04'),(5323,'g',0,'2012-01-25'),(5251,'g',0,'2012-01-25'),(5324,'g',0,'2012-01-26'),(5309,'g',0,'2012-01-26'),(5326,'g',0,'2012-01-26'),(5325,'g',0,'2012-01-26'),(5314,'g',0,'2012-01-26'),(5320,'g',0,'2012-01-27'),(5319,'g',0,'2012-01-27'),(5318,'g',0,'2012-01-27'),(5311,'g',0,'2012-01-27'),(5327,'g',0,'2012-01-27'),(5317,'g',0,'2012-01-27'),(5346,'g',0,'2012-01-27'),(5345,'g',0,'2012-01-27'),(5347,'g',0,'2012-01-27'),(5328,'g',0,'2012-01-27'),(5321,'g',0,'2012-01-28'),(5330,'g',0,'2012-01-29'),(5332,'g',0,'2012-01-29'),(5240,'g',0,'2012-01-29'),(5322,'g',0,'2012-01-29'),(5312,'g',0,'2012-01-29'),(5340,'g',0,'2012-01-29'),(5334,'g',0,'2012-01-29'),(5341,'g',0,'2012-01-29'),(5343,'g',0,'2012-01-29'),(5235,'g',0,'2012-01-29'),(5333,'g',0,'2012-01-29'),(5308,'g',0,'2012-01-29'),(5305,'g',0,'2012-01-29'),(5303,'g',0,'2012-01-30'),(5313,'g',0,'2012-01-30'),(5375,'g',0,'2012-01-31'),(5329,'g',0,'2012-02-01'),(5381,'g',0,'2012-02-01'),(5387,'g',0,'2012-02-01'),(5389,'g',0,'2012-02-01'),(5351,'g',0,'2012-02-01'),(5350,'g',0,'2012-02-01'),(5353,'g',0,'2012-02-01'),(5395,'g',0,'2012-02-01'),(5384,'g',0,'2012-02-01'),(5379,'g',0,'2012-02-01'),(5380,'g',0,'2012-02-01'),(5396,'g',0,'2012-02-01'),(5371,'g',0,'2012-02-01'),(5383,'g',0,'2012-02-01'),(5372,'g',0,'2012-02-01'),(5364,'g',0,'2012-02-01'),(5366,'g',0,'2012-02-01'),(5391,'g',0,'2012-02-01'),(5377,'g',0,'2012-02-01'),(5361,'g',0,'2012-02-01'),(5369,'g',0,'2012-02-03'),(5410,'g',0,'2012-02-03'),(5355,'g',0,'2012-02-03'),(5392,'g',0,'2012-02-04'),(5390,'g',0,'2012-02-04'),(5373,'g',0,'2012-02-04'),(5374,'g',0,'2012-02-04'),(5397,'g',0,'2012-02-04'),(5419,'g',0,'2012-02-04'),(5414,'g',0,'2012-02-04'),(5415,'g',0,'2012-02-04'),(5417,'g',0,'2012-02-04'),(5413,'g',0,'2012-02-04'),(5418,'g',0,'2012-02-05'),(5412,'g',0,'2012-02-05'),(5411,'g',0,'2012-02-05'),(5416,'g',0,'2012-02-05'),(5365,'g',0,'2012-02-05'),(5394,'g',0,'2012-02-05'),(5356,'g',0,'2012-02-05'),(5407,'g',0,'2012-02-06'),(5404,'g',0,'2012-02-06'),(5370,'g',0,'2012-02-06'),(5367,'g',0,'2012-02-06'),(5393,'g',0,'2012-02-06'),(5480,'g',0,'2012-02-06'),(5354,'g',0,'2012-02-07'),(5401,'g',0,'2012-02-07'),(5378,'g',0,'2012-02-07'),(5357,'g',0,'2012-02-07'),(5477,'g',0,'2012-02-07'),(5368,'g',0,'2012-02-07'),(5363,'g',0,'2012-02-07'),(5478,'g',0,'2012-02-08'),(5439,'g',0,'2012-02-08'),(5409,'g',0,'2012-02-08'),(5352,'g',0,'2012-02-09'),(5435,'g',0,'2012-02-09'),(5440,'g',0,'2012-02-09'),(5437,'g',0,'2012-02-10'),(5483,'g',0,'2012-02-10'),(5451,'g',0,'2012-02-10'),(5482,'g',0,'2012-02-10'),(5485,'g',0,'2012-02-10'),(5475,'g',0,'2012-02-11'),(5484,'g',0,'2012-02-11'),(5403,'g',0,'2012-02-12'),(5002,'g',0,'2012-02-15'),(5003,'g',0,'2012-02-15'),(4994,'g',0,'2012-02-15'),(5488,'g',0,'2012-02-16'),(5507,'g',0,'2012-02-17'),(5499,'g',0,'2012-02-19'),(5487,'g',0,'2012-02-22'),(5486,'g',0,'2012-02-22'),(5497,'g',0,'2012-02-24'),(4316,'g',0,'2012-02-24'),(4538,'g',0,'2012-02-24'),(4257,'g',0,'2012-02-24'),(4187,'g',0,'2012-02-24'),(4213,'g',0,'2012-02-24'),(4275,'g',0,'2012-02-24'),(4206,'g',0,'2012-02-24'),(4185,'g',0,'2012-02-24'),(4182,'g',0,'2012-02-24'),(4188,'g',0,'2012-02-24'),(4104,'g',0,'2012-02-24'),(4090,'g',0,'2012-02-24'),(5495,'g',0,'2012-02-24'),(4071,'g',0,'2012-02-24'),(5510,'g',0,'2012-02-24'),(4093,'g',0,'2012-02-24'),(4175,'g',0,'2012-02-24'),(4164,'g',0,'2012-02-24'),(4181,'g',0,'2012-02-24'),(4120,'g',0,'2012-02-24'),(4180,'g',0,'2012-02-24'),(4114,'g',0,'2012-02-24'),(5508,'g',0,'2012-02-24'),(4171,'g',0,'2012-02-24'),(4176,'g',0,'2012-02-24'),(4173,'g',0,'2012-02-24'),(4696,'g',0,'2012-02-24'),(4700,'g',0,'2012-02-24'),(4670,'g',0,'2012-02-24'),(4665,'g',0,'2012-02-24'),(4616,'g',0,'2012-02-24'),(4899,'g',0,'2012-02-24'),(5505,'g',0,'2012-02-24'),(4902,'g',0,'2012-02-24'),(4895,'g',0,'2012-02-24'),(4733,'g',0,'2012-02-24'),(5513,'g',0,'2012-02-24'),(4709,'g',0,'2012-02-25'),(5516,'g',0,'2012-02-25'),(4647,'g',0,'2012-02-25'),(4666,'g',0,'2012-02-25'),(4714,'g',0,'2012-02-25'),(4897,'g',0,'2012-02-25'),(4628,'g',0,'2012-02-25'),(4801,'g',0,'2012-02-26'),(4798,'g',0,'2012-02-26'),(4732,'g',0,'2012-02-26'),(4896,'g',0,'2012-02-26'),(4620,'g',0,'2012-02-26'),(4730,'g',0,'2012-02-26'),(4770,'g',0,'2012-02-26'),(4644,'g',0,'2012-02-26'),(5524,'g',0,'2012-02-26'),(4792,'g',0,'2012-02-26'),(4629,'g',0,'2012-02-26'),(4811,'g',0,'2012-02-26'),(4847,'g',0,'2012-02-26'),(4708,'g',0,'2012-02-26'),(5520,'g',0,'2012-02-27'),(5517,'g',0,'2012-02-27'),(5547,'g',0,'2012-02-29'),(5561,'g',0,'2012-03-03'),(5539,'g',0,'2012-03-03'),(5540,'g',0,'2012-03-03'),(5529,'g',0,'2012-03-03'),(5528,'g',0,'2012-03-03'),(5511,'g',0,'2012-03-04'),(5562,'g',0,'2012-03-05'),(5587,'g',0,'2012-03-07');

--
-- Table structure for table `idx_paid_listing`
--

CREATE TABLE `idx_paid_listing` (
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `premium` char(1) DEFAULT NULL,
  `sponsored` char(1) DEFAULT NULL,
  `expire` datetime DEFAULT NULL,
  `paid` char(1) DEFAULT NULL,
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_paid_listing`
--


--
-- Table structure for table `idx_payment_gateway`
--

CREATE TABLE `idx_payment_gateway` (
  `payment_gateway_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `enable` char(1) DEFAULT NULL,
  `setting` text,
  `invoice_html` text,
  PRIMARY KEY (`payment_gateway_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_gateway`
--

INSERT INTO `idx_payment_gateway` VALUES (1,'paypal','1','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n	<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.paypal.com/images/x-click-but02.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>\r\n'),(2,'2co','0','a:6:{s:6:\"co_sid\";s:5:\"84932\";s:9:\"co_secret\";s:5:\"tango\";s:12:\"co_recurring\";s:1:\"0\";s:9:\"co_prod_1\";s:6:\"100.00\";s:9:\"co_prod_2\";s:6:\"250.00\";s:9:\"co_prod_3\";s:6:\"400.00\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=2co\'><img src=\'http://www.2checkout.com/images/overview/btns/25.jpg\' alt=\'Pay Now with 2checkout...\' border=\'0\' /></a> \r\n</p>'),(3,'authorizenet','0','a:2:{s:21:\"authorizenet_login_id\";s:0:\"\";s:21:\"authorizenet_tran_key\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=authorizenet\'><img src=\'http://www.authorize.net/upload/images/Images/Header/authorizenet_logo.gif\' alt=\'Pay Now with Authorize.Net...\' width=\'99\' height=\'39\' style=\'{border : 1px solid #c0c0c0;}\' /></a>\r\n</p>'),(4,'egold','0','a:2:{s:19:\"egold_payee_account\";s:0:\"\";s:16:\"egold_payee_name\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=egold\'>\r\n<img src=\'http://www.e-gold.com/gif/paywith.gif\' border=\'0\' alt=\'Pay Now with e-gold...\' />\r\n</a>\r\n</p>'),(5,'moneybookers','0','a:1:{s:18:\"moneybookers_email\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.moneybookers.com/images/banners/88_en_mb.gif\' border=\'0\' alt=\'Make payments with Moneybookers - it is fast, free and secure!\' /></a> \r\n</p>'),(6,'paypal-subscriptions','0','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'https://www.paypal.com/en_US/i/btn/x-click-but20.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(7,'alertpay','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/pay_now_3.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(8,'alertpay-subcriptions','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay-subcriptions\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/subscribe_now_15.gif\' border=\'0\' alt=\'Make payments with Alert Pay - it is fast, free and secure!\' /></a> \r\n</p>');

--
-- Table structure for table `idx_payment_history`
--

CREATE TABLE `idx_payment_history` (
  `payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contact_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `detail` text,
  `amount` double DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `invoice_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_history`
--


--
-- Table structure for table `idx_plugin`
--

CREATE TABLE `idx_plugin` (
  `plugin_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `plugin_file` varchar(255) DEFAULT NULL,
  `status` enum('0','1') DEFAULT NULL,
  `option_plugin` text,
  PRIMARY KEY (`plugin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_plugin`
--


--
-- Table structure for table `idx_review`
--

CREATE TABLE `idx_review` (
  `review_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `review` text NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `subject` varchar(100) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_review`
--


--
-- Table structure for table `idx_searchlog`
--

CREATE TABLE `idx_searchlog` (
  `keyword` varchar(100) NOT NULL DEFAULT '',
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `result` mediumint(9) unsigned DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_searchlog`
--

INSERT INTO `idx_searchlog` VALUES ('Ebrandz Review','2012-01-03 02:17:05',3,'203.92.47.195');

--
-- Table structure for table `idx_set_hook_place`
--

CREATE TABLE `idx_set_hook_place` (
  `set_hook_place_id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin` varchar(255) DEFAULT NULL,
  `set_hook_place` text,
  PRIMARY KEY (`set_hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_set_hook_place`
--


--
-- Table structure for table `idx_setting`
--

CREATE TABLE `idx_setting` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_name` varchar(255) DEFAULT NULL,
  `setting_value` text,
  PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_setting`
--

INSERT INTO `idx_setting` VALUES (4,'site_name','zoogal.org'),(5,'site_url','http://zoogal.org'),(6,'email_address','dianna.blehm@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/zoogal/public_html/themes/'),(9,'admin_template_path','/home/zoogal/public_html/admin_tpl/'),(10,'plugin_path','/home/zoogal/public_html/plugin/'),(12,'active_theme','_zoogal'),(14,'spam_proof','1'),(15,'enable_user_validation','1'),(16,'allowed_file_extension','gif,jpg,png,pdf,zip,doc'),(17,'yahoo_appid',''),(18,'whosonline','600'),(19,'reciprocal_check','0'),(20,'urlcheck_limit','1'),(21,'pagerank_cache','30'),(22,'max_image_width','1024'),(23,'max_image_height','756'),(24,'max_file_size','500'),(25,'only_registered_can_add_link','0'),(26,'only_registered_can_add_review','0'),(27,'db_use_persistent','0'),(28,'paid_link_day_period','30,60,90,180'),(29,'paid_link_price_factor','1,1.5,2,3'),(30,'enable_html_tag','1'),(31,'allowed_html_tag','<b>,<strong>,<i>,<em>,<u>,<pre>,<blockquote>,<ol>,<ul>,<li>,<p>,<span>,<div>,<table>,<tr>,<td>'),(32,'enable_page_compression','0'),(33,'enable_category_ajax','1'),(34,'require_visit_category','0'),(35,'additional_category_price','0.5'),(36,'enable_rating_ajax','1'),(37,'service_nicecoder_avail','1'),(38,'enable_recaptcha','0'),(39,'recaptcha_publickey',''),(40,'recaptcha_privatekey',''),(41,'enable_bidding','0'),(42,'minimum_bid','5'),(43,'bid_increament','1'),(44,'charset','utf-8'),(45,'mailer','mail'),(46,'smtp_auth','0'),(47,'smtp_host',''),(48,'smtp_username',''),(49,'smtp_password',''),(50,'smtp_port','25'),(51,'emailbody_as_html','0'),(52,'indexu_version','2.4'),(53,'tos',''),(54,'submission_guidelines','');

--
-- Table structure for table `idx_tags`
--

CREATE TABLE `idx_tags` (
  `tag` varchar(64) NOT NULL DEFAULT '',
  `category_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `total` int(11) NOT NULL DEFAULT '0',
  `tag_path` varchar(64) NOT NULL,
  PRIMARY KEY (`tag`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_tags`
--


--
-- Table structure for table `idx_unavailable`
--

CREATE TABLE `idx_unavailable` (
  `idx_unavailable` int(11) NOT NULL AUTO_INCREMENT,
  `link_id` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `who_is` varchar(255) DEFAULT NULL,
  `note` text,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`idx_unavailable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_unavailable`
--


--
-- Table structure for table `idx_unavailable_latest`
--

CREATE TABLE `idx_unavailable_latest` (
  `idx_link` int(11) DEFAULT NULL,
  `record_execution` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_unavailable_latest`
--


--
-- Table structure for table `idx_votes`
--

CREATE TABLE `idx_votes` (
  `link_id` mediumint(9) NOT NULL DEFAULT '0',
  `ip` varchar(100) DEFAULT NULL,
  `value` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_votes`
--

INSERT INTO `idx_votes` VALUES (4402,'203.92.47.195',4);


