12345678 |
- CREATE TABLE im_permission (
- PMS_NO char(12) NOT NULL COMMENT '权限编号',
- PMS_NAME varchar(30) NOT NULL COMMENT '菜单名称',
- PMS_CHRNO char(5) NOT NULL COMMENT '子权限编号',
- PMS_CHRNAME varchar(30) NOT NULL COMMENT '子权限名称',
- PMS_DATETIME char(14) COMMENT '操作时间,格式为YYYYMMDDHHMISS',
- PRIMARY KEY (PMS_NO,PMS_CHRNO)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='内管权限控制表';
|