--
-- You should have received a copy of the GNU General Public License
-- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
+
+BEGIN TRANSACTION;
+
alter table transactions add year integer not null default 0;
alter table transactions add month integer not null default 0;
alter table transactions add day integer not null default 0;
insert into transactions_2(profile, id, data_hash, year, month, day, description, comment, keep) select profile, id, data_hash, year, month, day, description, comment, keep from transactions;
drop table transactions;
alter table transactions_2 rename to transactions;
+
+COMMIT TRANSACTION;
\ No newline at end of file