SQLize | PHPize | SQLtest

CREATE TABLE entity ( id serial PRIMARY KEY ); CREATE TABLE entity_version ( id bigint PRIMARY KEY GENERATED ALWAYS AS IDENTITY, entity_id integer REFERENCES entity (id), value jsonb, is_draft boolean ); DO $$ DECLARE new_entity_id bigint; 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); 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); 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); 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); 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); 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