START TRANSACTION;
truncate country;
truncate module;
truncate group_module;
truncate role;
truncate system_;
truncate group_system;
truncate user;
truncate user_country;
truncate service_variables;
truncate service_capacity;
truncate config;
truncate letter;
truncate numbers;
INSERT INTO `service_variables` VALUES (1,1.2,0.9,2,0,0);
INSERT INTO `service_capacity` VALUES (1,1,50,10,2.5,4.4,100,22,264,5,15,5,8,77),(2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,6,380,10,2,3.1,50,22,264,5,15,5,8,85),(7,7,124,5,2,3.9,70,22,264,5,15,5,8,63),(8,8,0,10,2,2.5,50,22,264,5,15,5,8,45),(9,9,0,10,2,3,50,22,264,5,15,5,8,24),(10,10,146,10,2,3.4,50,22,264,5,15,5,8,94),(11,11,23,10,2,2.4,50,22,264,5,15,5,8,53),(12,12,38,10,2,5.4,50,22,264,5,15,5,8,50),(13,13,111,10,2,2.8,50,22,264,5,15,5,8,42),(14,14,115,10,2,2.4,50,22,264,5,15,5,8,61),(15,15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,17,1401,10,2,3.5,50,22,264,5,15,5,8,65),(18,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,19,203,10,2,1.9,50,22,264,5,15,5,8,56),(20,20,60,10,2,5,50,22,264,5,15,5,8,84),(21,21,140,10,2,3.8,83,22,264,5,15,5,8,71),(22,22,245,10,2,3.2,50,22,264,5,15,5,8,70),(23,23,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,24,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,25,58,10,2,2.7,50,22,264,5,15,5,8,61),(26,26,10,10,2,2.7,50,22,264,5,15,5,8,73),(27,27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,28,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,29,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `config` VALUES (1,'disclaimer','This tool provides a recommendation that must be validated by the markets prior to place any purchase order.');
INSERT INTO `letter` VALUES (1,1,'A',12,12,'2017-06-02 12:31:52','2018-05-17 15:40:55'),(2,1,'B',5,11,'2017-06-02 12:31:52','2018-05-17 15:40:55'),(3,1,'C',1,4,'2017-06-02 12:32:19','2018-05-17 15:40:55'),(4,1,'D',0,12,'2017-06-02 12:32:19','2018-05-17 15:40:56'),(5,1,'OBSOLETE',0,24,'2017-06-02 12:32:40','2018-05-17 15:40:56'),(6,2,'A',9,12,'2017-06-29 00:07:40','2018-05-17 15:42:01'),(7,2,'B',5,8,'2017-06-29 00:07:40','2018-05-17 15:42:01'),(8,2,'C',1,4,'2017-06-29 00:07:40','2018-05-17 15:42:01'),(9,2,'D',0,12,'2017-06-29 00:07:40','2018-05-17 15:42:02'),(10,2,'OBSOLETE',0,12,'2017-06-29 00:07:40','2018-05-17 15:42:02'),(11,3,'A',12,12,'2017-06-29 00:15:01','2017-06-29 00:15:01'),(12,3,'B',5,11,'2017-06-29 00:15:01','2017-06-29 00:15:01'),(13,3,'C',1,4,'2017-06-29 00:15:01','2017-06-29 00:15:01'),(14,3,'D',0,12,'2017-06-29 00:15:01','2017-06-29 00:15:01'),(15,3,'OBSOLETE',0,24,'2017-06-29 00:15:01','2017-06-29 00:15:01'),(16,10,'A',12,12,'2017-11-29 16:59:46','2018-04-04 22:35:15'),(17,10,'B',4,11,'2017-11-29 16:59:46','2018-04-04 22:35:15'),(18,10,'C',1,3,'2017-11-29 16:59:46','2018-04-04 22:35:15'),(19,10,'D',0,12,'2017-11-29 16:59:46','2018-04-04 22:35:17'),(20,10,'OBSOLETE',0,24,'2017-11-29 16:59:46','2018-04-04 22:35:17'),(21,6,'A',12,12,'2017-11-29 17:29:03','2017-11-29 17:29:20'),(22,6,'B',5,11,'2017-11-29 17:29:05','2017-11-29 17:29:18'),(23,6,'C',1,4,'2017-11-29 17:29:06','2017-11-29 17:29:15'),(24,6,'D',0,12,'2017-11-29 17:29:07','2017-11-29 17:29:10'),(25,6,'OBSOLETE',0,24,'2017-11-29 17:29:08','2017-11-29 17:29:13'),(26,5,'A',12,12,'2017-12-01 19:52:43','2018-02-15 21:23:45'),(27,5,'B',5,11,'2017-12-01 19:52:45','2018-02-15 21:23:46'),(28,5,'C',1,4,'2017-12-01 19:52:50','2018-02-15 21:23:45'),(29,5,'D',0,12,'2017-12-01 19:52:53','2018-02-15 21:23:46'),(30,5,'OBSOLETE',0,24,'2017-12-01 19:52:54','2018-02-15 21:23:46'),(51,15,'A',12,12,'2017-12-07 19:18:41','2017-12-07 19:18:41'),(52,15,'B',5,11,'2017-12-07 19:18:41','2017-12-07 19:18:41'),(53,15,'C',1,4,'2017-12-07 19:18:41','2017-12-07 19:18:41'),(54,15,'D',0,0,'2017-12-07 19:18:41','2017-12-07 19:18:41'),(55,15,'OBSOLETE',0,0,'2017-12-07 19:18:41','2017-12-07 19:18:41'),(56,4,'B',5,11,'2017-12-14 13:32:50','2017-12-14 13:32:50'),(57,4,'C',1,4,'2017-12-14 13:32:50','2017-12-14 13:32:50'),(58,4,'A',12,12,'2017-12-14 13:32:50','2017-12-14 13:32:50'),(59,4,'D',0,0,'2017-12-14 13:32:50','2017-12-14 13:32:50'),(60,4,'OBSOLETE',0,0,'2017-12-14 13:32:50','2017-12-14 13:32:50'),(61,8,'A',12,12,'2017-12-14 17:53:48','2017-12-14 17:53:48'),(62,8,'D',0,0,'2017-12-14 17:53:49','2017-12-14 17:53:49'),(63,8,'B',5,11,'2017-12-14 17:53:49','2017-12-14 17:53:49'),(64,8,'C',1,4,'2017-12-14 17:53:49','2017-12-14 17:53:49'),(65,8,'OBSOLETE',0,0,'2017-12-14 17:53:50','2017-12-14 17:53:50'),(66,7,'A',12,12,'2018-02-15 20:36:18','2018-02-15 21:37:36'),(67,7,'D',0,12,'2018-02-15 20:36:18','2018-02-15 21:37:37'),(68,7,'B',5,11,'2018-02-15 20:36:19','2018-02-15 21:37:36'),(69,7,'C',1,4,'2018-02-15 20:36:19','2018-02-15 21:37:36'),(70,7,'OBSOLETE',0,24,'2018-02-15 20:36:19','2018-02-15 21:37:37'),(71,22,'B',5,11,'2018-03-07 21:26:04','2018-03-07 21:26:04'),(72,22,'C',1,4,'2018-03-07 21:26:04','2018-03-07 21:26:04'),(73,22,'A',12,12,'2018-03-07 21:26:04','2018-03-07 21:26:04'),(74,22,'D',0,12,'2018-03-07 21:26:04','2018-03-07 21:26:04'),(75,22,'OBSOLETE',0,24,'2018-03-07 21:26:04','2018-03-07 21:26:04'),(76,23,'A',12,12,'2018-05-22 18:17:30','2018-05-22 18:17:30'),(77,23,'D',0,12,'2018-05-22 18:17:31','2018-05-22 18:17:31'),(78,23,'C',1,3,'2018-05-22 18:17:31','2018-05-22 18:17:31'),(79,23,'B',4,11,'2018-05-22 18:17:31','2018-05-22 18:17:31'),(80,23,'OBSOLETE',0,24,'2018-05-22 18:17:31','2018-05-22 18:17:32'),(81,30,'A',12,12,'2018-07-18 20:13:51','2018-07-18 20:14:03'),(82,30,'D',0,12,'2018-07-18 20:13:52','2018-07-18 20:14:04'),(83,30,'B',5,11,'2018-07-18 20:13:52','2018-07-18 20:14:03'),(84,30,'C',1,4,'2018-07-18 20:13:52','2018-07-18 20:14:03'),(85,30,'OBSOLETE',0,24,'2018-07-18 20:13:53','2018-07-18 20:14:04'),(86,19,'A',12,12,'2018-07-25 15:07:42','2018-07-25 15:07:42'),(87,19,'D',0,12,'2018-07-25 15:07:42','2018-07-25 15:07:42'),(88,19,'C',1,4,'2018-07-25 15:07:43','2018-07-25 15:07:43'),(89,19,'B',5,11,'2018-07-25 15:07:43','2018-07-25 15:07:43'),(90,19,'OBSOLETE',0,24,'2018-07-25 15:07:43','2018-07-25 15:07:43'),(91,33,'A',12,12,'2019-01-16 15:30:51','2019-01-16 15:30:52'),(92,33,'C',1,4,'2019-01-16 15:30:52','2019-01-16 15:30:52'),(93,33,'B',5,11,'2019-01-16 15:30:52','2019-01-16 15:30:52'),(94,33,'D',0,12,'2019-01-16 15:30:52','2019-01-16 15:30:52'),(95,33,'OBSOLETE',0,24,'2019-01-16 15:30:52','2019-01-16 15:30:53');
INSERT INTO `numbers` VALUES (1,1,'1',0,9.99,9.99,'2017-06-02 12:16:33','2018-05-17 15:40:56'),(2,1,'2',10,99.99,10,'2017-06-02 12:16:33','2018-05-17 15:40:56'),(3,1,'3',100,499.99,100,'2017-06-02 00:00:00','2018-05-17 15:40:57'),(4,1,'4',500,10000000,500,'2017-06-02 12:18:12','2018-05-17 15:40:57'),(5,2,'1',0,13.99,9.99,'2017-06-29 00:19:09','2018-05-17 15:42:02'),(6,2,'2',14,133.99,10,'2017-06-29 00:19:09','2018-05-17 15:42:03'),(7,2,'3',134,1000000.99,100,'2017-06-29 00:19:09','2018-05-17 15:42:04'),(8,2,'4',1000001,10000000,500,'2017-06-29 00:19:09','2018-05-17 15:42:04'),(9,3,'1',0,9.99,9.99,'2017-06-29 00:23:12','2017-06-29 00:23:12'),(10,3,'2',10,99.99,10,'2017-06-29 00:23:12','2017-06-29 00:23:12'),(11,3,'3',100,499.99,100,'2017-06-29 00:23:12','2017-06-29 00:23:12'),(12,3,'4',500,1000000,500,'2017-06-29 00:23:12','2017-06-29 00:23:12'),(13,10,'1',0,9.99,0,'2017-11-29 16:59:46','2018-04-04 22:35:17'),(14,10,'2',10,99.99,10,'2017-11-29 16:59:46','2018-04-04 22:35:17'),(15,10,'3',100,499.99,100,'2017-11-29 16:59:46','2018-04-04 22:35:17'),(16,10,'4',500,100000,500,'2017-11-29 16:59:46','2018-04-04 22:35:17'),(17,6,'1',0,9.99,0,'2017-11-29 17:29:22','2017-11-29 17:29:39'),(18,6,'2',10,99.99,0,'2017-11-29 17:29:23','2017-11-29 17:29:42'),(19,6,'3',100,499.99,0,'2017-11-29 17:29:34','2017-11-29 17:29:47'),(20,6,'4',500,1000000,0,'2017-11-29 17:29:36','2017-11-29 17:29:56'),(21,5,'1',0,9.99,0,'2017-12-01 19:52:59','2018-02-15 21:23:46'),(22,5,'2',10,99.99,0,'2017-12-01 19:53:03','2018-02-15 21:23:47'),(23,5,'3',100,499.99,0,'2017-12-01 19:53:07','2018-02-15 21:23:47'),(24,5,'4',500,999999999999,0,'2017-12-01 19:53:10','2018-02-15 21:23:47'),(41,15,'1',0,9.99,0,'2017-12-07 19:18:41','2017-12-07 19:18:41'),(42,15,'2',10,99.99,10,'2017-12-07 19:18:41','2017-12-07 19:18:41'),(43,15,'3',100,499.99,100,'2017-12-07 19:18:41','2017-12-07 19:18:41'),(44,15,'4',500,999999999,500,'2017-12-07 19:18:41','2017-12-07 19:18:41'),(45,4,'1',0,9.99,0,'2017-12-14 13:32:50','2017-12-14 13:32:50'),(46,4,'2',10,99.99,0,'2017-12-14 13:32:51','2017-12-14 13:32:51'),(47,4,'3',100,499.99,0,'2017-12-14 13:32:51','2017-12-14 13:32:51'),(48,4,'4',500,1e27,0,'2017-12-14 13:32:51','2017-12-14 13:32:51'),(49,8,'1',0,9.99,0,'2017-12-14 17:53:49','2017-12-14 17:53:50'),(50,8,'2',10,99.99,0,'2017-12-14 17:53:50','2017-12-14 17:53:50'),(51,8,'3',100,499.99,0,'2017-12-14 17:53:50','2017-12-14 17:53:50'),(52,8,'4',500,9999999,0,'2017-12-14 17:53:50','2017-12-14 17:53:50'),(53,7,'1',0,9.99,0,'2018-02-15 20:36:19','2018-02-15 21:37:37'),(54,7,'2',10,99.99,0,'2018-02-15 20:36:19','2018-02-15 21:37:37'),(55,7,'3',100,499.99,0,'2018-02-15 20:36:19','2018-02-15 21:37:37'),(56,7,'4',500,1000000,0,'2018-02-15 20:36:19','2018-02-15 21:37:38'),(57,22,'1',0,9.99,0,'2018-03-07 21:26:04','2018-03-07 21:26:04'),(58,22,'2',10,99.99,0,'2018-03-07 21:26:04','2018-03-07 21:26:04'),(59,22,'3',100,499.99,0,'2018-03-07 21:26:04','2018-03-07 21:26:05'),(60,22,'4',500,10000000,0,'2018-03-07 21:26:05','2018-03-07 21:26:05'),(61,23,'1',0,9.99,0,'2018-05-22 18:17:31','2018-05-22 18:17:31'),(62,23,'2',10,99.99,0,'2018-05-22 18:17:31','2018-05-22 18:17:31'),(63,23,'3',100,499.99,0,'2018-05-22 18:17:31','2018-05-22 18:17:32'),(64,23,'4',500,1000000,0,'2018-05-22 18:17:32','2018-05-22 18:17:32'),(65,30,'1',0,9.99,0,'2018-07-18 20:13:53','2018-07-18 20:14:04'),(66,30,'2',10,99.99,0,'2018-07-18 20:13:53','2018-07-18 20:14:05'),(67,30,'3',100,499.99,0,'2018-07-18 20:13:53','2018-07-18 20:14:05'),(68,30,'4',500,1000000,0,'2018-07-18 20:13:53','2018-07-18 20:14:05'),(69,19,'1',0,9.99,0,'2018-07-25 15:07:43','2018-07-25 15:07:43'),(70,19,'2',10,99.99,0,'2018-07-25 15:07:43','2018-07-25 15:07:43'),(71,19,'3',100,499.99,0,'2018-07-25 15:07:43','2018-07-25 15:07:43'),(72,19,'4',500,1000000,0,'2018-07-25 15:07:43','2018-07-25 15:07:43'),(73,33,'1',0,9.99,0,'2019-01-16 15:30:53','2019-01-16 15:30:53'),(74,33,'2',10,99.99,0,'2019-01-16 15:30:53','2019-01-16 15:30:53'),(75,33,'3',100,499.99,0,'2019-01-16 15:30:53','2019-01-16 15:30:53'),(76,33,'4',500,1000000,0,'2019-01-16 15:30:53','2019-01-16 15:30:54');
--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `name`, `acronym`, `flag`, `status`, `region`) VALUES
(1, 'Argentina', 'ARG', 0x[encoded data, 239196 characters], 1, 'I');
INSERT INTO `country` (`id`, `name`, `acronym`, `flag`, `status`, `region`) VALUES
(2, 'Barbados', 'BRB', 0x[encoded data, 10124 characters], 1, NULL);
INSERT INTO `country` (`id`, `name`, `acronym`, `flag`, `status`, `region`) VALUES
(3, 'Bolivia', 'BOL', 0x[encoded data, 159830 characters], 1, 'II');
