Database Design

1, Create a new database onecms

CREATE DATABASE onecms;

2, create a new message table:

CREATE TABLE message(

id int(11) not null primary key auto_increment,

title varchar(255) NOT NULL,

content text NOT NULL)

ENGINE=InnoDB DEFAULT CHARSET=utf8;

3, the table structure is as shown below: