Create Database Query:

CREATE DATABASE i4inari

Create Table Query:

CREATE TABLE machine2 
(
id INT(11) AUTO_INCREMENT PRIMARY KEY,
location INT(11),
type INT(11),
owner_id INT(11)
)

Table Display Query:

SELECT machine2.id AS id, machine2.name AS name, machine2.description AS description, location.location AS location, machine_type.name AS type, users.name AS owner_id, machine2.ip_address AS ip_address, machine2.ip_port AS ip_port, machine2.process_code AS process_code, machine2.enabled AS enabled FROM machine2 INNER JOIN machine_type ON machine_type.id = machine2.type INNER JOIN location ON location.id = machine2.location INNER JOIN users ON users.id = machine2.owner_id ORDER BY machine2.id DESC