Bugzilla – Attachment 11657 Details for
Bug 8215
Add Course Reserves
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 8215 - Add Course Reserves - Followup - Fix DB Updater & Makefile
Bug-8215---Add-Course-Reserves---Followup---Fix-DB.patch (text/plain), 3.54 KB, created by
Kyle M Hall
on 2012-08-17 12:28:26 UTC
(
hide
)
Description:
Bug 8215 - Add Course Reserves - Followup - Fix DB Updater & Makefile
Filename:
MIME Type:
Creator:
Kyle M Hall
Created:
2012-08-17 12:28:26 UTC
Size:
3.54 KB
patch
obsolete
>From cc81a70e953828ae913b473b6ce2cfd2d03b6c44 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Fri, 17 Aug 2012 08:28:16 -0400 >Subject: [PATCH] Bug 8215 - Add Course Reserves - Followup - Fix DB Updater & Makefile > >--- > Makefile.PL | 1 + > installer/data/mysql/updatedatabase.pl | 15 ++++++++++++--- > 2 files changed, 13 insertions(+), 3 deletions(-) > >diff --git a/Makefile.PL b/Makefile.PL >index 46a3524..3e78aa5 100644 >--- a/Makefile.PL >+++ b/Makefile.PL >@@ -261,6 +261,7 @@ my $target_map = { > './changelanguage.pl' => 'INTRANET_CGI_DIR', > './check_sysprefs.pl' => 'NONE', > './circ' => 'INTRANET_CGI_DIR', >+ './course_reserves' => 'INTRANET_CGI_DIR', > './offline_circ' => 'INTRANET_CGI_DIR', > './edithelp.pl' => 'INTRANET_CGI_DIR', > './etc' => { target => 'KOHA_CONF_DIR', trimdir => -1 }, >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 9e4b142..858495d 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -5632,10 +5632,12 @@ if(C4::Context->preference("Version") < TransformToNum($DBversion) ) { > print "NOTE: The URL of your remote opac css file has been moved to preference opaclayoutstylesheet.\n"; > } > print "Upgrade to $DBversion done (BZ 8263: Make OPAC stylesheet preferences more consistent)\n"; >-$DBversion = "3.07.00.XXX"; >+ SetVersion($DBversion); >+} > >+$DBversion = "3.09.00.XXX"; > if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { >- $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('UseCourseReserves', '0', 'Enable the course reserves feature.', NULL, 'YesNo'"); >+ $dbh->do("INSERT INTO `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) VALUES ('UseCourseReserves', '0', NULL, 'Enable the course reserves feature.', 'YesNo')"); > $dbh->do("INSERT INTO userflags (bit,flag,flagdesc,defaulton) VALUES ('18','coursereserves','Course Reserves','0')"); > $dbh->do(" > CREATE TABLE `courses` ( >@@ -5652,14 +5654,18 @@ CREATE TABLE `courses` ( > `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, > PRIMARY KEY (`course_id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+"); > >+$dbh->do(" > CREATE TABLE `course_instructors` ( > `course_id` int(11) NOT NULL, > `borrowernumber` int(11) NOT NULL, > PRIMARY KEY (`course_id`,`borrowernumber`), > KEY `borrowernumber` (`borrowernumber`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+"); > >+$dbh->do(" > CREATE TABLE `course_items` ( > `ci_id` int(11) NOT NULL AUTO_INCREMENT, > `itemnumber` int(11) NOT NULL, >@@ -5672,7 +5678,9 @@ CREATE TABLE `course_items` ( > PRIMARY KEY (`ci_id`), > UNIQUE KEY `itemnumber` (`itemnumber`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+"); > >+$dbh->do(" > CREATE TABLE `course_reserves` ( > `cr_id` int(11) NOT NULL AUTO_INCREMENT, > `course_id` int(11) NOT NULL, >@@ -5684,13 +5692,14 @@ CREATE TABLE `course_reserves` ( > UNIQUE KEY `psuedo_key` (`course_id`,`ci_id`), > KEY `course_id` (`course_id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+"); > >+$dbh->do(" > INSERT INTO permissions (module_bit, code, description) VALUES > (18, 'manage_courses', 'Add, edit and delete courses'), > (18, 'add_reserves', 'Add course reserves'), > (18, 'delete_reserves', 'Remove course reserves') > ; >- > "); > > print "Upgrade to $DBversion done (Add Course Reserves ( system preference UseCourseReserves ))\n"; >-- >1.7.2.5
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 8215
:
9990
|
10181
|
10224
|
11131
|
11612
|
11657
|
11677
|
11678
|
11679
|
11680
|
11681
|
11682
|
11683
|
11860
|
11861
|
11862
|
11865
|
11875
|
11881
|
11882
|
11980
|
12039
|
12120
|
12128
|
12188
|
12189
|
12192
|
12246
|
12361
|
12400
|
12413
|
12414
|
12593
|
12627
|
13496
|
13497
|
13498
|
13499
|
15195
|
15196
|
15197
|
15198
|
15199
|
16228
|
16229
|
16251
|
16252
|
16532
|
16533
|
16534
|
16536
|
16537
|
16545
|
16567
|
16568
|
16587
|
16588
|
16599
|
16621
|
16623
|
16634
|
17333
|
17334
|
17335
|
17336
|
17337
|
17377
|
17378
|
17379
|
17894
|
17895
|
17896
|
17897
|
17898
|
17899
|
18274
|
18275
|
18276
|
18277
|
18278
|
18279
|
18282
|
18283
|
18284
|
18285
|
18286
|
18287
|
18288
|
18289
|
18290
|
18291
|
18292
|
18293
|
21885
|
23264