-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 21, 2011 at 12:20 PM
-- Server version: 5.1.53
-- PHP Version: 5.3.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `youtube`
--

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

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `machine_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `homepage` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `machine_name`, `homepage`) VALUES
(1, 'Music', 'Music', 1);

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

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `video_id` int(11) unsigned NOT NULL,
  `comment` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `user_id` int(11) unsigned NOT NULL,
  `userip` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `votes` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `FK_post_id` (`video_id`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `comments`
--


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

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `key` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `name`, `value`) VALUES
(1, 'captcha_use', 'Captcha Use?', 'no'),
(2, 'public_key', 'Captcha Public Key', ''),
(3, 'private_key', 'Captcha Private Key', ''),
(5, 'anonymous_posting', 'Anomymous Posting', 'no'),
(7, 'admin_email', 'Email', ''),
(8, 'mail_from_name', 'Mail From Name', 'Free Tube Script'),
(9, 'site_title', 'Site Title', 'Free Tube Script'),
(10, 'site_keywords', 'Site Keywords', 'free tube script, agrizlive.com'),
(11, 'site_description', 'Meta Description', 'Free tube script from agrizlive.com'),
(12, 'record_per_page', 'Record per page', '10');

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `account_status` enum('inactive','active') COLLATE utf8_unicode_ci NOT NULL,
  `email_status` enum('inactive','active') COLLATE utf8_unicode_ci NOT NULL,
  `userip` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `email_validation_key` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `profile_picture` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `password_reset_code` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `group_id` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

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

INSERT INTO `users` (`id`, `username`, `password`, `email`, `account_status`, `email_status`, `userip`, `email_validation_key`, `profile_picture`, `password_reset_code`, `created`, `group_id`) VALUES
(1, 'anonymous', '', '', 'inactive', 'inactive', '', '', '', '', '0000-00-00 00:00:00', 1),
(2, 'admin', 'af5cebf00d8ab9cab8b306cd4177101b322f23cb', 'admin@email.com', 'active', 'active', '', '4e1ce3b2-0c18-4c6b-8740-0904d66a46af', '', '', '2011-07-13 00:15:46', 2);

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

--
-- Table structure for table `videos`
--

CREATE TABLE IF NOT EXISTS `videos` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `machine_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `video_id` text COLLATE utf8_unicode_ci NOT NULL,
  `embed_code` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `viewed` int(5) NOT NULL,
  `user_id` int(5) NOT NULL,
  `category_id` int(3) NOT NULL,
  `width` int(3) DEFAULT '0',
  `height` int(3) DEFAULT '0',
  `source` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `video_timing` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `image_url` text COLLATE utf8_unicode_ci NOT NULL,
  `page_title` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `page_keyword` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `page_description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `name`, `machine_name`, `video_id`, `embed_code`, `viewed`, `user_id`, `category_id`, `width`, `height`, `source`, `video_timing`, `image_url`, `page_title`, `page_keyword`, `page_description`) VALUES
(2, 'Jennifer Lopez ', 'Jennifer-Lopez', 't4H_Zoh7G5A', '', 0, 1, 1, 700, 400, 'youtube', '4:27', '', '', '', '');
