Sha256: 3f45c7e85753af57d5bbeb030703bf154586563cb78d7f3f0effa299075de65d
Contents?: true
Size: 840 Bytes
Versions: 17
Compression:
Stored size: 840 Bytes
Contents
class AddPriorityToPromiseView < ActiveRecord::Migration[4.2]
def up
execute <<~SQL
DROP VIEW IF EXISTS marty_vw_promises;
CREATE OR REPLACE VIEW marty_vw_promises
AS
SELECT
id,
title,
user_id,
cformat,
parent_id,
job_id,
status,
start_dt,
end_dt,
priority
FROM marty_promises;
GRANT SELECT ON marty_vw_promises TO public;
SQL
end
def down
execute <<~SQL
DROP VIEW IF EXISTS marty_vw_promises;
CREATE OR REPLACE VIEW marty_vw_promises
AS
SELECT
id,
title,
user_id,
cformat,
parent_id,
job_id,
status,
start_dt,
end_dt
FROM marty_promises;
GRANT SELECT ON marty_vw_promises TO public;
SQL
end
end
Version data entries
17 entries across 17 versions & 1 rubygems