From 9d6a1e01f914d71c720f802919ae4e180a96575b Mon Sep 17 00:00:00 2001 From: UbitUmarov Date: Tue, 29 Oct 2019 22:55:51 +0000 Subject: fix some mysql timestamps default value --- OpenSim/Data/MySQL/Resources/HGTravelStore.migrations | 6 ++++++ OpenSim/Data/MySQL/Resources/os_groups_Store.migrations | 2 +- 2 files changed, 7 insertions(+), 1 deletion(-) (limited to 'OpenSim/Data') diff --git a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations index b4e4422..91a01c8 100644 --- a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations +++ b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations @@ -16,3 +16,9 @@ CREATE TABLE `hg_traveling_data` ( COMMIT; +:VERSION 2 # -------------------------- + +ALTER TABLE `hg_traveling_data` MODIFY `TMStamp` timestamp NOT NULL default CURRENT_TIMESTAMP; + +COMMIT; + diff --git a/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations b/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations index 1a8b565..96f001a 100644 --- a/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations +++ b/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations @@ -118,6 +118,6 @@ COMMIT; ALTER TABLE `os_groups_invites` -MODIFY `TMStamp` timestamp NOT NULL, default CURRENT_TIMESTAMP; +MODIFY `TMStamp` timestamp NOT NULL default CURRENT_TIMESTAMP; COMMIT; -- cgit v1.1