im_permisson.sql 449 B

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