--
-- Host: stupelinks.com    Database: stupelin_indexu
-- ------------------------------------------------------


--
-- 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',15,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Auto Industry','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Economy & Business','','folder.gif','','1',146,'','','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',25,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computer Services','','folder.gif','','1',19,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Building & Construction','','folder.gif','','1',74,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Dental','','folder.gif','','1',37,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Educational Resources','','folder.gif','','1',23,'','','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',25,'','','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',167,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Heating and Air Conditioning Contractors','','folder.gif','','1',57,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home & Family','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement & Appliances','','folder.gif','','1',303,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Hotels','','folder.gif','','1',68,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Providers','','folder.gif','','1',33,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law & Legal','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Attorneys','','folder.gif','','1',161,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & Society','','folder.gif','','1',4,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine & Surgery','','folder.gif','','1',11,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Finance & Investment','','folder.gif','','1',20,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News & Media','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing Contractors','','folder.gif','','1',45,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate & Property','','folder.gif','','1',31,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'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 Sales','','folder.gif','','1',54,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Sports & Recreation','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Transportation Services','','folder.gif','','1',39,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Travel & Tour','','folder.gif','','1',17,'','','0','0','','',0,'',0,0,0,0,0),(35,0,'Weddings','','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://stupelinks.com/arts-music/\" name=\"cat_1\" style=\"\">Arts & Music</a>',';0;'),(2,'Auto Industry','<a href=\"http://stupelinks.com/auto-industry/\" name=\"cat_2\" style=\"\">Auto Industry</a>',';0;'),(3,'Economy & Business','<a href=\"http://stupelinks.com/economy-business/\" name=\"cat_3\" style=\"\">Economy & Business</a>',';0;'),(4,'Careers & Job Search','<a href=\"http://stupelinks.com/careers-job-search/\" name=\"cat_4\" style=\"\">Careers & Job Search</a>',';0;'),(5,'Clothing Accessories','<a href=\"http://stupelinks.com/clothing-accessories/\" name=\"cat_5\" style=\"\">Clothing Accessories</a>',';0;'),(6,'Communications Services','<a href=\"http://stupelinks.com/communications-services/\" name=\"cat_6\" style=\"\">Communications Services</a>',';0;'),(7,'Computer Services','<a href=\"http://stupelinks.com/computer-services/\" name=\"cat_7\" style=\"\">Computer Services</a>',';0;'),(8,'Building & Construction','<a href=\"http://stupelinks.com/building-construction/\" name=\"cat_8\" style=\"\">Building & Construction</a>',';0;'),(9,'Dental','<a href=\"http://stupelinks.com/dental/\" name=\"cat_9\" style=\"\">Dental</a>',';0;'),(10,'Educational Resources','<a href=\"http://stupelinks.com/educational-resources/\" name=\"cat_10\" style=\"\">Educational Resources</a>',';0;'),(11,'Recruitment Services','<a href=\"http://stupelinks.com/recruitment-services/\" name=\"cat_11\" style=\"\">Recruitment Services</a>',';0;'),(12,'Gifts & Flowers','<a href=\"http://stupelinks.com/gifts-flowers/\" name=\"cat_12\" style=\"\">Gifts & Flowers</a>',';0;'),(13,'Hardware & Software Resources','<a href=\"http://stupelinks.com/hardware-software-resources/\" name=\"cat_13\" style=\"\">Hardware & Software Resources</a>',';0;'),(14,'Medical & Health','<a href=\"http://stupelinks.com/medical-health/\" name=\"cat_14\" style=\"\">Medical & Health</a>',';0;'),(15,'Healthcare Management','<a href=\"http://stupelinks.com/healthcare-management/\" name=\"cat_15\" style=\"\">Healthcare Management</a>',';0;'),(16,'Heating and Air Conditioning Contractors','<a href=\"http://stupelinks.com/heating-and-air-conditioning-contractors/\" name=\"cat_16\" style=\"\">Heating and Air Conditioning Contractors</a>',';0;'),(17,'Home & Family','<a href=\"http://stupelinks.com/home-family/\" name=\"cat_17\" style=\"\">Home & Family</a>',';0;'),(18,'Home Improvement & Appliances','<a href=\"http://stupelinks.com/home-improvement-appliances/\" name=\"cat_18\" style=\"\">Home Improvement & Appliances</a>',';0;'),(19,'Hotels','<a href=\"http://stupelinks.com/hotels/\" name=\"cat_19\" style=\"\">Hotels</a>',';0;'),(20,'Insurance Providers','<a href=\"http://stupelinks.com/insurance-providers/\" name=\"cat_20\" style=\"\">Insurance Providers</a>',';0;'),(21,'Law & Legal','<a href=\"http://stupelinks.com/law-legal/\" name=\"cat_21\" style=\"\">Law & Legal</a>',';0;'),(22,'Lawyers & Attorneys','<a href=\"http://stupelinks.com/lawyers-attorneys/\" name=\"cat_22\" style=\"\">Lawyers & Attorneys</a>',';0;'),(23,'Lifestyle & Society','<a href=\"http://stupelinks.com/lifestyle-society/\" name=\"cat_23\" style=\"\">Lifestyle & Society</a>',';0;'),(24,'Medicine & Surgery','<a href=\"http://stupelinks.com/medicine-surgery/\" name=\"cat_24\" style=\"\">Medicine & Surgery</a>',';0;'),(25,'Finance & Investment','<a href=\"http://stupelinks.com/finance-investment/\" name=\"cat_25\" style=\"\">Finance & Investment</a>',';0;'),(26,'News & Media','<a href=\"http://stupelinks.com/news-media/\" name=\"cat_26\" style=\"\">News & Media</a>',';0;'),(27,'Plumbing Contractors','<a href=\"http://stupelinks.com/plumbing-contractors/\" name=\"cat_27\" style=\"\">Plumbing Contractors</a>',';0;'),(28,'Real Estate & Property','<a href=\"http://stupelinks.com/real-estate-property/\" name=\"cat_28\" style=\"\">Real Estate & Property</a>',';0;'),(29,'Science','<a href=\"http://stupelinks.com/science/\" name=\"cat_29\" style=\"\">Science</a>',';0;'),(30,'SEO Services','<a href=\"http://stupelinks.com/seo-services/\" name=\"cat_30\" style=\"\">SEO Services</a>',';0;'),(31,'Shopping and Sales','<a href=\"http://stupelinks.com/shopping-and-sales/\" name=\"cat_31\" style=\"\">Shopping and Sales</a>',';0;'),(32,'Sports & Recreation','<a href=\"http://stupelinks.com/sports-recreation/\" name=\"cat_32\" style=\"\">Sports & Recreation</a>',';0;'),(33,'Transportation Services','<a href=\"http://stupelinks.com/transportation-services/\" name=\"cat_33\" style=\"\">Transportation Services</a>',';0;'),(34,'Travel & Tour','<a href=\"http://stupelinks.com/travel-tour/\" name=\"cat_34\" style=\"\">Travel & Tour</a>',';0;'),(35,'Weddings','<a href=\"http://stupelinks.com/weddings/\" name=\"cat_35\" style=\"\">Weddings</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=4 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_category_suggession` VALUES (1,19,'Armando','Did you guys see how Facebook is now snenidg Facebook Page administrators a weekly update regarding their Facebook page? # of new fans, # of visits etc  This is a great new addition!','2012-02-17 02:20:27'),(2,8,'Skylights','SG Eco Industries has 22 years experience in the natural lighting industry. We provide customized solutions to meet your energy saving needs.','2012-02-21 18:50:45'),(3,27,'Plumbers in Colorado Springs','Colorado Springs Plumbing Pro Power Rooter is Lowest Priced Drain Cleaning and Plumbing Service period!\r\n\r\nWe can have one of our expert drain cleaning technicians at your door and ready to fix any of your drain problems at your convenience. With the latest tools and technology our drain technicians will fix your leaky sinks to dripping faucets, flooded toilets and more serious matters such as tree root blockages in the main line.\r\n\r\nWe are always ready to respond to you drain problems, for any residential or commercial property owner with an emergency were there is a need for a drain clog solution.\r\n\r\n\r\nWe have the lowest prices in Colorado Springs, CO and El Paso County Guaranteed!\r\n\r\nCall (719) 331-4071 or visit us online http://propowerrooterservice.com\r\n\r\nWe Clean Out Your Drain, Not Your Wallet!','2012-02-27 03:25:57');

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

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

INSERT INTO `idx_favorites` VALUES (1,'jarodemmettr33g84','2011-10-18','My Favorites',NULL),(2,'bertramrandaw41t22','2011-10-19','My Favorites',NULL),(3,'aaroj9hqco','2011-10-20','My Favorites',NULL),(4,'brucvwoywi','2011-10-21','My Favorites',NULL),(5,'donaldthomasm94p97','2011-10-31','My Favorites',NULL),(6,'alvajoshuaw87h41','2011-11-01','My Favorites',NULL),(7,'ryanapfksc','2011-11-25','My Favorites',NULL),(8,'dougqetwza','2011-12-21','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 (6,'g',0,'2012-02-04'),(5,'g',0,'2012-02-22'),(1,'g',0,'2011-11-01'),(2,'g',0,'2012-01-06'),(3,'g',0,'2012-01-06'),(4,'g',0,'2012-02-14'),(7,'g',0,'2011-11-04'),(41,'g',0,'2011-11-14'),(20,'g',0,'2011-11-14'),(86,'g',0,'2011-11-14'),(44,'g',0,'2011-11-14'),(55,'g',0,'2011-11-14'),(193,'g',0,'2011-11-14'),(530,'g',0,'2011-12-27'),(310,'g',0,'2011-11-14'),(142,'g',0,'2011-11-14'),(362,'g',0,'2011-11-14'),(533,'g',0,'2011-12-27'),(581,'g',0,'2011-12-15'),(145,'g',0,'2011-11-14'),(443,'g',0,'2011-12-15'),(45,'g',0,'2011-11-14'),(61,'g',0,'2011-11-14'),(70,'g',0,'2011-11-14'),(94,'g',0,'2011-11-14'),(449,'g',0,'2012-01-06'),(254,'g',0,'2011-11-14'),(385,'g',0,'2011-11-14'),(171,'g',0,'2011-11-14'),(433,'g',0,'2012-01-06'),(377,'g',0,'2011-11-14'),(121,'g',0,'2011-11-15'),(256,'g',0,'2011-11-15'),(509,'g',0,'2012-01-24'),(644,'g',0,'2012-03-03'),(415,'g',0,'2012-03-03'),(27,'g',0,'2011-11-15'),(384,'g',0,'2011-11-15'),(40,'g',0,'2011-11-15'),(73,'g',0,'2011-11-15'),(63,'g',0,'2011-11-15'),(22,'g',0,'2011-11-15'),(106,'g',0,'2011-11-15'),(186,'g',0,'2011-11-15'),(190,'g',0,'2011-11-15'),(148,'g',0,'2011-11-15'),(143,'g',0,'2011-11-15'),(177,'g',0,'2011-11-15'),(265,'g',0,'2011-11-16'),(653,'g',0,'2012-02-16'),(244,'g',0,'2011-11-17'),(640,'g',0,'2011-12-22'),(252,'g',0,'2011-11-17'),(24,'g',0,'2011-11-17'),(314,'g',0,'2011-11-17'),(702,'g',0,'2011-12-22'),(412,'g',0,'2011-12-22'),(632,'g',0,'2011-12-22'),(232,'g',0,'2011-11-18'),(56,'g',0,'2011-11-18'),(347,'g',0,'2011-11-18'),(76,'g',0,'2011-11-18'),(183,'g',0,'2011-11-18'),(105,'g',0,'2011-11-18'),(118,'g',0,'2011-11-18'),(21,'g',0,'2011-11-18'),(281,'g',0,'2011-11-18'),(363,'g',0,'2011-11-18'),(42,'g',0,'2011-11-18'),(327,'g',0,'2011-11-18'),(11,'g',0,'2011-11-18'),(228,'g',0,'2011-11-18'),(49,'g',0,'2011-11-18'),(25,'g',0,'2011-11-18'),(82,'g',0,'2011-11-18'),(26,'g',0,'2011-11-18'),(146,'g',0,'2011-11-18'),(37,'g',0,'2011-11-18'),(69,'g',0,'2011-11-18'),(221,'g',0,'2011-11-18'),(392,'g',0,'2011-11-18'),(149,'g',0,'2011-11-18'),(38,'g',0,'2011-11-18'),(274,'g',0,'2011-11-18'),(62,'g',0,'2011-11-19'),(32,'g',0,'2011-11-19'),(34,'g',0,'2011-11-19'),(349,'g',0,'2011-11-19'),(273,'g',0,'2011-11-19'),(420,'g',0,'2011-11-19'),(422,'g',0,'2011-11-19'),(366,'g',0,'2011-11-19'),(133,'g',0,'2011-11-19'),(134,'g',0,'2011-11-19'),(521,'g',0,'2011-11-19'),(84,'g',0,'2011-11-19'),(99,'g',0,'2011-11-19'),(51,'g',0,'2011-11-19'),(58,'g',0,'2011-11-19'),(54,'g',0,'2011-11-19'),(126,'g',0,'2011-11-19'),(100,'g',0,'2011-11-19'),(103,'g',0,'2011-11-19'),(292,'g',0,'2011-11-19'),(159,'g',0,'2011-11-19'),(68,'g',0,'2011-11-19'),(66,'g',0,'2011-11-19'),(359,'g',0,'2011-11-19'),(378,'g',0,'2011-11-19'),(173,'g',0,'2011-11-19'),(657,'g',0,'2011-11-19'),(741,'g',0,'2011-11-19'),(117,'g',0,'2011-11-19'),(738,'g',0,'2011-11-19'),(350,'g',0,'2011-11-19'),(724,'g',0,'2011-11-19'),(336,'g',0,'2011-11-19'),(78,'g',0,'2011-11-19'),(10,'g',0,'2011-11-19'),(17,'g',0,'2011-11-19'),(278,'g',0,'2011-11-19'),(778,'g',0,'2011-12-29'),(217,'g',0,'2011-11-19'),(108,'g',0,'2011-11-19'),(562,'g',0,'2011-12-27'),(498,'g',0,'2011-11-19'),(329,'g',0,'2011-11-19'),(154,'g',0,'2011-11-19'),(19,'g',0,'2011-11-19'),(112,'g',0,'2011-11-19'),(107,'g',0,'2011-11-19'),(116,'g',0,'2011-11-19'),(110,'g',0,'2011-11-19'),(161,'g',0,'2011-11-19'),(174,'g',0,'2011-11-19'),(53,'g',0,'2011-11-19'),(192,'g',0,'2011-11-19'),(170,'g',0,'2011-11-19'),(210,'g',0,'2011-11-19'),(280,'g',0,'2011-11-19'),(114,'g',0,'2011-11-19'),(52,'g',0,'2011-11-19'),(43,'g',0,'2011-11-19'),(127,'g',0,'2011-11-19'),(390,'g',0,'2011-11-19'),(30,'g',0,'2011-11-19'),(18,'g',0,'2011-11-19'),(122,'g',0,'2011-11-19'),(196,'g',0,'2011-11-19'),(486,'g',0,'2011-12-29'),(500,'g',0,'2011-11-19'),(15,'g',0,'2011-11-19'),(379,'g',0,'2011-11-19'),(23,'g',0,'2011-11-19'),(402,'g',0,'2011-11-19'),(666,'g',0,'2011-12-29'),(411,'g',0,'2011-12-29'),(8,'g',0,'2011-11-19'),(746,'g',0,'2012-01-10'),(358,'g',0,'2011-11-19'),(353,'g',0,'2011-11-19'),(269,'g',0,'2011-11-19'),(85,'g',0,'2011-11-19'),(147,'g',0,'2011-11-20'),(398,'g',0,'2011-12-29'),(670,'g',0,'2011-12-29'),(95,'g',0,'2011-11-20'),(131,'g',0,'2011-11-20'),(64,'g',0,'2011-11-20'),(67,'g',0,'2011-11-20'),(156,'g',0,'2011-11-20'),(128,'g',0,'2011-11-20'),(141,'g',0,'2011-11-20'),(14,'g',0,'2011-11-20'),(405,'g',0,'2011-11-20'),(46,'g',0,'2011-11-20'),(120,'g',0,'2011-11-20'),(98,'g',0,'2011-11-20'),(47,'g',0,'2011-11-20'),(566,'g',0,'2011-12-29'),(178,'g',0,'2011-11-20'),(383,'g',0,'2011-11-20'),(50,'g',0,'2011-11-20'),(305,'g',0,'2011-11-20'),(13,'g',0,'2011-11-20'),(72,'g',0,'2011-11-20'),(137,'g',0,'2011-11-20'),(407,'g',0,'2011-12-29'),(431,'g',0,'2011-12-27'),(323,'g',0,'2011-11-20'),(282,'g',0,'2011-11-20'),(12,'g',0,'2011-11-20'),(771,'g',0,'2012-01-30'),(726,'g',0,'2011-12-26'),(354,'g',0,'2011-11-22'),(338,'g',0,'2011-11-22'),(742,'g',0,'2011-12-26'),(124,'g',0,'2011-11-24'),(33,'g',0,'2011-11-24'),(125,'g',0,'2011-11-24'),(92,'g',0,'2011-11-24'),(88,'g',0,'2011-11-24'),(9,'g',0,'2011-11-24'),(16,'g',0,'2011-11-24'),(39,'g',0,'2011-11-24'),(115,'g',0,'2011-11-24'),(158,'g',0,'2011-11-24'),(264,'g',0,'2011-11-24'),(459,'g',0,'2011-11-24'),(339,'g',0,'2011-11-24'),(71,'g',0,'2011-11-24'),(436,'g',0,'2011-11-24'),(445,'g',0,'2011-11-24'),(260,'g',0,'2011-11-24'),(648,'g',0,'2011-11-24'),(48,'g',0,'2011-11-24'),(57,'g',0,'2011-11-24'),(65,'g',0,'2011-11-24'),(453,'g',0,'2011-11-24'),(255,'g',0,'2011-11-26'),(526,'g',0,'2011-11-26'),(263,'g',0,'2011-11-26'),(36,'g',0,'2011-11-26'),(195,'g',0,'2011-11-26'),(28,'g',0,'2011-11-26'),(29,'g',0,'2011-11-26'),(138,'g',0,'2011-11-26'),(468,'g',0,'2011-11-26'),(239,'g',0,'2011-11-26'),(60,'g',0,'2011-11-26'),(31,'g',0,'2011-11-26'),(267,'g',0,'2011-11-26'),(80,'g',0,'2011-11-26'),(35,'g',0,'2011-11-26'),(150,'g',0,'2011-11-26'),(74,'g',0,'2011-11-26'),(59,'g',0,'2011-11-26'),(753,'g',0,'2011-11-26'),(365,'g',0,'2011-11-26'),(1063,'g',0,'2011-11-28'),(81,'g',0,'2011-11-29'),(218,'g',0,'2011-11-29'),(233,'g',0,'2011-11-29'),(152,'g',0,'2011-11-29'),(469,'g',0,'2011-11-29'),(214,'g',0,'2011-11-29'),(540,'g',0,'2011-11-29'),(467,'g',0,'2011-11-29'),(277,'g',0,'2011-11-29'),(79,'g',0,'2011-11-29'),(964,'g',0,'2011-11-29'),(960,'g',0,'2011-11-29'),(910,'g',0,'2012-02-14'),(1159,'g',0,'2012-03-03'),(1300,'g',0,'2012-02-27'),(1145,'g',0,'2012-03-03'),(920,'g',0,'2012-01-09'),(1230,'g',0,'2012-01-09'),(1313,'g',0,'2011-12-09'),(1314,'g',0,'2011-12-09'),(1171,'g',0,'2011-12-09'),(1198,'g',0,'2011-12-09'),(83,'g',0,'2011-12-09'),(1037,'g',0,'2011-12-10'),(698,'g',0,'2011-12-10'),(872,'g',0,'2011-12-10'),(923,'g',0,'2011-12-10'),(982,'g',0,'2011-12-10'),(750,'g',0,'2011-12-10'),(989,'g',0,'2011-12-10'),(1027,'g',0,'2011-12-10'),(1014,'g',0,'2011-12-10'),(1065,'g',0,'2011-12-10'),(1046,'g',0,'2011-12-10'),(410,'g',0,'2011-12-10'),(352,'g',0,'2011-12-10'),(235,'g',0,'2011-12-10'),(351,'g',0,'2011-12-10'),(296,'g',0,'2011-12-10'),(285,'g',0,'2011-12-10'),(236,'g',0,'2011-12-10'),(249,'g',0,'2011-12-10'),(211,'g',0,'2011-12-10'),(204,'g',0,'2011-12-10'),(965,'g',0,'2012-02-16'),(937,'g',0,'2012-02-16'),(936,'g',0,'2012-02-16'),(772,'g',0,'2012-02-16'),(1379,'g',0,'2011-12-10'),(1025,'g',0,'2012-01-10'),(1038,'g',0,'2011-12-10'),(1082,'g',0,'2011-12-10'),(482,'g',0,'2011-12-10'),(773,'g',0,'2011-12-10'),(896,'g',0,'2011-12-10'),(765,'g',0,'2011-12-10'),(850,'g',0,'2011-12-10'),(642,'g',0,'2011-12-10'),(559,'g',0,'2011-12-10'),(958,'g',0,'2011-12-10'),(458,'g',0,'2011-12-10'),(1000,'g',0,'2011-12-10'),(565,'g',0,'2011-12-11'),(428,'g',0,'2011-12-11'),(592,'g',0,'2011-12-11'),(536,'g',0,'2011-12-11'),(451,'g',0,'2011-12-11'),(494,'g',0,'2011-12-11'),(574,'g',0,'2011-12-11'),(531,'g',0,'2011-12-11'),(461,'g',0,'2011-12-11'),(578,'g',0,'2011-12-11'),(819,'g',0,'2011-12-11'),(624,'g',0,'2011-12-11'),(739,'g',0,'2011-12-11'),(684,'g',0,'2011-12-11'),(637,'g',0,'2011-12-11'),(740,'g',0,'2011-12-11'),(673,'g',0,'2011-12-11'),(623,'g',0,'2011-12-11'),(847,'g',0,'2011-12-11'),(599,'g',0,'2011-12-11'),(1235,'g',0,'2011-12-12'),(1214,'g',0,'2011-12-12'),(1429,'g',0,'2011-12-12'),(503,'g',0,'2011-12-12'),(404,'g',0,'2011-12-12'),(480,'g',0,'2011-12-12'),(427,'g',0,'2011-12-12'),(512,'g',0,'2011-12-12'),(421,'g',0,'2011-12-12'),(546,'g',0,'2011-12-12'),(476,'g',0,'2011-12-12'),(397,'g',0,'2011-12-12'),(513,'g',0,'2011-12-12'),(767,'g',0,'2011-12-12'),(711,'g',0,'2011-12-12'),(787,'g',0,'2011-12-12'),(584,'g',0,'2011-12-12'),(717,'g',0,'2011-12-12'),(857,'g',0,'2011-12-12'),(605,'g',0,'2011-12-12'),(580,'g',0,'2011-12-12'),(1467,'g',0,'2011-12-12'),(416,'g',0,'2012-02-22'),(462,'g',0,'2011-12-13'),(447,'g',0,'2012-02-22'),(419,'g',0,'2012-02-22'),(417,'g',0,'2011-12-13'),(448,'g',0,'2011-12-13'),(424,'g',0,'2011-12-13'),(423,'g',0,'2011-12-13'),(534,'g',0,'2012-02-01'),(735,'g',0,'2012-02-01'),(537,'g',0,'2012-02-01'),(715,'g',0,'2012-02-01'),(409,'g',0,'2012-02-01'),(450,'g',0,'2012-02-01'),(413,'g',0,'2012-02-01'),(457,'g',0,'2012-02-01'),(751,'g',0,'2011-12-14'),(1499,'g',0,'2012-02-01'),(1456,'g',0,'2011-12-14'),(1487,'g',0,'2012-02-14'),(1491,'g',0,'2012-02-22'),(1500,'g',0,'2011-12-14'),(1514,'g',0,'2012-02-22'),(1474,'g',0,'2011-12-14'),(1484,'g',0,'2012-02-22'),(1486,'g',0,'2011-12-14'),(1103,'g',0,'2011-12-15'),(882,'g',0,'2011-12-15'),(955,'g',0,'2011-12-15'),(1501,'g',0,'2011-12-15'),(1512,'g',0,'2011-12-15'),(414,'g',0,'2011-12-15'),(399,'g',0,'2011-12-15'),(1496,'g',0,'2011-12-15'),(1497,'g',0,'2011-12-15'),(1483,'g',0,'2011-12-15'),(1508,'g',0,'2011-12-15'),(1039,'g',0,'2011-12-16'),(1518,'g',0,'2011-12-17'),(1495,'g',0,'2011-12-17'),(1521,'g',0,'2011-12-17'),(1519,'g',0,'2011-12-17'),(1520,'g',0,'2011-12-17'),(1522,'g',0,'2011-12-17'),(1523,'g',0,'2011-12-17'),(1533,'g',0,'2011-12-17'),(981,'g',0,'2011-12-18'),(852,'g',0,'2011-12-18'),(851,'g',0,'2011-12-18'),(1045,'g',0,'2011-12-18'),(1041,'g',0,'2011-12-18'),(535,'g',0,'2011-12-18'),(466,'g',0,'2011-12-18'),(396,'g',0,'2011-12-18'),(508,'g',0,'2011-12-18'),(519,'g',0,'2011-12-18'),(483,'g',0,'2011-12-18'),(505,'g',0,'2011-12-18'),(403,'g',0,'2011-12-18'),(529,'g',0,'2011-12-18'),(1517,'g',0,'2011-12-18'),(766,'g',0,'2011-12-18'),(836,'g',0,'2011-12-18'),(747,'g',0,'2011-12-18'),(835,'g',0,'2011-12-18'),(838,'g',0,'2011-12-18'),(837,'g',0,'2011-12-18'),(1498,'g',0,'2012-02-03'),(1503,'g',0,'2012-01-21'),(1476,'g',0,'2012-02-08'),(1477,'g',0,'2012-02-08'),(504,'g',0,'2012-02-08'),(502,'g',0,'2012-02-07'),(1525,'g',0,'2012-01-21'),(1479,'g',0,'2012-01-21'),(1516,'g',0,'2012-01-21'),(542,'g',0,'2012-02-15'),(1505,'g',0,'2012-02-03'),(525,'g',0,'2012-02-15'),(1531,'g',0,'2012-02-03'),(515,'g',0,'2012-02-15'),(496,'g',0,'2012-02-15'),(516,'g',0,'2012-02-15'),(400,'g',0,'2012-02-15'),(495,'g',0,'2012-02-15'),(1541,'g',0,'2011-12-18'),(1480,'g',0,'2011-12-18'),(972,'g',0,'2011-12-18'),(856,'g',0,'2011-12-18'),(754,'g',0,'2011-12-18'),(737,'g',0,'2011-12-18'),(522,'g',0,'2011-12-18'),(1536,'g',0,'2011-12-18'),(661,'g',0,'2011-12-18'),(401,'g',0,'2011-12-19'),(441,'g',0,'2011-12-19'),(418,'g',0,'2011-12-19'),(406,'g',0,'2011-12-19'),(434,'g',0,'2011-12-19'),(438,'g',0,'2011-12-19'),(435,'g',0,'2011-12-19'),(440,'g',0,'2011-12-19'),(1504,'g',0,'2012-02-04'),(1538,'g',0,'2011-12-19'),(1566,'g',0,'2011-12-19'),(1560,'g',0,'2011-12-21'),(1532,'g',0,'2012-02-04'),(1490,'g',0,'2011-12-21'),(1527,'g',0,'2011-12-21'),(1493,'g',0,'2011-12-21'),(1509,'g',0,'2011-12-21'),(1561,'g',0,'2011-12-21'),(1528,'g',0,'2011-12-21'),(1542,'g',0,'2011-12-21'),(1510,'g',0,'2011-12-21'),(1506,'g',0,'2011-12-21'),(491,'g',0,'2012-02-22'),(487,'g',0,'2012-02-22'),(488,'g',0,'2011-12-22'),(472,'g',0,'2012-02-22'),(680,'g',0,'2011-12-22'),(439,'g',0,'2012-02-22'),(514,'g',0,'2011-12-22'),(547,'g',0,'2011-12-22'),(697,'g',0,'2011-12-22'),(446,'g',0,'2012-02-22'),(1535,'g',0,'2011-12-22'),(1537,'g',0,'2011-12-22'),(1494,'g',0,'2011-12-23'),(408,'g',0,'2011-12-23'),(1481,'g',0,'2011-12-23'),(429,'g',0,'2011-12-24'),(655,'g',0,'2011-12-24'),(538,'g',0,'2011-12-24'),(643,'g',0,'2011-12-24'),(651,'g',0,'2011-12-24'),(627,'g',0,'2011-12-24'),(583,'g',0,'2011-12-24'),(999,'g',0,'2011-12-24'),(1540,'g',0,'2011-12-24'),(1534,'g',0,'2011-12-24'),(1482,'g',0,'2011-12-24'),(432,'g',0,'2011-12-24'),(900,'g',0,'2011-12-24'),(873,'g',0,'2011-12-24'),(1488,'g',0,'2011-12-24'),(1281,'g',0,'2011-12-24'),(1543,'g',0,'2011-12-24'),(1526,'g',0,'2011-12-24'),(1530,'g',0,'2011-12-24'),(606,'g',0,'2011-12-24'),(1513,'g',0,'2011-12-24'),(963,'g',0,'2011-12-24'),(665,'g',0,'2011-12-24'),(621,'g',0,'2011-12-24'),(602,'g',0,'2011-12-24'),(1507,'g',0,'2011-12-24'),(1492,'g',0,'2011-12-25'),(1478,'g',0,'2012-02-14'),(1475,'g',0,'2012-02-14'),(571,'g',0,'2012-02-14'),(506,'g',0,'2012-02-14'),(616,'g',0,'2012-02-14'),(493,'g',0,'2011-12-25'),(464,'g',0,'2012-02-14'),(609,'g',0,'2012-02-14'),(620,'g',0,'2011-12-25'),(1558,'g',0,'2011-12-25'),(1502,'g',0,'2011-12-25'),(1529,'g',0,'2011-12-25'),(652,'g',0,'2011-12-26'),(1539,'g',0,'2011-12-26'),(1583,'g',0,'2012-02-22'),(1608,'g',0,'2012-02-22'),(1562,'g',0,'2012-02-22'),(1607,'g',0,'2012-02-22'),(1584,'g',0,'2012-02-22'),(1524,'g',0,'2012-02-22'),(1612,'g',0,'2012-02-22'),(1603,'g',0,'2012-02-22'),(727,'g',0,'2011-12-26'),(1597,'g',0,'2011-12-27'),(1602,'g',0,'2011-12-27'),(1585,'g',0,'2011-12-27'),(820,'g',0,'2011-12-27'),(855,'g',0,'2011-12-27'),(853,'g',0,'2011-12-27'),(823,'g',0,'2011-12-27'),(860,'g',0,'2011-12-27'),(1515,'g',0,'2011-12-27'),(784,'g',0,'2011-12-27'),(1606,'g',0,'2012-02-17'),(1582,'g',0,'2011-12-27'),(1489,'g',0,'2011-12-27'),(1609,'g',0,'2011-12-28'),(1600,'g',0,'2011-12-28'),(1619,'g',0,'2012-03-07'),(1557,'g',0,'2011-12-30'),(1581,'g',0,'2012-02-23'),(1599,'g',0,'2012-02-23'),(1616,'g',0,'2012-02-23'),(1579,'g',0,'2012-02-23'),(1626,'g',0,'2012-02-23'),(1598,'g',0,'2012-02-23'),(1578,'g',0,'2011-12-31'),(1621,'g',0,'2012-01-01'),(1624,'g',0,'2012-02-21'),(1622,'g',0,'2012-02-21'),(1556,'g',0,'2012-01-01'),(1559,'g',0,'2012-01-01'),(1631,'g',0,'2012-01-01'),(1623,'g',0,'2012-02-17'),(1555,'g',0,'2012-01-02'),(1610,'g',0,'2012-01-03'),(1615,'g',0,'2012-01-03'),(1620,'g',0,'2012-01-03'),(1627,'g',0,'2012-01-04'),(1654,'g',0,'2012-02-16'),(1614,'g',0,'2012-01-06'),(1629,'g',0,'2012-02-22'),(1628,'g',0,'2012-02-22'),(1601,'g',0,'2012-01-06'),(1611,'g',0,'2012-01-06'),(1618,'g',0,'2012-01-06'),(1604,'g',0,'2012-01-06'),(1613,'g',0,'2012-01-06'),(1617,'g',0,'2012-01-06'),(1605,'g',0,'2012-01-07'),(1666,'g',0,'2012-01-07'),(1637,'g',0,'2012-03-07'),(1625,'g',0,'2012-03-07'),(1653,'g',0,'2012-03-07'),(1638,'g',0,'2012-01-07'),(1630,'g',0,'2012-01-07'),(1651,'g',0,'2012-02-21'),(1655,'g',0,'2012-01-09'),(1642,'g',0,'2012-01-09'),(1657,'g',0,'2012-01-09'),(1634,'g',0,'2012-01-09'),(1635,'g',0,'2012-01-09'),(1648,'g',0,'2012-01-09'),(1644,'g',0,'2012-01-10'),(1656,'g',0,'2012-01-10'),(1683,'g',0,'2012-01-10'),(1649,'g',0,'2012-01-10'),(1645,'g',0,'2012-01-10'),(1641,'g',0,'2012-01-10'),(1511,'g',0,'2012-01-10'),(817,'g',0,'2012-01-10'),(1664,'g',0,'2012-01-11'),(1662,'g',0,'2012-02-27'),(1665,'g',0,'2012-01-11'),(1553,'g',0,'2012-02-27'),(875,'g',0,'2012-01-12'),(1700,'g',0,'2012-01-15'),(1636,'g',0,'2012-01-15'),(1632,'g',0,'2012-02-23'),(1639,'g',0,'2012-02-23'),(1715,'g',0,'2012-02-23'),(1647,'g',0,'2012-01-16'),(1707,'g',0,'2012-02-21'),(1723,'g',0,'2012-01-16'),(1682,'g',0,'2012-02-21'),(1725,'g',0,'2012-02-21'),(1722,'g',0,'2012-02-21'),(1672,'g',0,'2012-02-21'),(1772,'g',0,'2012-02-16'),(1674,'g',0,'2012-02-22'),(1803,'g',0,'2012-02-22'),(1799,'g',0,'2012-01-20'),(1650,'g',0,'2012-01-21'),(1810,'g',0,'2012-01-21'),(1704,'g',0,'2012-01-21'),(499,'g',0,'2012-01-21'),(460,'g',0,'2012-01-21'),(779,'g',0,'2012-01-21'),(674,'g',0,'2012-01-21'),(764,'g',0,'2012-01-21'),(736,'g',0,'2012-01-21'),(749,'g',0,'2012-01-21'),(507,'g',0,'2012-01-21'),(545,'g',0,'2012-01-21'),(1702,'g',0,'2012-01-21'),(1681,'g',0,'2012-01-21'),(1774,'g',0,'2012-01-21'),(1796,'g',0,'2012-01-21'),(1770,'g',0,'2012-01-21'),(1726,'g',0,'2012-01-21'),(1727,'g',0,'2012-01-21'),(1690,'g',0,'2012-01-21'),(1793,'g',0,'2012-01-21'),(1719,'g',0,'2012-01-22'),(1679,'g',0,'2012-02-22'),(1769,'g',0,'2012-01-22'),(1699,'g',0,'2012-01-22'),(1731,'g',0,'2012-01-22'),(1730,'g',0,'2012-01-22'),(1680,'g',0,'2012-01-22'),(1732,'g',0,'2012-01-22'),(1768,'g',0,'2012-01-22'),(1724,'g',0,'2012-01-22'),(1767,'g',0,'2012-01-22'),(1671,'g',0,'2012-01-22'),(662,'g',0,'2012-01-22'),(866,'g',0,'2012-01-22'),(861,'g',0,'2012-01-22'),(863,'g',0,'2012-01-22'),(862,'g',0,'2012-01-22'),(865,'g',0,'2012-01-22'),(864,'g',0,'2012-01-22'),(1271,'g',0,'2012-01-22'),(1815,'g',0,'2012-01-22'),(1689,'g',0,'2012-01-23'),(1377,'g',0,'2012-01-23'),(1318,'g',0,'2012-01-23'),(1347,'g',0,'2012-01-23'),(1345,'g',0,'2012-01-23'),(1670,'g',0,'2012-01-23'),(1812,'g',0,'2012-01-23'),(1797,'g',0,'2012-01-24'),(1765,'g',0,'2012-01-24'),(1786,'g',0,'2012-01-24'),(1809,'g',0,'2012-03-07'),(1808,'g',0,'2012-01-24'),(1714,'g',0,'2012-01-24'),(1763,'g',0,'2012-01-24'),(1785,'g',0,'2012-01-24'),(1694,'g',0,'2012-01-24'),(1669,'g',0,'2012-01-25'),(1705,'g',0,'2012-01-25'),(1735,'g',0,'2012-01-25'),(1706,'g',0,'2012-01-25'),(1736,'g',0,'2012-01-25'),(1684,'g',0,'2012-01-25'),(1811,'g',0,'2012-03-02'),(1813,'g',0,'2012-03-02'),(948,'g',0,'2012-01-26'),(935,'g',0,'2012-01-26'),(886,'g',0,'2012-01-26'),(858,'g',0,'2012-01-26'),(827,'g',0,'2012-01-26'),(883,'g',0,'2012-01-26'),(859,'g',0,'2012-01-26'),(876,'g',0,'2012-01-26'),(878,'g',0,'2012-01-26'),(941,'g',0,'2012-01-26'),(794,'g',0,'2012-01-26'),(770,'g',0,'2012-01-26'),(993,'g',0,'2012-01-26'),(791,'g',0,'2012-01-26'),(745,'g',0,'2012-01-26'),(793,'g',0,'2012-01-26'),(968,'g',0,'2012-01-26'),(996,'g',0,'2012-01-26'),(792,'g',0,'2012-01-26'),(774,'g',0,'2012-01-26'),(973,'g',0,'2012-01-26'),(777,'g',0,'2012-01-26'),(959,'g',0,'2012-01-26'),(961,'g',0,'2012-01-26'),(790,'g',0,'2012-01-26'),(769,'g',0,'2012-01-26'),(962,'g',0,'2012-01-26'),(1040,'g',0,'2012-01-26'),(1035,'g',0,'2012-01-26'),(1823,'g',0,'2012-01-26'),(1792,'g',0,'2012-01-27'),(924,'g',0,'2012-01-27'),(987,'g',0,'2012-01-27'),(933,'g',0,'2012-01-27'),(1009,'g',0,'2012-01-27'),(1010,'g',0,'2012-01-27'),(1011,'g',0,'2012-01-27'),(1052,'g',0,'2012-01-27'),(1061,'g',0,'2012-01-27'),(1071,'g',0,'2012-01-27'),(1150,'g',0,'2012-01-27'),(1471,'g',0,'2012-01-27'),(1278,'g',0,'2012-01-27'),(1279,'g',0,'2012-01-27'),(1280,'g',0,'2012-01-27'),(1223,'g',0,'2012-01-27'),(1296,'g',0,'2012-01-27'),(1277,'g',0,'2012-01-27'),(1232,'g',0,'2012-01-27'),(1269,'g',0,'2012-01-27'),(871,'g',0,'2012-01-27'),(1064,'g',0,'2012-01-27'),(891,'g',0,'2012-01-27'),(1874,'g',0,'2012-02-04'),(949,'g',0,'2012-02-06'),(947,'g',0,'2012-02-06'),(939,'g',0,'2012-02-06'),(967,'g',0,'2012-02-06'),(940,'g',0,'2012-02-06'),(966,'g',0,'2012-02-06'),(992,'g',0,'2012-02-06'),(1303,'g',0,'2012-02-06'),(1001,'g',0,'2012-02-06'),(1819,'g',0,'2012-02-06'),(1911,'g',0,'2012-02-06'),(1880,'g',0,'2012-02-07'),(1847,'g',0,'2012-02-07'),(1849,'g',0,'2012-02-07'),(1072,'g',0,'2012-02-07'),(1073,'g',0,'2012-02-07'),(1787,'g',0,'2012-02-07'),(1760,'g',0,'2012-02-07'),(1778,'g',0,'2012-02-07'),(1891,'g',0,'2012-02-07'),(1144,'g',0,'2012-02-07'),(1572,'g',0,'2012-02-07'),(510,'g',0,'2012-02-07'),(693,'g',0,'2012-02-07'),(598,'g',0,'2012-02-07'),(668,'g',0,'2012-02-08'),(1878,'g',0,'2012-02-08'),(1201,'g',0,'2012-02-08'),(1877,'g',0,'2012-02-08'),(1919,'g',0,'2012-02-08'),(1199,'g',0,'2012-02-08'),(1200,'g',0,'2012-02-08'),(1297,'g',0,'2012-02-08'),(1307,'g',0,'2012-02-08'),(1359,'g',0,'2012-02-08'),(1270,'g',0,'2012-02-08'),(1036,'g',0,'2012-02-08'),(1933,'g',0,'2012-02-08'),(946,'g',0,'2012-02-09'),(938,'g',0,'2012-02-09'),(780,'g',0,'2012-02-09'),(930,'g',0,'2012-02-09'),(879,'g',0,'2012-02-09'),(1844,'g',0,'2012-02-09'),(1430,'g',0,'2012-02-09'),(1852,'g',0,'2012-02-09'),(1225,'g',0,'2012-02-09'),(497,'g',0,'2012-02-11'),(604,'g',0,'2012-02-11'),(608,'g',0,'2012-02-11'),(541,'g',0,'2012-02-11'),(532,'g',0,'2012-02-11'),(575,'g',0,'2012-02-11'),(553,'g',0,'2012-02-11'),(586,'g',0,'2012-02-11'),(2015,'g',0,'2012-02-11'),(2006,'g',0,'2012-02-11'),(2026,'g',0,'2012-02-11'),(1080,'g',0,'2012-02-12'),(1034,'g',0,'2012-02-12'),(1020,'g',0,'2012-02-12'),(1022,'g',0,'2012-02-12'),(1051,'g',0,'2012-02-12'),(1473,'g',0,'2012-02-12'),(1056,'g',0,'2012-02-12'),(1079,'g',0,'2012-02-12'),(1021,'g',0,'2012-02-12'),(1017,'g',0,'2012-02-12'),(2014,'g',0,'2012-02-12'),(1952,'g',0,'2012-02-13'),(1202,'g',0,'2012-02-13'),(1836,'g',0,'2012-02-13'),(1316,'g',0,'2012-02-13'),(1851,'g',0,'2012-02-13'),(1427,'g',0,'2012-02-13'),(1964,'g',0,'2012-02-13'),(1094,'g',0,'2012-02-13'),(1563,'g',0,'2012-02-13'),(1577,'g',0,'2012-02-13'),(1140,'g',0,'2012-02-13'),(1206,'g',0,'2012-02-13'),(1207,'g',0,'2012-02-13'),(1469,'g',0,'2012-02-13'),(1097,'g',0,'2012-02-13'),(1945,'g',0,'2012-02-13'),(1389,'g',0,'2012-02-13'),(2007,'g',0,'2012-02-13'),(1912,'g',0,'2012-02-13'),(1310,'g',0,'2012-02-13'),(1865,'g',0,'2012-02-13'),(1888,'g',0,'2012-02-13'),(1564,'g',0,'2012-02-13'),(1567,'g',0,'2012-02-13'),(1257,'g',0,'2012-02-13'),(1304,'g',0,'2012-02-13'),(1916,'g',0,'2012-02-14'),(2017,'g',0,'2012-02-14'),(1890,'g',0,'2012-02-14'),(1203,'g',0,'2012-02-14'),(1391,'g',0,'2012-02-14'),(669,'g',0,'2012-02-14'),(1089,'g',0,'2012-02-15'),(1095,'g',0,'2012-02-15'),(1090,'g',0,'2012-02-15'),(1098,'g',0,'2012-02-15'),(1088,'g',0,'2012-02-15'),(1087,'g',0,'2012-02-15'),(1091,'g',0,'2012-02-15'),(1092,'g',0,'2012-02-15'),(1102,'g',0,'2012-02-15'),(1104,'g',0,'2012-02-15'),(953,'g',0,'2012-02-15'),(974,'g',0,'2012-02-15'),(977,'g',0,'2012-02-15'),(945,'g',0,'2012-02-15'),(978,'g',0,'2012-02-15'),(951,'g',0,'2012-02-15'),(782,'g',0,'2012-02-15'),(954,'g',0,'2012-02-15'),(638,'g',0,'2012-02-15'),(723,'g',0,'2012-02-15'),(783,'g',0,'2012-02-15'),(762,'g',0,'2012-02-15'),(756,'g',0,'2012-02-15'),(729,'g',0,'2012-02-15'),(776,'g',0,'2012-02-15'),(899,'g',0,'2012-02-15'),(893,'g',0,'2012-02-15'),(761,'g',0,'2012-02-15'),(898,'g',0,'2012-02-15'),(659,'g',0,'2012-02-15'),(636,'g',0,'2012-02-15'),(897,'g',0,'2012-02-15'),(743,'g',0,'2012-02-15'),(1084,'g',0,'2012-02-15'),(2032,'g',0,'2012-02-15'),(1086,'g',0,'2012-02-15'),(1085,'g',0,'2012-02-15'),(1083,'g',0,'2012-02-15'),(568,'g',0,'2012-02-15'),(558,'g',0,'2012-02-15'),(549,'g',0,'2012-02-15'),(2012,'g',0,'2012-02-16'),(1302,'g',0,'2012-02-16'),(1210,'g',0,'2012-02-16'),(1222,'g',0,'2012-02-16'),(1226,'g',0,'2012-02-16'),(1209,'g',0,'2012-02-16'),(1153,'g',0,'2012-02-16'),(1152,'g',0,'2012-02-16'),(2023,'g',0,'2012-02-16'),(785,'g',0,'2012-02-16'),(822,'g',0,'2012-02-17'),(815,'g',0,'2012-02-17'),(801,'g',0,'2012-02-17'),(813,'g',0,'2012-02-17'),(812,'g',0,'2012-02-17'),(814,'g',0,'2012-02-17'),(805,'g',0,'2012-02-17'),(816,'g',0,'2012-02-17'),(804,'g',0,'2012-02-17'),(733,'g',0,'2012-02-17'),(824,'g',0,'2012-02-17'),(802,'g',0,'2012-02-17'),(825,'g',0,'2012-02-17'),(708,'g',0,'2012-02-17'),(826,'g',0,'2012-02-17'),(803,'g',0,'2012-02-17'),(800,'g',0,'2012-02-17'),(691,'g',0,'2012-02-17'),(710,'g',0,'2012-02-17'),(1824,'g',0,'2012-02-20'),(1363,'g',0,'2012-02-21'),(2056,'g',0,'2012-02-21'),(1575,'g',0,'2012-02-21'),(1915,'g',0,'2012-02-21'),(1892,'g',0,'2012-02-21'),(1132,'g',0,'2012-02-22'),(1149,'g',0,'2012-02-22'),(1137,'g',0,'2012-02-22'),(1131,'g',0,'2012-02-22'),(1141,'g',0,'2012-02-22'),(1133,'g',0,'2012-02-22'),(1134,'g',0,'2012-02-22'),(1136,'g',0,'2012-02-22'),(1135,'g',0,'2012-02-22'),(1573,'g',0,'2012-02-22'),(1570,'g',0,'2012-02-22'),(1565,'g',0,'2012-02-22'),(1162,'g',0,'2012-02-22'),(1195,'g',0,'2012-02-22'),(1196,'g',0,'2012-02-22'),(1165,'g',0,'2012-02-22'),(1160,'g',0,'2012-02-22'),(1161,'g',0,'2012-02-22'),(1197,'g',0,'2012-02-22'),(1326,'g',0,'2012-02-22'),(1332,'g',0,'2012-02-22'),(1328,'g',0,'2012-02-22'),(1330,'g',0,'2012-02-22'),(1331,'g',0,'2012-02-22'),(1327,'g',0,'2012-02-22'),(1325,'g',0,'2012-02-22'),(1329,'g',0,'2012-02-22'),(1333,'g',0,'2012-02-22'),(1334,'g',0,'2012-02-22'),(1383,'g',0,'2012-02-22'),(1343,'g',0,'2012-02-22'),(1340,'g',0,'2012-02-22'),(1311,'g',0,'2012-02-22'),(1309,'g',0,'2012-02-22'),(1290,'g',0,'2012-02-22'),(1376,'g',0,'2012-02-22'),(1323,'g',0,'2012-02-22'),(1312,'g',0,'2012-02-22'),(1291,'g',0,'2012-02-22'),(1322,'g',0,'2012-02-22'),(1317,'g',0,'2012-02-22'),(1660,'g',0,'2012-02-22'),(1692,'g',0,'2012-02-22'),(1652,'g',0,'2012-02-22'),(1661,'g',0,'2012-02-22'),(1697,'g',0,'2012-02-22'),(1709,'g',0,'2012-02-22'),(1711,'g',0,'2012-02-22'),(1718,'g',0,'2012-02-22'),(1764,'g',0,'2012-02-22'),(1795,'g',0,'2012-02-22'),(1802,'g',0,'2012-02-22'),(1775,'g',0,'2012-02-22'),(1910,'g',0,'2012-02-22'),(1783,'g',0,'2012-02-22'),(1801,'g',0,'2012-02-22'),(1646,'g',0,'2012-02-22'),(1721,'g',0,'2012-02-22'),(1733,'g',0,'2012-02-22'),(1784,'g',0,'2012-02-22'),(465,'g',0,'2012-02-22'),(635,'g',0,'2012-02-22'),(511,'g',0,'2012-02-22'),(914,'g',0,'2012-02-22'),(612,'g',0,'2012-02-22'),(1324,'g',0,'2012-02-22'),(1301,'g',0,'2012-02-22'),(1321,'g',0,'2012-02-22'),(1380,'g',0,'2012-02-22'),(1335,'g',0,'2012-02-22'),(1341,'g',0,'2012-02-22'),(1342,'g',0,'2012-02-22'),(1338,'g',0,'2012-02-22'),(1396,'g',0,'2012-02-22'),(1339,'g',0,'2012-02-22'),(1344,'g',0,'2012-02-22'),(1346,'g',0,'2012-02-22'),(1113,'g',0,'2012-02-22'),(1920,'g',0,'2012-02-22'),(1118,'g',0,'2012-02-22'),(1362,'g',0,'2012-02-22'),(1421,'g',0,'2012-02-22'),(1351,'g',0,'2012-02-22'),(1882,'g',0,'2012-02-22'),(1355,'g',0,'2012-02-22'),(1256,'g',0,'2012-02-22'),(1216,'g',0,'2012-02-22'),(1227,'g',0,'2012-02-22'),(798,'g',0,'2012-02-22'),(1221,'g',0,'2012-02-22'),(1233,'g',0,'2012-02-22'),(1228,'g',0,'2012-02-22'),(1211,'g',0,'2012-02-22'),(795,'g',0,'2012-02-22'),(1255,'g',0,'2012-02-22'),(1218,'g',0,'2012-02-22'),(1262,'g',0,'2012-02-22'),(1260,'g',0,'2012-02-22'),(796,'g',0,'2012-02-22'),(1258,'g',0,'2012-02-22'),(1259,'g',0,'2012-02-22'),(1264,'g',0,'2012-02-22'),(797,'g',0,'2012-02-22'),(1263,'g',0,'2012-02-22'),(1108,'g',0,'2012-02-22'),(1048,'g',0,'2012-02-22'),(1093,'g',0,'2012-02-22'),(1100,'g',0,'2012-02-22'),(1076,'g',0,'2012-02-22'),(1096,'g',0,'2012-02-22'),(1110,'g',0,'2012-02-22'),(1059,'g',0,'2012-02-22'),(1336,'g',0,'2012-02-23'),(1018,'g',0,'2012-02-23'),(1074,'g',0,'2012-02-23'),(1068,'g',0,'2012-02-23'),(1250,'g',0,'2012-02-23'),(1249,'g',0,'2012-02-23'),(1246,'g',0,'2012-02-23'),(1244,'g',0,'2012-02-23'),(1248,'g',0,'2012-02-23'),(1404,'g',0,'2012-02-23'),(1245,'g',0,'2012-02-23'),(1252,'g',0,'2012-02-23'),(1251,'g',0,'2012-02-23'),(1115,'g',0,'2012-02-23'),(1843,'g',0,'2012-02-23'),(2040,'g',0,'2012-02-23'),(1243,'g',0,'2012-02-23'),(1242,'g',0,'2012-02-23'),(1128,'g',0,'2012-02-23'),(1107,'g',0,'2012-02-23'),(1283,'g',0,'2012-02-23'),(1109,'g',0,'2012-02-23'),(1276,'g',0,'2012-02-23'),(1238,'g',0,'2012-02-23'),(1106,'g',0,'2012-02-23'),(1239,'g',0,'2012-02-23'),(1384,'g',0,'2012-02-23'),(1143,'g',0,'2012-02-23'),(1375,'g',0,'2012-02-23'),(1105,'g',0,'2012-02-23'),(1349,'g',0,'2012-02-23'),(1273,'g',0,'2012-02-23'),(1265,'g',0,'2012-02-23'),(1392,'g',0,'2012-02-23'),(1254,'g',0,'2012-02-23'),(1393,'g',0,'2012-02-23'),(1274,'g',0,'2012-02-23'),(1938,'g',0,'2012-02-23'),(1350,'g',0,'2012-02-23'),(1356,'g',0,'2012-02-23'),(2001,'g',0,'2012-02-23'),(1348,'g',0,'2012-02-23'),(1125,'g',0,'2012-02-23'),(1358,'g',0,'2012-02-23'),(1114,'g',0,'2012-02-23'),(1900,'g',0,'2012-02-23'),(1354,'g',0,'2012-02-23'),(1130,'g',0,'2012-02-23'),(1352,'g',0,'2012-02-23'),(1388,'g',0,'2012-02-23'),(1217,'g',0,'2012-02-23'),(1127,'g',0,'2012-02-23'),(1287,'g',0,'2012-02-23'),(1382,'g',0,'2012-02-23'),(1289,'g',0,'2012-02-23'),(1123,'g',0,'2012-02-23'),(1360,'g',0,'2012-02-23'),(1390,'g',0,'2012-02-23'),(1986,'g',0,'2012-02-23'),(1385,'g',0,'2012-02-23'),(1970,'g',0,'2012-02-23'),(1373,'g',0,'2012-02-23'),(1820,'g',0,'2012-02-23'),(1976,'g',0,'2012-02-23'),(1975,'g',0,'2012-02-23'),(1353,'g',0,'2012-02-23'),(1126,'g',0,'2012-02-23'),(1966,'g',0,'2012-02-23'),(1122,'g',0,'2012-02-23'),(2002,'g',0,'2012-02-23'),(1124,'g',0,'2012-02-23'),(1401,'g',0,'2012-02-23'),(1985,'g',0,'2012-02-23'),(1973,'g',0,'2012-02-23'),(1387,'g',0,'2012-02-23'),(1981,'g',0,'2012-02-23'),(1977,'g',0,'2012-02-23'),(1374,'g',0,'2012-02-23'),(1121,'g',0,'2012-02-23'),(1369,'g',0,'2012-02-23'),(1424,'g',0,'2012-02-23'),(2004,'g',0,'2012-02-23'),(1112,'g',0,'2012-02-23'),(1120,'g',0,'2012-02-23'),(1395,'g',0,'2012-02-23'),(1365,'g',0,'2012-02-23'),(1285,'g',0,'2012-02-23'),(1371,'g',0,'2012-02-23'),(1370,'g',0,'2012-02-23'),(1361,'g',0,'2012-02-23'),(1364,'g',0,'2012-02-23'),(1372,'g',0,'2012-02-23'),(1816,'g',0,'2012-02-23'),(1936,'g',0,'2012-02-23'),(1119,'g',0,'2012-02-23'),(1941,'g',0,'2012-02-23'),(1898,'g',0,'2012-02-23'),(1394,'g',0,'2012-02-23'),(1937,'g',0,'2012-02-23'),(1367,'g',0,'2012-02-23'),(1992,'g',0,'2012-02-23'),(1117,'g',0,'2012-02-23'),(1129,'g',0,'2012-02-23'),(1111,'g',0,'2012-02-23'),(1116,'g',0,'2012-02-23'),(1842,'g',0,'2012-02-23'),(1423,'g',0,'2012-02-24'),(1839,'g',0,'2012-02-24'),(1978,'g',0,'2012-02-24'),(1980,'g',0,'2012-02-24'),(2036,'g',0,'2012-02-24'),(1845,'g',0,'2012-02-24'),(1922,'g',0,'2012-02-24'),(1895,'g',0,'2012-02-24'),(1868,'g',0,'2012-02-24'),(1899,'g',0,'2012-02-24'),(1284,'g',0,'2012-02-24'),(1950,'g',0,'2012-02-24'),(1288,'g',0,'2012-02-24'),(1968,'g',0,'2012-02-24'),(1942,'g',0,'2012-02-24'),(1398,'g',0,'2012-02-24'),(1943,'g',0,'2012-02-24'),(1275,'g',0,'2012-02-24'),(1969,'g',0,'2012-02-24'),(1282,'g',0,'2012-02-24'),(1286,'g',0,'2012-02-24'),(1971,'g',0,'2012-02-24'),(1993,'g',0,'2012-02-24'),(1984,'g',0,'2012-02-24'),(1972,'g',0,'2012-02-24'),(1994,'g',0,'2012-02-24'),(1982,'g',0,'2012-02-24'),(1998,'g',0,'2012-02-24'),(1940,'g',0,'2012-02-24'),(2000,'g',0,'2012-02-24'),(1989,'g',0,'2012-02-24'),(1996,'g',0,'2012-02-24'),(1979,'g',0,'2012-02-24'),(1965,'g',0,'2012-02-24'),(1999,'g',0,'2012-02-24'),(1997,'g',0,'2012-02-24'),(1935,'g',0,'2012-02-24'),(1967,'g',0,'2012-02-24'),(1983,'g',0,'2012-02-24'),(1947,'g',0,'2012-02-25'),(1995,'g',0,'2012-02-25'),(1974,'g',0,'2012-02-26'),(2022,'g',0,'2012-02-26'),(2027,'g',0,'2012-02-27'),(1944,'g',0,'2012-02-28'),(2069,'g',0,'2012-02-28'),(848,'g',0,'2012-03-01'),(2011,'g',0,'2012-03-01'),(2010,'g',0,'2012-03-01'),(849,'g',0,'2012-03-01'),(1907,'g',0,'2012-03-01'),(1219,'g',0,'2012-03-02'),(1781,'g',0,'2012-03-04'),(1794,'g',0,'2012-03-04'),(1791,'g',0,'2012-03-04'),(2020,'g',0,'2012-03-04'),(908,'g',0,'2012-03-04'),(2078,'g',0,'2012-03-04'),(2057,'g',0,'2012-03-04'),(870,'g',0,'2012-03-04'),(2021,'g',0,'2012-03-04'),(821,'g',0,'2012-03-04'),(1734,'g',0,'2012-03-04'),(611,'g',0,'2012-03-04'),(1822,'g',0,'2012-03-04'),(649,'g',0,'2012-03-04'),(1667,'g',0,'2012-03-04'),(1761,'g',0,'2012-03-04'),(1720,'g',0,'2012-03-04'),(2033,'g',0,'2012-03-04'),(1703,'g',0,'2012-03-04'),(1576,'g',0,'2012-03-04'),(985,'g',0,'2012-03-04'),(1029,'g',0,'2012-03-04'),(998,'g',0,'2012-03-04'),(557,'g',0,'2012-03-04'),(1959,'g',0,'2012-03-04'),(1686,'g',0,'2012-03-04'),(1675,'g',0,'2012-03-04'),(1807,'g',0,'2012-03-04'),(634,'g',0,'2012-03-04'),(1804,'g',0,'2012-03-04'),(1762,'g',0,'2012-03-04'),(2074,'g',0,'2012-03-04'),(1773,'g',0,'2012-03-04'),(1806,'g',0,'2012-03-04'),(1676,'g',0,'2012-03-04'),(2016,'g',0,'2012-03-04'),(576,'g',0,'2012-03-04'),(2054,'g',0,'2012-03-04'),(1875,'g',0,'2012-03-04'),(2018,'g',0,'2012-03-04'),(1873,'g',0,'2012-03-04'),(979,'g',0,'2012-03-04'),(1008,'g',0,'2012-03-04'),(1437,'g',0,'2012-03-04'),(1007,'g',0,'2012-03-04'),(901,'g',0,'2012-03-04'),(988,'g',0,'2012-03-05'),(1099,'g',0,'2012-03-05'),(909,'g',0,'2012-03-05'),(983,'g',0,'2012-03-05'),(2031,'g',0,'2012-03-05'),(1005,'g',0,'2012-03-05'),(943,'g',0,'2012-03-05'),(603,'g',0,'2012-03-05'),(1759,'g',0,'2012-03-05'),(1728,'g',0,'2012-03-05'),(1789,'g',0,'2012-03-05'),(615,'g',0,'2012-03-05'),(1712,'g',0,'2012-03-05'),(1693,'g',0,'2012-03-05'),(1951,'g',0,'2012-03-05'),(1470,'g',0,'2012-03-05'),(1909,'g',0,'2012-03-05'),(1272,'g',0,'2012-03-05'),(1066,'g',0,'2012-03-05'),(1154,'g',0,'2012-03-05'),(1151,'g',0,'2012-03-05'),(1069,'g',0,'2012-03-05'),(1044,'g',0,'2012-03-05'),(1075,'g',0,'2012-03-05'),(1101,'g',0,'2012-03-05'),(1050,'g',0,'2012-03-05'),(1146,'g',0,'2012-03-05'),(1158,'g',0,'2012-03-05'),(1850,'g',0,'2012-03-05'),(1905,'g',0,'2012-03-05'),(1894,'g',0,'2012-03-05'),(1906,'g',0,'2012-03-05'),(986,'g',0,'2012-03-05'),(1678,'g',0,'2012-03-05'),(1805,'g',0,'2012-03-05'),(1268,'g',0,'2012-03-05'),(1914,'g',0,'2012-03-05'),(1571,'g',0,'2012-03-05'),(1871,'g',0,'2012-03-05'),(1267,'g',0,'2012-03-05'),(1963,'g',0,'2012-03-05'),(1904,'g',0,'2012-03-05'),(1422,'g',0,'2012-03-05'),(1231,'g',0,'2012-03-05'),(1574,'g',0,'2012-03-05'),(1569,'g',0,'2012-03-05'),(1896,'g',0,'2012-03-05'),(1139,'g',0,'2012-03-05'),(1305,'g',0,'2012-03-05'),(1306,'g',0,'2012-03-05'),(1990,'g',0,'2012-03-05'),(2067,'g',0,'2012-03-05'),(1921,'g',0,'2012-03-05'),(1205,'g',0,'2012-03-05'),(1949,'g',0,'2012-03-05'),(2050,'g',0,'2012-03-05'),(1261,'g',0,'2012-03-05'),(1932,'g',0,'2012-03-05'),(1402,'g',0,'2012-03-05'),(1991,'g',0,'2012-03-05'),(1897,'g',0,'2012-03-05'),(1913,'g',0,'2012-03-05'),(1955,'g',0,'2012-03-05'),(1167,'g',0,'2012-03-05'),(425,'g',0,'2012-03-05'),(1771,'g',0,'2012-03-05'),(1691,'g',0,'2012-03-05'),(1668,'g',0,'2012-03-05'),(1673,'g',0,'2012-03-05'),(1717,'g',0,'2012-03-05'),(1713,'g',0,'2012-03-05'),(1677,'g',0,'2012-03-05'),(1716,'g',0,'2012-03-05'),(1698,'g',0,'2012-03-05'),(1640,'g',0,'2012-03-05'),(952,'g',0,'2012-03-05'),(927,'g',0,'2012-03-05'),(957,'g',0,'2012-03-05'),(944,'g',0,'2012-03-05'),(950,'g',0,'2012-03-05'),(1012,'g',0,'2012-03-05'),(1003,'g',0,'2012-03-05'),(1016,'g',0,'2012-03-05'),(1015,'g',0,'2012-03-05'),(656,'g',0,'2012-03-05'),(676,'g',0,'2012-03-05'),(843,'g',0,'2012-03-05'),(675,'g',0,'2012-03-05'),(682,'g',0,'2012-03-05'),(841,'g',0,'2012-03-05'),(997,'g',0,'2012-03-05'),(842,'g',0,'2012-03-05'),(840,'g',0,'2012-03-05'),(658,'g',0,'2012-03-05'),(844,'g',0,'2012-03-05'),(671,'g',0,'2012-03-05'),(839,'g',0,'2012-03-05'),(645,'g',0,'2012-03-05'),(663,'g',0,'2012-03-05'),(2059,'g',0,'2012-03-05'),(2070,'g',0,'2012-03-05'),(426,'g',0,'2012-03-05'),(2009,'g',0,'2012-03-05'),(479,'g',0,'2012-03-05'),(492,'g',0,'2012-03-05'),(444,'g',0,'2012-03-05'),(2055,'g',0,'2012-03-05'),(484,'g',0,'2012-03-05'),(485,'g',0,'2012-03-05'),(810,'g',0,'2012-03-05'),(808,'g',0,'2012-03-05'),(809,'g',0,'2012-03-05'),(430,'g',0,'2012-03-05'),(806,'g',0,'2012-03-05'),(807,'g',0,'2012-03-05'),(757,'g',0,'2012-03-05'),(755,'g',0,'2012-03-05'),(763,'g',0,'2012-03-05'),(768,'g',0,'2012-03-05'),(744,'g',0,'2012-03-05'),(722,'g',0,'2012-03-05'),(696,'g',0,'2012-03-05'),(718,'g',0,'2012-03-05'),(731,'g',0,'2012-03-05'),(699,'g',0,'2012-03-05'),(713,'g',0,'2012-03-05'),(716,'g',0,'2012-03-05'),(734,'g',0,'2012-03-05'),(728,'g',0,'2012-03-05'),(712,'g',0,'2012-03-05'),(894,'g',0,'2012-03-05'),(892,'g',0,'2012-03-05'),(881,'g',0,'2012-03-05'),(917,'g',0,'2012-03-05'),(887,'g',0,'2012-03-05'),(829,'g',0,'2012-03-05'),(895,'g',0,'2012-03-05'),(2079,'g',0,'2012-03-05'),(2091,'g',0,'2012-03-05'),(811,'g',0,'2012-03-05'),(2093,'g',0,'2012-03-06'),(2071,'g',0,'2012-03-06'),(2072,'g',0,'2012-03-06'),(2064,'g',0,'2012-03-06'),(2090,'g',0,'2012-03-06'),(2099,'g',0,'2012-03-07');

--
-- Table structure for table `idx_paid_listing`
--

CREATE TABLE `idx_paid_listing` (
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `premium` char(1) DEFAULT NULL,
  `sponsored` char(1) DEFAULT NULL,
  `expire` datetime DEFAULT NULL,
  `paid` char(1) DEFAULT NULL,
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_paid_listing`
--


--
-- Table structure for table `idx_payment_gateway`
--

CREATE TABLE `idx_payment_gateway` (
  `payment_gateway_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `enable` char(1) DEFAULT NULL,
  `setting` text,
  `invoice_html` text,
  PRIMARY KEY (`payment_gateway_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_gateway`
--

INSERT INTO `idx_payment_gateway` VALUES (1,'paypal','1','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n	<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.paypal.com/images/x-click-but02.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>\r\n'),(2,'2co','0','a:6:{s:6:\"co_sid\";s:5:\"84932\";s:9:\"co_secret\";s:5:\"tango\";s:12:\"co_recurring\";s:1:\"0\";s:9:\"co_prod_1\";s:6:\"100.00\";s:9:\"co_prod_2\";s:6:\"250.00\";s:9:\"co_prod_3\";s:6:\"400.00\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=2co\'><img src=\'http://www.2checkout.com/images/overview/btns/25.jpg\' alt=\'Pay Now with 2checkout...\' border=\'0\' /></a> \r\n</p>'),(3,'authorizenet','0','a:2:{s:21:\"authorizenet_login_id\";s:0:\"\";s:21:\"authorizenet_tran_key\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=authorizenet\'><img src=\'http://www.authorize.net/upload/images/Images/Header/authorizenet_logo.gif\' alt=\'Pay Now with Authorize.Net...\' width=\'99\' height=\'39\' style=\'{border : 1px solid #c0c0c0;}\' /></a>\r\n</p>'),(4,'egold','0','a:2:{s:19:\"egold_payee_account\";s:0:\"\";s:16:\"egold_payee_name\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=egold\'>\r\n<img src=\'http://www.e-gold.com/gif/paywith.gif\' border=\'0\' alt=\'Pay Now with e-gold...\' />\r\n</a>\r\n</p>'),(5,'moneybookers','0','a:1:{s:18:\"moneybookers_email\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.moneybookers.com/images/banners/88_en_mb.gif\' border=\'0\' alt=\'Make payments with Moneybookers - it is fast, free and secure!\' /></a> \r\n</p>'),(6,'paypal-subscriptions','0','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'https://www.paypal.com/en_US/i/btn/x-click-but20.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(7,'alertpay','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/pay_now_3.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(8,'alertpay-subcriptions','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay-subcriptions\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/subscribe_now_15.gif\' border=\'0\' alt=\'Make payments with Alert Pay - it is fast, free and secure!\' /></a> \r\n</p>');

--
-- Table structure for table `idx_payment_history`
--

CREATE TABLE `idx_payment_history` (
  `payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contact_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `detail` text,
  `amount` double DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `invoice_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_history`
--


--
-- Table structure for table `idx_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 AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_review` VALUES (1,1585,'Professionel and diligent ',5,'2012-01-03','Review','1','','Euro Lights','gilroy.stevens@gmail.com'),(2,1585,'Excellent',4,'2012-01-03','Review','1','','ketan','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','stupelinks.com'),(5,'site_url','http://stupelinks.com'),(6,'email_address','brennas.mccreedy@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/stupelin/public_html/themes/'),(9,'admin_template_path','/home/stupelin/public_html/admin_tpl/'),(10,'plugin_path','/home/stupelin/public_html/plugin/'),(12,'active_theme','_stupelinks'),(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`
--



