if (not exists (select name from syscolumns where id = object_id('Pub_Album') and name = 'GradeGuid'))   
    Begin

    ALTER TABLE Pub_Album ADD
    GradeGuid nvarchar(64)

    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属年级
type:selectbox
fk_table:Pub_Grade
fk_key:Guid
fk_name:Name
' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Pub_Album', @level2type=N'COLUMN', @level2name=N'GradeGuid'

    End


if (not exists (select name from syscolumns where id = object_id('Pub_Album') and name = 'CategoryGuid'))   
    Begin

    ALTER TABLE Pub_Album ADD
    CategoryGuid nvarchar(64)

    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属类型
   type:selectbox
   fk_table:Pub_Category
   fk_key:Guid
   fk_name:Name' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Pub_Album', @level2type=N'COLUMN', @level2name=N'CategoryGuid'

    End


if (not exists (select name from syscolumns where id = object_id('Pub_Album') and name = 'AlbumYear'))   
    Begin

    ALTER TABLE Pub_Album ADD
    AlbumYear int

    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属年份
type:text
regex:num1
regex_msg:所属年份应为数字' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Pub_Album', @level2type=N'COLUMN', @level2name=N'AlbumYear'

    End