summaryrefslogtreecommitdiffstats
path: root/upgrading
diff options
context:
space:
mode:
Diffstat (limited to 'upgrading')
-rw-r--r--upgrading/3.0.0.txt4
-rw-r--r--upgrading/3.1.0.txt2
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);
----