--
-- Host: localhost    Database: nova_db
-- ------------------------------------------------------


--
-- Table structure for table `app_category_main`
--

CREATE TABLE `app_category_main` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `CSort` int(11) NOT NULL,
  `CategoryName` varchar(255) NOT NULL,
  `Picturename` text NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `app_category_main`
--


--
-- Table structure for table `app_category_sub`
--

CREATE TABLE `app_category_sub` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryTID` int(11) NOT NULL,
  `SSort` int(11) NOT NULL,
  `SubCategory` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Picturename` text NOT NULL,
  `AlphaValue` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `app_category_sub`
--


--
-- Table structure for table `app_category_sub2`
--

CREATE TABLE `app_category_sub2` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryTID` int(11) NOT NULL,
  `SSort` int(11) NOT NULL,
  `SubCategory` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Picturename` text NOT NULL,
  `AlphaValue` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `app_category_sub2`
--


--
-- Table structure for table `b_credits`
--

CREATE TABLE `b_credits` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `UserTID` int(11) NOT NULL,
  `CerditsType` varchar(10) NOT NULL COMMENT 'Transfer, Pull',
  `TargetUserTID` int(11) NOT NULL,
  `Credits` int(11) NOT NULL,
  `Note` text NOT NULL,
  `Registration_Date` datetime NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `b_credits`
--


--
-- Table structure for table `b_credits_log`
--

