INSERT INTO `acme_widgetlist` (widgetlist) VALUES ('Reunion - Advocacy - Recipients - List'); DROP PROCEDURE IF EXISTS `procedure_foo`; DELIMITER $$ CREATE PROCEDURE `procedure_foo`() BEGIN DECLARE last_id INTEGER; SELECT id INTO last_id FROM `acme_widgetlist` WHERE `widgetlist` = 'Reunion - Advocacy - Recipients - List'; INSERT INTO `acme_widgetlist_item` (`item`, `display_name`, `widgetlist_id`, `is_active`, `the_order`, `access_level`, `type_id`, `is_searchable`, `field`) VALUES ('alert_name', 'Name', last_id, 1, 1, 0, 1, 1, 'advocacy_capwiz_alert.alert_title'); INSERT INTO `acme_widgetlist_item` (`item`, `display_name`, `widgetlist_id`, `is_active`, `the_order`, `access_level`, `type_id`, `is_searchable`, `field`) VALUES ('recipient_full_description', 'Recipient', last_id, 1, 2, 0, 1, 1, 'cms_form_completed_advocacy_letter_recipients.recipient_full_description'); INSERT INTO `acme_widgetlist_item` (`item`, `display_name`, `widgetlist_id`, `is_active`, `the_order`, `access_level`, `type_id`, `is_searchable`, `field`) VALUES ('created_at', 'Created At', last_id, 1, 3, 0, 3, 1, 'cms_form_completed_advocacy_letter.created_at'); INSERT INTO `acme_widgetlist_item` (`item`, `display_name`, `widgetlist_id`, `is_active`, `the_order`, `access_level`, `type_id`, `is_searchable`, `field`) VALUES ('delivery_method', 'Delivery Method', last_id, 1, 4, 0, 1, 0, ''); INSERT INTO `acme_widgetlist_item` (`item`, `display_name`, `widgetlist_id`, `is_active`, `the_order`, `access_level`, `type_id`, `is_searchable`, `field`) VALUES ('form_title', 'Form Name', last_id, 1, 5, 0, 1, 1, 'cms_forms.title'); INSERT INTO `acme_widgetlist_item` (`item`, `display_name`, `widgetlist_id`, `is_active`, `the_order`, `access_level`, `type_id`, `is_searchable`, `field`) VALUES ('package_name', 'Package Name', last_id, 1, 6, 0, 1, 1, 'bb_package.name'); INSERT INTO `acme_widgetlist_item` (`item`, `display_name`, `widgetlist_id`, `is_active`, `the_order`, `access_level`, `type_id`, `is_searchable`, `field`) VALUES ('package_subject', 'Package Subject', last_id, 1, 7, 0, 1, 1, 'bb_package.description'); INSERT INTO `acme_widgetlist_item` (`item`, `display_name`, `widgetlist_id`, `is_active`, `the_order`, `access_level`, `type_id`, `is_searchable`, `field`) VALUES ('export', '', last_id, 1, 8, 0, 1, 0, ''); END $$ delimiter ; CALL procedure_foo(); DROP PROCEDURE procedure_foo;