        `created_at`,       `updated_at`,              `text`,
        `old_help_text_id`, `old_suggested_answer_id`, `old_institution_id`,
        `old_funder_id`)
-SELECT 'help_text',         NULL,     dmp2.fnStripTags(LEFT(`help_text`,50)),
+SELECT 'help_text',         NULL,        LEFT(dmp2.fnStripTags(`help_text`), 50),
        `h`.`created_at`,   `h`.`updated_at`,          `help_text`,
        `h`.`id`,            NULL,                      NULL,
        `f`.`funder_id`

ALTER TABLE `dmp2`.`resource_contexts`      DROP COLUMN `old_funder_id`;
ALTER TABLE `dmp2`.`users`                  DROP COLUMN `old_user_id`;




# resources: first copy DMP1 resources into DMP2 URL resources;
# then insert DMP1 help and suggested answers,
# using their first 50 characters as labels (the actionable URLs labels will not be truncated)
# help and suggested answers are de-duplicated within institutions
TRUNCATE TABLE `dmp2`.`resources`;
INSERT INTO `dmp2`.`resources` (
       `id`,         `resource_type`,  `value`, `label`, `created_at`,
       `updated_at`, `text`)
SELECT `id`,         'actionable_url', `url`,   `desc`,  `created_at`,
       `updated_at`,  NULL
FROM `dmp`.`resources`;

