69.sql 370 B

123456789101112
  1. begin;
  2. create table ttrss_access_keys (id serial not null primary key,
  3. access_key varchar(250) not null,
  4. feed_id varchar(250) not null,
  5. is_cat bool not null default false,
  6. owner_uid integer not null,
  7. foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
  8. update ttrss_version set schema_version = 69;
  9. commit;