summaryrefslogblamecommitdiff
path: root/db/schema.sql
blob: 78668c6ae80f8c2c078353d27ea91ad66876832c (plain) (tree)
1
2
3
4
5
6
7
8
9
10
11
                                  
                               

                               

                         
  



                                         



                                         
CREATE TABLE IF NOT EXISTS Usage (
  HardwareAddr BIGINT NOT NULL,
  StartTime TIMESTAMP NOT NULL,
  StopTime TIMESTAMP NOT NULL,
  Egress BIGINT NOT NULL,
  Ingress BIGINT NOT NULL
);

CREATE TABLE IF NOT EXISTS DnsBlackList (
  Name TEXT NOT NULL UNIQUE
);

CREATE TABLE IF NOT EXISTS MacBlackList (
  HardwareAddr BIGINT NOT NULL UNIQUE
);