Mercurial > epgrec.yaz
diff upgrade_db.php @ 142:481e789605e3
mod: EPGの更新と同時に予約情報を更新するように変更、ログビューアの追加
| author | epgrec@park.mda.or.jp <yoneda@recorder.localnet.mda.or.jp> |
|---|---|
| date | Sun, 21 Mar 2010 16:42:58 +0900 |
| parents | 9c5e597ef6c6 |
| children | 0283c2c75147 |
line wrap: on
line diff
--- a/upgrade_db.php Sun Mar 21 00:00:58 2010 +0900 +++ b/upgrade_db.php Sun Mar 21 16:42:58 2010 +0900 @@ -66,6 +66,13 @@ "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify mode integer not null default '0';", //牙祉≪若 ); + if( index_exists( $settings->tbl_prefix.RESERVE_TBL, "dirty", $dbh) ) { + echo "dirtyｃ若с絖篏障\n"; + } + else { + array_push( $sqlstrs, "alter table ".$settings->tbl_prefix.RESERVE_TBL." add dirty boolean not null default '0';" ); + } + if( multi_query( $sqlstrs, $dbh ) ) { echo "篋膣若≪若紊掩\n"; } @@ -178,31 +185,35 @@ } if( column_exists( $settings->tbl_prefix.KEYWORD_TBL, "weekofday", $dbh ) ) { echo "weekofday絖т障\n"; + array_push( $sqlstrs, "alter table ".$settings->tbl_prefix.KEYWORD_TBL." modify weekofday enum ('0','1','2','3','4','5','6','7' ) not null default '7'" ); } else { - array_push( $sqlstrs, "alter table ".$settings->tbl_prefix.KEYWORD_TBL." add weekofday enum ('0','1','2','3','4','5','6','7' ) default '7'" ); + array_push( $sqlstrs, "alter table ".$settings->tbl_prefix.KEYWORD_TBL." add weekofday enum ('0','1','2','3','4','5','6','7' ) not null default '7'" ); } if( column_exists( $settings->tbl_prefix.KEYWORD_TBL, "prgtime", $dbh ) ) { echo "prgtime絖т障\n"; + array_push( $sqlstrs, + "alter table ".$settings->tbl_prefix.KEYWORD_TBL." modify prgtime enum ('0','1','2','3','4','5','6','7','8','9','10','11','12',". + "'13','14','15','16','17','18','19','20','21','22','23','24') not null default '24'" ); } else { array_push( $sqlstrs, "alter table ".$settings->tbl_prefix.KEYWORD_TBL." add prgtime enum ('0','1','2','3','4','5','6','7','8','9','10','11','12',". - "'13','14','15','16','17','18','19','20','21','22','23','24') default '24'" ); + "'13','14','15','16','17','18','19','20','21','22','23','24') not null default '24'" ); } if( multi_query( $sqlstrs, $dbh ) ) { echo "若若若≪若紊掩\n"; } - // 違若 + // 違若域鋎 try { $log = new DBRecord( LOG_TBL ); $log->createTable( LOG_STRUCT ); } catch( Exception $e ) { - echo $e->message; + echo $e->getMessage(); echo "\n"; }