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

40 lines
2.0 KiB
SQL

INSERT INTO `emails` (`val`, `name`, `description`, `from`, `subject`, `body`, `bodyhtml`, `type`, `fundraising_campaigns_id`, `lastsent`) VALUES ('teacher_new_invite', 'Teacher - New Teacher Invitation', 'This is sent to a new teacher when their account is created', '', 'Teacher Account Registration for [FAIRNAME]', 'A teacher account has been created for you for the [FAIRNAME]. You can login to the registration site to complete your information, or invite students to attend the fair to represent your school with:
Username: [USERNAME]
Email Address: [EMAIL]
Password: [PASSWORD]
You can change your password once you login.', '<p>A teacher account has been created for you for the [FAIRNAME]. You can
login to the registration site to complete your information, or invite students to attend the fair to represent your school with:
</p>
<p>
Username: [USERNAME] <br />
Email Address: [EMAIL] <br />
Password: [PASSWORD] <br />
</p>
Website: [URLMAIN]
<p>
You can change your password once you login.
</p>','system',NULL,NULL);
INSERT INTO `emails` (`val`, `name`, `description`, `from`, `subject`, `body`, `bodyhtml`, `type`, `fundraising_campaigns_id`, `lastsent`) VALUES ('participant_new_invite', 'Participant - New Participant Invitation', 'This is sent to a new participant when their account is created', '', 'Participant Account Registration for [FAIRNAME]', 'A participant account has been created for you for the [FAIRNAME]. You must login to the registration site to complete your registration information.
Username: [USERNAME]
Email Address: [EMAIL]
Password: [PASSWORD]
You can change your password once you login.', '<p>A participant account has been created for you for the [FAIRNAME]. You must
login to the registration site to complete your registration information.
</p>
<p>
Username: [USERNAME] <br />
Email Address: [EMAIL] <br />
Password: [PASSWORD] <br />
</p>
<p>Website: [URLMAIN]
</p>
<p>
You can change your password once you login.
</p>','system',NULL,NULL);