CREATE TABLE [dbo].[CuteSupportNote] (
[NoteId] [int] IDENTITY (1, 1) NOT NULL ,
[OperatorId] [int] NOT NULL ,
[OperatorName] [nvarchar] (50) NOT NULL ,
[CreateTime] [datetime] NOT NULL ,
[UpdateTime] [datetime] NOT NULL ,
[Color] [nvarchar] (50) NOT NULL ,
[Title] [nvarchar] (200) NOT NULL ,
[Content] [ntext] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[CuteSupportNote] WITH NOCHECK ADD
CONSTRAINT [PK_CuteSupportNote] PRIMARY KEY CLUSTERED
(
[NoteId]
) ON [PRIMARY]
CREATE TABLE [dbo].[CuteSupportSession] (
[LocationId] [int] IDENTITY (1, 1) NOT NULL ,
[CustomerId] [uniqueidentifier] NOT NULL ,
[BeginTime] [datetime] NOT NULL ,
[ActiveTime] [datetime] NOT NULL ,
[UserId] [int] NULL ,
[DisplayName] [nvarchar] (50) NOT NULL ,
[IPAddress] [nvarchar] (50) NOT NULL ,
[Culture] [nvarchar] (50) NOT NULL ,
[Platform] [nvarchar] (50) NOT NULL ,
[Browser] [nvarchar] (50) NOT NULL ,
[OperatorId] [int] NOT NULL ,
[OperatorName] [nvarchar] (50) NOT NULL ,
[PubicProperties] [ntext] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[CuteSupportSession] WITH NOCHECK ADD
CONSTRAINT [PK_CuteSupportSession] PRIMARY KEY CLUSTERED
(
[LocationId]
) ON [PRIMARY]
ALTER TABLE dbo.CuteChatClient ADD
IPAddress nvarchar(50) NULL
ALTER TABLE dbo.CuteSupportCustomer ADD
Platform nvarchar(50) NULL
ALTER TABLE dbo.CuteSupportCustomer ADD
Browser nvarchar(50) NULL
ALTER TABLE dbo.CuteSupportCustomer
DROP COLUMN LocationId
GO
EXEC sp_rename 'CuteChatClient.AnonymousPubicProperties', 'AnonymousPublicProperties', 'COLUMN';
GO
GO
EXEC sp_rename 'CuteChatUser.PubicProperties', 'PublicProperties', 'COLUMN';
GO
GO
EXEC sp_rename 'CuteSupportSession.PubicProperties', 'PublicProperties', 'COLUMN';
GO
GO
EXEC sp_rename 'CuteSupportCustomer.PubicProperties', 'PublicProperties', 'COLUMN';