Fwd: Re: Schema definition fails when converted to InnoDB

2003-04-04 Thread Ian Hartas
on Oracle, where the syntax was valid and acted on.) Ian Hartas wrote: Description: I have a database schema .sql file which is accepted when run with MyISAM tables. If I change the tables to be type = InnoDB, then it fails with the error message: mysql -u ts -p hbs

Re: AW: Re: Schema definition fails when converted to InnoDB

2003-04-04 Thread Ian Hartas
and better explain the reason why it failed. -- regards, Ian Hartas - Pluralitas non est ponenda sine neccesitate Occam's Razor. - -- MySQL General Mailing List For list archives: http

Schema definition fails when converted to InnoDB

2003-04-03 Thread Ian Hartas
: 150) How-To-Repeat: Save this text as schema_mysql.sql and run it as noted in the description line. database called 'hbs', user called 'ts' /* ** MySQL schema for the Holiay Booking System within FJS. ** ** by Ian Hartas, Kid01. ** */ drop table if exists ts_proj_team; drop table