diff options
author | sinanmohd <sinan@sinanmohd.com> | 2024-07-07 15:04:52 +0530 |
---|---|---|
committer | sinanmohd <sinan@sinanmohd.com> | 2024-07-07 15:07:34 +0530 |
commit | 60aa1b7adbd133a5b1679ab2feac4ec17e3b48b5 (patch) | |
tree | 082f64ac3ef625fb364227c138a99ba5c571016b /db/schema.sql | |
parent | 38bf443cb2f52bd4cc822e69f9339094d846396f (diff) |
dns: block blacklisted domains in the database
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 +); |