schema/versions/mysql/51.sql

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