建立数据库:
CREATE DATABASE `company` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
建立表user(用户信息):
CREATE TABLE `company`.`user` (
`uid` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`pass` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
PRIMARY KEY ( `uid` )
) ENGINE = InnoDB;
表message(用户留言详情):
CREATE TABLE `company`.`message` (
`author` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`title` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`content` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`date` DATE NOT NULL
) ENGINE = InnoDB;
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。