https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30592
Tomás Cohen Arazi <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected], | |[email protected], | |[email protected] Assignee|[email protected] |[email protected] |ity.org | --- Comment #1 from Tomás Cohen Arazi <[email protected]> --- Throwing this to start the conversation: ```sql CREATE TABLE `patron_credentials` ( `patron_credential_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key, Koha assigned ID number for patron credentials', `patron_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Foreign key to the patron the credential belongs to', `type` ENUM('password','two-factor') NOT NULL COMMENT 'Credential type', `created_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the credential was created', `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Time and date of the latest change on the credential', `value` mediumtext DEFAULT NULL COMMENT 'Credential value', PRIMARY KEY (`patron_credential_id`), CONSTRAINT `patron_id_ibfk_1` FOREIGN KEY (`patron_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,, ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; ``` Thoughts? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
