science-ation/db/db.update.74.sql

2 lines
513 B
SQL

UPDATE `emails` SET body='A new registration account has been created for you. To access your registration account, please enter the following registration number into the registration website:\r\n\r\nEmail Address: [EMAIL]\r\nRegistration Number: [REGNUM]\r\n' WHERE val='new_participant' AND body='A new registration account has been created for you. To access your registration account, please enter the following registration number into the registration website:\r\n\r\nRegistration Number: [REGNUM]\r\n';