--
-- Host: slickr.org    Database: slickr_slic
-- ------------------------------------------------------


--
-- 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=MyISAM AUTO_INCREMENT=472 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',15,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Auto Industry','','folder.gif','','1',39,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Economy & Business','','folder.gif','','1',150,'','','0','0','','',0,'',0,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',10,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Communications Services','','folder.gif','','1',26,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computer Services','','folder.gif','','1',21,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Building & Construction','','folder.gif','','1',73,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental','','folder.gif','','1',36,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Educational Resources','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Recruitment Services','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Gifts & Flowers','','folder.gif','','1',26,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software Resources','','folder.gif','','1',10,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Medical & Health','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Management','','folder.gif','','1',168,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Air Conditioning & Heating','','folder.gif','','1',57,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home Decor & Garden','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement Services','','folder.gif','','1',318,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Resorts','','folder.gif','','1',70,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Services','','folder.gif','','1',33,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers and Law Firms','','folder.gif','','1',165,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & People','','folder.gif','','1',3,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine  Facilities','','folder.gif','','1',11,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Financial Services','','folder.gif','','1',15,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing & Plumbers','','folder.gif','','1',47,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate Services','','folder.gif','','1',31,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Technology & Science','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'SEO Services','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Shopping and Fashion','','folder.gif','','1',52,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Games & Sports','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Transport & Freight Forwarding','','folder.gif','','1',39,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Travel & Vacations','','folder.gif','','1',19,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Wedding Accessories','','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://slickr.org/arts-music/\" name=\"cat_1\" style=\"\">Arts & Music</a>',';0;'),(2,'Auto Industry','<a href=\"http://slickr.org/auto-industry/\" name=\"cat_2\" style=\"\">Auto Industry</a>',';0;'),(3,'Economy & Business','<a href=\"http://slickr.org/economy-business/\" name=\"cat_3\" style=\"\">Economy & Business</a>',';0;'),(4,'Careers & Job Search','<a href=\"http://slickr.org/careers-job-search/\" name=\"cat_4\" style=\"\">Careers & Job Search</a>',';0;'),(5,'Clothing Accessories','<a href=\"http://slickr.org/clothing-accessories/\" name=\"cat_5\" style=\"\">Clothing Accessories</a>',';0;'),(6,'Communications Services','<a href=\"http://slickr.org/communications-services/\" name=\"cat_6\" style=\"\">Communications Services</a>',';0;'),(7,'Computer Services','<a href=\"http://slickr.org/computer-services/\" name=\"cat_7\" style=\"\">Computer Services</a>',';0;'),(8,'Building & Construction','<a href=\"http://slickr.org/building-construction/\" name=\"cat_8\" style=\"\">Building & Construction</a>',';0;'),(9,'Dental','<a href=\"http://slickr.org/dental/\" name=\"cat_9\" style=\"\">Dental</a>',';0;'),(10,'Educational Resources','<a href=\"http://slickr.org/educational-resources/\" name=\"cat_10\" style=\"\">Educational Resources</a>',';0;'),(11,'Recruitment Services','<a href=\"http://slickr.org/recruitment-services/\" name=\"cat_11\" style=\"\">Recruitment Services</a>',';0;'),(12,'Gifts & Flowers','<a href=\"http://slickr.org/gifts-flowers/\" name=\"cat_12\" style=\"\">Gifts & Flowers</a>',';0;'),(13,'Hardware & Software Resources','<a href=\"http://slickr.org/hardware-software-resources/\" name=\"cat_13\" style=\"\">Hardware & Software Resources</a>',';0;'),(14,'Medical & Health','<a href=\"http://slickr.org/medical-health/\" name=\"cat_14\" style=\"\">Medical & Health</a>',';0;'),(15,'Healthcare Management','<a href=\"http://slickr.org/healthcare-management/\" name=\"cat_15\" style=\"\">Healthcare Management</a>',';0;'),(16,'Air Conditioning & Heating','<a href=\"http://slickr.org/air-conditioning-heating/\" name=\"cat_16\" style=\"\">Air Conditioning & Heating</a>',';0;'),(17,'Home Decor & Garden','<a href=\"http://slickr.org/home-decor-garden/\" name=\"cat_17\" style=\"\">Home Decor & Garden</a>',';0;'),(18,'Home Improvement Services','<a href=\"http://slickr.org/home-improvement-services/\" name=\"cat_18\" style=\"\">Home Improvement Services</a>',';0;'),(19,'Hotels & Resorts','<a href=\"http://slickr.org/hotels-resorts/\" name=\"cat_19\" style=\"\">Hotels & Resorts</a>',';0;'),(20,'Insurance Services','<a href=\"http://slickr.org/insurance-services/\" name=\"cat_20\" style=\"\">Insurance Services</a>',';0;'),(21,'Law Services','<a href=\"http://slickr.org/law-services/\" name=\"cat_21\" style=\"\">Law Services</a>',';0;'),(22,'Lawyers and Law Firms','<a href=\"http://slickr.org/lawyers-and-law-firms/\" name=\"cat_22\" style=\"\">Lawyers and Law Firms</a>',';0;'),(23,'Lifestyle & People','<a href=\"http://slickr.org/lifestyle-people/\" name=\"cat_23\" style=\"\">Lifestyle & People</a>',';0;'),(24,'Medicine  Facilities','<a href=\"http://slickr.org/medicine-facilities/\" name=\"cat_24\" style=\"\">Medicine  Facilities</a>',';0;'),(25,'Financial Services','<a href=\"http://slickr.org/financial-services/\" name=\"cat_25\" style=\"\">Financial Services</a>',';0;'),(26,'News','<a href=\"http://slickr.org/news/\" name=\"cat_26\" style=\"\">News</a>',';0;'),(27,'Plumbing & Plumbers','<a href=\"http://slickr.org/plumbing-plumbers/\" name=\"cat_27\" style=\"\">Plumbing & Plumbers</a>',';0;'),(28,'Real Estate Services','<a href=\"http://slickr.org/real-estate-services/\" name=\"cat_28\" style=\"\">Real Estate Services</a>',';0;'),(29,'Technology & Science','<a href=\"http://slickr.org/technology-science/\" name=\"cat_29\" style=\"\">Technology & Science</a>',';0;'),(30,'SEO Services','<a href=\"http://slickr.org/seo-services/\" name=\"cat_30\" style=\"\">SEO Services</a>',';0;'),(31,'Shopping and Fashion','<a href=\"http://slickr.org/shopping-and-fashion/\" name=\"cat_31\" style=\"\">Shopping and Fashion</a>',';0;'),(32,'Games & Sports','<a href=\"http://slickr.org/games-sports/\" name=\"cat_32\" style=\"\">Games & Sports</a>',';0;'),(33,'Transport & Freight Forwarding','<a href=\"http://slickr.org/transport-freight-forwarding/\" name=\"cat_33\" style=\"\">Transport & Freight Forwarding</a>',';0;'),(34,'Travel & Vacations','<a href=\"http://slickr.org/travel-vacations/\" name=\"cat_34\" style=\"\">Travel & Vacations</a>',';0;'),(35,'Wedding Accessories','<a href=\"http://slickr.org/wedding-accessories/\" name=\"cat_35\" style=\"\">Wedding Accessories</a>',';0;');

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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



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

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

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