CREATE TABLE `b_credits_log` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `UserTID` int(11) NOT NULL,
  `UserName` varchar(50) NOT NULL,
  `TargetTID` int(11) NOT NULL,
  `TargetName` varchar(50) NOT NULL,
  `Details` varchar(100) NOT NULL,
  `Note` text NOT NULL,
  `RegDate` datetime NOT NULL,
  PRIMARY KEY (`TID`),
  KEY `MemberTID` (`UserTID`,`RegDate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `b_credits_log`
--


--
-- Table structure for table `b_member_log`
--

CREATE TABLE `b_member_log` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `MemberTID` int(11) NOT NULL,
  `ProgramName` varchar(100) NOT NULL,
  `Working` varchar(200) NOT NULL,
  `RegDate` datetime NOT NULL,
  PRIMARY KEY (`TID`),
  KEY `MemberTID` (`MemberTID`,`RegDate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `b_member_log`
--


--
-- Table structure for table `b_message`
--

CREATE TABLE `b_message` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `MemberTID` int(11) NOT NULL,
  `MAC` text NOT NULL,
  `RetailerTID` int(11) NOT NULL,
  `RetailerName` varchar(50) NOT NULL,
  `Message` text NOT NULL,
  `Status` varchar(20) NOT NULL,
  `Registration_Date` datetime NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `b_message`
--

INSERT INTO `b_message` VALUES (1,9,'0G43sILHAiM3X/+9CDgcPgIYKUJ9TQz/snty3ImdPpE=',1,'novatester','qqqbbb','Waiting','2016-06-02 21:57:43');

--
-- Table structure for table `category_main`
--

CREATE TABLE `category_main` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `CSort` int(11) NOT NULL,
  `CategoryName` varchar(255) NOT NULL,
  `Picturename` text NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category_main`
--

INSERT INTO `category_main` VALUES (1,1,'Live',''),(2,2,'VOD',''),(3,3,'Audio','');

--
-- Table structure for table `category_sub`
--

CREATE TABLE `category_sub` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryTID` int(11) NOT NULL,
  `SSort` int(11) NOT NULL,
  `SubCategory` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Picturename` text NOT NULL,
  `AlphaValue` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category_sub`
--


--
-- Table structure for table `category_sub2`
--

CREATE TABLE `category_sub2` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryTID` int(11) NOT NULL,
  `SSort` int(11) NOT NULL,
  `SubCategory` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Picturename` text NOT NULL,
  `AlphaValue` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category_sub2`
--


--
-- Table structure for table `category_sub3`
--

CREATE TABLE `category_sub3` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryTID` int(11) NOT NULL,
  `SSort` int(11) NOT NULL,
  `SubCategory` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Picturename` text NOT NULL,
  `AlphaValue` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category_sub3`
--


--
-- Table structure for table `category_sub4`
--

CREATE TABLE `category_sub4` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryTID` int(11) NOT NULL,
  `SSort` int(11) NOT NULL,
  `SubCategory` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Picturename` text NOT NULL,
  `AlphaValue` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category_sub4`
--


--
-- Table structure for table `channel_app`
--

CREATE TABLE `channel_app` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `AppName` varchar(255) NOT NULL,
  `Version` varchar(100) NOT NULL,
  `PackageName` varchar(100) NOT NULL,
  `Revision` varchar(100) NOT NULL,
  `Type` varchar(20) NOT NULL,
  `Distrbute` varchar(20) NOT NULL,
  `Status` varchar(20) NOT NULL,
  `AutoInstall` varchar(10) NOT NULL,
  `HidingDevice` varchar(10) NOT NULL,
  `Price` varchar(100) NOT NULL,
  `Installs` varchar(100) NOT NULL,
  `Rating` varchar(100) NOT NULL,
  `FileURL` text NOT NULL,
  `FileName` varchar(255) NOT NULL,
  `FileSize` varchar(100) NOT NULL,
  `Description` text NOT NULL,
  `Language` varchar(100) NOT NULL,
  `Category1` varchar(100) NOT NULL,
  `Category2` varchar(100) NOT NULL,
  `Category3` varchar(100) NOT NULL,
  `thumbnail1` varchar(255) NOT NULL,
  `thumbnail2` varchar(255) NOT NULL,
  `thumbnail3` varchar(255) NOT NULL,
  `thumbnail4` varchar(255) NOT NULL,
  `Registration_date` datetime NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `channel_app`
--


--
-- Table structure for table `channel_app_language`
--

CREATE TABLE `channel_app_language` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `AppTID` int(11) NOT NULL,
  `TypeName` varchar(50) NOT NULL,
  `Description` text NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `channel_app_language`
--


--
-- Table structure for table `channel_audio`
--

CREATE TABLE `channel_audio` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `ChName` varchar(100) NOT NULL,
  `ChNumber` varchar(10) NOT NULL,
  `Subtitle` varchar(100) NOT NULL,
  `SourceServer` int(11) NOT NULL,
  `Age` varchar(10) NOT NULL,
  `Rating` varchar(10) NOT NULL,
  `Volume` varchar(10) NOT NULL,
  `Bonus` varchar(10) NOT NULL,
  `Price` varchar(50) NOT NULL,
  `PeriodPrice1` date NOT NULL,
  `PeriodPrice2` date NOT NULL,
  `PeriodPriceUnlimited` varchar(2) NOT NULL,
  `PeriodService1` date NOT NULL,
  `PeriodService2` date NOT NULL,
  `PeriodServiceUnlimited` varchar(2) NOT NULL,
  `IPGTime` varchar(10) NOT NULL,
  `IPGTID` int(11) NOT NULL,
  `Status` varchar(10) NOT NULL,
  `Genre` varchar(100) NOT NULL,
  `Category1` varchar(100) NOT NULL,
  `Category2` varchar(100) NOT NULL,
  `Category3` varchar(100) NOT NULL,
  `Category4` varchar(100) NOT NULL,
  `Category5` varchar(100) NOT NULL,
  `Comments` text NOT NULL,
  `Registration_date` datetime NOT NULL,
  `favorite` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `channel_audio`
--


--
-- Table structure for table `channel_history`
--

CREATE TABLE `channel_history` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `SettopName` varchar(100) NOT NULL,
  `NickName` varchar(50) NOT NULL,
  `TariffTID` int(11) NOT NULL,
  `TariffName` varchar(100) NOT NULL,
  `ChannelTID` int(11) NOT NULL,
  `BroadCastingType` varchar(10) NOT NULL,
  `MetadataTitle` varchar(100) DEFAULT NULL,
  `Price` float DEFAULT '0',
  `UserIP` varchar(20) NOT NULL,
  `UserMAC` varchar(100) NOT NULL,
  `ServerTID` int(11) NOT NULL,
  `ServerNickName` varchar(100) NOT NULL,
  `ViewDateTime` datetime NOT NULL,
  PRIMARY KEY (`TID`),
  UNIQUE KEY `ServerCount` (`ServerTID`,`ViewDateTime`),
  KEY `SettopName` (`SettopName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `channel_history`
--


--
-- Table structure for table `channel_live`
--

CREATE TABLE `channel_live` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `ChName` varchar(100) NOT NULL,
  `ChNumber` varchar(10) NOT NULL,
  `Subtitle` varchar(100) NOT NULL,
  `SourceServer` int(11) NOT NULL,
  `Age` varchar(10) NOT NULL,
  `Rating` varchar(10) NOT NULL,
  `Volume` varchar(10) NOT NULL,
  `Bonus` varchar(10) NOT NULL,
  `Price` varchar(50) NOT NULL,
  `PeriodPrice1` date NOT NULL,
  `PeriodPrice2` date NOT NULL,
  `PeriodPriceUnlimited` varchar(2) NOT NULL,
  `PeriodService1` date NOT NULL,
  `PeriodService2` date NOT NULL,
  `PeriodServiceUnlimited` varchar(2) NOT NULL,
  `IPGTime` varchar(10) NOT NULL,
  `IPGTID` int(11) NOT NULL,
  `Status` varchar(10) NOT NULL,
  `Genre` varchar(100) NOT NULL,
  `Category1` varchar(100) NOT NULL,
  `Category2` varchar(100) NOT NULL,
  `Category3` varchar(100) NOT NULL,
  `Category4` varchar(100) NOT NULL,
  `Category5` varchar(100) NOT NULL,
  `Comments` text NOT NULL,
  `Registration_date` datetime NOT NULL,
  `favorite` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `channel_live`
--


--
-- Table structure for table `channel_vod`
--

CREATE TABLE `channel_vod` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `ChName` varchar(100) NOT NULL,
  `Subtitle` varchar(100) NOT NULL,
  `SourceServer` int(11) NOT NULL,
  `Age` varchar(10) NOT NULL,
  `Rating` varchar(10) NOT NULL,
  `Volume` varchar(10) NOT NULL,
  `Bonus` varchar(10) NOT NULL,
  `Price` varchar(50) NOT NULL,
  `PeriodPrice1` date NOT NULL,
  `PeriodPrice2` date NOT NULL,
  `PeriodPriceUnlimited` varchar(2) NOT NULL,
  `PeriodService1` date NOT NULL,
  `PeriodService2` date NOT NULL,
  `PeriodServiceUnlimited` varchar(2) NOT NULL,
  `IPGTime` varchar(10) NOT NULL,
  `IPGTID` int(11) NOT NULL,
  `Status` varchar(10) NOT NULL,
  `Genre` varchar(100) NOT NULL,
  `Category1` varchar(100) NOT NULL,
  `Category2` varchar(100) NOT NULL,
  `Category3` varchar(100) NOT NULL,
  `Category4` varchar(100) NOT NULL,
  `Category5` varchar(100) NOT NULL,
  `Comments` text NOT NULL,
  `Registration_date` datetime NOT NULL,
  `favorite` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `channel_vod`
--


--
-- Table structure for table `ipg_epg`
--

CREATE TABLE `ipg_epg` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `IPGName` varchar(100) NOT NULL,
  `ServerTID` int(11) NOT NULL,
  `Status` varchar(10) NOT NULL,
  `Picturename` text NOT NULL,
  `Registration_Date` datetime NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ipg_epg`
--


--
-- Table structure for table `ipg_epg_program`
--

CREATE TABLE `ipg_epg_program` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `IPGTID` int(11) NOT NULL,
  `PName` varchar(100) NOT NULL,
  `StartTime` datetime NOT NULL,
  `EndTime` datetime NOT NULL,
  `Description` text NOT NULL,
  `Registration_Date` datetime NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ipg_epg_program`
--


--
-- Table structure for table `member_authority`
--

CREATE TABLE `member_authority` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `MemberTID` int(11) NOT NULL,
  `ProgramName` varchar(100) NOT NULL,
  `Authority` varchar(1) NOT NULL,
  PRIMARY KEY (`TID`),
  KEY `MemberTID` (`MemberTID`,`ProgramName`)
) ENGINE=MyISAM AUTO_INCREMENT=1075 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `member_authority`
--

