CREATE TABLE `t_sys_role` (
`ID` VARCHAR(32) NOT NULL COMMENT '主键ID',
`ROLE_NAME` VARCHAR(32) NOT NULL COMMENT '角色名称',
PRIMARY KEY (`ID`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COMMENT='系统角色信息';
CREATE TABLE `T_SYS_ROLE` (
`ID` VARCHAR(32) NOT NULL,
`ROLE_NAME` VARCHAR(32) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=INNODB DEFAULT CHARSET=UTF8;
ENGINE=MYISAM 不支持事务
ENGINE=INNODB 支持事务
`ID` VARCHAR(32) NOT NULL COMMENT '主键ID',
`ROLE_NAME` VARCHAR(32) NOT NULL COMMENT '角色名称',
PRIMARY KEY (`ID`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COMMENT='系统角色信息';
CREATE TABLE `T_SYS_ROLE` (
`ID` VARCHAR(32) NOT NULL,
`ROLE_NAME` VARCHAR(32) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=INNODB DEFAULT CHARSET=UTF8;
ENGINE=MYISAM 不支持事务
ENGINE=INNODB 支持事务