summaryrefslogtreecommitdiff
path: root/schema/versions/mysql/69.sql
blob: 75d2dadcbf976fe8f3dae5863ba8f5a2cbbbcaeb (plain)
1
2
3
4
5
6
7
8
9
10
11
12
begin;

create table ttrss_access_keys (id serial not null primary key,
	access_key varchar(250) not null,
	feed_id varchar(250) not null,
	is_cat bool not null default false,
	owner_uid integer not null,
  	foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) TYPE=InnoDB DEFAULT CHARSET=UTF8;

update ttrss_version set schema_version = 69;

commit;