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 [email protected].
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
