ÿþ

/****** Object:  Table [dbo].[CoreCmsContinuousCheckInRuleDetails]    Script Date: 2022/3/14 0:38:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CoreCmsContinuousCheckInRuleDetails](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[userGradeId] [int] NOT NULL,

	[ruleId] [int] NOT NULL,

	[num] [int] NOT NULL,

	[type] [int] NOT NULL,

 CONSTRAINT [PK_CoreCmsContinuousCheckInRuleDetails] 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

/****** Object:  Table [dbo].[CoreCmsContinuousCheckInRules]    Script Date: 2022/3/14 0:38:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CoreCmsContinuousCheckInRules](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[days] [int] NOT NULL,

 CONSTRAINT [PK_ContinuousCheckInRules] 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

/****** Object:  Table [dbo].[CoreCmsCumulativeCheckInRules]    Script Date: 2022/3/14 0:38:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CoreCmsCumulativeCheckInRules](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[days] [int] NOT NULL,

	[num] [int] NOT NULL,

	[type] [int] NOT NULL,

 CONSTRAINT [PK_CoreCmsCumulativeCheckInRules] 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

/****** Object:  Table [dbo].[CoreCmsUserCheckIn]    Script Date: 2022/3/14 0:38:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CoreCmsUserCheckIn](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[userId] [int] NOT NULL,

	[continuousCheckInCount] [int] NOT NULL,

	[cumulativeCheckInCount] [int] NOT NULL,

 CONSTRAINT [PK_CoreCmsUserCheckIn] 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

/****** Object:  Table [dbo].[CoreCmsUserCheckInDetails]    Script Date: 2022/3/14 0:38:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CoreCmsUserCheckInDetails](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[userId] [int] NOT NULL,

	[checkInData] [date] NOT NULL,

	[createTime] [datetime] NOT NULL,

 CONSTRAINT [PK_CoreCmsUserCheckInDetails] 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

SET IDENTITY_INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ON 



INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (109, 2, 37, 1, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (110, 6, 37, 2, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (111, 1006, 37, 3, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (112, 2, 38, 1, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (113, 6, 38, 2, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (114, 1006, 38, 3, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (115, 2, 39, 1, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (116, 6, 39, 2, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (117, 1006, 39, 3, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (118, 2, 40, 1, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (119, 6, 40, 2, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] ([id], [userGradeId], [ruleId], [num], [type]) VALUES (120, 1006, 40, 3, 1)

SET IDENTITY_INSERT [dbo].[CoreCmsContinuousCheckInRuleDetails] OFF

GO

SET IDENTITY_INSERT [dbo].[CoreCmsContinuousCheckInRules] ON 



INSERT [dbo].[CoreCmsContinuousCheckInRules] ([id], [days]) VALUES (37, 1)

INSERT [dbo].[CoreCmsContinuousCheckInRules] ([id], [days]) VALUES (38, 2)

INSERT [dbo].[CoreCmsContinuousCheckInRules] ([id], [days]) VALUES (39, 3)

INSERT [dbo].[CoreCmsContinuousCheckInRules] ([id], [days]) VALUES (40, 4)

SET IDENTITY_INSERT [dbo].[CoreCmsContinuousCheckInRules] OFF

GO

SET IDENTITY_INSERT [dbo].[CoreCmsCumulativeCheckInRules] ON 



INSERT [dbo].[CoreCmsCumulativeCheckInRules] ([id], [days], [num], [type]) VALUES (58, 4, 1, 1)

INSERT [dbo].[CoreCmsCumulativeCheckInRules] ([id], [days], [num], [type]) VALUES (59, 5, 2, 1)

INSERT [dbo].[CoreCmsCumulativeCheckInRules] ([id], [days], [num], [type]) VALUES (60, 6, 3, 1)

SET IDENTITY_INSERT [dbo].[CoreCmsCumulativeCheckInRules] OFF

GO

SET IDENTITY_INSERT [dbo].[CoreCmsUserCheckIn] ON 



INSERT [dbo].[CoreCmsUserCheckIn] ([id], [userId], [continuousCheckInCount], [cumulativeCheckInCount]) VALUES (17, 4467, 4, 4)

SET IDENTITY_INSERT [dbo].[CoreCmsUserCheckIn] OFF

GO

SET IDENTITY_INSERT [dbo].[CoreCmsUserCheckInDetails] ON 



INSERT [dbo].[CoreCmsUserCheckInDetails] ([id], [userId], [checkInData], [createTime]) VALUES (67, 4467, CAST(N'2022-03-01' AS Date), CAST(N'2022-03-14T00:35:05.757' AS DateTime))

INSERT [dbo].[CoreCmsUserCheckInDetails] ([id], [userId], [checkInData], [createTime]) VALUES (68, 4467, CAST(N'2022-03-02' AS Date), CAST(N'2022-03-14T00:35:10.817' AS DateTime))

INSERT [dbo].[CoreCmsUserCheckInDetails] ([id], [userId], [checkInData], [createTime]) VALUES (69, 4467, CAST(N'2022-03-11' AS Date), CAST(N'2022-03-14T00:35:12.377' AS DateTime))

INSERT [dbo].[CoreCmsUserCheckInDetails] ([id], [userId], [checkInData], [createTime]) VALUES (70, 4467, CAST(N'2022-03-12' AS Date), CAST(N'2022-03-14T00:35:14.723' AS DateTime))

SET IDENTITY_INSERT [dbo].[CoreCmsUserCheckInDetails] OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsContinuousCheckInRuleDetails', @level2type=N'COLUMN',@level2name=N'id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7b§~+R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsContinuousCheckInRuleDetails', @level2type=N'COLUMN',@level2name=N'userGradeId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Þí~~{0RÄR^R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsContinuousCheckInRuleDetails', @level2type=N'COLUMN',@level2name=N'ruleId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peÏ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsContinuousCheckInRuleDetails', @level2type=N'COLUMN',@level2name=N'num'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ïyR1YO2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsContinuousCheckInRuleDetails', @level2type=N'COLUMN',@level2name=N'type'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Þí~~{0RÄRfÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsContinuousCheckInRuleDetails'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsContinuousCheckInRules', @level2type=N'COLUMN',@level2name=N'id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N')Ype' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsContinuousCheckInRules', @level2type=N'COLUMN',@level2name=N'days'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Þí~~{0RÄR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsContinuousCheckInRules'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCumulativeCheckInRules', @level2type=N'COLUMN',@level2name=N'id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/}¡)Ype' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCumulativeCheckInRules', @level2type=N'COLUMN',@level2name=N'days'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peÏ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCumulativeCheckInRules', @level2type=N'COLUMN',@level2name=N'num'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ïyR1YO2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCumulativeCheckInRules', @level2type=N'COLUMN',@level2name=N'type'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/}¡~{0RÄR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsCumulativeCheckInRules'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsUserCheckIn', @level2type=N'COLUMN',@level2name=N'id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7b^R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsUserCheckIn', @level2type=N'COLUMN',@level2name=N'userId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Þí~~{0R!kpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsUserCheckIn', @level2type=N'COLUMN',@level2name=N'continuousCheckInCount'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/}¡~{0R!kpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsUserCheckIn', @level2type=N'COLUMN',@level2name=N'cumulativeCheckInCount'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7båeS~{0Rß~¡' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsUserCheckIn'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsUserCheckInDetails', @level2type=N'COLUMN',@level2name=N'id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7b^R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsUserCheckInDetails', @level2type=N'COLUMN',@level2name=N'userId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SbaSåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsUserCheckInDetails', @level2type=N'COLUMN',@level2name=N'checkInData'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SbaSöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsUserCheckInDetails', @level2type=N'COLUMN',@level2name=N'createTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7b~{0RfÆ~h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CoreCmsUserCheckInDetails'

GO

