補足します。
autoattendモジュールに付属の、PostgreSQL用のSQLファイルは以下のような修正が必要でした。
--- mod/autoattendmod/db/postgres7.sql.ORG 2007-03-28 03:08:58.000000000 +0900
+++ mod/autoattendmod/db/postgres7.sql 2010-08-19 17:03:29.998724000 +0900
@@ -9,7 +9,7 @@
CREATE TABLE prefix_autoattendmod (
id SERIAL PRIMARY KEY,
course integer NOT NULL default '0',
- timemodified integer NOT NULL default '0';
+ timemodified integer NOT NULL default '0',
name varchar(255) NOT NULL default ''
);
--- blocks/autoattend/db/postgres7.sql.ORG 2007-04-01 18:59:12.000000000 +0900
+++ blocks/autoattend/db/postgres7.sql 2010-08-19 17:28:55.240475000 +0900
@@ -1,4 +1,9 @@
CREATE TABLE prefix_autoattend_sessions (
id SERIAL PRIMARY KEY,
courseid integer NOT NULL default '0',
@@ -13,11 +18,11 @@
starttime integer NOT NULL default '0',
latetime integer NOT NULL default '0',
endtime integer NOT NULL default '0',
- denysameip integer NOT NULL default '1'
+ denysameip integer NOT NULL default '1',
attendkey varchar(36) NULL default '',
allowip varchar(128) NULL default '',
- description varchar(128) NULL default '',
+ description varchar(128) NULL default ''
);
CREATE INDEX prefix_autoattend_sessions_courseid_idx ON prefix_autoattend_sessions (courseid);
@@ -26,13 +31,16 @@
CREATE TABLE prefix_autoattend_students (
id SERIAL PRIMARY KEY,
attsid integer NOT NULL default '0',
studentid integer NOT NULL default '0',
status varchar(1) NOT NULL default 'Y',
called varchar(1) NOT NULL default 'D',
- alledby integer NOT NULL default '0',
+ calledby integer NOT NULL default '0',
calledtime integer NOT NULL default '0',
remarks varchar(50) default '',
ipaddress varchar(20) default ''
@@ -56,9 +64,9 @@
-INSERT INTO prefix_autoattend_settings VALUES (nextval('id'), 0, 'P', '2');
-INSERT INTO prefix_autoattend_settings VALUES (nextval('id'), 0, 'L', '1');
-INSERT INTO prefix_autoattend_settings VALUES (nextval('id'), 0, 'E', '1');
-INSERT INTO prefix_autoattend_settings VALUES (nextval('id'), 0, 'X', '0');
-INSERT INTO prefix_autoattend_settings VALUES (nextval('id'), 0, 'Y', '0');
+INSERT INTO prefix_autoattend_settings VALUES (default, 0, 'P', '2');
+INSERT INTO prefix_autoattend_settings VALUES (default, 0, 'L', '1');
+INSERT INTO prefix_autoattend_settings VALUES (default, 0, 'E', '1');
+INSERT INTO prefix_autoattend_settings VALUES (default, 0, 'X', '0');
+INSERT INTO prefix_autoattend_settings VALUES (default, 0, 'Y', '0');