aboutsummaryrefslogtreecommitdiff
path: root/migrations
diff options
context:
space:
mode:
authorGeorgi Nikolov <ggeorgi60@gmail.com>2025-01-25 17:01:26 +0200
committerGeorgi Nikolov <ggeorgi60@gmail.com>2025-01-25 17:01:26 +0200
commite143770fc296e34862d95272fc79a56fa9d20a34 (patch)
tree2bcbf53e686619bddec5da28d5775656b26b5ea0 /migrations
parentdb285a4be28e6da35be65424b2f324dd04e9becf (diff)
downloadnowayforward_human-e143770fc296e34862d95272fc79a56fa9d20a34.tar
nowayforward_human-e143770fc296e34862d95272fc79a56fa9d20a34.tar.gz
nowayforward_human-e143770fc296e34862d95272fc79a56fa9d20a34.zip
Added additional table column for the favicon in the database
With that commit handled the saving of that favicon as well
Diffstat (limited to 'migrations')
-rw-r--r--migrations/00-initial.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/migrations/00-initial.sql b/migrations/00-initial.sql
index f50d9d2..0edf29b 100644
--- a/migrations/00-initial.sql
+++ b/migrations/00-initial.sql
@@ -24,6 +24,7 @@ CREATE TABLE IF NOT EXISTS Webpages (
Date DATETIME NOT NULL,
Visits INT NOT NULL,
RequesterUID INT NOT NULL,
+ FaviconPath VARCHAR(512) NOT NULL,
PRIMARY KEY (WID),
FOREIGN KEY (RequesterUID) REFERENCES Users(UID)
);