diff upgrade_db.php @ 142:481e789605e3

mod: EPG???????????????????????????????

--- 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";
 	}