[Opensource] Customize table creation

[Eddie Lewis]

Simply use

drop table if exists [table_name];

/*==============================================================*/
/* Table: table_name                               */
/*==============================================================*/
create table if not exists [table_name]
(
   id                         int                            not null,
   other_notes                    text,
   primary key (id)
)
type = INNODB;

you can convert existing tables via

alter table [table_name] type=innodb;


-----Original Message-----
From: Roberto Orenstein [mailto:orenstein at brturbo.com]
Sent: Friday, 21 February 2003 12:54 PM
To: opensource at jcorporate.com
Subject: [Opensource] Customize table creation


Hi guys!

I'm new to this list and don't even know if this is the right place to
ask, but here it goes.

Is there a way to tell expresso to use, in mysql , the InnoDB table type
during table creation. The create table statement generated uses the
MyIsam type, wich lacks some features.

tia
Roberto




_______________________________________________
Opensource mailing list
Opensource at jcorporate.com
http://mail.jcorporate.com/mailman/listinfo/opensource
Archives: http://mail.jcorporate.com/pipermail/opensource/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.jcorporate.com/pipermail/opensource/attachments/20030221/c2295909/attachment-0002.htm