SQL

  •  08-30-2006, 7:48 PM

    SQL

    when i import the sql i get this
     
     
     localhost   cutechat
    Error
    SQL query: 
    IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[Roles]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[Roles]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[UserRole]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[UserRole]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[Users]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[Users]GO CREATE TABLE [dbo].[Roles](
    [RoleName][nvarchar]( 64 ) NOT NULL ,
    [IsSystemReserved][bit] NOT NULL
    ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[UserRole](
    [Username][nvarchar]( 64 ) NOT NULL ,
    [RoleName][nvarchar]( 64 ) NOT NULL
    ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[Users](
    [Username][nvarchar]( 64 ) NOT NULL ,
    [ PASSWORD ][nvarchar]( 64 ) NOT NULL ,
    [Age][int] NULL ,
    [Location][nvarchar]( 100 ) NULL ,
    [Occupation][nvarchar]( 100 ) NULL ,
    [Interests][nvarchar]( 100 ) NULL ,
    [Gender][bit] NULL ,
    [LastLoginTime][datetime] NOT NULL ,
    [DateCreated][datetime] NOT NULL
    ) ON [ PRIMARY ]GO IF NOT EXISTS (
    SELECT Rolename
    FROM Roles
    WHERE Rolename = 'Admins'
    )
    INSERT INTO Roles( RoleName, IsSystemReserved )
    VALUES (
    'Admins', 1
    )
    IF NOT
    EXISTS (
    SELECT Rolename
    FROM Roles
    WHERE Rolename = 'Members'
    )
    INSERT INTO Roles( RoleName, IsSystemReserved )
    VALUES (
    'Members', 1
    )
    IF NOT
    EXISTS (
    SELECT Username
    FROM Users
    WHERE Username = 'Admin'
    )
    INSERT INTO Users( Username, [
    PASSWORD ], Age, Gender, Location, Occupation, LastLoginTime, DateCreated )
    VALUES (
    'Admin', 'admin', 35, 1, 'Ontatio, Canada', 'Web Developer', GetDate(
    ), GetDate(
    )
    )
    IF NOT
    EXISTS (
    SELECT Username
    FROM UserRole
    WHERE Username = 'Admin'
    AND RoleName = 'Admins'
    )
    INSERT INTO UserRole( Username, Rolename )
    VALUES (
    'Admin', 'Admins'
    )
    IF NOT
    EXISTS (
    SELECT Username
    FROM UserRole
    WHERE Username = 'Admin'
    AND RoleName = 'Members'
    )
    INSERT INTO UserRole( Username, Rolename )
    VALUES (
    'Admin', 'Members'
    )
    IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatBadWord]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatBadWord]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatChannel]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatChannel]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatClient]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatClient]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatConfig]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatConfig]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatCustomItem]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatCustomItem]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatFile]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatFile]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatIPRule]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatIPRule]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatInstantMessage]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatInstantMessage]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatLobby]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatLobby]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatMessage]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatMessage]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatQueueItem]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatQueueItem]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatRelation]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatRelation]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatTempStateLog]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatTempStateLog]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteChatUser]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteChatUser]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteSupportCustomer]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteSupportCustomer]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteSupportFeedback]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteSupportFeedback]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteSupportLog]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteSupportLog]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteSupportNote]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteSupportNote]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteSupportOperator]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteSupportOperator]GO IF EXISTS (
    SELECT *
    FROM dbo.sysobjects
    WHERE id = object_id(
    N '[dbo].[CuteSupportSession]'
    )
    AND OBJECTPROPERTY(
    id, N 'IsUserTable'
    ) =1
    )
    DROP TABLE [dbo].[CuteSupportSession]GO CREATE TABLE [dbo].[CuteChatBadWord](
    [BadWordId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [BadWord][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [MatchType][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL
    ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatChannel](
    [ChannelId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [Location][nvarchar]( 50 ) NOT NULL ,
    [LocationId][int] NOT NULL ,
    [BeginTime][datetime] NOT NULL ,
    [ActiveTime][datetime] NOT NULL ,
    [Locked][bit] NOT NULL ,
    [KickedUsers][ntext] NOT NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatClient](
    [ClientId][uniqueidentifier] NOT NULL ,
    [Location][nvarchar]( 50 ) NOT NULL ,
    [ChannelId][int] NOT NULL ,
    [LocationId][int] NOT NULL ,
    [IPAddress][nvarchar]( 50 ) NULL ,
    [Software][nvarchar]( 50 ) NOT NULL ,
    [InstantTargetUserId][int] NOT NULL ,
    [IsAdmin][bit] NULL ,
    [BeginTime][datetime] NOT NULL ,
    [ActiveTime][datetime] NOT NULL ,
    [UserId][int] NOT NULL ,
    [DisplayName][nvarchar]( 50 ) NOT NULL ,
    [OnlineStatus][nvarchar]( 20 ) NOT NULL ,
    [AnonymousPubicProperties][ntext] NULL ,
    [AnonymousPrivateProperties][ntext] NULL ,
    [CurrentWorkXml][ntext] NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatConfig](
    [ConfigName][nvarchar]( 100 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [ConfigValue][ntext] COLLATE Latin1_General_CI_AS NOT NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatCustomItem](
    [ItemId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [ItemType][nvarchar]( 50 ) NOT NULL ,
    [ItemIndex][nvarchar]( 50 ) NOT NULL ,
    [Short1][nvarchar]( 50 ) NULL ,
    [Short2][nvarchar]( 50 ) NULL ,
    [Short3][nvarchar]( 50 ) NULL ,
    [Short4][nvarchar]( 50 ) NULL ,
    [Long1][nvarchar]( 1000 ) NULL ,
    [Long2][nvarchar]( 1000 ) NULL ,
    [ItemText][ntext] NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatFile](
    [FileId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [DownloadId][uniqueidentifier] NOT NULL ,
    [UserId][int] NOT NULL ,
    [DisplayName][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [FileTime][datetime] NOT NULL ,
    [FileName][nvarchar]( 255 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [FileMine][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [FileSize][int] NOT NULL ,
    [FileData][image] NOT NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatIPRule](
    [RuleId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [Sort][int] NOT NULL ,
    [IPExpression][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [Operate][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL
    ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatInstantMessage](
    [MessageId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [MessageTime][datetime] NOT NULL ,
    [Scope][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [MessageType][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [Location][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [ChannelId][int] NOT NULL ,
    [LocationId][int] NOT NULL ,
    [SenderUserId][int] NOT NULL ,
    [SenderDisplayName][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [TargetUserId][int] NULL ,
    [TargetDisplayName][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NULL ,
    [Whisper][bit] NULL ,
    [Bold][bit] NULL ,
    [Italic][bit] NULL ,
    [Underline][bit] NULL ,
    [FontColor][nvarchar]( 20 ) COLLATE Latin1_General_CI_AS NULL ,
    [FontName][nvarchar]( 20 ) COLLATE Latin1_General_CI_AS NULL ,
    [FontSize][nvarchar]( 20 ) COLLATE Latin1_General_CI_AS NULL ,
    [MessageText][nvarchar]( 2000 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [MessageHtml][ntext] COLLATE Latin1_General_CI_AS NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatLobby](
    [LobbyId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [Name][nvarchar]( 50 ) NOT NULL ,
    [Description][nvarchar]( 200 ) NOT NULL ,
    [Announcement][nvarchar]( 2000 ) NULL ,
    [IsPublic][bit] NOT NULL ,
    [IsEnable][bit] NOT NULL ,
    [IsHidden][bit] NOT NULL ,
    [Authenticate][bit] NOT NULL ,
    [AllowAnonymous][bit] NOT NULL ,
    [ PASSWORD ][nvarchar]( 50 ) NULL ,
    [Integration][nvarchar]( 50 ) NULL ,
    [ManagerList][nvarchar]( 1000 ) NOT NULL ,
    [MaxOnlineCount][int] NOT NULL
    ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatMessage](
    [MessageId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [MessageTime][datetime] NOT NULL ,
    [Scope][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [MessageType][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [Location][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [ChannelId][int] NOT NULL ,
    [LocationId][int] NOT NULL ,
    [SenderUserId][int] NOT NULL ,
    [SenderDisplayName][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [TargetUserId][int] NULL ,
    [TargetDisplayName][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NULL ,
    [Whisper][bit] NULL ,
    [Bold][bit] NULL ,
    [Italic][bit] NULL ,
    [Underline][bit] NULL ,
    [FontColor][nvarchar]( 20 ) COLLATE Latin1_General_CI_AS NULL ,
    [FontName][nvarchar]( 20 ) COLLATE Latin1_General_CI_AS NULL ,
    [FontSize][nvarchar]( 20 ) COLLATE Latin1_General_CI_AS NULL ,
    [MessageText][nvarchar]( 2000 ) COLLATE Latin1_General_CI_AS NOT NULL ,
    [MessageHtml][ntext] COLLATE Latin1_General_CI_AS NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatQueueItem](
    [QueueItemId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [ItemTime][bigint] NOT NULL ,
    [Scope][nvarchar]( 50 ) NOT NULL ,
    [SingleClientId][uniqueidentifier] NOT NULL ,
    [MultiClients][ntext] NULL ,
    [ItemName][nvarchar]( 50 ) NOT NULL ,
    [ItemType][nvarchar]( 50 ) NOT NULL ,
    [ItemXml][ntext] NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatRelation](
    [RelationId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [IndexType][nvarchar]( 50 ) NOT NULL ,
    [Index1][int] NOT NULL ,
    [Index2][int] NOT NULL ,
    [RelationType][nvarchar]( 50 ) NOT NULL
    ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatTempStateLog](
    [StateLogId][int] NOT NULL ,
    [ManagerId][int] NULL ,
    [LogTime][datetime] NULL ,
    [LogType][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NULL ,
    [Category][nvarchar]( 50 ) COLLATE Latin1_General_CI_AS NULL ,
    [ParentName][nvarchar]( 100 ) COLLATE Latin1_General_CI_AS NULL ,
    [TargetName][nvarchar]( 100 ) COLLATE Latin1_General_CI_AS NULL ,
    [TargetGuid][uniqueidentifier] NULL ,
    [TargetTime][datetime] NULL ,
    [TargetInteger][int] NULL ,
    [TargetText][ntext] COLLATE Latin1_General_CI_AS NULL ,
    [InfoXml][ntext] COLLATE Latin1_General_CI_AS NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteChatUser](
    [UserId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [UniqueName][nvarchar]( 50 ) NOT NULL ,
    [DisplayName][nvarchar]( 50 ) NOT NULL ,
    [PubicProperties][ntext] NULL ,
    [PrivateProperties][ntext] NULL ,
    [ContactSyncTime][datetime] NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteSupportCustomer](
    [CustomerId][uniqueidentifier] NOT NULL ,
    [UserId][int] NOT NULL ,
    [DisplayName][nvarchar]( 50 ) NULL ,
    [IPAddress][nvarchar]( 50 ) NOT NULL ,
    [Culture][nvarchar]( 50 ) NOT NULL ,
    [Platform][nvarchar]( 50 ) NULL ,
    [Browser][nvarchar]( 50 ) NULL ,
    [PathAndQuery][nvarchar]( 400 ) NOT NULL ,
    [BeginTime][datetime] NOT NULL ,
    [ActiveTime][datetime] NOT NULL ,
    [ STATUS ][nvarchar]( 50 ) NOT NULL ,
    [OperatorId][int] NULL ,
    [OperatorName][nvarchar]( 50 ) NULL ,
    [CurrentWorkXml][ntext] NULL ,
    [PubicProperties][ntext] NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteSupportFeedback](
    [FeedbackId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [Time][datetime] NOT NULL ,
    [UserId][int] NOT NULL ,
    [DisplayName][nvarchar]( 50 ) NOT NULL ,
    [Name][nvarchar]( 50 ) NOT NULL ,
    [Email][nvarchar]( 50 ) NOT NULL ,
    [Title][nvarchar]( 200 ) NOT NULL ,
    [Message][ntext] NOT NULL ,
    [LastReadOperatorId][int] NOT NULL ,
    [LastReadOperatorName][nvarchar]( 50 ) NOT NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[CuteSupportLog](
    [LogId][int]IDENTITY( 1, 1 ) NOT NULL ,
    [Time][datetime] NOT NULL ,
    [LogType][nvarchar]( 50 ) NOT NULL ,
    [CustomerUserId][int] NULL ,
    [CustomerName][nvarchar]( 50 ) NULL ,
    [OperatorId][int] NULL ,
    [OperatorName][nvarchar]( 50 ) NULL ,
    [Message][ntext] NULL ,
    [Info1][nvarchar]( 500 ) NULL ,
    [Info2][nvarchar]( 500 ) NULL ,
    [Info3][nvarchar]( 500 ) NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO 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 ]GO CREATE TABLE [dbo].[CuteSupportOperator](
    [UserId][int] NOT NULL ,
    [ClientId][uniqueidentifier] NULL ,
    [IsReady][bit] NOT NULL ,
    [SyncTicks][bigint] NULL ,
    [ActiveTime][datetime] NULL ,
    [CurrentWorkXml][ntext] NULL
    ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO 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 ]GO ALTER TABLE [dbo].[CuteChatBadWord] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatBadWord] PRIMARY KEY CLUSTERED(
    [BadWordId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatChannel] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatChannel] PRIMARY KEY CLUSTERED(
    [ChannelId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatClient] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatClient] PRIMARY KEY CLUSTERED(
    [ClientId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatConfig] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatConfig] PRIMARY KEY CLUSTERED(
    [ConfigName]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatCustomItem] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatCustomItem] PRIMARY KEY CLUSTERED(
    [ItemId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatFile] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatFile] PRIMARY KEY CLUSTERED(
    [FileId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatIPRule] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatIPRule] PRIMARY KEY CLUSTERED(
    [RuleId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatInstantMessage] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatInstantMessage] PRIMARY KEY CLUSTERED(
    [MessageId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatLobby] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatLobby] PRIMARY KEY CLUSTERED(
    [LobbyId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatMessage] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatMessage] PRIMARY KEY CLUSTERED(
    [MessageId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatQueueItem] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatQueueItem] PRIMARY KEY CLUSTERED(
    [QueueItemId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatRelation] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatRelation] PRIMARY KEY CLUSTERED(
    [RelationId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatTempStateLog] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatTempStateLog] PRIMARY KEY CLUSTERED(
    [StateLogId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatUser] WITH NOCHECK ADD CONSTRAINT [PK_CuteChatUser] PRIMARY KEY CLUSTERED(
    [UserId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteSupportCustomer] WITH NOCHECK ADD CONSTRAINT [PK_CuteSupportCustomer] PRIMARY KEY CLUSTERED(
    [CustomerId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteSupportFeedback] WITH NOCHECK ADD CONSTRAINT [PK_CuteSupportFeedback] PRIMARY KEY CLUSTERED(
    [FeedbackId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteSupportLog] WITH NOCHECK ADD CONSTRAINT [PK_CuteSupportLog] PRIMARY KEY CLUSTERED(
    [LogId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteSupportNote] WITH NOCHECK ADD CONSTRAINT [PK_CuteSupportNote] PRIMARY KEY CLUSTERED(
    [NoteId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteSupportOperator] WITH NOCHECK ADD CONSTRAINT [PK_CuteSupportOperator] PRIMARY KEY CLUSTERED(
    [UserId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteSupportSession] WITH NOCHECK ADD CONSTRAINT [PK_CuteSupportSession] PRIMARY KEY CLUSTERED(
    [LocationId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatChannel] ADD CONSTRAINT [DF_CuteChatChannel_Locked]DEFAULT( 0 ) FOR [Locked],
    CONSTRAINT [DF_CuteChatChannel_KickedUsers]DEFAULT( '' ) FOR [KickedUsers]GO ALTER TABLE [dbo].[CuteChatClient] ADD CONSTRAINT [DF_CuteChatClient_Software]DEFAULT( '' ) FOR [Software],
    CONSTRAINT [DF_CuteChatClient_InstantTargetUserId]DEFAULT( 0 ) FOR [InstantTargetUserId]GO CREATE INDEX [IX_CuteChatCustomItem] ON [dbo].[CuteChatCustomItem](
    [ItemType],
    [ItemIndex]
    ) ON [ PRIMARY ]GO CREATE UNIQUE INDEX [IX_CuteChatFile] ON [dbo].[CuteChatFile](
    [DownloadId]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteChatLobby] ADD CONSTRAINT [DF_CuteChatLobby_Description]DEFAULT( '' ) FOR [Description],
    CONSTRAINT [DF_CuteChatLobby_IsPublic]DEFAULT( 1 ) FOR [IsPublic],
    CONSTRAINT [DF_CuteChatLobby_IsEnable]DEFAULT( 1 ) FOR [IsEnable],
    CONSTRAINT [DF_CuteChatLobby_IsHidden]DEFAULT( 0 ) FOR [IsHidden],
    CONSTRAINT [DF_CuteChatLobby_Authenticate]DEFAULT( 0 ) FOR [Authenticate],
    CONSTRAINT [DF_CuteChatLobby_AllowAnonymous]DEFAULT( 1 ) FOR [AllowAnonymous],
    CONSTRAINT [DF_CuteChatLobby_ManagerList]DEFAULT( '' ) FOR [ManagerList],
    CONSTRAINT [DF_CuteChatLobby_MaxOnlineCount]DEFAULT( 200 ) FOR [MaxOnlineCount]GO CREATE INDEX [IX_CuteChatQueueItem] ON [dbo].[CuteChatQueueItem](
    [ItemTime]
    ) ON [ PRIMARY ]GO CREATE INDEX [IX_CuteChatRelation] ON [dbo].[CuteChatRelation](
    [IndexType],
    [Index1],
    [Index2]
    ) ON [ PRIMARY ]GO CREATE INDEX [IX_CuteChatRelation_RelationType] ON [dbo].[CuteChatRelation](
    [IndexType]
    ) ON [ PRIMARY ]GO CREATE INDEX [IX_CuteChatTempStateLog] ON [dbo].[CuteChatTempStateLog](
    [ManagerId]
    ) ON [ PRIMARY ]GO CREATE UNIQUE INDEX [IX_CuteChatUser] ON [dbo].[CuteChatUser](
    [UniqueName]
    ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[CuteSupportOperator] ADD CONSTRAINT [DF_CuteSupportOperator_IsReady]DEFAULT( 0 ) FOR [IsReady]GO
    MySQL said: 
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Roles]') a' at line 1
    [ Back ]   
     
     
     
    please help i like the look of this program ;)
     
    chris
View Complete Thread