我的sql1

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50150
Source Host : localhost:3306
Source Database : erp

Target Server Type : MYSQL
Target Server Version : 50150
File Encoding : 65001

Date: 2018-12-04 20:22:38
*/

SET FOREIGN_KEY_CHECKS=0;

---

– Table structure for users

---

DROP TABLE IF EXISTS users;
CREATE TABLE users (
USER_ID int(11) NOT NULL AUTO_INCREMENT COMMENT ‘用户代码’,
MYID varchar(50) DEFAULT NULL COMMENT ‘用户自编码’,
ACCOUNT varchar(50) DEFAULT NULL COMMENT ‘账号’,
NAME varchar(50) DEFAULT NULL COMMENT ‘名称’,
ORGANIZE_ID int(11) DEFAULT NULL COMMENT ‘组织代码’,
ORGANIZE_NAME varchar(255) DEFAULT NULL COMMENT ‘组织名称’,
DUTY_ID int(11) DEFAULT NULL COMMENT ‘称位代码 表:SYSTEM_CODE position’,
TITLE_ID int(11) DEFAULT NULL COMMENT ‘职等代码 表:SYSTEM_CODE title’,
PASSWORD varchar(128) DEFAULT NULL COMMENT ‘密码’,
EMAIL varchar(200) DEFAULT NULL COMMENT ‘电子邮箱’,
LANG varchar(20) DEFAULT NULL COMMENT ‘语言’,
THEME varchar(20) DEFAULT NULL COMMENT ‘样式’,
FIRST_VISIT datetime DEFAULT NULL COMMENT ‘第一次登录’,
PREVIOUS_VISIT datetime DEFAULT NULL COMMENT ‘上一次登录’,
LAST_VISITS datetime DEFAULT NULL COMMENT ‘最后一次登录’,
LOGIN_COUNT int(10) DEFAULT NULL COMMENT ‘登录资数’,
ISEMPLOYEE int(1) DEFAULT NULL COMMENT ‘是否是职工’,
STATUS char(10) DEFAULT NULL COMMENT ‘状态’,
IP varchar(20) DEFAULT NULL COMMENT ‘IP地址’,
DESCRIPTION varchar(2000) DEFAULT NULL COMMENT ‘备注’,
QUESTION_ID int(10) DEFAULT NULL COMMENT ‘问题代码’,
ANSWER varchar(100) DEFAULT NULL COMMENT ‘回复’,
ISONLINE int(1) DEFAULT NULL COMMENT ‘是否在线’,
CREATED datetime DEFAULT NULL COMMENT ‘创造日期’,
LASTMOD datetime DEFAULT NULL COMMENT ‘修改日期’,
CREATER int(10) DEFAULT NULL COMMENT ‘创建人’,
MODIFYER int(10) DEFAULT NULL COMMENT ‘修改人’,
TEL varchar(30) DEFAULT NULL COMMENT ‘用户电话’,
identity varchar(10) DEFAULT NULL,
assessstatus varchar(10) DEFAULT NULL,
assessdate date DEFAULT NULL,
assessresult varchar(50) DEFAULT NULL,
teacher varchar(50) DEFAULT NULL,
head varchar(50) DEFAULT NULL,
customer varchar(50) DEFAULT NULL,
delstatus varchar(10) DEFAULT ‘’,
sex varchar(10) DEFAULT NULL,
rank varchar(50) DEFAULT NULL,
depertment varchar(50) DEFAULT NULL,
teachername varchar(50) DEFAULT NULL,
headname varchar(50) DEFAULT NULL,
customername varchar(50) DEFAULT NULL,
planstatus varchar(50) DEFAULT NULL,
PRIMARY KEY (USER_ID)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COMMENT=‘用户资料表’;

---

– Records of users

---

INSERT INTO users VALUES (‘1’, ‘admin’, ‘admin’, ‘admin’, ‘2’, ‘MIS’, null, null, ‘admin’, ‘12@qq.com’, null, null, null, null, null, null, null, ‘A’, null, ‘111111’, null, null, null, null, ‘2013-06-14 00:00:00’, ‘1’, ‘1’, ‘1111111’, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO users VALUES (‘25’, ‘001’, ‘001’, ‘张三’, ‘2’, ‘MIS’, null, null, ‘11’, ‘111’, null, null, null, null, null, null, null, ‘I’, null, ‘111’, null, null, null, ‘2018-12-03 20:17:21’, ‘2018-12-03 20:19:57’, ‘1’, ‘1’, ‘11’, null, null, null, null, null, null, null, ‘’, null, ‘主管工程师(四级)-HW’, ‘主管工程师(四级)-HW’, ‘赵四’, ‘赵四’, ‘赵四’, ‘0’);
INSERT INTO users VALUES (‘26’, ‘005’, ‘005’, ‘张三’, null, null, null, null, ‘001’, null, null, null, null, null, null, null, null, ‘A’, null, null, null, null, null, ‘2018-12-04 13:13:46’, ‘2018-12-04 13:14:14’, ‘26’, ‘27’, null, ‘3’, ‘1’, null, ‘无’, ‘’, ‘’, ‘’, null, ‘1’, ‘主管工程师(四级)-HW’, ‘西安HW云服务实施一部’, ‘赵四’, ‘赵四aaa’, ‘赵四’, ‘0’);
INSERT INTO users VALUES (‘27’, ‘002’, ‘002’, ‘李四’, ‘12’, ‘123’, null, null, ‘002’, ‘002’, null, null, null, null, null, null, null, ‘A’, null, ‘’, null, null, null, ‘2018-12-03 20:20:50’, ‘2018-12-03 20:20:50’, ‘1’, ‘1’, ‘002’, ‘1’, ‘0’, null, null, null, null, null, ‘1’, ‘1’, ‘主管工程师(四级)-HW’, ‘西安HW云服务实施一部’, ‘赵四’, ‘赵四’, ‘赵四’, ‘0’);
INSERT INTO users VALUES (‘28’, ‘003’, ‘003’, ‘王五’, null, null, null, null, ‘003’, null, null, null, null, null, null, null, null, ‘A’, null, null, null, null, null, ‘2018-12-04 12:58:14’, ‘2018-12-04 12:58:32’, ‘28’, ‘27’, null, ‘2’, ‘1’, null, ‘无’, ‘002’, ‘’, ‘’, null, ‘’, ‘主管工程师(四级)-HW’, ‘西安HW云服务实施二部’, ‘赵四1’, ‘赵四1’, ‘赵四1’, ‘1’);
INSERT INTO users VALUES (‘29’, ‘004’, ‘004’, ‘李l六’, null, null, null, null, ‘004’, null, null, null, null, null, null, null, null, ‘A’, null, null, null, null, null, ‘2018-12-04 13:14:18’, ‘2018-12-04 13:15:42’, ‘29’, ‘27’, null, ‘3’, ‘1’, ‘2018-12-10’, ‘1’, ‘002’, ‘’, ‘’, null, ‘1’, ‘主管工程师(四级)-HW’, ‘西安HW云服务实施一部’, ‘赵四2’, ‘赵四2’, ‘赵四’, ‘1’);
INSERT INTO users VALUES (‘40’, ‘006’, ‘006’, ‘小明’, null, null, null, null, ‘’, null, null, null, null, null, null, null, null, ‘A’, null, null, null, null, null, ‘2018-12-04 19:32:22’, ‘2018-12-04 19:34:07’, ‘40’, ‘1’, null, ‘3’, ‘1’, ‘2018-12-04’, ‘’, ‘002’, ‘’, ‘’, null, ‘1’, ‘主管工程师(四级)-HW’, ‘西安HW云服务实施一部’, ‘李四’, ‘李四1’, ‘李四1’, ‘0’);