Bugzilla – Attachment 60517 Details for
Bug 15707
Add ability to define hierarchical groups of libraries
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 15707 - Switch datetimes to timestamps
Bug-15707---Switch-datetimes-to-timestamps.patch (text/plain), 1.97 KB, created by
Kyle M Hall (khall)
on 2017-02-21 13:42:51 UTC
(
hide
)
Description:
Bug 15707 - Switch datetimes to timestamps
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2017-02-21 13:42:51 UTC
Size:
1.97 KB
patch
obsolete
>From 85be327939f5c262b26fbd008fca9ff350e416ee Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Tue, 21 Feb 2017 12:16:03 +0000 >Subject: [PATCH] Bug 15707 - Switch datetimes to timestamps > >--- > Koha/Library/Group.pm | 4 +--- > installer/data/mysql/atomicupdate/library_groups.sql | 4 ++-- > 2 files changed, 3 insertions(+), 5 deletions(-) > >diff --git a/Koha/Library/Group.pm b/Koha/Library/Group.pm >index cd53899..43291e8 100644 >--- a/Koha/Library/Group.pm >+++ b/Koha/Library/Group.pm >@@ -118,9 +118,7 @@ sub libraries_not_direct_children { > sub store { > my ($self) = @_; > >- my $now = dt_from_string; >- $self->updated_on($now); >- $self->created_on($now) unless $self->in_storage(); >+ $self->created_on( dt_from_string() ) unless $self->in_storage(); > > return $self->SUPER::store(@_); > } >diff --git a/installer/data/mysql/atomicupdate/library_groups.sql b/installer/data/mysql/atomicupdate/library_groups.sql >index d6d3425..ba30eec 100644 >--- a/installer/data/mysql/atomicupdate/library_groups.sql >+++ b/installer/data/mysql/atomicupdate/library_groups.sql >@@ -4,8 +4,8 @@ CREATE TABLE library_groups ( > branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group > title VARCHAR(100) NULL DEFAULT NULL, -- Short description of the goup > description TEXT NULL DEFAULT NULL, -- Longer explanation of the group, if necessary >- created_on DATETIME NOT NULL, -- Date and time of creation >- updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last >+ created_on TIMESTAMP NULL, -- Date and time of creation >+ updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last > PRIMARY KEY id ( id ), > FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE, > FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE >-- >2.1.4
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 15707
:
47479
|
47480
|
47481
|
47482
|
47483
|
47484
|
47728
|
47729
|
47730
|
47731
|
47732
|
47733
|
47734
|
47849
|
47850
|
47851
|
47852
|
47853
|
47854
|
47855
|
47868
|
47869
|
47870
|
47871
|
47872
|
47873
|
47874
|
48072
|
50400
|
50401
|
50402
|
50403
|
50404
|
50405
|
50406
|
50407
|
50408
|
52267
|
52268
|
52269
|
52270
|
52271
|
52272
|
52273
|
52274
|
52275
|
52367
|
52370
|
52562
|
52563
|
52564
|
52565
|
52566
|
52567
|
52568
|
52569
|
52570
|
52571
|
52572
|
52573
|
52574
|
52575
|
57080
|
57081
|
57082
|
57083
|
57084
|
57085
|
57086
|
57087
|
57088
|
57089
|
57090
|
57091
|
57092
|
57093
|
58086
|
60504
|
60505
|
60506
|
60507
|
60508
|
60509
|
60510
|
60511
|
60512
|
60513
|
60514
|
60515
|
60516
|
60517
|
60518
|
60572
|
60573
|
60574
|
60575
|
60576
|
60577
|
60578
|
60579
|
60580
|
60581
|
60582
|
60583
|
60584
|
60585
|
60586
|
60587
|
60755
|
60756
|
60757
|
60758
|
60759
|
60760
|
60761
|
60762
|
60763
|
60764
|
60765
|
60766
|
60767
|
60768
|
60769
|
60770
|
60771
|
65666
|
65667
|
65668
|
65669
|
65670
|
65671
|
65672
|
65673
|
65674
|
65675
|
65676
|
65677
|
65678
|
65679
|
65680
|
65681
|
69514
|
69515
|
69516
|
69517
|
69518
|
69519
|
69520
|
69521
|
69522
|
69523
|
69524
|
69525
|
69526
|
69527
|
69528
|
69529
|
69573
|
69574
|
69575
|
69576
|
69577
|
69578
|
69579
|
69580
|
69581
|
69582
|
69583
|
69584
|
69585
|
69586
|
69587
|
69588
|
69589