From c1c9f06c50f4eeed3cdc418ac718769adc46e85b Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Sun, 29 Sep 2013 02:05:39 +0200 Subject: [PATCH] Added missing foreign key --- com.woltlab.wcf/update_b10.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/com.woltlab.wcf/update_b10.sql b/com.woltlab.wcf/update_b10.sql index 246d406efb..5a84f0863a 100644 --- a/com.woltlab.wcf/update_b10.sql +++ b/com.woltlab.wcf/update_b10.sql @@ -10,4 +10,6 @@ CREATE TABLE wcf1_cli_history ( userID INT(10) NOT NULL, command VARCHAR(255) NOT NULL, KEY (userID) -); \ No newline at end of file +); + +ALTER TABLE wcf1_cli_history ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; -- 2.20.1