- Issue created by @anaconda777
- 🇬🇧United Kingdom steven jones
I had this issue on a Drupal 7 site that was sort of close to going over the limit, the following code sorted it out:
db_add_index('queue', 'temp', ['item_id']); db_drop_primary_key('queue'); db_change_field('queue', 'item_id', 'item_id', array( 'type' => 'serial', 'size' => 'big', 'unsigned' => TRUE, 'not null' => TRUE, 'description' => 'Primary Key: Unique item ID.', ), [ 'primary key' => ['item_id'], ]); db_drop_index('queue', 'temp');
I imagine this sort of approach could be adapted very easily for Drupal 11.