The following issue has been CLOSED ====================================================================== http://dbmail.org/mantis/view.php?id=920 ====================================================================== Reported By: alan Assigned To: ====================================================================== Project: DBMail Issue ID: 920 Category: installation scripts Reproducibility: always Severity: minor Priority: normal Status: closed target: Resolution: no change required Fixed in Version: 3.0.1 ====================================================================== Date Submitted: 26-Aug-11 18:52 CEST Last Modified: 14-Feb-12 16:23 CET ====================================================================== Summary: Differences between scripts Description: There are differences between create_tables.mysql and 2_2-3_0.mysql
Some id's are UNSIGNED, others are SIGNED. Foreign key and indexes are named differently. 2_2-3_0.mysql ============= Some id's (dbmail_acl) are UNSIGNED, others (dbmail_aliases.alias_idnr dbmail_aliases.client_idnr dbmail_envelope) are SIGNED ALTER TABLE dbmail_sievescripts ADD UNIQUE INDEX dbmail_sievescripts_1 (owner_idnr, name); create_tables.mysql =================== UNIQUE KEY `owner_idnr_2` (`owner_idnr`,`name`), As I haven't looked at our schema for some while, I would like to make future updates easier by making it as consistent with the release default. Thought I would ask which is the preferred script, ====================================================================== ---------------------------------------------------------------------- (0003398) alan (reporter) - 14-Feb-12 16:06 http://dbmail.org/mantis/view.php?id=920#c3398 ---------------------------------------------------------------------- 2_2-3_0.mysql.diff updates the update script to more closely align with create_tables.mysql Please feel free to close this issue with or without applying the patch. ---------------------------------------------------------------------- (0003399) paul (administrator) - 14-Feb-12 16:23 http://dbmail.org/mantis/view.php?id=920#c3399 ---------------------------------------------------------------------- Alan, thanks for the patch, but this was resolved using a different strategy. Issue History Date Modified Username Field Change ====================================================================== 26-Aug-11 18:52 alan New Issue 14-Feb-12 16:04 alan File Added: 2_2-3_0.mysql.diff 14-Feb-12 16:06 alan Note Added: 0003398 14-Feb-12 16:23 paul Note Added: 0003399 14-Feb-12 16:23 paul Status new => closed 14-Feb-12 16:23 paul Resolution open => no change required 14-Feb-12 16:23 paul Fixed in Version => 3.0.1 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
