/****** Object:  Table [dbo].[CoreCmsPrinter]    Script Date: 2022/9/17 2:15:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[CoreCmsPrinter](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NOT NULL,
	[code] [nvarchar](50) NOT NULL,
	[clientId] [nvarchar](50) NOT NULL,
	[clientSecret] [nvarchar](50) NOT NULL,
	[machineCode] [nvarchar](50) NOT NULL,
	[msign] [nvarchar](50) NOT NULL,
	[printerName] [nvarchar](50) NOT NULL,
	[phone] [nvarchar](50) NOT NULL,
	[accessToken] [nvarchar](50) NULL,
	[refreshToken] [nvarchar](50) NULL,
	[expiresIn] [int] NULL,
	[expiressEndTime] [datetime] NULL,
	[parameters] [nvarchar](max) NULL,
	[createTime] [datetime] NOT NULL,
	[isDefault] [bit] NOT NULL,
	[isOpen] [bit] NOT NULL,
	[storeId] [int] NOT NULL,
 CONSTRAINT [PK_CoreCmsPrinter] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[CoreCmsPrinter] ADD  CONSTRAINT [DF_CoreCmsPrinter_expiresIn]  DEFAULT ((0)) FOR [expiresIn]
GO

ALTER TABLE [dbo].[CoreCmsPrinter] ADD  CONSTRAINT [DF_CoreCmsPrinter_isDefault]  DEFAULT ((0)) FOR [isDefault]
GO

ALTER TABLE [dbo].[CoreCmsPrinter] ADD  CONSTRAINT [DF_CoreCmsPrinter_isOpen]  DEFAULT ((0)) FOR [isOpen]
GO

ALTER TABLE [dbo].[CoreCmsPrinter] ADD  CONSTRAINT [DF_CoreCmsPrinter_storeId]  DEFAULT ((0)) FOR [storeId]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÐòÁÐ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ó¦ÓÃÃû³Æ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ó¦ÓñàÂë' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'code'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ò×ÁªÔÆÓ¦ÓÃid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'clientId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ò×ÁªÔÆÓ¦ÓÃÃÜÔ¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'clientSecret'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ò×ÁªÔÆÖն˺Å' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'machineCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ò×ÁªÔÆÖÕ¶ËÃÜÔ¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'msign'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'´òÓ¡»úÃû³Æ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'printerName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÁªÏµµç»°' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'phone'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'·ÃÎÊÁîÅÆ£¬APIµ÷ÓÃʱÐèÒª£¬ÁîÅÆ¿ÉÒÔÖظ´Ê¹ÓÃÎÞʧЧʱ¼ä£¬Ç뿪·¢ÕßÈ«¾Ö±£´æ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'accessToken'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¸üÐÂaccess_tokenËùÐ裬ÓÐЧʱ¼ä35Ìì' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'refreshToken'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÁîÅƵÄÓÐЧʱ¼ä£¬µ¥Î»Ãë (30Ìì),×¢£º¸ÃģʽÏ¿ɺöÂԴ˲ÎÊý' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'expiresIn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓÐЧÆÚ½Øֹʱ¼ä' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'expiressEndTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆäËû²ÎÊý' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'parameters'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'´´½¨Ê±¼ä' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'createTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÊÇ·ñĬÈÏ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'isDefault'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÊÇ·ñ¿ªÆô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'isOpen'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'°ó¶¨Ãŵê' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter', @level2type=N'COLUMN',@level2name=N'storeId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'´òÓ¡»úÁбí' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsPrinter'
GO