谷钉-用户

-- 数据库大全：谷钉-用户
-- 来源：YesApi.cn
CREATE TABLE `yesapi_goodeen_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `email` varchar(60) NULL COMMENT '',
    `screenName` varchar(20) NULL COMMENT '',
    `yesapi_goodeen_user_password` varchar(32) NULL COMMENT '',
    `yesapi_goodeen_user_key` varchar(32) NULL COMMENT '',
    `state` tinyint(1) NULL COMMENT '',
    `createTime` timestamp NULL COMMENT '',
    `updateTime` timestamp NULL COMMENT '',
    `image` varchar(60) NULL COMMENT '',
    `headerImage` varchar(60) NULL COMMENT '',
    `yesapi_goodeen_user_name` varchar(15) NULL COMMENT '',
    `location` varchar(60) NULL COMMENT '',
    `url` varchar(60) NULL COMMENT '',
    `summary` varchar(160) NULL COMMENT '',
    `theme` tinyint(1) NULL COMMENT '',
    `backgroundImage` varchar(100) NULL COMMENT '',
    `backgroundTiled` tinyint(1) NULL COMMENT '',
    `backgroundPosition` tinyint(1) NULL COMMENT '',
    `backgroundColor` varchar(10) NULL COMMENT '',
    `linkColor` varchar(10) NULL COMMENT '',
    `overlayColor` tinyint(1) NULL COMMENT '',
    `tripStat` int(11) NULL COMMENT '',
    `followingStat` int(11) NULL COMMENT '',
    `followerStat` int(11) NULL COMMENT '',
    UNIQUE KEY `email` (`email`),
    UNIQUE KEY `screenName` (`screenName`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '谷钉-用户';

复制后，到数据库执行，即可创建此数据库表。