Untitled

CREATE TRIGGER reminder BEFORE UPDATE ON glpi_computers
 FOR EACH ROW BEGIN
  DECLARE previous_user_name VARCHAR(255);
  DECLARE current_user_name VARCHAR(255);
  DECLARE serial_number VARCHAR(255);
  DECLARE inventory_number VARCHAR(255);
  DECLARE current_host_name VARCHAR(255);
  DECLARE previous_user_id VARCHAR(255);
  DECLARE current_user_id VARCHAR(255);

  SET previous_user_id = OLD.users_id;
  SET current_user_id = NEW.users_id;
  SET previous_user_name = (SELECT name FROM glpi_users WHERE id = OLD.users_id);
  SET current_user_name = (SELECT name FROM glpi_users WHERE id = NEW.users_id);
  SET serial_number = OLD.serial;
  SET inventory_number = OLD.otherserial;
  SET current_host_name = OLD.name;


  IF (previous_user_id != current_user_id OR current_user_id = '0') THEN
   INSERT INTO glpi.logs VALUES(NULL,previous_user_name,current_user_name,serial_number,inventory_number,current_host_name,NOW());
  END IF;
END

|