--up
ALTER TABLE short_urls ADD COLUMN "user_id" integer REFERENCES users(id) ON UPDATE RESTRICT ON DELETE CASCADE;
ALTER TABLE short_urls ADD COLUMN is_manual boolean DEFAULT false;
ALTER TABLE short_url_clicks ADD COLUMN request_information JSONB;


--down
ALTER TABLE short_urls DROP COLUMN user_id;
ALTER TABLE short_urls DROP COLUMN is_manual;
ALTER TABLE short_url_clicks DROP COLUMN request_information;
