db/script.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

USE [letswit]
GO
/****** Object:  Table [dbo].[H_viewCount]    Script Date: 12/01/2018 10:26:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[H_viewCount](
	[viewID] [int] IDENTITY(10000000,1) NOT NULL,
	[userID] [int] NULL,
	[viewProduct] [varchar](50) NULL,
	[viewProductID] [int] NULL,
	[viewTime] [datetime] NULL,
 CONSTRAINT [PK_H_viewCount] PRIMARY KEY CLUSTERED 
(
	[viewID] 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 ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[H_viewCount] ON
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000000, 0, N'activity', 10000060, CAST(0x0000A97401600C38 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000001, 0, N'activity', 10000060, CAST(0x0000A974016024D4 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000002, 0, N'activity', 10000060, CAST(0x0000A97401602984 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000003, -1, N'activity', 10000060, CAST(0x0000A974016097AC AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000004, -1, N'activity', 10000055, CAST(0x0000A974016126A4 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000005, -1, N'activity', 10000055, CAST(0x0000A97401615200 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000006, -1, N'activity', 10000057, CAST(0x0000A97401615458 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000007, -1, N'activity', 10000057, CAST(0x0000A9740162342C AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000008, -1, N'activity', 10000060, CAST(0x0000A97401623558 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000009, -1, N'activity', 10000057, CAST(0x0000A974016259AC AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000010, -1, N'activity', 10000057, CAST(0x0000A97401626EC4 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000011, 10000004, N'activity', 10000057, CAST(0x0000A97401631E8C AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000012, 10000004, N'activity', 10000059, CAST(0x0000A9740163233C AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000013, 10000004, N'activity', 10000059, CAST(0x0000A97401632A44 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000014, 10000004, N'activity', 10000059, CAST(0x0000A97401650030 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000015, 10000004, N'activity', 10000060, CAST(0x0000A97401651674 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000016, 10000004, N'activity', 10000059, CAST(0x0000A974016519F8 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000017, 10000004, N'activity', 10000059, CAST(0x0000A97401652484 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000018, 10000004, N'activity', 10000059, CAST(0x0000A974016541D0 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000019, 10000004, N'activity', 10000059, CAST(0x0000A97401655490 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000020, 10000004, N'activity', 10000059, CAST(0x0000A97401659054 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000021, 10000004, N'activity', 10000059, CAST(0x0000A9740165B5D4 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000022, 10000004, N'activity', 10000059, CAST(0x0000A9740165BF34 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000023, 10000004, N'activity', 10000060, CAST(0x0000A974017BCD4C AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000024, 10000004, N'activity', 10000061, CAST(0x0000A974017C22D8 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000025, 10000004, N'activity', 10000061, CAST(0x0000A974017C2D64 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000026, 10000004, N'activity', 10000061, CAST(0x0000A974017C36C4 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000027, 10000004, N'activity', 10000061, CAST(0x0000A974017C508C AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000028, 10000004, N'activity', 10000061, CAST(0x0000A974017C8674 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000029, -1, N'activity', 10000061, CAST(0x0000A974017F40E4 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000030, 10000004, N'activity', 10000061, CAST(0x0000A974017F4A44 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000031, 10000004, N'activity', 10000061, CAST(0x0000A9740180A524 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000032, 10000004, N'activity', 10000061, CAST(0x0000A974018101B8 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000033, -1, N'activity', 10000061, CAST(0x0000A97A010FECE4 AS DateTime))
INSERT [dbo].[H_viewCount] ([viewID], [userID], [viewProduct], [viewProductID], [viewTime]) VALUES (10000034, -1, N'activity', 10000060, CAST(0x0000A97A010FEF3C AS DateTime))