Re: Upgrade error from 3.0 to 3.1 Cutechat and Cutemessenger

  •  10-23-2006, 11:36 AM

    Re: Upgrade error from 3.0 to 3.1 Cutechat and Cutemessenger

    TLI,
     
    upgrade_3.0_to_3.1.sql
     

    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';

    GO
     
     
    upgrade_3.1_to_3.1.1.sql
     
    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';
    GO


    Keep me posted
     
     

    asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
    Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
    asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
    asp wysiwyg html editor: http://cutesoft.net/ASP
    asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
    Live Support: http://cutesoft.net/live-support/default.aspx

View Complete Thread