Mercurial > epgrec.yaz
view upgrade_to_201002.php @ 95:d9b9d1d903a1
fix: ¤µ¤é¤Ë½¤Àµ
author | epgrec@park.mda.or.jp <yoneda@recorder.localnet.mda.or.jp> |
---|---|
date | Wed, 03 Mar 2010 00:02:15 +0900 |
parents | cce6f88590fd |
children |
line wrap: on
line source
#!/usr/bin/php <?php include_once('config.php'); include_once(INSTALL_PATH . '/Settings.class.php' ); // mysqli::multi_queryã¯å‹•ä½œãŒã„ã¾ã„ã¡ãªã®ã§ä½¿ã‚ãªã„ function multi_query( $sqlstrs, $dbh ) { $error = false; foreach( $sqlstrs as $sqlstr ) { $res = mysql_query( $sqlstr ); if( $res === FALSE ) { echo "failed: ". $sqlstr . "\n"; $error = true; } } return $error; } $settings = Settings::factory(); $dbh = mysql_connect( $settings->db_host, $settings->db_user, $settings->db_pass ); if( $dbh !== FALSE ) { $sqlstr = "use ".$settings->db_name; mysql_query( $sqlstr ); $sqlstr = "set NAMES 'utf8'"; mysql_query( $sqlstr ); // RESERVE_TBL $sqlstrs = array ( "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify channel_disc varchar(128) not null default 'none';", // channel disc "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify channel_id integer not null default '0';", // channel ID "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify program_id integer not null default '0';", // Program ID "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify type varchar(8) not null default 'GR';", // 種別(GR/BS/CS) "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify channel varchar(10) not null default '0';", // ãƒãƒ£ãƒ³ãƒãƒ« "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify title varchar(512) not null default 'none';", // タイトル "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify description varchar(512) not null default 'none';", // 説明 text->varchar "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify category_id integer not null default '0';", // カテゴリID "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify starttime datetime not null default '1970-01-01 00:00:00';", // 開始時刻 "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify endtime datetime not null default '1970-01-01 00:00:00';", // 終了時刻 "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify job integer not null default '0';", // jobç•ªå· "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify path blob default null;", // 録画ファイルパス "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify complete boolean not null default '0';", // 完了フラグ "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify reserve_disc varchar(128) not null default 'none';", // è˜åˆ¥ç”¨hash "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify autorec integer not null default '0';", // ã‚ーワードID "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify mode integer not null default '0';", //録画モード ); if( multi_query( $sqlstrs, $dbh ) ) { echo "予約テーブルã®ã‚¢ãƒƒãƒ—デートã«å¤±æ•—\n"; } $sqlstrs = array( "create index reserve_ch_idx on ".$settings->tbl_prefix.RESERVE_TBL." (channel_disc);", "create index reserve_st_idx on ".$settings->tbl_prefix.RESERVE_TBL." (starttime);", ); if( multi_query( $sqlstrs, $dbh ) ) { echo "予約テーブルã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½œæˆã§ãã¾ã›ã‚“\n"; } // PROGRAM_TBL $sqlstrs = array ( "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify channel_disc varchar(128) not null default 'none';", // channel disc "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify channel_id integer not null default '0';", // channel ID "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify type varchar(8) not null default 'GR';", // 種別(GR/BS/CS) "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify channel varchar(10) not null default '0';", // ãƒãƒ£ãƒ³ãƒãƒ« "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify title varchar(512) not null default 'none';", // タイトル "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify description varchar(512) not null default 'none';", // 説明 text->varchar "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify category_id integer not null default '0';", // カテゴリID "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify starttime datetime not null default '1970-01-01 00:00:00';", // 開始時刻 "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify endtime datetime not null default '1970-01-01 00:00:00';", // 終了時刻 "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify program_disc varchar(128) not null default 'none';", // è˜åˆ¥ç”¨hash "alter table ".$settings->tbl_prefix.PROGRAM_TBL." modify autorec boolean not null default '1';", // 自動録画有効無効 ); if( multi_query( $sqlstrs, $dbh ) ) { echo "番組テーブルã®ã‚¢ãƒƒãƒ—デートã«å¤±æ•—\n"; } $sqlstrs = array( "create index program_ch_idx on ".$settings->tbl_prefix.PROGRAM_TBL." (channel_disc);", // インデックス "create index program_st_idx on ".$settings->tbl_prefix.PROGRAM_TBL." (starttime);", // インデックス ); if( multi_query( $sqlstrs, $dbh ) ) { echo "番組テーブルã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½œæˆã§ãã¾ã›ã‚“\n"; } // CHANNEL_TBL $sqlstrs = array( "alter table ".$settings->tbl_prefix.CHANNEL_TBL." modify type varchar(8) not null default 'GR';", // 種別 "alter table ".$settings->tbl_prefix.CHANNEL_TBL." modify channel varchar(10) not null default '0';", // channel "alter table ".$settings->tbl_prefix.CHANNEL_TBL." modify name varchar(512) not null default 'none';", // 表示å "alter table ".$settings->tbl_prefix.CHANNEL_TBL." modify channel_disc varchar(128) not null default 'none';", // è˜åˆ¥ç”¨hash "alter table ".$settings->tbl_prefix.CHANNEL_TBL." add sid varchar(64) not null default 'hd'", // サービスID用02/23/2010è¿½åŠ ); if( multi_query( $sqlstrs, $dbh ) ) { echo "ãƒãƒ£ãƒ³ãƒãƒ«ãƒ†ãƒ¼ãƒ–ルã®ã‚¢ãƒƒãƒ—デートã«å¤±æ•—\n"; } // CATEGORY_TBL $sqlstrs = array( "alter table ".$settings->tbl_prefix.CATEGORY_TBL." modify name_jp varchar(512) not null default 'none';", // 表示å "alter table ".$settings->tbl_prefix.CATEGORY_TBL." modify name_en varchar(512) not null default 'none';", // åŒä¸Š "alter table ".$settings->tbl_prefix.CATEGORY_TBL." modify category_disc varchar(128) not null default 'none'", // è˜åˆ¥ç”¨hash ); if( multi_query( $sqlstrs, $dbh ) ) { echo "カテゴリテーブルã®ã‚¢ãƒƒãƒ—デートã«å¤±æ•—\n"; } // KEYWORD_TBL $sqlstrs = array( "alter table ".$settings->tbl_prefix.KEYWORD_TBL." modify keyword varchar(512) not null default '*';", // 表示å "alter table ".$settings->tbl_prefix.KEYWORD_TBL." modify type varchar(8) not null default '*';", // 種別 "alter table ".$settings->tbl_prefix.KEYWORD_TBL." modify channel_id integer not null default '0';", // channel ID "alter table ".$settings->tbl_prefix.KEYWORD_TBL." modify category_id integer not null default '0';", // カテゴリID "alter table ".$settings->tbl_prefix.KEYWORD_TBL." modify use_regexp boolean not null default '0';", // æ£è¦è¡¨ç¾ã‚’使用ã™ã‚‹ãªã‚‰1 "alter table ".$settings->tbl_prefix.KEYWORD_TBL." add autorec_mode integer not null default '0';", // 自動録画ã®ãƒ¢ãƒ¼ãƒ‰02/23/2010è¿½åŠ "alter table ".$settings->tbl_prefix.KEYWORD_TBL." add weekofday enum ('0','1','2','3','4','5','6','7' ) default '7'", // 曜日ã€åŒè¿½åŠ ); if( multi_query( $sqlstrs, $dbh ) ) { echo "ã‚ーワードテーブルã®ã‚¢ãƒƒãƒ—デートã«å¤±æ•—\n"; } } else exit( "DBã®æŽ¥ç¶šã«å¤±æ•—\n" ); ?>