View difference between Paste ID: F9qX8MXx and MEG4t6YX

 -- phpMyAdmin SQL Dump
--- version 4.0.5
+-- version 4.0.1
 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
--- Generation Time: Dec 22, 2013 at 06:21 AM
+-- Generation Time: Jan 09, 2014 at 11:05 PM
--- Server version: 5.1.71
+-- Server version: 5.1.62-0ubuntu0.10.04.1
--- PHP Version: 5.3.3
+-- PHP Version: 5.4.15-1~lucid+1
 
 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
 SET time_zone = "+00:00";
 
 --
 -- Database: `open`
 --
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `clikes`
 --
 
-DROP TABLE IF EXISTS `users`;
+CREATE TABLE IF NOT EXISTS `clikes` (
   `uid` int(11) NOT NULL,
   `cid` int(11) NOT NULL,
   `liked` varchar(20) NOT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
-  PRIMARY KEY (`id`)
+
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=158 ;
+-- Table structure for table `cmt`
 --
 
 CREATE TABLE IF NOT EXISTS `cmt` (
   `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`),
   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 ;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `conn`
 --
 
 CREATE TABLE IF NOT EXISTS `conn` (
   `uid` int(11) NOT NULL,
   `fid` int(11) NOT NULL,
   `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`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `data`
 --
 
 CREATE TABLE IF NOT EXISTS `data` (
   `uid` int(11) NOT NULL,
   `name` varchar(100) NOT NULL,
   `txt` longtext NOT NULL,
   PRIMARY KEY (`uid`),
   UNIQUE KEY `uid` (`uid`),
   KEY `uid_2` (`uid`),
   KEY `name` (`name`),
   FULLTEXT KEY `name_2` (`name`),
   FULLTEXT KEY `txt` (`txt`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- 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 `oauth_session`
 --
 
 CREATE TABLE IF NOT EXISTS `oauth_session` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `session` char(32) NOT NULL DEFAULT '',
   `state` char(32) NOT NULL DEFAULT '',
   `access_token` mediumtext NOT NULL,
   `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`),
   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`),
   KEY `creation_2` (`creation`),
   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`),
   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`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=175 ;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `trend`
 --
 
 CREATE TABLE IF NOT EXISTS `trend` (
   `title` varchar(50) 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`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- 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,
   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 ;
 
 -- --------------------------------------------------------
 
 --
 -- 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,
   PRIMARY KEY (`code`),
   UNIQUE KEY `code` (`code`),
   UNIQUE KEY `posted` (`posted`),
   KEY `uid` (`uid`),
   KEY `code_2` (`code`),
   KEY `posted_2` (`posted`),
   FULLTEXT KEY `code_3` (`code`),
   FULLTEXT KEY `posted_3` (`posted`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;