why doesn't this sql script work in mysql?

pwd · 13-12-2004 11:05PM #1

This is a script to be run while setting up openwiki:

CREATE TABLE [openwiki_attachments] (
[att_wrv_name] [nvarchar] (128) NOT NULL ,
[att_wrv_revision] [int] NOT NULL ,
[att_name] [nvarchar] (255) NOT NULL ,
[att_revision] [int] NOT NULL ,
[att_hidden] [int] NOT NULL ,
[att_deprecated] [int] NOT NULL ,
[att_filename] [nvarchar] (255) NOT NULL ,
[att_timestamp] [datetime] NOT NULL ,
[att_filesize] [int] NOT NULL ,
[att_host] [nvarchar] (128) NULL ,
[att_agent] [nvarchar] (255) NULL ,
[att_by] [nvarchar] (128) NULL ,
[att_byalias] [nvarchar] (128) NULL ,
[att_comment] [text] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

It generates syntax errors when I run it on mysql. I've run it with and without a semicolon on the end.

anyone know why?

leeroybrown · 13-12-2004 11:12PM

It looks more like an SQL Server script. Check if there is a specific MySQL create script with openwiki.

pwd · 13-12-2004 11:27PM

That's it alright!
They don't have a mysql script, but they do give directions on how to convert the access one into mysql.

Thanks!

pwd · 13-12-2004 11:37PM

CREATE TABLE openwiki_attachments (
att_wrv_name VARCHAR(128) NOT NULL,
att_wrv_revision INT NOT NULL,
att_name VARCHAR(255) NOT NULL,
att_revision INT NOT NULL,
att_hidden INT NOT NULL,
att_deprecated INT NOT NULL,
att_filename VARCHAR(255) NOT NULL,
att_timestamp DATETIME NOT NULL,
att_filesize INT NOT NULL,
att_host VARCHAR(128),
att_agent VARCHAR(255),
att_by VARCHAR(128),
att_byalias VARCHAR(128),
att_comment TEXT
)
;

that's the myqsl version. they actually have that in the download, even though they don't mention it in the online docs. accessdump.com converts the mdb perfectly anyway!

why doesn't this sql script work in mysql?

Comments