I have tried to install the stand alone version of Cute Live Support however the file LiveSupportWeb.sql is missing from the SQLScripts directory.

I have not been able to proceed with the installation, I assume I need this file…

Can anyone help me out..

Thanks 

Matt

Matt,

 

I am sorry for the inconvenience. We uploaded a wrong version file last night.

 

Here is the LiveSupportWeb.sql.

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyUsers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MyUsers]
GO

CREATE TABLE [dbo].[MyUsers] (
 [LoginName] [nvarchar] (20) NOT NULL ,
 [NickName] [nvarchar] (50) NOT NULL ,
 [Password] [nvarchar] (50) NOT NULL ,
 [Email] [nvarchar] (50) NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[MyUsers] WITH NOCHECK ADD
 CONSTRAINT [PK_MyUsers] PRIMARY KEY  CLUSTERED
 (
  [LoginName]
 )  ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [IX_MyUsers] ON [dbo].[MyUsers]([NickName]) ON [PRIMARY]
GO

-- Add the portal-administrator
IF NOT EXISTS (SELECT LoginName FROM MyUsers WHERE LoginName='Admin')
  INSERT INTO MyUsers (LoginName, NickName, Password,Email) VALUES ('admin', 'admin', 'admin','[email protected]')