Most content intensive websites I develop, rely use MySQL tables with a standard ID for the primary key.
I've came across a problem with this a few times before, but recently I found it in a table for Bentley Bear:
|CREATE TABLE photos (|
id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
gallery VARCHAR(3) NOT NULL,
title VARCHAR(20) NOT NULL,
description TEXT NOT NULL,
PRIMARY KEY (id)
The problem comes in the admin panel: When the owner deletes a record, the ID of that deleted record then becomes depreciated. I need the column ID to be linear (1, 2, 3, etc), with no number jumps.
Is there a way this can be accomplished?