Sha256: 7b5a4cc630074b08bcf4f9cf46b47737c56b0c9540ca8c2e7d61bb4bbe0483d4

Contents?: true

Size: 1.14 KB

Versions: 3

Compression:

Stored size: 1.14 KB

Contents

Sequel.migration do
  change do
    create_table :reg_1500 do
      column :id, :Bignum, primary_key: true
      column :id_pai, :Bignum, index: true, null: false
      column :per_apu_cred, String, size: 6
      column :orig_cred, String, size: 2
      column :cnpj_suc, String, size: 14
      column :cod_cred, String, size: 3
      column :vl_cred_apu, BigDecimal, size: [18, 2]
      column :vl_cred_ext_apu, BigDecimal, size: [18, 2]
      column :vl_tot_cred_apu, BigDecimal, size: [18, 2]
      column :vl_cred_desc_pa_ant, BigDecimal, size: [18, 2]
      column :vl_cred_per_pa_ant, BigDecimal, size: [18, 2]
      column :vl_cred_dcomp_pa_ant, BigDecimal, size: [18, 2]
      column :sd_cred_disp_efd, BigDecimal, size: [18, 2]
      column :vl_cred_desc_efd, BigDecimal, size: [18, 2]
      column :vl_cred_per_efd, BigDecimal, size: [18, 2]
      column :vl_cred_dcomp_efd, BigDecimal, size: [18, 2]
      column :vl_cred_trans, BigDecimal, size: [18, 2]
      column :vl_cred_out, BigDecimal, size: [18, 2]
      column :sld_cred_fim, BigDecimal, size: [18, 2]
      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/026_create_table_reg_1500.rb
sped2db-1.2.0 migrations/contrib/v004/026_create_table_reg_1500.rb
sped2db-1.2.0 migrations/contrib/v005/027_create_table_reg_1500.rb