IF NOT EXISTS(
    SELECT * FROM sys.columns 
    WHERE Name      = N'verifyCode'
      AND Object_ID = Object_ID(N'pal_User'))
BEGIN
    ALTER TABLE dbo.pal_User 
	ADD verifyCode varchar(10) NOT NULL default '';
END
GO
IF NOT EXISTS(
    SELECT * FROM sys.columns 
    WHERE Name      = N'verifyCodeValidUntil'
      AND Object_ID = Object_ID(N'pal_User'))
BEGIN
    ALTER TABLE dbo.pal_User 
	ADD verifyCodeValidUntil  datetime NOT NULL default '1901-01-01';
END

IF NOT EXISTS(
    SELECT * FROM sys.columns 
    WHERE Name      = N'verifyCodeWrongAttempts'
      AND Object_ID = Object_ID(N'pal_User'))
BEGIN
    ALTER TABLE dbo.pal_User 
	ADD verifyCodeWrongAttempts int NOT NULL default 0;
END

update pal_Setup set isGoogleSignIn = 0 where code = 'stud-1'
GO