-- Newsletter
INSERT INTO `block` VALUES ({SGL_NEXT_ID}, 'Newsletter_Block_Subscribe', 'Subscribe', NULL, NULL, 1, 'Left', 0, 1, 'N;');

-- block IDs
SELECT @newsletter2BlockId := block_id FROM block WHERE name = 'Newsletter_Block_Subscribe';

-- create block assignments
INSERT INTO `block_assignment` VALUES (@newsletter2BlockId, 0);

-- create block role assignments
INSERT INTO `block_role` VALUES (@newsletter2BlockId, -2);