- 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
- );
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 );