CREATE TABLE oids ( oid_id INT PRIMARY KEY, device_id INT NOT NULL, oid TEXT NOT NULL, type ENUM ('get', 'walk', 'table') NOT NULL, mib TEXT, format TEXT, parent INT );