Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted March 25, 20213 yr am I right in saying the post_key column in the posts database table is no longer used for anything? is it ok to empty this column to reduce the size of the table?
March 25, 20213 yr 3 hours ago, sound said: am I right in saying the post_key column in the posts database table is no longer used for anything? is it ok to empty this column to reduce the size of the table? You would be very wrong. If I were you, I would leave it be. Here you can read about what that column does.
March 25, 20213 yr Author thanks but don't have permission to see the link/topic it's been empty for a fair few years now yep?
March 28, 20213 yr On 3/25/2021 at 7:42 PM, sound said: thanks but don't have permission to see the link/topic it's been empty for a fair few years now yep? You can read it below. Quote It's for attachments. Logically the code cannot connect attachments to a post ID when it's first uploaded to a non-published post, since the post isn't published yet (and have no post ID). So they use a generated post_key for the attachment table relation instead.