USE [SaasCRM]
GO
IF NOT EXISTS(SELECT * FROM sys.objects WHERE type='U' AND name='Saas_Today_FromSoqiCN')
begin
CREATE TABLE [dbo].[Saas_Today_FromSoqiCN](
[SoqiCN_ID] [nvarchar](32) COLLATE Chinese_PRC_CI_AS NOT NULL,
[CompanyID] [nvarchar](32) COLLATE Chinese_PRC_CI_AS NULL,
[UserID] [nvarchar](32) COLLATE Chinese_PRC_CI_AS NULL,
[CreateTime] [datetime] NULL,
[SoqiCustomerID] [int] NULL,
CONSTRAINT [PK__Saas_TodayCustom__4DD47EBD] PRIMARY KEY CLUSTERED
(
[SoqiCN_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]
END
go
IF NOT EXISTS(SELECT * FROM sys.columns WHERE name='SoqiCustomerID'
AND object_id IN(SELECT object_id FROM sys.objects WHERE type='U' AND name='Saas_customer_customer_My'))
BEGIN
ALTER TABLE dbo.Saas_customer_customer_My ADD SoqiCustomerID INT
END