Tadashi Okoshi
slash****@users*****
2006年 6月 2日 (金) 18:55:51 JST
Index: affelio/lib/Affelio/misc/InitAffelio.pm
diff -u affelio/lib/Affelio/misc/InitAffelio.pm:1.25 affelio/lib/Affelio/misc/InitAffelio.pm:1.26
--- affelio/lib/Affelio/misc/InitAffelio.pm:1.25 Thu Jun 1 15:34:13 2006
+++ affelio/lib/Affelio/misc/InitAffelio.pm Fri Jun 2 18:55:51 2006
@@ -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.25 2006/06/01 06:34:13 slash5234 Exp $
+# $Id: InitAffelio.pm,v 1.26 2006/06/02 09:55:51 slash5234 Exp $
package Affelio::misc::InitAffelio;
{
@@ -256,9 +256,16 @@
################################
#friends DB
################################
- $create_tbl_cmd = <<EOT;
+ if($af->{site__db_type} eq "mysql"){
+ $create_tbl_cmd = <<EOT;
+CREATE TABLE $af->{site__dbtbl_prefix}_CORE_friends(uid INTEGER PRIMARY KEY, af_id CHAR(255), nickname TEXT, timestamp TEXT, password TEXT, intro TEXT, option_pid INTEGER, lastupdated DATETIME, f2list TEXT, last_news_in DATETIME, last_news_out DATETIME, last_access DATETIME, count_access INTEGER DEFAULT 0, last_incoming DATETIME, count_incoming INTEGER DEFAULT 0, last_outgoing DATETIME, count_outgoing INTEGER DEFAULT 0, apps TEXT, af_type TEXT, rflag TEXT)
+EOT
+ }else{
+ $create_tbl_cmd = <<EOT;
CREATE TABLE $af->{site__dbtbl_prefix}_CORE_friends(uid INTEGER PRIMARY KEY, af_id CHAR(255), nickname TEXT, timestamp TEXT, password TEXT, intro TEXT, option_pid INTEGER, lastupdated TEXT, f2list TEXT, last_news_in INTEGER DEFAULT 0, last_news_out INTEGER DEFAULT 0,last_access INTEGER DEFAULT 0, count_access INTEGER DEFAULT 0, last_incoming INTEGER DEFAULT 0, count_incoming INTEGER DEFAULT 0, last_outgoing INTEGER DEFAULT 0, count_outgoing INTEGER DEFAULT 0, apps TEXT, af_type TEXT, rflag TEXT)
EOT
+ }
+
if(!$dbh->do($create_tbl_cmd)){
throw Affelio::exception::DBException("creating friends tbl: $@");
}