Bugzilla – Attachment 77080 Details for
Bug 18887
Introduce new table 'circulation_rules', use for 'max_holds' rules
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 18887 - Update database
Bug-18887---Update-database.patch (text/plain), 3.47 KB, created by
Kyle M Hall (khall)
on 2018-07-18 18:02:25 UTC
(
hide
)
Description:
Bug 18887 - Update database
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2018-07-18 18:02:25 UTC
Size:
3.47 KB
patch
obsolete
>From 8de3d552527601eaa84d253d159a0af0490ae999 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Mon, 6 Mar 2017 17:35:40 +0000 >Subject: [PATCH] Bug 18887 - Update database > >--- > installer/data/mysql/atomicupdate/bug_18887.perl | 41 ++++++++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 20 ++++++++++++ > 2 files changed, 61 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_18887.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_18887.perl b/installer/data/mysql/atomicupdate/bug_18887.perl >new file mode 100644 >index 0000000000..38610c9d44 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_18887.perl >@@ -0,0 +1,41 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ >+ $dbh->do(q{ >+ CREATE TABLE `circulation_rules` ( >+ `id` int(11) NOT NULL auto_increment, >+ `branchcode` varchar(10) NULL default NULL, >+ `categorycode` varchar(10) NULL default NULL, >+ `itemtype` varchar(10) NULL default NULL, >+ `rule_name` varchar(32) NOT NULL, >+ `rule_value` varchar(32) NOT NULL, >+ PRIMARY KEY (`id`), >+ KEY `branchcode` (`branchcode`), >+ KEY `categorycode` (`categorycode`), >+ KEY `itemtype` (`itemtype`), >+ KEY `rule_name` (`rule_name`), >+ UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`) >+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ }); >+ >+ $dbh->do(q{ >+ INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) >+ SELECT branchcode, categorycode, NULL, 'max_holds', max_holds FROM branch_borrower_circ_rules >+ }); >+ >+ $dbh->do(q{ >+ INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) >+ SELECT NULL, categorycode, NULL, 'max_holds', max_holds FROM branch_borrower_circ_rules >+ }); >+ >+ $dbh->do(q{ >+ ALTER TABLE branch_borrower_circ_rules DROP COLUMN max_holds >+ }); >+ >+ $dbh->do(q{ >+ ALTER TABLE default_borrower_circ_rules DROP COLUMN max_holds >+ }); >+ >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 18887 - Introduce new table 'circulation_rules', use for 'max_holds' rules)\n"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 68f21922d6..62d42eee84 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -4197,6 +4197,26 @@ CREATE TABLE `oauth_access_tokens` ( > PRIMARY KEY (`access_token`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > >+-- >+-- Table structure for table `circulation_rules` >+-- >+ >+DROP TABLE IF EXISTS `circulation_rules`; >+CREATE TABLE `circulation_rules` ( >+ `id` int(11) NOT NULL auto_increment, >+ `branchcode` varchar(10) NULL default NULL, >+ `categorycode` varchar(10) NULL default NULL, >+ `itemtype` varchar(10) NULL default NULL, >+ `rule_name` varchar(32) NOT NULL, >+ `rule_value` varchar(32) NOT NULL, >+ PRIMARY KEY (`id`), >+ KEY `branchcode` (`branchcode`), >+ KEY `categorycode` (`categorycode`), >+ KEY `itemtype` (`itemtype`), >+ UNIQUE (`branchcode`,`categorycode`,`itemtype`) >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+>>>>>>> Bug 18887 - Update database >+ > /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; > /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; > /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; >-- >2.11.0
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 18887
:
65233
|
65234
|
65235
|
65236
|
65237
|
67620
|
70986
|
70987
|
70988
|
70989
|
70990
|
70991
|
71031
|
71042
|
72218
|
72219
|
72220
|
72221
|
72222
|
72223
|
72224
|
77080
|
77081
|
77082
|
77083
|
77084
|
77085
|
77086
|
77087
|
77207
|
77208
|
77209
|
77210
|
77211
|
77212
|
77213
|
77214
|
77215
|
77218
|
77238
|
77649
|
77650
|
77651
|
77652
|
77653
|
77654
|
77655
|
77656
|
77657
|
77658
|
77659
|
78346
|
78347
|
78348
|
78349
|
78350
|
78351
|
78352
|
78353
|
78354
|
78355
|
78356
|
78674
|
78675
|
78676
|
78677
|
78678
|
78679
|
78680
|
78681
|
78682
|
78683
|
78684
|
78743
|
78744
|
78745
|
78746
|
78747
|
78748
|
78749
|
78750
|
78751
|
78752
|
78753
|
78879
|
79119
|
79626
|
79627
|
79628
|
79629
|
79630
|
79631
|
79632
|
79633
|
79634
|
79635
|
79636
|
79637
|
79638
|
79639
|
79640
|
79641
|
79761
|
79762
|
79763
|
79764
|
79765
|
79766
|
79767
|
79768
|
79769
|
79770
|
79771
|
79772
|
79773
|
79774
|
79775
|
79776
|
79778
|
79891