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