Ticket #1484844 (closed Patches: fixed)
InnoDB in MySQL5
| Reported by: | iezzip | Owned by: | thomasb |
|---|---|---|---|
| Priority: | 5 | Milestone: | 0.1.1 |
| Component: | Database | Version: | 0.1-stable |
| Severity: | normal | Keywords: | |
| Cc: |
Description
I still don't get it why you guys provide wonderful foreign key constraints in the SQL/mysql5.initial.sql table definitions without actually using them. CONSTRAINT definitions only work in MySQL >= 5.x if you use the InnoDB table format. In Roundcube's CREATE TABLE definitions you are still using MYISAM. As Roundcube should be still compatible with older MySQL-versions (I actually don't care) and though can not make any usage of these fk's it would still be nice to tidy this up. I wrote some controlpanel-to-webmail hooks that create and remove identities in Roundcube. Those foreign key constraints made it a lot easier.
Attachments
Change History
Note: See
TracTickets for help on using
tickets.
