Attachment 111091 Details for Bug 22417 – Bug 22417: UpdateDB entry

[patch] Bug 22417: UpdateDB entry

Bug-22417-UpdateDB-entry.patch (text/plain), 3.02 KB, created by Kyle M Hall (khall) on 2020-10-02 11:07:30 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2020-10-02 11:07:30 UTC

Size: 3.02 KB

patch

obsolete

>From 51c835f8ed17dd91c3723ee588edbaf688c25baa Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Mon, 25 Feb 2019 13:31:15 -0300
>Subject: [PATCH] Bug 22417: UpdateDB entry
>
>TODO:
>- Add the FK on borrowernumber
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>
>Signed-off-by: David Cook <dcook@prosentient.com.au>
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>---
> .../data/mysql/atomicupdate/bug_15032.perl    | 25 +++++++++++++++++++
> installer/data/mysql/kohastructure.sql        | 19 ++++++++++++++
> 2 files changed, 44 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_15032.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_15032.perl b/installer/data/mysql/atomicupdate/bug_15032.perl
>new file mode 100644
>index 0000000000..34554fc2f2
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_15032.perl
>@@ -0,0 +1,25 @@
>+$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";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 7bc8a4dd96..6fbed2fba3 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -4584,6 +4584,25 @@ CREATE TABLE advanced_editor_macros (
>     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 */;
>-- 
>2.24.1 (Apple Git-126)

Actions: View | Diff | Splinter Review

Attachments on bug 22417: 105542 | 105543 | 107385 | 107386 | 107387 | 107388 | 107389 | 107390 | 107391 | 107392 | 107393 | 107394 | 107395 | 107396 | 107397 | 107398 | 107399 | 107400 | 107401 | 107402 | 107403 | 107404 | 107405 | 107406 | 107481 | 107482 | 107682 | 108023 | 108024 | 108025 | 108026 | 108027 | 108028 | 108029 | 108030 | 108031 | 108032 | 108033 | 108034 | 108035 | 108036 | 108037 | 108038 | 108039 | 108040 | 108041 | 108042 | 108043 | 108044 | 108045 | 108046 | 108047 | 109270 | 109271 | 109319 | 109320 | 109321 | 109322 | 109323 | 109324 | 109325 | 109326 | 109327 | 109328 | 109329 | 109330 | 109331 | 109332 | 109333 | 109334 | 109335 | 109336 | 109337 | 109338 | 109339 | 109340 | 109341 | 109342 | 109343 | 109344 | 109345 | 109350 | 109351 | 109355 | 109390 | 109391 | 109392 | 109393 | 109394 | 109395 | 109396 | 109397 | 109398 | 109399 | 109400 | 109401 | 109402 | 109403 | 109404 | 109405 | 109406 | 109407 | 109408 | 109409 | 109410 | 109411 | 109412 | 109413 | 109414 | 109415 | 109416 | 109417 | 109418 | 109474 | 109475 | 109476 | 109477 | 110150 | 111091 | 111092 | 111093 | 111094 | 111095 | 111096 | 111097 | 111098 | 111099 | 111100 | 111101 | 111102 | 111103 | 111104 | 111105 | 111106 | 111107 | 111108 | 111109 | 111110 | 111111 | 111112 | 111113 | 111114 | 111115 | 111116 | 111117 | 111118 | 111119 | 111120 | 111121 | 111238 | 111239 | 111245