View difference between Paste ID: nJX46jzu 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 26, 2014 at 05:27 AM
--- 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=19 ;
 
 -- --------------------------------------------------------
 
 --
 -- 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=71 ;
 
 -- --------------------------------------------------------
-  `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 `notify`
 --
 
 CREATE TABLE IF NOT EXISTS `notify` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `uid` int(11) NOT NULL,
   `fid` int(11) NOT NULL,
   `ty` varchar(10) NOT NULL,
   `post` varchar(100) NOT NULL,
   `posted` varchar(20) NOT NULL,
   `red` int(11) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `oauth_session`
 --
 
 CREATE TABLE IF NOT EXISTS `oauth_session` (
-  UNIQUE KEY `social_oauth_session_index` (`session`,`server`),
+
-  UNIQUE KEY `id` (`id`),
+
-  UNIQUE KEY `state` (`state`),
+
-  UNIQUE KEY `type` (`type`),
+
-  UNIQUE KEY `creation` (`creation`),
+
-  UNIQUE KEY `user` (`user`),
+
-  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`),
+  UNIQUE KEY `social_oauth_session_index` (`session`,`server`)
-  KEY `creation_2` (`creation`),
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=346 ;
-  KEY `authorized_2` (`authorized`),
+
-  KEY `user_2` (`user`)
+
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+
 --
 -- Table structure for table `posts`
 --
 
 CREATE TABLE IF NOT EXISTS `posts` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `uid` int(11) NOT NULL,
   `post` text NOT NULL,
   `posted` varchar(30) NOT NULL,
   `privacy` varchar(3) NOT NULL DEFAULT 'p',
   `likes` int(11) NOT NULL DEFAULT '0',
   `cmts` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=127 ;
 
 -- --------------------------------------------------------
-  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`),
+  `hits` int(11) NOT NULL
-  FULLTEXT KEY `post` (`post`),
+
-  FULLTEXT KEY `posted_3` (`posted`),
+
-  FULLTEXT KEY `privacy_2` (`privacy`)
+
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=175 ;
+
 --
 -- 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,
-  `hits` int(11) NOT NULL,
+
-  PRIMARY KEY (`title`),
+
-  UNIQUE KEY `title` (`title`),
+  `seen` varchar(20) NOT NULL,
-  KEY `title_2` (`title`),
+  PRIMARY KEY (`id`)
-  KEY `hits` (`hits`),
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=227 ;
-  FULLTEXT KEY `title_3` (`title`)
+
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `verify`
 --
 
 CREATE TABLE IF NOT EXISTS `verify` (
   `uid` int(11) NOT NULL,
   `code` varchar(35) NOT NULL,
   `posted` varchar(20) NOT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;