-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 19, 2010 at 12:45 PM
-- Server version: 5.0.90
-- PHP Version: 5.2.9
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `bdmonst1_sitesame`
--
-- --------------------------------------------------------
--
-- Table structure for table `auto_keys`
--
DROP TABLE IF EXISTS `auto_keys`;
CREATE TABLE `auto_keys` (
`id` int(11) NOT NULL auto_increment,
`s_key` varchar(255) NOT NULL,
`max_suggestion` int(11) NOT NULL,
`total_suggested` int(11) NOT NULL default '0',
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `s_key` (`s_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `auto_keys`
--
INSERT INTO `auto_keys` (`id`, `s_key`, `max_suggestion`, `total_suggested`, `status`) VALUES
(2, 'social network', 10, 3, 1),
(3, 'file share', 8, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `pages`
--
DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
`id` smallint(6) NOT NULL auto_increment,
`page` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`content` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `pages`
--
INSERT INTO `pages` (`id`, `page`, `title`, `content`) VALUES
(1, 'about', ' More Information About SiteSame', '
\r\nInformation About SitesLike
\r\n
\r\nWho we are.
\r\n
\r\nThe idea for Sitesame came from founder and CEO Mike Zaha, after trying to find a couple of similar websites he noticed that there was no authority in this field. There are some other sites that try to offer such a service but fail when it comes to protecting their visitors from spam, phishing and virusses. Not to mention the irrelevant results and the fact that links are up for sale.
\r\n
\r\nWhat we offer.
\r\n
\r\nSitesmae takes a different approach from what you have seen up until now. We think that it is extremely important that the results are relevant and that it is safe to click on a link. Sitesame is a democracy, meaning that you decide which sites are most similar to another and which are not. Links with negative votes are then deleted or even banned depending on the result of your reports and our own in house developed tools. Let''s summarize our features:
\r\n
\r\nFresh Content & Safety
\r\n\r\n- Website Monitoring 24/7
\r\n- Safe browsing Integration In Cooperation With Google''s Safe browsing.
\r\n- Spam detection algorithms (onsite & offsite).
\r\n
\r\n
Our Database
\r\n\r\n- Find Related or Similar Sites.
\r\n- Vote on Websites Based on Quality or Relevance.
\r\n- Create new Tags/Website Entries.
\r\n- Report bad sites.
\r\n- Share Links With Friends and Family.
\r\n
\r\n
\r\n
Benefits for webmasters
\r\n\r\n- High Exposure.
\r\n- Hard coded Links With Follow Attribute.
\r\n- There is no registration.
\r\n- It is 100% Free.
\r\n
\r\n
\r\nFor more information and details, please use our
contact form.
'),
(3, 'faq', 'Frequently Asked Questions', '\r\n
\r\n
\r\n
\r\nWhy is there no thumbnail for my website?
\r\n
\r\nUnlike favicons, thumbnails are not created on the fly. Instead we use several fixed intervals to create thumbnails. No worries though, all websites will have a preview shot soon.
\r\n
\r\n
\r\nThe tags I''ve added are not displayed, why?
\r\n
\r\nIt may take a while before your tags are displayed as our tagging engine updates every 30 minutes.
Please be patient, your tags will definitely appear.
');
-- --------------------------------------------------------
--
-- Table structure for table `report`
--
DROP TABLE IF EXISTS `report`;
CREATE TABLE `report` (
`id` bigint(20) NOT NULL auto_increment,
`site_id` bigint(20) NOT NULL,
`link_id` bigint(20) NOT NULL,
`user_ip` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`report_desc` varchar(255) NOT NULL,
`created` timestamp NOT NULL default CURRENT_TIMESTAMP,
`status` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `report`
--
INSERT INTO `report` (`id`, `site_id`, `link_id`, `user_ip`, `user_id`, `report_desc`, `created`, `status`) VALUES
(1, 8, 3, 3232235788, 1, 'Harmful', '2009-09-15 20:58:33', 1),
(3, 0, 0, 2130706433, 0, 'Harmful', '2010-04-10 23:01:18', 1),
(4, 6, 4, 2130706433, 2, 'Harmful', '2010-04-11 07:08:11', 1);
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
`id` int(11) NOT NULL auto_increment,
`v_key` varchar(255) NOT NULL,
`v_value` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `v_key` (`v_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=127 ;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `v_key`, `v_value`) VALUES
(1, 'SCRIPT_NAME', 'SiteSame - Find,Share,Tag Similar Websites'),
(2, 'SCRIPT_META_KEYWORD', 'tags,similarsites,rate,share'),
(3, 'SCRIPT_META_DESCRIPTION', 'Find tag rates share similar site'),
(4, 'CONTACT_EMAIL', 'mikezaha@gmail.com'),
(6, 'PAGING_PER_PAGE', '10'),
(5, 'CONTACT_EMAIL_SUBJECT', 'Contact US'),
(14, 'EMAIL_SIGNATURE', 'Administrator SitesLike'),
(16, 'CHARSET', 'utf-8'),
(111, 'SITE_ADMIN_EMAIL', 'admin@tweetee.com'),
(112, 'SITE_ADMIN_NAME', 'Administrator'),
(119, 'CAPTCHA_MODE', '1'),
(124, 'SITE_TWITTER_ACCOUNT', 'poipoi69'),
(125, 'SITE_SUBMIT_CONFIRMATION', '1'),
(126, 'AUTO_SUGGEST', '1');
-- --------------------------------------------------------
--
-- Table structure for table `sites`
--
DROP TABLE IF EXISTS `sites`;
CREATE TABLE `sites` (
`id` bigint(20) NOT NULL auto_increment,
`url` varchar(255) NOT NULL,
`user_id` bigint(20) NOT NULL,
`user_ip` bigint(20) NOT NULL,
`tags` mediumtext NOT NULL,
`domain_terms` mediumtext NOT NULL,
`active` tinyint(4) NOT NULL default '1',
`vote_count` int(11) NOT NULL,
`created` datetime NOT NULL,
`last_modified` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;
--
-- Dumping data for table `sites`
--
INSERT INTO `sites` (`id`, `url`, `user_id`, `user_ip`, `tags`, `domain_terms`, `active`, `vote_count`, `created`, `last_modified`) VALUES
(1, 'file-rack.com', 1, 3232235788, 'File,Share,Rack,upload,share file', 'file-rack.com,file-rack,file-r ack,file-r ack com,file-r ack.com,file-rack com', 1, 2, '2009-09-14 12:48:06', '2009-09-16 17:53:49'),
(2, 'yahoo.com', 0, 3232235788, 'mail,check,chat', 'yahoo.com,yahoo,yaho o,yaho o com,yaho o.com,yahoo com', 1, 0, '2009-09-14 12:49:40', '2009-09-15 16:37:13'),
(3, 'facebook.com', 0, 3232235788, 'social,share,community', 'facebook.com,facebook,facebo ok,facebo ok com,facebo ok.com,facebook com', 1, 1, '2009-09-14 12:51:31', '2010-04-12 12:43:50'),
(4, 'fudgemylife.com', 0, 3232235788, 'top,top FudgeMyLife Tweets,top FudgeMyLife Tweets,hate life,i hate my life,i hate life,hate my life,why do i hate life,life sucks,hate my job life,fucking hate life,i hate myself and want to die,i hate,fudge,tweet,twitter', 'fudgemylife.com,fudgemylife,fudgemy life,fudgemy life com,fudgemy life.com,fudgemylife com', 1, 3, '2009-09-14 12:52:53', '2010-04-10 19:32:11'),
(5, 'twitter.com', 0, 3232235788, 'tweet,community,social', 'twitter.com,twitter,twitt er,twitt er com,twitt er.com,twitter com', 1, 1, '2009-09-14 12:53:41', '2010-04-11 12:22:44'),
(6, 'tweetworth.com', 0, 3232235788, 'tweet worth, twitt worth, twitter worth, tweetworth, tweet value, twitt value, twitter value, how much my twitter worth,worth,Tweet,Twitter', 'tweetworth.com,tweetworth,tweetwo rth,tweetwo rth com,tweetwo rth.com,tweetworth com', 1, 0, '2009-09-14 12:55:07', '2009-09-15 16:37:13'),
(7, 'revtwt.com', 0, 3232235788, 'Twitter Advertising, Twitter Marketing, Make money on Twitter, Twitter Ad Network,revenue,earn', 'revtwt.com,revtwt,revtw t,revtw t com,revtw t.com,revtwt com', 1, -1, '2009-09-14 12:56:34', '2010-01-28 13:25:09'),
(8, 'hi5.com', 0, 3232235788, 'social,community', 'hi5.com,hi5,hi5 ,hi5 com,hi5 .com,hi5 com', 1, 2, '2009-09-14 12:57:04', '2009-09-16 17:54:36'),
(9, 'abc.com', 0, 3232235788, 'shop,buy,online', 'abc.com,abc,abc ,abc com,abc .com,abc com', 1, 3, '2009-09-14 13:05:54', '2009-09-15 21:33:08'),
(12, 'cnn.com', 1, 3232235788, 'CNN,CNN news,CNN.com,CNN TV,news,news online,breaking news,U.S. news,world news,weather,business,CNN Money,sports,politics,law,technology,entertainment,education,travel,health,special reports,autos,developing story,news video,CNN Intl', 'cnn.com,cnn,cnn ,cnn com,cnn .com,cnn com', 1, 1, '2009-09-16 15:10:54', '2010-04-12 09:55:07'),
(13, 'indepth-bd.com', 0, 3232235788, 'Software,Outsourcing,Outsource,Procure,Outsourcing Buyers,IT Outsourcing,Outsourcing Consultants,Information Technology,BPO,Business Process Outsourcing,Information Technology Outsourcing,outsourcing white papers,outsourcing solutions,outsourcing news,RFP,RFI,RFX,Outsourcing Service Providers,Outsourcing Influencers,custom software development,custom web software development,custom software services,ecommerce solution.,community', 'indepth-bd.com,indepth-bd,indepth -bd,indepth -bd com,indepth -bd.com,indepth-bd com', 1, 3, '2009-09-16 16:23:43', '2010-04-12 09:54:48'),
(14, 'chromespot.com', 0, 3232235833, 'Google Chrome Themes,Chrome Forum,Google Chrome Plugins,Chrome Themes,Chrome Plugins,Chrome OS,Chrome News,tweet,chrome,twitter', 'chromespot.com,chromespot,chromes pot,chromes pot com,chromes pot.com,chromespot com', 1, 1, '2009-10-03 12:16:55', '2010-04-12 09:55:04'),
(31, 'example.com', 1, 0, 'test,ex', 'example.com,example,examp le,examp le com,examp le.com,example com', 1, 0, '2009-10-03 19:23:15', '0000-00-00 00:00:00'),
(32, 'google.com', 0, 0, 'google,search', 'google.com,google,googl e,googl e com,googl e.com,google com', 1, 1, '2009-10-03 19:32:56', '2010-04-12 09:55:11'),
(33, 'cemetco.com', 0, 0, 'software,website', 'cemetco.com,cemetco,cemet co,cemet co com,cemet co.com,cemetco com', 1, 1, '2010-01-28 13:29:42', '2010-01-28 14:00:29'),
(34, 'sismediagroup.com', 0, 3232235829, 'kentucky web development,kentucky web design,kentucky web development company,kentucky web design company,New Jersey web design,New Jersey web development,New Jersey web development company,New York custom designs,new york web development,software,website', 'sismediagroup.com,sismediagroup,sismedia group,sismedia group com,sismedia group.com,sismediagroup com', 1, 1, '2010-01-28 13:36:13', '2010-04-10 22:52:10'),
(35, 'thewebearth.com', 0, 3232235829, 'software,website', 'thewebearth.com,thewebearth,thewebe arth,thewebe arth com,thewebe arth.com,thewebearth com', 1, 0, '2010-01-28 13:39:09', '0000-00-00 00:00:00'),
(36, 'gmail.com', 0, 3232235829, 'email,mail,', 'gmail.com,gmail,gmai l,gmai l com,gmai l.com,gmail com', 1, 0, '2010-01-28 15:52:28', '0000-00-00 00:00:00'),
(37, 'bbc.com', 0, 3232235828, 'BBC,bbc.co.uk,Search,British Broadcasting Corporation,bbc,news', 'bbc.com,bbc,bbc ,bbc com,bbc .com,bbc com', 1, 0, '2010-01-28 17:05:01', '0000-00-00 00:00:00'),
(38, 'zeek.us', 0, 2130706433, 'url,shortener,shortening,free,eco-friendly,tracker,zeek,zeek url,tiny,redo,small', 'Free Eco-Friendly URL Shortener.', 1, 0, '2010-04-10 21:05:20', '0000-00-00 00:00:00'),
(39, 'witpic.com', 0, 2130706433, 'sign,up,for,account,email,info,hotmail,msn,rd,make,file,upload', 'one free photo amp; vector per week download any photo use forever', 1, 0, '2010-04-10 23:04:46', '0000-00-00 00:00:00'),
(40, 'cricinfo.com', 1, 2130706433, 'Cricinfo,Cricinfo.com,cricket,sport,scores,live,audio,video,Test matches,Tests,one-day internationals,ODIs,England,Australia,South Africa,West Indies,New Zealand,India,Pakistan,Sri Lanka,Zimbabwe,Bangladesh,Kenya,live score', 'Cricinfo offers users the most comprehensive live coverage of international and domestic cricket available as well as an unparalleled stats database, quality editorial comment and analysis and is part of ESPN.', 1, 0, '2010-04-11 07:48:13', '0000-00-00 00:00:00'),
(46, 'urlredo.com', 2, 1964173081, 'shorten url,redirect url,shrink link,short link,uniform resource locator redirection,hide url,smaller webpage address', 'urlredo.com,urlredo,urlre do,urlre do com,urlre do.com,urlredo com', 0, 0, '2010-04-16 14:15:21', '0000-00-00 00:00:00'),
(47, 'luxist.com', 0, 2904736553, '', 'luxist.com,luxist,luxis t,luxis t com,luxis t.com,luxist com', 0, 0, '2010-04-16 15:08:48', '0000-00-00 00:00:00'),
(42, 'thisis-cricket.com', 0, 2130706433, 'cricket,live score', 'Thisis-Cricket is an informative...', 1, 0, '2010-04-11 10:15:06', '2010-04-11 12:22:32'),
(43, 'webcric.com', 0, 1964173070, 'live cricket,watch cricket,free cricket stream,online cricket,live cricket stream,cricket streaming,cricket online,watch live cricket,IPL,IPL 2010,Indian Premier League 2010,Indian Premier League', 'Array', 0, 0, '2010-04-12 10:17:10', '0000-00-00 00:00:00'),
(44, 'pahlowan.com', 0, 1964173070, '', 'Array', 0, 0, '2010-04-12 10:17:40', '0000-00-00 00:00:00'),
(45, 'scriptlance.com', 0, 1275663742, 'programming,freelance,programmers,outsource,outsourcing,custom programming,project bid,web programmer,bidding,designers', 'Array', 0, 0, '2010-04-12 10:23:31', '0000-00-00 00:00:00'),
(48, 'wikipedia.org', 0, 2904736553, '', 'wikipedia.org,wikipedia,wikipe dia,wikipe dia org,wikipe dia.org,wikipedia org', 0, 0, '2010-04-16 15:11:44', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- Table structure for table `tag_cloud`
--
DROP TABLE IF EXISTS `tag_cloud`;
CREATE TABLE `tag_cloud` (
`tag_id` bigint(20) NOT NULL auto_increment,
`tag` varchar(255) NOT NULL,
`occurance` int(11) NOT NULL default '0',
`modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;
--
-- Dumping data for table `tag_cloud`
--
INSERT INTO `tag_cloud` (`tag_id`, `tag`, `occurance`, `modified`) VALUES
(1, 'Cricinfo', 1, '2010-04-11 07:48:10'),
(2, 'Cricinfo.com', 1, '2010-04-11 07:48:10'),
(3, 'cricket', 6, '2010-04-11 10:15:02'),
(4, 'sport', 1, '2010-04-11 07:48:10'),
(5, 'scores', 1, '2010-04-11 07:48:10'),
(6, 'live', 1, '2010-04-11 07:48:10'),
(7, 'audio', 1, '2010-04-11 07:48:10'),
(8, 'video', 1, '2010-04-11 07:48:10'),
(9, 'Test matches', 1, '2010-04-11 07:48:10'),
(10, 'Tests', 1, '2010-04-11 07:48:10'),
(11, 'one-day internationals', 1, '2010-04-11 07:48:10'),
(12, 'ODIs', 1, '2010-04-11 07:48:10'),
(13, 'England', 1, '2010-04-11 07:48:10'),
(14, 'Australia', 1, '2010-04-11 07:48:10'),
(15, 'South Africa', 1, '2010-04-11 07:48:10'),
(16, 'West Indies', 1, '2010-04-11 07:48:10'),
(17, 'New Zealand', 1, '2010-04-11 07:48:10'),
(18, 'India', 1, '2010-04-11 07:48:10'),
(19, 'Pakistan', 1, '2010-04-11 07:48:10'),
(20, 'Sri Lanka', 1, '2010-04-11 07:48:10'),
(21, 'Zimbabwe', 1, '2010-04-11 07:48:10'),
(22, 'Bangladesh', 1, '2010-04-11 07:48:10'),
(23, 'Kenya', 1, '2010-04-11 07:48:10'),
(24, 'live score', 2, '2010-04-11 10:15:02'),
(25, 'shorten url', 2, '2010-04-16 14:15:21'),
(26, 'redirect url', 2, '2010-04-16 14:15:21'),
(27, 'shrink link', 2, '2010-04-16 14:15:21'),
(28, 'short link', 2, '2010-04-16 14:15:21'),
(29, 'uniform resource locator redirection', 2, '2010-04-16 14:15:21'),
(30, 'hide url', 2, '2010-04-16 14:15:21'),
(31, 'smaller webpage address', 2, '2010-04-16 14:15:21'),
(32, 'shorten', 1, '2010-04-11 08:16:40'),
(33, 'share', 1, '2010-04-11 08:16:40'),
(34, 'url', 1, '2010-04-11 08:16:40'),
(35, 'live cricket', 2, '2010-04-12 10:17:16'),
(36, 'watch cricket', 2, '2010-04-12 10:17:16'),
(37, 'free cricket stream', 2, '2010-04-12 10:17:16'),
(38, 'online cricket', 2, '2010-04-12 10:17:16'),
(39, 'live cricket stream', 2, '2010-04-12 10:17:16'),
(40, 'cricket streaming', 2, '2010-04-12 10:17:16'),
(41, 'cricket online', 2, '2010-04-12 10:17:16'),
(42, 'watch live cricket', 2, '2010-04-12 10:17:16'),
(43, 'IPL', 2, '2010-04-12 10:17:16'),
(44, 'IPL 2010', 2, '2010-04-12 10:17:16'),
(45, 'Indian Premier League 2010', 2, '2010-04-12 10:17:16'),
(46, 'Indian Premier League', 2, '2010-04-12 10:17:16'),
(47, 'programming', 1, '2010-04-12 10:23:31'),
(48, 'freelance', 1, '2010-04-12 10:23:31'),
(49, 'programmers', 1, '2010-04-12 10:23:31'),
(50, 'outsource', 1, '2010-04-12 10:23:31'),
(51, 'outsourcing', 1, '2010-04-12 10:23:31'),
(52, 'custom programming', 1, '2010-04-12 10:23:31'),
(53, 'project bid', 1, '2010-04-12 10:23:31'),
(54, 'web programmer', 1, '2010-04-12 10:23:31'),
(55, 'bidding', 1, '2010-04-12 10:23:31'),
(56, 'designers', 1, '2010-04-12 10:23:31');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`user_id` bigint(20) NOT NULL auto_increment,
`user_ip` bigint(20) NOT NULL,
`user_name` varchar(255) NOT NULL,
`user_email` varchar(255) NOT NULL,
`paypal_email` varchar(255) NOT NULL,
`user_password` varchar(32) NOT NULL,
`first_name` varchar(50) character set utf8 NOT NULL,
`last_name` varchar(50) character set utf8 NOT NULL,
`user_type` enum('0','1','2') NOT NULL default '0',
`user_created` datetime NOT NULL,
`user_birthdate` date NOT NULL,
`user_country` varchar(255) NOT NULL,
`active` enum('0','1') NOT NULL default '0',
`status` enum('0','1') NOT NULL default '1',
`email_notification` enum('0','1') NOT NULL default '0',
`user_lastlogin` datetime NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`user_id`, `user_ip`, `user_name`, `user_email`, `paypal_email`, `user_password`, `first_name`, `last_name`, `user_type`, `user_created`, `user_birthdate`, `user_country`, `active`, `status`, `email_notification`, `user_lastlogin`) VALUES
(1, 3232235833, 'chisty', 'chisty@cemetco.com', 'chisty@paypal.com', '3302fba5d513b9ce55bb6cface3439f4', 'Chisty', 'Shohag', '0', '2009-07-24 09:52:56', '0000-00-00', 'Bangladesh', '1', '1', '1', '2010-04-11 01:47:01'),
(2, 0, 'admin', 'admin@test.com', '', '3302fba5d513b9ce55bb6cface3439f4', 'Site', 'Admin', '1', '0000-00-00 00:00:00', '0000-00-00', 'Bangladesh', '1', '1', '0', '2010-04-17 14:37:27'),
(10, 3232235829, 'khan', 'khanmrh@gmail.com', '', '3302fba5d513b9ce55bb6cface3439f4', '', '', '0', '2010-01-28 10:47:33', '0000-00-00', '', '1', '1', '0', '2010-01-28 10:54:40'),
(9, 3232235788, 'rakib', 'rakib@cemetco.com', '', '3302fba5d513b9ce55bb6cface3439f4', '', '', '0', '2009-09-13 11:06:05', '0000-00-00', '', '1', '1', '0', '2009-09-13 11:06:27');
-- --------------------------------------------------------
--
-- Table structure for table `user_favorites`
--
DROP TABLE IF EXISTS `user_favorites`;
CREATE TABLE `user_favorites` (
`id` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL,
`site_id` bigint(20) NOT NULL,
`created` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `user_favorites`
--
INSERT INTO `user_favorites` (`id`, `user_id`, `site_id`, `created`) VALUES
(4, 1, 1, '2010-04-10 21:46:50'),
(5, 1, 5, '2010-04-10 22:28:14');
-- --------------------------------------------------------
--
-- Table structure for table `votes`
--
DROP TABLE IF EXISTS `votes`;
CREATE TABLE `votes` (
`vote_id` bigint(20) NOT NULL auto_increment,
`site_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`user_ip` bigint(20) NOT NULL,
`votting_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `votes`
--
INSERT INTO `votes` (`vote_id`, `site_id`, `user_id`, `user_ip`, `votting_time`) VALUES
(1, 14, 0, 3232235833, '2009-10-03 23:31:52'),
(2, 13, 0, 3232235829, '2010-01-27 13:10:26'),
(3, 14, 0, 3232235829, '2010-01-28 13:22:19'),
(4, 4, 0, 3232235829, '2010-01-28 13:24:56'),
(5, 7, 0, 3232235829, '2010-01-28 13:25:09'),
(6, 33, 0, 3232235829, '2010-01-28 14:00:29'),
(7, 5, 0, 3232235828, '2010-01-28 17:01:53'),
(8, 3, 0, 3232235828, '2010-01-28 17:16:55'),
(9, 4, 0, 2130706433, '2010-04-10 19:32:11'),
(10, 34, 0, 2130706433, '2010-04-10 22:52:10'),
(11, 13, 0, 1964173070, '2010-04-12 09:54:48'),
(12, 14, 0, 1964173070, '2010-04-12 09:55:04'),
(13, 12, 0, 1964173070, '2010-04-12 09:55:07'),
(14, 32, 0, 1964173070, '2010-04-12 09:55:11'),
(15, 3, 0, 1958848595, '2010-04-12 12:43:50');