UPDATE `ima_admin_option` SET `Checksum`=MD5( CONCAT( '[HASH_SALT]','_', `Admin_ID`,'_', `Option_Key`,'_', `Option_Value`,'_', COALESCE(`EditedBy`,0)));
UPDATE `ima_admin_user` SET `Checksum`=MD5( CONCAT( '[HASH_SALT]','_', `Admin_ID`,'_',`User_ID`,'_', `Active`,'_', COALESCE(`EditedBy`,0)));

UPDATE `ima_chart` SET `Checksum`= MD5 ( CONCAT ('[HASH_SALT]','_',`Chart_ID`,'_',`Chart_Template_ID`,'_',`Chart_Date`,'_',`User_ID`,'_',`Plan_ID`,'_',`Session_ID`,'_',`Plan_Game_ID`,'_',`Active`));
UPDATE `ima_chart_calculus_status` SET `Checksum`= MD5 ( CONCAT ('[HASH_SALT]','_',`User_ID`,'_',`Last_Session_Checked`));
UPDATE `ima_chart_data` SET `Checksum`= MD5 ( CONCAT ('[HASH_SALT]','_',`Chart_ID`,'_',`Name`,'_',`Value`));
UPDATE `ima_chart_game_template` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_', `Chart_Template_ID`,'_', `Game_ID`));
UPDATE `ima_chart_template` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Chart_Template_ID`,'_',`Type_ID`,'_',`Name`,'_',`Title`,'_',COALESCE(`Resource_URL`,''),'_',COALESCE(`Description`,''),'_',`Session_Bound`,'_',`Optional`,'_',`Display_Order`,'_',`Active`));
UPDATE `ima_chart_template_data` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Chart_Template_ID`,'_',`Name`,'_',`Source`,'_',COALESCE(`Data_Order`,0),'_',`Active`));
UPDATE `ima_chart_template_data_language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Chart_Template_ID`,'_',`Language_ID`,'_',`Name`,'_',`Label`,'_',`Active`));
UPDATE `ima_chart_template_language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_', `Chart_Template_ID`,'_',`Language_ID`,'_',`Title`,'_', COALESCE(`Resource_URL`,''),'_',COALESCE(`Description`,''),'_',`Active`));
UPDATE `ima_chart_template_option` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Chart_Template_ID`,'_',`Name`,'_',`Value`,'_',`Active`));
UPDATE `ima_chart_template_option_language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Chart_Template_ID`,'_',`Language_ID`,'_',`Name`,'_',COALESCE(`Value`,''),'_',`Active`));
UPDATE `ima_chart_type` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Type_ID`,'_',`Name`,'_',COALESCE(`Resource_URL`,''),'_',COALESCE(`Description`,''),'_',`Interpreter`,'_',`Active`));
UPDATE `ima_chart_type_language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Type_ID`,'_',`Language_ID`,'_',`Name`,'_',COALESCE(`Resource_URL`,''),'_',COALESCE(`Description`,''),'_',`Active`));

UPDATE `ima_device` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Device_ID`,'_',`Name`,'_',`Icon_URL`,'_',`Active`,'_', COALESCE(`EditedBy`,0)));

