Attachment 52114 Details for Bug 10459 – Bug 10459 renamed timestamp to updated_on

[patch] Bug 10459 renamed timestamp to updated_on

Bug-10459-renamed-timestamp-to-updatedon.patch (text/plain), 3.53 KB, created by Jonathan Druart on 2016-06-07 09:21:39 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2016-06-07 09:21:39 UTC

Size: 3.53 KB

patch

obsolete

>From 6da2e8f31663ce5bd1dbf0a7f99f363fd5ced98f Mon Sep 17 00:00:00 2001
>From: Mark Tompsett <mtompset@hotmail.com>
>Date: Wed, 25 May 2016 21:57:34 -0400
>Subject: [PATCH] Bug 10459 renamed timestamp to updated_on
>
>Signed-off-by: Joy Nelson <joy@bywatersolutions.com>
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>---
> .../data/mysql/atomicupdate/Bug10459_AddTimestampToBorrowers.sql      | 4 ++--
> installer/data/mysql/kohastructure.sql                                | 4 ++--
> 2 files changed, 4 insertions(+), 4 deletions(-)
>
>diff --git a/installer/data/mysql/atomicupdate/Bug10459_AddTimestampToBorrowers.sql b/installer/data/mysql/atomicupdate/Bug10459_AddTimestampToBorrowers.sql
>index dc3bbb2..6f428c3 100644
>--- a/installer/data/mysql/atomicupdate/Bug10459_AddTimestampToBorrowers.sql
>+++ b/installer/data/mysql/atomicupdate/Bug10459_AddTimestampToBorrowers.sql
>@@ -1,8 +1,8 @@
> ALTER TABLE borrowers
>-    ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
>+    ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
>     ON UPDATE CURRENT_TIMESTAMP
>     AFTER privacy_guarantor_checkouts;
> ALTER TABLE deletedborrowers
>-    ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
>+    ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
>     ON UPDATE CURRENT_TIMESTAMP
>     AFTER privacy_guarantor_checkouts;
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 494a4b7..4612a17 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -618,7 +618,7 @@ CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
>   `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
>   `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
>   `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
>-  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
>+  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
>   KEY borrowernumber (borrowernumber),
>   KEY `cardnumber` (`cardnumber`),
>   KEY `sms_provider_id` (`sms_provider_id`)
>@@ -1624,7 +1624,7 @@ CREATE TABLE `borrowers` ( -- this table includes information about your patrons
>   `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
>   `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
>   `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
>-  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
>+  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
>   UNIQUE KEY `cardnumber` (`cardnumber`),
>   PRIMARY KEY `borrowernumber` (`borrowernumber`),
>   KEY `categorycode` (`categorycode`),
>-- 
>2.8.1

Actions: View | Diff | Splinter Review

Attachments on bug 10459: 33421 | 33424 | 33435 | 33490 | 33491 | 33509 | 50475 | 50476 | 50478 | 50479 | 50480 | 50481 | 51807 | 51808 | 51809 | 51810 | 51842 | 51843 | 51844 | 51867 | 51868 | 52113 | 52114 | 52115 | 52294