CREATE TABLE im_user_permission (
  UPMS_USERNO 	char(12) 	NOT NULL COMMENT '用户编号',
  UPMS_NO 		char(12) 	NOT NULL COMMENT '权限编号',
  UPMS_CHRNO 	char(5) 	NOT NULL COMMENT '子权限编号',
  UPMS_DATETIME char(14) 			 COMMENT '操作时间，格式为YYYYMMDDHHMISS',
  PRIMARY KEY (UPMS_USERNO,UPMS_NO,UPMS_CHRNO)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='内管用户权限控制表';
