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

begin;

create table ttrss_linked_instances (id integer not null primary key auto_increment,
	last_connected timestamp not null,
	access_key varchar(250) not null,
	access_url text not null) TYPE=InnoDB DEFAULT CHARSET=UTF8;

create table ttrss_linked_feeds (
	feed_url text not null,
	title text not null,
	created datetime not null,
	updated datetime not null,
	instance_id integer not null,
	subscribers integer not null,
 	foreign key (instance_id) references ttrss_linked_instances(id) ON DELETE CASCADE) TYPE=InnoDB DEFAULT CHARSET=UTF8;

drop table ttrss_scheduled_updates;

update ttrss_version set schema_version = 84;

commit;
Commit	Line	Data
58fa1bbc AD	1	begin;
	2
	3	create table ttrss_linked_instances (id integer not null primary key auto_increment,
afb875cc	4	last_connected timestamp not null,
58fa1bbc AD	5	access_key varchar(250) not null,
	6	access_url text not null) TYPE=InnoDB DEFAULT CHARSET=UTF8;
	7
	8	create table ttrss_linked_feeds (
	9	feed_url text not null,
	10	title text not null,
	11	created datetime not null,
	12	updated datetime not null,
	13	instance_id integer not null,
	14	subscribers integer not null,
	15	foreign key (instance_id) references ttrss_linked_instances(id) ON DELETE CASCADE) TYPE=InnoDB DEFAULT CHARSET=UTF8;
	16
	17	drop table ttrss_scheduled_updates;
	18
	19	update ttrss_version set schema_version = 84;
	20
	21	commit;