From 64e3e6c09e258d28eb3c46a3a9932b37a8ef6ca1 Mon Sep 17 00:00:00 2001 From: joshuaruesweg Date: Thu, 4 Mar 2021 19:45:17 +0100 Subject: [PATCH] Clean up SQL --- wcfsetup/setup/db/install.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 70793edf1c..5902ce9c92 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -1450,13 +1450,13 @@ DROP TABLE IF EXISTS wcf1_unfurl_url; CREATE TABLE wcf1_unfurl_url ( urlID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, url TEXT NOT NULL, - urlHash VARCHAR(40) NOT NULL UNIQUE KEY, + urlHash VARCHAR(40) NOT NULL UNIQUE KEY (urlHash), title VARCHAR(255) NOT NULL DEFAULT '', - description TEXT, - imageUrl TEXT, - imageType ENUM('SQUARED', 'COVER', 'NOIMAGE') NOT NULL DEFAULT 'NOIMAGE', - imageHash VARCHAR(40) NOT NULL DEFAULT '', - status ENUM('PENDING', 'SUCCESSFUL', 'REJECTED') DEFAULT 'PENDING' + description TEXT, + imageUrl TEXT NOT NULL DEFAULT '', + imageType VARCHAR(255) NOT NULL DEFAULT 'NOIMAGE', + imageHash VARCHAR(45) NOT NULL DEFAULT '', + status VARCHAR(255) NOT NULL DEFAULT 'PENDING' ); DROP TABLE IF EXISTS wcf1_user; -- 2.20.1