mktable.txt

リビジョン 70, 10.1 kB (コミッタ: sorshi, コミット時期: 16 年前)
環境ポリシー機能搭載

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

Note: リポジトリブラウザについてのヘルプは TracBrowser を参照してください。

root/trunk/install/mktable.txt

異なるフォーマットでダウンロード: