-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysql.sql
20 lines (19 loc) · 961 Bytes
/
mysql.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
-- ----------------------------
-- Table structure for `SYS_USER`
-- ----------------------------
DROP TABLE IF EXISTS `SYS_USER`;
CREATE TABLE `SYS_USER` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account` varchar(50) NOT NULL COMMENT '登录名',
`password` varchar(100) NOT NULL COMMENT '密码(加密)',
`lastLoginIp` varchar(20) DEFAULT NULL COMMENT '最后登录IP',
`lastLoginTime` datetime DEFAULT NULL COMMENT '最后登录时间',
`loginCount` int(11) NOT NULL COMMENT '登录总次数',
`createTime` datetime NOT NULL COMMENT '创建时间',
`isEnable` int(1) NOT NULL COMMENT '是否启用',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户表';
-- ----------------------------
-- Records of SYS_USER
-- ----------------------------
INSERT INTO `SYS_USER` VALUES ('2', 'admin', '26524bdf4ea266f131566a89e8f4972c', '0:0:0:0:0:0:0:1', '2018-09-13 16:28:02', '216', '2015-06-02 11:31:56', '1');