Files

Ignoring revisions in .git-blame-ignore-revs. Click here to bypass and see the normal blame view.

3 lines
209 B
SQL
Raw Permalink Normal View History

2014-09-30 01:15:33 +01:00
-- Update to add ping response time and last ping datetime
ALTER TABLE `devices` ADD `last_ping` TIMESTAMP NULL AFTER `last_discovered` , ADD `last_ping_timetaken` DOUBLE( 5, 2 ) NULL AFTER `last_ping` ;