ALTER TABLE `uc_demension` CHANGE `DEM_NAME_` `DEM_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '维度名称'; ALTER TABLE `uc_demension` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '维度代码'; ALTER TABLE `uc_demension` CHANGE `IS_DEFAULT_` `IS_DEFAULT_` int(11) null DEFAULT null COMMENT '是否默认(1:默认,0:非默认)'; ALTER TABLE `uc_demension` CHANGE `DEM_DESC_` `DEM_DESC_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '描述'; ALTER TABLE `uc_demension` CHANGE `ORGAN_ID_` `ORGAN_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '机构id'; ALTER TABLE `uc_demension` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_demension` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_operate_log` CHANGE `REQ_IP_` `REQ_IP_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '请求ip地址'; ALTER TABLE `uc_operate_log` CHANGE `REQ_TYPE_` `REQ_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '请求方式'; ALTER TABLE `uc_operate_log` CHANGE `REQ_URL_` `REQ_URL_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '请求地址'; ALTER TABLE `uc_operate_log` CHANGE `OPERATOR_NAME_` `OPERATOR_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '操作人'; ALTER TABLE `uc_operate_log` CHANGE `NOTE_` `NOTE_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '说明'; ALTER TABLE `uc_operate_log` CHANGE `SUCCESS_` `SUCCESS_` int(11) null DEFAULT null COMMENT '是否成功'; ALTER TABLE `uc_operate_log` CHANGE `FAIL_REASON_` `FAIL_REASON_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '失败原因'; ALTER TABLE `uc_operate_log` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_org` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '名称'; ALTER TABLE `uc_org` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父组织id'; ALTER TABLE `uc_org` CHANGE `ORDER_NO_` `ORDER_NO_` int(11) null DEFAULT null COMMENT '排序号'; ALTER TABLE `uc_org` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '组织代码'; ALTER TABLE `uc_org` CHANGE `GRADE_` `GRADE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '级别'; ALTER TABLE `uc_org` CHANGE `PATH_` `PATH_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织id路径，包含层级关系'; ALTER TABLE `uc_org` CHANGE `PATH_NAME_` `PATH_NAME_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织名路径，包含层级关系'; ALTER TABLE `uc_org` CHANGE `DEM_ID_` `DEM_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '维度id'; ALTER TABLE `uc_org` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_org` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_org` CHANGE `LIMIT_NUM_` `LIMIT_NUM_` int(11) NOT NULL DEFAULT '0' COMMENT '组织限编用户数量(0:不受限制)'; ALTER TABLE `uc_org` CHANGE `NOW_NUM_` `NOW_NUM_` int(11) null DEFAULT null COMMENT '组织现编用户数量'; ALTER TABLE `uc_org` CHANGE `EXCEED_LIMIT_NUM_` `EXCEED_LIMIT_NUM_` int(11) NOT NULL DEFAULT '0' COMMENT '是否允许超过限编(0:允许；1:不允许)'; ALTER TABLE `uc_org_auth` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '分级组织管理员id'; ALTER TABLE `uc_org_auth` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '对应管理组织id'; ALTER TABLE `uc_org_auth` CHANGE `DEM_ID_` `DEM_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '对应维度id'; ALTER TABLE `uc_org_auth` CHANGE `ORG_PERMS_` `ORG_PERMS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织管理权限'; ALTER TABLE `uc_org_auth` CHANGE `USER_PERMS_` `USER_PERMS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户管理权限'; ALTER TABLE `uc_org_auth` CHANGE `POS_PERMS_` `POS_PERMS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '岗位管理权限'; ALTER TABLE `uc_org_auth` CHANGE `ORGAUTH_PERMS_` `ORGAUTH_PERMS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '分级管理员权限'; ALTER TABLE `uc_org_auth` CHANGE `LAYOUT_PERMS_` `LAYOUT_PERMS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '首页布局管理权限'; ALTER TABLE `uc_org_auth` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_org_auth` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_org_job` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '名称'; ALTER TABLE `uc_org_job` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '编码'; ALTER TABLE `uc_org_job` CHANGE `JOB_LEVEL_` `JOB_LEVEL_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '职务级别'; ALTER TABLE `uc_org_job` CHANGE `DESCRIPTION_` `DESCRIPTION_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '描述'; ALTER TABLE `uc_org_job` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_org_job` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_org_params` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织id'; ALTER TABLE `uc_org_params` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '参数代码'; ALTER TABLE `uc_org_params` CHANGE `VALUE_` `VALUE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '值'; ALTER TABLE `uc_org_params` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_org_params` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_org_post` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织id'; ALTER TABLE `uc_org_post` CHANGE `JOB_ID_` `JOB_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '职务id'; ALTER TABLE `uc_org_post` CHANGE `POS_NAME_` `POS_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '岗位名称'; ALTER TABLE `uc_org_post` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '岗位编码'; ALTER TABLE `uc_org_post` CHANGE `IS_CHARGE_` `IS_CHARGE_` int(11) NOT NULL DEFAULT '0' COMMENT '是否主岗位：1主岗位，0 非主岗位'; ALTER TABLE `uc_org_post` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_org_post` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_org_role` CHANGE `ROLE_ID_` `ROLE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '角色id'; ALTER TABLE `uc_org_role` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织id'; ALTER TABLE `uc_org_role` CHANGE `IS_INHERIT_` `IS_INHERIT_` int(11) null DEFAULT '0' COMMENT '子组织是否可以继承,0:不可1:可以'; ALTER TABLE `uc_org_role` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_org_role` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_org_user` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织编号'; ALTER TABLE `uc_org_user` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户编号'; ALTER TABLE `uc_org_user` CHANGE `IS_MASTER_` `IS_MASTER_` int(11) NOT NULL DEFAULT '0' COMMENT '0:非主部门，1：主部门'; ALTER TABLE `uc_org_user` CHANGE `POS_ID_` `POS_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '岗位id'; ALTER TABLE `uc_org_user` CHANGE `IS_CHARGE_` `IS_CHARGE_` int(11) null DEFAULT '0' COMMENT '2组织主负责人，1组织负责人，0 不是负责人'; ALTER TABLE `uc_org_user` CHANGE `IS_REL_ACTIVE_` `IS_REL_ACTIVE_` int(11) NOT NULL COMMENT '是否有效，0:无效，1：有效'; ALTER TABLE `uc_org_user` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_org_user` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_organ` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '机构编码'; ALTER TABLE `uc_organ` CHANGE `NAME_` `NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '机构名称'; ALTER TABLE `uc_organ` CHANGE `DESC_` `DESC_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '机构描述'; ALTER TABLE `uc_organ` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人'; ALTER TABLE `uc_organ` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_organ` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_params` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '参数名称'; ALTER TABLE `uc_params` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '参数代码'; ALTER TABLE `uc_params` CHANGE `TYPE_` `TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '类型'; ALTER TABLE `uc_params` CHANGE `CTL_TYPE_` `CTL_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '控件类型'; ALTER TABLE `uc_params` CHANGE `JSON_` `JSON_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'json值'; ALTER TABLE `uc_params` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_params` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_pwd_strategy` CHANGE `PWD_RULE_` `PWD_RULE_` smallint(6) null DEFAULT null COMMENT '密码规则'; ALTER TABLE `uc_pwd_strategy` CHANGE `PWD_LENGTH_` `PWD_LENGTH_` smallint(6) null DEFAULT null COMMENT '密码长度'; ALTER TABLE `uc_pwd_strategy` CHANGE `DURATION_` `DURATION_` smallint(6) null DEFAULT null COMMENT '密码时长（单位：天）'; ALTER TABLE `uc_pwd_strategy` CHANGE `ENABLE_` `ENABLE_` smallint(6) null DEFAULT null COMMENT '启用策略 0:停用，1:启用'; ALTER TABLE `uc_rel_auth` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '分级汇报线管理员id'; ALTER TABLE `uc_rel_auth` CHANGE `REL_ID_` `REL_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '对应汇报线节点id'; ALTER TABLE `uc_rel_auth` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '对应汇报线分类id'; ALTER TABLE `uc_rel_auth` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_rel_auth` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_rel_type` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '汇报关系分类名称'; ALTER TABLE `uc_rel_type` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '英文别名'; ALTER TABLE `uc_rel_type` CHANGE `DESCRIPTION_` `DESCRIPTION_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '描述'; ALTER TABLE `uc_rel_type` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_rel_type` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_role` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '角色名称'; ALTER TABLE `uc_role` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '英文别名'; ALTER TABLE `uc_role` CHANGE `ENABLED_` `ENABLED_` int(11) null DEFAULT null COMMENT '可用 0：禁用，1：启用'; ALTER TABLE `uc_role` CHANGE `DESCRIPTION_` `DESCRIPTION_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '描述'; ALTER TABLE `uc_role` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_role` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_tenant_logs` CHANGE `RESULT_` `RESULT_` smallint(6) null DEFAULT null COMMENT '操作结果（1:成功，0:失败）'; ALTER TABLE `uc_tenant_mail_server` CHANGE `MAIL_PORT_` `MAIL_PORT_` int(11) null DEFAULT null COMMENT '端口号'; ALTER TABLE `uc_tenant_mail_server` CHANGE `USE_SSL_` `USE_SSL_` smallint(6) null DEFAULT null COMMENT '是否使用SSL认证。0：否；1：是'; ALTER TABLE `uc_tenant_manage` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_user` CHANGE `FULLNAME_` `FULLNAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '姓名'; ALTER TABLE `uc_user` CHANGE `ACCOUNT_` `ACCOUNT_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '帐号'; ALTER TABLE `uc_user` CHANGE `PASSWORD_` `PASSWORD_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '密码'; ALTER TABLE `uc_user` CHANGE `EMAIL_` `EMAIL_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '邮箱'; ALTER TABLE `uc_user` CHANGE `MOBILE_` `MOBILE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '手机号码'; ALTER TABLE `uc_user` CHANGE `WEIXIN_` `WEIXIN_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '微信号'; ALTER TABLE `uc_user` CHANGE `ADDRESS_` `ADDRESS_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '地址'; ALTER TABLE `uc_user` CHANGE `PHOTO_` `PHOTO_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '头像'; ALTER TABLE `uc_user` CHANGE `SEX_` `SEX_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '性别：男，女，未知'; ALTER TABLE `uc_user` CHANGE `FROM_` `FROM_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '来源'; ALTER TABLE `uc_user` CHANGE `STATUS_` `STATUS_` int(11) null DEFAULT null COMMENT '0:禁用，1正常'; ALTER TABLE `uc_user` CHANGE `HAS_SYNC_TO_WX_` `HAS_SYNC_TO_WX_` int(11) null DEFAULT null COMMENT '微信同步关注状态: 0：未同步 1：已同步，尚未关注 2：已同步且已关注'; ALTER TABLE `uc_user` CHANGE `NOTIFY_TYPE_` `NOTIFY_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '自定义接收消息类型'; ALTER TABLE `uc_user` CHANGE `USER_NUMBER_` `USER_NUMBER_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '工号'; ALTER TABLE `uc_user` CHANGE `ID_CARD_` `ID_CARD_` varchar(38) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '身份证号'; ALTER TABLE `uc_user` CHANGE `PHONE_` `PHONE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '办公电话'; ALTER TABLE `uc_user` CHANGE `EDUCATION_` `EDUCATION_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '学历'; ALTER TABLE `uc_user` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_user` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_user_group` CHANGE `NAME_` `NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '名称'; ALTER TABLE `uc_user_group` CHANGE `JSON_` `JSON_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '群里的人或组'; ALTER TABLE `uc_user_group` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '群组代码'; ALTER TABLE `uc_user_group` CHANGE `DESCRIPTION_` `DESCRIPTION_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '描述'; ALTER TABLE `uc_user_group` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户id'; ALTER TABLE `uc_user_group` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织id'; ALTER TABLE `uc_user_group` CHANGE `ROLE_ID_` `ROLE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '角色id'; ALTER TABLE `uc_user_group` CHANGE `POS_ID_` `POS_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '岗位id'; ALTER TABLE `uc_user_group` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_user_group` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_user_params` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户id'; ALTER TABLE `uc_user_params` CHANGE `CODE_` `CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '参数代码'; ALTER TABLE `uc_user_params` CHANGE `VALUE_` `VALUE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '参数值'; ALTER TABLE `uc_user_params` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_user_params` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_user_rel` CHANGE `NAME_` `NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '名称'; ALTER TABLE `uc_user_rel` CHANGE `LEVEL_` `LEVEL_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '级别(用于区分有多个上级的情况)'; ALTER TABLE `uc_user_rel` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父id'; ALTER TABLE `uc_user_rel` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户关系分类下的id'; ALTER TABLE `uc_user_rel` CHANGE `GROUP_TYPE_` `GROUP_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '群组id'; ALTER TABLE `uc_user_rel` CHANGE `PATH_` `PATH_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织id路径，包含层级关系'; ALTER TABLE `uc_user_rel` CHANGE `VALUE_` `VALUE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '值'; ALTER TABLE `uc_user_rel` CHANGE `STATUS_` `STATUS_` int(11) null DEFAULT null COMMENT '状态（1：正常，0：失效）'; ALTER TABLE `uc_user_rel` CHANGE `ALIAS_` `ALIAS_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户组别名'; ALTER TABLE `uc_user_rel` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_user_rel` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_user_role` CHANGE `ROLE_ID_` `ROLE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '角色id'; ALTER TABLE `uc_user_role` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户id'; ALTER TABLE `uc_user_role` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_user_role` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号'; ALTER TABLE `uc_user_under` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户id'; ALTER TABLE `uc_user_under` CHANGE `UNDER_USER_ID_` `UNDER_USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '下属用户id'; ALTER TABLE `uc_user_under` CHANGE `UNDER_USER_NAME_` `UNDER_USER_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '下属用户名'; ALTER TABLE `uc_user_under` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织id'; ALTER TABLE `uc_user_under` CHANGE `IS_DELE_` `IS_DELE_` char(1) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `uc_user_under` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本号';