From 042f3f2622e1adbc7546cfa25a5d138486b99341 Mon Sep 17 00:00:00 2001
From: Florian Pritz <bluewind@xinu.at>
Date: Mon, 14 Jan 2019 20:44:12 +0100
Subject: Quote MySql 8.0 reserved keywords

Signed-off-by: Florian Pritz <bluewind@xinu.at>
Signed-off-by: Eli Schwartz <eschwartz@archlinux.org>
---
 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

