[tt-rss.git] / schema / versions / mysql / 69.sql

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) ENGINE=InnoDB DEFAULT CHARSET=UTF8;

update ttrss_version set schema_version = 69;

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