Increase the size of several database fields

Several fields turned out to be too small (e.g. when long package
versions are used in VCS packages). Since the type of all affected
fields is VARCHAR, there is no reason to keep them as small as possible.

Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>

1 files changed, 17 insertions, 0 deletions

diff --git a/UPGRADING b/UPGRADING
index a45c970c..863fde31 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -1,6 +1,23 @@
 Upgrading
 =========
 
+From 3.0.0 to 3.1.0
+-------------------
+
+1. Increase the size of all fields containing package names, license names,
+group names or package versions:
+
+----
+ALTER TABLE PackageBases MODIFY Name VARCHAR(255) NOT NULL;
+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 PackageDepends MODIFY DepCondition VARCHAR(255);
+ALTER TABLE PackageRelations MODIFY RelCondition VARCHAR(255);
+----
+
 From 2.3.1 to 3.0.0
 -------------------