2 files changed, 7 insertions, 4 deletions
diff --git a/models/config.php b/models/config.php
index f4d34986..a00d0b7e 100644
--- a/models/config.php
+++ b/models/config.php
@@ -9,6 +9,12 @@ class Config extends Base
 {
     const TABLE = 'config';
 
+    public function getTimezones()
+    {
+        $timezones = \timezone_identifiers_list();
+        return array_combine(array_values($timezones), $timezones);
+    }
+
     public function getLanguages()
     {
         $languages = array(
diff --git a/models/schema.php b/models/schema.php
index 3704aad1..66571bbe 100644
--- a/models/schema.php
+++ b/models/schema.php
@@ -4,10 +4,7 @@ namespace Schema;
 
 function version_4($pdo)
 {
-    $pdo->exec('ALTER TABLE config ADD column timezone TEXT');
-
-    //set default timezone to UTC
-    $pdo->exec('UPDATE config SET timezone = \'UTC\'');
+    $pdo->exec("ALTER TABLE config ADD column timezone TEXT DEFAULT 'UTC'");
 }
 
 function version_3($pdo)