Hello,
We're finally starting to migrate from 1.2 and I ran across a problem
in the migration script (both 2.0 and 2.1) if you don't already have the
auto_notifications or auto_replies tables.
--- migrate_from_1.x_to_2.0.pgsql Thu Jul 20 15:11:55 2006
+++ migrate_from_1.x_to_2.0.pgsql.fix Thu Jul 20 16:33:12 2006
@@ -28,6 +28,7 @@
CREATE SEQUENCE auto_notification_seq;
CREATE TABLE auto_notifications (
auto_notify_idnr INT8 DEFAULT nextval('auto_notification_seq'),
+ user_idnr INT8 DEFAULT '0' NOT NULL,
notify_address VARCHAR(100),
PRIMARY KEY (auto_notify_idnr)
);
@@ -35,6 +36,7 @@
CREATE SEQUENCE auto_reply_seq;
CREATE TABLE auto_replies (
auto_reply_idnr INT8 DEFAULT nextval('auto_reply_seq'),
+ user_idnr INT8 DEFAULT '0' NOT NULL,
reply_body TEXT,
PRIMARY KEY(auto_reply_idnr)
);
--
Jesse Norell - [EMAIL PROTECTED]
Kentec Communications, Inc.
