Tadashi Okoshi
slash****@users*****
2006年 5月 26日 (金) 12:16:38 JST
Index: affelio/lib/Affelio/misc/InitAffelio.pm
diff -u affelio/lib/Affelio/misc/InitAffelio.pm:1.22 affelio/lib/Affelio/misc/InitAffelio.pm:1.23
--- affelio/lib/Affelio/misc/InitAffelio.pm:1.22 Wed Apr 19 20:32:41 2006
+++ affelio/lib/Affelio/misc/InitAffelio.pm Fri May 26 12:16:37 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.22 2006/04/19 11:32:41 slash5234 Exp $
+# $Id: InitAffelio.pm,v 1.23 2006/05/26 03:16:37 slash5234 Exp $
package Affelio::misc::InitAffelio;
{
@@ -256,7 +256,7 @@
#friends DB
################################
$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)
+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: $@");
@@ -276,7 +276,7 @@
#friendsfriends DB
################################
$create_tbl_cmd = <<EOT;
-CREATE TABLE $af->{site__dbtbl_prefix}_CORE_friendsfriends(uid INTEGER PRIMARY KEY, af_id CHAR(255), nickname TEXT, timestamp TEXT, f1list TEXT)
+CREATE TABLE $af->{site__dbtbl_prefix}_CORE_friendsfriends(uid INTEGER PRIMARY KEY, af_id CHAR(255), nickname TEXT, timestamp TEXT, f1list TEXT, af_type TEXT, rflag TEXT)
EOT
if(!$dbh->do($create_tbl_cmd)){
throw Affelio::exception::DBException("creating F2 tbl: $@");