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?
QuoteIs this by design?
Yes, we've decided to keep data integrity rules in the KonaKart business logic rather than the data layer.