代码拉取完成,页面将自动刷新
同步操作将从 佛山市贝密信息科技有限公司/UCKeFu 强制同步,此操作会覆盖自 Fork 仓库以来所做的任何修改,且无法恢复!!!
确定后同步将在后台操作,完成时将刷新页面,请耐心等待。
/*
Navicat MySQL Data Transfer
Source Server : 127.0.0.1
Source Server Version : 50554
Source Host : localhost:3306
Source Database : uckefu
Target Server Type : MYSQL
Target Server Version : 50554
File Encoding : 65001
Date: 2017-03-16 18:53:20
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `uk_agentservice`
-- ----------------------------
DROP TABLE IF EXISTS `uk_agentservice`;
CREATE TABLE `uk_agentservice` (
`id` varchar(100) NOT NULL DEFAULT '',
`username` varchar(100) DEFAULT '',
`agentno` varchar(100) DEFAULT '',
`userid` varchar(100) DEFAULT '',
`channel` varchar(100) DEFAULT '',
`logindate` datetime DEFAULT NULL,
`source` varchar(100) DEFAULT '',
`endtime` datetime DEFAULT NULL,
`nickname` varchar(100) DEFAULT '',
`city` varchar(100) DEFAULT '',
`province` varchar(100) DEFAULT '',
`country` varchar(100) DEFAULT '',
`headImgUrl` varchar(100) DEFAULT '',
`waittingtime` int(11) DEFAULT '0',
`tokenum` int(11) DEFAULT '0',
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`status` varchar(100) DEFAULT '',
`appid` varchar(100) DEFAULT '',
`sessiontype` varchar(100) DEFAULT '',
`contextid` varchar(100) DEFAULT '',
`agentserviceid` varchar(100) DEFAULT '',
`orgi` varchar(100) DEFAULT '',
`snsuser` varchar(100) DEFAULT '',
`lastmessage` datetime DEFAULT NULL,
`waittingtimestart` datetime DEFAULT NULL,
`lastgetmessage` datetime DEFAULT NULL,
`lastmsg` varchar(100) DEFAULT '',
`agentskill` varchar(100) DEFAULT '',
`name` varchar(255) DEFAULT NULL COMMENT '名称',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`creater` varchar(255) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_user` varchar(255) DEFAULT NULL COMMENT '修改人',
`assignedto` varchar(255) DEFAULT NULL COMMENT '分配目标用户',
`wfstatus` varchar(255) DEFAULT NULL COMMENT '流程状态',
`shares` varchar(255) DEFAULT NULL COMMENT '分享给',
`owner` varchar(255) DEFAULT NULL COMMENT '所属人',
`datadept` varchar(255) DEFAULT NULL COMMENT '创建人部门',
`intime` int(32) DEFAULT NULL,
`batid` varchar(32) DEFAULT NULL,
`ipaddr` varchar(50) DEFAULT NULL,
`osname` varchar(100) DEFAULT NULL,
`browser` varchar(100) DEFAULT NULL,
`sessiontimes` int(20) DEFAULT NULL,
`servicetime` datetime DEFAULT NULL,
`region` varchar(255) DEFAULT NULL,
`agentusername` varchar(32) DEFAULT NULL,
`times` int(10) DEFAULT NULL,
`dataid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_agentservice
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_agentstatus`
-- ----------------------------
DROP TABLE IF EXISTS `uk_agentstatus`;
CREATE TABLE `uk_agentstatus` (
`id` varchar(100) NOT NULL DEFAULT '',
`agentno` varchar(100) DEFAULT '',
`logindate` datetime DEFAULT NULL,
`status` varchar(100) DEFAULT '',
`orgi` varchar(100) DEFAULT '',
`agentserviceid` varchar(100) DEFAULT '',
`serusernum` int(11) DEFAULT '0',
`skill` varchar(100) DEFAULT '',
`skillname` varchar(100) DEFAULT '',
`users` int(11) DEFAULT '0',
`maxusers` int(11) DEFAULT '0',
`username` varchar(100) DEFAULT '',
`name` varchar(100) DEFAULT '',
`updatetime` datetime DEFAULT NULL,
`userid` varchar(100) DEFAULT '',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`creater` varchar(255) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_user` varchar(255) DEFAULT NULL COMMENT '修改人',
`assignedto` varchar(255) DEFAULT NULL COMMENT '分配目标用户',
`wfstatus` varchar(255) DEFAULT NULL COMMENT '流程状态',
`shares` varchar(255) DEFAULT NULL COMMENT '分享给',
`owner` varchar(255) DEFAULT NULL COMMENT '所属人',
`datadept` varchar(255) DEFAULT NULL COMMENT '创建人部门',
`batid` varchar(32) DEFAULT NULL,
`pulluser` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_agentstatus
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_agentuser`
-- ----------------------------
DROP TABLE IF EXISTS `uk_agentuser`;
CREATE TABLE `uk_agentuser` (
`id` varchar(100) NOT NULL DEFAULT '',
`username` varchar(100) DEFAULT '',
`agentno` varchar(100) DEFAULT '',
`userid` varchar(100) DEFAULT '',
`channel` varchar(100) DEFAULT '',
`logindate` datetime DEFAULT NULL,
`source` varchar(100) DEFAULT '',
`endtime` datetime DEFAULT NULL,
`nickname` varchar(100) DEFAULT '',
`city` varchar(100) DEFAULT '',
`province` varchar(100) DEFAULT '',
`country` varchar(100) DEFAULT '',
`headImgUrl` varchar(100) DEFAULT '',
`waittingtime` int(11) DEFAULT '0',
`tokenum` int(11) DEFAULT '0',
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`status` varchar(100) DEFAULT '',
`appid` varchar(100) DEFAULT '',
`sessiontype` varchar(100) DEFAULT '',
`contextid` varchar(100) DEFAULT '',
`agentserviceid` varchar(100) DEFAULT '',
`orgi` varchar(100) DEFAULT '',
`snsuser` varchar(100) DEFAULT '',
`lastmessage` datetime DEFAULT NULL,
`waittingtimestart` datetime DEFAULT NULL,
`lastgetmessage` datetime DEFAULT NULL,
`lastmsg` varchar(100) DEFAULT '',
`agentskill` varchar(100) DEFAULT '',
`name` varchar(255) DEFAULT NULL COMMENT '名称',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`creater` varchar(255) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_user` varchar(255) DEFAULT NULL COMMENT '修改人',
`assignedto` varchar(255) DEFAULT NULL COMMENT '分配目标用户',
`wfstatus` varchar(255) DEFAULT NULL COMMENT '流程状态',
`shares` varchar(255) DEFAULT NULL COMMENT '分享给',
`owner` varchar(255) DEFAULT NULL COMMENT '所属人',
`datadept` varchar(255) DEFAULT NULL COMMENT '创建人部门',
`intime` int(32) DEFAULT NULL,
`batid` varchar(32) DEFAULT NULL,
`ipaddr` varchar(50) DEFAULT NULL,
`osname` varchar(100) DEFAULT NULL,
`browser` varchar(100) DEFAULT NULL,
`sessiontimes` int(20) DEFAULT NULL,
`servicetime` datetime DEFAULT NULL,
`region` varchar(255) DEFAULT NULL,
`agentservice` varchar(32) DEFAULT NULL,
`warnings` varchar(11) DEFAULT NULL,
`warningtime` datetime DEFAULT NULL,
`reptime` datetime DEFAULT NULL,
`reptimes` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_agentuser
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_blacklist`
-- ----------------------------
DROP TABLE IF EXISTS `uk_blacklist`;
CREATE TABLE `uk_blacklist` (
`id` varchar(32) NOT NULL,
`orgi` varchar(32) DEFAULT NULL,
`userid` varchar(32) DEFAULT NULL,
`contactid` varchar(32) DEFAULT NULL,
`sessionid` varchar(32) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`channel` varchar(20) DEFAULT NULL,
`creater` varchar(32) DEFAULT NULL,
`agentid` varchar(32) DEFAULT NULL,
`phone` varchar(20) DEFAULT NULL,
`openid` varchar(100) DEFAULT NULL,
`description` text,
`agentserviceid` varchar(32) DEFAULT NULL,
`times` int(11) DEFAULT NULL,
`chattime` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_blacklist
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_chat_message`
-- ----------------------------
DROP TABLE IF EXISTS `uk_chat_message`;
CREATE TABLE `uk_chat_message` (
`type` varchar(100) DEFAULT '',
`id` varchar(100) NOT NULL DEFAULT '',
`calltype` varchar(32) DEFAULT NULL,
`contextid` varchar(50) DEFAULT NULL,
`session` varchar(100) DEFAULT NULL,
`touser` varchar(50) DEFAULT NULL,
`channel` varchar(32) DEFAULT NULL,
`tousername` varchar(100) DEFAULT NULL,
`appid` varchar(50) DEFAULT NULL,
`userid` varchar(100) DEFAULT '',
`nickname` varchar(100) DEFAULT '',
`message` text,
`msgtype` varchar(100) DEFAULT '',
`orgi` varchar(100) DEFAULT '',
`msgid` varchar(100) DEFAULT '',
`expmsg` varchar(100) DEFAULT '',
`name` varchar(255) DEFAULT NULL COMMENT '名称',
`createtime` varchar(50) DEFAULT NULL COMMENT '创建时间',
`creater` varchar(255) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_user` varchar(255) DEFAULT NULL COMMENT '修改人',
`username` varchar(255) DEFAULT NULL COMMENT '用户名',
`assignedto` varchar(255) DEFAULT NULL COMMENT '分配目标用户',
`wfstatus` varchar(255) DEFAULT NULL COMMENT '流程状态',
`shares` varchar(255) DEFAULT NULL COMMENT '分享给',
`owner` varchar(255) DEFAULT NULL COMMENT '所属人',
`datadept` varchar(255) DEFAULT NULL COMMENT '创建人部门',
`batid` varchar(32) DEFAULT NULL,
`model` varchar(32) DEFAULT NULL,
`chatype` varchar(32) DEFAULT NULL,
`agentserviceid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_chat_message
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_consult_invite`
-- ----------------------------
DROP TABLE IF EXISTS `uk_consult_invite`;
CREATE TABLE `uk_consult_invite` (
`id` varchar(255) NOT NULL,
`impid` varchar(255) DEFAULT NULL,
`orgi` varchar(255) DEFAULT NULL,
`owner` varchar(255) DEFAULT NULL,
`processid` varchar(255) DEFAULT NULL,
`shares` varchar(255) DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`update_user` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`wfstatus` varchar(255) DEFAULT NULL,
`consult_invite_model` varchar(32) DEFAULT NULL,
`consult_invite_content` varchar(255) DEFAULT NULL,
`consult_invite_position` varchar(32) DEFAULT NULL,
`consult_invite_color` varchar(32) DEFAULT NULL,
`consult_invite_right` int(11) DEFAULT NULL,
`consult_invite_left` int(11) DEFAULT NULL,
`consult_invite_bottom` int(11) DEFAULT NULL,
`consult_invite_top` int(11) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`consult_invite_width` int(32) DEFAULT NULL,
`consult_invite_poptype` varchar(32) DEFAULT NULL,
`consult_invite_fontsize` int(32) DEFAULT NULL,
`consult_invite_fontstyle` varchar(32) DEFAULT NULL,
`consult_invite_fontcolor` varchar(32) DEFAULT NULL,
`consult_invite_interval` int(32) DEFAULT NULL,
`consult_invite_repeat` varchar(32) DEFAULT NULL,
`consult_invite_hight` int(32) DEFAULT NULL,
`snsaccountid` varchar(56) DEFAULT NULL,
`consult_vsitorbtn_position` varchar(32) DEFAULT NULL,
`consult_vsitorbtn_content` varchar(32) DEFAULT NULL,
`consult_vsitorbtn_right` varchar(32) DEFAULT NULL,
`consult_vsitorbtn_left` varchar(32) DEFAULT NULL,
`consult_vsitorbtn_top` varchar(32) DEFAULT NULL,
`consult_vsitorbtn_color` varchar(32) DEFAULT NULL,
`consult_vsitorbtn_model` varchar(32) DEFAULT NULL,
`consult_vsitorbtn_bottom` varchar(32) DEFAULT NULL,
`consult_invite_backimg` varchar(32) DEFAULT NULL,
`datadept` varchar(255) DEFAULT NULL,
`agent_online` varchar(32) DEFAULT NULL,
`consult_dialog_color` varchar(32) DEFAULT NULL,
`consult_dialog_logo` varchar(100) DEFAULT NULL,
`consult_dialog_headimg` varchar(100) DEFAULT NULL,
`consult_vsitorbtn_display` int(11) DEFAULT NULL,
`dialog_name` varchar(100) DEFAULT NULL,
`dialog_address` varchar(255) DEFAULT NULL,
`dialog_phone` varchar(32) DEFAULT NULL,
`dialog_mail` varchar(100) DEFAULT NULL,
`dialog_introduction` text,
`dialog_message` text,
`dialog_ad` varchar(100) DEFAULT NULL,
`consult_invite_enable` tinyint(4) DEFAULT NULL,
`consult_invite_accept` varchar(50) DEFAULT NULL,
`consult_invite_later` varchar(50) DEFAULT NULL,
`consult_invite_delay` int(11) DEFAULT NULL,
`consult_invite_bg` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_consult_invite
-- ----------------------------
INSERT INTO `uk_consult_invite` VALUES ('4028838b5ac815e3015ac81645f90000', null, 'ukewo', null, null, null, null, null, null, null, null, '欢迎来到本网站,请问有什么可以帮您?', null, '1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '297e8c7b455798280145579c73e501c1', 'right,middle', '在线客服', null, null, null, '1', '1', null, null, null, null, '1', null, null, '0', null, null, null, null, null, null, null, '0', '现在咨询', '稍后再说', '0', 'invote/4028838b5ac815e3015ac81645f90000.jpg');
-- ----------------------------
-- Table structure for `uk_fans`
-- ----------------------------
DROP TABLE IF EXISTS `uk_fans`;
CREATE TABLE `uk_fans` (
`id` varchar(32) NOT NULL,
`creater` varchar(32) DEFAULT NULL,
`createtime` date DEFAULT NULL,
`updatetime` date DEFAULT NULL,
`user` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_fans
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_imgroup`
-- ----------------------------
DROP TABLE IF EXISTS `uk_imgroup`;
CREATE TABLE `uk_imgroup` (
`id` varchar(32) NOT NULL,
`creater` varchar(32) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`tipmessage` text,
`descript` text,
`name` varchar(100) DEFAULT NULL,
`orgi` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_imgroup
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_imgroup_user`
-- ----------------------------
DROP TABLE IF EXISTS `uk_imgroup_user`;
CREATE TABLE `uk_imgroup_user` (
`id` varchar(32) NOT NULL,
`creater` varchar(32) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`orgi` varchar(100) DEFAULT NULL,
`user_id` varchar(32) DEFAULT NULL,
`imgroup_id` varchar(32) DEFAULT NULL,
`admin` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_imgroup_user
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_inviterecord`
-- ----------------------------
DROP TABLE IF EXISTS `uk_inviterecord`;
CREATE TABLE `uk_inviterecord` (
`id` varchar(32) NOT NULL,
`orgi` varchar(32) DEFAULT NULL,
`userid` varchar(32) DEFAULT NULL,
`agentno` varchar(32) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`result` varchar(10) DEFAULT NULL,
`responsetime` int(11) DEFAULT NULL,
`appid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_inviterecord
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_message`
-- ----------------------------
DROP TABLE IF EXISTS `uk_message`;
CREATE TABLE `uk_message` (
`id` varchar(32) NOT NULL,
`createtime` datetime DEFAULT NULL,
`creater` varchar(32) DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`userid` varchar(32) DEFAULT NULL,
`content` text,
`status` varchar(10) DEFAULT NULL,
`fromuser` varchar(32) DEFAULT NULL,
`touser` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_message
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_onlineuser`
-- ----------------------------
DROP TABLE IF EXISTS `uk_onlineuser`;
CREATE TABLE `uk_onlineuser` (
`assignedto` varchar(255) NOT NULL DEFAULT '',
`creater` varchar(255) DEFAULT NULL,
`datastatus` varchar(255) DEFAULT NULL,
`id` varchar(255) NOT NULL,
`impid` varchar(255) DEFAULT NULL,
`ipcode` varchar(255) DEFAULT NULL,
`orgi` varchar(255) DEFAULT NULL,
`owner` varchar(255) DEFAULT NULL,
`processid` varchar(255) DEFAULT NULL,
`shares` varchar(255) DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`updateuser` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`wfstatus` varchar(255) DEFAULT NULL,
`resolution` varchar(255) DEFAULT NULL,
`opersystem` varchar(32) DEFAULT NULL,
`ip` varchar(32) DEFAULT NULL,
`hostname` varchar(32) DEFAULT NULL,
`browser` varchar(32) DEFAULT NULL,
`status` varchar(11) DEFAULT NULL,
`userid` varchar(52) DEFAULT NULL,
`logintime` datetime DEFAULT NULL,
`sessionid` varchar(100) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`usertype` varchar(52) DEFAULT NULL,
`optype` varchar(52) DEFAULT NULL,
`mobile` varchar(10) DEFAULT NULL,
`olduser` varchar(10) DEFAULT NULL,
`country` varchar(50) DEFAULT NULL,
`region` varchar(200) DEFAULT NULL,
`city` varchar(50) DEFAULT NULL,
`isp` varchar(100) DEFAULT NULL,
`province` varchar(50) DEFAULT NULL,
`betweentime` bigint(20) DEFAULT NULL,
`datestr` varchar(20) DEFAULT NULL,
`keyword` varchar(100) DEFAULT NULL,
`source` varchar(50) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`useragent` varchar(255) DEFAULT NULL,
`invitetimes` int(11) DEFAULT NULL,
`invitestatus` varchar(10) DEFAULT NULL,
`refusetimes` int(11) DEFAULT NULL,
`channel` varchar(32) DEFAULT NULL,
`appid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`,`assignedto`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_onlineuser
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_onlineuser_his`
-- ----------------------------
DROP TABLE IF EXISTS `uk_onlineuser_his`;
CREATE TABLE `uk_onlineuser_his` (
`assignedto` varchar(255) NOT NULL DEFAULT '',
`creater` varchar(255) DEFAULT NULL,
`datastatus` varchar(255) DEFAULT NULL,
`id` varchar(255) NOT NULL,
`impid` varchar(255) DEFAULT NULL,
`ipcode` varchar(255) DEFAULT NULL,
`orgi` varchar(255) DEFAULT NULL,
`owner` varchar(255) DEFAULT NULL,
`processid` varchar(255) DEFAULT NULL,
`shares` varchar(255) DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`updateuser` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`wfstatus` varchar(255) DEFAULT NULL,
`resolution` varchar(255) DEFAULT NULL,
`opersystem` varchar(32) DEFAULT NULL,
`ip` varchar(32) DEFAULT NULL,
`hostname` varchar(32) DEFAULT NULL,
`browser` varchar(32) DEFAULT NULL,
`status` varchar(11) DEFAULT NULL,
`userid` varchar(52) DEFAULT NULL,
`logintime` datetime DEFAULT NULL,
`sessionid` varchar(100) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`usertype` varchar(52) DEFAULT NULL,
`optype` varchar(52) DEFAULT NULL,
`mobile` varchar(10) DEFAULT NULL,
`olduser` varchar(10) DEFAULT NULL,
`country` varchar(50) DEFAULT NULL,
`region` varchar(200) DEFAULT NULL,
`city` varchar(50) DEFAULT NULL,
`isp` varchar(100) DEFAULT NULL,
`province` varchar(50) DEFAULT NULL,
`betweentime` bigint(20) DEFAULT NULL,
`datestr` varchar(20) DEFAULT NULL,
`keyword` varchar(100) DEFAULT NULL,
`source` varchar(50) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`useragent` varchar(255) DEFAULT NULL,
`invitetimes` int(11) DEFAULT NULL,
`invitestatus` varchar(10) DEFAULT NULL,
`refusetimes` int(11) DEFAULT NULL,
`channel` varchar(32) DEFAULT NULL,
`appid` varchar(32) DEFAULT NULL,
`dataid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`,`assignedto`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_onlineuser_his
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_organ`
-- ----------------------------
DROP TABLE IF EXISTS `uk_organ`;
CREATE TABLE `uk_organ` (
`ID` varchar(32) NOT NULL,
`NAME` varchar(50) DEFAULT NULL,
`CODE` varchar(50) DEFAULT NULL,
`CREATETIME` datetime DEFAULT NULL,
`CREATER` varchar(32) DEFAULT NULL,
`UPDATETIME` datetime DEFAULT NULL,
`ORGI` varchar(32) DEFAULT NULL,
`USERNAME` varchar(50) DEFAULT NULL,
`PARENT` varchar(32) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_organ
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_quickreply`
-- ----------------------------
DROP TABLE IF EXISTS `uk_quickreply`;
CREATE TABLE `uk_quickreply` (
`id` varchar(32) NOT NULL DEFAULT '',
`title` varchar(255) DEFAULT NULL,
`content` text,
`type` varchar(10) DEFAULT NULL,
`creater` varchar(32) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`cate` varchar(32) DEFAULT NULL,
`orgi` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_quickreply
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_recentuser`
-- ----------------------------
DROP TABLE IF EXISTS `uk_recentuser`;
CREATE TABLE `uk_recentuser` (
`id` varchar(32) NOT NULL,
`creater` varchar(32) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`orgi` varchar(100) DEFAULT NULL,
`user_id` varchar(32) DEFAULT NULL,
`lastmsg` varchar(100) DEFAULT NULL,
`newmsg` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_recentuser
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_role`
-- ----------------------------
DROP TABLE IF EXISTS `uk_role`;
CREATE TABLE `uk_role` (
`ID` varchar(32) NOT NULL,
`NAME` varchar(50) DEFAULT NULL,
`CODE` varchar(50) DEFAULT NULL,
`CREATETIME` datetime DEFAULT NULL,
`CREATER` varchar(32) DEFAULT NULL,
`UPDATETIME` datetime DEFAULT NULL,
`ORGI` varchar(32) DEFAULT NULL,
`USERNAME` varchar(50) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_role
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_sessionconfig`
-- ----------------------------
DROP TABLE IF EXISTS `uk_sessionconfig`;
CREATE TABLE `uk_sessionconfig` (
`id` varchar(32) NOT NULL DEFAULT '',
`orgi` varchar(32) DEFAULT NULL,
`creater` varchar(32) DEFAULT NULL,
`username` varchar(32) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`sessionmsg` varchar(255) DEFAULT NULL,
`distribution` varchar(32) DEFAULT NULL,
`timeoutmsg` varchar(255) DEFAULT NULL,
`retimeoutmsg` varchar(255) DEFAULT NULL,
`satisfaction` tinyint(4) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`lastagent` tinyint(4) DEFAULT NULL,
`sessiontimeout` tinyint(4) DEFAULT NULL,
`resessiontimeout` tinyint(4) DEFAULT NULL,
`timeout` int(11) DEFAULT NULL,
`retimeout` int(11) DEFAULT NULL,
`agenttimeout` int(11) DEFAULT NULL,
`agentreplaytimeout` tinyint(4) DEFAULT NULL,
`agenttimeoutmsg` varchar(255) DEFAULT NULL,
`maxuser` int(11) DEFAULT NULL,
`initmaxuser` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_sessionconfig
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_snsaccount`
-- ----------------------------
DROP TABLE IF EXISTS `uk_snsaccount`;
CREATE TABLE `uk_snsaccount` (
`authorizeURL` varchar(255) DEFAULT NULL,
`accessTokenURL` varchar(255) DEFAULT NULL,
`baseURL` varchar(255) DEFAULT NULL,
`redirectURI` varchar(255) DEFAULT NULL,
`clientSERCRET` varchar(192) DEFAULT NULL,
`clientID` varchar(96) DEFAULT NULL,
`ID` varchar(96) NOT NULL,
`states` varchar(32) DEFAULT NULL,
`region` varchar(32) DEFAULT NULL,
`NAME` varchar(255) DEFAULT NULL,
`CODE` varchar(255) DEFAULT NULL,
`USERNAME` varchar(255) DEFAULT NULL,
`APIPOINT` varchar(255) DEFAULT NULL,
`PASSWORD` varchar(255) DEFAULT NULL,
`SNSTYPE` varchar(255) DEFAULT NULL,
`CREATETIME` datetime DEFAULT NULL,
`ACCOUNT` varchar(255) DEFAULT NULL,
`ALLOWREMOTE` varchar(255) DEFAULT NULL,
`EMAIL` varchar(255) DEFAULT NULL,
`USERNO` varchar(255) DEFAULT NULL,
`TOKEN` varchar(255) DEFAULT NULL,
`APPKEY` varchar(255) DEFAULT NULL,
`SECRET` varchar(255) DEFAULT NULL,
`AESKEY` varchar(255) DEFAULT NULL,
`APPTOKEN` varchar(255) DEFAULT NULL,
`SESSIONKEY` varchar(255) DEFAULT NULL,
`MOREPARAM` varchar(255) DEFAULT NULL,
`ORGI` varchar(255) DEFAULT NULL,
`DEFAULTACCOUNT` smallint(6) DEFAULT NULL,
`lastatupdate` varchar(96) DEFAULT NULL,
`lastprimsgupdate` varchar(96) DEFAULT NULL,
`ACCTYPE` varchar(32) DEFAULT NULL,
`UPDATETIME` datetime DEFAULT NULL,
`creater` varchar(32) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`update_username` varchar(255) DEFAULT NULL,
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_user` varchar(255) DEFAULT NULL COMMENT '修改人',
`shares` varchar(255) DEFAULT NULL COMMENT '分享给',
`owner` varchar(255) DEFAULT NULL COMMENT '所属人',
`assignedto` varchar(255) DEFAULT NULL COMMENT '分配目标用户',
`wfstatus` varchar(255) DEFAULT NULL COMMENT '流程状态',
`datadept` varchar(255) DEFAULT NULL COMMENT '创建人部门',
`batid` varchar(32) DEFAULT NULL,
`alias` varchar(50) DEFAULT NULL,
`authaccesstoken` varchar(255) DEFAULT NULL,
`expirestime` int(11) DEFAULT NULL,
`headimg` varchar(255) DEFAULT NULL,
`oepnscan` varchar(100) DEFAULT NULL,
`opencard` varchar(100) DEFAULT NULL,
`openstore` varchar(100) DEFAULT NULL,
`openpay` varchar(100) DEFAULT NULL,
`openshake` varchar(100) DEFAULT NULL,
`qrcode` varchar(100) DEFAULT NULL,
`refreshtoken` varchar(255) DEFAULT NULL,
`verify` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `SQL121227155530370` (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_snsaccount
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_tag`
-- ----------------------------
DROP TABLE IF EXISTS `uk_tag`;
CREATE TABLE `uk_tag` (
`id` varchar(32) NOT NULL,
`tag` varchar(100) DEFAULT NULL,
`orgi` varchar(32) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`times` int(11) DEFAULT NULL,
`creater` varchar(32) DEFAULT NULL,
`tagtype` varchar(32) DEFAULT NULL,
`icon` varchar(50) DEFAULT NULL,
`color` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_tag
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_tagrelation`
-- ----------------------------
DROP TABLE IF EXISTS `uk_tagrelation`;
CREATE TABLE `uk_tagrelation` (
`id` varchar(32) NOT NULL,
`tagid` varchar(32) DEFAULT NULL,
`userid` varchar(32) DEFAULT NULL,
`dataid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_tagrelation
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_user`
-- ----------------------------
DROP TABLE IF EXISTS `uk_user`;
CREATE TABLE `uk_user` (
`ID` varchar(32) NOT NULL,
`LANGUAGE` varchar(255) DEFAULT NULL,
`USERNAME` varchar(255) DEFAULT NULL,
`PASSWORD` varchar(255) DEFAULT NULL,
`SECURECONF` varchar(255) DEFAULT NULL,
`EMAIL` varchar(255) DEFAULT NULL,
`FIRSTNAME` varchar(255) DEFAULT NULL,
`MIDNAME` varchar(255) DEFAULT NULL,
`LASTNAME` varchar(255) DEFAULT NULL,
`JOBTITLE` varchar(255) DEFAULT NULL,
`DEPARTMENT` varchar(255) DEFAULT NULL,
`GENDER` varchar(255) DEFAULT NULL,
`BIRTHDAY` varchar(255) DEFAULT NULL,
`NICKNAME` varchar(255) DEFAULT NULL,
`USERTYPE` varchar(255) DEFAULT NULL,
`RULENAME` varchar(255) DEFAULT NULL,
`SEARCHPROJECTID` varchar(255) DEFAULT NULL,
`ORGI` varchar(32) DEFAULT NULL,
`CREATER` varchar(32) DEFAULT NULL,
`CREATETIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`MEMO` varchar(255) DEFAULT NULL,
`UPDATETIME` timestamp NULL DEFAULT NULL,
`ORGAN` varchar(32) DEFAULT NULL,
`MOBILE` varchar(32) DEFAULT NULL,
`passupdatetime` timestamp NULL DEFAULT NULL,
`sign` text,
`del` tinyint(4) DEFAULT '0',
`uname` varchar(100) DEFAULT NULL,
`musteditpassword` tinyint(4) DEFAULT NULL,
`AGENT` tinyint(4) DEFAULT NULL,
`SKILL` varchar(32) DEFAULT NULL,
`province` varchar(50) DEFAULT NULL,
`city` varchar(50) DEFAULT NULL,
`fans` int(11) DEFAULT NULL,
`follows` int(11) DEFAULT NULL,
`integral` int(11) DEFAULT NULL,
`lastlogintime` datetime DEFAULT NULL,
`status` varchar(10) DEFAULT NULL,
`deactivetime` datetime DEFAULT NULL,
`title` varchar(50) DEFAULT NULL,
`DATASTATUS` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_user
-- ----------------------------
INSERT INTO `uk_user` VALUES ('297e8c7b455798280145579c73e501c1', null, 'admin', '14e1b600b1fd579f47433b88e8d85291', '5', 'admin@ukewo.com', null, null, null, null, null, '0', null, null, '0', null, null, 'ukewo', null, '2017-03-16 13:56:34', '北京', '2017-03-16 18:36:15', '4028838b5acb901f015acba98b70000b', '18510129577', null, null, '0', '系统管理员', '0', '1', null, '北京', '北京', '2', '1', '0', '2017-03-16 18:35:19', null, null, null, '0');
INSERT INTO `uk_user` VALUES ('4028838b5ad5b1a3015ad5b6e5f50005', null, 'ukewo', '14e1b600b1fd579f47433b88e8d85291', '5', 'ukewo@sina.cn', null, null, null, null, null, null, null, null, null, null, null, 'ukewo', null, '2017-03-16 14:03:37', null, '2017-03-16 14:03:37', null, '18510129566', '2017-03-16 14:03:37', null, '0', 'ukewo', null, '0', null, null, null, '0', '0', '0', '2017-03-16 14:03:37', null, null, null, '1');
-- ----------------------------
-- Table structure for `uk_userevent`
-- ----------------------------
DROP TABLE IF EXISTS `uk_userevent`;
CREATE TABLE `uk_userevent` (
`id` varchar(32) NOT NULL DEFAULT '',
`username` varchar(32) DEFAULT NULL,
`creater` varchar(32) DEFAULT NULL,
`orgi` varchar(50) DEFAULT NULL,
`maintype` varchar(32) DEFAULT NULL,
`subtype` varchar(32) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`admin` tinyint(32) DEFAULT NULL,
`access` tinyint(32) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
`hostname` varchar(50) DEFAULT NULL,
`country` varchar(50) DEFAULT NULL,
`region` varchar(50) DEFAULT NULL,
`city` varchar(32) DEFAULT NULL,
`isp` varchar(32) DEFAULT NULL,
`province` varchar(32) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`sessionid` varchar(32) DEFAULT NULL,
`param` text,
`times` int(11) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`ostype` varchar(50) DEFAULT NULL,
`browser` varchar(50) DEFAULT NULL,
`mobile` varchar(10) DEFAULT NULL,
`model` varchar(10) DEFAULT NULL,
`appid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_userevent
-- ----------------------------
-- ----------------------------
-- Table structure for `uk_userrole`
-- ----------------------------
DROP TABLE IF EXISTS `uk_userrole`;
CREATE TABLE `uk_userrole` (
`id` varchar(32) NOT NULL,
`user_id` varchar(32) DEFAULT NULL,
`role_id` varchar(32) DEFAULT NULL,
`creater` varchar(32) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`orgi` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uk_userrole
-- ----------------------------
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。