[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