From 41765fef9b2db10afec646fa486111d0c01aa64c Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 29 Dec 2005 19:03:24 +0100 Subject: bump schema version --- 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 ++ 4 files changed, 6 insertions(+), 2 deletions(-) (limited to 'schema') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 9d79f8a25..7d7f7151e 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 c2db4b36c..5344783de 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 9061587b3..a889e5c1c 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 9061587b3..a889e5c1c 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; -- cgit v1.2.3