Simple CMS DB setup

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Khorask
Forum Newbie
Posts: 6
Joined: Fri Apr 28, 2006 10:14 am

Simple CMS DB setup

Post 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
User avatar
Hurreman
Forum Commoner
Posts: 61
Joined: Sat Apr 29, 2006 8:42 am

Post 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.
Post Reply