Sha256: d43e994042acb7dc3d09bf12155b0713a896c064f7e15c25d8dfa3e6aa3530bb

Contents?: true

Size: 396 Bytes

Versions: 78

Compression:

Stored size: 396 Bytes

Contents

class CreateVwPromises < ActiveRecord::Migration[5.1]
  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
from marty_promises;

grant select on marty_vw_promises to public;

SQL
  end
  def down
    execute "drop view if exists marty_vw_promises;"
  end
end

Version data entries

78 entries across 78 versions & 1 rubygems

Version Path
marty-14.3.0 db/migrate/411_create_vw_promises.rb
marty-14.0.0 db/migrate/411_create_vw_promises.rb
marty-13.0.2 db/migrate/411_create_vw_promises.rb
marty-11.0.0 db/migrate/411_create_vw_promises.rb
marty-10.0.3 db/migrate/411_create_vw_promises.rb
marty-10.0.2 db/migrate/411_create_vw_promises.rb
marty-10.0.0 db/migrate/411_create_vw_promises.rb
marty-9.5.1 db/migrate/411_create_vw_promises.rb
marty-9.5.0 db/migrate/411_create_vw_promises.rb
marty-9.3.3 db/migrate/411_create_vw_promises.rb
marty-9.3.2 db/migrate/411_create_vw_promises.rb
marty-9.3.0 db/migrate/411_create_vw_promises.rb
marty-8.5.0 db/migrate/411_create_vw_promises.rb
marty-8.4.1 db/migrate/411_create_vw_promises.rb
marty-8.3.1 db/migrate/411_create_vw_promises.rb
marty-8.2.0 db/migrate/411_create_vw_promises.rb
marty-8.0.0 db/migrate/411_create_vw_promises.rb
marty-6.1.0 db/migrate/411_create_vw_promises.rb
marty-5.2.0 db/migrate/411_create_vw_promises.rb
marty-5.1.4 db/migrate/411_create_vw_promises.rb