(3.5ms)  CREATE TABLE "schema_migrations" ("version" character varying NOT NULL) 
   (1.5ms)  CREATE UNIQUE INDEX  "unique_schema_migrations" ON "schema_migrations"  ("version")
  ActiveRecord::SchemaMigration Load (0.4ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateNotifiableApps (20131210115648)
   (0.2ms)  BEGIN
DEPRECATION WARNING: `#timestamps` was called without specifying an option for `null`. In Rails 5, this behavior will change to `null: false`. You should manually specify `null: true` to prevent the behavior of your existing migrations from changing. (called from block in change at /Users/mattbrooke-smith/Development/notifiable-rails/db/migrate/20131210115648_create_notifiable_apps.rb:7)
   (5.2ms)  CREATE TABLE "notifiable_apps" ("id" serial primary key, "name" character varying, "configuration" text, "created_at" timestamp, "updated_at" timestamp) 
  SQL (0.5ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20131210115648"]]
   (0.6ms)  COMMIT
Migrating to CreateNotifiableDeviceTokens (20131210115649)
   (0.4ms)  BEGIN
DEPRECATION WARNING: `#timestamps` was called without specifying an option for `null`. In Rails 5, this behavior will change to `null: false`. You should manually specify `null: true` to prevent the behavior of your existing migrations from changing. (called from block in change at /Users/mattbrooke-smith/Development/notifiable-rails/db/migrate/20131210115649_create_notifiable_device_tokens.rb:12)
   (4.3ms)  CREATE TABLE "notifiable_device_tokens" ("id" serial primary key, "token" character varying, "provider" character varying, "locale" character varying, "is_valid" boolean DEFAULT 't', "user_alias" character varying, "app_id" integer, "created_at" timestamp, "updated_at" timestamp) 
   (1.0ms)  CREATE  INDEX  "index_notifiable_device_tokens_on_user_alias" ON "notifiable_device_tokens"  ("user_alias")
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20131210115649"]]
   (0.6ms)  COMMIT
Migrating to CreateNotifiableNotifications (20131210115650)
   (0.3ms)  BEGIN
DEPRECATION WARNING: `#timestamps` was called without specifying an option for `null`. In Rails 5, this behavior will change to `null: false`. You should manually specify `null: true` to prevent the behavior of your existing migrations from changing. (called from block in change at /Users/mattbrooke-smith/Development/notifiable-rails/db/migrate/20131210115650_create_notifiable_notifications.rb:23)
   (4.5ms)  CREATE TABLE "notifiable_notifications" ("id" serial primary key, "app_id" integer, "sent_count" integer DEFAULT 0, "gateway_accepted_count" integer DEFAULT 0, "opened_count" integer DEFAULT 0, "message" text, "parameters" text, "sound" character varying, "identifier" character varying, "expiry" timestamp, "content_available" boolean, "mutable_content" boolean, "created_at" timestamp, "updated_at" timestamp) 
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20131210115650"]]
   (0.5ms)  COMMIT
Migrating to CreateNotifiableStatuses (20131210115652)
   (0.3ms)  BEGIN
   (3.4ms)  CREATE TABLE "notifiable_statuses" ("id" serial primary key, "notification_id" integer, "device_token_id" integer, "status" integer, "created_at" timestamp) 
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20131210115652"]]
   (0.5ms)  COMMIT
Migrating to AddNameToNotifiableDeviceTokens (20131210115653)
   (0.3ms)  BEGIN
   (2.7ms)  ALTER TABLE "notifiable_device_tokens" ADD "name" character varying
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20131210115653"]]
   (0.5ms)  COMMIT
Migrating to AddBadgeCountToNotifiableNotifications (20161208221332)
   (0.2ms)  BEGIN
   (0.4ms)  ALTER TABLE "notifiable_notifications" ADD "badge_count" integer
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20161208221332"]]
   (0.4ms)  COMMIT
Migrating to RemoveIsValidFromNotifiableDeviceTokens (20170108221332)
   (0.1ms)  BEGIN
   (0.9ms)  ALTER TABLE "notifiable_device_tokens" DROP "is_valid"
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170108221332"]]
   (0.5ms)  COMMIT
Migrating to AddAppIdTokenIndexToNotifiableDeviceTokens (20170108221432)
   (0.1ms)  BEGIN
   (1.1ms)  CREATE UNIQUE INDEX  "index_notifiable_device_tokens_on_app_id_and_token" ON "notifiable_device_tokens"  ("app_id", "token")
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170108221432"]]
   (0.5ms)  COMMIT
Migrating to AddLatLonToNotifiableDeviceTokens (20170116212641)
   (0.1ms)  BEGIN
  SQL (0.3ms)  CREATE EXTENSION IF NOT EXISTS "postgis"
   (3.4ms)  ALTER TABLE "notifiable_device_tokens" ADD "lonlat" geography(POINT,4326)
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170116212641"]]
   (0.5ms)  COMMIT
Migrating to AddLastErrorMessageToNotifications (20180302212641)
  ActiveRecord::SchemaMigration Load (0.4ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to AddLastErrorMessageToNotifications (20180302212641)
   (0.3ms)  BEGIN
   (1.0ms)  ALTER TABLE "notifiable_notifications" ADD "last_error_message" text
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20180302212641"]]
   (0.5ms)  COMMIT
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (3.9ms)  SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete
FROM pg_constraint c
JOIN pg_class t1 ON c.conrelid = t1.oid
JOIN pg_class t2 ON c.confrelid = t2.oid
JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid
JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid
JOIN pg_namespace t3 ON c.connamespace = t3.oid
WHERE c.contype = 'f'
  AND t1.relname = 'notifiable_apps'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (3.1ms)  SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete
FROM pg_constraint c
JOIN pg_class t1 ON c.conrelid = t1.oid
JOIN pg_class t2 ON c.confrelid = t2.oid
JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid
JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid
JOIN pg_namespace t3 ON c.connamespace = t3.oid
WHERE c.contype = 'f'
  AND t1.relname = 'notifiable_device_tokens'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (3.0ms)  SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete
FROM pg_constraint c
JOIN pg_class t1 ON c.conrelid = t1.oid
JOIN pg_class t2 ON c.confrelid = t2.oid
JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid
JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid
JOIN pg_namespace t3 ON c.connamespace = t3.oid
WHERE c.contype = 'f'
  AND t1.relname = 'notifiable_notifications'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (5.2ms)  SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete
FROM pg_constraint c
JOIN pg_class t1 ON c.conrelid = t1.oid
JOIN pg_class t2 ON c.confrelid = t2.oid
JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid
JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid
JOIN pg_namespace t3 ON c.connamespace = t3.oid
WHERE c.contype = 'f'
  AND t1.relname = 'notifiable_statuses'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (3.8ms)  CREATE TABLE "schema_migrations" ("version" character varying NOT NULL) 
   (2.0ms)  CREATE UNIQUE INDEX  "unique_schema_migrations" ON "schema_migrations"  ("version")
  ActiveRecord::SchemaMigration Load (0.5ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateNotifiableApps (20131210115648)
   (0.2ms)  BEGIN
DEPRECATION WARNING: `#timestamps` was called without specifying an option for `null`. In Rails 5, this behavior will change to `null: false`. You should manually specify `null: true` to prevent the behavior of your existing migrations from changing. (called from block in change at /Users/mattbrooke-smith/Development/notifiable-rails/db/migrate/20131210115648_create_notifiable_apps.rb:7)
   (6.6ms)  CREATE TABLE "notifiable_apps" ("id" serial primary key, "name" character varying, "configuration" text, "created_at" timestamp, "updated_at" timestamp) 
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20131210115648"]]
   (0.5ms)  COMMIT
Migrating to CreateNotifiableDeviceTokens (20131210115649)
   (0.4ms)  BEGIN
DEPRECATION WARNING: `#timestamps` was called without specifying an option for `null`. In Rails 5, this behavior will change to `null: false`. You should manually specify `null: true` to prevent the behavior of your existing migrations from changing. (called from block in change at /Users/mattbrooke-smith/Development/notifiable-rails/db/migrate/20131210115649_create_notifiable_device_tokens.rb:12)
   (4.5ms)  CREATE TABLE "notifiable_device_tokens" ("id" serial primary key, "token" character varying, "provider" character varying, "locale" character varying, "is_valid" boolean DEFAULT 't', "user_alias" character varying, "app_id" integer, "created_at" timestamp, "updated_at" timestamp) 
   (1.0ms)  CREATE  INDEX  "index_notifiable_device_tokens_on_user_alias" ON "notifiable_device_tokens"  ("user_alias")
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20131210115649"]]
   (0.6ms)  COMMIT
Migrating to CreateNotifiableNotifications (20131210115650)
   (0.3ms)  BEGIN
DEPRECATION WARNING: `#timestamps` was called without specifying an option for `null`. In Rails 5, this behavior will change to `null: false`. You should manually specify `null: true` to prevent the behavior of your existing migrations from changing. (called from block in change at /Users/mattbrooke-smith/Development/notifiable-rails/db/migrate/20131210115650_create_notifiable_notifications.rb:23)
   (3.6ms)  CREATE TABLE "notifiable_notifications" ("id" serial primary key, "app_id" integer, "sent_count" integer DEFAULT 0, "gateway_accepted_count" integer DEFAULT 0, "opened_count" integer DEFAULT 0, "message" text, "parameters" text, "sound" character varying, "identifier" character varying, "expiry" timestamp, "content_available" boolean, "mutable_content" boolean, "created_at" timestamp, "updated_at" timestamp) 
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20131210115650"]]
   (0.4ms)  COMMIT
Migrating to CreateNotifiableStatuses (20131210115652)
   (0.2ms)  BEGIN
   (2.5ms)  CREATE TABLE "notifiable_statuses" ("id" serial primary key, "notification_id" integer, "device_token_id" integer, "status" integer, "created_at" timestamp) 
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20131210115652"]]
   (0.4ms)  COMMIT
Migrating to AddNameToNotifiableDeviceTokens (20131210115653)
   (0.3ms)  BEGIN
   (2.5ms)  ALTER TABLE "notifiable_device_tokens" ADD "name" character varying
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20131210115653"]]
   (0.5ms)  COMMIT
Migrating to AddBadgeCountToNotifiableNotifications (20161208221332)
   (0.2ms)  BEGIN
   (0.3ms)  ALTER TABLE "notifiable_notifications" ADD "badge_count" integer
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20161208221332"]]
   (0.4ms)  COMMIT
Migrating to RemoveIsValidFromNotifiableDeviceTokens (20170108221332)
   (0.1ms)  BEGIN
   (1.5ms)  ALTER TABLE "notifiable_device_tokens" DROP "is_valid"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170108221332"]]
   (0.4ms)  COMMIT
Migrating to AddAppIdTokenIndexToNotifiableDeviceTokens (20170108221432)
   (0.1ms)  BEGIN
   (1.0ms)  CREATE UNIQUE INDEX  "index_notifiable_device_tokens_on_app_id_and_token" ON "notifiable_device_tokens"  ("app_id", "token")
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170108221432"]]
   (0.4ms)  COMMIT
Migrating to AddLatLonToNotifiableDeviceTokens (20170116212641)
   (0.1ms)  BEGIN
  SQL (0.2ms)  CREATE EXTENSION IF NOT EXISTS "postgis"
   (8.0ms)  ALTER TABLE "notifiable_device_tokens" ADD "lonlat" geography(POINT,4326)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170116212641"]]
   (0.4ms)  COMMIT
Migrating to AddLastErrorMessageToNotifications (20180302212641)
   (0.1ms)  BEGIN
   (0.3ms)  ALTER TABLE "notifiable_notifications" ADD "last_error_message" text
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20180302212641"]]
   (0.5ms)  COMMIT
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (4.6ms)  SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete
FROM pg_constraint c
JOIN pg_class t1 ON c.conrelid = t1.oid
JOIN pg_class t2 ON c.confrelid = t2.oid
JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid
JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid
JOIN pg_namespace t3 ON c.connamespace = t3.oid
WHERE c.contype = 'f'
  AND t1.relname = 'notifiable_apps'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (4.1ms)  SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete
FROM pg_constraint c
JOIN pg_class t1 ON c.conrelid = t1.oid
JOIN pg_class t2 ON c.confrelid = t2.oid
JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid
JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid
JOIN pg_namespace t3 ON c.connamespace = t3.oid
WHERE c.contype = 'f'
  AND t1.relname = 'notifiable_device_tokens'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (3.6ms)  SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete
FROM pg_constraint c
JOIN pg_class t1 ON c.conrelid = t1.oid
JOIN pg_class t2 ON c.confrelid = t2.oid
JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid
JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid
JOIN pg_namespace t3 ON c.connamespace = t3.oid
WHERE c.contype = 'f'
  AND t1.relname = 'notifiable_notifications'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (3.4ms)  SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete
FROM pg_constraint c
JOIN pg_class t1 ON c.conrelid = t1.oid
JOIN pg_class t2 ON c.confrelid = t2.oid
JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid
JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid
JOIN pg_namespace t3 ON c.connamespace = t3.oid
WHERE c.contype = 'f'
  AND t1.relname = 'notifiable_statuses'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (4.6ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
   (34.6ms)  CREATE TABLE "ar_internal_metadata" ("key" character varying NOT NULL PRIMARY KEY, "value" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
   (1.0ms)  SELECT pg_try_advisory_lock(1477033930387646610)
   (3.3ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to AddTitleToNotifications (201803142135000)
   (0.2ms)  BEGIN
   (1.7ms)  ALTER TABLE "notifiable_notifications" ADD "title" character varying
  SQL (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "201803142135000"]]
   (0.5ms)  COMMIT
Migrating to AddLanguageAndRegionToDeviceTokens (201805292135000)
   (0.1ms)  BEGIN
   (1.5ms)  ALTER TABLE "notifiable_device_tokens" ADD "language" character varying
   (0.5ms)  ALTER TABLE "notifiable_device_tokens" ADD "region" character varying
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "201805292135000"]]
   (0.5ms)  COMMIT
  ActiveRecord::InternalMetadata Load (0.6ms)  SELECT  "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2  [["key", "environment"], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  SQL (0.4ms)  INSERT INTO "ar_internal_metadata" ("key", "value", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "key"  [["key", "environment"], ["value", "development"], ["created_at", "2018-05-29 17:53:16.691191"], ["updated_at", "2018-05-29 17:53:16.691191"]]
   (0.4ms)  COMMIT
   (0.3ms)  SELECT pg_advisory_unlock(1477033930387646610)
   (0.2ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
   (1.0ms)  SELECT pg_try_advisory_lock(1477033930387646610)
   (3.0ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to AddThreadIdToNotifications (201806182135000)
   (0.6ms)  BEGIN
   (10.2ms)  ALTER TABLE "notifiable_notifications" ADD "thread_id" character varying
  SQL (2.9ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "201806182135000"]]
   (1.1ms)  COMMIT
Migrating to AddCategoryToNotifications (201806242135000)
   (0.2ms)  SELECT pg_advisory_unlock(1477033930387646610)
   (0.2ms)  SELECT pg_try_advisory_lock(1477033930387646610)
   (0.9ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to AddCategoryToNotifications (201806242135000)
   (0.1ms)  BEGIN
   (0.7ms)  ALTER TABLE "notifiable_notifications" ADD "category" character varying
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "201806242135000"]]
   (6.3ms)  COMMIT
  ActiveRecord::InternalMetadata Load (3.4ms)  SELECT  "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2  [["key", "environment"], ["LIMIT", 1]]
   (0.3ms)  BEGIN
   (0.2ms)  COMMIT
   (0.3ms)  SELECT pg_advisory_unlock(1477033930387646610)
   (0.3ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC