Sha256: 815b3bf99d3efe593e9c927d5dedeef552eafcff828b03453199853ada8f3445

Contents?: true

Size: 978 Bytes

Versions: 3

Compression:

Stored size: 978 Bytes

Contents

Sequel.migration do
  change do
    create_table :reg_m500 do
      column :id, :Bignum, primary_key: true
      column :id_pai, :Bignum, index: true, null: false
      column :cod_cred, String, size: 3
      column :ind_cred_ori, String, size: 1
      column :vl_bc_cred, BigDecimal, size: [18, 2]
      column :aliq_cofins, BigDecimal, size: [18, 4]
      column :quant_bc_cofins, BigDecimal, size: [18, 3]
      column :aliq_cofins_quant, BigDecimal, size: [18, 4]
      column :vl_cred, BigDecimal, size: [18, 2]
      column :vl_ajus_acres, BigDecimal, size: [18, 2]
      column :vl_ajus_reduc, BigDecimal, size: [18, 2]
      column :vl_cred_dif, BigDecimal, size: [18, 2]
      column :vl_cred_disp, BigDecimal, size: [18, 2]
      column :ind_desc_cred, String, size: 1
      column :vl_cred_desc, BigDecimal, size: [18, 2]
      column :sld_cred, 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/162_create_table_reg_m500.rb
sped2db-1.2.0 migrations/contrib/v004/162_create_table_reg_m500.rb
sped2db-1.2.0 migrations/contrib/v005/164_create_table_reg_m500.rb