Yoshihisa Fukuhara
higef****@users*****
2005年 6月 22日 (水) 01:35:31 JST
Index: affelio/apps/album/Album.pm
diff -u affelio/apps/album/Album.pm:1.4 affelio/apps/album/Album.pm:1.5
--- affelio/apps/album/Album.pm:1.4 Mon Jun 20 23:26:57 2005
+++ affelio/apps/album/Album.pm Wed Jun 22 01:35:30 2005
@@ -49,7 +49,7 @@
$this->{dbh} = $afap->get_userdata_dbh();
# 日記テーブル
$this->{dbh}->do("CREATE TABLE $album_table (
- id INTEGER PRIMARY KEY,
+ id INTEGER AUTO_INCREMENT PRIMARY KEY,
title TEXT,
contents TEXT,
timestamp INTEGER,
@@ -62,7 +62,7 @@
# コメントテーブル
$this->{dbh}->do("CREATE TABLE $album_comment_table (
- pkey INTEGER PRIMARY KEY,
+ pkey INTEGER AUTO_INCREMENT PRIMARY KEY,
id INTEGER,
user TEXT,
afid TEXT,
@@ -73,7 +73,7 @@
# ç”»åƒãƒ†ãƒ¼ãƒ–ル
$this->{dbh}->do("CREATE TABLE $album_image_table (
- pkey INTEGER PRIMARY KEY,
+ pkey INTEGER AUTO_INCREMENT PRIMARY KEY,
id INTEGER,
image TEXT,
title TEXT,
@@ -365,7 +365,7 @@
sub getCommentsNo {
my ($this, $id) = @_;
- return $this->getColumn("SELECT COUNT (*) FROM $album_comment_table WHERE id = $id");
+ return $this->getColumn("SELECT COUNT(*) FROM $album_comment_table WHERE id = $id");
}
sub getColumn {