-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 04, 2012 at 10:59 AM
-- Server version: 5.1.61
-- PHP Version: 5.2.6

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: `propextv_database`
--

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

--
-- Table structure for table `tbl_compilations`
--

CREATE TABLE IF NOT EXISTS `tbl_compilations` (
  `com_id` bigint(10) NOT NULL AUTO_INCREMENT,
  `com_cat` varchar(100) NOT NULL,
  `com_title` varchar(255) NOT NULL,
  `com_des` text NOT NULL,
  `com_url` varchar(255) NOT NULL,
  `com_date` varchar(30) NOT NULL,
  PRIMARY KEY (`com_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tbl_compilations`
--

INSERT INTO `tbl_compilations` (`com_id`, `com_cat`, `com_title`, `com_des`, `com_url`, `com_date`) VALUES
(3, 'Advertisement', 'Channel Introduction', '', 'http://www.youtube.com/watch?v=rI34uEnSMHw', '1338568795'),
(4, 'automotive', 'autoshow graphics', '', 'http://www.youtube.com/watch?v=WA5S9yYZbOw', '1338787318'),
(5, 'pets', 'Pets show graphics', '', 'http://www.youtube.com/watch?v=4QLHjqEiRSo', '1338787469'),
(6, 'propex channel graphics', 'Propextv Ad', 'mistake ad propextv.com', 'http://www.youtube.com/watch?v=pv70QtFCbfg', '1338787212'),
(7, 'propex channel graphics', 'website & web channel ads', '', 'http://www.youtube.com/watch?v=Io8zfvjLapI', '1338787114');

/*!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 */;
