[aur-dev] [PATCH 1/2] Create missing foreign key for comments

[Marcel Korpel]

Signed-off-by: Marcel Korpel <marcel.korpel at gmail.com>
---
 schema/aur-schema.sql | 1 +
 1 file changed, 1 insertion(+)

diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 3aef7a3..444cb5e 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -261,6 +261,7 @@ CREATE TABLE PackageComments (
 	INDEX (UsersID),
 	INDEX (PackageBaseID),
 	FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE SET NULL,
+	FOREIGN KEY (EditedUsersID) REFERENCES Users(ID) ON DELETE SET NULL,
 	FOREIGN KEY (DelUsersID) REFERENCES Users(ID) ON DELETE CASCADE,
 	FOREIGN KEY (PackageBaseID) REFERENCES PackageBases(ID) ON DELETE CASCADE
 ) ENGINE = InnoDB;
-- 
2.4.5