INSERT INTO `idx_favorites` VALUES (1,'claytondongk30r16','2011-10-18','My Favorites',NULL),(2,'wilberscoto73w97','2011-10-19','My Favorites',NULL),(3,'benedictcalet48c65','2011-10-31','My Favorites',NULL),(4,'marcusstevei58t21','2011-11-01','My Favorites',NULL),(5,'adaptive84','2011-12-07','My Favorites',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


--
-- 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',0,'2011-11-07'),(55,'g',0,'2011-11-14'),(96,'g',0,'2011-11-14'),(85,'g',0,'2011-11-14'),(57,'g',0,'2011-11-14'),(252,'g',0,'2011-11-14'),(209,'g',0,'2011-11-14'),(163,'g',0,'2011-11-14'),(205,'g',0,'2011-11-14'),(213,'g',0,'2011-11-14'),(45,'g',0,'2011-11-14'),(51,'g',0,'2011-11-14'),(34,'g',0,'2011-11-14'),(242,'g',0,'2011-11-14'),(319,'g',0,'2011-11-14'),(222,'g',0,'2011-11-15'),(230,'g',0,'2011-11-15'),(48,'g',0,'2011-11-15'),(66,'g',0,'2011-11-15'),(44,'g',0,'2011-11-15'),(67,'g',0,'2011-11-15'),(46,'g',0,'2011-11-15'),(27,'g',0,'2011-11-15'),(65,'g',0,'2011-11-15'),(63,'g',0,'2011-11-15'),(43,'g',0,'2011-11-15'),(194,'g',0,'2011-11-15'),(333,'g',0,'2011-11-15'),(378,'g',0,'2011-11-15'),(345,'g',0,'2011-11-15'),(198,'g',0,'2011-11-15'),(113,'g',0,'2011-11-16'),(346,'g',0,'2011-11-16'),(154,'g',0,'2011-11-16'),(327,'g',0,'2011-11-16'),(299,'g',0,'2011-11-16'),(20,'g',0,'2011-11-16'),(29,'g',0,'2011-11-16'),(112,'g',0,'2011-11-16'),(309,'g',0,'2011-11-16'),(251,'g',0,'2011-11-16'),(172,'g',0,'2011-11-16'),(365,'g',0,'2011-11-16'),(176,'g',0,'2011-11-16'),(350,'g',0,'2011-11-17'),(38,'g',0,'2011-11-17'),(50,'g',0,'2011-11-17'),(374,'g',0,'2011-11-17'),(358,'g',0,'2011-11-17'),(383,'g',0,'2011-11-17'),(151,'g',0,'2011-11-17'),(363,'g',0,'2011-11-17'),(232,'g',0,'2011-11-17'),(100,'g',0,'2011-11-18'),(243,'g',0,'2011-11-18'),(234,'g',0,'2011-11-18'),(370,'g',0,'2011-11-18'),(74,'g',0,'2011-11-19'),(6,'g',0,'2011-11-19'),(98,'g',0,'2011-11-19'),(95,'g',0,'2011-11-19'),(110,'g',0,'2011-11-19'),(169,'g',0,'2011-11-19'),(59,'g',0,'2011-11-19'),(126,'g',0,'2011-11-19'),(120,'g',0,'2011-11-19'),(153,'g',0,'2011-11-19'),(75,'g',0,'2011-11-19'),(23,'g',0,'2011-11-20'),(5,'g',0,'2011-11-20'),(33,'g',0,'2011-11-20'),(68,'g',0,'2011-11-20'),(2,'g',0,'2011-11-20'),(11,'g',0,'2011-11-20'),(25,'g',0,'2011-11-20'),(31,'g',0,'2011-11-20'),(72,'g',0,'2011-11-20'),(137,'g',0,'2011-11-20'),(168,'g',0,'2011-11-20'),(149,'g',0,'2011-11-20'),(103,'g',0,'2011-11-20'),(7,'g',0,'2011-11-20'),(28,'g',0,'2011-11-20'),(24,'g',0,'2011-11-20'),(78,'g',0,'2011-11-20'),(104,'g',0,'2011-11-20'),(30,'g',0,'2011-11-20'),(83,'g',0,'2011-11-20'),(286,'g',0,'2011-11-20'),(79,'g',0,'2011-11-20'),(64,'g',0,'2011-11-20'),(138,'g',0,'2011-11-20'),(71,'g',0,'2011-11-20'),(42,'g',0,'2011-11-20'),(3,'g',0,'2011-11-20'),(125,'g',0,'2011-11-21'),(49,'g',0,'2011-11-21'),(39,'g',0,'2011-11-21'),(82,'g',0,'2011-11-21'),(304,'g',0,'2011-11-21'),(128,'g',0,'2011-11-21'),(99,'g',0,'2011-11-22'),(388,'g',0,'2011-11-23'),(62,'g',0,'2011-11-23'),(210,'g',0,'2011-11-23'),(377,'g',0,'2011-11-23'),(255,'g',0,'2011-11-23'),(191,'g',0,'2011-11-23'),(292,'g',0,'2011-11-24'),(195,'g',0,'2011-11-24'),(60,'g',0,'2011-11-24'),(132,'g',0,'2011-11-24'),(8,'g',0,'2011-11-26'),(160,'g',0,'2011-11-26'),(140,'g',0,'2011-11-26'),(219,'g',0,'2011-11-26'),(134,'g',0,'2011-11-26'),(107,'g',0,'2011-11-26'),(106,'g',0,'2011-11-26'),(150,'g',0,'2011-11-26'),(116,'g',0,'2011-11-26'),(688,'g',0,'2011-11-29'),(40,'g',0,'2011-11-29'),(14,'g',0,'2011-11-29'),(52,'g',0,'2011-11-29'),(26,'g',0,'2011-11-29'),(86,'g',0,'2011-11-29'),(127,'g',0,'2011-11-29'),(170,'g',0,'2011-11-29'),(166,'g',0,'2011-11-29'),(157,'g',0,'2011-11-29'),(544,'g',0,'2012-02-22'),(684,'g',0,'2012-02-22'),(543,'g',0,'2012-02-22'),(534,'g',0,'2012-01-21'),(90,'g',0,'2011-11-30'),(218,'g',0,'2011-11-30'),(282,'g',0,'2011-11-30'),(189,'g',0,'2011-11-30'),(233,'g',0,'2011-11-30'),(245,'g',0,'2011-11-30'),(117,'g',0,'2011-11-30'),(4,'g',0,'2011-11-30'),(257,'g',0,'2011-11-30'),(93,'g',0,'2011-11-30'),(532,'g',0,'2012-01-21'),(395,'g',0,'2011-11-30'),(61,'g',0,'2011-11-30'),(101,'g',0,'2011-11-30'),(129,'g',0,'2011-11-30'),(238,'g',0,'2011-11-30'),(18,'g',0,'2011-11-30'),(54,'g',0,'2011-11-30'),(37,'g',0,'2011-11-30'),(36,'g',0,'2011-11-30'),(56,'g',0,'2011-11-30'),(15,'g',0,'2011-11-30'),(53,'g',0,'2011-12-01'),(16,'g',0,'2011-12-01'),(21,'g',0,'2011-12-01'),(22,'g',0,'2011-12-01'),(771,'g',0,'2012-02-17'),(324,'g',0,'2011-12-01'),(812,'g',0,'2012-02-20'),(432,'g',0,'2011-12-01'),(41,'g',0,'2011-12-01'),(313,'g',0,'2011-12-01'),(780,'g',0,'2012-02-20'),(485,'g',0,'2012-02-14'),(279,'g',0,'2011-12-01'),(1125,'g',0,'2011-12-02'),(866,'g',0,'2012-01-12'),(1256,'g',0,'2011-12-02'),(815,'g',0,'2012-03-06'),(992,'g',0,'2012-03-06'),(989,'g',0,'2012-03-06'),(334,'g',0,'2011-12-03'),(316,'g',0,'2011-12-03'),(845,'g',0,'2012-03-06'),(1093,'g',0,'2011-12-03'),(1220,'g',0,'2011-12-03'),(10,'g',0,'2011-12-03'),(489,'g',0,'2012-01-18'),(247,'g',0,'2011-12-03'),(401,'g',0,'2011-12-03'),(337,'g',0,'2011-12-03'),(436,'g',0,'2011-12-03'),(342,'g',0,'2011-12-03'),(478,'g',0,'2012-02-22'),(454,'g',0,'2012-01-13'),(442,'g',0,'2011-12-03'),(12,'g',0,'2011-12-03'),(403,'g',0,'2011-12-03'),(130,'g',0,'2011-12-03'),(13,'g',0,'2011-12-03'),(262,'g',0,'2011-12-03'),(362,'g',0,'2011-12-03'),(97,'g',0,'2011-12-03'),(400,'g',0,'2011-12-03'),(344,'g',0,'2011-12-03'),(9,'g',0,'2011-12-03'),(17,'g',0,'2011-12-03'),(331,'g',0,'2011-12-03'),(371,'g',0,'2011-12-03'),(105,'g',0,'2011-12-03'),(348,'g',0,'2011-12-03'),(136,'g',0,'2011-12-04'),(420,'g',0,'2011-12-04'),(298,'g',0,'2011-12-05'),(959,'g',0,'2012-02-22'),(1255,'g',0,'2011-12-05'),(693,'g',0,'2012-02-22'),(790,'g',0,'2012-01-08'),(968,'g',0,'2012-02-22'),(1124,'g',0,'2011-12-05'),(768,'g',0,'2012-02-28'),(527,'g',0,'2012-01-21'),(763,'g',0,'2012-02-28'),(522,'g',0,'2012-01-21'),(479,'g',0,'2012-01-21'),(679,'g',0,'2012-02-19'),(890,'g',0,'2012-02-19'),(984,'g',0,'2012-02-19'),(1477,'g',0,'2012-02-19'),(1785,'g',0,'2011-12-12'),(773,'g',0,'2011-12-12'),(793,'g',0,'2011-12-12'),(711,'g',0,'2012-02-15'),(737,'g',0,'2012-02-15'),(788,'g',0,'2011-12-12'),(777,'g',0,'2011-12-12'),(770,'g',0,'2011-12-12'),(460,'g',0,'2011-12-13'),(459,'g',0,'2011-12-13'),(498,'g',0,'2011-12-13'),(450,'g',0,'2012-02-17'),(1846,'g',0,'2011-12-16'),(1865,'g',0,'2012-02-22'),(1807,'g',0,'2011-12-16'),(1796,'g',0,'2011-12-16'),(1824,'g',0,'2011-12-16'),(1603,'g',0,'2012-02-22'),(1556,'g',0,'2012-02-22'),(1887,'g',0,'2012-02-22'),(800,'g',0,'2012-02-01'),(913,'g',0,'2011-12-16'),(572,'g',0,'2012-02-01'),(526,'g',0,'2012-02-01'),(993,'g',0,'2012-02-22'),(899,'g',0,'2012-02-22'),(1050,'g',0,'2012-02-22'),(961,'g',0,'2011-12-16'),(569,'g',0,'2012-02-01'),(623,'g',0,'2011-12-16'),(598,'g',0,'2011-12-16'),(807,'g',0,'2011-12-16'),(901,'g',0,'2011-12-16'),(830,'g',0,'2011-12-16'),(473,'g',0,'2011-12-16'),(864,'g',0,'2011-12-16'),(618,'g',0,'2011-12-16'),(1658,'g',0,'2012-02-24'),(842,'g',0,'2011-12-16'),(962,'g',0,'2011-12-16'),(493,'g',0,'2012-02-01'),(960,'g',0,'2011-12-16'),(446,'g',0,'2011-12-16'),(581,'g',0,'2011-12-16'),(516,'g',0,'2011-12-16'),(512,'g',0,'2011-12-16'),(455,'g',0,'2011-12-16'),(475,'g',0,'2011-12-16'),(614,'g',0,'2011-12-16'),(469,'g',0,'2011-12-16'),(483,'g',0,'2012-02-01'),(508,'g',0,'2012-01-21'),(739,'g',0,'2012-02-28'),(529,'g',0,'2012-01-17'),(501,'g',0,'2012-02-17'),(499,'g',0,'2012-02-17'),(540,'g',0,'2012-02-17'),(536,'g',0,'2012-01-28'),(464,'g',0,'2012-02-27'),(463,'g',0,'2012-02-27'),(844,'g',0,'2012-02-27'),(701,'g',0,'2012-01-28'),(829,'g',0,'2012-02-27'),(858,'g',0,'2012-01-28'),(561,'g',0,'2012-03-03'),(505,'g',0,'2012-03-03'),(667,'g',0,'2012-03-03'),(691,'g',0,'2012-03-03'),(683,'g',0,'2012-03-03'),(1028,'g',0,'2012-03-03'),(1834,'g',0,'2011-12-17'),(1850,'g',0,'2011-12-17'),(1809,'g',0,'2011-12-17'),(447,'g',0,'2012-02-08'),(519,'g',0,'2011-12-17'),(449,'g',0,'2012-02-08'),(486,'g',0,'2011-12-17'),(515,'g',0,'2011-12-17'),(451,'g',0,'2012-02-08'),(472,'g',0,'2011-12-17'),(477,'g',0,'2011-12-17'),(467,'g',0,'2012-02-08'),(975,'g',0,'2011-12-17'),(954,'g',0,'2011-12-17'),(1660,'g',0,'2012-01-18'),(495,'g',0,'2012-02-22'),(979,'g',0,'2012-02-22'),(692,'g',0,'2012-02-22'),(818,'g',0,'2012-02-22'),(530,'g',0,'2011-12-17'),(566,'g',0,'2011-12-17'),(616,'g',0,'2011-12-17'),(496,'g',0,'2011-12-17'),(470,'g',0,'2011-12-17'),(603,'g',0,'2011-12-17'),(484,'g',0,'2011-12-17'),(612,'g',0,'2011-12-17'),(458,'g',0,'2011-12-17'),(571,'g',0,'2011-12-17'),(494,'g',0,'2011-12-17'),(482,'g',0,'2011-12-17'),(875,'g',0,'2011-12-17'),(900,'g',0,'2011-12-17'),(806,'g',0,'2011-12-17'),(682,'g',0,'2011-12-17'),(595,'g',0,'2011-12-17'),(920,'g',0,'2011-12-17'),(906,'g',0,'2011-12-17'),(503,'g',0,'2012-03-02'),(554,'g',0,'2011-12-19'),(570,'g',0,'2011-12-19'),(539,'g',0,'2012-03-02'),(615,'g',0,'2011-12-19'),(597,'g',0,'2011-12-19'),(542,'g',0,'2012-01-24'),(848,'g',0,'2012-01-19'),(518,'g',0,'2012-03-02'),(662,'g',0,'2012-01-23'),(564,'g',0,'2011-12-20'),(697,'g',0,'2012-01-19'),(574,'g',0,'2012-01-19'),(647,'g',0,'2012-01-23'),(703,'g',0,'2012-01-23'),(854,'g',0,'2012-01-19'),(456,'g',0,'2012-01-19'),(1868,'g',0,'2012-01-19'),(1867,'g',0,'2012-01-19'),(606,'g',0,'2011-12-20'),(860,'g',0,'2012-01-19'),(835,'g',0,'2011-12-21'),(756,'g',0,'2012-02-20'),(836,'g',0,'2011-12-21'),(834,'g',0,'2012-02-20'),(833,'g',0,'2012-02-20'),(824,'g',0,'2012-01-20'),(1875,'g',0,'2011-12-21'),(538,'g',0,'2011-12-21'),(537,'g',0,'2012-01-21'),(948,'g',0,'2011-12-21'),(957,'g',0,'2011-12-21'),(709,'g',0,'2011-12-21'),(759,'g',0,'2011-12-21'),(636,'g',0,'2011-12-21'),(468,'g',0,'2012-02-08'),(791,'g',0,'2011-12-22'),(1872,'g',0,'2012-01-30'),(1851,'g',0,'2011-12-22'),(1855,'g',0,'2011-12-22'),(1854,'g',0,'2011-12-22'),(1853,'g',0,'2011-12-22'),(671,'g',0,'2011-12-22'),(1031,'g',0,'2012-02-19'),(1924,'g',0,'2012-02-19'),(1856,'g',0,'2012-01-30'),(1873,'g',0,'2012-01-30'),(1852,'g',0,'2011-12-22'),(1857,'g',0,'2011-12-22'),(1859,'g',0,'2011-12-22'),(1411,'g',0,'2012-01-21'),(1768,'g',0,'2012-02-02'),(822,'g',0,'2011-12-22'),(453,'g',0,'2011-12-23'),(857,'g',0,'2011-12-23'),(541,'g',0,'2012-02-22'),(1882,'g',0,'2012-01-25'),(885,'g',0,'2011-12-23'),(731,'g',0,'2012-02-22'),(461,'g',0,'2012-02-22'),(843,'g',0,'2012-02-22'),(533,'g',0,'2012-02-22'),(764,'g',0,'2012-03-07'),(797,'g',0,'2012-03-06'),(794,'g',0,'2012-03-07'),(863,'g',0,'2011-12-23'),(568,'g',0,'2012-03-06'),(565,'g',0,'2012-03-07'),(492,'g',0,'2011-12-23'),(510,'g',0,'2011-12-23'),(487,'g',0,'2011-12-23'),(509,'g',0,'2011-12-23'),(488,'g',0,'2011-12-23'),(491,'g',0,'2011-12-23'),(511,'g',0,'2011-12-23'),(490,'g',0,'2011-12-23'),(507,'g',0,'2011-12-23'),(621,'g',0,'2012-03-03'),(448,'g',0,'2011-12-23'),(695,'g',0,'2012-03-03'),(573,'g',0,'2012-03-03'),(998,'g',0,'2011-12-23'),(867,'g',0,'2011-12-23'),(1363,'g',0,'2011-12-23'),(1600,'g',0,'2011-12-23'),(1923,'g',0,'2011-12-23'),(609,'g',0,'2012-02-03'),(654,'g',0,'2012-02-03'),(658,'g',0,'2011-12-26'),(1956,'g',0,'2011-12-26'),(582,'g',0,'2012-02-28'),(523,'g',0,'2011-12-26'),(548,'g',0,'2011-12-26'),(1977,'g',0,'2012-02-08'),(1982,'g',0,'2011-12-26'),(1861,'g',0,'2011-12-26'),(1860,'g',0,'2011-12-26'),(549,'g',0,'2012-01-31'),(1937,'g',0,'2012-02-08'),(465,'g',0,'2011-12-26'),(462,'g',0,'2011-12-26'),(466,'g',0,'2011-12-26'),(480,'g',0,'2011-12-26'),(481,'g',0,'2011-12-26'),(497,'g',0,'2011-12-26'),(500,'g',0,'2011-12-26'),(504,'g',0,'2012-02-05'),(640,'g',0,'2012-02-06'),(506,'g',0,'2012-02-05'),(707,'g',0,'2011-12-26'),(644,'g',0,'2011-12-26'),(659,'g',0,'2011-12-26'),(576,'g',0,'2012-02-05'),(769,'g',0,'2011-12-26'),(827,'g',0,'2011-12-26'),(1915,'g',0,'2011-12-26'),(557,'g',0,'2012-02-27'),(556,'g',0,'2012-02-27'),(1858,'g',0,'2011-12-26'),(457,'g',0,'2012-02-22'),(912,'g',0,'2011-12-27'),(1360,'g',0,'2011-12-28'),(1669,'g',0,'2011-12-28'),(1983,'g',0,'2011-12-28'),(1670,'g',0,'2011-12-28'),(1596,'g',0,'2011-12-28'),(1595,'g',0,'2011-12-28'),(861,'g',0,'2011-12-28'),(847,'g',0,'2011-12-28'),(967,'g',0,'2011-12-28'),(846,'g',0,'2011-12-28'),(1964,'g',0,'2011-12-28'),(1052,'g',0,'2011-12-28'),(1918,'g',0,'2011-12-28'),(1864,'g',0,'2011-12-28'),(1970,'g',0,'2011-12-28'),(1979,'g',0,'2011-12-28'),(661,'g',0,'2011-12-28'),(638,'g',0,'2011-12-28'),(664,'g',0,'2011-12-28'),(743,'g',0,'2011-12-28'),(630,'g',0,'2011-12-28'),(804,'g',0,'2011-12-28'),(779,'g',0,'2011-12-28'),(676,'g',0,'2011-12-28'),(727,'g',0,'2011-12-28'),(1984,'g',0,'2011-12-28'),(1552,'g',0,'2011-12-28'),(1448,'g',0,'2011-12-28'),(1582,'g',0,'2011-12-28'),(1565,'g',0,'2011-12-28'),(1554,'g',0,'2011-12-28'),(1553,'g',0,'2011-12-28'),(1436,'g',0,'2011-12-28'),(1446,'g',0,'2011-12-28'),(1564,'g',0,'2011-12-28'),(1435,'g',0,'2011-12-28'),(1427,'g',0,'2011-12-28'),(1405,'g',0,'2011-12-28'),(1383,'g',0,'2011-12-28'),(1424,'g',0,'2011-12-28'),(1426,'g',0,'2011-12-28'),(1368,'g',0,'2011-12-28'),(1418,'g',0,'2011-12-28'),(1422,'g',0,'2011-12-28'),(1333,'g',0,'2011-12-28'),(1429,'g',0,'2011-12-28'),(452,'g',0,'2011-12-28'),(550,'g',0,'2011-12-28'),(551,'g',0,'2011-12-28'),(560,'g',0,'2011-12-28'),(578,'g',0,'2011-12-28'),(471,'g',0,'2011-12-30'),(817,'g',0,'2012-03-04'),(876,'g',0,'2011-12-31'),(1407,'g',0,'2011-12-31'),(1881,'g',0,'2011-12-31'),(1990,'g',0,'2011-12-31'),(1365,'g',0,'2011-12-31'),(946,'g',0,'2011-12-31'),(874,'g',0,'2011-12-31'),(1018,'g',0,'2011-12-31'),(1891,'g',0,'2011-12-31'),(1950,'g',0,'2011-12-31'),(1884,'g',0,'2011-12-31'),(1011,'g',0,'2011-12-31'),(1942,'g',0,'2011-12-31'),(1389,'g',0,'2011-12-31'),(1987,'g',0,'2011-12-31'),(1434,'g',0,'2011-12-31'),(1437,'g',0,'2011-12-31'),(1415,'g',0,'2011-12-31'),(1393,'g',0,'2011-12-31'),(1549,'g',0,'2011-12-31'),(1390,'g',0,'2011-12-31'),(1550,'g',0,'2011-12-31'),(1605,'g',0,'2011-12-31'),(897,'g',0,'2011-12-31'),(604,'g',0,'2012-01-01'),(943,'g',0,'2012-03-04'),(911,'g',0,'2012-01-01'),(991,'g',0,'2012-01-01'),(1441,'g',0,'2012-03-04'),(924,'g',0,'2012-01-02'),(850,'g',0,'2012-03-04'),(1960,'g',0,'2012-03-04'),(1951,'g',0,'2012-03-04'),(1409,'g',0,'2012-01-02'),(593,'g',0,'2012-01-02'),(547,'g',0,'2012-01-02'),(884,'g',0,'2012-01-02'),(521,'g',0,'2012-01-03'),(1904,'g',0,'2012-01-03'),(1589,'g',0,'2012-01-03'),(2044,'g',0,'2012-02-03'),(2043,'g',0,'2012-02-03'),(580,'g',0,'2012-01-04'),(2010,'g',0,'2012-01-05'),(1364,'g',0,'2012-02-14'),(1972,'g',0,'2012-02-14'),(2031,'g',0,'2012-01-07'),(1531,'g',0,'2012-02-14'),(2049,'g',0,'2012-01-07'),(2029,'g',0,'2012-01-07'),(2033,'g',0,'2012-01-07'),(1973,'g',0,'2012-02-08'),(2014,'g',0,'2012-02-08'),(2055,'g',0,'2012-02-22'),(2040,'g',0,'2012-01-08'),(2042,'g',0,'2012-01-08'),(2050,'g',0,'2012-01-09'),(2057,'g',0,'2012-01-09'),(2052,'g',0,'2012-01-09'),(2053,'g',0,'2012-01-09'),(2051,'g',0,'2012-01-09'),(2078,'g',0,'2012-01-09'),(2039,'g',0,'2012-01-09'),(2060,'g',0,'2012-01-09'),(600,'g',0,'2012-01-09'),(862,'g',0,'2012-01-09'),(643,'g',0,'2012-01-09'),(2048,'g',0,'2012-01-09'),(2004,'g',0,'2012-01-09'),(2091,'g',0,'2012-02-22'),(2097,'g',0,'2012-02-22'),(2077,'g',0,'2012-01-10'),(2083,'g',0,'2012-01-10'),(2086,'g',0,'2012-01-10'),(2084,'g',0,'2012-01-10'),(2070,'g',0,'2012-01-10'),(2066,'g',0,'2012-01-10'),(2065,'g',0,'2012-01-10'),(2081,'g',0,'2012-03-02'),(476,'g',0,'2012-03-02'),(786,'g',0,'2012-03-07'),(619,'g',0,'2012-02-22'),(2064,'g',0,'2012-03-06'),(2090,'g',0,'2012-02-22'),(814,'g',0,'2012-02-22'),(881,'g',0,'2012-02-22'),(859,'g',0,'2012-02-22'),(820,'g',0,'2012-02-22'),(699,'g',0,'2012-02-22'),(851,'g',0,'2012-02-22'),(675,'g',0,'2012-01-10'),(869,'g',0,'2012-02-22'),(677,'g',0,'2012-02-22'),(923,'g',0,'2012-01-10'),(934,'g',0,'2012-01-10'),(907,'g',0,'2012-02-22'),(966,'g',0,'2012-01-10'),(963,'g',0,'2012-01-10'),(964,'g',0,'2012-01-10'),(882,'g',0,'2012-02-22'),(922,'g',0,'2012-01-10'),(917,'g',0,'2012-01-10'),(921,'g',0,'2012-01-10'),(2079,'g',0,'2012-01-10'),(2067,'g',0,'2012-01-10'),(2019,'g',0,'2012-01-10'),(2058,'g',0,'2012-01-11'),(2073,'g',0,'2012-01-11'),(2076,'g',0,'2012-02-22'),(2092,'g',0,'2012-01-13'),(887,'g',0,'2012-01-13'),(1342,'g',0,'2012-01-13'),(1343,'g',0,'2012-01-13'),(1344,'g',0,'2012-01-13'),(1345,'g',0,'2012-01-13'),(1346,'g',0,'2012-01-13'),(1348,'g',0,'2012-01-13'),(1349,'g',0,'2012-01-13'),(1351,'g',0,'2012-01-13'),(1352,'g',0,'2012-01-13'),(1353,'g',0,'2012-01-13'),(1355,'g',0,'2012-01-13'),(1354,'g',0,'2012-01-13'),(1412,'g',0,'2012-01-13'),(1519,'g',0,'2012-01-13'),(1401,'g',0,'2012-01-13'),(1350,'g',0,'2012-01-13'),(2134,'g',0,'2012-03-02'),(2098,'g',0,'2012-02-14'),(2074,'g',0,'2012-02-13'),(2046,'g',0,'2012-02-22'),(2139,'g',0,'2012-01-15'),(2095,'g',0,'2012-02-27'),(2115,'g',0,'2012-02-27'),(2119,'g',0,'2012-02-27'),(2133,'g',0,'2012-02-22'),(2150,'g',0,'2012-02-22'),(2114,'g',0,'2012-02-22'),(2087,'g',0,'2012-02-17'),(2135,'g',0,'2012-02-17'),(2068,'g',0,'2012-02-17'),(2136,'g',0,'2012-01-17'),(2149,'g',0,'2012-01-17'),(2157,'g',0,'2012-02-22'),(2082,'g',0,'2012-03-07'),(2072,'g',0,'2012-03-07'),(2163,'g',0,'2012-01-19'),(2080,'g',0,'2012-01-19'),(2099,'g',0,'2012-03-07'),(2069,'g',0,'2012-03-07'),(2059,'g',0,'2012-01-19'),(2062,'g',0,'2012-01-19'),(2089,'g',0,'2012-03-07'),(2152,'g',0,'2012-02-22'),(2166,'g',0,'2012-01-19'),(2156,'g',0,'2012-02-22'),(2143,'g',0,'2012-02-22'),(2142,'g',0,'2012-03-07'),(2160,'g',0,'2012-03-07'),(2159,'g',0,'2012-03-07'),(2154,'g',0,'2012-02-22'),(2171,'g',0,'2012-01-19'),(2118,'g',0,'2012-03-07'),(2063,'g',0,'2012-01-19'),(2032,'g',0,'2012-01-19'),(668,'g',0,'2012-01-19'),(1500,'g',0,'2012-01-20'),(1499,'g',0,'2012-01-20'),(1501,'g',0,'2012-01-20'),(1502,'g',0,'2012-01-20'),(1497,'g',0,'2012-01-20'),(1495,'g',0,'2012-01-20'),(1498,'g',0,'2012-01-20'),(1496,'g',0,'2012-01-20'),(1503,'g',0,'2012-01-20'),(1504,'g',0,'2012-01-20'),(1981,'g',0,'2012-01-20'),(1916,'g',0,'2012-01-20'),(2104,'g',0,'2012-01-20'),(1931,'g',0,'2012-01-20'),(1921,'g',0,'2012-01-20'),(2021,'g',0,'2012-01-20'),(1877,'g',0,'2012-01-20'),(1998,'g',0,'2012-01-20'),(1906,'g',0,'2012-01-20'),(1461,'g',0,'2012-01-20'),(1460,'g',0,'2012-01-20'),(1476,'g',0,'2012-01-20'),(1462,'g',0,'2012-01-20'),(1478,'g',0,'2012-01-20'),(1459,'g',0,'2012-01-20'),(1474,'g',0,'2012-01-20'),(1468,'g',0,'2012-01-20'),(1465,'g',0,'2012-01-20'),(1475,'g',0,'2012-01-20'),(1410,'g',0,'2012-01-20'),(1455,'g',0,'2012-01-20'),(1615,'g',0,'2012-01-20'),(2016,'g',0,'2012-01-20'),(1377,'g',0,'2012-01-20'),(1509,'g',0,'2012-01-20'),(1513,'g',0,'2012-01-20'),(1511,'g',0,'2012-01-20'),(1510,'g',0,'2012-01-20'),(1508,'g',0,'2012-01-20'),(1506,'g',0,'2012-01-20'),(1505,'g',0,'2012-01-20'),(1518,'g',0,'2012-01-20'),(1507,'g',0,'2012-01-20'),(1512,'g',0,'2012-01-20'),(914,'g',0,'2012-01-20'),(936,'g',0,'2012-01-20'),(925,'g',0,'2012-01-20'),(1012,'g',0,'2012-01-20'),(1968,'g',0,'2012-01-20'),(1017,'g',0,'2012-01-20'),(2037,'g',0,'2012-01-20'),(2056,'g',0,'2012-01-20'),(2071,'g',0,'2012-01-20'),(2088,'g',0,'2012-01-20'),(2093,'g',0,'2012-01-20'),(2102,'g',0,'2012-01-20'),(2100,'g',0,'2012-01-20'),(2101,'g',0,'2012-01-20'),(2061,'g',0,'2012-01-20'),(1491,'g',0,'2012-01-20'),(1493,'g',0,'2012-01-20'),(1473,'g',0,'2012-01-20'),(1494,'g',0,'2012-01-20'),(1488,'g',0,'2012-01-20'),(1487,'g',0,'2012-01-20'),(1490,'g',0,'2012-01-20'),(1489,'g',0,'2012-01-20'),(1492,'g',0,'2012-01-20'),(1486,'g',0,'2012-01-20'),(974,'g',0,'2012-01-20'),(973,'g',0,'2012-01-20'),(970,'g',0,'2012-01-20'),(972,'g',0,'2012-01-20'),(999,'g',0,'2012-01-20'),(933,'g',0,'2012-01-20'),(983,'g',0,'2012-01-20'),(1002,'g',0,'2012-01-20'),(1001,'g',0,'2012-01-20'),(1940,'g',0,'2012-01-20'),(1047,'g',0,'2012-01-20'),(1947,'g',0,'2012-01-20'),(1939,'g',0,'2012-01-20'),(1048,'g',0,'2012-01-20'),(1933,'g',0,'2012-01-20'),(1967,'g',0,'2012-01-20'),(1936,'g',0,'2012-01-20'),(1944,'g',0,'2012-01-20'),(2015,'g',0,'2012-01-20'),(905,'g',0,'2012-01-20'),(826,'g',0,'2012-01-20'),(903,'g',0,'2012-01-20'),(821,'g',0,'2012-01-20'),(940,'g',0,'2012-01-20'),(904,'g',0,'2012-01-20'),(931,'g',0,'2012-01-20'),(902,'g',0,'2012-01-20'),(873,'g',0,'2012-01-20'),(929,'g',0,'2012-01-20'),(855,'g',0,'2012-01-20'),(947,'g',0,'2012-01-20'),(910,'g',0,'2012-01-20'),(958,'g',0,'2012-01-20'),(809,'g',0,'2012-01-20'),(930,'g',0,'2012-01-20'),(927,'g',0,'2012-01-20'),(932,'g',0,'2012-01-20'),(1043,'g',0,'2012-01-20'),(1032,'g',0,'2012-01-20'),(1400,'g',0,'2012-01-20'),(1391,'g',0,'2012-01-20'),(1372,'g',0,'2012-01-20'),(1417,'g',0,'2012-01-20'),(1358,'g',0,'2012-01-20'),(1359,'g',0,'2012-01-20'),(1399,'g',0,'2012-01-20'),(1398,'g',0,'2012-01-20'),(1357,'g',0,'2012-01-20'),(1367,'g',0,'2012-01-20'),(2168,'g',0,'2012-01-20'),(2165,'g',0,'2012-01-21'),(1007,'g',0,'2012-01-21'),(2116,'g',0,'2012-01-21'),(2041,'g',0,'2012-01-21'),(2075,'g',0,'2012-01-21'),(2030,'g',0,'2012-01-21'),(2035,'g',0,'2012-01-21'),(2045,'g',0,'2012-01-21'),(2034,'g',0,'2012-01-21'),(1925,'g',0,'2012-01-21'),(2085,'g',0,'2012-01-21'),(2110,'g',0,'2012-01-21'),(1458,'g',0,'2012-01-21'),(1051,'g',0,'2012-01-21'),(1456,'g',0,'2012-01-21'),(1005,'g',0,'2012-01-21'),(1064,'g',0,'2012-01-21'),(1004,'g',0,'2012-01-21'),(1008,'g',0,'2012-01-21'),(1457,'g',0,'2012-01-21'),(2094,'g',0,'2012-01-21'),(1594,'g',0,'2012-01-21'),(1863,'g',0,'2012-01-21'),(1408,'g',0,'2012-01-21'),(1619,'g',0,'2012-01-21'),(2006,'g',0,'2012-01-21'),(1893,'g',0,'2012-01-21'),(1332,'g',0,'2012-01-21'),(1580,'g',0,'2012-01-21'),(1527,'g',0,'2012-01-21'),(1663,'g',0,'2012-01-21'),(2005,'g',0,'2012-01-21'),(1607,'g',0,'2012-01-21'),(1356,'g',0,'2012-01-21'),(1630,'g',0,'2012-01-21'),(1649,'g',0,'2012-01-21'),(2173,'g',0,'2012-01-21'),(1445,'g',0,'2012-01-22'),(1463,'g',0,'2012-01-22'),(1428,'g',0,'2012-01-22'),(1438,'g',0,'2012-01-22'),(1443,'g',0,'2012-01-22'),(1466,'g',0,'2012-01-22'),(1439,'g',0,'2012-01-22'),(1469,'g',0,'2012-01-22'),(1471,'g',0,'2012-01-22'),(1450,'g',0,'2012-01-22'),(2144,'g',0,'2012-02-27'),(2174,'g',0,'2012-01-22'),(2145,'g',0,'2012-02-22'),(2146,'g',0,'2012-02-22'),(2117,'g',0,'2012-02-22'),(2109,'g',0,'2012-01-22'),(2132,'g',0,'2012-01-22'),(2148,'g',0,'2012-01-23'),(918,'g',0,'2012-01-23'),(981,'g',0,'2012-01-23'),(969,'g',0,'2012-01-23'),(898,'g',0,'2012-01-23'),(919,'g',0,'2012-01-23'),(980,'g',0,'2012-01-23'),(928,'g',0,'2012-01-23'),(892,'g',0,'2012-01-23'),(916,'g',0,'2012-01-23'),(951,'g',0,'2012-01-23'),(1986,'g',0,'2012-01-23'),(1994,'g',0,'2012-01-23'),(2017,'g',0,'2012-01-23'),(2013,'g',0,'2012-01-23'),(1963,'g',0,'2012-01-23'),(1995,'g',0,'2012-01-23'),(1978,'g',0,'2012-01-23'),(1991,'g',0,'2012-01-23'),(2107,'g',0,'2012-01-23'),(1976,'g',0,'2012-01-23'),(2096,'g',0,'2012-01-23'),(997,'g',0,'2012-01-24'),(982,'g',0,'2012-01-24'),(986,'g',0,'2012-01-24'),(1061,'g',0,'2012-01-24'),(1049,'g',0,'2012-01-24'),(1040,'g',0,'2012-01-24'),(1033,'g',0,'2012-01-24'),(1027,'g',0,'2012-01-24'),(1062,'g',0,'2012-01-24'),(1935,'g',0,'2012-01-24'),(1926,'g',0,'2012-01-24'),(1927,'g',0,'2012-01-24'),(1419,'g',0,'2012-01-24'),(1414,'g',0,'2012-01-24'),(1385,'g',0,'2012-01-24'),(1869,'g',0,'2012-01-24'),(1442,'g',0,'2012-01-24'),(1402,'g',0,'2012-01-24'),(2024,'g',0,'2012-01-24'),(1371,'g',0,'2012-01-24'),(2008,'g',0,'2012-01-24'),(1878,'g',0,'2012-01-24'),(1885,'g',0,'2012-01-24'),(1901,'g',0,'2012-01-24'),(2018,'g',0,'2012-01-24'),(1900,'g',0,'2012-01-24'),(1883,'g',0,'2012-01-24'),(1919,'g',0,'2012-01-24'),(2002,'g',0,'2012-01-24'),(1922,'g',0,'2012-01-24'),(2155,'g',0,'2012-01-24'),(2182,'g',0,'2012-01-25'),(2184,'g',0,'2012-01-25'),(2147,'g',0,'2012-02-28'),(2158,'g',0,'2012-02-28'),(2175,'g',0,'2012-03-02'),(2187,'g',0,'2012-03-02'),(2193,'g',0,'2012-01-26'),(2196,'g',0,'2012-01-28'),(2190,'g',0,'2012-01-28'),(2199,'g',0,'2012-01-28'),(2197,'g',0,'2012-01-28'),(2192,'g',0,'2012-01-28'),(2183,'g',0,'2012-01-29'),(2054,'g',0,'2012-03-07'),(2103,'g',0,'2012-03-07'),(2106,'g',0,'2012-03-07'),(1874,'g',0,'2012-01-30'),(1862,'g',0,'2012-01-30'),(2191,'g',0,'2012-01-30'),(2151,'g',0,'2012-03-07'),(2188,'g',0,'2012-01-30'),(2167,'g',0,'2012-01-30'),(2189,'g',0,'2012-01-30'),(2176,'g',0,'2012-01-30'),(2164,'g',0,'2012-01-30'),(2180,'g',0,'2012-01-30'),(2178,'g',0,'2012-01-30'),(2179,'g',0,'2012-01-30'),(2181,'g',0,'2012-01-30'),(2162,'g',0,'2012-01-30'),(2177,'g',0,'2012-01-30'),(2172,'g',0,'2012-01-30'),(2195,'g',0,'2012-01-30'),(2225,'g',0,'2012-01-30'),(2194,'g',0,'2012-01-31'),(2217,'g',0,'2012-01-31'),(2186,'g',0,'2012-01-31'),(2185,'g',0,'2012-01-31'),(2208,'g',0,'2012-02-01'),(2210,'g',0,'2012-02-01'),(2218,'g',0,'2012-02-04'),(2240,'g',0,'2012-02-04'),(2246,'g',0,'2012-02-04'),(2209,'g',0,'2012-02-04'),(2224,'g',0,'2012-02-04'),(2226,'g',0,'2012-02-05'),(2253,'g',0,'2012-02-05'),(2252,'g',0,'2012-02-05'),(2272,'g',0,'2012-02-05'),(2273,'g',0,'2012-02-05'),(2223,'g',0,'2012-02-05'),(2219,'g',0,'2012-02-05'),(2207,'g',0,'2012-02-05'),(2213,'g',0,'2012-02-05'),(2237,'g',0,'2012-02-06'),(2276,'g',0,'2012-02-06'),(2262,'g',0,'2012-02-06'),(2230,'g',0,'2012-02-06'),(2261,'g',0,'2012-02-06'),(2258,'g',0,'2012-02-06'),(2260,'g',0,'2012-02-06'),(2259,'g',0,'2012-02-06'),(2254,'g',0,'2012-02-06'),(2257,'g',0,'2012-02-06'),(2256,'g',0,'2012-02-06'),(2255,'g',0,'2012-02-06'),(2245,'g',0,'2012-02-07'),(2271,'g',0,'2012-02-07'),(2303,'g',0,'2012-02-07'),(2216,'g',0,'2012-02-07'),(700,'g',0,'2012-02-07'),(646,'g',0,'2012-02-07'),(696,'g',0,'2012-02-07'),(663,'g',0,'2012-02-07'),(698,'g',0,'2012-02-07'),(685,'g',0,'2012-02-07'),(704,'g',0,'2012-02-07'),(681,'g',0,'2012-02-07'),(642,'g',0,'2012-02-07'),(625,'g',0,'2012-02-07'),(2243,'g',0,'2012-02-07'),(2298,'g',0,'2012-02-07'),(2299,'g',0,'2012-02-07'),(2301,'g',0,'2012-02-07'),(783,'g',0,'2012-02-08'),(840,'g',0,'2012-02-08'),(878,'g',0,'2012-02-08'),(832,'g',0,'2012-02-08'),(880,'g',0,'2012-02-08'),(784,'g',0,'2012-02-08'),(805,'g',0,'2012-02-08'),(831,'g',0,'2012-02-08'),(853,'g',0,'2012-02-08'),(893,'g',0,'2012-02-08'),(2296,'g',0,'2012-02-08'),(2251,'g',0,'2012-02-08'),(2234,'g',0,'2012-02-08'),(2300,'g',0,'2012-02-08'),(1966,'g',0,'2012-02-08'),(1962,'g',0,'2012-02-08'),(1938,'g',0,'2012-02-08'),(1975,'g',0,'2012-02-08'),(1961,'g',0,'2012-02-08'),(1903,'g',0,'2012-02-08'),(2003,'g',0,'2012-02-08'),(1897,'g',0,'2012-02-08'),(1958,'g',0,'2012-02-08'),(2007,'g',0,'2012-02-08'),(2304,'g',0,'2012-02-08'),(2297,'g',0,'2012-02-08'),(2295,'g',0,'2012-02-08'),(2238,'g',0,'2012-02-08'),(2294,'g',0,'2012-02-08'),(2293,'g',0,'2012-02-08'),(2288,'g',0,'2012-02-08'),(1374,'g',0,'2012-02-08'),(1754,'g',0,'2012-02-08'),(1373,'g',0,'2012-02-08'),(1516,'g',0,'2012-02-08'),(1375,'g',0,'2012-02-08'),(2239,'g',0,'2012-02-08'),(2242,'g',0,'2012-02-09'),(2214,'g',0,'2012-02-09'),(2244,'g',0,'2012-02-09'),(2233,'g',0,'2012-02-09'),(2248,'g',0,'2012-02-09'),(2247,'g',0,'2012-02-09'),(2302,'g',0,'2012-02-09'),(2227,'g',0,'2012-02-09'),(2306,'g',0,'2012-02-09'),(2249,'g',0,'2012-02-09'),(2250,'g',0,'2012-02-09'),(2275,'g',0,'2012-02-09'),(2309,'g',0,'2012-02-10'),(2317,'g',0,'2012-02-10'),(2285,'g',0,'2012-02-10'),(2311,'g',0,'2012-02-10'),(2316,'g',0,'2012-02-10'),(1871,'g',0,'2012-02-10'),(1880,'g',0,'2012-02-10'),(2022,'g',0,'2012-02-10'),(1866,'g',0,'2012-02-10'),(1894,'g',0,'2012-02-10'),(2026,'g',0,'2012-02-10'),(2307,'g',0,'2012-02-10'),(2235,'g',0,'2012-02-10'),(1756,'g',0,'2012-02-10'),(1757,'g',0,'2012-02-10'),(1758,'g',0,'2012-02-10'),(1755,'g',0,'2012-02-10'),(2283,'g',0,'2012-02-10'),(2236,'g',0,'2012-02-10'),(2232,'g',0,'2012-02-11'),(2279,'g',0,'2012-02-11'),(2308,'g',0,'2012-02-11'),(2282,'g',0,'2012-02-11'),(2312,'g',0,'2012-02-11'),(2313,'g',0,'2012-02-11'),(2241,'g',0,'2012-02-11'),(2277,'g',0,'2012-02-11'),(2228,'g',0,'2012-02-11'),(2281,'g',0,'2012-02-11'),(2314,'g',0,'2012-02-11'),(2278,'g',0,'2012-02-11'),(2289,'g',0,'2012-02-12'),(2284,'g',0,'2012-02-12'),(2318,'g',0,'2012-02-12'),(2290,'g',0,'2012-02-12'),(2287,'g',0,'2012-02-12'),(2286,'g',0,'2012-02-12'),(2336,'g',0,'2012-02-13'),(1616,'g',0,'2012-02-14'),(1667,'g',0,'2012-02-14'),(1618,'g',0,'2012-02-14'),(1612,'g',0,'2012-02-14'),(1622,'g',0,'2012-02-14'),(1626,'g',0,'2012-02-14'),(1623,'g',0,'2012-02-14'),(2310,'g',0,'2012-02-14'),(2211,'g',0,'2012-02-14'),(2221,'g',0,'2012-02-14'),(2229,'g',0,'2012-02-14'),(2315,'g',0,'2012-02-15'),(738,'g',0,'2012-02-15'),(2319,'g',0,'2012-02-15'),(713,'g',0,'2012-02-15'),(705,'g',0,'2012-02-15'),(653,'g',0,'2012-02-15'),(702,'g',0,'2012-02-15'),(649,'g',0,'2012-02-15'),(673,'g',0,'2012-02-15'),(689,'g',0,'2012-02-15'),(710,'g',0,'2012-02-15'),(712,'g',0,'2012-02-15'),(2346,'g',0,'2012-02-15'),(2305,'g',0,'2012-02-15'),(994,'g',0,'2012-02-15'),(995,'g',0,'2012-02-15'),(1030,'g',0,'2012-02-15'),(1899,'g',0,'2012-02-15'),(1889,'g',0,'2012-02-15'),(1387,'g',0,'2012-02-15'),(1888,'g',0,'2012-02-15'),(1021,'g',0,'2012-02-15'),(2001,'g',0,'2012-02-15'),(1989,'g',0,'2012-02-15'),(976,'g',0,'2012-02-15'),(978,'g',0,'2012-02-15'),(810,'g',0,'2012-02-15'),(941,'g',0,'2012-02-15'),(879,'g',0,'2012-02-15'),(772,'g',0,'2012-02-15'),(1560,'g',0,'2012-02-16'),(1544,'g',0,'2012-02-16'),(1557,'g',0,'2012-02-16'),(1559,'g',0,'2012-02-17'),(1558,'g',0,'2012-02-17'),(2332,'g',0,'2012-02-17'),(1562,'g',0,'2012-02-17'),(1563,'g',0,'2012-02-17'),(1432,'g',0,'2012-02-20'),(718,'g',0,'2012-02-20'),(717,'g',0,'2012-02-20'),(714,'g',0,'2012-02-20'),(715,'g',0,'2012-02-20'),(719,'g',0,'2012-02-20'),(2012,'g',0,'2012-02-20'),(2335,'g',0,'2012-02-20'),(1347,'g',0,'2012-02-21'),(2345,'g',0,'2012-02-22'),(2350,'g',0,'2012-02-22'),(1599,'g',0,'2012-02-22'),(1588,'g',0,'2012-02-22'),(1547,'g',0,'2012-02-22'),(1585,'g',0,'2012-02-22'),(1579,'g',0,'2012-02-22'),(1444,'g',0,'2012-02-22'),(1587,'g',0,'2012-02-22'),(1586,'g',0,'2012-02-22'),(1430,'g',0,'2012-02-22'),(2324,'g',0,'2012-02-22'),(1037,'g',0,'2012-02-22'),(1016,'g',0,'2012-02-22'),(1036,'g',0,'2012-02-22'),(1404,'g',0,'2012-02-22'),(1892,'g',0,'2012-02-22'),(1421,'g',0,'2012-02-22'),(1876,'g',0,'2012-02-22'),(1056,'g',0,'2012-02-22'),(1038,'g',0,'2012-02-22'),(1063,'g',0,'2012-02-22'),(1039,'g',0,'2012-02-22'),(1895,'g',0,'2012-02-22'),(1376,'g',0,'2012-02-22'),(2349,'g',0,'2012-02-22'),(1029,'g',0,'2012-02-23'),(987,'g',0,'2012-02-24'),(1392,'g',0,'2012-02-24'),(1396,'g',0,'2012-02-25'),(2351,'g',0,'2012-02-25'),(1932,'g',0,'2012-02-26'),(2009,'g',0,'2012-02-26'),(1928,'g',0,'2012-02-28'),(2347,'g',0,'2012-02-28'),(971,'g',0,'2012-02-28'),(985,'g',0,'2012-02-28'),(1009,'g',0,'2012-02-28'),(1034,'g',0,'2012-02-28'),(2334,'g',0,'2012-02-28'),(828,'g',0,'2012-02-28'),(816,'g',0,'2012-02-28'),(872,'g',0,'2012-02-28'),(877,'g',0,'2012-02-28'),(856,'g',0,'2012-02-28'),(871,'g',0,'2012-02-28'),(1929,'g',0,'2012-03-01'),(1651,'g',0,'2012-03-01'),(1608,'g',0,'2012-03-01'),(2027,'g',0,'2012-03-01'),(1433,'g',0,'2012-03-01'),(1917,'g',0,'2012-03-01'),(1647,'g',0,'2012-03-01'),(2383,'g',0,'2012-03-01'),(2398,'g',0,'2012-03-04'),(2427,'g',0,'2012-03-05'),(2417,'g',0,'2012-03-05'),(2418,'g',0,'2012-03-05'),(2409,'g',0,'2012-03-05'),(2425,'g',0,'2012-03-06'),(2387,'g',0,'2012-03-06'),(2395,'g',0,'2012-03-06'),(2412,'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_plugin`
--

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

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


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

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

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


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

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

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


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



