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

Return to bug 22417