forked from science-ation/science-ation
13 lines
773 B
SQL
13 lines
773 B
SQL
ALTER TABLE `accounts` ADD `pendingemailcode` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `pendingemail`;
|
|
INSERT INTO `emails` ( `val` , `name` , `description` , `from` , `subject` , `body` , `bodyhtml` , `type` , `fundraising_campaigns_id` , `lastsent`) VALUES ( 'account_email_confirmation', 'Email Address Confirmation', 'Gets sent when someone adds or changes their email address to allow the user to confirm the email address is valid', NULL , 'Email Authorization - [FAIRNAME]',
|
|
'We have received a request to add or change the email address on
|
|
your account. Before any emails will be sent to you from
|
|
[FAIRNAME] you need to
|
|
click the link below to validate your email address.
|
|
|
|
Email Address: [EMAIL]
|
|
|
|
[EMAILCONFIRMATIONLINK]
|
|
|
|
Thank You', '', 'system', NULL , NULL);
|