SET SESSION sql_mode = 'TRADITIONAL'; START TRANSACTION; -- applicationPassport ALTER TABLE `applicationPassport` ADD column `allowPwd` tinyint(1) DEFAULT NULL; -- passport ALTER TABLE `passport` MODIFY column `type` ENUM('password', 'sms', 'email', 'wechatWeb', 'wechatMp', 'wechatPublic', 'wechatPublicForWeb', 'wechatMpForWeb', 'wechatNative', 'loginName', 'oauth') NOT NULL; COMMIT;