Contents

Sequel.migration do
  change do
    create_table :reg_p100 do
      column :id, :Bignum, primary_key: true
      column :id_pai, :Bignum, index: true, null: false
      column :dt_ini, Date
      column :dt_fim, Date
      column :vl_rec_tot_est, BigDecimal, size: [18, 2]
      column :cod_ativ_econ, String, size: 8
      column :vl_rec_ativ_estab, BigDecimal, size: [18, 2]
      column :vl_exc, BigDecimal, size: [18, 2]
      column :vl_bc_cont, BigDecimal, size: [18, 2]
      column :aliq_cont, BigDecimal, size: [18, 4]
      column :vl_cont_apu, BigDecimal, size: [18, 2]
      column :cod_cta, String, size: 255
      column :info_compl, String, size: 1000
      column :cnpj_pai, String, size: 14, index: true
    end
  end
end

Version data entries

3 entries across 1 versions & 1 rubygems

Version	Path
sped2db-1.2.0	migrations/contrib/v003/179_create_table_reg_p100.rb
sped2db-1.2.0	migrations/contrib/v004/179_create_table_reg_p100.rb
sped2db-1.2.0	migrations/contrib/v005/182_create_table_reg_p100.rb