Index: /trunk/doc/CHANGES.txt
===================================================================
--- /trunk/doc/CHANGES.txt (リビジョン 68)
+++ /trunk/doc/CHANGES.txt (リビジョン 69)
@@ -1,3 +1,10 @@
 foltia 更新履歴 http://www.dcc-jpl.com/soft/foltia/
+
+07.12.5
+updatem2pfiletable.pl:
+　MP4ファイルリストを作成するときの処理をより効率化。
+mktable.txt:
+　しょぼかる放送局名変更にあわせて初期テーブル修正。
+　 [しょぼかる] チャンネル名の変更について(2007-11-13更新)  http://syobocal.g.hatena.ne.jp/gae/20071015
 
 07.10.29
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";
+
+