DdlUtils
  1. DdlUtils
  2. DDLUTILS-32

I want to be able to specify the table type/engine when i create tables in mysql.

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0 RC1
    • Component/s: Core - MySql
    • Labels:
      None

      Description

      In MySQL, a table type or engine can be specified after the "create table" statement, like so:
      CREATE TABLE table
      (
      column INTEGER
      ) ENGINE=InnoDB

      "TYPE" is a synonym for "ENGINE".

      http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available beginning with MySQL 3.23.0, the first version of MySQL for which multiple storage engines were available."

      1. DDLUTILS-32.patch
        19 kB
        Christoffer Hammarström

        Activity

        Christoffer Hammarström created issue -
        Christoffer Hammarström made changes -
        Field Original Value New Value
        Attachment DDLUTILS-32.patch [ 12314860 ]
        Thomas Dudziak made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Thomas Dudziak made changes -
        Component/s Core - MySql [ 12311216 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.0 RC1 [ 12312482 ]

          People

          • Assignee:
            Thomas Dudziak
            Reporter:
            Christoffer Hammarström
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development