View | Details | Raw Unified | Return to bug 20568
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_20568_api_keys.perl (-23 / +20 lines)
Lines 1-28 Link Here
1
$DBversion = "XXX";
1
$DBversion = "XXX";
2
if(CheckVersion($DBversion)) {
2
if(CheckVersion($DBversion)) {
3
3
4
    $dbh->do(q{
4
    if (!TableExists('api_keys')) {
5
        DROP TABLE IF EXISTS api_keys;
5
        $dbh->do(q{
6
    });
6
            CREATE TABLE `api_keys` (
7
7
                `id`          INT(11) NOT NULL AUTO_INCREMENT,
8
    $dbh->do(q{
8
                `patron_id`   INT(11) NOT NULL,
9
        CREATE TABLE `api_keys` (
9
                `client_id`   VARCHAR(191) NOT NULL,
10
            `id`          INT(11) NOT NULL AUTO_INCREMENT,
10
                `secret`      VARCHAR(191) NOT NULL,
11
            `patron_id`   INT(11) NOT NULL,
11
                `description` VARCHAR(255) NOT NULL,
12
            `client_id`   VARCHAR(191) NOT NULL,
12
                `active`      TINYINT(1) DEFAULT 1 NOT NULL,
13
            `secret`      VARCHAR(191) NOT NULL,
13
                PRIMARY KEY (`id`),
14
            `description` VARCHAR(255) NOT NULL,
14
                UNIQUE KEY `client_id` (`client_id`),
15
            `active`      TINYINT(1) DEFAULT 1 NOT NULL,
15
                UNIQUE KEY `secret` (`secret`),
16
            PRIMARY KEY (`id`),
16
                KEY `patron_id` (`patron_id`),
17
            UNIQUE KEY `client_id` (`client_id`),
17
                CONSTRAINT `api_keys_fk_patron_id`
18
            UNIQUE KEY `secret` (`secret`),
18
                  FOREIGN KEY (`patron_id`)
19
            KEY `patron_id` (`patron_id`),
19
                  REFERENCES `borrowers` (`borrowernumber`)
20
            CONSTRAINT `api_keys_fk_patron_id`
20
                  ON DELETE CASCADE ON UPDATE CASCADE
21
              FOREIGN KEY (`patron_id`)
21
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
22
              REFERENCES `borrowers` (`borrowernumber`)
22
        });
23
              ON DELETE CASCADE ON UPDATE CASCADE
23
    }
24
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
25
    });
26
24
27
    $dbh->do(q{
25
    $dbh->do(q{
28
        INSERT IGNORE INTO `systempreferences`
26
        INSERT IGNORE INTO `systempreferences`
29
- 

Return to bug 20568