
/****** 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


