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

Bug #537037 reported by Julian Lam on 2010-03-11
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MacCMS
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.

Julian Lam (julian-lam) wrote :

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

Informally targetting to v1.0

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  Edit
Everyone can see this information.

Other bug subscribers