[Vtigercrm-developers] 4.2.4 installer creates tables as MyISAM

[Mike Fedyk]

I have added this post in the adodb forum (they don't seem to use the 
mailing list much).

http://phplens.com/lens/lensforum/msgs.php?id=14708

Jeff Kowalczyk wrote:

>Mike Fedyk wrote:
>  
>
>>Run this sql on one of your tables:
>>
>>SHOW TABLE STATUS LIKE 'leaddetails'
>>
>>If you see type: myisam instead of type: innodb, you have just confirmed
>>the problem.  I asked Matt to try also with the same result.
>>
>>Mike
>>    
>>
>
>Confirming:
>
>Output from SQL command SHOW TABLE STATUS LIKE 'leaddetails' ..
>
>Name ,Engine ,Version ,Row_format ,Rows ,Avg_row_length ,Data_length
>,Max_data_length ,Index_length ,Data_free ,Auto_increment ,Create_time
>,Update_time ,Check_time ,Collation ,Checksum ,Create_options ,Comment
>
>leaddetails ,MyISAM ,10 ,Dynamic ,10 ,134 ,1340 ,281474976710655 ,3072 ,0
>, ,2006-02-20 22:37:58 ,2006-02-20 22:38:12 ,2006-02-20 22:37:58
>,utf8_general_ci , , ,
>
>
>
>  --
>  -- Table structure for table `leaddetails`
>  --
>
>  DROP TABLE IF EXISTS `leaddetails`;
>  CREATE TABLE `leaddetails` (
>  `leadid` int(19) NOT NULL,
>  `email` varchar(100) default NULL,
>  `interest` varchar(50) default NULL,
>  `firstname` varchar(40) default NULL,
>  `salutation` varchar(10) default NULL,
>  `lastname` varchar(80) NOT NULL,
>  `company` varchar(100) NOT NULL,
>  `annualrevenue` int(19) default '0',
>  `industry` varchar(50) default NULL,
>  `campaign` varchar(30) default NULL,
>  `rating` varchar(50) default NULL,
>  `leadstatus` varchar(50) default NULL,
>  `leadsource` varchar(50) default NULL,
>  `converted` int(1) default '0',
>  `designation` varchar(50) default 'SalesMan',
>  `licencekeystatus` varchar(50) default NULL,
>  `space` varchar(250) default NULL,
>  `comments` text,
>  `priority` varchar(50) default NULL,
>  `demorequest` varchar(50) default NULL,
>  `partnercontact` varchar(50) default NULL,
>  `productversion` varchar(20) default NULL,
>  `product` varchar(50) default NULL,
>  `maildate` date default NULL,
>  `nextstepdate` date default NULL,
>  `fundingsituation` varchar(50) default NULL,
>  `purpose` varchar(50) default NULL,
>  `evaluationstatus` varchar(50) default NULL,
>  `transferdate` date default NULL,
>  `revenuetype` varchar(50) default NULL,
>  `noofemployees` varchar(50) default NULL,
>  `yahooid` varchar(100) default NULL,
>  `assignleadchk` int(1) default '0',
>  PRIMARY KEY  (`leadid`),
>  KEY `converted` (`converted`,`leadstatus`)
>  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
>
>
>
>_______________________________________________
>This vtiger.com email is sponsored by: Zoho Writer. Are you still using your desktop word processor for typing documents? Try the AJAX enabled, collaboration-friendly online word processor, Zoho Writer for FREE instead!
>http://zohowriter.com/?vt 
>
>  
>