diff options
author | Andrew Dolgov <[email protected]> | 2013-09-10 08:48:32 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2013-09-10 08:48:32 +0400 |
commit | 4df07d50b11af9fdfb27ceff282f0a5ad2826794 (patch) | |
tree | 47c7756d31423264135cbfcf7f84c0212dc41a50 | |
parent | 2e35b3bd6bb54da3284b8a06b025b39972a756a0 (diff) |
specify engine=innodb for all tt-rss tables
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index fd4bf924a..243dad8cc 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -84,7 +84,7 @@ create table ttrss_counters_cache ( value integer not null default 0, updated datetime not null, foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE -); +) ENGINE=InnoDB DEFAULT CHARSET=UTF8; create index ttrss_counters_cache_feed_id_idx on ttrss_counters_cache(feed_id); create index ttrss_counters_cache_owner_uid_idx on ttrss_counters_cache(owner_uid); @@ -96,7 +96,7 @@ create table ttrss_cat_counters_cache ( value integer not null default 0, updated datetime not null, foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE -); +) ENGINE=InnoDB DEFAULT CHARSET=UTF8; create index ttrss_cat_counters_cache_owner_uid_idx on ttrss_cat_counters_cache(owner_uid); @@ -435,7 +435,7 @@ create table ttrss_feedbrowser_cache ( feed_url text not null, site_url text not null, title text not null, - subscribers integer not null) DEFAULT CHARSET=UTF8; + subscribers integer not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8; create table ttrss_labels2 (id integer not null primary key auto_increment, owner_uid integer not null, |