| 1234567 |
- 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='内管用户权限控制表';
|
