Bugzilla – Attachment 41988 Details for
Bug 14544
Move the list related code to Koha::Virtualshelves
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 14544: DB Changes: Set a default value for sortfield
Bug-14544-DB-Changes-Set-a-default-value-for-sortf.patch (text/plain), 2.12 KB, created by
Jonathan Druart
on 2015-08-26 13:48:47 UTC
(
hide
)
Description:
Bug 14544: DB Changes: Set a default value for sortfield
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2015-08-26 13:48:47 UTC
Size:
2.12 KB
patch
obsolete
>From ec45a4668be87dd94ed8237c51d7c13a86ac3255 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Wed, 26 Aug 2015 14:48:35 +0100 >Subject: [PATCH] Bug 14544: DB Changes: Set a default value for sortfield > >--- > .../bug_14544_set_default_value_for_virtualshelves_sortfield.sql | 4 ++++ > installer/data/mysql/kohastructure.sql | 2 +- > 2 files changed, 5 insertions(+), 1 deletion(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql b/installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql >new file mode 100644 >index 0000000..11d95e2 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql >@@ -0,0 +1,4 @@ >+ALTER TABLE virtualshelves CHANGE COLUMN sortfield sortfield VARCHAR(16) DEFAULT 'title'; >+ >+UPDATE virtualshelves SET sortfield='title' WHERE sortfield IS NULL; >+ >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 3a497ae..171bc63 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2313,7 +2313,7 @@ CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) > `shelfname` varchar(255) default NULL, -- name of the list > `owner` int default NULL, -- foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) > `category` varchar(1) default NULL, -- type of list (private [1], public [2]) >- `sortfield` varchar(16) default NULL, -- the field this list is sorted on >+ `sortfield` varchar(16) default 'title', -- the field this list is sorted on > `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified > `created_on` TIMESTAMP NOT NULL, -- creation time > `allow_add` tinyint(1) default 0, -- permission for adding entries to list >-- >2.1.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 14544
:
41034
|
41035
|
41036
|
41037
|
41038
|
41039
|
41040
|
41041
|
41042
|
41403
|
41404
|
41405
|
41406
|
41407
|
41408
|
41409
|
41410
|
41411
|
41412
|
41584
|
41585
|
41586
|
41587
|
41588
|
41589
|
41590
|
41591
|
41592
|
41593
|
41594
|
41595
|
41596
|
41597
|
41598
|
41599
|
41600
|
41601
|
41716
|
41717
|
41718
|
41719
|
41720
|
41721
|
41722
|
41723
|
41724
|
41725
|
41726
|
41727
|
41728
|
41729
|
41730
|
41731
|
41732
|
41733
|
41766
|
41909
|
41910
|
41913
|
41914
|
41915
|
41917
|
41918
|
41919
|
41924
|
41927
|
41931
|
41932
|
41953
|
41954
|
41955
|
41956
|
41957
|
41958
|
41959
|
41960
|
41961
|
41962
|
41963
|
41964
|
41965
|
41966
|
41967
|
41968
|
41969
|
41970
|
41973
|
41974
|
41975
|
41976
|
41977
|
41978
|
41979
|
41980
|
41981
|
41982
|
41983
|
41986
|
41988
|
42192
|
42199
|
42200
|
42201
|
42202
|
42203
|
42204
|
42205
|
42206
|
42207
|
42208
|
42209
|
42210
|
42211
|
42212
|
42213
|
42214
|
42215
|
42216
|
42217
|
42218
|
42219
|
42638
|
43223
|
43224
|
43225
|
43226
|
43227
|
43228
|
43229
|
43230
|
43231
|
43232
|
43233
|
43234
|
43235
|
43236
|
43237
|
43238
|
43239
|
43240
|
43241
|
43242
|
43243
|
43296
|
43334
|
43335
|
43403
|
43456
|
43457
|
43458
|
43459
|
43460
|
43461
|
43462
|
43463
|
43464
|
43465
|
43466
|
43467
|
43469
|
43470
|
43471
|
43472
|
43473
|
43474
|
43475
|
43476
|
43477
|
43478
|
43479
|
43480
|
43481
|
43482
|
43485
|
43486
|
43487
|
44467
|
44468
|
44469
|
44470
|
44471
|
44472
|
44473
|
44474
|
44475
|
44476
|
44477
|
44478
|
44479
|
44480
|
44481
|
44482
|
44483
|
44484
|
44485
|
44486
|
44487
|
44758
|
44845
|
44852
|
44863
|
44872