The following bug has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000224 ====================================================================== Reported By: tmatsuo Assigned To: ====================================================================== Project: DBMail Bug ID: 224 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: new ====================================================================== Date Submitted: 07-Jul-05 04:11 CEST Last Modified: 07-Jul-05 04:11 CEST ====================================================================== Summary: Missing columns in the file sql/postgresql/add_usermap.psql. Description: There is only one column in the sql statement.
-- ACTUAL -- CREATE TABLE dbmail_usermap( user_idnr INT8 REFERENCES dbmail_users(user_idnr) ON UPDATE CASCADE ON DELETE CASCADE, userid VARCHAR(100) ); CREATE INDEX usermap_userid_idx ON dbmail_usermap(userid); -- DESIRED -- CREATE TABLE dbmail_usermap( user_idnr INT8 REFERENCES dbmail_users(user_idnr) ON UPDATE CASCADE ON DELETE CASCADE, login VARCHAR(100) NOT NULL, sock_allow VARCHAR(100) NOT NULL, sock_deny VARCHAR(100) NOT NULL, userid VARCHAR(100) NOT NULL ); CREATE INDEX usermap_userid_idx ON dbmail_usermap(userid); ====================================================================== Bug History Date Modified Username Field Change ====================================================================== 07-Jul-05 04:11tmatsuo New Bug ======================================================================