Lines 5-12
CREATE TABLE IF NOT EXISTS borrower_password_recovery (
Link Here
|
5 |
borrowernumber int(11) NOT NULL, |
5 |
borrowernumber int(11) NOT NULL, |
6 |
uuid varchar(128) NOT NULL, |
6 |
uuid varchar(128) NOT NULL, |
7 |
valid_until timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
7 |
valid_until timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
|
|
8 |
PRIMARY KEY (borrowernumber), |
8 |
KEY borrowernumber (borrowernumber) |
9 |
KEY borrowernumber (borrowernumber) |
9 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
10 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
10 |
|
11 |
|
11 |
INSERT IGNORE INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) |
12 |
INSERT IGNORE INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) |
12 |
VALUES ('members','PASSWORD_RESET','','Online password reset',1,'Koha password recovery','<html>\r\n<p>This email has been sent in response to your password recovery request for the account <strong><<user>></strong>.\r\n</p>\r\n<p>\r\nYou can now create your new password using the following link:\r\n<br/><a href=\"<<passwordreseturl>>\"><<passwordreseturl>></a>\r\n</p>\r\n<p>This link will be valid for 2 days from this email\'s reception, then you must reapply if you do not change your password.</p>\r\n<p>Thank you.</p>\r\n</html>\r\n','email'); |
13 |
VALUES ('members','PASSWORD_RESET','','Online password reset',1,'Koha password recovery','<html>\r\n<p>This email has been sent in response to your password recovery request for the account <strong><<user>></strong>.\r\n</p>\r\n<p>\r\nYou can now create your new password using the following link:\r\n<br/><a href=\"<<passwordreseturl>>\"><<passwordreseturl>></a>\r\n</p>\r\n<p>This link will be valid for 2 days from this email\'s reception, then you must reapply if you do not change your password.</p>\r\n<p>Thank you.</p>\r\n</html>\r\n','email'); |