funcionarios

class CreateFuncionarios < ActiveRecord::Migration
  def change
    create_table :funcionarios, id: false   do |t|
      t.string  :Login, :limit => 30, primary_key: true
      t.integer :Matricula
      t.string  :Nome
      t.date    :DataAdmissao
      t.date    :DataDemissao
      t.string  :Email
      t.string  :CPF, :limit => 20
      t.string  :Identidade, :limit => 20
      t.string  :CodigoCC , :limit => 6
      t.string  :NomeCC
      t.string  :NomeTipoCC
      t.string  :OwnerCC
      t.string  :CodigoSecao, :limit => 10
      t.string  :NomeLocalTrabalho
      t.string  :NomeCidadeTrabalho
      t.string  :CCTorre, :limit => 6
      t.string  :DescCCTorre
    end
  end
end


create_table "funcionarios", primary_key: "Login", force: :cascade do |t|
    t.integer  "NumMatrProfissional",          limit: 4
    t.string   "NomProfissional",              limit: 50
    t.date     "DtaAdmissao"
    t.date     "DtaDemissao"
    t.string   "NomEmailBRQ",                  limit: 50
    t.string   "IdtCPF",                       limit: 20
    t.string   "IdtRG",                        limit: 20
    t.string   "IdtCodigoCentroCusto",         limit: 10
    t.string   "NomCentroCusto",               limit: 255
    t.string   "NomTipoCentroCusto",           limit: 255
    t.string   "IdtCodigoSecao",               limit: 10
    t.string   "NomLocalTrabalho",             limit: 50
    t.string   "NomCidadeLocalTrabalho",       limit: 50
    t.string   "IdtCentroCustoTorre",          limit: 10
 ....
 
 
 
 mysql> describe itmgmt_new.funcionarios;
+------------------------------+--------------+------+-----+---------+----------------+
| Field                        | Type         | Null | Key | Default | Extra          |
+------------------------------+--------------+------+-----+---------+----------------+
| Login                        | int(11)      | NO   | PRI | NULL    | auto_increment |

mysql> describe itmgmt_new.funcionarios;
+------------------------------+--------------+------+-----+---------+-------+
| Field                        | Type         | Null | Key | Default | Extra |
+------------------------------+--------------+------+-----+---------+-------+
| Login                        | varchar(30)  | NO   | PRI |         |       |