Cage System does not use InnoDB tables, thus no foreign keys

Bug #537037 reported by Julian Lam
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MacCMS
Confirmed
Wishlist
Unassigned

Bug Description

Chose MyISAM only because I didn't know better - foreign keys would allow for
more server-side reliability, instead of relying on PHP code as with the MyISAM
table.

Not a major problem, since I designed around it, but it should be fixed in the
future.

Revision history for this message
Julian Lam (julian-lam) wrote :

InnoDB also supports transactions, which may be important (even critical) for accessory sales.

Informally targetting to v1.0

Revision history for this message
Julian Lam (julian-lam) wrote :

As MySQL supports table-type mixing, the following tables require changing to the InnoDB engine:
authz
contracts
accessories (for transaction support)

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.