Tadashi Okoshi
slash****@users*****
2005年 12月 10日 (土) 08:07:38 JST
Index: affelio/upgrade-10-11.cgi
diff -u affelio/upgrade-10-11.cgi:1.6 affelio/upgrade-10-11.cgi:1.7
--- affelio/upgrade-10-11.cgi:1.6 Sat Dec 10 05:18:30 2005
+++ affelio/upgrade-10-11.cgi Sat Dec 10 08:07:38 2005
@@ -97,6 +97,48 @@
}#block
################################
+ #Create nghr_news
+ ################################
+ {
+ my $query = 'SELECT * from AFuser_CORE_nghr_news';
+ my $sth;
+ eval{
+ $sth = $af->getDB->prepare($query);
+ $sth->execute;
+ };
+ if($@){
+ print "We confirmed that nghr_news table does not exist.<BR>";
+ print "So, We will make it<BR>";
+ my $query = <<EOT;
+CREATE TABLE AFuser_CORE_nghr_news(nid INTEGER PRIMARY KEY AUTOINCREMENT,
+ datetime INTEGER,
+ af_id TEXT,
+ nickname TEXT,
+ app_install_name TEXT,
+ title TEXT,
+ description TEXT,
+ creator TEXT,
+ URL TEXT)
+EOT
+ my $sth;
+ eval{
+ $sth = $af->getDB->prepare($query);
+ $sth->execute;
+ };
+ if($@){
+ print 'Error occured in creating the table<BR><BR>' . $@;
+ exit(1);
+ }
+
+ }else{
+ #Application table already exists.
+ #So, do nothing.
+ print 'We confirmed that nghr_news table already exists.<BR>';
+ print 'So, We will do nothing.<BR>';
+ }
+ }#block
+
+ ################################
#Add columns to friend tale
################################
add_column($af, 'AFuser_CORE_friends', 'last_news_in', "INTEGER", 0);