Index: trunk/install/perl/updatem2pfiletable.pl =================================================================== --- trunk/install/perl/updatem2pfiletable.pl (リビジョン 57) +++ trunk/install/perl/updatem2pfiletable.pl (リビジョン 69) @@ -43,4 +43,6 @@ # foltia_mp4files +@mp4filelist = `find ${recfolderpath}/ | grep MP4`;#by foltia dev ticket #5 http://www.dcc-jpl.com/foltia/ticket/5 + # ひとまず消す $query = "DELETE FROM foltia_mp4files "; @@ -48,5 +50,4 @@ $sth->execute(); -@mp4filelist = `find ${recfolderpath}/ | grep MP4`;#by foltia dev ticket #5 http://www.dcc-jpl.com/foltia/ticket/5 foreach (@mp4filelist) { Index: trunk/install/mktable.txt =================================================================== --- trunk/install/mktable.txt (リビジョン 46) +++ trunk/install/mktable.txt (リビジョン 69) @@ -45,5 +45,5 @@ drop table foltia_tvrecord; create table foltia_tvrecord ( -tid int8, +tid int8 PRIMARY KEY, stationid int8, bitrate int8 @@ -57,5 +57,5 @@ drop table foltia_epg; create table foltia_epg ( -epgid int8, +epgid int8 PRIMARY KEY, startdatetime int8, enddatetime int8, @@ -90,5 +90,5 @@ drop table foltia_station; CREATE TABLE foltia_station ( - stationid bigint NOT NULL, + stationid bigint PRIMARY KEY, stationname text, stationrecch bigint, @@ -176,5 +176,5 @@ INSERT INTO foltia_station VALUES (411, 'インターネット', -10, '', '', NULL, NULL, NULL, NULL); INSERT INTO foltia_station VALUES (381, 'BSフジ', 0, '', '', 'b', 'X181', NULL, '3008.ontvjapan.com'); -INSERT INTO foltia_station VALUES (413, 'よみうりテレビ', -10, '', '', NULL, NULL, NULL, NULL); +INSERT INTO foltia_station VALUES (413, 'ytv', -10, '', '', NULL, NULL, NULL, NULL); INSERT INTO foltia_station VALUES (414, 'LFX488', -10, '', '', NULL, NULL, NULL, NULL); INSERT INTO foltia_station VALUES (415, 'LFX', -10, '', '', NULL, NULL, NULL, NULL); @@ -186,7 +186,7 @@ INSERT INTO foltia_station VALUES (417, 'とちぎテレビ', -10, 'TTV', '', NULL, NULL, NULL, NULL); INSERT INTO foltia_station VALUES (412, '群馬テレビ', -10, 'GTV', '', NULL, NULL, NULL, NULL); -INSERT INTO foltia_station VALUES (46, '千葉テレビ', -10, 'CTC', '', NULL, NULL, NULL, NULL); -INSERT INTO foltia_station VALUES (38, 'テレビ埼玉', -10, 'TVS', '', NULL, NULL, NULL, NULL); -INSERT INTO foltia_station VALUES (14, '東京MXテレビ', 0, 'MX', '', NULL, NULL, NULL, NULL); +INSERT INTO foltia_station VALUES (46, 'チバテレビ', -10, 'CTC', '', NULL, NULL, NULL, NULL); +INSERT INTO foltia_station VALUES (38, 'テレ玉', -10, 'TVS', '', NULL, NULL, NULL, NULL); +INSERT INTO foltia_station VALUES (14, 'TOKYO MX', 0, 'MX', '', NULL, NULL, NULL, NULL); INSERT INTO foltia_station VALUES (421, 'WOWOW3', 0, NULL, NULL, 'b', 'X193', NULL, '3011.ontvjapan.com'); INSERT INTO foltia_station VALUES (401, 'チャンネルNECO', 0, '', '', 'c', 'X242', NULL, '1008.ontvjapan.com'); @@ -211,4 +211,31 @@ ADD CONSTRAINT foltia_station_pkey PRIMARY KEY (stationid); - - +drop table foltia_envpolicy; +CREATE TABLE foltia_envpolicy ( +memberid bigint PRIMARY KEY, +userclass bigint, +name text, +passwd1 text , +adddate timestamp, +remotehost text +); +REVOKE ALL on "foltia_envpolicy" from PUBLIC; +GRANT ALL on "foltia_envpolicy" to "foltia"; +create index foltia_envpolicy_index on foltia_envpolicy (name); +insert into foltia_envpolicy values ( '0','0','foltia','foltiapasswd',now(),''); + + +drop table foltia_weeklytimer ; +create table foltia_weeklytimer ( +timerid int8 PRIMARY KEY, +recpattern int8, +stationid int8, +startdatetime int8, +enddatetime int8, +subtitle text, +addeddate timestamp +); +REVOKE ALL on "foltia_weeklytimer" from PUBLIC; +GRANT UPDATE,SELECT,INSERT on "foltia_weeklytimer" to "foltia"; + +