# Database: tvguide
# tvguide@localhost
#
# Table structure for table 'channel'
#
# DROP TABLE IF EXISTS channel;
CREATE TABLE `channel` (
  `channelnum` smallint(4) default NULL,
  `id` varchar(255) NOT NULL default '',
  `display_name` varchar(255) default NULL,
  `iconurl` varchar(255) default NULL,
  KEY `channel_id` (`id`(10))
) TYPE=MyISAM;
#
#
# Table structure for table 'channellike'
#
# DROP TABLE IF EXISTS channellike;
CREATE TABLE `channellike` (
  `userid` varchar(10) NOT NULL default '',
  `id` varchar(255) default NULL,
  KEY `channellike_id` (`id`(10))
) TYPE=MyISAM;
#
#
#
# Table structure for table 'hatedcategories'
#
# DROP TABLE IF EXISTS hatedcategories;
CREATE TABLE `hatedcategories` (
  `userid` varchar(10) NOT NULL default '',
  `category` varchar(255) NOT NULL default '',
  KEY `hatedcategories_category` (`category`(10))
) TYPE=MyISAM;
#
#
#
# Table structure for table 'hatedprograms'
#
# DROP TABLE IF EXISTS hatedprograms;
CREATE TABLE `hatedprograms` (
  `userid` varchar(10) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  KEY `hatedprograms_title` (`title`)
) TYPE=MyISAM;
#
#
#
# Table structure for table 'programme'
#
# DROP TABLE IF EXISTS programme;
CREATE TABLE `programme` (
  `title` varchar(255) default NULL,
  `sub_title` varchar(255) default NULL,
  `desc_str` varchar(255) default NULL,
  `start_str` varchar(255) default NULL,
  `stop_str` varchar(255) default NULL,
  `channel` varchar(255) default NULL,
  `channel_no` smallint(6) default NULL,
  `category` varchar(255) default NULL,
  `length` varchar(255) default NULL,
  `star_rating` varchar(255) default NULL,
  `start_date` datetime default NULL,
  `stop_date` datetime default NULL,
  `date_str` varchar(255) default NULL,
  `detailnumber` int(11) default NULL,
  KEY `programme_title` (`title`),
  KEY `programme_channel` (`channel`(10)),
  KEY `programme_category` (`category`(10)),
  KEY `programme_start_date` (`start_date`),
  KEY `programme_stop_date` (`stop_date`)
) TYPE=MyISAM;
#
#
#
# Table structure for table 'programmeweight'
#
# DROP TABLE IF EXISTS programmeweight;
CREATE TABLE `programmeweight` (
  `title` varchar(255) NOT NULL default '',
  `weight` smallint(4) default NULL
) TYPE=MyISAM;