1 |
drop table foltia_program ; |
---|
2 |
|
---|
3 |
create table foltia_program ( |
---|
4 |
tid int8 PRIMARY KEY, |
---|
5 |
title text , |
---|
6 |
startweektype text, |
---|
7 |
starttime text, |
---|
8 |
lengthmin int8, |
---|
9 |
firstlight text, |
---|
10 |
officialuri text , |
---|
11 |
aspect int8 , |
---|
12 |
psp int8 , |
---|
13 |
transfer text, |
---|
14 |
PSPdirname text |
---|
15 |
); |
---|
16 |
create unique index foltia_program_tid_index on foltia_program (tid); |
---|
17 |
|
---|
18 |
REVOKE ALL on "foltia_program" from PUBLIC; |
---|
19 |
GRANT UPDATE,SELECT,INSERT on "foltia_program" to "foltia"; |
---|
20 |
|
---|
21 |
drop table foltia_subtitle ; |
---|
22 |
|
---|
23 |
create table foltia_subtitle ( |
---|
24 |
pid int8 PRIMARY KEY, |
---|
25 |
tid int8, |
---|
26 |
stationid int8, |
---|
27 |
countno int8, |
---|
28 |
subtitle text, |
---|
29 |
startdatetime int8, |
---|
30 |
enddatetime int8, |
---|
31 |
startoffset int8, |
---|
32 |
lengthmin int8, |
---|
33 |
m2pfilename text , |
---|
34 |
PSPfilename text |
---|
35 |
); |
---|
36 |
create unique index foltia_subtitle_pid_index on foltia_subtitle (pid); |
---|
37 |
create index foltia_subtitle_tid_index on foltia_subtitle (tid); |
---|
38 |
create index foltia_subtitle_stationid_index on foltia_subtitle (stationid); |
---|
39 |
create index foltia_subtitle_enddatetime_index on foltia_subtitle (enddatetime); |
---|
40 |
create index foltia_subtitle_startdatetime_index on foltia_subtitle (startdatetime); |
---|
41 |
|
---|
42 |
REVOKE ALL on "foltia_subtitle" from PUBLIC; |
---|
43 |
GRANT UPDATE,SELECT,INSERT on "foltia_subtitle" to "foltia"; |
---|
44 |
|
---|
45 |
drop table foltia_tvrecord; |
---|
46 |
create table foltia_tvrecord ( |
---|
47 |
tid int8, |
---|
48 |
stationid int8, |
---|
49 |
bitrate int8 |
---|
50 |
); |
---|
51 |
create index foltia_tvrecord_tid_index on foltia_tvrecord (tid); |
---|
52 |
|
---|
53 |
REVOKE ALL on "foltia_tvrecord" from PUBLIC; |
---|
54 |
GRANT ALL on "foltia_tvrecord" to "foltia"; |
---|
55 |
|
---|
56 |
|
---|
57 |
drop table foltia_epg; |
---|
58 |
create table foltia_epg ( |
---|
59 |
epgid int8, |
---|
60 |
startdatetime int8, |
---|
61 |
enddatetime int8, |
---|
62 |
lengthmin int8 , |
---|
63 |
ontvchannel text, |
---|
64 |
epgtitle text, |
---|
65 |
epgdesc text, |
---|
66 |
epgcategory text |
---|
67 |
); |
---|
68 |
create index foltia_epg_startdatetime_index on foltia_epg (startdatetime); |
---|
69 |
create index foltia_epg_enddatetime_index on foltia_epg (enddatetime); |
---|
70 |
create index foltia_epg_ontvchannel_index on foltia_epg (ontvchannel); |
---|
71 |
|
---|
72 |
REVOKE ALL on "foltia_epg" from PUBLIC; |
---|
73 |
GRANT ALL on "foltia_epg" to "foltia"; |
---|
74 |
|
---|
75 |
drop table foltia_m2pfiles; |
---|
76 |
create table foltia_m2pfiles ( |
---|
77 |
m2pfilename text |
---|
78 |
); |
---|
79 |
REVOKE ALL on "foltia_m2pfiles" from PUBLIC; |
---|
80 |
GRANT ALL on "foltia_m2pfiles" to "foltia"; |
---|
81 |
|
---|
82 |
drop table foltia_mp4files; |
---|
83 |
create table foltia_mp4files ( |
---|
84 |
tid int8, |
---|
85 |
mp4filename text |
---|
86 |
); |
---|
87 |
REVOKE ALL on "foltia_mp4files" from PUBLIC; |
---|
88 |
GRANT ALL on "foltia_mp4files" to "foltia"; |
---|
89 |
|
---|
90 |
drop table foltia_station; |
---|
91 |
CREATE TABLE foltia_station ( |
---|
92 |
stationid bigint NOT NULL, |
---|
93 |
stationname text, |
---|
94 |
stationrecch bigint, |
---|
95 |
stationcallsign text, |
---|
96 |
stationuri text, |
---|
97 |
tunertype text, |
---|
98 |
tunerch text, |
---|
99 |
device text, |
---|
100 |
ontvcode text |
---|
101 |
); |
---|
102 |
REVOKE ALL on "foltia_station" from PUBLIC; |
---|
103 |
GRANT ALL on "foltia_station" to "foltia"; |
---|
104 |
|
---|
105 |
-- |
---|
106 |
-- PostgreSQL database dump |
---|
107 |
-- |
---|
108 |
|
---|
109 |
SET client_encoding = 'EUC_JP'; |
---|
110 |
SET check_function_bodies = false; |
---|
111 |
|
---|
112 |
SET SESSION AUTHORIZATION 'foltia'; |
---|
113 |
|
---|
114 |
SET search_path = public, pg_catalog; |
---|
115 |
|
---|
116 |
-- |
---|
117 |
-- TOC entry 3 (OID 17158) |
---|
118 |
-- Name: foltia_station; Type: TABLE; Schema: public; Owner: foltia |
---|
119 |
-- |
---|
120 |
|
---|
121 |
-- |
---|
122 |
-- TOC entry 4 (OID 17158) |
---|
123 |
-- Name: foltia_station; Type: ACL; Schema: public; Owner: foltia |
---|
124 |
-- |
---|
125 |
|
---|
126 |
|
---|
127 |
SET SESSION AUTHORIZATION 'foltia'; |
---|
128 |
|
---|
129 |
-- |
---|
130 |
-- Data for TOC entry 6 (OID 17158) |
---|
131 |
-- Name: foltia_station; Type: TABLE DATA; Schema: public; Owner: foltia |
---|
132 |
-- |
---|
133 |
INSERT INTO foltia_program VALUES (0, 'EPG録画', '', '', NULL, '', '', 3, 1, '', ''); |
---|
134 |
INSERT INTO foltia_tvrecord VALUES (0,0,5); |
---|
135 |
|
---|
136 |
INSERT INTO foltia_station VALUES (1, 'NHK総合', 1, 'NHK', '', NULL, NULL, NULL, '0031.ontvjapan.com'); |
---|
137 |
INSERT INTO foltia_station VALUES (3, 'NHK教育', 3, 'ETV', '', NULL, NULL, NULL, '0041.ontvjapan.com'); |
---|
138 |
INSERT INTO foltia_station VALUES (4, '日本テレビ', 4, 'NTV', '', NULL, NULL, NULL, '0004.ontvjapan.com'); |
---|
139 |
INSERT INTO foltia_station VALUES (6, 'TBS', 6, 'TBS', '', NULL, NULL, NULL, '0005.ontvjapan.com'); |
---|
140 |
INSERT INTO foltia_station VALUES (8, 'フジテレビ', 8, 'CX', '', NULL, NULL, NULL, '0006.ontvjapan.com'); |
---|
141 |
INSERT INTO foltia_station VALUES (10, 'テレビ朝日', 10, 'EX', '', NULL, NULL, NULL, '0007.ontvjapan.com'); |
---|
142 |
INSERT INTO foltia_station VALUES (12, 'テレビ東京', 12, 'TX', '', NULL, NULL, NULL, '0008.ontvjapan.com'); |
---|
143 |
INSERT INTO foltia_station VALUES (422, '東海テレビ', -10, NULL, NULL, NULL, NULL, NULL, NULL); |
---|
144 |
INSERT INTO foltia_station VALUES (42, 'tvk', 5, 'TVK', '', NULL, NULL, NULL, '0009.ontvjapan.com'); |
---|
145 |
INSERT INTO foltia_station VALUES (423, 'ShowTime', -10, NULL, NULL, NULL, NULL, NULL, NULL); |
---|
146 |
INSERT INTO foltia_station VALUES (424, 'メ〜テレ', -10, NULL, NULL, NULL, NULL, NULL, NULL); |
---|
147 |
INSERT INTO foltia_station VALUES (409, 'BS日テレ', 0, '', '', 'b', 'X141', NULL, '3004.ontvjapan.com'); |
---|
148 |
INSERT INTO foltia_station VALUES (384, 'BS朝日', 0, '', '', 'b', 'X151', NULL, '3005.ontvjapan.com'); |
---|
149 |
INSERT INTO foltia_station VALUES (425, '三重テレビ', -10, NULL, NULL, NULL, NULL, NULL, NULL); |
---|
150 |
INSERT INTO foltia_station VALUES (426, '中京テレビ', -10, NULL, NULL, NULL, NULL, NULL, NULL); |
---|
151 |
INSERT INTO foltia_station VALUES (293, 'AT-X', 0, '', '', NULL, NULL, NULL, NULL); |
---|
152 |
INSERT INTO foltia_station VALUES (161, 'BS-i', 0, '', '', 'b', 'X161', NULL, '3006.ontvjapan.com'); |
---|
153 |
INSERT INTO foltia_station VALUES (382, 'BSジャパン', 0, '', '', 'b', 'X171', NULL, '3007.ontvjapan.com'); |
---|
154 |
INSERT INTO foltia_station VALUES (295, 'フジ721', -10, '', '', NULL, NULL, NULL, NULL); |
---|
155 |
INSERT INTO foltia_station VALUES (380, 'スカパー180ch', -10, '', '', NULL, NULL, NULL, NULL); |
---|
156 |
INSERT INTO foltia_station VALUES (427, '岐阜放送', -10, NULL, NULL, NULL, NULL, NULL, NULL); |
---|
157 |
INSERT INTO foltia_station VALUES (428, 'テレビ新広島', -10, NULL, NULL, NULL, NULL, NULL, NULL); |
---|
158 |
INSERT INTO foltia_station VALUES (383, 'サンテレビ', -10, '', '', NULL, NULL, NULL, NULL); |
---|
159 |
INSERT INTO foltia_station VALUES (429, 'CBCテレビ', -10, NULL, NULL, NULL, NULL, NULL, NULL); |
---|
160 |
INSERT INTO foltia_station VALUES (385, 'TBSチャンネル', 0, '', '', NULL, NULL, NULL, NULL); |
---|
161 |
INSERT INTO foltia_station VALUES (386, 'テレ朝チャンネル', 0, '', '', NULL, NULL, NULL, NULL); |
---|
162 |
INSERT INTO foltia_station VALUES (389, 'BS Japan', 0, '', '', 'b', 'X171', NULL, NULL); |
---|
163 |
INSERT INTO foltia_station VALUES (390, 'サンテレビジョン', -10, '', '', NULL, NULL, NULL, NULL); |
---|
164 |
INSERT INTO foltia_station VALUES (0, '[全局]', 0, NULL, NULL, NULL, NULL, NULL, NULL); |
---|
165 |
INSERT INTO foltia_station VALUES (392, 'スカパー183ch', 0, '', '', NULL, NULL, NULL, NULL); |
---|
166 |
INSERT INTO foltia_station VALUES (393, 'BSQR 489', -10, '', '', 'b', 'X489', NULL, NULL); |
---|
167 |
INSERT INTO foltia_station VALUES (394, 'スカパー160ch', -10, '', '', NULL, NULL, NULL, NULL); |
---|
168 |
INSERT INTO foltia_station VALUES (396, 'KBS京都', -10, '', '', NULL, NULL, NULL, NULL); |
---|
169 |
INSERT INTO foltia_station VALUES (398, 'テレビ大阪', -10, '', '', NULL, NULL, NULL, NULL); |
---|
170 |
INSERT INTO foltia_station VALUES (399, 'ABCテレビ', -10, '', '', NULL, NULL, NULL, NULL); |
---|
171 |
INSERT INTO foltia_station VALUES (400, 'なし', -10, '', '', NULL, NULL, NULL, NULL); |
---|
172 |
INSERT INTO foltia_station VALUES (402, '関西テレビ', -10, '', '', NULL, NULL, NULL, NULL); |
---|
173 |
INSERT INTO foltia_station VALUES (406, 'MBS毎日放送', -10, '', '', NULL, NULL, NULL, NULL); |
---|
174 |
INSERT INTO foltia_station VALUES (407, 'animate.tv', -10, '', '', NULL, NULL, NULL, NULL); |
---|
175 |
INSERT INTO foltia_station VALUES (410, 'テレビ愛知', -10, '', '', NULL, NULL, NULL, NULL); |
---|
176 |
INSERT INTO foltia_station VALUES (411, 'インターネット', -10, '', '', NULL, NULL, NULL, NULL); |
---|
177 |
INSERT INTO foltia_station VALUES (381, 'BSフジ', 0, '', '', 'b', 'X181', NULL, '3008.ontvjapan.com'); |
---|
178 |
INSERT INTO foltia_station VALUES (413, 'よみうりテレビ', -10, '', '', NULL, NULL, NULL, NULL); |
---|
179 |
INSERT INTO foltia_station VALUES (414, 'LFX488', -10, '', '', NULL, NULL, NULL, NULL); |
---|
180 |
INSERT INTO foltia_station VALUES (415, 'LFX', -10, '', '', NULL, NULL, NULL, NULL); |
---|
181 |
INSERT INTO foltia_station VALUES (416, 'LFX BB', -10, '', '', NULL, NULL, NULL, NULL); |
---|
182 |
INSERT INTO foltia_station VALUES (191, 'WOWOW', 0, 'BS5', '', 'b', 'X191', NULL, '3009.ontvjapan.com'); |
---|
183 |
INSERT INTO foltia_station VALUES (419, 'GyaO', -10, '', '', NULL, NULL, NULL, NULL); |
---|
184 |
INSERT INTO foltia_station VALUES (418, '放送大学', 0, 'UAIR', '', NULL, NULL, NULL, '0013.ontvjapan.com'); |
---|
185 |
INSERT INTO foltia_station VALUES (420, 'WOWOW2', 0, NULL, NULL, 'b', 'X192', NULL, '3010.ontvjapan.com'); |
---|
186 |
INSERT INTO foltia_station VALUES (417, 'とちぎテレビ', -10, 'TTV', '', NULL, NULL, NULL, NULL); |
---|
187 |
INSERT INTO foltia_station VALUES (412, '群馬テレビ', -10, 'GTV', '', NULL, NULL, NULL, NULL); |
---|
188 |
INSERT INTO foltia_station VALUES (46, '千葉テレビ', -10, 'CTC', '', NULL, NULL, NULL, NULL); |
---|
189 |
INSERT INTO foltia_station VALUES (38, 'テレビ埼玉', -10, 'TVS', '', NULL, NULL, NULL, NULL); |
---|
190 |
INSERT INTO foltia_station VALUES (14, '東京MXテレビ', 0, 'MX', '', NULL, NULL, NULL, NULL); |
---|
191 |
INSERT INTO foltia_station VALUES (421, 'WOWOW3', 0, NULL, NULL, 'b', 'X193', NULL, '3011.ontvjapan.com'); |
---|
192 |
INSERT INTO foltia_station VALUES (401, 'チャンネルNECO', 0, '', '', 'c', 'X242', NULL, '1008.ontvjapan.com'); |
---|
193 |
INSERT INTO foltia_station VALUES (395, 'カミングスーンTV', 0, '', '', 'c', 'X245', NULL, '1012.ontvjapan.com'); |
---|
194 |
INSERT INTO foltia_station VALUES (408, 'ファミリー劇場', 0, '', '', 'c', 'X254', NULL, '1015.ontvjapan.com'); |
---|
195 |
INSERT INTO foltia_station VALUES (397, 'カートゥーンネットワーク', 0, '', '', 'c', 'X262', NULL, '1046.ontvjapan.com'); |
---|
196 |
INSERT INTO foltia_station VALUES (103, 'NHK-BShi', 0, '', '', 'b', 'X103', '', '3003.ontvjapan.com'); |
---|
197 |
INSERT INTO foltia_station VALUES (101, 'NHK-BS1', 0, 'BS7', '', 'b', 'X101',NULL, '3001.ontvjapan.com'); |
---|
198 |
INSERT INTO foltia_station VALUES (102, 'NHK-BS2', 0, 'BS11', '', 'b', 'X102',NULL, '3002.ontvjapan.com'); |
---|
199 |
INSERT INTO foltia_station VALUES (261, 'キッズステーション', 0, '', '', 'c', 'X264', '', '1045.ontvjapan.com'); |
---|
200 |
INSERT INTO foltia_station VALUES (263, 'アニマックス', 0, '', '', 'c', 'X263', '', '1047.ontvjapan.com'); |
---|
201 |
|
---|
202 |
|
---|
203 |
|
---|
204 |
|
---|
205 |
-- |
---|
206 |
-- TOC entry 5 (OID 17163) |
---|
207 |
-- Name: foltia_station_pkey; Type: CONSTRAINT; Schema: public; Owner: foltia |
---|
208 |
-- |
---|
209 |
|
---|
210 |
ALTER TABLE ONLY foltia_station |
---|
211 |
ADD CONSTRAINT foltia_station_pkey PRIMARY KEY (stationid); |
---|
212 |
|
---|
213 |
|
---|
214 |
|
---|