mysql 指定引擎

CREATE TABLE `ecard_info`(    `id` bigint(18) NOT NULL AUTO_INCREMENT,    `userid` bigint(18),    `createdate` date,    `updatedate` date,    `name` varchar(20),    `mobile` varchar(20),    `job` varchar(20),    `tel` varchar(20),    `email` varchar(50),    `postcode` varchar(10),    `fax` varchar(20),    `company` varchar(50),    `department` varchar(50),    `homepage` varchar(100),    `address` varchar(100),    `memo` varchar(500),    PRIMARY KEY (`id`),    CONSTRAINT `FK_ECARD_USER` FOREIGN KEY (`userid`) REFERENCES `core_user` (`user_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf-8;-- 角色create table role(    id bigint,    name varchar(50),    descn varchar(200)) ENGINE=InnoDB;alter table role add constraint pk_role primary key(id);