diff options
| author | Florian Pritz <bluewind@xinu.at> | 2019-01-14 20:44:12 +0100 |
|---|---|---|
| committer | Eli Schwartz <eschwartz@archlinux.org> | 2019-01-14 20:45:37 +0100 |
| commit | 042f3f2622e1adbc7546cfa25a5d138486b99341 (patch) | |
| tree | d3f56bc3205725635a5282b362221dd1a78c98ec /schema | |
| parent | f1d109e9b6863d924d2cb20f83e41d7091d62e20 (diff) | |
| download | aur-042f3f2622e1adbc7546cfa25a5d138486b99341.tar.gz aur-042f3f2622e1adbc7546cfa25a5d138486b99341.tar.xz | |
Quote MySql 8.0 reserved keywords
Signed-off-by: Florian Pritz <bluewind@xinu.at>
Signed-off-by: Eli Schwartz <eschwartz@archlinux.org>
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/aur-schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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; |