summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2010-01-20 14:21:25 +0300
committerAndrew Dolgov <[email protected]>2010-01-20 14:21:25 +0300
commitfbe2ea1c6dc8f4af402c7ea88a9e83d5c85692b1 (patch)
tree54bd91777f245878b2cc4369ad95953149f1366a /schema
parentc633e370ec9b98731dff95045ddb12ff4e53092f (diff)
change description of DEFAULT_UPDATE_INTERVAL (bump schema)
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql4
-rw-r--r--schema/ttrss_schema_pgsql.sql4
-rw-r--r--schema/versions/mysql/65.sql7
-rw-r--r--schema/versions/pgsql/65.sql7
4 files changed, 18 insertions, 4 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 82284b8bf..b9bb777ec 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -239,7 +239,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 (64);
+insert into ttrss_version values (65);
create table ttrss_enclosures (id integer primary key auto_increment,
content_url text not null,
@@ -288,7 +288,7 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) valu
insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ENABLE_LABELS', 1, 'false', 'Enable labels',3,
'Experimental support for virtual feeds based on user crafted SQL queries. This feature is highly experimental and at this point not user friendly. Use with caution.');
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('DEFAULT_UPDATE_INTERVAL', 3, '30', 'Default interval between feed updates (in minutes)',1);
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('DEFAULT_UPDATE_INTERVAL', 3, '30', 'Default interval between feed updates',1);
insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('DEFAULT_ARTICLE_LIMIT', 3, '30', 'Amount of articles to display at once',2);
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 3a27577f8..55b07b6ea 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -211,7 +211,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 (64);
+insert into ttrss_version values (65);
create table ttrss_enclosures (id serial not null primary key,
content_url text not null,
@@ -252,7 +252,7 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) valu
insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ENABLE_LABELS', 1, 'false', 'Enable labels',3,
'Experimental support for virtual feeds based on user crafted SQL queries. This feature is highly experimental and at this point not user friendly. Use with caution.');
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('DEFAULT_UPDATE_INTERVAL', 3, '30', 'Default interval between feed updates (in minutes)',1);
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('DEFAULT_UPDATE_INTERVAL', 3, '30', 'Default interval between feed updates',1);
insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('DEFAULT_ARTICLE_LIMIT', 3, '30', 'Amount of articles to display at once',2);
diff --git a/schema/versions/mysql/65.sql b/schema/versions/mysql/65.sql
new file mode 100644
index 000000000..ce21de898
--- /dev/null
+++ b/schema/versions/mysql/65.sql
@@ -0,0 +1,7 @@
+begin;
+
+update ttrss_prefs set short_desc = 'Default feed update interval' where pref_name = 'DEFAULT_UPDATE_INTERVAL';
+
+update ttrss_version set schema_version = 65;
+
+commit;
diff --git a/schema/versions/pgsql/65.sql b/schema/versions/pgsql/65.sql
new file mode 100644
index 000000000..ce21de898
--- /dev/null
+++ b/schema/versions/pgsql/65.sql
@@ -0,0 +1,7 @@
+begin;
+
+update ttrss_prefs set short_desc = 'Default feed update interval' where pref_name = 'DEFAULT_UPDATE_INTERVAL';
+
+update ttrss_version set schema_version = 65;
+
+commit;