However for some mysterious reason all the blocks in the negative x half are raised 1 block and blocks in the positive x half are lowered 1 block. This results in an awkward 2-block step dividing my map in two.
Here's the SQL I'm using to do this transformation:
Code: Select all
alter table blocks rename to oldblocks; create table blocks (pos int primary key, data blob); insert into blocks select (pos & 0xfff000) | (~pos & ~0xfff000), data from oldblocks; drop table oldblocks; vacuum;