--
-- Host: livewebdir.com    Database: santosh_live
-- ------------------------------------------------------


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

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

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

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


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

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

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



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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (1,0,'Arts & Music ','','folder.gif','','1',13,'','','0','0','','',0,'',7,0,0,0,0),(2,0,'Auto Industry ','','folder.gif','','1',35,'','','0','0','','',0,'',3,0,0,0,0),(3,0,'Economy & Business  ','','folder.gif','','1',129,'','','0','0','','',0,'',1,0,0,0,0),(4,0,'Careers & Job Search ','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Clothing Accessories ','','folder.gif','','1',9,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Communications Services ','','folder.gif','','1',18,'','','0','0','','',0,'',1,0,0,0,0),(7,0,'Computer Services ','','folder.gif','','1',20,'','','0','0','','',0,'',2,0,0,0,0),(8,0,'Building & Construction  ','','folder.gif','','1',78,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental','','folder.gif','','1',20,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Educational Resources ','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Recruitment Services ','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Gifts & Flowers ','','folder.gif','','1',23,'','','0','0','','',0,'',1,0,0,0,0),(13,0,'Hardware & Software Resources ','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Medical & Health ','','folder.gif','','1',35,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Management  ','','folder.gif','','1',149,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Heating and Air Conditioning Contractors ','','folder.gif','','1',46,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home & Family  ','','folder.gif','','1',21,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement & Decor ','','folder.gif','','1',267,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Accomadation ','','folder.gif','','1',36,'','','0','0','','',0,'',1,0,0,0,0),(20,0,'Insurance Companies ','','folder.gif','','1',28,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law ','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Judges ','','folder.gif','','1',154,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Dating & Relationships  ','','folder.gif','','1',4,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine & Hospitals  ','','folder.gif','','1',7,'','','0','0','','',0,'',1,0,0,0,0),(25,0,'Finance & Investment Services   ','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News & Magazines ','','folder.gif','','1',1,'','','0','0','','',0,'',1,0,0,0,0),(27,0,'Plumbing Services ','','folder.gif','','1',33,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate Development  ','','folder.gif','','1',25,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Science & Technology   ','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'SEO & SMO ','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Shopping ','','folder.gif','','1',61,'','','0','0','','',0,'',1,0,0,0,0),(32,0,'Sports & Games ','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Transportation and Logistics ','','folder.gif','','1',40,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Travel ','','folder.gif','','1',17,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Wedding ','','folder.gif','','1',10,'','','0','0','','',0,'',0,0,0,0,0);

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

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

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

INSERT INTO `idx_category_path` VALUES (1,'Arts & Music ','<a href=\"http://livewebdir.com/arts-music/\" name=\"cat_1\" style=\"\">Arts & Music </a>',';0;'),(2,'Auto Industry ','<a href=\"http://livewebdir.com/auto-industry/\" name=\"cat_2\" style=\"\">Auto Industry </a>',';0;'),(3,'Economy & Business  ','<a href=\"http://livewebdir.com/economy-business/\" name=\"cat_3\" style=\"\">Economy & Business  </a>',';0;'),(4,'Careers & Job Search ','<a href=\"http://livewebdir.com/careers-job-search/\" name=\"cat_4\" style=\"\">Careers & Job Search </a>',';0;'),(5,'Clothing Accessories ','<a href=\"http://livewebdir.com/clothing-accessories/\" name=\"cat_5\" style=\"\">Clothing Accessories </a>',';0;'),(6,'Communications Services ','<a href=\"http://livewebdir.com/communications-services/\" name=\"cat_6\" style=\"\">Communications Services </a>',';0;'),(7,'Computer Services ','<a href=\"http://livewebdir.com/computer-services/\" name=\"cat_7\" style=\"\">Computer Services </a>',';0;'),(8,'Building & Construction  ','<a href=\"http://livewebdir.com/building-construction/\" name=\"cat_8\" style=\"\">Building & Construction  </a>',';0;'),(9,'Dental','<a href=\"http://livewebdir.com/dental/\" name=\"cat_9\" style=\"\">Dental</a>',';0;'),(10,'Educational Resources ','<a href=\"http://livewebdir.com/educational-resources/\" name=\"cat_10\" style=\"\">Educational Resources </a>',';0;'),(11,'Recruitment Services ','<a href=\"http://livewebdir.com/recruitment-services/\" name=\"cat_11\" style=\"\">Recruitment Services </a>',';0;'),(12,'Gifts & Flowers ','<a href=\"http://livewebdir.com/gifts-flowers/\" name=\"cat_12\" style=\"\">Gifts & Flowers </a>',';0;'),(13,'Hardware & Software Resources ','<a href=\"http://livewebdir.com/hardware-software-resources/\" name=\"cat_13\" style=\"\">Hardware & Software Resources </a>',';0;'),(14,'Medical & Health ','<a href=\"http://livewebdir.com/medical-health/\" name=\"cat_14\" style=\"\">Medical & Health </a>',';0;'),(15,'Healthcare Management  ','<a href=\"http://livewebdir.com/healthcare-management/\" name=\"cat_15\" style=\"\">Healthcare Management  </a>',';0;'),(16,'Heating and Air Conditioning Contractors ','<a href=\"http://livewebdir.com/heating-and-air-conditioning-contractors/\" name=\"cat_16\" style=\"\">Heating and Air Conditioning Contractors </a>',';0;'),(17,'Home & Family  ','<a href=\"http://livewebdir.com/home-family/\" name=\"cat_17\" style=\"\">Home & Family  </a>',';0;'),(18,'Home Improvement & Decor ','<a href=\"http://livewebdir.com/home-improvement-decor/\" name=\"cat_18\" style=\"\">Home Improvement & Decor </a>',';0;'),(19,'Hotels & Accomadation ','<a href=\"http://livewebdir.com/hotels-accomadation/\" name=\"cat_19\" style=\"\">Hotels & Accomadation </a>',';0;'),(20,'Insurance Companies ','<a href=\"http://livewebdir.com/insurance-companies/\" name=\"cat_20\" style=\"\">Insurance Companies </a>',';0;'),(21,'Law ','<a href=\"http://livewebdir.com/law/\" name=\"cat_21\" style=\"\">Law </a>',';0;'),(22,'Lawyers & Judges ','<a href=\"http://livewebdir.com/lawyers-judges/\" name=\"cat_22\" style=\"\">Lawyers & Judges </a>',';0;'),(23,'Dating & Relationships  ','<a href=\"http://livewebdir.com/dating-relationships/\" name=\"cat_23\" style=\"\">Dating & Relationships  </a>',';0;'),(24,'Medicine & Hospitals  ','<a href=\"http://livewebdir.com/medicine-hospitals/\" name=\"cat_24\" style=\"\">Medicine & Hospitals  </a>',';0;'),(25,'Finance & Investment Services   ','<a href=\"http://livewebdir.com/finance-investment-services/\" name=\"cat_25\" style=\"\">Finance & Investment Services   </a>',';0;'),(26,'News & Magazines ','<a href=\"http://livewebdir.com/news-magazines/\" name=\"cat_26\" style=\"\">News & Magazines </a>',';0;'),(27,'Plumbing Services ','<a href=\"http://livewebdir.com/plumbing-services/\" name=\"cat_27\" style=\"\">Plumbing Services </a>',';0;'),(28,'Real Estate Development  ','<a href=\"http://livewebdir.com/real-estate-development/\" name=\"cat_28\" style=\"\">Real Estate Development  </a>',';0;'),(29,'Science & Technology   ','<a href=\"http://livewebdir.com/science-technology/\" name=\"cat_29\" style=\"\">Science & Technology   </a>',';0;'),(30,'SEO & SMO ','<a href=\"http://livewebdir.com/seo-smo/\" name=\"cat_30\" style=\"\">SEO & SMO </a>',';0;'),(31,'Shopping ','<a href=\"http://livewebdir.com/shopping/\" name=\"cat_31\" style=\"\">Shopping </a>',';0;'),(32,'Sports & Games ','<a href=\"http://livewebdir.com/sports-games/\" name=\"cat_32\" style=\"\">Sports & Games </a>',';0;'),(33,'Transportation and Logistics ','<a href=\"http://livewebdir.com/transportation-and-logistics/\" name=\"cat_33\" style=\"\">Transportation and Logistics </a>',';0;'),(34,'Travel ','<a href=\"http://livewebdir.com/travel/\" name=\"cat_34\" style=\"\">Travel </a>',';0;'),(35,'Wedding ','<a href=\"http://livewebdir.com/wedding/\" name=\"cat_35\" style=\"\">Wedding </a>',';0;');

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

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

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

INSERT INTO `idx_category_suggession` VALUES (1,33,'Daisy','You really found a way to make this whole procses easier.','2011-12-07 10:00:45');

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

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

INSERT INTO `idx_favorites` VALUES (1,'adaptive84','2011-12-07','My Favorites',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (1,'g',4,'2011-09-30'),(2,'g',5,'2011-09-30'),(7,'g',1,'2011-09-30'),(4,'g',0,'2011-09-30'),(3,'g',2,'2011-09-30'),(6,'g',0,'2011-10-09'),(10,'g',0,'2011-10-09'),(9,'g',2,'2011-09-30'),(5,'g',0,'2011-10-09'),(8,'g',0,'2011-09-29'),(11,'g',0,'2011-09-30'),(12,'g',0,'2011-10-09'),(14,'g',3,'2011-09-29'),(13,'g',0,'2011-10-08'),(15,'g',4,'2011-09-30'),(16,'g',0,'2011-10-14'),(19,'g',0,'2011-10-08'),(22,'g',6,'2011-10-05'),(18,'g',0,'2011-10-08'),(21,'g',0,'2012-02-24'),(27,'g',0,'2011-09-05'),(26,'g',0,'2011-10-14'),(31,'g',5,'2011-09-08'),(34,'g',6,'2011-09-09'),(24,'g',0,'2011-10-15'),(32,'g',4,'2011-09-09'),(30,'g',3,'2011-09-09'),(41,'g',3,'2011-09-14'),(39,'g',6,'2011-09-14'),(48,'g',2,'2011-09-14'),(45,'g',2,'2011-09-14'),(44,'g',2,'2011-09-14'),(37,'g',4,'2011-09-14'),(43,'g',0,'2011-09-14'),(47,'g',2,'2011-09-14'),(46,'g',0,'2011-09-14'),(33,'g',4,'2011-09-15'),(53,'g',0,'2011-09-18'),(59,'g',0,'2011-09-18'),(56,'g',0,'2011-09-18'),(100,'g',0,'2011-09-21'),(102,'g',3,'2011-09-22'),(105,'g',6,'2011-09-22'),(101,'g',3,'2011-09-22'),(40,'g',0,'2011-09-23'),(35,'g',0,'2011-09-23'),(38,'g',1,'2011-09-23'),(17,'g',3,'2011-09-23'),(29,'g',4,'2011-09-23'),(23,'g',2,'2011-09-23'),(36,'g',2,'2011-09-23'),(20,'g',0,'2011-09-23'),(25,'g',3,'2011-09-23'),(28,'g',0,'2011-09-23'),(93,'g',0,'2012-02-24'),(111,'g',0,'2011-09-25'),(96,'g',2,'2011-09-26'),(119,'g',0,'2012-01-17'),(107,'g',0,'2011-11-04'),(106,'g',0,'2012-02-13'),(120,'g',0,'2012-02-24'),(117,'g',0,'2012-01-26'),(121,'g',4,'2011-09-29'),(123,'g',2,'2011-09-29'),(112,'g',2,'2011-09-29'),(122,'g',3,'2011-09-29'),(103,'g',0,'2011-09-30'),(129,'g',0,'2012-01-09'),(130,'g',2,'2011-10-01'),(134,'g',0,'2012-01-26'),(140,'g',0,'2012-02-09'),(131,'g',2,'2011-10-01'),(136,'g',2,'2011-10-01'),(108,'g',0,'2012-02-09'),(142,'g',2,'2011-10-02'),(92,'g',0,'2012-01-23'),(127,'g',0,'2011-10-03'),(143,'g',1,'2011-10-03'),(151,'g',2,'2011-10-03'),(146,'g',0,'2012-02-12'),(118,'g',0,'2012-01-04'),(155,'g',3,'2011-10-05'),(157,'g',0,'2011-10-05'),(161,'g',0,'2011-10-09'),(132,'g',0,'2011-10-09'),(135,'g',0,'2012-02-13'),(133,'g',0,'2012-02-24'),(52,'g',0,'2011-10-12'),(62,'g',0,'2011-10-12'),(49,'g',0,'2011-10-12'),(51,'g',0,'2011-10-12'),(64,'g',0,'2011-10-12'),(50,'g',0,'2011-10-12'),(54,'g',0,'2011-10-12'),(61,'g',0,'2011-10-12'),(65,'g',0,'2011-10-12'),(42,'g',0,'2011-10-12'),(94,'g',0,'2011-10-12'),(60,'g',0,'2011-10-12'),(63,'g',0,'2011-10-12'),(58,'g',0,'2011-10-12'),(55,'g',0,'2011-10-12'),(57,'g',0,'2011-10-12'),(104,'g',0,'2011-10-12'),(109,'g',0,'2011-10-12'),(110,'g',0,'2011-10-12'),(113,'g',0,'2011-10-12'),(152,'g',0,'2011-10-13'),(160,'g',0,'2011-10-15'),(197,'g',0,'2012-02-24'),(191,'g',0,'2012-02-12'),(116,'g',0,'2011-10-16'),(178,'g',0,'2012-01-26'),(148,'g',0,'2011-10-16'),(150,'g',0,'2011-10-16'),(205,'g',0,'2012-02-06'),(149,'g',0,'2011-10-16'),(236,'g',0,'2011-10-16'),(189,'g',0,'2012-02-17'),(213,'g',0,'2012-02-13'),(214,'g',0,'2012-02-24'),(219,'g',0,'2012-02-24'),(198,'g',0,'2011-12-01'),(184,'g',0,'2012-02-13'),(215,'g',0,'2012-02-24'),(212,'g',0,'2012-02-24'),(223,'g',0,'2012-02-24'),(181,'g',0,'2012-02-16'),(218,'g',0,'2012-02-12'),(208,'g',0,'2011-10-18'),(206,'g',0,'2012-02-24'),(230,'g',0,'2012-01-19'),(193,'g',0,'2012-01-23'),(166,'g',0,'2012-02-02'),(167,'g',0,'2011-11-19'),(168,'g',0,'2011-11-19'),(204,'g',0,'2012-02-10'),(203,'g',0,'2012-01-21'),(196,'g',0,'2012-02-13'),(227,'g',0,'2011-10-19'),(186,'g',0,'2012-02-13'),(201,'g',0,'2012-02-13'),(188,'g',0,'2012-02-24'),(175,'g',0,'2012-02-24'),(216,'g',0,'2012-01-23'),(185,'g',0,'2012-01-24'),(182,'g',0,'2012-02-16'),(183,'g',0,'2012-02-16'),(220,'g',0,'2011-10-20'),(200,'g',0,'2011-10-20'),(180,'g',0,'2012-02-12'),(199,'g',0,'2012-01-21'),(233,'g',0,'2011-10-21'),(174,'g',0,'2011-10-21'),(177,'g',0,'2011-10-21'),(173,'g',0,'2011-11-22'),(187,'g',0,'2012-02-12'),(190,'g',0,'2012-02-12'),(179,'g',0,'2011-10-21'),(202,'g',0,'2011-10-21'),(217,'g',0,'2011-10-21'),(176,'g',0,'2011-12-16'),(221,'g',0,'2011-10-21'),(172,'g',0,'2012-02-13'),(246,'g',0,'2011-11-28'),(232,'g',0,'2011-10-22'),(194,'g',0,'2011-10-22'),(209,'g',0,'2012-02-12'),(222,'g',0,'2012-02-13'),(192,'g',0,'2012-02-17'),(336,'g',0,'2012-01-25'),(340,'g',0,'2012-02-24'),(354,'g',0,'2012-02-24'),(322,'g',0,'2012-02-24'),(337,'g',0,'2012-01-25'),(358,'g',0,'2012-02-24'),(331,'g',0,'2012-02-24'),(334,'g',0,'2012-01-25'),(329,'g',0,'2012-02-24'),(195,'g',0,'2012-02-06'),(171,'g',0,'2012-02-17'),(170,'g',0,'2012-02-17'),(207,'g',0,'2012-02-17'),(279,'g',0,'2012-02-24'),(365,'g',0,'2011-10-24'),(363,'g',0,'2011-11-28'),(371,'g',0,'2012-02-24'),(280,'g',0,'2012-02-24'),(248,'g',0,'2011-10-24'),(370,'g',0,'2012-02-24'),(247,'g',0,'2011-10-24'),(169,'g',0,'2011-12-29'),(305,'g',0,'2012-02-24'),(296,'g',0,'2012-02-24'),(326,'g',0,'2012-02-24'),(320,'g',0,'2012-02-24'),(259,'g',0,'2012-02-13'),(257,'g',0,'2012-02-24'),(260,'g',0,'2012-02-13'),(288,'g',0,'2012-02-24'),(330,'g',0,'2012-01-25'),(325,'g',0,'2012-02-13'),(271,'g',0,'2012-02-12'),(253,'g',0,'2012-02-12'),(254,'g',0,'2012-02-13'),(349,'g',0,'2012-02-12'),(360,'g',0,'2012-02-13'),(374,'g',0,'2011-10-25'),(256,'g',0,'2012-02-06'),(262,'g',0,'2012-02-06'),(319,'g',0,'2011-12-01'),(369,'g',0,'2012-02-24'),(350,'g',0,'2012-02-24'),(361,'g',0,'2012-02-24'),(314,'g',0,'2012-02-24'),(373,'g',0,'2012-02-24'),(315,'g',0,'2012-02-24'),(372,'g',0,'2012-02-24'),(313,'g',0,'2012-02-24'),(338,'g',0,'2012-02-24'),(278,'g',0,'2012-02-24'),(359,'g',0,'2012-02-24'),(375,'g',0,'2012-02-24'),(277,'g',0,'2012-02-13'),(342,'g',0,'2012-02-13'),(346,'g',0,'2012-02-12'),(275,'g',0,'2012-02-13'),(311,'g',0,'2012-02-17'),(310,'g',0,'2012-02-17'),(391,'g',0,'2011-11-27'),(272,'g',0,'2012-01-23'),(255,'g',0,'2012-01-23'),(357,'g',0,'2012-01-23'),(274,'g',0,'2012-01-23'),(300,'g',0,'2012-02-13'),(292,'g',0,'2012-02-12'),(388,'g',0,'2011-10-29'),(378,'g',0,'2011-12-02'),(298,'g',0,'2012-02-13'),(380,'g',0,'2011-12-02'),(386,'g',0,'2011-10-29'),(406,'g',0,'2011-10-29'),(353,'g',0,'2012-02-13'),(258,'g',0,'2012-02-12'),(395,'g',0,'2011-10-30'),(390,'g',0,'2011-10-30'),(356,'g',0,'2012-02-12'),(343,'g',0,'2012-02-12'),(312,'g',0,'2012-02-12'),(379,'g',0,'2012-02-12'),(324,'g',0,'2012-02-12'),(293,'g',0,'2012-02-12'),(261,'g',0,'2012-02-12'),(323,'g',0,'2012-02-12'),(285,'g',0,'2012-02-16'),(306,'g',0,'2012-02-13'),(328,'g',0,'2012-02-02'),(415,'g',0,'2012-02-02'),(404,'g',0,'2012-02-12'),(308,'g',0,'2012-02-12'),(339,'g',0,'2012-02-13'),(341,'g',0,'2012-02-12'),(345,'g',0,'2012-02-12'),(266,'g',0,'2012-02-13'),(273,'g',0,'2012-02-12'),(250,'g',0,'2012-02-24'),(210,'g',0,'2012-02-24'),(407,'g',0,'2011-11-02'),(297,'g',0,'2012-02-24'),(211,'g',0,'2012-02-24'),(327,'g',0,'2012-01-21'),(333,'g',0,'2012-02-24'),(304,'g',0,'2012-02-24'),(387,'g',0,'2012-01-21'),(397,'g',0,'2012-02-12'),(294,'g',0,'2012-02-13'),(362,'g',0,'2011-11-02'),(394,'g',0,'2011-11-02'),(347,'g',0,'2012-02-13'),(344,'g',0,'2012-02-12'),(295,'g',0,'2012-02-13'),(367,'g',0,'2012-02-12'),(316,'g',0,'2012-02-16'),(377,'g',0,'2011-11-02'),(335,'g',0,'2012-02-13'),(393,'g',0,'2012-02-24'),(307,'g',0,'2012-02-12'),(442,'g',0,'2011-11-03'),(420,'g',0,'2011-11-05'),(421,'g',0,'2011-11-05'),(425,'g',0,'2011-11-05'),(418,'g',0,'2012-02-24'),(403,'g',0,'2012-02-24'),(423,'g',0,'2011-11-05'),(424,'g',0,'2011-11-05'),(419,'g',0,'2011-11-05'),(422,'g',0,'2011-11-05'),(426,'g',0,'2011-11-05'),(445,'g',0,'2011-11-06'),(414,'g',0,'2012-02-12'),(413,'g',0,'2012-02-12'),(455,'g',0,'2011-11-07'),(382,'g',0,'2012-02-09'),(383,'g',0,'2012-02-09'),(381,'g',0,'2012-02-09'),(265,'g',0,'2012-02-17'),(348,'g',0,'2012-02-17'),(264,'g',0,'2011-12-15'),(449,'g',0,'2011-11-08'),(459,'g',0,'2011-11-08'),(318,'g',0,'2012-02-17'),(284,'g',0,'2012-01-07'),(269,'g',0,'2012-02-17'),(332,'g',0,'2012-02-12'),(460,'g',0,'2011-11-09'),(366,'g',0,'2012-02-13'),(385,'g',0,'2012-02-13'),(398,'g',0,'2011-11-10'),(376,'g',0,'2012-02-13'),(268,'g',0,'2012-02-12'),(368,'g',0,'2012-02-12'),(351,'g',0,'2012-02-13'),(309,'g',0,'2012-02-13'),(384,'g',0,'2012-02-18'),(364,'g',0,'2012-02-13'),(355,'g',0,'2012-02-06'),(290,'g',0,'2012-02-06'),(352,'g',0,'2012-02-06'),(276,'g',0,'2011-11-10'),(465,'g',0,'2011-11-10'),(561,'g',0,'2011-11-12'),(457,'g',0,'2011-11-12'),(560,'g',0,'2011-11-12'),(563,'g',0,'2011-11-12'),(541,'g',0,'2011-11-12'),(559,'g',0,'2011-11-12'),(562,'g',0,'2011-11-12'),(593,'g',0,'2011-11-12'),(523,'g',0,'2011-11-12'),(482,'g',0,'2011-11-12'),(520,'g',0,'2011-11-12'),(590,'g',0,'2011-11-12'),(487,'g',0,'2011-11-12'),(467,'g',0,'2011-11-12'),(604,'g',0,'2011-11-12'),(609,'g',0,'2011-11-13'),(585,'g',0,'2011-11-14'),(553,'g',0,'2011-11-14'),(492,'g',0,'2011-11-14'),(635,'g',0,'2011-11-14'),(519,'g',0,'2011-11-14'),(517,'g',0,'2011-11-14'),(515,'g',0,'2011-11-14'),(631,'g',0,'2011-11-14'),(539,'g',0,'2011-11-14'),(595,'g',0,'2011-11-14'),(597,'g',0,'2011-11-14'),(583,'g',0,'2011-11-14'),(498,'g',0,'2011-11-14'),(581,'g',0,'2011-11-14'),(529,'g',0,'2011-11-15'),(499,'g',0,'2011-11-15'),(470,'g',0,'2011-11-15'),(532,'g',0,'2011-11-15'),(598,'g',0,'2011-11-15'),(475,'g',0,'2011-11-15'),(550,'g',0,'2011-11-15'),(556,'g',0,'2011-11-15'),(538,'g',0,'2011-11-15'),(589,'g',0,'2011-11-15'),(507,'g',0,'2011-11-15'),(612,'g',0,'2011-11-15'),(485,'g',0,'2011-11-15'),(436,'g',0,'2011-11-15'),(473,'g',0,'2011-11-15'),(518,'g',0,'2011-11-15'),(438,'g',0,'2011-11-15'),(504,'g',0,'2011-11-15'),(434,'g',0,'2011-11-15'),(435,'g',0,'2011-11-15'),(437,'g',0,'2011-11-15'),(488,'g',0,'2011-11-15'),(586,'g',0,'2011-11-16'),(544,'g',0,'2011-11-16'),(569,'g',0,'2011-11-16'),(605,'g',0,'2011-11-16'),(469,'g',0,'2011-11-17'),(571,'g',0,'2011-11-17'),(466,'g',0,'2011-11-17'),(463,'g',0,'2011-11-17'),(456,'g',0,'2011-11-17'),(547,'g',0,'2011-11-17'),(458,'g',0,'2011-11-17'),(464,'g',0,'2011-11-17'),(389,'g',0,'2011-11-17'),(454,'g',0,'2011-11-17'),(441,'g',0,'2011-11-17'),(505,'g',0,'2011-11-18'),(496,'g',0,'2011-11-18'),(513,'g',0,'2011-11-18'),(540,'g',0,'2011-11-18'),(643,'g',0,'2011-11-20'),(577,'g',0,'2011-11-20'),(468,'g',0,'2011-11-20'),(546,'g',0,'2011-11-20'),(587,'g',0,'2011-11-22'),(618,'g',0,'2011-11-22'),(600,'g',0,'2011-11-22'),(531,'g',0,'2011-11-22'),(552,'g',0,'2011-11-22'),(567,'g',0,'2011-11-22'),(619,'g',0,'2011-11-22'),(621,'g',0,'2011-11-22'),(634,'g',0,'2011-11-22'),(614,'g',0,'2011-11-22'),(611,'g',0,'2011-11-22'),(591,'g',0,'2011-11-22'),(623,'g',0,'2011-11-22'),(568,'g',0,'2011-11-22'),(321,'g',0,'2012-02-24'),(267,'g',0,'2011-11-22'),(291,'g',0,'2011-11-22'),(283,'g',0,'2011-11-22'),(317,'g',0,'2011-11-22'),(270,'g',0,'2011-11-22'),(287,'g',0,'2011-11-22'),(224,'g',0,'2012-02-24'),(229,'g',0,'2012-02-24'),(231,'g',0,'2012-02-24'),(226,'g',0,'2012-02-24'),(588,'g',0,'2011-11-22'),(613,'g',0,'2011-11-22'),(680,'g',0,'2011-11-26'),(712,'g',0,'2011-11-26'),(962,'g',0,'2011-11-26'),(939,'g',0,'2011-11-26'),(882,'g',0,'2011-11-26'),(837,'g',0,'2011-11-27'),(956,'g',0,'2011-11-27'),(573,'g',0,'2011-11-27'),(690,'g',0,'2011-11-27'),(572,'g',0,'2011-11-27'),(936,'g',0,'2011-11-27'),(948,'g',0,'2011-11-27'),(806,'g',0,'2011-11-27'),(878,'g',0,'2011-11-27'),(818,'g',0,'2011-11-27'),(810,'g',0,'2011-11-27'),(775,'g',0,'2011-11-27'),(904,'g',0,'2011-11-27'),(967,'g',0,'2011-11-27'),(857,'g',0,'2011-11-27'),(839,'g',0,'2011-11-27'),(834,'g',0,'2011-11-27'),(757,'g',0,'2011-11-27'),(693,'g',0,'2011-11-27'),(654,'g',0,'2011-11-27'),(503,'g',0,'2011-11-27'),(648,'g',0,'2011-11-27'),(534,'g',0,'2011-11-27'),(670,'g',0,'2011-11-27'),(858,'g',0,'2011-11-27'),(951,'g',0,'2011-11-27'),(925,'g',0,'2011-11-27'),(921,'g',0,'2011-11-27'),(542,'g',0,'2011-11-27'),(763,'g',0,'2011-11-27'),(830,'g',0,'2011-11-27'),(796,'g',0,'2011-11-27'),(717,'g',0,'2011-11-27'),(596,'g',0,'2011-11-27'),(579,'g',0,'2011-11-27'),(661,'g',0,'2011-11-27'),(990,'g',0,'2011-11-27'),(766,'g',0,'2011-11-27'),(802,'g',0,'2011-11-27'),(608,'g',0,'2011-12-01'),(833,'g',0,'2011-12-01'),(1401,'g',0,'2011-12-01'),(1181,'g',0,'2011-12-01'),(1396,'g',0,'2011-12-01'),(646,'g',0,'2011-12-01'),(1005,'g',0,'2011-12-01'),(1230,'g',0,'2012-02-14'),(1287,'g',0,'2012-02-14'),(1310,'g',0,'2012-02-14'),(1185,'g',0,'2012-02-24'),(1337,'g',0,'2012-02-24'),(1008,'g',0,'2012-02-12'),(1115,'g',0,'2012-02-13'),(793,'g',0,'2011-12-03'),(1166,'g',0,'2012-01-07'),(1400,'g',0,'2011-12-03'),(860,'g',0,'2011-12-03'),(816,'g',0,'2011-12-03'),(744,'g',0,'2011-12-03'),(867,'g',0,'2011-12-03'),(836,'g',0,'2011-12-03'),(674,'g',0,'2011-12-03'),(675,'g',0,'2011-12-03'),(677,'g',0,'2011-12-03'),(676,'g',0,'2011-12-03'),(678,'g',0,'2011-12-03'),(747,'g',0,'2011-12-03'),(671,'g',0,'2011-12-03'),(730,'g',0,'2011-12-03'),(683,'g',0,'2011-12-03'),(640,'g',0,'2011-12-03'),(686,'g',0,'2011-12-03'),(629,'g',0,'2011-12-03'),(633,'g',0,'2011-12-03'),(603,'g',0,'2011-12-03'),(252,'g',0,'2012-02-24'),(400,'g',0,'2012-02-24'),(228,'g',0,'2012-02-24'),(225,'g',0,'2012-02-24'),(543,'g',0,'2011-12-04'),(632,'g',0,'2011-12-04'),(472,'g',0,'2011-12-05'),(451,'g',0,'2011-12-05'),(392,'g',0,'2011-12-05'),(495,'g',0,'2011-12-05'),(461,'g',0,'2011-12-05'),(462,'g',0,'2011-12-05'),(549,'g',0,'2011-12-05'),(626,'g',0,'2011-12-05'),(617,'g',0,'2011-12-05'),(548,'g',0,'2011-12-05'),(580,'g',0,'2011-12-05'),(630,'g',0,'2011-12-05'),(615,'g',0,'2011-12-05'),(566,'g',0,'2011-12-05'),(624,'g',0,'2011-12-05'),(578,'g',0,'2011-12-05'),(620,'g',0,'2011-12-05'),(622,'g',0,'2011-12-05'),(628,'g',0,'2011-12-05'),(625,'g',0,'2011-12-05'),(558,'g',0,'2011-12-05'),(627,'g',0,'2011-12-05'),(599,'g',0,'2011-12-05'),(706,'g',0,'2011-12-06'),(794,'g',0,'2011-12-06'),(865,'g',0,'2011-12-06'),(694,'g',0,'2011-12-06'),(811,'g',0,'2011-12-06'),(887,'g',0,'2011-12-06'),(927,'g',0,'2011-12-06'),(866,'g',0,'2011-12-06'),(847,'g',0,'2011-12-06'),(983,'g',0,'2011-12-06'),(869,'g',0,'2011-12-06'),(771,'g',0,'2011-12-06'),(770,'g',0,'2011-12-06'),(748,'g',0,'2011-12-06'),(673,'g',0,'2011-12-06'),(755,'g',0,'2011-12-06'),(718,'g',0,'2011-12-06'),(697,'g',0,'2011-12-06'),(699,'g',0,'2011-12-06'),(814,'g',0,'2011-12-06'),(938,'g',0,'2011-12-06'),(781,'g',0,'2011-12-06'),(850,'g',0,'2011-12-07'),(668,'g',0,'2011-12-07'),(824,'g',0,'2011-12-07'),(762,'g',0,'2011-12-07'),(812,'g',0,'2011-12-07'),(803,'g',0,'2011-12-07'),(715,'g',0,'2011-12-07'),(652,'g',0,'2011-12-07'),(657,'g',0,'2011-12-07'),(641,'g',0,'2011-12-07'),(769,'g',0,'2011-12-07'),(1485,'g',0,'2012-01-10'),(1299,'g',0,'2012-02-16'),(1273,'g',0,'2012-02-16'),(1490,'g',0,'2011-12-07'),(1206,'g',0,'2012-02-13'),(1064,'g',0,'2012-01-10'),(1269,'g',0,'2012-02-13'),(900,'g',0,'2011-12-07'),(940,'g',0,'2011-12-07'),(942,'g',0,'2011-12-07'),(902,'g',0,'2011-12-07'),(949,'g',0,'2011-12-07'),(916,'g',0,'2011-12-07'),(941,'g',0,'2011-12-07'),(943,'g',0,'2011-12-07'),(930,'g',0,'2011-12-07'),(946,'g',0,'2011-12-07'),(901,'g',0,'2011-12-07'),(1264,'g',0,'2012-02-24'),(1303,'g',0,'2011-12-07'),(1351,'g',0,'2012-02-24'),(1327,'g',0,'2011-12-07'),(1321,'g',0,'2011-12-07'),(1146,'g',0,'2011-12-07'),(1341,'g',0,'2012-02-24'),(1051,'g',0,'2011-12-07'),(1325,'g',0,'2011-12-07'),(1353,'g',0,'2012-02-24'),(1329,'g',0,'2012-02-24'),(1099,'g',0,'2011-12-07'),(1340,'g',0,'2012-02-24'),(1145,'g',0,'2011-12-07'),(1141,'g',0,'2012-02-24'),(1112,'g',0,'2012-02-12'),(1045,'g',0,'2011-12-07'),(1272,'g',0,'2011-12-07'),(1332,'g',0,'2012-02-24'),(1253,'g',0,'2011-12-07'),(1161,'g',0,'2011-12-07'),(1330,'g',0,'2012-02-24'),(1040,'g',0,'2011-12-07'),(1278,'g',0,'2012-01-21'),(1164,'g',0,'2012-01-21'),(1184,'g',0,'2012-02-24'),(1208,'g',0,'2012-02-24'),(1093,'g',0,'2012-02-24'),(1215,'g',0,'2012-02-24'),(1530,'g',0,'2011-12-08'),(1540,'g',0,'2011-12-10'),(480,'g',0,'2011-12-10'),(281,'g',0,'2011-12-10'),(479,'g',0,'2011-12-10'),(481,'g',0,'2011-12-10'),(476,'g',0,'2011-12-10'),(557,'g',0,'2011-12-10'),(497,'g',0,'2011-12-10'),(399,'g',0,'2011-12-10'),(405,'g',0,'2011-12-10'),(282,'g',0,'2012-03-04'),(401,'g',0,'2011-12-10'),(402,'g',0,'2011-12-10'),(478,'g',0,'2011-12-10'),(477,'g',0,'2011-12-10'),(501,'g',0,'2011-12-10'),(474,'g',0,'2011-12-10'),(483,'g',0,'2011-12-10'),(303,'g',0,'2012-02-12'),(301,'g',0,'2012-02-13'),(502,'g',0,'2011-12-10'),(500,'g',0,'2011-12-10'),(506,'g',0,'2011-12-10'),(263,'g',0,'2012-02-12'),(302,'g',0,'2012-02-13'),(289,'g',0,'2012-02-13'),(484,'g',0,'2011-12-10'),(412,'g',0,'2011-12-10'),(299,'g',0,'2012-02-13'),(408,'g',0,'2011-12-10'),(286,'g',0,'2012-02-12'),(489,'g',0,'2011-12-10'),(493,'g',0,'2011-12-10'),(432,'g',0,'2011-12-10'),(431,'g',0,'2011-12-10'),(430,'g',0,'2011-12-10'),(427,'g',0,'2011-12-10'),(429,'g',0,'2011-12-10'),(428,'g',0,'2011-12-10'),(433,'g',0,'2011-12-10'),(1493,'g',0,'2012-01-26'),(1529,'g',0,'2011-12-10'),(1526,'g',0,'2012-01-26'),(1178,'g',0,'2012-02-13'),(1250,'g',0,'2012-02-13'),(1144,'g',0,'2012-02-13'),(1249,'g',0,'2012-02-13'),(1248,'g',0,'2012-02-12'),(1288,'g',0,'2011-12-11'),(1182,'g',0,'2012-02-16'),(1296,'g',0,'2012-01-17'),(1205,'g',0,'2012-02-16'),(1187,'g',0,'2012-02-16'),(1226,'g',0,'2012-01-17'),(1120,'g',0,'2011-12-12'),(1015,'g',0,'2011-12-12'),(1127,'g',0,'2011-12-12'),(1044,'g',0,'2011-12-12'),(1020,'g',0,'2011-12-12'),(1097,'g',0,'2011-12-12'),(1119,'g',0,'2011-12-12'),(1168,'g',0,'2011-12-12'),(1156,'g',0,'2011-12-12'),(1046,'g',0,'2011-12-12'),(1025,'g',0,'2011-12-12'),(1130,'g',0,'2011-12-12'),(1101,'g',0,'2011-12-12'),(1024,'g',0,'2011-12-12'),(1026,'g',0,'2011-12-12'),(1049,'g',0,'2011-12-12'),(1043,'g',0,'2011-12-12'),(1022,'g',0,'2011-12-12'),(1023,'g',0,'2011-12-12'),(1021,'g',0,'2011-12-12'),(1019,'g',0,'2011-12-12'),(1048,'g',0,'2011-12-12'),(1029,'g',0,'2011-12-12'),(1028,'g',0,'2011-12-12'),(1054,'g',0,'2011-12-12'),(1034,'g',0,'2011-12-12'),(1050,'g',0,'2011-12-12'),(1038,'g',0,'2012-03-05'),(1547,'g',0,'2011-12-12'),(1137,'g',0,'2011-12-12'),(1132,'g',0,'2011-12-12'),(1109,'g',0,'2011-12-12'),(1133,'g',0,'2011-12-12'),(1136,'g',0,'2011-12-12'),(1135,'g',0,'2011-12-12'),(1134,'g',0,'2011-12-12'),(1041,'g',0,'2012-02-24'),(1142,'g',0,'2012-02-24'),(1125,'g',0,'2011-12-13'),(1074,'g',0,'2011-12-13'),(1105,'g',0,'2011-12-13'),(1122,'g',0,'2011-12-13'),(1086,'g',0,'2011-12-13'),(1261,'g',0,'2011-12-13'),(1247,'g',0,'2011-12-13'),(1165,'g',0,'2011-12-13'),(1548,'g',0,'2011-12-13'),(1143,'g',0,'2011-12-13'),(1128,'g',0,'2012-02-24'),(1282,'g',0,'2012-02-13'),(1546,'g',0,'2011-12-13'),(1116,'g',0,'2012-02-13'),(1562,'g',0,'2011-12-13'),(1587,'g',0,'2012-01-26'),(1129,'g',0,'2011-12-14'),(1575,'g',0,'2012-02-13'),(1559,'g',0,'2011-12-14'),(1346,'g',0,'2012-02-17'),(1150,'g',0,'2012-02-17'),(1198,'g',0,'2011-12-14'),(1583,'g',0,'2011-12-14'),(1582,'g',0,'2011-12-14'),(1597,'g',0,'2011-12-14'),(1584,'g',0,'2011-12-14'),(1270,'g',0,'2011-12-14'),(1031,'g',0,'2011-12-14'),(1217,'g',0,'2011-12-14'),(1308,'g',0,'2011-12-14'),(409,'g',0,'2011-12-14'),(1338,'g',0,'2011-12-14'),(235,'g',0,'2011-12-14'),(1238,'g',0,'2011-12-15'),(1307,'g',0,'2011-12-15'),(1235,'g',0,'2011-12-15'),(396,'g',0,'2012-02-24'),(1155,'g',0,'2011-12-15'),(1009,'g',0,'2011-12-15'),(1103,'g',0,'2011-12-15'),(1302,'g',0,'2011-12-15'),(1162,'g',0,'2011-12-15'),(1277,'g',0,'2011-12-15'),(1336,'g',0,'2011-12-15'),(249,'g',0,'2012-02-12'),(1286,'g',0,'2011-12-15'),(1306,'g',0,'2011-12-15'),(1154,'g',0,'2012-02-13'),(1075,'g',0,'2012-01-23'),(1284,'g',0,'2012-02-24'),(1080,'g',0,'2011-12-15'),(1078,'g',0,'2012-01-23'),(1216,'g',0,'2011-12-15'),(1147,'g',0,'2011-12-15'),(416,'g',0,'2011-12-15'),(1317,'g',0,'2011-12-15'),(1102,'g',0,'2011-12-16'),(1298,'g',0,'2011-12-16'),(1106,'g',0,'2012-02-13'),(1149,'g',0,'2011-12-16'),(1252,'g',0,'2012-02-12'),(1281,'g',0,'2011-12-16'),(1098,'g',0,'2011-12-16'),(1301,'g',0,'2011-12-16'),(1276,'g',0,'2011-12-16'),(1275,'g',0,'2011-12-16'),(1104,'g',0,'2011-12-16'),(1345,'g',0,'2011-12-16'),(1100,'g',0,'2011-12-16'),(1279,'g',0,'2011-12-16'),(1618,'g',0,'2012-01-17'),(1615,'g',0,'2011-12-17'),(1608,'g',0,'2011-12-17'),(1604,'g',0,'2011-12-17'),(1609,'g',0,'2011-12-17'),(1610,'g',0,'2011-12-17'),(1624,'g',0,'2011-12-18'),(1639,'g',0,'2011-12-18'),(1635,'g',0,'2011-12-18'),(1638,'g',0,'2011-12-18'),(1483,'g',0,'2011-12-18'),(1081,'g',0,'2011-12-18'),(1595,'g',0,'2011-12-18'),(1594,'g',0,'2011-12-18'),(1007,'g',0,'2011-12-18'),(1032,'g',0,'2011-12-18'),(1076,'g',0,'2011-12-18'),(1576,'g',0,'2012-02-16'),(1072,'g',0,'2012-02-12'),(1058,'g',0,'2012-02-13'),(1052,'g',0,'2012-02-13'),(1589,'g',0,'2011-12-19'),(1563,'g',0,'2012-02-12'),(1569,'g',0,'2011-12-19'),(1586,'g',0,'2011-12-19'),(1570,'g',0,'2011-12-19'),(1599,'g',0,'2011-12-19'),(1579,'g',0,'2011-12-19'),(1580,'g',0,'2011-12-19'),(1572,'g',0,'2011-12-19'),(1605,'g',0,'2011-12-19'),(1613,'g',0,'2012-01-21'),(1037,'g',0,'2012-02-24'),(1158,'g',0,'2012-02-24'),(1304,'g',0,'2011-12-19'),(1124,'g',0,'2012-02-24'),(1042,'g',0,'2012-02-13'),(1663,'g',0,'2011-12-20'),(1657,'g',0,'2011-12-20'),(1668,'g',0,'2011-12-20'),(1677,'g',0,'2011-12-20'),(1664,'g',0,'2011-12-20'),(1660,'g',0,'2011-12-20'),(1642,'g',0,'2011-12-21'),(1673,'g',0,'2011-12-21'),(1682,'g',0,'2011-12-21'),(1675,'g',0,'2011-12-21'),(1669,'g',0,'2012-02-16'),(1667,'g',0,'2011-12-21'),(1670,'g',0,'2011-12-21'),(1655,'g',0,'2012-02-12'),(1678,'g',0,'2011-12-21'),(1686,'g',0,'2011-12-21'),(1065,'g',0,'2011-12-21'),(1680,'g',0,'2012-02-12'),(1160,'g',0,'2011-12-21'),(1172,'g',0,'2011-12-21'),(1602,'g',0,'2011-12-21'),(1111,'g',0,'2011-12-21'),(1151,'g',0,'2011-12-21'),(1118,'g',0,'2011-12-21'),(1211,'g',0,'2011-12-21'),(1191,'g',0,'2011-12-21'),(1193,'g',0,'2011-12-21'),(1062,'g',0,'2011-12-21'),(1152,'g',0,'2011-12-21'),(1117,'g',0,'2011-12-21'),(1169,'g',0,'2011-12-21'),(1110,'g',0,'2012-01-24'),(1186,'g',0,'2011-12-21'),(1173,'g',0,'2011-12-21'),(1140,'g',0,'2011-12-21'),(1126,'g',0,'2011-12-21'),(1123,'g',0,'2011-12-21'),(1018,'g',0,'2012-01-24'),(1096,'g',0,'2012-01-24'),(1593,'g',0,'2012-01-24'),(1588,'g',0,'2012-01-24'),(1571,'g',0,'2012-01-24'),(1601,'g',0,'2011-12-21'),(1079,'g',0,'2012-01-24'),(1033,'g',0,'2012-01-24'),(1596,'g',0,'2011-12-22'),(1030,'g',0,'2012-01-24'),(1057,'g',0,'2012-01-24'),(1688,'g',0,'2012-02-12'),(1687,'g',0,'2011-12-22'),(1684,'g',0,'2011-12-22'),(1693,'g',0,'2011-12-22'),(1679,'g',0,'2011-12-22'),(1662,'g',0,'2012-02-24'),(1698,'g',0,'2011-12-22'),(1699,'g',0,'2011-12-23'),(1689,'g',0,'2011-12-23'),(1672,'g',0,'2011-12-23'),(1600,'g',0,'2012-02-12'),(1533,'g',0,'2011-12-23'),(1700,'g',0,'2011-12-24'),(1705,'g',0,'2011-12-24'),(1535,'g',0,'2011-12-24'),(1219,'g',0,'2011-12-24'),(1224,'g',0,'2011-12-24'),(1223,'g',0,'2011-12-24'),(1225,'g',0,'2011-12-24'),(1195,'g',0,'2012-02-24'),(1159,'g',0,'2012-02-24'),(1213,'g',0,'2012-02-24'),(1228,'g',0,'2011-12-24'),(1214,'g',0,'2011-12-24'),(1227,'g',0,'2011-12-24'),(1412,'g',0,'2012-02-24'),(1411,'g',0,'2012-02-24'),(1482,'g',0,'2012-02-24'),(1564,'g',0,'2011-12-24'),(1359,'g',0,'2011-12-24'),(1348,'g',0,'2011-12-24'),(1356,'g',0,'2011-12-24'),(1350,'g',0,'2011-12-24'),(1361,'g',0,'2011-12-24'),(1360,'g',0,'2011-12-24'),(1344,'g',0,'2011-12-24'),(1358,'g',0,'2011-12-24'),(1362,'g',0,'2011-12-24'),(1354,'g',0,'2011-12-24'),(1319,'g',0,'2011-12-25'),(1324,'g',0,'2011-12-25'),(1409,'g',0,'2011-12-25'),(1335,'g',0,'2011-12-25'),(1690,'g',0,'2011-12-25'),(1681,'g',0,'2011-12-25'),(1676,'g',0,'2011-12-25'),(1695,'g',0,'2011-12-25'),(1349,'g',0,'2011-12-25'),(1694,'g',0,'2011-12-26'),(1776,'g',0,'2012-02-24'),(1770,'g',0,'2012-02-24'),(1779,'g',0,'2012-02-24'),(1088,'g',0,'2011-12-26'),(1082,'g',0,'2011-12-26'),(1091,'g',0,'2011-12-27'),(1741,'g',0,'2011-12-27'),(1087,'g',0,'2011-12-27'),(1090,'g',0,'2011-12-27'),(251,'g',0,'2012-02-24'),(1036,'g',0,'2011-12-27'),(1039,'g',0,'2011-12-27'),(1447,'g',0,'2011-12-27'),(1292,'g',0,'2011-12-27'),(1719,'g',0,'2011-12-27'),(234,'g',0,'2011-12-27'),(1750,'g',0,'2012-02-13'),(1768,'g',0,'2012-02-14'),(1711,'g',0,'2011-12-27'),(1731,'g',0,'2012-02-12'),(1771,'g',0,'2012-02-12'),(1777,'g',0,'2012-02-13'),(1084,'g',0,'2011-12-27'),(1094,'g',0,'2011-12-27'),(1012,'g',0,'2011-12-27'),(1016,'g',0,'2011-12-27'),(1011,'g',0,'2011-12-27'),(1014,'g',0,'2011-12-27'),(1035,'g',0,'2011-12-27'),(1611,'g',0,'2011-12-27'),(1013,'g',0,'2011-12-27'),(1592,'g',0,'2011-12-27'),(1591,'g',0,'2011-12-28'),(1805,'g',0,'2011-12-28'),(1816,'g',0,'2011-12-28'),(1751,'g',0,'2011-12-28'),(1809,'g',0,'2011-12-28'),(1806,'g',0,'2011-12-28'),(1729,'g',0,'2011-12-28'),(1812,'g',0,'2011-12-28'),(1767,'g',0,'2011-12-28'),(1752,'g',0,'2012-02-12'),(1746,'g',0,'2012-02-13'),(1590,'g',0,'2011-12-28'),(1620,'g',0,'2011-12-28'),(1222,'g',0,'2011-12-28'),(1309,'g',0,'2011-12-28'),(1585,'g',0,'2011-12-28'),(1010,'g',0,'2011-12-28'),(1783,'g',0,'2011-12-28'),(1807,'g',0,'2012-02-17'),(1818,'g',0,'2011-12-28'),(1819,'g',0,'2011-12-28'),(1210,'g',0,'2011-12-28'),(1817,'g',0,'2011-12-28'),(1113,'g',0,'2011-12-28'),(1352,'g',0,'2011-12-28'),(1207,'g',0,'2011-12-28'),(1196,'g',0,'2011-12-28'),(1148,'g',0,'2011-12-28'),(1573,'g',0,'2011-12-28'),(1316,'g',0,'2011-12-28'),(1063,'g',0,'2011-12-28'),(1085,'g',0,'2011-12-28'),(1053,'g',0,'2011-12-28'),(1059,'g',0,'2011-12-28'),(1236,'g',0,'2011-12-28'),(1027,'g',0,'2011-12-29'),(1060,'g',0,'2011-12-29'),(1239,'g',0,'2011-12-29'),(1243,'g',0,'2011-12-29'),(1568,'g',0,'2011-12-29'),(1240,'g',0,'2011-12-29'),(1619,'g',0,'2011-12-29'),(1757,'g',0,'2012-02-24'),(1787,'g',0,'2012-02-24'),(1814,'g',0,'2012-02-24'),(1797,'g',0,'2012-02-24'),(1726,'g',0,'2012-02-24'),(1183,'g',0,'2011-12-29'),(1251,'g',0,'2011-12-29'),(1242,'g',0,'2011-12-29'),(1644,'g',0,'2011-12-29'),(1197,'g',0,'2011-12-29'),(1209,'g',0,'2011-12-29'),(1241,'g',0,'2011-12-29'),(1574,'g',0,'2011-12-29'),(1255,'g',0,'2011-12-29'),(1829,'g',0,'2012-02-12'),(1598,'g',0,'2011-12-29'),(1305,'g',0,'2011-12-29'),(1293,'g',0,'2011-12-29'),(1245,'g',0,'2011-12-29'),(1274,'g',0,'2011-12-29'),(1260,'g',0,'2011-12-29'),(1285,'g',0,'2011-12-29'),(1406,'g',0,'2011-12-29'),(1221,'g',0,'2011-12-29'),(1231,'g',0,'2011-12-29'),(1312,'g',0,'2011-12-29'),(1542,'g',0,'2011-12-29'),(1311,'g',0,'2011-12-29'),(1220,'g',0,'2011-12-29'),(1283,'g',0,'2011-12-29'),(1322,'g',0,'2011-12-29'),(1405,'g',0,'2011-12-29'),(1651,'g',0,'2011-12-29'),(1347,'g',0,'2011-12-29'),(1566,'g',0,'2011-12-29'),(1246,'g',0,'2011-12-29'),(1237,'g',0,'2011-12-29'),(1343,'g',0,'2011-12-29'),(1333,'g',0,'2011-12-29'),(1331,'g',0,'2011-12-29'),(1254,'g',0,'2011-12-29'),(1300,'g',0,'2011-12-29'),(1244,'g',0,'2011-12-29'),(1268,'g',0,'2011-12-29'),(1320,'g',0,'2011-12-29'),(1578,'g',0,'2011-12-29'),(1577,'g',0,'2011-12-29'),(1017,'g',0,'2011-12-29'),(1826,'g',0,'2012-02-12'),(1842,'g',0,'2012-02-12'),(1712,'g',0,'2012-02-24'),(1728,'g',0,'2012-02-24'),(1131,'g',0,'2011-12-29'),(1259,'g',0,'2011-12-29'),(1153,'g',0,'2011-12-29'),(1200,'g',0,'2011-12-29'),(1189,'g',0,'2011-12-29'),(1139,'g',0,'2011-12-29'),(1258,'g',0,'2011-12-29'),(1265,'g',0,'2011-12-29'),(1484,'g',0,'2011-12-29'),(1355,'g',0,'2011-12-29'),(1824,'g',0,'2011-12-29'),(1323,'g',0,'2011-12-29'),(1844,'g',0,'2011-12-29'),(1840,'g',0,'2012-02-24'),(1357,'g',0,'2011-12-29'),(1408,'g',0,'2011-12-29'),(1328,'g',0,'2011-12-30'),(1314,'g',0,'2011-12-30'),(1171,'g',0,'2011-12-30'),(1229,'g',0,'2011-12-30'),(1232,'g',0,'2011-12-30'),(1821,'g',0,'2012-02-13'),(1234,'g',0,'2011-12-30'),(1838,'g',0,'2012-02-24'),(1233,'g',0,'2011-12-30'),(1848,'g',0,'2011-12-30'),(1170,'g',0,'2011-12-30'),(1176,'g',0,'2011-12-30'),(1839,'g',0,'2012-02-14'),(1761,'g',0,'2011-12-30'),(1095,'g',0,'2011-12-30'),(1174,'g',0,'2011-12-30'),(1850,'g',0,'2011-12-31'),(1832,'g',0,'2012-02-17'),(1785,'g',0,'2011-12-31'),(1068,'g',0,'2011-12-31'),(1786,'g',0,'2011-12-31'),(1092,'g',0,'2011-12-31'),(1055,'g',0,'2011-12-31'),(1114,'g',0,'2011-12-31'),(1774,'g',0,'2011-12-31'),(1789,'g',0,'2011-12-31'),(1073,'g',0,'2011-12-31'),(1794,'g',0,'2011-12-31'),(1061,'g',0,'2011-12-31'),(1067,'g',0,'2011-12-31'),(1089,'g',0,'2011-12-31'),(1194,'g',0,'2011-12-31'),(1291,'g',0,'2011-12-31'),(1290,'g',0,'2011-12-31'),(1294,'g',0,'2012-01-01'),(1743,'g',0,'2012-01-01'),(1066,'g',0,'2012-01-01'),(1083,'g',0,'2012-01-01'),(1212,'g',0,'2012-01-01'),(1218,'g',0,'2012-01-01'),(1525,'g',0,'2012-01-01'),(1175,'g',0,'2012-01-01'),(1834,'g',0,'2012-01-01'),(1823,'g',0,'2012-01-01'),(1853,'g',0,'2012-01-01'),(1851,'g',0,'2012-01-01'),(1536,'g',0,'2012-01-01'),(1342,'g',0,'2012-01-01'),(1537,'g',0,'2012-01-01'),(1192,'g',0,'2012-01-01'),(1071,'g',0,'2012-01-01'),(1256,'g',0,'2012-01-01'),(1313,'g',0,'2012-01-02'),(1334,'g',0,'2012-01-02'),(1763,'g',0,'2012-01-02'),(1793,'g',0,'2012-01-02'),(1204,'g',0,'2012-01-02'),(1835,'g',0,'2012-02-24'),(1538,'g',0,'2012-01-02'),(1825,'g',0,'2012-02-13'),(1297,'g',0,'2012-01-02'),(1339,'g',0,'2012-01-02'),(1201,'g',0,'2012-01-02'),(1056,'g',0,'2012-01-02'),(1157,'g',0,'2012-01-02'),(1289,'g',0,'2012-01-02'),(1047,'g',0,'2012-01-02'),(1262,'g',0,'2012-01-02'),(1069,'g',0,'2012-01-02'),(1138,'g',0,'2012-01-02'),(1070,'g',0,'2012-01-02'),(1541,'g',0,'2012-01-02'),(1487,'g',0,'2012-01-02'),(1263,'g',0,'2012-01-02'),(1369,'g',0,'2012-01-02'),(1365,'g',0,'2012-01-02'),(1370,'g',0,'2012-01-02'),(1367,'g',0,'2012-01-02'),(1371,'g',0,'2012-01-02'),(1387,'g',0,'2012-01-02'),(1108,'g',0,'2012-01-02'),(1643,'g',0,'2012-01-03'),(1257,'g',0,'2012-01-03'),(1202,'g',0,'2012-01-03'),(1875,'g',0,'2012-02-02'),(1646,'g',0,'2012-01-03'),(1874,'g',0,'2012-02-12'),(1866,'g',0,'2012-02-12'),(1856,'g',0,'2012-01-03'),(1295,'g',0,'2012-01-03'),(1386,'g',0,'2012-01-03'),(1870,'g',0,'2012-01-03'),(1363,'g',0,'2012-01-03'),(1389,'g',0,'2012-01-03'),(1366,'g',0,'2012-01-03'),(1077,'g',0,'2012-01-03'),(1271,'g',0,'2012-01-03'),(1199,'g',0,'2012-01-03'),(1390,'g',0,'2012-01-03'),(1384,'g',0,'2012-01-03'),(1385,'g',0,'2012-01-03'),(1364,'g',0,'2012-01-03'),(1382,'g',0,'2012-01-03'),(1383,'g',0,'2012-01-03'),(1368,'g',0,'2012-01-03'),(1650,'g',0,'2012-01-03'),(1280,'g',0,'2012-01-03'),(1203,'g',0,'2012-01-03'),(1188,'g',0,'2012-01-03'),(1394,'g',0,'2012-01-03'),(1372,'g',0,'2012-01-03'),(1380,'g',0,'2012-01-03'),(1415,'g',0,'2012-01-03'),(1374,'g',0,'2012-01-03'),(1379,'g',0,'2012-01-03'),(1413,'g',0,'2012-01-03'),(1414,'g',0,'2012-01-03'),(1373,'g',0,'2012-01-03'),(1375,'g',0,'2012-01-03'),(1378,'g',0,'2012-01-03'),(1407,'g',0,'2012-01-03'),(1395,'g',0,'2012-01-03'),(1416,'g',0,'2012-01-03'),(1381,'g',0,'2012-01-03'),(1393,'g',0,'2012-01-03'),(1376,'g',0,'2012-01-03'),(1388,'g',0,'2012-01-03'),(1318,'g',0,'2012-01-03'),(1756,'g',0,'2012-01-03'),(1392,'g',0,'2012-01-03'),(1648,'g',0,'2012-01-03'),(1391,'g',0,'2012-01-03'),(1377,'g',0,'2012-01-03'),(1417,'g',0,'2012-01-03'),(1649,'g',0,'2012-01-03'),(1857,'g',0,'2012-01-03'),(1871,'g',0,'2012-01-03'),(1864,'g',0,'2012-01-03'),(1878,'g',0,'2012-01-04'),(1867,'g',0,'2012-02-12'),(1888,'g',0,'2012-02-09'),(1876,'g',0,'2012-02-24'),(1877,'g',0,'2012-01-05'),(1883,'g',0,'2012-01-05'),(1891,'g',0,'2012-02-13'),(1884,'g',0,'2012-02-24'),(1881,'g',0,'2012-02-13'),(1896,'g',0,'2012-01-07'),(1882,'g',0,'2012-01-07'),(1893,'g',0,'2012-02-24'),(1841,'g',0,'2012-02-24'),(1803,'g',0,'2012-02-24'),(1811,'g',0,'2012-02-24'),(1742,'g',0,'2012-02-24'),(1865,'g',0,'2012-02-24'),(1905,'g',0,'2012-01-08'),(1908,'g',0,'2012-01-08'),(1924,'g',0,'2012-02-24'),(1929,'g',0,'2012-01-10'),(1916,'g',0,'2012-01-10'),(1928,'g',0,'2012-01-10'),(1914,'g',0,'2012-02-13'),(1920,'g',0,'2012-02-12'),(1900,'g',0,'2012-02-13'),(1691,'g',0,'2012-01-10'),(1725,'g',0,'2012-01-10'),(1704,'g',0,'2012-01-10'),(1724,'g',0,'2012-01-10'),(1738,'g',0,'2012-01-10'),(1930,'g',0,'2012-01-10'),(1739,'g',0,'2012-01-10'),(1921,'g',0,'2012-01-10'),(1922,'g',0,'2012-01-10'),(1919,'g',0,'2012-01-10'),(1703,'g',0,'2012-01-11'),(1917,'g',0,'2012-02-17'),(1671,'g',0,'2012-01-11'),(1749,'g',0,'2012-01-11'),(1747,'g',0,'2012-01-11'),(1923,'g',0,'2012-02-24'),(1943,'g',0,'2012-01-11'),(1938,'g',0,'2012-01-12'),(1935,'g',0,'2012-01-12'),(1937,'g',0,'2012-01-12'),(1944,'g',0,'2012-01-12'),(1936,'g',0,'2012-01-12'),(1947,'g',0,'2012-01-13'),(1948,'g',0,'2012-02-17'),(1946,'g',0,'2012-02-17'),(1957,'g',0,'2012-01-14'),(1969,'g',0,'2012-01-14'),(1968,'g',0,'2012-02-14'),(1952,'g',0,'2012-02-17'),(1965,'g',0,'2012-01-15'),(1975,'g',0,'2012-01-15'),(1976,'g',0,'2012-01-15'),(1964,'g',0,'2012-01-15'),(1945,'g',0,'2012-02-16'),(1863,'g',0,'2012-01-15'),(1918,'g',0,'2012-01-15'),(1911,'g',0,'2012-01-15'),(1862,'g',0,'2012-01-15'),(1983,'g',0,'2012-01-16'),(1913,'g',0,'2012-01-16'),(1894,'g',0,'2012-01-16'),(1858,'g',0,'2012-01-16'),(1656,'g',0,'2012-01-16'),(1994,'g',0,'2012-02-24'),(1993,'g',0,'2012-02-24'),(2005,'g',0,'2012-01-17'),(2019,'g',0,'2012-02-16'),(1997,'g',0,'2012-01-17'),(2006,'g',0,'2012-01-17'),(2015,'g',0,'2012-01-17'),(2023,'g',0,'2012-01-17'),(2002,'g',0,'2012-02-16'),(2022,'g',0,'2012-01-17'),(2024,'g',0,'2012-01-17'),(2021,'g',0,'2012-01-17'),(2016,'g',0,'2012-01-17'),(2026,'g',0,'2012-02-16'),(2014,'g',0,'2012-01-17'),(2028,'g',0,'2012-01-17'),(1998,'g',0,'2012-02-17'),(1991,'g',0,'2012-01-17'),(2000,'g',0,'2012-01-17'),(1984,'g',0,'2012-02-17'),(1985,'g',0,'2012-02-24'),(2018,'g',0,'2012-02-17'),(2030,'g',0,'2012-01-19'),(2040,'g',0,'2012-01-19'),(2043,'g',0,'2012-01-20'),(2037,'g',0,'2012-01-21'),(2034,'g',0,'2012-01-21'),(2058,'g',0,'2012-01-21'),(2032,'g',0,'2012-01-21'),(2076,'g',0,'2012-01-21'),(2068,'g',0,'2012-01-21'),(2061,'g',0,'2012-02-22'),(2075,'g',0,'2012-01-21'),(2059,'g',0,'2012-02-24'),(2047,'g',0,'2012-02-22'),(1762,'g',0,'2012-01-21'),(1773,'g',0,'2012-01-21'),(1932,'g',0,'2012-01-21'),(1764,'g',0,'2012-01-21'),(2055,'g',0,'2012-02-24'),(1754,'g',0,'2012-01-21'),(1658,'g',0,'2012-01-21'),(1622,'g',0,'2012-01-21'),(2045,'g',0,'2012-01-21'),(1621,'g',0,'2012-01-21'),(2012,'g',0,'2012-01-21'),(2017,'g',0,'2012-01-21'),(1996,'g',0,'2012-01-21'),(1960,'g',0,'2012-01-21'),(1966,'g',0,'2012-01-21'),(2007,'g',0,'2012-01-21'),(1961,'g',0,'2012-01-21'),(2010,'g',0,'2012-01-21'),(1999,'g',0,'2012-01-21'),(2009,'g',0,'2012-01-21'),(2062,'g',0,'2012-01-22'),(2052,'g',0,'2012-01-22'),(2039,'g',0,'2012-01-22'),(2036,'g',0,'2012-01-22'),(2049,'g',0,'2012-01-22'),(2060,'g',0,'2012-01-22'),(1769,'g',0,'2012-01-22'),(1758,'g',0,'2012-01-22'),(1759,'g',0,'2012-01-22'),(1830,'g',0,'2012-01-22'),(1990,'g',0,'2012-01-22'),(1860,'g',0,'2012-01-22'),(1748,'g',0,'2012-01-22'),(1963,'g',0,'2012-01-22'),(1989,'g',0,'2012-01-22'),(1992,'g',0,'2012-01-22'),(1765,'g',0,'2012-01-22'),(1939,'g',0,'2012-01-22'),(1831,'g',0,'2012-01-22'),(1987,'g',0,'2012-01-22'),(1827,'g',0,'2012-01-22'),(1772,'g',0,'2012-01-22'),(1861,'g',0,'2012-02-24'),(1781,'g',0,'2012-01-22'),(1868,'g',0,'2012-02-24'),(1801,'g',0,'2012-01-22'),(1846,'g',0,'2012-02-24'),(2065,'g',0,'2012-01-23'),(2001,'g',0,'2012-01-23'),(1788,'g',0,'2012-01-23'),(1603,'g',0,'2012-01-23'),(1782,'g',0,'2012-01-23'),(1784,'g',0,'2012-01-23'),(1744,'g',0,'2012-01-23'),(1912,'g',0,'2012-01-23'),(1795,'g',0,'2012-01-23'),(1791,'g',0,'2012-01-23'),(1890,'g',0,'2012-01-23'),(1766,'g',0,'2012-01-23'),(1740,'g',0,'2012-01-23'),(1780,'g',0,'2012-01-23'),(2056,'g',0,'2012-01-23'),(2020,'g',0,'2012-01-23'),(2073,'g',0,'2012-01-23'),(1954,'g',0,'2012-01-23'),(2053,'g',0,'2012-01-23'),(1956,'g',0,'2012-01-24'),(1723,'g',0,'2012-01-24'),(1736,'g',0,'2012-01-24'),(1745,'g',0,'2012-01-24'),(1734,'g',0,'2012-01-24'),(1733,'g',0,'2012-01-24'),(1735,'g',0,'2012-01-24'),(1898,'g',0,'2012-02-24'),(1872,'g',0,'2012-02-24'),(2025,'g',0,'2012-01-24'),(1927,'g',0,'2012-02-24'),(1950,'g',0,'2012-02-24'),(2027,'g',0,'2012-01-24'),(2003,'g',0,'2012-01-24'),(1873,'g',0,'2012-02-24'),(2066,'g',0,'2012-01-24'),(1808,'g',0,'2012-01-24'),(1790,'g',0,'2012-01-24'),(1730,'g',0,'2012-01-24'),(1666,'g',0,'2012-01-24'),(1859,'g',0,'2012-01-24'),(1813,'g',0,'2012-01-24'),(1720,'g',0,'2012-01-24'),(1778,'g',0,'2012-01-24'),(1721,'g',0,'2012-01-24'),(1845,'g',0,'2012-01-24'),(2081,'g',0,'2012-01-24'),(1775,'g',0,'2012-01-24'),(1661,'g',0,'2012-01-24'),(1820,'g',0,'2012-01-24'),(1665,'g',0,'2012-01-24'),(2096,'g',0,'2012-01-24'),(1792,'g',0,'2012-01-24'),(2078,'g',0,'2012-01-24'),(2074,'g',0,'2012-01-24'),(2089,'g',0,'2012-02-24'),(2079,'g',0,'2012-01-24'),(2051,'g',0,'2012-02-24'),(1995,'g',0,'2012-01-24'),(1967,'g',0,'2012-01-24'),(1959,'g',0,'2012-01-24'),(2008,'g',0,'2012-01-24'),(2011,'g',0,'2012-01-24'),(2038,'g',0,'2012-02-24'),(2004,'g',0,'2012-01-24'),(2031,'g',0,'2012-01-24'),(1988,'g',0,'2012-01-25'),(2097,'g',0,'2012-01-25'),(2102,'g',0,'2012-01-25'),(2101,'g',0,'2012-01-25'),(2104,'g',0,'2012-01-25'),(2095,'g',0,'2012-02-24'),(2121,'g',0,'2012-02-25'),(2123,'g',0,'2012-01-26'),(2124,'g',0,'2012-01-28'),(2126,'g',0,'2012-01-28'),(2131,'g',0,'2012-01-28'),(2054,'g',0,'2012-01-28'),(2133,'g',0,'2012-01-28'),(2128,'g',0,'2012-01-28'),(2132,'g',0,'2012-01-28'),(2140,'g',0,'2012-01-28'),(2136,'g',0,'2012-01-28'),(1951,'g',0,'2012-01-28'),(1962,'g',0,'2012-01-28'),(1121,'g',0,'2012-01-28'),(1163,'g',0,'2012-01-28'),(1177,'g',0,'2012-01-28'),(1798,'g',0,'2012-01-28'),(1755,'g',0,'2012-01-28'),(1737,'g',0,'2012-01-28'),(1886,'g',0,'2012-01-28'),(1887,'g',0,'2012-01-28'),(1828,'g',0,'2012-01-28'),(1760,'g',0,'2012-01-28'),(2048,'g',0,'2012-01-28'),(1909,'g',0,'2012-01-28'),(2082,'g',0,'2012-01-28'),(1843,'g',0,'2012-01-28'),(1892,'g',0,'2012-01-28'),(1815,'g',0,'2012-01-28'),(1810,'g',0,'2012-01-28'),(1880,'g',0,'2012-01-28'),(2108,'g',0,'2012-01-28'),(2106,'g',0,'2012-01-28'),(2105,'g',0,'2012-01-28'),(2088,'g',0,'2012-01-28'),(1822,'g',0,'2012-01-28'),(2107,'g',0,'2012-01-28'),(2084,'g',0,'2012-01-29'),(1800,'g',0,'2012-01-29'),(1885,'g',0,'2012-01-29'),(2083,'g',0,'2012-01-29'),(1847,'g',0,'2012-01-29'),(2142,'g',0,'2012-01-29'),(1833,'g',0,'2012-01-29'),(2109,'g',0,'2012-01-29'),(1879,'g',0,'2012-01-29'),(1802,'g',0,'2012-01-29'),(1804,'g',0,'2012-01-29'),(1722,'g',0,'2012-01-29'),(1692,'g',0,'2012-01-29'),(1931,'g',0,'2012-01-29'),(1701,'g',0,'2012-01-29'),(1940,'g',0,'2012-01-29'),(1727,'g',0,'2012-01-29'),(1702,'g',0,'2012-01-29'),(2099,'g',0,'2012-01-30'),(2157,'g',0,'2012-01-30'),(2145,'g',0,'2012-01-30'),(2178,'g',0,'2012-01-30'),(2160,'g',0,'2012-01-30'),(2156,'g',0,'2012-01-30'),(2155,'g',0,'2012-01-31'),(2170,'g',0,'2012-01-31'),(2167,'g',0,'2012-01-31'),(2159,'g',0,'2012-01-31'),(2188,'g',0,'2012-02-01'),(2182,'g',0,'2012-02-01'),(2165,'g',0,'2012-02-01'),(2146,'g',0,'2012-02-01'),(2154,'g',0,'2012-02-01'),(2158,'g',0,'2012-02-01'),(2183,'g',0,'2012-02-01'),(2187,'g',0,'2012-02-01'),(1532,'g',0,'2012-02-01'),(1567,'g',0,'2012-02-01'),(1404,'g',0,'2012-02-01'),(2202,'g',0,'2012-02-01'),(2201,'g',0,'2012-02-01'),(2200,'g',0,'2012-02-01'),(2199,'g',0,'2012-02-01'),(2197,'g',0,'2012-02-01'),(2169,'g',0,'2012-02-01'),(2153,'g',0,'2012-02-01'),(2150,'g',0,'2012-02-01'),(2166,'g',0,'2012-02-01'),(2191,'g',0,'2012-02-01'),(1565,'g',0,'2012-02-02'),(1486,'g',0,'2012-02-02'),(1266,'g',0,'2012-02-02'),(1410,'g',0,'2012-02-02'),(2192,'g',0,'2012-02-02'),(2190,'g',0,'2012-02-02'),(2194,'g',0,'2012-02-03'),(2195,'g',0,'2012-02-03'),(2193,'g',0,'2012-02-03'),(2227,'g',0,'2012-02-04'),(2309,'g',0,'2012-02-06'),(2288,'g',0,'2012-02-06'),(1953,'g',0,'2012-02-07'),(1955,'g',0,'2012-02-07'),(1949,'g',0,'2012-02-07'),(2317,'g',0,'2012-02-07'),(2093,'g',0,'2012-02-08'),(2184,'g',0,'2012-02-08'),(2151,'g',0,'2012-02-08'),(2325,'g',0,'2012-02-08'),(2326,'g',0,'2012-02-08'),(2147,'g',0,'2012-02-08'),(2148,'g',0,'2012-02-08'),(2091,'g',0,'2012-02-09'),(2291,'g',0,'2012-02-09'),(2240,'g',0,'2012-02-10'),(2316,'g',0,'2012-02-10'),(2324,'g',0,'2012-02-10'),(2333,'g',0,'2012-02-11'),(2336,'g',0,'2012-02-11'),(2329,'g',0,'2012-02-11'),(2341,'g',0,'2012-02-12'),(2368,'g',0,'2012-02-12'),(2349,'g',0,'2012-02-12'),(2335,'g',0,'2012-02-12'),(2198,'g',0,'2012-02-12'),(2248,'g',0,'2012-02-12'),(2297,'g',0,'2012-02-12'),(2295,'g',0,'2012-02-13'),(1167,'g',0,'2012-02-13'),(1179,'g',0,'2012-02-13'),(1180,'g',0,'2012-02-13'),(2354,'g',0,'2012-02-13'),(2090,'g',0,'2012-02-13'),(2340,'g',0,'2012-02-13'),(2120,'g',0,'2012-02-14'),(2173,'g',0,'2012-02-14'),(2100,'g',0,'2012-02-14'),(2172,'g',0,'2012-02-14'),(2350,'g',0,'2012-02-14'),(2171,'g',0,'2012-02-14'),(1869,'g',0,'2012-02-14'),(2119,'g',0,'2012-02-14'),(2161,'g',0,'2012-02-14'),(2242,'g',0,'2012-02-14'),(2196,'g',0,'2012-02-14'),(2357,'g',0,'2012-02-14'),(2378,'g',0,'2012-02-14'),(2375,'g',0,'2012-02-14'),(2373,'g',0,'2012-02-14'),(2355,'g',0,'2012-02-15'),(2094,'g',0,'2012-02-15'),(2176,'g',0,'2012-02-15'),(2162,'g',0,'2012-02-15'),(2315,'g',0,'2012-02-15'),(2164,'g',0,'2012-02-15'),(2371,'g',0,'2012-02-15'),(2377,'g',0,'2012-02-16'),(2383,'g',0,'2012-02-16'),(2374,'g',0,'2012-02-16'),(2117,'g',0,'2012-02-16'),(2386,'g',0,'2012-02-17'),(2382,'g',0,'2012-02-17'),(2149,'g',0,'2012-02-17'),(2092,'g',0,'2012-02-17'),(2314,'g',0,'2012-02-17'),(2241,'g',0,'2012-02-17'),(2347,'g',0,'2012-02-17'),(2384,'g',0,'2012-02-18'),(2381,'g',0,'2012-02-18'),(2391,'g',0,'2012-02-18'),(2289,'g',0,'2012-02-18'),(2392,'g',0,'2012-02-19'),(2372,'g',0,'2012-02-19'),(2358,'g',0,'2012-02-19'),(2249,'g',0,'2012-02-19'),(2292,'g',0,'2012-02-19'),(2320,'g',0,'2012-02-20'),(2301,'g',0,'2012-02-20'),(2257,'g',0,'2012-02-20'),(2251,'g',0,'2012-02-20'),(2364,'g',0,'2012-02-20'),(2353,'g',0,'2012-02-20'),(2338,'g',0,'2012-02-20'),(2346,'g',0,'2012-02-20'),(2397,'g',0,'2012-02-21'),(2416,'g',0,'2012-02-21'),(1645,'g',0,'2012-02-21'),(1714,'g',0,'2012-02-21'),(2252,'g',0,'2012-02-21'),(1715,'g',0,'2012-02-21'),(1716,'g',0,'2012-02-21'),(1732,'g',0,'2012-02-21'),(1612,'g',0,'2012-02-21'),(1718,'g',0,'2012-02-21'),(2345,'g',0,'2012-02-21'),(2348,'g',0,'2012-02-21'),(2098,'g',0,'2012-02-21'),(1717,'g',0,'2012-02-21'),(2163,'g',0,'2012-02-21'),(2063,'g',0,'2012-02-21'),(2337,'g',0,'2012-02-21'),(2033,'g',0,'2012-02-21'),(2343,'g',0,'2012-02-21'),(2057,'g',0,'2012-02-21'),(2046,'g',0,'2012-02-21'),(2307,'g',0,'2012-02-21'),(2246,'g',0,'2012-02-21'),(2406,'g',0,'2012-02-21'),(2402,'g',0,'2012-02-21'),(2342,'g',0,'2012-02-22'),(2421,'g',0,'2012-02-22'),(2250,'g',0,'2012-02-22'),(2304,'g',0,'2012-02-22'),(2404,'g',0,'2012-02-23'),(2408,'g',0,'2012-02-23'),(2432,'g',0,'2012-02-23'),(2422,'g',0,'2012-02-23'),(2403,'g',0,'2012-02-24'),(2405,'g',0,'2012-02-24'),(2414,'g',0,'2012-02-24'),(2410,'g',0,'2012-02-24'),(2152,'g',0,'2012-02-24'),(2118,'g',0,'2012-02-24'),(2168,'g',0,'2012-02-24'),(2411,'g',0,'2012-02-24'),(1450,'g',0,'2012-02-24'),(2439,'g',0,'2012-02-24'),(2440,'g',0,'2012-02-24'),(2433,'g',0,'2012-02-24'),(2436,'g',0,'2012-02-24'),(2431,'g',0,'2012-02-24'),(2419,'g',0,'2012-02-24'),(2427,'g',0,'2012-02-24'),(2435,'g',0,'2012-02-24'),(2339,'g',0,'2012-02-24'),(2085,'g',0,'2012-02-24'),(2434,'g',0,'2012-02-24'),(2438,'g',0,'2012-02-24'),(2175,'g',0,'2012-02-24'),(1462,'g',0,'2012-02-24'),(1437,'g',0,'2012-02-25'),(1436,'g',0,'2012-02-25'),(1467,'g',0,'2012-02-25'),(1449,'g',0,'2012-02-25'),(2258,'g',0,'2012-02-25'),(1926,'g',0,'2012-02-25'),(2417,'g',0,'2012-02-25'),(1428,'g',0,'2012-02-25'),(1430,'g',0,'2012-02-25'),(1457,'g',0,'2012-02-25'),(1441,'g',0,'2012-02-25'),(1434,'g',0,'2012-02-25'),(2396,'g',0,'2012-02-25'),(1439,'g',0,'2012-02-25'),(1458,'g',0,'2012-02-25'),(2399,'g',0,'2012-02-25'),(2359,'g',0,'2012-02-25'),(2356,'g',0,'2012-02-25'),(2296,'g',0,'2012-02-25'),(1933,'g',0,'2012-02-25'),(1925,'g',0,'2012-02-25'),(1910,'g',0,'2012-02-25'),(1899,'g',0,'2012-02-25'),(2174,'g',0,'2012-02-25'),(2087,'g',0,'2012-02-25'),(1267,'g',0,'2012-02-25'),(1422,'g',0,'2012-02-25'),(1418,'g',0,'2012-02-25'),(1427,'g',0,'2012-02-25'),(1444,'g',0,'2012-02-25'),(1469,'g',0,'2012-02-25'),(1459,'g',0,'2012-02-25'),(1456,'g',0,'2012-02-25'),(1463,'g',0,'2012-02-25'),(2379,'g',0,'2012-02-25'),(2401,'g',0,'2012-02-25'),(2259,'g',0,'2012-02-25'),(1941,'g',0,'2012-02-25'),(1423,'g',0,'2012-02-25'),(1426,'g',0,'2012-02-25'),(1424,'g',0,'2012-02-25'),(1464,'g',0,'2012-02-25'),(1448,'g',0,'2012-02-25'),(1442,'g',0,'2012-02-25'),(1453,'g',0,'2012-02-25'),(1438,'g',0,'2012-02-25'),(1451,'g',0,'2012-02-25'),(1461,'g',0,'2012-02-25'),(1431,'g',0,'2012-02-25'),(1432,'g',0,'2012-02-25'),(1445,'g',0,'2012-02-25'),(1466,'g',0,'2012-02-25'),(1452,'g',0,'2012-02-25'),(1433,'g',0,'2012-02-25'),(1942,'g',0,'2012-02-25'),(1425,'g',0,'2012-02-25'),(1468,'g',0,'2012-02-25'),(1455,'g',0,'2012-02-25'),(1435,'g',0,'2012-02-25'),(1440,'g',0,'2012-02-25'),(1465,'g',0,'2012-02-25'),(2290,'g',0,'2012-02-26'),(1420,'g',0,'2012-02-26'),(2086,'g',0,'2012-02-26'),(1421,'g',0,'2012-02-26'),(1429,'g',0,'2012-02-26'),(1446,'g',0,'2012-02-26'),(1443,'g',0,'2012-02-26'),(1454,'g',0,'2012-02-26'),(2415,'g',0,'2012-02-26'),(1419,'g',0,'2012-02-26'),(2254,'g',0,'2012-02-26'),(2305,'g',0,'2012-02-26'),(1915,'g',0,'2012-02-26'),(2310,'g',0,'2012-02-26'),(1460,'g',0,'2012-02-26'),(2466,'g',0,'2012-02-27'),(2351,'g',0,'2012-02-29'),(2465,'g',0,'2012-02-29'),(2361,'g',0,'2012-02-29'),(2216,'g',0,'2012-02-29'),(2462,'g',0,'2012-02-29'),(2407,'g',0,'2012-02-29'),(2447,'g',0,'2012-03-01'),(2448,'g',0,'2012-03-01'),(2472,'g',0,'2012-03-01'),(2477,'g',0,'2012-03-01'),(2473,'g',0,'2012-03-03'),(2458,'g',0,'2012-03-03'),(2293,'g',0,'2012-03-03'),(2294,'g',0,'2012-03-04'),(2489,'g',0,'2012-03-04'),(2482,'g',0,'2012-03-04'),(2387,'g',0,'2012-03-04'),(2302,'g',0,'2012-03-04'),(2311,'g',0,'2012-03-04'),(2300,'g',0,'2012-03-04'),(2363,'g',0,'2012-03-04'),(2247,'g',0,'2012-03-04'),(2456,'g',0,'2012-03-04'),(2303,'g',0,'2012-03-04'),(2244,'g',0,'2012-03-04'),(2319,'g',0,'2012-03-04'),(2299,'g',0,'2012-03-04'),(2308,'g',0,'2012-03-04'),(2298,'g',0,'2012-03-04'),(2245,'g',0,'2012-03-04'),(2253,'g',0,'2012-03-04'),(2256,'g',0,'2012-03-04'),(2490,'g',0,'2012-03-04'),(2255,'g',0,'2012-03-04'),(2312,'g',0,'2012-03-05'),(2460,'g',0,'2012-03-05'),(2508,'g',0,'2012-03-06'),(2505,'g',0,'2012-03-06'),(2413,'g',0,'2012-03-06'),(2510,'g',0,'2012-03-06'),(2318,'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 ('13NejDHSqSNdYKgeUY0LgA','GkJAKu5f2b7cHOYdIO29deSsg4svw6w4oBCuSM3vTU','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,'AutoTweet','twitter_auto_tweet/twitter_auto_tweet.php','1',NULL),(2,'Sociable','sociable/sociable.php','1',NULL);

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

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

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

INSERT INTO `idx_review` VALUES (1,1148,'This is one Excellent company.\r\n\r\nPrompt responses -awesome job well done. ',5,'2012-01-03','Review','1','','Shopper','gilroy.stevens@gmail.com'),(2,1148,'It was great experience. ',4,'2012-01-03','Review','1','','Shopper','roniethoma1@hotmail.com');

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

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

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


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



