-- phpMyAdmin SQL Dump
-- version 4.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 14, 2014 at 12:48 PM
-- Server version: 5.1.62-0ubuntu0.10.04.1
-- 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 `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=9 ;

-- --------------------------------------------------------

--
-- 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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 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=56 ;

-- --------------------------------------------------------

--
-- 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=190 ;

-- --------------------------------------------------------

--
-- 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,
  `seen` VARCHAR(20) 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;