-- phpMyAdmin SQL Dump -- version 2.11.0 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 26, 2007 at 02:01 PM -- Server version: 4.1.22 -- PHP Version: 5.2.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `livetv_livetv` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL default '0', `uid` varchar(15) NOT NULL default '', `pwd` varchar(15) default NULL, `email` varchar(100) default NULL, `admin_email` varchar(100) default NULL, `report_email` varchar(100) default NULL, `feedback_email` varchar(100) default NULL, `support_email` varchar(100) default NULL, `info_email` varchar(100) default NULL, `legal_email` varchar(100) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `admin` -- INSERT INTO `admin` VALUES(1, 'admin', 'admin', 'you@YourTVChannel.com', 'you@YourTVChannel.com', 'you@YourTVChannel.com', 'you@YourTVChannel.com', 'you@YourTVChannel.com', 'you@YourTVChannel.com', '12'); -- -------------------------------------------------------- -- -- Table structure for table `advertise` -- CREATE TABLE `advertise` ( `ad_id` int(22) NOT NULL auto_increment, `comp_name` varchar(200) collate latin1_general_ci NOT NULL default '', `fname` varchar(200) collate latin1_general_ci NOT NULL default '', `lname` varchar(200) collate latin1_general_ci NOT NULL default '', `email` varchar(130) collate latin1_general_ci NOT NULL default '', `message` text collate latin1_general_ci NOT NULL, `pdate` int(11) NOT NULL default '0', PRIMARY KEY (`ad_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ; -- -- Dumping data for table `advertise` -- -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `cat_id` int(22) NOT NULL auto_increment, `cat_name` varchar(255) collate latin1_general_ci NOT NULL default '', `top_flag` tinyint(2) NOT NULL default '0', `mid` int(22) NOT NULL default '0', PRIMARY KEY (`cat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ; -- -- Dumping data for table `category` -- INSERT INTO `category` VALUES(9, 'cartoons', 0, 11); INSERT INTO `category` VALUES(4, 'Live Press Conferences', 1, 1); INSERT INTO `category` VALUES(8, 'Live Games', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `channel` -- CREATE TABLE `channel` ( `ch_id` int(22) NOT NULL auto_increment, `cat_id` int(22) NOT NULL default '0', `channel_name` varchar(200) collate latin1_general_ci NOT NULL default '', `channel_description` text collate latin1_general_ci NOT NULL, `channel_video` varchar(230) collate latin1_general_ci NOT NULL default '', `top_flag` tinyint(2) NOT NULL default '0', `channel_url` text collate latin1_general_ci, `mid` int(22) NOT NULL default '0', `channel_type` char(1) collate latin1_general_ci default NULL, PRIMARY KEY (`ch_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=16 ; -- -- Dumping data for table `channel` -- INSERT INTO `channel` VALUES(1, 4, 'ABCNews', 'newschannel', '11788825452.Dat', 1, 'mms://a1873.l2639649579.c26396.g.lm.akamaistream.net/D/1873/26396/v0001/reflector:49579', 0, NULL); INSERT INTO `channel` VALUES(2, 4, 'DEFNews', 'DEF new is the best news channel.', '1178888464.mp3', 1, 'mms://a1873.l2639649579.c26396.g.lm.akamaistream.net/D/1873/26396/v0001/reflector:49579', 0, NULL); INSERT INTO `channel` VALUES(3, 8, 'ABC Sports', 'This is a sports channel.This is very popular.', '1178888464.mp3', 1, 'mms://a1873.l2639649579.c26396.g.lm.akamaistream.net/D/1873/26396/v0001/reflector:49579', 0, 'T'); INSERT INTO `channel` VALUES(4, 4, 'Food', 'Food Demonstration', '', 0, 'mms://twc.wmod.llnwd.net/a189/e1/multimedia/video/limelight/topstory_bb.asf', 0, NULL); INSERT INTO `channel` VALUES(9, 9, 'fgsdfg', '', '', 0, 'fghjdghj', 11, NULL); INSERT INTO `channel` VALUES(6, 4, 'bb', '', '', 0, 'http://208.53.137.180:30000', 1, NULL); INSERT INTO `channel` VALUES(8, 4, 'GEO TV', 'PAKISTANI TV CHANNEL', '', 0, 'http://geo.tv', 1, NULL); INSERT INTO `channel` VALUES(11, 8, 'Test video', 'Youtube video - Upps', '', 0, '', 1, 'V'); INSERT INTO `channel` VALUES(12, 4, 'Youtube Favorites', 'Youtube Favorites', '', 0, 'http://youtube.com/rss/global/top_favorites.rss', 1, 'R'); INSERT INTO `channel` VALUES(13, 4, 'Youtube Recently', 'Youtube Recently', '', 0, 'http://youtube.com/rss/global/recently_added.rss', 1, 'R'); INSERT INTO `channel` VALUES(14, 9, 'test3', 'testa', '', 0, 'mms://a1873.l2639649579.c26396.g.lm.akamaistream.net/D/1873/26396/v0001/reflector:49579', 11, 'T'); INSERT INTO `channel` VALUES(15, 8, 'Google Videos', 'Google Videos', '', 0, 'http://video.google.com/videofeed?type=search&q=baseball&num=20&output=rss', 1, 'R'); -- -------------------------------------------------------- -- -- Table structure for table `mcategory` -- CREATE TABLE `mcategory` ( `mid` int(22) NOT NULL auto_increment, `mcat_name` varchar(200) character set latin1 collate latin1_general_ci NOT NULL default '', PRIMARY KEY (`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `mcategory` -- INSERT INTO `mcategory` VALUES(1, 'American Football'); INSERT INTO `mcategory` VALUES(11, 'Cartoons'); -- -------------------------------------------------------- -- -- Table structure for table `media` -- CREATE TABLE `media` ( `med_id` int(11) NOT NULL auto_increment, `description` varchar(200) default NULL, `url` varchar(200) default NULL, `html_code` text, `top_flag` smallint(6) default NULL, PRIMARY KEY (`med_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `media` -- INSERT INTO `media` VALUES(1, 'upps funny clip #28', 'http://www.youtube.com/watch?v=Gm3cYz4oQYA', '', 0); INSERT INTO `media` VALUES(7, 'upps funny clip #17', 'http://www.youtube.com/watch?v=52qU9RAn1Dw', '', NULL); INSERT INTO `media` VALUES(8, 'great goals', 'http://www.youtube.com/watch?v=HD8f_Qgwc50', '', NULL); INSERT INTO `media` VALUES(9, 'queen + pavarotti - too much love will kill you', 'http://www.youtube.com/watch?v=C7FGPIRJx6I', '', NULL); -- -------------------------------------------------------- -- -- Table structure for table `news` -- CREATE TABLE `news` ( `nid` int(22) NOT NULL auto_increment, `newsdetails` text character set latin1 collate latin1_general_ci NOT NULL, `pdate` int(11) NOT NULL default '0', PRIMARY KEY (`nid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `news` -- INSERT INTO `news` VALUES(1, 'THIS IS THE NEWS SECTION , IT CAN BE UPDATED VIA ADMIN PANEL.', 1192725335); -- -------------------------------------------------------- -- -- Table structure for table `poll_db` -- CREATE TABLE `poll_db` ( `pl_id` int(22) NOT NULL auto_increment, `num_option` varchar(220) collate latin1_general_ci NOT NULL default '', `option_name` text collate latin1_general_ci NOT NULL, `pl_name` varchar(200) collate latin1_general_ci NOT NULL default '', PRIMARY KEY (`pl_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `poll_db` -- INSERT INTO `poll_db` VALUES(1, '3', '20 to 35 years old:36 to 55 years old:56 + years old:', 'What is your age range'); -- -------------------------------------------------------- -- -- Table structure for table `problems` -- CREATE TABLE `problems` ( `pb_id` int(22) NOT NULL auto_increment, `prob_desc` text collate latin1_general_ci NOT NULL, PRIMARY KEY (`pb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `problems` -- INSERT INTO `problems` VALUES(1, 'You can edit this via admin panel\r\n
'); -- -------------------------------------------------------- -- -- Table structure for table `requirment` -- CREATE TABLE `requirment` ( `req_id` int(22) NOT NULL auto_increment, `prob_desc` text NOT NULL, PRIMARY KEY (`req_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `requirment` -- INSERT INTO `requirment` VALUES(1, 'You can edit this via admin panel\r\n
'); -- -------------------------------------------------------- -- -- Table structure for table `rss_feeds` -- CREATE TABLE `rss_feeds` ( `rss_id` int(11) NOT NULL auto_increment, `description` varchar(200) default NULL, `url` varchar(200) default NULL, `top_flag` smallint(6) default NULL, PRIMARY KEY (`rss_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `rss_feeds` -- INSERT INTO `rss_feeds` VALUES(3, 'YouTube :: Recently Added Videos', 'http://youtube.com/rss/global/recently_added.rss', NULL); INSERT INTO `rss_feeds` VALUES(5, 'YouTube :: Recently Featured', 'http://youtube.com/rss/global/recently_featured.rss', NULL); INSERT INTO `rss_feeds` VALUES(6, 'YouTube :: Top Favorites', 'http://youtube.com/rss/global/top_favorites.rss', NULL); -- -------------------------------------------------------- -- -- Table structure for table `suggest_stream` -- CREATE TABLE `suggest_stream` ( `sg_id` int(22) NOT NULL auto_increment, `Name_of_stream` varchar(222) collate latin1_general_ci NOT NULL default '', `url` varchar(200) collate latin1_general_ci NOT NULL default '', `fname` varchar(120) collate latin1_general_ci NOT NULL default '', `lname` varchar(120) collate latin1_general_ci NOT NULL default '', `email` varchar(130) collate latin1_general_ci NOT NULL default '', `pdate` int(11) NOT NULL default '0', PRIMARY KEY (`sg_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ; -- -- Dumping data for table `suggest_stream` -- INSERT INTO `suggest_stream` VALUES(1, 'sdfsdf', 'sdfdsf', 'sdfsdf', 'sdfsdf', 'sdfsdf@sdfsdf.com', 1179007518); INSERT INTO `suggest_stream` VALUES(2, 'zee sports', '', '', '', '', 1192323551); INSERT INTO `suggest_stream` VALUES(3, 'aass', 'http://spreelance.com', 'aa', 'aa', 'aass@aass.com', 1193105552); -- -------------------------------------------------------- -- -- Table structure for table `terms` -- CREATE TABLE `terms` ( `tr_id` int(22) NOT NULL auto_increment, `prob_desc` text collate latin1_general_ci NOT NULL, PRIMARY KEY (`tr_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `terms` -- INSERT INTO `terms` VALUES(1, '');