Tadashi Okoshi
slash****@users*****
2005年 12月 20日 (火) 02:26:14 JST
Index: affelio/lib/Affelio/misc/InitAffelio.pm
diff -u affelio/lib/Affelio/misc/InitAffelio.pm:1.15 affelio/lib/Affelio/misc/InitAffelio.pm:1.16
--- affelio/lib/Affelio/misc/InitAffelio.pm:1.15 Sat Dec 17 14:08:07 2005
+++ affelio/lib/Affelio/misc/InitAffelio.pm Tue Dec 20 02:26:14 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.15 2005/12/17 05:08:07 slash5234 Exp $
+# $Id: InitAffelio.pm,v 1.16 2005/12/19 17:26:14 slash5234 Exp $
package Affelio::misc::InitAffelio;
{
@@ -251,7 +251,7 @@
#friends DB
################################
$create_tbl_cmd = <<EOT;
-CREATE TABLE AFuser_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)
+CREATE TABLE AFuser_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 DEFAULT ' ')
EOT
if(!$dbh->do($create_tbl_cmd)){
throw Affelio::exception::DBException("creating friends tbl: $@");