From 0f45e98a088d7e941dce09ef17643335f4483f7e Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Fri, 18 Apr 2014 23:44:59 +0200 Subject: Allow dependency names of up to 255 characters This field needs to be a bit larger now that optdepends (including descriptions) are stored there as well. Signed-off-by: Lukas Fleischer --- 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), -- cgit v1.2.3-54-g00ecf