INSERT INTO `member_authority` VALUES (846,1011,'Middleware - Setup for Management Server','0'),(845,1011,'Middleware - Option','0'),(844,1011,'Middleware - Authority Initialize','0'),(843,1011,'Middleware - Administrator Accounts','0'),(842,1011,'Middleware - Default Settings','0'),(841,1011,'Middleware - SMS','0'),(840,1011,'Middleware - Playlist Creation','0'),(839,1011,'Middleware - IPG(EPG)','0'),(838,1011,'Middleware - Category','0'),(837,1011,'Middleware - Stream Servers','0'),(836,1011,'Middleware - News Setup','0'),(835,1011,'Middleware - Notice Setup','0'),(834,1011,'Middleware - Set-Top Control','0'),(1067,1000,'Middleware - SMS','1'),(1066,1000,'Middleware - Setup for Management Server','1'),(1065,1000,'Middleware - Set-Top Setting','1'),(1064,1000,'Middleware - Set-Top Control','1'),(1063,1000,'Middleware - Service Packages','1'),(1062,1000,'Middleware - Playlist Creation','1'),(1061,1000,'Middleware - Option','1'),(1060,1000,'Middleware - Notice Setup','1'),(1059,1000,'Middleware - News Setup','1'),(1058,1000,'Middleware - Live Channels','1'),(1057,1000,'Middleware - IPG(EPG)','1'),(1056,1000,'Middleware - Default Settings','1'),(1055,1000,'Middleware - DB Initialize','1'),(1054,1000,'Middleware - Category','1'),(833,1011,'Middleware - Set-Top Setting','0'),(832,1011,'Middleware - Tariffs Packages','0'),(831,1011,'Middleware - Service Packages','0'),(830,1011,'Middleware - Audio Channels','0'),(829,1011,'Middleware - VoD Channels','0'),(573,0,'Middleware - Live Channels','1'),(574,0,'Middleware - VoD Channels','1'),(575,0,'Middleware - Audio Channels','1'),(576,0,'Middleware - Service Packages','1'),(577,0,'Middleware - Tariffs Packages','1'),(578,0,'Middleware - Set-Top Setting','1'),(579,0,'Middleware - Set-Top Control','1'),(580,0,'Middleware - Notice Setup','1'),(581,0,'Middleware - News Setup','1'),(582,0,'Middleware - Stream Servers','1'),(583,0,'Middleware - Category','1'),(584,0,'Middleware - IPG(EPG)','1'),(585,0,'Middleware - Playlist Creation','1'),(586,0,'Middleware - SMS','1'),(587,0,'Middleware - Default Settings','1'),(588,0,'Middleware - Administrator Accounts','1'),(589,0,'Middleware - Authority Initialize','1'),(590,0,'Statistics - Rating','1'),(591,0,'Statistics - Set-Top Box','1'),(592,0,'Statistics - Stream Server','1'),(593,0,'Statistics - Total Count','1'),(594,0,'Middleware - Live Channels','0'),(595,0,'Middleware - VoD Channels','0'),(596,0,'Middleware - Audio Channels','0'),(597,0,'Middleware - Service Packages','0'),(598,0,'Middleware - Tariffs Packages','0'),(599,0,'Middleware - Set-Top Setting','0'),(600,0,'Middleware - Set-Top Control','0'),(601,0,'Middleware - Notice Setup','0'),(602,0,'Middleware - News Setup','0'),(603,0,'Middleware - Stream Servers','0'),(604,0,'Middleware - Category','0'),(605,0,'Middleware - IPG(EPG)','0'),(606,0,'Middleware - Playlist Creation','0'),(607,0,'Middleware - SMS','0'),(608,0,'Middleware - Default Settings','0'),(609,0,'Middleware - Administrator Accounts','0'),(610,0,'Middleware - Authority Initialize','0'),(611,0,'Statistics - Rating','0'),(612,0,'Statistics - Set-Top Box','0'),(613,0,'Statistics - Stream Server','0'),(614,0,'Statistics - Total Count','0'),(615,0,'Middleware - Live Channels','0'),(616,0,'Middleware - VoD Channels','0'),(617,0,'Middleware - Audio Channels','0'),(618,0,'Middleware - Service Packages','0'),(619,0,'Middleware - Tariffs Packages','0'),(620,0,'Middleware - Set-Top Setting','0'),(621,0,'Middleware - Set-Top Control','0'),(622,0,'Middleware - Notice Setup','0'),(623,0,'Middleware - News Setup','0'),(624,0,'Middleware - Stream Servers','0'),(625,0,'Middleware - Category','0'),(626,0,'Middleware - IPG(EPG)','0'),(627,0,'Middleware - Playlist Creation','0'),(628,0,'Middleware - SMS','0'),(629,0,'Middleware - Default Settings','0'),(630,0,'Middleware - Administrator Accounts','0'),(631,0,'Middleware - Authority Initialize','0'),(632,0,'Statistics - Rating','0'),(633,0,'Statistics - Set-Top Box','0'),(634,0,'Statistics - Stream Server','0'),(635,0,'Statistics - Total Count','0'),(1053,1000,'Middleware - Authority Initialize','1'),(828,1011,'Middleware - Live Channels','0'),(1052,1000,'Middleware - Audio Channels','1'),(1051,1000,'Middleware - App Channels','1'),(1050,1000,'Middleware - Administrator Accounts','1'),(847,1011,'Middleware - DB Initialize','0'),(848,1011,'Statistics - Rating','1'),(849,1011,'Statistics - Set-Top Box','1'),(850,1011,'Statistics - Stream Server','1'),(851,1011,'Statistics - Total Count','1'),(1074,1000,'Statistics - Total Count','1'),(1073,1000,'Statistics - Stream Server','1'),(1072,1000,'Statistics - Set-Top Box','1'),(1071,1000,'Statistics - Rating','1'),(1070,1000,'Middleware - VoD Channels','1'),(1068,1000,'Middleware - Stream Servers','1'),(1069,1000,'Middleware - Tariffs Packages','1');

