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 주소',

기본 키(id)

)engine=InnoDB 기본 charset utf8 comment '메시지 테이블';