CREATE TABLE im_user_permission ( UPMS_USERNO char(20) 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='内管用户权限控制表';