2 if(CheckVersion($DBversion)) {
5 DROP TABLE IF EXISTS api_keys;
9 CREATE TABLE `api_keys` (
10 `id` INT(11) NOT NULL AUTO_INCREMENT,
11 `patron_id` INT(11) NOT NULL,
12 `client_id` VARCHAR(191) NOT NULL,
13 `secret` VARCHAR(191) NOT NULL,
14 `description` VARCHAR(255) NOT NULL,
15 `active` TINYINT(1) DEFAULT 1 NOT NULL,
17 UNIQUE KEY `client_id` (`client_id`),
18 UNIQUE KEY `secret` (`secret`),
19 KEY `patron_id` (`patron_id`),
20 CONSTRAINT `api_keys_fk_patron_id`
21 FOREIGN KEY (`patron_id`)
22 REFERENCES `borrowers` (`borrowernumber`)
23 ON DELETE CASCADE ON UPDATE CASCADE
24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
27 print "Upgrade to $DBversion done (Bug 20568 - Add API key management interface for patrons)\n";
28 SetVersion($DBversion);