revise schema 139 to use engine=innodb

2 files changed, 2 insertions, 2 deletions

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 8f7fb8d31..db8e262b0 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -64,7 +64,7 @@ create table ttrss_app_passwords (id integer not null primary key auto_increment
     service varchar(100) not null,
     created datetime not null,
     last_used datetime default null,
-    owner_uid integer not null references ttrss_users(id) on delete cascade);
+    owner_uid integer not null references ttrss_users(id) on delete cascade) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 
 create table ttrss_feed_categories(id integer not null primary key auto_increment,
 	owner_uid integer not null,
diff --git a/schema/versions/mysql/139.sql b/schema/versions/mysql/139.sql
index d2071d49e..88dfb69c7 100644
--- a/schema/versions/mysql/139.sql
+++ b/schema/versions/mysql/139.sql
@@ -6,7 +6,7 @@ create table ttrss_app_passwords (id integer not null primary key auto_increment
     service varchar(100) not null,
     created datetime not null,
     last_used datetime default null,
-    owner_uid integer not null references ttrss_users(id) on delete cascade);
+    owner_uid integer not null references ttrss_users(id) on delete cascade) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 
 update ttrss_version set schema_version = 139;