schema: add email column to ttrss_users

[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 cf8d7d9472cd8ae0dd13dce221d30abe43682ab3..994cc76de6e90057b37fca94e1cc7e183ad0af6b 100644 (file)
--- a/schema/upgrade-1.1-1.1.1-mysql.sql
+++ b/schema/upgrade-1.1-1.1.1-mysql.sql
@@ -29,4 +29,11 @@ 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 '';
 
+alter table ttrss_users add column email varchar(250);
+
+update ttrss_users set email = '';
+
+alter table ttrss_users change email email varchar(250) not null;
+alter table ttrss_users alter column email set default '';
+
 commit;