add login/pass fields for feeds

[tt-rss.git] / schema / upgrade-1.1-1.1.1-mysql.sql

diff --git a/schema/upgrade-1.1-1.1.1-mysql.sql b/schema/upgrade-1.1-1.1.1-mysql.sql
index 4faf4fd032c90264baa9c99eb33277591dc2e4b1..cf8d7d9472cd8ae0dd13dce221d30abe43682ab3 100644 (file)
--- a/schema/upgrade-1.1-1.1.1-mysql.sql
+++ b/schema/upgrade-1.1-1.1.1-mysql.sql
@@ -17,4 +17,16 @@ update ttrss_feed_categories set collapsed = false;
 alter table ttrss_feed_categories change collapsed collapsed bool not null;
 alter table ttrss_feed_categories alter column collapsed set default 0;
 
+alter table ttrss_feeds add column auth_login varchar(250);
+alter table ttrss_feeds add column auth_pass varchar(250);
+
+update ttrss_feeds set auth_login = '';
+update ttrss_feeds set auth_pass = '';
+
+alter table ttrss_feeds change auth_login auth_login varchar(250) not null;
+alter table ttrss_feeds alter column auth_login set default '';
+
+alter table ttrss_feeds change auth_pass auth_pass varchar(250) not null;
+alter table ttrss_feeds alter column auth_pass set default '';
+
 commit;