schema/versions/pgsql/51.sql

   1 begin;
   2
   3 create table ttrss_labels2 (id serial not null primary key,
   4         owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE,
   5         caption varchar(250) not null
   6 );
   7
   8 create table ttrss_user_labels2 (
   9         label_id integer not null references ttrss_labels2(id) ON DELETE CASCADE,
  10         article_id integer not null references ttrss_entries(id) ON DELETE CASCADE
  11 );
  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;
  17
  18 commit;