Lines 1813-1818
CREATE TABLE `categories` (
Link Here
|
1813 |
`can_be_guarantee` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'if patrons of this category can be guarantees', |
1813 |
`can_be_guarantee` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'if patrons of this category can be guarantees', |
1814 |
`reset_password` tinyint(1) DEFAULT NULL COMMENT 'if patrons of this category can do the password reset flow,', |
1814 |
`reset_password` tinyint(1) DEFAULT NULL COMMENT 'if patrons of this category can do the password reset flow,', |
1815 |
`change_password` tinyint(1) DEFAULT NULL COMMENT 'if patrons of this category can change their passwords in the OAPC', |
1815 |
`change_password` tinyint(1) DEFAULT NULL COMMENT 'if patrons of this category can change their passwords in the OAPC', |
|
|
1816 |
`password_history_count` smallint(6) DEFAULT NULL COMMENT 'Number of previous passwords to check against when changing password for this patron type', |
1816 |
`min_password_length` smallint(6) DEFAULT NULL COMMENT 'set minimum password length for patrons in this category', |
1817 |
`min_password_length` smallint(6) DEFAULT NULL COMMENT 'set minimum password length for patrons in this category', |
1817 |
`require_strong_password` tinyint(1) DEFAULT NULL COMMENT 'set required password strength for patrons in this category', |
1818 |
`require_strong_password` tinyint(1) DEFAULT NULL COMMENT 'set required password strength for patrons in this category', |
1818 |
`force_password_reset_when_set_by_staff` tinyint(1) DEFAULT NULL COMMENT 'if patrons of this category are required to reset password after being created by a staff member', |
1819 |
`force_password_reset_when_set_by_staff` tinyint(1) DEFAULT NULL COMMENT 'if patrons of this category are required to reset password after being created by a staff member', |
Lines 6814-6819
CREATE TABLE `zebraqueue` (
Link Here
|
6814 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6815 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6815 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
6816 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
6816 |
|
6817 |
|
|
|
6818 |
-- |
6819 |
-- Table structure for table `borrower_password_history` |
6820 |
-- |
6821 |
|
6822 |
DROP TABLE IF EXISTS `borrower_password_history`; |
6823 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
6824 |
/*!40101 SET character_set_client = utf8 */; |
6825 |
CREATE TABLE IF NOT EXISTS borrower_password_history ( |
6826 |
id int(11) NOT NULL AUTO_INCREMENT, |
6827 |
borrowernumber int(11) NOT NULL, |
6828 |
password varchar(128) NOT NULL, |
6829 |
created_on timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
6830 |
PRIMARY KEY (id), |
6831 |
KEY borrowernumber (borrowernumber), |
6832 |
CONSTRAINT borrower_password_history_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers(borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE |
6833 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6834 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6835 |
|
6836 |
|
6817 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
6837 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
6818 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
6838 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
6819 |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
6839 |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
6820 |
- |
|
|