2016-10-24

Software List (Enhanced Version) Create DB Table

USE [Info]
GO

/****** Object:  Table [dbo].[ARPTable]    Script Date: 10/24/2016 10:28:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ARPTable]') AND type in (N'U'))
DROP TABLE [dbo].[ARPTable]
GO

/****** Object:  Table [dbo].[ARPTable]    Script Date: 10/24/2016 10:28:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ARPTable](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[DateTime] [datetime] NOT NULL,
[HostName] [nvarchar](max) NOT NULL,
[IPAddress] [nvarchar](15) NOT NULL,
[MACAddress] [nvarchar](17) NOT NULL,
[Checked] [int] NOT NULL CONSTRAINT [DF_ARPTable_Checked]  DEFAULT ((0)),
 CONSTRAINT [PK_ARPTable] PRIMARY KEY CLUSTERED
(
[Serial] 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



USE [Info]
GO

/****** Object:  Table [dbo].[ASMAData]    Script Date: 10/24/2016 10:28:21 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ASMAData]') AND type in (N'U'))
DROP TABLE [dbo].[ASMAData]
GO

/****** Object:  Table [dbo].[ASMAData]    Script Date: 10/24/2016 10:28:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ASMAData](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Type] [nvarchar](50) NOT NULL,
[Value] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_ASMAData] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[ASMALink]    Script Date: 10/24/2016 10:28:14 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ASMALink]') AND type in (N'U'))
DROP TABLE [dbo].[ASMALink]
GO

/****** Object:  Table [dbo].[ASMALink]    Script Date: 10/24/2016 10:28:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ASMALink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[UserName] [int] NOT NULL,
[DeviceID] [int] NOT NULL,
[DeviceUserAgent] [int] NOT NULL,
[DeviceFriendlyName] [int] NOT NULL,
[DeviceModel] [int] NOT NULL,
[DeviceType] [int] NOT NULL,
[DeviceMACAddress] [int] NOT NULL,
 CONSTRAINT [PK_ASMALink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[FilterKeywords]    Script Date: 10/24/2016 10:27:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FilterKeywords]') AND type in (N'U'))
DROP TABLE [dbo].[FilterKeywords]
GO

/****** Object:  Table [dbo].[FilterKeywords]    Script Date: 10/24/2016 10:27:59 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[FilterKeywords](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Type] [int] NOT NULL,
[Value] [nvarchar](max) NULL,
 CONSTRAINT [PK_FilterKeyword] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoAllDataLink]    Script Date: 03/23/2016 17:23:51 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoAllDataLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoAllDataLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoAllDataLink]    Script Date: 03/23/2016 17:23:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoAllDataLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Type] [int] NOT NULL,
[Value] [nvarchar](max) NULL,
 CONSTRAINT [PK_InfoAllData] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoAllDataType]    Script Date: 03/23/2016 17:24:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoAllDataType]') AND type in (N'U'))
DROP TABLE [dbo].[InfoAllDataType]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoAllDataType]    Script Date: 03/23/2016 17:24:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoAllDataType](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Type] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_InfoAllDataType] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoAllLink]    Script Date: 03/23/2016 17:24:09 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoAllLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoAllLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoAllLink]    Script Date: 03/23/2016 17:24:09 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoAllLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Record] [int] NOT NULL,
[Type] [nvarchar](10) NOT NULL,
[TypeSerial] [int] NOT NULL,
 CONSTRAINT [PK_InfoAllLink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoCDROMLink]    Script Date: 03/23/2016 17:24:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoCDROMLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoCDROMLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoCDROMLink]    Script Date: 03/23/2016 17:24:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoCDROMLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Caption] [int] NOT NULL,
[MediaType] [int] NOT NULL,
[MfrAssignedRevisionLevel] [int] NOT NULL,
[Name] [int] NOT NULL,
 CONSTRAINT [PK_InfoCDROMLink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoCPULink]    Script Date: 03/23/2016 17:24:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoCPULink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoCPULink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoCPULink]    Script Date: 03/23/2016 17:24:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoCPULink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[AddressWidth] [int] NOT NULL,
[Architecture] [int] NOT NULL,
[Caption] [int] NOT NULL,
[DataWidth] [int] NOT NULL,
[DeviceID] [int] NOT NULL,
[ExtClock] [int] NOT NULL,
[Family] [int] NOT NULL,
[Level] [int] NOT NULL,
[Manufacturer] [int] NOT NULL,
[MaxClockSpeed] [int] NOT NULL,
[Name] [int] NOT NULL,
[NumberOfCores] [int] NOT NULL,
[NumberOfLogicalProcessors] [int] NOT NULL,
[ProcessorId] [int] NOT NULL,
[SocketDesignation] [int] NOT NULL,
 CONSTRAINT [PK_InfoCPULink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoDiskLink]    Script Date: 03/23/2016 17:24:27 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoDiskLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoDiskLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoDiskLink]    Script Date: 03/23/2016 17:24:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoDiskLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Caption] [int] NOT NULL,
[FirmwareRevision] [int] NOT NULL,
[InterfaceType] [int] NOT NULL,
[MediaType] [int] NOT NULL,
[Model] [int] NOT NULL,
[SerialNumber] [int] NOT NULL,
[Signature] [int] NOT NULL,
[Size] [int] NOT NULL,
 CONSTRAINT [PK_InfoDiskLink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoMBLink]    Script Date: 03/23/2016 17:24:34 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoMBLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoMBLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoMBLink]    Script Date: 03/23/2016 17:24:34 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoMBLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Manufacturer] [int] NOT NULL,
[Product] [int] NOT NULL,
[SerialNumber] [int] NOT NULL,
[Version] [int] NOT NULL,
 CONSTRAINT [PK_InfoMBLink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoMEMLink]    Script Date: 03/23/2016 17:24:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoMEMLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoMEMLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoMEMLink]    Script Date: 03/23/2016 17:24:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoMEMLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[BankLabel] [int] NOT NULL,
[DeviceLocator] [int] NOT NULL,
[Tag] [int] NOT NULL,
[Capacity] [int] NOT NULL,
[Manufacturer] [int] NOT NULL,
[MemoryType] [int] NOT NULL,
[PartNumber] [int] NOT NULL,
[SerialNumber] [int] NOT NULL,
[Speed] [int] NOT NULL,
 CONSTRAINT [PK_InfoMEMLink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_InfoNICLink_Registed]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[InfoNICLink] DROP CONSTRAINT [DF_InfoNICLink_Registed]
END

GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoNICLink]    Script Date: 03/23/2016 17:24:47 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoNICLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoNICLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoNICLink]    Script Date: 03/23/2016 17:24:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoNICLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[DHCPEnabled] [int] NOT NULL,
[DNSHostName] [int] NOT NULL,
[IPAddress] [int] NOT NULL,
[Caption] [int] NOT NULL,
[MACAddress] [int] NOT NULL,
[ServiceName] [int] NOT NULL,
[Registed] [int] NOT NULL,
 CONSTRAINT [PK_InfoNICLink] PRIMARY KEY CLUSTERED
(
[Serial] 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

ALTER TABLE [dbo].[InfoNICLink] ADD  CONSTRAINT [DF_InfoNICLink_Registed]  DEFAULT ((0)) FOR [Registed]
GO


USE [Info]
GO

/****** Object:  Table [dbo].[InfoOSLink]    Script Date: 03/23/2016 17:24:52 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoOSLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoOSLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoOSLink]    Script Date: 03/23/2016 17:24:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoOSLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[CSName] [int] NOT NULL,
[RegisteredUser] [int] NOT NULL,
[SerialNumber] [int] NOT NULL,
[InstallDate] [int] NOT NULL,
[LastBootUpTime] [int] NOT NULL,
[BuildNumber] [int] NOT NULL,
[Caption] [int] NOT NULL,
[CodeSet] [int] NOT NULL,
[CountryCode] [int] NOT NULL,
[CSDVersion] [int] NOT NULL,
[CurrentTimeZone] [int] NOT NULL,
[Locale] [int] NOT NULL,
[Manufacturer] [int] NOT NULL,
[OperatingSystemSKU] [int] NOT NULL,
[OSArchitecture] [int] NOT NULL,
[OSProductSuite] [int] NOT NULL,
[OSLanguage] [int] NOT NULL,
[OSType] [int] NOT NULL,
[OtherTypeDescription] [int] NOT NULL,
[ProductKey] [int] NOT NULL,
[ProductType] [int] NOT NULL,
[Version] [int] NOT NULL,
 CONSTRAINT [PK_InfoOSLink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoOfficeLink]    Script Date: 03/23/2016 17:24:57 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoOfficeLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoOfficeLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoOfficeLink]    Script Date: 03/23/2016 17:24:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoOfficeLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Version] [int] NOT NULL,
[ProductName] [int] NOT NULL,
[ProductID] [int] NOT NULL,
[OfficeType] [int] NOT NULL,
[ProductKey] [int] NOT NULL,
[Note] [int] NOT NULL,
 CONSTRAINT [PK_InfoOfficeLink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoPrivilegeLink]    Script Date: 03/23/2016 17:25:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoPrivilegeLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoPrivilegeLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoPrivilegeLink]    Script Date: 03/23/2016 17:25:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoPrivilegeLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[PrivilegeType] [int] NOT NULL,
[Account] [int] NOT NULL,
 CONSTRAINT [PK_InfoPrivilegeLink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoRecordLink]    Script Date: 03/23/2016 17:25:08 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoRecordLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoRecordLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoRecordLink]    Script Date: 03/23/2016 17:25:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoRecordLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[DateTime] [int] NOT NULL,
[HostName] [int] NOT NULL,
[DataType] [int] NOT NULL,
[LastLogonAccount] [int] NOT NULL,
[ComputerSID] [int] NOT NULL,
 CONSTRAINT [PK_InfoRecordLink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[InfoSoftwareLink]    Script Date: 03/23/2016 17:25:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InfoSoftwareLink]') AND type in (N'U'))
DROP TABLE [dbo].[InfoSoftwareLink]
GO

USE [Info]
GO

/****** Object:  Table [dbo].[InfoSoftwareLink]    Script Date: 03/23/2016 17:25:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[InfoSoftwareLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[InstallDate] [int] NOT NULL,
[DisplayName] [int] NOT NULL,
[DisplayVersion] [int] NOT NULL,
[Publisher] [int] NOT NULL,
 CONSTRAINT [PK_InfoSoftwareLink] PRIMARY KEY CLUSTERED
(
[Serial] 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

USE [Info]
GO

/****** Object:  Table [dbo].[OutgoingData]    Script Date: 10/24/2016 10:30:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OutgoingData]') AND type in (N'U'))
DROP TABLE [dbo].[OutgoingData]
GO

/****** Object:  Table [dbo].[OutgoingData]    Script Date: 10/24/2016 10:30:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OutgoingData](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Type] [nchar](10) NOT NULL,
[Value] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_OutgoingData] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[OutgoingLink]    Script Date: 10/24/2016 10:31:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OutgoingLink]') AND type in (N'U'))
DROP TABLE [dbo].[OutgoingLink]
GO

/****** Object:  Table [dbo].[OutgoingLink]    Script Date: 10/24/2016 10:31:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[OutgoingLink](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[DateTime] [int] NOT NULL,
[HostName] [int] NOT NULL,
[NIC] [int] NOT NULL,
[To] [int] NOT NULL,
[Port] [int] NOT NULL,
[Process] [int] NOT NULL,
 CONSTRAINT [PK_OutgoingAllLink] PRIMARY KEY CLUSTERED
(
[Serial] 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


USE [Info]
GO

/****** Object:  Table [dbo].[Property]    Script Date: 10/24/2016 10:31:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Property]') AND type in (N'U'))
DROP TABLE [dbo].[Property]
GO

/****** Object:  Table [dbo].[Property]    Script Date: 10/24/2016 10:31:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Property](
[Serial] [int] IDENTITY(1,1) NOT NULL,
[Type] [int] NOT NULL,
[MACAddress] [nchar](17) NOT NULL,
[Company] [int] NOT NULL,
[PropertyID] [varchar](20) NOT NULL,
 CONSTRAINT [PK_Property] PRIMARY KEY CLUSTERED
(
[Serial] 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






insert into [Info].[dbo].[InfoAllDataType] ([Type]) values
('MBManufacturer'),
('MBProduct'),
('MBSerialNumber'),
('MBVersion'),
('CPUAddressWidth'),
('CPUArchitecture'),
('CPUCaption'),
('CPUDataWidth'),
('CPUDeviceID'),
('CPUExtClock'),
('CPUFamily'),
('CPULevel'),
('CPUManufacturer'),
('CPUMaxClockSpeed'),
('CPUName'),
('CPUNumberOfCores'),
('CPUNumberOfLogicalProcessors'),
('CPUProcessorId'),
('CPUSocketDesignation'),
('MEMBankLabel'),
('MEMDeviceLocator'),
('MEMTag'),
('MEMCapacity'),
('MEMManufacturer'),
('MEMMemoryType'),
('MEMPartNumber'),
('MEMSerialNumber'),
('MEMSpeed'),
('NICDHCPEnabled'),
('NICDNSHostName'),
('NICIPAddress'),
('NICCaption'),
('NICMACAddress'),
('NICServiceName'),
('DiskCaption'),
('DiskFirmwareRevision'),
('DiskInterfaceType'),
('DiskMediaType'),
('DiskModel'),
('DiskSerialNumber'),
('DiskSignature'),
('DiskSize'),
('CDROMCaption'),
('CDROMMediaType'),
('CDROMMfrAssignedRevisionLevel'),
('CDROMName'),
('OSBuildNumber'),
('OSCaption'),
('OSCodeSet'),
('OSCountryCode'),
('OSCSDVersion'),
('OSCurrentTimeZone'),
('OSLocale'),
('OSManufacturer'),
('OSOperatingSystemSKU'),
('OSOSArchitecture'),
('OSOSLanguage'),
('OSOSProductSuite'),
('OSOSType'),
('OSOtherTypeDescription'),
('OSProductKey'),
('OSProductType'),
('OSVersion'),
('OSCSName'),
('OSRegisteredUser'),
('OSSerialNumber'),
('OSInstallDate'),
('OSLastBootUpTime'),
('PrivilegeType'),
('PrivilegeAccount'),
('OfficeVersion'),
('OfficeProductName'),
('OfficeProductID'),
('OfficeType'),
('OfficeProductKey'),
('OfficeNote'),
('SoftwareDisplayName'),
('SoftwareDisplayVersion'),
('SoftwarePublisher'),
('SoftwareInstallDate'),
('RecordDateTime'),
('RecordHostName'),
('RecordDataType'),
('RecordLastLogonAccount'),
('RecordComputerSID')

沒有留言: