From c3ebc4d7fa35b280c353192b23d7b6338f60a9a9 Mon Sep 17 00:00:00 2001 From: Loui Chang Date: Sun, 29 Nov 2009 06:28:15 -0500 Subject: aur-schema.sql: Expand LangPreference field to allow for longer lang codes. To upgrade existing databases: ALTER TABLE Users MODIFY LangPreference CHAR(5) NOT NULL DEFAULT 'en'; Signed-off-by: Loui Chang --- support/schema/aur-schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 39da1bd..67e20a7 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -28,7 +28,7 @@ CREATE TABLE Users ( Passwd CHAR(32) NOT NULL, ResetKey CHAR(32) NOT NULL DEFAULT '', RealName CHAR(64) NOT NULL DEFAULT '', - LangPreference CHAR(2) NOT NULL DEFAULT 'en', + LangPreference CHAR(5) NOT NULL DEFAULT 'en', IRCNick CHAR(32) NOT NULL DEFAULT '', LastVoted BIGINT UNSIGNED NOT NULL DEFAULT 0, NewPkgNotify TINYINT UNSIGNED NOT NULL DEFAULT 0, -- cgit v1.2.3-70-g09d2