The following issue has been CLOSED ====================================================================== http://dbmail.org/mantis/view.php?id=761 ====================================================================== Reported By: waza123 Assigned To: ====================================================================== Project: DBMail Issue ID: 761 Category: Database layer Reproducibility: always Severity: minor Priority: normal Status: closed target: Resolution: open Fixed in Version: ====================================================================== Date Submitted: 03-Feb-09 22:52 CET Last Modified: 04-Feb-09 09:43 CET ====================================================================== Summary: .sql for mysql bug Description: sql error in this commit for mysql:
http://git.dbmail.eu/paul/dbmail/?p=paul/dbmail;a=commitdiff;h=6bdfea2664dfca5347e5de631be312a152397166 DROP TABLE IF EXISTS dbmail_filters; CREATE TABLE dbmail_filters ( user_id BIGINT NOT NULL, id BIGINT NOT NULL AUTO_INCREMENT, headername varchar(128) NOT NULL, headervalue varchar(255) NOT NULL, mailbox varchar(100) NOT NULL, PRIMARY KEY (id), FOREIGN KEY (user_id) REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; think need this: PRIMARY KEY (id), instant of this: PRIMARY KEY (user_id, id), ====================================================================== ---------------------------------------------------------------------- (0002758) paul (administrator) - 04-Feb-09 09:43 http://dbmail.org/mantis/view.php?id=761#c2758 ---------------------------------------------------------------------- please do not report bugs against unreleased code in this tracker. Please do submit patches to dbmail-dev@dbmail.org or report them there if you can't. Issue History Date Modified Username Field Change ====================================================================== 03-Feb-09 22:52 waza123 New Issue 04-Feb-09 09:43 paul Note Added: 0002758 04-Feb-09 09:43 paul Status new => closed ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
