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';