3 建表

DROP TABLE IF EXISTS sys_user;
CREATE TABLE sys_user (
id int NOT NULL AUTO_INCREMENT,
username varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
password varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
email varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
phone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

— ——————————————
— Records of sys_user
— ——————————————
INSERT INTO sys_user VALUES (1, ‘admin’, ‘123456’, ‘管理员’, ‘12306@qq.com’, ‘15655556666’);

SET FOREIGN_KEY_CHECKS = 1;