Re: How to set my table's Storage Engine using CakeSchema?

I figured out. Just in case someone else wants to know this:

'tableParameters' => array('engine' => 'MEMORY')

On Thursday, August 23, 2012 10:14:50 AM UTC-7, andrewperk wrote:

Hello,

I'd like to be able to ensure that the table CakeSchema create's is a memory heap. How can I set the storage engine for a table created using CakeSchema? 

I tried something like this:

public $sucker_log = array(

'id'=>array('type'=>'integer', 'null'=>false, 'default'=>null, 'key'=>'primary', 'length'=>11),

'ip'=>array('type'=>'string', 'null'=>true, 'default'=>null),

'storage'=>array('engine'=>'memory'),

'indexes'=>array('PRIMARY'=>array('column'=>'id', 'unique'=>1))

);

But my table is still InnoDB. I just guessed at what it could be, I didn't see anything in the documentation. 

Note: not all tables in the DB are memory heaps. The other tables are InnoDB.

Thanks,

Andrew

--
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.