summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql2
-rw-r--r--schema/versions/mysql/139.sql2
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;