Bugzilla – Attachment 109392 Details for
Bug 22417
Add a task queue
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 22417: UpdateDB entry
Bug-22417-UpdateDB-entry.patch (text/plain), 2.95 KB, created by
Jonathan Druart
on 2020-09-01 09:36:18 UTC
(
hide
)
Description:
Bug 22417: UpdateDB entry
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2020-09-01 09:36:18 UTC
Size:
2.95 KB
patch
obsolete
>From 65ecb758af17f6c98145fa626784637f5bb498f1 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> >--- > .../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 0316e4be19..257834b06b 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -4581,6 +4581,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.20.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
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