[aur-dev] [PATCH 1/3] Allow dependency names of up to 255 characters

[Lukas Fleischer]

This field needs to be a bit larger now that optdepends (including
descriptions) are stored there as well.

Signed-off-by: Lukas Fleischer <archlinux at cryptocrack.de>
---
 UPGRADING             | 6 ++++++
 schema/aur-schema.sql | 2 +-
 2 files changed, 7 insertions(+), 1 deletion(-)

diff --git a/UPGRADING b/UPGRADING
index 48737f2..0a801cc 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -165,6 +165,12 @@ ALTER TABLE PackageDepends
 	ADD FOREIGN KEY (DepTypeID) REFERENCES DependencyTypes(ID) ON DELETE NO ACTION;
 ----
 
+14. Resize the package dependency name field:
+
+----
+ALTER TABLE PackageDepends MODIFY DepName VARCHAR(255) NOT NULL;
+----
+
 From 2.2.0 to 2.3.0
 -------------------
 
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 327a792..af03b69 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -151,7 +151,7 @@ INSERT INTO DependencyTypes VALUES (4, 'optdepends');
 CREATE TABLE PackageDepends (
 	PackageID INTEGER UNSIGNED NOT NULL,
 	DepTypeID TINYINT UNSIGNED NOT NULL,
-	DepName VARCHAR(64) NOT NULL,
+	DepName VARCHAR(255) NOT NULL,
 	DepCondition VARCHAR(20),
 	INDEX (PackageID),
 	INDEX (DepName),
-- 
1.9.2