API tools faq
paste
Advertisement
robertjota

base de datos inventario

robertjota
Oct 29th, 2024
198
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 148.21 KB | Source Code | 0 0
raw download clone embed print report
  1. /*
  2.  Navicat Premium Data Transfer
  3.  
  4.  Source Server         : Heli-Global
  5.  Source Server Type    : MySQL
  6.  Source Server Version : 80039 (8.0.39-cll-lve)
  7.  Source Host           : localhost:3306
  8.  Source Schema         : heliglob_heli-global
  9.  
  10.  Target Server Type    : MySQL
  11.  Target Server Version : 80039 (8.0.39-cll-lve)
  12.  File Encoding         : 65001
  13.  
  14.  Date: 29/10/2024 20:27:04
  15. */
  16.  
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  19.  
  20. -- ----------------------------
  21. -- Table structure for acceso
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `acceso`;
  24. CREATE TABLE `acceso`  (
  25.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'Identificador del acceso',
  26.   `usuario_id` int NOT NULL COMMENT 'Identificador del usuario que accede',
  27.   `tipo_acceso` int NOT NULL DEFAULT 1 COMMENT 'Tipo de acceso (entrata o salida)',
  28.   `ip` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Dirección IP del usuario que ingresa',
  29.   `acceso_at` datetime NULL DEFAULT NULL COMMENT 'Fecha de registro del acceso',
  30.   PRIMARY KEY (`id`) USING BTREE,
  31.   INDEX `fk_acceso_usuario_idx`(`usuario_id` ASC) USING BTREE,
  32.   CONSTRAINT `acceso_ibfk_1` FOREIGN KEY (`usuario_id`) REFERENCES `usuario` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
  33. ) ENGINE = InnoDB AUTO_INCREMENT = 1086 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'Tabla que registra los accesos de los usuarios al sistema' ROW_FORMAT = Dynamic;
  34.  
  35. -- ----------------------------
  36. -- Records of acceso
  37. -- ----------------------------
  38. INSERT INTO `acceso` VALUES (23, 1, 1, '201.211.93.159', '2021-02-06 23:49:43');
  39. INSERT INTO `acceso` VALUES (24, 1, 1, '190.206.251.89', '2021-02-06 23:50:43');
  40. INSERT INTO `acceso` VALUES (25, 1, 1, '201.211.93.159', '2021-02-07 00:18:48');
  41. INSERT INTO `acceso` VALUES (26, 1, 2, '201.211.93.159', '2021-02-07 00:19:10');
  42. INSERT INTO `acceso` VALUES (27, 1, 1, '200.93.115.229', '2021-02-07 17:40:30');
  43. INSERT INTO `acceso` VALUES (28, 1, 1, '201.211.93.159', '2021-02-07 20:34:26');
  44. INSERT INTO `acceso` VALUES (29, 1, 2, '201.211.93.159', '2021-02-07 20:44:42');
  45. INSERT INTO `acceso` VALUES (30, 1, 1, '201.211.93.159', '2021-02-07 22:06:30');
  46. INSERT INTO `acceso` VALUES (31, 1, 2, '201.211.93.159', '2021-02-08 00:03:12');
  47. INSERT INTO `acceso` VALUES (32, 1, 1, '201.211.93.159', '2021-02-08 00:27:07');
  48. INSERT INTO `acceso` VALUES (33, 1, 2, '201.211.93.159', '2021-02-08 00:29:17');
  49. INSERT INTO `acceso` VALUES (34, 1, 1, '190.74.88.83', '2021-02-08 16:31:21');
  50. INSERT INTO `acceso` VALUES (35, 1, 2, '190.74.88.83', '2021-02-08 21:06:03');
  51. INSERT INTO `acceso` VALUES (36, 1, 1, '190.74.88.83', '2021-02-08 21:07:54');
  52. INSERT INTO `acceso` VALUES (37, 1, 1, '201.211.93.159', '2021-02-11 23:25:36');
  53. INSERT INTO `acceso` VALUES (38, 1, 1, '64.211.66.30', '2021-02-12 14:43:38');
  54. INSERT INTO `acceso` VALUES (39, 1, 1, '201.211.93.159', '2021-02-13 20:40:45');
  55. INSERT INTO `acceso` VALUES (40, 1, 2, '201.211.93.159', '2021-02-13 20:41:45');
  56. INSERT INTO `acceso` VALUES (41, 1, 1, '186.90.187.96', '2021-02-20 12:03:09');
  57. INSERT INTO `acceso` VALUES (44, 1, 1, '190.74.71.111', '2021-02-24 01:41:23');
  58. INSERT INTO `acceso` VALUES (45, 1, 1, '190.36.94.128', '2021-03-22 14:25:06');
  59. INSERT INTO `acceso` VALUES (46, 1, 1, '190.74.207.5', '2021-04-09 21:38:05');
  60. INSERT INTO `acceso` VALUES (47, 1, 1, '190.74.207.5', '2021-04-09 23:40:26');
  61. INSERT INTO `acceso` VALUES (170, 1, 1, '186.90.62.251', '2022-03-31 23:08:14');
  62. INSERT INTO `acceso` VALUES (275, 1, 1, '190.74.2.33', '2022-04-12 22:16:26');
  63. INSERT INTO `acceso` VALUES (276, 1, 1, '186.167.248.93', '2022-04-13 16:39:09');
  64. INSERT INTO `acceso` VALUES (277, 1, 2, '186.167.248.93', '2022-04-13 16:40:59');
  65. INSERT INTO `acceso` VALUES (280, 1, 1, '190.74.2.33', '2022-04-14 11:45:15');
  66. INSERT INTO `acceso` VALUES (281, 1, 1, '190.74.2.33', '2022-04-14 12:25:37');
  67. INSERT INTO `acceso` VALUES (282, 1, 2, '190.74.2.33', '2022-04-14 12:51:22');
  68. INSERT INTO `acceso` VALUES (283, 1, 1, '200.229.216.98', '2022-04-14 15:33:56');
  69. INSERT INTO `acceso` VALUES (284, 1, 1, '190.74.2.33', '2022-04-14 16:49:25');
  70. INSERT INTO `acceso` VALUES (285, 1, 1, '190.74.2.33', '2022-04-15 17:02:05');
  71. INSERT INTO `acceso` VALUES (286, 1, 1, '190.74.2.33', '2022-04-15 18:24:32');
  72. INSERT INTO `acceso` VALUES (287, 1, 2, '190.74.2.33', '2022-04-15 18:40:23');
  73. INSERT INTO `acceso` VALUES (290, 2, 1, '190.79.211.153', '2022-04-15 23:35:33');
  74. INSERT INTO `acceso` VALUES (291, 1, 1, '190.74.2.33', '2022-04-16 10:28:25');
  75. INSERT INTO `acceso` VALUES (292, 1, 1, '190.202.58.166', '2022-04-18 13:10:48');
  76. INSERT INTO `acceso` VALUES (293, 2, 1, '190.36.236.96', '2022-04-20 00:13:23');
  77. INSERT INTO `acceso` VALUES (294, 2, 2, '190.36.236.96', '2022-04-20 00:15:57');
  78. INSERT INTO `acceso` VALUES (295, 2, 1, '190.36.236.96', '2022-04-20 22:37:54');
  79. INSERT INTO `acceso` VALUES (296, 2, 1, '190.36.236.96', '2022-04-20 22:54:19');
  80. INSERT INTO `acceso` VALUES (297, 2, 2, '190.36.236.96', '2022-04-20 23:03:24');
  81. INSERT INTO `acceso` VALUES (298, 2, 1, '190.36.236.96', '2022-04-20 23:03:28');
  82. INSERT INTO `acceso` VALUES (299, 2, 2, '190.36.236.96', '2022-04-20 23:03:49');
  83. INSERT INTO `acceso` VALUES (300, 2, 1, '190.36.236.96', '2022-04-20 23:03:57');
  84. INSERT INTO `acceso` VALUES (301, 2, 2, '190.36.236.96', '2022-04-20 23:05:22');
  85. INSERT INTO `acceso` VALUES (302, 2, 1, '190.36.236.96', '2022-04-20 23:05:28');
  86. INSERT INTO `acceso` VALUES (303, 2, 2, '190.36.236.96', '2022-04-20 23:06:39');
  87. INSERT INTO `acceso` VALUES (304, 2, 1, '190.36.236.96', '2022-04-20 23:06:42');
  88. INSERT INTO `acceso` VALUES (305, 2, 1, '190.36.236.96', '2022-04-22 19:55:18');
  89. INSERT INTO `acceso` VALUES (306, 1, 1, '190.202.58.166', '2022-04-26 14:29:35');
  90. INSERT INTO `acceso` VALUES (307, 2, 1, '201.211.166.188', '2022-05-01 17:16:35');
  91. INSERT INTO `acceso` VALUES (308, 2, 1, '201.211.166.188', '2022-05-01 19:36:02');
  92. INSERT INTO `acceso` VALUES (309, 2, 1, '201.211.166.188', '2022-05-02 01:09:12');
  93. INSERT INTO `acceso` VALUES (310, 2, 1, '201.211.166.188', '2022-05-02 15:56:48');
  94. INSERT INTO `acceso` VALUES (311, 2, 1, '201.211.166.188', '2022-05-02 17:13:02');
  95. INSERT INTO `acceso` VALUES (312, 2, 1, '201.211.166.188', '2022-05-02 17:13:21');
  96. INSERT INTO `acceso` VALUES (313, 2, 1, '201.211.166.188', '2022-05-02 17:14:13');
  97. INSERT INTO `acceso` VALUES (314, 2, 1, '201.211.166.188', '2022-05-02 18:10:17');
  98. INSERT INTO `acceso` VALUES (315, 2, 2, '201.211.166.188', '2022-05-02 19:08:24');
  99. INSERT INTO `acceso` VALUES (316, 2, 1, '201.211.166.188', '2022-05-02 19:08:27');
  100. INSERT INTO `acceso` VALUES (317, 2, 1, '201.211.166.188', '2022-05-02 20:14:18');
  101. INSERT INTO `acceso` VALUES (318, 2, 2, '201.211.166.188', '2022-05-02 21:33:55');
  102. INSERT INTO `acceso` VALUES (319, 2, 1, '201.211.166.188', '2022-05-02 21:34:00');
  103. INSERT INTO `acceso` VALUES (320, 1, 1, '201.211.63.112', '2022-05-02 22:07:40');
  104. INSERT INTO `acceso` VALUES (321, 2, 1, '201.211.48.121', '2022-05-03 00:07:54');
  105. INSERT INTO `acceso` VALUES (322, 1, 1, '190.202.58.166', '2022-05-03 12:10:24');
  106. INSERT INTO `acceso` VALUES (323, 1, 1, '190.202.58.166', '2022-05-03 12:12:22');
  107. INSERT INTO `acceso` VALUES (324, 1, 2, '190.202.58.166', '2022-05-03 12:14:20');
  108. INSERT INTO `acceso` VALUES (325, 2, 1, '190.75.103.3', '2022-05-03 22:45:22');
  109. INSERT INTO `acceso` VALUES (326, 2, 1, '201.211.48.121', '2022-05-04 12:51:17');
  110. INSERT INTO `acceso` VALUES (327, 1, 1, '200.125.189.14', '2022-05-10 14:34:29');
  111. INSERT INTO `acceso` VALUES (328, 1, 1, '200.125.189.14', '2022-05-10 15:05:13');
  112. INSERT INTO `acceso` VALUES (329, 1, 2, '200.125.189.14', '2022-05-10 15:09:25');
  113. INSERT INTO `acceso` VALUES (330, 2, 1, '186.88.147.238', '2022-05-24 11:10:56');
  114. INSERT INTO `acceso` VALUES (331, 1, 1, '201.242.215.228', '2022-05-28 14:54:50');
  115. INSERT INTO `acceso` VALUES (332, 2, 1, '186.90.42.58', '2022-07-05 13:35:46');
  116. INSERT INTO `acceso` VALUES (333, 2, 1, '190.75.119.4', '2022-09-05 12:54:23');
  117. INSERT INTO `acceso` VALUES (334, 2, 1, '190.75.119.4', '2022-09-06 20:37:02');
  118. INSERT INTO `acceso` VALUES (335, 2, 2, '190.75.119.4', '2022-09-06 20:42:33');
  119. INSERT INTO `acceso` VALUES (336, 2, 1, '190.75.119.4', '2022-09-06 20:42:54');
  120. INSERT INTO `acceso` VALUES (337, 2, 2, '190.75.119.4', '2022-09-06 20:44:25');
  121. INSERT INTO `acceso` VALUES (338, 2, 1, '190.75.119.4', '2022-09-06 20:44:47');
  122. INSERT INTO `acceso` VALUES (339, 2, 2, '190.75.119.4', '2022-09-06 22:03:02');
  123. INSERT INTO `acceso` VALUES (340, 2, 1, '190.75.119.4', '2022-09-06 22:03:08');
  124. INSERT INTO `acceso` VALUES (341, 1, 1, '200.8.152.17', '2022-09-22 06:30:13');
  125. INSERT INTO `acceso` VALUES (342, 1, 1, '200.8.152.17', '2022-09-22 06:56:10');
  126. INSERT INTO `acceso` VALUES (343, 1, 1, '190.114.244.65', '2022-09-22 12:22:22');
  127. INSERT INTO `acceso` VALUES (344, 2, 1, '186.90.29.32', '2022-12-19 10:40:18');
  128. INSERT INTO `acceso` VALUES (345, 2, 1, '201.210.179.106', '2023-05-02 15:00:42');
  129. INSERT INTO `acceso` VALUES (346, 2, 1, '38.41.5.72', '2023-10-19 07:47:52');
  130. INSERT INTO `acceso` VALUES (350, 2, 1, '181.208.127.11', '2024-07-05 16:13:49');
  131. INSERT INTO `acceso` VALUES (351, 2, 1, '38.41.5.73', '2024-08-28 13:27:56');
  132. INSERT INTO `acceso` VALUES (352, 2, 2, '38.41.5.73', '2024-08-28 13:29:53');
  133. INSERT INTO `acceso` VALUES (353, 1, 1, '38.41.5.73', '2024-08-28 13:32:34');
  134. INSERT INTO `acceso` VALUES (354, 1, 1, '190.216.227.34', '2024-08-28 13:34:28');
  135. INSERT INTO `acceso` VALUES (355, 1, 2, '38.41.5.73', '2024-08-28 13:34:48');
  136. INSERT INTO `acceso` VALUES (356, 1, 1, '190.216.227.34', '2024-08-28 13:36:14');
  137. INSERT INTO `acceso` VALUES (357, 1, 1, '38.41.5.73', '2024-08-28 13:44:58');
  138. INSERT INTO `acceso` VALUES (358, 1, 1, '186.188.37.203', '2024-08-28 18:42:00');
  139. INSERT INTO `acceso` VALUES (359, 1, 1, '181.208.127.249', '2024-08-31 21:50:13');
  140. INSERT INTO `acceso` VALUES (360, 1, 1, '181.208.127.249', '2024-08-31 23:19:48');
  141. INSERT INTO `acceso` VALUES (361, 1, 1, '181.208.127.249', '2024-08-31 23:25:45');
  142. INSERT INTO `acceso` VALUES (362, 1, 1, '181.208.127.249', '2024-08-31 23:26:54');
  143. INSERT INTO `acceso` VALUES (363, 1, 2, '181.208.127.249', '2024-08-31 23:48:15');
  144. INSERT INTO `acceso` VALUES (364, 1, 1, '181.208.127.249', '2024-09-01 00:38:19');
  145. INSERT INTO `acceso` VALUES (365, 1, 2, '181.208.127.249', '2024-09-01 00:51:26');
  146. INSERT INTO `acceso` VALUES (366, 1, 1, '181.208.127.249', '2024-09-01 00:51:28');
  147. INSERT INTO `acceso` VALUES (367, 1, 2, '181.208.127.249', '2024-09-01 00:51:38');
  148. INSERT INTO `acceso` VALUES (368, 1, 1, '181.208.127.249', '2024-09-01 00:52:12');
  149. INSERT INTO `acceso` VALUES (369, 1, 1, '181.208.127.249', '2024-09-01 00:55:02');
  150. INSERT INTO `acceso` VALUES (370, 1, 1, '186.188.37.203', '2024-09-01 08:30:00');
  151. INSERT INTO `acceso` VALUES (371, 1, 1, '181.208.127.249', '2024-09-01 10:58:35');
  152. INSERT INTO `acceso` VALUES (372, 1, 2, '181.208.127.249', '2024-09-01 11:12:02');
  153. INSERT INTO `acceso` VALUES (373, 1, 1, '181.208.127.249', '2024-09-01 11:12:06');
  154. INSERT INTO `acceso` VALUES (374, 1, 2, '181.208.127.249', '2024-09-01 11:12:40');
  155. INSERT INTO `acceso` VALUES (375, 1, 1, '181.208.127.249', '2024-09-01 11:12:45');
  156. INSERT INTO `acceso` VALUES (376, 1, 2, '181.208.127.249', '2024-09-01 11:13:46');
  157. INSERT INTO `acceso` VALUES (377, 1, 1, '181.208.127.249', '2024-09-01 11:13:50');
  158. INSERT INTO `acceso` VALUES (378, 1, 1, '186.188.37.203', '2024-09-01 13:09:51');
  159. INSERT INTO `acceso` VALUES (379, 1, 2, '186.188.37.203', '2024-09-01 13:11:23');
  160. INSERT INTO `acceso` VALUES (380, 1, 1, '186.188.37.203', '2024-09-01 13:15:47');
  161. INSERT INTO `acceso` VALUES (381, 1, 1, '181.208.127.249', '2024-09-01 19:29:17');
  162. INSERT INTO `acceso` VALUES (382, 1, 1, '186.188.37.203', '2024-09-01 20:11:06');
  163. INSERT INTO `acceso` VALUES (383, 1, 2, '181.208.127.249', '2024-09-01 20:36:07');
  164. INSERT INTO `acceso` VALUES (384, 1, 2, '186.188.37.203', '2024-09-01 20:45:42');
  165. INSERT INTO `acceso` VALUES (385, 1, 1, '186.188.37.203', '2024-09-01 20:48:02');
  166. INSERT INTO `acceso` VALUES (386, 1, 2, '186.188.37.203', '2024-09-01 20:54:15');
  167. INSERT INTO `acceso` VALUES (387, 1, 1, '186.188.37.203', '2024-09-01 21:26:47');
  168. INSERT INTO `acceso` VALUES (388, 1, 2, '186.188.37.203', '2024-09-01 21:27:02');
  169. INSERT INTO `acceso` VALUES (389, 1, 1, '186.188.37.203', '2024-09-01 21:31:34');
  170. INSERT INTO `acceso` VALUES (390, 1, 2, '186.188.37.203', '2024-09-01 21:34:10');
  171. INSERT INTO `acceso` VALUES (391, 1, 1, '186.188.37.203', '2024-09-01 21:56:49');
  172. INSERT INTO `acceso` VALUES (392, 1, 1, '186.188.37.203', '2024-09-02 19:09:45');
  173. INSERT INTO `acceso` VALUES (393, 1, 2, '186.188.37.203', '2024-09-02 19:10:12');
  174. INSERT INTO `acceso` VALUES (394, 1, 1, '186.188.37.203', '2024-09-02 19:10:14');
  175. INSERT INTO `acceso` VALUES (395, 1, 1, '181.208.127.249', '2024-09-02 20:03:24');
  176. INSERT INTO `acceso` VALUES (396, 1, 1, '186.188.37.203', '2024-09-02 20:23:15');
  177. INSERT INTO `acceso` VALUES (397, 1, 2, '186.188.37.203', '2024-09-02 20:42:11');
  178. INSERT INTO `acceso` VALUES (398, 1, 1, '186.188.37.203', '2024-09-02 20:42:29');
  179. INSERT INTO `acceso` VALUES (399, 1, 2, '186.188.37.203', '2024-09-02 20:44:21');
  180. INSERT INTO `acceso` VALUES (400, 1, 1, '186.188.37.203', '2024-09-02 20:51:10');
  181. INSERT INTO `acceso` VALUES (401, 1, 2, '186.188.37.203', '2024-09-02 21:06:22');
  182. INSERT INTO `acceso` VALUES (402, 1, 1, '186.188.37.203', '2024-09-02 21:06:39');
  183. INSERT INTO `acceso` VALUES (403, 1, 2, '186.188.37.203', '2024-09-02 21:07:32');
  184. INSERT INTO `acceso` VALUES (404, 1, 1, '186.188.37.203', '2024-09-02 21:09:06');
  185. INSERT INTO `acceso` VALUES (405, 1, 2, '186.188.37.203', '2024-09-02 21:09:10');
  186. INSERT INTO `acceso` VALUES (406, 1, 1, '186.188.37.203', '2024-09-02 21:09:13');
  187. INSERT INTO `acceso` VALUES (407, 1, 2, '186.188.37.203', '2024-09-02 21:16:33');
  188. INSERT INTO `acceso` VALUES (408, 1, 1, '186.188.37.203', '2024-09-02 21:16:37');
  189. INSERT INTO `acceso` VALUES (409, 1, 2, '186.188.37.203', '2024-09-02 21:18:47');
  190. INSERT INTO `acceso` VALUES (410, 1, 1, '186.188.37.203', '2024-09-02 21:19:06');
  191. INSERT INTO `acceso` VALUES (411, 1, 2, '186.188.37.203', '2024-09-02 21:22:19');
  192. INSERT INTO `acceso` VALUES (412, 1, 1, '186.188.37.203', '2024-09-02 21:23:37');
  193. INSERT INTO `acceso` VALUES (413, 1, 1, '186.188.37.203', '2024-09-02 22:16:31');
  194. INSERT INTO `acceso` VALUES (414, 1, 1, '186.188.37.203', '2024-09-02 23:11:29');
  195. INSERT INTO `acceso` VALUES (415, 1, 1, '186.188.37.203', '2024-09-04 06:32:08');
  196. INSERT INTO `acceso` VALUES (416, 1, 1, '181.208.127.249', '2024-09-05 22:24:00');
  197. INSERT INTO `acceso` VALUES (417, 1, 1, '181.208.127.249', '2024-09-05 23:12:27');
  198. INSERT INTO `acceso` VALUES (418, 1, 1, '181.208.127.249', '2024-09-07 13:12:41');
  199. INSERT INTO `acceso` VALUES (419, 2, 1, '181.208.127.133', '2024-09-07 20:11:01');
  200. INSERT INTO `acceso` VALUES (420, 2, 2, '181.208.127.133', '2024-09-07 20:11:41');
  201. INSERT INTO `acceso` VALUES (421, 2, 1, '181.208.127.133', '2024-09-07 20:11:50');
  202. INSERT INTO `acceso` VALUES (422, 2, 2, '181.208.127.133', '2024-09-07 20:12:52');
  203. INSERT INTO `acceso` VALUES (423, 2, 1, '181.208.127.133', '2024-09-07 20:12:57');
  204. INSERT INTO `acceso` VALUES (424, 2, 1, '181.208.127.133', '2024-09-07 22:40:48');
  205. INSERT INTO `acceso` VALUES (425, 2, 1, '181.208.127.133', '2024-09-07 22:44:11');
  206. INSERT INTO `acceso` VALUES (426, 2, 1, '181.208.127.133', '2024-09-07 23:30:10');
  207. INSERT INTO `acceso` VALUES (427, 2, 1, '181.208.127.133', '2024-09-07 23:32:48');
  208. INSERT INTO `acceso` VALUES (428, 2, 1, '181.208.127.133', '2024-09-07 23:33:18');
  209. INSERT INTO `acceso` VALUES (429, 2, 1, '181.208.127.133', '2024-09-07 23:39:18');
  210. INSERT INTO `acceso` VALUES (430, 2, 1, '181.208.127.133', '2024-09-07 23:40:59');
  211. INSERT INTO `acceso` VALUES (431, 2, 1, '181.208.127.133', '2024-09-08 10:50:22');
  212. INSERT INTO `acceso` VALUES (432, 1, 1, '181.208.127.133', '2024-09-08 16:53:52');
  213. INSERT INTO `acceso` VALUES (433, 1, 2, '181.208.127.133', '2024-09-08 16:54:11');
  214. INSERT INTO `acceso` VALUES (434, 2, 1, '181.208.127.133', '2024-09-08 16:54:20');
  215. INSERT INTO `acceso` VALUES (435, 2, 2, '181.208.127.133', '2024-09-08 17:39:46');
  216. INSERT INTO `acceso` VALUES (436, 1, 1, '181.208.127.133', '2024-09-08 17:39:50');
  217. INSERT INTO `acceso` VALUES (437, 1, 1, '181.208.127.133', '2024-09-08 18:47:06');
  218. INSERT INTO `acceso` VALUES (438, 1, 1, '186.188.37.59', '2024-09-09 05:51:17');
  219. INSERT INTO `acceso` VALUES (439, 1, 1, '181.208.127.4', '2024-09-09 07:58:15');
  220. INSERT INTO `acceso` VALUES (440, 1, 1, '181.208.127.4', '2024-09-09 08:36:31');
  221. INSERT INTO `acceso` VALUES (441, 1, 1, '201.234.227.210', '2024-09-09 14:07:25');
  222. INSERT INTO `acceso` VALUES (442, 1, 1, '181.208.127.4', '2024-09-09 16:43:20');
  223. INSERT INTO `acceso` VALUES (443, 1, 2, '181.208.127.4', '2024-09-09 16:57:35');
  224. INSERT INTO `acceso` VALUES (444, 2, 1, '181.208.127.4', '2024-09-09 16:57:40');
  225. INSERT INTO `acceso` VALUES (445, 2, 2, '181.208.127.4', '2024-09-09 17:11:05');
  226. INSERT INTO `acceso` VALUES (446, 1, 1, '186.188.37.59', '2024-09-09 18:30:54');
  227. INSERT INTO `acceso` VALUES (447, 1, 2, '186.188.37.59', '2024-09-09 18:32:39');
  228. INSERT INTO `acceso` VALUES (448, 1, 1, '186.188.37.59', '2024-09-09 18:32:42');
  229. INSERT INTO `acceso` VALUES (449, 1, 1, '200.125.185.224', '2024-09-09 20:21:51');
  230. INSERT INTO `acceso` VALUES (450, 1, 1, '200.125.185.224', '2024-09-09 21:52:02');
  231. INSERT INTO `acceso` VALUES (451, 1, 2, '200.125.185.224', '2024-09-09 22:36:58');
  232. INSERT INTO `acceso` VALUES (452, 1, 1, '186.188.37.59', '2024-09-10 06:18:15');
  233. INSERT INTO `acceso` VALUES (453, 1, 1, '201.234.227.210', '2024-09-10 08:16:25');
  234. INSERT INTO `acceso` VALUES (454, 1, 2, '201.234.227.210', '2024-09-10 08:18:21');
  235. INSERT INTO `acceso` VALUES (455, 1, 1, '201.234.227.210', '2024-09-10 09:15:37');
  236. INSERT INTO `acceso` VALUES (456, 1, 1, '38.41.5.73', '2024-09-10 14:35:11');
  237. INSERT INTO `acceso` VALUES (457, 1, 1, '181.208.127.133', '2024-09-10 18:34:28');
  238. INSERT INTO `acceso` VALUES (458, 1, 1, '181.208.127.133', '2024-09-10 20:29:41');
  239. INSERT INTO `acceso` VALUES (459, 1, 1, '186.188.37.59', '2024-09-10 21:33:58');
  240. INSERT INTO `acceso` VALUES (460, 1, 1, '200.125.185.224', '2024-09-10 22:10:21');
  241. INSERT INTO `acceso` VALUES (461, 1, 1, '200.125.185.224', '2024-09-10 22:13:02');
  242. INSERT INTO `acceso` VALUES (462, 1, 1, '186.188.37.59', '2024-09-10 22:13:17');
  243. INSERT INTO `acceso` VALUES (463, 1, 1, '200.125.185.224', '2024-09-10 22:14:39');
  244. INSERT INTO `acceso` VALUES (464, 1, 1, '181.208.127.133', '2024-09-10 23:21:42');
  245. INSERT INTO `acceso` VALUES (465, 1, 1, '181.208.127.133', '2024-09-11 00:05:53');
  246. INSERT INTO `acceso` VALUES (466, 1, 1, '181.208.127.133', '2024-09-11 00:17:23');
  247. INSERT INTO `acceso` VALUES (467, 1, 1, '181.208.127.133', '2024-09-11 00:22:32');
  248. INSERT INTO `acceso` VALUES (468, 1, 1, '186.188.37.59', '2024-09-11 05:38:44');
  249. INSERT INTO `acceso` VALUES (469, 1, 2, '186.188.37.59', '2024-09-11 05:41:14');
  250. INSERT INTO `acceso` VALUES (470, 1, 1, '186.188.37.59', '2024-09-11 06:26:21');
  251. INSERT INTO `acceso` VALUES (471, 1, 1, '181.208.127.133', '2024-09-11 17:47:47');
  252. INSERT INTO `acceso` VALUES (472, 1, 1, '181.208.127.133', '2024-09-11 20:30:52');
  253. INSERT INTO `acceso` VALUES (473, 1, 1, '38.41.5.73', '2024-09-12 07:35:38');
  254. INSERT INTO `acceso` VALUES (474, 1, 1, '201.234.227.210', '2024-09-12 12:36:06');
  255. INSERT INTO `acceso` VALUES (475, 1, 1, '38.41.5.73', '2024-09-12 15:51:24');
  256. INSERT INTO `acceso` VALUES (476, 1, 1, '181.208.127.133', '2024-09-12 17:08:32');
  257. INSERT INTO `acceso` VALUES (477, 1, 1, '181.208.127.133', '2024-09-12 17:22:44');
  258. INSERT INTO `acceso` VALUES (478, 1, 1, '200.125.185.224', '2024-09-12 19:14:07');
  259. INSERT INTO `acceso` VALUES (479, 1, 1, '186.188.37.59', '2024-09-12 19:17:04');
  260. INSERT INTO `acceso` VALUES (480, 1, 2, '200.125.185.224', '2024-09-12 19:24:03');
  261. INSERT INTO `acceso` VALUES (481, 1, 1, '200.125.185.224', '2024-09-12 21:21:32');
  262. INSERT INTO `acceso` VALUES (482, 1, 1, '200.125.185.224', '2024-09-12 23:05:55');
  263. INSERT INTO `acceso` VALUES (483, 1, 1, '200.125.185.224', '2024-09-12 23:47:04');
  264. INSERT INTO `acceso` VALUES (484, 1, 2, '200.125.185.224', '2024-09-13 00:01:16');
  265. INSERT INTO `acceso` VALUES (485, 1, 1, '38.41.5.73', '2024-09-13 07:16:14');
  266. INSERT INTO `acceso` VALUES (486, 1, 2, '38.41.5.73', '2024-09-13 07:52:56');
  267. INSERT INTO `acceso` VALUES (487, 1, 1, '38.41.5.73', '2024-09-13 07:53:02');
  268. INSERT INTO `acceso` VALUES (488, 1, 1, '38.41.5.73', '2024-09-13 08:45:21');
  269. INSERT INTO `acceso` VALUES (489, 1, 1, '38.41.5.73', '2024-09-13 14:32:03');
  270. INSERT INTO `acceso` VALUES (490, 1, 1, '181.208.127.133', '2024-09-13 18:41:18');
  271. INSERT INTO `acceso` VALUES (491, 1, 2, '181.208.127.133', '2024-09-13 18:41:19');
  272. INSERT INTO `acceso` VALUES (492, 1, 1, '181.208.127.133', '2024-09-13 18:41:26');
  273. INSERT INTO `acceso` VALUES (493, 1, 2, '181.208.127.133', '2024-09-13 18:41:27');
  274. INSERT INTO `acceso` VALUES (494, 1, 1, '181.208.127.133', '2024-09-13 18:41:40');
  275. INSERT INTO `acceso` VALUES (495, 1, 2, '181.208.127.133', '2024-09-13 18:41:41');
  276. INSERT INTO `acceso` VALUES (496, 1, 1, '181.208.127.133', '2024-09-13 18:43:10');
  277. INSERT INTO `acceso` VALUES (497, 1, 2, '181.208.127.133', '2024-09-13 18:43:12');
  278. INSERT INTO `acceso` VALUES (498, 1, 1, '181.208.127.133', '2024-09-13 18:44:27');
  279. INSERT INTO `acceso` VALUES (499, 1, 2, '181.208.127.133', '2024-09-13 18:44:52');
  280. INSERT INTO `acceso` VALUES (500, 1, 1, '181.208.127.133', '2024-09-13 18:46:06');
  281. INSERT INTO `acceso` VALUES (501, 1, 2, '181.208.127.133', '2024-09-13 18:46:08');
  282. INSERT INTO `acceso` VALUES (502, 1, 1, '181.208.127.133', '2024-09-13 18:46:44');
  283. INSERT INTO `acceso` VALUES (503, 1, 2, '181.208.127.133', '2024-09-13 18:46:46');
  284. INSERT INTO `acceso` VALUES (504, 1, 1, '181.208.127.133', '2024-09-13 18:47:03');
  285. INSERT INTO `acceso` VALUES (505, 1, 2, '181.208.127.133', '2024-09-13 18:47:05');
  286. INSERT INTO `acceso` VALUES (506, 1, 1, '181.208.127.133', '2024-09-13 18:48:13');
  287. INSERT INTO `acceso` VALUES (507, 1, 2, '181.208.127.133', '2024-09-13 18:48:15');
  288. INSERT INTO `acceso` VALUES (508, 1, 1, '181.208.127.133', '2024-09-13 19:14:34');
  289. INSERT INTO `acceso` VALUES (509, 1, 2, '181.208.127.133', '2024-09-13 19:35:17');
  290. INSERT INTO `acceso` VALUES (510, 1, 1, '181.208.127.133', '2024-09-13 19:36:11');
  291. INSERT INTO `acceso` VALUES (511, 1, 2, '181.208.127.133', '2024-09-13 19:39:38');
  292. INSERT INTO `acceso` VALUES (512, 1, 1, '181.208.127.133', '2024-09-13 19:40:54');
  293. INSERT INTO `acceso` VALUES (513, 1, 2, '181.208.127.133', '2024-09-13 19:40:56');
  294. INSERT INTO `acceso` VALUES (514, 1, 1, '181.208.127.133', '2024-09-13 19:41:01');
  295. INSERT INTO `acceso` VALUES (515, 1, 2, '181.208.127.133', '2024-09-13 19:41:03');
  296. INSERT INTO `acceso` VALUES (516, 1, 1, '181.208.127.133', '2024-09-13 19:41:09');
  297. INSERT INTO `acceso` VALUES (517, 1, 2, '181.208.127.133', '2024-09-13 19:41:10');
  298. INSERT INTO `acceso` VALUES (518, 1, 1, '181.208.127.133', '2024-09-13 19:41:33');
  299. INSERT INTO `acceso` VALUES (519, 1, 2, '181.208.127.133', '2024-09-13 19:42:32');
  300. INSERT INTO `acceso` VALUES (520, 1, 1, '181.208.127.133', '2024-09-13 19:42:46');
  301. INSERT INTO `acceso` VALUES (521, 1, 2, '181.208.127.133', '2024-09-13 19:45:49');
  302. INSERT INTO `acceso` VALUES (522, 1, 1, '181.208.127.133', '2024-09-13 19:51:27');
  303. INSERT INTO `acceso` VALUES (523, 1, 2, '181.208.127.133', '2024-09-13 19:51:44');
  304. INSERT INTO `acceso` VALUES (524, 1, 1, '181.208.127.133', '2024-09-13 19:51:52');
  305. INSERT INTO `acceso` VALUES (525, 1, 2, '181.208.127.133', '2024-09-13 19:53:15');
  306. INSERT INTO `acceso` VALUES (526, 1, 1, '181.208.127.133', '2024-09-13 19:53:22');
  307. INSERT INTO `acceso` VALUES (527, 1, 2, '181.208.127.133', '2024-09-13 19:56:24');
  308. INSERT INTO `acceso` VALUES (528, 1, 1, '181.208.127.133', '2024-09-13 19:57:02');
  309. INSERT INTO `acceso` VALUES (529, 1, 2, '181.208.127.133', '2024-09-13 20:00:05');
  310. INSERT INTO `acceso` VALUES (530, 1, 1, '186.188.37.59', '2024-09-13 20:07:38');
  311. INSERT INTO `acceso` VALUES (531, 1, 1, '181.208.127.133', '2024-09-13 20:12:28');
  312. INSERT INTO `acceso` VALUES (532, 1, 2, '186.188.37.59', '2024-09-13 20:13:09');
  313. INSERT INTO `acceso` VALUES (533, 1, 1, '186.188.37.59', '2024-09-13 20:13:13');
  314. INSERT INTO `acceso` VALUES (534, 1, 2, '181.208.127.133', '2024-09-13 20:15:30');
  315. INSERT INTO `acceso` VALUES (535, 1, 2, '186.188.37.59', '2024-09-13 20:16:33');
  316. INSERT INTO `acceso` VALUES (536, 1, 1, '186.188.37.59', '2024-09-13 20:23:36');
  317. INSERT INTO `acceso` VALUES (537, 1, 2, '186.188.37.59', '2024-09-13 20:23:43');
  318. INSERT INTO `acceso` VALUES (538, 1, 1, '186.188.37.59', '2024-09-13 20:35:26');
  319. INSERT INTO `acceso` VALUES (539, 1, 2, '186.188.37.59', '2024-09-13 20:38:29');
  320. INSERT INTO `acceso` VALUES (540, 1, 1, '181.208.127.133', '2024-09-13 21:31:59');
  321. INSERT INTO `acceso` VALUES (541, 1, 2, '181.208.127.133', '2024-09-13 22:06:52');
  322. INSERT INTO `acceso` VALUES (542, 1, 1, '181.208.127.133', '2024-09-13 22:07:19');
  323. INSERT INTO `acceso` VALUES (543, 1, 2, '181.208.127.133', '2024-09-13 22:11:00');
  324. INSERT INTO `acceso` VALUES (544, 1, 1, '181.208.127.133', '2024-09-13 22:12:31');
  325. INSERT INTO `acceso` VALUES (545, 1, 2, '181.208.127.133', '2024-09-13 22:28:16');
  326. INSERT INTO `acceso` VALUES (546, 1, 1, '181.208.127.133', '2024-09-13 22:33:07');
  327. INSERT INTO `acceso` VALUES (547, 1, 2, '181.208.127.133', '2024-09-13 22:38:41');
  328. INSERT INTO `acceso` VALUES (548, 1, 1, '181.208.127.133', '2024-09-13 22:57:22');
  329. INSERT INTO `acceso` VALUES (549, 1, 2, '181.208.127.133', '2024-09-13 22:57:29');
  330. INSERT INTO `acceso` VALUES (550, 1, 1, '181.208.127.133', '2024-09-13 22:57:43');
  331. INSERT INTO `acceso` VALUES (551, 1, 2, '181.208.127.133', '2024-09-13 23:00:45');
  332. INSERT INTO `acceso` VALUES (552, 1, 1, '186.188.37.59', '2024-09-13 23:05:17');
  333. INSERT INTO `acceso` VALUES (553, 1, 1, '181.208.127.133', '2024-09-13 23:05:31');
  334. INSERT INTO `acceso` VALUES (554, 1, 2, '186.188.37.59', '2024-09-13 23:08:08');
  335. INSERT INTO `acceso` VALUES (555, 1, 2, '181.208.127.133', '2024-09-13 23:08:59');
  336. INSERT INTO `acceso` VALUES (556, 1, 1, '181.208.127.133', '2024-09-13 23:09:10');
  337. INSERT INTO `acceso` VALUES (557, 1, 2, '181.208.127.133', '2024-09-13 23:10:11');
  338. INSERT INTO `acceso` VALUES (558, 1, 1, '181.208.127.133', '2024-09-13 23:10:30');
  339. INSERT INTO `acceso` VALUES (559, 1, 1, '186.188.37.59', '2024-09-13 23:11:39');
  340. INSERT INTO `acceso` VALUES (560, 1, 2, '181.208.127.133', '2024-09-13 23:12:32');
  341. INSERT INTO `acceso` VALUES (561, 1, 2, '186.188.37.59', '2024-09-13 23:13:01');
  342. INSERT INTO `acceso` VALUES (562, 1, 1, '200.125.185.224', '2024-09-14 13:40:18');
  343. INSERT INTO `acceso` VALUES (563, 1, 2, '200.125.185.224', '2024-09-14 13:47:02');
  344. INSERT INTO `acceso` VALUES (564, 1, 1, '186.188.37.59', '2024-09-14 14:53:11');
  345. INSERT INTO `acceso` VALUES (565, 1, 2, '186.188.37.59', '2024-09-14 14:55:17');
  346. INSERT INTO `acceso` VALUES (566, 1, 1, '190.74.84.181', '2024-09-14 15:00:27');
  347. INSERT INTO `acceso` VALUES (567, 1, 1, '190.74.84.181', '2024-09-14 15:00:47');
  348. INSERT INTO `acceso` VALUES (568, 1, 2, '190.74.84.181', '2024-09-14 15:01:06');
  349. INSERT INTO `acceso` VALUES (569, 1, 1, '190.74.84.181', '2024-09-15 00:34:07');
  350. INSERT INTO `acceso` VALUES (570, 1, 2, '190.74.84.181', '2024-09-15 00:39:46');
  351. INSERT INTO `acceso` VALUES (571, 1, 1, '200.125.185.224', '2024-09-15 11:24:17');
  352. INSERT INTO `acceso` VALUES (572, 1, 2, '200.125.185.224', '2024-09-15 11:26:20');
  353. INSERT INTO `acceso` VALUES (573, 1, 1, '200.125.185.224', '2024-09-15 11:47:08');
  354. INSERT INTO `acceso` VALUES (574, 1, 2, '200.125.185.224', '2024-09-15 11:49:42');
  355. INSERT INTO `acceso` VALUES (575, 1, 1, '200.125.185.224', '2024-09-15 12:19:12');
  356. INSERT INTO `acceso` VALUES (576, 1, 2, '200.125.185.224', '2024-09-15 12:27:09');
  357. INSERT INTO `acceso` VALUES (577, 1, 1, '200.125.185.224', '2024-09-15 13:18:05');
  358. INSERT INTO `acceso` VALUES (578, 1, 2, '200.125.185.224', '2024-09-15 13:22:31');
  359. INSERT INTO `acceso` VALUES (579, 1, 1, '200.125.185.224', '2024-09-15 13:23:31');
  360. INSERT INTO `acceso` VALUES (580, 1, 2, '200.125.185.224', '2024-09-15 13:29:18');
  361. INSERT INTO `acceso` VALUES (581, 1, 1, '200.125.185.224', '2024-09-15 13:34:07');
  362. INSERT INTO `acceso` VALUES (582, 1, 2, '200.125.185.224', '2024-09-15 13:37:49');
  363. INSERT INTO `acceso` VALUES (583, 1, 1, '200.125.185.224', '2024-09-15 13:45:35');
  364. INSERT INTO `acceso` VALUES (584, 1, 2, '200.125.185.224', '2024-09-15 13:53:16');
  365. INSERT INTO `acceso` VALUES (585, 1, 1, '200.125.185.224', '2024-09-15 13:53:21');
  366. INSERT INTO `acceso` VALUES (586, 1, 2, '200.125.185.224', '2024-09-15 14:02:30');
  367. INSERT INTO `acceso` VALUES (587, 1, 1, '200.125.185.224', '2024-09-15 15:50:24');
  368. INSERT INTO `acceso` VALUES (588, 1, 1, '200.125.185.224', '2024-09-15 17:29:02');
  369. INSERT INTO `acceso` VALUES (589, 1, 2, '200.125.185.224', '2024-09-15 18:33:35');
  370. INSERT INTO `acceso` VALUES (590, 1, 1, '200.125.185.224', '2024-09-15 18:43:26');
  371. INSERT INTO `acceso` VALUES (591, 1, 2, '200.125.185.224', '2024-09-15 18:52:53');
  372. INSERT INTO `acceso` VALUES (592, 1, 1, '200.125.185.224', '2024-09-15 18:53:56');
  373. INSERT INTO `acceso` VALUES (593, 1, 2, '200.125.185.224', '2024-09-15 19:28:51');
  374. INSERT INTO `acceso` VALUES (594, 1, 1, '200.125.185.224', '2024-09-15 19:31:36');
  375. INSERT INTO `acceso` VALUES (595, 1, 2, '200.125.185.224', '2024-09-15 19:51:13');
  376. INSERT INTO `acceso` VALUES (596, 1, 1, '200.125.185.224', '2024-09-15 20:00:04');
  377. INSERT INTO `acceso` VALUES (597, 1, 1, '200.125.185.224', '2024-09-15 20:20:34');
  378. INSERT INTO `acceso` VALUES (598, 1, 2, '200.125.185.224', '2024-09-15 20:47:34');
  379. INSERT INTO `acceso` VALUES (599, 1, 1, '200.125.185.224', '2024-09-15 20:52:10');
  380. INSERT INTO `acceso` VALUES (600, 1, 1, '181.208.127.9', '2024-09-15 20:59:47');
  381. INSERT INTO `acceso` VALUES (601, 1, 2, '181.208.127.9', '2024-09-15 21:09:14');
  382. INSERT INTO `acceso` VALUES (602, 1, 1, '200.125.185.224', '2024-09-15 21:13:37');
  383. INSERT INTO `acceso` VALUES (603, 1, 2, '200.125.185.224', '2024-09-15 21:24:29');
  384. INSERT INTO `acceso` VALUES (604, 1, 1, '200.125.185.224', '2024-09-15 21:25:06');
  385. INSERT INTO `acceso` VALUES (605, 1, 1, '200.125.185.224', '2024-09-15 21:43:06');
  386. INSERT INTO `acceso` VALUES (606, 1, 1, '186.188.37.59', '2024-09-15 21:45:16');
  387. INSERT INTO `acceso` VALUES (607, 1, 1, '181.208.127.9', '2024-09-15 21:46:40');
  388. INSERT INTO `acceso` VALUES (608, 1, 2, '200.125.185.224', '2024-09-15 21:57:32');
  389. INSERT INTO `acceso` VALUES (609, 1, 2, '186.188.37.59', '2024-09-15 22:02:05');
  390. INSERT INTO `acceso` VALUES (610, 1, 2, '181.208.127.9', '2024-09-15 22:03:34');
  391. INSERT INTO `acceso` VALUES (611, 1, 1, '181.208.127.9', '2024-09-15 22:03:40');
  392. INSERT INTO `acceso` VALUES (612, 1, 1, '200.125.185.224', '2024-09-15 22:20:20');
  393. INSERT INTO `acceso` VALUES (613, 1, 2, '200.125.185.224', '2024-09-15 22:48:08');
  394. INSERT INTO `acceso` VALUES (614, 1, 2, '181.208.127.9', '2024-09-15 23:00:37');
  395. INSERT INTO `acceso` VALUES (615, 1, 1, '181.208.127.9', '2024-09-15 23:00:53');
  396. INSERT INTO `acceso` VALUES (616, 1, 1, '200.125.185.224', '2024-09-15 23:25:02');
  397. INSERT INTO `acceso` VALUES (617, 1, 2, '181.208.127.9', '2024-09-15 23:39:56');
  398. INSERT INTO `acceso` VALUES (618, 1, 1, '201.234.227.210', '2024-09-16 08:49:48');
  399. INSERT INTO `acceso` VALUES (619, 1, 2, '201.234.227.210', '2024-09-16 09:01:28');
  400. INSERT INTO `acceso` VALUES (620, 1, 1, '201.234.227.210', '2024-09-16 10:41:58');
  401. INSERT INTO `acceso` VALUES (621, 1, 2, '201.234.227.210', '2024-09-16 11:12:09');
  402. INSERT INTO `acceso` VALUES (622, 1, 1, '201.234.227.210', '2024-09-16 11:14:17');
  403. INSERT INTO `acceso` VALUES (623, 1, 2, '201.234.227.210', '2024-09-16 11:26:08');
  404. INSERT INTO `acceso` VALUES (624, 1, 1, '201.234.227.210', '2024-09-16 11:28:29');
  405. INSERT INTO `acceso` VALUES (625, 1, 2, '201.234.227.210', '2024-09-16 11:28:54');
  406. INSERT INTO `acceso` VALUES (626, 1, 1, '201.234.227.210', '2024-09-16 11:28:58');
  407. INSERT INTO `acceso` VALUES (627, 1, 2, '201.234.227.210', '2024-09-16 11:30:58');
  408. INSERT INTO `acceso` VALUES (628, 1, 1, '201.234.227.210', '2024-09-16 11:31:00');
  409. INSERT INTO `acceso` VALUES (629, 1, 1, '38.41.5.73', '2024-09-16 11:47:50');
  410. INSERT INTO `acceso` VALUES (630, 1, 1, '201.234.227.210', '2024-09-16 12:34:06');
  411. INSERT INTO `acceso` VALUES (631, 1, 1, '201.234.227.210', '2024-09-16 12:49:13');
  412. INSERT INTO `acceso` VALUES (632, 1, 1, '38.41.5.73', '2024-09-16 13:08:42');
  413. INSERT INTO `acceso` VALUES (633, 1, 1, '181.208.127.4', '2024-09-16 15:36:48');
  414. INSERT INTO `acceso` VALUES (634, 1, 2, '181.208.127.4', '2024-09-16 15:40:42');
  415. INSERT INTO `acceso` VALUES (635, 1, 1, '201.234.227.210', '2024-09-16 15:40:55');
  416. INSERT INTO `acceso` VALUES (636, 1, 1, '181.208.127.9', '2024-09-16 18:54:47');
  417. INSERT INTO `acceso` VALUES (637, 1, 1, '181.208.127.9', '2024-09-16 20:08:18');
  418. INSERT INTO `acceso` VALUES (638, 1, 1, '186.188.37.59', '2024-09-16 20:12:41');
  419. INSERT INTO `acceso` VALUES (639, 1, 1, '186.188.37.59', '2024-09-16 22:04:54');
  420. INSERT INTO `acceso` VALUES (640, 1, 1, '201.234.227.210', '2024-09-17 07:57:50');
  421. INSERT INTO `acceso` VALUES (641, 1, 1, '181.208.127.4', '2024-09-17 09:36:00');
  422. INSERT INTO `acceso` VALUES (642, 1, 2, '181.208.127.4', '2024-09-17 09:36:10');
  423. INSERT INTO `acceso` VALUES (643, 1, 1, '38.41.5.73', '2024-09-17 09:41:03');
  424. INSERT INTO `acceso` VALUES (644, 1, 1, '200.125.185.224', '2024-09-18 20:43:16');
  425. INSERT INTO `acceso` VALUES (645, 1, 2, '200.125.185.224', '2024-09-18 21:26:23');
  426. INSERT INTO `acceso` VALUES (646, 1, 1, '201.234.227.210', '2024-09-19 09:04:02');
  427. INSERT INTO `acceso` VALUES (647, 1, 1, '38.41.5.73', '2024-09-19 09:18:32');
  428. INSERT INTO `acceso` VALUES (648, 1, 1, '201.234.227.210', '2024-09-19 10:03:54');
  429. INSERT INTO `acceso` VALUES (649, 1, 1, '38.41.5.73', '2024-09-19 11:56:52');
  430. INSERT INTO `acceso` VALUES (650, 1, 2, '38.41.5.73', '2024-09-19 12:06:54');
  431. INSERT INTO `acceso` VALUES (651, 2, 1, '38.41.5.73', '2024-09-19 12:06:59');
  432. INSERT INTO `acceso` VALUES (652, 2, 2, '38.41.5.73', '2024-09-19 12:21:15');
  433. INSERT INTO `acceso` VALUES (653, 1, 1, '38.41.5.73', '2024-09-19 12:21:19');
  434. INSERT INTO `acceso` VALUES (654, 1, 1, '201.234.227.210', '2024-09-19 12:38:00');
  435. INSERT INTO `acceso` VALUES (655, 1, 1, '181.208.127.9', '2024-09-19 17:42:41');
  436. INSERT INTO `acceso` VALUES (656, 1, 2, '181.208.127.9', '2024-09-19 17:45:59');
  437. INSERT INTO `acceso` VALUES (657, 2, 1, '181.208.127.9', '2024-09-19 17:46:04');
  438. INSERT INTO `acceso` VALUES (658, 2, 2, '181.208.127.9', '2024-09-19 17:46:13');
  439. INSERT INTO `acceso` VALUES (659, 2, 1, '181.208.127.9', '2024-09-19 17:46:17');
  440. INSERT INTO `acceso` VALUES (660, 2, 2, '181.208.127.9', '2024-09-19 17:50:55');
  441. INSERT INTO `acceso` VALUES (661, 2, 1, '181.208.127.9', '2024-09-19 17:50:58');
  442. INSERT INTO `acceso` VALUES (662, 2, 2, '181.208.127.9', '2024-09-19 17:51:23');
  443. INSERT INTO `acceso` VALUES (663, 1, 1, '181.208.127.9', '2024-09-19 17:51:28');
  444. INSERT INTO `acceso` VALUES (664, 1, 2, '181.208.127.9', '2024-09-19 17:53:08');
  445. INSERT INTO `acceso` VALUES (665, 2, 1, '181.208.127.9', '2024-09-19 17:53:13');
  446. INSERT INTO `acceso` VALUES (666, 2, 2, '181.208.127.9', '2024-09-19 17:53:46');
  447. INSERT INTO `acceso` VALUES (668, 1, 1, '181.208.127.9', '2024-09-19 19:39:24');
  448. INSERT INTO `acceso` VALUES (669, 1, 2, '181.208.127.9', '2024-09-19 20:20:45');
  449. INSERT INTO `acceso` VALUES (670, 1, 1, '181.208.127.9', '2024-09-19 20:20:48');
  450. INSERT INTO `acceso` VALUES (671, 1, 2, '181.208.127.9', '2024-09-19 20:21:31');
  451. INSERT INTO `acceso` VALUES (672, 1, 1, '181.208.127.9', '2024-09-19 20:21:36');
  452. INSERT INTO `acceso` VALUES (673, 1, 2, '181.208.127.9', '2024-09-19 20:21:57');
  453. INSERT INTO `acceso` VALUES (674, 1, 1, '181.208.127.9', '2024-09-19 20:22:03');
  454. INSERT INTO `acceso` VALUES (675, 1, 1, '200.125.185.224', '2024-09-19 21:04:54');
  455. INSERT INTO `acceso` VALUES (676, 1, 1, '181.208.127.9', '2024-09-19 21:29:38');
  456. INSERT INTO `acceso` VALUES (677, 1, 2, '181.208.127.9', '2024-09-19 22:25:27');
  457. INSERT INTO `acceso` VALUES (678, 1, 1, '181.208.127.9', '2024-09-19 22:25:31');
  458. INSERT INTO `acceso` VALUES (679, 1, 2, '181.208.127.9', '2024-09-19 22:26:07');
  459. INSERT INTO `acceso` VALUES (680, 1, 1, '181.208.127.9', '2024-09-19 22:26:11');
  460. INSERT INTO `acceso` VALUES (681, 1, 2, '181.208.127.9', '2024-09-19 22:33:17');
  461. INSERT INTO `acceso` VALUES (682, 1, 1, '181.208.127.9', '2024-09-19 22:33:21');
  462. INSERT INTO `acceso` VALUES (683, 1, 2, '181.208.127.9', '2024-09-19 22:33:35');
  463. INSERT INTO `acceso` VALUES (684, 1, 1, '181.208.127.9', '2024-09-19 22:33:40');
  464. INSERT INTO `acceso` VALUES (685, 1, 1, '186.188.37.59', '2024-09-19 23:16:16');
  465. INSERT INTO `acceso` VALUES (686, 1, 1, '181.208.127.9', '2024-09-19 23:17:09');
  466. INSERT INTO `acceso` VALUES (687, 1, 2, '186.188.37.59', '2024-09-19 23:17:48');
  467. INSERT INTO `acceso` VALUES (688, 1, 1, '186.188.37.59', '2024-09-19 23:17:53');
  468. INSERT INTO `acceso` VALUES (689, 1, 1, '186.188.37.59', '2024-09-20 07:01:52');
  469. INSERT INTO `acceso` VALUES (690, 1, 2, '186.188.37.59', '2024-09-20 07:02:29');
  470. INSERT INTO `acceso` VALUES (691, 1, 1, '38.41.5.73', '2024-09-20 11:21:11');
  471. INSERT INTO `acceso` VALUES (692, 1, 1, '181.208.127.9', '2024-09-20 17:40:28');
  472. INSERT INTO `acceso` VALUES (693, 1, 1, '200.125.185.224', '2024-09-20 20:01:54');
  473. INSERT INTO `acceso` VALUES (694, 1, 1, '200.125.185.224', '2024-09-20 21:15:45');
  474. INSERT INTO `acceso` VALUES (695, 1, 2, '200.125.185.224', '2024-09-20 21:18:01');
  475. INSERT INTO `acceso` VALUES (696, 1, 1, '200.125.185.224', '2024-09-20 21:18:05');
  476. INSERT INTO `acceso` VALUES (697, 1, 2, '200.125.185.224', '2024-09-20 21:18:36');
  477. INSERT INTO `acceso` VALUES (698, 1, 1, '200.125.185.224', '2024-09-20 21:19:03');
  478. INSERT INTO `acceso` VALUES (699, 1, 2, '200.125.185.224', '2024-09-20 21:20:37');
  479. INSERT INTO `acceso` VALUES (700, 1, 1, '200.125.185.224', '2024-09-20 21:21:06');
  480. INSERT INTO `acceso` VALUES (701, 1, 2, '200.125.185.224', '2024-09-20 21:23:14');
  481. INSERT INTO `acceso` VALUES (702, 1, 1, '200.125.185.224', '2024-09-20 21:23:56');
  482. INSERT INTO `acceso` VALUES (703, 1, 2, '200.125.185.224', '2024-09-20 21:26:34');
  483. INSERT INTO `acceso` VALUES (704, 1, 1, '200.125.185.224', '2024-09-20 21:30:54');
  484. INSERT INTO `acceso` VALUES (705, 1, 2, '200.125.185.224', '2024-09-20 21:56:32');
  485. INSERT INTO `acceso` VALUES (706, 1, 1, '200.125.185.224', '2024-09-20 21:56:40');
  486. INSERT INTO `acceso` VALUES (707, 1, 2, '181.208.127.9', '2024-09-20 21:57:00');
  487. INSERT INTO `acceso` VALUES (708, 1, 1, '181.208.127.9', '2024-09-20 21:57:08');
  488. INSERT INTO `acceso` VALUES (709, 1, 2, '200.125.185.224', '2024-09-20 21:57:38');
  489. INSERT INTO `acceso` VALUES (710, 1, 1, '186.188.37.59', '2024-09-20 21:58:40');
  490. INSERT INTO `acceso` VALUES (711, 1, 1, '200.125.185.224', '2024-09-20 22:00:51');
  491. INSERT INTO `acceso` VALUES (712, 1, 1, '186.188.37.59', '2024-09-20 22:15:48');
  492. INSERT INTO `acceso` VALUES (713, 1, 1, '200.125.185.224', '2024-09-20 23:30:04');
  493. INSERT INTO `acceso` VALUES (714, 1, 2, '200.125.185.224', '2024-09-20 23:31:44');
  494. INSERT INTO `acceso` VALUES (715, 1, 1, '186.188.37.59', '2024-09-21 05:45:40');
  495. INSERT INTO `acceso` VALUES (716, 1, 2, '186.188.37.59', '2024-09-21 05:47:40');
  496. INSERT INTO `acceso` VALUES (717, 1, 1, '181.208.127.9', '2024-09-21 13:18:23');
  497. INSERT INTO `acceso` VALUES (718, 1, 2, '181.208.127.9', '2024-09-21 13:20:50');
  498. INSERT INTO `acceso` VALUES (719, 1, 1, '181.208.127.9', '2024-09-21 13:53:20');
  499. INSERT INTO `acceso` VALUES (720, 1, 1, '181.208.127.9', '2024-09-21 15:40:09');
  500. INSERT INTO `acceso` VALUES (721, 1, 1, '181.208.127.9', '2024-09-21 17:50:24');
  501. INSERT INTO `acceso` VALUES (722, 1, 1, '200.125.185.224', '2024-09-21 17:52:01');
  502. INSERT INTO `acceso` VALUES (723, 1, 1, '200.125.185.224', '2024-09-21 18:34:21');
  503. INSERT INTO `acceso` VALUES (724, 1, 1, '181.208.127.9', '2024-09-21 20:56:03');
  504. INSERT INTO `acceso` VALUES (725, 1, 1, '181.208.127.9', '2024-09-21 22:09:30');
  505. INSERT INTO `acceso` VALUES (726, 1, 1, '200.125.185.224', '2024-09-21 22:10:56');
  506. INSERT INTO `acceso` VALUES (727, 1, 2, '200.125.185.224', '2024-09-21 23:05:56');
  507. INSERT INTO `acceso` VALUES (728, 1, 1, '186.188.37.59', '2024-09-22 13:18:21');
  508. INSERT INTO `acceso` VALUES (729, 1, 2, '186.188.37.59', '2024-09-22 13:18:38');
  509. INSERT INTO `acceso` VALUES (730, 1, 1, '186.188.37.59', '2024-09-22 13:18:39');
  510. INSERT INTO `acceso` VALUES (731, 1, 1, '181.208.127.9', '2024-09-22 15:24:55');
  511. INSERT INTO `acceso` VALUES (732, 1, 1, '200.125.185.224', '2024-09-22 17:40:22');
  512. INSERT INTO `acceso` VALUES (733, 1, 1, '200.125.185.224', '2024-09-22 17:40:38');
  513. INSERT INTO `acceso` VALUES (734, 1, 1, '200.125.185.224', '2024-09-22 18:45:15');
  514. INSERT INTO `acceso` VALUES (735, 1, 1, '200.125.185.224', '2024-09-22 19:03:59');
  515. INSERT INTO `acceso` VALUES (736, 1, 1, '181.208.127.9', '2024-09-22 19:08:18');
  516. INSERT INTO `acceso` VALUES (737, 1, 1, '181.208.127.9', '2024-09-22 20:30:01');
  517. INSERT INTO `acceso` VALUES (738, 1, 1, '200.125.185.224', '2024-09-22 20:53:14');
  518. INSERT INTO `acceso` VALUES (739, 1, 2, '200.125.185.224', '2024-09-22 20:54:26');
  519. INSERT INTO `acceso` VALUES (740, 1, 1, '181.208.127.9', '2024-09-22 21:34:43');
  520. INSERT INTO `acceso` VALUES (741, 1, 1, '38.41.5.73', '2024-09-23 07:30:58');
  521. INSERT INTO `acceso` VALUES (742, 1, 1, '38.41.5.73', '2024-09-23 07:44:21');
  522. INSERT INTO `acceso` VALUES (743, 1, 1, '38.41.5.73', '2024-09-23 08:47:39');
  523. INSERT INTO `acceso` VALUES (744, 1, 1, '38.41.5.73', '2024-09-23 08:49:27');
  524. INSERT INTO `acceso` VALUES (745, 1, 1, '201.234.227.210', '2024-09-23 09:03:13');
  525. INSERT INTO `acceso` VALUES (746, 1, 1, '38.41.5.73', '2024-09-23 11:34:36');
  526. INSERT INTO `acceso` VALUES (747, 1, 1, '38.41.5.73', '2024-09-23 13:45:10');
  527. INSERT INTO `acceso` VALUES (748, 1, 1, '38.41.5.73', '2024-09-23 14:25:50');
  528. INSERT INTO `acceso` VALUES (749, 1, 1, '38.41.5.73', '2024-09-23 14:29:22');
  529. INSERT INTO `acceso` VALUES (750, 1, 1, '38.41.5.73', '2024-09-23 14:30:03');
  530. INSERT INTO `acceso` VALUES (751, 1, 2, '38.41.5.73', '2024-09-23 15:56:25');
  531. INSERT INTO `acceso` VALUES (752, 1, 1, '38.41.5.73', '2024-09-23 15:56:32');
  532. INSERT INTO `acceso` VALUES (753, 1, 1, '186.188.37.59', '2024-09-23 17:15:00');
  533. INSERT INTO `acceso` VALUES (754, 1, 2, '186.188.37.59', '2024-09-23 17:15:43');
  534. INSERT INTO `acceso` VALUES (755, 1, 1, '181.208.127.9', '2024-09-23 19:59:32');
  535. INSERT INTO `acceso` VALUES (756, 1, 2, '181.208.127.9', '2024-09-23 20:31:02');
  536. INSERT INTO `acceso` VALUES (757, 1, 1, '181.208.127.9', '2024-09-23 20:31:09');
  537. INSERT INTO `acceso` VALUES (758, 1, 1, '181.208.127.9', '2024-09-23 21:41:05');
  538. INSERT INTO `acceso` VALUES (759, 1, 1, '181.208.127.9', '2024-09-23 21:42:01');
  539. INSERT INTO `acceso` VALUES (760, 1, 1, '186.188.37.59', '2024-09-23 22:47:13');
  540. INSERT INTO `acceso` VALUES (761, 1, 1, '186.188.37.59', '2024-09-24 06:46:04');
  541. INSERT INTO `acceso` VALUES (762, 1, 1, '38.41.5.73', '2024-09-24 07:29:50');
  542. INSERT INTO `acceso` VALUES (763, 1, 1, '38.41.5.73', '2024-09-24 14:07:30');
  543. INSERT INTO `acceso` VALUES (764, 1, 1, '38.41.5.73', '2024-09-24 16:18:45');
  544. INSERT INTO `acceso` VALUES (765, 1, 1, '181.208.127.9', '2024-09-24 19:49:51');
  545. INSERT INTO `acceso` VALUES (766, 1, 1, '186.188.37.59', '2024-09-24 20:48:39');
  546. INSERT INTO `acceso` VALUES (767, 1, 1, '38.41.5.73', '2024-09-25 07:16:06');
  547. INSERT INTO `acceso` VALUES (768, 1, 1, '38.41.5.73', '2024-09-25 07:16:45');
  548. INSERT INTO `acceso` VALUES (769, 1, 1, '38.41.5.73', '2024-09-25 11:32:16');
  549. INSERT INTO `acceso` VALUES (770, 1, 1, '186.188.37.59', '2024-09-25 12:02:26');
  550. INSERT INTO `acceso` VALUES (771, 1, 1, '38.41.5.73', '2024-09-25 13:20:29');
  551. INSERT INTO `acceso` VALUES (772, 1, 1, '38.41.5.73', '2024-09-25 14:15:45');
  552. INSERT INTO `acceso` VALUES (773, 1, 1, '38.41.5.73', '2024-09-25 15:55:01');
  553. INSERT INTO `acceso` VALUES (774, 1, 1, '181.208.127.9', '2024-09-25 18:32:53');
  554. INSERT INTO `acceso` VALUES (775, 1, 1, '181.208.127.9', '2024-09-25 20:28:10');
  555. INSERT INTO `acceso` VALUES (776, 1, 1, '186.188.37.59', '2024-09-25 20:36:57');
  556. INSERT INTO `acceso` VALUES (777, 1, 1, '181.208.127.9', '2024-09-25 21:17:47');
  557. INSERT INTO `acceso` VALUES (778, 1, 2, '181.208.127.9', '2024-09-25 21:34:56');
  558. INSERT INTO `acceso` VALUES (779, 1, 1, '181.208.127.9', '2024-09-25 21:35:07');
  559. INSERT INTO `acceso` VALUES (780, 1, 1, '181.208.127.9', '2024-09-25 23:31:25');
  560. INSERT INTO `acceso` VALUES (781, 1, 1, '186.188.37.59', '2024-09-26 00:11:50');
  561. INSERT INTO `acceso` VALUES (782, 1, 1, '201.234.227.210', '2024-09-26 08:05:17');
  562. INSERT INTO `acceso` VALUES (783, 1, 1, '201.234.227.210', '2024-09-26 09:42:21');
  563. INSERT INTO `acceso` VALUES (784, 1, 1, '129.222.203.75', '2024-09-26 13:19:29');
  564. INSERT INTO `acceso` VALUES (785, 1, 1, '181.208.127.4', '2024-09-26 13:39:59');
  565. INSERT INTO `acceso` VALUES (786, 1, 2, '181.208.127.4', '2024-09-26 13:55:30');
  566. INSERT INTO `acceso` VALUES (787, 1, 1, '200.125.185.224', '2024-09-26 18:46:30');
  567. INSERT INTO `acceso` VALUES (788, 1, 2, '200.125.185.224', '2024-09-26 18:47:54');
  568. INSERT INTO `acceso` VALUES (789, 1, 1, '186.188.37.59', '2024-09-26 19:52:32');
  569. INSERT INTO `acceso` VALUES (790, 1, 1, '200.125.185.224', '2024-09-26 21:23:12');
  570. INSERT INTO `acceso` VALUES (791, 1, 2, '200.125.185.224', '2024-09-26 21:34:37');
  571. INSERT INTO `acceso` VALUES (792, 1, 1, '181.208.127.9', '2024-09-26 21:36:01');
  572. INSERT INTO `acceso` VALUES (793, 1, 1, '200.125.185.224', '2024-09-26 21:46:22');
  573. INSERT INTO `acceso` VALUES (794, 1, 2, '200.125.185.224', '2024-09-26 21:46:32');
  574. INSERT INTO `acceso` VALUES (795, 1, 1, '186.188.37.59', '2024-09-26 21:50:06');
  575. INSERT INTO `acceso` VALUES (796, 1, 1, '186.188.37.59', '2024-09-27 06:29:20');
  576. INSERT INTO `acceso` VALUES (797, 1, 2, '186.188.37.59', '2024-09-27 06:29:59');
  577. INSERT INTO `acceso` VALUES (798, 1, 1, '186.188.37.59', '2024-09-27 06:30:56');
  578. INSERT INTO `acceso` VALUES (799, 1, 2, '186.188.37.59', '2024-09-27 06:32:00');
  579. INSERT INTO `acceso` VALUES (800, 1, 1, '38.41.5.73', '2024-09-27 07:19:04');
  580. INSERT INTO `acceso` VALUES (801, 1, 1, '181.208.127.4', '2024-09-27 08:14:27');
  581. INSERT INTO `acceso` VALUES (802, 1, 2, '181.208.127.4', '2024-09-27 08:34:35');
  582. INSERT INTO `acceso` VALUES (803, 1, 1, '201.234.227.210', '2024-09-27 08:55:58');
  583. INSERT INTO `acceso` VALUES (804, 1, 1, '38.41.5.73', '2024-09-27 09:02:29');
  584. INSERT INTO `acceso` VALUES (805, 1, 1, '201.234.227.210', '2024-09-27 09:06:02');
  585. INSERT INTO `acceso` VALUES (806, 1, 2, '38.41.5.73', '2024-09-27 09:06:20');
  586. INSERT INTO `acceso` VALUES (807, 1, 1, '38.41.5.73', '2024-09-27 09:06:24');
  587. INSERT INTO `acceso` VALUES (808, 1, 2, '38.41.5.73', '2024-09-27 09:10:42');
  588. INSERT INTO `acceso` VALUES (809, 1, 2, '201.234.227.210', '2024-09-27 09:10:43');
  589. INSERT INTO `acceso` VALUES (810, 1, 1, '201.234.227.210', '2024-09-27 09:10:45');
  590. INSERT INTO `acceso` VALUES (811, 1, 1, '38.41.5.73', '2024-09-27 09:10:51');
  591. INSERT INTO `acceso` VALUES (812, 1, 2, '38.41.5.73', '2024-09-27 09:18:46');
  592. INSERT INTO `acceso` VALUES (813, 1, 1, '38.41.5.73', '2024-09-27 09:18:50');
  593. INSERT INTO `acceso` VALUES (814, 1, 1, '38.41.5.73', '2024-09-27 11:58:20');
  594. INSERT INTO `acceso` VALUES (815, 1, 1, '38.41.5.73', '2024-09-27 12:04:18');
  595. INSERT INTO `acceso` VALUES (816, 1, 1, '38.41.5.73', '2024-09-27 12:23:13');
  596. INSERT INTO `acceso` VALUES (817, 1, 1, '38.41.5.73', '2024-09-27 13:22:10');
  597. INSERT INTO `acceso` VALUES (818, 1, 1, '181.208.127.4', '2024-09-27 14:22:11');
  598. INSERT INTO `acceso` VALUES (819, 1, 2, '181.208.127.4', '2024-09-27 14:22:52');
  599. INSERT INTO `acceso` VALUES (820, 1, 1, '38.41.5.73', '2024-09-27 15:53:07');
  600. INSERT INTO `acceso` VALUES (821, 1, 1, '181.208.127.9', '2024-09-27 17:51:20');
  601. INSERT INTO `acceso` VALUES (822, 1, 1, '186.188.37.59', '2024-09-27 19:31:51');
  602. INSERT INTO `acceso` VALUES (823, 1, 1, '200.125.185.224', '2024-09-27 20:25:08');
  603. INSERT INTO `acceso` VALUES (824, 1, 1, '181.208.127.9', '2024-09-27 20:38:08');
  604. INSERT INTO `acceso` VALUES (825, 1, 2, '200.125.185.224', '2024-09-27 21:04:18');
  605. INSERT INTO `acceso` VALUES (826, 1, 2, '181.208.127.9', '2024-09-27 22:17:41');
  606. INSERT INTO `acceso` VALUES (827, 1, 1, '181.208.127.9', '2024-09-27 22:17:45');
  607. INSERT INTO `acceso` VALUES (828, 2, 1, '186.188.37.59', '2024-09-27 22:30:11');
  608. INSERT INTO `acceso` VALUES (829, 1, 1, '186.188.37.59', '2024-09-27 22:30:54');
  609. INSERT INTO `acceso` VALUES (830, 2, 2, '186.188.37.59', '2024-09-27 22:33:43');
  610. INSERT INTO `acceso` VALUES (831, 1, 1, '186.188.37.223', '2024-09-28 15:52:09');
  611. INSERT INTO `acceso` VALUES (832, 1, 1, '186.188.37.59', '2024-09-28 17:41:54');
  612. INSERT INTO `acceso` VALUES (833, 1, 1, '186.188.37.223', '2024-09-28 17:58:20');
  613. INSERT INTO `acceso` VALUES (834, 1, 1, '186.188.37.223', '2024-09-28 18:01:41');
  614. INSERT INTO `acceso` VALUES (835, 1, 1, '186.188.37.223', '2024-09-28 18:03:03');
  615. INSERT INTO `acceso` VALUES (836, 1, 1, '186.188.37.223', '2024-09-28 18:03:38');
  616. INSERT INTO `acceso` VALUES (837, 1, 1, '186.188.37.223', '2024-09-28 18:07:48');
  617. INSERT INTO `acceso` VALUES (838, 1, 1, '186.188.37.223', '2024-09-28 18:53:09');
  618. INSERT INTO `acceso` VALUES (839, 1, 1, '186.188.37.223', '2024-09-28 18:54:46');
  619. INSERT INTO `acceso` VALUES (840, 1, 1, '186.188.37.223', '2024-09-28 18:55:43');
  620. INSERT INTO `acceso` VALUES (841, 1, 1, '186.188.37.223', '2024-09-28 18:57:23');
  621. INSERT INTO `acceso` VALUES (842, 1, 1, '186.188.37.223', '2024-09-28 19:13:49');
  622. INSERT INTO `acceso` VALUES (843, 1, 1, '186.188.37.223', '2024-09-28 19:15:03');
  623. INSERT INTO `acceso` VALUES (844, 1, 1, '186.188.37.223', '2024-09-28 19:17:01');
  624. INSERT INTO `acceso` VALUES (845, 1, 1, '186.188.37.223', '2024-09-28 19:19:53');
  625. INSERT INTO `acceso` VALUES (846, 1, 1, '186.188.37.223', '2024-09-28 19:33:34');
  626. INSERT INTO `acceso` VALUES (847, 1, 1, '200.125.185.224', '2024-09-28 20:03:11');
  627. INSERT INTO `acceso` VALUES (848, 1, 1, '186.188.37.59', '2024-09-28 20:07:56');
  628. INSERT INTO `acceso` VALUES (849, 1, 1, '186.188.37.59', '2024-09-28 20:59:14');
  629. INSERT INTO `acceso` VALUES (850, 1, 1, '186.188.37.59', '2024-09-28 22:00:13');
  630. INSERT INTO `acceso` VALUES (851, 1, 1, '186.188.37.59', '2024-09-28 22:19:08');
  631. INSERT INTO `acceso` VALUES (852, 1, 1, '186.188.37.223', '2024-09-28 22:38:43');
  632. INSERT INTO `acceso` VALUES (853, 1, 2, '186.188.37.59', '2024-09-28 23:11:35');
  633. INSERT INTO `acceso` VALUES (854, 1, 1, '186.188.37.59', '2024-09-28 23:11:45');
  634. INSERT INTO `acceso` VALUES (855, 1, 2, '186.188.37.59', '2024-09-28 23:13:16');
  635. INSERT INTO `acceso` VALUES (856, 1, 1, '186.188.37.59', '2024-09-28 23:13:19');
  636. INSERT INTO `acceso` VALUES (857, 1, 2, '186.188.37.59', '2024-09-28 23:13:36');
  637. INSERT INTO `acceso` VALUES (858, 1, 1, '186.188.37.59', '2024-09-28 23:14:02');
  638. INSERT INTO `acceso` VALUES (859, 1, 2, '186.188.37.59', '2024-09-28 23:14:36');
  639. INSERT INTO `acceso` VALUES (860, 1, 1, '186.188.37.59', '2024-09-28 23:14:38');
  640. INSERT INTO `acceso` VALUES (861, 1, 2, '186.188.37.59', '2024-09-28 23:16:20');
  641. INSERT INTO `acceso` VALUES (862, 1, 1, '186.188.37.59', '2024-09-28 23:16:22');
  642. INSERT INTO `acceso` VALUES (863, 1, 2, '186.188.37.59', '2024-09-28 23:16:43');
  643. INSERT INTO `acceso` VALUES (864, 1, 2, '186.188.37.223', '2024-09-29 00:01:50');
  644. INSERT INTO `acceso` VALUES (865, 1, 1, '186.188.37.223', '2024-09-29 00:01:55');
  645. INSERT INTO `acceso` VALUES (866, 1, 2, '186.188.37.223', '2024-09-29 00:40:35');
  646. INSERT INTO `acceso` VALUES (867, 1, 1, '186.188.37.223', '2024-09-29 00:40:39');
  647. INSERT INTO `acceso` VALUES (868, 1, 2, '186.188.37.223', '2024-09-29 00:42:28');
  648. INSERT INTO `acceso` VALUES (869, 1, 1, '186.188.37.223', '2024-09-29 00:42:31');
  649. INSERT INTO `acceso` VALUES (870, 1, 1, '38.41.5.73', '2024-09-29 00:46:49');
  650. INSERT INTO `acceso` VALUES (871, 1, 1, '186.188.37.223', '2024-09-29 00:48:39');
  651. INSERT INTO `acceso` VALUES (872, 1, 2, '186.188.37.223', '2024-09-29 00:52:32');
  652. INSERT INTO `acceso` VALUES (873, 1, 1, '186.188.37.223', '2024-09-29 00:52:44');
  653. INSERT INTO `acceso` VALUES (874, 1, 1, '186.188.37.59', '2024-09-29 06:24:09');
  654. INSERT INTO `acceso` VALUES (875, 1, 2, '186.188.37.59', '2024-09-29 06:25:21');
  655. INSERT INTO `acceso` VALUES (876, 1, 1, '186.188.37.59', '2024-09-29 06:25:27');
  656. INSERT INTO `acceso` VALUES (877, 1, 1, '186.188.37.223', '2024-09-29 12:10:06');
  657. INSERT INTO `acceso` VALUES (878, 1, 2, '186.188.37.223', '2024-09-29 12:12:03');
  658. INSERT INTO `acceso` VALUES (879, 1, 1, '186.188.37.223', '2024-09-29 12:12:11');
  659. INSERT INTO `acceso` VALUES (880, 1, 2, '186.188.37.223', '2024-09-29 12:59:52');
  660. INSERT INTO `acceso` VALUES (881, 1, 1, '186.188.37.223', '2024-09-29 13:00:01');
  661. INSERT INTO `acceso` VALUES (882, 1, 1, '186.188.37.223', '2024-09-29 14:16:36');
  662. INSERT INTO `acceso` VALUES (883, 1, 2, '186.188.37.223', '2024-09-29 14:23:23');
  663. INSERT INTO `acceso` VALUES (884, 1, 1, '186.188.37.223', '2024-09-29 14:23:30');
  664. INSERT INTO `acceso` VALUES (885, 1, 1, '186.188.37.223', '2024-09-29 15:42:17');
  665. INSERT INTO `acceso` VALUES (886, 1, 1, '186.188.37.223', '2024-09-29 17:23:35');
  666. INSERT INTO `acceso` VALUES (887, 1, 1, '186.188.37.59', '2024-09-29 17:26:07');
  667. INSERT INTO `acceso` VALUES (888, 1, 2, '186.188.37.59', '2024-09-29 17:27:10');
  668. INSERT INTO `acceso` VALUES (889, 1, 1, '186.188.37.59', '2024-09-29 17:27:17');
  669. INSERT INTO `acceso` VALUES (890, 1, 2, '186.188.37.59', '2024-09-29 17:28:54');
  670. INSERT INTO `acceso` VALUES (891, 1, 1, '186.188.37.59', '2024-09-29 17:28:55');
  671. INSERT INTO `acceso` VALUES (892, 1, 1, '186.188.37.223', '2024-09-29 17:38:53');
  672. INSERT INTO `acceso` VALUES (893, 1, 1, '186.188.37.223', '2024-09-29 17:42:01');
  673. INSERT INTO `acceso` VALUES (894, 1, 1, '186.188.37.59', '2024-09-29 18:54:42');
  674. INSERT INTO `acceso` VALUES (895, 1, 1, '186.188.37.223', '2024-09-29 21:52:46');
  675. INSERT INTO `acceso` VALUES (896, 1, 1, '38.41.5.73', '2024-09-30 13:22:16');
  676. INSERT INTO `acceso` VALUES (897, 1, 1, '200.125.185.224', '2024-09-30 21:44:16');
  677. INSERT INTO `acceso` VALUES (898, 1, 1, '186.188.37.57', '2024-10-01 17:44:49');
  678. INSERT INTO `acceso` VALUES (899, 1, 1, '186.188.37.57', '2024-10-01 19:35:21');
  679. INSERT INTO `acceso` VALUES (900, 1, 1, '38.41.5.73', '2024-10-02 09:04:58');
  680. INSERT INTO `acceso` VALUES (901, 1, 1, '38.41.5.73', '2024-10-02 10:15:21');
  681. INSERT INTO `acceso` VALUES (902, 1, 1, '186.188.37.57', '2024-10-02 20:30:24');
  682. INSERT INTO `acceso` VALUES (903, 1, 1, '186.188.37.57', '2024-10-02 20:32:52');
  683. INSERT INTO `acceso` VALUES (904, 1, 2, '186.188.37.57', '2024-10-02 21:32:21');
  684. INSERT INTO `acceso` VALUES (905, 1, 1, '186.188.37.57', '2024-10-02 21:38:31');
  685. INSERT INTO `acceso` VALUES (906, 1, 1, '186.188.37.59', '2024-10-03 04:41:54');
  686. INSERT INTO `acceso` VALUES (907, 1, 1, '38.41.5.73', '2024-10-03 13:48:56');
  687. INSERT INTO `acceso` VALUES (908, 1, 1, '181.208.127.4', '2024-10-03 15:05:48');
  688. INSERT INTO `acceso` VALUES (909, 1, 2, '181.208.127.4', '2024-10-03 15:10:15');
  689. INSERT INTO `acceso` VALUES (910, 1, 1, '38.41.5.73', '2024-10-03 15:49:19');
  690. INSERT INTO `acceso` VALUES (911, 1, 1, '200.125.185.224', '2024-10-04 19:56:56');
  691. INSERT INTO `acceso` VALUES (912, 1, 1, '200.125.185.224', '2024-10-04 20:31:57');
  692. INSERT INTO `acceso` VALUES (913, 1, 2, '200.125.185.224', '2024-10-04 20:57:59');
  693. INSERT INTO `acceso` VALUES (914, 1, 1, '200.125.185.224', '2024-10-04 20:58:07');
  694. INSERT INTO `acceso` VALUES (915, 1, 2, '200.125.185.224', '2024-10-04 21:51:18');
  695. INSERT INTO `acceso` VALUES (916, 1, 1, '186.188.37.57', '2024-10-05 07:30:05');
  696. INSERT INTO `acceso` VALUES (917, 1, 1, '186.188.37.43', '2024-10-05 17:17:43');
  697. INSERT INTO `acceso` VALUES (918, 1, 1, '186.188.37.43', '2024-10-05 19:28:32');
  698. INSERT INTO `acceso` VALUES (919, 1, 1, '186.188.37.59', '2024-10-05 20:36:30');
  699. INSERT INTO `acceso` VALUES (920, 1, 1, '186.188.37.59', '2024-10-06 10:26:48');
  700. INSERT INTO `acceso` VALUES (921, 1, 1, '186.188.37.59', '2024-10-06 18:33:26');
  701. INSERT INTO `acceso` VALUES (922, 1, 1, '200.125.185.224', '2024-10-06 19:33:40');
  702. INSERT INTO `acceso` VALUES (923, 1, 2, '200.125.185.224', '2024-10-06 20:27:15');
  703. INSERT INTO `acceso` VALUES (924, 1, 1, '186.188.37.59', '2024-10-06 21:49:45');
  704. INSERT INTO `acceso` VALUES (925, 1, 2, '186.188.37.59', '2024-10-06 21:57:38');
  705. INSERT INTO `acceso` VALUES (926, 1, 1, '200.125.185.224', '2024-10-06 22:39:17');
  706. INSERT INTO `acceso` VALUES (927, 1, 1, '186.188.37.43', '2024-10-06 22:39:20');
  707. INSERT INTO `acceso` VALUES (928, 1, 2, '200.125.185.224', '2024-10-06 22:41:48');
  708. INSERT INTO `acceso` VALUES (929, 1, 1, '186.188.37.59', '2024-10-06 22:46:21');
  709. INSERT INTO `acceso` VALUES (930, 1, 1, '186.188.37.59', '2024-10-06 22:51:14');
  710. INSERT INTO `acceso` VALUES (931, 1, 2, '186.188.37.59', '2024-10-06 22:51:41');
  711. INSERT INTO `acceso` VALUES (932, 1, 1, '186.188.37.59', '2024-10-07 19:05:01');
  712. INSERT INTO `acceso` VALUES (933, 1, 1, '186.188.37.59', '2024-10-07 20:14:36');
  713. INSERT INTO `acceso` VALUES (934, 1, 1, '186.188.37.43', '2024-10-07 21:30:09');
  714. INSERT INTO `acceso` VALUES (935, 1, 1, '201.234.227.210', '2024-10-08 11:17:24');
  715. INSERT INTO `acceso` VALUES (936, 1, 1, '201.234.227.210', '2024-10-08 11:18:11');
  716. INSERT INTO `acceso` VALUES (937, 1, 1, '181.208.127.4', '2024-10-08 17:24:35');
  717. INSERT INTO `acceso` VALUES (938, 1, 1, '186.188.37.43', '2024-10-08 19:44:20');
  718. INSERT INTO `acceso` VALUES (939, 1, 1, '186.188.37.59', '2024-10-08 20:06:04');
  719. INSERT INTO `acceso` VALUES (940, 1, 1, '186.188.37.59', '2024-10-08 21:47:48');
  720. INSERT INTO `acceso` VALUES (941, 1, 2, '186.188.37.59', '2024-10-08 21:58:27');
  721. INSERT INTO `acceso` VALUES (942, 1, 1, '186.188.37.59', '2024-10-09 05:05:05');
  722. INSERT INTO `acceso` VALUES (943, 1, 1, '186.188.37.59', '2024-10-09 05:41:09');
  723. INSERT INTO `acceso` VALUES (944, 1, 1, '201.234.227.210', '2024-10-09 08:14:23');
  724. INSERT INTO `acceso` VALUES (945, 1, 1, '201.234.227.210', '2024-10-09 08:32:14');
  725. INSERT INTO `acceso` VALUES (946, 1, 1, '201.234.227.210', '2024-10-10 08:26:31');
  726. INSERT INTO `acceso` VALUES (947, 1, 1, '181.208.127.4', '2024-10-10 09:45:57');
  727. INSERT INTO `acceso` VALUES (948, 1, 2, '181.208.127.4', '2024-10-10 09:48:32');
  728. INSERT INTO `acceso` VALUES (949, 1, 1, '77.81.136.73', '2024-10-10 10:17:21');
  729. INSERT INTO `acceso` VALUES (950, 1, 2, '77.81.136.73', '2024-10-10 10:28:01');
  730. INSERT INTO `acceso` VALUES (951, 1, 1, '77.81.136.73', '2024-10-10 10:28:24');
  731. INSERT INTO `acceso` VALUES (952, 1, 2, '77.81.136.73', '2024-10-10 10:44:51');
  732. INSERT INTO `acceso` VALUES (953, 1, 1, '186.188.37.43', '2024-10-10 11:05:17');
  733. INSERT INTO `acceso` VALUES (954, 1, 2, '186.188.37.43', '2024-10-10 11:47:39');
  734. INSERT INTO `acceso` VALUES (955, 1, 1, '186.188.37.43', '2024-10-10 11:48:20');
  735. INSERT INTO `acceso` VALUES (956, 1, 2, '186.188.37.43', '2024-10-10 11:51:39');
  736. INSERT INTO `acceso` VALUES (957, 6, 1, '186.188.37.43', '2024-10-10 11:51:48');
  737. INSERT INTO `acceso` VALUES (958, 1, 1, '201.234.227.210', '2024-10-11 08:02:04');
  738. INSERT INTO `acceso` VALUES (959, 1, 2, '201.234.227.210', '2024-10-11 08:11:51');
  739. INSERT INTO `acceso` VALUES (960, 6, 1, '201.234.227.210', '2024-10-11 08:11:59');
  740. INSERT INTO `acceso` VALUES (961, 6, 2, '201.234.227.210', '2024-10-11 08:12:52');
  741. INSERT INTO `acceso` VALUES (962, 6, 1, '201.234.227.210', '2024-10-11 08:13:01');
  742. INSERT INTO `acceso` VALUES (963, 6, 2, '201.234.227.210', '2024-10-11 08:23:39');
  743. INSERT INTO `acceso` VALUES (964, 6, 1, '201.234.227.210', '2024-10-11 08:37:45');
  744. INSERT INTO `acceso` VALUES (965, 6, 2, '201.234.227.210', '2024-10-11 08:48:05');
  745. INSERT INTO `acceso` VALUES (966, 6, 1, '201.234.227.210', '2024-10-11 10:14:45');
  746. INSERT INTO `acceso` VALUES (967, 6, 2, '201.234.227.210', '2024-10-11 10:33:12');
  747. INSERT INTO `acceso` VALUES (968, 1, 1, '200.8.184.115', '2024-10-11 11:41:21');
  748. INSERT INTO `acceso` VALUES (969, 1, 2, '200.8.184.115', '2024-10-11 11:42:20');
  749. INSERT INTO `acceso` VALUES (970, 1, 1, '186.188.37.59', '2024-10-12 05:55:46');
  750. INSERT INTO `acceso` VALUES (971, 1, 1, '200.125.185.224', '2024-10-12 18:16:34');
  751. INSERT INTO `acceso` VALUES (972, 1, 1, '186.188.37.43', '2024-10-13 18:21:45');
  752. INSERT INTO `acceso` VALUES (973, 1, 1, '186.188.37.43', '2024-10-13 19:21:16');
  753. INSERT INTO `acceso` VALUES (974, 1, 1, '200.125.185.224', '2024-10-14 21:35:40');
  754. INSERT INTO `acceso` VALUES (975, 1, 2, '200.125.185.224', '2024-10-14 23:22:05');
  755. INSERT INTO `acceso` VALUES (976, 1, 1, '186.188.37.59', '2024-10-14 23:28:11');
  756. INSERT INTO `acceso` VALUES (977, 1, 2, '186.188.37.59', '2024-10-14 23:31:47');
  757. INSERT INTO `acceso` VALUES (978, 1, 1, '38.41.5.73', '2024-10-15 07:48:27');
  758. INSERT INTO `acceso` VALUES (979, 6, 1, '200.189.27.122', '2024-10-15 13:19:47');
  759. INSERT INTO `acceso` VALUES (980, 1, 1, '201.234.227.210', '2024-10-15 13:24:06');
  760. INSERT INTO `acceso` VALUES (981, 1, 1, '186.188.37.59', '2024-10-15 22:09:50');
  761. INSERT INTO `acceso` VALUES (982, 1, 1, '186.188.37.59', '2024-10-16 06:52:49');
  762. INSERT INTO `acceso` VALUES (983, 1, 1, '186.167.180.58', '2024-10-16 07:41:51');
  763. INSERT INTO `acceso` VALUES (984, 1, 1, '186.188.37.59', '2024-10-16 21:04:29');
  764. INSERT INTO `acceso` VALUES (985, 1, 1, '200.125.185.224', '2024-10-16 22:11:33');
  765. INSERT INTO `acceso` VALUES (986, 1, 2, '200.125.185.224', '2024-10-16 22:13:19');
  766. INSERT INTO `acceso` VALUES (987, 1, 1, '186.188.37.59', '2024-10-17 06:10:53');
  767. INSERT INTO `acceso` VALUES (988, 1, 1, '38.41.5.73', '2024-10-17 08:09:42');
  768. INSERT INTO `acceso` VALUES (989, 1, 1, '186.188.37.59', '2024-10-17 20:12:44');
  769. INSERT INTO `acceso` VALUES (990, 1, 1, '186.188.37.43', '2024-10-17 20:31:12');
  770. INSERT INTO `acceso` VALUES (991, 1, 1, '200.125.185.224', '2024-10-17 20:50:25');
  771. INSERT INTO `acceso` VALUES (992, 1, 1, '200.125.185.224', '2024-10-17 20:51:02');
  772. INSERT INTO `acceso` VALUES (993, 1, 2, '200.125.185.224', '2024-10-17 20:52:32');
  773. INSERT INTO `acceso` VALUES (994, 1, 1, '186.188.37.59', '2024-10-17 21:12:09');
  774. INSERT INTO `acceso` VALUES (995, 1, 1, '186.188.37.59', '2024-10-17 22:26:15');
  775. INSERT INTO `acceso` VALUES (996, 1, 1, '186.188.37.43', '2024-10-18 21:18:00');
  776. INSERT INTO `acceso` VALUES (997, 1, 1, '200.125.185.224', '2024-10-21 22:41:15');
  777. INSERT INTO `acceso` VALUES (998, 1, 2, '200.125.185.224', '2024-10-21 22:52:11');
  778. INSERT INTO `acceso` VALUES (999, 1, 1, '200.82.254.6', '2024-10-22 05:56:41');
  779. INSERT INTO `acceso` VALUES (1000, 1, 1, '38.41.5.73', '2024-10-22 08:22:34');
  780. INSERT INTO `acceso` VALUES (1001, 1, 1, '38.41.5.73', '2024-10-22 09:07:28');
  781. INSERT INTO `acceso` VALUES (1002, 1, 1, '201.234.227.210', '2024-10-22 09:26:25');
  782. INSERT INTO `acceso` VALUES (1003, 1, 1, '201.234.227.210', '2024-10-22 10:52:47');
  783. INSERT INTO `acceso` VALUES (1004, 1, 2, '201.234.227.210', '2024-10-22 10:53:58');
  784. INSERT INTO `acceso` VALUES (1005, 6, 1, '129.222.203.159', '2024-10-22 11:16:10');
  785. INSERT INTO `acceso` VALUES (1006, 6, 1, '129.222.203.159', '2024-10-22 11:22:00');
  786. INSERT INTO `acceso` VALUES (1007, 6, 2, '129.222.203.159', '2024-10-22 11:25:24');
  787. INSERT INTO `acceso` VALUES (1008, 1, 1, '201.234.227.210', '2024-10-22 11:49:53');
  788. INSERT INTO `acceso` VALUES (1009, 6, 1, '129.222.203.159', '2024-10-22 11:52:59');
  789. INSERT INTO `acceso` VALUES (1010, 6, 2, '129.222.203.159', '2024-10-22 12:12:31');
  790. INSERT INTO `acceso` VALUES (1011, 6, 1, '129.222.203.159', '2024-10-22 12:13:06');
  791. INSERT INTO `acceso` VALUES (1012, 1, 1, '38.41.5.73', '2024-10-22 13:29:51');
  792. INSERT INTO `acceso` VALUES (1013, 1, 1, '38.41.5.73', '2024-10-22 15:03:52');
  793. INSERT INTO `acceso` VALUES (1014, 1, 1, '38.41.5.73', '2024-10-22 15:10:48');
  794. INSERT INTO `acceso` VALUES (1015, 1, 1, '181.208.127.4', '2024-10-22 15:42:17');
  795. INSERT INTO `acceso` VALUES (1016, 1, 2, '181.208.127.4', '2024-10-22 15:43:20');
  796. INSERT INTO `acceso` VALUES (1017, 1, 1, '200.82.254.6', '2024-10-22 19:57:16');
  797. INSERT INTO `acceso` VALUES (1018, 1, 1, '186.188.37.43', '2024-10-22 21:14:24');
  798. INSERT INTO `acceso` VALUES (1019, 1, 1, '181.208.127.4', '2024-10-24 09:07:53');
  799. INSERT INTO `acceso` VALUES (1020, 1, 2, '181.208.127.4', '2024-10-24 09:09:15');
  800. INSERT INTO `acceso` VALUES (1021, 1, 1, '186.188.37.43', '2024-10-24 21:25:59');
  801. INSERT INTO `acceso` VALUES (1022, 1, 1, '200.82.254.6', '2024-10-24 22:07:43');
  802. INSERT INTO `acceso` VALUES (1023, 1, 1, '38.41.5.73', '2024-10-25 11:54:53');
  803. INSERT INTO `acceso` VALUES (1024, 1, 1, '38.41.5.73', '2024-10-25 13:25:27');
  804. INSERT INTO `acceso` VALUES (1025, 1, 2, '38.41.5.73', '2024-10-25 13:30:19');
  805. INSERT INTO `acceso` VALUES (1026, 1, 1, '38.41.5.73', '2024-10-25 13:32:06');
  806. INSERT INTO `acceso` VALUES (1027, 1, 2, '38.41.5.73', '2024-10-25 14:04:36');
  807. INSERT INTO `acceso` VALUES (1028, 1, 1, '38.41.5.73', '2024-10-25 14:06:32');
  808. INSERT INTO `acceso` VALUES (1029, 1, 2, '38.41.5.73', '2024-10-25 14:09:12');
  809. INSERT INTO `acceso` VALUES (1030, 1, 1, '38.41.5.73', '2024-10-25 14:09:22');
  810. INSERT INTO `acceso` VALUES (1031, 1, 2, '38.41.5.73', '2024-10-25 14:14:31');
  811. INSERT INTO `acceso` VALUES (1032, 1, 1, '38.41.5.73', '2024-10-25 14:14:56');
  812. INSERT INTO `acceso` VALUES (1033, 1, 1, '38.41.5.73', '2024-10-25 16:25:18');
  813. INSERT INTO `acceso` VALUES (1034, 1, 1, '186.188.37.43', '2024-10-25 19:42:16');
  814. INSERT INTO `acceso` VALUES (1035, 1, 1, '200.82.254.6', '2024-10-25 20:49:39');
  815. INSERT INTO `acceso` VALUES (1036, 1, 1, '186.188.37.43', '2024-10-25 21:59:29');
  816. INSERT INTO `acceso` VALUES (1037, 1, 1, '200.82.254.6', '2024-10-26 08:59:47');
  817. INSERT INTO `acceso` VALUES (1038, 1, 1, '186.188.37.43', '2024-10-26 13:20:34');
  818. INSERT INTO `acceso` VALUES (1039, 1, 1, '200.82.254.6', '2024-10-26 16:36:45');
  819. INSERT INTO `acceso` VALUES (1040, 1, 1, '200.82.254.6', '2024-10-26 17:32:25');
  820. INSERT INTO `acceso` VALUES (1041, 1, 2, '200.82.254.6', '2024-10-26 17:55:18');
  821. INSERT INTO `acceso` VALUES (1042, 1, 1, '200.82.254.6', '2024-10-27 11:03:16');
  822. INSERT INTO `acceso` VALUES (1043, 1, 1, '200.82.254.6', '2024-10-27 12:01:24');
  823. INSERT INTO `acceso` VALUES (1044, 1, 1, '186.167.164.254', '2024-10-28 05:28:15');
  824. INSERT INTO `acceso` VALUES (1045, 1, 1, '38.41.5.73', '2024-10-28 08:13:47');
  825. INSERT INTO `acceso` VALUES (1046, 1, 1, '201.234.227.210', '2024-10-28 08:17:30');
  826. INSERT INTO `acceso` VALUES (1047, 1, 1, '38.41.5.73', '2024-10-28 08:58:51');
  827. INSERT INTO `acceso` VALUES (1048, 1, 1, '201.234.227.210', '2024-10-28 09:07:30');
  828. INSERT INTO `acceso` VALUES (1049, 1, 1, '38.41.5.73', '2024-10-28 09:44:23');
  829. INSERT INTO `acceso` VALUES (1050, 1, 1, '201.234.227.210', '2024-10-28 10:38:00');
  830. INSERT INTO `acceso` VALUES (1051, 1, 1, '201.234.227.210', '2024-10-28 11:43:02');
  831. INSERT INTO `acceso` VALUES (1052, 1, 1, '38.41.5.73', '2024-10-28 13:47:34');
  832. INSERT INTO `acceso` VALUES (1053, 1, 1, '181.208.127.4', '2024-10-28 17:23:42');
  833. INSERT INTO `acceso` VALUES (1054, 1, 2, '181.208.127.4', '2024-10-28 17:31:22');
  834. INSERT INTO `acceso` VALUES (1055, 1, 1, '200.82.254.6', '2024-10-28 23:14:04');
  835. INSERT INTO `acceso` VALUES (1056, 1, 1, '200.82.254.6', '2024-10-28 23:30:32');
  836. INSERT INTO `acceso` VALUES (1057, 1, 2, '200.82.254.6', '2024-10-28 23:38:31');
  837. INSERT INTO `acceso` VALUES (1058, 1, 1, '200.82.254.6', '2024-10-28 23:38:36');
  838. INSERT INTO `acceso` VALUES (1059, 1, 2, '200.82.254.6', '2024-10-28 23:39:04');
  839. INSERT INTO `acceso` VALUES (1060, 1, 1, '200.82.254.6', '2024-10-28 23:39:07');
  840. INSERT INTO `acceso` VALUES (1061, 1, 2, '200.82.254.6', '2024-10-28 23:41:32');
  841. INSERT INTO `acceso` VALUES (1062, 1, 1, '200.82.254.6', '2024-10-28 23:41:35');
  842. INSERT INTO `acceso` VALUES (1063, 1, 2, '200.82.254.6', '2024-10-28 23:50:09');
  843. INSERT INTO `acceso` VALUES (1064, 1, 1, '200.82.254.6', '2024-10-28 23:50:11');
  844. INSERT INTO `acceso` VALUES (1065, 1, 2, '200.82.254.6', '2024-10-28 23:50:48');
  845. INSERT INTO `acceso` VALUES (1066, 1, 1, '200.82.254.6', '2024-10-28 23:50:50');
  846. INSERT INTO `acceso` VALUES (1067, 1, 1, '200.82.254.6', '2024-10-28 23:57:03');
  847. INSERT INTO `acceso` VALUES (1068, 1, 1, '200.82.254.6', '2024-10-28 23:57:27');
  848. INSERT INTO `acceso` VALUES (1069, 1, 1, '200.82.254.6', '2024-10-29 06:34:53');
  849. INSERT INTO `acceso` VALUES (1070, 1, 2, '200.82.254.6', '2024-10-29 06:41:43');
  850. INSERT INTO `acceso` VALUES (1071, 1, 1, '200.82.254.6', '2024-10-29 06:41:45');
  851. INSERT INTO `acceso` VALUES (1072, 1, 2, '200.82.254.6', '2024-10-29 07:14:08');
  852. INSERT INTO `acceso` VALUES (1073, 1, 1, '200.82.254.6', '2024-10-29 07:15:24');
  853. INSERT INTO `acceso` VALUES (1074, 1, 2, '200.82.254.6', '2024-10-29 07:18:44');
  854. INSERT INTO `acceso` VALUES (1075, 1, 1, '200.82.254.6', '2024-10-29 07:18:47');
  855. INSERT INTO `acceso` VALUES (1076, 1, 2, '200.82.254.6', '2024-10-29 07:18:54');
  856. INSERT INTO `acceso` VALUES (1077, 1, 1, '38.41.5.73', '2024-10-29 07:26:13');
  857. INSERT INTO `acceso` VALUES (1078, 1, 1, '181.208.127.4', '2024-10-29 09:30:23');
  858. INSERT INTO `acceso` VALUES (1079, 1, 2, '181.208.127.4', '2024-10-29 09:31:31');
  859. INSERT INTO `acceso` VALUES (1080, 1, 1, '181.208.127.4', '2024-10-29 10:04:16');
  860. INSERT INTO `acceso` VALUES (1081, 1, 2, '181.208.127.4', '2024-10-29 10:09:52');
  861. INSERT INTO `acceso` VALUES (1082, 1, 1, '38.41.5.73', '2024-10-29 14:36:52');
  862. INSERT INTO `acceso` VALUES (1083, 1, 1, '200.82.254.6', '2024-10-29 18:28:16');
  863. INSERT INTO `acceso` VALUES (1084, 1, 1, '200.82.254.6', '2024-10-29 19:42:22');
  864. INSERT INTO `acceso` VALUES (1085, 1, 2, '200.82.254.6', '2024-10-29 19:45:13');
  865.  
  866. -- ----------------------------
  867. -- Table structure for aeronave
  868. -- ----------------------------
  869. DROP TABLE IF EXISTS `aeronave`;
  870. CREATE TABLE `aeronave`  (
  871.   `id` int NOT NULL AUTO_INCREMENT,
  872.   `sigla` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  873.   `cliente_id` int NULL DEFAULT NULL,
  874.   `fecha_construccion` date NULL DEFAULT NULL,
  875.   `serial_aeronave` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  876.   `serial_motor` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  877.   `serie_id` int NULL DEFAULT NULL,
  878.   `estatus` tinyint NULL DEFAULT 1,
  879.   `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  880.   `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  881.   PRIMARY KEY (`id`) USING BTREE,
  882.   INDEX `fk_aeronave_cliente_id`(`cliente_id` ASC) USING BTREE,
  883.   INDEX `fk_aeronave_serie_id`(`serie_id` ASC) USING BTREE,
  884.   CONSTRAINT `fk_aeronave_cliente_id` FOREIGN KEY (`cliente_id`) REFERENCES `cliente` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  885.   CONSTRAINT `fk_aeronave_serie_id` FOREIGN KEY (`serie_id`) REFERENCES `serie` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  886. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Tabla que contiene las Aeronaves de los Clientes del Sistema.' ROW_FORMAT = Dynamic;
  887.  
  888. -- ----------------------------
  889. -- Records of aeronave
  890. -- ----------------------------
  891.  
  892. -- ----------------------------
  893. -- Table structure for almacen
  894. -- ----------------------------
  895. DROP TABLE IF EXISTS `almacen`;
  896. CREATE TABLE `almacen`  (
  897.   `id` int NOT NULL AUTO_INCREMENT,
  898.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  899.   `estatus` tinyint NULL DEFAULT 1,
  900.   `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  901.   `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  902.   PRIMARY KEY (`id`) USING BTREE,
  903.   INDEX `id`(`id` ASC) USING BTREE
  904. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Tabla que contiene los Almacenes  para definir sus Ubicaciones de los Artículos del Inventario.-' ROW_FORMAT = Dynamic;
  905.  
  906. -- ----------------------------
  907. -- Records of almacen
  908. -- ----------------------------
  909. INSERT INTO `almacen` VALUES (1, 'PRINCIPAL', 1, '2024-10-22 11:25:38', '2024-10-22 11:25:38');
  910.  
  911. -- ----------------------------
  912. -- Table structure for backup
  913. -- ----------------------------
  914. DROP TABLE IF EXISTS `backup`;
  915. CREATE TABLE `backup`  (
  916.   `id` int NOT NULL AUTO_INCREMENT,
  917.   `usuario_id` int NOT NULL,
  918.   `denominacion` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  919.   `tamano` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  920.   `archivo` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  921.   `backup_at` datetime NULL DEFAULT NULL,
  922.   PRIMARY KEY (`id`) USING BTREE,
  923.   INDEX `fk_backup_usuario_idx`(`usuario_id` ASC) USING BTREE,
  924.   CONSTRAINT `backup_ibfk_1` FOREIGN KEY (`usuario_id`) REFERENCES `usuario` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
  925. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'Tabla que contiene las copias de seguridad del sistema' ROW_FORMAT = Dynamic;
  926.  
  927. -- ----------------------------
  928. -- Records of backup
  929. -- ----------------------------
  930. INSERT INTO `backup` VALUES (1, 2, 'DBKM Inicial', '3,44 KB', 'backup-1.sql.gz', '2014-01-01 00:00:01');
  931.  
  932. -- ----------------------------
  933. -- Table structure for cliente
  934. -- ----------------------------
  935. DROP TABLE IF EXISTS `cliente`;
  936. CREATE TABLE `cliente`  (
  937.   `id` int NOT NULL AUTO_INCREMENT,
  938.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  939.   `razon_social` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  940.   `rif` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  941.   `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  942.   `telefono_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  943.   `telefono_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  944.   `telefono_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  945.   `correo_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  946.   `correo_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  947.   `correo_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  948.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  949.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  950.   PRIMARY KEY (`id`) USING BTREE
  951. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Tabla que contiene los Clientes a quienes se le factura los servicios en el Sistema.-' ROW_FORMAT = Dynamic;
  952.  
  953. -- ----------------------------
  954. -- Records of cliente
  955. -- ----------------------------
  956. INSERT INTO `cliente` VALUES (1, 'CLIENTE DE PRUEBA', NULL, 'J-00000000', 'DIRECCION', '03430303', NULL, NULL, NULL, NULL, NULL, '2024-10-28 13:49:04', NULL);
  957.  
  958. -- ----------------------------
  959. -- Table structure for compra_d
  960. -- ----------------------------
  961. DROP TABLE IF EXISTS `compra_d`;
  962. CREATE TABLE `compra_d`  (
  963.   `id` int NOT NULL AUTO_INCREMENT,
  964.   `compra_t_id` int NULL DEFAULT NULL,
  965.   `inventario_id` int NULL DEFAULT NULL,
  966.   `unidad_id` int NULL DEFAULT NULL,
  967.   `ubicacion_id` int NULL DEFAULT NULL,
  968.   `cantidad` decimal(10, 2) NULL DEFAULT 0.00,
  969.   `precio_unitario` decimal(10, 2) NULL DEFAULT 0.00,
  970.   `precio_total` decimal(10, 2) NULL DEFAULT 0.00,
  971.   `descripcion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  972.   `procesado` int NULL DEFAULT 0,
  973.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  974.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  975.   PRIMARY KEY (`id`) USING BTREE,
  976.   INDEX `fk_compraD_inventario_id`(`inventario_id` ASC) USING BTREE,
  977.   INDEX `fk_compraD_compraT_id`(`compra_t_id` ASC) USING BTREE,
  978.   INDEX `fk_compraD_unidad_id`(`unidad_id` ASC) USING BTREE,
  979.   INDEX `fk_compraD_ubicacion_id`(`ubicacion_id` ASC) USING BTREE,
  980.   CONSTRAINT `fk_compraD_compraT_id` FOREIGN KEY (`compra_t_id`) REFERENCES `compra_t` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  981.   CONSTRAINT `fk_compraD_inventario_id` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  982.   CONSTRAINT `fk_compraD_ubicacion_id` FOREIGN KEY (`ubicacion_id`) REFERENCES `ubicacion` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  983.   CONSTRAINT `fk_compraD_unidad_id` FOREIGN KEY (`unidad_id`) REFERENCES `unidad` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  984. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  985.  
  986. -- ----------------------------
  987. -- Records of compra_d
  988. -- ----------------------------
  989.  
  990. -- ----------------------------
  991. -- Table structure for compra_t
  992. -- ----------------------------
  993. DROP TABLE IF EXISTS `compra_t`;
  994. CREATE TABLE `compra_t`  (
  995.   `id` int NOT NULL AUTO_INCREMENT,
  996.   `proveedor_id` int NULL DEFAULT NULL,
  997.   `currier_id` int NULL DEFAULT NULL,
  998.   `fecha` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  999.   `forma_p` enum('Credito','Contado') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1000.   `factura_num` int NULL DEFAULT NULL,
  1001.   `monto_total` decimal(10, 2) NULL DEFAULT NULL,
  1002.   `abono` decimal(10, 2) NULL DEFAULT NULL,
  1003.   `dias_creditos` int NULL DEFAULT NULL,
  1004.   `fecha_vencimiento` date NULL DEFAULT NULL,
  1005.   `monto_currier` decimal(10, 2) NULL DEFAULT NULL,
  1006.   `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1007.   `tipo_compra` enum('Nacional','Internacional') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1008.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1009.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1010.   PRIMARY KEY (`id`) USING BTREE,
  1011.   INDEX `fk_compraT_proveedor_id`(`proveedor_id` ASC) USING BTREE,
  1012.   INDEX `fk_compraT_currier_id`(`currier_id` ASC) USING BTREE,
  1013.   CONSTRAINT `fk_compraT_currier_id` FOREIGN KEY (`currier_id`) REFERENCES `currier` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1014.   CONSTRAINT `fk_compraT_proveedor_id` FOREIGN KEY (`proveedor_id`) REFERENCES `proveedor` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1015. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1016.  
  1017. -- ----------------------------
  1018. -- Records of compra_t
  1019. -- ----------------------------
  1020.  
  1021. -- ----------------------------
  1022. -- Table structure for condicion
  1023. -- ----------------------------
  1024. DROP TABLE IF EXISTS `condicion`;
  1025. CREATE TABLE `condicion`  (
  1026.   `id` int NOT NULL AUTO_INCREMENT,
  1027.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  1028.   `estatus` tinyint NULL DEFAULT 1,
  1029.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1030.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1031.   PRIMARY KEY (`id`) USING BTREE
  1032. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1033.  
  1034. -- ----------------------------
  1035. -- Records of condicion
  1036. -- ----------------------------
  1037. INSERT INTO `condicion` VALUES (1, 'NUEVO', 1, '2024-10-22 11:23:41', NULL);
  1038. INSERT INTO `condicion` VALUES (2, 'SERVICIABLE', 1, '2024-10-22 11:23:56', NULL);
  1039. INSERT INTO `condicion` VALUES (3, 'OVERHAULED', 1, '2024-10-22 11:24:16', NULL);
  1040.  
  1041. -- ----------------------------
  1042. -- Table structure for currier
  1043. -- ----------------------------
  1044. DROP TABLE IF EXISTS `currier`;
  1045. CREATE TABLE `currier`  (
  1046.   `id` int NOT NULL AUTO_INCREMENT,
  1047.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1048.   `rif` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1049.   `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1050.   `telefono` int NULL DEFAULT NULL,
  1051.   `correo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1052.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1053.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1054.   PRIMARY KEY (`id`) USING BTREE
  1055. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1056.  
  1057. -- ----------------------------
  1058. -- Records of currier
  1059. -- ----------------------------
  1060.  
  1061. -- ----------------------------
  1062. -- Table structure for estado_usuario
  1063. -- ----------------------------
  1064. DROP TABLE IF EXISTS `estado_usuario`;
  1065. CREATE TABLE `estado_usuario`  (
  1066.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'Identificador del estado del usuario',
  1067.   `usuario_id` int NOT NULL COMMENT 'Identificador del usuario',
  1068.   `estado_usuario` int NOT NULL COMMENT 'Código del estado del usuario',
  1069.   `descripcion` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Motivo del cambio de estado',
  1070.   `estado_usuario_at` datetime NULL DEFAULT NULL COMMENT 'Fecha del cambio de estado',
  1071.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1072.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1073.   PRIMARY KEY (`id`) USING BTREE,
  1074.   INDEX `fk_estado_usuario_usuario_idx`(`usuario_id` ASC) USING BTREE,
  1075.   CONSTRAINT `estado_usuario_ibfk_1` FOREIGN KEY (`usuario_id`) REFERENCES `usuario` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
  1076. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'Tabla que contiene los estados de los usuarios' ROW_FORMAT = Dynamic;
  1077.  
  1078. -- ----------------------------
  1079. -- Records of estado_usuario
  1080. -- ----------------------------
  1081. INSERT INTO `estado_usuario` VALUES (1, 1, 2, 'Bloqueado por ser un usuario sin privilegios', '2014-01-01 00:00:01', '2024-10-21 22:44:12', NULL);
  1082. INSERT INTO `estado_usuario` VALUES (2, 2, 1, 'Activo por ser el Super Usuario del sistema', '2014-01-01 00:00:01', '2024-10-21 22:44:12', NULL);
  1083. INSERT INTO `estado_usuario` VALUES (3, 3, 1, 'ACTIVADO', '2021-01-26 23:07:23', '2024-10-21 22:44:12', NULL);
  1084. INSERT INTO `estado_usuario` VALUES (4, 4, 1, 'Activado por registro inicial', '2022-09-06 22:00:28', '2024-10-21 22:44:12', NULL);
  1085. INSERT INTO `estado_usuario` VALUES (5, 5, 1, 'Activado por registro inicial', '2024-09-22 15:58:07', '2024-10-21 22:44:12', NULL);
  1086. INSERT INTO `estado_usuario` VALUES (6, 6, 1, 'Activo Administrador del sistema', NULL, '2024-10-21 22:44:12', NULL);
  1087.  
  1088. -- ----------------------------
  1089. -- Table structure for inventario
  1090. -- ----------------------------
  1091. DROP TABLE IF EXISTS `inventario`;
  1092. CREATE TABLE `inventario`  (
  1093.   `id` int NOT NULL AUTO_INCREMENT,
  1094.   `marca_id` int NULL DEFAULT NULL,
  1095.   `modelo_id` int NULL DEFAULT NULL,
  1096.   `ubicacion_id` int NULL DEFAULT NULL,
  1097.   `unidad_id` int NULL DEFAULT NULL,
  1098.   `tipo` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1099.   `num_parte` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1100.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  1101.   `expiracion_ini` date NULL DEFAULT NULL,
  1102.   `expiracion_fin` date NULL DEFAULT NULL,
  1103.   `doc` tinyint(1) NULL DEFAULT NULL,
  1104.   `existencia_total` int NULL DEFAULT NULL,
  1105.   `existencia_min` int NULL DEFAULT NULL,
  1106.   `prioridad` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  1107.   `observaciones` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  1108.   `condicion` enum('new','used','overhauled','rep','serviceable','util','resguard') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1109.   `estatus` tinyint NULL DEFAULT 1,
  1110.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1111.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1112.   PRIMARY KEY (`id`) USING BTREE,
  1113.   INDEX `fk_inventario_unidad_id`(`unidad_id` ASC) USING BTREE,
  1114.   INDEX `fk_inventario_ubicacion_id`(`ubicacion_id` ASC) USING BTREE,
  1115.   INDEX `fk_inventario_invenMarca_id`(`marca_id` ASC) USING BTREE,
  1116.   INDEX `fk_inventario_invenModelo_id`(`modelo_id` ASC) USING BTREE,
  1117.   CONSTRAINT `fk_inventario_invenMarca_id` FOREIGN KEY (`marca_id`) REFERENCES `marca` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1118.   CONSTRAINT `fk_inventario_invenModelo_id` FOREIGN KEY (`modelo_id`) REFERENCES `modelo` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1119.   CONSTRAINT `fk_inventario_ubicacion_id` FOREIGN KEY (`ubicacion_id`) REFERENCES `ubicacion` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1120.   CONSTRAINT `fk_inventario_unidad_id` FOREIGN KEY (`unidad_id`) REFERENCES `unidad` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1121. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1122.  
  1123. -- ----------------------------
  1124. -- Records of inventario
  1125. -- ----------------------------
  1126. INSERT INTO `inventario` VALUES (1, 1, 1, NULL, 1, 'REPUESTO', 'MS29512-254', 'PACKING', '2025-02-22', '2025-12-22', 1, 15, 10, 'A', 'OBSERVACION', NULL, 1, '2024-10-22 11:40:26', '2024-10-28 10:39:59');
  1127. INSERT INTO `inventario` VALUES (3, 1, 1, NULL, 1, 'REPUESTO', '12345644433', 'OTRO NOMBRE PORQUE LO CAMBIE', '2024-10-22', '2024-10-22', 0, NULL, 0, 'B', 'OBSERVACION', NULL, 1, '2024-10-22 15:43:56', '2024-10-26 14:39:47');
  1128.  
  1129. -- ----------------------------
  1130. -- Table structure for inventario_ajuste_d
  1131. -- ----------------------------
  1132. DROP TABLE IF EXISTS `inventario_ajuste_d`;
  1133. CREATE TABLE `inventario_ajuste_d`  (
  1134.   `id` int NOT NULL AUTO_INCREMENT,
  1135.   `inventario_ajuste_t_id` int NULL DEFAULT NULL,
  1136.   `inventario_id` int NULL DEFAULT NULL,
  1137.   `inventario_ubicacion_id` int NULL DEFAULT NULL,
  1138.   `unidad_id` int NULL DEFAULT NULL,
  1139.   `existencia_old` decimal(10, 2) NULL DEFAULT 0.00,
  1140.   `existencia_new` decimal(10, 2) NULL DEFAULT 0.00,
  1141.   `precio` decimal(10, 2) NULL DEFAULT 0.00,
  1142.   `procesado` int NULL DEFAULT 0,
  1143.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1144.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1145.   PRIMARY KEY (`id`) USING BTREE,
  1146.   INDEX `fk_invenAjusteD_invenAjusteT_id`(`inventario_ajuste_t_id` ASC) USING BTREE,
  1147.   INDEX `fk_invenAjusteD_inventario_id`(`inventario_id` ASC) USING BTREE,
  1148.   INDEX `fk_invenAjusteD_invenUbica_id`(`inventario_ubicacion_id` ASC) USING BTREE,
  1149.   INDEX `fk_invenAjusteD_unidad_id`(`unidad_id` ASC) USING BTREE,
  1150.   CONSTRAINT `fk_invenAjusteD_invenAjusteT_id` FOREIGN KEY (`inventario_ajuste_t_id`) REFERENCES `inventario_ajuste_t` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1151.   CONSTRAINT `fk_invenAjusteD_inventario_id` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1152.   CONSTRAINT `fk_invenAjusteD_invenUbica_id` FOREIGN KEY (`inventario_ubicacion_id`) REFERENCES `inventario_ubicacion` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1153.   CONSTRAINT `fk_invenAjusteD_unidad_id` FOREIGN KEY (`unidad_id`) REFERENCES `unidad` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1154. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Tabla que contiene el Datalle de los Ajustes para los Artículos del Inventario.-' ROW_FORMAT = DYNAMIC;
  1155.  
  1156. -- ----------------------------
  1157. -- Records of inventario_ajuste_d
  1158. -- ----------------------------
  1159.  
  1160. -- ----------------------------
  1161. -- Table structure for inventario_ajuste_t
  1162. -- ----------------------------
  1163. DROP TABLE IF EXISTS `inventario_ajuste_t`;
  1164. CREATE TABLE `inventario_ajuste_t`  (
  1165.   `id` int NOT NULL AUTO_INCREMENT,
  1166.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  1167.   `usuario_id` int NULL DEFAULT NULL,
  1168.   `fecha` datetime NULL DEFAULT NULL,
  1169.   `procesado` int NULL DEFAULT 0,
  1170.   `observacion` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  1171.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1172.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1173.   PRIMARY KEY (`id`) USING BTREE,
  1174.   INDEX `fk_invenAjusteT_usuario_id`(`usuario_id` ASC) USING BTREE,
  1175.   CONSTRAINT `fk_invenAjusteT_usuario_id` FOREIGN KEY (`usuario_id`) REFERENCES `usuario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1176. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Tabla que contiene los Títulos de los Ajustes para los Artículos del Inventario.-' ROW_FORMAT = DYNAMIC;
  1177.  
  1178. -- ----------------------------
  1179. -- Records of inventario_ajuste_t
  1180. -- ----------------------------
  1181. INSERT INTO `inventario_ajuste_t` VALUES (1, 'PRUEBA', 1, NULL, NULL, 'TEST', '2024-10-27 12:04:07', '2024-10-27 12:45:56');
  1182.  
  1183. -- ----------------------------
  1184. -- Table structure for inventario_aplica
  1185. -- ----------------------------
  1186. DROP TABLE IF EXISTS `inventario_aplica`;
  1187. CREATE TABLE `inventario_aplica`  (
  1188.   `id` int NOT NULL AUTO_INCREMENT,
  1189.   `inventario_id` int NULL DEFAULT NULL,
  1190.   `codigo` int NULL DEFAULT NULL COMMENT 'Id relacional del tipo',
  1191.   `nombre` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Nombre del Tipo (Marca, Modelo, Serie o Aeronave)',
  1192.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1193.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1194.   PRIMARY KEY (`id`) USING BTREE
  1195. ) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Tabla que contine todos los registros de aeronave_id, variante_id, modelo_id y marca_id de cada item Inventario' ROW_FORMAT = Dynamic;
  1196.  
  1197. -- ----------------------------
  1198. -- Records of inventario_aplica
  1199. -- ----------------------------
  1200. INSERT INTO `inventario_aplica` VALUES (1, 2, 3, 'modelo_id', '2024-10-22 15:09:57', NULL);
  1201. INSERT INTO `inventario_aplica` VALUES (2, 2, 11, 'marca_id', '2024-10-22 15:09:57', NULL);
  1202. INSERT INTO `inventario_aplica` VALUES (3, 3, 2, 'serie_id', '2024-10-22 15:43:56', NULL);
  1203. INSERT INTO `inventario_aplica` VALUES (4, 3, 4, 'modelo_id', '2024-10-22 15:43:56', NULL);
  1204. INSERT INTO `inventario_aplica` VALUES (5, 3, 13, 'marca_id', '2024-10-22 15:43:56', NULL);
  1205. INSERT INTO `inventario_aplica` VALUES (6, 1, 1, 'modelo_id', '2024-10-25 22:59:24', NULL);
  1206. INSERT INTO `inventario_aplica` VALUES (7, 1, 1, 'marca_id', '2024-10-25 22:59:24', NULL);
  1207. INSERT INTO `inventario_aplica` VALUES (8, 1, 3, 'serie_id', '2024-10-25 23:22:29', NULL);
  1208. INSERT INTO `inventario_aplica` VALUES (9, 1, 1, 'modelo_id', '2024-10-25 23:22:29', '2024-10-26 13:49:53');
  1209. INSERT INTO `inventario_aplica` VALUES (10, 1, 18, 'marca_id', '2024-10-25 23:22:29', NULL);
  1210. INSERT INTO `inventario_aplica` VALUES (11, 1, 1, 'marca_id', '2024-10-25 23:22:29', NULL);
  1211. INSERT INTO `inventario_aplica` VALUES (12, 1, 15, 'marca_id', '2024-10-25 23:22:29', NULL);
  1212. INSERT INTO `inventario_aplica` VALUES (13, 1, 17, 'marca_id', '2024-10-25 23:22:29', NULL);
  1213. INSERT INTO `inventario_aplica` VALUES (14, 1, 3, 'serie_id', '2024-10-26 14:24:22', NULL);
  1214. INSERT INTO `inventario_aplica` VALUES (15, 1, 4, 'serie_id', '2024-10-26 14:24:22', NULL);
  1215. INSERT INTO `inventario_aplica` VALUES (16, 1, 1, 'modelo_id', '2024-10-26 14:24:22', NULL);
  1216. INSERT INTO `inventario_aplica` VALUES (17, 1, 6, 'modelo_id', '2024-10-26 14:24:22', NULL);
  1217. INSERT INTO `inventario_aplica` VALUES (18, 1, 18, 'marca_id', '2024-10-26 14:24:22', NULL);
  1218. INSERT INTO `inventario_aplica` VALUES (19, 1, 1, 'marca_id', '2024-10-26 14:24:22', NULL);
  1219. INSERT INTO `inventario_aplica` VALUES (20, 1, 15, 'marca_id', '2024-10-26 14:24:22', NULL);
  1220. INSERT INTO `inventario_aplica` VALUES (21, 1, 17, 'marca_id', '2024-10-26 14:24:22', NULL);
  1221. INSERT INTO `inventario_aplica` VALUES (22, 1, 3, 'serie_id', '2024-10-26 14:31:16', NULL);
  1222. INSERT INTO `inventario_aplica` VALUES (23, 1, 4, 'serie_id', '2024-10-26 14:31:16', NULL);
  1223. INSERT INTO `inventario_aplica` VALUES (24, 1, 1, 'modelo_id', '2024-10-26 14:31:16', NULL);
  1224. INSERT INTO `inventario_aplica` VALUES (25, 1, 6, 'modelo_id', '2024-10-26 14:31:16', NULL);
  1225. INSERT INTO `inventario_aplica` VALUES (26, 1, 18, 'marca_id', '2024-10-26 14:31:16', NULL);
  1226. INSERT INTO `inventario_aplica` VALUES (27, 1, 1, 'marca_id', '2024-10-26 14:31:16', NULL);
  1227. INSERT INTO `inventario_aplica` VALUES (28, 1, 15, 'marca_id', '2024-10-26 14:31:16', NULL);
  1228. INSERT INTO `inventario_aplica` VALUES (29, 1, 17, 'marca_id', '2024-10-26 14:31:16', NULL);
  1229. INSERT INTO `inventario_aplica` VALUES (30, 3, 4, 'serie_id', '2024-10-26 14:39:11', NULL);
  1230. INSERT INTO `inventario_aplica` VALUES (31, 3, 1, 'modelo_id', '2024-10-26 14:39:11', NULL);
  1231. INSERT INTO `inventario_aplica` VALUES (32, 3, 6, 'modelo_id', '2024-10-26 14:39:11', NULL);
  1232. INSERT INTO `inventario_aplica` VALUES (33, 3, 1, 'marca_id', '2024-10-26 14:39:11', NULL);
  1233. INSERT INTO `inventario_aplica` VALUES (34, 3, 17, 'marca_id', '2024-10-26 14:39:11', NULL);
  1234. INSERT INTO `inventario_aplica` VALUES (35, 3, 4, 'serie_id', '2024-10-26 14:39:47', NULL);
  1235. INSERT INTO `inventario_aplica` VALUES (36, 3, 1, 'modelo_id', '2024-10-26 14:39:47', NULL);
  1236. INSERT INTO `inventario_aplica` VALUES (37, 3, 6, 'modelo_id', '2024-10-26 14:39:47', NULL);
  1237. INSERT INTO `inventario_aplica` VALUES (38, 3, 1, 'marca_id', '2024-10-26 14:39:47', NULL);
  1238. INSERT INTO `inventario_aplica` VALUES (39, 3, 17, 'marca_id', '2024-10-26 14:39:47', NULL);
  1239. INSERT INTO `inventario_aplica` VALUES (40, 1, 4, 'serie_id', '2024-10-28 10:39:47', NULL);
  1240. INSERT INTO `inventario_aplica` VALUES (41, 1, 6, 'modelo_id', '2024-10-28 10:39:47', NULL);
  1241. INSERT INTO `inventario_aplica` VALUES (42, 1, 18, 'marca_id', '2024-10-28 10:39:47', NULL);
  1242. INSERT INTO `inventario_aplica` VALUES (43, 1, 17, 'marca_id', '2024-10-28 10:39:47', NULL);
  1243. INSERT INTO `inventario_aplica` VALUES (44, 1, 3, 'serie_id', '2024-10-28 10:39:59', NULL);
  1244. INSERT INTO `inventario_aplica` VALUES (45, 1, 4, 'serie_id', '2024-10-28 10:39:59', NULL);
  1245. INSERT INTO `inventario_aplica` VALUES (46, 1, 1, 'modelo_id', '2024-10-28 10:39:59', NULL);
  1246. INSERT INTO `inventario_aplica` VALUES (47, 1, 6, 'modelo_id', '2024-10-28 10:39:59', NULL);
  1247. INSERT INTO `inventario_aplica` VALUES (48, 1, 1, 'marca_id', '2024-10-28 10:39:59', NULL);
  1248. INSERT INTO `inventario_aplica` VALUES (49, 1, 15, 'marca_id', '2024-10-28 10:39:59', NULL);
  1249. INSERT INTO `inventario_aplica` VALUES (50, 1, 17, 'marca_id', '2024-10-28 10:39:59', NULL);
  1250.  
  1251. -- ----------------------------
  1252. -- Table structure for inventario_devolucion
  1253. -- ----------------------------
  1254. DROP TABLE IF EXISTS `inventario_devolucion`;
  1255. CREATE TABLE `inventario_devolucion`  (
  1256.   `id` int NOT NULL AUTO_INCREMENT,
  1257.   `inventario_id` int NULL DEFAULT NULL,
  1258.   `ubicacion_id` int NULL DEFAULT NULL,
  1259.   `cantidad` decimal(10, 2) NULL DEFAULT 0.00,
  1260.   `motivo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  1261.   `procesado` int NULL DEFAULT 0,
  1262.   `fecha` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  1263.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1264.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1265.   PRIMARY KEY (`id`) USING BTREE,
  1266.   INDEX `fk_inventarioKadex_inventario_id`(`inventario_id` ASC) USING BTREE,
  1267.   INDEX `fk_inventarioKadex_ubicacion_id`(`ubicacion_id` ASC) USING BTREE,
  1268.   CONSTRAINT `fk_inventarioKadex_inventario_id` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1269.   CONSTRAINT `fk_inventarioKadex_ubicacion_id` FOREIGN KEY (`ubicacion_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1270. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Tabla que contiene las Devoluciones de los Articulos del Inventario.-' ROW_FORMAT = Dynamic;
  1271.  
  1272. -- ----------------------------
  1273. -- Records of inventario_devolucion
  1274. -- ----------------------------
  1275.  
  1276. -- ----------------------------
  1277. -- Table structure for inventario_documento
  1278. -- ----------------------------
  1279. DROP TABLE IF EXISTS `inventario_documento`;
  1280. CREATE TABLE `inventario_documento`  (
  1281.   `id` int NOT NULL AUTO_INCREMENT,
  1282.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  1283.   `tipo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1284.   `inventario_id` int NULL DEFAULT NULL,
  1285.   `estatus` tinyint NULL DEFAULT 1,
  1286.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1287.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1288.   PRIMARY KEY (`id`) USING BTREE,
  1289.   INDEX `fk_serial_inventario_id`(`inventario_id` ASC) USING BTREE,
  1290.   CONSTRAINT `inventario_documento_ibfk_1` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1291. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1292.  
  1293. -- ----------------------------
  1294. -- Records of inventario_documento
  1295. -- ----------------------------
  1296. INSERT INTO `inventario_documento` VALUES (1, 'IGIIGIUGIHOJPO', 'REPUESTO', 1, 1, '2024-10-22 21:29:31', NULL);
  1297.  
  1298. -- ----------------------------
  1299. -- Table structure for inventario_kardex
  1300. -- ----------------------------
  1301. DROP TABLE IF EXISTS `inventario_kardex`;
  1302. CREATE TABLE `inventario_kardex`  (
  1303.   `id` int NOT NULL AUTO_INCREMENT,
  1304.   `inventario_id` int NULL DEFAULT NULL,
  1305.   `compra_d_id` int NULL DEFAULT NULL,
  1306.   `devolucion_id` int NULL DEFAULT NULL,
  1307.   `proveedor_id` int NULL DEFAULT NULL,
  1308.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'Nombre del Artículo del Inventario',
  1309.   `fecha` date NULL DEFAULT NULL,
  1310.   `tipo` enum('C','S','A','D','M','I') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'C = Compra, S = Salida, A = Ajuste, D = Devolución, M = Malo o Dañado, I = Inactivo',
  1311.   `cantidad` decimal(10, 2) NULL DEFAULT 0.00,
  1312.   `saldo_inicial` decimal(10, 2) NULL DEFAULT 0.00,
  1313.   `saldo_anterior` decimal(10, 2) NULL DEFAULT 0.00,
  1314.   `saldo_actual` decimal(10, 2) NULL DEFAULT 0.00,
  1315.   `precio_anterior` decimal(10, 2) NULL DEFAULT 0.00,
  1316.   `precio_costo` decimal(10, 2) NULL DEFAULT 0.00,
  1317.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1318.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1319.   PRIMARY KEY (`id`) USING BTREE,
  1320.   INDEX `fk_inventarioKardex_inventario_id`(`inventario_id` ASC) USING BTREE,
  1321.   INDEX `fk_inventarioKardex_compraD_id`(`compra_d_id` ASC) USING BTREE,
  1322.   INDEX `fk_inventarioKardex_devolucion_id`(`devolucion_id` ASC) USING BTREE,
  1323.   INDEX `fk_inventarioKardex_proveedor_id`(`proveedor_id` ASC) USING BTREE,
  1324.   CONSTRAINT `fk_inventarioKardex_compraD_id` FOREIGN KEY (`compra_d_id`) REFERENCES `compra_d` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1325.   CONSTRAINT `fk_inventarioKardex_devolucion_id` FOREIGN KEY (`devolucion_id`) REFERENCES `inventario_devolucion` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1326.   CONSTRAINT `fk_inventarioKardex_inventario_id` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1327.   CONSTRAINT `fk_inventarioKardex_proveedor_id` FOREIGN KEY (`proveedor_id`) REFERENCES `cliente` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1328. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Tabla que contiene el Kardex de los Artículos del Inventario.-' ROW_FORMAT = Dynamic;
  1329.  
  1330. -- ----------------------------
  1331. -- Records of inventario_kardex
  1332. -- ----------------------------
  1333.  
  1334. -- ----------------------------
  1335. -- Table structure for inventario_nombre
  1336. -- ----------------------------
  1337. DROP TABLE IF EXISTS `inventario_nombre`;
  1338. CREATE TABLE `inventario_nombre`  (
  1339.   `id` int NOT NULL AUTO_INCREMENT,
  1340.   `inventario_id` int NULL DEFAULT NULL,
  1341.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1342.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1343.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1344.   PRIMARY KEY (`id`) USING BTREE,
  1345.   INDEX `inventario_id`(`inventario_id` ASC) USING BTREE,
  1346.   CONSTRAINT `inventario_nombre_ibfk_1` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
  1347. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1348.  
  1349. -- ----------------------------
  1350. -- Records of inventario_nombre
  1351. -- ----------------------------
  1352. INSERT INTO `inventario_nombre` VALUES (3, 3, 'PRUEBA', '2024-10-26 17:19:28', '2024-10-26 17:47:55');
  1353.  
  1354. -- ----------------------------
  1355. -- Table structure for inventario_requisicion
  1356. -- ----------------------------
  1357. DROP TABLE IF EXISTS `inventario_requisicion`;
  1358. CREATE TABLE `inventario_requisicion`  (
  1359.   `id` int NOT NULL,
  1360.   `inventario_id` int NULL DEFAULT NULL,
  1361.   `unidad_id` int NULL DEFAULT NULL,
  1362.   `numero` int NULL DEFAULT NULL,
  1363.   `fecha` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1364.   `cantidad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1365.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1366.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1367.   PRIMARY KEY (`id`) USING BTREE,
  1368.   INDEX `fk_requisicion_inventario_id`(`inventario_id` ASC) USING BTREE,
  1369.   INDEX `fk_requisicion_unidad_id`(`unidad_id` ASC) USING BTREE,
  1370.   CONSTRAINT `fk_requisicion_inventario_id` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1371.   CONSTRAINT `fk_requisicion_unidad_id` FOREIGN KEY (`unidad_id`) REFERENCES `unidad` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1372. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1373.  
  1374. -- ----------------------------
  1375. -- Records of inventario_requisicion
  1376. -- ----------------------------
  1377.  
  1378. -- ----------------------------
  1379. -- Table structure for inventario_salida
  1380. -- ----------------------------
  1381. DROP TABLE IF EXISTS `inventario_salida`;
  1382. CREATE TABLE `inventario_salida`  (
  1383.   `id` int NOT NULL AUTO_INCREMENT,
  1384.   `responsable_id` int NULL DEFAULT NULL,
  1385.   `i_tipo_id` int NULL DEFAULT NULL,
  1386.   `i_categoria_id` int NULL DEFAULT NULL,
  1387.   `inventario_id` int NULL DEFAULT NULL,
  1388.   `origen_id` int NULL DEFAULT NULL,
  1389.   `cantidad` decimal(10, 2) NULL DEFAULT NULL,
  1390.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  1391.   `destino` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  1392.   `fecha` datetime NULL DEFAULT NULL,
  1393.   `procesado` int NULL DEFAULT NULL,
  1394.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1395.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1396.   PRIMARY KEY (`id`) USING BTREE
  1397. ) ENGINE = InnoDB AUTO_INCREMENT = 943 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Tabla que contiene los Titulos de las Salidas de los Artículos del Inventario.-' ROW_FORMAT = DYNAMIC;
  1398.  
  1399. -- ----------------------------
  1400. -- Records of inventario_salida
  1401. -- ----------------------------
  1402.  
  1403. -- ----------------------------
  1404. -- Table structure for inventario_traslado_d
  1405. -- ----------------------------
  1406. DROP TABLE IF EXISTS `inventario_traslado_d`;
  1407. CREATE TABLE `inventario_traslado_d`  (
  1408.   `id` int NOT NULL AUTO_INCREMENT,
  1409.   `inventario_traslado_t_id` int NULL DEFAULT NULL,
  1410.   `inventario_id` int NULL DEFAULT NULL,
  1411.   `origen_id` int NULL DEFAULT NULL,
  1412.   `destino_id` int NULL DEFAULT NULL,
  1413.   `cantidad` decimal(10, 2) NULL DEFAULT 0.00,
  1414.   `procesado` int NULL DEFAULT 0,
  1415.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1416.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1417.   PRIMARY KEY (`id`) USING BTREE,
  1418.   INDEX `fk_invenTraslaD_invenTraslaT_id`(`inventario_traslado_t_id` ASC) USING BTREE,
  1419.   INDEX `fk_invenTraslaD_inventario_id`(`inventario_id` ASC) USING BTREE,
  1420.   INDEX `fk_invenTraslaD_origen_id`(`origen_id` ASC) USING BTREE,
  1421.   INDEX `fk_invenTraslaD_destino_id`(`destino_id` ASC) USING BTREE,
  1422.   CONSTRAINT `fk_invenTraslaD_destino_id` FOREIGN KEY (`destino_id`) REFERENCES `ubicacion` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1423.   CONSTRAINT `fk_invenTraslaD_inventario_id` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1424.   CONSTRAINT `fk_invenTraslaD_invenTraslaT_id` FOREIGN KEY (`inventario_traslado_t_id`) REFERENCES `inventario_traslado_t` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1425.   CONSTRAINT `fk_invenTraslaD_origen_id` FOREIGN KEY (`origen_id`) REFERENCES `ubicacion` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1426. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Tabla que contiene los Detalles de las Traslados entre Almacenes y Ubicación de los Artículos del Inventario.-' ROW_FORMAT = Dynamic;
  1427.  
  1428. -- ----------------------------
  1429. -- Records of inventario_traslado_d
  1430. -- ----------------------------
  1431.  
  1432. -- ----------------------------
  1433. -- Table structure for inventario_traslado_t
  1434. -- ----------------------------
  1435. DROP TABLE IF EXISTS `inventario_traslado_t`;
  1436. CREATE TABLE `inventario_traslado_t`  (
  1437.   `id` int NOT NULL AUTO_INCREMENT,
  1438.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  1439.   `usuario_id` int NULL DEFAULT NULL,
  1440.   `procesado` int NULL DEFAULT 0,
  1441.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1442.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1443.   PRIMARY KEY (`id`) USING BTREE,
  1444.   INDEX `fk_invenTraslaT_usuario_id`(`usuario_id` ASC) USING BTREE,
  1445.   CONSTRAINT `fk_invenTraslaT_usuario_id` FOREIGN KEY (`usuario_id`) REFERENCES `usuario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1446. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Tabla que contiene los Titulos de las Traslados entre Almacenes y Ubicación de los Artículos del Inventario.-' ROW_FORMAT = Dynamic;
  1447.  
  1448. -- ----------------------------
  1449. -- Records of inventario_traslado_t
  1450. -- ----------------------------
  1451.  
  1452. -- ----------------------------
  1453. -- Table structure for inventario_ubicacion
  1454. -- ----------------------------
  1455. DROP TABLE IF EXISTS `inventario_ubicacion`;
  1456. CREATE TABLE `inventario_ubicacion`  (
  1457.   `id` int NOT NULL AUTO_INCREMENT,
  1458.   `ubicacion_id` int NULL DEFAULT NULL,
  1459.   `inventario_id` int NULL DEFAULT NULL,
  1460.   `proveedor_id` int NULL DEFAULT NULL COMMENT 'Ultimo proveedor',
  1461.   `unidad_id` int NULL DEFAULT NULL,
  1462.   `existencia` int NULL DEFAULT 0,
  1463.   `ruta_completa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  1464.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1465.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1466.   PRIMARY KEY (`id`) USING BTREE,
  1467.   UNIQUE INDEX `uk_inventario_ubicacion`(`inventario_id` ASC, `ubicacion_id` ASC) USING BTREE,
  1468.   INDEX `fk_inventarioUbicacion_ubicacion_id`(`ubicacion_id` ASC) USING BTREE,
  1469.   INDEX `fk_inventarioUbicacion_proveedor_id`(`proveedor_id` ASC) USING BTREE,
  1470.   INDEX `fk_inventarioUbicacion_unidad_id`(`unidad_id` ASC) USING BTREE,
  1471.   CONSTRAINT `fk_inventarioUbicacion_inventario_id` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1472.   CONSTRAINT `fk_inventarioUbicacion_proveedor_id` FOREIGN KEY (`proveedor_id`) REFERENCES `proveedor` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1473.   CONSTRAINT `fk_inventarioUbicacion_ubicacion_id` FOREIGN KEY (`ubicacion_id`) REFERENCES `ubicacion` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1474.   CONSTRAINT `fk_inventarioUbicacion_unidad_id` FOREIGN KEY (`unidad_id`) REFERENCES `unidad` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1475. ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Tabla de relacion entre las ubicaciones o almacenes y el Inventario del sistema' ROW_FORMAT = Dynamic;
  1476.  
  1477. -- ----------------------------
  1478. -- Records of inventario_ubicacion
  1479. -- ----------------------------
  1480. INSERT INTO `inventario_ubicacion` VALUES (1, 8, 1, NULL, NULL, 10, 'PRINCIPAL -> E1 -> P004 -> C001', '2024-10-22 11:41:44', '2024-10-22 21:30:25');
  1481. INSERT INTO `inventario_ubicacion` VALUES (2, 16, 1, NULL, NULL, 5, 'PRINCIPAL -> E1 -> P004 -> C009', '2024-10-22 11:42:18', NULL);
  1482.  
  1483. -- ----------------------------
  1484. -- Table structure for marca
  1485. -- ----------------------------
  1486. DROP TABLE IF EXISTS `marca`;
  1487. CREATE TABLE `marca`  (
  1488.   `id` int NOT NULL AUTO_INCREMENT,
  1489.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  1490.   `tipo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1491.   `ala` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1492.   `estatus` tinyint NULL DEFAULT 1,
  1493.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1494.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1495.   PRIMARY KEY (`id`) USING BTREE
  1496. ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1497.  
  1498. -- ----------------------------
  1499. -- Records of marca
  1500. -- ----------------------------
  1501. INSERT INTO `marca` VALUES (1, 'BELL', 'REPUESTO', NULL, 1, '2024-10-22 11:32:09', NULL);
  1502. INSERT INTO `marca` VALUES (2, 'AIRBUS HELICOPTERS', NULL, NULL, 1, '2024-10-22 11:47:43', NULL);
  1503. INSERT INTO `marca` VALUES (3, 'AIRBUS HELICOPTERS', NULL, NULL, 1, '2024-10-22 11:47:44', NULL);
  1504. INSERT INTO `marca` VALUES (4, 'AIRBUS HELICOPTERS', NULL, NULL, 1, '2024-10-22 11:47:52', NULL);
  1505. INSERT INTO `marca` VALUES (5, 'AIRBUS HELICOPTERS', NULL, NULL, 1, '2024-10-22 11:47:54', NULL);
  1506. INSERT INTO `marca` VALUES (6, 'AIRBUS HELICOPTERS', NULL, NULL, 1, '2024-10-22 11:47:55', NULL);
  1507. INSERT INTO `marca` VALUES (7, 'AIRBUS HELICOPTERS', NULL, NULL, 1, '2024-10-22 11:47:57', NULL);
  1508. INSERT INTO `marca` VALUES (8, 'AIRBUS HELICOPTERS', NULL, NULL, 1, '2024-10-22 11:48:00', NULL);
  1509. INSERT INTO `marca` VALUES (9, 'AIRBUS HELICOPTERS', NULL, NULL, 1, '2024-10-22 11:48:00', NULL);
  1510. INSERT INTO `marca` VALUES (10, 'AIRBUS HELICOPTERS', NULL, NULL, 1, '2024-10-22 11:53:36', NULL);
  1511. INSERT INTO `marca` VALUES (11, 'NUEVA MARCA', NULL, NULL, 1, '2024-10-22 15:08:39', NULL);
  1512. INSERT INTO `marca` VALUES (12, 'NUEVA MARCA2', NULL, NULL, 1, '2024-10-22 15:18:48', NULL);
  1513. INSERT INTO `marca` VALUES (13, 'NUEVA MARCA', NULL, NULL, 1, '2024-10-22 15:42:18', NULL);
  1514. INSERT INTO `marca` VALUES (15, 'NUEVO123', 'REPUESTO', NULL, 1, '2024-10-22 22:19:39', NULL);
  1515. INSERT INTO `marca` VALUES (17, 'OTRA MAS', 'REPUESTO', NULL, 1, '2024-10-22 22:33:18', NULL);
  1516.  
  1517. -- ----------------------------
  1518. -- Table structure for menu
  1519. -- ----------------------------
  1520. DROP TABLE IF EXISTS `menu`;
  1521. CREATE TABLE `menu`  (
  1522.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'Identificador del menú',
  1523.   `menu_id` int NULL DEFAULT NULL COMMENT 'Identificador del menú padre',
  1524.   `recurso_id` int NULL DEFAULT NULL COMMENT 'Identificador del recurso',
  1525.   `menu` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Texto a mostrar del menú',
  1526.   `url` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Url del menú',
  1527.   `posicion` int NULL DEFAULT 0 COMMENT 'Posisión dentro de otros items',
  1528.   `icono` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Icono a mostrar ',
  1529.   `activo` int NOT NULL DEFAULT 1 COMMENT 'Menú activo o inactivo',
  1530.   `visibilidad` int NOT NULL DEFAULT 1 COMMENT 'Indica si el menú se muestra en el backend o en el frontend',
  1531.   `custom` int NULL DEFAULT 1,
  1532.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1533.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1534.   PRIMARY KEY (`id`) USING BTREE,
  1535.   INDEX `fk_menu_recurso_idx`(`recurso_id` ASC) USING BTREE,
  1536.   INDEX `fk_menu_menu_idx`(`menu_id` ASC) USING BTREE,
  1537.   CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  1538.   CONSTRAINT `menu_ibfk_2` FOREIGN KEY (`recurso_id`) REFERENCES `recurso` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
  1539. ) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'Tabla que contiene los menú para los usuarios' ROW_FORMAT = Dynamic;
  1540.  
  1541. -- ----------------------------
  1542. -- Records of menu
  1543. -- ----------------------------
  1544. INSERT INTO `menu` VALUES (1, NULL, NULL, 'Dashboard', 'dashboard/', 10, 'fa-home', 1, 1, NULL, '2024-10-21 22:46:54', NULL);
  1545. INSERT INTO `menu` VALUES (2, 1, 2, 'Dashboard', 'dashboard/', 11, 'fa-home', 0, 1, NULL, '2024-10-21 22:46:54', NULL);
  1546. INSERT INTO `menu` VALUES (3, NULL, NULL, 'Sistema', '#', 900, 'fa-cogs', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1547. INSERT INTO `menu` VALUES (4, 3, 4, 'Accesos', 'sistema/accesos/listar/', 901, 'fa-exchange', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1548. INSERT INTO `menu` VALUES (5, 3, 5, 'Auditorias', 'sistema/auditorias/', 902, 'fa-eye', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1549. INSERT INTO `menu` VALUES (8, 3, 8, 'Menus', 'sistema/menus/listar/', 903, 'fa-list', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1550. INSERT INTO `menu` VALUES (9, 3, 9, 'Perfiles', 'sistema/perfiles/listar/', 904, 'fa-group', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1551. INSERT INTO `menu` VALUES (10, 3, 10, 'Permisos', 'sistema/permisos/listar/', 905, 'fa-magic', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1552. INSERT INTO `menu` VALUES (11, 3, 11, 'Recursos', 'sistema/recursos/listar/', 906, 'fa-lock', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1553. INSERT INTO `menu` VALUES (12, 3, 12, 'Usuarios', 'sistema/usuarios/listar/', 907, 'fa-user', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1554. INSERT INTO `menu` VALUES (13, 3, 13, 'Visualizador de Eventos', 'sistema/sucesos/listar/', 908, 'fa-filter', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1555. INSERT INTO `menu` VALUES (14, 3, 14, 'Configuración del Sistema', 'sistema/configuracion/', 999, 'fa-wrench', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1556. INSERT INTO `menu` VALUES (46, NULL, NULL, 'Parametros', '#', 100, 'fa-list-ol', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1557. INSERT INTO `menu` VALUES (47, 46, NULL, 'Inventario', '#', 101, 'fa-list', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1558. INSERT INTO `menu` VALUES (48, 47, 38, 'Marcas de Aeronaves', 'inventario/marcas/listar/AERONAVE/', 102, 'fa-plane', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1559. INSERT INTO `menu` VALUES (49, 47, 42, 'Marcas de Repuestos', 'inventario/marcas/listar/REPUESTO/', 103, 'fa-tachometer', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1560. INSERT INTO `menu` VALUES (50, 47, 43, 'Marcas de Consumibles', 'inventario/marcas/listar/CONSUMIBLE/', 104, 'fa-barcode', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1561. INSERT INTO `menu` VALUES (51, 47, 44, 'Marcas de Insumos', 'inventario/marcas/listar/INSUMO/', 105, 'fa-shopping-cart', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1562. INSERT INTO `menu` VALUES (52, 46, NULL, 'Administración', '#', 110, 'fa-dollar', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1563. INSERT INTO `menu` VALUES (53, 52, 41, 'Clientes', 'inventario/clientes/listar/', 111, 'fa-user', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1564. INSERT INTO `menu` VALUES (54, 47, 46, 'Condiciones de Artículos', 'inventario/condiciones/listar/', 106, 'fa-edit', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1565. INSERT INTO `menu` VALUES (55, 47, 45, 'Unidades', 'inventario/unidades/listar/', 107, 'fa-gears', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1566. INSERT INTO `menu` VALUES (56, NULL, NULL, 'Inventario', '#', 200, 'fa-qrcode', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1567. INSERT INTO `menu` VALUES (57, 47, 36, 'Almacenes', 'inventario/almacenes/listar/', 108, 'fa-qrcode', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1568. INSERT INTO `menu` VALUES (58, 56, 47, 'Artículos', 'inventario/inventarios/listar/', 201, 'fa-sitemap', 1, 1, 0, '2024-10-21 22:46:54', NULL);
  1569. INSERT INTO `menu` VALUES (59, 56, 48, 'Ajuste de Artículos', 'inventario/inventario_ajuste_ts/listar/', 202, 'fa-clipboard', 1, 1, 0, '2024-10-27 12:13:05', NULL);
  1570. INSERT INTO `menu` VALUES (60, 56, 49, 'Traslado de Artículos', 'inventario/inventario_traslado_ts/listar/', 203, 'fa-repeat', 1, 1, 0, '2024-10-29 18:33:45', NULL);
  1571.  
  1572. -- ----------------------------
  1573. -- Table structure for modelo
  1574. -- ----------------------------
  1575. DROP TABLE IF EXISTS `modelo`;
  1576. CREATE TABLE `modelo`  (
  1577.   `id` int NOT NULL AUTO_INCREMENT,
  1578.   `marca_id` int NULL DEFAULT NULL,
  1579.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  1580.   `ala` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1581.   `estatus` tinyint NULL DEFAULT 1,
  1582.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1583.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1584.   PRIMARY KEY (`id`) USING BTREE,
  1585.   INDEX `fk_modelo_marca_id`(`marca_id` ASC) USING BTREE,
  1586.   CONSTRAINT `fk_modelo_marca_id` FOREIGN KEY (`marca_id`) REFERENCES `marca` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1587. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1588.  
  1589. -- ----------------------------
  1590. -- Records of modelo
  1591. -- ----------------------------
  1592. INSERT INTO `modelo` VALUES (1, 1, '206B', NULL, 1, '2024-10-22 11:33:11', NULL);
  1593. INSERT INTO `modelo` VALUES (2, 10, 'EC130', NULL, 1, '2024-10-22 11:53:52', NULL);
  1594. INSERT INTO `modelo` VALUES (3, 11, 'NUEVO MODELO', NULL, 1, '2024-10-22 15:09:29', NULL);
  1595. INSERT INTO `modelo` VALUES (4, 13, 'NUEVO MODELO', NULL, 1, '2024-10-22 15:42:33', NULL);
  1596. INSERT INTO `modelo` VALUES (5, 15, 'NUEVO MODELO2', NULL, 1, '2024-10-26 13:50:32', NULL);
  1597. INSERT INTO `modelo` VALUES (6, 17, 'NUEVO MODELO-OTRO MAS', NULL, 1, '2024-10-26 14:23:20', NULL);
  1598.  
  1599. -- ----------------------------
  1600. -- Table structure for num_parte
  1601. -- ----------------------------
  1602. DROP TABLE IF EXISTS `num_parte`;
  1603. CREATE TABLE `num_parte`  (
  1604.   `id` int NOT NULL AUTO_INCREMENT,
  1605.   `marca_id` int NULL DEFAULT NULL,
  1606.   `inventario_id` int NULL DEFAULT NULL,
  1607.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  1608.   `tipo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1609.   `estatus` tinyint NULL DEFAULT 1,
  1610.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1611.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1612.   PRIMARY KEY (`id`) USING BTREE,
  1613.   INDEX `fk_numParte_marca_id`(`marca_id` ASC) USING BTREE,
  1614.   INDEX `fk_numParte_inventario_id`(`inventario_id` ASC) USING BTREE,
  1615.   CONSTRAINT `fk_numParte_inventario_id` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1616.   CONSTRAINT `fk_numParte_marca_id` FOREIGN KEY (`marca_id`) REFERENCES `marca` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1617. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1618.  
  1619. -- ----------------------------
  1620. -- Records of num_parte
  1621. -- ----------------------------
  1622. INSERT INTO `num_parte` VALUES (1, 1, 1, '999666555-1', 'REPUESTO', 1, '2024-10-22 21:28:37', NULL);
  1623.  
  1624. -- ----------------------------
  1625. -- Table structure for perfil
  1626. -- ----------------------------
  1627. DROP TABLE IF EXISTS `perfil`;
  1628. CREATE TABLE `perfil`  (
  1629.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'Identificador del perfil',
  1630.   `perfil` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Nombre del perfil',
  1631.   `estado` int NOT NULL DEFAULT 1 COMMENT 'Indica si el perfil esta activo o inactivo',
  1632.   `plantilla` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'default' COMMENT 'Plantilla para usar en el sitema',
  1633.   `perfil_at` datetime NULL DEFAULT NULL COMMENT 'Fecha de registro del perfil',
  1634.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1635.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1636.   PRIMARY KEY (`id`) USING BTREE
  1637. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'Tabla que contiene los grupos de los usuarios' ROW_FORMAT = Dynamic;
  1638.  
  1639. -- ----------------------------
  1640. -- Records of perfil
  1641. -- ----------------------------
  1642. INSERT INTO `perfil` VALUES (1, 'Super Usuario', 1, 'template', '2014-01-01 00:00:01', '2024-10-21 22:47:43', NULL);
  1643. INSERT INTO `perfil` VALUES (2, 'Administrador', 1, 'template', '2021-01-26 23:06:06', '2024-10-21 22:47:43', NULL);
  1644. INSERT INTO `perfil` VALUES (3, 'AppAdmin', 1, 'template', '2021-02-01 15:34:52', '2024-10-21 22:47:43', NULL);
  1645. INSERT INTO `perfil` VALUES (5, 'Usuario', 1, 'template', '2022-03-31 13:23:42', '2024-10-21 22:47:43', NULL);
  1646.  
  1647. -- ----------------------------
  1648. -- Table structure for proveedor
  1649. -- ----------------------------
  1650. DROP TABLE IF EXISTS `proveedor`;
  1651. CREATE TABLE `proveedor`  (
  1652.   `id` int NOT NULL AUTO_INCREMENT,
  1653.   `nombre` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1654.   `rif` varchar(14) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1655.   `direccion_ofic` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1656.   `ref_direccion_ofic` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1657.   `direccion_desp` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1658.   `ref_direccion_desp` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1659.   `telf1` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1660.   `telf2` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1661.   `telf3` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1662.   `credito` decimal(20, 2) NULL DEFAULT NULL,
  1663.   `url` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1664.   `email1` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1665.   `email2` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1666.   `email3` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1667.   `coordenadas` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  1668.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1669.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1670.   PRIMARY KEY (`id`) USING BTREE
  1671. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = 'Tabla que contiene los Proveedores del sistema' ROW_FORMAT = Dynamic;
  1672.  
  1673. -- ----------------------------
  1674. -- Records of proveedor
  1675. -- ----------------------------
  1676.  
  1677. -- ----------------------------
  1678. -- Table structure for recurso
  1679. -- ----------------------------
  1680. DROP TABLE IF EXISTS `recurso`;
  1681. CREATE TABLE `recurso`  (
  1682.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'Identificador del recurso',
  1683.   `modulo` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Nombre del módulo',
  1684.   `controlador` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Nombre del controlador',
  1685.   `accion` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Nombre de la acción',
  1686.   `recurso` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Nombre del recurso',
  1687.   `descripcion` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Descripción del recurso',
  1688.   `activo` int NOT NULL DEFAULT 1 COMMENT 'Estado del recurso',
  1689.   `custom` int NULL DEFAULT 1,
  1690.   `recurso_at` datetime NULL DEFAULT NULL COMMENT 'Fecha de registro',
  1691.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1692.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1693.   PRIMARY KEY (`id`) USING BTREE
  1694. ) ENGINE = InnoDB AUTO_INCREMENT = 50 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'Tabla que contiene los recursos a los que acceden los usuarios' ROW_FORMAT = Dynamic;
  1695.  
  1696. -- ----------------------------
  1697. -- Records of recurso
  1698. -- ----------------------------
  1699. INSERT INTO `recurso` VALUES (1, '*', 'NULL', 'NULL', '*', 'Comodín para la administración total (usar con cuidado)', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1700. INSERT INTO `recurso` VALUES (2, 'dashboard', '*', '*', 'dashboard/*/*', 'Página principal del sistema', 1, 0, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1701. INSERT INTO `recurso` VALUES (3, 'sistema', 'mi_cuenta', '*', 'sistema/mi_cuenta/*', 'Gestión de la cuenta del usuario logueado', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1702. INSERT INTO `recurso` VALUES (4, 'sistema', 'accesos', '*', 'sistema/accesos/*', 'Submódulo para la gestión de ingresos al sistema', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1703. INSERT INTO `recurso` VALUES (5, 'sistema', 'auditorias', '*', 'sistema/auditorias/*', 'Submódulo para el control de las acciones de los usuarios', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1704. INSERT INTO `recurso` VALUES (6, 'sistema', 'backups', '*', 'sistema/backups/*', 'Submódulo para la gestión de las copias de seguridad', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1705. INSERT INTO `recurso` VALUES (7, 'sistema', 'mantenimiento', '*', 'sistema/mantenimiento/*', 'Submódulo para el mantenimiento de las tablas', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1706. INSERT INTO `recurso` VALUES (8, 'sistema', 'menus', '*', 'sistema/menus/*', 'Submódulo del sistema para la creación de menús', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1707. INSERT INTO `recurso` VALUES (9, 'sistema', 'perfiles', '*', 'sistema/perfiles/*', 'Submódulo del sistema para los perfiles de usuarios', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1708. INSERT INTO `recurso` VALUES (10, 'sistema', 'permisos', '*', 'sistema/permisos/*', 'Submódulo del sistema para asignar recursos a los perfiles', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1709. INSERT INTO `recurso` VALUES (11, 'sistema', 'recursos', '*', 'sistema/recursos/*', 'Submódulo del sistema para la gestión de los recursos', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1710. INSERT INTO `recurso` VALUES (12, 'sistema', 'usuarios', '*', 'sistema/usuarios/*', 'Submódulo para la administración de los usuarios del sistema', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1711. INSERT INTO `recurso` VALUES (13, 'sistema', 'sucesos', '*', 'sistema/sucesos/*', 'Submódulo para el listado de los logs del sistema', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1712. INSERT INTO `recurso` VALUES (14, 'sistema', 'configuracion', '*', 'sistema/configuracion/*', 'Submódulo para la configuración de la aplicación (.ini)', 1, NULL, '2014-01-01 00:00:01', '2024-10-21 22:48:23', NULL);
  1713. INSERT INTO `recurso` VALUES (36, 'inventario', 'almacenes', 'listar/*', 'inventario/almacenes/listar/*', 'Identificación de los Diferentes Almacenes de Articulos usados por el Sistema.', 1, 0, '2024-09-10 06:31:48', '2024-10-21 22:48:23', NULL);
  1714. INSERT INTO `recurso` VALUES (38, 'inventario', 'marcas', 'listar/AERONAVE/*', 'inventario/marcas/listar/AERONAVE/*', 'Gestión para la identificación de Marcas para Aeronaves del Sistema.-.', 1, 0, '2024-09-10 06:35:31', '2024-10-21 22:48:23', NULL);
  1715. INSERT INTO `recurso` VALUES (41, 'inventario', 'clientes', 'listar/*', 'inventario/clientes/listar/*', 'Gestión de Clientes.-', 1, 0, '2024-09-26 19:55:09', '2024-10-21 22:48:23', NULL);
  1716. INSERT INTO `recurso` VALUES (42, 'inventario', 'marcas', 'listar/REPUESTO/*', 'inventario/marcas/listar/REPUESTO/*', 'Gestión para la identificación de Marcas para los Repuestos del Sistema.-', 1, 0, '2024-09-26 21:34:26', '2024-10-21 22:48:23', NULL);
  1717. INSERT INTO `recurso` VALUES (43, 'inventario', 'marcas', 'listar/CONSUMIBLE/*', 'inventario/marcas/listar/CONSUMIBLE/*', 'Gestion para la identificación de Marcas para los Consumibles del Sistema.-', 1, 0, '2024-09-26 21:36:43', '2024-10-21 22:48:23', NULL);
  1718. INSERT INTO `recurso` VALUES (44, 'inventario', 'marcas', 'listar/INSUMO/*', 'inventario/marcas/listar/INSUMO/*', 'Gestión para la identificación de Marcas para los Insumos del Sistema.-', 1, 0, '2024-09-26 21:38:22', '2024-10-21 22:48:23', NULL);
  1719. INSERT INTO `recurso` VALUES (45, 'inventario', 'unidades', 'listar/*', 'inventario/unidades/listar/*', 'Gestión de Unidades de medidas para los Artículos del Sitema.-', 1, 0, '2024-09-26 22:24:46', '2024-10-21 22:48:23', NULL);
  1720. INSERT INTO `recurso` VALUES (46, 'inventario', 'condiciones', 'listar/*', 'inventario/condiciones/listar/*', 'Gestión de Condiciones para los Artículos del Sistema.-', 1, 0, '2024-09-26 22:25:57', '2024-10-21 22:48:23', NULL);
  1721. INSERT INTO `recurso` VALUES (47, 'inventario', 'inventarios', 'listar/*', 'inventario/inventarios/listar/*', 'Gestión de Articulos para el Inventario del Sistema.-', 1, 0, '2024-09-26 22:36:24', '2024-10-21 22:48:23', NULL);
  1722. INSERT INTO `recurso` VALUES (48, 'inventario', 'inventario_ajuste_ts', 'listar/*', 'inventario/inventario_ajuste_ts/listar/*', 'Gestión de Ajustes para los Artículos Registedo en Sistema.-', 1, 0, '2024-10-27 12:11:34', '2024-10-27 12:11:34', '2024-10-27 12:11:50');
  1723. INSERT INTO `recurso` VALUES (49, 'inventario', 'inventario_traslado_ts', 'listar/*', 'inventario/inventario_traslado_ts/listar/*', 'Gestión de los Traslados de Articulos entre los Alamcenes y Ubicaciones en el Sistema.-', 1, 0, '2024-10-29 18:30:47', '2024-10-29 18:30:47', NULL);
  1724.  
  1725. -- ----------------------------
  1726. -- Table structure for recurso_perfil
  1727. -- ----------------------------
  1728. DROP TABLE IF EXISTS `recurso_perfil`;
  1729. CREATE TABLE `recurso_perfil`  (
  1730.   `id` int NOT NULL AUTO_INCREMENT,
  1731.   `recurso_id` int NOT NULL,
  1732.   `perfil_id` int NOT NULL,
  1733.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1734.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1735.   PRIMARY KEY (`id`) USING BTREE,
  1736.   INDEX `fk_recurso_perfil_recurso_id`(`recurso_id` ASC) USING BTREE,
  1737.   INDEX `fk_recurso_perfil_perfil_id`(`perfil_id` ASC) USING BTREE,
  1738.   CONSTRAINT `fk_recurso_perfil_perfil_id` FOREIGN KEY (`perfil_id`) REFERENCES `perfil` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1739.   CONSTRAINT `fk_recurso_perfil_recurso_id` FOREIGN KEY (`recurso_id`) REFERENCES `recurso` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  1740. ) ENGINE = InnoDB AUTO_INCREMENT = 532 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'Tabla que contiene los recursos del usuario en el sistema segun su perfl' ROW_FORMAT = Dynamic;
  1741.  
  1742. -- ----------------------------
  1743. -- Records of recurso_perfil
  1744. -- ----------------------------
  1745. INSERT INTO `recurso_perfil` VALUES (1, 1, 1, '2024-10-21 22:48:41', NULL);
  1746. INSERT INTO `recurso_perfil` VALUES (2, 2, 2, '2024-10-21 22:48:41', NULL);
  1747. INSERT INTO `recurso_perfil` VALUES (3, 2, 3, '2024-10-21 22:48:41', NULL);
  1748. INSERT INTO `recurso_perfil` VALUES (4, 3, 3, '2024-10-21 22:48:41', NULL);
  1749. INSERT INTO `recurso_perfil` VALUES (5, 3, 2, '2024-10-21 22:48:41', NULL);
  1750. INSERT INTO `recurso_perfil` VALUES (8, 2, 5, '2024-10-21 22:48:41', NULL);
  1751. INSERT INTO `recurso_perfil` VALUES (9, 3, 5, '2024-10-21 22:48:41', NULL);
  1752. INSERT INTO `recurso_perfil` VALUES (12, 2, 7, '2024-10-21 22:48:41', NULL);
  1753. INSERT INTO `recurso_perfil` VALUES (13, 3, 7, '2024-10-21 22:48:41', NULL);
  1754. INSERT INTO `recurso_perfil` VALUES (14, 2, 8, '2024-10-21 22:48:41', NULL);
  1755. INSERT INTO `recurso_perfil` VALUES (15, 3, 8, '2024-10-21 22:48:41', NULL);
  1756. INSERT INTO `recurso_perfil` VALUES (16, 2, 9, '2024-10-21 22:48:41', NULL);
  1757. INSERT INTO `recurso_perfil` VALUES (17, 3, 9, '2024-10-21 22:48:41', NULL);
  1758. INSERT INTO `recurso_perfil` VALUES (18, 2, 10, '2024-10-21 22:48:41', NULL);
  1759. INSERT INTO `recurso_perfil` VALUES (19, 3, 10, '2024-10-21 22:48:41', NULL);
  1760. INSERT INTO `recurso_perfil` VALUES (20, 2, 11, '2024-10-21 22:48:41', NULL);
  1761. INSERT INTO `recurso_perfil` VALUES (21, 3, 11, '2024-10-21 22:48:41', NULL);
  1762. INSERT INTO `recurso_perfil` VALUES (116, 15, 2, '2024-10-21 22:48:41', NULL);
  1763. INSERT INTO `recurso_perfil` VALUES (117, 15, 3, '2024-10-21 22:48:41', NULL);
  1764. INSERT INTO `recurso_perfil` VALUES (118, 16, 2, '2024-10-21 22:48:41', NULL);
  1765. INSERT INTO `recurso_perfil` VALUES (119, 17, 2, '2024-10-21 22:48:41', NULL);
  1766. INSERT INTO `recurso_perfil` VALUES (120, 18, 2, '2024-10-21 22:48:41', NULL);
  1767. INSERT INTO `recurso_perfil` VALUES (121, 19, 2, '2024-10-21 22:48:41', NULL);
  1768. INSERT INTO `recurso_perfil` VALUES (122, 20, 2, '2024-10-21 22:48:41', NULL);
  1769. INSERT INTO `recurso_perfil` VALUES (123, 21, 2, '2024-10-21 22:48:41', NULL);
  1770. INSERT INTO `recurso_perfil` VALUES (124, 22, 2, '2024-10-21 22:48:41', NULL);
  1771. INSERT INTO `recurso_perfil` VALUES (125, 23, 2, '2024-10-21 22:48:41', NULL);
  1772. INSERT INTO `recurso_perfil` VALUES (498, 36, 2, '2024-10-21 22:48:41', NULL);
  1773. INSERT INTO `recurso_perfil` VALUES (499, 36, 3, '2024-10-21 22:48:41', NULL);
  1774. INSERT INTO `recurso_perfil` VALUES (500, 38, 2, '2024-10-21 22:48:41', NULL);
  1775. INSERT INTO `recurso_perfil` VALUES (501, 38, 3, '2024-10-21 22:48:41', NULL);
  1776. INSERT INTO `recurso_perfil` VALUES (502, 41, 2, '2024-10-21 22:48:41', NULL);
  1777. INSERT INTO `recurso_perfil` VALUES (503, 41, 3, '2024-10-21 22:48:41', NULL);
  1778. INSERT INTO `recurso_perfil` VALUES (504, 42, 2, '2024-10-21 22:48:41', NULL);
  1779. INSERT INTO `recurso_perfil` VALUES (505, 42, 3, '2024-10-21 22:48:41', NULL);
  1780. INSERT INTO `recurso_perfil` VALUES (506, 43, 2, '2024-10-21 22:48:41', NULL);
  1781. INSERT INTO `recurso_perfil` VALUES (507, 43, 3, '2024-10-21 22:48:41', NULL);
  1782. INSERT INTO `recurso_perfil` VALUES (508, 44, 2, '2024-10-21 22:48:41', NULL);
  1783. INSERT INTO `recurso_perfil` VALUES (509, 44, 3, '2024-10-21 22:48:41', NULL);
  1784. INSERT INTO `recurso_perfil` VALUES (510, 45, 2, '2024-10-21 22:48:41', NULL);
  1785. INSERT INTO `recurso_perfil` VALUES (511, 45, 3, '2024-10-21 22:48:41', NULL);
  1786. INSERT INTO `recurso_perfil` VALUES (512, 46, 2, '2024-10-21 22:48:41', NULL);
  1787. INSERT INTO `recurso_perfil` VALUES (513, 46, 3, '2024-10-21 22:48:41', NULL);
  1788. INSERT INTO `recurso_perfil` VALUES (514, 47, 2, '2024-10-21 22:48:41', NULL);
  1789. INSERT INTO `recurso_perfil` VALUES (515, 47, 3, '2024-10-21 22:48:41', NULL);
  1790. INSERT INTO `recurso_perfil` VALUES (516, 4, 2, '2024-10-21 22:48:41', NULL);
  1791. INSERT INTO `recurso_perfil` VALUES (517, 4, 3, '2024-10-21 22:48:41', NULL);
  1792. INSERT INTO `recurso_perfil` VALUES (518, 5, 2, '2024-10-21 22:48:41', NULL);
  1793. INSERT INTO `recurso_perfil` VALUES (519, 6, 2, '2024-10-21 22:48:41', NULL);
  1794. INSERT INTO `recurso_perfil` VALUES (520, 6, 3, '2024-10-21 22:48:41', NULL);
  1795. INSERT INTO `recurso_perfil` VALUES (521, 7, 2, '2024-10-21 22:48:41', NULL);
  1796. INSERT INTO `recurso_perfil` VALUES (522, 8, 2, '2024-10-21 22:48:41', NULL);
  1797. INSERT INTO `recurso_perfil` VALUES (523, 9, 2, '2024-10-21 22:48:41', NULL);
  1798. INSERT INTO `recurso_perfil` VALUES (524, 9, 3, '2024-10-21 22:48:41', NULL);
  1799. INSERT INTO `recurso_perfil` VALUES (525, 10, 2, '2024-10-21 22:48:41', NULL);
  1800. INSERT INTO `recurso_perfil` VALUES (526, 10, 3, '2024-10-21 22:48:41', NULL);
  1801. INSERT INTO `recurso_perfil` VALUES (527, 11, 2, '2024-10-21 22:48:41', NULL);
  1802. INSERT INTO `recurso_perfil` VALUES (528, 12, 2, '2024-10-21 22:48:41', NULL);
  1803. INSERT INTO `recurso_perfil` VALUES (529, 12, 3, '2024-10-21 22:48:41', NULL);
  1804. INSERT INTO `recurso_perfil` VALUES (530, 13, 2, '2024-10-21 22:48:41', NULL);
  1805. INSERT INTO `recurso_perfil` VALUES (531, 14, 2, '2024-10-21 22:48:41', NULL);
  1806.  
  1807. -- ----------------------------
  1808. -- Table structure for serial
  1809. -- ----------------------------
  1810. DROP TABLE IF EXISTS `serial`;
  1811. CREATE TABLE `serial`  (
  1812.   `id` int NOT NULL AUTO_INCREMENT,
  1813.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  1814.   `tipo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1815.   `inventario_id` int NULL DEFAULT NULL,
  1816.   `estatus` tinyint NULL DEFAULT 1,
  1817.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1818.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1819.   PRIMARY KEY (`id`) USING BTREE,
  1820.   INDEX `fk_serial_inventario_id`(`inventario_id` ASC) USING BTREE,
  1821.   CONSTRAINT `fk_serial_inventario_id` FOREIGN KEY (`inventario_id`) REFERENCES `inventario` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1822. ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1823.  
  1824. -- ----------------------------
  1825. -- Records of serial
  1826. -- ----------------------------
  1827. INSERT INTO `serial` VALUES (2, '1234', 'REPUESTO', 1, 1, '2024-10-22 11:44:52', NULL);
  1828.  
  1829. -- ----------------------------
  1830. -- Table structure for serie
  1831. -- ----------------------------
  1832. DROP TABLE IF EXISTS `serie`;
  1833. CREATE TABLE `serie`  (
  1834.   `id` int NOT NULL AUTO_INCREMENT,
  1835.   `modelo_id` int NULL DEFAULT NULL,
  1836.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  1837.   `tipo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1838.   `estatus` tinyint NULL DEFAULT 1,
  1839.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1840.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1841.   PRIMARY KEY (`id`) USING BTREE,
  1842.   INDEX `fk_variante_modelo_id`(`modelo_id` ASC) USING BTREE,
  1843.   CONSTRAINT `fk_variante_modelo_id` FOREIGN KEY (`modelo_id`) REFERENCES `modelo` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1844. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1845.  
  1846. -- ----------------------------
  1847. -- Records of serie
  1848. -- ----------------------------
  1849. INSERT INTO `serie` VALUES (1, 2, 'B4', NULL, 1, '2024-10-22 11:54:05', NULL);
  1850. INSERT INTO `serie` VALUES (2, 4, 'NUEVA SERIE', NULL, 1, '2024-10-22 15:42:46', NULL);
  1851. INSERT INTO `serie` VALUES (3, 1, 'SERIE1', NULL, 1, '2024-10-25 23:22:20', NULL);
  1852. INSERT INTO `serie` VALUES (4, 6, 'NUEVA SERIE - NUEVO MODELO-OTRO MAS', NULL, 1, '2024-10-26 14:24:10', NULL);
  1853.  
  1854. -- ----------------------------
  1855. -- Table structure for ubicacion
  1856. -- ----------------------------
  1857. DROP TABLE IF EXISTS `ubicacion`;
  1858. CREATE TABLE `ubicacion`  (
  1859.   `id` int NOT NULL AUTO_INCREMENT,
  1860.   `almacen_id` int NULL DEFAULT NULL,
  1861.   `padre_id` int NULL DEFAULT NULL,
  1862.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  1863.   `codificado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1864.   `abreviatura` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1865.   `estatus` tinyint NULL DEFAULT 1,
  1866.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1867.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1868.   PRIMARY KEY (`id`) USING BTREE,
  1869.   INDEX `fk_ubicacion_padre_id`(`padre_id` ASC) USING BTREE,
  1870.   INDEX `fk_ubicacion_almacen_id`(`almacen_id` ASC) USING BTREE,
  1871.   CONSTRAINT `fk_ubicacion_almacen_id` FOREIGN KEY (`almacen_id`) REFERENCES `almacen` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  1872.   CONSTRAINT `fk_ubicacion_padre_id` FOREIGN KEY (`padre_id`) REFERENCES `ubicacion` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  1873. ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1874.  
  1875. -- ----------------------------
  1876. -- Records of ubicacion
  1877. -- ----------------------------
  1878. INSERT INTO `ubicacion` VALUES (1, 1, NULL, 'ESTANTE 1', '0001', 'E1', 1, '2024-10-22 11:27:01', '2024-10-22 11:27:01');
  1879. INSERT INTO `ubicacion` VALUES (2, 1, 1, 'PELDAÑO 001', '00010002', 'P001', 1, '2024-10-22 11:28:28', '2024-10-22 11:28:28');
  1880. INSERT INTO `ubicacion` VALUES (3, 1, 1, 'PELDAÑO 002', '00010003', 'P002', 1, '2024-10-22 11:28:28', '2024-10-22 11:28:28');
  1881. INSERT INTO `ubicacion` VALUES (4, 1, 1, 'PELDAÑO 003', '00010004', 'P003', 1, '2024-10-22 11:28:28', '2024-10-22 11:28:28');
  1882. INSERT INTO `ubicacion` VALUES (5, 1, 1, 'PELDAÑO 004', '00010005', 'P004', 1, '2024-10-22 11:28:28', '2024-10-22 11:28:28');
  1883. INSERT INTO `ubicacion` VALUES (6, 1, 1, 'PELDAÑO 005', '00010006', 'P005', 1, '2024-10-22 11:28:28', '2024-10-22 11:28:28');
  1884. INSERT INTO `ubicacion` VALUES (7, 1, 1, 'PELDAÑO 006', '00010007', 'P006', 1, '2024-10-22 11:28:28', '2024-10-22 11:28:28');
  1885. INSERT INTO `ubicacion` VALUES (8, 1, 5, 'CAJA 001', '000100050008', 'C001', 1, '2024-10-22 11:30:07', '2024-10-22 11:30:07');
  1886. INSERT INTO `ubicacion` VALUES (9, 1, 5, 'CAJA 002', '000100050009', 'C002', 1, '2024-10-22 11:30:07', '2024-10-22 11:30:07');
  1887. INSERT INTO `ubicacion` VALUES (10, 1, 5, 'CAJA 003', '000100050010', 'C003', 1, '2024-10-22 11:30:07', '2024-10-22 11:30:07');
  1888. INSERT INTO `ubicacion` VALUES (11, 1, 5, 'CAJA 004', '000100050011', 'C004', 1, '2024-10-22 11:30:07', '2024-10-22 11:30:07');
  1889. INSERT INTO `ubicacion` VALUES (12, 1, 5, 'CAJA 005', '000100050012', 'C005', 1, '2024-10-22 11:30:07', '2024-10-22 11:30:07');
  1890. INSERT INTO `ubicacion` VALUES (13, 1, 5, 'CAJA 006', '000100050013', 'C006', 1, '2024-10-22 11:30:07', '2024-10-22 11:30:07');
  1891. INSERT INTO `ubicacion` VALUES (14, 1, 5, 'CAJA 007', '000100050014', 'C007', 1, '2024-10-22 11:30:07', '2024-10-22 11:30:07');
  1892. INSERT INTO `ubicacion` VALUES (15, 1, 5, 'CAJA 008', '000100050015', 'C008', 1, '2024-10-22 11:30:07', '2024-10-22 11:30:07');
  1893. INSERT INTO `ubicacion` VALUES (16, 1, 5, 'CAJA 009', '000100050016', 'C009', 1, '2024-10-22 11:30:07', '2024-10-22 11:30:07');
  1894. INSERT INTO `ubicacion` VALUES (17, 1, 5, 'CAJA 010', '000100050017', 'C010', 1, '2024-10-22 11:30:07', '2024-10-22 11:30:07');
  1895.  
  1896. -- ----------------------------
  1897. -- Table structure for unidad
  1898. -- ----------------------------
  1899. DROP TABLE IF EXISTS `unidad`;
  1900. CREATE TABLE `unidad`  (
  1901.   `id` int NOT NULL AUTO_INCREMENT,
  1902.   `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  1903.   `abreviatura` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  1904.   `estatus` tinyint NULL DEFAULT 1,
  1905.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1906.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1907.   PRIMARY KEY (`id`) USING BTREE
  1908. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  1909.  
  1910. -- ----------------------------
  1911. -- Records of unidad
  1912. -- ----------------------------
  1913. INSERT INTO `unidad` VALUES (1, 'UNIDAD', 'EA', 1, '2024-10-22 11:38:23', NULL);
  1914.  
  1915. -- ----------------------------
  1916. -- Table structure for usuario
  1917. -- ----------------------------
  1918. DROP TABLE IF EXISTS `usuario`;
  1919. CREATE TABLE `usuario`  (
  1920.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'Identificador del usuario',
  1921.   `nombre` varchar(70) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Nombre del Usuario',
  1922.   `apellido` varchar(70) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Apellido del usuario',
  1923.   `login` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Nombre de usuario',
  1924.   `password` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Contraseña de acceso al sistea',
  1925.   `perfil_id` int NOT NULL COMMENT 'Identificador del perfil',
  1926.   `cedula` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  1927.   `email` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Dirección del correo electónico',
  1928.   `telefono` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Telefonos',
  1929.   `tiempo` int NULL DEFAULT 3 COMMENT 'Tiempo de duracion de sesion',
  1930.   `tema` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'default' COMMENT 'Tema aplicable para la interfaz',
  1931.   `app_ajax` int NULL DEFAULT 1 COMMENT 'Indica si la app se trabaja con ajax o peticiones normales',
  1932.   `datagrid` int NULL DEFAULT 30 COMMENT 'Datos por página en los datagrid',
  1933.   `fotografia` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'default.png',
  1934.   `usuario_at` datetime NULL DEFAULT NULL COMMENT 'Fecha de registro',
  1935.   `usuario_in` datetime NULL DEFAULT NULL COMMENT 'Fecha de la última modificación',
  1936.   `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creación del Registro',
  1937.   `updated_in` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Ultima Actualización',
  1938.   PRIMARY KEY (`id`) USING BTREE,
  1939.   INDEX `fk_usuario_perfil_idx`(`perfil_id` ASC) USING BTREE,
  1940.   CONSTRAINT `fk_usuario_perfil_id` FOREIGN KEY (`perfil_id`) REFERENCES `perfil` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  1941. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'Tabla que contiene los usuarios' ROW_FORMAT = Dynamic;
  1942.  
  1943. -- ----------------------------
  1944. -- Records of usuario
  1945. -- ----------------------------
  1946. INSERT INTO `usuario` VALUES (1, 'PROGRAMADOR', 'DEL SISTEMA', 'cronjob', '5b5b2b169c2618291e1a025af3792447180f7f95', 1, NULL, NULL, NULL, 60, 'default', 1, 0, '49314b779caa00d752bc2a63f8bd0aa3.png', '2013-01-01 00:00:01', '2024-09-28 16:01:52', '2024-10-21 22:50:09', NULL);
  1947. INSERT INTO `usuario` VALUES (2, 'ADMINISTRADOR', 'DEL SISTEMA', 'admin', '7c4a8d09ca3762af61e59520943dc26494f8941b', 1, NULL, 'admin@admin1.com', NULL, 3, 'default', 1, 0, 'default.png', '2013-01-01 00:00:01', '2022-09-06 22:02:38', '2024-10-21 22:50:09', NULL);
  1948. INSERT INTO `usuario` VALUES (4, 'ROBERT', 'ARIAS', 'robertjota', '7c4a8d09ca3762af61e59520943dc26494f8941b', 3, 'V-7949343', 'robertjota@gmail.com', '04129236406', 3, 'default', 1, 30, 'default.png', '2022-09-06 22:00:28', NULL, '2024-10-21 22:50:09', NULL);
  1949. INSERT INTO `usuario` VALUES (5, 'PEPE', 'TRUENO', 'pepetrueno', '5b5b2b169c2618291e1a025af3792447180f7f95', 5, NULL, 'pepe@pepe.com', NULL, 3, 'blue', 1, 0, 'cc27445052f64c3c03e0d2bf3d69664f.jpg', '2024-09-22 15:58:07', '2024-09-28 16:01:20', '2024-10-21 22:50:09', NULL);
  1950. INSERT INTO `usuario` VALUES (6, 'JUAN CARLOS', 'ROGRIGUEZ', 'juan', '7c4a8d09ca3762af61e59520943dc26494f8941b', 1, NULL, 'juan@admin.com', NULL, 10, 'default', 1, 0, 'default.png', '2024-10-10 11:13:42', '2024-10-11 08:12:40', '2024-10-21 22:50:09', NULL);
  1951.  
  1952. -- ----------------------------
  1953. -- View structure for v_ubicacion_ruta
  1954. -- ----------------------------
  1955. DROP VIEW IF EXISTS `v_ubicacion_ruta`;
  1956. CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_ubicacion_ruta` AS with recursive `ubicacion_path` as (select `u`.`id` AS `id`,`u`.`nombre` AS `nombre`,`u`.`abreviatura` AS `abreviatura`,`u`.`codificado` AS `codificado`,`u`.`almacen_id` AS `almacen_id`,`a`.`nombre` AS `almacen_nombre`,concat(`a`.`nombre`,'->',coalesce(`u`.`abreviatura`,`u`.`nombre`)) AS `path` from (`ubicacion` `u` join `almacen` `a` on((`u`.`almacen_id` = `a`.`id`))) where (`u`.`padre_id` is null) union all select `c`.`id` AS `id`,`c`.`nombre` AS `nombre`,`c`.`abreviatura` AS `abreviatura`,`c`.`codificado` AS `codificado`,`c`.`almacen_id` AS `almacen_id`,`p`.`almacen_nombre` AS `almacen_nombre`,concat(`p`.`path`,'->',coalesce(`c`.`abreviatura`,`c`.`nombre`)) AS `CONCAT(p.path, '->', COALESCE(c.abreviatura, c.nombre))` from (`ubicacion` `c` join `ubicacion_path` `p` on((`c`.`padre_id` = `p`.`id`)))) select `u`.`id` AS `id`,`u`.`almacen_id` AS `almacen_id`,`u`.`padre_id` AS `padre_id`,`u`.`nombre` AS `nombre`,`u`.`codificado` AS `codificado`,`u`.`abreviatura` AS `abreviatura`,`u`.`estatus` AS `estatus`,`u`.`created_at` AS `created_at`,`u`.`updated_at` AS `updated_at`,`up`.`path` AS `ruta_completa` from (`ubicacion` `u` join `ubicacion_path` `up` on((`u`.`id` = `up`.`id`)));
  1957.  
  1958. -- ----------------------------
  1959. -- Triggers structure for table inventario_ubicacion
  1960. -- ----------------------------
  1961. DROP TRIGGER IF EXISTS `after_inventario_ubicacion_insert`;
  1962. delimiter ;;
  1963. CREATE TRIGGER `after_inventario_ubicacion_insert` AFTER INSERT ON `inventario_ubicacion` FOR EACH ROW BEGIN
  1964.     UPDATE inventario
  1965.     SET existencia_total = (
  1966.         SELECT COALESCE(SUM(existencia), 0)
  1967.         FROM inventario_ubicacion
  1968.         WHERE inventario_id = NEW.inventario_id
  1969.     )
  1970.     WHERE id = NEW.inventario_id;
  1971. END
  1972. ;;
  1973. delimiter ;
  1974.  
  1975. -- ----------------------------
  1976. -- Triggers structure for table inventario_ubicacion
  1977. -- ----------------------------
  1978. DROP TRIGGER IF EXISTS `after_inventario_ubicacion_update`;
  1979. delimiter ;;
  1980. CREATE TRIGGER `after_inventario_ubicacion_update` AFTER UPDATE ON `inventario_ubicacion` FOR EACH ROW BEGIN
  1981.     UPDATE inventario
  1982.     SET existencia_total = (
  1983.         SELECT COALESCE(SUM(existencia), 0)
  1984.         FROM inventario_ubicacion
  1985.         WHERE inventario_id = NEW.inventario_id
  1986.     )
  1987.     WHERE id = NEW.inventario_id;
  1988.    
  1989.     -- Si el inventario_id ha cambiado, actualizamos también el antiguo inventario
  1990.     IF OLD.inventario_id != NEW.inventario_id THEN
  1991.         UPDATE inventario
  1992.         SET existencia_total = (
  1993.             SELECT COALESCE(SUM(existencia), 0)
  1994.             FROM inventario_ubicacion
  1995.             WHERE inventario_id = OLD.inventario_id
  1996.         )
  1997.         WHERE id = OLD.inventario_id;
  1998.     END IF;
  1999. END
  2000. ;;
  2001. delimiter ;
  2002.  
  2003. -- ----------------------------
  2004. -- Triggers structure for table inventario_ubicacion
  2005. -- ----------------------------
  2006. DROP TRIGGER IF EXISTS `after_inventario_ubicacion_delete`;
  2007. delimiter ;;
  2008. CREATE TRIGGER `after_inventario_ubicacion_delete` AFTER DELETE ON `inventario_ubicacion` FOR EACH ROW BEGIN
  2009.     UPDATE inventario
  2010.     SET existencia_total = (
  2011.         SELECT COALESCE(SUM(existencia), 0)
  2012.         FROM inventario_ubicacion
  2013.         WHERE inventario_id = OLD.inventario_id
  2014.     )
  2015.     WHERE id = OLD.inventario_id;
  2016. END
  2017. ;;
  2018. delimiter ;
  2019.  
  2020. SET FOREIGN_KEY_CHECKS = 1;
  2021.  
Tags: base de datos
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!