From 2cfbb448fb197837c063c377c042beb3ba704a52 Mon Sep 17 00:00:00 2001 From: moontear Date: Mon, 15 Apr 2013 12:28:52 +0200 Subject: Added average color calculation of feeds' favicons for banded display. --- schema/versions/mysql/117.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 schema/versions/mysql/117.sql (limited to 'schema/versions') diff --git a/schema/versions/mysql/117.sql b/schema/versions/mysql/117.sql new file mode 100644 index 000000000..008f819ed --- /dev/null +++ b/schema/versions/mysql/117.sql @@ -0,0 +1,7 @@ +begin; + +ALTER TABLE `ttrss_feeds` ADD favicon_avg_color VARCHAR(11) + +update ttrss_version set schema_version = 117; + +commit; -- cgit v1.2.3 From 14118af36f2ba65a4e5151ee33b6ad565492cbf0 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 15 Apr 2013 14:54:17 +0400 Subject: fix schema for favicon_avg_color --- schema/versions/mysql/117.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'schema/versions') diff --git a/schema/versions/mysql/117.sql b/schema/versions/mysql/117.sql index 008f819ed..da3d056cc 100644 --- a/schema/versions/mysql/117.sql +++ b/schema/versions/mysql/117.sql @@ -1,6 +1,7 @@ begin; -ALTER TABLE `ttrss_feeds` ADD favicon_avg_color VARCHAR(11) +ALTER TABLE ttrss_feeds ADD COLUMN favicon_avg_color VARCHAR(11); +alter table ttrss_feeds alter column favicon_avg_color set default null; update ttrss_version set schema_version = 117; -- cgit v1.2.3 From 646aeb70011c60e781baa869faf00bf05bea1568 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 15 Apr 2013 15:38:20 +0400 Subject: add schema version 177 upgrade scripts --- schema/versions/pgsql/117.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 schema/versions/pgsql/117.sql (limited to 'schema/versions') diff --git a/schema/versions/pgsql/117.sql b/schema/versions/pgsql/117.sql new file mode 100644 index 000000000..da3d056cc --- /dev/null +++ b/schema/versions/pgsql/117.sql @@ -0,0 +1,8 @@ +begin; + +ALTER TABLE ttrss_feeds ADD COLUMN favicon_avg_color VARCHAR(11); +alter table ttrss_feeds alter column favicon_avg_color set default null; + +update ttrss_version set schema_version = 117; + +commit; -- cgit v1.2.3 From 889a5f9f195309df5842f142986b3166212d8a58 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 16 Apr 2013 19:41:31 +0400 Subject: experimental SQL-based error logger --- schema/versions/mysql/118.sql | 16 ++++++++++++++++ schema/versions/pgsql/118.sql | 15 +++++++++++++++ 2 files changed, 31 insertions(+) create mode 100644 schema/versions/mysql/118.sql create mode 100644 schema/versions/pgsql/118.sql (limited to 'schema/versions') diff --git a/schema/versions/mysql/118.sql b/schema/versions/mysql/118.sql new file mode 100644 index 000000000..add2b0c1f --- /dev/null +++ b/schema/versions/mysql/118.sql @@ -0,0 +1,16 @@ +begin; + +create table ttrss_error_log( + id integer not null auto_increment primary key, + owner_uid integer, + errno integer not null, + errstr text not null, + filename text not null, + lineno integer not null, + context text not null, + created_at datetime not null, + foreign key (owner_uid) references ttrss_users(id) ON DELETE SET NULL) ENGINE=InnoDB DEFAULT CHARSET=UTF8; + +update ttrss_version set schema_version = 118; + +commit; diff --git a/schema/versions/pgsql/118.sql b/schema/versions/pgsql/118.sql new file mode 100644 index 000000000..161cf4e3c --- /dev/null +++ b/schema/versions/pgsql/118.sql @@ -0,0 +1,15 @@ +begin; + +create table ttrss_error_log( + id serial not null primary key, + owner_uid integer references ttrss_users(id) ON DELETE SET NULL, + errno integer not null, + errstr text not null, + filename text not null, + lineno integer not null, + context text not null, + created_at timestamp not null); + +update ttrss_version set schema_version = 118; + +commit; -- cgit v1.2.3 From 3fbb4d183d6b0cb4b6d9d2d8d62d635eb70ebf13 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 26 Apr 2013 14:15:57 +0400 Subject: set default timezone to automatic (bump schema) --- schema/versions/mysql/119.sql | 7 +++++++ schema/versions/pgsql/119.sql | 7 +++++++ 2 files changed, 14 insertions(+) create mode 100644 schema/versions/mysql/119.sql create mode 100644 schema/versions/pgsql/119.sql (limited to 'schema/versions') diff --git a/schema/versions/mysql/119.sql b/schema/versions/mysql/119.sql new file mode 100644 index 000000000..ddb7d64de --- /dev/null +++ b/schema/versions/mysql/119.sql @@ -0,0 +1,7 @@ +begin; + +update ttrss_prefs set def_value = 'Automatic' where pref_name = 'USER_TIMEZONE'; + +update ttrss_version set schema_version = 119; + +commit; diff --git a/schema/versions/pgsql/119.sql b/schema/versions/pgsql/119.sql new file mode 100644 index 000000000..ddb7d64de --- /dev/null +++ b/schema/versions/pgsql/119.sql @@ -0,0 +1,7 @@ +begin; + +update ttrss_prefs set def_value = 'Automatic' where pref_name = 'USER_TIMEZONE'; + +update ttrss_version set schema_version = 119; + +commit; -- cgit v1.2.3 From 7b149552cb99a44f1fbeef642ffc60e91b1f61a0 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 29 Apr 2013 15:54:23 +0400 Subject: remove language selector from the login form, store language in the database per-user --- schema/versions/mysql/120.sql | 7 +++++++ schema/versions/pgsql/120.sql | 7 +++++++ 2 files changed, 14 insertions(+) create mode 100644 schema/versions/mysql/120.sql create mode 100644 schema/versions/pgsql/120.sql (limited to 'schema/versions') diff --git a/schema/versions/mysql/120.sql b/schema/versions/mysql/120.sql new file mode 100644 index 000000000..34971146e --- /dev/null +++ b/schema/versions/mysql/120.sql @@ -0,0 +1,7 @@ +begin; + +insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('USER_LANGUAGE', 2, '', 2); + +update ttrss_version set schema_version = 120; + +commit; diff --git a/schema/versions/pgsql/120.sql b/schema/versions/pgsql/120.sql new file mode 100644 index 000000000..34971146e --- /dev/null +++ b/schema/versions/pgsql/120.sql @@ -0,0 +1,7 @@ +begin; + +insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('USER_LANGUAGE', 2, '', 2); + +update ttrss_version set schema_version = 120; + +commit; -- cgit v1.2.3