]> git.wh0rd.org - tt-rss.git/commitdiff
mysql: ttrss_enclosures should be an InnoDB table
authorAndrew Dolgov <fox@bah.org.ru>
Mon, 11 May 2009 19:25:56 +0000 (23:25 +0400)
committerAndrew Dolgov <fox@bah.org.ru>
Mon, 11 May 2009 19:25:56 +0000 (23:25 +0400)
schema/ttrss_schema_mysql.sql

index ac057fd5d1b6c40758262128667e38a2e6bb5af9..abeb30eca178bd7161ba85f6aa72a1ecb305a0f3 100644 (file)
@@ -234,7 +234,7 @@ create table ttrss_enclosures (id serial not null primary key,
        title text not null,
        duration text not null,
        index (post_id),
-       foreign key (post_id) references ttrss_entries(id) ON DELETE cascade);
+       foreign key (post_id) references ttrss_entries(id) ON DELETE cascade) TYPE=InnoDB;
 
 create table ttrss_prefs_types (id integer not null primary key, 
        type_name varchar(100) not null) TYPE=InnoDB;