#4 Generating SQL Dump with current CVS Snapshot

[Markus]

Hi,

I have loaded the omm example in the myobjects
webclient, and generated a sql dump of it.

While excecuting the generated dump (see enclosed) with
phpMyAdmin on MySQL 4.1.13 following a syntax error
occures.

Quote
SQL-Befehl:

CREATE TABLE movies(
`movieid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL ,
`description` text,
`year` year( 4 ) ,
`runtime` varchar( 50 ) ,
`originaltitle` varchar( 255 ) ,
`country` varchar( 45 ) ,
`imdbid` varchar( 15 ) ,
`imdbrating` float( ) ,
`imdbvotecount` int( 10 ) unsigned,
`tagline` varchar( 255 ) ,
`imdbimageurl` varchar( 255 ) ,
PRIMARY KEY ( `movieid` ) ,
UNIQUE KEY `movieid` ( `movieid` )
)

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version
for the right syntax to use near '),
`imdbvotecount` int(10) unsigned,
`tagline` varchar(255),
`imd' at line 10

Bye,
Markus