Feature Update VTS

File : manage_edit_account.php Increment counter in Line:25

INSERT INTO iespl_vts_beta.feature_mapping (
feature_id ,
field_name ,
feature_name ,
feature_type ,
create_id ,
create_date ,
edit_id ,
edit_date ,
status ,
remark
)
VALUES (
NULL , 'field42', 'door_open3', 'hw', '', '2015-01-07 18:40:00', NULL , NULL , '1', NULL
);

UPDATE iespl_vts_beta.usertype_mapping SET feature_id = '1,2,3,4,5,9,10,12,13,14,15,16,17,18,19,22,23,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42' WHERE usertype_mapping.sno =1;

ALTER TABLE account_feature ADD field39 INT( 11 ) NULL DEFAULT '0' AFTER field38;
ALTER TABLE account_feature ADD field40 INT( 11 ) NULL DEFAULT '0' AFTER field39;
ALTER TABLE account_feature ADD field41 INT( 11 ) NULL DEFAULT '0' AFTER field40;
ALTER TABLE account_feature ADD field42 INT( 11 ) NULL DEFAULT '0' AFTER field41;

UPDATE account_feature SET field39 =1 WHERE account_id =1;
UPDATE account_feature SET field40 =1 WHERE account_id =1;
UPDATE account_feature SET field41 =1 WHERE account_id =1;
UPDATE account_feature SET field42 =1 WHERE account_id =1;