From 49756fc36cd7014459c8c29e83d77dd327627c01 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 21 Dec 2005 19:08:59 +0100 Subject: bump schema version --- schema/ttrss_schema_mysql.sql | 2 +- schema/ttrss_schema_pgsql.sql | 2 +- schema/upgrade-1.1-1.1.1-mysql.sql | 2 ++ schema/upgrade-1.1-1.1.1-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 ad90cc43d..0fa1aa77a 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -166,7 +166,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 (2); +insert into ttrss_version values (3); 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 b2523764d..9df7418fa 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -150,7 +150,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 (2); +insert into ttrss_version values (3); 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-mysql.sql b/schema/upgrade-1.1-1.1.1-mysql.sql index 0bea5e9a2..79860a29c 100644 --- a/schema/upgrade-1.1-1.1.1-mysql.sql +++ b/schema/upgrade-1.1-1.1.1-mysql.sql @@ -38,4 +38,6 @@ alter table ttrss_users alter column email set default ''; insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_SEARCH_TOOLBAR', 1, 'false', 'Enable search toolbar',2); +update ttrss_version set schema_version = 3; + commit; diff --git a/schema/upgrade-1.1-1.1.1-pgsql.sql b/schema/upgrade-1.1-1.1.1-pgsql.sql index e48cd90c1..5b23f3366 100644 --- a/schema/upgrade-1.1-1.1.1-pgsql.sql +++ b/schema/upgrade-1.1-1.1.1-pgsql.sql @@ -38,4 +38,6 @@ alter table ttrss_users alter column email set default ''; insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_SEARCH_TOOLBAR', 1, 'false', 'Enable search toolbar',2); +update ttrss_version set schema_version = 3; + commit; -- cgit v1.2.3