--
-- Host: bizprimary.com    Database: bizprima_primary
-- ------------------------------------------------------


--
-- Not dumping tablespaces as no INFORMATION_SCHEMA.FILES table on this server
--

--
-- 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 Gallery & Entertainment','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Automobiles','','folder.gif','','1',36,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Business & Investment','','folder.gif','','1',134,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Careers & Recruitment','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Clothing & Designers','','folder.gif','','1',9,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Communication ','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computers','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Construction and Remodeling','','folder.gif','','1',78,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental Directories','','folder.gif','','1',20,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Education & Colleges','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Employment & Staffing','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Gifts & Stationery','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software Systems','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Health Resources','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Services & Products','','folder.gif','','1',164,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Air Conditioning, Heating & Ventilating','','folder.gif','','1',46,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Family ,Home & Garden','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement & Interiors','','folder.gif','','1',274,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Restaurants','','folder.gif','','1',34,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Agents and Companies','','folder.gif','','1',27,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Legal Consultants','','folder.gif','','1',153,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & People','','folder.gif','','1',5,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine & Medical Services','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Finance','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News & Journals','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing & Fitting ','','folder.gif','','1',36,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate & Agents ','','folder.gif','','1',26,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Science & Technology','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'SEO & SMO','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Shopping','','folder.gif','','1',63,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Sports & Games','','folder.gif','','1',3,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Transportation and Logistics','','folder.gif','','1',37,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Travel','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Wedding','','folder.gif','','1',10,'','','0','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 Gallery & Entertainment','<a href=\"http://bizprimary.com/arts-gallery-entertainment/\" name=\"cat_1\" style=\"\">Arts Gallery & Entertainment</a>',';0;'),(2,'Automobiles','<a href=\"http://bizprimary.com/automobiles/\" name=\"cat_2\" style=\"\">Automobiles</a>',';0;'),(3,'Business & Investment','<a href=\"http://bizprimary.com/business-investment/\" name=\"cat_3\" style=\"\">Business & Investment</a>',';0;'),(4,'Careers & Recruitment','<a href=\"http://bizprimary.com/careers-recruitment/\" name=\"cat_4\" style=\"\">Careers & Recruitment</a>',';0;'),(5,'Clothing & Designers','<a href=\"http://bizprimary.com/clothing-designers/\" name=\"cat_5\" style=\"\">Clothing & Designers</a>',';0;'),(6,'Communication ','<a href=\"http://bizprimary.com/communication/\" name=\"cat_6\" style=\"\">Communication </a>',';0;'),(7,'Computers','<a href=\"http://bizprimary.com/computers/\" name=\"cat_7\" style=\"\">Computers</a>',';0;'),(8,'Construction and Remodeling','<a href=\"http://bizprimary.com/construction-and-remodeling/\" name=\"cat_8\" style=\"\">Construction and Remodeling</a>',';0;'),(9,'Dental Directories','<a href=\"http://bizprimary.com/dental-directories/\" name=\"cat_9\" style=\"\">Dental Directories</a>',';0;'),(10,'Education & Colleges','<a href=\"http://bizprimary.com/education-colleges/\" name=\"cat_10\" style=\"\">Education & Colleges</a>',';0;'),(11,'Employment & Staffing','<a href=\"http://bizprimary.com/employment-staffing/\" name=\"cat_11\" style=\"\">Employment & Staffing</a>',';0;'),(12,'Gifts & Stationery','<a href=\"http://bizprimary.com/gifts-stationery/\" name=\"cat_12\" style=\"\">Gifts & Stationery</a>',';0;'),(13,'Hardware & Software Systems','<a href=\"http://bizprimary.com/hardware-software-systems/\" name=\"cat_13\" style=\"\">Hardware & Software Systems</a>',';0;'),(14,'Health Resources','<a href=\"http://bizprimary.com/health-resources/\" name=\"cat_14\" style=\"\">Health Resources</a>',';0;'),(15,'Healthcare Services & Products','<a href=\"http://bizprimary.com/healthcare-services-products/\" name=\"cat_15\" style=\"\">Healthcare Services & Products</a>',';0;'),(16,'Air Conditioning, Heating & Ventilating','<a href=\"http://bizprimary.com/air-conditioning-heating-ventilating/\" name=\"cat_16\" style=\"\">Air Conditioning, Heating & Ventilating</a>',';0;'),(17,'Family ,Home & Garden','<a href=\"http://bizprimary.com/family-home-garden/\" name=\"cat_17\" style=\"\">Family ,Home & Garden</a>',';0;'),(18,'Home Improvement & Interiors','<a href=\"http://bizprimary.com/home-improvement-interiors/\" name=\"cat_18\" style=\"\">Home Improvement & Interiors</a>',';0;'),(19,'Hotels & Restaurants','<a href=\"http://bizprimary.com/hotels-restaurants/\" name=\"cat_19\" style=\"\">Hotels & Restaurants</a>',';0;'),(20,'Insurance Agents and Companies','<a href=\"http://bizprimary.com/insurance-agents-and-companies/\" name=\"cat_20\" style=\"\">Insurance Agents and Companies</a>',';0;'),(21,'Law Services','<a href=\"http://bizprimary.com/law-services/\" name=\"cat_21\" style=\"\">Law Services</a>',';0;'),(22,'Lawyers & Legal Consultants','<a href=\"http://bizprimary.com/lawyers-legal-consultants/\" name=\"cat_22\" style=\"\">Lawyers & Legal Consultants</a>',';0;'),(23,'Lifestyle & People','<a href=\"http://bizprimary.com/lifestyle-people/\" name=\"cat_23\" style=\"\">Lifestyle & People</a>',';0;'),(24,'Medicine & Medical Services','<a href=\"http://bizprimary.com/medicine-medical-services/\" name=\"cat_24\" style=\"\">Medicine & Medical Services</a>',';0;'),(25,'Finance','<a href=\"http://bizprimary.com/finance/\" name=\"cat_25\" style=\"\">Finance</a>',';0;'),(26,'News & Journals','<a href=\"http://bizprimary.com/news-journals/\" name=\"cat_26\" style=\"\">News & Journals</a>',';0;'),(27,'Plumbing & Fitting ','<a href=\"http://bizprimary.com/plumbing-fitting/\" name=\"cat_27\" style=\"\">Plumbing & Fitting </a>',';0;'),(28,'Real Estate & Agents ','<a href=\"http://bizprimary.com/real-estate-agents/\" name=\"cat_28\" style=\"\">Real Estate & Agents </a>',';0;'),(29,'Science & Technology','<a href=\"http://bizprimary.com/science-technology/\" name=\"cat_29\" style=\"\">Science & Technology</a>',';0;'),(30,'SEO & SMO','<a href=\"http://bizprimary.com/seo-smo/\" name=\"cat_30\" style=\"\">SEO & SMO</a>',';0;'),(31,'Shopping','<a href=\"http://bizprimary.com/shopping/\" name=\"cat_31\" style=\"\">Shopping</a>',';0;'),(32,'Sports & Games','<a href=\"http://bizprimary.com/sports-games/\" name=\"cat_32\" style=\"\">Sports & Games</a>',';0;'),(33,'Transportation and Logistics','<a href=\"http://bizprimary.com/transportation-and-logistics/\" name=\"cat_33\" style=\"\">Transportation and Logistics</a>',';0;'),(34,'Travel','<a href=\"http://bizprimary.com/travel/\" name=\"cat_34\" style=\"\">Travel</a>',';0;'),(35,'Wedding','<a href=\"http://bizprimary.com/wedding/\" name=\"cat_35\" style=\"\">Wedding</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 AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_category_suggession` VALUES (1,32,'Casino','If you want to have much fun and earn money easily, play online casino games at one of the Top Us online Casino sites.','2011-12-07 06:47:49'),(2,32,'Top us casino','If you want to have much fun and earn money easily, play online casino games at one of the Top Us online Casino sites.','2011-12-07 06:52:16');

--
-- 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=5 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_favorites` VALUES (1,'caryfletcherj57m11','2011-10-18','My Favorites',NULL),(2,'rolanddouglay42c17','2011-10-31','My Favorites',NULL),(3,'darellbarryx36v79','2011-11-01','My Favorites',NULL),(4,'adaptive84','2011-12-07','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 (10,'g',0,'2011-10-12'),(8,'g',0,'2011-08-07'),(9,'g',1,'2011-08-07'),(3,'g',0,'2011-10-14'),(6,'g',3,'2011-08-08'),(5,'g',3,'2011-08-08'),(2,'g',2,'2011-08-08'),(14,'g',2,'2011-08-08'),(13,'g',3,'2011-08-08'),(15,'g',0,'2011-10-14'),(7,'g',1,'2011-08-08'),(4,'g',0,'2011-10-14'),(12,'g',0,'2011-08-08'),(11,'g',0,'2011-10-14'),(17,'g',0,'2011-08-11'),(18,'g',3,'2011-08-12'),(20,'g',3,'2011-08-14'),(19,'g',0,'2011-08-14'),(23,'g',2,'2011-08-15'),(25,'g',3,'2011-08-16'),(24,'g',1,'2011-08-16'),(21,'g',0,'2011-10-14'),(26,'g',3,'2011-08-16'),(27,'g',0,'2011-08-17'),(28,'g',3,'2011-08-17'),(29,'g',0,'2011-08-18'),(35,'g',4,'2011-09-20'),(37,'g',4,'2011-09-20'),(38,'g',1,'2011-09-20'),(30,'g',0,'2011-10-05'),(31,'g',2,'2011-08-19'),(33,'g',2,'2011-08-19'),(32,'g',2,'2011-08-19'),(34,'g',4,'2011-08-21'),(1,'g',4,'2011-08-21'),(22,'g',0,'2011-08-21'),(16,'g',0,'2011-10-14'),(36,'g',0,'2011-10-14'),(45,'g',2,'2011-08-24'),(43,'g',3,'2011-09-29'),(50,'g',2,'2011-10-05'),(48,'g',1,'2011-08-27'),(51,'g',3,'2011-10-02'),(49,'g',2,'2011-08-28'),(54,'g',0,'2011-08-28'),(53,'g',2,'2011-08-28'),(52,'g',0,'2011-08-29'),(55,'g',3,'2011-08-29'),(58,'g',0,'2011-08-29'),(57,'g',3,'2011-08-29'),(56,'g',0,'2011-08-29'),(59,'g',0,'2011-10-02'),(66,'g',0,'2011-09-02'),(67,'g',1,'2011-09-02'),(62,'g',6,'2011-09-02'),(65,'g',0,'2011-09-02'),(68,'g',0,'2011-09-04'),(69,'g',0,'2011-10-05'),(74,'g',0,'2011-09-06'),(70,'g',0,'2011-09-06'),(72,'g',1,'2011-09-08'),(77,'g',0,'2011-09-08'),(75,'g',0,'2011-09-08'),(78,'g',1,'2011-09-09'),(76,'g',0,'2011-09-09'),(82,'g',4,'2011-09-09'),(80,'g',0,'2011-09-09'),(91,'g',6,'2011-09-09'),(79,'g',0,'2011-09-09'),(86,'g',6,'2011-09-10'),(83,'g',4,'2011-09-10'),(87,'g',2,'2011-09-10'),(84,'g',0,'2011-09-10'),(88,'g',2,'2011-09-10'),(85,'g',2,'2011-09-10'),(92,'g',2,'2011-09-11'),(89,'g',0,'2011-09-12'),(90,'g',4,'2011-09-12'),(93,'g',4,'2011-09-12'),(96,'g',0,'2011-09-13'),(95,'g',3,'2011-09-14'),(94,'g',2,'2011-09-14'),(98,'g',0,'2011-09-15'),(97,'g',0,'2011-09-15'),(100,'g',3,'2011-09-16'),(109,'g',4,'2011-09-17'),(110,'g',0,'2011-09-17'),(111,'g',1,'2011-09-18'),(64,'g',2,'2011-09-19'),(46,'g',1,'2011-09-19'),(63,'g',0,'2011-09-19'),(118,'g',0,'2011-11-22'),(47,'g',0,'2011-09-20'),(71,'g',1,'2011-09-20'),(61,'g',0,'2012-03-01'),(44,'g',0,'2011-09-20'),(121,'g',2,'2011-09-20'),(134,'g',0,'2012-02-05'),(73,'g',0,'2011-09-20'),(60,'g',0,'2011-09-20'),(116,'g',2,'2011-09-20'),(103,'g',0,'2011-09-20'),(101,'g',0,'2011-09-20'),(104,'g',2,'2011-09-20'),(105,'g',0,'2011-09-20'),(106,'g',0,'2011-09-20'),(102,'g',2,'2011-09-20'),(130,'g',1,'2011-09-21'),(133,'g',0,'2012-01-26'),(41,'g',0,'2011-09-22'),(125,'g',3,'2011-09-22'),(132,'g',0,'2012-01-26'),(139,'g',0,'2011-11-27'),(138,'g',2,'2011-09-23'),(146,'g',2,'2011-09-24'),(145,'g',0,'2012-01-27'),(137,'g',1,'2011-09-24'),(136,'g',4,'2011-09-25'),(142,'g',0,'2011-09-25'),(149,'g',0,'2012-01-26'),(150,'g',0,'2012-01-26'),(147,'g',0,'2012-03-02'),(127,'g',3,'2011-09-26'),(126,'g',0,'2011-09-26'),(159,'g',2,'2011-09-29'),(164,'g',0,'2011-09-29'),(163,'g',0,'2012-01-14'),(171,'g',0,'2012-02-09'),(158,'g',1,'2011-09-30'),(152,'g',1,'2011-09-30'),(170,'g',0,'2012-03-02'),(155,'g',0,'2011-10-01'),(162,'g',0,'2011-10-01'),(166,'g',0,'2011-10-01'),(165,'g',2,'2011-10-01'),(161,'g',0,'2011-10-01'),(154,'g',0,'2011-10-01'),(157,'g',0,'2011-10-01'),(160,'g',0,'2011-10-02'),(168,'g',0,'2011-10-02'),(153,'g',0,'2011-10-02'),(156,'g',2,'2011-10-02'),(99,'g',3,'2011-10-02'),(81,'g',5,'2011-10-02'),(169,'g',0,'2011-10-02'),(151,'g',3,'2011-10-03'),(148,'g',0,'2011-12-22'),(186,'g',1,'2011-10-05'),(181,'g',0,'2011-10-06'),(167,'g',0,'2011-10-06'),(173,'g',0,'2011-10-06'),(184,'g',0,'2011-10-07'),(192,'g',0,'2011-10-07'),(189,'g',0,'2011-10-07'),(185,'g',0,'2011-10-07'),(196,'g',0,'2011-10-07'),(200,'g',0,'2011-10-07'),(182,'g',0,'2011-10-07'),(195,'g',0,'2011-10-07'),(197,'g',0,'2011-10-07'),(187,'g',0,'2011-10-08'),(199,'g',0,'2011-10-08'),(190,'g',0,'2011-10-12'),(235,'g',0,'2011-12-19'),(236,'g',0,'2011-12-19'),(207,'g',0,'2011-10-15'),(249,'g',0,'2011-10-15'),(243,'g',0,'2012-03-06'),(227,'g',0,'2012-02-12'),(213,'g',0,'2011-12-19'),(239,'g',0,'2011-10-15'),(231,'g',0,'2011-10-15'),(245,'g',0,'2011-10-15'),(214,'g',0,'2012-01-14'),(198,'g',0,'2011-10-16'),(194,'g',0,'2011-10-16'),(206,'g',0,'2011-10-16'),(202,'g',0,'2011-10-16'),(203,'g',0,'2011-10-16'),(205,'g',0,'2011-10-16'),(204,'g',0,'2011-10-16'),(183,'g',0,'2011-10-16'),(193,'g',0,'2011-10-16'),(191,'g',0,'2011-10-16'),(180,'g',0,'2011-10-16'),(217,'g',0,'2012-01-22'),(216,'g',0,'2012-01-19'),(218,'g',0,'2012-02-11'),(219,'g',0,'2012-02-11'),(221,'g',0,'2012-02-11'),(224,'g',0,'2012-02-11'),(225,'g',0,'2012-02-11'),(220,'g',0,'2012-02-11'),(262,'g',0,'2011-10-17'),(212,'g',0,'2012-01-24'),(240,'g',0,'2011-11-21'),(241,'g',0,'2011-11-21'),(215,'g',0,'2011-11-21'),(254,'g',0,'2011-10-21'),(253,'g',0,'2011-10-21'),(248,'g',0,'2011-10-21'),(247,'g',0,'2011-10-21'),(252,'g',0,'2011-10-21'),(223,'g',0,'2011-10-22'),(268,'g',0,'2011-10-22'),(267,'g',0,'2011-10-23'),(211,'g',0,'2011-11-26'),(530,'g',0,'2011-10-24'),(359,'g',0,'2011-11-27'),(395,'g',0,'2011-11-27'),(277,'g',0,'2011-12-01'),(320,'g',0,'2011-12-19'),(449,'g',0,'2011-11-27'),(402,'g',0,'2011-10-25'),(397,'g',0,'2011-10-25'),(401,'g',0,'2011-10-25'),(301,'g',0,'2012-01-26'),(454,'g',0,'2012-01-26'),(313,'g',0,'2012-01-26'),(400,'g',0,'2011-10-25'),(305,'g',0,'2012-01-26'),(463,'g',0,'2012-01-26'),(372,'g',0,'2011-11-27'),(413,'g',0,'2011-11-27'),(346,'g',0,'2011-11-27'),(357,'g',0,'2011-11-27'),(358,'g',0,'2011-11-27'),(288,'g',0,'2011-10-25'),(493,'g',0,'2011-10-25'),(360,'g',0,'2012-01-07'),(237,'g',0,'2011-10-25'),(350,'g',0,'2011-10-25'),(515,'g',0,'2011-10-25'),(332,'g',0,'2012-01-07'),(242,'g',0,'2011-10-25'),(405,'g',0,'2011-11-27'),(278,'g',0,'2011-12-19'),(403,'g',0,'2011-10-25'),(349,'g',0,'2012-01-07'),(371,'g',0,'2011-12-19'),(341,'g',0,'2012-01-07'),(304,'g',0,'2012-02-17'),(299,'g',0,'2012-02-17'),(547,'g',0,'2011-10-26'),(473,'g',0,'2011-10-26'),(443,'g',0,'2011-12-21'),(444,'g',0,'2011-10-26'),(429,'g',0,'2011-12-21'),(433,'g',0,'2011-12-21'),(347,'g',0,'2011-12-13'),(440,'g',0,'2011-10-26'),(425,'g',0,'2011-12-13'),(390,'g',0,'2011-10-26'),(337,'g',0,'2011-12-13'),(461,'g',0,'2011-10-26'),(384,'g',0,'2011-10-26'),(456,'g',0,'2011-10-26'),(437,'g',0,'2011-12-13'),(459,'g',0,'2011-10-26'),(439,'g',0,'2011-12-21'),(430,'g',0,'2011-10-26'),(450,'g',0,'2011-10-26'),(445,'g',0,'2011-10-26'),(446,'g',0,'2011-12-21'),(434,'g',0,'2011-10-27'),(415,'g',0,'2011-12-07'),(421,'g',0,'2011-12-22'),(422,'g',0,'2011-12-22'),(507,'g',0,'2011-10-27'),(457,'g',0,'2011-12-22'),(381,'g',0,'2011-10-27'),(315,'g',0,'2012-01-14'),(298,'g',0,'2011-12-08'),(367,'g',0,'2011-12-08'),(361,'g',0,'2011-12-08'),(366,'g',0,'2011-12-08'),(364,'g',0,'2011-12-08'),(373,'g',0,'2011-12-28'),(311,'g',0,'2012-01-14'),(448,'g',0,'2011-10-28'),(483,'g',0,'2011-10-28'),(460,'g',0,'2012-01-14'),(316,'g',0,'2012-01-14'),(432,'g',0,'2011-10-28'),(362,'g',0,'2011-12-08'),(452,'g',0,'2011-10-28'),(398,'g',0,'2011-10-28'),(295,'g',0,'2011-12-08'),(532,'g',0,'2011-12-07'),(458,'g',0,'2011-10-28'),(348,'g',0,'2011-10-28'),(290,'g',0,'2011-11-28'),(230,'g',0,'2011-11-28'),(345,'g',0,'2011-10-28'),(573,'g',0,'2011-10-28'),(338,'g',0,'2012-01-10'),(572,'g',0,'2011-10-28'),(328,'g',0,'2012-01-10'),(300,'g',0,'2011-11-28'),(302,'g',0,'2012-03-01'),(344,'g',0,'2012-01-10'),(321,'g',0,'2012-01-10'),(297,'g',0,'2011-10-28'),(283,'g',0,'2012-02-19'),(411,'g',0,'2011-10-28'),(303,'g',0,'2011-12-08'),(399,'g',0,'2011-12-08'),(527,'g',0,'2011-11-28'),(438,'g',0,'2011-10-28'),(575,'g',0,'2012-02-12'),(451,'g',0,'2012-02-12'),(537,'g',0,'2011-12-07'),(292,'g',0,'2011-10-28'),(352,'g',0,'2012-02-13'),(355,'g',0,'2012-01-14'),(568,'g',0,'2011-12-07'),(540,'g',0,'2011-12-23'),(396,'g',0,'2011-12-01'),(474,'g',0,'2011-12-01'),(538,'g',0,'2011-12-23'),(363,'g',0,'2011-12-08'),(336,'g',0,'2011-12-21'),(307,'g',0,'2011-11-28'),(412,'g',0,'2011-11-28'),(498,'g',0,'2011-12-01'),(308,'g',0,'2012-02-13'),(324,'g',0,'2012-01-24'),(499,'g',0,'2011-11-28'),(516,'g',0,'2011-11-28'),(535,'g',0,'2011-12-01'),(546,'g',0,'2011-12-19'),(424,'g',0,'2011-12-21'),(380,'g',0,'2011-10-28'),(354,'g',0,'2012-01-14'),(306,'g',0,'2012-02-12'),(238,'g',0,'2011-12-21'),(571,'g',0,'2011-10-28'),(368,'g',0,'2011-11-28'),(544,'g',0,'2011-12-03'),(584,'g',0,'2012-02-17'),(447,'g',0,'2011-11-03'),(563,'g',0,'2011-12-13'),(281,'g',0,'2012-02-04'),(326,'g',0,'2012-02-10'),(327,'g',0,'2012-02-10'),(464,'g',0,'2011-11-03'),(427,'g',0,'2011-12-13'),(481,'g',0,'2012-01-24'),(441,'g',0,'2012-01-26'),(387,'g',0,'2011-11-03'),(351,'g',0,'2012-01-26'),(414,'g',0,'2011-11-03'),(374,'g',0,'2012-01-26'),(462,'g',0,'2011-11-03'),(406,'g',0,'2011-11-03'),(436,'g',0,'2011-11-03'),(369,'g',0,'2012-03-01'),(455,'g',0,'2011-11-03'),(520,'g',0,'2011-11-03'),(529,'g',0,'2011-11-03'),(506,'g',0,'2012-02-04'),(521,'g',0,'2011-11-03'),(392,'g',0,'2011-11-03'),(586,'g',0,'2011-12-13'),(423,'g',0,'2012-02-10'),(404,'g',0,'2011-11-03'),(502,'g',0,'2011-11-03'),(431,'g',0,'2012-02-10'),(382,'g',0,'2011-11-03'),(442,'g',0,'2011-11-03'),(592,'g',0,'2012-02-12'),(353,'g',0,'2012-02-04'),(385,'g',0,'2011-11-03'),(601,'g',0,'2011-11-04'),(574,'g',0,'2011-12-13'),(607,'g',0,'2011-11-04'),(576,'g',0,'2011-11-04'),(599,'g',0,'2011-11-04'),(600,'g',0,'2011-11-04'),(577,'g',0,'2011-11-04'),(596,'g',0,'2011-11-04'),(610,'g',0,'2011-11-04'),(578,'g',0,'2011-11-06'),(598,'g',0,'2011-11-06'),(603,'g',0,'2011-11-06'),(549,'g',0,'2011-11-06'),(545,'g',0,'2011-11-06'),(476,'g',0,'2011-11-06'),(621,'g',0,'2011-11-06'),(469,'g',0,'2011-11-06'),(517,'g',0,'2011-12-09'),(597,'g',0,'2011-11-06'),(613,'g',0,'2011-11-06'),(609,'g',0,'2011-11-06'),(497,'g',0,'2011-11-06'),(605,'g',0,'2011-11-07'),(435,'g',0,'2012-03-05'),(453,'g',0,'2011-11-08'),(580,'g',0,'2012-03-05'),(389,'g',0,'2011-11-08'),(475,'g',0,'2011-11-08'),(484,'g',0,'2011-11-09'),(525,'g',0,'2011-11-09'),(505,'g',0,'2011-11-09'),(310,'g',0,'2011-11-09'),(495,'g',0,'2011-11-09'),(626,'g',0,'2011-11-09'),(522,'g',0,'2011-11-09'),(410,'g',0,'2011-11-09'),(512,'g',0,'2011-11-09'),(407,'g',0,'2011-11-09'),(330,'g',0,'2011-11-10'),(608,'g',0,'2011-11-10'),(602,'g',0,'2011-11-10'),(617,'g',0,'2011-11-11'),(616,'g',0,'2011-11-11'),(618,'g',0,'2011-11-12'),(615,'g',0,'2011-11-12'),(611,'g',0,'2011-11-12'),(675,'g',0,'2011-11-13'),(811,'g',0,'2011-12-23'),(700,'g',0,'2012-02-17'),(747,'g',0,'2011-11-13'),(781,'g',0,'2011-11-14'),(728,'g',0,'2011-11-14'),(799,'g',0,'2011-12-15'),(783,'g',0,'2011-11-15'),(814,'g',0,'2011-11-15'),(624,'g',0,'2011-11-15'),(612,'g',0,'2011-11-15'),(565,'g',0,'2011-11-15'),(730,'g',0,'2011-11-15'),(817,'g',0,'2011-11-15'),(731,'g',0,'2011-11-15'),(772,'g',0,'2011-11-15'),(619,'g',0,'2011-11-16'),(776,'g',0,'2012-01-14'),(625,'g',0,'2011-11-16'),(627,'g',0,'2011-11-16'),(620,'g',0,'2011-11-16'),(768,'g',0,'2012-03-05'),(738,'g',0,'2012-03-05'),(733,'g',0,'2011-12-21'),(797,'g',0,'2011-11-17'),(762,'g',0,'2011-11-17'),(736,'g',0,'2011-11-17'),(628,'g',0,'2011-11-17'),(785,'g',0,'2012-01-19'),(629,'g',0,'2011-11-18'),(632,'g',0,'2011-11-18'),(630,'g',0,'2011-11-18'),(635,'g',0,'2011-11-18'),(636,'g',0,'2011-11-18'),(634,'g',0,'2011-11-19'),(633,'g',0,'2011-11-19'),(820,'g',0,'2011-11-19'),(739,'g',0,'2012-01-07'),(687,'g',0,'2011-11-19'),(832,'g',0,'2011-11-19'),(685,'g',0,'2011-11-19'),(680,'g',0,'2011-11-19'),(638,'g',0,'2011-11-19'),(639,'g',0,'2011-11-19'),(806,'g',0,'2011-11-19'),(637,'g',0,'2011-11-19'),(821,'g',0,'2011-11-20'),(720,'g',0,'2011-11-21'),(807,'g',0,'2012-02-11'),(715,'g',0,'2011-11-21'),(723,'g',0,'2011-11-21'),(802,'g',0,'2011-11-21'),(750,'g',0,'2011-12-21'),(688,'g',0,'2011-11-21'),(689,'g',0,'2012-02-12'),(693,'g',0,'2011-11-21'),(754,'g',0,'2011-11-21'),(790,'g',0,'2011-11-21'),(796,'g',0,'2011-11-21'),(714,'g',0,'2011-11-21'),(699,'g',0,'2011-11-21'),(801,'g',0,'2011-11-21'),(710,'g',0,'2011-11-21'),(749,'g',0,'2011-11-21'),(726,'g',0,'2012-02-17'),(711,'g',0,'2011-11-21'),(756,'g',0,'2011-11-21'),(805,'g',0,'2011-11-21'),(753,'g',0,'2012-02-16'),(725,'g',0,'2012-02-18'),(737,'g',0,'2011-11-21'),(695,'g',0,'2011-11-21'),(789,'g',0,'2011-11-21'),(779,'g',0,'2011-11-21'),(701,'g',0,'2011-11-21'),(780,'g',0,'2011-11-21'),(793,'g',0,'2012-03-01'),(757,'g',0,'2011-11-21'),(713,'g',0,'2011-11-21'),(690,'g',0,'2012-02-12'),(707,'g',0,'2011-11-21'),(748,'g',0,'2011-11-21'),(775,'g',0,'2011-11-21'),(696,'g',0,'2012-01-05'),(722,'g',0,'2011-11-21'),(767,'g',0,'2011-11-21'),(800,'g',0,'2011-11-21'),(702,'g',0,'2011-11-21'),(803,'g',0,'2011-11-21'),(709,'g',0,'2011-11-21'),(642,'g',0,'2011-11-21'),(717,'g',0,'2011-11-21'),(774,'g',0,'2011-11-21'),(743,'g',0,'2011-11-21'),(668,'g',0,'2011-11-21'),(694,'g',0,'2011-11-21'),(692,'g',0,'2011-11-21'),(742,'g',0,'2011-11-21'),(809,'g',0,'2012-03-01'),(751,'g',0,'2012-03-01'),(706,'g',0,'2012-01-11'),(691,'g',0,'2011-11-21'),(708,'g',0,'2011-11-21'),(718,'g',0,'2011-11-21'),(766,'g',0,'2011-11-21'),(712,'g',0,'2011-11-21'),(704,'g',0,'2011-11-21'),(787,'g',0,'2011-11-21'),(705,'g',0,'2011-11-21'),(755,'g',0,'2011-11-21'),(746,'g',0,'2012-01-14'),(698,'g',0,'2011-11-21'),(752,'g',0,'2011-11-21'),(804,'g',0,'2011-11-21'),(795,'g',0,'2012-03-01'),(808,'g',0,'2012-03-02'),(703,'g',0,'2011-11-21'),(758,'g',0,'2011-11-21'),(813,'g',0,'2011-11-21'),(778,'g',0,'2011-11-21'),(812,'g',0,'2011-11-21'),(764,'g',0,'2011-11-21'),(763,'g',0,'2011-11-21'),(697,'g',0,'2011-11-21'),(660,'g',0,'2011-11-21'),(724,'g',0,'2011-11-21'),(664,'g',0,'2011-11-21'),(788,'g',0,'2011-11-21'),(678,'g',0,'2011-11-21'),(662,'g',0,'2011-11-21'),(721,'g',0,'2011-11-21'),(663,'g',0,'2011-11-21'),(740,'g',0,'2011-11-21'),(641,'g',0,'2011-11-21'),(661,'g',0,'2011-11-21'),(745,'g',0,'2011-11-21'),(734,'g',0,'2011-11-21'),(682,'g',0,'2011-11-21'),(665,'g',0,'2011-11-21'),(770,'g',0,'2011-11-21'),(666,'g',0,'2011-11-21'),(792,'g',0,'2011-11-21'),(815,'g',0,'2011-11-21'),(816,'g',0,'2011-11-21'),(735,'g',0,'2011-11-23'),(1027,'g',0,'2012-03-05'),(970,'g',0,'2012-01-07'),(941,'g',0,'2011-11-27'),(1099,'g',0,'2011-12-01'),(848,'g',0,'2011-12-01'),(844,'g',0,'2011-12-01'),(829,'g',0,'2011-12-01'),(1112,'g',0,'2011-12-01'),(938,'g',0,'2011-12-02'),(937,'g',0,'2011-12-02'),(939,'g',0,'2011-12-02'),(846,'g',0,'2011-12-02'),(865,'g',0,'2011-12-02'),(847,'g',0,'2011-12-02'),(842,'g',0,'2011-12-02'),(824,'g',0,'2011-12-02'),(834,'g',0,'2011-12-02'),(827,'g',0,'2011-12-02'),(889,'g',0,'2011-12-02'),(910,'g',0,'2011-12-02'),(909,'g',0,'2011-12-02'),(896,'g',0,'2011-12-02'),(891,'g',0,'2011-12-02'),(843,'g',0,'2011-12-02'),(886,'g',0,'2011-12-02'),(823,'g',0,'2011-12-02'),(1116,'g',0,'2011-12-03'),(967,'g',0,'2011-12-03'),(888,'g',0,'2011-12-03'),(925,'g',0,'2011-12-03'),(914,'g',0,'2011-12-03'),(913,'g',0,'2011-12-03'),(890,'g',0,'2011-12-03'),(926,'g',0,'2011-12-03'),(907,'g',0,'2011-12-03'),(969,'g',0,'2011-12-03'),(915,'g',0,'2011-12-03'),(981,'g',0,'2011-12-04'),(993,'g',0,'2011-12-04'),(973,'g',0,'2011-12-04'),(971,'g',0,'2011-12-04'),(919,'g',0,'2011-12-04'),(911,'g',0,'2011-12-04'),(934,'g',0,'2011-12-04'),(962,'g',0,'2011-12-04'),(949,'g',0,'2011-12-04'),(1000,'g',0,'2011-12-04'),(874,'g',0,'2011-12-04'),(857,'g',0,'2011-12-04'),(640,'g',0,'2011-12-04'),(782,'g',0,'2011-12-04'),(681,'g',0,'2011-12-04'),(727,'g',0,'2011-12-05'),(581,'g',0,'2011-12-05'),(579,'g',0,'2011-12-05'),(606,'g',0,'2011-12-05'),(777,'g',0,'2011-12-05'),(760,'g',0,'2012-01-26'),(810,'g',0,'2011-12-05'),(819,'g',0,'2011-12-05'),(818,'g',0,'2011-12-05'),(744,'g',0,'2011-12-05'),(686,'g',0,'2011-12-05'),(683,'g',0,'2011-12-05'),(716,'g',0,'2011-12-05'),(794,'g',0,'2011-12-05'),(784,'g',0,'2011-12-06'),(861,'g',0,'2011-12-06'),(869,'g',0,'2011-12-06'),(883,'g',0,'2011-12-06'),(877,'g',0,'2012-01-14'),(984,'g',0,'2012-01-14'),(833,'g',0,'2011-12-06'),(1044,'g',0,'2012-01-14'),(1039,'g',0,'2011-12-07'),(992,'g',0,'2012-01-14'),(916,'g',0,'2012-01-14'),(901,'g',0,'2011-12-07'),(729,'g',0,'2012-02-12'),(1111,'g',0,'2011-12-07'),(732,'g',0,'2011-12-07'),(871,'g',0,'2011-12-07'),(1059,'g',0,'2011-12-08'),(1202,'g',0,'2011-12-08'),(974,'g',0,'2011-12-08'),(895,'g',0,'2011-12-08'),(1104,'g',0,'2011-12-08'),(1020,'g',0,'2011-12-08'),(1210,'g',0,'2011-12-08'),(1230,'g',0,'2011-12-08'),(365,'g',0,'2012-01-10'),(408,'g',0,'2011-12-09'),(860,'g',0,'2011-12-10'),(859,'g',0,'2011-12-10'),(863,'g',0,'2011-12-10'),(870,'g',0,'2011-12-10'),(872,'g',0,'2011-12-10'),(906,'g',0,'2011-12-10'),(893,'g',0,'2011-12-10'),(912,'g',0,'2011-12-10'),(903,'g',0,'2011-12-10'),(998,'g',0,'2011-12-10'),(830,'g',0,'2011-12-10'),(927,'g',0,'2011-12-10'),(963,'g',0,'2011-12-10'),(892,'g',0,'2011-12-11'),(855,'g',0,'2011-12-11'),(923,'g',0,'2011-12-11'),(878,'g',0,'2011-12-11'),(897,'g',0,'2011-12-11'),(887,'g',0,'2011-12-11'),(771,'g',0,'2011-12-11'),(968,'g',0,'2011-12-11'),(900,'g',0,'2011-12-11'),(898,'g',0,'2011-12-11'),(825,'g',0,'2011-12-11'),(899,'g',0,'2011-12-11'),(959,'g',0,'2011-12-11'),(999,'g',0,'2011-12-11'),(918,'g',0,'2011-12-11'),(975,'g',0,'2011-12-11'),(885,'g',0,'2011-12-11'),(983,'g',0,'2011-12-12'),(990,'g',0,'2011-12-12'),(995,'g',0,'2011-12-12'),(287,'g',0,'2012-03-02'),(291,'g',0,'2012-02-11'),(296,'g',0,'2012-02-11'),(178,'g',0,'2012-02-11'),(293,'g',0,'2012-02-11'),(294,'g',0,'2012-02-11'),(552,'g',0,'2012-02-04'),(569,'g',0,'2012-03-06'),(659,'g',0,'2011-12-13'),(585,'g',0,'2011-12-13'),(541,'g',0,'2012-02-04'),(559,'g',0,'2012-02-04'),(858,'g',0,'2011-12-13'),(862,'g',0,'2011-12-13'),(339,'g',0,'2011-12-13'),(343,'g',0,'2011-12-13'),(342,'g',0,'2011-12-13'),(334,'g',0,'2012-01-26'),(333,'g',0,'2011-12-13'),(276,'g',0,'2011-12-13'),(655,'g',0,'2011-12-13'),(669,'g',0,'2011-12-13'),(656,'g',0,'2011-12-13'),(652,'g',0,'2011-12-13'),(657,'g',0,'2011-12-13'),(651,'g',0,'2011-12-13'),(653,'g',0,'2011-12-13'),(654,'g',0,'2011-12-13'),(658,'g',0,'2011-12-13'),(670,'g',0,'2011-12-13'),(674,'g',0,'2011-12-13'),(672,'g',0,'2011-12-13'),(673,'g',0,'2011-12-13'),(671,'g',0,'2011-12-13'),(273,'g',0,'2011-12-13'),(719,'g',0,'2011-12-13'),(759,'g',0,'2011-12-13'),(798,'g',0,'2012-01-21'),(904,'g',0,'2012-01-21'),(966,'g',0,'2012-01-21'),(908,'g',0,'2012-01-21'),(1279,'g',0,'2011-12-13'),(1278,'g',0,'2011-12-13'),(953,'g',0,'2012-01-21'),(356,'g',0,'2011-12-13'),(272,'g',0,'2011-12-14'),(335,'g',0,'2012-01-26'),(533,'g',0,'2011-12-14'),(791,'g',0,'2011-12-14'),(1316,'g',0,'2012-03-02'),(976,'g',0,'2011-12-15'),(769,'g',0,'2011-12-15'),(972,'g',0,'2011-12-15'),(1004,'g',0,'2011-12-15'),(1347,'g',0,'2011-12-15'),(1337,'g',0,'2011-12-15'),(1258,'g',0,'2011-12-15'),(741,'g',0,'2011-12-16'),(555,'g',0,'2011-12-16'),(554,'g',0,'2011-12-16'),(1257,'g',0,'2011-12-16'),(1351,'g',0,'2011-12-16'),(1353,'g',0,'2011-12-16'),(1354,'g',0,'2011-12-16'),(1339,'g',0,'2011-12-16'),(1349,'g',0,'2011-12-16'),(1330,'g',0,'2011-12-17'),(902,'g',0,'2011-12-17'),(958,'g',0,'2011-12-17'),(987,'g',0,'2011-12-17'),(961,'g',0,'2011-12-17'),(1259,'g',0,'2011-12-18'),(1326,'g',0,'2011-12-19'),(1341,'g',0,'2011-12-19'),(1352,'g',0,'2012-02-16'),(1324,'g',0,'2011-12-19'),(1327,'g',0,'2011-12-19'),(1297,'g',0,'2011-12-19'),(1329,'g',0,'2011-12-19'),(1328,'g',0,'2011-12-19'),(1323,'g',0,'2011-12-19'),(1318,'g',0,'2011-12-19'),(1325,'g',0,'2011-12-19'),(1309,'g',0,'2011-12-19'),(1317,'g',0,'2011-12-19'),(1315,'g',0,'2011-12-19'),(1322,'g',0,'2011-12-19'),(881,'g',0,'2011-12-19'),(1308,'g',0,'2011-12-19'),(994,'g',0,'2011-12-19'),(786,'g',0,'2011-12-19'),(880,'g',0,'2011-12-19'),(882,'g',0,'2011-12-19'),(773,'g',0,'2011-12-19'),(765,'g',0,'2011-12-19'),(1121,'g',0,'2011-12-19'),(1280,'g',0,'2011-12-19'),(1391,'g',0,'2011-12-20'),(1390,'g',0,'2011-12-20'),(1399,'g',0,'2012-03-05'),(1299,'g',0,'2012-03-05'),(419,'g',0,'2011-12-21'),(417,'g',0,'2011-12-21'),(420,'g',0,'2011-12-21'),(418,'g',0,'2011-12-21'),(416,'g',0,'2011-12-21'),(1385,'g',0,'2011-12-21'),(1388,'g',0,'2011-12-21'),(1363,'g',0,'2011-12-21'),(1376,'g',0,'2012-02-21'),(1401,'g',0,'2011-12-21'),(1414,'g',0,'2011-12-22'),(1383,'g',0,'2011-12-22'),(1424,'g',0,'2011-12-23'),(761,'g',0,'2011-12-23'),(1411,'g',0,'2011-12-23'),(1375,'g',0,'2011-12-23'),(1423,'g',0,'2011-12-23'),(1381,'g',0,'2011-12-23'),(1373,'g',0,'2012-02-01'),(1404,'g',0,'2012-02-01'),(1422,'g',0,'2011-12-23'),(1372,'g',0,'2012-02-01'),(1370,'g',0,'2011-12-23'),(1403,'g',0,'2011-12-23'),(1435,'g',0,'2011-12-24'),(1412,'g',0,'2011-12-24'),(1417,'g',0,'2011-12-24'),(1420,'g',0,'2011-12-24'),(1434,'g',0,'2011-12-24'),(1314,'g',0,'2011-12-26'),(1289,'g',0,'2011-12-26'),(1054,'g',0,'2011-12-26'),(1198,'g',0,'2011-12-26'),(1320,'g',0,'2011-12-26'),(1457,'g',0,'2012-03-02'),(1441,'g',0,'2012-03-02'),(1468,'g',0,'2011-12-26'),(1476,'g',0,'2011-12-26'),(1319,'g',0,'2011-12-26'),(1450,'g',0,'2011-12-26'),(1444,'g',0,'2011-12-26'),(1448,'g',0,'2011-12-26'),(1451,'g',0,'2011-12-26'),(1443,'g',0,'2011-12-26'),(1431,'g',0,'2011-12-26'),(1449,'g',0,'2011-12-26'),(1480,'g',0,'2011-12-26'),(1465,'g',0,'2011-12-26'),(1455,'g',0,'2011-12-26'),(1406,'g',0,'2012-02-17'),(1053,'g',0,'2011-12-26'),(1321,'g',0,'2011-12-27'),(1307,'g',0,'2011-12-27'),(1429,'g',0,'2012-03-07'),(1445,'g',0,'2012-03-06'),(1426,'g',0,'2012-03-07'),(1478,'g',0,'2012-01-26'),(1430,'g',0,'2012-01-26'),(470,'g',0,'2012-01-26'),(467,'g',0,'2011-12-28'),(1288,'g',0,'2011-12-28'),(1302,'g',0,'2011-12-28'),(1428,'g',0,'2011-12-28'),(1008,'g',0,'2011-12-28'),(1055,'g',0,'2011-12-28'),(1442,'g',0,'2011-12-29'),(1460,'g',0,'2011-12-29'),(1294,'g',0,'2011-12-29'),(1122,'g',0,'2011-12-29'),(1028,'g',0,'2011-12-29'),(1292,'g',0,'2011-12-29'),(1517,'g',0,'2011-12-30'),(945,'g',0,'2011-12-31'),(1057,'g',0,'2011-12-31'),(1005,'g',0,'2011-12-31'),(1023,'g',0,'2011-12-31'),(1002,'g',0,'2011-12-31'),(1060,'g',0,'2011-12-31'),(1398,'g',0,'2011-12-31'),(1051,'g',0,'2011-12-31'),(1495,'g',0,'2012-01-01'),(1378,'g',0,'2012-01-01'),(1405,'g',0,'2012-01-01'),(1413,'g',0,'2012-01-01'),(1511,'g',0,'2012-01-01'),(1484,'g',0,'2012-01-01'),(1482,'g',0,'2012-01-01'),(1523,'g',0,'2012-02-17'),(1528,'g',0,'2012-02-17'),(1487,'g',0,'2012-02-17'),(1452,'g',0,'2012-01-01'),(1456,'g',0,'2012-01-01'),(1432,'g',0,'2012-01-01'),(1496,'g',0,'2012-01-02'),(1368,'g',0,'2012-01-02'),(1459,'g',0,'2012-01-02'),(1520,'g',0,'2012-01-02'),(1472,'g',0,'2012-01-02'),(989,'g',0,'2012-01-02'),(997,'g',0,'2012-01-02'),(1479,'g',0,'2012-01-02'),(1544,'g',0,'2012-01-03'),(1545,'g',0,'2012-01-03'),(1541,'g',0,'2012-01-03'),(1546,'g',0,'2012-02-04'),(1617,'g',0,'2012-01-03'),(1513,'g',0,'2012-01-03'),(1612,'g',0,'2012-01-03'),(1427,'g',0,'2012-01-03'),(1499,'g',0,'2012-01-04'),(1551,'g',0,'2012-01-04'),(1527,'g',0,'2012-01-04'),(1477,'g',0,'2012-01-05'),(1458,'g',0,'2012-01-05'),(1515,'g',0,'2012-01-05'),(1512,'g',0,'2012-01-05'),(1525,'g',0,'2012-01-05'),(1590,'g',0,'2012-01-05'),(1580,'g',0,'2012-01-05'),(1586,'g',0,'2012-01-05'),(1522,'g',0,'2012-01-05'),(1481,'g',0,'2012-01-05'),(1561,'g',0,'2012-01-05'),(1542,'g',0,'2012-02-10'),(1379,'g',0,'2012-01-05'),(1638,'g',0,'2012-01-05'),(1643,'g',0,'2012-01-05'),(1540,'g',0,'2012-02-10'),(1249,'g',0,'2012-01-05'),(1519,'g',0,'2012-01-06'),(1555,'g',0,'2012-02-17'),(1581,'g',0,'2012-03-05'),(1588,'g',0,'2012-03-05'),(1587,'g',0,'2012-01-07'),(1562,'g',0,'2012-01-07'),(1567,'g',0,'2012-01-08'),(1620,'g',0,'2012-01-08'),(1560,'g',0,'2012-01-08'),(1305,'g',0,'2012-01-08'),(1509,'g',0,'2012-01-08'),(1548,'g',0,'2012-02-10'),(1547,'g',0,'2012-02-10'),(594,'g',0,'2012-01-09'),(677,'g',0,'2012-01-09'),(667,'g',0,'2012-01-09'),(593,'g',0,'2012-01-09'),(1473,'g',0,'2012-01-09'),(551,'g',0,'2012-01-10'),(589,'g',0,'2012-01-10'),(582,'g',0,'2012-01-10'),(590,'g',0,'2012-01-10'),(542,'g',0,'2012-01-10'),(587,'g',0,'2012-01-10'),(539,'g',0,'2012-01-10'),(1377,'g',0,'2012-01-10'),(1508,'g',0,'2012-01-10'),(648,'g',0,'2012-01-11'),(649,'g',0,'2012-01-11'),(650,'g',0,'2012-01-11'),(647,'g',0,'2012-01-11'),(996,'g',0,'2012-01-12'),(1636,'g',0,'2012-01-12'),(1205,'g',0,'2012-01-12'),(986,'g',0,'2012-01-12'),(1550,'g',0,'2012-01-13'),(1690,'g',0,'2012-01-14'),(1549,'g',0,'2012-03-01'),(1691,'g',0,'2012-01-19'),(1032,'g',0,'2012-01-19'),(1650,'g',0,'2012-01-19'),(1501,'g',0,'2012-01-19'),(1801,'g',0,'2012-01-20'),(1795,'g',0,'2012-01-21'),(1521,'g',0,'2012-01-21'),(226,'g',0,'2012-01-21'),(222,'g',0,'2012-03-02'),(228,'g',0,'2012-01-21'),(229,'g',0,'2012-01-21'),(1553,'g',0,'2012-01-21'),(1488,'g',0,'2012-01-21'),(1788,'g',0,'2012-01-21'),(1827,'g',0,'2012-01-21'),(1490,'g',0,'2012-01-21'),(1494,'g',0,'2012-01-23'),(1365,'g',0,'2012-01-23'),(1058,'g',0,'2012-01-23'),(1026,'g',0,'2012-01-23'),(1366,'g',0,'2012-01-23'),(1301,'g',0,'2012-01-23'),(1812,'g',0,'2012-01-23'),(1578,'g',0,'2012-01-24'),(1491,'g',0,'2012-01-24'),(1492,'g',0,'2012-01-24'),(1543,'g',0,'2012-01-26'),(1698,'g',0,'2012-01-27'),(1593,'g',0,'2012-01-27'),(1052,'g',0,'2012-01-27'),(1576,'g',0,'2012-01-27'),(1600,'g',0,'2012-01-27'),(1595,'g',0,'2012-01-27'),(1944,'g',0,'2012-02-01'),(1946,'g',0,'2012-02-01'),(875,'g',0,'2012-02-03'),(950,'g',0,'2012-02-03'),(955,'g',0,'2012-02-03'),(936,'g',0,'2012-02-04'),(954,'g',0,'2012-02-05'),(930,'g',0,'2012-02-05'),(948,'g',0,'2012-02-05'),(944,'g',0,'2012-02-05'),(932,'g',0,'2012-02-05'),(940,'g',0,'2012-02-05'),(931,'g',0,'2012-02-05'),(947,'g',0,'2012-02-05'),(1009,'g',0,'2012-02-05'),(1001,'g',0,'2012-02-05'),(1960,'g',0,'2012-02-05'),(1969,'g',0,'2012-02-06'),(1949,'g',0,'2012-02-06'),(2004,'g',0,'2012-02-06'),(2002,'g',0,'2012-02-06'),(1883,'g',0,'2012-02-07'),(1697,'g',0,'2012-02-07'),(1935,'g',0,'2012-02-07'),(1710,'g',0,'2012-02-07'),(1191,'g',0,'2012-02-07'),(1773,'g',0,'2012-02-07'),(557,'g',0,'2012-02-09'),(583,'g',0,'2012-02-09'),(595,'g',0,'2012-02-09'),(553,'g',0,'2012-02-09'),(556,'g',0,'2012-02-09'),(478,'g',0,'2012-02-09'),(322,'g',0,'2012-02-09'),(340,'g',0,'2012-02-09'),(274,'g',0,'2012-02-09'),(550,'g',0,'2012-02-09'),(325,'g',0,'2012-02-09'),(503,'g',0,'2012-02-09'),(490,'g',0,'2012-02-10'),(279,'g',0,'2012-02-10'),(1371,'g',0,'2012-02-10'),(1382,'g',0,'2012-02-10'),(1407,'g',0,'2012-02-10'),(1461,'g',0,'2012-02-10'),(1402,'g',0,'2012-02-10'),(964,'g',0,'2012-02-10'),(965,'g',0,'2012-02-10'),(2096,'g',0,'2012-02-11'),(588,'g',0,'2012-02-11'),(280,'g',0,'2012-02-11'),(591,'g',0,'2012-02-11'),(275,'g',0,'2012-02-11'),(496,'g',0,'2012-02-11'),(1514,'g',0,'2012-02-11'),(1374,'g',0,'2012-02-11'),(488,'g',0,'2012-02-11'),(1554,'g',0,'2012-02-11'),(1344,'g',0,'2012-02-11'),(1693,'g',0,'2012-02-11'),(1594,'g',0,'2012-02-12'),(1524,'g',0,'2012-02-12'),(1552,'g',0,'2012-02-12'),(2094,'g',0,'2012-02-12'),(1504,'g',0,'2012-02-12'),(1158,'g',0,'2012-02-12'),(980,'g',0,'2012-02-12'),(1797,'g',0,'2012-02-12'),(1493,'g',0,'2012-02-12'),(1717,'g',0,'2012-02-13'),(1931,'g',0,'2012-02-13'),(2047,'g',0,'2012-02-14'),(2093,'g',0,'2012-02-14'),(1951,'g',0,'2012-02-14'),(1952,'g',0,'2012-02-14'),(2044,'g',0,'2012-02-14'),(2124,'g',0,'2012-02-14'),(1591,'g',0,'2012-02-14'),(1641,'g',0,'2012-02-14'),(1860,'g',0,'2012-02-14'),(1397,'g',0,'2012-02-14'),(1592,'g',0,'2012-02-14'),(1684,'g',0,'2012-02-14'),(1611,'g',0,'2012-02-14'),(1610,'g',0,'2012-02-14'),(1579,'g',0,'2012-02-14'),(1582,'g',0,'2012-02-14'),(2128,'g',0,'2012-02-14'),(2012,'g',0,'2012-02-14'),(1719,'g',0,'2012-02-14'),(2148,'g',0,'2012-02-14'),(2144,'g',0,'2012-02-15'),(2146,'g',0,'2012-02-15'),(2092,'g',0,'2012-02-15'),(314,'g',0,'2012-02-15'),(318,'g',0,'2012-02-15'),(317,'g',0,'2012-02-15'),(1400,'g',0,'2012-02-15'),(312,'g',0,'2012-02-15'),(1559,'g',0,'2012-02-15'),(1369,'g',0,'2012-02-15'),(309,'g',0,'2012-02-15'),(1386,'g',0,'2012-02-15'),(1387,'g',0,'2012-02-15'),(1858,'g',0,'2012-02-15'),(2125,'g',0,'2012-02-15'),(1928,'g',0,'2012-02-15'),(2147,'g',0,'2012-02-15'),(1672,'g',0,'2012-02-15'),(1296,'g',0,'2012-02-15'),(1283,'g',0,'2012-02-15'),(1728,'g',0,'2012-02-15'),(1029,'g',0,'2012-02-15'),(1727,'g',0,'2012-02-15'),(1628,'g',0,'2012-02-15'),(1635,'g',0,'2012-02-15'),(1813,'g',0,'2012-02-15'),(2046,'g',0,'2012-02-15'),(946,'g',0,'2012-02-15'),(866,'g',0,'2012-02-15'),(952,'g',0,'2012-02-15'),(1310,'g',0,'2012-02-15'),(1311,'g',0,'2012-02-15'),(1313,'g',0,'2012-02-15'),(1019,'g',0,'2012-02-15'),(1312,'g',0,'2012-02-15'),(1010,'g',0,'2012-02-15'),(2117,'g',0,'2012-02-15'),(2115,'g',0,'2012-02-15'),(2149,'g',0,'2012-02-16'),(2043,'g',0,'2012-02-16'),(850,'g',0,'2012-02-16'),(849,'g',0,'2012-02-16'),(679,'g',0,'2012-02-16'),(1489,'g',0,'2012-02-16'),(684,'g',0,'2012-02-16'),(1630,'g',0,'2012-02-16'),(2024,'g',0,'2012-02-16'),(1953,'g',0,'2012-02-16'),(1963,'g',0,'2012-02-16'),(1700,'g',0,'2012-02-16'),(2134,'g',0,'2012-02-16'),(1918,'g',0,'2012-02-16'),(2030,'g',0,'2012-02-16'),(1929,'g',0,'2012-02-16'),(1857,'g',0,'2012-02-16'),(1703,'g',0,'2012-02-16'),(1471,'g',0,'2012-02-16'),(1470,'g',0,'2012-02-16'),(1474,'g',0,'2012-02-16'),(2011,'g',0,'2012-02-16'),(942,'g',0,'2012-02-17'),(1286,'g',0,'2012-02-17'),(1281,'g',0,'2012-02-17'),(1021,'g',0,'2012-02-17'),(1285,'g',0,'2012-02-17'),(331,'g',0,'2012-02-17'),(1306,'g',0,'2012-02-17'),(1608,'g',0,'2012-02-17'),(1015,'g',0,'2012-02-17'),(1016,'g',0,'2012-02-17'),(1854,'g',0,'2012-02-17'),(1018,'g',0,'2012-02-17'),(1033,'g',0,'2012-02-17'),(1011,'g',0,'2012-02-17'),(1013,'g',0,'2012-02-17'),(1007,'g',0,'2012-02-17'),(2156,'g',0,'2012-02-17'),(2152,'g',0,'2012-02-17'),(960,'g',0,'2012-02-17'),(1031,'g',0,'2012-02-17'),(991,'g',0,'2012-02-17'),(1250,'g',0,'2012-02-17'),(1596,'g',0,'2012-02-17'),(1571,'g',0,'2012-02-17'),(1573,'g',0,'2012-02-17'),(1584,'g',0,'2012-02-17'),(1022,'g',0,'2012-02-17'),(1467,'g',0,'2012-02-17'),(2145,'g',0,'2012-02-18'),(1425,'g',0,'2012-02-18'),(982,'g',0,'2012-02-18'),(985,'g',0,'2012-02-18'),(2034,'g',0,'2012-02-18'),(1597,'g',0,'2012-02-18'),(1948,'g',0,'2012-02-18'),(2050,'g',0,'2012-02-18'),(1656,'g',0,'2012-02-18'),(978,'g',0,'2012-02-18'),(2170,'g',0,'2012-02-18'),(979,'g',0,'2012-02-18'),(977,'g',0,'2012-02-18'),(2164,'g',0,'2012-02-19'),(1961,'g',0,'2012-02-20'),(1735,'g',0,'2012-02-20'),(1922,'g',0,'2012-02-20'),(2176,'g',0,'2012-02-20'),(1819,'g',0,'2012-02-20'),(1859,'g',0,'2012-02-20'),(1936,'g',0,'2012-02-20'),(1716,'g',0,'2012-02-20'),(2103,'g',0,'2012-02-21'),(2102,'g',0,'2012-02-21'),(2104,'g',0,'2012-02-21'),(2186,'g',0,'2012-02-21'),(2181,'g',0,'2012-02-21'),(2206,'g',0,'2012-02-21'),(2211,'g',0,'2012-02-22'),(1067,'g',0,'2012-03-01'),(1295,'g',0,'2012-03-01'),(1077,'g',0,'2012-03-01'),(1074,'g',0,'2012-03-01'),(935,'g',0,'2012-03-01'),(1040,'g',0,'2012-03-01'),(1076,'g',0,'2012-03-01'),(884,'g',0,'2012-03-01'),(1073,'g',0,'2012-03-01'),(1065,'g',0,'2012-03-01'),(1300,'g',0,'2012-03-01'),(1090,'g',0,'2012-03-01'),(1088,'g',0,'2012-03-01'),(1089,'g',0,'2012-03-01'),(1085,'g',0,'2012-03-01'),(1087,'g',0,'2012-03-01'),(1086,'g',0,'2012-03-01'),(1084,'g',0,'2012-03-01'),(1083,'g',0,'2012-03-01'),(1071,'g',0,'2012-03-01'),(905,'g',0,'2012-03-01'),(1061,'g',0,'2012-03-01'),(1072,'g',0,'2012-03-01'),(1062,'g',0,'2012-03-01'),(1068,'g',0,'2012-03-01'),(879,'g',0,'2012-03-01'),(1082,'g',0,'2012-03-01'),(1078,'g',0,'2012-03-01'),(1017,'g',0,'2012-03-01'),(1070,'g',0,'2012-03-01'),(928,'g',0,'2012-03-01'),(873,'g',0,'2012-03-01'),(1042,'g',0,'2012-03-01'),(1006,'g',0,'2012-03-01'),(1056,'g',0,'2012-03-01'),(1045,'g',0,'2012-03-01'),(1287,'g',0,'2012-03-01'),(1291,'g',0,'2012-03-01'),(1098,'g',0,'2012-03-01'),(1293,'g',0,'2012-03-01'),(1081,'g',0,'2012-03-01'),(1096,'g',0,'2012-03-01'),(1209,'g',0,'2012-03-01'),(929,'g',0,'2012-03-01'),(1094,'g',0,'2012-03-01'),(1284,'g',0,'2012-03-01'),(1024,'g',0,'2012-03-01'),(1079,'g',0,'2012-03-01'),(1080,'g',0,'2012-03-01'),(917,'g',0,'2012-03-01'),(1069,'g',0,'2012-03-01'),(924,'g',0,'2012-03-01'),(1030,'g',0,'2012-03-01'),(1075,'g',0,'2012-03-01'),(1066,'g',0,'2012-03-01'),(933,'g',0,'2012-03-01'),(1063,'g',0,'2012-03-01'),(1025,'g',0,'2012-03-01'),(1064,'g',0,'2012-03-01'),(1050,'g',0,'2012-03-01'),(1298,'g',0,'2012-03-01'),(876,'g',0,'2012-03-01'),(988,'g',0,'2012-03-01'),(943,'g',0,'2012-03-01'),(957,'g',0,'2012-03-01'),(1092,'g',0,'2012-03-01'),(1093,'g',0,'2012-03-01'),(1097,'g',0,'2012-03-01'),(2248,'g',0,'2012-03-01'),(2233,'g',0,'2012-03-01'),(2200,'g',0,'2012-03-01'),(2196,'g',0,'2012-03-01'),(2110,'g',0,'2012-03-01'),(2228,'g',0,'2012-03-01'),(2215,'g',0,'2012-03-01'),(2214,'g',0,'2012-03-01'),(2227,'g',0,'2012-03-01'),(2191,'g',0,'2012-03-01'),(2213,'g',0,'2012-03-02'),(2101,'g',0,'2012-03-02'),(2182,'g',0,'2012-03-02'),(2106,'g',0,'2012-03-02'),(2216,'g',0,'2012-03-02'),(2178,'g',0,'2012-03-02'),(2244,'g',0,'2012-03-02'),(2184,'g',0,'2012-03-02'),(2157,'g',0,'2012-03-02'),(2189,'g',0,'2012-03-02'),(2225,'g',0,'2012-03-02'),(2159,'g',0,'2012-03-02'),(2197,'g',0,'2012-03-02'),(2240,'g',0,'2012-03-02'),(2163,'g',0,'2012-03-02'),(2179,'g',0,'2012-03-02'),(2232,'g',0,'2012-03-02'),(2111,'g',0,'2012-03-02'),(851,'g',0,'2012-03-02'),(2107,'g',0,'2012-03-02'),(2177,'g',0,'2012-03-02'),(1603,'g',0,'2012-03-03'),(1607,'g',0,'2012-03-03'),(2252,'g',0,'2012-03-03'),(2251,'g',0,'2012-03-03'),(2208,'g',0,'2012-03-03'),(1725,'g',0,'2012-03-04'),(2231,'g',0,'2012-03-05'),(1014,'g',0,'2012-03-05'),(2131,'g',0,'2012-03-05'),(2099,'g',0,'2012-03-05'),(543,'g',0,'2012-03-05'),(562,'g',0,'2012-03-05'),(2160,'g',0,'2012-03-05'),(2241,'g',0,'2012-03-05'),(2230,'g',0,'2012-03-05'),(534,'g',0,'2012-03-05'),(2190,'g',0,'2012-03-05'),(329,'g',0,'2012-03-05'),(319,'g',0,'2012-03-05'),(2203,'g',0,'2012-03-05'),(2239,'g',0,'2012-03-05'),(2229,'g',0,'2012-03-05'),(548,'g',0,'2012-03-05'),(323,'g',0,'2012-03-05'),(2155,'g',0,'2012-03-05'),(2226,'g',0,'2012-03-06'),(2201,'g',0,'2012-03-06'),(2284,'g',0,'2012-03-06'),(2199,'g',0,'2012-03-06'),(2217,'g',0,'2012-03-06'),(645,'g',0,'2012-03-06'),(2198,'g',0,'2012-03-07'),(2218,'g',0,'2012-03-07'),(646,'g',0,'2012-03-07'),(2220,'g',0,'2012-03-07'),(2236,'g',0,'2012-03-07'),(2223,'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_pl_sociable`
--

