-- phpMyAdmin SQL Dump
-- version 3.4.10.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 25, 2012 at 01:48 AM
-- Server version: 5.1.63
-- PHP Version: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `hysterec_phplogin`
--

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

--
-- Table structure for table `chats`
--

DROP TABLE IF EXISTS `chats`;
CREATE TABLE IF NOT EXISTS `chats` (
  `chat_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `chat_body` text NOT NULL,
  `posted_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`chat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=275 ;

--
-- Dumping data for table `chats`
--

INSERT INTO `chats` (`chat_id`, `user_id`, `chat_body`, `posted_on`) VALUES
(269, 49, '<i>underline</i>', '2012-01-30 02:11:12'),
(268, 49, '<b>fsafsdf</b>', '2012-01-30 02:11:02'),
(267, 49, '<a href=\\"http://finance.yahoo.com/q?s=nsrs\\">Here\\''s the link</a>', '2012-01-30 02:10:54'),
(266, 49, 'keep an eye on NSRS', '2012-01-30 02:10:27'),
(265, 49, 'Keep an eye on NSRS.OB <a href=\\"http://finance.yahoo.com/q?s=nsrs.ob\\">Here</a>', '2012-01-30 01:09:27'),
(264, 49, 'this is my first chat. Here\\''s a <a href=\\"http://trade.saoud.org\\">link</a> in my chat!', '2012-01-30 01:03:27'),
(270, 50, 'hi', '2012-02-05 02:04:45'),
(271, 51, 'vvv', '2012-02-05 02:08:05'),
(272, 51, 'vvvvv', '2012-02-05 02:08:07'),
(273, 54, 'adfadfsasdf', '2012-07-25 07:45:31'),
(274, 54, 'asfafgdsfgsdfg', '2012-07-25 07:45:37');

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `date` date NOT NULL,
  `random` varchar(20) NOT NULL,
  `activated` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `email`, `date`, `random`, `activated`) VALUES
(47, 'saoud', 's1', 'saoudrizwan@gmail.com', '2010-12-19', '73181145', 1),
(48, 'riz', '123', 'rmalikmd@gmail.com', '2011-01-09', '89363461', 1),
(49, 'saoud', '7797', 'me@saoud.org', '2012-01-28', '38484590', 1),
(50, 'matthewkosloski', 'yowne', 'mattk1017@yahoo.com', '2012-02-04', '84699613', 1),
(51, 'matthewkosloski', 'yowne', 'mattk1017@yahoo.com', '2012-02-04', '72532268', 1),
(52, 'Ava Elizabiana Grace', 'avagrace', 'avagrace609@aol.com', '2012-03-24', '57988147', 0),
(53, 'Jake wilkinson', 'pickle11', 'Asjhgda@gmail.com', '2012-05-18', '50923312', 1),
(54, 'saoud rizwan', 'saoud', 'me@saoud.org', '2012-07-25', '75094414', 1);

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

--
-- Table structure for table `user_friends`
--

DROP TABLE IF EXISTS `user_friends`;
CREATE TABLE IF NOT EXISTS `user_friends` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `friendid` int(11) NOT NULL,
  `confirmed` int(11) NOT NULL,
  `date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;