From 7ec2a838ef97834a93685dfea0e3f6cb4f38ac92 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Thu, 10 Nov 2005 05:35:39 +0100
Subject: [PATCH] schema_version handling in backend.php

---
 backend.php | 12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/backend.php b/backend.php
index 611b67b3..2a865747 100644
--- a/backend.php
+++ b/backend.php
@@ -1,4 +1,6 @@
 <?
+	define(SCHEMA_VERSION, 2);
+
 	$op = $_GET["op"];
 
 	if ($op == "rpc") {
@@ -25,6 +27,16 @@
 	if (DB_TYPE == "pgsql") {
 		pg_query("set client_encoding = 'utf-8'");
 	}
+
+	$result = db_query($link, "SELECT schema_version FROM ttrss_version");
+
+	$schema_version = db_fetch_result($result, 0, "schema_version");
+
+	if ($schema_version != SCHEMA_VERSION) {
+		print "Error: database schema is invalid
+			(got version $schema_version; expected ".SCHEMA_VERSION.")";
+		return;
+	}
 	
 	$fetch = $_GET["fetch"];
 
-- 
2.39.5