1 DROP TABLE IF EXISTS `batches`;
2 CREATE TABLE `batches` (
3 `id` int(11) NOT NULL auto_increment,
4 `name` varchar(50) NOT NULL default '',
5 `last_update` int(11) NOT NULL default '0',
6 `message` text NOT NULL,
7 `abort_message` text NOT NULL,
9 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11 DROP TABLE IF EXISTS `channels`;
12 CREATE TABLE `channels` (
13 `id` int(11) NOT NULL auto_increment,
14 `display_name` varchar(100) NOT NULL default '',
15 `xmltvid` varchar(100) NOT NULL default '',
16 `chgroup` varchar(100) NOT NULL,
17 `grabber` varchar(20) NOT NULL default '',
18 `export` tinyint(1) NOT NULL default '0',
19 `grabber_info` varchar(100) NOT NULL default '',
20 `logo` tinyint(4) NOT NULL default '0',
21 `def_pty` varchar(20) default '',
22 `def_cat` varchar(20) default '',
23 `sched_lang` varchar(4) NOT NULL default '',
24 `empty_ok` tinyint(1) NOT NULL default '0',
25 `url` varchar(100) default NULL,
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29 DROP TABLE IF EXISTS `channelgroups`;
30 CREATE TABLE `channelgroups` (
31 `abr` varchar(24) character set latin1 NOT NULL,
32 `display_name` varchar(100) character set latin1 NOT NULL,
33 `position` tinyint(10) unsigned NOT NULL,
34 `sortby` varchar(32) NOT NULL,
35 `hidden` tinyint(1) NOT NULL default '0'
36 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38 DROP TABLE IF EXISTS `files`;
39 CREATE TABLE `files` (
40 `id` int(11) NOT NULL auto_increment,
41 `channelid` int(11) NOT NULL default '0',
42 `filename` varchar(80) NOT NULL default '',
43 `successful` tinyint(1) default NULL,
44 `message` text NOT NULL,
45 `earliestdate` datetime default NULL,
46 `latestdate` datetime default NULL,
47 `md5sum` varchar(33) NOT NULL default '',
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
51 DROP TABLE IF EXISTS `programs`;
52 CREATE TABLE `programs` (
53 `category` varchar(100) NOT NULL default '',
54 `channel_id` int(11) NOT NULL default '0',
55 `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
56 `end_time` datetime default '0000-00-00 00:00:00',
57 `schedule_id` varchar(100) NOT NULL,
58 `title_id` varchar(100) NOT NULL,
59 `title` varchar(100) NOT NULL default '',
60 `subtitle` mediumtext,
61 `description` mediumtext,
62 `batch_id` int(11) NOT NULL default '0',
63 `program_type` varchar(20) default '',
64 `episode` varchar(20) default NULL,
65 `production_date` date default NULL,
66 `aspect` enum('unknown','4:3','16:9') NOT NULL default 'unknown',
67 `stereo` varchar(40) NOT NULL,
68 `rating` varchar(20) NOT NULL,
69 `directors` text NOT NULL,
70 `actors` text NOT NULL,
71 `writers` text NOT NULL,
72 `adapters` text NOT NULL,
73 `producers` text NOT NULL,
74 `presenters` text NOT NULL,
75 `commentators` text NOT NULL,
76 `guests` text NOT NULL,
77 `url` varchar(100) default NULL,
78 `url_image_main` varchar(100) default NULL,
79 `url_image_thumbnail` varchar(100) default NULL,
80 `url_image_icon` varchar(100) default NULL,
81 PRIMARY KEY (`channel_id`,`start_time`),
82 KEY `channel_id` (`channel_id`,`start_time`),
83 KEY `batch` (`batch_id`,`start_time`)
84 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
86 DROP TABLE IF EXISTS `state`;
87 CREATE TABLE `state` (
88 `name` varchar(60) NOT NULL default '',
91 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
93 DROP TABLE IF EXISTS `trans_cat`;
94 CREATE TABLE `trans_cat` (
95 `type` varchar(20) NOT NULL default '',
96 `original` varchar(50) NOT NULL default '',
97 `category` varchar(20) default '',
98 `program_type` varchar(50) default '',
99 PRIMARY KEY (`type`,`original`)
100 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
102 DROP TABLE IF EXISTS `languagestrings`;
103 CREATE TABLE `languagestrings` (
104 `module` varchar(32) NOT NULL default '',
105 `strname` varchar(32) NOT NULL default '',
106 `strvalue` text NOT NULL,
107 `language` varchar(4) NOT NULL default ''
108 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
110 DROP TABLE IF EXISTS `admins`;
111 CREATE TABLE `admins` (
112 `username` varchar(32) NOT NULL,
113 `password` varchar(32) NOT NULL
114 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
115 INSERT INTO `admins` (username, password) VALUES (`nonametv`, ``);
117 DROP TABLE IF EXISTS `epgservers`;
118 CREATE TABLE `epgservers` (
119 `id` int(11) NOT NULL auto_increment,
120 `active` tinyint(4) NOT NULL default '0',
121 `name` varchar(100) NOT NULL default '',
122 `description` varchar(100) NOT NULL default '',
123 `vendor` varchar(100) NOT NULL default '',
124 `type` varchar(100) NOT NULL default '',
126 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
128 DROP TABLE IF EXISTS `networks`;
129 CREATE TABLE `networks` (
130 `id` int(11) NOT NULL auto_increment,
131 `epgserver` int(11) NOT NULL,
132 `active` tinyint(4) NOT NULL default '0',
133 `name` varchar(100) NOT NULL default '',
134 `operator` varchar(100) NOT NULL default '',
135 `description` varchar(100) NOT NULL default '',
136 `charset` varchar(100) NOT NULL default '',
138 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
140 DROP TABLE IF EXISTS `transportstreams`;
141 CREATE TABLE `transportstreams` (
142 `id` int(11) NOT NULL,
143 `network` int(11) NOT NULL,
144 `active` int(11) NOT NULL,
145 `description` varchar(256) NOT NULL,
146 `muxmainprotocol` int(11) NOT NULL,
147 `eitmaxbw` int(11) NOT NULL,
148 `simaxbw` int(11) NOT NULL,
149 `dsystype` int(11) NOT NULL,
150 `dsysfrequency` int(11) NOT NULL,
151 `dsysmodulationschemeid` int(11) NOT NULL,
152 `dsysfecouterschemeid` int(11) NOT NULL,
153 `dsysfecinnerschemeid` int(11) NOT NULL,
154 `dsyssymbolrate` int(11) NOT NULL,
156 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
158 DROP TABLE IF EXISTS `services`;
159 CREATE TABLE `services` (
160 `id` int(11) NOT NULL,
161 `transportstream` int(11) NOT NULL,
162 `active` int(11) NOT NULL,
163 `serviceid` int(11) NOT NULL,
164 `servicename` varchar(256) NOT NULL,
165 `logicalchannelnumber` int(11) NOT NULL,
166 `description` varchar(256) NOT NULL,
167 `nvod` int(11) NOT NULL,
168 `servicetypeid` int(11) NOT NULL,
169 `dbchid` int(11) NOT NULL,
171 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;