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);
