create table s7_ note
(
id mediumint unsigned not null auto_ inc rement c omment 'Id',
title varchar(100) not null comment 'title ',
content longtext not null comment 'content',
addtime datetime not null default current_timestamp comment 'Add time',
ip int not null comment 'IP address' ,
primary key(id)
)engine=InnoDB default charset utf8 comment 'Message table';
