Ticket #1484844 (closed Patches: fixed)

Opened 10 months ago

Last modified 9 months ago

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

mysql5.initial.sql.diff (1.8 kB) - added by iezzip 10 months ago.

Change History

Changed 10 months ago by iezzip

Changed 10 months ago by till

  • owner set to thomasb

Changed 9 months ago by thomasb

  • status changed from new to closed
  • resolution set to fixed

fixed in trunk

Note: See TracTickets for help on using tickets.