SQLize | PHPize | SQLtest

USE [tstTommyHilfiger] GO /****** Object: Table [dbo].[ImportQueueSFSent] Script Date: 03/11/2023 15:57:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ImportQueueSFSent]( [ClientID] [bigint] NULL, [SendID] [nvarchar](50) NULL, [SubscriberKey] [nvarchar](100) NULL, [EmailAddress] [nvarchar](100) NULL, [SubscriberID] [bigint] NULL, [ListID] [bigint] NULL, [EventDate] [datetime] NULL, [EventType] [nvarchar](50) NULL, [BatchID] [bigint] NULL, [TriggeredSendExternalKey] [nvarchar](100) NULL, [FileName] [nvarchar](200) NULL, [ProcessGuid] [uniqueidentifier] NULL, [EmailId] [int] NULL, [ContactId] [int] NULL, [CommunicationId] [bigint] NULL, [ProcessedDateTime] [datetime] NULL, [CreatedDateTime] [datetime] NULL, [StartProcessDateTime] [datetime] NULL, [NofError] [tinyint] NULL, [StepId] [tinyint] NULL, [CId] [bigint] IDENTITY(1,1) NOT NULL, [ReferenceContactId] [int] NULL, CONSTRAINT [PK_ImportQueueSFSent] PRIMARY KEY CLUSTERED ( [CId] 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].[ImportQueueSFSent] ADD CONSTRAINT [DF_ImportQueueSFSent_CreatedDateTime] DEFAULT (getdate()) FOR [CreatedDateTime] GO