CREATE TABLE `idx_pl_sociable` (
  `sb_id` int(11) NOT NULL auto_increment,
  `sb_name` varchar(255) character set utf8 default NULL,
  `sb_url` varchar(255) character set utf8 default NULL,
  `sb_icon` varchar(255) character set utf8 default NULL,
  `sb_enable` char(1) character set utf8 default '0',
  PRIMARY KEY  (`sb_id`)
) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_sociable`
--

INSERT INTO `idx_pl_sociable` VALUES (1,'BarraPunto','http://barrapunto.com/submit.pl?subj=TITLE&amp;story=PERMALINK','barrapunto.png','0'),(2,'Bitacoras.com','http://bitacoras.com/anotaciones/PERMALINK','bitacoras.png','0'),(3,'BlinkList','http://www.blinklist.com/index.php?Action=Blink/addblink.php&amp;Url=PERMALINK&amp;Title=TITLE','blinklist.png','0'),(4,'blogmarks','http://blogmarks.net/my/new.php?mini=1&amp;simple=1&amp;url=PERMALINK&amp;title=TITLE','blogmarks.png','0'),(5,'Blogosphere News','http://www.blogospherenews.com/submit.php?url=PERMALINK&amp;title=TITLE','blogospherenews.png','0'),(6,'blogtercimlap','http://cimlap.blogter.hu/index.php?action=suggest_link&amp;title=TITLE&amp;url=PERMALINK','blogter.png','0'),(7,'Faves','http://faves.com/Authoring.aspx?u=PERMALINK&amp;title=TITLE','bluedot.png','0'),(8,'connotea','http://www.connotea.org/addpopup?continue=confirm&amp;uri=PERMALINK&amp;title=TITLE&amp;description=EXCERPT','connotea.png','0'),(9,'Current','http://current.com/clipper.htm?url=PERMALINK&amp;title=TITLE','current.png','0'),(10,'del.icio.us','http://delicious.com/post?url=PERMALINK&amp;title=TITLE&amp;notes=EXCERPT','delicious.png','0'),(11,'Digg','http://digg.com/submit?phase=2&amp;url=PERMALINK&amp;title=TITLE&amp;bodytext=EXCERPT','digg.png','1'),(12,'Diigo','http://www.diigo.com/post?url=PERMALINK&amp;title=TITLE','diigo.png','0'),(13,'DotNetKicks','http://www.dotnetkicks.com/kick/?url=PERMALINK&amp;title=TITLE','dotnetkicks.png','0'),(14,'DZone','http://www.dzone.com/links/add.html?url=PERMALINK&amp;title=TITLE','dzone.png','0'),(15,'eKudos','http://www.ekudos.nl/artikel/nieuw?url=PERMALINK&amp;title=TITLE&amp;desc=EXCERPT','ekudos.png','0'),(16,'email','mailto:?subject=TITLE&amp;body=PERMALINK','email_link.png','0'),(17,'Facebook','http://www.facebook.com/share.php?u=PERMALINK&amp;t=TITLE','facebook.png','1'),(18,'Fark','http://cgi.fark.com/cgi/fark/farkit.pl?h=TITLE&amp;u=PERMALINK','fark.png','0'),(19,'Fleck','http://beta3.fleck.com/bookmarklet.php?url=PERMALINK&amp;title=TITLE','fleck.png','0'),(20,'FriendFeed','http://www.friendfeed.com/share?title=TITLE&amp;link=PERMALINK','friendfeed.png','0'),(21,'FSDaily','http://www.fsdaily.com/submit?url=PERMALINK&amp;title=TITLE','fsdaily.png','0'),(22,'Global Grind','http://globalgrind.com/submission/submit.aspx?url=PERMALINK&amp;type=Article&amp;title=TITLE','globalgrind.png','0'),(23,'Google','http://www.google.com/bookmarks/mark?op=edit&amp;bkmk=PERMALINK&amp;title=TITLE&amp;annotation=EXCERPT','googlebookmark.png','0'),(24,'Gwar','http://www.gwar.pl/DodajGwar.html?u=PERMALINK','gwar.png','0'),(25,'HackerNews','http://news.ycombinator.com/submitlink?u=PERMALINK&amp;t=TITLE','hackernews.png','0'),(26,'Haohao','http://www.haohaoreport.com/submit.php?url=PERMALINK&amp;title=TITLE','haohao.png','0'),(27,'HealthRanker','http://healthranker.com/submit.php?url=PERMALINK&amp;title=TITLE','healthranker.png','0'),(28,'HelloTxt','http://hellotxt.com/?status=TITLE+PERMALINK','hellotxt.png','0'),(29,'Hemidemi','http://www.hemidemi.com/user_bookmark/new?title=TITLE&amp;url=PERMALINK','hemidemi.png','0'),(30,'Hyves','http://www.hyves.nl/profilemanage/add/tips/?name=TITLE&amp;text=EXCERPT+PERMALINK&amp;rating=5','hyves.png','0'),(31,'Identi.ca','http://identi.ca/notice/new?status_textarea=PERMALINK','identica.png','0'),(32,'IndianPad','http://www.indianpad.com/submit.php?url=PERMALINK','indianpad.png','0'),(33,'Internetmedia','http://internetmedia.hu/submit.php?url=PERMALINK','im.png','0'),(34,'Kirtsy','http://www.kirtsy.com/submit.php?url=PERMALINK&amp;title=TITLE','kirtsy.png','0'),(35,'laaik.it','http://laaik.it/NewStoryCompact.aspx?uri=PERMALINK&amp;headline=TITLE&amp;cat=5e082fcc-8a3b-47e2-acec-fdf64ff19d12','laaikit.png','0'),(36,'LinkArena','http://linkarena.com/bookmarks/addlink/?url=PERMALINK&amp;title=TITLE','linkarena.png','0'),(37,'LinkaGoGo','http://www.linkagogo.com/go/AddNoPopup?url=PERMALINK&amp;title=TITLE','linkagogo.png','0'),(38,'LinkedIn','http://www.linkedin.com/shareArticle?mini=true&amp;url=PERMALINK&amp;title=TITLE&amp;source=BLOGNAME&amp;summary=EXCERPT','linkedin.png','0'),(39,'Linkter','http://www.linkter.hu/index.php?action=suggest_link&amp;url=PERMALINK&amp;title=TITLE','linkter.png','0'),(40,'Live','https://favorites.live.com/quickadd.aspx?marklet=1&amp;url=PERMALINK&amp;title=TITLE','live.png','0'),(41,'Meneame','http://meneame.net/submit.php?url=PERMALINK','meneame.png','0'),(42,'MisterWong','http://www.mister-wong.com/addurl/?bm_url=PERMALINK&amp;bm_description=TITLE&amp;plugin=soc','misterwong.png','0'),(43,'MisterWong.DE','http://www.mister-wong.de/addurl/?bm_url=PERMALINK&amp;bm_description=TITLE&amp;plugin=soc','misterwong.png','0'),(44,'Mixx','http://www.mixx.com/submit?page_url=PERMALINK&amp;title=TITLE','mixx.png','0'),(45,'muti','http://www.muti.co.za/submit?url=PERMALINK&amp;title=TITLE','muti.png','0'),(46,'MyShare','http://myshare.url.com.tw/index.php?func=newurl&amp;url=PERMALINK&amp;desc=TITLE','myshare.png','0'),(47,'MySpace','http://www.myspace.com/Modules/PostTo/Pages/?u=PERMALINK&amp;t=TITLE','myspace.png','0'),(48,'MSNReporter','http://reporter.nl.msn.com/?fn=contribute&amp;Title=TITLE&amp;URL=PERMALINK&amp;cat_id=6&amp;tag_id=31&amp;Remark=EXCERPT','msnreporter.png','0'),(49,'N4G','http://www.n4g.com/tips.aspx?url=PERMALINK&amp;title=TITLE','n4g.png','0'),(50,'Netvibes','http://www.netvibes.com/share?title=TITLE&amp;url=PERMALINK','netvibes.png','0'),(51,'NewsVine','http://www.newsvine.com/_tools/seed&amp;save?u=PERMALINK&amp;h=TITLE','newsvine.png','0'),(52,'Netvouz','http://www.netvouz.com/action/submitBookmark?url=PERMALINK&amp;title=TITLE&amp;popup=no','netvouz.png','0'),(53,'NuJIJ','http://nujij.nl/jij.lynkx?t=TITLE&amp;u=PERMALINK&amp;b=EXCERPT','nujij.png','0'),(54,'Ping.fm','http://ping.fm/ref/?link=PERMALINK&amp;title=TITLE&amp;body=EXCERPT','ping.png','0'),(55,'Posterous','http://posterous.com/share?linkto=PERMALINK&amp;title=TITLE&amp;selection=EXCERPT','posterous.png','0'),(56,'PDF','http://www.printfriendly.com/print?url=PERMALINK&amp;partner=sociable','pdf.png','0'),(57,'Print','http://www.printfriendly.com/print?url=PERMALINK&amp;partner=sociable','printfriendly.png','0'),(58,'Propeller','http://www.propeller.com/submit/?url=PERMALINK','propeller.png','0'),(59,'Ratimarks','http://ratimarks.org/bookmarks.php/?action=add&address=PERMALINK&amp;title=TITLE','ratimarks.png','0'),(60,'Rec6','http://rec6.via6.com/link.php?url=PERMALINK&amp;=TITLE','rec6.png','0'),(61,'Reddit','http://reddit.com/submit?url=PERMALINK&amp;title=TITLE','reddit.png','0'),(62,'RSS','FEEDLINK','rss.png','0'),(63,'Scoopeo','http://www.scoopeo.com/scoop/new?newurl=PERMALINK&amp;title=TITLE','scoopeo.png','0'),(64,'Segnalo','http://segnalo.alice.it/post.html.php?url=PERMALINK&amp;title=TITLE','segnalo.png','0'),(65,'Simpy','http://www.simpy.com/simpy/LinkAdd.do?href=PERMALINK&amp;title=TITLE','simpy.png','0'),(66,'Slashdot','http://slashdot.org/bookmark.pl?title=TITLE&amp;url=PERMALINK','slashdot.png','0'),(67,'Socialogs','http://socialogs.com/add_story.php?story_url=PERMALINK&amp;story_title=TITLE','socialogs.png','0'),(68,'SphereIt','http://www.sphere.com/search?q=sphereit:PERMALINK&amp;title=TITLE','sphere.png','0'),(69,'Sphinn','http://sphinn.com/index.php?c=post&amp;m=submit&amp;link=PERMALINK','sphinn.png','0'),(70,'StumbleUpon','http://www.stumbleupon.com/submit?url=PERMALINK&amp;title=TITLE','stumbleupon.png','0'),(71,'Techmeme','http://twitter.com/home/?status=tip%20@Techmeme%20PERMALINK%20TITLE','techmeme.png','0'),(72,'Technorati','http://technorati.com/faves?add=PERMALINK','technorati.png','1'),(73,'ThisNext','http://www.thisnext.com/pick/new/submit/sociable/?url=PERMALINK&amp;name=TITLE','thisnext.png','0'),(74,'Tipd','http://tipd.com/submit.php?url=PERMALINK','tipd.png','0'),(75,'Tumblr','http://www.tumblr.com/share?v=3&amp;u=PERMALINK&amp;t=TITLE&amp;s=EXCERPT','tumblr.png','0'),(76,'Twitter','http://twitter.com/home?status=TITLE%20-%20PERMALINK','twitter.png','1'),(77,'Upnews','http://www.upnews.it/submit?url=PERMALINK&amp;title=TITLE','upnews.png','0'),(78,'Webnews.de','http://www.webnews.de/einstellen?url=PERMALINK&amp;title=TITLE','webnews.png','0'),(79,'Webride','http://webride.org/discuss/split.php?uri=PERMALINK&amp;title=TITLE','webride.png','0'),(80,'Wikio','http://www.wikio.com/vote?url=PERMALINK','wikio.png','0'),(81,'Wikio FR','http://www.wikio.fr/vote?url=PERMALINK','wikio.png','0'),(82,'Wikio IT','http://www.wikio.it/vote?url=PERMALINK','wikio.png','0'),(83,'Wists','http://wists.com/s.php?c=&amp;r=PERMALINK&amp;title=TITLE','wists.png','0'),(84,'Wykop','http://www.wykop.pl/dodaj?url=PERMALINK','wykop.png','0'),(85,'Xerpi','http://www.xerpi.com/block/add_link_from_extension?url=PERMALINK&amp;title=TITLE','xerpi.png','0'),(86,'YahooBuzz','http://buzz.yahoo.com/submit/?submitUrl=PERMALINK&amp;submitHeadline=TITLE&amp;submitSummary=EXCERPT&amp;submitCategory=science&amp;submitAssetType=text','yahoobuzz.png','0'),(87,'Yahoo! Bookmarks','http://bookmarks.yahoo.com/toolbar/savebm?u=PERMALINK&amp;t=TITLE&opener=bm&amp;ei=UTF-8&amp;d=EXCERPT','yahoomyweb.png','0'),(88,'Yigg','http://yigg.de/neu?exturl=PERMALINK&amp;exttitle=TITLE','yiggit.png','0'),(89,'Blogplay','http://blogplay.com','blogplay.png','0');

--
-- Table structure for table `idx_pl_twitter_account`
--

CREATE TABLE `idx_pl_twitter_account` (
  `ck` varchar(255) character set utf8 default NULL,
  `cs` varchar(255) character set utf8 default NULL,
  `at` varchar(255) character set utf8 default NULL,
  `ats` varchar(255) character set utf8 default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_twitter_account`
