summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2005-12-29 19:03:24 +0100
committerAndrew Dolgov <[email protected]>2005-12-29 19:03:24 +0100
commit41765fef9b2db10afec646fa486111d0c01aa64c (patch)
tree462e60a5b221c064eeba35f70a509dd951c877d5 /schema
parent3b0027a4be16eb2d504b0ca56affbd1d86491ec8 (diff)
bump schema version
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql2
-rw-r--r--schema/ttrss_schema_pgsql.sql2
-rw-r--r--schema/upgrade-1.1.1-1.1.2-mysql.sql2
-rw-r--r--schema/upgrade-1.1.1-1.1.2-pgsql.sql2
4 files changed, 6 insertions, 2 deletions
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;