Primary Keys Missing
-
Column
id
is not set as the Primary Key on tableswp_shortpixel_folders
andwp_shortpixel_meta
. This may result in data loss for users using cloud MYSQL services, more specifically those who are scaling via row-based replication.DigitalOcean, for example, uses row-based replication and requires all database tables to specify a Primary Key https://www.digitalocean.com/docs/databases/mysql/how-to/create-primary-keys/
This is easily fixed by running:
ALTER TABLE wp_shortpixel_folders ADD PRIMARY KEY (id);
ALTER TABLE wp_shortpixel_meta ADD PRIMARY KEY (id);
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Primary Keys Missing’ is closed to new replies.