Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

why doesn't this sql script work in mysql?

  • 14-12-2004 12:05AM
    #1
    pwd
    Closed Accounts Posts: 5,284 ✭✭✭


    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?


Comments

  • #2
    leeroybrown
    Closed Accounts Posts: 7,562 ✭✭✭leeroybrown


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


  • #3
    pwd
    Closed Accounts Posts: 5,284 ✭✭✭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!


  • #4
    pwd
    Closed Accounts Posts: 5,284 ✭✭✭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!


Advertisement