patch-setting-value-type.sql

-- You should not modify if this have pushed to Github, unless it does serious wrong with the db.
BEGIN TRANSACTION;

-- Generated by Intellij IDEA
create table setting_dg_tmp
(
    id INTEGER
        primary key autoincrement,
    key VARCHAR(200) not null
        unique,
    value TEXT,
    type VARCHAR(20)
);

insert into setting_dg_tmp(id, key, value, type) select id, key, value, type from setting;

drop table setting;

alter table setting_dg_tmp rename to setting;


COMMIT;