Sha256: 9f73ae4481dea9425ffc844bdcb75b27685bcf591a24805f8a5c4a81d36d7d6a

Contents?: true

Size: 860 Bytes

Versions: 5

Compression:

Stored size: 860 Bytes

Contents

Sequel.migration do
  change do
    create_table :reg_f150 do
      column :id, Integer, primary_key: true
      column :id_pai, Integer, index: true, null: false
      column :nat_bc_cred, String, size: 2
      column :vl_tot_est, BigDecimal, size: [18, 2]
      column :est_imp, BigDecimal, size: [18, 2]
      column :vl_bc_est, BigDecimal, size: [18, 2]
      column :vl_bc_men_est, BigDecimal, size: [18, 2]
      column :cst_pis, String, size: 2
      column :aliq_pis, BigDecimal, size: [18, 4]
      column :vl_cred_pis, BigDecimal, size: [18, 2]
      column :cst_cofins, String, size: 2
      column :aliq_cofins, BigDecimal, size: [18, 4]
      column :vl_cred_cofins, BigDecimal, size: [18, 2]
      column :desc_est, String, size: 100
      column :cod_cta, String, size: 60
      column :cnpj_pai, String, size: 14, index: true
    end
  end
end

Version data entries

5 entries across 3 versions & 1 rubygems

Version Path
sped2db-1.2.0 migrations/contrib/v002/122_create_table_reg_f150.rb
sped2db-1.1.1 migrations/contrib/v002/122_create_table_reg_f150.rb
sped2db-1.1.1 migrations/contrib/v003/119_create_table_reg_f150.rb
sped2db-1.1.0 migrations/contrib/v002/122_create_table_reg_f150.rb
sped2db-1.1.0 migrations/contrib/v003/119_create_table_reg_f150.rb