Website Summary Files Commits Branches @commit @diff @stats
path: root / migrations / 00-initial.sql
diff options
context:
space:
mode:
Commitd391a2cbf0cd59ceace2cabd042330e9e1dea4ee (patch)
Author
 Syndamia <kamen@syndamia.com>
2025-01-19 08:33:05 +0200
Committer
 Syndamia <kamen@syndamia.com>
2025-01-19 08:33:05 +0200
Files3abc3cd045f6d3bc49cac0cd54d4107744d03a65 /migrations/00-initial.sql
nowayforward_human-d391a2cbf0cd59ceace2cabd042330e9e1dea4ee.tar
nowayforward_human-d391a2cbf0cd59ceace2cabd042330e9e1dea4ee.tar.gz
nowayforward_human-d391a2cbf0cd59ceace2cabd042330e9e1dea4ee.zip
Parent98074f4ba13d5937b51dd1da98a4abb08beece5e (diff)
fix: Rename Webpage to Webpages and remove unique path constraint
1 files changed, 2 insertions, 2 deletions
-rw-r--r--migrations/00-initial.sql4
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,