NYCPHP Meetup

NYPHP.org

[nycphp-talk] DB Schema for storing revision history?

David Krings ramons at gmx.net
Wed Jun 27 12:43:49 EDT 2007


Jake McGraw wrote:
> Hi All, this is my first post, so if this is in the wrong section
> please let me know.
> 
> I'd like to know if anyone has developed a database schema for storing
> the revision history for a plain text document by multiple users.
> Basically, I'm talking about a wiki, but something much more simple.
> Any suggestions on methods of organizing the information using SQL
> (specifically MySQL) would be much appreciated.
> 
> Thanks!
> - jake

I'd just keep individual copies of the text files in the file system and 
then use a db table to keep track of the file location and their 
chronological sequence using a UNIX time stamp. Can't think of any 
easier way to do it.

David




More information about the talk mailing list