I just started a blog or CMS. I want to ask that how many fields of database is ideal for a normal blog? Currently I have following fields. 1) post_id (which is an auto increment unique id of every post) 2) post_title (which is of course the title of every post.) 3)post_body (the content or the whole article) 4)comments (the comments to be posted by visitors for every post. By the way currently I don't know how to use it ) 5) date (the date when a particular post is submitted to the database) So are this fields enough or still I am missing some essential fields????
+ field "publish" with enum "yes" - "no". If is it set "yes" - all visitors can view your post, else - only you.
Table Posts: id title - For use within the blog post page metaDescription - For use within the meta description tag alias - Could use this for short menu links and within the URL published - 1/0 Flag, is this post published? publishDate - Timestamp of when it was published parent - The id of the parent post, 0 is none (good for categories) container - 1/0 Flag, is this is a container. It can be treated as a category content - The actual post content createdBy - The user id or 0 if anonymous of who created this post Table Keywords: id post_id keyword - a keyword that can be used to find the associated post Table Users: id username password - Preferebly an MD5 hash Table User Attributes: id user_id email phone gender avatar - Their avatar URL firstName lastName blocked - 1/0 Flag, if the user is blocked. They can't post or log in. failedLogins - How many failed logins have there been? if more than 3, block them session_id - To keep them logged in superuser - If this is set to 1, allow them to edit any posts lastLogin - Timestamp of their last login loginCount - How many times have they logged in?