534a9d9378
* new oui importer using IEEE csv for MA-L+M+S * schema update for new vendor table * change vendor to manufacturer because Device has a vendor field * remove oui from manuf table, and update node oui after manuf update * faster way to bulk update node oui * switch from using oui table to manufacturer table for vendor lookup * some other oui cleanup * faster/scalable way to join a macaddr to manuf table * remove device.oui support * update node oui in bulk at end of macsuck run * correct literal sql instead of bind * more efficient to get oui base for each mac * comment better the base lookup in macsuck
22 lines
500 B
PL/PgSQL
22 lines
500 B
PL/PgSQL
BEGIN;
|
|
|
|
UPDATE node SET oui = NULL;
|
|
|
|
ALTER TABLE node ALTER COLUMN oui TYPE varchar(9);
|
|
|
|
CREATE TABLE manufacturer (
|
|
"company" text NOT NULL,
|
|
"abbrev" text NOT NULL,
|
|
"base" text NOT NULL,
|
|
"bits" integer NOT NULL,
|
|
"first" macaddr NOT NULL,
|
|
"last" macaddr NOT NULL,
|
|
"range" int8range NOT NULL,
|
|
PRIMARY KEY ("base"),
|
|
EXCLUDE USING GIST (range WITH &&)
|
|
);
|
|
|
|
CREATE INDEX idx_manufacturer_first_last ON manufacturer ("first", "last" DESC);
|
|
|
|
COMMIT;
|