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 4581-4586 CREATE TABLE advanced_editor_macros ( Link Here
4581
    CONSTRAINT borrower_macro_fk FOREIGN KEY ( borrowernumber ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE
4581
    CONSTRAINT borrower_macro_fk FOREIGN KEY ( borrowernumber ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE
4582
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4582
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4583
4583
4584
--
4585
-- Table structure for table background_jobs
4586
--
4587
4588
DROP TABLE IF EXISTS `background_jobs`;
4589
CREATE TABLE background_jobs (
4590
    id INT(11) NOT NULL AUTO_INCREMENT,
4591
    status VARCHAR(32),
4592
    progress INT(11),
4593
    size INT(11),
4594
    borrowernumber INT(11),
4595
    type VARCHAR(64),
4596
    data TEXT,
4597
    enqueued_on DATETIME DEFAULT NULL,
4598
    started_on DATETIME DEFAULT NULL,
4599
    ended_on DATETIME DEFAULT NULL,
4600
    PRIMARY KEY (id)
4601
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4602
4584
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4603
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4585
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4604
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4586
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4605
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4587
- 

Return to bug 22417