Yoshihisa Fukuhara
higef****@users*****
2006年 3月 1日 (水) 15:32:25 JST
Index: affelio/apps/diary/upgrade/index.cgi
diff -u affelio/apps/diary/upgrade/index.cgi:1.1 affelio/apps/diary/upgrade/index.cgi:1.2
--- affelio/apps/diary/upgrade/index.cgi:1.1 Wed Mar 1 14:40:36 2006
+++ affelio/apps/diary/upgrade/index.cgi Wed Mar 1 15:32:25 2006
@@ -151,11 +151,11 @@
#Add columns
################################
my $entry_table = "diary_$afap->{install_name}_entries";
- add_column($dbh, $entry_table, 'c_id', "INTEGER", 1);
- add_column($dbh, $entry_table, 'user', "TEXT", "NULL");
- add_column($dbh, $entry_table, 'uri', "TEXT", "NULL");
- add_column($dbh, $entry_table, 'pwd', "TEXT", "NULL");
- add_column($dbh, $entry_table, 'draft', "INTEGER", "0");
+ add_column($dbh, $entry_table, 'c_id', "INTEGER");
+ add_column($dbh, $entry_table, 'user', "TEXT");
+ add_column($dbh, $entry_table, 'uri', "TEXT");
+ add_column($dbh, $entry_table, 'pwd', "TEXT");
+ add_column($dbh, $entry_table, 'draft', "INTEGER");
################################
#Update tables
@@ -187,7 +187,7 @@
};
if($@){
print "We confirmed that table [$table] needs column [$col]<BR>";
- my $query2 = "ALTER TABLE $table ADD COLUMN $col $type DEFAULT $def";
+ my $query2 = "ALTER TABLE $table ADD COLUMN $col $type";
my $sth;
eval{
$dbh->do($query2);
@@ -226,13 +226,14 @@
if ($col2 ne "" && $current2 ne""){
$query.= " AND $col2 = '$current2'";
}
+ print $query;
my $sth;
my $ret;
eval{
$sth = $dbh->prepare($query);
$ret = $sth->execute;
};
-
+ print $ret;
if($ret>0){
my $query2;
print "We confirmed that table [$table] needs update [$col]<BR>";