20241127162048_add_song_history_table.sql

-- +goose Up
-- +goose StatementBegin
ALTER TABLE spotify
DROP COLUMN created_at;

ALTER TABLE spotify RENAME TO song;

CREATE TABLE IF NOT EXISTS song_history (
    id SERIAL PRIMARY KEY,
    song_id INTEGER NOT NULL,
    created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY(song_id) REFERENCES song(id)
);
-- +goose StatementEnd

-- +goose Down
-- +goose StatementBegin
DROP TABLE IF EXISTS song_history;

ALTER TABLE song RENAME TO spotify;

ALTER TABLE spotify
ADD COLUMN created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP;
-- +goose StatementEnd