diff options
| author | UbitUmarov | 2019-10-29 22:55:51 +0000 |
|---|---|---|
| committer | UbitUmarov | 2019-10-29 22:55:51 +0000 |
| commit | 9d6a1e01f914d71c720f802919ae4e180a96575b (patch) | |
| tree | 916917114704c7f896b748b661da3a7e87083f18 | |
| parent | update server release notes default URL (diff) | |
| download | opensim-SC-9d6a1e01f914d71c720f802919ae4e180a96575b.zip opensim-SC-9d6a1e01f914d71c720f802919ae4e180a96575b.tar.gz opensim-SC-9d6a1e01f914d71c720f802919ae4e180a96575b.tar.bz2 opensim-SC-9d6a1e01f914d71c720f802919ae4e180a96575b.tar.xz | |
fix some mysql timestamps default value
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/HGTravelStore.migrations | 6 | ||||
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/os_groups_Store.migrations | 2 |
2 files changed, 7 insertions, 1 deletions
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` ( | |||
| 16 | 16 | ||
| 17 | COMMIT; | 17 | COMMIT; |
| 18 | 18 | ||
| 19 | :VERSION 2 # -------------------------- | ||
| 20 | |||
| 21 | ALTER TABLE `hg_traveling_data` MODIFY `TMStamp` timestamp NOT NULL default CURRENT_TIMESTAMP; | ||
| 22 | |||
| 23 | COMMIT; | ||
| 24 | |||
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; | |||
| 118 | 118 | ||
| 119 | ALTER TABLE `os_groups_invites` | 119 | ALTER TABLE `os_groups_invites` |
| 120 | 120 | ||
| 121 | MODIFY `TMStamp` timestamp NOT NULL, default CURRENT_TIMESTAMP; | 121 | MODIFY `TMStamp` timestamp NOT NULL default CURRENT_TIMESTAMP; |
| 122 | 122 | ||
| 123 | COMMIT; | 123 | COMMIT; |