-- $Id: node_wireless.sql,v 1.2 2009/03/25 22:10:07 fenner Exp $

DROP TABLE node_wireless;

CREATE TABLE node_wireless (
    mac         macaddr,
    uptime      integer,
    maxrate     integer, -- can be 0.5 but we ignore that for now
    txrate      integer, -- can be 0.5 but we ignore that for now
    sigstrength integer, -- signal strength (-db)
    sigqual     integer, -- signal quality
    rxpkt       integer, -- received packets
    txpkt       integer, -- transmitted packets
    rxbyte      bigint,  -- received bytes
    txbyte      bigint,  -- transmitted bytes
    time_last   timestamp default now(),
    PRIMARY KEY(mac)
);

