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

2003-04-04 Thread Ian Hartas
onfusion and better explain the reason why it failed. -- regards, Ian Hartas - "Pluralitas non est ponenda sine neccesitate" Occam's Razor. - -- MySQL General Mailing L

Fwd: Re: Schema definition fails when converted to InnoDB

2003-04-04 Thread Ian Hartas
t fails. ( This schema was originally 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 fa

Schema definition fails when converted to InnoDB

2003-04-03 Thread Ian Hartas
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 if exists ts_resource_mgrs; drop table if exists ts_entry; drop table if