summaryrefslogtreecommitdiff
path: root/db/schema.sql
blob: c8c35a173c636535e99e68ab98e0f50b98de54e4 (plain) (blame)
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
);