Mercurial > epgrec.yaz
annotate epgrec_upgrade.php @ 71:29131bd8dea3
fixed typo
author | Yoshiki Yazawa <yaz@honeyplanet.jp> |
---|---|
date | Sun, 17 Jan 2010 01:31:14 +0900 |
parents | e5f9aa34d06f |
children |
rev | line source |
---|---|
20 | 1 #!/usr/bin/php |
2 <?php | |
3 include_once('config.php'); | |
37
e5f9aa34d06f
change: modify all script for web base setting
yoneda <epgrec@park.mda.or.jp>
parents:
20
diff
changeset
|
4 include_once(INSTALL_PATH . '/Settings.class.php' ); |
20 | 5 |
37
e5f9aa34d06f
change: modify all script for web base setting
yoneda <epgrec@park.mda.or.jp>
parents:
20
diff
changeset
|
6 $settings = Settings::factory(); |
e5f9aa34d06f
change: modify all script for web base setting
yoneda <epgrec@park.mda.or.jp>
parents:
20
diff
changeset
|
7 |
e5f9aa34d06f
change: modify all script for web base setting
yoneda <epgrec@park.mda.or.jp>
parents:
20
diff
changeset
|
8 $dbh = mysql_connect( $settings->db_host, $settings->db_user, $settings->db_pass ); |
20 | 9 if( $dbh !== false ) { |
10 | |
37
e5f9aa34d06f
change: modify all script for web base setting
yoneda <epgrec@park.mda.or.jp>
parents:
20
diff
changeset
|
11 $sqlstr = "use ".$settings->db_name; |
20 | 12 mysql_query( $sqlstr ); |
13 | |
14 $sqlstr = "set NAMES 'utf8'"; | |
15 mysql_query( $sqlstr ); | |
16 | |
17 // RESERVE_TBL | |
18 // description -> text | |
37
e5f9aa34d06f
change: modify all script for web base setting
yoneda <epgrec@park.mda.or.jp>
parents:
20
diff
changeset
|
19 $sqlstr = "alter table ".RESERVE_TBL." modify description text default null;"; |
20 | 20 mysql_query( $sqlstr ); |
21 // path -> blob | |
37
e5f9aa34d06f
change: modify all script for web base setting
yoneda <epgrec@park.mda.or.jp>
parents:
20
diff
changeset
|
22 $sqlstr = "alter table ".RESERVE_TBL." modify path blob default null;"; |
20 | 23 mysql_query( $sqlstr ); |
24 | |
25 // PROGRAM_TBL | |
26 // descripton -> text | |
37
e5f9aa34d06f
change: modify all script for web base setting
yoneda <epgrec@park.mda.or.jp>
parents:
20
diff
changeset
|
27 $sqlstr = "alter table ".PROGRAM_TBL." modify description text default null;"; |
20 | 28 mysql_query( $sqlstr ); |
29 } | |
30 else exit( "Can't connect DB\n"); | |
31 | |
32 ?> |