CREATE TABLE user(
   userId INT PRIMARY KEY AUTO_INCREMENT,
	 username VARCHAR(225) UNIQUE NOT NULL,
	 password VARCHAR(225) NOT NULL,
	 realName VARCHAR(225) NOT NULL
	 )
	 
	 
	 
CREATE TABLE book(
   bookId INT PRIMARY KEY AUTO_INCREMENT,
   bookName VARCHAR(225) NOT NULL,
   bookType VARCHAR(225) NOT NULL,
   bookWriter VARCHAR(225) NOT NULL
);

	 
	 
INSERT INTO user (username, password, realName) 
VALUES 
('zhangsan', 'password123', '张三'),
('lisi', 'password456', '李四'),
('wangwu', 'password789', '王五'),
('zhaoliu', 'password101', '赵六'),
('sunqi', 'password202', '孙七');

INSERT INTO book (bookName, bookType, bookWriter) 
VALUES 
('三国演义', '历史', '罗贯中'),
('红楼梦', '古典文学', '曹雪芹'),
('西游记', '神话', '吴承恩'),
('水浒传', '历史', '施耐庵'),
('聊斋志异', '志怪', '蒲松龄');