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 | 7 |
1 files changed, 7 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 cf8d7d947..994cc76de 100644 --- 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; |