--
-- Host: bizonlinelisting.com    Database: bizonlin_bizonlin
-- ------------------------------------------------------


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

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

INSERT INTO `idx_favorites` VALUES (1,'blakejeromyg30l87','2011-10-18','My Favorites',NULL),(2,'josiahjeffera64j59','2011-10-19','My Favorites',NULL),(3,'harveyandersr37v34','2011-10-31','My Favorites',NULL),(4,'edwardohansi51t58','2011-11-01','My Favorites',NULL),(5,'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`
--

INSERT INTO `idx_mailing_list` VALUES ('vwpwes@tojtxj.com','6385','0');

--
-- 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 (2,'g',6,'2011-09-11'),(6,'g',4,'2011-09-11'),(1,'g',0,'2011-12-18'),(3,'g',5,'2011-09-12'),(4,'g',4,'2011-09-12'),(11,'g',4,'2011-09-12'),(8,'g',4,'2011-09-12'),(7,'g',4,'2011-09-12'),(10,'g',3,'2011-09-12'),(12,'g',4,'2011-09-12'),(9,'g',4,'2011-09-12'),(41,'g',2,'2011-09-17'),(42,'g',2,'2011-09-17'),(35,'g',6,'2011-09-17'),(39,'g',2,'2011-09-17'),(37,'g',2,'2011-09-17'),(40,'g',2,'2011-09-17'),(13,'g',4,'2011-09-20'),(16,'g',4,'2011-09-20'),(15,'g',4,'2011-09-20'),(51,'g',0,'2011-12-31'),(108,'g',3,'2011-09-22'),(107,'g',3,'2011-09-23'),(112,'g',0,'2012-02-06'),(119,'g',0,'2012-01-17'),(125,'g',0,'2012-02-14'),(115,'g',0,'2012-01-23'),(121,'g',0,'2011-11-23'),(120,'g',0,'2012-01-09'),(122,'g',0,'2012-02-13'),(127,'g',0,'2012-02-26'),(134,'g',0,'2012-01-09'),(116,'g',0,'2012-01-18'),(129,'g',0,'2012-01-15'),(118,'g',0,'2012-01-09'),(111,'g',0,'2012-01-09'),(110,'g',0,'2012-01-09'),(132,'g',0,'2012-02-15'),(123,'g',0,'2012-01-17'),(126,'g',0,'2012-01-17'),(147,'g',0,'2012-01-22'),(135,'g',0,'2012-02-15'),(138,'g',0,'2012-01-09'),(137,'g',0,'2012-01-09'),(140,'g',0,'2012-01-09'),(158,'g',0,'2011-10-17'),(148,'g',0,'2011-10-18'),(141,'g',0,'2011-10-18'),(144,'g',0,'2011-10-18'),(146,'g',0,'2011-10-18'),(133,'g',0,'2012-01-07'),(163,'g',0,'2012-02-13'),(151,'g',0,'2012-02-07'),(155,'g',0,'2012-01-07'),(156,'g',0,'2012-01-09'),(162,'g',0,'2012-02-13'),(240,'g',0,'2011-10-24'),(332,'g',0,'2011-12-24'),(335,'g',0,'2011-10-24'),(187,'g',0,'2011-10-24'),(259,'g',0,'2011-10-24'),(318,'g',0,'2011-10-24'),(273,'g',0,'2012-02-15'),(286,'g',0,'2011-10-24'),(204,'g',0,'2011-12-07'),(183,'g',0,'2011-12-07'),(173,'g',0,'2011-12-07'),(223,'g',0,'2011-12-07'),(175,'g',0,'2011-12-07'),(221,'g',0,'2011-12-07'),(195,'g',0,'2011-12-07'),(217,'g',0,'2011-12-07'),(142,'g',0,'2012-02-15'),(136,'g',0,'2011-10-25'),(336,'g',0,'2012-01-18'),(225,'g',0,'2011-10-25'),(242,'g',0,'2011-12-18'),(327,'g',0,'2011-10-25'),(182,'g',0,'2011-10-25'),(308,'g',0,'2011-10-25'),(159,'g',0,'2011-10-26'),(208,'g',0,'2011-12-07'),(205,'g',0,'2011-10-26'),(174,'g',0,'2011-10-26'),(202,'g',0,'2011-10-26'),(169,'g',0,'2011-12-04'),(222,'g',0,'2011-12-04'),(218,'g',0,'2012-03-02'),(167,'g',0,'2011-10-28'),(145,'g',0,'2011-10-28'),(161,'g',0,'2012-02-15'),(143,'g',0,'2011-12-22'),(216,'g',0,'2011-10-28'),(179,'g',0,'2011-12-22'),(281,'g',0,'2011-10-29'),(261,'g',0,'2012-02-15'),(190,'g',0,'2011-10-29'),(230,'g',0,'2011-10-29'),(188,'g',0,'2011-10-29'),(206,'g',0,'2012-01-07'),(353,'g',0,'2012-02-15'),(196,'g',0,'2011-10-29'),(263,'g',0,'2011-10-29'),(165,'g',0,'2011-10-29'),(228,'g',0,'2011-10-29'),(172,'g',0,'2011-10-29'),(139,'g',0,'2012-02-15'),(124,'g',0,'2012-02-13'),(229,'g',0,'2011-10-29'),(185,'g',0,'2011-10-29'),(177,'g',0,'2011-10-29'),(214,'g',0,'2011-10-29'),(250,'g',0,'2011-10-29'),(211,'g',0,'2011-11-03'),(189,'g',0,'2011-11-03'),(191,'g',0,'2011-11-03'),(178,'g',0,'2011-11-03'),(197,'g',0,'2011-11-03'),(171,'g',0,'2011-12-19'),(186,'g',0,'2011-12-19'),(213,'g',0,'2011-11-03'),(152,'g',0,'2012-02-13'),(355,'g',0,'2011-12-30'),(325,'g',0,'2011-12-15'),(279,'g',0,'2011-12-14'),(194,'g',0,'2011-11-03'),(304,'g',0,'2011-12-15'),(180,'g',0,'2011-11-03'),(255,'g',0,'2011-12-15'),(113,'g',0,'2011-11-03'),(181,'g',0,'2011-11-03'),(220,'g',0,'2011-11-03'),(198,'g',0,'2011-12-19'),(153,'g',0,'2012-02-15'),(238,'g',0,'2011-12-15'),(154,'g',0,'2012-02-13'),(176,'g',0,'2011-11-04'),(150,'g',0,'2012-02-13'),(339,'g',0,'2012-02-29'),(298,'g',0,'2011-12-15'),(199,'g',0,'2011-11-04'),(241,'g',0,'2012-02-15'),(338,'g',0,'2012-02-15'),(319,'g',0,'2011-12-15'),(192,'g',0,'2011-11-05'),(193,'g',0,'2011-12-09'),(290,'g',0,'2011-12-09'),(203,'g',0,'2011-12-09'),(215,'g',0,'2012-02-15'),(303,'g',0,'2011-12-09'),(200,'g',0,'2011-11-07'),(168,'g',0,'2011-12-09'),(252,'g',0,'2011-12-09'),(235,'g',0,'2011-12-16'),(359,'g',0,'2011-11-09'),(342,'g',0,'2012-01-09'),(373,'g',0,'2011-11-14'),(426,'g',0,'2011-11-14'),(429,'g',0,'2011-11-14'),(530,'g',0,'2011-11-14'),(368,'g',0,'2011-11-14'),(367,'g',0,'2011-11-14'),(370,'g',0,'2011-11-14'),(425,'g',0,'2011-11-14'),(430,'g',0,'2011-11-14'),(344,'g',0,'2012-02-13'),(479,'g',0,'2011-11-16'),(386,'g',0,'2011-11-16'),(542,'g',0,'2011-11-16'),(428,'g',0,'2011-11-16'),(481,'g',0,'2011-11-16'),(483,'g',0,'2011-11-16'),(441,'g',0,'2011-11-16'),(543,'g',0,'2011-11-16'),(626,'g',0,'2011-11-16'),(511,'g',0,'2011-11-16'),(642,'g',0,'2011-11-16'),(674,'g',0,'2011-11-16'),(473,'g',0,'2011-11-16'),(347,'g',0,'2011-11-16'),(380,'g',0,'2011-11-16'),(471,'g',0,'2011-11-17'),(379,'g',0,'2011-11-17'),(375,'g',0,'2011-11-17'),(463,'g',0,'2011-11-17'),(505,'g',0,'2011-11-17'),(476,'g',0,'2011-11-17'),(352,'g',0,'2011-11-17'),(493,'g',0,'2011-11-17'),(477,'g',0,'2011-11-17'),(648,'g',0,'2011-11-17'),(640,'g',0,'2011-11-17'),(639,'g',0,'2011-11-17'),(442,'g',0,'2011-11-17'),(495,'g',0,'2011-11-17'),(605,'g',0,'2011-11-17'),(492,'g',0,'2011-11-18'),(655,'g',0,'2011-11-18'),(378,'g',0,'2011-11-20'),(360,'g',0,'2011-11-20'),(376,'g',0,'2011-11-20'),(361,'g',0,'2011-11-20'),(427,'g',0,'2011-11-20'),(387,'g',0,'2011-11-20'),(550,'g',0,'2011-11-20'),(381,'g',0,'2011-11-20'),(362,'g',0,'2011-11-21'),(458,'g',0,'2011-11-21'),(464,'g',0,'2011-11-21'),(627,'g',0,'2011-11-21'),(621,'g',0,'2011-11-21'),(672,'g',0,'2011-11-22'),(662,'g',0,'2011-11-22'),(518,'g',0,'2011-11-23'),(617,'g',0,'2011-11-23'),(622,'g',0,'2011-12-26'),(606,'g',0,'2011-12-26'),(602,'g',0,'2011-12-30'),(439,'g',0,'2011-12-30'),(491,'g',0,'2011-11-23'),(641,'g',0,'2011-11-23'),(633,'g',0,'2011-11-25'),(470,'g',0,'2011-11-25'),(856,'g',0,'2011-11-28'),(906,'g',0,'2011-11-28'),(908,'g',0,'2011-11-28'),(1004,'g',0,'2011-11-28'),(1219,'g',0,'2012-02-13'),(714,'g',0,'2011-11-29'),(792,'g',0,'2011-11-29'),(607,'g',0,'2011-11-29'),(444,'g',0,'2011-11-29'),(1294,'g',0,'2012-02-15'),(388,'g',0,'2011-11-30'),(923,'g',0,'2011-12-01'),(1077,'g',0,'2012-02-15'),(551,'g',0,'2011-12-01'),(467,'g',0,'2011-12-03'),(630,'g',0,'2011-12-03'),(899,'g',0,'2011-12-03'),(974,'g',0,'2011-12-03'),(822,'g',0,'2011-12-03'),(1407,'g',0,'2012-02-13'),(768,'g',0,'2011-12-04'),(767,'g',0,'2011-12-05'),(765,'g',0,'2011-12-05'),(766,'g',0,'2011-12-05'),(1147,'g',0,'2011-12-05'),(926,'g',0,'2011-12-06'),(814,'g',0,'2011-12-06'),(784,'g',0,'2011-12-06'),(1006,'g',0,'2011-12-06'),(1177,'g',0,'2011-12-06'),(1297,'g',0,'2011-12-06'),(942,'g',0,'2011-12-06'),(936,'g',0,'2011-12-06'),(806,'g',0,'2011-12-07'),(896,'g',0,'2011-12-07'),(712,'g',0,'2011-12-07'),(882,'g',0,'2011-12-07'),(931,'g',0,'2011-12-07'),(838,'g',0,'2011-12-07'),(940,'g',0,'2011-12-07'),(789,'g',0,'2011-12-07'),(201,'g',0,'2011-12-07'),(1378,'g',0,'2011-12-07'),(1188,'g',0,'2011-12-07'),(1005,'g',0,'2011-12-07'),(825,'g',0,'2011-12-08'),(877,'g',0,'2011-12-08'),(836,'g',0,'2011-12-09'),(854,'g',0,'2011-12-09'),(938,'g',0,'2011-12-09'),(844,'g',0,'2011-12-09'),(964,'g',0,'2011-12-09'),(890,'g',0,'2011-12-10'),(867,'g',0,'2011-12-10'),(878,'g',0,'2011-12-10'),(810,'g',0,'2011-12-13'),(791,'g',0,'2011-12-13'),(1154,'g',0,'2012-02-15'),(897,'g',0,'2011-12-13'),(1173,'g',0,'2012-02-13'),(1030,'g',0,'2011-12-13'),(862,'g',0,'2011-12-14'),(499,'g',0,'2011-12-14'),(618,'g',0,'2011-12-14'),(549,'g',0,'2011-12-15'),(930,'g',0,'2011-12-15'),(1014,'g',0,'2011-12-15'),(226,'g',0,'2011-12-15'),(863,'g',0,'2011-12-15'),(1095,'g',0,'2012-02-13'),(786,'g',0,'2011-12-16'),(1149,'g',0,'2011-12-16'),(1381,'g',0,'2011-12-16'),(952,'g',0,'2011-12-16'),(1038,'g',0,'2011-12-16'),(272,'g',0,'2011-12-16'),(681,'g',0,'2011-12-16'),(961,'g',0,'2011-12-16'),(1060,'g',0,'2012-02-15'),(983,'g',0,'2011-12-16'),(310,'g',0,'2011-12-18'),(317,'g',0,'2011-12-18'),(313,'g',0,'2011-12-18'),(328,'g',0,'2011-12-18'),(340,'g',0,'2011-12-18'),(246,'g',0,'2011-12-18'),(257,'g',0,'2011-12-18'),(307,'g',0,'2011-12-18'),(270,'g',0,'2011-12-18'),(266,'g',0,'2011-12-18'),(264,'g',0,'2011-12-18'),(292,'g',0,'2011-12-18'),(237,'g',0,'2011-12-18'),(295,'g',0,'2011-12-18'),(227,'g',0,'2011-12-18'),(297,'g',0,'2011-12-18'),(282,'g',0,'2011-12-18'),(231,'g',0,'2011-12-18'),(170,'g',0,'2011-12-18'),(509,'g',0,'2011-12-19'),(315,'g',0,'2011-12-20'),(326,'g',0,'2011-12-20'),(420,'g',0,'2011-12-20'),(305,'g',0,'2011-12-20'),(306,'g',0,'2011-12-20'),(296,'g',0,'2011-12-20'),(384,'g',0,'2011-12-20'),(357,'g',0,'2011-12-20'),(358,'g',0,'2012-03-02'),(364,'g',0,'2011-12-20'),(239,'g',0,'2011-12-20'),(291,'g',0,'2011-12-20'),(280,'g',0,'2011-12-20'),(258,'g',0,'2011-12-20'),(268,'g',0,'2011-12-20'),(149,'g',0,'2012-03-02'),(164,'g',0,'2011-12-20'),(234,'g',0,'2012-03-02'),(254,'g',0,'2011-12-20'),(1739,'g',0,'2011-12-21'),(1520,'g',0,'2011-12-21'),(1921,'g',0,'2011-12-23'),(1720,'g',0,'2011-12-23'),(1940,'g',0,'2011-12-23'),(2157,'g',0,'2011-12-23'),(1702,'g',0,'2011-12-23'),(1937,'g',0,'2011-12-23'),(2141,'g',0,'2011-12-23'),(1719,'g',0,'2011-12-24'),(1788,'g',0,'2011-12-24'),(1569,'g',0,'2011-12-24'),(1690,'g',0,'2011-12-24'),(443,'g',0,'2011-12-26'),(459,'g',0,'2011-12-26'),(1808,'g',0,'2011-12-27'),(1155,'g',0,'2012-02-13'),(2028,'g',0,'2011-12-27'),(2154,'g',0,'2011-12-27'),(1951,'g',0,'2011-12-27'),(1731,'g',0,'2011-12-27'),(2601,'g',0,'2011-12-28'),(1915,'g',0,'2011-12-29'),(2451,'g',0,'2011-12-29'),(2577,'g',0,'2011-12-29'),(1528,'g',0,'2011-12-29'),(1423,'g',0,'2011-12-29'),(1396,'g',0,'2011-12-29'),(1400,'g',0,'2011-12-29'),(1402,'g',0,'2011-12-29'),(1399,'g',0,'2011-12-29'),(1410,'g',0,'2011-12-29'),(1421,'g',0,'2011-12-29'),(1411,'g',0,'2011-12-29'),(1466,'g',0,'2011-12-29'),(2592,'g',0,'2011-12-29'),(2634,'g',0,'2011-12-29'),(2565,'g',0,'2011-12-29'),(2606,'g',0,'2011-12-29'),(1904,'g',0,'2011-12-29'),(2008,'g',0,'2011-12-29'),(2368,'g',0,'2011-12-29'),(2149,'g',0,'2011-12-29'),(2369,'g',0,'2011-12-29'),(2373,'g',0,'2011-12-29'),(2449,'g',0,'2011-12-29'),(2228,'g',0,'2011-12-29'),(2379,'g',0,'2011-12-29'),(2159,'g',0,'2011-12-29'),(1698,'g',0,'2011-12-29'),(2683,'g',0,'2011-12-29'),(3602,'g',0,'2011-12-29'),(2828,'g',0,'2011-12-29'),(3335,'g',0,'2011-12-29'),(2374,'g',0,'2011-12-29'),(3070,'g',0,'2011-12-29'),(2595,'g',0,'2011-12-29'),(2777,'g',0,'2011-12-30'),(1933,'g',0,'2011-12-30'),(1928,'g',0,'2011-12-30'),(2342,'g',0,'2011-12-30'),(1956,'g',0,'2011-12-30'),(1710,'g',0,'2011-12-30'),(1929,'g',0,'2011-12-30'),(2227,'g',0,'2011-12-30'),(2328,'g',0,'2011-12-30'),(2858,'g',0,'2011-12-30'),(2234,'g',0,'2011-12-30'),(2594,'g',0,'2011-12-30'),(2224,'g',0,'2011-12-30'),(2136,'g',0,'2011-12-30'),(1957,'g',0,'2011-12-30'),(2839,'g',0,'2011-12-30'),(2801,'g',0,'2011-12-30'),(2162,'g',0,'2011-12-30'),(3661,'g',0,'2011-12-30'),(2802,'g',0,'2011-12-30'),(2358,'g',0,'2011-12-30'),(3017,'g',0,'2011-12-30'),(2356,'g',0,'2011-12-30'),(2399,'g',0,'2011-12-30'),(2947,'g',0,'2011-12-30'),(1712,'g',0,'2011-12-30'),(2445,'g',0,'2011-12-30'),(2357,'g',0,'2011-12-30'),(2576,'g',0,'2011-12-30'),(2827,'g',0,'2011-12-30'),(1722,'g',0,'2011-12-30'),(1699,'g',0,'2011-12-30'),(2355,'g',0,'2011-12-30'),(2230,'g',0,'2011-12-30'),(2448,'g',0,'2011-12-30'),(2549,'g',0,'2011-12-30'),(2684,'g',0,'2011-12-30'),(2122,'g',0,'2011-12-30'),(2590,'g',0,'2011-12-30'),(2177,'g',0,'2011-12-30'),(2349,'g',0,'2011-12-30'),(1784,'g',0,'2011-12-30'),(2176,'g',0,'2011-12-30'),(2791,'g',0,'2011-12-30'),(2455,'g',0,'2011-12-30'),(1517,'g',0,'2011-12-30'),(2578,'g',0,'2011-12-30'),(2398,'g',0,'2011-12-30'),(1736,'g',0,'2011-12-30'),(1745,'g',0,'2011-12-30'),(2589,'g',0,'2011-12-30'),(2129,'g',0,'2011-12-30'),(1737,'g',0,'2011-12-30'),(2406,'g',0,'2011-12-30'),(2383,'g',0,'2011-12-30'),(2371,'g',0,'2011-12-30'),(2344,'g',0,'2011-12-30'),(2397,'g',0,'2011-12-30'),(1790,'g',0,'2011-12-30'),(2579,'g',0,'2011-12-30'),(1939,'g',0,'2011-12-30'),(1909,'g',0,'2011-12-30'),(1787,'g',0,'2011-12-30'),(2602,'g',0,'2011-12-30'),(2148,'g',0,'2011-12-30'),(2014,'g',0,'2011-12-30'),(2185,'g',0,'2011-12-30'),(2570,'g',0,'2011-12-30'),(2151,'g',0,'2011-12-30'),(2138,'g',0,'2011-12-30'),(1709,'g',0,'2011-12-30'),(2563,'g',0,'2011-12-30'),(2627,'g',0,'2011-12-30'),(1518,'g',0,'2011-12-30'),(2137,'g',0,'2011-12-30'),(2456,'g',0,'2011-12-30'),(2153,'g',0,'2011-12-30'),(2135,'g',0,'2011-12-30'),(2108,'g',0,'2011-12-30'),(3026,'g',0,'2011-12-30'),(2823,'g',0,'2011-12-31'),(2933,'g',0,'2011-12-31'),(3016,'g',0,'2011-12-31'),(1669,'g',0,'2011-12-31'),(3112,'g',0,'2011-12-31'),(2010,'g',0,'2011-12-31'),(1576,'g',0,'2011-12-31'),(1916,'g',0,'2011-12-31'),(1795,'g',0,'2011-12-31'),(2613,'g',0,'2011-12-31'),(3078,'g',0,'2011-12-31'),(1918,'g',0,'2011-12-31'),(2124,'g',0,'2011-12-31'),(3076,'g',0,'2011-12-31'),(2834,'g',0,'2011-12-31'),(2918,'g',0,'2011-12-31'),(3106,'g',0,'2011-12-31'),(3039,'g',0,'2011-12-31'),(3183,'g',0,'2011-12-31'),(2798,'g',0,'2011-12-31'),(2677,'g',0,'2011-12-31'),(2544,'g',0,'2011-12-31'),(2144,'g',0,'2012-01-01'),(2359,'g',0,'2012-01-01'),(3013,'g',0,'2012-01-01'),(2365,'g',0,'2012-01-01'),(3370,'g',0,'2012-01-01'),(2364,'g',0,'2012-01-01'),(2772,'g',0,'2012-01-01'),(2547,'g',0,'2012-01-01'),(2557,'g',0,'2012-01-01'),(3093,'g',0,'2012-01-01'),(3105,'g',0,'2012-01-01'),(2187,'g',0,'2012-01-01'),(2168,'g',0,'2012-01-01'),(1942,'g',0,'2012-01-01'),(2472,'g',0,'2012-01-01'),(3014,'g',0,'2012-01-01'),(2941,'g',0,'2012-01-01'),(1965,'g',0,'2012-01-01'),(2696,'g',0,'2012-01-01'),(3101,'g',0,'2012-01-01'),(2937,'g',0,'2012-01-01'),(2850,'g',0,'2012-01-01'),(1075,'g',0,'2012-01-02'),(1201,'g',0,'2012-01-02'),(1489,'g',0,'2012-01-02'),(1470,'g',0,'2012-01-02'),(1302,'g',0,'2012-01-02'),(1343,'g',0,'2012-01-02'),(1245,'g',0,'2012-01-02'),(3579,'g',0,'2012-02-01'),(1266,'g',0,'2012-02-01'),(1416,'g',0,'2012-02-01'),(1473,'g',0,'2012-02-01'),(1478,'g',0,'2012-02-01'),(3401,'g',0,'2012-01-02'),(3393,'g',0,'2012-01-02'),(3601,'g',0,'2012-01-02'),(3657,'g',0,'2012-01-02'),(1120,'g',0,'2012-01-02'),(1057,'g',0,'2012-02-06'),(1269,'g',0,'2012-02-15'),(1062,'g',0,'2012-02-15'),(1059,'g',0,'2012-02-06'),(1116,'g',0,'2012-02-13'),(1056,'g',0,'2012-02-15'),(1117,'g',0,'2012-02-06'),(3564,'g',0,'2012-01-03'),(3634,'g',0,'2012-01-03'),(3546,'g',0,'2012-01-03'),(3473,'g',0,'2012-01-03'),(3469,'g',0,'2012-01-03'),(3620,'g',0,'2012-01-03'),(3470,'g',0,'2012-01-03'),(3561,'g',0,'2012-02-15'),(3456,'g',0,'2012-01-03'),(1279,'g',0,'2012-02-13'),(1278,'g',0,'2012-02-13'),(1377,'g',0,'2012-02-16'),(1313,'g',0,'2012-02-13'),(1276,'g',0,'2012-02-15'),(1485,'g',0,'2012-02-13'),(3683,'g',0,'2012-01-03'),(3740,'g',0,'2012-01-03'),(1350,'g',0,'2012-02-15'),(3741,'g',0,'2012-01-04'),(1309,'g',0,'2012-02-13'),(3684,'g',0,'2012-01-04'),(1240,'g',0,'2012-02-15'),(1335,'g',0,'2012-01-04'),(1199,'g',0,'2012-02-13'),(1217,'g',0,'2012-02-13'),(1207,'g',0,'2012-02-15'),(3610,'g',0,'2012-01-04'),(3589,'g',0,'2012-01-04'),(3797,'g',0,'2012-01-04'),(3606,'g',0,'2012-01-04'),(3765,'g',0,'2012-01-04'),(3708,'g',0,'2012-01-04'),(3656,'g',0,'2012-02-13'),(3664,'g',0,'2012-01-05'),(3759,'g',0,'2012-01-05'),(1061,'g',0,'2012-01-05'),(1133,'g',0,'2012-01-05'),(348,'g',0,'2012-01-05'),(1113,'g',0,'2012-01-05'),(243,'g',0,'2012-01-05'),(3450,'g',0,'2012-01-05'),(3608,'g',0,'2012-01-05'),(3571,'g',0,'2012-01-05'),(3640,'g',0,'2012-01-05'),(269,'g',0,'2012-01-05'),(3702,'g',0,'2012-01-05'),(354,'g',0,'2012-01-05'),(3798,'g',0,'2012-01-05'),(3857,'g',0,'2012-01-05'),(3912,'g',0,'2012-01-05'),(4001,'g',0,'2012-01-07'),(1152,'g',0,'2012-02-08'),(1263,'g',0,'2012-02-09'),(1125,'g',0,'2012-02-15'),(1226,'g',0,'2012-02-15'),(1225,'g',0,'2012-02-16'),(341,'g',0,'2012-02-13'),(3935,'g',0,'2012-01-07'),(1185,'g',0,'2012-01-07'),(346,'g',0,'2012-01-07'),(1404,'g',0,'2012-01-07'),(1409,'g',0,'2012-01-07'),(267,'g',0,'2012-01-07'),(275,'g',0,'2012-01-07'),(1139,'g',0,'2012-01-07'),(1112,'g',0,'2012-01-07'),(1200,'g',0,'2012-01-07'),(1166,'g',0,'2012-01-07'),(1072,'g',0,'2012-01-07'),(1186,'g',0,'2012-01-07'),(1221,'g',0,'2012-01-07'),(1382,'g',0,'2012-01-08'),(3690,'g',0,'2012-01-08'),(3863,'g',0,'2012-01-08'),(3804,'g',0,'2012-01-08'),(3942,'g',0,'2012-01-08'),(3747,'g',0,'2012-01-08'),(1205,'g',0,'2012-01-08'),(1203,'g',0,'2012-02-13'),(1191,'g',0,'2012-02-15'),(1151,'g',0,'2012-02-16'),(1119,'g',0,'2012-02-15'),(1157,'g',0,'2012-02-13'),(1174,'g',0,'2012-02-15'),(1064,'g',0,'2012-02-15'),(1268,'g',0,'2012-01-09'),(1181,'g',0,'2012-01-09'),(1208,'g',0,'2012-01-09'),(3663,'g',0,'2012-01-09'),(1167,'g',0,'2012-01-09'),(1054,'g',0,'2012-02-08'),(157,'g',0,'2012-01-09'),(117,'g',0,'2012-01-09'),(251,'g',0,'2012-02-13'),(343,'g',0,'2012-02-13'),(1074,'g',0,'2012-02-13'),(1079,'g',0,'2012-02-13'),(3662,'g',0,'2012-02-13'),(4055,'g',0,'2012-01-10'),(1063,'g',0,'2012-02-15'),(4175,'g',0,'2012-01-10'),(4240,'g',0,'2012-01-11'),(4119,'g',0,'2012-01-11'),(1053,'g',0,'2012-03-02'),(1241,'g',0,'2012-03-03'),(1230,'g',0,'2012-01-11'),(4031,'g',0,'2012-01-11'),(1362,'g',0,'2012-01-11'),(1488,'g',0,'2012-03-03'),(4032,'g',0,'2012-01-11'),(1429,'g',0,'2012-03-03'),(1253,'g',0,'2012-03-03'),(1073,'g',0,'2012-03-02'),(1383,'g',0,'2012-01-11'),(4150,'g',0,'2012-01-11'),(4030,'g',0,'2012-01-11'),(4089,'g',0,'2012-01-11'),(1345,'g',0,'2012-01-11'),(4260,'g',0,'2012-01-11'),(4391,'g',0,'2012-01-11'),(4306,'g',0,'2012-01-11'),(1170,'g',0,'2012-02-13'),(1096,'g',0,'2012-02-13'),(1183,'g',0,'2012-02-13'),(1055,'g',0,'2012-01-12'),(4364,'g',0,'2012-01-12'),(350,'g',0,'2012-02-15'),(1252,'g',0,'2012-02-16'),(1171,'g',0,'2012-02-13'),(3665,'g',0,'2012-03-03'),(1121,'g',0,'2012-01-12'),(1184,'g',0,'2012-01-12'),(1231,'g',0,'2012-01-12'),(1160,'g',0,'2012-03-03'),(1145,'g',0,'2012-03-03'),(1212,'g',0,'2012-01-12'),(4271,'g',0,'2012-01-12'),(4034,'g',0,'2012-01-12'),(4216,'g',0,'2012-01-12'),(4269,'g',0,'2012-01-12'),(4143,'g',0,'2012-01-12'),(4282,'g',0,'2012-01-12'),(4095,'g',0,'2012-01-12'),(4154,'g',0,'2012-01-12'),(4023,'g',0,'2012-01-12'),(4211,'g',0,'2012-01-12'),(1182,'g',0,'2012-02-13'),(1069,'g',0,'2012-02-13'),(1068,'g',0,'2012-02-16'),(1197,'g',0,'2012-02-13'),(1168,'g',0,'2012-02-13'),(1189,'g',0,'2012-02-16'),(1195,'g',0,'2012-02-15'),(4437,'g',0,'2012-01-14'),(1220,'g',0,'2012-01-14'),(1209,'g',0,'2012-01-14'),(1305,'g',0,'2012-01-14'),(1196,'g',0,'2012-01-14'),(1236,'g',0,'2012-01-14'),(1325,'g',0,'2012-01-14'),(1223,'g',0,'2012-01-14'),(1341,'g',0,'2012-01-14'),(1321,'g',0,'2012-01-14'),(1194,'g',0,'2012-01-14'),(4408,'g',0,'2012-01-15'),(4479,'g',0,'2012-01-15'),(1134,'g',0,'2012-01-15'),(1131,'g',0,'2012-02-15'),(1128,'g',0,'2012-01-15'),(1130,'g',0,'2012-01-15'),(1135,'g',0,'2012-02-15'),(1137,'g',0,'2012-02-15'),(1129,'g',0,'2012-01-15'),(1132,'g',0,'2012-02-15'),(1070,'g',0,'2012-01-15'),(1179,'g',0,'2012-02-15'),(1247,'g',0,'2012-01-15'),(1067,'g',0,'2012-01-15'),(1246,'g',0,'2012-01-15'),(1065,'g',0,'2012-01-15'),(1118,'g',0,'2012-01-15'),(1071,'g',0,'2012-02-15'),(1158,'g',0,'2012-02-16'),(1244,'g',0,'2012-02-15'),(4503,'g',0,'2012-01-15'),(4471,'g',0,'2012-01-16'),(4409,'g',0,'2012-01-16'),(4466,'g',0,'2012-03-03'),(4455,'g',0,'2012-01-17'),(1110,'g',0,'2012-01-18'),(1227,'g',0,'2012-01-18'),(356,'g',0,'2012-01-21'),(351,'g',0,'2012-01-22'),(3666,'g',0,'2012-01-22'),(349,'g',0,'2012-01-22'),(345,'g',0,'2012-01-22'),(4585,'g',0,'2012-01-27'),(4481,'g',0,'2012-01-28'),(4429,'g',0,'2012-01-28'),(1172,'g',0,'2012-01-30'),(1144,'g',0,'2012-01-30'),(1229,'g',0,'2012-01-30'),(1138,'g',0,'2012-01-30'),(1140,'g',0,'2012-01-30'),(1143,'g',0,'2012-01-30'),(1178,'g',0,'2012-01-30'),(1210,'g',0,'2012-01-30'),(4431,'g',0,'2012-01-30'),(1142,'g',0,'2012-01-30'),(4582,'g',0,'2012-01-30'),(1480,'g',0,'2012-02-01'),(4586,'g',0,'2012-02-01'),(1472,'g',0,'2012-02-01'),(1340,'g',0,'2012-02-01'),(1076,'g',0,'2012-02-01'),(4638,'g',0,'2012-02-03'),(4670,'g',0,'2012-02-03'),(1355,'g',0,'2012-02-05'),(1395,'g',0,'2012-02-05'),(4403,'g',0,'2012-02-05'),(4636,'g',0,'2012-02-05'),(4647,'g',0,'2012-02-05'),(3597,'g',0,'2012-02-05'),(3596,'g',0,'2012-02-05'),(3574,'g',0,'2012-02-05'),(3575,'g',0,'2012-02-05'),(3400,'g',0,'2012-02-05'),(3637,'g',0,'2012-02-05'),(4665,'g',0,'2012-02-05'),(3457,'g',0,'2012-02-05'),(3550,'g',0,'2012-02-05'),(3638,'g',0,'2012-02-05'),(3591,'g',0,'2012-02-05'),(3588,'g',0,'2012-02-05'),(3581,'g',0,'2012-02-05'),(3624,'g',0,'2012-02-05'),(3525,'g',0,'2012-02-05'),(3520,'g',0,'2012-02-05'),(3573,'g',0,'2012-02-05'),(3521,'g',0,'2012-02-05'),(3522,'g',0,'2012-02-05'),(3527,'g',0,'2012-02-05'),(3582,'g',0,'2012-02-05'),(3519,'g',0,'2012-02-05'),(3526,'g',0,'2012-02-05'),(4400,'g',0,'2012-02-05'),(1460,'g',0,'2012-02-05'),(1474,'g',0,'2012-02-05'),(1481,'g',0,'2012-02-05'),(4560,'g',0,'2012-02-05'),(4413,'g',0,'2012-02-05'),(1234,'g',0,'2012-02-05'),(1235,'g',0,'2012-02-05'),(1218,'g',0,'2012-02-05'),(4402,'g',0,'2012-02-05'),(4478,'g',0,'2012-02-05'),(1284,'g',0,'2012-02-05'),(4473,'g',0,'2012-02-05'),(1224,'g',0,'2012-02-05'),(1271,'g',0,'2012-02-05'),(1190,'g',0,'2012-02-05'),(1150,'g',0,'2012-02-05'),(1206,'g',0,'2012-02-05'),(1344,'g',0,'2012-02-05'),(1304,'g',0,'2012-02-05'),(1165,'g',0,'2012-02-05'),(1339,'g',0,'2012-02-05'),(1175,'g',0,'2012-02-05'),(1298,'g',0,'2012-02-05'),(3639,'g',0,'2012-02-05'),(1417,'g',0,'2012-02-06'),(1296,'g',0,'2012-02-06'),(1310,'g',0,'2012-02-06'),(1192,'g',0,'2012-02-06'),(1156,'g',0,'2012-02-06'),(1392,'g',0,'2012-02-06'),(1393,'g',0,'2012-02-06'),(1387,'g',0,'2012-02-06'),(1471,'g',0,'2012-02-06'),(1159,'g',0,'2012-02-06'),(1213,'g',0,'2012-02-06'),(1232,'g',0,'2012-02-06'),(1204,'g',0,'2012-02-06'),(1202,'g',0,'2012-02-06'),(1261,'g',0,'2012-02-06'),(3635,'g',0,'2012-02-06'),(1301,'g',0,'2012-02-06'),(1295,'g',0,'2012-02-06'),(3518,'g',0,'2012-02-06'),(3524,'g',0,'2012-02-06'),(3651,'g',0,'2012-02-06'),(3577,'g',0,'2012-02-06'),(3523,'g',0,'2012-02-06'),(4496,'g',0,'2012-02-06'),(1323,'g',0,'2012-02-06'),(1424,'g',0,'2012-02-06'),(4514,'g',0,'2012-02-06'),(4507,'g',0,'2012-02-06'),(4517,'g',0,'2012-02-06'),(4499,'g',0,'2012-02-06'),(4506,'g',0,'2012-02-06'),(4513,'g',0,'2012-02-06'),(4559,'g',0,'2012-02-06'),(4498,'g',0,'2012-02-06'),(1332,'g',0,'2012-02-06'),(4549,'g',0,'2012-02-06'),(3660,'g',0,'2012-02-06'),(4592,'g',0,'2012-02-06'),(4660,'g',0,'2012-02-06'),(3410,'g',0,'2012-02-06'),(3409,'g',0,'2012-02-06'),(4572,'g',0,'2012-02-06'),(4666,'g',0,'2012-02-06'),(4623,'g',0,'2012-02-06'),(3580,'g',0,'2012-02-06'),(4575,'g',0,'2012-02-06'),(3587,'g',0,'2012-02-06'),(1401,'g',0,'2012-02-08'),(1372,'g',0,'2012-02-08'),(1369,'g',0,'2012-02-08'),(1394,'g',0,'2012-02-08'),(1385,'g',0,'2012-02-08'),(1413,'g',0,'2012-02-08'),(1414,'g',0,'2012-02-08'),(1403,'g',0,'2012-02-08'),(1397,'g',0,'2012-02-08'),(1366,'g',0,'2012-02-08'),(1248,'g',0,'2012-02-08'),(1260,'g',0,'2012-02-08'),(1351,'g',0,'2012-02-08'),(1353,'g',0,'2012-02-08'),(1334,'g',0,'2012-02-08'),(1277,'g',0,'2012-02-08'),(1349,'g',0,'2012-02-08'),(1103,'g',0,'2012-02-08'),(1331,'g',0,'2012-02-08'),(1092,'g',0,'2012-02-08'),(1090,'g',0,'2012-02-08'),(1249,'g',0,'2012-02-08'),(1105,'g',0,'2012-02-08'),(1093,'g',0,'2012-02-08'),(1091,'g',0,'2012-02-08'),(1106,'g',0,'2012-02-08'),(1094,'g',0,'2012-02-08'),(1102,'g',0,'2012-02-08'),(4528,'g',0,'2012-02-08'),(1104,'g',0,'2012-02-08'),(4525,'g',0,'2012-02-08'),(4500,'g',0,'2012-02-08'),(4518,'g',0,'2012-02-08'),(4530,'g',0,'2012-02-08'),(4531,'g',0,'2012-02-08'),(4516,'g',0,'2012-02-08'),(4527,'g',0,'2012-02-08'),(4529,'g',0,'2012-02-08'),(4526,'g',0,'2012-02-08'),(1406,'g',0,'2012-02-08'),(1281,'g',0,'2012-02-08'),(1306,'g',0,'2012-02-08'),(1320,'g',0,'2012-02-08'),(1308,'g',0,'2012-02-08'),(1338,'g',0,'2012-02-08'),(1316,'g',0,'2012-02-08'),(1292,'g',0,'2012-02-08'),(1375,'g',0,'2012-02-08'),(1326,'g',0,'2012-02-08'),(1311,'g',0,'2012-02-08'),(1264,'g',0,'2012-02-08'),(4440,'g',0,'2012-02-08'),(3626,'g',0,'2012-02-08'),(3558,'g',0,'2012-02-08'),(3545,'g',0,'2012-02-08'),(3548,'g',0,'2012-02-08'),(4622,'g',0,'2012-02-08'),(3465,'g',0,'2012-02-08'),(4474,'g',0,'2012-02-08'),(4454,'g',0,'2012-02-08'),(1265,'g',0,'2012-02-08'),(1307,'g',0,'2012-02-09'),(4656,'g',0,'2012-02-09'),(1461,'g',0,'2012-02-09'),(1379,'g',0,'2012-02-09'),(1462,'g',0,'2012-02-09'),(1398,'g',0,'2012-02-09'),(1428,'g',0,'2012-02-09'),(1426,'g',0,'2012-02-09'),(1388,'g',0,'2012-02-09'),(1389,'g',0,'2012-02-09'),(1464,'g',0,'2012-02-09'),(1380,'g',0,'2012-02-09'),(1262,'g',0,'2012-02-09'),(1169,'g',0,'2012-02-09'),(4457,'g',0,'2012-02-09'),(4524,'g',0,'2012-02-10'),(1250,'g',0,'2012-02-10'),(1300,'g',0,'2012-02-10'),(4462,'g',0,'2012-02-10'),(1432,'g',0,'2012-02-10'),(1288,'g',0,'2012-02-10'),(1254,'g',0,'2012-02-10'),(1287,'g',0,'2012-02-10'),(1289,'g',0,'2012-02-10'),(1285,'g',0,'2012-02-10'),(4566,'g',0,'2012-02-10'),(4442,'g',0,'2012-02-10'),(4644,'g',0,'2012-02-11'),(4625,'g',0,'2012-02-11'),(4653,'g',0,'2012-02-11'),(4569,'g',0,'2012-02-11'),(4396,'g',0,'2012-02-11'),(4619,'g',0,'2012-02-11'),(4642,'g',0,'2012-02-11'),(4668,'g',0,'2012-02-11'),(4573,'g',0,'2012-02-11'),(3404,'g',0,'2012-02-11'),(4392,'g',0,'2012-02-11'),(4677,'g',0,'2012-02-11'),(4632,'g',0,'2012-02-11'),(3568,'g',0,'2012-02-11'),(3659,'g',0,'2012-02-11'),(3628,'g',0,'2012-02-11'),(4393,'g',0,'2012-02-11'),(4667,'g',0,'2012-02-11'),(3408,'g',0,'2012-02-11'),(4727,'g',0,'2012-02-11'),(3392,'g',0,'2012-02-11'),(3396,'g',0,'2012-02-11'),(4594,'g',0,'2012-02-11'),(4637,'g',0,'2012-02-11'),(4669,'g',0,'2012-02-11'),(4720,'g',0,'2012-02-11'),(3459,'g',0,'2012-02-11'),(3566,'g',0,'2012-02-11'),(3613,'g',0,'2012-02-11'),(3407,'g',0,'2012-02-11'),(3585,'g',0,'2012-02-11'),(4451,'g',0,'2012-02-11'),(3446,'g',0,'2012-02-11'),(4492,'g',0,'2012-02-11'),(4401,'g',0,'2012-02-11'),(1275,'g',0,'2012-02-11'),(3449,'g',0,'2012-02-11'),(3584,'g',0,'2012-02-11'),(4449,'g',0,'2012-02-11'),(1370,'g',0,'2012-02-11'),(3452,'g',0,'2012-02-11'),(4394,'g',0,'2012-02-11'),(4395,'g',0,'2012-02-12'),(3481,'g',0,'2012-02-12'),(4723,'g',0,'2012-02-12'),(3463,'g',0,'2012-02-12'),(3453,'g',0,'2012-02-12'),(3557,'g',0,'2012-02-12'),(3619,'g',0,'2012-02-12'),(3467,'g',0,'2012-02-12'),(4621,'g',0,'2012-02-12'),(3586,'g',0,'2012-02-12'),(3556,'g',0,'2012-02-12'),(4652,'g',0,'2012-02-12'),(4714,'g',0,'2012-02-12'),(1390,'g',0,'2012-02-12'),(4649,'g',0,'2012-02-12'),(3583,'g',0,'2012-02-12'),(4450,'g',0,'2012-02-12'),(1405,'g',0,'2012-02-12'),(1419,'g',0,'2012-02-12'),(3609,'g',0,'2012-02-12'),(3599,'g',0,'2012-02-12'),(4504,'g',0,'2012-02-12'),(3604,'g',0,'2012-02-12'),(4728,'g',0,'2012-02-12'),(4459,'g',0,'2012-02-13'),(3399,'g',0,'2012-02-13'),(3398,'g',0,'2012-02-13'),(4460,'g',0,'2012-02-13'),(3576,'g',0,'2012-02-13'),(4511,'g',0,'2012-02-13'),(4577,'g',0,'2012-02-13'),(4646,'g',0,'2012-02-13'),(4643,'g',0,'2012-02-13'),(1412,'g',0,'2012-02-13'),(209,'g',0,'2012-02-13'),(212,'g',0,'2012-02-13'),(3460,'g',0,'2012-02-13'),(3528,'g',0,'2012-02-13'),(3493,'g',0,'2012-02-13'),(3496,'g',0,'2012-02-13'),(3492,'g',0,'2012-02-13'),(3494,'g',0,'2012-02-13'),(3491,'g',0,'2012-02-13'),(3486,'g',0,'2012-02-13'),(3488,'g',0,'2012-02-13'),(3489,'g',0,'2012-02-13'),(3497,'g',0,'2012-02-13'),(3490,'g',0,'2012-02-13'),(4734,'g',0,'2012-02-14'),(4465,'g',0,'2012-02-14'),(1327,'g',0,'2012-02-14'),(4463,'g',0,'2012-02-14'),(4725,'g',0,'2012-02-14'),(4443,'g',0,'2012-02-14'),(3646,'g',0,'2012-02-14'),(4717,'g',0,'2012-02-14'),(4730,'g',0,'2012-02-14'),(1337,'g',0,'2012-02-14'),(4426,'g',0,'2012-02-14'),(4406,'g',0,'2012-02-14'),(4732,'g',0,'2012-02-14'),(1333,'g',0,'2012-02-14'),(1467,'g',0,'2012-02-14'),(4597,'g',0,'2012-02-14'),(1342,'g',0,'2012-02-14'),(1492,'g',0,'2012-02-14'),(4520,'g',0,'2012-02-14'),(1483,'g',0,'2012-02-14'),(3607,'g',0,'2012-02-14'),(4659,'g',0,'2012-02-14'),(4581,'g',0,'2012-02-14'),(1508,'g',0,'2012-02-14'),(3565,'g',0,'2012-02-14'),(3540,'g',0,'2012-02-14'),(3652,'g',0,'2012-02-14'),(3552,'g',0,'2012-02-14'),(3539,'g',0,'2012-02-14'),(3543,'g',0,'2012-02-14'),(3654,'g',0,'2012-02-14'),(3653,'g',0,'2012-02-14'),(3559,'g',0,'2012-02-14'),(3567,'g',0,'2012-02-14'),(3541,'g',0,'2012-02-14'),(3542,'g',0,'2012-02-14'),(4485,'g',0,'2012-02-15'),(4484,'g',0,'2012-02-15'),(4486,'g',0,'2012-02-15'),(4487,'g',0,'2012-02-15'),(4483,'g',0,'2012-02-15'),(4482,'g',0,'2012-02-15'),(4523,'g',0,'2012-02-15'),(4568,'g',0,'2012-02-15'),(4468,'g',0,'2012-02-16'),(4494,'g',0,'2012-02-16'),(4469,'g',0,'2012-02-16'),(4493,'g',0,'2012-02-16'),(1422,'g',0,'2012-02-16'),(4724,'g',0,'2012-02-16'),(1272,'g',0,'2012-02-16'),(1228,'g',0,'2012-02-16'),(1081,'g',0,'2012-02-16'),(4739,'g',0,'2012-02-16'),(4735,'g',0,'2012-02-16'),(1080,'g',0,'2012-02-16'),(4583,'g',0,'2012-02-16'),(4639,'g',0,'2012-02-16'),(4576,'g',0,'2012-02-16'),(4635,'g',0,'2012-02-16'),(4641,'g',0,'2012-02-16'),(4591,'g',0,'2012-02-16'),(4574,'g',0,'2012-02-16'),(4584,'g',0,'2012-02-16'),(4567,'g',0,'2012-02-16'),(4588,'g',0,'2012-02-16'),(4671,'g',0,'2012-02-16'),(3406,'g',0,'2012-02-16'),(4648,'g',0,'2012-02-16'),(3472,'g',0,'2012-02-16'),(4664,'g',0,'2012-02-16'),(3394,'g',0,'2012-02-16'),(3397,'g',0,'2012-02-16'),(3487,'g',0,'2012-02-16'),(3455,'g',0,'2012-02-16'),(3512,'g',0,'2012-02-16'),(1198,'g',0,'2012-02-16'),(4738,'g',0,'2012-02-17'),(4564,'g',0,'2012-02-19'),(4740,'g',0,'2012-02-19'),(4731,'g',0,'2012-02-21'),(4744,'g',0,'2012-02-21'),(4676,'g',0,'2012-02-22'),(4743,'g',0,'2012-02-22'),(4741,'g',0,'2012-02-22'),(4745,'g',0,'2012-02-22'),(4726,'g',0,'2012-02-22'),(1148,'g',0,'2012-02-26'),(1356,'g',0,'2012-02-26'),(4746,'g',0,'2012-02-26'),(4733,'g',0,'2012-02-27'),(4688,'g',0,'2012-02-27'),(4693,'g',0,'2012-02-27'),(4689,'g',0,'2012-02-27'),(4695,'g',0,'2012-02-27'),(4691,'g',0,'2012-02-27'),(4694,'g',0,'2012-02-27'),(4690,'g',0,'2012-02-27'),(4687,'g',0,'2012-02-27'),(4696,'g',0,'2012-02-27'),(3625,'g',0,'2012-02-27'),(3615,'g',0,'2012-02-27'),(3631,'g',0,'2012-02-27'),(3616,'g',0,'2012-02-27'),(3632,'g',0,'2012-02-27'),(3612,'g',0,'2012-02-27'),(3629,'g',0,'2012-02-27'),(3617,'g',0,'2012-02-27'),(4711,'g',0,'2012-02-27'),(4710,'g',0,'2012-02-27'),(4708,'g',0,'2012-02-27'),(4707,'g',0,'2012-02-27'),(4712,'g',0,'2012-02-27'),(4713,'g',0,'2012-02-27'),(4709,'g',0,'2012-02-27'),(4719,'g',0,'2012-02-27'),(4561,'g',0,'2012-02-27'),(4718,'g',0,'2012-02-27'),(3578,'g',0,'2012-02-27'),(3563,'g',0,'2012-02-27'),(3600,'g',0,'2012-02-27'),(3544,'g',0,'2012-02-27'),(3572,'g',0,'2012-02-27'),(3555,'g',0,'2012-02-27'),(3611,'g',0,'2012-02-27'),(3603,'g',0,'2012-02-27'),(4700,'g',0,'2012-02-27'),(4704,'g',0,'2012-02-27'),(4703,'g',0,'2012-02-27'),(4701,'g',0,'2012-02-27'),(3554,'g',0,'2012-02-27'),(4699,'g',0,'2012-02-27'),(4705,'g',0,'2012-02-27'),(4706,'g',0,'2012-02-27'),(4698,'g',0,'2012-02-27'),(3547,'g',0,'2012-02-27'),(3414,'g',0,'2012-02-27'),(4692,'g',0,'2012-02-27'),(3412,'g',0,'2012-02-27'),(3411,'g',0,'2012-02-27'),(3415,'g',0,'2012-02-27'),(3416,'g',0,'2012-02-27'),(3403,'g',0,'2012-02-27'),(3413,'g',0,'2012-02-27'),(3636,'g',0,'2012-02-27'),(3644,'g',0,'2012-02-27'),(1435,'g',0,'2012-02-28'),(1427,'g',0,'2012-02-28'),(1433,'g',0,'2012-02-28'),(3647,'g',0,'2012-02-28'),(3618,'g',0,'2012-02-28'),(3417,'g',0,'2012-02-28'),(4702,'g',0,'2012-02-28'),(1434,'g',0,'2012-02-28'),(1439,'g',0,'2012-02-28'),(1436,'g',0,'2012-02-28'),(1440,'g',0,'2012-02-28'),(1270,'g',0,'2012-02-28'),(1441,'g',0,'2012-02-28'),(1180,'g',0,'2012-02-28'),(1123,'g',0,'2012-02-28'),(1222,'g',0,'2012-02-28'),(1058,'g',0,'2012-02-28'),(1126,'g',0,'2012-02-28'),(1259,'g',0,'2012-02-28'),(1256,'g',0,'2012-02-28'),(1243,'g',0,'2012-02-28'),(1127,'g',0,'2012-02-28'),(1193,'g',0,'2012-02-28'),(1267,'g',0,'2012-02-28'),(1122,'g',0,'2012-02-28'),(1153,'g',0,'2012-02-28'),(1114,'g',0,'2012-02-28'),(1258,'g',0,'2012-02-28'),(1255,'g',0,'2012-02-28'),(1052,'g',0,'2012-02-28'),(1257,'g',0,'2012-02-29'),(1087,'g',0,'2012-02-29'),(1502,'g',0,'2012-02-29'),(1496,'g',0,'2012-02-29'),(1445,'g',0,'2012-02-29'),(1447,'g',0,'2012-02-29'),(1497,'g',0,'2012-02-29'),(1459,'g',0,'2012-02-29'),(1509,'g',0,'2012-02-29'),(1500,'g',0,'2012-02-29'),(1082,'g',0,'2012-02-29'),(1437,'g',0,'2012-02-29'),(1450,'g',0,'2012-02-29'),(1442,'g',0,'2012-02-29'),(1088,'g',0,'2012-02-29'),(1507,'g',0,'2012-02-29'),(1086,'g',0,'2012-02-29'),(1504,'g',0,'2012-02-29'),(1124,'g',0,'2012-02-29'),(1494,'g',0,'2012-02-29'),(1085,'g',0,'2012-02-29'),(1458,'g',0,'2012-02-29'),(1448,'g',0,'2012-02-29'),(1456,'g',0,'2012-02-29'),(1438,'g',0,'2012-02-29'),(1457,'g',0,'2012-02-29'),(1454,'g',0,'2012-02-29'),(1136,'g',0,'2012-02-29'),(1066,'g',0,'2012-02-29'),(1452,'g',0,'2012-02-29'),(1506,'g',0,'2012-02-29'),(1453,'g',0,'2012-02-29'),(1455,'g',0,'2012-02-29'),(1446,'g',0,'2012-02-29'),(1089,'g',0,'2012-02-29'),(1251,'g',0,'2012-02-29'),(4753,'g',0,'2012-02-29'),(4757,'g',0,'2012-02-29'),(1083,'g',0,'2012-02-29'),(1468,'g',0,'2012-02-29'),(1451,'g',0,'2012-02-29'),(1444,'g',0,'2012-02-29'),(1430,'g',0,'2012-02-29'),(4755,'g',0,'2012-03-01'),(4579,'g',0,'2012-03-01'),(4587,'g',0,'2012-03-01'),(4589,'g',0,'2012-03-01'),(1482,'g',0,'2012-03-01'),(1299,'g',0,'2012-03-01'),(1449,'g',0,'2012-03-01'),(4495,'g',0,'2012-03-01'),(4509,'g',0,'2012-03-01'),(4415,'g',0,'2012-03-01'),(3474,'g',0,'2012-03-01'),(4650,'g',0,'2012-03-01'),(4488,'g',0,'2012-03-01'),(4475,'g',0,'2012-03-01'),(1408,'g',0,'2012-03-01'),(4476,'g',0,'2012-03-01'),(4508,'g',0,'2012-03-01'),(4477,'g',0,'2012-03-01'),(1329,'g',0,'2012-03-01'),(1352,'g',0,'2012-03-01'),(4550,'g',0,'2012-03-02'),(4551,'g',0,'2012-03-02'),(4554,'g',0,'2012-03-02'),(4553,'g',0,'2012-03-02'),(4533,'g',0,'2012-03-02'),(4535,'g',0,'2012-03-02'),(4534,'g',0,'2012-03-02'),(4536,'g',0,'2012-03-02'),(4555,'g',0,'2012-03-02'),(4552,'g',0,'2012-03-02'),(1084,'g',0,'2012-03-02'),(4452,'g',0,'2012-03-02'),(4430,'g',0,'2012-03-02'),(4404,'g',0,'2012-03-02'),(4441,'g',0,'2012-03-02'),(4398,'g',0,'2012-03-02'),(4729,'g',0,'2012-03-02'),(4405,'g',0,'2012-03-02'),(4461,'g',0,'2012-03-02'),(4397,'g',0,'2012-03-02'),(4532,'g',0,'2012-03-02'),(1487,'g',0,'2012-03-02'),(1490,'g',0,'2012-03-02'),(1431,'g',0,'2012-03-02'),(1465,'g',0,'2012-03-02'),(1415,'g',0,'2012-03-02'),(1476,'g',0,'2012-03-02'),(1463,'g',0,'2012-03-02'),(1486,'g',0,'2012-03-02'),(1505,'g',0,'2012-03-02'),(4758,'g',0,'2012-03-02'),(4750,'g',0,'2012-03-02'),(4759,'g',0,'2012-03-02'),(4748,'g',0,'2012-03-02'),(4751,'g',0,'2012-03-02'),(4428,'g',0,'2012-03-02'),(4736,'g',0,'2012-03-02'),(4742,'g',0,'2012-03-03'),(4747,'g',0,'2012-03-03'),(4620,'g',0,'2012-03-04'),(4756,'g',0,'2012-03-04'),(1475,'g',0,'2012-03-04'),(1499,'g',0,'2012-03-04'),(1495,'g',0,'2012-03-05'),(4781,'g',0,'2012-03-06'),(4760,'g',0,'2012-03-07'),(4763,'g',0,'2012-03-07'),(4778,'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 ('4twgRdxWB2TFpGz27bHURg','21vrXO6X1kQYgDNemtrRch7T2U7558hLH43lwwHPU','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 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`
--


--
-- 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','bizonlinelisting.com'),(5,'site_url','http://bizonlinelisting.com'),(6,'email_address','bizonlinelisting@hotmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/bizonlin/public_html/themes/'),(9,'admin_template_path','/home/bizonlin/public_html/admin_tpl/'),(10,'plugin_path','/home/bizonlin/public_html/plugin/'),(12,'active_theme','bizonline'),(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`
--



