Book a Demo

Author Topic: CREATE TABLE Task ( MySql InnoDB  (Read 3657 times)

aflik

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
CREATE TABLE Task ( MySql InnoDB
« on: December 19, 2003, 06:57:52 am »
My generate DDL looks like (simplified) -
CREATE TABLE Task (
     TaskID INTEGER NOT NULL,
     JobID INTEGER NOT NULL
) ;

In order for MySql to identify this as an InnoDB table the DDL needs to look like -
CREATE TABLE Task (
     TaskID INTEGER NOT NULL,
     JobID INTEGER NOT NULL
) Type = InnoDB ;

How do I get EA to generate the Type = InnoDB for me?
Thanks much.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: CREATE TABLE Task ( MySql InnoDB
« Reply #1 on: December 21, 2003, 01:33:23 pm »
Build 656 generates InnoDB MySQL tables by default.

upsidedown

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: CREATE TABLE Task ( MySql InnoDB
« Reply #2 on: January 08, 2004, 05:53:45 am »
How can I tell EA not to generate Type = InnoDB ?

Thanks