Mercurial > epgrec.yaz
view epgrec_upgrade.php @ 29:ae5491d72470
modified: templates/recordedTable.html
author | yoneda <epgrec@park.mda.or.jp> |
---|---|
date | Sun, 26 Jul 2009 18:38:44 +0900 |
parents | 9ab4184561d9 |
children | e5f9aa34d06f |
line wrap: on
line source
#!/usr/bin/php <?php include_once('config.php'); $dbh = mysql_connect( DB_HOST, DB_USER, DB_PASS ); if( $dbh !== false ) { $sqlstr = "use ".DB_NAME; mysql_query( $sqlstr ); $sqlstr = "set NAMES 'utf8'"; mysql_query( $sqlstr ); // RESERVE_TBL // description -> text $sqlstr = "alter table ".TBL_PREFIX.RESERVE_TBL." modify description text default null;"; mysql_query( $sqlstr ); // path -> blob $sqlstr = "alter table ".TBL_PREFIX.RESERVE_TBL." modify path blob default null;"; mysql_query( $sqlstr ); // PROGRAM_TBL // descripton -> text $sqlstr = "alter table ".TBL_PREFIX.PROGRAM_TBL." modify description text default null;"; mysql_query( $sqlstr ); } else exit( "Can't connect DB\n"); ?>