Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Database Table for Personal Blog Website

Table structure for table admins

ColumnTypeNull
idint(11)No
adminnamevarchar(255)No
adminusernamevarchar(255)No
adminpasswordvarchar(255)No

Table structure for table article

ColumnTypeNull
idint(11)No
article_titlevarchar(255)No
article_authorvarchar(255)No
article_contenttextNo
article_imagevarchar(255)No
article_datestampint(11)No
article_datevarchar(255)No
article_seovarchar(255)No
article_categoryvarchar(255)No
article_readcountint(11)No
numberofcommentint(11)No

Table structure for table category

ColumnTypeNull
idint(11)No
categorynamevarchar(255)No

Table structure for table comments

ColumnTypeNull
idint(11)No
comments_articleidint(11)No
comments_usersidint(11)No
comments_contenttextNo
comments_datestampint(11)No
comments_datevarchar(255)No
comments_confirmationint(1)No
comments_replyidint(11)No

Table structure for table hit

ColumnTypeNull
idint(11)No
IPvarchar(255)No
countvarchar(255)No

Table structure for table settings

ColumnTypeNull
idint(1)No
titlevarchar(255)No
descriptionvarchar(255)No
keywordstextNo
linkvarchar(255)No
emailvarchar(255)No
aboutmetextNo
smtphostvarchar(255)No
smtpportvarchar(255)No
encryptionvarchar(255)No
smtpusernamevarchar(255)No
smtppasswordvarchar(255)No
myskillstextNo

Table structure for table slideshow

ColumnTypeNull
idint(11)No
slideimagevarchar(255)No

Table structure for table users

ColumnTypeNull
idint(11)No
users_usernamevarchar(255)No
users_passwordvarchar(255)No
users_datestampint(11)No
users_datevarchar(255)No
users_ipnovarchar(255)No
users_websitevarchar(255)No
users_numberofcommentint(11)No
users_emailtextNo

Leave a reply

About StudentProjects.Live

A collection of source codes that I wrote in Android, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone.

Follow Me