#100 SourceForge.sql uses mSQL syntax

[Anonymous]

Using SourceForge 2.5 downloaded from this site.

Trying to create tables in MySQL, after successfully
creating database sourceforge and setting up user
sf_admin.

When executing the command

%mysql sourceforge < db/SourceForge.sql -u sf_admin -p

Getting the following error

ERROR 1064 at line 4: You have an error in your SQL
syntax near 'onnect - sf_admin CREATE
SEQUENCE "bug_pk_seq" start 1 increment 1 maxvalue
2147' at line 1

It looks like the SourceForge.sql is written using
mSQL syntax?

[Nobody/Anonymous]

Logged In: NO

Are you sure that's not PostgreSQL syntax? SEQUENCEs are
something original to PostgreSQL as far as I know, if you
wanted to rewrite the SQL you should know that a SEQUENCE is
a table that holds the value of the SERIAL value... similar
to MySQL's AUTOINCREMENT flag. So if you needed MySQL
support, just change the field type from SERIAL to INTEGER
AUTO INCREMENT or whatever their syntax is.