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 /upgrading | |
| 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 'upgrading')
| -rw-r--r-- | upgrading/3.0.0.txt | 4 | ||||
| -rw-r--r-- | upgrading/3.1.0.txt | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/upgrading/3.0.0.txt b/upgrading/3.0.0.txt index b134b797..4f9c70f6 100644 --- a/upgrading/3.0.0.txt +++ b/upgrading/3.0.0.txt @@ -200,7 +200,7 @@ CREATE TABLE PackageRelations ( 17. Create tables to store package groups: ---- -CREATE TABLE Groups ( +CREATE TABLE `Groups` ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, Name VARCHAR(64) NOT NULL, PRIMARY KEY (ID), @@ -211,7 +211,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; ---- diff --git a/upgrading/3.1.0.txt b/upgrading/3.1.0.txt index 2fc16147..e883a6cd 100644 --- a/upgrading/3.1.0.txt +++ b/upgrading/3.1.0.txt @@ -7,7 +7,7 @@ ALTER TABLE Packages MODIFY Name VARCHAR(255) NOT NULL, MODIFY Version VARCHAR(255) NOT NULL DEFAULT ''; ALTER TABLE Licenses MODIFY Name VARCHAR(255) NOT NULL; -ALTER TABLE Groups MODIFY Name VARCHAR(255) NOT NULL; +ALTER TABLE `Groups` MODIFY Name VARCHAR(255) NOT NULL; ALTER TABLE PackageDepends MODIFY DepCondition VARCHAR(255); ALTER TABLE PackageRelations MODIFY RelCondition VARCHAR(255); ---- |