服务端与客户端连接数据库建表语句,有3张表
CREATE TABLE `book_man_sys_user` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`username` VARCHAR(50) NOT NULL,
`password` VARCHAR(50) NOT NULL,
`token` VARCHAR(50) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `username` (`username`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `book_man_sys_books` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`bookname` VARCHAR(50) NOT NULL,
`author` VARCHAR(50) NOT NULL,
`category` VARCHAR(50) NOT NULL,
`count` INT(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `bookname` (`bookname`)
)
COLLATE='utf8_general_ci'