Categories and Sub-Categories (depending on how you want to customize your upload/download directories and display pages for the uploaded content) should probably have (or at least mine have in similar situations):
Unique Id Short Description (for display) Long Description (for help) Sub-Directory where any files may be stored An Access "CODE", usually 20 characters in length tops that offers quick identification for custom queries later (its easier to remember BODPROFILE than Category 21). A Bit field to turn the category/sub-category off for maintenance needs (precautionary) A Discontinue Date (so you can permanently disable the type of upload document if it becomes obsolete but retain the linked information to your master upload tables). And Finally perhaps an administrative code or access level so that you can integrate security (preventing some categories/sub-categories from now showing as viable upload or download options when searching or view the "board of directors" page). There are a few of my ideas and how I have accomplished this in the past. I'm sure there are plenty others. -----Original Message----- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 12:00 PM To: CF_OpenSource Subject: doing a content mangement system, very simple need some ideas Ok I have a project that needs to content management solution. I figured since i have CoSmoS i will release the code as GPL once I am done with it, but anyways here is my problemo. I am doing a website for a home owners association and it has to be easy. They want a place to put board of directors, links, upload documents, edit the front page, stuff like that. The problem I am having is this, should I have categories, then subcategories, should the subcategories have a definition of what they are, like a link, a file, or directory? Anyone have some insight they can give me. It's gonna start out simple then get complicated eventually. Robert Everland III Dixon Ticonderoga ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
