diff options
author | Andrew Dolgov <[email protected]> | 2007-04-18 07:25:51 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2007-04-18 07:25:51 +0100 |
commit | 155a2a53ffc4fac6299cc165cfc56114a61873f7 (patch) | |
tree | 0175f8c3cc74116b0498039dee4071153c0f2392 /schema/versions | |
parent | 21f4756a3f2589c68c8f58fd6111678c0f8af04c (diff) |
schema: add (unused) ttrss_feeds.auth_pass_encrypted, bump schema
Diffstat (limited to 'schema/versions')
-rw-r--r-- | schema/versions/mysql/16.sql | 6 | ||||
-rw-r--r-- | schema/versions/pgsql/16.sql | 6 |
2 files changed, 12 insertions, 0 deletions
diff --git a/schema/versions/mysql/16.sql b/schema/versions/mysql/16.sql new file mode 100644 index 000000000..00034df33 --- /dev/null +++ b/schema/versions/mysql/16.sql @@ -0,0 +1,6 @@ +alter table ttrss_feeds add column auth_pass_encrypted bool; +update ttrss_feeds set auth_pass_encrypted = false; +alter table ttrss_feeds change auth_pass_encrypted auth_pass_encrypted bool not null; +alter table ttrss_feeds alter column auth_pass_encrypted set default false; + +update ttrss_version set schema_version = 16; diff --git a/schema/versions/pgsql/16.sql b/schema/versions/pgsql/16.sql new file mode 100644 index 000000000..996e9a5dd --- /dev/null +++ b/schema/versions/pgsql/16.sql @@ -0,0 +1,6 @@ +alter table ttrss_feeds add column auth_pass_encrypted boolean; +update ttrss_feeds set auth_pass_encrypted = false; +alter table ttrss_feeds alter column auth_pass_encrypted set not null; +alter table ttrss_feeds alter column auth_pass_encrypted set default false; + +update ttrss_version set schema_version = 16; |