main update is addition of type table for actions

else nothing spécial. just jotting down some sql queries to see if everything is working and correcting wherever required