diff options
author | Andrew Dolgov <[email protected]> | 2019-11-01 11:57:36 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2019-11-01 11:57:45 +0300 |
commit | 84e9f1d5ccec90103a3decb7069884342f73fdfb (patch) | |
tree | 85ea7e5512d263c0e9563c81ce45a9cb6399c764 /schema/versions | |
parent | 178bcd43497253c2ffb35d6c3ab3456277bf4ab6 (diff) |
update schema for app-specific passwords
Diffstat (limited to 'schema/versions')
-rw-r--r-- | schema/versions/mysql/139.sql | 11 | ||||
-rw-r--r-- | schema/versions/pgsql/139.sql | 11 |
2 files changed, 22 insertions, 0 deletions
diff --git a/schema/versions/mysql/139.sql b/schema/versions/mysql/139.sql new file mode 100644 index 000000000..45c4d6266 --- /dev/null +++ b/schema/versions/mysql/139.sql @@ -0,0 +1,11 @@ +begin; + +create table ttrss_app_passwords (id integer not null primary key auto_increment, + title varchar(250) not null, + pwd_hash text not null, + service varchar(100) not null, + owner_uid integer not null references ttrss_users(id) on delete cascade); + +update ttrss_version set schema_version = 139; + +commit; diff --git a/schema/versions/pgsql/139.sql b/schema/versions/pgsql/139.sql new file mode 100644 index 000000000..6001ee139 --- /dev/null +++ b/schema/versions/pgsql/139.sql @@ -0,0 +1,11 @@ +begin; + +create table ttrss_app_passwords (id serial not null primary key, + title varchar(250) not null, + pwd_hash text not null, + service varchar(100) not null, + owner_uid integer not null references ttrss_users(id) on delete cascade); + +update ttrss_version set schema_version = 139; + +commit; |