SQL file included with software does not create tables

  •  04-04-2010, 6:20 PM

    SQL file included with software does not create tables

    I tried to import to mysql on two totally different servers changing compatibility modes. both unable to create tables using the cutesoftchat.sql  file.
    MySQL ERROR GENERATED:
    #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 'i' at line 1

    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CuteChat4_SupportAgent_CuteChat4_SupportDepartment]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

    ALTER TABLE [dbo].[CuteChat4_SupportAgent] DROP CONSTRAINT FK_CuteChat4_SupportAgent_CuteChat4_SupportDepartment

    GO



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

    drop table [dbo].[CuteChat4_InstantMessage]

    GO



    if exists (se[...]
View Complete Thread