Page 1 of 1

Simple CMS DB setup

Posted: Mon May 01, 2006 4:37 am
by Khorask
I need to create a very simple CMS to add/edit and remove pages. Not allowed to use a third party CMS, as it has to be created from scratch.

Just a little confused with how I should structure the DB? I only have a pageID, pageName and pageComment thus far. should I store page content in the DB ? or just a link where I can get the page contents. Also what other fields should I include?

Thanks

Posted: Mon May 01, 2006 12:59 pm
by Hurreman
It all depends on what you're trying to do. Will you have multiple users, will the pages be sorted in any certain matter (by date, id, title, other?)...

You could start out with a pageID, pageTopic, pageContent. I tend to have additional fields such as date, category, author, type, security level, and so on, but once again, it's all up to what you're trying to achieve.