SQLize | PHPize | SQLtest

CREATE TABLE entity ( id serial PRIMARY KEY ); CREATE TABLE entity_version ( id serial PRIMARY KEY, entity_id integer REFERENCES entity (id), value jsonb, is_draft boolean ); do $$ declare new_entity_id integer; begin insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); insert into entity default values returning entity.Id into new_entity_id; insert into entity_version(entity_id, value, is_draft) values (new_entity_id, '{"data":"123456"}', TRUE); end $$; select * from entity_version