The following issue has been CLOSED ====================================================================== http://www.dbmail.org/mantis/view.php?id=224 ====================================================================== Reported By: tmatsuo Assigned To: ====================================================================== Project: DBMail Issue ID: 224 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: closed Resolution: open Fixed in Version: ====================================================================== Date Submitted: 07-Jul-05 04:11 CEST Last Modified: 08-Feb-06 07:39 CET ====================================================================== 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); ====================================================================== Relationships ID Summary ---------------------------------------------------------------------- duplicate of 0000225 Missing table definition in the file sq... ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 07-Jul-05 04:11 tmatsuo New Issue 08-Feb-06 07:38 aaron Relationship added duplicate of 0000225 08-Feb-06 07:39 aaron Status new => closed ======================================================================