Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#57 Add support for MySQL ENGINE specification

closed-rejected
nobody
None
5
2007-04-20
2006-03-15
Anonymous
No

MySQL supports several different database engine types,
each having its own advantage and drawbacks, with two
of the most prevalent being InnoDB (support for
transactions and indices) and MyISAM. The engine type
can be explicitly specified at the end of a CREATE
TABLE. E.g.,
CREATE TABLE test (
id INT PRIMARY KEY AUTO_INCREMENT,
value INT
) ENGINE=InnoDB;

The patch adds an engine keyword into the SQLObject
that can be used to append the ENGINE specification to
every table creation. Usage:
SQLObject.engine = "InnoDB"

Discussion

  • Support for MySQL ENGINEs

     
    Attachments
  • Oleg Broytman
    Oleg Broytman
    2006-03-21

    Logged In: YES
    user_id=4799

    Please add documentation and tests.

     
  • Oleg Broytman
    Oleg Broytman
    2006-03-21

    • status: open --> open-invalid
     
  • Oleg Broytman
    Oleg Broytman
    2007-03-02

    • status: open-invalid --> closed-accepted
     
  • Oleg Broytman
    Oleg Broytman
    2007-03-02

    Logged In: YES
    user_id=4799
    Originator: NO

    Applied in the revision 2369.

     
  • Oleg Broytman
    Oleg Broytman
    2007-04-20

    Logged In: YES
    user_id=4799
    Originator: NO

    Reverted and unapplied in the revisions 2575-2577 (0.9, trunk, docs) - it's too special and could be implemented using createSQL.

     
  • Oleg Broytman
    Oleg Broytman
    2007-04-20

    • status: closed-accepted --> closed-rejected