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