summaryrefslogtreecommitdiff
authorMark Tompsett <mtompset@hotmail.com>2016-05-26 01:57:34 (GMT)
committer Kyle M Hall <kyle@bywatersolutions.com>2016-06-10 17:10:22 (GMT)
commitf863e478b994f2631d79821473c773099dc78172 (patch) (side-by-side diff)
tree14d89ca4826d95219f4a441aa8b9a199952247e5
parent255596ae6c483caf5746745f3656b56e0ea011b4 (diff)
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> Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--installer/data/mysql/atomicupdate/Bug10459_AddTimestampToBorrowers.sql4
-rw-r--r--installer/data/mysql/kohastructure.sql4
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`),