Mercurial > epgrec.yaz
comparison epgrec_upgrade.php @ 20:9ab4184561d9
new file: epgrec_upgrade.php
author | Sushi-k <epgrec@park.mda.or.jp> |
---|---|
date | Thu, 16 Jul 2009 16:52:54 +0900 |
parents | |
children | e5f9aa34d06f |
comparison
equal
deleted
inserted
replaced
19:9648e3af1777 | 20:9ab4184561d9 |
---|---|
1 #!/usr/bin/php | |
2 <?php | |
3 include_once('config.php'); | |
4 | |
5 $dbh = mysql_connect( DB_HOST, DB_USER, DB_PASS ); | |
6 if( $dbh !== false ) { | |
7 | |
8 $sqlstr = "use ".DB_NAME; | |
9 mysql_query( $sqlstr ); | |
10 | |
11 $sqlstr = "set NAMES 'utf8'"; | |
12 mysql_query( $sqlstr ); | |
13 | |
14 // RESERVE_TBL | |
15 // description -> text | |
16 $sqlstr = "alter table ".TBL_PREFIX.RESERVE_TBL." modify description text default null;"; | |
17 mysql_query( $sqlstr ); | |
18 // path -> blob | |
19 $sqlstr = "alter table ".TBL_PREFIX.RESERVE_TBL." modify path blob default null;"; | |
20 mysql_query( $sqlstr ); | |
21 | |
22 // PROGRAM_TBL | |
23 // descripton -> text | |
24 $sqlstr = "alter table ".TBL_PREFIX.PROGRAM_TBL." modify description text default null;"; | |
25 mysql_query( $sqlstr ); | |
26 } | |
27 else exit( "Can't connect DB\n"); | |
28 | |
29 ?> |