Re: [PHP] Best practices for deleting and restoring records - moving vs flagging

2005-08-12 Thread Jochem Maas
Saqib Ali wrote: Hello All, What are best practices for deleting records in a DB. We need the ability to restore the records. Two obvious choices are: 1) Flag them deleted or undeleted 2) Move the deleted records to seperate table for deleted records. We have a complex schema. However the th

Re: [PHP] Best practices for deleting and restoring records - moving vs flagging

2005-08-11 Thread James Kaufman
On Thu, Aug 11, 2005 at 10:47:09AM -0700, Saqib Ali wrote: > Hello All, > > What are best practices for deleting records in a DB. We need the > ability to restore the records. > > Two obvious choices are: > > 1) Flag them deleted or undeleted > 2) Move the deleted records to seperate table for d

[PHP] Best practices for deleting and restoring records - moving vs flagging

2005-08-11 Thread Saqib Ali
Hello All, What are best practices for deleting records in a DB. We need the ability to restore the records. Two obvious choices are: 1) Flag them deleted or undeleted 2) Move the deleted records to seperate table for deleted records. We have a complex schema. However the the records that need