From 042f3f2622e1adbc7546cfa25a5d138486b99341 Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Mon, 14 Jan 2019 20:44:12 +0100 Subject: Quote MySql 8.0 reserved keywords Signed-off-by: Florian Pritz Signed-off-by: Eli Schwartz --- schema/aur-schema.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'schema/aur-schema.sql') diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index 79de3f27..f05f40a3 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -149,7 +149,7 @@ CREATE TABLE PackageLicenses ( -- Information about groups -- -CREATE TABLE Groups ( +CREATE TABLE `Groups` ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, Name VARCHAR(255) NOT NULL, PRIMARY KEY (ID), @@ -164,7 +164,7 @@ CREATE TABLE PackageGroups ( GroupID INTEGER UNSIGNED NOT NULL, PRIMARY KEY (PackageID, GroupID), FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE, - FOREIGN KEY (GroupID) REFERENCES Groups(ID) ON DELETE CASCADE + FOREIGN KEY (GroupID) REFERENCES `Groups`(ID) ON DELETE CASCADE ) ENGINE = InnoDB; -- cgit v1.2.3-24-g4f1b