Contents

Sequel.migration do
  change do
    create_table :reg_d180 do
      column :id, Integer, primary_key: true
      column :id_pai, Integer, index: true, null: false
      column :num_seq, Integer
      column :ind_emit, String, size: 1
      column :cnpj_cpf_emit, String, size: 14
      column :uf_emit, String, size: 2
      column :ie_emit, String, size: 14
      column :cod_mun_orig, String, size: 7
      column :cnpj_cpf_tom, String, size: 14
      column :uf_tom, String, size: 2
      column :ie_tom, String, size: 14
      column :cod_mun_dest, String, size: 7
      column :cod_mod, String, size: 2
      column :ser, String, size: 4
      column :sub, String, size: 3
      column :num_doc, String, size: 9
      column :dt_doc, Date
      column :vl_doc, BigDecimal, size: [18, 2]
      column :cnpj_pai, String, size: 14, index: true
    end
  end
end

Version data entries

9 entries across 3 versions & 1 rubygems

Version	Path
sped2db-1.2.0	migrations/fiscal/v011/130_create_table_reg_d180.rb
sped2db-1.2.0	migrations/fiscal/v009/127_create_table_reg_d180.rb
sped2db-1.2.0	migrations/fiscal/v010/130_create_table_reg_d180.rb
sped2db-1.1.1	migrations/fiscal/v010/130_create_table_reg_d180.rb
sped2db-1.1.1	migrations/fiscal/v009/127_create_table_reg_d180.rb
sped2db-1.1.1	migrations/fiscal/v011/130_create_table_reg_d180.rb
sped2db-1.1.0	migrations/fiscal/v009/127_create_table_reg_d180.rb
sped2db-1.1.0	migrations/fiscal/v011/130_create_table_reg_d180.rb
sped2db-1.1.0	migrations/fiscal/v010/130_create_table_reg_d180.rb