Files
micromdm/migrations/201610120001_devices_default_timestamp_down.sql
mosen e4ab7e0b17 Hotfix/last check in (#34)
* Convert all time.Time pointers to value types.
Use UTC time when updating `last_checkin`.
Update `last_checkin` correctly on Authenticate, TokenUpdate, and query response.
Set database defaults to golangs zero value for time.Time which is `0001-01-01`.

* Add down migration for time defaults.
2016-10-12 16:20:48 +11:00

6 lines
221 B
SQL

ALTER TABLE devices
ALTER COLUMN dep_profile_assign_time DROP DEFAULT,
ALTER COLUMN dep_profile_push_time DROP DEFAULT,
ALTER COLUMN dep_profile_assigned_date DROP DEFAULT,
ALTER COLUMN last_checkin DROP DEFAULT;