Attachment #108023 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 4570-4575 CREATE TABLE advanced_editor_macros ( Link Here

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

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	}