USE [DomainGuy]
GO

/****** Object:  Table [dbo].[ZonesStaging]    Script Date: 5/16/2022 7:40:30 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ZonesStaging](
	[DomainName] [varchar](75) NOT NULL,
	[Name] [varchar](75) NULL,
	[Tld] [varchar](10) NULL,
	[DNS_servers] [varchar](500) NULL,
	[IP] [varchar](50) NULL,
	[GeoIP] [varchar](25) NULL,
	[GeoByHtml] [varchar](50) NULL,
	[WebServer] [varchar](50) NULL,
	[Hostname] [varchar](100) NULL,
	[Emails] [varchar](200) NULL,
	[Alexa] [numeric](6, 0) NULL,
	[PhoneNumbers] [varchar](50) NULL,
	[Majestic] [numeric](6, 0) NULL,
	[DiscoveryDate] [date] NULL,
	[MD5] [varchar](24) NULL,
	[Status] [varchar](10) NULL,
 CONSTRAINT [PK_ZonesStaging] PRIMARY KEY CLUSTERED 
(
	[DomainName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ZonesStaging] ADD  CONSTRAINT [DF_ZonesStaging_Status]  DEFAULT ('No Change') FOR [Status]
GO


USE [DomainGuy]
GO

/****** Object:  Table [dbo].[Zones]    Script Date: 5/16/2022 7:40:16 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Zones](
	[DomainName] [varchar](75) NOT NULL,
	[Name] [varchar](75) NULL,
	[Tld] [varchar](10) NULL,
	[DNS_servers] [varchar](500) NULL,
	[IP] [varchar](50) NULL,
	[GeoIP] [varchar](25) NULL,
	[GeoByHtml] [varchar](50) NULL,
	[WebServer] [varchar](50) NULL,
	[Hostname] [varchar](100) NULL,
	[Emails] [varchar](200) NULL,
	[Alexa] [numeric](6, 0) NULL,
	[PhoneNumbers] [varchar](50) NULL,
	[Majestic] [numeric](6, 0) NULL,
	[DiscoveryDate] [date] NULL,
	[MD5] [varchar](24) NULL,
 CONSTRAINT [PK_Zones] PRIMARY KEY CLUSTERED 
(
	[DomainName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO