DROP TABLE IF EXISTS log_unid_oper;

CREATE TABLE log_unid_oper (
  uop_nu_sequencial INTEGER NOT NULL DEFAULT 0, 
  ufe_sg VARCHAR(2) NOT NULL, 
  loc_nu_sequencial INTEGER NOT NULL DEFAULT 0, 
  log_nu_sequencial INTEGER DEFAULT 0, 
  bai_nu_sequencial INTEGER NOT NULL DEFAULT 0, 
  uop_no VARCHAR(100) NOT NULL, 
  cep VARCHAR(16) NOT NULL, 
  uop_endereco VARCHAR(200) NOT NULL, 
  uop_in_cp VARCHAR(1), 
  temp VARCHAR(8), 
  PRIMARY KEY (uop_nu_sequencial)
);
