## SQL command to create admin_settings table ```sql CREATE TABLE `admin_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `record_id` varchar(255) NOT NULL, `name` varchar(255) DEFAULT NULL, `resource_id` varchar(255) NOT NULL, `black_box` blob, `created_date_time` datetime DEFAULT NULL, `modified_date_time` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ``` ## SQL script to create form_data table ```sql CREATE TABLE `form_data` ( `id` bigint(20) UNSIGNED NOT NULL, `record_id` varchar(255) NOT NULL, `resource_id` varchar(255) NOT NULL, `envelope_id` varchar(255) NOT NULL, `application_id` varchar(255) DEFAULT NULL, `callback_url` varchar(255) DEFAULT NULL, `callback_status` varchar(255) DEFAULT NULL, `context` text, `black_box` blob, `black_box_data` blob, `created_date_time` datetime DEFAULT NULL, `modified_date_time` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ``` ## Docker command to export activities ```bash docker run -v /opt/migrations/:/migrations -e "START_DATE=2016-01-01" -e "END_DATE=2017-12-30" -e 'INFLUX_HOST_NAME={{IP_ADDRESS}}' -e 'INFLUX_PORT={{PORT}}' localhost:5000/activity_migrator ````