From 60aa1b7adbd133a5b1679ab2feac4ec17e3b48b5 Mon Sep 17 00:00:00 2001
From: sinanmohd <sinan@sinanmohd.com>
Date: Sun, 7 Jul 2024 15:04:52 +0530
Subject: dns: block blacklisted domains in the database

---
 db/schema.sql | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'db/schema.sql')

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
+);
-- 
cgit v1.2.3

