From d391a2cbf0cd59ceace2cabd042330e9e1dea4ee Mon Sep 17 00:00:00 2001 From: Syndamia Date: Sun, 19 Jan 2025 08:33:05 +0200 Subject: fix: Rename Webpage to Webpages and remove unique path constraint --- migrations/00-initial.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'migrations') diff --git a/migrations/00-initial.sql b/migrations/00-initial.sql index 8ac5ac0..f50d9d2 100644 --- a/migrations/00-initial.sql +++ b/migrations/00-initial.sql @@ -17,9 +17,9 @@ CREATE TABLE IF NOT EXISTS Cookies ( FOREIGN KEY (UID) REFERENCES Users(UID) ); -CREATE TABLE IF NOT EXISTS Webpage ( +CREATE TABLE IF NOT EXISTS Webpages ( WID INT NOT NULL AUTO_INCREMENT, - Path VARCHAR(512) NOT NULL UNIQUE, + Path VARCHAR(512) NOT NULL, URL VARCHAR(512) NOT NULL, Date DATETIME NOT NULL, Visits INT NOT NULL, -- cgit v1.2.3