create table s7_ note

(

id mediumint unsigned not null auto_ inc rement comment 'Id',

title varchar(100) not null comment 'title',

content longtext not null comment 'content',

Addtime datetime not null default current_timestamp comment 'Time hinzufügen',

ip int not null comment 'IP address',

Primary Key(id)

)engine=InnoDB default charset utf8 comment 'Message table';