Sha256: 30207f652282c86dace4e15ec74c3f3f865f3612d43a4b6e61fadf6f403518b2

Contents?: true

Size: 802 Bytes

Versions: 3

Compression:

Stored size: 802 Bytes

Contents

Sequel.migration do
  change do
    create_table :reg_i100 do
      column :id, :Bignum, primary_key: true
      column :id_pai, :Bignum, index: true, null: false
      column :vl_rec_fin, BigDecimal, size: [18, 2]
      column :cst, String, size: 2
      column :vl_tot_ded_ger, BigDecimal, size: [18, 2]
      column :vl_tot_ded_esp, BigDecimal, size: [18, 2]
      column :vl_bc_pis, BigDecimal, size: [18, 2]
      column :aliq_pis, BigDecimal, size: [18, 2]
      column :vl_pis, BigDecimal, size: [18, 2]
      column :vl_bc_cofins, BigDecimal, size: [18, 2]
      column :aliq_cofins, BigDecimal, size: [18, 2]
      column :vl_cofins, BigDecimal, size: [18, 2]
      column :inf_comp, String, size: 90
      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/139_create_table_reg_i100.rb
sped2db-1.2.0 migrations/contrib/v004/139_create_table_reg_i100.rb
sped2db-1.2.0 migrations/contrib/v005/140_create_table_reg_i100.rb