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