summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJohannes Löthberg <johannes@kyriasis.com>2016-07-20 20:16:25 +0200
committerLukas Fleischer <lfleischer@archlinux.org>2016-07-24 18:51:05 +0200
commite55b529813feb806fd139ccbf47be87970d95b74 (patch)
tree64c2f6ac48f51ada7c52f73665bebf33e9978c05
parent2160678f9bfb4ff5403086e202cc24e8e0d4cf69 (diff)
downloadaur-e55b529813feb806fd139ccbf47be87970d95b74.tar.gz
aur-e55b529813feb806fd139ccbf47be87970d95b74.tar.xz
Make LangPreference DB field wide enough to fit es_419
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@kyriasis.com> Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
-rw-r--r--schema/aur-schema.sql2
-rw-r--r--upgrading/4.3.0.txt6
2 files changed, 7 insertions, 1 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 1affc25e..99911298 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 6c1753de..78f94551 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);
+--