Skip to main content
Inspiring
October 7, 2008
Question

ID for oft deleted data

  • October 7, 2008
  • 1 reply
  • 379 views
I am created an ad site where people can upload an ad to stay for two weeks before being automatically deleted. I first thought of using auto increment to create the product Id, but I realize that this would cause problems later when their record is deleted.

I need advise on the best way to create an appropriate product ID in a scenario where the id field will constantly change (updated). When a record it deleted it ID could be used again.

Thanks
    This topic has been closed for replies.

    1 reply

    Inspiring
    October 7, 2008
    I don't see what problems it would create. But, if you want to use something else, how about making the field char(35) and create uuids to get the values.