GO
CREATE TABLE [dbo].[ZL_QrCode](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ImageUrl] [nvarchar](255) NULL,
[CodeType] [nvarchar](50) NULL,
[CodeLevel] [nvarchar](50) NULL,
[CodeVersion] [int] NULL,
[CodeContents] [nvarchar](255) NULL,
[UserName] [nvarchar](50) NULL,
[Type] [int] NULL,
[CreateTime] [datetime] NULL,
[AppID] [int] NULL,
[Urls] [nvarchar](500) NULL,
CONSTRAINT [PK_ZL_QrCode] PRIMARY KEY CLUSTERED
([ID] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'纠错等级 分为' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_QrCode', @level2type=N'COLUMN',@level2name=N'CodeLevel'
GO

ALTER TABLE [dbo].[ZL_QrCode] ADD  DEFAULT ((0)) FOR [Type]