diff options
Diffstat (limited to 'schema/upgrade-1.1-1.1.1-mysql.sql')
-rw-r--r-- | schema/upgrade-1.1-1.1.1-mysql.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/schema/upgrade-1.1-1.1.1-mysql.sql b/schema/upgrade-1.1-1.1.1-mysql.sql index 4faf4fd03..cf8d7d947 100644 --- 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; |