Primary Key error on Digital Ocean database cluster
Hello -- We are hosting our Collective Access database on Digital Ocean's Managed Databases. Everything works great, good speed, etc. The only issue really is the persistent error from their admin., "Our systems have indicated that your MySQL cluster, db-mysql-*-*, has tables without primary keys". I am aware that it is a requirement of their service that all tables in a hosted database have primary keys. Apparently some Collective Access databases do not? Is there a way to remedy this so we don't get these errors, perhap to add primary keys to those tables that do have them? Thanks!