From 1089b16bc2dccbfba226fbd7d98b7535203449d2 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 16 Nov 2005 08:24:43 +0100 Subject: add purge_interval in ttrss_feeds (schema updated) --- schema/ttrss_schema_mysql.sql | 3 ++- schema/ttrss_schema_pgsql.sql | 3 ++- schema/upgrade-1.0.7-1.0.8-pgsql.sql | 12 ++++++++++++ 3 files changed, 16 insertions(+), 2 deletions(-) create mode 100644 schema/upgrade-1.0.7-1.0.8-pgsql.sql (limited to 'schema') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 93a2aa299..d63a9d57c 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -7,6 +7,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key, feed_url varchar(250) unique not null, icon_url varchar(250) not null default '', update_interval integer not null default 0, + purge_interval integer not null default 0, last_updated datetime default '', last_error text not null default '', site_url varchar(250) not null default '') TYPE=InnoDB; @@ -88,6 +89,6 @@ drop table ttrss_version; create table ttrss_version (schema_version int not null) TYPE=InnoDB; -insert into ttrss_version values (1); +insert into ttrss_version values (2); diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 3a20588eb..2a63243ad 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -7,6 +7,7 @@ create table ttrss_feeds (id serial not null primary key, feed_url varchar(250) unique not null, icon_url varchar(250) not null default '', update_interval integer not null default 0, + purge_interval integer not null default 0, last_updated timestamp default null, last_error text not null default '', site_url varchar(250) not null default ''); @@ -83,5 +84,5 @@ drop table ttrss_version; create table ttrss_version (schema_version int not null); -insert into ttrss_version values (1); +insert into ttrss_version values (2); diff --git a/schema/upgrade-1.0.7-1.0.8-pgsql.sql b/schema/upgrade-1.0.7-1.0.8-pgsql.sql new file mode 100644 index 000000000..abae1c684 --- /dev/null +++ b/schema/upgrade-1.0.7-1.0.8-pgsql.sql @@ -0,0 +1,12 @@ +begin; + +alter table ttrss_feeds add column purge_interval integer; + +update ttrss_feeds set purge_interval = 0; + +alter table ttrss_feeds alter column purge_interval set not null; +alter table ttrss_feeds alter column purge_interval set default 0; + +update ttrss_version set schema_version = 2; + +commit; -- cgit v1.2.3