why doesn't this sql script work in mysql?

pwd

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

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

pwd

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

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!