ALTER TABLE `rooms101_rtsdev`.`timeclock`
    DROP COLUMN `ti_date`,
    DROP COLUMN `ti_time`,
    DROP COLUMN `to_date`,
    DROP COLUMN `to_time`,
    DROP COLUMN `timestamp`,
    ADD COLUMN `clockIn` datetime NULL AFTER `staff_id`,
    ADD COLUMN `clockOut` datetime NULL AFTER `clockIn`;

-- rename table to tbl_timeclock
