CREATE TABLE `transaccion_medicamentos_enc` (
  `id` int not null PRIMARY KEY AUTO_INCREMENT,
  `serie` varchar(15) NOT NULL DEFAULT 'SAL-MED-',  
  `folio` int NOT NULL,
  `fecha` date NOT NULL,
  `created_user` int(3) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `nombre` varchar(150) NOT NULL,
  `status` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `transaccion_medicamentos_enc`  
  ADD KEY `created_user` (`created_user`);


ALTER TABLE `transaccion_medicamentos` ADD `idenc` INT NULL DEFAULT NULL AFTER `almacen`;