Sha256: 21537fed3a51a3c5ed29ed98df10ff16fec99ddd24bc6315e941fb92bbee6411

Contents?: true

Size: 1.12 KB

Versions: 14

Compression:

Stored size: 1.12 KB

Contents

Sequel.migration do
  change do
    create_table :reg_c600 do
      column :id, Integer, primary_key: true
      column :id_pai, Integer, index: true, null: false
      column :cod_mod, String, size: 2
      column :cod_mun, String, size: 7
      column :ser, String, size: 4
      column :sub, String, size: 3
      column :cod_cons, String, size: 2
      column :qtd_cons, Integer
      column :qtd_canc, Integer
      column :dt_doc, Date
      column :vl_doc, BigDecimal, size: [18, 2]
      column :vl_desc, BigDecimal, size: [18, 2]
      column :cons, Integer
      column :vl_forn, BigDecimal, size: [18, 2]
      column :vl_serv_nt, BigDecimal, size: [18, 2]
      column :vl_terc, BigDecimal, size: [18, 2]
      column :vl_da, BigDecimal, size: [18, 2]
      column :vl_bc_icms, BigDecimal, size: [18, 2]
      column :vl_icms, BigDecimal, size: [18, 2]
      column :vl_bc_icms_st, BigDecimal, size: [18, 2]
      column :vl_icms_st, BigDecimal, size: [18, 2]
      column :vl_pis, BigDecimal, size: [18, 2]
      column :vl_cofins, BigDecimal, size: [18, 2]
      column :cnpj_pai, String, size: 14, index: true
    end
  end
end

Version data entries

14 entries across 3 versions & 1 rubygems

Version Path
sped2db-1.2.0 migrations/contrib/v002/086_create_table_reg_c600.rb
sped2db-1.2.0 migrations/fiscal/v011/106_create_table_reg_c600.rb
sped2db-1.2.0 migrations/fiscal/v010/106_create_table_reg_c600.rb
sped2db-1.2.0 migrations/fiscal/v009/104_create_table_reg_c600.rb
sped2db-1.1.1 migrations/fiscal/v009/104_create_table_reg_c600.rb
sped2db-1.1.1 migrations/contrib/v002/086_create_table_reg_c600.rb
sped2db-1.1.1 migrations/contrib/v003/079_create_table_reg_c600.rb
sped2db-1.1.1 migrations/fiscal/v010/106_create_table_reg_c600.rb
sped2db-1.1.1 migrations/fiscal/v011/106_create_table_reg_c600.rb
sped2db-1.1.0 migrations/contrib/v003/079_create_table_reg_c600.rb
sped2db-1.1.0 migrations/fiscal/v011/106_create_table_reg_c600.rb
sped2db-1.1.0 migrations/fiscal/v010/106_create_table_reg_c600.rb
sped2db-1.1.0 migrations/contrib/v002/086_create_table_reg_c600.rb
sped2db-1.1.0 migrations/fiscal/v009/104_create_table_reg_c600.rb