Thanks for the reply. I understand that I can use SVN for
version
control of the software I'm building, but I'm thinking of
version
control of the pages in the CMS software, not the software
itself.
Here's a scenario of what I'd like to happen:
User logs in to CMS software, and updates a page. That page
then goes
to a queue where someone else can approve/deny the page.
When
approved, the page becomes live on the site. However, if
they want,
they can revert back to the old page. Here's the brief MySQL
table
layouts I just thought of:
revisions:
id
page_id
created
modified
title
body
pages:
id
revision_id
All the live pages would be queried from pages, but the
actual content
would be in revisions. The revision_id field in pages would
determine
what revision to reference, and the page_id field in
revisions would
determine which revisions were available to use. I'm trying
to do
something like a wiki. Would this be a good approach?
On Mar 2, 6:34 am, "lalit shakya"
<opposite... gmail.com> wrote:
> 1. You can use SVN for version control
> 2. Design and development of CMS you need the core
engine which must
> control everything for the system like layout page
service etc
> 3. for more detial you can email to me opposite...gmail.com
>
> On 3/1/07, BlenderStyle <BlenderSt...gmail.com> wrote:
>
>
>
> > I want to design a content managment system with
version control so I
> > can revert to previous versions of pages if
necessary. I also want a
> > workflow, so pages have to be approved before
they're live. I'm not
> > sure how to approach this problem. My pages will
be stored in MySQL.
> > Should I insert a new row for every change?
--~--~---------~--~----~------------~-------~--~----~
This group is managed and maintained by the development
staff at 360 PSG. An enterprise application development
company utilizing open-source technologies for todays
small-to-medium size businesses.
For information or project assistance please visit :
http://www.360psg.com
You received this message because you are subscribed to the
Google Groups "Professional PHP Developers"
group.
To post to this group, send email to Professional-PHPgooglegroups.com
To unsubscribe from this group, send email to
Professional-PHP-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/Professional-PHP
-~----------~----~----~----~------~----~------~--~---
|
