-- phpMyAdmin SQL Dump
-- version 4.0.5
-- http://www.phpmyadmin.net
--
-- Host: 127.10.59.2:3306
-- Generation Time: Jan 26, 2014 at 05:27 AM
-- Server version: 5.1.71
-- 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
) 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=71 ;

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

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

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

--
-- Table structure for table `data`
--

CREATE TABLE IF NOT EXISTS `data` (
  `uid` INT(11) NOT NULL,
  `name` VARCHAR(50) NOT NULL,
  `txt` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 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` (
  `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`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=346 ;

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

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

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

--
-- Table structure for table `trend`
--

CREATE TABLE IF NOT EXISTS `trend` (
  `title` VARCHAR(50) NOT NULL,
  `hits` INT(11) NOT NULL
) 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,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=227 ;

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

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