Mercurial > epgrec.yaz
comparison epgrec_upgrade.php @ 37:e5f9aa34d06f
change: modify all script for web base setting
author | yoneda <epgrec@park.mda.or.jp> |
---|---|
date | Tue, 28 Jul 2009 00:00:04 +0900 |
parents | 9ab4184561d9 |
children |
comparison
equal
deleted
inserted
replaced
36:c2522d1df005 | 37:e5f9aa34d06f |
---|---|
1 #!/usr/bin/php | 1 #!/usr/bin/php |
2 <?php | 2 <?php |
3 include_once('config.php'); | 3 include_once('config.php'); |
4 include_once(INSTALL_PATH . '/Settings.class.php' ); | |
4 | 5 |
5 $dbh = mysql_connect( DB_HOST, DB_USER, DB_PASS ); | 6 $settings = Settings::factory(); |
7 | |
8 $dbh = mysql_connect( $settings->db_host, $settings->db_user, $settings->db_pass ); | |
6 if( $dbh !== false ) { | 9 if( $dbh !== false ) { |
7 | 10 |
8 $sqlstr = "use ".DB_NAME; | 11 $sqlstr = "use ".$settings->db_name; |
9 mysql_query( $sqlstr ); | 12 mysql_query( $sqlstr ); |
10 | 13 |
11 $sqlstr = "set NAMES 'utf8'"; | 14 $sqlstr = "set NAMES 'utf8'"; |
12 mysql_query( $sqlstr ); | 15 mysql_query( $sqlstr ); |
13 | 16 |
14 // RESERVE_TBL | 17 // RESERVE_TBL |
15 // description -> text | 18 // description -> text |
16 $sqlstr = "alter table ".TBL_PREFIX.RESERVE_TBL." modify description text default null;"; | 19 $sqlstr = "alter table ".RESERVE_TBL." modify description text default null;"; |
17 mysql_query( $sqlstr ); | 20 mysql_query( $sqlstr ); |
18 // path -> blob | 21 // path -> blob |
19 $sqlstr = "alter table ".TBL_PREFIX.RESERVE_TBL." modify path blob default null;"; | 22 $sqlstr = "alter table ".RESERVE_TBL." modify path blob default null;"; |
20 mysql_query( $sqlstr ); | 23 mysql_query( $sqlstr ); |
21 | 24 |
22 // PROGRAM_TBL | 25 // PROGRAM_TBL |
23 // descripton -> text | 26 // descripton -> text |
24 $sqlstr = "alter table ".TBL_PREFIX.PROGRAM_TBL." modify description text default null;"; | 27 $sqlstr = "alter table ".PROGRAM_TBL." modify description text default null;"; |
25 mysql_query( $sqlstr ); | 28 mysql_query( $sqlstr ); |
26 } | 29 } |
27 else exit( "Can't connect DB\n"); | 30 else exit( "Can't connect DB\n"); |
28 | 31 |
29 ?> | 32 ?> |