create DATABASE mmall;
use mmall;
CREATE TABLE user(
	id int(11) not null,
	login_name varchar(255) not null,
	user_name varchar(255) not null,
	password varchar(255) not null,
	gender int(11) not null,
	identity_code varchar(60),
	email varchar(80),
	mobile varchar(11),
	file_name varchar(255),
	create_time datetime not null,
	update_time datetime not null,
	PRIMARY key(id)
);

CREATE TABLE `order`(
	id int(11) not null,
	user_id int(11),
	login_name varchar(255),
	user_address varchar(255),
	cost float,
	serialnumber varchar(255),
	create_time datetime,
	update_time datetime not null,
	PRIMARY key(id)
);

CREATE TABLE `cart`(
	id int(11) not null,
	product_id int(11),
	quantity int(11),
	cost int(11),
	user_id int(11),
	create_time datetime not null,
	update_time datetime not null,
	PRIMARY key(id)
);

CREATE TABLE `product`(
	id int(11) not null,
	`name` varchar(200) not null,
	description varchar(1024),
	price float not null,
	stock int(11) not null,
	categorylevelone_id int(11),
	categoryleveltwo_id int(11),
	categorylevelthree_id int(11),
	file_name varchar(200),
	PRIMARY key(id)
);

INSERT into user
VALUES(1,'admin','管理员','000000',0,'13040619830214189','hello@bdqn.com','1583233515','7.jpg','2020-05-18 06:22:27','2020-05-18 06:22:32');