ALTER TABLE Member ADD isdynamicLogin INT DEFAULT '1';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'动态码登录  0否，1是，2已绑定' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',
@level1name=N'Member', @level2type=N'COLUMN',@level2name=N'isdynamicLogin'


ALTER TABLE Member ADD loginErrNum INT DEFAULT '0';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录错误次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',
@level1name=N'Member', @level2type=N'COLUMN',@level2name=N'loginErrNum'


ALTER TABLE Member ADD dynamicLoginCodeDate VARCHAR(50) NOT NULL DEFAULT 'default';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'动态生成码的时间，每次生成二维码时变的' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',
@level1name=N'Member', @level2type=N'COLUMN',@level2name=N'dynamicLoginCodeDate'

UPDATE Member SET isdynamicLogin=0;

UPDATE Member SET loginErrNum=0;

ALTER TABLE LR_Base_User ADD isdynamicLogin INT DEFAULT '1';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'动态码登录  0否，1是，2已绑定' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',
@level1name=N'LR_Base_User', @level2type=N'COLUMN',@level2name=N'isdynamicLogin'


ALTER TABLE LR_Base_User ADD loginErrNum INT DEFAULT '0';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录错误次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',
@level1name=N'LR_Base_User', @level2type=N'COLUMN',@level2name=N'loginErrNum'


ALTER TABLE LR_Base_User ADD dynamicLoginCodeDate VARCHAR(50) NOT NULL DEFAULT 'default';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'动态生成码的时间，每次生成二维码时变的' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',
@level1name=N'LR_Base_User', @level2type=N'COLUMN',@level2name=N'dynamicLoginCodeDate'

UPDATE LR_Base_User SET isdynamicLogin=0;
UPDATE LR_Base_User SET loginErrNum=0;

---------------------------------------------------------------------------------------------------------------------------------

ALTER TABLE Goceen_SysUsers ADD isdynamicLogin INT DEFAULT '1';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'动态码登录  0否，1是，2已绑定' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',
@level1name=N'Goceen_SysUsers', @level2type=N'COLUMN',@level2name=N'isdynamicLogin';


ALTER TABLE Goceen_SysUsers ADD loginErrNum INT DEFAULT '0';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录错误次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',
@level1name=N'Goceen_SysUsers', @level2type=N'COLUMN',@level2name=N'loginErrNum';


ALTER TABLE Goceen_SysUsers ADD dynamicLoginCodeDate VARCHAR(50) NOT NULL DEFAULT 'default';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'动态生成码的时间，每次生成二维码时变的' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',
@level1name=N'Goceen_SysUsers', @level2type=N'COLUMN',@level2name=N'dynamicLoginCodeDate';

UPDATE Goceen_SysUsers SET isdynamicLogin=0;
UPDATE Goceen_SysUsers SET loginErrNum=0;