Snipe-IT : Changing checkout consumeables directly from database.

There are 2 tables that need to be updated in order for the consumable item to be displayed correctly. Otherwise, your log is messed up.

Table1 : action_logs

Filter by user_id

Filter action_type = checkout <additional>

Changed column target_id

Changed column company_id <additional>

Table2 : consumables_users

Filter by user_id

Cross Check "Date & Time" from table action_logs

Changed column assigned_to

Now it depends on you to create an interface for it or custom your own SQL syntax.