--
-- Table structure for table `member_authority_init`
--

CREATE TABLE `member_authority_init` (
  `TID` int(10) NOT NULL AUTO_INCREMENT,
  `ProgramName` varchar(100) NOT NULL,
  UNIQUE KEY `TID` (`TID`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `member_authority_init`
--

INSERT INTO `member_authority_init` VALUES (1,'Middleware - Live Channels'),(2,'Middleware - VoD Channels'),(3,'Middleware - Audio Channels'),(4,'Middleware - Service Packages'),(5,'Middleware - Tariffs Packages'),(6,'Middleware - Set-Top Setting'),(7,'Middleware - Set-Top Control'),(8,'Middleware - Notice Setup'),(9,'Middleware - News Setup'),(10,'Middleware - Stream Servers'),(11,'Middleware - Category'),(12,'Middleware - IPG(EPG)'),(13,'Middleware - Playlist Creation'),(14,'Middleware - SMS'),(15,'Middleware - Default Settings'),(16,'Middleware - Administrator Accounts'),(21,'Statistics - Rating'),(22,'Statistics - Set-Top Box'),(23,'Statistics - Stream Server'),(24,'Statistics - Total Count'),(17,'Middleware - Authority Initialize'),(18,'Middleware - Option'),(19,'Middleware - Setup for Management Server'),(20,'Middleware - DB Initialize'),(26,'Middleware - App Channels');

--
-- Table structure for table `member_log`
--

CREATE TABLE `member_log` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `MemberTID` int(11) NOT NULL,
  `ProgramName` varchar(100) NOT NULL,
  `Working` varchar(200) NOT NULL,
  `RegDate` datetime NOT NULL,
  PRIMARY KEY (`TID`),
  KEY `MemberTID` (`MemberTID`,`RegDate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `member_log`
--


--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `NewsName` varchar(100) NOT NULL,
  `NewsType` varchar(10) NOT NULL,
  `NewsURL` varchar(255) NOT NULL,
  `MustWatch` varchar(10) NOT NULL,
  `TariffPlan` varchar(100) NOT NULL,
  `PeriodService1` date NOT NULL,
  `PeriodService2` date NOT NULL,
  `Status` varchar(10) NOT NULL,
  `Category1` varchar(100) NOT NULL,
  `Category2` varchar(100) NOT NULL,
  `Category3` varchar(100) NOT NULL,
  `Category4` varchar(100) NOT NULL,
  `Category5` varchar(100) NOT NULL,
  `Message` text NOT NULL,
  `Registration_Date` datetime NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `news`
--


--
-- Table structure for table `notice`
--

CREATE TABLE `notice` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `NoticeName` varchar(100) NOT NULL,
  `NoticeType` varchar(10) NOT NULL,
  `NoticeURL` varchar(255) NOT NULL,
  `MustWatch` varchar(10) NOT NULL,
  `TariffPlan` varchar(100) NOT NULL,
  `PeriodService1` date NOT NULL,
  `PeriodService2` date NOT NULL,
  `Status` varchar(10) NOT NULL,
  `Category1` varchar(100) NOT NULL,
  `Category2` varchar(100) NOT NULL,
  `Category3` varchar(100) NOT NULL,
  `Category4` varchar(100) NOT NULL,
  `Category5` varchar(100) NOT NULL,
  `Message` text NOT NULL,
  `Registration_Date` datetime NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notice`
--


--
-- Table structure for table `playlist`
--

CREATE TABLE `playlist` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `PlayName` varchar(100) NOT NULL,
  `URL` varchar(255) NOT NULL,
  `Registration_Date` datetime NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `playlist`
--


--
-- Table structure for table `playlist_url`
--

CREATE TABLE `playlist_url` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `PTID` int(11) NOT NULL,
  `PSort` int(11) NOT NULL,
  `URL` text NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `playlist_url`
--


--
-- Table structure for table `service_packages`
--

CREATE TABLE `service_packages` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `EID` varchar(100) NOT NULL,
  `PName` varchar(100) NOT NULL,
  `Service` varchar(10) NOT NULL,
  `Status` varchar(10) NOT NULL,
  `All_Services` varchar(2) NOT NULL,
  `Registration_Date` datetime NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `service_packages`
--


--
-- Table structure for table `service_packages_selected`
--

CREATE TABLE `service_packages_selected` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `ETID` int(11) NOT NULL,
  `Service` varchar(10) NOT NULL,
  `ChannelTID` int(11) NOT NULL,
  `ChannelName` varchar(100) NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `service_packages_selected`
--


--
-- Table structure for table `settop_control`
--

CREATE TABLE `settop_control` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `SettopName` varchar(50) NOT NULL,
  `ControlType` varchar(50) NOT NULL,
  `TTL` varchar(10) NOT NULL,
  `Message` text NOT NULL,
  `PlayChannel` varchar(100) NOT NULL,
  `Registration_Date` datetime NOT NULL,
  `ViewCheck` int(11) NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settop_control`
--


--
-- Table structure for table `sms`
--

CREATE TABLE `sms` (
  `Status` varchar(10) NOT NULL,
  `AutoServer` int(11) NOT NULL,
  `SendAdmin` int(11) NOT NULL,
  `SendServer` int(11) NOT NULL,
  `Start_H` int(11) NOT NULL,
  `Start_M` int(11) NOT NULL,
  `Start_S` int(11) NOT NULL,
  `End_H` int(11) NOT NULL,
  `End_M` int(11) NOT NULL,
  `End_S` int(11) NOT NULL,
  `IntervalTime` int(11) NOT NULL,
  `ActiveMsg` varchar(255) NOT NULL,
  `InactiveMsg` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sms`
--


--
-- Table structure for table `sms_log`
--

CREATE TABLE `sms_log` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `ServerName` varchar(100) NOT NULL,
  `Status` varchar(10) NOT NULL,
  `Registration` datetime NOT NULL,
  UNIQUE KEY `TID` (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sms_log`
--


--
-- Table structure for table `stream_server`
--

CREATE TABLE `stream_server` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `ChannelName` varchar(255) NOT NULL,
  `BroadcastingType` varchar(50) NOT NULL,
  `Resolution` varchar(10) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `LoadBalancing` varchar(2) NOT NULL,
  `MaxBitRate` varchar(10) NOT NULL,
  `MaxSession` varchar(10) NOT NULL,
  `Status` varchar(20) NOT NULL,
  `Functions` varchar(255) NOT NULL,
  `Formats` varchar(255) NOT NULL,
  `Comments` varchar(255) NOT NULL,
  `Author` varchar(100) NOT NULL,
  `Copyright` varchar(100) NOT NULL,
  `Producer` varchar(100) NOT NULL,
  `LeadingActor` varchar(100) NOT NULL,
  `SupportingActor` varchar(100) NOT NULL,
  `Opening` varchar(255) NOT NULL,
  `SubtitlesActivated` varchar(10) NOT NULL,
  `Description` text NOT NULL,
  `ScreeningTime` varchar(100) NOT NULL,
  `Keyword` varchar(100) NOT NULL,
  `Lending` varchar(100) NOT NULL,
  `Duration` varchar(100) NOT NULL,
  `Dimensions` varchar(20) NOT NULL,
  `VideoFormats` varchar(50) NOT NULL,
  `Subtitlefile` text NOT NULL,
  `Registration_date` datetime NOT NULL,
  `SmsCheck` int(11) NOT NULL,
  `thumbnail1` varchar(255) NOT NULL,
  `thumbnail2` varchar(255) NOT NULL,
  `thumbnail3` varchar(255) NOT NULL,
  `thumbnail4` varchar(255) NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stream_server`
--


--
-- Table structure for table `stream_server_load`
--

CREATE TABLE `stream_server_load` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `ServerTID` int(11) NOT NULL,
  `URL` text NOT NULL,
  `Priority` int(11) NOT NULL,
  `Device` varchar(100) NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stream_server_load`
--


--
-- Table structure for table `tariff_plan`
--

CREATE TABLE `tariff_plan` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `EID` varchar(100) NOT NULL,
  `PName` varchar(100) NOT NULL,
  `Status` varchar(10) NOT NULL,
  `UseDefault` varchar(2) NOT NULL,
  `Registration_Date` datetime NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tariff_plan`
--


--
-- Table structure for table `tariff_plan_selected`
--

CREATE TABLE `tariff_plan_selected` (
  `TID` int(11) NOT NULL AUTO_INCREMENT,
  `ETID` int(11) NOT NULL,
  `ChannelTID` int(11) NOT NULL,
  `ChannelName` varchar(100) NOT NULL,
  PRIMARY KEY (`TID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tariff_plan_selected`
--


--
-- Table structure for table `type_device`
--

CREATE TABLE `type_device` (
  `Code` varchar(50) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Registration` datetime NOT NULL,
  PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `type_device`
--


--
-- Table structure for table `type_genre`
--

CREATE TABLE `type_genre` (
  `Code` varchar(50) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Registration` datetime NOT NULL,
  PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `type_genre`
--


--
-- Table structure for table `type_language`
--

CREATE TABLE `type_language` (
  `Code` varchar(50) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Registration` datetime NOT NULL,
  PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `type_language`
--


--
-- Table structure for table `type_stb_group`
--

CREATE TABLE `type_stb_group` (
  `Code` varchar(50) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Registration` datetime NOT NULL,
  PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `type_stb_group`
--



