diff options
Diffstat (limited to 'db/schema.sql')
-rw-r--r-- | db/schema.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index aece061..c8c35a1 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -1,7 +1,11 @@ -CREATE TABLE Usage ( +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 +); |