X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_6.sql;h=dd4ff22773df0f926ec809553315cb70648c9bf4;hb=390a653a4424bd146f73bca3e421a0be252ee443;hp=c8e86348e7bb2cc4cb3b793ce3174fd6555b74dd;hpb=f6c803b3c43e2601b3c5ed7f6b6a0e630a71cf6b;p=mobile-ledger.git diff --git a/app/src/main/res/raw/sql_6.sql b/app/src/main/res/raw/sql_6.sql index c8e86348..dd4ff227 100644 --- a/app/src/main/res/raw/sql_6.sql +++ b/app/src/main/res/raw/sql_6.sql @@ -1,3 +1,20 @@ +-- Copyright © 2018 Damyan Ivanov. +-- This file is part of MoLe. +-- MoLe is free software: you can distribute it and/or modify it +-- under the term of the GNU General Public License as published by +-- the Free Software Foundation, either version 3 of the License, or +-- (at your opinion), any later version. +-- +-- MoLe is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License terms for details. +-- +-- You should have received a copy of the GNU General Public License +-- along with MoLe. If not, see . + +BEGIN TRANSACTION; + drop index idx_accounts_name; create table accounts_tmp(name varchar not null, name_upper varchar not null primary key, hidden boolean not null default 0, level integer not null default 0, parent_name varchar); insert or replace into accounts_tmp(name, name_upper, hidden, level, parent_name) select name, name_upper, hidden, level, parent from accounts; @@ -5,3 +22,5 @@ drop table accounts; create table accounts(name varchar not null, name_upper varchar not null primary key, hidden boolean not null default 0, level integer not null default 0, parent_name varchar, keep boolean default 1); insert into accounts(name, name_upper, hidden, level, parent_name) select name, name_upper, hidden, level, parent_name from accounts_tmp; drop table accounts_tmp; + +COMMIT TRANSACTION; \ No newline at end of file