forked from ZongXR/SuperMarket
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathuser.sql
More file actions
14 lines (12 loc) · 433 Bytes
/
user.sql
File metadata and controls
14 lines (12 loc) · 433 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
create database if not exists supermarket;
use supermarket;
create table user(
id int primary key auto_increment,
username varchar(100),
password varchar(100),
nickname varchar(100),
email varchar(100)
);
insert into user values(null, 'admin', '123', '超级管理员', 'admin@supermarket.com');
insert into user values(null, '张三', '123', '管理员', 'admin@supermarket.com');
update user set password = md5(password);