UPDATE `ima_game` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Game_ID`,'_',`Name`,'_',COALESCE(`Resource_URL`,''),'_',COALESCE(`Executable`,''),'_',COALESCE(`Description`,''),'_',`Version`,'_',`Active`,'_',COALESCE(`EditedBy`,0)));
UPDATE `ima_game_dependency` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Game_ID`,'_',`Resource_ID`,'_',`Order`,'_',`Active`));
UPDATE `ima_game_device` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Game_ID`,'_',`Device_ID`,'_',`Active`));
UPDATE `ima_game_language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Game_ID`,'_',`Language_ID`,'_',`Name`,'_',COALESCE(`Resource_URL`,''),'_',COALESCE(`Executable`,''),'_',COALESCE(`Description`,''),'_',`Active`));
UPDATE `ima_game_level` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Level_ID`,'_',`Game_ID`,'_',`Name`,'_',`Parameters`,'_',`Active`,'_',COALESCE(`EditedBy`,0)));
UPDATE `ima_game_output` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`Game_ID`,'_',`Name`,'_',`Parameter`,'_',COALESCE(`Description`,''),'_',`Active`));
UPDATE `ima_game_parameter` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Parameter_ID`,'_',COALESCE(`Device_ID`,0),'_',`Name`,'_',`Label`,'_',COALESCE(`Description`,''),'_',`Default`,'_',`Order`,'_',`Levelable`,'_',`Active`));
UPDATE `ima_game_parameter_association` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Game_ID`,'_',`Parameter_ID`,'_',`Optional_Parameter`,'_',`Active`));
UPDATE `ima_game_parameter_language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Parameter_ID`,'_',`Language_ID`,'_',`Label`,'_',COALESCE(`Description`,''),'_',`Active`));
UPDATE `ima_game_parameter_value` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Parameter_ID`,'_',`Value`,'_',`Label`,'_',COALESCE(`Description`,''),'_',`Default`,'_',`Order`,'_',`Active`));
UPDATE `ima_game_parameter_value_language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Parameter_ID`,'_',`Value`,'_',`Language_ID`,'_',`Label`,'_',COALESCE(`Description`,''),'_',`Active`));
UPDATE `ima_game_resource` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Resource_ID`,'_',`Name`,'_',`Resource_URL`,'_',`Type`,'_',`Version`,'_',`Active`));

UPDATE `ima_language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Language_ID`,'_',`Eng_Name`,'_',`Lang_Name`,'_',`Resource_URL`,'_',`Active`));

UPDATE `ima_log` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Log_ID`,'_',`User_ID`,'_',`Event_Type`,'_',COALESCE(`Event_Value`,''),'_',`Event_Time`,'_',`Remote_Address`,'_',`Compressed`));

UPDATE `ima_plan` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Plan_ID`,'_',`Plan_Name`,'_',`Owner`,'_',`Device_ID`,'_',`Plan_Period`,'_',`Period_Start_Reference`,'_',`Active`,'_',`Generic`,'_',COALESCE(`EditedBy`,0)));
UPDATE `ima_plan_game` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Plan_Game_ID`,'_',`Plan_ID`,'_',`Game_ID`,'_',`Parameters`,'_',`Plan_Order`,'_',`Level`,'_',`Sequence`,'_',`Active`,'_',COALESCE(`EditedBy`,0)));
UPDATE `ima_plan_option` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Plan_ID`,'_',`Option_Key`,'_',`Option_Value`,'_',`Active`,'_',COALESCE(`EditedBy`,0)));
UPDATE `ima_plan_scheduler` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Scheduler_ID`,'_',`Plan_ID`,'_',`User_ID`,'_',`Start_Date`,'_',`End_Date`,'_',`Start_Time`,'_',`End_Time`,'_',`Active`,'_',COALESCE(`EditedBy`,0)));
UPDATE `ima_plan_session` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Session_ID`,'_',`Plan_ID`,'_',`User_ID`,'_',`Session_Start`,'_',`Session_End`,'_',`Expired`,'_',COALESCE(`Results`,'')));
UPDATE `ima_plan_session_control` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Session_ID`,'_',`Client_ID`,'_',`Creation_Date`,'_',`Overbook`,'_',`Paid`));
UPDATE `ima_plan_session_game_status` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Session_ID`,'_',`Plan_Game_ID`,'_',`Status`,'_',`Game_Start`,'_',`Game_End`,'_',`Score`,'_',COALESCE(`Results`,'')));
UPDATE `ima_plan_session_game_status_tracking` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Session_ID`,'_',`Plan_Game_ID`,'_',`Tracking`));

--UPDATE `IMA_Progression_Map` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`Prog_Order`,'_',`IdAchievement`,'_',`Category`,'_',`Name`,'_',COALESCE(`Description`,''),'_',`Active`));
--UPDATE `IMA_Progression_Map_Element` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Progression_Map_ID`,'_',`Key`,'_',`Value`,'_',`Active`));
--UPDATE `IMA_Progression_Map_Element_Language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Progression_Map_ID`,'_',`Key`,'_',`Language_ID`,'_',`Value`,'_',`Active`));
--UPDATE `IMA_Progression_Map_Language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Progression_Map_ID`,'_',`Language_ID`,'_',`Category`,'_',`Name`,'_',COALESCE(`Description`,''),'_',`Active`));
--UPDATE `IMA_Progression_Map_Milestone` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Milestone_ID`,'_',`Progression_Map_ID`,'_',`Title`,'_',COALESCE(`Description`,''),'_',`Position`,'_',COALESCE(`Image_URL_1`,''),'_',COALESCE(`Image_URL_2`,''),'_',COALESCE(`Image_URL_3`,''),'_',`Active`));
--UPDATE `IMA_Progression_Map_Milestone_Language` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Milestone_ID`,'_',`Language_ID`,'_',`Title`,'_',COALESCE(`Description`,''),'_',COALESCE(`Image_URL_1`,''),'_',COALESCE(`Image_URL_2`,''),'_',COALESCE(`Image_URL_3`,''),'_',`Active`));
UPDATE `ima_progression_rule` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`Sequence_Level_Id`,'_',`Parameter`,'_',`Operator`,'_',`Result`,'_',`Rule_Type`,'_',`Weight`,'_',`Active`,'_',COALESCE(`EditedBy`,0)));
UPDATE `ima_progression_sequence` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`Game_ID`,'_',`Device_ID`,'_',`Name`,'_',`Mode`,'_',`Active`,'_',COALESCE(`EditedBy`,0)));
UPDATE `ima_progression_sequence_level` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`Level_ID`,'_',`Sequence_ID`,'_',`Sequence_Order`,'_',`IdAchievement`,'_',`Global_Progression_Parameter`,'_',`Global_Progression_Multiplier`,'_',`Active`,'_',COALESCE(`EditedBy`,0)));

