[Vtigercrm-developers] 4.2.4 installer creates tables as MyISAM

[Jeff Kowalczyk]

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;