diff options
author | Andrew Dolgov <[email protected]> | 2005-12-20 07:23:33 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-12-20 07:23:33 +0100 |
commit | 8629e09d9b60eda1c4f06d88267287083f8f3ea2 (patch) | |
tree | 479f8fd7415d22fd0edf477b566352d80d5282bc /schema/upgrade-1.1-1.1.1-pgsql.sql | |
parent | d2afdfa09f86ac4f73b82b88175a09e4a124ab42 (diff) |
schema: add email column to ttrss_users
Diffstat (limited to 'schema/upgrade-1.1-1.1.1-pgsql.sql')
-rw-r--r-- | schema/upgrade-1.1-1.1.1-pgsql.sql | 7 |
1 files changed, 7 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 110d01af0..06380815c 100644 --- a/schema/upgrade-1.1-1.1.1-pgsql.sql +++ b/schema/upgrade-1.1-1.1.1-pgsql.sql @@ -29,4 +29,11 @@ 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 ''; +alter table ttrss_users add column email varchar(250); + +update ttrss_users set email = ''; + +alter table ttrss_users alter column email set not null; +alter table ttrss_users alter column email set default ''; + commit; |