I guess, you could create a table with some colums like, 'last_modified',
'who_modified', 'document_path'.

  Then when someone makes a change, you save this changed document in a
folder with the name of the document, so it is easy, folder by folder, to
find all modified documents. You can even put some kind of 'log' file on
each folder, recording what has changed, if the second person does all
changes, or create another mysql colum. Save every document with a different
name (might be useful to store on format date_name.extension, to be useful
sortable by date), and update the mysql table.

  Ops, first update the table, generate an ID by auto_increment, saving this
ID on the 'log' file, to keep track of changes.


  Julio Nobrega.

2B||!BB - That's the question.

"Dave Freeman" <[EMAIL PROTECTED]> wrote in message
> 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,
> 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
> additional reasons behind this).
> The only solution I've come up with that will easily implement some sort
> revision system would be to store only the last five, for example,
> 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
> 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]

Reply via email to