一.项目功能结构
1.功能
2.实体
3.对应sql语句
CREATE DATABASE shop;
use shop;
create table user(
id int(11) primary key auto_increment,
username varchar(100),
password varchar(100),
nickname varchar(100),
type int(5)
);
INSERT INTO user VALUES (null,'admin','7946521','管理员',1);
CREATE TABLE address(
id INT(10) PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255),
phone VARCHAR(100),
postcode VARCHAR(100),
user_id INT(10),
CONSTRAINT FOREIGN KEY (user_id) REFERENCES