51.sql 517 B

123456789101112131415161718
  1. begin;
  2. create table ttrss_labels2 (id serial not null primary key,
  3. owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE,
  4. caption varchar(250) not null
  5. );
  6. create table ttrss_user_labels2 (
  7. label_id integer not null references ttrss_labels2(id) ON DELETE CASCADE,
  8. article_id integer not null references ttrss_entries(id) ON DELETE CASCADE
  9. );
  10. insert into ttrss_filter_actions (id,name,description) values (7, 'label',
  11. 'Assign label');
  12. update ttrss_version set schema_version = 51;
  13. commit;