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

begin;

alter table ttrss_users add column otp_enabled boolean;
update ttrss_users set otp_enabled = false;
alter table ttrss_users change otp_enabled otp_enabled boolean not null;
alter table ttrss_users alter column otp_enabled set default false;

update ttrss_version set schema_version = 97;

commit;
Commit	Line	Data
fb70f26e AD	1	begin;
	2
	3	alter table ttrss_users add column otp_enabled boolean;
	4	update ttrss_users set otp_enabled = false;
	5	alter table ttrss_users change otp_enabled otp_enabled boolean not null;
	6	alter table ttrss_users alter column otp_enabled set default false;
	7
	8	update ttrss_version set schema_version = 97;
	9
	10	commit;