aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/2020-08-23-140315_fix_screening_timestamps/down.sql
blob: 49ceb2cdd808bb5642b06ed609543552ccd9675f (plain) (blame)
1
2
3
4
5
6
7
-- Revert date and timestamps back to separate state.
-- There should be no reason to do this, but included for completeness-
-- This will re-add the 'date' column, but not set the proper date.
ALTER TABLE screenings
    ADD COLUMN date TYPE DATE NOT NULL,
    ALTER COLUMN start_time TYPE TIME,
    ALTER COLUMN end_time TYPE TIME;