summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2013-09-10 08:48:32 +0400
committerAndrew Dolgov <[email protected]>2013-09-10 08:48:32 +0400
commit4df07d50b11af9fdfb27ceff282f0a5ad2826794 (patch)
tree47c7756d31423264135cbfcf7f84c0212dc41a50 /schema
parent2e35b3bd6bb54da3284b8a06b025b39972a756a0 (diff)
specify engine=innodb for all tt-rss tables
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql6
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,