UPDATE `rehab_calibration` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Calibration_ID`,'_',`User_ID`,'_',`Calibration_Value`,'_',`Hand`,'_',`Device_ID`));
UPDATE `rehab_licensekey` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`LicenseKey`,'_',COALESCE(`Start_Date`,''),'_',COALESCE(`End_Date`,''),'_',COALESCE(`Activation_Date`,''),'_',`Used`,'_',`Active`,'_',COALESCE(`EditedBy`,0)));
UPDATE `rehab_macaddress` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Mac`,'_',COALESCE(`Username`,''),'_',`Active`,'_',COALESCE(`License`,''),'_',COALESCE(`Model`,''),'_',COALESCE(`Type`,''),'_',COALESCE(`Name`,''),'_',COALESCE(`Version`,''),'_',COALESCE(`Tag`,''),'_',COALESCE(`EditedBy`,0)));
UPDATE `rehab_option` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Key`,'_',`Value`,'_',`Type`,'_',`Active`,'_',COALESCE(`Description`,''),'_',COALESCE(`EditedBy`,0),'_',`Order`,'_',COALESCE(`Group`,'')));

UPDATE `cb_account` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`Username`,'_',`Password`,'_',`Enabled`));
UPDATE `cb_customdata` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`IdAccount`,'_',`DataKey`,'_',`DataValue`));
UPDATE `cb_adminaccount` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`Username`,'_',`Password`));

UPDATE `cb_achievement` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`Title`,'_',`Description`,'_',`UniqueRecords`,'_',`Position`));
UPDATE `cb_achievement_user` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`IdAchievement`,'_',`IdAccount`,'_',`Progress`));
UPDATE `cb_leaderboard` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`Title`,'_',`Description`,'_',`UniqueRecords`,'_',`ValueType`,'_',`OrderType`,'_',`AllowAnonymous`));
UPDATE `cb_leaderboard_user` SET `Checksum`= MD5( CONCAT( '[HASH_SALT]','_',`Id`,'_',`IdLeaderboard`,'_',`IdAccount`,'_',`ValueInt`,'_',`ValueFloat`,'_',`LastUpdated`,'_',`Username`));