微信婚礼请柬-大屏

-- 数据库大全：微信婚礼请柬-大屏
-- 来源：YesApi.cn
CREATE TABLE `yesapi_wedding_wx_accounts` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `lastUpdateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '',
    `lastCheckinStatus` enum('coming','absent','present') NOT NULL COMMENT '',
    `accountID` int(11) NOT NULL COMMENT '',
    `openID` varchar(50) NOT NULL COMMENT '',
    `nickName` varchar(50) NOT NULL COMMENT '',
    `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '',
    `province` varchar(20) NOT NULL COMMENT '',
    `city` varchar(20) NOT NULL COMMENT '',
    `country` varchar(20) NOT NULL COMMENT '',
    `headImgUrl` varchar(300) NOT NULL COMMENT '',
    `privilege` text NOT NULL COMMENT '',
    `accessToken` varchar(500) NOT NULL COMMENT '',
    `refreshToken` varchar(500) NOT NULL COMMENT '',
    `expireIn` int(11) NOT NULL DEFAULT '7200' COMMENT '',
    `tokenTime` datetime NOT NULL COMMENT '',
    `createTime` datetime NOT NULL COMMENT '',
    UNIQUE KEY `openID` (`openID`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '微信婚礼请柬-大屏';

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