you are severely re-inventing the wheel.

Look for CVS or RCS programs on the net.

you'll save yourself a ton of work.

> -----Original Message-----
> From: Dave Freeman [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 6:27 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Revision Tracking - program concept
> 
> 
> G'day All
> 
> I'm writing an application for an intranet environment.  At the moment I'm 
> writing a document control system.  The intention is that people will be 
> able to check in documents (generally created in MS Word from 
> templates) and the app will upload them to the server.
> 
> The process related to this involves other people then checking the 
> documents back out and making appropriate changes based on their 
> responsibilities and then checking the documents back into the system 
> again.
> 
> What I would like to do is keep track of each revision of these documents 
> (ie. actually provide a capability to review earlier revisions, or, indeed, 
> revert to earlier revisions).
> 
> At this stage I am planning to track information about each document in 
> an SQL table but not actually store the binary data in the table (there are 
> additional reasons behind this).
> 
> The only solution I've come up with that will easily implement some sort of 
> revision system would be to store only the last five, for example, revisions 
> and then use duplicate SQL tables to store older iterations of the 
> document with suitable links in the SQL back to the current version.
> 
> Can anyone suggest an alternate approach that will let me do this?
> 
> More from a program logic point of view than from an actual code example 
> point of view really.  I guess that makes this close to off-topic but there 
> you go - hopefully it won't be considered too out of place.
> 
> CYA, Dave
> 
> 
> -----------------------------------------------------------------------
> Outback Queensland Internet - Longreach, Outback Queensland - Australia
> http://www.outbackqld.net.au          mailto:[EMAIL PROTECTED]
> -----------------------------------------------------------------------
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to