wip for db_migrations for core schema

286 files changed, 102 insertions, 23 deletions

diff --git a/classes/config.php b/classes/config.php
index 7a37d4a86..30b65305a 100644
--- a/classes/config.php
+++ b/classes/config.php
@@ -114,6 +114,9 @@ class Config {
 	private $schema_version = null;
 	private $version = [];
 
+	/** @var Db_Migrations $migrations */
+	private $migrations;
+
 	public static function get_instance() : Config {
 		if (self::$instance == null)
 			self::$instance = new self();
@@ -218,18 +221,25 @@ class Config {
 		return $rv;
 	}
 
-	static function get_schema_version(bool $nocache = false) {
-		return self::get_instance()->_schema_version($nocache);
+	static function get_migrations() : Db_Migrations {
+		return self::get_instance()->_get_migrations();
 	}
 
-	function _schema_version(bool $nocache = false) {
-		if (empty($this->schema_version) || $nocache) {
-			$row = Db::pdo()->query("SELECT schema_version FROM ttrss_version")->fetch();
-
-			$this->schema_version = (int) $row["schema_version"];
+	private function _get_migrations() : Db_Migrations {
+		if (empty($this->migrations)) {
+			$this->migrations = new Db_Migrations();
+			$this->migrations->initialize(dirname(__DIR__) . "/sql", "ttrss_version", true);
 		}
 
-		return $this->schema_version;
+		return $this->migrations;
+	}
+
+	static function is_migration_needed() : bool {
+		return self::get_migrations()->is_migration_needed();
+	}
+
+	static function get_schema_version() : int {
+		return self::get_migrations()->get_version();
 	}
 
 	static function cast_to(string $value, int $type_hint) {
diff --git a/classes/db/migrations.php b/classes/db/migrations.php
index f85b4d7c7..e77904f60 100644
--- a/classes/db/migrations.php
+++ b/classes/db/migrations.php
@@ -10,6 +10,7 @@ class Db_Migrations {
 
 	private $cached_version;
 	private $cached_max_version;
+	private $max_version_override;
 
 	function __construct() {
 		$this->pdo = Db::pdo();
@@ -22,14 +23,17 @@ class Db_Migrations {
 			$base_is_latest);
 	}
 
-	function initialize(string $root_path, string $migrations_table, bool $base_is_latest = true) {
+	function initialize(string $root_path, string $migrations_table, bool $base_is_latest = true, int $max_version_override = 0) {
 		$this->base_path = "$root_path/" . Config::get(Config::DB_TYPE);
 		$this->migrations_path = $this->base_path . "/migrations";
 		$this->migrations_table = $migrations_table;
 		$this->base_is_latest = $base_is_latest;
+		$this->max_version_override =  $max_version_override;
 	}
 
 	private function set_version(int $version) {
+		Debug::log("Updating table {$this->migrations_table} with version ${version}...", Debug::LOG_EXTENDED);
+
 		$sth = $this->pdo->query("SELECT * FROM {$this->migrations_table}");
 
 		if ($res = $sth->fetch()) {
@@ -43,7 +47,7 @@ class Db_Migrations {
 		$this->cached_version = $version;
 	}
 
-	private function get_version() : int {
+	function get_version() : int {
 		if (isset($this->cached_version))
 			return $this->cached_version;
 
@@ -68,10 +72,26 @@ class Db_Migrations {
 
 	private function migrate_to(int $version) {
 		try {
+			if ($version <= $this->get_version()) {
+				Debug::log("Refusing to apply version $version: current version is higher", Debug::LOG_VERBOSE);
+				return false;
+			}
+
+			if ($version == 0)
+				Debug::log("Loading base database schema...", Debug::LOG_VERBOSE);
+			else
+				Debug::log("Starting migration to $version...", Debug::LOG_VERBOSE);
+
 			$this->pdo->beginTransaction();
 
 			foreach ($this->get_lines($version) as $line) {
-				$this->pdo->query($line);
+				Debug::log($line, Debug::LOG_EXTENDED);
+				try {
+					$this->pdo->query($line);
+				} catch (PDOException $e) {
+					Debug::log("Failed on line: $line");
+					throw $e;
+				}
 			}
 
 			if ($version == 0 && $this->base_is_latest)
@@ -80,7 +100,10 @@ class Db_Migrations {
 				$this->set_version($version);
 
 			$this->pdo->commit();
+			Debug::log("Migration finished, current version: " . $this->get_version(), Debug::LOG_VERBOSE);
+
 		} catch (PDOException $e) {
+			Debug::log("Migration failed: " . $e->getMessage(), Debug::LOG_VERBOSE);
 			try {
 				$this->pdo->rollback();
 			} catch (PDOException $ie) {
@@ -90,7 +113,10 @@ class Db_Migrations {
 		}
 	}
 
-	private function get_max_version() : int {
+	function get_max_version() : int {
+		if ($this->max_version_override > 0)
+			return $this->max_version_override;
+
 		if (isset($this->cached_max_version))
 			return $this->cached_max_version;
 
@@ -108,17 +134,32 @@ class Db_Migrations {
 		return $this->cached_max_version;
 	}
 
+	function is_migration_needed() : bool {
+		return $this->get_version() != $this->get_max_version();
+	}
+
 	function migrate() : bool {
 
-		for ($i = $this->get_version() + 1; $i <= $this->get_max_version(); $i++)
+		if ($this->get_version() == -1) {
+			try {
+				$this->migrate_to(0);
+			} catch (PDOException $e) {
+				user_error("Failed to load base schema for {$this->migrations_table}: " . $e->getMessage(), E_USER_WARNING);
+				return false;
+			}
+		}
+
+		for ($i = $this->get_version() + 1; $i <= $this->get_max_version(); $i++) {
 			try {
 				$this->migrate_to($i);
 			} catch (PDOException $e) {
-				user_error("Failed applying migration $i on table {$this->migrations_table}: " . $e->getMessage(), E_USER_WARNING);
+				user_error("Failed to apply migration ${i} for {$this->migrations_table}: " . $e->getMessage(), E_USER_WARNING);
+				return false;
 				//throw $e;
 			}
+		}
 
-		return $this->get_version() == $this->get_max_version();
+		return !$this->is_migration_needed();
 	}
 
 	private function get_lines(int $version) : array {
@@ -134,11 +175,11 @@ class Db_Migrations {
 							});
 
 			return array_filter(explode(";", implode("", $lines)), function ($line) {
-				return strlen(trim($line)) > 0;
+				return strlen(trim($line)) > 0 && !in_array(strtolower($line), ["begin", "commit"]);
 			});
 
 		} else {
-			user_error(E_USER_ERROR, "[migrations] requested schema file ${filename} not found.");
+			user_error("Requested schema file ${filename} not found.", E_USER_ERROR);
 			return [];
 		}
 	}
diff --git a/classes/debug.php b/classes/debug.php
index 3061c6893..a0dcac35b 100644
--- a/classes/debug.php
+++ b/classes/debug.php
@@ -1,5 +1,10 @@
 <?php
 class Debug {
+	const LOG_DISABLED = -1;
+    const LOG_NORMAL = 0;
+    const LOG_VERBOSE = 1;
+    const LOG_EXTENDED = 2;
+
 	public static $LOG_DISABLED = -1;
     public static $LOG_NORMAL = 0;
     public static $LOG_VERBOSE = 1;
diff --git a/schema/versions/mysql/10.sql b/sql/mysql/migrations/10.sql
index e951f482f..e951f482f 100644
--- a/schema/versions/mysql/10.sql
+++ b/sql/mysql/migrations/10.sql
diff --git a/schema/versions/mysql/100.sql b/sql/mysql/migrations/100.sql
index a360dab6c..a360dab6c 100644
--- a/schema/versions/mysql/100.sql
+++ b/sql/mysql/migrations/100.sql
diff --git a/schema/versions/mysql/101.sql b/sql/mysql/migrations/101.sql
index 47ff26522..47ff26522 100644
--- a/schema/versions/mysql/101.sql
+++ b/sql/mysql/migrations/101.sql
diff --git a/schema/versions/mysql/102.sql b/sql/mysql/migrations/102.sql
index ccf5ef3b3..ccf5ef3b3 100644
--- a/schema/versions/mysql/102.sql
+++ b/sql/mysql/migrations/102.sql
diff --git a/schema/versions/mysql/103.sql b/sql/mysql/migrations/103.sql
index 6a93b80b8..6a93b80b8 100644
--- a/schema/versions/mysql/103.sql
+++ b/sql/mysql/migrations/103.sql
diff --git a/schema/versions/mysql/104.sql b/sql/mysql/migrations/104.sql
index 104e4b917..104e4b917 100644
--- a/schema/versions/mysql/104.sql
+++ b/sql/mysql/migrations/104.sql
diff --git a/schema/versions/mysql/105.sql b/sql/mysql/migrations/105.sql
index a96101784..a96101784 100644
--- a/schema/versions/mysql/105.sql
+++ b/sql/mysql/migrations/105.sql
diff --git a/schema/versions/mysql/106.sql b/sql/mysql/migrations/106.sql
index b819416b9..b819416b9 100644
--- a/schema/versions/mysql/106.sql
+++ b/sql/mysql/migrations/106.sql
diff --git a/schema/versions/mysql/107.sql b/sql/mysql/migrations/107.sql
index 9283d40d9..9283d40d9 100644
--- a/schema/versions/mysql/107.sql
+++ b/sql/mysql/migrations/107.sql
diff --git a/schema/versions/mysql/108.sql b/sql/mysql/migrations/108.sql
index 899be8bb4..899be8bb4 100644
--- a/schema/versions/mysql/108.sql
+++ b/sql/mysql/migrations/108.sql
diff --git a/schema/versions/mysql/109.sql b/sql/mysql/migrations/109.sql
index 77e883c3b..77e883c3b 100644
--- a/schema/versions/mysql/109.sql
+++ b/sql/mysql/migrations/109.sql
diff --git a/schema/versions/mysql/11.sql b/sql/mysql/migrations/11.sql
index 690b978eb..690b978eb 100644
--- a/schema/versions/mysql/11.sql
+++ b/sql/mysql/migrations/11.sql
diff --git a/schema/versions/mysql/110.sql b/sql/mysql/migrations/110.sql
index 859f7d6dc..859f7d6dc 100644
--- a/schema/versions/mysql/110.sql
+++ b/sql/mysql/migrations/110.sql
diff --git a/schema/versions/mysql/111.sql b/sql/mysql/migrations/111.sql
index 27f287d1a..27f287d1a 100644
--- a/schema/versions/mysql/111.sql
+++ b/sql/mysql/migrations/111.sql
diff --git a/schema/versions/mysql/112.sql b/sql/mysql/migrations/112.sql
index a6f0b200b..a6f0b200b 100644
--- a/schema/versions/mysql/112.sql
+++ b/sql/mysql/migrations/112.sql
diff --git a/schema/versions/mysql/113.sql b/sql/mysql/migrations/113.sql
index 3c0d00563..3c0d00563 100644
--- a/schema/versions/mysql/113.sql
+++ b/sql/mysql/migrations/113.sql
diff --git a/schema/versions/mysql/114.sql b/sql/mysql/migrations/114.sql
index fd7ce5d2b..fd7ce5d2b 100644
--- a/schema/versions/mysql/114.sql
+++ b/sql/mysql/migrations/114.sql
diff --git a/schema/versions/mysql/115.sql b/sql/mysql/migrations/115.sql
index e23f0533a..e23f0533a 100644
--- a/schema/versions/mysql/115.sql
+++ b/sql/mysql/migrations/115.sql
diff --git a/schema/versions/mysql/116.sql b/sql/mysql/migrations/116.sql
index 252ba0e3a..252ba0e3a 100644
--- a/schema/versions/mysql/116.sql
+++ b/sql/mysql/migrations/116.sql
diff --git a/schema/versions/mysql/117.sql b/sql/mysql/migrations/117.sql
index da3d056cc..da3d056cc 100644
--- a/schema/versions/mysql/117.sql
+++ b/sql/mysql/migrations/117.sql
diff --git a/schema/versions/mysql/118.sql b/sql/mysql/migrations/118.sql
index add2b0c1f..add2b0c1f 100644
--- a/schema/versions/mysql/118.sql
+++ b/sql/mysql/migrations/118.sql
diff --git a/schema/versions/mysql/119.sql b/sql/mysql/migrations/119.sql
index ddb7d64de..ddb7d64de 100644
--- a/schema/versions/mysql/119.sql
+++ b/sql/mysql/migrations/119.sql
diff --git a/schema/versions/mysql/12.sql b/sql/mysql/migrations/12.sql
index 73af4e375..73af4e375 100644
--- a/schema/versions/mysql/12.sql
+++ b/sql/mysql/migrations/12.sql
diff --git a/schema/versions/mysql/120.sql b/sql/mysql/migrations/120.sql
index 34971146e..34971146e 100644
--- a/schema/versions/mysql/120.sql
+++ b/sql/mysql/migrations/120.sql
diff --git a/schema/versions/mysql/121.sql b/sql/mysql/migrations/121.sql
index d9cf51184..d9cf51184 100644
--- a/schema/versions/mysql/121.sql
+++ b/sql/mysql/migrations/121.sql
diff --git a/schema/versions/mysql/122.sql b/sql/mysql/migrations/122.sql
index 397b97bfc..397b97bfc 100644
--- a/schema/versions/mysql/122.sql
+++ b/sql/mysql/migrations/122.sql
diff --git a/schema/versions/mysql/123.sql b/sql/mysql/migrations/123.sql
index f311d060b..f311d060b 100644
--- a/schema/versions/mysql/123.sql
+++ b/sql/mysql/migrations/123.sql
diff --git a/schema/versions/mysql/124.sql b/sql/mysql/migrations/124.sql
index 96ae46341..96ae46341 100644
--- a/schema/versions/mysql/124.sql
+++ b/sql/mysql/migrations/124.sql
diff --git a/schema/versions/mysql/125.sql b/sql/mysql/migrations/125.sql
index 9f004d963..9f004d963 100644
--- a/schema/versions/mysql/125.sql
+++ b/sql/mysql/migrations/125.sql
diff --git a/schema/versions/mysql/126.sql b/sql/mysql/migrations/126.sql
index 6ff661e71..6ff661e71 100644
--- a/schema/versions/mysql/126.sql
+++ b/sql/mysql/migrations/126.sql
diff --git a/schema/versions/mysql/127.sql b/sql/mysql/migrations/127.sql
index 2c521d86c..2c521d86c 100644
--- a/schema/versions/mysql/127.sql
+++ b/sql/mysql/migrations/127.sql
diff --git a/schema/versions/mysql/128.sql b/sql/mysql/migrations/128.sql
index 281379bb0..281379bb0 100644
--- a/schema/versions/mysql/128.sql
+++ b/sql/mysql/migrations/128.sql
diff --git a/schema/versions/mysql/129.sql b/sql/mysql/migrations/129.sql
index 2ebec0dc9..2ebec0dc9 100644
--- a/schema/versions/mysql/129.sql
+++ b/sql/mysql/migrations/129.sql
diff --git a/schema/versions/mysql/13.sql b/sql/mysql/migrations/13.sql
index ad068c8a2..ad068c8a2 100644
--- a/schema/versions/mysql/13.sql
+++ b/sql/mysql/migrations/13.sql
diff --git a/schema/versions/mysql/130.sql b/sql/mysql/migrations/130.sql
index 7b90d4d2c..7b90d4d2c 100644
--- a/schema/versions/mysql/130.sql
+++ b/sql/mysql/migrations/130.sql
diff --git a/schema/versions/mysql/131.sql b/sql/mysql/migrations/131.sql
index 9316b7f41..9316b7f41 100644
--- a/schema/versions/mysql/131.sql
+++ b/sql/mysql/migrations/131.sql
diff --git a/schema/versions/mysql/132.sql b/sql/mysql/migrations/132.sql
index 1f1fb5901..1f1fb5901 100644
--- a/schema/versions/mysql/132.sql
+++ b/sql/mysql/migrations/132.sql
diff --git a/schema/versions/mysql/133.sql b/sql/mysql/migrations/133.sql
index e1693a9cb..e1693a9cb 100644
--- a/schema/versions/mysql/133.sql
+++ b/sql/mysql/migrations/133.sql
diff --git a/schema/versions/mysql/134.sql b/sql/mysql/migrations/134.sql
index 7bbd7662d..7bbd7662d 100644
--- a/schema/versions/mysql/134.sql
+++ b/sql/mysql/migrations/134.sql
diff --git a/schema/versions/mysql/135.sql b/sql/mysql/migrations/135.sql
index 6d9d41ba6..6d9d41ba6 100644
--- a/schema/versions/mysql/135.sql
+++ b/sql/mysql/migrations/135.sql
diff --git a/schema/versions/mysql/136.sql b/sql/mysql/migrations/136.sql
index 05506a568..05506a568 100644
--- a/schema/versions/mysql/136.sql
+++ b/sql/mysql/migrations/136.sql
diff --git a/schema/versions/mysql/137.sql b/sql/mysql/migrations/137.sql
index 45e4de02f..45e4de02f 100644
--- a/schema/versions/mysql/137.sql
+++ b/sql/mysql/migrations/137.sql
diff --git a/schema/versions/mysql/138.sql b/sql/mysql/migrations/138.sql
index 6bfc5bcd5..6bfc5bcd5 100644
--- a/schema/versions/mysql/138.sql
+++ b/sql/mysql/migrations/138.sql
diff --git a/schema/versions/mysql/139.sql b/sql/mysql/migrations/139.sql
index 88dfb69c7..88dfb69c7 100644
--- a/schema/versions/mysql/139.sql
+++ b/sql/mysql/migrations/139.sql
diff --git a/schema/versions/mysql/14.sql b/sql/mysql/migrations/14.sql
index 8e7cc4dd5..8e7cc4dd5 100644
--- a/schema/versions/mysql/14.sql
+++ b/sql/mysql/migrations/14.sql
diff --git a/schema/versions/mysql/140.sql b/sql/mysql/migrations/140.sql
index 91215eff1..91215eff1 100644
--- a/schema/versions/mysql/140.sql
+++ b/sql/mysql/migrations/140.sql
diff --git a/schema/versions/mysql/141.sql b/sql/mysql/migrations/141.sql
index 03caf23d0..03caf23d0 100644
--- a/schema/versions/mysql/141.sql
+++ b/sql/mysql/migrations/141.sql
diff --git a/schema/versions/mysql/142.sql b/sql/mysql/migrations/142.sql
index 7a75f3f52..7a75f3f52 100644
--- a/schema/versions/mysql/142.sql
+++ b/sql/mysql/migrations/142.sql
diff --git a/schema/versions/mysql/15.sql b/sql/mysql/migrations/15.sql
index 9fa183a09..9fa183a09 100644
--- a/schema/versions/mysql/15.sql
+++ b/sql/mysql/migrations/15.sql
diff --git a/schema/versions/mysql/16.sql b/sql/mysql/migrations/16.sql
index 00034df33..00034df33 100644
--- a/schema/versions/mysql/16.sql
+++ b/sql/mysql/migrations/16.sql
diff --git a/schema/versions/mysql/17.sql b/sql/mysql/migrations/17.sql
index f5d39f33d..f5d39f33d 100644
--- a/schema/versions/mysql/17.sql
+++ b/sql/mysql/migrations/17.sql
diff --git a/schema/versions/mysql/18.sql b/sql/mysql/migrations/18.sql
index e03c96fd0..e03c96fd0 100644
--- a/schema/versions/mysql/18.sql
+++ b/sql/mysql/migrations/18.sql
diff --git a/schema/versions/mysql/19.sql b/sql/mysql/migrations/19.sql
index ce727174b..ce727174b 100644
--- a/schema/versions/mysql/19.sql
+++ b/sql/mysql/migrations/19.sql
diff --git a/schema/versions/mysql/20.sql b/sql/mysql/migrations/20.sql
index 347654512..347654512 100644
--- a/schema/versions/mysql/20.sql
+++ b/sql/mysql/migrations/20.sql
diff --git a/schema/versions/mysql/21.sql b/sql/mysql/migrations/21.sql
index f64d82228..f64d82228 100644
--- a/schema/versions/mysql/21.sql
+++ b/sql/mysql/migrations/21.sql
diff --git a/schema/versions/mysql/22.sql b/sql/mysql/migrations/22.sql
index 7b4457887..7b4457887 100644
--- a/schema/versions/mysql/22.sql
+++ b/sql/mysql/migrations/22.sql
diff --git a/schema/versions/mysql/23.sql b/sql/mysql/migrations/23.sql
index fe54e757d..fe54e757d 100644
--- a/schema/versions/mysql/23.sql
+++ b/sql/mysql/migrations/23.sql
diff --git a/schema/versions/mysql/24.sql b/sql/mysql/migrations/24.sql
index f24e34062..f24e34062 100644
--- a/schema/versions/mysql/24.sql
+++ b/sql/mysql/migrations/24.sql
diff --git a/schema/versions/mysql/25.sql b/sql/mysql/migrations/25.sql
index c3f3d5ea4..c3f3d5ea4 100644
--- a/schema/versions/mysql/25.sql
+++ b/sql/mysql/migrations/25.sql
diff --git a/schema/versions/mysql/26.sql b/sql/mysql/migrations/26.sql
index 14d62b8c0..14d62b8c0 100644
--- a/schema/versions/mysql/26.sql
+++ b/sql/mysql/migrations/26.sql
diff --git a/schema/versions/mysql/27.sql b/sql/mysql/migrations/27.sql
index fcd6e8509..fcd6e8509 100644
--- a/schema/versions/mysql/27.sql
+++ b/sql/mysql/migrations/27.sql
diff --git a/schema/versions/mysql/28.sql b/sql/mysql/migrations/28.sql
index ffdf8448e..ffdf8448e 100644
--- a/schema/versions/mysql/28.sql
+++ b/sql/mysql/migrations/28.sql
diff --git a/schema/versions/mysql/29.sql b/sql/mysql/migrations/29.sql
index 89b5e94a0..89b5e94a0 100644
--- a/schema/versions/mysql/29.sql
+++ b/sql/mysql/migrations/29.sql
diff --git a/schema/versions/mysql/3.sql b/sql/mysql/migrations/3.sql
index 79860a29c..79860a29c 100644
--- a/schema/versions/mysql/3.sql
+++ b/sql/mysql/migrations/3.sql
diff --git a/schema/versions/mysql/30.sql b/sql/mysql/migrations/30.sql
index 0cff2018a..0cff2018a 100644
--- a/schema/versions/mysql/30.sql
+++ b/sql/mysql/migrations/30.sql
diff --git a/schema/versions/mysql/31.sql b/sql/mysql/migrations/31.sql
index 94cfc14d8..94cfc14d8 100644
--- a/schema/versions/mysql/31.sql
+++ b/sql/mysql/migrations/31.sql
diff --git a/schema/versions/mysql/32.sql b/sql/mysql/migrations/32.sql
index 689e5072c..689e5072c 100644
--- a/schema/versions/mysql/32.sql
+++ b/sql/mysql/migrations/32.sql
diff --git a/schema/versions/mysql/33.sql b/sql/mysql/migrations/33.sql
index 8317dc2de..8317dc2de 100644
--- a/schema/versions/mysql/33.sql
+++ b/sql/mysql/migrations/33.sql
diff --git a/schema/versions/mysql/34.sql b/sql/mysql/migrations/34.sql
index e591a7a96..e591a7a96 100644
--- a/schema/versions/mysql/34.sql
+++ b/sql/mysql/migrations/34.sql
diff --git a/schema/versions/mysql/35.sql b/sql/mysql/migrations/35.sql
index ad112a021..ad112a021 100644
--- a/schema/versions/mysql/35.sql
+++ b/sql/mysql/migrations/35.sql
diff --git a/schema/versions/mysql/36.sql b/sql/mysql/migrations/36.sql
index d92da2880..d92da2880 100644
--- a/schema/versions/mysql/36.sql
+++ b/sql/mysql/migrations/36.sql
diff --git a/schema/versions/mysql/37.sql b/sql/mysql/migrations/37.sql
index 4e764d7ee..4e764d7ee 100644
--- a/schema/versions/mysql/37.sql
+++ b/sql/mysql/migrations/37.sql
diff --git a/schema/versions/mysql/38.sql b/sql/mysql/migrations/38.sql
index df544d03b..df544d03b 100644
--- a/schema/versions/mysql/38.sql
+++ b/sql/mysql/migrations/38.sql
diff --git a/schema/versions/mysql/39.sql b/sql/mysql/migrations/39.sql
index f27db09d6..f27db09d6 100644
--- a/schema/versions/mysql/39.sql
+++ b/sql/mysql/migrations/39.sql
diff --git a/schema/versions/mysql/4.sql b/sql/mysql/migrations/4.sql
index 6dfc5f82f..6dfc5f82f 100644
--- a/schema/versions/mysql/4.sql
+++ b/sql/mysql/migrations/4.sql
diff --git a/schema/versions/mysql/40.sql b/sql/mysql/migrations/40.sql
index 5a506cea6..5a506cea6 100644
--- a/schema/versions/mysql/40.sql
+++ b/sql/mysql/migrations/40.sql
diff --git a/schema/versions/mysql/41.sql b/sql/mysql/migrations/41.sql
index bf5887336..bf5887336 100644
--- a/schema/versions/mysql/41.sql
+++ b/sql/mysql/migrations/41.sql
diff --git a/schema/versions/mysql/42.sql b/sql/mysql/migrations/42.sql
index 3ae211d07..3ae211d07 100644
--- a/schema/versions/mysql/42.sql
+++ b/sql/mysql/migrations/42.sql
diff --git a/schema/versions/mysql/43.sql b/sql/mysql/migrations/43.sql
index f1344b203..f1344b203 100644
--- a/schema/versions/mysql/43.sql
+++ b/sql/mysql/migrations/43.sql
diff --git a/schema/versions/mysql/44.sql b/sql/mysql/migrations/44.sql
index c17bcc38f..c17bcc38f 100644
--- a/schema/versions/mysql/44.sql
+++ b/sql/mysql/migrations/44.sql
diff --git a/schema/versions/mysql/45.sql b/sql/mysql/migrations/45.sql
index c4b91cf48..c4b91cf48 100644
--- a/schema/versions/mysql/45.sql
+++ b/sql/mysql/migrations/45.sql
diff --git a/schema/versions/mysql/46.sql b/sql/mysql/migrations/46.sql
index 8bf25629a..8bf25629a 100644
--- a/schema/versions/mysql/46.sql
+++ b/sql/mysql/migrations/46.sql
diff --git a/schema/versions/mysql/47.sql b/sql/mysql/migrations/47.sql
index a3afd94c5..a3afd94c5 100644
--- a/schema/versions/mysql/47.sql
+++ b/sql/mysql/migrations/47.sql
diff --git a/schema/versions/mysql/48.sql b/sql/mysql/migrations/48.sql
index 8c42f6e27..8c42f6e27 100644
--- a/schema/versions/mysql/48.sql
+++ b/sql/mysql/migrations/48.sql
diff --git a/schema/versions/mysql/49.sql b/sql/mysql/migrations/49.sql
index 812f3e65b..812f3e65b 100644
--- a/schema/versions/mysql/49.sql
+++ b/sql/mysql/migrations/49.sql
diff --git a/schema/versions/mysql/5.sql b/sql/mysql/migrations/5.sql
index 1d8b8537b..1d8b8537b 100644
--- a/schema/versions/mysql/5.sql
+++ b/sql/mysql/migrations/5.sql
diff --git a/schema/versions/mysql/50.sql b/sql/mysql/migrations/50.sql
index 6f49742f4..6f49742f4 100644
--- a/schema/versions/mysql/50.sql
+++ b/sql/mysql/migrations/50.sql
diff --git a/schema/versions/mysql/51.sql b/sql/mysql/migrations/51.sql
index e8fe4c7b8..e8fe4c7b8 100644
--- a/schema/versions/mysql/51.sql
+++ b/sql/mysql/migrations/51.sql
diff --git a/schema/versions/mysql/52.sql b/sql/mysql/migrations/52.sql
index 4d9b64eb1..4d9b64eb1 100644
--- a/schema/versions/mysql/52.sql
+++ b/sql/mysql/migrations/52.sql
diff --git a/schema/versions/mysql/53.sql b/sql/mysql/migrations/53.sql
index 3db0cbd81..3db0cbd81 100644
--- a/schema/versions/mysql/53.sql
+++ b/sql/mysql/migrations/53.sql
diff --git a/schema/versions/mysql/54.sql b/sql/mysql/migrations/54.sql
index 28d3f8ee4..28d3f8ee4 100644
--- a/schema/versions/mysql/54.sql
+++ b/sql/mysql/migrations/54.sql
diff --git a/schema/versions/mysql/55.sql b/sql/mysql/migrations/55.sql
index 75f55b3c3..75f55b3c3 100644
--- a/schema/versions/mysql/55.sql
+++ b/sql/mysql/migrations/55.sql
diff --git a/schema/versions/mysql/56.sql b/sql/mysql/migrations/56.sql
index 11cd3069c..11cd3069c 100644
--- a/schema/versions/mysql/56.sql
+++ b/sql/mysql/migrations/56.sql
diff --git a/schema/versions/mysql/57.sql b/sql/mysql/migrations/57.sql
index 27a66d5b7..27a66d5b7 100644
--- a/schema/versions/mysql/57.sql
+++ b/sql/mysql/migrations/57.sql
diff --git a/schema/versions/mysql/58.sql b/sql/mysql/migrations/58.sql
index 61173c1d5..61173c1d5 100644
--- a/schema/versions/mysql/58.sql
+++ b/sql/mysql/migrations/58.sql
diff --git a/schema/versions/mysql/59.sql b/sql/mysql/migrations/59.sql
index d51fe8f65..d51fe8f65 100644
--- a/schema/versions/mysql/59.sql
+++ b/sql/mysql/migrations/59.sql
diff --git a/schema/versions/mysql/6.sql b/sql/mysql/migrations/6.sql
index b7ee97ccc..b7ee97ccc 100644
--- a/schema/versions/mysql/6.sql
+++ b/sql/mysql/migrations/6.sql
diff --git a/schema/versions/mysql/60.sql b/sql/mysql/migrations/60.sql
index 6b33e6c87..6b33e6c87 100644
--- a/schema/versions/mysql/60.sql
+++ b/sql/mysql/migrations/60.sql
diff --git a/schema/versions/mysql/61.sql b/sql/mysql/migrations/61.sql
index 209a7ba55..209a7ba55 100644
--- a/schema/versions/mysql/61.sql
+++ b/sql/mysql/migrations/61.sql
diff --git a/schema/versions/mysql/62.sql b/sql/mysql/migrations/62.sql
index 4cc904b0a..4cc904b0a 100644
--- a/schema/versions/mysql/62.sql
+++ b/sql/mysql/migrations/62.sql
diff --git a/schema/versions/mysql/63.sql b/sql/mysql/migrations/63.sql
index 26b7126e7..26b7126e7 100644
--- a/schema/versions/mysql/63.sql
+++ b/sql/mysql/migrations/63.sql
diff --git a/schema/versions/mysql/64.sql b/sql/mysql/migrations/64.sql
index 51f0be7e2..51f0be7e2 100644
--- a/schema/versions/mysql/64.sql
+++ b/sql/mysql/migrations/64.sql
diff --git a/schema/versions/mysql/65.sql b/sql/mysql/migrations/65.sql
index ce21de898..ce21de898 100644
--- a/schema/versions/mysql/65.sql
+++ b/sql/mysql/migrations/65.sql
diff --git a/schema/versions/mysql/66.sql b/sql/mysql/migrations/66.sql
index f90c0a157..f90c0a157 100644
--- a/schema/versions/mysql/66.sql
+++ b/sql/mysql/migrations/66.sql
diff --git a/schema/versions/mysql/67.sql b/sql/mysql/migrations/67.sql
index b501bf4c3..b501bf4c3 100644
--- a/schema/versions/mysql/67.sql
+++ b/sql/mysql/migrations/67.sql
diff --git a/schema/versions/mysql/68.sql b/sql/mysql/migrations/68.sql
index 6d56df0f9..6d56df0f9 100644
--- a/schema/versions/mysql/68.sql
+++ b/sql/mysql/migrations/68.sql
diff --git a/schema/versions/mysql/69.sql b/sql/mysql/migrations/69.sql
index 3e42fd3fb..3e42fd3fb 100644
--- a/schema/versions/mysql/69.sql
+++ b/sql/mysql/migrations/69.sql
diff --git a/schema/versions/mysql/7.sql b/sql/mysql/migrations/7.sql
index bee135989..bee135989 100644
--- a/schema/versions/mysql/7.sql
+++ b/sql/mysql/migrations/7.sql
diff --git a/schema/versions/mysql/70.sql b/sql/mysql/migrations/70.sql
index 0c64336d4..0c64336d4 100644
--- a/schema/versions/mysql/70.sql
+++ b/sql/mysql/migrations/70.sql
diff --git a/schema/versions/mysql/71.sql b/sql/mysql/migrations/71.sql
index 2061ada2b..2061ada2b 100644
--- a/schema/versions/mysql/71.sql
+++ b/sql/mysql/migrations/71.sql
diff --git a/schema/versions/mysql/72.sql b/sql/mysql/migrations/72.sql
index 2995afda3..2995afda3 100644
--- a/schema/versions/mysql/72.sql
+++ b/sql/mysql/migrations/72.sql
diff --git a/schema/versions/mysql/73.sql b/sql/mysql/migrations/73.sql
index 051578d22..051578d22 100644
--- a/schema/versions/mysql/73.sql
+++ b/sql/mysql/migrations/73.sql
diff --git a/schema/versions/mysql/74.sql b/sql/mysql/migrations/74.sql
index d13856ea9..d13856ea9 100644
--- a/schema/versions/mysql/74.sql
+++ b/sql/mysql/migrations/74.sql
diff --git a/schema/versions/mysql/75.sql b/sql/mysql/migrations/75.sql
index c9017b9e9..c9017b9e9 100644
--- a/schema/versions/mysql/75.sql
+++ b/sql/mysql/migrations/75.sql
diff --git a/schema/versions/mysql/76.sql b/sql/mysql/migrations/76.sql
index 95c352b45..95c352b45 100644
--- a/schema/versions/mysql/76.sql
+++ b/sql/mysql/migrations/76.sql
diff --git a/schema/versions/mysql/77.sql b/sql/mysql/migrations/77.sql
index 944f31d84..944f31d84 100644
--- a/schema/versions/mysql/77.sql
+++ b/sql/mysql/migrations/77.sql
diff --git a/schema/versions/mysql/78.sql b/sql/mysql/migrations/78.sql
index 80e9e782a..80e9e782a 100644
--- a/schema/versions/mysql/78.sql
+++ b/sql/mysql/migrations/78.sql
diff --git a/schema/versions/mysql/79.sql b/sql/mysql/migrations/79.sql
index 7e8c31d49..7e8c31d49 100644
--- a/schema/versions/mysql/79.sql
+++ b/sql/mysql/migrations/79.sql
diff --git a/schema/versions/mysql/8.sql b/sql/mysql/migrations/8.sql
index 39100450b..39100450b 100644
--- a/schema/versions/mysql/8.sql
+++ b/sql/mysql/migrations/8.sql
diff --git a/schema/versions/mysql/80.sql b/sql/mysql/migrations/80.sql
index df2295c42..df2295c42 100644
--- a/schema/versions/mysql/80.sql
+++ b/sql/mysql/migrations/80.sql
diff --git a/schema/versions/mysql/81.sql b/sql/mysql/migrations/81.sql
index 800ceede0..800ceede0 100644
--- a/schema/versions/mysql/81.sql
+++ b/sql/mysql/migrations/81.sql
diff --git a/schema/versions/mysql/82.sql b/sql/mysql/migrations/82.sql
index 80ca24e72..80ca24e72 100644
--- a/schema/versions/mysql/82.sql
+++ b/sql/mysql/migrations/82.sql
diff --git a/schema/versions/mysql/83.sql b/sql/mysql/migrations/83.sql
index e6f9a2a7f..e6f9a2a7f 100644
--- a/schema/versions/mysql/83.sql
+++ b/sql/mysql/migrations/83.sql
diff --git a/schema/versions/mysql/84.sql b/sql/mysql/migrations/84.sql
index cc28b7574..cc28b7574 100644
--- a/schema/versions/mysql/84.sql
+++ b/sql/mysql/migrations/84.sql
diff --git a/schema/versions/mysql/85.sql b/sql/mysql/migrations/85.sql
index 70cab0297..70cab0297 100644
--- a/schema/versions/mysql/85.sql
+++ b/sql/mysql/migrations/85.sql
diff --git a/schema/versions/mysql/86.sql b/sql/mysql/migrations/86.sql
index c8979b2af..c8979b2af 100644
--- a/schema/versions/mysql/86.sql
+++ b/sql/mysql/migrations/86.sql
diff --git a/schema/versions/mysql/87.sql b/sql/mysql/migrations/87.sql
index 7ef4630d5..7ef4630d5 100644
--- a/schema/versions/mysql/87.sql
+++ b/sql/mysql/migrations/87.sql
diff --git a/schema/versions/mysql/88.sql b/sql/mysql/migrations/88.sql
index 0abb2ab33..0abb2ab33 100644
--- a/schema/versions/mysql/88.sql
+++ b/sql/mysql/migrations/88.sql
diff --git a/schema/versions/mysql/89.sql b/sql/mysql/migrations/89.sql
index 9727a9c42..9727a9c42 100644
--- a/schema/versions/mysql/89.sql
+++ b/sql/mysql/migrations/89.sql
diff --git a/schema/versions/mysql/9.sql b/sql/mysql/migrations/9.sql
index 546adc2d7..546adc2d7 100644
--- a/schema/versions/mysql/9.sql
+++ b/sql/mysql/migrations/9.sql
diff --git a/schema/versions/mysql/90.sql b/sql/mysql/migrations/90.sql
index b7935535e..b7935535e 100644
--- a/schema/versions/mysql/90.sql
+++ b/sql/mysql/migrations/90.sql
diff --git a/schema/versions/mysql/91.sql b/sql/mysql/migrations/91.sql
index 791d43063..791d43063 100644
--- a/schema/versions/mysql/91.sql
+++ b/sql/mysql/migrations/91.sql
diff --git a/schema/versions/mysql/92.sql b/sql/mysql/migrations/92.sql
index 8ebe81fe0..8ebe81fe0 100644
--- a/schema/versions/mysql/92.sql
+++ b/sql/mysql/migrations/92.sql
diff --git a/schema/versions/mysql/93.sql b/sql/mysql/migrations/93.sql
index 56b96e3b5..56b96e3b5 100644
--- a/schema/versions/mysql/93.sql
+++ b/sql/mysql/migrations/93.sql
diff --git a/schema/versions/mysql/94.sql b/sql/mysql/migrations/94.sql
index 0f76c4c5f..0f76c4c5f 100644
--- a/schema/versions/mysql/94.sql
+++ b/sql/mysql/migrations/94.sql
diff --git a/schema/versions/mysql/95.sql b/sql/mysql/migrations/95.sql
index 234acd495..234acd495 100644
--- a/schema/versions/mysql/95.sql
+++ b/sql/mysql/migrations/95.sql
diff --git a/schema/versions/mysql/96.sql b/sql/mysql/migrations/96.sql
index 4d4e2445c..4d4e2445c 100644
--- a/schema/versions/mysql/96.sql
+++ b/sql/mysql/migrations/96.sql
diff --git a/schema/versions/mysql/97.sql b/sql/mysql/migrations/97.sql
index c555b86dc..c555b86dc 100644
--- a/schema/versions/mysql/97.sql
+++ b/sql/mysql/migrations/97.sql
diff --git a/schema/versions/mysql/98.sql b/sql/mysql/migrations/98.sql
index 1984a4325..1984a4325 100644
--- a/schema/versions/mysql/98.sql
+++ b/sql/mysql/migrations/98.sql
diff --git a/schema/versions/mysql/99.sql b/sql/mysql/migrations/99.sql
index d7f9e0230..d7f9e0230 100644
--- a/schema/versions/mysql/99.sql
+++ b/sql/mysql/migrations/99.sql
diff --git a/schema/ttrss_schema_mysql.sql b/sql/mysql/schema.sql
index a3fbc827d..a3fbc827d 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/sql/mysql/schema.sql
diff --git a/schema/versions/pgsql/10.sql b/sql/pgsql/migrations/10.sql
index 764b4b763..764b4b763 100644
--- a/schema/versions/pgsql/10.sql
+++ b/sql/pgsql/migrations/10.sql
diff --git a/schema/versions/pgsql/100.sql b/sql/pgsql/migrations/100.sql
index a360dab6c..a360dab6c 100644
--- a/schema/versions/pgsql/100.sql
+++ b/sql/pgsql/migrations/100.sql
diff --git a/schema/versions/pgsql/101.sql b/sql/pgsql/migrations/101.sql
index 5be859002..5be859002 100644
--- a/schema/versions/pgsql/101.sql
+++ b/sql/pgsql/migrations/101.sql
diff --git a/schema/versions/pgsql/102.sql b/sql/pgsql/migrations/102.sql
index ccf5ef3b3..ccf5ef3b3 100644
--- a/schema/versions/pgsql/102.sql
+++ b/sql/pgsql/migrations/102.sql
diff --git a/schema/versions/pgsql/103.sql b/sql/pgsql/migrations/103.sql
index cb91fd871..cb91fd871 100644
--- a/schema/versions/pgsql/103.sql
+++ b/sql/pgsql/migrations/103.sql
diff --git a/schema/versions/pgsql/104.sql b/sql/pgsql/migrations/104.sql
index 104e4b917..104e4b917 100644
--- a/schema/versions/pgsql/104.sql
+++ b/sql/pgsql/migrations/104.sql
diff --git a/schema/versions/pgsql/105.sql b/sql/pgsql/migrations/105.sql
index 11ef679f1..11ef679f1 100644
--- a/schema/versions/pgsql/105.sql
+++ b/sql/pgsql/migrations/105.sql
diff --git a/schema/versions/pgsql/106.sql b/sql/pgsql/migrations/106.sql
index 6e3dee2c9..6e3dee2c9 100644
--- a/schema/versions/pgsql/106.sql
+++ b/sql/pgsql/migrations/106.sql
diff --git a/schema/versions/pgsql/107.sql b/sql/pgsql/migrations/107.sql
index a4a537c2f..a4a537c2f 100644
--- a/schema/versions/pgsql/107.sql
+++ b/sql/pgsql/migrations/107.sql
diff --git a/schema/versions/pgsql/108.sql b/sql/pgsql/migrations/108.sql
index 899be8bb4..899be8bb4 100644
--- a/schema/versions/pgsql/108.sql
+++ b/sql/pgsql/migrations/108.sql
diff --git a/schema/versions/pgsql/109.sql b/sql/pgsql/migrations/109.sql
index 77e883c3b..77e883c3b 100644
--- a/schema/versions/pgsql/109.sql
+++ b/sql/pgsql/migrations/109.sql
diff --git a/schema/versions/pgsql/11.sql b/sql/pgsql/migrations/11.sql
index 690b978eb..690b978eb 100644
--- a/schema/versions/pgsql/11.sql
+++ b/sql/pgsql/migrations/11.sql
diff --git a/schema/versions/pgsql/110.sql b/sql/pgsql/migrations/110.sql
index 859f7d6dc..859f7d6dc 100644
--- a/schema/versions/pgsql/110.sql
+++ b/sql/pgsql/migrations/110.sql
diff --git a/schema/versions/pgsql/111.sql b/sql/pgsql/migrations/111.sql
index 27f287d1a..27f287d1a 100644
--- a/schema/versions/pgsql/111.sql
+++ b/sql/pgsql/migrations/111.sql
diff --git a/schema/versions/pgsql/112.sql b/sql/pgsql/migrations/112.sql
index a9d90d6d4..a9d90d6d4 100644
--- a/schema/versions/pgsql/112.sql
+++ b/sql/pgsql/migrations/112.sql
diff --git a/schema/versions/pgsql/113.sql b/sql/pgsql/migrations/113.sql
index 3c0d00563..3c0d00563 100644
--- a/schema/versions/pgsql/113.sql
+++ b/sql/pgsql/migrations/113.sql
diff --git a/schema/versions/pgsql/114.sql b/sql/pgsql/migrations/114.sql
index d317ea794..d317ea794 100644
--- a/schema/versions/pgsql/114.sql
+++ b/sql/pgsql/migrations/114.sql
diff --git a/schema/versions/pgsql/115.sql b/sql/pgsql/migrations/115.sql
index e23f0533a..e23f0533a 100644
--- a/schema/versions/pgsql/115.sql
+++ b/sql/pgsql/migrations/115.sql
diff --git a/schema/versions/pgsql/116.sql b/sql/pgsql/migrations/116.sql
index 252ba0e3a..252ba0e3a 100644
--- a/schema/versions/pgsql/116.sql
+++ b/sql/pgsql/migrations/116.sql
diff --git a/schema/versions/pgsql/117.sql b/sql/pgsql/migrations/117.sql
index da3d056cc..da3d056cc 100644
--- a/schema/versions/pgsql/117.sql
+++ b/sql/pgsql/migrations/117.sql
diff --git a/schema/versions/pgsql/118.sql b/sql/pgsql/migrations/118.sql
index 161cf4e3c..161cf4e3c 100644
--- a/schema/versions/pgsql/118.sql
+++ b/sql/pgsql/migrations/118.sql
diff --git a/schema/versions/pgsql/119.sql b/sql/pgsql/migrations/119.sql
index ddb7d64de..ddb7d64de 100644
--- a/schema/versions/pgsql/119.sql
+++ b/sql/pgsql/migrations/119.sql
diff --git a/schema/versions/pgsql/12.sql b/sql/pgsql/migrations/12.sql
index 6de90f1ab..6de90f1ab 100644
--- a/schema/versions/pgsql/12.sql
+++ b/sql/pgsql/migrations/12.sql
diff --git a/schema/versions/pgsql/120.sql b/sql/pgsql/migrations/120.sql
index 34971146e..34971146e 100644
--- a/schema/versions/pgsql/120.sql
+++ b/sql/pgsql/migrations/120.sql
diff --git a/schema/versions/pgsql/121.sql b/sql/pgsql/migrations/121.sql
index d9cf51184..d9cf51184 100644
--- a/schema/versions/pgsql/121.sql
+++ b/sql/pgsql/migrations/121.sql
diff --git a/schema/versions/pgsql/122.sql b/sql/pgsql/migrations/122.sql
index 397b97bfc..397b97bfc 100644
--- a/schema/versions/pgsql/122.sql
+++ b/sql/pgsql/migrations/122.sql
diff --git a/schema/versions/pgsql/123.sql b/sql/pgsql/migrations/123.sql
index 999d48bf7..999d48bf7 100644
--- a/schema/versions/pgsql/123.sql
+++ b/sql/pgsql/migrations/123.sql
diff --git a/schema/versions/pgsql/124.sql b/sql/pgsql/migrations/124.sql
index 96ae46341..96ae46341 100644
--- a/schema/versions/pgsql/124.sql
+++ b/sql/pgsql/migrations/124.sql
diff --git a/schema/versions/pgsql/125.sql b/sql/pgsql/migrations/125.sql
index e56e0299a..e56e0299a 100644
--- a/schema/versions/pgsql/125.sql
+++ b/sql/pgsql/migrations/125.sql
diff --git a/schema/versions/pgsql/126.sql b/sql/pgsql/migrations/126.sql
index 46f391aa5..46f391aa5 100644
--- a/schema/versions/pgsql/126.sql
+++ b/sql/pgsql/migrations/126.sql
diff --git a/schema/versions/pgsql/127.sql b/sql/pgsql/migrations/127.sql
index 7895aacc0..7895aacc0 100644
--- a/schema/versions/pgsql/127.sql
+++ b/sql/pgsql/migrations/127.sql
diff --git a/schema/versions/pgsql/128.sql b/sql/pgsql/migrations/128.sql
index 3aba67220..3aba67220 100644
--- a/schema/versions/pgsql/128.sql
+++ b/sql/pgsql/migrations/128.sql
diff --git a/schema/versions/pgsql/129.sql b/sql/pgsql/migrations/129.sql
index 2ebec0dc9..2ebec0dc9 100644
--- a/schema/versions/pgsql/129.sql
+++ b/sql/pgsql/migrations/129.sql
diff --git a/schema/versions/pgsql/13.sql b/sql/pgsql/migrations/13.sql
index bf2a2b438..bf2a2b438 100644
--- a/schema/versions/pgsql/13.sql
+++ b/sql/pgsql/migrations/13.sql
diff --git a/schema/versions/pgsql/130.sql b/sql/pgsql/migrations/130.sql
index 820f0b6a8..820f0b6a8 100644
--- a/schema/versions/pgsql/130.sql
+++ b/sql/pgsql/migrations/130.sql
diff --git a/schema/versions/pgsql/131.sql b/sql/pgsql/migrations/131.sql
index 9b3001221..9b3001221 100644
--- a/schema/versions/pgsql/131.sql
+++ b/sql/pgsql/migrations/131.sql
diff --git a/schema/versions/pgsql/132.sql b/sql/pgsql/migrations/132.sql
index e6b4bd13f..e6b4bd13f 100644
--- a/schema/versions/pgsql/132.sql
+++ b/sql/pgsql/migrations/132.sql
diff --git a/schema/versions/pgsql/133.sql b/sql/pgsql/migrations/133.sql
index 7bf2f9fa6..7bf2f9fa6 100644
--- a/schema/versions/pgsql/133.sql
+++ b/sql/pgsql/migrations/133.sql
diff --git a/schema/versions/pgsql/134.sql b/sql/pgsql/migrations/134.sql
index 036abb126..036abb126 100644
--- a/schema/versions/pgsql/134.sql
+++ b/sql/pgsql/migrations/134.sql
diff --git a/schema/versions/pgsql/135.sql b/sql/pgsql/migrations/135.sql
index b1ec70505..b1ec70505 100644
--- a/schema/versions/pgsql/135.sql
+++ b/sql/pgsql/migrations/135.sql
diff --git a/schema/versions/pgsql/136.sql b/sql/pgsql/migrations/136.sql
index d74136537..d74136537 100644
--- a/schema/versions/pgsql/136.sql
+++ b/sql/pgsql/migrations/136.sql
diff --git a/schema/versions/pgsql/137.sql b/sql/pgsql/migrations/137.sql
index 71b67327e..71b67327e 100644
--- a/schema/versions/pgsql/137.sql
+++ b/sql/pgsql/migrations/137.sql
diff --git a/schema/versions/pgsql/138.sql b/sql/pgsql/migrations/138.sql
index 6bfc5bcd5..6bfc5bcd5 100644
--- a/schema/versions/pgsql/138.sql
+++ b/sql/pgsql/migrations/138.sql
diff --git a/schema/versions/pgsql/139.sql b/sql/pgsql/migrations/139.sql
index b2617390c..b2617390c 100644
--- a/schema/versions/pgsql/139.sql
+++ b/sql/pgsql/migrations/139.sql
diff --git a/schema/versions/pgsql/14.sql b/sql/pgsql/migrations/14.sql
index 8e7cc4dd5..8e7cc4dd5 100644
--- a/schema/versions/pgsql/14.sql
+++ b/sql/pgsql/migrations/14.sql
diff --git a/schema/versions/pgsql/140.sql b/sql/pgsql/migrations/140.sql
index 985e30241..985e30241 100644
--- a/schema/versions/pgsql/140.sql
+++ b/sql/pgsql/migrations/140.sql
diff --git a/schema/versions/pgsql/141.sql b/sql/pgsql/migrations/141.sql
index 679ca9498..679ca9498 100644
--- a/schema/versions/pgsql/141.sql
+++ b/sql/pgsql/migrations/141.sql
diff --git a/schema/versions/pgsql/142.sql b/sql/pgsql/migrations/142.sql
index 7a75f3f52..7a75f3f52 100644
--- a/schema/versions/pgsql/142.sql
+++ b/sql/pgsql/migrations/142.sql
diff --git a/schema/versions/pgsql/15.sql b/sql/pgsql/migrations/15.sql
index 9fa183a09..9fa183a09 100644
--- a/schema/versions/pgsql/15.sql
+++ b/sql/pgsql/migrations/15.sql
diff --git a/schema/versions/pgsql/16.sql b/sql/pgsql/migrations/16.sql
index 996e9a5dd..996e9a5dd 100644
--- a/schema/versions/pgsql/16.sql
+++ b/sql/pgsql/migrations/16.sql
diff --git a/schema/versions/pgsql/17.sql b/sql/pgsql/migrations/17.sql
index f5d39f33d..f5d39f33d 100644
--- a/schema/versions/pgsql/17.sql
+++ b/sql/pgsql/migrations/17.sql
diff --git a/schema/versions/pgsql/18.sql b/sql/pgsql/migrations/18.sql
index e03c96fd0..e03c96fd0 100644
--- a/schema/versions/pgsql/18.sql
+++ b/sql/pgsql/migrations/18.sql
diff --git a/schema/versions/pgsql/19.sql b/sql/pgsql/migrations/19.sql
index 15c12ca33..15c12ca33 100644
--- a/schema/versions/pgsql/19.sql
+++ b/sql/pgsql/migrations/19.sql
diff --git a/schema/versions/pgsql/20.sql b/sql/pgsql/migrations/20.sql
index 347654512..347654512 100644
--- a/schema/versions/pgsql/20.sql
+++ b/sql/pgsql/migrations/20.sql
diff --git a/schema/versions/pgsql/21.sql b/sql/pgsql/migrations/21.sql
index f64d82228..f64d82228 100644
--- a/schema/versions/pgsql/21.sql
+++ b/sql/pgsql/migrations/21.sql
diff --git a/schema/versions/pgsql/22.sql b/sql/pgsql/migrations/22.sql
index 96e67e4a0..96e67e4a0 100644
--- a/schema/versions/pgsql/22.sql
+++ b/sql/pgsql/migrations/22.sql
diff --git a/schema/versions/pgsql/23.sql b/sql/pgsql/migrations/23.sql
index fe54e757d..fe54e757d 100644
--- a/schema/versions/pgsql/23.sql
+++ b/sql/pgsql/migrations/23.sql
diff --git a/schema/versions/pgsql/24.sql b/sql/pgsql/migrations/24.sql
index f24e34062..f24e34062 100644
--- a/schema/versions/pgsql/24.sql
+++ b/sql/pgsql/migrations/24.sql
diff --git a/schema/versions/pgsql/25.sql b/sql/pgsql/migrations/25.sql
index c3f3d5ea4..c3f3d5ea4 100644
--- a/schema/versions/pgsql/25.sql
+++ b/sql/pgsql/migrations/25.sql
diff --git a/schema/versions/pgsql/26.sql b/sql/pgsql/migrations/26.sql
index c7c1be691..c7c1be691 100644
--- a/schema/versions/pgsql/26.sql
+++ b/sql/pgsql/migrations/26.sql
diff --git a/schema/versions/pgsql/27.sql b/sql/pgsql/migrations/27.sql
index d0baaebc0..d0baaebc0 100644
--- a/schema/versions/pgsql/27.sql
+++ b/sql/pgsql/migrations/27.sql
diff --git a/schema/versions/pgsql/28.sql b/sql/pgsql/migrations/28.sql
index ffdf8448e..ffdf8448e 100644
--- a/schema/versions/pgsql/28.sql
+++ b/sql/pgsql/migrations/28.sql
diff --git a/schema/versions/pgsql/29.sql b/sql/pgsql/migrations/29.sql
index 89b5e94a0..89b5e94a0 100644
--- a/schema/versions/pgsql/29.sql
+++ b/sql/pgsql/migrations/29.sql
diff --git a/schema/versions/pgsql/3.sql b/sql/pgsql/migrations/3.sql
index 5b23f3366..5b23f3366 100644
--- a/schema/versions/pgsql/3.sql
+++ b/sql/pgsql/migrations/3.sql
diff --git a/schema/versions/pgsql/30.sql b/sql/pgsql/migrations/30.sql
index d83eee1f1..d83eee1f1 100644
--- a/schema/versions/pgsql/30.sql
+++ b/sql/pgsql/migrations/30.sql
diff --git a/schema/versions/pgsql/31.sql b/sql/pgsql/migrations/31.sql
index e8d6bdb4a..e8d6bdb4a 100644
--- a/schema/versions/pgsql/31.sql
+++ b/sql/pgsql/migrations/31.sql
diff --git a/schema/versions/pgsql/32.sql b/sql/pgsql/migrations/32.sql
index 30565555e..30565555e 100644
--- a/schema/versions/pgsql/32.sql
+++ b/sql/pgsql/migrations/32.sql
diff --git a/schema/versions/pgsql/33.sql b/sql/pgsql/migrations/33.sql
index 8317dc2de..8317dc2de 100644
--- a/schema/versions/pgsql/33.sql
+++ b/sql/pgsql/migrations/33.sql
diff --git a/schema/versions/pgsql/34.sql b/sql/pgsql/migrations/34.sql
index c8733d430..c8733d430 100644
--- a/schema/versions/pgsql/34.sql
+++ b/sql/pgsql/migrations/34.sql
diff --git a/schema/versions/pgsql/35.sql b/sql/pgsql/migrations/35.sql
index e624d66b3..e624d66b3 100644
--- a/schema/versions/pgsql/35.sql
+++ b/sql/pgsql/migrations/35.sql
diff --git a/schema/versions/pgsql/36.sql b/sql/pgsql/migrations/36.sql
index 1e4a460ee..1e4a460ee 100644
--- a/schema/versions/pgsql/36.sql
+++ b/sql/pgsql/migrations/36.sql
diff --git a/schema/versions/pgsql/37.sql b/sql/pgsql/migrations/37.sql
index 4e764d7ee..4e764d7ee 100644
--- a/schema/versions/pgsql/37.sql
+++ b/sql/pgsql/migrations/37.sql
diff --git a/schema/versions/pgsql/38.sql b/sql/pgsql/migrations/38.sql
index df544d03b..df544d03b 100644
--- a/schema/versions/pgsql/38.sql
+++ b/sql/pgsql/migrations/38.sql
diff --git a/schema/versions/pgsql/39.sql b/sql/pgsql/migrations/39.sql
index f27db09d6..f27db09d6 100644
--- a/schema/versions/pgsql/39.sql
+++ b/sql/pgsql/migrations/39.sql
diff --git a/schema/versions/pgsql/4.sql b/sql/pgsql/migrations/4.sql
index 1f926eaeb..1f926eaeb 100644
--- a/schema/versions/pgsql/4.sql
+++ b/sql/pgsql/migrations/4.sql
diff --git a/schema/versions/pgsql/40.sql b/sql/pgsql/migrations/40.sql
index 5a506cea6..5a506cea6 100644
--- a/schema/versions/pgsql/40.sql
+++ b/sql/pgsql/migrations/40.sql
diff --git a/schema/versions/pgsql/41.sql b/sql/pgsql/migrations/41.sql
index bdb87239b..bdb87239b 100644
--- a/schema/versions/pgsql/41.sql
+++ b/sql/pgsql/migrations/41.sql
diff --git a/schema/versions/pgsql/42.sql b/sql/pgsql/migrations/42.sql
index 3ae211d07..3ae211d07 100644
--- a/schema/versions/pgsql/42.sql
+++ b/sql/pgsql/migrations/42.sql
diff --git a/schema/versions/pgsql/43.sql b/sql/pgsql/migrations/43.sql
index 52bc365cc..52bc365cc 100644
--- a/schema/versions/pgsql/43.sql
+++ b/sql/pgsql/migrations/43.sql
diff --git a/schema/versions/pgsql/44.sql b/sql/pgsql/migrations/44.sql
index a88bfede6..a88bfede6 100644
--- a/schema/versions/pgsql/44.sql
+++ b/sql/pgsql/migrations/44.sql
diff --git a/schema/versions/pgsql/45.sql b/sql/pgsql/migrations/45.sql
index c4b91cf48..c4b91cf48 100644
--- a/schema/versions/pgsql/45.sql
+++ b/sql/pgsql/migrations/45.sql
diff --git a/schema/versions/pgsql/46.sql b/sql/pgsql/migrations/46.sql
index 007824f7a..007824f7a 100644
--- a/schema/versions/pgsql/46.sql
+++ b/sql/pgsql/migrations/46.sql
diff --git a/schema/versions/pgsql/47.sql b/sql/pgsql/migrations/47.sql
index 5dbd6e07e..5dbd6e07e 100644
--- a/schema/versions/pgsql/47.sql
+++ b/sql/pgsql/migrations/47.sql
diff --git a/schema/versions/pgsql/48.sql b/sql/pgsql/migrations/48.sql
index e3a742ace..e3a742ace 100644
--- a/schema/versions/pgsql/48.sql
+++ b/sql/pgsql/migrations/48.sql
diff --git a/schema/versions/pgsql/49.sql b/sql/pgsql/migrations/49.sql
index 6efd91925..6efd91925 100644
--- a/schema/versions/pgsql/49.sql
+++ b/sql/pgsql/migrations/49.sql
diff --git a/schema/versions/pgsql/5.sql b/sql/pgsql/migrations/5.sql
index 1292daa3c..1292daa3c 100644
--- a/schema/versions/pgsql/5.sql
+++ b/sql/pgsql/migrations/5.sql
diff --git a/schema/versions/pgsql/50.sql b/sql/pgsql/migrations/50.sql
index 86846242c..86846242c 100644
--- a/schema/versions/pgsql/50.sql
+++ b/sql/pgsql/migrations/50.sql
diff --git a/schema/versions/pgsql/51.sql b/sql/pgsql/migrations/51.sql
index dd566072b..dd566072b 100644
--- a/schema/versions/pgsql/51.sql
+++ b/sql/pgsql/migrations/51.sql
diff --git a/schema/versions/pgsql/52.sql b/sql/pgsql/migrations/52.sql
index f7165e795..f7165e795 100644
--- a/schema/versions/pgsql/52.sql
+++ b/sql/pgsql/migrations/52.sql
diff --git a/schema/versions/pgsql/53.sql b/sql/pgsql/migrations/53.sql
index adcf6fdec..adcf6fdec 100644
--- a/schema/versions/pgsql/53.sql
+++ b/sql/pgsql/migrations/53.sql
diff --git a/schema/versions/pgsql/54.sql b/sql/pgsql/migrations/54.sql
index 28d3f8ee4..28d3f8ee4 100644
--- a/schema/versions/pgsql/54.sql
+++ b/sql/pgsql/migrations/54.sql
diff --git a/schema/versions/pgsql/55.sql b/sql/pgsql/migrations/55.sql
index 75f55b3c3..75f55b3c3 100644
--- a/schema/versions/pgsql/55.sql
+++ b/sql/pgsql/migrations/55.sql
diff --git a/schema/versions/pgsql/56.sql b/sql/pgsql/migrations/56.sql
index d6d57f03a..d6d57f03a 100644
--- a/schema/versions/pgsql/56.sql
+++ b/sql/pgsql/migrations/56.sql
diff --git a/schema/versions/pgsql/57.sql b/sql/pgsql/migrations/57.sql
index 3dd7898b9..3dd7898b9 100644
--- a/schema/versions/pgsql/57.sql
+++ b/sql/pgsql/migrations/57.sql
diff --git a/schema/versions/pgsql/58.sql b/sql/pgsql/migrations/58.sql
index 61173c1d5..61173c1d5 100644
--- a/schema/versions/pgsql/58.sql
+++ b/sql/pgsql/migrations/58.sql
diff --git a/schema/versions/pgsql/59.sql b/sql/pgsql/migrations/59.sql
index d51fe8f65..d51fe8f65 100644
--- a/schema/versions/pgsql/59.sql
+++ b/sql/pgsql/migrations/59.sql
diff --git a/schema/versions/pgsql/6.sql b/sql/pgsql/migrations/6.sql
index 6c406495d..6c406495d 100644
--- a/schema/versions/pgsql/6.sql
+++ b/sql/pgsql/migrations/6.sql
diff --git a/schema/versions/pgsql/60.sql b/sql/pgsql/migrations/60.sql
index bcf2fdefb..bcf2fdefb 100644
--- a/schema/versions/pgsql/60.sql
+++ b/sql/pgsql/migrations/60.sql
diff --git a/schema/versions/pgsql/61.sql b/sql/pgsql/migrations/61.sql
index 209a7ba55..209a7ba55 100644
--- a/schema/versions/pgsql/61.sql
+++ b/sql/pgsql/migrations/61.sql
diff --git a/schema/versions/pgsql/62.sql b/sql/pgsql/migrations/62.sql
index 4cc904b0a..4cc904b0a 100644
--- a/schema/versions/pgsql/62.sql
+++ b/sql/pgsql/migrations/62.sql
diff --git a/schema/versions/pgsql/63.sql b/sql/pgsql/migrations/63.sql
index 90bde3154..90bde3154 100644
--- a/schema/versions/pgsql/63.sql
+++ b/sql/pgsql/migrations/63.sql
diff --git a/schema/versions/pgsql/64.sql b/sql/pgsql/migrations/64.sql
index 51f0be7e2..51f0be7e2 100644
--- a/schema/versions/pgsql/64.sql
+++ b/sql/pgsql/migrations/64.sql
diff --git a/schema/versions/pgsql/65.sql b/sql/pgsql/migrations/65.sql
index ce21de898..ce21de898 100644
--- a/schema/versions/pgsql/65.sql
+++ b/sql/pgsql/migrations/65.sql
diff --git a/schema/versions/pgsql/66.sql b/sql/pgsql/migrations/66.sql
index f90c0a157..f90c0a157 100644
--- a/schema/versions/pgsql/66.sql
+++ b/sql/pgsql/migrations/66.sql
diff --git a/schema/versions/pgsql/67.sql b/sql/pgsql/migrations/67.sql
index 1e2aa4429..1e2aa4429 100644
--- a/schema/versions/pgsql/67.sql
+++ b/sql/pgsql/migrations/67.sql
diff --git a/schema/versions/pgsql/68.sql b/sql/pgsql/migrations/68.sql
index 6d56df0f9..6d56df0f9 100644
--- a/schema/versions/pgsql/68.sql
+++ b/sql/pgsql/migrations/68.sql
diff --git a/schema/versions/pgsql/69.sql b/sql/pgsql/migrations/69.sql
index cae0ff50f..cae0ff50f 100644
--- a/schema/versions/pgsql/69.sql
+++ b/sql/pgsql/migrations/69.sql
diff --git a/schema/versions/pgsql/7.sql b/sql/pgsql/migrations/7.sql
index 51437e4fa..51437e4fa 100644
--- a/schema/versions/pgsql/7.sql
+++ b/sql/pgsql/migrations/7.sql
diff --git a/schema/versions/pgsql/70.sql b/sql/pgsql/migrations/70.sql
index b970a861c..b970a861c 100644
--- a/schema/versions/pgsql/70.sql
+++ b/sql/pgsql/migrations/70.sql
diff --git a/schema/versions/pgsql/71.sql b/sql/pgsql/migrations/71.sql
index 2061ada2b..2061ada2b 100644
--- a/schema/versions/pgsql/71.sql
+++ b/sql/pgsql/migrations/71.sql
diff --git a/schema/versions/pgsql/72.sql b/sql/pgsql/migrations/72.sql
index 65e4d2e0a..65e4d2e0a 100644
--- a/schema/versions/pgsql/72.sql
+++ b/sql/pgsql/migrations/72.sql
diff --git a/schema/versions/pgsql/73.sql b/sql/pgsql/migrations/73.sql
index 051578d22..051578d22 100644
--- a/schema/versions/pgsql/73.sql
+++ b/sql/pgsql/migrations/73.sql
diff --git a/schema/versions/pgsql/74.sql b/sql/pgsql/migrations/74.sql
index 22c95c5d3..22c95c5d3 100644
--- a/schema/versions/pgsql/74.sql
+++ b/sql/pgsql/migrations/74.sql
diff --git a/schema/versions/pgsql/75.sql b/sql/pgsql/migrations/75.sql
index 3291d652c..3291d652c 100644
--- a/schema/versions/pgsql/75.sql
+++ b/sql/pgsql/migrations/75.sql
diff --git a/schema/versions/pgsql/76.sql b/sql/pgsql/migrations/76.sql
index b7cc12c7a..b7cc12c7a 100644
--- a/schema/versions/pgsql/76.sql
+++ b/sql/pgsql/migrations/76.sql
diff --git a/schema/versions/pgsql/77.sql b/sql/pgsql/migrations/77.sql
index 944f31d84..944f31d84 100644
--- a/schema/versions/pgsql/77.sql
+++ b/sql/pgsql/migrations/77.sql
diff --git a/schema/versions/pgsql/78.sql b/sql/pgsql/migrations/78.sql
index 80e9e782a..80e9e782a 100644
--- a/schema/versions/pgsql/78.sql
+++ b/sql/pgsql/migrations/78.sql
diff --git a/schema/versions/pgsql/79.sql b/sql/pgsql/migrations/79.sql
index 7e8c31d49..7e8c31d49 100644
--- a/schema/versions/pgsql/79.sql
+++ b/sql/pgsql/migrations/79.sql
diff --git a/schema/versions/pgsql/8.sql b/sql/pgsql/migrations/8.sql
index ab7a7df33..ab7a7df33 100644
--- a/schema/versions/pgsql/8.sql
+++ b/sql/pgsql/migrations/8.sql
diff --git a/schema/versions/pgsql/80.sql b/sql/pgsql/migrations/80.sql
index df2295c42..df2295c42 100644
--- a/schema/versions/pgsql/80.sql
+++ b/sql/pgsql/migrations/80.sql
diff --git a/schema/versions/pgsql/81.sql b/sql/pgsql/migrations/81.sql
index 800ceede0..800ceede0 100644
--- a/schema/versions/pgsql/81.sql
+++ b/sql/pgsql/migrations/81.sql
diff --git a/schema/versions/pgsql/82.sql b/sql/pgsql/migrations/82.sql
index 80ca24e72..80ca24e72 100644
--- a/schema/versions/pgsql/82.sql
+++ b/sql/pgsql/migrations/82.sql
diff --git a/schema/versions/pgsql/83.sql b/sql/pgsql/migrations/83.sql
index a89086551..a89086551 100644
--- a/schema/versions/pgsql/83.sql
+++ b/sql/pgsql/migrations/83.sql
diff --git a/schema/versions/pgsql/84.sql b/sql/pgsql/migrations/84.sql
index 55a7caf71..55a7caf71 100644
--- a/schema/versions/pgsql/84.sql
+++ b/sql/pgsql/migrations/84.sql
diff --git a/schema/versions/pgsql/85.sql b/sql/pgsql/migrations/85.sql
index a0a782280..a0a782280 100644
--- a/schema/versions/pgsql/85.sql
+++ b/sql/pgsql/migrations/85.sql
diff --git a/schema/versions/pgsql/86.sql b/sql/pgsql/migrations/86.sql
index 1f311b6d7..1f311b6d7 100644
--- a/schema/versions/pgsql/86.sql
+++ b/sql/pgsql/migrations/86.sql
diff --git a/schema/versions/pgsql/87.sql b/sql/pgsql/migrations/87.sql
index 86d0c4f61..86d0c4f61 100644
--- a/schema/versions/pgsql/87.sql
+++ b/sql/pgsql/migrations/87.sql
diff --git a/schema/versions/pgsql/88.sql b/sql/pgsql/migrations/88.sql
index df6ec8fb7..df6ec8fb7 100644
--- a/schema/versions/pgsql/88.sql
+++ b/sql/pgsql/migrations/88.sql
diff --git a/schema/versions/pgsql/89.sql b/sql/pgsql/migrations/89.sql
index 9727a9c42..9727a9c42 100644
--- a/schema/versions/pgsql/89.sql
+++ b/sql/pgsql/migrations/89.sql
diff --git a/schema/versions/pgsql/9.sql b/sql/pgsql/migrations/9.sql
index 9624403aa..9624403aa 100644
--- a/schema/versions/pgsql/9.sql
+++ b/sql/pgsql/migrations/9.sql
diff --git a/schema/versions/pgsql/90.sql b/sql/pgsql/migrations/90.sql
index b7935535e..b7935535e 100644
--- a/schema/versions/pgsql/90.sql
+++ b/sql/pgsql/migrations/90.sql
diff --git a/schema/versions/pgsql/91.sql b/sql/pgsql/migrations/91.sql
index 791d43063..791d43063 100644
--- a/schema/versions/pgsql/91.sql
+++ b/sql/pgsql/migrations/91.sql
diff --git a/schema/versions/pgsql/92.sql b/sql/pgsql/migrations/92.sql
index b683d514d..b683d514d 100644
--- a/schema/versions/pgsql/92.sql
+++ b/sql/pgsql/migrations/92.sql
diff --git a/schema/versions/pgsql/93.sql b/sql/pgsql/migrations/93.sql
index 0374c0b0a..0374c0b0a 100644
--- a/schema/versions/pgsql/93.sql
+++ b/sql/pgsql/migrations/93.sql
diff --git a/schema/versions/pgsql/94.sql b/sql/pgsql/migrations/94.sql
index 0f76c4c5f..0f76c4c5f 100644
--- a/schema/versions/pgsql/94.sql
+++ b/sql/pgsql/migrations/94.sql
diff --git a/schema/versions/pgsql/95.sql b/sql/pgsql/migrations/95.sql
index 014463a85..014463a85 100644
--- a/schema/versions/pgsql/95.sql
+++ b/sql/pgsql/migrations/95.sql
diff --git a/schema/versions/pgsql/96.sql b/sql/pgsql/migrations/96.sql
index e3cdc06be..e3cdc06be 100644
--- a/schema/versions/pgsql/96.sql
+++ b/sql/pgsql/migrations/96.sql
diff --git a/schema/versions/pgsql/97.sql b/sql/pgsql/migrations/97.sql
index f458ee910..f458ee910 100644
--- a/schema/versions/pgsql/97.sql
+++ b/sql/pgsql/migrations/97.sql
diff --git a/schema/versions/pgsql/98.sql b/sql/pgsql/migrations/98.sql
index 1984a4325..1984a4325 100644
--- a/schema/versions/pgsql/98.sql
+++ b/sql/pgsql/migrations/98.sql
diff --git a/schema/versions/pgsql/99.sql b/sql/pgsql/migrations/99.sql
index 846056cd6..846056cd6 100644
--- a/schema/versions/pgsql/99.sql
+++ b/sql/pgsql/migrations/99.sql
diff --git a/schema/ttrss_schema_pgsql.sql b/sql/pgsql/schema.sql
index ca7e8241c..ca7e8241c 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/sql/pgsql/schema.sql
diff --git a/update.php b/update.php
index 94a6bb5ca..d19c5f823 100755
--- a/update.php
+++ b/update.php
@@ -145,10 +145,8 @@
 		require_once "errorhandler.php";
 	}
 
-	if (!isset($options['update-schema'])) {
-		if (Db_Updater::is_update_required()) {
-			die("Schema version is wrong, please upgrade the database (--update-schema).\n");
-		}
+	if (!isset($options['update-schema']) && Config::is_migration_needed()) {
+		die("Schema version is wrong, please upgrade the database (--update-schema).\n");
 	}
 
 	Debug::set_enabled(true);
@@ -372,7 +370,32 @@
 	}
 
 	if (isset($options["update-schema"])) {
-		Debug::log("Checking for updates (" . Config::get(Config::DB_TYPE) . ")...");
+		if (Config::is_migration_needed()) {
+
+			if ($options["update-schema"] != "force-yes") {
+				Debug::log("Type 'yes' to continue.");
+
+				if (read_stdin() != 'yes')
+					exit;
+			} else {
+				Debug::log("Proceeding to update without confirmation...");
+			}
+
+			if (!isset($options["log-level"])) {
+				Debug::set_loglevel(Debug::$LOG_VERBOSE);
+			}
+
+			$migrations = Config::get_migrations();
+
+			Debug::log("Migrating schema to version " . $migrations->get_max_version());
+
+			$migrations->migrate();
+
+		} else {
+			Debug::log("Database schema is already at latest version.");
+		}
+
+		/*Debug::log("Checking for updates (" . Config::get(Config::DB_TYPE) . ")...");
 
 		$updater = new Db_Updater(Db::pdo(), Config::get(Config::DB_TYPE));
 
@@ -412,7 +435,7 @@
 			Debug::log("All done.");
 		} else {
 			Debug::log("Database schema is already at latest version.");
-		}
+		} */
 
 	}