diff options
author | Andrew Dolgov <[email protected]> | 2005-12-16 06:45:04 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-12-16 06:45:04 +0100 |
commit | e93a3c96bb7baf28be14918387839d172dbb5e9b (patch) | |
tree | 8e7a058afe45ee9994f47be32db6718adafc4c50 /schema/upgrade-1.1-1.1.1-pgsql.sql | |
parent | 65f8581478a3fff9b39d9c9a6011f8b0d3225655 (diff) |
add login/pass fields for feeds
Diffstat (limited to 'schema/upgrade-1.1-1.1.1-pgsql.sql')
-rw-r--r-- | schema/upgrade-1.1-1.1.1-pgsql.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/schema/upgrade-1.1-1.1.1-pgsql.sql b/schema/upgrade-1.1-1.1.1-pgsql.sql index 33b28271a..110d01af0 100644 --- a/schema/upgrade-1.1-1.1.1-pgsql.sql +++ b/schema/upgrade-1.1-1.1.1-pgsql.sql @@ -17,4 +17,16 @@ update ttrss_feed_categories set collapsed = false; alter table ttrss_feed_categories alter column collapsed set not null; alter table ttrss_feed_categories alter column collapsed set default false; +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 alter column auth_login set not null; +alter table ttrss_feeds alter column auth_login set default ''; + +alter table ttrss_feeds alter column auth_pass set not null; +alter table ttrss_feeds alter column auth_pass set default ''; + commit; |