Index: /trunk/install/perl/db/Pg.pl =================================================================== --- /trunk/install/perl/db/Pg.pl (リビジョン 111) +++ /trunk/install/perl/db/Pg.pl (リビジョン 113) @@ -75,6 +75,5 @@ 'xmltv2foltia.replaceepg.1' => "SELECT * FROM foltia_epg WHERE enddatetime > ? AND startdatetime < ? AND ontvchannel = ?", 'xmltv2foltia.commitdb.1' => "DELETE FROM foltia_epg WHERE epgid = ?", -'xmltv2foltia.commitdb.2' => "INSERT INTO foltia_epg VALUES (NULL, ?, ?, ?, ?, ?, ?, ?)" , - +'xmltv2foltia.commitdb.2' => "INSERT INTO foltia_epg VALUES ( nextval('foltia_epg_epgid_seq'), ?, ?, ?, ?, ?, ?, ?)" , 'epgimport.1' => "SELECT count(*) FROM foltia_station WHERE stationid = ?" , 'epgimport.2' => "SELECT digitalch,ontvcode FROM foltia_station WHERE stationid = ?" , Index: /trunk/install/perl/db/SQLite.pl =================================================================== --- /trunk/install/perl/db/SQLite.pl (リビジョン 94) +++ /trunk/install/perl/db/SQLite.pl (リビジョン 113) @@ -4,3 +4,6 @@ $stmt{'foltialib.changefilestatus.1'} = "UPDATE foltia_subtitle SET filestatus = ?, lastupdate = datetime('now', 'localtime') WHERE pid = ?"; +$stmt{'xmltv2foltia.commitdb.2'} ="INSERT INTO foltia_epg VALUES (NULL, ?, ?, ?, ?, ?, ?, ?)"; + + 1; Index: /trunk/install/mktable.txt =================================================================== --- /trunk/install/mktable.txt (リビジョン 111) +++ /trunk/install/mktable.txt (リビジョン 113) @@ -62,5 +62,5 @@ drop table foltia_epg; create table foltia_epg ( -epgid int8 PRIMARY KEY SERIAL, +epgid BIGSERIAL PRIMARY KEY , startdatetime int8, enddatetime int8,