Tadashi Okoshi
slash****@users*****
2006年 5月 29日 (月) 21:08:49 JST
Index: affelio/lib/Affelio/misc/InitAffelio.pm
diff -u affelio/lib/Affelio/misc/InitAffelio.pm:1.23 affelio/lib/Affelio/misc/InitAffelio.pm:1.24
--- affelio/lib/Affelio/misc/InitAffelio.pm:1.23 Fri May 26 12:16:37 2006
+++ affelio/lib/Affelio/misc/InitAffelio.pm Mon May 29 21:08:49 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.23 2006/05/26 03:16:37 slash5234 Exp $
+# $Id: InitAffelio.pm,v 1.24 2006/05/29 12:08:49 slash5234 Exp $
package Affelio::misc::InitAffelio;
{
@@ -364,7 +364,7 @@
#my_news
################################
$create_tbl_cmd = <<EOT;
-CREATE TABLE $af->{site__dbtbl_prefix}_CORE_my_news(nid INTEGER PRIMARY KEY AUTOINCREMENT,
+ CREATE TABLE $af->{site__dbtbl_prefix}_CORE_my_news(nid INTEGER PRIMARY KEY AUTOINCREMENT,
datetime INTEGER,
app_install_name TEXT,
title TEXT,
@@ -375,6 +375,7 @@
EOT
if($af->{site__db_type} eq "mysql"){
$create_tbl_cmd =~ s/AUTOINCREMENT/AUTO\_INCREMENT/g;
+ $create_tbl_cmd =~ s/datetime INTEGER/datetime DATETIME/g;
}
if(!$dbh->do($create_tbl_cmd)){
throw Affelio::exception::DBException("creating mynews tbl: $@");
@@ -397,6 +398,7 @@
EOT
if($af->{site__db_type} eq "mysql"){
$create_tbl_cmd =~ s/AUTOINCREMENT/AUTO\_INCREMENT/g;
+ $create_tbl_cmd =~ s/datetime INTEGER/datetime DATETIME/g;
}
if(!$dbh->do($create_tbl_cmd)){
throw Affelio::exception::DBException("creating nghr_news tbl: $@");