--

INSERT INTO `idx_pl_twitter_account` VALUES ('Lp7k6189YdxgrSDiaJ0sQ','1SSOoi2diW9Mi7O2AUVOcWflQLMjZV65qLsRLy3NE','https://api.twitter.com/oauth/authorize','https://api.twitter.com/oauth/access_token');

--
-- 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 AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_plugin` VALUES (1,'Sociable','sociable/sociable.php','1',NULL),(2,'AutoTweet','twitter_auto_tweet/twitter_auto_tweet.php','1',NULL);

--
-- 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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_review` VALUES (1,153,'Microsoft word files viewed less than ideal, I try to use this software,covert it to flash, flip effect is very good, This software is useful to me.\r\n',5,'2011-10-11','covert useful','0','','bobby','dogoly@gmail.com');

--
-- 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 ('www.soundandvision.co.uk','2011-08-19 15:14:51',1,'90.195.93.25'),('www.soundandvision.co.uk','2011-08-19 17:43:03',1,'90.195.93.196'),('www.soundandvision.co.uk','2011-08-19 18:13:25',1,'90.195.93.196'),('diri.ee','2011-08-25 03:47:43',1,'81.164.219.114'),('www.soundandvision.co.uk','2011-09-04 17:39:41',1,'91.228.1.168'),('www.soundandvision.co.uk','2011-09-05 04:13:59',1,'90.195.167.88'),('sokobanja','2011-09-09 16:14:54',1,'93.86.137.162'),('www.onitaly.com','2011-10-05 16:26:40',1,'109.169.76.177'),('Gel Nails','2011-10-05 21:49:53',0,'68.63.149.165'),('Gel Nails','2011-10-06 13:44:22',0,'68.63.149.165'),('www.love-calculator.me','2011-10-06 18:04:46',1,'67.71.20.12'),('dadons-laserdiscs.com','2011-10-09 02:16:27',0,'67.160.34.96'),('cruisesfromsouthampton.co.uk','2011-10-13 06:23:54',1,'94.173.149.157'),('cruisesfromsouthampton.co.uk','2011-10-13 08:09:18',1,'94.173.149.157'),('cruisesfromsouthampton.co.uk','2011-10-13 09:12:44',1,'94.173.149.157'),('cruisesfromsouthampton.co.uk','2011-10-17 07:49:24',1,'94.173.149.157'),('honeymoon','2011-10-17 15:19:02',1,'79.101.247.51'),('honeymoon','2011-10-17 15:19:33',1,'79.101.247.51'),('www.aseolinkbuildingservices.co.uk','2011-10-22 01:49:13',1,'94.173.149.157'),('www.aseolinkbuildingservices.co.uk','2011-10-23 11:03:52',2,'94.173.149.157'),('mobilephonedeals.me.uk','2011-10-25 06:03:39',1,'174.37.196.178'),('mobilephonedeals.me.uk','2011-10-25 06:33:43',1,'174.37.196.178'),('slabescnatural.ro','2011-10-26 06:40:38',1,'92.85.47.168'),('seo-optimiert.net','2011-11-04 11:23:52',1,'82.195.232.218'),('www.restaurant-allegro.ro','2011-11-22 08:03:54',1,'89.43.124.78'),('digitpet','2011-11-23 02:27:53',1,'203.92.47.195'),('cheap watches','2011-12-01 18:36:58',1,'66.206.4.78'),('www.best-greece-escorts.com','2011-12-04 20:32:06',1,'79.114.15.219'),('www.best-greece-escorts.com','2011-12-05 07:38:57',1,'79.114.15.219'),('www.greece-escorts-directory.com','2011-12-05 17:00:17',1,'79.114.15.219'),('www.greece-escorts-directory.com','2011-12-05 20:20:56',1,'79.114.15.219'),('www.escort-lon.com','2011-12-10 15:45:08',0,'94.112.36.224'),('www.fast-help.de','2011-12-13 13:25:05',0,'87.185.112.221'),('www.fast-help.de','2011-12-13 13:25:08',0,'87.185.112.221'),('Sports packages','2011-12-24 05:26:00',1,'188.2.172.211'),('debt','2012-01-05 22:32:57',9,'108.27.246.111'),('cruisesfromsouthampton.co.uk','2012-01-09 10:50:50',0,'94.173.142.179'),('cruisesfromsouthampton.co.uk','2012-01-09 14:16:49',0,'94.173.142.179'),('cruisesfromsouthampton.co.uk','2012-01-11 06:45:02',0,'94.173.142.179'),('top us casino','2012-01-24 02:27:02',0,'122.180.24.219'),('www.syncback4all.com','2012-02-02 02:51:25',0,'114.112.44.6'),('www.syncback4all.com','2012-02-02 02:51:29',0,'114.112.44.6'),('weathering steel','2012-02-17 03:20:30',1,'203.129.209.101'),('weathering steel','2012-02-17 03:23:51',1,'150.70.75.37'),('liyela.com','2012-02-20 21:45:15',0,'87.185.157.117'),('liyela.com','2012-02-20 21:45:18',0,'87.185.157.117'),('Google optimizacija','2012-03-01 14:59:55',1,'178.223.62.204'),('http://www.adcoheatingandair.com','2012-03-06 23:39:22',1,'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','bizprimary.com'),(5,'site_url','http://bizprimary.com'),(6,'email_address','bizprimary@hotmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/bizprima/public_html/themes/'),(9,'admin_template_path','/home/bizprima/public_html/admin_tpl/'),(10,'plugin_path','/home/bizprima/public_html/plugin/'),(12,'active_theme','bizprimary'),(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 (153,'121.228.113.163',5),(153,'221.225.255.121',5);


