Fejl ved oprettelse af tabeller
Jeg har fundet et gratis system, men min MYsql melder fejl når jeg vil rette tabellerne.Jeg har ikke set sådanne en opsætning af databasen, men jeg har heller ikke meget forstand på det.
Jeg bruger MySql 4.1.9
og filen ser sådanne ud: (lægger kun en lille del op, så i ikke bliver bange :-)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cats]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[cats]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[elists]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[elists]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[etemplates]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[etemplates]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[links]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[links]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[maillist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[maillist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qusers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[qusers]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[reviews]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[reviews]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[system]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[system]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[votes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[votes]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ips]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ips]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[domains]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[domains]
GO
håber der er en der kan give en løsning på problemet.
