Title: Primary Keys
Last modified: August 23, 2022

---

# Primary Keys

 *  Resolved [Compudata](https://wordpress.org/support/users/compudata/)
 * (@compudata)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/primary-keys/)
 * Hello,
 * The following tables have no primary key:
    prefix_aws_cache prefix_aws_index
 * For managed database clusters at DigitalOcean, this is a problem, since the primary
   key is required to exist on all tables for restoring, recovering, forking, etc:
   [https://docs.digitalocean.com/products/databases/mysql/how-to/create-primary-keys/](https://docs.digitalocean.com/products/databases/mysql/how-to/create-primary-keys/)
 * I noticed that to solve a migration issue a few months back, you had someone 
   simply drop the tables and re-index, etc. Will this re-create the tables with
   a primary key? If not, would you consider adding a primary key to these tables
   during creation to accommodate the subset of your users who utilize databases
   such as DigitalOcean’s managed database clusters?
 * Thanks in advance for your help.

Viewing 1 replies (of 1 total)

 *  Plugin Author [ILLID](https://wordpress.org/support/users/mihail-barinov/)
 * (@mihail-barinov)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/primary-keys/#post-15945126)
 * Hi,
 * For now you can use following code snippet to create table keys:
 *     ```
       add_action( 'aws_create_index_table', 'my_aws_create_index_table' );
       function my_aws_create_index_table() {
           global $wpdb;
           $table_name = $wpdb->prefix . AWS_INDEX_TABLE_NAME;
           $wpdb->query("
               ALTER TABLE {$table_name}
               ADD COLUMN <code>key</code> int(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT FIRST;
           ");
   
           $table_name = $wpdb->prefix . AWS_CACHE_TABLE_NAME;
           $wpdb->query("
               ALTER TABLE {$table_name}
               ADD COLUMN <code>key</code> int(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT FIRST;
           ");
       }
       ```
   
 * After add it please reindex plugin table.
 * Regards

Viewing 1 replies (of 1 total)

The topic ‘Primary Keys’ is closed to new replies.

 * ![](https://ps.w.org/advanced-woo-search/assets/icon-256x256.png?rev=3303984)
 * [Advanced Woo Search - Product Search for WooCommerce](https://wordpress.org/plugins/advanced-woo-search/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/advanced-woo-search/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/advanced-woo-search/)
 * [Active Topics](https://wordpress.org/support/plugin/advanced-woo-search/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/advanced-woo-search/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/advanced-woo-search/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [digitalocean](https://wordpress.org/support/topic-tag/digitalocean/)
 * [primary key](https://wordpress.org/support/topic-tag/primary-key/)

 * 1 reply
 * 2 participants
 * Last reply from: [ILLID](https://wordpress.org/support/users/mihail-barinov/)
 * Last activity: [3 years, 9 months ago](https://wordpress.org/support/topic/primary-keys/#post-15945126)
 * Status: resolved