From e93a3c96bb7baf28be14918387839d172dbb5e9b Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Fri, 16 Dec 2005 06:45:04 +0100
Subject: add login/pass fields for feeds

---
 schema/upgrade-1.1-1.1.1-mysql.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to '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 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;
-- 
cgit v1.2.3-54-g00ecf

