[nycphp-talk] DB Schema for storing revision history?
Jon Baer
jonbaer at jonbaer.com
Wed Jun 27 13:48:45 EDT 2007
Subversion and WebSVN :-)
http://websvn.tigris.org/
On Jun 27, 2007, at 12:43 PM, David Krings wrote:
> 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
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20070627/fd88f414/attachment.html>
More information about the talk
mailing list