diff options
author | Andrew Dolgov <[email protected]> | 2019-11-03 20:13:42 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2019-11-03 20:13:42 +0300 |
commit | 17e145f4810385534f076143276d5f2df43d025d (patch) | |
tree | 4943772060205e0eaf23bd2cfaf3a1d444ee403e | |
parent | f75fb6bd75b2f80c5bdce3c4e22a335e147b5f16 (diff) |
revise schema 139 to use engine=innodb
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 2 | ||||
-rw-r--r-- | schema/versions/mysql/139.sql | 2 |
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; |