CREATE DATABASE IF NOT EXISTS library;
USE library;

CREATE TABLE IF NOT EXISTS `user`(userUserName VARCHAR(20),userPwd VARCHAR(20),userName VARCHAR(20),userSex CHAR(1),userPhone VARCHAR(11));

CREATE TABLE IF NOT EXISTS `seller`(sellerUserName VARCHAR(20),sellerPwd VARCHAR(20),sellerName VARCHAR(20),sellerSex CHAR(1),sellerPhone VARCHAR(11));

CREATE TABLE IF NOT EXISTS `admin`(adminUserName VARCHAR(20),adminPwd VARCHAR(20));

CREATE TABLE IF NOT EXISTS `buyBooks`(bookID VARCHAR(20),bookName VARCHAR(20),buyPrice DOUBLE,number INT,
remarks VARCHAR(20));

CREATE TABLE IF NOT EXISTS `saleBooks`(bookID VARCHAR(20),bookName VARCHAR(20),salePrice DOUBLE,number INT,
remarks VARCHAR(20));

CREATE TABLE IF NOT EXISTS `userOrders`(userName VARCHAR(20),orderID INT PRIMARY KEY AUTO_INCREMENT,bookID VARCHAR(20),bookName VARCHAR(20),number INT);

CREATE TABLE IF NOT EXISTS `msgBoard`(userName VARCHAR(20),content VARCHAR(100));