summaryrefslogtreecommitdiff
path: root/sql/mysql/migrations/141.sql
blob: 03caf23d0d60099e7d0d71dde9526438225debf4 (plain)
1
2
3
4
5
6
7
8
9
create table ttrss_user_prefs2 (
	owner_uid integer not null,
	pref_name varchar(250),
	profile integer null,
	value longtext not null,
	foreign key (profile) references ttrss_settings_profiles(id) ON DELETE CASCADE,
 	foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;

update ttrss_version set schema_version = 141;