ALTER TABLE similar_hash
  ADD COLUMN IF NOT EXISTS type smallint NOT NULL DEFAULT 0;
CREATE OR REPLACE FUNCTION public.insert_similar_hash_missing_units_func( user_id integer )
  RETURNS void
  LANGUAGE plpgsql
AS $$
BEGIN
  INSERT INTO similar_hash (id_unit, id_user, takentime, is_major, id_item, type)
  SELECT unit.id, unit.id_user, unit.takentime, unit.is_major, unit.id_item, unit.type
  FROM unit LEFT JOIN similar_hash
  ON unit.id = similar_hash.id_unit
  WHERE similar_hash.id_unit IS NULL and unit.id_user = user_id;
END;
$$;