Referential constraints

[Ted]

I've noticed that the MySQL database schema sql (konakart_demo.sql) doesn't have any foreign keys in its tables. Is this by design? Right now, it seems I manually would be able to delete a product (without using the KonaKart API) and everything pointing to its product id would be left orphan in the database?

[trevor]

Is this by design?

Yes, we've decided to keep data integrity rules in the KonaKart business logic rather than the data layer.