console.sql

create extension "uuid-ossp";

select * from mappable;
insert into mappable values (uuid_generate_v4(), 0, uuid_generate_v4(), now());

select * from game_version;
insert into game_version values (uuid_generate_v4(), 'test', now(), uuid_generate_v4(), false, false);
insert into game_version values (uuid_generate_v4(), 'test2', now(), uuid_generate_v4(), false, false);
insert into game_version values (uuid_generate_v4(), 'test3', now(), uuid_generate_v4(), false, false);

select * from versioned_mappable;
insert into versioned_mappable values(uuid_generate_v4(), 'fcf1f124-ba5a-4216-9d63-0ca2f92056cb', uuid_generate_v4(), now(), '49a525fa-1114-4513-a433-860b2c1235f6', null, null, null, null, null, null, null);
insert into versioned_mappable values(uuid_generate_v4(), 'c681ad66-563a-4d26-8088-66130d228059', uuid_generate_v4(), now(), '49a525fa-1114-4513-a433-860b2c1235f6', null, null, null, null, null, null, null);
insert into versioned_mappable values(uuid_generate_v4(), 'b11bfd4e-dd1d-4fb7-89f3-cbff91a39d88', uuid_generate_v4(), now(), '49a525fa-1114-4513-a433-860b2c1235f6', null, null, null, null, null, null, null);

select * from mapping_type;
insert into mapping_type values (uuid_generate_v4(), 'test', uuid_generate_v4(), now(), true, true);
insert into mapping_type values (uuid_generate_v4(), 'test2', uuid_generate_v4(), now(), true, true);

select * from mapping;
insert into mapping values(uuid_generate_v4(), 'c80d4994-3287-4f1e-86bd-973431ee86b2', now(), 'input1Old', 'output1Old', 'documentationOld', 3, '527d0b6d-01c2-4530-bcde-d5923dd7a604', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), 'c80d4994-3287-4f1e-86bd-973431ee86b2', now(), 'input1New', 'output1New', 'documentationOld', 3, '527d0b6d-01c2-4530-bcde-d5923dd7a604', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), '13e643a9-884b-4a33-b557-ed275b8e1b5e', now(), 'input2Old', 'output2Old', 'documentationOld', 3, '527d0b6d-01c2-4530-bcde-d5923dd7a604', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), '13e643a9-884b-4a33-b557-ed275b8e1b5e', now(), 'input2New', 'output2New', 'documentationOld', 3, '527d0b6d-01c2-4530-bcde-d5923dd7a604', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), 'be27d6b7-13fb-4f54-ad65-533df1cc7725', now(), 'input3Old', 'output3Old', 'documentationOld', 3, '527d0b6d-01c2-4530-bcde-d5923dd7a604', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), 'be27d6b7-13fb-4f54-ad65-533df1cc7725', now(), 'input3New', 'output3New', 'documentationOld', 3, '527d0b6d-01c2-4530-bcde-d5923dd7a604', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), 'be27d6b7-13fb-4f54-ad65-533df1cc7725', now(), 'input3New2', 'output3New2', 'documentationOld', 3, '527d0b6d-01c2-4530-bcde-d5923dd7a604', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), 'c80d4994-3287-4f1e-86bd-973431ee86b2', now(), 'input1Old', 'output1Old', 'documentationOld', 3, 'bb849eb2-478a-4408-b0f4-0aa1ffd7f0b8', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), 'c80d4994-3287-4f1e-86bd-973431ee86b2', now(), 'input1New', 'output1New', 'documentationOld', 3, 'bb849eb2-478a-4408-b0f4-0aa1ffd7f0b8', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), '13e643a9-884b-4a33-b557-ed275b8e1b5e', now(), 'input2Old', 'output2Old', 'documentationOld', 3, 'bb849eb2-478a-4408-b0f4-0aa1ffd7f0b8', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), '13e643a9-884b-4a33-b557-ed275b8e1b5e', now(), 'input2New', 'output2New', 'documentationOld', 3, 'bb849eb2-478a-4408-b0f4-0aa1ffd7f0b8', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), 'be27d6b7-13fb-4f54-ad65-533df1cc7725', now(), 'input3Old', 'output3Old', 'documentationOld', 3, 'bb849eb2-478a-4408-b0f4-0aa1ffd7f0b8', uuid_generate_v4());
insert into mapping values(uuid_generate_v4(), 'be27d6b7-13fb-4f54-ad65-533df1cc7725', now(), 'input3New', 'output3New', 'documentationOld', 3, 'bb849eb2-478a-4408-b0f4-0aa1ffd7f0b8', uuid_generate_v4());