diff options
| author | Syndamia <kamen@syndamia.com> | 2025-01-19 08:33:05 +0200 |
|---|---|---|
| committer | Syndamia <kamen@syndamia.com> | 2025-01-19 08:33:05 +0200 |
| commit | d391a2cbf0cd59ceace2cabd042330e9e1dea4ee (patch) | |
| tree | 3abc3cd045f6d3bc49cac0cd54d4107744d03a65 /migrations/00-initial.sql | |
| parent | 98074f4ba13d5937b51dd1da98a4abb08beece5e (diff) | |
| download | nowayforward_human-d391a2cbf0cd59ceace2cabd042330e9e1dea4ee.tar nowayforward_human-d391a2cbf0cd59ceace2cabd042330e9e1dea4ee.tar.gz nowayforward_human-d391a2cbf0cd59ceace2cabd042330e9e1dea4ee.zip | |
fix: Rename Webpage to Webpages and remove unique path constraint
Diffstat (limited to 'migrations/00-initial.sql')
| -rw-r--r-- | migrations/00-initial.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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, |