summaryrefslogtreecommitdiffstats
path: root/schema
diff options
context:
space:
mode:
authorMark Weiman <mark.weiman@markzz.com>2017-01-20 07:16:39 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2017-01-20 23:20:40 +0100
commit608c48309084e4048d8226c3f7e363b240248040 (patch)
treeb17b272ae8d5101e239fd65ed75397144981057d /schema
parent087b539cbc3f4a24872e340b1aa863c263cd65bd (diff)
downloadaur-608c48309084e4048d8226c3f7e363b240248040.tar.gz
aur-608c48309084e4048d8226c3f7e363b240248040.tar.xz
Add user set timezones
Currently, aurweb displays all dates and times in UTC time. This patch adds a capability for each logged in user to set their preferred timezone. Implements FS#48729. Signed-off-by: Mark Weiman <mark.weiman@markzz.com> Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'schema')
-rw-r--r--schema/aur-schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 30209bd8..13e3fd94 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -32,6 +32,7 @@ CREATE TABLE Users (
ResetKey CHAR(32) NOT NULL DEFAULT '',
RealName VARCHAR(64) NOT NULL DEFAULT '',
LangPreference VARCHAR(6) NOT NULL DEFAULT 'en',
+ Timezone VARCHAR(32) NOT NULL DEFAULT 'UTC',
Homepage TEXT NULL DEFAULT NULL,
IRCNick VARCHAR(32) NOT NULL DEFAULT '',
PGPKey VARCHAR(40) NULL DEFAULT NULL,