]>
git.wh0rd.org - tt-rss.git/blob - schema/versions/mysql/63.sql
3 create table ttrss_settings_profiles(id integer primary key auto_increment
,
4 title
varchar(250) not null,
5 owner_uid
integer not null,
7 foreign key (owner_uid
) references ttrss_users(id) ON DELETE CASCADE) TYPE=InnoDB
;
9 alter table ttrss_user_prefs
add column profile
integer;
10 update ttrss_user_prefs
set profile
= NULL;
12 alter table ttrss_user_prefs
add FOREIGN KEY (profile
) REFERENCES ttrss_settings_profiles(id) ON DELETE CASCADE;
14 insert into ttrss_prefs (pref_name
,type_id
,def_value
,short_desc
,section_id
) values('_THEME_ID', 3, '0', '', 1);
16 update ttrss_version
set schema_version
= 63;