ALTER TABLE [dbo].[CoreCmsUserGrade] ADD [isOpenUpgrade] BIT DEFAULT 0 NOT NULL, [developNum] INT DEFAULT 0 NOT NULL, [expenditureMoney] INT DEFAULT 0 NOT NULL, [rechargeAmount] INT DEFAULT 0 NOT NULL, [prioritySortId] INT DEFAULT 0 NOT NULL; EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'发展用户数量', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CoreCmsUserGrade', @level2type = N'COLUMN', @level2name = N'developNum'; EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'订单消费金额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CoreCmsUserGrade', @level2type = N'COLUMN', @level2name = N'expenditureMoney'; EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'开启自动升级', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CoreCmsUserGrade', @level2type = N'COLUMN', @level2name = N'isOpenUpgrade'; EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'充值总金额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CoreCmsUserGrade', @level2type = N'COLUMN', @level2name = N'rechargeAmount'; EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'权重优先级', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CoreCmsUserGrade', @level2type = N'COLUMN', @level2name = N'prioritySortId';