[aur-dev] [PATCH] Make LangPreference DB field wide enough to fit es_419

[Johannes Löthberg]

The language code for Latin American Spanish is es_419, which is longer
than the 5 characters previously allowed.

Signed-off-by: Johannes Löthberg <johannes at kyriasis.com>
---
 schema/aur-schema.sql | 2 +-
 upgrading/4.3.0.txt   | 6 ++++++
 2 files changed, 7 insertions(+), 1 deletion(-)

diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 1affc25..9991129 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -31,7 +31,7 @@ CREATE TABLE Users (
 	Salt CHAR(32) NOT NULL DEFAULT '',
 	ResetKey CHAR(32) NOT NULL DEFAULT '',
 	RealName VARCHAR(64) NOT NULL DEFAULT '',
-	LangPreference VARCHAR(5) NOT NULL DEFAULT 'en',
+	LangPreference VARCHAR(6) NOT NULL DEFAULT 'en',
 	Homepage TEXT NULL DEFAULT NULL,
 	IRCNick VARCHAR(32) NOT NULL DEFAULT '',
 	PGPKey VARCHAR(40) NULL DEFAULT NULL,
diff --git a/upgrading/4.3.0.txt b/upgrading/4.3.0.txt
index 6c1753d..78f9455 100644
--- a/upgrading/4.3.0.txt
+++ b/upgrading/4.3.0.txt
@@ -21,3 +21,9 @@ ALTER TABLE OfficialProviders ADD COLUMN Repo VARCHAR(64) NOT NULL;
 ----
 ALTER TABLE Users ADD COLUMN Homepage TEXT NULL DEFAULT NULL;
 ----
+
+5. Resize LangPreference to fit Latin American Spanish language code:
+
+--
+ALTER TABLE Users MODIFY LangPreference VARCHAR(6);
+--
-- 
2.9.0