学习系统微课在线学习系统源码 教学管理平台

GO /****** Object: Table [dbo].[ThirdpartyLogin] Script Date: 08/29/2023 10:27:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ThirdpartyLogin]( [Tl_ID] [int] IDENTITY(1,1) NOT NULL, [Tl_Tag] [nvarchar](255) NULL, [Tl_Tax] [int] NOT NULL, [Tl_Account] [nvarchar](255) NULL, [Tl_Domain] [nvarchar](500) NULL, [Tl_Name] [nvarchar](255) NULL, [Tl_IsUse] [bit] NOT NULL, [Tl_IsRegister] [bit] NOT NULL, [Tl_APPID] [nvarchar](255) NULL, [Tl_Secret] [nvarchar](2000) NULL, [Tl_Returl] [nvarchar](1000) NULL, [Tl_Config] [nvarchar](max) NULL, CONSTRAINT [aaaaaThirdpartyLogin_PK] PRIMARY KEY NONCLUSTERED ( [Tl_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].[ThirdpartyLogin] ON INSERT [dbo].[ThirdpartyLogin] ([Tl_ID], [Tl_Tag], [Tl_Tax], [Tl_Account], [Tl_Domain], [Tl_Name], [Tl_IsUse], [Tl_IsRegister], [Tl_APPID], [Tl_Secret], [Tl_Returl], [Tl_Config]) VALUES (1, N'QqOpenID', 1, NULL, NULL, N'QQ', 1, 1, NULL, NULL, NULL, N'') INSERT [dbo].[ThirdpartyLogin] ([Tl_ID], [Tl_Tag], [Tl_Tax], [Tl_Account], [Tl_Domain], [Tl_Name], [Tl_IsUse], [Tl_IsRegister], [Tl_APPID], [Tl_Secret], [Tl_Returl], [Tl_Config]) VALUES (2, N'WeixinOpenID', 2, NULL, NULL, N'微信', 1, 1, NULL, NULL, NULL, NULL) INSERT [dbo].[ThirdpartyLogin] ([Tl_ID], [Tl_Tag], [Tl_Tax], [Tl_Account], [Tl_Domain], [Tl_Name], [Tl_IsUse], [Tl_IsRegister], [Tl_APPID], [Tl_Secret], [Tl_Returl], [Tl_Config]) VALUES (3, N'Jindie', 3, NULL, NULL, N'金蝶', 1, 1, NULL, NULL, NULL, N'') INSERT [dbo].[ThirdpartyLogin] ([Tl_ID], [Tl_Tag], [Tl_Tax], [Tl_Account], [Tl_Domain], [Tl_Name], [Tl_IsUse], [Tl_IsRegister], [Tl_APPID], [Tl_Secret], [Tl_Returl], [Tl_Config]) VALUES (4, N'ZzGongshang', 4, NULL, NULL, N'郑州工商', 0, 1, N'', N'', N'', N'') SET IDENTITY_INSERT [dbo].[ThirdpartyLogin] OFF /****** Object: Table [dbo].[ThirdpartyAccounts] Script Date: 08/29/2023 10:27:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ThirdpartyAccounts]( [Ta_ID] [int] IDENTITY(1,1) NOT NULL, [Ta_NickName] [nvarchar](255) NULL, [Ta_Headimgurl] [nvarchar](500) NULL, [Ta_Openid] [nvarchar](255) NULL, [Ta_Tag] [nvarchar](100) NULL, [Ac_ID] [bigint] NOT NULL, CONSTRAINT [aaaaaThirdpartyAccounts_PK] PRIMARY KEY NONCLUSTERED ( [Ta_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].[TestResults] Script Date: 08/29/2023 10:27:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TestResults]( [Tr_ID] [int] IDENTITY(1,1) NOT NULL, [Tr_Score] [real] NULL, [Tr_ScoreFinal] [real] NULL, [Tr_Draw] [real] NULL, [Tr_Colligate] [real] NULL, [Tr_Results] [ntext] NULL, [Tr_CrtTime] [datetime] NULL, [Tr_IP] [nvarchar](255) NULL, [Tr_Name] [nvarchar](255) NULL, [Tr_Mac] [nvarchar](255) NULL, [Tr_IsSubmit] [bit] NOT NULL, [Tr_UID] [nvarchar](255) NULL, [Sbj_ID] [bigint] NOT NULL, [Sbj_Name] [nvarchar](255) NULL, [Tp_Id] [bigint] NOT NULL, [Tp_Name] [nvarchar](255) NULL, [Ac_ID] [int] NOT NULL, [Ac_Name] [nvarchar](255) NULL, [Sts_ID] [bigint] NOT NULL, [Sts_Name] [nvarchar](255) NULL, [Org_ID] [int] NOT NULL, [Org_Name] [nvarchar](255) NULL, [St_Sex] [int] NOT NULL, [St_IDCardNumber] [nvarchar](50) NULL, [Cou_ID] [bigint] NOT NULL, CONSTRAINT [aaaaaTestResults_PK] PRIMARY KEY NONCLUSTERED ( [Tr_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 EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TestRes