From 85a3822bf3eab9a86918ff1e65a53056d34a3aaf Mon Sep 17 00:00:00 2001 From: Matthias Schmidt Date: Sat, 7 May 2016 13:14:59 +0200 Subject: [PATCH] Add missing NOT NULL for wcf1_user_profile_visitor columns --- wcfsetup/setup/db/install.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 4663990a54..3f1df99cfe 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -1560,8 +1560,8 @@ CREATE TABLE wcf1_user_profile_menu_item ( DROP TABLE IF EXISTS wcf1_user_profile_visitor; CREATE TABLE wcf1_user_profile_visitor ( visitorID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - ownerID INT(10), - userID INT(10), + ownerID INT(10) NOT NULL, + userID INT(10) NOT NULL, time INT(10) NOT NULL DEFAULT 0, UNIQUE KEY (ownerID, userID), KEY (time) -- 2.20.1