From 41765fef9b2db10afec646fa486111d0c01aa64c Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 29 Dec 2005 19:03:24 +0100 Subject: [PATCH] bump schema version --- backend.php | 2 +- schema/ttrss_schema_mysql.sql | 2 +- schema/ttrss_schema_pgsql.sql | 2 +- schema/upgrade-1.1.1-1.1.2-mysql.sql | 2 ++ schema/upgrade-1.1.1-1.1.2-pgsql.sql | 2 ++ 5 files changed, 7 insertions(+), 3 deletions(-) diff --git a/backend.php b/backend.php index 067995b8..626df1d0 100644 --- a/backend.php +++ b/backend.php @@ -28,7 +28,7 @@ exit; } - define('SCHEMA_VERSION', 3); + define('SCHEMA_VERSION', 4); require_once "sanity_check.php"; require_once "config.php"; diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 9d79f8a2..7d7f7151 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -169,7 +169,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 (3); +insert into ttrss_version values (4); 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 c2db4b36..5344783d 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -151,7 +151,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 (3); +insert into ttrss_version values (4); create table ttrss_prefs_types (id integer not null primary key, type_name varchar(100) not null); diff --git a/schema/upgrade-1.1.1-1.1.2-mysql.sql b/schema/upgrade-1.1.1-1.1.2-mysql.sql index 9061587b..a889e5c1 100644 --- a/schema/upgrade-1.1.1-1.1.2-mysql.sql +++ b/schema/upgrade-1.1.1-1.1.2-mysql.sql @@ -3,4 +3,6 @@ begin; alter table ttrss_feeds add column parent_feed integer; alter table ttrss_feeds add foreign key (parent_feed) references ttrss_feeds(id) on delete set null; +update ttrss_version set schema_version = 4; + commit; diff --git a/schema/upgrade-1.1.1-1.1.2-pgsql.sql b/schema/upgrade-1.1.1-1.1.2-pgsql.sql index 9061587b..a889e5c1 100644 --- a/schema/upgrade-1.1.1-1.1.2-pgsql.sql +++ b/schema/upgrade-1.1.1-1.1.2-pgsql.sql @@ -3,4 +3,6 @@ begin; alter table ttrss_feeds add column parent_feed integer; alter table ttrss_feeds add foreign key (parent_feed) references ttrss_feeds(id) on delete set null; +update ttrss_version set schema_version = 4; + commit; -- 2.39.5