1 Star 0 Fork 35

hsp / UPMS

forked from lyg945 / UPMS 
Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or download
sys_user.sql 6.47 KB
Copy Edit Web IDE Raw Blame History
lyg945 authored 2015-10-13 16:33 . 初始化项目,完成增删改查
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50624
Source Host : localhost:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 50624
File Encoding : 65001
Date: 2015-10-13 16:20:08
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`LOGIN_NAME` varchar(100) DEFAULT NULL,
`LOGIN_PWD` longtext,
`COMPANY_ID` int(11) DEFAULT NULL,
`SHOW_NAME` varchar(100) DEFAULT NULL,
`ORG_ID` int(11) DEFAULT NULL,
`ORG_NAME` varchar(100) DEFAULT NULL,
`EMAIL` longtext COMMENT '邮箱,必须唯一,用作密码找回',
`VER_EMAIL_FLAG` varchar(5) DEFAULT NULL COMMENT 'DICT_GLOBAL_YESNO 是Y,否N',
`VER_EMAIL_DATE` datetime DEFAULT NULL,
`FIRST_LANG` varchar(50) DEFAULT NULL,
`SEL_THEME` varchar(50) DEFAULT NULL,
`FIRST_VISIT_DT` datetime DEFAULT NULL,
`PRE_VISIT_DT` datetime DEFAULT NULL,
`LAST_VISIT_DT` datetime DEFAULT NULL,
`LAST_ERR_DT` datetime DEFAULT NULL,
`FIRST_VISIT_IP` varchar(100) DEFAULT NULL,
`PRE_VISIT_IP` varchar(100) DEFAULT NULL,
`LAST_VISIT_IP` varchar(100) DEFAULT NULL,
`LAST_ERR_IP` varchar(100) DEFAULT NULL,
`LOGIN_COUNT` int(11) DEFAULT NULL,
`EMPLOYEE_FLAG` varchar(5) DEFAULT NULL COMMENT 'DICT_GLOBAL_YESNO 是Y,否N',
`ONLINE_STATUS` varchar(5) DEFAULT NULL COMMENT 'DICT_SYS_ONLINE_STATUS:ONL在线、OFL离线、HID隐身',
`TELEPHONE` varchar(50) DEFAULT NULL,
`MP` varchar(50) DEFAULT NULL,
`MP_VAL_FLAG` varchar(5) DEFAULT NULL COMMENT 'DICT_GLOBAL_YESNO 是Y,否N',
`MP_VAL_TIME` datetime DEFAULT NULL,
`USER_TYPE` varchar(5) DEFAULT NULL COMMENT 'DICT_SYS_USER_TYPE:COM企业客户、AGT代理商、PEF个人免费客户、PEM个人会员客户、PEV个人VIP客户',
`QUESTION_FLAG` varchar(5) DEFAULT NULL COMMENT 'DICT_GLOBAL_YESNO 是Y,否N',
`MISC_DESC` longtext,
`STATUS` varchar(5) DEFAULT NULL COMMENT '状态:DICT_GLOBAL_STATUS 有效V、无效I、草稿D、待审核W',
`CREATE_TIME` datetime DEFAULT NULL,
`CREATE_OPER_ID` int(11) DEFAULT NULL,
`CREATE_OPER_NAME` varchar(50) DEFAULT NULL,
`LAST_MOD_TIME` datetime DEFAULT NULL,
`LAST_MOD_OPER_ID` int(11) DEFAULT NULL,
`LAST_MOD_OPER_NAME` varchar(50) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `FK_Reference_3` (`COMPANY_ID`) USING BTREE,
KEY `FK_Reference_4` (`ORG_ID`) USING BTREE,
CONSTRAINT `sys_user_ibfk_1` FOREIGN KEY (`COMPANY_ID`) REFERENCES `sys_company` (`ID`),
CONSTRAINT `sys_user_ibfk_2` FOREIGN KEY (`ORG_ID`) REFERENCES `sys_org_tree` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='用户,与compnay用户共用,包括系统的用户,个人客户,企业客户';
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1', 'lyg945', 'lyg945', '1', 'lyg945', null, '无线通讯', '544872316@qq.com', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '13564672700', '13564672700', null, null, '1', null, null, '1', null, null, null, null, null, null);
INSERT INTO `sys_user` VALUES ('2', 'zhangsan', 'E10ADC3949BA59ABBE56E057F20F883E', '1', '张三', '1', '无线通讯', '544872316@qq.com', '1', '2014-09-02 20:12:52', '英语', null, null, null, null, null, null, null, null, null, '0', null, null, '13564672700', '13564672700', null, null, null, null, null, 'V', null, null, null, null, null, null);
INSERT INTO `sys_user` VALUES ('3', 'lisi', 'E10ADC3949BA59ABBE56E057F20F883E', '1', '李四', '1', '无线通讯', '544872316@qq.com', '1', '2014-09-02 20:12:52', '韩语', null, null, null, null, null, null, null, null, null, '0', null, null, '13564672700', '13564672700', null, null, null, null, null, 'I', null, null, null, '2015-01-05 14:54:29', null, null);
INSERT INTO `sys_user` VALUES ('4', 'test', 'E10ADC3949BA59ABBE56E057F20F883E', '1', '游客', '1', '无线通讯', '544872316@qq.com', '1', '2014-09-02 20:12:52', '法语', null, null, null, null, null, null, null, null, null, '0', null, null, '13564672700', '13564672700', null, null, null, null, null, 'V', null, null, null, null, null, null);
INSERT INTO `sys_user` VALUES ('5', '123', 'E10ADC3949BA59ABBE56E057F20F883E', '1', 'guest', '1', '无线通讯', '544872316@qq.com', null, null, null, null, null, null, null, null, null, null, null, null, '0', 'N', null, '13564672700', '13564672700', null, null, 'PEF', null, '放大', 'V', null, null, null, '2014-09-14 16:32:43', null, null);
INSERT INTO `sys_user` VALUES ('12', 'fangke', 'E10ADC3949BA59ABBE56E057F20F883E', '1', '访客', '2', '无线通讯', '544872316@qq.com', null, null, null, null, null, null, null, null, null, null, null, null, '0', 'Y', null, '13564672700', '13564672700', null, null, 'COM', 'Y', 'dasdad', 'V', null, null, null, '2014-09-14 19:36:34', null, null);
INSERT INTO `sys_user` VALUES ('17', 'aaaaa', 'testtest', '1', 'aaaaa', null, null, '544872316@qq.com', null, null, null, null, null, null, null, null, null, null, null, null, null, '1', null, '13564672700', '13564672700', null, null, '1', null, null, '1', null, null, null, null, null, null);
INSERT INTO `sys_user` VALUES ('22', 'ChinaSailing', 'ChinaSailing', '1', 'ChinaSailing', null, '无线通讯', '544872316@qq.com', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '13564672700', '13564672700', null, null, '1', null, null, '1', null, null, null, null, null, null);
INSERT INTO `sys_user` VALUES ('23', 'Copyright', 'Copyright', '1', 'Copyright', null, '无线通讯', '544872316@qq.com', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '13564672700', '13564672700', null, null, '1', null, null, '1', null, null, null, null, null, null);
INSERT INTO `sys_user` VALUES ('25', '2222', '111111', '1', '2222', null, '无线通讯', '544872316@qq.com', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '13564672700', '13564672700', null, null, '1', null, null, '1', null, null, null, null, null, null);
INSERT INTO `sys_user` VALUES ('26', 'asd', '111111', null, 'asd', '2', null, '544872316@qq.com', null, null, null, null, null, null, null, null, null, null, null, null, null, '2', null, '1111', '18001670539', null, null, '1', null, null, '2', null, null, null, null, null, null);

Comment ( 0 )

Sign in for post a comment

Java
1
https://gitee.com/gspandy78/UPMS.git
git@gitee.com:gspandy78/UPMS.git
gspandy78
UPMS
UPMS
master

Search