56.sql 400 B

12345678910111213141516
  1. begin;
  2. drop table ttrss_enclosures;
  3. create table ttrss_enclosures (id serial not null primary key,
  4. content_url text not null,
  5. content_type varchar(250) not null,
  6. post_id integer not null,
  7. title text not null,
  8. duration text not null,
  9. index (post_id),
  10. foreign key (post_id) references ttrss_entries(id) ON DELETE cascade) ENGINE=InnoDB;
  11. update ttrss_version set schema_version = 56;
  12. commit;