vZgVEuZE

1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET NAMES utf8 */;
3/*!50503 SET NAMES utf8mb4 */;
4/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
5/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
6
7CREATE TABLE IF NOT EXISTS `opsal_ordenes_edi` (
8  `codigo_orden_edi` int(11) NOT NULL AUTO_INCREMENT,
9  `codigo_orden` int(11) NOT NULL,
10  `codigo_movimiento` int(11) NOT NULL,
11  `fechatiempo` datetime NOT NULL,
12  `edi_raw` text NOT NULL,
13  `estado` tinyint(1) NOT NULL,
14  PRIMARY KEY (`codigo_orden_edi`),
15  KEY `resultado` (`estado`),
16  KEY `fechatiempo` (`fechatiempo`),
17  KEY `codigo_orden_codigo_movimiento` (`codigo_orden`,`codigo_movimiento`)
18) ENGINE=InnoDB AUTO_INCREMENT=27245 DEFAULT CHARSET=latin1;
19
20/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
21/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
22/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;