チェンジセット 97: trunk/install/perl/db

差分発生行の前後
無視リスト:
コミット日時:
2010/04/02 22:58:58 (15 年前)
コミッタ:
sorshi
ログメッセージ:

radiko録音対応

ファイル:

凡例:

変更無し
追加
削除
更新
コピー
移動

  • trunk/install/perl/db/Pg.pl

    r94 r97  
    5454'recwrap.6' => "INSERT into foltia_mp4files VALUES (?, ?)", 
    5555'recwrap.7' => "SELECT foltia_subtitle.tid,foltia_subtitle.countno,foltia_subtitle.subtitle,foltia_subtitle.startdatetime ,foltia_subtitle.enddatetime ,foltia_subtitle.lengthmin ,foltia_tvrecord.bitrate , foltia_subtitle.startoffset , foltia_subtitle.pid ,foltia_tvrecord.digital FROM foltia_subtitle ,foltia_tvrecord WHERE foltia_tvrecord.tid = foltia_subtitle.tid AND foltia_tvrecord.tid = ? AND foltia_subtitle.startdatetime = ? AND foltia_tvrecord.digital = 1", 
     56'recwrap.8' => "SELECT stationid,stationname,stationrecch,tunertype FROM foltia_station WHERE stationid = ? ", 
    5657 
    5758'schedulecheck.1' => "SELECT count(*) FROM foltia_tvrecord", 
track feed