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

(-)a/installer/data/mysql/atomicupdate/bug_15032.perl (+25 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );
4
5
    unless ( TableExists('background_jobs') ) {
6
        $dbh->do(q|
7
            CREATE TABLE background_jobs (
8
                id INT(11) NOT NULL AUTO_INCREMENT,
9
                status VARCHAR(32),
10
                progress INT(11),
11
                size INT(11),
12
                borrowernumber INT(11),
13
                type VARCHAR(64),
14
                data TEXT,
15
                enqueued_on DATETIME DEFAULT NULL,
16
                started_on DATETIME DEFAULT NULL,
17
                ended_on DATETIME DEFAULT NULL,
18
                PRIMARY KEY (id)
19
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
20
        |);
21
    }
22
23
    SetVersion( $DBversion );
24
    print "Upgrade to $DBversion done (Bug 15032 - Add new table background_jobs)\n";
25
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +19 lines)
Lines 4584-4589 CREATE TABLE advanced_editor_macros ( Link Here
4584
    CONSTRAINT borrower_macro_fk FOREIGN KEY ( borrowernumber ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE
4584
    CONSTRAINT borrower_macro_fk FOREIGN KEY ( borrowernumber ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE
4585
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4585
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4586
4586
4587
--
4588
-- Table structure for table background_jobs
4589
--
4590
4591
DROP TABLE IF EXISTS `background_jobs`;
4592
CREATE TABLE background_jobs (
4593
    id INT(11) NOT NULL AUTO_INCREMENT,
4594
    status VARCHAR(32),
4595
    progress INT(11),
4596
    size INT(11),
4597
    borrowernumber INT(11),
4598
    type VARCHAR(64),
4599
    data TEXT,
4600
    enqueued_on DATETIME DEFAULT NULL,
4601
    started_on DATETIME DEFAULT NULL,
4602
    ended_on DATETIME DEFAULT NULL,
4603
    PRIMARY KEY (id)
4604
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4605
4587
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4606
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4588
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4607
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4589
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4608
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4590
- 

Return to bug 22417