wso2 - mysql throws Unknown column 'mac' in 'field list' -

wso2 - mysql throws Unknown column 'mac' in 'field list' -

org.mozilla.javascript.wrappedexception: wrapped org.jaggeryjs.scriptengine.exceptions.scriptexception: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: unknown column 'mac' in 'field list' ([driver]/driver.js#32)

i encounter error in wso2 emm 1.1.0 after upgrading 1.0.0

did face issue while migrating mysql db wso2emm_db?

there issue mysql.sql script devices table , has been reported in public jira . in <product_home>/dbscripts/emm/mysql.sql, alter field wifi_mac devices table mac shown below:

create table if not exists `devices` ( `id` int(11) not null auto_increment, `tenant_id` int(11) default null, `user_id` varchar(255) default null, `platform_id` int(11) default null, `reg_id` longtext, `os_version` varchar(45) default null, `properties` text, `created_date` datetime default null, `status` varchar(10) default null, `byod` smallint(6) default '1', `deleted` int(11) default '0', `vendor` varchar(11) default null, `udid` varchar(4096) null default null, `push_token` varchar(256) null default null, **`mac`** varchar(100) null default null, primary key (`id`) ) engine=innodb auto_increment=1 default charset=latin1;

mysql wso2 wso2carbon