Mercurial > epgrec.yaz
view epgrec_upgrade.php @ 23:f3bf1be1a51b
Change: using ajax in custom reservation method
author | yoneda <yoneda@recorder.localnet.mda.or.jp> |
---|---|
date | Thu, 23 Jul 2009 23:35:43 +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"); ?>