Mercurial > epgrec.yaz

comparison upgrade_db.php @ 158:be39a7efcc87

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merged with upstream
author Yoshiki Yazawa <yaz@honeyplanet.jp>
date Wed, 31 Mar 2010 06:16:04 +0900
parents 0283c2c75147
children
comparison
equal deleted inserted replaced
155:190a3c46611d 158:be39a7efcc87
64 "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify reserve_disc varchar(128) not null default 'none';", // 識別用hash 64 "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify reserve_disc varchar(128) not null default 'none';", // 識別用hash
65 "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify autorec integer not null default '0';", // キーワードID 65 "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify autorec integer not null default '0';", // キーワードID
66 "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify mode integer not null default '0';", //録画モード 66 "alter table ".$settings->tbl_prefix.RESERVE_TBL." modify mode integer not null default '0';", //録画モード
67 ); 67 );
68 68
69 if( index_exists( $settings->tbl_prefix.RESERVE_TBL, "dirty", $dbh) ) { 69 if( column_exists( $settings->tbl_prefix.RESERVE_TBL, "dirty", $dbh) ) {
70 echo "dirtyフィールドはすでに存在しているため作成しません\n"; 70 echo "dirtyフィールドはすでに存在しているため作成しません\n";
71 } 71 }
72 else { 72 else {
73 array_push( $sqlstrs, "alter table ".$settings->tbl_prefix.RESERVE_TBL." add dirty boolean not null default '0';" ); 73 array_push( $sqlstrs, "alter table ".$settings->tbl_prefix.RESERVE_TBL." add dirty boolean not null default '0';" );
74 } 74 }