From e2a8a097bd2ffa7fbad4382d482e1c17844f7908 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 21 Aug 2006 16:09:05 +0100 Subject: [PATCH] bump schema version --- backend.php | 2 +- schema/ttrss_schema_mysql.sql | 2 +- schema/ttrss_schema_pgsql.sql | 2 +- schema/upgrade-1.2.2-1.2.3-mysql.sql | 2 ++ schema/upgrade-1.2.2-1.2.3-pgsql.sql | 2 ++ 5 files changed, 7 insertions(+), 3 deletions(-) diff --git a/backend.php b/backend.php index 3f8427f4..670ea4b5 100644 --- a/backend.php +++ b/backend.php @@ -16,7 +16,7 @@ $op = $_REQUEST["op"]; - define('SCHEMA_VERSION', 9); + define('SCHEMA_VERSION', 10); require_once "sanity_check.php"; require_once "config.php"; diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 61622388..9cd1dfba 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -183,7 +183,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) TYPE=InnoDB; -insert into ttrss_version values (9); +insert into ttrss_version values (10); create table ttrss_prefs_types (id integer not null primary key, type_name varchar(100) not null) TYPE=InnoDB; diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index bed7186c..61bb13f4 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -167,7 +167,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (9); +insert into ttrss_version values (10); create table ttrss_prefs_types (id integer not null primary key, type_name varchar(100) not null); diff --git a/schema/upgrade-1.2.2-1.2.3-mysql.sql b/schema/upgrade-1.2.2-1.2.3-mysql.sql index 90e32f50..114fa083 100644 --- a/schema/upgrade-1.2.2-1.2.3-mysql.sql +++ b/schema/upgrade-1.2.2-1.2.3-mysql.sql @@ -1,3 +1,5 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable e-mail digest',1, 'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address'); +update ttrss_version set schema_version = 10; + diff --git a/schema/upgrade-1.2.2-1.2.3-pgsql.sql b/schema/upgrade-1.2.2-1.2.3-pgsql.sql index 90e32f50..114fa083 100644 --- a/schema/upgrade-1.2.2-1.2.3-pgsql.sql +++ b/schema/upgrade-1.2.2-1.2.3-pgsql.sql @@ -1,3 +1,5 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable e-mail digest',1, 'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address'); +update ttrss_version set schema_version = 10; + -- 2.39.5