From 741d74fd21ae6674d6db92623a175cb51867e5b3 Mon Sep 17 00:00:00 2001
From: Jordan Doyle <jordan@doyle.wf>
Date: Sun, 26 Jun 2016 15:52:45 +0100
Subject: [PATCH] Add default for timezone

---
 database/migrations/2016_06_26_154849_update_users_timezones_add_timezone_default.php | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 database/migrations/2016_06_26_154849_update_users_timezones_add_timezone_default.php

diff --git a/database/migrations/2016_06_26_154849_update_users_timezones_add_timezone_default.php b/database/migrations/2016_06_26_154849_update_users_timezones_add_timezone_default.php
new file mode 100644
index 0000000..d7629a0
--- /dev/null
+++ b/database/migrations/2016_06_26_154849_update_users_timezones_add_timezone_default.php
@@ -0,0 +1,27 @@
+<?php
+
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class UpdateUsersTimezonesAddTimezoneDefault extends Migration
+{
+    /**
+     * Run the migrations.
+     *
+     * @return void
+     */
+    public function up()
+    {
+        DB::statement('ALTER TABLE users_timezones ALTER timezone SET DEFAULT \'Europe/London\'');
+    }
+
+    /**
+     * Reverse the migrations.
+     *
+     * @return void
+     */
+    public function down()
+    {
+        DB::statement('ALTER TABLE users_timezones ALTER timezone DROP DEFAULT');
+    }
+}
--
libgit2 1.7.2