-- Run this once against an EXISTING database that already has the
-- attendance table without the location/IP columns (fresh installs
-- using the current sql/schema.sql already have these).
--
--   mysql -u youruser -p yourdatabase < sql/migration_attendance_location.sql

ALTER TABLE attendance
    ADD COLUMN clock_in_lat DECIMAL(10,7) DEFAULT NULL AFTER clock_out,
    ADD COLUMN clock_in_lng DECIMAL(10,7) DEFAULT NULL AFTER clock_in_lat,
    ADD COLUMN clock_out_lat DECIMAL(10,7) DEFAULT NULL AFTER clock_in_lng,
    ADD COLUMN clock_out_lng DECIMAL(10,7) DEFAULT NULL AFTER clock_out_lat,
    ADD COLUMN clock_in_ip VARCHAR(45) DEFAULT NULL AFTER clock_out_lng,
    ADD COLUMN clock_out_ip VARCHAR(45) DEFAULT NULL AFTER clock_in_ip;