View difference between Paste ID: uVNucXHp and F9qX8MXx

 -- phpMyAdmin SQL Dump
--- version 4.0.1
+-- version 4.0.5
 -- http://www.phpmyadmin.net
 --
--- Host: localhost
+-- Host: 127.10.59.2:3306
--- Generation Time: Jan 09, 2014 at 11:05 PM
+-- Generation Time: Jan 30, 2014 at 12:49 PM
--- Server version: 5.1.62-0ubuntu0.10.04.1
+-- Server version: 5.1.71
--- PHP Version: 5.4.15-1~lucid+1
+-- PHP Version: 5.3.3
 
 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
 SET time_zone = "+00:00";
 
 --
 -- Database: `open`
 --
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `chat`
 --
 
 CREATE TABLE IF NOT EXISTS `chat` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `uid` int(11) NOT NULL,
   `fid` int(11) NOT NULL,
   `msg` text NOT NULL,
   `posted` varchar(20) NOT NULL,
   `red` int(1) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `clikes`
 --
 
 CREATE TABLE IF NOT EXISTS `clikes` (
   `uid` int(11) NOT NULL,
   `cid` int(11) NOT NULL,
   `liked` varchar(20) NOT NULL
-  UNIQUE KEY `id` (`id`),
+
-  UNIQUE KEY `posted` (`posted`),
+
-  KEY `id_2` (`id`),
+
-  KEY `uid` (`uid`),
+
-  KEY `pid` (`pid`),
+
-  KEY `posted_2` (`posted`),
+
-  FULLTEXT KEY `cmt` (`cmt`),
+
-  FULLTEXT KEY `posted_3` (`posted`)
+
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
+
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `uid` int(11) NOT NULL,
   `pid` int(11) NOT NULL,
   `cmt` text NOT NULL,
   `posted` varchar(30) NOT NULL,
   `likes` int(11) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=72 ;
 
 -- --------------------------------------------------------
-  `since` varchar(20) NOT NULL,
+
-  PRIMARY KEY (`since`),
+
-  UNIQUE KEY `since` (`since`),
+
-  KEY `uid` (`uid`),
+
-  KEY `fid` (`fid`),
+
-  KEY `since_2` (`since`),
+
-  FULLTEXT KEY `since_3` (`since`)
+
   `fid` int(11) NOT NULL,
   `since` varchar(20) NOT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `data`
 --
 
 CREATE TABLE IF NOT EXISTS `data` (
-  `txt` longtext NOT NULL,
+
-  PRIMARY KEY (`uid`),
+  `name` varchar(50) NOT NULL,
-  UNIQUE KEY `uid` (`uid`),
+  `txt` longtext NOT NULL
-  KEY `uid_2` (`uid`),
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-  KEY `name` (`name`),
+
-  FULLTEXT KEY `name_2` (`name`),
+
-  FULLTEXT KEY `txt` (`txt`)
+
 --
 -- Table structure for table `likes`
 --
 
 CREATE TABLE IF NOT EXISTS `likes` (
   `uid` int(11) NOT NULL,
   `pid` int(11) NOT NULL,
   `liked` varchar(20) NOT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `mails`
 --
 
 CREATE TABLE IF NOT EXISTS `mails` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `email` varchar(150) NOT NULL,
   `sub` text NOT NULL,
   `message` text NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `notify`
 --
 
 CREATE TABLE IF NOT EXISTS `notify` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `uid` int(11) NOT NULL,
   `fid` int(11) NOT NULL,
-  UNIQUE KEY `social_oauth_session_index` (`session`,`server`),
+  `ty` varchar(10) NOT NULL,
-  UNIQUE KEY `id` (`id`),
+  `post` varchar(100) NOT NULL,
-  UNIQUE KEY `state` (`state`),
+
-  UNIQUE KEY `type` (`type`),
+  `red` int(11) NOT NULL,
-  UNIQUE KEY `creation` (`creation`),
+  PRIMARY KEY (`id`)
-  UNIQUE KEY `user` (`user`),
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=129 ;
-  UNIQUE KEY `expiry` (`expiry`),
+
-  UNIQUE KEY `authorized` (`authorized`),
+
-  KEY `id_2` (`id`),
+
-  KEY `session` (`session`),
+
-  KEY `state_2` (`state`),
+
-  KEY `expiry_2` (`expiry`),
+
-  KEY `type_2` (`type`),
+
-  KEY `server` (`server`),
+
-  KEY `creation_2` (`creation`),
+
-  KEY `authorized_2` (`authorized`),
+
-  KEY `user_2` (`user`)
+
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+
   `expiry` datetime DEFAULT NULL,
   `type` char(12) NOT NULL DEFAULT '',
   `server` char(12) NOT NULL DEFAULT '',
   `creation` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
   `access_token_secret` mediumtext NOT NULL,
   `authorized` char(1) DEFAULT NULL,
   `user` int(10) unsigned NOT NULL,
   `refresh_token` mediumtext NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `social_oauth_session_index` (`session`,`server`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=369 ;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `posts`
-  UNIQUE KEY `id` (`id`),
+
-  UNIQUE KEY `posted` (`posted`),
+
-  KEY `id_2` (`id`),
+
-  KEY `uid` (`uid`),
+
-  KEY `posted_2` (`posted`),
+
-  KEY `privacy` (`privacy`),
+
-  KEY `likes` (`likes`),
+
-  KEY `cmts` (`cmts`),
+
-  FULLTEXT KEY `post` (`post`),
+
-  FULLTEXT KEY `posted_3` (`posted`),
+
-  FULLTEXT KEY `privacy_2` (`privacy`)
+  PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=175 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=131 ;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `trend`
 --
 
 CREATE TABLE IF NOT EXISTS `trend` (
   `title` varchar(50) NOT NULL,
-  `hits` int(11) NOT NULL,
+  `hits` int(11) NOT NULL
-  PRIMARY KEY (`title`),
+
-  UNIQUE KEY `title` (`title`),
+
-  KEY `title_2` (`title`),
+
-  KEY `hits` (`hits`),
+
-  FULLTEXT KEY `title_3` (`title`)
+
 -- Table structure for table `users`
 --
 
 CREATE TABLE IF NOT EXISTS `users` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `username` text NOT NULL,
   `password` text NOT NULL,
   `psalt` text NOT NULL,
   `name` varchar(100) NOT NULL,
   `udata` text NOT NULL,
   `seen` varchar(20) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=229 ;
 
 -- --------------------------------------------------------
-  UNIQUE KEY `id` (`id`),
+
-  KEY `id_2` (`id`),
+
-  FULLTEXT KEY `username` (`username`),
+
-  FULLTEXT KEY `password` (`password`),
+
-  FULLTEXT KEY `psalt` (`psalt`),
+
-  FULLTEXT KEY `udata` (`udata`)
+
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
+
   `code` varchar(35) NOT NULL,
   `posted` varchar(20) NOT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;