Attachment #111091 for bug #22417

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




$DBversion = 'XXX'; # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {
    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );

    unless ( TableExists('background_jobs') ) {
        $dbh->do(q|
            CREATE TABLE background_jobs (
                id INT(11) NOT NULL AUTO_INCREMENT,
                status VARCHAR(32),
                progress INT(11),
                size INT(11),
                borrowernumber INT(11),
                type VARCHAR(64),
                data TEXT,
                enqueued_on DATETIME DEFAULT NULL,
                started_on DATETIME DEFAULT NULL,
                ended_on DATETIME DEFAULT NULL,
                PRIMARY KEY (id)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
        |);
    }

    SetVersion( $DBversion );
    print "Upgrade to $DBversion done (Bug 15032 - Add new table background_jobs)\n";
}




    CONSTRAINT borrower_macro_fk FOREIGN KEY ( borrowernumber ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table background_jobs
--

DROP TABLE IF EXISTS `background_jobs`;
CREATE TABLE background_jobs (
    id INT(11) NOT NULL AUTO_INCREMENT,
    status VARCHAR(32),
    progress INT(11),
    size INT(11),
    borrowernumber INT(11),
    type VARCHAR(64),
    data TEXT,
    enqueued_on DATETIME DEFAULT NULL,
    started_on DATETIME DEFAULT NULL,
    ended_on DATETIME DEFAULT NULL,
    PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- 

Return to bug 22417

Lines 4584-4589 CREATE TABLE advanced_editor_macros ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +19 lines)
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	-

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_15032.perl (+25 lines)
	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	}