Tadashi Okoshi
slash****@users*****
2005年 12月 10日 (土) 12:01:31 JST
Index: affelio/lib/Affelio/misc/InitAffelio.pm
diff -u affelio/lib/Affelio/misc/InitAffelio.pm:1.11 affelio/lib/Affelio/misc/InitAffelio.pm:1.12
--- affelio/lib/Affelio/misc/InitAffelio.pm:1.11 Sat Dec 10 05:18:30 2005
+++ affelio/lib/Affelio/misc/InitAffelio.pm Sat Dec 10 12:01:30 2005
@@ -14,7 +14,7 @@
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
#
-# $Id: InitAffelio.pm,v 1.11 2005/12/09 20:18:30 slash5234 Exp $
+# $Id: InitAffelio.pm,v 1.12 2005/12/10 03:01:30 slash5234 Exp $
package Affelio::misc::InitAffelio;
{
@@ -332,13 +332,56 @@
throw Affelio::exception::DBException("creating apps tbl: $@");
}
+ ################################
+ #my_news
+ ################################
+ $create_tbl_cmd = <<EOT;
+CREATE TABLE AFuser_CORE_my_news(nid INTEGER PRIMARY KEY AUTOINCREMENT,
+ datetime INTEGER,
+ app_install_name TEXT,
+ title TEXT,
+ description TEXT,
+ creator TEXT,
+ URL TEXT)
+EOT
+ if(!$dbh->do($create_tbl_cmd)){
+ throw Affelio::exception::DBException("creating mynews tbl: $@");
+ }
+
+
+ ################################
+ #nghr_news
+ ################################
+ $create_tbl_cmd = <<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
+ if(!$dbh->do($create_tbl_cmd)){
+ throw Affelio::exception::DBException("creating nghr_news tbl: $@");
+ }
+
+ ################################
+ #disconnect DB
+ ################################
try{
$dbh->disconnect;
}catch Error with{
my $e = shift;
throw Affelio::exception::DBException("DB disconnecting: $@");
+
+
};
+
+
+
################################################################
#Stage 2: Reload Affelio
################################################################