--
-- Host: hotdirectory.co.uk    Database: hotdirec_direct
-- ------------------------------------------------------


--
-- 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 default '0',
  `project_id` bigint(100) NOT NULL default '0',
  `link_id` bigint(100) NOT NULL default '0',
  `confirm_link` text NOT NULL,
  `category_id` int(10) NOT NULL default '0',
  `category_name` varchar(150) NOT NULL default '',
  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 & Music','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Auto Industry','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Economy & Business','','folder.gif','','1',77,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Careers & Job Search','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Clothing Accessories','','folder.gif','','1',5,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Communications Services','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computer Services','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Construction and Contractors','','folder.gif','','1',56,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental Care','','folder.gif','','1',7,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Education & Research','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Employment Services','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Gift Baskets','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software Services','','folder.gif','','1',5,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Health & Medical','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Management','','folder.gif','','1',130,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Heating and Air Conditioning Contractors','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home & Family','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement & Decor','','folder.gif','','1',243,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Accomadation','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Companies','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Judges','','folder.gif','','1',108,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Dating & Relationships','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine & Hospitals','','folder.gif','','1',4,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Finance & Investment Services','','folder.gif','','1',9,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News & Magazines','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing Services','','folder.gif','','1',25,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate Development','','folder.gif','','1',17,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Energy & Science','','folder.gif','','1',8,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'SEO ,SMO & PPC','','folder.gif','','1',15,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Shopping and Retail','','folder.gif','','1',35,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Recreation & Sports','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Transport & Moving Services','','folder.gif','','1',29,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Travel Industry','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Wedding & Events','','folder.gif','','1',7,'','','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 & Music','<a href=\"http://hotdirectory.co.uk/arts-music/\" name=\"cat_1\" style=\"\">Arts & Music</a>',';0;'),(2,'Auto Industry','<a href=\"http://hotdirectory.co.uk/auto-industry/\" name=\"cat_2\" style=\"\">Auto Industry</a>',';0;'),(3,'Economy & Business','<a href=\"http://hotdirectory.co.uk/economy-business/\" name=\"cat_3\" style=\"\">Economy & Business</a>',';0;'),(4,'Careers & Job Search','<a href=\"http://hotdirectory.co.uk/careers-job-search/\" name=\"cat_4\" style=\"\">Careers & Job Search</a>',';0;'),(5,'Clothing Accessories','<a href=\"http://hotdirectory.co.uk/clothing-accessories/\" name=\"cat_5\" style=\"\">Clothing Accessories</a>',';0;'),(6,'Communications Services','<a href=\"http://hotdirectory.co.uk/communications-services/\" name=\"cat_6\" style=\"\">Communications Services</a>',';0;'),(7,'Computer Services','<a href=\"http://hotdirectory.co.uk/computer-services/\" name=\"cat_7\" style=\"\">Computer Services</a>',';0;'),(8,'Construction and Contractors','<a href=\"http://hotdirectory.co.uk/construction-and-contractors/\" name=\"cat_8\" style=\"\">Construction and Contractors</a>',';0;'),(9,'Dental Care','<a href=\"http://hotdirectory.co.uk/dental-care/\" name=\"cat_9\" style=\"\">Dental Care</a>',';0;'),(10,'Education & Research','<a href=\"http://hotdirectory.co.uk/education-research/\" name=\"cat_10\" style=\"\">Education & Research</a>',';0;'),(11,'Employment Services','<a href=\"http://hotdirectory.co.uk/employment-services/\" name=\"cat_11\" style=\"\">Employment Services</a>',';0;'),(12,'Gift Baskets','<a href=\"http://hotdirectory.co.uk/gift-baskets/\" name=\"cat_12\" style=\"\">Gift Baskets</a>',';0;'),(13,'Hardware & Software Services','<a href=\"http://hotdirectory.co.uk/hardware-software-services/\" name=\"cat_13\" style=\"\">Hardware & Software Services</a>',';0;'),(14,'Health & Medical','<a href=\"http://hotdirectory.co.uk/health-medical/\" name=\"cat_14\" style=\"\">Health & Medical</a>',';0;'),(15,'Healthcare Management','<a href=\"http://hotdirectory.co.uk/healthcare-management/\" name=\"cat_15\" style=\"\">Healthcare Management</a>',';0;'),(16,'Heating and Air Conditioning Contractors','<a href=\"http://hotdirectory.co.uk/heating-and-air-conditioning-contractors/\" name=\"cat_16\" style=\"\">Heating and Air Conditioning Contractors</a>',';0;'),(17,'Home & Family','<a href=\"http://hotdirectory.co.uk/home-family/\" name=\"cat_17\" style=\"\">Home & Family</a>',';0;'),(18,'Home Improvement & Decor','<a href=\"http://hotdirectory.co.uk/home-improvement-decor/\" name=\"cat_18\" style=\"\">Home Improvement & Decor</a>',';0;'),(19,'Hotels & Accomadation','<a href=\"http://hotdirectory.co.uk/hotels-accomadation/\" name=\"cat_19\" style=\"\">Hotels & Accomadation</a>',';0;'),(20,'Insurance Companies','<a href=\"http://hotdirectory.co.uk/insurance-companies/\" name=\"cat_20\" style=\"\">Insurance Companies</a>',';0;'),(21,'Law','<a href=\"http://hotdirectory.co.uk/law/\" name=\"cat_21\" style=\"\">Law</a>',';0;'),(22,'Lawyers & Judges','<a href=\"http://hotdirectory.co.uk/lawyers-judges/\" name=\"cat_22\" style=\"\">Lawyers & Judges</a>',';0;'),(23,'Dating & Relationships','<a href=\"http://hotdirectory.co.uk/dating-relationships/\" name=\"cat_23\" style=\"\">Dating & Relationships</a>',';0;'),(24,'Medicine & Hospitals','<a href=\"http://hotdirectory.co.uk/medicine-hospitals/\" name=\"cat_24\" style=\"\">Medicine & Hospitals</a>',';0;'),(25,'Finance & Investment Services','<a href=\"http://hotdirectory.co.uk/finance-investment-services/\" name=\"cat_25\" style=\"\">Finance & Investment Services</a>',';0;'),(26,'News & Magazines','<a href=\"http://hotdirectory.co.uk/news-magazines/\" name=\"cat_26\" style=\"\">News & Magazines</a>',';0;'),(27,'Plumbing Services','<a href=\"http://hotdirectory.co.uk/plumbing-services/\" name=\"cat_27\" style=\"\">Plumbing Services</a>',';0;'),(28,'Real Estate Development','<a href=\"http://hotdirectory.co.uk/real-estate-development/\" name=\"cat_28\" style=\"\">Real Estate Development</a>',';0;'),(29,'Energy & Science','<a href=\"http://hotdirectory.co.uk/energy-science/\" name=\"cat_29\" style=\"\">Energy & Science</a>',';0;'),(30,'SEO ,SMO & PPC','<a href=\"http://hotdirectory.co.uk/seo-smo-ppc/\" name=\"cat_30\" style=\"\">SEO ,SMO & PPC</a>',';0;'),(31,'Shopping and Retail','<a href=\"http://hotdirectory.co.uk/shopping-and-retail/\" name=\"cat_31\" style=\"\">Shopping and Retail</a>',';0;'),(32,'Recreation & Sports','<a href=\"http://hotdirectory.co.uk/recreation-sports/\" name=\"cat_32\" style=\"\">Recreation & Sports</a>',';0;'),(33,'Transport & Moving Services','<a href=\"http://hotdirectory.co.uk/transport-moving-services/\" name=\"cat_33\" style=\"\">Transport & Moving Services</a>',';0;'),(34,'Travel Industry','<a href=\"http://hotdirectory.co.uk/travel-industry/\" name=\"cat_34\" style=\"\">Travel Industry</a>',';0;'),(35,'Wedding & Events','<a href=\"http://hotdirectory.co.uk/wedding-events/\" name=\"cat_35\" style=\"\">Wedding & Events</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=6 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_category_suggession` VALUES (1,31,'EganReid Office Environments','Egan Reid is a leading independent office furniture & interiors specialist operating nationwide from its Stockport (Cheshire) base.','2011-11-21 07:54:11'),(2,0,'William Smith','Alcohol Miniatures, small (mini bar) bottles of alcoholic drinks; miniature whisky, brandy, gin, vodka and quarter size bottles of wine. Unusual ideas personalised for wedding favours (favors) and party gifts.','2011-11-24 03:17:23'),(3,31,'home & garden','Italian Sofas, an artisan company which for over thirty five years has been to the service of very rigorous costumers,sofas made in Italy to enrich your home with items of great quality and value.\r\n','2012-02-16 05:23:52'),(4,0,'home & garden','Italian Sofas, an artisan company which for over thirty five years has been to the service of very rigorous costumers,sofas made in Italy to enrich your home with items of great quality and value.\r\n','2012-02-16 07:20:40'),(5,31,'Catering Equipment | Catering Supplies','Catering equipment, catering supplies and restaurant equipment from Next Day Catering. We supply commercial glass washers, commercial kitchen equipment, ice machines and industrial kitchen equipment for hotels, bars, chefs and caterers.','2012-03-05 09:57:37');

--
-- 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 default '',
  `schedule` varchar(255) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `execution` char(1) NOT NULL default '',
  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 default '',
  `required` char(1) NOT NULL default '',
  `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 DEFAULT CHARSET=latin1;

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


--
-- 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`
--

INSERT INTO `idx_notification` VALUES ('admin',3);

--
-- 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 (1,'g',6,'2011-09-26'),(3,'g',1,'2011-09-26'),(2,'g',2,'2011-09-26'),(4,'g',1,'2011-09-26'),(9,'g',4,'2011-09-26'),(5,'g',3,'2011-09-26'),(10,'g',3,'2011-09-26'),(11,'g',0,'2011-09-26'),(6,'g',0,'2012-02-17'),(8,'g',0,'2011-12-15'),(7,'g',0,'2012-03-02'),(14,'g',0,'2011-10-16'),(15,'g',0,'2011-10-16'),(45,'g',0,'2012-02-04'),(47,'g',0,'2012-02-04'),(27,'g',0,'2012-02-04'),(17,'g',0,'2012-03-02'),(51,'g',0,'2012-03-02'),(22,'g',0,'2012-02-04'),(50,'g',0,'2012-02-04'),(35,'g',0,'2012-02-04'),(73,'g',0,'2012-02-04'),(300,'g',0,'2012-03-02'),(142,'g',0,'2012-03-02'),(153,'g',0,'2012-03-02'),(260,'g',0,'2012-03-02'),(280,'g',0,'2012-03-02'),(308,'g',0,'2012-03-02'),(319,'g',0,'2012-03-02'),(123,'g',0,'2012-03-02'),(313,'g',0,'2012-03-02'),(114,'g',0,'2012-03-02'),(106,'g',0,'2012-02-17'),(112,'g',0,'2012-02-17'),(72,'g',0,'2012-02-17'),(77,'g',0,'2012-02-17'),(154,'g',0,'2012-02-17'),(169,'g',0,'2012-02-17'),(163,'g',0,'2012-02-17'),(209,'g',0,'2012-02-17'),(181,'g',0,'2012-02-17'),(62,'g',0,'2012-03-02'),(75,'g',0,'2012-03-02'),(71,'g',0,'2012-03-02'),(78,'g',0,'2012-03-02'),(66,'g',0,'2012-03-02'),(67,'g',0,'2012-03-02'),(65,'g',0,'2012-03-02'),(68,'g',0,'2012-03-02'),(69,'g',0,'2012-03-02'),(64,'g',0,'2012-03-02'),(297,'g',0,'2012-02-17'),(98,'g',0,'2012-02-17'),(160,'g',0,'2012-02-17'),(109,'g',0,'2012-02-17'),(52,'g',0,'2012-02-17'),(244,'g',0,'2012-02-17'),(56,'g',0,'2012-02-17'),(84,'g',0,'2012-02-17'),(354,'g',0,'2012-03-02'),(105,'g',0,'2012-02-17'),(289,'g',0,'2012-02-17'),(282,'g',0,'2012-02-17'),(117,'g',0,'2012-02-17'),(159,'g',0,'2012-02-17'),(99,'g',0,'2012-02-17'),(89,'g',0,'2012-02-17'),(93,'g',0,'2012-02-17'),(25,'g',0,'2012-02-15'),(185,'g',0,'2012-02-17'),(42,'g',0,'2012-02-17'),(189,'g',0,'2012-01-05'),(165,'g',0,'2012-02-17'),(157,'g',0,'2012-02-17'),(168,'g',0,'2012-02-17'),(177,'g',0,'2012-02-17'),(34,'g',0,'2012-02-15'),(38,'g',0,'2012-02-17'),(145,'g',0,'2012-02-17'),(57,'g',0,'2012-02-17'),(91,'g',0,'2012-02-15'),(132,'g',0,'2012-02-15'),(54,'g',0,'2012-02-17'),(113,'g',0,'2012-02-17'),(173,'g',0,'2012-02-14'),(44,'g',0,'2012-02-14'),(102,'g',0,'2012-03-02'),(23,'g',0,'2012-03-02'),(48,'g',0,'2012-02-06'),(32,'g',0,'2012-03-02'),(29,'g',0,'2012-02-14'),(118,'g',0,'2012-02-14'),(28,'g',0,'2012-02-14'),(33,'g',0,'2012-02-14'),(86,'g',0,'2012-02-06'),(70,'g',0,'2012-02-06'),(195,'g',0,'2012-02-14'),(81,'g',0,'2012-02-06'),(88,'g',0,'2012-03-02'),(74,'g',0,'2012-02-06'),(79,'g',0,'2012-02-14'),(90,'g',0,'2012-02-06'),(95,'g',0,'2012-02-06'),(82,'g',0,'2012-02-14'),(101,'g',0,'2012-02-06'),(125,'g',0,'2012-03-02'),(108,'g',0,'2012-03-02'),(41,'g',0,'2012-03-02'),(19,'g',0,'2012-02-14'),(26,'g',0,'2012-02-14'),(20,'g',0,'2012-02-14'),(96,'g',0,'2012-02-06'),(183,'g',0,'2012-02-14'),(46,'g',0,'2012-03-02'),(353,'g',0,'2012-02-17'),(43,'g',0,'2012-02-06'),(36,'g',0,'2012-02-14'),(49,'g',0,'2012-03-02'),(40,'g',0,'2012-02-14'),(39,'g',0,'2012-02-14'),(53,'g',0,'2012-03-02'),(31,'g',0,'2012-02-15'),(30,'g',0,'2012-02-17'),(133,'g',0,'2012-02-17'),(100,'g',0,'2012-02-15'),(21,'g',0,'2012-02-17'),(37,'g',0,'2012-02-15'),(85,'g',0,'2012-02-17'),(120,'g',0,'2012-02-17'),(146,'g',0,'2012-02-11'),(150,'g',0,'2012-02-17'),(314,'g',0,'2012-02-17'),(202,'g',0,'2012-02-17'),(191,'g',0,'2012-02-17'),(346,'g',0,'2012-02-17'),(350,'g',0,'2012-02-17'),(352,'g',0,'2011-12-15'),(360,'g',0,'2012-03-03'),(329,'g',0,'2012-03-03'),(324,'g',0,'2012-03-04'),(343,'g',0,'2011-11-09'),(347,'g',0,'2011-11-09'),(264,'g',0,'2012-03-02'),(304,'g',0,'2012-03-02'),(317,'g',0,'2011-11-10'),(312,'g',0,'2012-03-02'),(119,'g',0,'2012-03-02'),(129,'g',0,'2012-03-02'),(362,'g',0,'2012-02-28'),(363,'g',0,'2012-02-28'),(365,'g',0,'2012-02-17'),(322,'g',0,'2012-03-03'),(327,'g',0,'2012-03-03'),(332,'g',0,'2012-03-03'),(349,'g',0,'2012-03-03'),(339,'g',0,'2012-03-03'),(364,'g',0,'2012-03-03'),(366,'g',0,'2012-03-03'),(126,'g',0,'2012-02-17'),(139,'g',0,'2012-02-17'),(179,'g',0,'2012-02-17'),(200,'g',0,'2012-03-03'),(248,'g',0,'2012-03-03'),(294,'g',0,'2012-03-04'),(301,'g',0,'2012-03-03'),(285,'g',0,'2012-03-03'),(148,'g',0,'2012-02-17'),(158,'g',0,'2012-02-17'),(216,'g',0,'2012-03-04'),(149,'g',0,'2012-02-17'),(201,'g',0,'2012-03-03'),(207,'g',0,'2012-03-03'),(345,'g',0,'2012-03-03'),(152,'g',0,'2012-02-17'),(188,'g',0,'2012-03-04'),(284,'g',0,'2012-03-03'),(306,'g',0,'2012-03-03'),(180,'g',0,'2012-03-03'),(192,'g',0,'2012-03-03'),(373,'g',0,'2011-12-27'),(372,'g',0,'2012-03-03'),(371,'g',0,'2012-02-28'),(370,'g',0,'2012-02-28'),(368,'g',0,'2012-02-14'),(369,'g',0,'2012-03-02'),(367,'g',0,'2012-03-04'),(383,'g',0,'2012-02-29'),(380,'g',0,'2012-03-02'),(379,'g',0,'2012-02-17'),(376,'g',0,'2012-01-21'),(375,'g',0,'2012-01-21'),(374,'g',0,'2012-02-28'),(378,'g',0,'2012-01-21'),(382,'g',0,'2011-12-15'),(381,'g',0,'2012-01-21'),(377,'g',0,'2011-12-27'),(392,'g',0,'2012-02-29'),(391,'g',0,'2011-12-27'),(390,'g',0,'2011-11-10'),(389,'g',0,'2012-02-17'),(393,'g',0,'2011-12-27'),(388,'g',0,'2012-02-14'),(387,'g',0,'2012-02-17'),(386,'g',0,'2012-03-02'),(385,'g',0,'2012-02-17'),(384,'g',0,'2012-02-29'),(403,'g',0,'2011-12-27'),(402,'g',0,'2012-02-29'),(401,'g',0,'2012-02-29'),(404,'g',0,'2012-02-14'),(400,'g',0,'2012-03-02'),(399,'g',0,'2011-12-27'),(398,'g',0,'2011-11-10'),(397,'g',0,'2012-02-29'),(396,'g',0,'2012-02-17'),(394,'g',0,'2012-02-17'),(395,'g',0,'2012-02-17'),(412,'g',0,'2011-12-27'),(410,'g',0,'2011-12-27'),(408,'g',0,'2012-01-09'),(406,'g',0,'2012-02-29'),(405,'g',0,'2012-02-29'),(411,'g',0,'2011-12-27'),(409,'g',0,'2012-01-09'),(407,'g',0,'2011-11-10'),(413,'g',0,'2011-12-27'),(59,'g',0,'2012-02-17'),(55,'g',0,'2012-02-17'),(222,'g',0,'2011-11-11'),(130,'g',0,'2012-02-17'),(136,'g',0,'2012-02-17'),(215,'g',0,'2011-11-11'),(147,'g',0,'2012-02-17'),(171,'g',0,'2012-02-17'),(414,'g',0,'2011-12-27'),(231,'g',0,'2011-11-11'),(141,'g',0,'2012-02-17'),(355,'g',0,'2012-02-17'),(16,'g',0,'2012-03-03'),(361,'g',0,'2012-02-17'),(172,'g',0,'2011-11-12'),(161,'g',0,'2012-02-17'),(166,'g',0,'2012-02-17'),(167,'g',0,'2011-11-12'),(178,'g',0,'2012-02-17'),(156,'g',0,'2012-02-17'),(63,'g',0,'2012-03-03'),(107,'g',0,'2012-03-03'),(61,'g',0,'2012-03-04'),(58,'g',0,'2012-02-24'),(116,'g',0,'2012-03-04'),(60,'g',0,'2012-03-03'),(24,'g',0,'2012-03-03'),(76,'g',0,'2012-03-03'),(18,'g',0,'2012-03-03'),(432,'g',0,'2012-02-17'),(204,'g',0,'2012-02-17'),(122,'g',0,'2012-03-02'),(151,'g',0,'2012-03-02'),(212,'g',0,'2011-11-14'),(199,'g',0,'2012-02-17'),(190,'g',0,'2012-03-02'),(138,'g',0,'2012-03-02'),(196,'g',0,'2012-03-02'),(143,'g',0,'2012-03-02'),(137,'g',0,'2012-03-02'),(162,'g',0,'2011-11-14'),(103,'g',0,'2012-03-02'),(210,'g',0,'2011-11-14'),(111,'g',0,'2012-03-02'),(94,'g',0,'2012-03-02'),(281,'g',0,'2011-12-15'),(307,'g',0,'2012-02-17'),(92,'g',0,'2012-02-17'),(275,'g',0,'2012-02-17'),(266,'g',0,'2012-02-17'),(225,'g',0,'2012-02-17'),(87,'g',0,'2012-02-17'),(268,'g',0,'2012-02-17'),(124,'g',0,'2012-02-17'),(135,'g',0,'2012-02-17'),(415,'g',0,'2012-02-24'),(434,'g',0,'2012-02-24'),(435,'g',0,'2012-02-14'),(417,'g',0,'2012-02-14'),(439,'g',0,'2012-02-14'),(442,'g',0,'2012-02-17'),(416,'g',0,'2012-02-17'),(356,'g',0,'2012-02-17'),(359,'g',0,'2012-02-17'),(433,'g',0,'2012-02-17'),(484,'g',0,'2012-02-17'),(358,'g',0,'2012-02-17'),(444,'g',0,'2011-11-26'),(427,'g',0,'2011-11-26'),(459,'g',0,'2011-11-26'),(422,'g',0,'2011-11-26'),(454,'g',0,'2011-11-26'),(443,'g',0,'2011-11-26'),(572,'g',0,'2012-03-03'),(534,'g',0,'2012-03-03'),(468,'g',0,'2011-11-26'),(530,'g',0,'2012-03-03'),(574,'g',0,'2012-03-03'),(418,'g',0,'2012-02-17'),(450,'g',0,'2012-02-17'),(429,'g',0,'2012-02-17'),(431,'g',0,'2012-02-17'),(458,'g',0,'2012-02-17'),(426,'g',0,'2012-02-17'),(518,'g',0,'2012-03-04'),(501,'g',0,'2012-02-17'),(517,'g',0,'2012-02-17'),(524,'g',0,'2012-03-04'),(460,'g',0,'2012-02-17'),(428,'g',0,'2012-02-17'),(516,'g',0,'2012-03-03'),(529,'g',0,'2012-01-07'),(513,'g',0,'2012-02-14'),(567,'g',0,'2012-01-07'),(493,'g',0,'2011-12-03'),(436,'g',0,'2011-12-03'),(494,'g',0,'2011-12-03'),(500,'g',0,'2012-02-17'),(609,'g',0,'2012-02-17'),(525,'g',0,'2012-02-17'),(483,'g',0,'2012-02-17'),(511,'g',0,'2012-02-17'),(499,'g',0,'2012-02-17'),(496,'g',0,'2012-02-17'),(764,'g',0,'2012-02-16'),(566,'g',0,'2012-02-16'),(538,'g',0,'2012-02-16'),(615,'g',0,'2012-02-17'),(602,'g',0,'2012-02-17'),(724,'g',0,'2012-02-16'),(485,'g',0,'2011-12-11'),(767,'g',0,'2012-02-17'),(447,'g',0,'2012-02-17'),(542,'g',0,'2012-02-17'),(655,'g',0,'2012-02-17'),(449,'g',0,'2012-02-14'),(506,'g',0,'2012-02-17'),(711,'g',0,'2012-02-17'),(537,'g',0,'2012-02-17'),(584,'g',0,'2012-03-02'),(309,'g',0,'2011-12-14'),(302,'g',0,'2011-12-15'),(341,'g',0,'2011-12-15'),(303,'g',0,'2011-12-15'),(334,'g',0,'2011-12-15'),(338,'g',0,'2011-12-15'),(331,'g',0,'2011-12-15'),(336,'g',0,'2011-12-15'),(328,'g',0,'2011-12-15'),(337,'g',0,'2011-12-15'),(448,'g',0,'2012-02-17'),(486,'g',0,'2012-02-17'),(778,'g',0,'2012-02-14'),(593,'g',0,'2012-02-07'),(791,'g',0,'2012-02-14'),(598,'g',0,'2012-02-14'),(798,'g',0,'2012-02-17'),(768,'g',0,'2012-02-17'),(770,'g',0,'2012-02-17'),(769,'g',0,'2012-02-17'),(813,'g',0,'2011-12-24'),(799,'g',0,'2012-02-14'),(795,'g',0,'2012-02-14'),(843,'g',0,'2012-02-17'),(827,'g',0,'2012-02-17'),(866,'g',0,'2012-02-17'),(604,'g',0,'2012-03-03'),(580,'g',0,'2012-03-04'),(913,'g',0,'2012-02-17'),(579,'g',0,'2011-12-26'),(594,'g',0,'2012-03-03'),(649,'g',0,'2011-12-27'),(722,'g',0,'2012-02-17'),(723,'g',0,'2012-02-17'),(456,'g',0,'2011-12-27'),(482,'g',0,'2011-12-27'),(523,'g',0,'2011-12-27'),(421,'g',0,'2011-12-27'),(498,'g',0,'2011-12-27'),(425,'g',0,'2011-12-27'),(453,'g',0,'2011-12-27'),(438,'g',0,'2011-12-27'),(478,'g',0,'2012-02-17'),(473,'g',0,'2012-02-17'),(469,'g',0,'2012-02-17'),(470,'g',0,'2012-02-17'),(474,'g',0,'2012-02-17'),(639,'g',0,'2012-02-17'),(625,'g',0,'2011-12-27'),(475,'g',0,'2012-02-17'),(630,'g',0,'2012-03-04'),(642,'g',0,'2011-12-27'),(592,'g',0,'2011-12-27'),(641,'g',0,'2011-12-27'),(623,'g',0,'2011-12-27'),(677,'g',0,'2011-12-27'),(618,'g',0,'2012-02-17'),(680,'g',0,'2011-12-27'),(590,'g',0,'2011-12-27'),(674,'g',0,'2011-12-27'),(610,'g',0,'2012-02-17'),(682,'g',0,'2011-12-27'),(822,'g',0,'2012-03-04'),(833,'g',0,'2012-03-03'),(668,'g',0,'2012-03-03'),(850,'g',0,'2012-03-03'),(809,'g',0,'2012-03-03'),(873,'g',0,'2012-03-03'),(802,'g',0,'2012-03-03'),(860,'g',0,'2011-12-27'),(559,'g',0,'2011-12-27'),(883,'g',0,'2011-12-27'),(492,'g',0,'2011-12-27'),(595,'g',0,'2011-12-27'),(557,'g',0,'2011-12-27'),(715,'g',0,'2012-02-17'),(556,'g',0,'2011-12-27'),(326,'g',0,'2011-12-27'),(781,'g',0,'2011-12-27'),(782,'g',0,'2011-12-27'),(807,'g',0,'2011-12-27'),(800,'g',0,'2011-12-27'),(780,'g',0,'2011-12-27'),(333,'g',0,'2011-12-27'),(335,'g',0,'2011-12-27'),(330,'g',0,'2011-12-27'),(344,'g',0,'2011-12-27'),(340,'g',0,'2011-12-27'),(357,'g',0,'2011-12-27'),(424,'g',0,'2011-12-27'),(457,'g',0,'2011-12-27'),(472,'g',0,'2012-02-17'),(471,'g',0,'2012-02-17'),(477,'g',0,'2012-02-17'),(476,'g',0,'2012-02-17'),(586,'g',0,'2011-12-27'),(628,'g',0,'2012-03-04'),(676,'g',0,'2011-12-27'),(619,'g',0,'2012-02-17'),(620,'g',0,'2012-02-17'),(636,'g',0,'2012-02-17'),(614,'g',0,'2012-02-17'),(446,'g',0,'2011-12-27'),(600,'g',0,'2012-02-17'),(644,'g',0,'2011-12-27'),(621,'g',0,'2011-12-27'),(461,'g',0,'2011-12-27'),(673,'g',0,'2011-12-27'),(560,'g',0,'2011-12-27'),(679,'g',0,'2011-12-27'),(616,'g',0,'2012-02-17'),(640,'g',0,'2012-02-17'),(622,'g',0,'2011-12-27'),(624,'g',0,'2011-12-27'),(568,'g',0,'2011-12-27'),(626,'g',0,'2011-12-27'),(678,'g',0,'2011-12-27'),(632,'g',0,'2012-02-17'),(637,'g',0,'2012-02-17'),(612,'g',0,'2012-02-17'),(675,'g',0,'2011-12-27'),(627,'g',0,'2011-12-27'),(634,'g',0,'2012-02-17'),(445,'g',0,'2011-12-27'),(681,'g',0,'2011-12-27'),(599,'g',0,'2011-12-27'),(583,'g',0,'2011-12-27'),(605,'g',0,'2012-02-17'),(635,'g',0,'2012-02-17'),(629,'g',0,'2012-03-04'),(633,'g',0,'2012-02-17'),(638,'g',0,'2012-02-17'),(617,'g',0,'2012-02-17'),(631,'g',0,'2012-02-17'),(721,'g',0,'2012-02-17'),(716,'g',0,'2012-02-17'),(717,'g',0,'2012-02-17'),(714,'g',0,'2012-02-17'),(720,'g',0,'2012-02-17'),(718,'g',0,'2012-02-17'),(719,'g',0,'2012-02-17'),(713,'g',0,'2012-02-17'),(712,'g',0,'2012-02-17'),(541,'g',0,'2011-12-27'),(544,'g',0,'2011-12-27'),(507,'g',0,'2011-12-27'),(546,'g',0,'2011-12-27'),(543,'g',0,'2011-12-27'),(487,'g',0,'2011-12-27'),(508,'g',0,'2011-12-27'),(545,'g',0,'2011-12-27'),(547,'g',0,'2011-12-27'),(652,'g',0,'2011-12-27'),(650,'g',0,'2011-12-27'),(467,'g',0,'2011-12-27'),(514,'g',0,'2011-12-27'),(515,'g',0,'2011-12-27'),(510,'g',0,'2011-12-27'),(463,'g',0,'2011-12-27'),(653,'g',0,'2011-12-27'),(840,'g',0,'2011-12-28'),(553,'g',0,'2011-12-28'),(648,'g',0,'2011-12-28'),(466,'g',0,'2011-12-28'),(646,'g',0,'2011-12-28'),(657,'g',0,'2011-12-28'),(558,'g',0,'2011-12-28'),(522,'g',0,'2011-12-28'),(647,'g',0,'2011-12-28'),(509,'g',0,'2011-12-28'),(645,'g',0,'2011-12-28'),(829,'g',0,'2012-02-16'),(838,'g',0,'2011-12-28'),(832,'g',0,'2011-12-28'),(651,'g',0,'2011-12-28'),(464,'g',0,'2012-03-04'),(726,'g',0,'2012-03-04'),(452,'g',0,'2012-03-04'),(465,'g',0,'2012-03-04'),(528,'g',0,'2012-03-04'),(451,'g',0,'2011-12-28'),(725,'g',0,'2012-03-04'),(305,'g',0,'2011-12-28'),(246,'g',0,'2011-12-28'),(299,'g',0,'2011-12-28'),(291,'g',0,'2011-12-28'),(325,'g',0,'2011-12-28'),(298,'g',0,'2011-12-28'),(261,'g',0,'2011-12-28'),(288,'g',0,'2011-12-28'),(255,'g',0,'2011-12-28'),(488,'g',0,'2011-12-28'),(252,'g',0,'2011-12-28'),(659,'g',0,'2011-12-28'),(663,'g',0,'2011-12-28'),(660,'g',0,'2011-12-28'),(662,'g',0,'2011-12-28'),(666,'g',0,'2011-12-28'),(661,'g',0,'2011-12-28'),(665,'g',0,'2011-12-28'),(672,'g',0,'2011-12-28'),(658,'g',0,'2011-12-28'),(664,'g',0,'2011-12-28'),(727,'g',0,'2012-03-04'),(772,'g',0,'2012-02-17'),(563,'g',0,'2011-12-28'),(601,'g',0,'2011-12-28'),(577,'g',0,'2011-12-28'),(565,'g',0,'2011-12-28'),(562,'g',0,'2011-12-28'),(654,'g',0,'2011-12-28'),(777,'g',0,'2012-02-17'),(561,'g',0,'2011-12-28'),(564,'g',0,'2011-12-28'),(643,'g',0,'2012-03-03'),(490,'g',0,'2012-03-03'),(521,'g',0,'2011-12-28'),(656,'g',0,'2011-12-28'),(502,'g',0,'2012-03-04'),(503,'g',0,'2012-03-04'),(512,'g',0,'2012-03-03'),(519,'g',0,'2012-03-04'),(915,'g',0,'2011-12-29'),(964,'g',0,'2012-02-17'),(1081,'g',0,'2012-02-17'),(1016,'g',0,'2012-02-17'),(131,'g',0,'2011-12-29'),(194,'g',0,'2011-12-29'),(205,'g',0,'2012-03-05'),(218,'g',0,'2011-12-29'),(206,'g',0,'2011-12-29'),(229,'g',0,'2011-12-29'),(184,'g',0,'2011-12-29'),(251,'g',0,'2011-12-29'),(242,'g',0,'2011-12-29'),(237,'g',0,'2011-12-29'),(613,'g',0,'2012-02-17'),(761,'g',0,'2012-02-17'),(706,'g',0,'2012-02-17'),(587,'g',0,'2012-02-17'),(667,'g',0,'2012-02-17'),(611,'g',0,'2012-02-17'),(710,'g',0,'2012-02-17'),(709,'g',0,'2012-02-17'),(707,'g',0,'2012-02-17'),(708,'g',0,'2012-02-17'),(985,'g',0,'2012-02-17'),(908,'g',0,'2012-02-17'),(984,'g',0,'2012-02-17'),(907,'g',0,'2012-02-17'),(934,'g',0,'2012-02-17'),(935,'g',0,'2012-02-17'),(1039,'g',0,'2012-02-17'),(1038,'g',0,'2012-02-17'),(824,'g',0,'2012-02-17'),(839,'g',0,'2012-02-17'),(857,'g',0,'2012-02-17'),(880,'g',0,'2012-01-01'),(849,'g',0,'2012-02-17'),(872,'g',0,'2012-02-17'),(787,'g',0,'2012-02-17'),(912,'g',0,'2012-02-17'),(775,'g',0,'2012-02-17'),(1237,'g',0,'2012-02-17'),(1236,'g',0,'2012-02-17'),(1208,'g',0,'2012-02-17'),(947,'g',0,'2012-02-17'),(1134,'g',0,'2012-02-17'),(967,'g',0,'2012-02-17'),(1062,'g',0,'2012-02-17'),(999,'g',0,'2012-02-17'),(884,'g',0,'2012-02-15'),(943,'g',0,'2012-02-16'),(790,'g',0,'2012-02-15'),(861,'g',0,'2012-02-15'),(789,'g',0,'2012-02-15'),(316,'g',0,'2012-02-17'),(1325,'g',0,'2012-02-17'),(1153,'g',0,'2012-02-17'),(1228,'g',0,'2012-02-17'),(1311,'g',0,'2012-02-17'),(276,'g',0,'2012-01-05'),(323,'g',0,'2012-01-05'),(318,'g',0,'2012-01-05'),(310,'g',0,'2012-01-05'),(272,'g',0,'2012-01-05'),(315,'g',0,'2012-01-05'),(321,'g',0,'2012-01-05'),(430,'g',0,'2012-01-06'),(226,'g',0,'2012-01-06'),(220,'g',0,'2012-01-06'),(236,'g',0,'2012-01-06'),(240,'g',0,'2012-01-06'),(224,'g',0,'2012-01-06'),(176,'g',0,'2012-01-06'),(182,'g',0,'2012-01-06'),(128,'g',0,'2012-01-06'),(230,'g',0,'2012-01-06'),(1356,'g',0,'2012-02-17'),(1362,'g',0,'2012-02-17'),(1365,'g',0,'2012-02-17'),(895,'g',0,'2012-03-03'),(894,'g',0,'2012-03-03'),(896,'g',0,'2012-03-03'),(1119,'g',0,'2012-02-17'),(1192,'g',0,'2012-02-17'),(1052,'g',0,'2012-02-17'),(773,'g',0,'2012-03-04'),(779,'g',0,'2012-02-17'),(766,'g',0,'2012-03-04'),(455,'g',0,'2012-01-08'),(585,'g',0,'2012-01-08'),(531,'g',0,'2012-01-08'),(423,'g',0,'2012-01-08'),(576,'g',0,'2012-01-09'),(569,'g',0,'2012-01-09'),(573,'g',0,'2012-01-09'),(491,'g',0,'2012-01-09'),(1420,'g',0,'2012-02-17'),(254,'g',0,'2012-03-02'),(859,'g',0,'2012-01-21'),(265,'g',0,'2012-03-02'),(259,'g',0,'2012-03-02'),(253,'g',0,'2012-03-02'),(263,'g',0,'2012-03-02'),(269,'g',0,'2012-03-02'),(950,'g',0,'2012-01-21'),(1002,'g',0,'2012-01-21'),(1065,'g',0,'2012-01-21'),(1442,'g',0,'2012-01-21'),(1137,'g',0,'2012-01-21'),(1294,'g',0,'2012-01-21'),(1526,'g',0,'2012-01-21'),(1211,'g',0,'2012-01-21'),(1470,'g',0,'2012-01-21'),(1556,'g',0,'2012-03-02'),(1393,'g',0,'2012-03-02'),(1585,'g',0,'2012-03-02'),(1312,'g',0,'2012-03-04'),(917,'g',0,'2012-03-04'),(945,'g',0,'2012-01-22'),(868,'g',0,'2012-01-22'),(845,'g',0,'2012-01-22'),(871,'g',0,'2012-01-22'),(1481,'g',0,'2012-03-02'),(1487,'g',0,'2012-03-02'),(1501,'g',0,'2012-03-02'),(1241,'g',0,'2012-03-02'),(1472,'g',0,'2012-03-02'),(881,'g',0,'2012-03-02'),(858,'g',0,'2012-03-02'),(1609,'g',0,'2012-03-02'),(1622,'g',0,'2012-03-02'),(953,'g',0,'2012-03-04'),(997,'g',0,'2012-01-22'),(941,'g',0,'2012-01-22'),(1373,'g',0,'2012-01-22'),(1450,'g',0,'2012-01-22'),(856,'g',0,'2012-01-22'),(848,'g',0,'2012-01-22'),(296,'g',0,'2012-01-22'),(1446,'g',0,'2012-03-03'),(1534,'g',0,'2012-01-22'),(993,'g',0,'2012-01-22'),(1341,'g',0,'2012-03-02'),(1388,'g',0,'2012-01-24'),(1375,'g',0,'2012-03-02'),(820,'g',0,'2012-01-27'),(1354,'g',0,'2012-03-02'),(1347,'g',0,'2012-03-03'),(1399,'g',0,'2012-03-03'),(1436,'g',0,'2012-03-03'),(1480,'g',0,'2012-03-04'),(1564,'g',0,'2012-03-03'),(1743,'g',0,'2012-02-05'),(1689,'g',0,'2012-02-05'),(588,'g',0,'2012-02-05'),(589,'g',0,'2012-02-05'),(591,'g',0,'2012-02-06'),(671,'g',0,'2012-02-06'),(606,'g',0,'2012-02-06'),(596,'g',0,'2012-02-06'),(670,'g',0,'2012-02-06'),(888,'g',0,'2012-02-06'),(608,'g',0,'2012-02-06'),(597,'g',0,'2012-02-06'),(801,'g',0,'2012-02-06'),(786,'g',0,'2012-02-06'),(603,'g',0,'2012-02-06'),(825,'g',0,'2012-02-06'),(1693,'g',0,'2012-02-06'),(1750,'g',0,'2012-02-10'),(1670,'g',0,'2012-02-10'),(1755,'g',0,'2012-02-14'),(1695,'g',0,'2012-02-14'),(1819,'g',0,'2012-02-15'),(1820,'g',0,'2012-02-15'),(763,'g',0,'2012-02-16'),(808,'g',0,'2012-02-16'),(818,'g',0,'2012-02-16'),(823,'g',0,'2012-02-16'),(774,'g',0,'2012-02-16'),(1838,'g',0,'2012-02-16'),(198,'g',0,'2012-02-16'),(1741,'g',0,'2012-02-17'),(1729,'g',0,'2012-02-17'),(1725,'g',0,'2012-02-17'),(1736,'g',0,'2012-02-17'),(875,'g',0,'2012-02-17'),(864,'g',0,'2012-02-17'),(854,'g',0,'2012-02-17'),(876,'g',0,'2012-02-17'),(878,'g',0,'2012-02-17'),(869,'g',0,'2012-02-17'),(1857,'g',0,'2012-02-17'),(539,'g',0,'2012-02-17'),(1853,'g',0,'2012-02-17'),(1814,'g',0,'2012-02-17'),(1850,'g',0,'2012-02-17'),(1852,'g',0,'2012-02-17'),(1833,'g',0,'2012-02-17'),(1842,'g',0,'2012-02-17'),(1851,'g',0,'2012-02-17'),(1045,'g',0,'2012-02-17'),(1059,'g',0,'2012-02-17'),(760,'g',0,'2012-02-17'),(831,'g',0,'2012-02-17'),(669,'g',0,'2012-02-17'),(536,'g',0,'2012-02-17'),(887,'g',0,'2012-02-17'),(1111,'g',0,'2012-02-17'),(836,'g',0,'2012-02-17'),(956,'g',0,'2012-02-17'),(1072,'g',0,'2012-02-17'),(955,'g',0,'2012-02-17'),(1121,'g',0,'2012-02-17'),(1070,'g',0,'2012-02-17'),(942,'g',0,'2012-02-17'),(890,'g',0,'2012-02-17'),(97,'g',0,'2012-02-17'),(115,'g',0,'2012-02-17'),(110,'g',0,'2012-02-17'),(127,'g',0,'2012-02-17'),(846,'g',0,'2012-02-17'),(847,'g',0,'2012-02-17'),(996,'g',0,'2012-02-17'),(1123,'g',0,'2012-02-17'),(783,'g',0,'2012-02-17'),(816,'g',0,'2012-02-17'),(1129,'g',0,'2012-02-17'),(811,'g',0,'2012-02-17'),(771,'g',0,'2012-02-17'),(1007,'g',0,'2012-02-17'),(804,'g',0,'2012-02-17'),(155,'g',0,'2012-02-17'),(1008,'g',0,'2012-02-17'),(144,'g',0,'2012-02-17'),(852,'g',0,'2012-02-17'),(1260,'g',0,'2012-02-17'),(1104,'g',0,'2012-02-17'),(821,'g',0,'2012-02-17'),(853,'g',0,'2012-02-17'),(1324,'g',0,'2012-02-17'),(462,'g',0,'2012-02-17'),(479,'g',0,'2012-02-17'),(1261,'g',0,'2012-02-17'),(489,'g',0,'2012-02-17'),(1844,'g',0,'2012-02-17'),(527,'g',0,'2012-02-17'),(1473,'g',0,'2012-02-17'),(1638,'g',0,'2012-02-17'),(532,'g',0,'2012-02-17'),(1400,'g',0,'2012-02-17'),(1455,'g',0,'2012-02-17'),(855,'g',0,'2012-02-17'),(1489,'g',0,'2012-02-17'),(870,'g',0,'2012-02-17'),(867,'g',0,'2012-02-17'),(571,'g',0,'2012-02-17'),(1339,'g',0,'2012-02-17'),(533,'g',0,'2012-02-17'),(578,'g',0,'2012-02-17'),(877,'g',0,'2012-02-17'),(1235,'g',0,'2012-02-17'),(1263,'g',0,'2012-02-17'),(1275,'g',0,'2012-02-17'),(1249,'g',0,'2012-02-17'),(1102,'g',0,'2012-02-17'),(1280,'g',0,'2012-02-17'),(1101,'g',0,'2012-02-17'),(1268,'g',0,'2012-02-17'),(1161,'g',0,'2012-02-17'),(1429,'g',0,'2012-02-17'),(1168,'g',0,'2012-02-17'),(1415,'g',0,'2012-02-17'),(1413,'g',0,'2012-02-17'),(1447,'g',0,'2012-02-17'),(1173,'g',0,'2012-02-17'),(1468,'g',0,'2012-02-17'),(555,'g',0,'2012-02-17'),(835,'g',0,'2012-02-17'),(834,'g',0,'2012-02-17'),(1057,'g',0,'2012-02-17'),(837,'g',0,'2012-02-17'),(1073,'g',0,'2012-02-17'),(844,'g',0,'2012-02-17'),(944,'g',0,'2012-02-17'),(104,'g',0,'2012-02-17'),(121,'g',0,'2012-02-17'),(994,'g',0,'2012-02-17'),(815,'g',0,'2012-02-17'),(134,'g',0,'2012-02-17'),(819,'g',0,'2012-02-17'),(1105,'g',0,'2012-02-17'),(1178,'g',0,'2012-02-17'),(1177,'g',0,'2012-02-17'),(828,'g',0,'2012-02-17'),(830,'g',0,'2012-02-17'),(1316,'g',0,'2012-02-17'),(481,'g',0,'2012-02-17'),(1843,'g',0,'2012-02-17'),(1344,'g',0,'2012-02-17'),(1557,'g',0,'2012-02-17'),(535,'g',0,'2012-02-17'),(1147,'g',0,'2012-02-17'),(1126,'g',0,'2012-02-17'),(1387,'g',0,'2012-02-17'),(1250,'g',0,'2012-02-17'),(1154,'g',0,'2012-02-17'),(1334,'g',0,'2012-02-17'),(1753,'g',0,'2012-02-17'),(1414,'g',0,'2012-02-17'),(1174,'g',0,'2012-02-17'),(1175,'g',0,'2012-02-17'),(1422,'g',0,'2012-02-17'),(1419,'g',0,'2012-02-17'),(1571,'g',0,'2012-02-17'),(1456,'g',0,'2012-02-17'),(1740,'g',0,'2012-02-17'),(1702,'g',0,'2012-02-17'),(1525,'g',0,'2012-02-17'),(989,'g',0,'2012-02-17'),(990,'g',0,'2012-02-17'),(1061,'g',0,'2012-02-17'),(865,'g',0,'2012-02-17'),(863,'g',0,'2012-02-17'),(938,'g',0,'2012-02-17'),(946,'g',0,'2012-02-17'),(1020,'g',0,'2012-02-17'),(1133,'g',0,'2012-02-17'),(1120,'g',0,'2012-02-17'),(1042,'g',0,'2012-02-17'),(1043,'g',0,'2012-02-17'),(1046,'g',0,'2012-02-17'),(1389,'g',0,'2012-02-17'),(1841,'g',0,'2012-02-17'),(1831,'g',0,'2012-02-17'),(1441,'g',0,'2012-02-17'),(1565,'g',0,'2012-02-17'),(1540,'g',0,'2012-02-17'),(1822,'g',0,'2012-02-17'),(1180,'g',0,'2012-02-17'),(793,'g',0,'2012-02-17'),(1164,'g',0,'2012-02-17'),(1124,'g',0,'2012-02-17'),(1167,'g',0,'2012-02-17'),(797,'g',0,'2012-02-17'),(814,'g',0,'2012-02-17'),(1185,'g',0,'2012-02-17'),(1248,'g',0,'2012-02-17'),(1696,'g',0,'2012-02-17'),(1837,'g',0,'2012-02-17'),(842,'g',0,'2012-02-17'),(1538,'g',0,'2012-02-17'),(1582,'g',0,'2012-02-17'),(1247,'g',0,'2012-02-17'),(851,'g',0,'2012-02-17'),(1752,'g',0,'2012-02-17'),(886,'g',0,'2012-02-17'),(998,'g',0,'2012-02-17'),(1053,'g',0,'2012-02-17'),(988,'g',0,'2012-02-17'),(1193,'g',0,'2012-02-17'),(1207,'g',0,'2012-02-17'),(1047,'g',0,'2012-02-17'),(1165,'g',0,'2012-02-17'),(784,'g',0,'2012-02-17'),(1166,'g',0,'2012-02-17'),(794,'g',0,'2012-02-17'),(806,'g',0,'2012-02-17'),(1197,'g',0,'2012-02-17'),(1845,'g',0,'2012-02-17'),(1475,'g',0,'2012-02-18'),(1321,'g',0,'2012-02-18'),(1322,'g',0,'2012-02-18'),(1348,'g',0,'2012-02-18'),(1491,'g',0,'2012-02-18'),(1330,'g',0,'2012-02-18'),(1333,'g',0,'2012-02-18'),(1288,'g',0,'2012-02-18'),(1476,'g',0,'2012-02-18'),(1485,'g',0,'2012-02-18'),(1492,'g',0,'2012-02-18'),(1496,'g',0,'2012-02-18'),(1484,'g',0,'2012-02-18'),(1523,'g',0,'2012-02-18'),(1471,'g',0,'2012-02-18'),(1314,'g',0,'2012-02-18'),(1301,'g',0,'2012-02-18'),(1520,'g',0,'2012-02-18'),(1338,'g',0,'2012-02-18'),(1299,'g',0,'2012-02-18'),(1647,'g',0,'2012-02-19'),(526,'g',0,'2012-02-19'),(581,'g',0,'2012-02-19'),(570,'g',0,'2012-02-19'),(548,'g',0,'2012-02-19'),(1462,'g',0,'2012-02-19'),(1575,'g',0,'2012-02-19'),(1359,'g',0,'2012-02-19'),(1734,'g',0,'2012-02-19'),(1386,'g',0,'2012-02-19'),(1553,'g',0,'2012-02-19'),(1397,'g',0,'2012-02-19'),(540,'g',0,'2012-02-19'),(551,'g',0,'2012-02-19'),(1690,'g',0,'2012-02-19'),(552,'g',0,'2012-02-19'),(1439,'g',0,'2012-02-19'),(549,'g',0,'2012-02-19'),(1406,'g',0,'2012-02-19'),(550,'g',0,'2012-02-19'),(1426,'g',0,'2012-02-19'),(582,'g',0,'2012-02-19'),(1728,'g',0,'2012-02-19'),(1611,'g',0,'2012-02-19'),(1604,'g',0,'2012-02-19'),(1836,'g',0,'2012-02-19'),(1380,'g',0,'2012-02-19'),(1624,'g',0,'2012-02-19'),(1576,'g',0,'2012-02-19'),(1698,'g',0,'2012-02-19'),(1722,'g',0,'2012-02-19'),(1639,'g',0,'2012-02-19'),(1546,'g',0,'2012-02-20'),(1569,'g',0,'2012-02-20'),(1580,'g',0,'2012-02-20'),(1723,'g',0,'2012-02-20'),(1568,'g',0,'2012-02-20'),(1440,'g',0,'2012-02-20'),(1542,'g',0,'2012-02-20'),(1730,'g',0,'2012-02-20'),(1821,'g',0,'2012-02-20'),(1427,'g',0,'2012-02-20'),(1361,'g',0,'2012-02-20'),(1378,'g',0,'2012-02-20'),(1678,'g',0,'2012-02-20'),(1452,'g',0,'2012-02-20'),(1423,'g',0,'2012-02-20'),(1677,'g',0,'2012-02-20'),(1640,'g',0,'2012-02-20'),(1692,'g',0,'2012-02-20'),(1555,'g',0,'2012-02-20'),(1701,'g',0,'2012-02-20'),(1610,'g',0,'2012-02-20'),(1655,'g',0,'2012-02-20'),(1390,'g',0,'2012-02-20'),(1619,'g',0,'2012-02-20'),(1644,'g',0,'2012-02-20'),(1469,'g',0,'2012-02-21'),(1632,'g',0,'2012-02-21'),(1350,'g',0,'2012-02-21'),(1559,'g',0,'2012-02-21'),(1524,'g',0,'2012-02-21'),(1458,'g',0,'2012-02-21'),(1402,'g',0,'2012-02-21'),(1364,'g',0,'2012-02-21'),(1662,'g',0,'2012-02-21'),(1536,'g',0,'2012-02-22'),(1606,'g',0,'2012-02-22'),(1754,'g',0,'2012-02-23'),(1683,'g',0,'2012-02-23'),(1623,'g',0,'2012-02-23'),(1204,'g',0,'2012-02-23'),(1251,'g',0,'2012-02-23'),(1283,'g',0,'2012-02-23'),(1200,'g',0,'2012-02-23'),(1257,'g',0,'2012-02-23'),(1221,'g',0,'2012-02-23'),(1229,'g',0,'2012-02-23'),(1258,'g',0,'2012-02-23'),(1304,'g',0,'2012-02-23'),(1244,'g',0,'2012-02-23'),(1256,'g',0,'2012-02-23'),(1130,'g',0,'2012-02-23'),(1445,'g',0,'2012-02-23'),(1152,'g',0,'2012-02-23'),(931,'g',0,'2012-02-23'),(1075,'g',0,'2012-02-23'),(980,'g',0,'2012-02-23'),(1036,'g',0,'2012-02-23'),(968,'g',0,'2012-02-23'),(932,'g',0,'2012-02-23'),(1675,'g',0,'2012-02-23'),(1641,'g',0,'2012-02-23'),(1666,'g',0,'2012-02-23'),(1463,'g',0,'2012-02-23'),(1227,'g',0,'2012-02-23'),(1303,'g',0,'2012-02-23'),(1392,'g',0,'2012-02-23'),(1220,'g',0,'2012-02-23'),(1310,'g',0,'2012-02-23'),(1411,'g',0,'2012-02-23'),(1240,'g',0,'2012-02-23'),(1100,'g',0,'2012-02-23'),(1035,'g',0,'2012-02-23'),(1082,'g',0,'2012-02-23'),(1029,'g',0,'2012-02-23'),(1095,'g',0,'2012-02-23'),(995,'g',0,'2012-02-23'),(1034,'g',0,'2012-02-23'),(1088,'g',0,'2012-02-23'),(1022,'g',0,'2012-02-23'),(1017,'g',0,'2012-02-24'),(958,'g',0,'2012-02-24'),(975,'g',0,'2012-02-24'),(982,'g',0,'2012-02-24'),(1710,'g',0,'2012-02-24'),(1828,'g',0,'2012-02-24'),(1317,'g',0,'2012-02-24'),(1320,'g',0,'2012-02-24'),(1287,'g',0,'2012-02-24'),(1684,'g',0,'2012-02-24'),(1183,'g',0,'2012-02-24'),(1110,'g',0,'2012-02-24'),(1285,'g',0,'2012-02-24'),(1234,'g',0,'2012-02-24'),(1132,'g',0,'2012-02-24'),(1329,'g',0,'2012-02-24'),(1206,'g',0,'2012-02-24'),(1384,'g',0,'2012-02-24'),(1431,'g',0,'2012-02-24'),(1707,'g',0,'2012-02-24'),(1128,'g',0,'2012-02-25'),(1336,'g',0,'2012-02-25'),(1058,'g',0,'2012-02-25'),(1289,'g',0,'2012-02-25'),(1056,'g',0,'2012-02-25'),(1010,'g',0,'2012-02-25'),(1464,'g',0,'2012-02-25'),(1433,'g',0,'2012-02-25'),(1418,'g',0,'2012-02-25'),(1407,'g',0,'2012-02-25'),(1432,'g',0,'2012-02-25'),(1694,'g',0,'2012-02-25'),(1044,'g',0,'2012-02-25'),(1060,'g',0,'2012-02-25'),(1434,'g',0,'2012-02-25'),(1467,'g',0,'2012-02-25'),(1125,'g',0,'2012-02-25'),(1158,'g',0,'2012-02-25'),(704,'g',0,'2012-02-25'),(981,'g',0,'2012-02-25'),(1202,'g',0,'2012-02-26'),(728,'g',0,'2012-02-26'),(1653,'g',0,'2012-02-26'),(700,'g',0,'2012-02-26'),(1282,'g',0,'2012-02-26'),(1266,'g',0,'2012-02-26'),(703,'g',0,'2012-02-26'),(702,'g',0,'2012-02-26'),(1290,'g',0,'2012-02-26'),(1648,'g',0,'2012-02-26'),(1199,'g',0,'2012-02-26'),(701,'g',0,'2012-02-26'),(705,'g',0,'2012-02-26'),(1276,'g',0,'2012-02-26'),(729,'g',0,'2012-02-26'),(1649,'g',0,'2012-02-26'),(1421,'g',0,'2012-02-26'),(1532,'g',0,'2012-02-26'),(1444,'g',0,'2012-02-26'),(1448,'g',0,'2012-02-26'),(1383,'g',0,'2012-02-26'),(1454,'g',0,'2012-02-26'),(1528,'g',0,'2012-02-26'),(1827,'g',0,'2012-02-26'),(1498,'g',0,'2012-02-26'),(1425,'g',0,'2012-02-26'),(1424,'g',0,'2012-02-26'),(731,'g',0,'2012-02-26'),(730,'g',0,'2012-02-26'),(1651,'g',0,'2012-02-26'),(1650,'g',0,'2012-02-27'),(1654,'g',0,'2012-02-27'),(740,'g',0,'2012-02-27'),(734,'g',0,'2012-02-27'),(694,'g',0,'2012-02-27'),(1486,'g',0,'2012-02-27'),(690,'g',0,'2012-02-27'),(756,'g',0,'2012-02-27'),(699,'g',0,'2012-02-27'),(695,'g',0,'2012-02-27'),(741,'g',0,'2012-02-27'),(696,'g',0,'2012-02-27'),(738,'g',0,'2012-02-27'),(698,'g',0,'2012-02-27'),(1652,'g',0,'2012-02-27'),(211,'g',0,'2012-02-27'),(342,'g',0,'2012-02-27'),(348,'g',0,'2012-02-27'),(691,'g',0,'2012-02-27'),(753,'g',0,'2012-02-27'),(758,'g',0,'2012-02-28'),(736,'g',0,'2012-02-28'),(735,'g',0,'2012-02-28'),(737,'g',0,'2012-02-28'),(697,'g',0,'2012-02-28'),(685,'g',0,'2012-02-28'),(689,'g',0,'2012-02-28'),(739,'g',0,'2012-02-28'),(686,'g',0,'2012-02-28'),(692,'g',0,'2012-02-28'),(684,'g',0,'2012-02-28'),(963,'g',0,'2012-02-28'),(1080,'g',0,'2012-02-28'),(755,'g',0,'2012-02-28'),(554,'g',0,'2012-02-28'),(1074,'g',0,'2012-02-28'),(219,'g',0,'2012-02-28'),(419,'g',0,'2012-02-28'),(311,'g',0,'2012-02-28'),(504,'g',0,'2012-02-28'),(520,'g',0,'2012-02-28'),(437,'g',0,'2012-02-28'),(497,'g',0,'2012-02-28'),(1839,'g',0,'2012-02-28'),(754,'g',0,'2012-02-28'),(732,'g',0,'2012-02-28'),(752,'g',0,'2012-02-28'),(765,'g',0,'2012-02-28'),(687,'g',0,'2012-02-28'),(805,'g',0,'2012-02-28'),(607,'g',0,'2012-02-28'),(440,'g',0,'2012-02-28'),(505,'g',0,'2012-02-28'),(1643,'g',0,'2012-02-28'),(1009,'g',0,'2012-02-28'),(1015,'g',0,'2012-02-28'),(957,'g',0,'2012-02-28'),(420,'g',0,'2012-02-28'),(1840,'g',0,'2012-02-28'),(1573,'g',0,'2012-02-28'),(1862,'g',0,'2012-02-28'),(757,'g',0,'2012-02-28'),(759,'g',0,'2012-02-28'),(683,'g',0,'2012-02-28'),(812,'g',0,'2012-02-28'),(441,'g',0,'2012-02-28'),(688,'g',0,'2012-02-28'),(693,'g',0,'2012-02-28'),(1146,'g',0,'2012-02-28'),(495,'g',0,'2012-02-28'),(1539,'g',0,'2012-02-28'),(1642,'g',0,'2012-02-28'),(1731,'g',0,'2012-02-28'),(733,'g',0,'2012-02-28'),(762,'g',0,'2012-02-28'),(320,'g',0,'2012-02-29'),(1846,'g',0,'2012-02-29'),(1691,'g',0,'2012-02-29'),(1859,'g',0,'2012-03-01'),(1890,'g',0,'2012-03-01'),(1897,'g',0,'2012-03-02'),(83,'g',0,'2012-03-02'),(80,'g',0,'2012-03-02'),(187,'g',0,'2012-03-02'),(197,'g',0,'2012-03-02'),(203,'g',0,'2012-03-02'),(213,'g',0,'2012-03-02'),(243,'g',0,'2012-03-02'),(232,'g',0,'2012-03-02'),(245,'g',0,'2012-03-02'),(238,'g',0,'2012-03-02'),(235,'g',0,'2012-03-02'),(241,'g',0,'2012-03-02'),(239,'g',0,'2012-03-02'),(249,'g',0,'2012-03-02'),(250,'g',0,'2012-03-02'),(1459,'g',0,'2012-03-02'),(1830,'g',0,'2012-03-02'),(1493,'g',0,'2012-03-02'),(1627,'g',0,'2012-03-02'),(1577,'g',0,'2012-03-02'),(1543,'g',0,'2012-03-02'),(1006,'g',0,'2012-03-02'),(1673,'g',0,'2012-03-02'),(954,'g',0,'2012-03-02'),(1708,'g',0,'2012-03-02'),(1191,'g',0,'2012-03-02'),(1215,'g',0,'2012-03-02'),(1370,'g',0,'2012-03-02'),(1898,'g',0,'2012-03-02'),(1069,'g',0,'2012-03-02'),(923,'g',0,'2012-03-02'),(937,'g',0,'2012-03-02'),(924,'g',0,'2012-03-02'),(922,'g',0,'2012-03-02'),(987,'g',0,'2012-03-02'),(973,'g',0,'2012-03-02'),(1051,'g',0,'2012-03-02'),(1141,'g',0,'2012-03-02'),(1118,'g',0,'2012-03-02'),(1869,'g',0,'2012-03-02'),(1614,'g',0,'2012-03-02'),(1298,'g',0,'2012-03-02'),(193,'g',0,'2012-03-02'),(217,'g',0,'2012-03-02'),(228,'g',0,'2012-03-02'),(247,'g',0,'2012-03-02'),(234,'g',0,'2012-03-02'),(1657,'g',0,'2012-03-02'),(972,'g',0,'2012-03-02'),(971,'g',0,'2012-03-02'),(974,'g',0,'2012-03-02'),(1025,'g',0,'2012-03-02'),(1870,'g',0,'2012-03-03'),(1889,'g',0,'2012-03-03'),(1669,'g',0,'2012-03-03'),(1628,'g',0,'2012-03-03'),(1895,'g',0,'2012-03-03'),(1886,'g',0,'2012-03-03'),(1885,'g',0,'2012-03-03'),(1888,'g',0,'2012-03-03'),(1453,'g',0,'2012-03-03'),(1530,'g',0,'2012-03-03'),(1027,'g',0,'2012-03-03'),(1041,'g',0,'2012-03-03'),(1028,'g',0,'2012-03-03'),(1091,'g',0,'2012-03-03'),(1093,'g',0,'2012-03-03'),(1092,'g',0,'2012-03-03'),(1094,'g',0,'2012-03-03'),(1107,'g',0,'2012-03-03'),(921,'g',0,'2012-03-03'),(1552,'g',0,'2012-03-04'),(1482,'g',0,'2012-03-04'),(1531,'g',0,'2012-03-04'),(1566,'g',0,'2012-03-04'),(1864,'g',0,'2012-03-04'),(1867,'g',0,'2012-03-04'),(1026,'g',0,'2012-03-04'),(897,'g',0,'2012-03-04'),(1537,'g',0,'2012-03-04'),(1615,'g',0,'2012-03-04'),(1876,'g',0,'2012-03-04'),(1892,'g',0,'2012-03-04'),(1659,'g',0,'2012-03-04'),(1887,'g',0,'2012-03-04'),(1112,'g',0,'2012-03-04'),(910,'g',0,'2012-03-04'),(1005,'g',0,'2012-03-04'),(286,'g',0,'2012-03-05'),(293,'g',0,'2012-03-05'),(273,'g',0,'2012-03-05'),(257,'g',0,'2012-03-05'),(1832,'g',0,'2012-03-05'),(1854,'g',0,'2012-03-06'),(1253,'g',0,'2012-03-06'),(1709,'g',0,'2012-03-06');

--
-- 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 ('JXM6nzWDkARejxKNKiw4iA','YPkNNoOYbIVlJan8REnTh5cZhkvi9okwXFkPl3rbgu8','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`
--

INSERT INTO `idx_searchlog` VALUES ('Family Law London','2011-11-10 09:27:17',1,'203.92.47.195'),('Automatic Gates Portsmouth','2011-11-10 09:27:50',1,'203.92.47.195'),('Hot Tubs Hemel Hempstead','2011-11-10 09:28:24',1,'203.92.47.195'),('Plumber in Colchester','2011-11-10 09:38:27',0,'203.92.47.195'),('Waste Management Banbury','2011-11-10 09:38:37',1,'203.92.47.195'),('Storage Swindon','2011-11-10 09:38:56',1,'203.92.47.195'),('Bedrooms Bedford','2011-11-10 09:39:22',1,'203.92.47.195'),('Blasting Sand London','2011-11-10 09:39:34',1,'203.92.47.195'),('Air Conditioning Reading','2011-11-10 09:39:45',1,'203.92.47.195'),('Windscreen Cambridge','2011-11-10 09:41:13',1,'203.92.47.195'),('Washing Machines Southampton','2011-11-10 09:44:05',1,'203.92.47.195'),('Roofing Bracknell','2011-11-10 10:02:35',1,'203.92.47.195'),('Glaziers Ascot','2011-11-10 10:02:52',1,'203.92.47.195'),('Plumbers Merchants Bromsgrove','2011-11-10 10:03:14',1,'203.92.47.195'),('Disability Bathrooms Torquay','2011-11-10 10:03:25',1,'203.92.47.195'),('Marquees Bristol','2011-11-10 10:03:43',1,'203.92.47.195'),('Waste Disposal Hertfordshire','2011-11-10 10:03:53',1,'203.92.47.195'),('Plumber in Ipswich','2011-11-10 10:04:04',1,'203.92.47.195'),('Plumber in Newmarket','2011-11-10 10:04:15',1,'203.92.47.195'),('Plumber in Brentwood','2011-11-10 10:04:25',1,'203.92.47.195'),('Plumber in Colchester','2011-11-10 10:04:38',1,'203.92.47.195'),('Driveways Gloucester','2011-11-10 10:17:40',1,'203.92.47.195'),('Bathrooms Bath','2011-11-10 10:17:59',4,'203.92.47.195'),('Care Services Somerset','2011-11-10 10:18:22',1,'203.92.47.195'),('Jobs In Somerset','2011-11-10 10:18:34',1,'203.92.47.195'),('Double Glazing Hertfordshire','2011-11-10 10:18:47',0,'203.92.47.195'),('Double Glazing Hertfordshire','2011-11-10 10:18:57',0,'203.92.47.195'),('Double Glazing Hertfordshire','2011-11-10 10:19:35',1,'203.92.47.195'),('Clutch Replacement Bristol','2011-11-10 10:19:45',1,'203.92.47.195'),('Courier Service High Wycombe','2011-11-10 10:19:57',1,'203.92.47.195'),('Boiler Repairs Guildford','2011-11-10 10:20:08',1,'203.92.47.195'),('Tree Surgery Guildford','2011-11-10 10:20:22',1,'203.92.47.195'),('Roofing company Bromley','2011-11-10 10:20:33',1,'203.92.47.195'),('Plumbers Newcastle','2011-11-10 10:27:03',1,'203.92.47.195'),('Fireplaces London','2011-11-10 10:27:19',1,'203.92.47.195'),('Windscreens Bristol','2011-11-10 10:27:55',0,'203.92.47.195'),('Windscreens Bristol','2011-11-10 10:28:11',0,'203.92.47.195'),('Fence Panels Bath','2011-11-10 10:28:22',1,'203.92.47.195'),('Windscreens Bristol','2011-11-10 10:29:22',1,'203.92.47.195'),('Heating System Lancing','2011-11-10 10:29:35',1,'203.92.47.195'),('Bathrooms Halton','2011-11-10 10:29:45',1,'203.92.47.195'),('Driving test Nottingham','2011-11-10 10:29:58',1,'203.92.47.195'),('Builders Bristol','2011-11-10 10:30:10',1,'203.92.47.195'),('Hydroponics Liverpool','2011-11-10 10:30:22',1,'203.92.47.195'),('Roofing Nottingham','2011-11-10 10:30:32',3,'203.92.47.195'),('Flat Roofs Nottingham','2011-11-10 10:30:51',2,'203.92.47.195'),('Curtain Cleaning London','2011-11-10 10:35:55',1,'203.92.47.195'),('Mirrors Reading','2011-11-10 10:36:07',0,'203.92.47.195'),('Mirrors Reading','2011-11-10 10:36:47',1,'203.92.47.195'),('Locksmith Portsmouth','2011-11-10 10:36:58',1,'203.92.47.195'),('Gates Surrey','2011-11-10 10:37:10',1,'203.92.47.195'),('Skips Oxford','2011-11-10 10:37:24',1,'203.92.47.195'),('Concrete Newcastle Upon Tyne','2011-11-10 10:37:37',1,'203.92.47.195'),('Window Cleaning Watford','2011-11-10 10:37:49',1,'203.92.47.195'),('Conservatories Medway','2011-11-10 10:38:02',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','hotdirectory.co.uk'),(5,'site_url','http://hotdirectory.co.uk'),(6,'email_address','ayannas.habenicht@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/hotdirec/public_html/themes/'),(9,'admin_template_path','/home/hotdirec/public_html/admin_tpl/'),(10,'plugin_path','/home/hotdirec/public_html/plugin/'),(12,'active_theme','hotdirectory'),(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 default '',
  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`
--



