(7412,'2025-04-21 17:25:25','2025-04-21 17:25:25',1,NULL,NULL,NULL,1,-220,14.50000000,2,5,'Factura 12565 validada',NULL,NULL,7445,'facture',NULL,0),(7413,'2025-04-21 17:29:19','2025-04-21 17:29:19',1,NULL,NULL,NULL,1,-264,15.00000000,2,5,'Factura 12566 validada',NULL,NULL,7446,'facture',NULL,0),(7414,'2025-04-21 17:37:28','2025-04-21 17:37:28',5,NULL,NULL,NULL,1,-60,160.00000000,2,5,'Factura 12567 validada',NULL,NULL,7447,'facture',NULL,0),(7415,'2025-04-21 17:40:14','2025-04-21 17:40:14',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12568 validada',NULL,NULL,7448,'facture',NULL,0),(7416,'2025-04-21 17:45:24','2025-04-21 17:45:24',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12569 validada',NULL,NULL,7449,'facture',NULL,0),(7417,'2025-04-21 17:48:21','2025-04-21 17:48:21',1,NULL,NULL,NULL,1,-220,15.00000000,2,5,'Factura 12570 validada',NULL,NULL,7450,'facture',NULL,0),(7418,'2025-04-21 17:48:21','2025-04-21 17:48:21',5,NULL,NULL,NULL,1,-20,160.00000000,2,5,'Factura 12570 validada',NULL,NULL,7450,'facture',NULL,0),(7419,'2025-04-21 17:51:59','2025-04-21 17:51:59',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12571 validada',NULL,NULL,7451,'facture',NULL,0),(7420,'2025-04-21 17:53:55','2025-04-21 17:53:55',7,NULL,NULL,NULL,1,-150,49.00000000,2,5,'Factura 12572 validada',NULL,NULL,7452,'facture',NULL,0),(7421,'2025-04-21 17:59:56','2025-04-21 17:59:56',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12573 validada',NULL,NULL,7453,'facture',NULL,0),(7422,'2025-04-21 18:06:12','2025-04-21 18:06:12',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12574 validada',NULL,NULL,7454,'facture',NULL,0),(7423,'2025-04-21 18:30:58','2025-04-21 18:30:58',1,NULL,NULL,NULL,1,-66,18.00000000,2,5,'Factura 12575 validada',NULL,NULL,7455,'facture',NULL,0),(7424,'2025-04-22 15:59:12','2025-04-22 15:59:12',1,NULL,NULL,NULL,1,-330,14.50000000,2,5,'Factura 12576 validada',NULL,NULL,7456,'facture',NULL,0),(7425,'2025-04-22 16:03:46','2025-04-22 16:03:46',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12577 validada',NULL,NULL,7457,'facture',NULL,0),(7426,'2025-04-22 16:08:08','2025-04-22 16:08:08',1,NULL,NULL,NULL,1,-880,14.50000000,2,5,'Factura 12578 validada',NULL,NULL,7458,'facture',NULL,0),(7427,'2025-04-22 16:11:48','2025-04-22 16:11:48',1,NULL,NULL,NULL,1,-66,15.00000000,2,5,'Factura 12579 validada',NULL,NULL,7459,'facture',NULL,0),(7428,'2025-04-22 16:14:28','2025-04-22 16:14:28',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12580 validada',NULL,NULL,7460,'facture',NULL,0),(7429,'2025-04-22 22:34:37','2025-04-22 22:34:37',1,NULL,NULL,NULL,1,-176,15.00000000,2,5,'Factura 12581 validada',NULL,NULL,7461,'facture',NULL,0),(7430,'2025-04-22 22:34:37','2025-04-22 22:34:37',5,NULL,NULL,NULL,1,-20,160.00000000,2,5,'Factura 12581 validada',NULL,NULL,7461,'facture',NULL,0),(7431,'2025-04-23 15:59:50','2025-04-23 15:59:50',7,NULL,NULL,NULL,1,-500,42.00000000,2,5,'Factura 12582 validada',NULL,NULL,7462,'facture',NULL,0),(7446,'2025-04-23 20:46:30','2025-04-23 20:46:30',7,NULL,NULL,NULL,1,250,0.00000000,3,1,'Factura NC0001 validada',NULL,NULL,7463,'facture',NULL,0),(7447,'2025-04-23 21:17:09','2025-04-23 21:17:09',7,NULL,NULL,NULL,1,15,0.00000000,3,5,'Factura NC0002 validada',NULL,NULL,7464,'facture',NULL,0),(7448,'2025-04-23 21:20:25','2025-04-23 21:20:25',1,NULL,NULL,NULL,1,-330,14.50000000,2,5,'Factura 12583 validada',NULL,NULL,7465,'facture',NULL,0),(7449,'2025-04-23 22:01:57','2025-04-23 22:01:57',7,NULL,NULL,NULL,1,-495,42.00000000,2,5,'Factura 12584 validada',NULL,NULL,7466,'facture',NULL,0),(7450,'2025-04-23 23:24:15','2025-04-23 23:24:15',1,NULL,NULL,NULL,1,-264,13.30000000,2,5,'Factura 12585 validada',NULL,NULL,7467,'facture',NULL,0),(7451,'2025-04-24 16:10:28','2025-04-24 16:10:28',1,NULL,NULL,NULL,1,-440,15.00000000,2,5,'Factura 12586 validada',NULL,NULL,7468,'facture',NULL,0),(7452,'2025-04-24 16:12:51','2025-04-24 16:12:51',1,NULL,NULL,NULL,1,-374,14.50000000,2,5,'Factura 12587 validada',NULL,NULL,7469,'facture',NULL,0),(7453,'2025-04-24 16:15:27','2025-04-24 16:15:27',1,NULL,NULL,NULL,1,-15,264.00000000,2,5,'Factura 12588 validada',NULL,NULL,7470,'facture',NULL,0),(7454,'2025-04-24 16:17:46','2025-04-24 16:17:46',1,NULL,NULL,NULL,1,-66,18.00000000,2,5,'Factura 12589 validada',NULL,NULL,7471,'facture',NULL,0),(7455,'2025-04-24 16:23:02','2025-04-24 16:23:02',1,NULL,NULL,NULL,1,-484,18.00000000,2,5,'Factura 12590 validada',NULL,NULL,7472,'facture',NULL,0),(7456,'2025-04-24 16:52:11','2025-04-24 16:52:11',1,NULL,NULL,NULL,1,-330,14.50000000,2,5,'Factura 12591 validada',NULL,NULL,7473,'facture',NULL,0),(7457,'2025-04-24 17:39:35','2025-04-24 17:39:35',1,NULL,NULL,NULL,1,-660,15.00000000,2,5,'Factura 12592 validada',NULL,NULL,7474,'facture',NULL,0),(7458,'2025-04-24 18:10:35','2025-04-24 18:10:35',1,NULL,NULL,NULL,1,-660,15.00000000,2,5,'Factura 12593 validada',NULL,NULL,7475,'facture',NULL,0),(7459,'2025-04-24 20:41:06','2025-04-24 20:41:06',5,NULL,NULL,NULL,1,-466.6,8.00000000,2,5,'Factura 12594 validada',NULL,NULL,7476,'facture',NULL,0),(7460,'2025-04-24 21:45:37','2025-04-24 21:45:37',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12595 validada',NULL,NULL,7477,'facture',NULL,0),(7461,'2025-04-25 02:42:53','2025-04-25 02:42:53',7,NULL,NULL,NULL,1,-1100,49.88000000,2,5,'Factura 12596 validada',NULL,NULL,7478,'facture',NULL,0),(7462,'2025-04-25 18:43:38','2025-04-25 18:43:38',1,NULL,NULL,NULL,1,-880,14.50000000,2,5,'Factura 12597 validada',NULL,NULL,7479,'facture',NULL,0),(7463,'2025-04-25 22:43:42','2025-04-25 22:43:42',7,NULL,NULL,NULL,1,130,0.00000000,3,5,'Factura NC0003 validada',NULL,NULL,7480,'facture',NULL,0),(7464,'2025-04-30 15:22:40','2025-04-30 15:22:40',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12598 validada',NULL,NULL,7481,'facture',NULL,0),(7465,'2025-04-30 15:31:19','2025-04-30 15:31:19',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12599 validada',NULL,NULL,7482,'facture',NULL,0),(7466,'2025-04-30 16:06:35','2025-04-30 16:06:35',1,NULL,NULL,NULL,1,-132,15.00000000,2,5,'Factura 12600 validada',NULL,NULL,7483,'facture',NULL,0),(7467,'2025-04-30 16:06:35','2025-04-30 16:06:35',5,NULL,NULL,NULL,1,-7,160.00000000,2,5,'Factura 12600 validada',NULL,NULL,7483,'facture',NULL,0),(7468,'2025-04-30 16:15:41','2025-04-30 16:15:41',1,NULL,NULL,NULL,1,-264,14.50000000,2,5,'Factura 12601 validada',NULL,NULL,7484,'facture',NULL,0),(7469,'2025-04-30 16:20:44','2025-04-30 16:20:44',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12602 validada',NULL,NULL,7485,'facture',NULL,0),(7470,'2025-04-30 22:59:53','2025-04-30 22:59:53',1,NULL,NULL,NULL,1,-660,15.00000000,2,5,'Factura 12603 validada',NULL,NULL,7486,'facture',NULL,0),(7471,'2025-04-30 22:59:53','2025-04-30 22:59:53',5,NULL,NULL,NULL,1,-20,160.00000000,2,5,'Factura 12603 validada',NULL,NULL,7486,'facture',NULL,0),(7472,'2025-05-01 22:37:15','2025-05-01 22:37:15',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12604 validada',NULL,NULL,7487,'facture',NULL,0),(7473,'2025-05-02 14:47:29','2025-05-02 14:47:29',7,NULL,NULL,NULL,1,-500,49.88000000,2,5,'Factura 12605 validada',NULL,NULL,7488,'facture',NULL,0),(7474,'2025-05-02 18:46:52','2025-05-02 18:46:52',1,NULL,NULL,NULL,1,-550,15.00000000,2,5,'Factura 12606 validada',NULL,NULL,7489,'facture',NULL,0);
INSERT INTO `llx_stock_mouvement` VALUES (7475,'2025-05-05 19:21:07','2025-05-05 19:21:07',1,NULL,NULL,NULL,1,-550,15.00000000,2,5,'Factura 12607 validada',NULL,NULL,7490,'facture',NULL,0),(7476,'2025-05-06 16:29:13','2025-05-06 16:29:13',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12608 validada',NULL,NULL,7491,'facture',NULL,0),(7477,'2025-05-06 16:31:52','2025-05-06 16:31:52',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12609 validada',NULL,NULL,7492,'facture',NULL,0),(7478,'2025-05-06 16:34:49','2025-05-06 16:34:49',1,NULL,NULL,NULL,1,-66,15.00000000,2,5,'Factura 12610 validada',NULL,NULL,7493,'facture',NULL,0),(7479,'2025-05-06 17:00:30','2025-05-06 17:00:30',1,NULL,NULL,NULL,1,-132,15.00000000,2,5,'Factura 12611 validada',NULL,NULL,7494,'facture',NULL,0),(7480,'2025-05-06 17:03:22','2025-05-06 17:03:22',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12612 validada',NULL,NULL,7495,'facture',NULL,0),(7481,'2025-05-06 17:14:32','2025-05-06 17:14:32',1,NULL,NULL,NULL,1,-66,18.00000000,2,5,'Factura 12613 validada',NULL,NULL,7496,'facture',NULL,0),(7482,'2025-05-06 17:50:54','2025-05-06 17:50:54',1,NULL,NULL,NULL,1,-330,14.50000000,2,5,'Factura 12614 validada',NULL,NULL,7497,'facture',NULL,0),(7483,'2025-05-06 17:54:05','2025-05-06 17:54:05',1,NULL,NULL,NULL,1,-880,14.50000000,2,5,'Factura 12615 validada',NULL,NULL,7498,'facture',NULL,0),(7484,'2025-05-06 17:57:05','2025-05-06 17:57:05',1,NULL,NULL,NULL,1,-30,160.00000000,2,5,'Factura 12616 validada',NULL,NULL,7499,'facture',NULL,0),(7485,'2025-05-06 18:02:55','2025-05-06 18:02:55',2,NULL,NULL,NULL,1,-35,160.00000000,2,5,'Factura 12617 validada',NULL,NULL,7500,'facture',NULL,0),(7486,'2025-05-06 19:35:57','2025-05-06 19:35:57',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12618 validada',NULL,NULL,7501,'facture',NULL,0),(7487,'2025-05-06 19:35:57','2025-05-06 19:35:57',5,NULL,NULL,NULL,1,-20,160.00000000,2,5,'Factura 12618 validada',NULL,NULL,7501,'facture',NULL,0),(7488,'2025-05-06 19:52:41','2025-05-06 19:52:41',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12619 validada',NULL,NULL,7502,'facture',NULL,0),(7489,'2025-05-06 19:55:43','2025-05-06 19:55:43',1,NULL,NULL,NULL,1,-660,15.00000000,2,5,'Factura 12620 validada',NULL,NULL,7503,'facture',NULL,0),(7490,'2025-05-06 19:55:43','2025-05-06 19:55:43',5,NULL,NULL,NULL,1,-37,160.00000000,2,5,'Factura 12620 validada',NULL,NULL,7503,'facture',NULL,0),(7493,'2025-05-06 20:55:22','2025-05-06 20:55:22',1,NULL,NULL,NULL,1,-440,13.00000000,2,5,'Factura 12621 validada',NULL,NULL,7504,'facture',NULL,0),(7494,'2025-05-06 21:11:25','2025-05-06 21:11:25',1,NULL,NULL,NULL,1,-176,15.00000000,2,5,'Factura 12622 validada',NULL,NULL,7505,'facture',NULL,0),(7495,'2025-05-06 22:36:34','2025-05-06 22:36:34',1,NULL,NULL,NULL,1,-1100,14.50000000,2,5,'Factura 12623 validada',NULL,NULL,7506,'facture',NULL,0),(7496,'2025-05-06 23:57:45','2025-05-06 23:57:45',1,NULL,NULL,NULL,1,-396,18.00000000,2,5,'Factura 12624 validada',NULL,NULL,7507,'facture',NULL,0),(7497,'2025-05-07 17:47:39','2025-05-07 17:47:39',13,NULL,NULL,NULL,1,-3528,71.00000000,2,5,'Factura 12625 validada',NULL,NULL,7508,'facture',NULL,0),(7498,'2025-05-07 17:57:42','2025-05-07 17:57:42',7,NULL,NULL,NULL,1,-250,49.00000000,2,5,'Factura 12626 validada',NULL,NULL,7509,'facture',NULL,0),(7499,'2025-05-07 21:18:12','2025-05-07 21:18:12',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12627 validada',NULL,NULL,7510,'facture',NULL,0),(7500,'2025-05-07 21:18:12','2025-05-07 21:18:12',5,NULL,NULL,NULL,1,-500.6,8.00000000,2,5,'Factura 12627 validada',NULL,NULL,7510,'facture',NULL,0),(7501,'2025-05-09 18:28:30','2025-05-09 18:28:30',1,NULL,NULL,NULL,1,-1038,13.00000000,2,5,'Factura 12628 validada',NULL,NULL,7511,'facture',NULL,0),(7502,'2025-05-12 17:22:14','2025-05-12 17:22:14',1,NULL,NULL,NULL,1,1038,0.00000000,3,5,'Regresar factura 12628 al estado de borrador',NULL,NULL,7511,'facture',NULL,0),(7505,'2025-05-12 17:25:33','2025-05-12 17:25:33',1,NULL,NULL,NULL,1,-838.2307,13.00000000,2,5,'Factura 12629 validada',NULL,NULL,7512,'facture',NULL,0),(7506,'2025-05-12 20:58:51','2025-05-12 20:58:51',1,NULL,NULL,NULL,1,-66,18.00000000,2,5,'Factura 12630 validada',NULL,NULL,7513,'facture',NULL,0),(7507,'2025-05-12 21:26:02','2025-05-12 21:26:02',1,NULL,NULL,NULL,1,-880,14.50000000,2,5,'Factura 12631 validada',NULL,NULL,7514,'facture',NULL,0),(7508,'2025-05-13 00:11:43','2025-05-13 00:11:43',1,NULL,NULL,NULL,1,-154,15.00000000,2,5,'Factura 12632 validada',NULL,NULL,7515,'facture',NULL,0),(7509,'2025-05-13 00:17:02','2025-05-13 00:17:02',1,NULL,NULL,NULL,1,-524,15.00000000,2,5,'Factura 12633 validada',NULL,NULL,7516,'facture',NULL,0),(7510,'2025-05-13 16:37:23','2025-05-13 16:37:23',1,NULL,NULL,NULL,1,-220,14.00000000,2,5,'Factura 12634 validada',NULL,NULL,7517,'facture',NULL,0),(7511,'2025-05-13 18:14:16','2025-05-13 18:14:16',18,NULL,NULL,NULL,1,-1100,14.50000000,2,5,'Factura 12635 validada',NULL,NULL,7518,'facture',NULL,0),(7512,'2025-05-13 18:17:18','2025-05-13 18:17:18',18,NULL,NULL,NULL,1,-858,13.50000000,2,5,'Factura 12636 validada',NULL,NULL,7519,'facture',NULL,0),(7513,'2025-05-13 18:59:14','2025-05-13 18:59:14',1,NULL,NULL,NULL,1,-660,14.50000000,2,5,'Factura 12637 validada',NULL,NULL,7520,'facture',NULL,0),(7514,'2025-05-13 20:48:23','2025-05-13 20:48:23',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12638 validada',NULL,NULL,7521,'facture',NULL,0),(7515,'2025-05-13 21:01:35','2025-05-13 21:01:35',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12639 validada',NULL,NULL,7522,'facture',NULL,0),(7516,'2025-05-13 21:04:43','2025-05-13 21:04:43',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12640 validada',NULL,NULL,7523,'facture',NULL,0),(7517,'2025-05-13 21:07:47','2025-05-13 21:07:47',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12641 validada',NULL,NULL,7524,'facture',NULL,0),(7518,'2025-05-13 21:12:00','2025-05-13 21:12:00',1,NULL,NULL,NULL,1,-132,15.00000000,2,5,'Factura 12642 validada',NULL,NULL,7525,'facture',NULL,0),(7519,'2025-05-13 21:12:00','2025-05-13 21:12:00',5,NULL,NULL,NULL,1,-7,160.00000000,2,5,'Factura 12642 validada',NULL,NULL,7525,'facture',NULL,0),(7520,'2025-05-13 21:14:25','2025-05-13 21:14:25',1,NULL,NULL,NULL,1,-880,14.50000000,2,5,'Factura 12643 validada',NULL,NULL,7526,'facture',NULL,0),(7521,'2025-05-13 21:17:51','2025-05-13 21:17:51',1,NULL,NULL,NULL,1,-66,15.00000000,2,5,'Factura 12644 validada',NULL,NULL,7527,'facture',NULL,0),(7522,'2025-05-13 21:24:50','2025-05-13 21:24:50',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12645 validada',NULL,NULL,7528,'facture',NULL,0),(7523,'2025-05-13 21:39:00','2025-05-13 21:39:00',1,NULL,NULL,NULL,1,-330,13.00000000,2,5,'Factura 12646 validada',NULL,NULL,7529,'facture',NULL,0),(7524,'2025-05-13 21:42:25','2025-05-13 21:42:25',1,NULL,NULL,NULL,1,-220,15.00000000,2,5,'Factura 12647 validada',NULL,NULL,7530,'facture',NULL,0),(7525,'2025-05-13 21:42:25','2025-05-13 21:42:25',5,NULL,NULL,NULL,1,-1,160.00000000,2,5,'Factura 12647 validada',NULL,NULL,7530,'facture',NULL,0),(7526,'2025-05-14 01:32:25','2025-05-14 01:32:25',3,NULL,NULL,NULL,1,22,0.00000000,3,1,'Regresar factura 9631 al estado de borrador',NULL,NULL,4456,'facture',NULL,0),(7527,'2025-05-14 01:32:43','2025-05-14 01:32:43',3,NULL,NULL,NULL,1,-22,15.00000000,2,1,'Factura 9631 validada',NULL,NULL,4456,'facture',NULL,0),(7528,'2025-05-14 17:50:09','2025-05-14 17:50:09',1,NULL,NULL,NULL,1,-154,13.80000000,2,5,'Factura 12648 validada',NULL,NULL,7531,'facture',NULL,0),(7529,'2025-05-14 17:53:17','2025-05-14 17:53:17',1,NULL,NULL,NULL,1,-176,13.80000000,2,5,'Factura 12649 validada',NULL,NULL,7532,'facture',NULL,0),(7530,'2025-05-14 17:55:24','2025-05-14 17:55:24',1,NULL,NULL,NULL,1,-198,13.80000000,2,5,'Factura 12650 validada',NULL,NULL,7533,'facture',NULL,0),(7531,'2025-05-14 17:59:38','2025-05-14 17:59:38',1,NULL,NULL,NULL,1,-154,13.80000000,2,5,'Factura 12651 validada',NULL,NULL,7534,'facture',NULL,0),(7532,'2025-05-15 15:22:28','2025-05-15 15:22:28',1,NULL,NULL,NULL,1,-308,14.00000000,2,5,'Factura 12652 validada',NULL,NULL,7535,'facture',NULL,0),(7533,'2025-05-15 20:08:15','2025-05-15 20:08:15',1,NULL,NULL,NULL,1,-154,13.80000000,2,5,'Factura 12653 validada',NULL,NULL,7536,'facture',NULL,0),(7534,'2025-05-15 20:28:25','2025-05-15 20:28:25',1,NULL,NULL,NULL,1,-44,18.00000000,2,5,'Factura 12654 validada',NULL,NULL,7537,'facture',NULL,0),(7535,'2025-05-15 20:40:36','2025-05-15 20:40:36',1,NULL,NULL,NULL,1,-66,18.00000000,2,5,'Factura 12655 validada',NULL,NULL,7538,'facture',NULL,0),(7536,'2025-05-15 20:46:24','2025-05-15 20:46:24',1,NULL,NULL,NULL,1,-66,14.50000000,2,5,'Factura 12656 validada',NULL,NULL,7539,'facture',NULL,0),(7537,'2025-05-15 21:09:05','2025-05-15 21:09:05',1,NULL,NULL,NULL,1,-8,160.00000000,2,5,'Factura 12657 validada',NULL,NULL,7540,'facture',NULL,0),(7538,'2025-05-15 22:59:21','2025-05-15 22:59:21',1,NULL,NULL,NULL,1,-330,16.00000000,2,5,'Factura 12658 validada',NULL,NULL,7541,'facture',NULL,0),(7539,'2025-05-15 23:00:17','2025-05-15 23:00:17',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12659 validada',NULL,NULL,7542,'facture',NULL,0),(7540,'2025-05-16 17:18:00','2025-05-16 17:18:00',18,NULL,NULL,NULL,1,-440,18.00000000,2,5,'Factura 12660 validada',NULL,NULL,7543,'facture',NULL,0),(7541,'2025-05-16 17:26:11','2025-05-16 17:26:11',1,NULL,NULL,NULL,1,-572,13.30000000,2,5,'Factura 12661 validada',NULL,NULL,7544,'facture',NULL,0),(7542,'2025-05-16 17:26:11','2025-05-16 17:26:11',7,NULL,NULL,NULL,1,-60,41.00000000,2,5,'Factura 12661 validada',NULL,NULL,7544,'facture',NULL,0),(7543,'2025-05-16 17:47:30','2025-05-16 17:47:30',1,NULL,NULL,NULL,1,-660,14.50000000,2,5,'Factura 12662 validada',NULL,NULL,7545,'facture',NULL,0),(7544,'2025-05-16 17:55:09','2025-05-16 17:55:09',5,NULL,NULL,NULL,1,-20,160.00000000,2,5,'Factura 12663 validada',NULL,NULL,7546,'facture',NULL,0),(7546,'2025-05-17 15:29:59','2025-05-17 15:29:59',1,NULL,NULL,NULL,1,-550,14.00000000,2,5,'Factura 12664 validada',NULL,NULL,7547,'facture',NULL,0),(7547,'2025-05-17 16:21:19','2025-05-17 16:21:19',1,NULL,NULL,NULL,1,-550,14.50000000,2,5,'Factura 12665 validada',NULL,NULL,7548,'facture',NULL,0),(7548,'2025-05-19 21:12:13','2025-05-19 21:12:13',7,NULL,NULL,NULL,1,20,0.00000000,3,5,'Factura NC0004 validada',NULL,NULL,7549,'facture',NULL,0),(7549,'2025-05-20 14:17:51','2025-05-20 14:17:51',1,NULL,NULL,NULL,1,-220,14.00000000,2,5,'Factura 12666 validada',NULL,NULL,7550,'facture',NULL,0),(7550,'2025-05-20 22:38:48','2025-05-20 22:38:48',1,NULL,NULL,NULL,1,-660,14.50000000,2,5,'Factura 12667 validada',NULL,NULL,7551,'facture',NULL,0),(7551,'2025-05-20 23:09:36','2025-05-20 23:09:36',1,NULL,NULL,NULL,1,-286,13.00000000,2,5,'Factura 12668 validada',NULL,NULL,7552,'facture',NULL,0),(7552,'2025-05-21 18:08:28','2025-05-21 18:08:28',1,NULL,NULL,NULL,1,-176,13.30000000,2,1,'Factura 12669 validada',NULL,NULL,7553,'facture',NULL,0),(7553,'2025-05-21 19:50:42','2025-05-21 19:50:42',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12670 validada',NULL,NULL,7554,'facture',NULL,0),(7554,'2025-05-21 19:57:22','2025-05-21 19:57:22',1,NULL,NULL,NULL,1,-66,14.45455000,2,5,'Factura 12671 validada',NULL,NULL,7555,'facture',NULL,0),(7555,'2025-05-21 20:05:22','2025-05-21 20:05:22',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12672 validada',NULL,NULL,7556,'facture',NULL,0),(7556,'2025-05-21 20:09:33','2025-05-21 20:09:33',5,NULL,NULL,NULL,1,-25,160.00000000,2,5,'Factura 12673 validada',NULL,NULL,7557,'facture',NULL,0),(7557,'2025-05-21 20:09:33','2025-05-21 20:09:33',1,NULL,NULL,NULL,1,-440,14.50000000,2,5,'Factura 12673 validada',NULL,NULL,7557,'facture',NULL,0),(7558,'2025-05-21 20:14:31','2025-05-21 20:14:31',5,NULL,NULL,NULL,1,-50,160.00000000,2,5,'Factura 12674 validada',NULL,NULL,7558,'facture',NULL,0),(7559,'2025-05-21 20:18:18','2025-05-21 20:18:18',1,NULL,NULL,NULL,1,-66,15.00000000,2,5,'Factura 12675 validada',NULL,NULL,7559,'facture',NULL,0),(7560,'2025-05-21 20:34:56','2025-05-21 20:34:56',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12676 validada',NULL,NULL,7560,'facture',NULL,0),(7561,'2025-05-21 20:38:56','2025-05-21 20:38:56',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12677 validada',NULL,NULL,7561,'facture',NULL,0),(7562,'2025-05-21 20:47:01','2025-05-21 20:47:01',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12678 validada',NULL,NULL,7562,'facture',NULL,0),(7563,'2025-05-21 20:50:29','2025-05-21 20:50:29',1,NULL,NULL,NULL,1,-220,15.00000000,2,5,'Factura 12679 validada',NULL,NULL,7563,'facture',NULL,0),(7565,'2025-05-21 20:55:40','2025-05-21 20:55:40',1,NULL,NULL,NULL,1,-220,13.30000000,2,5,'Factura 12680 validada',NULL,NULL,7564,'facture',NULL,0),(7566,'2025-05-21 21:02:03','2025-05-21 21:02:03',1,NULL,NULL,NULL,1,-132,15.00000000,2,5,'Factura 12681 validada',NULL,NULL,7565,'facture',NULL,0),(7567,'2025-05-21 21:02:03','2025-05-21 21:02:03',5,NULL,NULL,NULL,1,-6,160.00000000,2,5,'Factura 12681 validada',NULL,NULL,7565,'facture',NULL,0),(7568,'2025-05-21 21:13:24','2025-05-21 21:13:24',1,NULL,NULL,NULL,1,-330,14.00000000,2,5,'Factura 12682 validada',NULL,NULL,7566,'facture',NULL,0),(7570,'2025-05-22 20:55:18','2025-05-22 20:55:18',1,NULL,NULL,NULL,1,-550,14.00000000,2,5,'Factura 12683 validada',NULL,NULL,7567,'facture',NULL,0),(7571,'2025-05-22 21:49:07','2025-05-22 21:49:07',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12684 validada',NULL,NULL,7568,'facture',NULL,0),(7572,'2025-05-23 14:35:03','2025-05-23 14:35:03',1,NULL,NULL,NULL,1,-528,18.00000000,2,5,'Factura 12685 validada',NULL,NULL,7569,'facture',NULL,0),(7573,'2025-05-23 18:22:23','2025-05-23 18:22:23',1,NULL,NULL,NULL,1,-550,14.00000000,2,5,'Factura 12686 validada',NULL,NULL,7570,'facture',NULL,0),(7574,'2025-05-23 18:32:42','2025-05-23 18:32:42',1,NULL,NULL,NULL,1,-220,15.00000000,2,5,'Factura 12687 validada',NULL,NULL,7571,'facture',NULL,0),(7575,'2025-05-23 21:51:56','2025-05-23 21:51:56',5,NULL,NULL,NULL,1,-38,160.00000000,2,5,'Factura 12688 validada',NULL,NULL,7572,'facture',NULL,0),(7576,'2025-05-23 21:54:16','2025-05-23 21:54:16',1,NULL,NULL,NULL,1,-660,15.00000000,2,5,'Factura 12689 validada',NULL,NULL,7573,'facture',NULL,0),(7577,'2025-05-23 22:00:20','2025-05-23 22:00:20',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12690 validada',NULL,NULL,7574,'facture',NULL,0),(7578,'2025-05-23 22:08:39','2025-05-23 22:08:39',1,NULL,NULL,NULL,1,-220,14.50000000,2,5,'Factura 12691 validada',NULL,NULL,7575,'facture',NULL,0),(7579,'2025-05-26 19:24:53','2025-05-26 19:24:53',1,NULL,NULL,NULL,1,-213.98,14.50000000,2,5,'Factura 12692 validada',NULL,NULL,7576,'facture',NULL,0),(7580,'2025-05-26 19:30:41','2025-05-26 19:30:41',1,NULL,NULL,NULL,1,-764.46122,13.00000000,2,5,'Factura 12693 validada',NULL,NULL,7577,'facture',NULL,0),(7581,'2025-05-26 19:35:27','2025-05-26 19:35:27',1,NULL,NULL,NULL,1,-220,15.00000000,2,5,'Factura 12694 validada',NULL,NULL,7578,'facture',NULL,0),(7582,'2025-05-26 19:38:02','2025-05-26 19:38:02',1,NULL,NULL,NULL,1,-110,15.00000000,2,5,'Factura 12695 validada',NULL,NULL,7579,'facture',NULL,0),(7583,'2025-05-26 19:38:02','2025-05-26 19:38:02',5,NULL,NULL,NULL,1,-6,160.00000000,2,5,'Factura 12695 validada',NULL,NULL,7579,'facture',NULL,0),(7584,'2025-05-26 19:48:25','2025-05-26 19:48:25',1,NULL,NULL,NULL,1,-220,14.00000000,2,5,'Factura 12696 validada',NULL,NULL,7580,'facture',NULL,0),(7585,'2025-05-26 22:58:59','2025-05-26 22:58:59',1,NULL,NULL,NULL,1,-220,15.00000000,2,5,'Factura 12697 validada',NULL,NULL,7581,'facture',NULL,0),(7586,'2025-05-27 17:54:46','2025-05-27 17:54:46',7,NULL,NULL,NULL,1,-15,52.00000000,2,5,'Factura 12698 validada',NULL,NULL,7582,'facture',NULL,0),(7587,'2025-05-27 21:56:30','2025-05-27 21:56:30',1,NULL,NULL,NULL,1,-418,14.50000000,2,5,'Factura 12699 validada',NULL,NULL,7583,'facture',NULL,0),(7588,'2025-05-28 20:19:28','2025-05-28 20:19:28',1,NULL,NULL,NULL,1,-352,13.00000000,2,5,'Factura 12700 validada',NULL,NULL,7584,'facture',NULL,0),(7589,'2025-05-28 20:22:19','2025-05-28 20:22:19',5,NULL,NULL,NULL,1,-1,160.00000000,2,5,'Factura 12701 validada',NULL,NULL,7585,'facture',NULL,0),(7590,'2025-05-28 20:23:48','2025-05-28 20:23:48',1,NULL,NULL,NULL,1,-220,15.00000000,2,5,'Factura 12702 validada',NULL,NULL,7586,'facture',NULL,0),(7591,'2025-05-28 20:26:27','2025-05-28 20:26:27',1,NULL,NULL,NULL,1,-330,14.50000000,2,5,'Factura 12703 validada',NULL,NULL,7587,'facture',NULL,0),(7592,'2025-05-28 20:26:27','2025-05-28 20:26:27',5,NULL,NULL,NULL,1,-25,160.00000000,2,5,'Factura 12703 validada',NULL,NULL,7587,'facture',NULL,0),(7593,'2025-05-28 20:28:48','2025-05-28 20:28:48',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12704 validada',NULL,NULL,7588,'facture',NULL,0),(7594,'2025-05-28 20:36:24','2025-05-28 20:36:24',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12705 validada',NULL,NULL,7589,'facture',NULL,0),(7595,'2025-05-28 20:54:34','2025-05-28 20:54:34',1,NULL,NULL,NULL,1,-132,13.80000000,2,5,'Factura 12706 validada',NULL,NULL,7590,'facture',NULL,0),(7596,'2025-05-28 20:55:53','2025-05-28 20:55:53',1,NULL,NULL,NULL,1,-220,13.80000000,2,5,'Factura 12707 validada',NULL,NULL,7591,'facture',NULL,0),(7597,'2025-05-28 20:57:10','2025-05-28 20:57:10',1,NULL,NULL,NULL,1,-154,13.80000000,2,5,'Factura 12708 validada',NULL,NULL,7592,'facture',NULL,0),(7598,'2025-05-28 20:59:49','2025-05-28 20:59:49',1,NULL,NULL,NULL,1,-220,13.80000000,2,5,'Factura 12709 validada',NULL,NULL,7593,'facture',NULL,0),(7599,'2025-05-28 21:13:08','2025-05-28 21:13:08',1,NULL,NULL,NULL,1,-880,14.50000000,2,5,'Factura 12710 validada',NULL,NULL,7594,'facture',NULL,0),(7600,'2025-05-28 21:17:20','2025-05-28 21:17:20',1,NULL,NULL,NULL,1,-41,160.00000000,2,5,'Factura 12711 validada',NULL,NULL,7595,'facture',NULL,0),(7601,'2025-05-28 21:27:16','2025-05-28 21:27:16',1,NULL,NULL,NULL,1,-330,14.00000000,2,5,'Factura 12712 validada',NULL,NULL,7596,'facture',NULL,0),(7602,'2025-05-28 21:37:59','2025-05-28 21:37:59',7,NULL,NULL,NULL,1,-3000,49.88000000,2,5,'Factura 12713 validada',NULL,NULL,7597,'facture',NULL,0),(7603,'2025-05-29 19:19:27','2025-05-29 19:19:27',1,NULL,NULL,NULL,1,-510.4,15.00000000,2,5,'Factura 12714 validada',NULL,NULL,7598,'facture',NULL,0),(7604,'2025-05-29 19:20:27','2025-05-29 19:20:27',1,NULL,NULL,NULL,1,-510.4,15.00000000,2,5,'Factura 12715 validada',NULL,NULL,7599,'facture',NULL,0),(7605,'2025-05-29 19:28:09','2025-05-29 19:28:09',1,NULL,NULL,NULL,1,-382.8,15.00000000,2,5,'Factura 12716 validada',NULL,NULL,7600,'facture',NULL,0),(7606,'2025-05-29 19:43:50','2025-05-29 19:43:50',1,NULL,NULL,NULL,1,-382.8,15.00000000,2,5,'Factura 12717 validada',NULL,NULL,7601,'facture',NULL,0),(7607,'2025-05-29 19:44:44','2025-05-29 19:44:44',1,NULL,NULL,NULL,1,-382.8,15.00000000,2,5,'Factura 12718 validada',NULL,NULL,7602,'facture',NULL,0),(7608,'2025-05-29 19:45:33','2025-05-29 19:45:33',1,NULL,NULL,NULL,1,-382.8,15.00000000,2,5,'Factura 12719 validada',NULL,NULL,7603,'facture',NULL,0),(7609,'2025-05-29 19:46:27','2025-05-29 19:46:27',1,NULL,NULL,NULL,1,-382.8,15.00000000,2,5,'Factura 12720 validada',NULL,NULL,7604,'facture',NULL,0),(7610,'2025-05-29 20:02:36','2025-05-29 20:02:36',1,NULL,NULL,NULL,1,-370,15.00000000,2,5,'Factura 12721 validada',NULL,NULL,7605,'facture',NULL,0),(7611,'2025-05-29 20:03:40','2025-05-29 20:03:40',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12722 validada',NULL,NULL,7606,'facture',NULL,0),(7612,'2025-05-29 20:04:28','2025-05-29 20:04:28',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12723 validada',NULL,NULL,7607,'facture',NULL,0),(7613,'2025-05-29 20:05:14','2025-05-29 20:05:14',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12724 validada',NULL,NULL,7608,'facture',NULL,0),(7614,'2025-05-29 20:05:58','2025-05-29 20:05:58',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12725 validada',NULL,NULL,7609,'facture',NULL,0),(7615,'2025-05-30 14:34:20','2025-05-30 14:34:20',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12726 validada',NULL,NULL,7610,'facture',NULL,0),(7616,'2025-05-30 21:42:15','2025-05-30 21:42:15',1,NULL,NULL,NULL,1,-176,13.80000000,2,5,'Factura 12727 validada',NULL,NULL,7611,'facture',NULL,0),(7617,'2025-05-30 21:47:06','2025-05-30 21:47:06',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12728 validada',NULL,NULL,7612,'facture',NULL,0),(7618,'2025-05-30 21:50:07','2025-05-30 21:50:07',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12729 validada',NULL,NULL,7613,'facture',NULL,0),(7619,'2025-05-30 21:53:07','2025-05-30 21:53:07',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12730 validada',NULL,NULL,7614,'facture',NULL,0),(7620,'2025-05-30 22:04:22','2025-05-30 22:04:22',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12731 validada',NULL,NULL,7616,'facture',NULL,0),(7622,'2025-05-30 22:08:30','2025-05-30 22:08:30',1,NULL,NULL,NULL,1,-66,18.00000000,2,5,'Factura 12732 validada',NULL,NULL,7617,'facture',NULL,0),(7623,'2025-05-30 22:31:17','2025-05-30 22:31:17',1,NULL,NULL,NULL,1,-44,18.00000000,2,5,'Factura 12733 validada',NULL,NULL,7618,'facture',NULL,0),(7625,'2025-05-30 22:40:52','2025-05-30 22:40:52',1,NULL,NULL,NULL,1,-550,14.00000000,2,5,'Factura 12734 validada',NULL,NULL,7619,'facture',NULL,0),(7626,'2025-05-30 23:10:34','2025-05-30 23:10:34',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12735 validada',NULL,NULL,7620,'facture',NULL,0),(7627,'2025-06-02 21:59:14','2025-06-02 21:59:14',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12736 validada',NULL,NULL,7621,'facture',NULL,0),(7628,'2025-06-02 22:00:49','2025-06-02 22:00:49',1,NULL,NULL,NULL,1,-396,13.50000000,2,5,'Factura 12737 validada',NULL,NULL,7622,'facture',NULL,0),(7629,'2025-06-02 22:02:20','2025-06-02 22:02:20',1,NULL,NULL,NULL,1,-330,14.50000000,2,5,'Factura 12738 validada',NULL,NULL,7623,'facture',NULL,0),(7630,'2025-06-02 22:04:30','2025-06-02 22:04:30',1,NULL,NULL,NULL,1,-220,14.50000000,2,5,'Factura 12739 validada',NULL,NULL,7624,'facture',NULL,0),(7631,'2025-06-02 23:11:25','2025-06-02 23:11:25',7,NULL,NULL,NULL,1,-2600,49.88000000,2,5,'Factura 12740 validada',NULL,NULL,7625,'facture',NULL,0),(7632,'2025-06-03 02:09:50','2025-06-03 02:09:50',1,NULL,NULL,NULL,1,-220,14.00000000,2,5,'Factura 12741 validada',NULL,NULL,7626,'facture',NULL,0),(7633,'2025-06-03 23:01:13','2025-06-03 23:01:13',1,NULL,NULL,NULL,1,-66,15.00000000,2,5,'Factura 12742 validada',NULL,NULL,7627,'facture',NULL,0),(7634,'2025-06-05 07:47:38','2025-06-05 07:47:38',1,NULL,NULL,NULL,1,-220,14.00000000,2,5,'Factura 12743 validada',NULL,NULL,7628,'facture',NULL,0),(7636,'2025-06-05 20:33:13','2025-06-05 20:33:13',1,NULL,NULL,NULL,1,-176,13.80000000,2,5,'Factura 12744 validada',NULL,NULL,7629,'facture',NULL,0),(7637,'2025-06-05 20:36:50','2025-06-05 20:36:50',5,NULL,NULL,NULL,1,-19,160.00000000,2,5,'Factura 12745 validada',NULL,NULL,7630,'facture',NULL,0),(7638,'2025-06-05 20:39:52','2025-06-05 20:39:52',1,NULL,NULL,NULL,1,-88,13.80000000,2,5,'Factura 12746 validada',NULL,NULL,7631,'facture',NULL,0),(7639,'2025-06-05 20:41:22','2025-06-05 20:41:22',1,NULL,NULL,NULL,1,-132,13.80000000,2,5,'Factura 12747 validada',NULL,NULL,7632,'facture',NULL,0),(7640,'2025-06-05 20:43:01','2025-06-05 20:43:01',1,NULL,NULL,NULL,1,-286,13.80000000,2,5,'Factura 12748 validada',NULL,NULL,7633,'facture',NULL,0),(7641,'2025-06-05 23:13:12','2025-06-05 23:13:12',7,NULL,NULL,NULL,1,-200,45.00000000,2,5,'Factura 12749 validada',NULL,NULL,7634,'facture',NULL,0),(7642,'2025-06-06 15:02:52','2025-06-06 15:02:52',7,NULL,NULL,NULL,1,-500,42.00000000,2,5,'Factura 12750 validada',NULL,NULL,7635,'facture',NULL,0),(7643,'2025-06-06 15:35:39','2025-06-06 15:35:39',13,NULL,NULL,NULL,1,-3528,71.00000000,2,5,'Factura 12751 validada',NULL,NULL,7636,'facture',NULL,0),(7644,'2025-06-06 21:39:39','2025-06-06 21:39:39',1,NULL,NULL,NULL,1,-25,42.00000000,2,5,'Factura 12752 validada',NULL,NULL,7637,'facture',NULL,0),(7645,'2025-06-06 21:53:32','2025-06-06 21:53:32',1,NULL,NULL,NULL,1,-440,14.00000000,2,5,'Factura 12753 validada',NULL,NULL,7638,'facture',NULL,0),(7646,'2025-06-09 21:24:07','2025-06-09 21:24:07',7,NULL,NULL,NULL,1,-3000,49.88000000,2,5,'Factura 12754 validada',NULL,NULL,7639,'facture',NULL,0),(7647,'2025-06-09 21:52:16','2025-06-09 21:52:16',1,NULL,NULL,NULL,1,-330,14.00000000,2,5,'Factura 12755 validada',NULL,NULL,7640,'facture',NULL,0),(7648,'2025-06-24 16:17:56','2025-06-24 16:17:56',1,NULL,NULL,NULL,1,-10,0.00000000,2,1,'Expedici&oacute;n SH2506-0002 clasificada como pagada',NULL,NULL,2,'shipping',NULL,0),(7649,'2025-06-24 16:31:15','2025-06-24 16:31:15',17,NULL,NULL,NULL,1,-17,0.00000000,2,1,'Expedici&oacute;n SH2506-0003 clasificada como pagada',NULL,NULL,3,'shipping',NULL,0),(7650,'2025-07-10 16:30:28','2025-07-10 16:30:28',57,NULL,NULL,NULL,1,-1,140.00000000,2,1,'Expedici&oacute;n SH2507-0002 clasificada como pagada',NULL,NULL,7,'shipping',NULL,0),(7651,'2025-07-10 16:31:35','2025-07-10 16:31:35',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,7,'shipping',NULL,0),(7652,'2025-07-10 18:07:41','2025-07-10 18:07:41',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,7,'shipping',NULL,0),(7653,'2025-07-10 18:08:51','2025-07-10 18:08:51',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,7,'shipping',NULL,0),(7654,'2025-07-10 18:15:25','2025-07-10 18:15:25',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,7,'shipping',NULL,0),(7655,'2025-07-10 18:16:03','2025-07-10 18:16:03',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,7,'shipping',NULL,0),(7656,'2025-07-10 18:22:33','2025-07-10 18:22:33',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,7,'shipping',NULL,0),(7657,'2025-07-10 18:22:47','2025-07-10 18:22:47',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,7,'shipping',NULL,0),(7658,'2025-07-15 22:54:45','2025-07-15 22:54:45',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,7,'shipping',NULL,0),(7659,'2025-08-01 23:17:30','2025-08-01 23:17:30',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,8,'shipping',NULL,0),(7660,'2025-08-21 22:37:06','2025-08-21 22:37:06',7,NULL,NULL,NULL,1,10,54.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,13,'shipping',NULL,0),(7661,'2025-08-21 22:37:15','2025-08-21 22:37:15',22,NULL,NULL,NULL,1,1,600.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,12,'shipping',NULL,0),(7662,'2025-09-19 21:35:21','2025-09-19 21:35:21',65,NULL,NULL,NULL,1,14000,9.50000000,3,5,'Factura SI2509-0003 validada',NULL,NULL,4,'invoice_supplier',NULL,0),(7663,'2026-04-07 16:29:45','2026-04-07 16:29:45',7,NULL,NULL,NULL,1,1,54.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,14,'shipping',NULL,0),(7664,'2026-04-07 16:29:51','2026-04-07 16:29:51',7,NULL,NULL,NULL,1,10,54.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,13,'shipping',NULL,0),(7665,'2026-04-07 16:29:57','2026-04-07 16:29:57',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,7,'shipping',NULL,0),(7666,'2026-04-07 17:20:03','2026-04-07 17:20:03',22,NULL,NULL,NULL,1,1,600.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,12,'shipping',NULL,0),(7667,'2026-04-07 17:20:29','2026-04-07 17:20:29',57,NULL,NULL,NULL,1,1,140.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,7,'shipping',NULL,0),(7668,'2026-04-07 17:20:37','2026-04-07 17:20:37',22,NULL,NULL,NULL,1,1,500.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,11,'shipping',NULL,0),(7669,'2026-04-07 18:44:27','2026-04-07 18:44:27',7,NULL,NULL,NULL,1,184411.88,0.00000000,0,1,'Correción de sotck del producto BF3KG','20260407184413',NULL,0,'',NULL,0),(7670,'2026-04-07 18:44:45','2026-04-07 18:44:45',7,NULL,NULL,NULL,2,-15506,0.00000000,1,1,'Correción de sotck del producto BF3KG','20260407184436',NULL,0,'',NULL,0),(7671,'2026-04-07 18:45:58','2026-04-07 18:45:58',7,NULL,NULL,NULL,1,750,0.00000000,0,1,'Correción de sotck del producto BF3KG','20260407184539',NULL,0,'',NULL,0),(7672,'2026-04-07 18:53:29','2026-04-07 18:53:29',8,NULL,NULL,NULL,1,1,100.00000000,3,1,'Factura SI2604-0004 validada',NULL,NULL,5,'invoice_supplier',NULL,0),(7673,'2026-04-07 18:54:05','2026-04-07 18:54:05',8,NULL,NULL,NULL,1,-1,100.00000000,2,1,'Regresar factura SI2604-0004 al estado de borrador',NULL,NULL,5,'invoice_supplier',NULL,0),(7674,'2026-04-07 18:55:52','2026-04-07 18:55:52',8,NULL,NULL,NULL,1,100,0.00000000,3,1,'Factura SI2604-0004 validada',NULL,NULL,5,'invoice_supplier',NULL,0),(7675,'2026-04-07 18:55:52','2026-04-07 18:55:52',6,NULL,NULL,NULL,1,50,0.00000000,3,1,'Factura SI2604-0004 validada',NULL,NULL,5,'invoice_supplier',NULL,0),(7676,'2026-04-07 19:01:03','2026-04-07 19:01:03',5,NULL,NULL,NULL,1,95374.0412,0.00000000,0,1,'Inventario Ajuste_07042026','INV-Ajuste_07042026',NULL,1,'inventory',NULL,0),(7677,'2026-04-13 22:04:56','2026-04-13 22:04:56',5,NULL,NULL,NULL,1,1,0.00000000,3,1,'Factura SI2604-0005 validada',NULL,NULL,6,'invoice_supplier',NULL,0),(7678,'2026-04-14 00:56:08','2026-04-14 00:56:08',7,NULL,NULL,NULL,1,10,54.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,17,'shipping',NULL,0),(7679,'2026-04-14 17:14:25','2026-04-14 17:14:25',1,NULL,NULL,NULL,1,220,30.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,16,'shipping',NULL,0),(7680,'2026-04-14 17:30:52','2026-04-14 17:30:52',1,NULL,NULL,NULL,1,220,30.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,16,'shipping',NULL,0),(7681,'2026-04-14 19:19:47','2026-04-14 19:19:47',7,NULL,NULL,NULL,1,5,54.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,15,'shipping',NULL,0),(7682,'2026-04-14 19:33:23','2026-04-14 19:33:23',7,NULL,NULL,NULL,1,10,54.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,17,'shipping',NULL,0),(7683,'2026-07-30 22:49:06','2026-07-30 22:49:06',7,NULL,NULL,NULL,1,1,54.00000000,2,1,'Env&iacute;o  clasificado como reabierto',NULL,NULL,20,'shipping',NULL,0);

--
-- Table structure for table `llx_stock_mouvement_extrafields`
--

CREATE TABLE `llx_stock_mouvement_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_stock_mouvement_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_stock_mouvement_extrafields`
--


--
-- Table structure for table `llx_subscription`
--

CREATE TABLE `llx_subscription` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_adherent` int(11) DEFAULT NULL,
  `fk_type` int(11) DEFAULT NULL,
  `dateadh` datetime DEFAULT NULL,
  `datef` datetime DEFAULT NULL,
  `subscription` double(24,8) DEFAULT NULL,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `note` text DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_subscription` (`fk_adherent`,`dateadh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_subscription`
--


--
-- Table structure for table `llx_supplier_proposal`
--

CREATE TABLE `llx_supplier_proposal` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_int` varchar(255) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_user_cloture` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT 0,
  `price` double DEFAULT 0,
  `remise_percent` double DEFAULT 0,
  `remise_absolue` double DEFAULT 0,
  `remise` double DEFAULT 0,
  `total_ht` double(24,8) DEFAULT 0.00000000,
  `total_tva` double(24,8) DEFAULT 0.00000000,
  `localtax1` double(24,8) DEFAULT 0.00000000,
  `localtax2` double(24,8) DEFAULT 0.00000000,
  `total_ttc` double(24,8) DEFAULT 0.00000000,
  `fk_account` int(11) DEFAULT NULL,
  `fk_currency` varchar(3) DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `note_private` text DEFAULT NULL,
  `note_public` text DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `date_livraison` date DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(3) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT 1.00000000,
  `multicurrency_total_ht` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_tva` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_ttc` double(24,8) DEFAULT 0.00000000,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_supplier_proposal`
--


--
-- Table structure for table `llx_supplier_proposal_extrafields`
--

CREATE TABLE `llx_supplier_proposal_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_supplier_proposal_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_supplier_proposal_extrafields`
--


--
-- Table structure for table `llx_supplier_proposaldet`
--

CREATE TABLE `llx_supplier_proposaldet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_supplier_proposal` int(11) NOT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `fk_remise_except` int(11) DEFAULT NULL,
  `vat_src_code` varchar(10) DEFAULT '',
  `tva_tx` double(7,4) DEFAULT 0.0000,
  `localtax1_tx` double(7,4) DEFAULT 0.0000,
  `localtax1_type` varchar(10) DEFAULT NULL,
  `localtax2_tx` double(7,4) DEFAULT 0.0000,
  `localtax2_type` varchar(10) DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT 0,
  `remise` double DEFAULT 0,
  `price` double DEFAULT NULL,
  `subprice` double(24,8) DEFAULT 0.00000000,
  `total_ht` double(24,8) DEFAULT 0.00000000,
  `total_tva` double(24,8) DEFAULT 0.00000000,
  `total_localtax1` double(24,8) DEFAULT 0.00000000,
  `total_localtax2` double(24,8) DEFAULT 0.00000000,
  `total_ttc` double(24,8) DEFAULT 0.00000000,
  `product_type` int(11) DEFAULT 0,
  `date_start` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `info_bits` int(11) DEFAULT 0,
  `buy_price_ht` double(24,8) DEFAULT 0.00000000,
  `fk_product_fournisseur_price` int(11) DEFAULT NULL,
  `special_code` int(11) DEFAULT 0,
  `rang` int(11) DEFAULT 0,
  `ref_fourn` varchar(30) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(3) DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_ht` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_tva` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_ttc` double(24,8) DEFAULT 0.00000000,
  `fk_unit` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_supplier_proposaldet_fk_supplier_proposal` (`fk_supplier_proposal`),
  KEY `idx_supplier_proposaldet_fk_product` (`fk_product`),
  KEY `fk_supplier_proposaldet_fk_unit` (`fk_unit`),
  CONSTRAINT `fk_supplier_proposaldet_fk_supplier_proposal` FOREIGN KEY (`fk_supplier_proposal`) REFERENCES `llx_supplier_proposal` (`rowid`),
  CONSTRAINT `fk_supplier_proposaldet_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `llx_c_units` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_supplier_proposaldet`
--


--
-- Table structure for table `llx_supplier_proposaldet_extrafields`
--

CREATE TABLE `llx_supplier_proposaldet_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_supplier_proposaldet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_supplier_proposaldet_extrafields`
--


--
-- Table structure for table `llx_takepos_floor_tables`
--

CREATE TABLE `llx_takepos_floor_tables` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `label` varchar(255) DEFAULT NULL,
  `leftpos` float DEFAULT NULL,
  `toppos` float DEFAULT NULL,
  `floor` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `entity` (`entity`,`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_takepos_floor_tables`
--


--
-- Table structure for table `llx_tva`
--

CREATE TABLE `llx_tva` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `amount` double(24,8) NOT NULL DEFAULT 0.00000000,
  `fk_typepayment` int(11) DEFAULT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `note` text DEFAULT NULL,
  `paye` smallint(6) NOT NULL DEFAULT 0,
  `fk_account` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_tva`
--


--
-- Table structure for table `llx_user`
--

CREATE TABLE `llx_user` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref_employee` varchar(50) DEFAULT NULL,
  `ref_ext` varchar(50) DEFAULT NULL,
  `admin` smallint(6) DEFAULT 0,
  `employee` tinyint(4) DEFAULT 1,
  `fk_establishment` int(11) DEFAULT 0,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `login` varchar(50) NOT NULL,
  `pass_encoding` varchar(24) DEFAULT NULL,
  `pass` varchar(128) DEFAULT NULL,
  `pass_crypted` varchar(128) DEFAULT NULL,
  `pass_temp` varchar(128) DEFAULT NULL,
  `api_key` varchar(128) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `civility` varchar(6) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(25) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `fk_state` int(11) DEFAULT 0,
  `fk_country` int(11) DEFAULT 0,
  `birth` date DEFAULT NULL,
  `job` varchar(128) DEFAULT NULL,
  `office_phone` varchar(20) DEFAULT NULL,
  `office_fax` varchar(20) DEFAULT NULL,
  `user_mobile` varchar(20) DEFAULT NULL,
  `personal_mobile` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `personal_email` varchar(255) DEFAULT NULL,
  `signature` text DEFAULT NULL,
  `socialnetworks` text DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_socpeople` int(11) DEFAULT NULL,
  `fk_member` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `fk_user_expense_validator` int(11) DEFAULT NULL,
  `fk_user_holiday_validator` int(11) DEFAULT NULL,
  `idpers1` varchar(128) DEFAULT NULL,
  `idpers2` varchar(128) DEFAULT NULL,
  `idpers3` varchar(128) DEFAULT NULL,
  `note_public` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `datelastlogin` datetime DEFAULT NULL,
  `datepreviouslogin` datetime DEFAULT NULL,
  `datelastpassvalidation` datetime DEFAULT NULL,
  `datestartvalidity` datetime DEFAULT NULL,
  `dateendvalidity` datetime DEFAULT NULL,
  `iplastlogin` varchar(250) DEFAULT NULL,
  `ippreviouslogin` varchar(250) DEFAULT NULL,
  `egroupware_id` int(11) DEFAULT NULL,
  `ldap_sid` varchar(255) DEFAULT NULL,
  `openid` varchar(255) DEFAULT NULL,
  `statut` tinyint(4) DEFAULT 1,
  `photo` varchar(255) DEFAULT NULL,
  `lang` varchar(6) DEFAULT NULL,
  `color` varchar(6) DEFAULT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT 0,
  `accountancy_code` varchar(32) DEFAULT NULL,
  `nb_holiday` int(11) DEFAULT 0,
  `thm` double(24,8) DEFAULT NULL,
  `tjm` double(24,8) DEFAULT NULL,
  `salary` double(24,8) DEFAULT NULL,
  `salaryextra` double(24,8) DEFAULT NULL,
  `dateemployment` date DEFAULT NULL,
  `dateemploymentend` date DEFAULT NULL,
  `weeklyhours` double(16,8) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `default_range` int(11) DEFAULT NULL,
  `default_c_exp_tax_cat` int(11) DEFAULT NULL,
  `national_registration_number` varchar(50) DEFAULT NULL,
  `fk_warehouse` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_login` (`login`,`entity`),
  UNIQUE KEY `uk_user_fk_socpeople` (`fk_socpeople`),
  UNIQUE KEY `uk_user_fk_member` (`fk_member`),
  UNIQUE KEY `uk_user_api_key` (`api_key`),
  KEY `idx_user_fk_societe` (`fk_soc`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_user`
--

INSERT INTO `llx_user` VALUES (1,0,'',NULL,1,1,0,'2023-02-15 20:09:45','2023-02-15 20:09:45',NULL,NULL,'admin',NULL,NULL,'$2y$10$nojtuH7OR4T1erTkuDi75e5D3KXXS.vbAMbGQbpVAqKu1n6XCSoFG',NULL,NULL,'','','SuperAdmin','','','','',NULL,NULL,NULL,'','','','','','','','','null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2026-08-05 19:51:26','2026-07-30 21:57:33',NULL,NULL,NULL,'189.196.223.134','187.190.15.233',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(3,1,'',NULL,0,1,0,'2023-04-13 22:56:29','2025-08-18 22:25:41',NULL,NULL,'apiuser',NULL,NULL,'$2y$10$xalaF.vGAXYS/Cws9DaoV.Kw//KotabhfBoR.TFUv9.XStXqYUBKq',NULL,'ne0eJRSk0EQF',NULL,'','api','apiuser','','','',NULL,NULL,NULL,'','','','','','','','','null',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,0,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(4,1,'',NULL,0,1,0,'2023-04-21 23:13:12','2026-03-20 14:03:27',NULL,NULL,'restapi',NULL,NULL,'$2y$10$DjqHLMuVZikpcoZpDTPqA.qFg4VTw0Etp/KDNesbN6kPvPJOV7wIu',NULL,'051tGEtPOvM5u45e3wL0MobAok5P8TmA',NULL,'','API','REST','','','',NULL,NULL,NULL,'','','','','','','','','null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(5,0,'',NULL,1,1,0,'2023-04-24 21:59:19','2025-08-18 22:30:29',NULL,NULL,'temo',NULL,NULL,'$2y$10$MRw2PPKyChpkEhdN3T.Ur.2cVbf7WhBMQO9LLk//Hj7uj6QyMwTjK',NULL,NULL,NULL,'','Temo','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2026-08-08 20:56:49','2026-08-05 20:17:08',NULL,NULL,NULL,'177.245.206.87','177.245.204.87',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(7,1,'',NULL,0,1,0,'2023-04-27 21:18:21','2025-08-18 22:27:50',NULL,NULL,'carbonfiro',NULL,NULL,'$2y$10$BPBnKI4NgfghwYruQCYrjOdFN4Nc7suLNVzu8ugII2lMjlLRRJK6C',NULL,NULL,NULL,'','Firo','Carbon','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2025-01-08 21:14:01','2025-01-08 20:38:54',NULL,NULL,NULL,'177.245.194.87','177.245.194.87',NULL,'',NULL,0,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(8,1,'',NULL,0,1,0,'2023-07-20 18:07:12','2025-05-17 19:47:29',NULL,NULL,'mortega',NULL,NULL,'$2y$10$U.cjxaBGOLKhfz/di5b2dupYkqPrPtfx1KrCDjzKpvU8SSoBzuI4C',NULL,NULL,NULL,'','Ortega','Manuel','','','',NULL,NULL,NULL,'','','','','','carbonfiro.almacen@gmail.com','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2024-06-14 15:41:51','2024-06-13 17:53:50',NULL,NULL,NULL,'177.245.192.207','177.245.192.207',NULL,'',NULL,0,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(9,1,'',NULL,0,1,0,'2025-05-13 20:01:56','2025-09-04 21:46:51',NULL,NULL,'emmanuel',NULL,NULL,'$2y$10$14fMD8uJoRAxuty9zXNr5.Asf34QCd2e8dGcDq2.q4SAZrJUrMfvW',NULL,NULL,NULL,'','Emmanuel','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2026-08-07 23:33:52','2026-08-04 21:42:20',NULL,NULL,NULL,'177.245.204.87','177.245.204.87',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(10,1,'',NULL,0,1,0,'2025-05-13 20:03:21','2025-08-18 22:27:50',NULL,NULL,'operaciones',NULL,NULL,'$2y$10$6AC485JreVOdDmpqK.iXw.mkatTeQYosX7nog76Hk9GAQxNBfizRO',NULL,NULL,NULL,'','Operaciones','','','','',NULL,NULL,NULL,'','','','','','','','','null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,0,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(11,1,'',NULL,1,1,0,'2025-05-13 20:11:30','2025-08-18 22:28:04',NULL,NULL,'admon',NULL,NULL,'$2y$10$Bv1jbp3B2lbJYZIAjTzGlOATXJjRB.v/hG6k91Z2DDB0OFkppuWqO',NULL,NULL,NULL,'','Admon','','','','',NULL,NULL,NULL,'','','','','','','','','null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,0,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(12,1,'',NULL,1,1,0,'2025-07-29 19:10:31','2025-08-18 22:31:37',NULL,NULL,'mabel.carbonfiro',NULL,NULL,'$2y$10$yBhzfoZx5ap1lXj92cmYe.fsrljsebOBSxPAJWsA4iUHGbkACfvn2',NULL,NULL,'woman','','Ahumada','Mabel','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2026-02-20 21:27:04','2026-02-17 20:01:23',NULL,NULL,NULL,'177.245.206.111','177.245.195.19',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(13,1,'',NULL,0,1,0,'2025-07-29 19:35:42','2025-08-18 22:27:50',NULL,NULL,'Contabilidad',NULL,NULL,'$2y$10$DHz4.ytnS5bxbtqd/MgDqey3qUbPvpQ4VeW/Q7luUMi0J2cY8nJla',NULL,NULL,'man','','Torres','Eduardo','','','',NULL,NULL,NULL,'','','','','','cpceduardo.torres@gmail.com','','','null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,0,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(14,1,'',NULL,0,1,0,'2025-08-09 16:24:39','2026-05-20 21:34:25',NULL,NULL,'ventas1',NULL,NULL,'$2y$10$FfG98LjYyxDbmVms8r7EnOqsWSH53t0RQ3j5Lhg8e61fUh.yyQ19.',NULL,NULL,NULL,'','LUIS','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2026-08-08 20:17:48','2026-08-08 19:03:25',NULL,NULL,NULL,'177.245.206.87','177.245.206.87',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(15,0,'',NULL,0,1,0,'2026-02-16 19:07:02','2026-05-20 18:10:07',NULL,NULL,'SAUL.ADMIN',NULL,NULL,'$2y$10$LUY6rb1qcuQ0m1Mv7uoYRei//WHtvKP5QapjdC0Lw71nxxJfDFXc6',NULL,NULL,'man','','DIAZ NAVA','SAUL WENCESLAO','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,12,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2026-08-08 20:00:00','2026-08-08 18:11:20',NULL,NULL,NULL,'177.245.206.87','177.245.206.87',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(17,1,'',NULL,0,1,0,'2026-07-30 22:56:20','2026-07-30 22:56:20',NULL,NULL,'isaac',NULL,NULL,'$2y$10$Pk5c2vjDRyWwtgoDc4LZ1.wbMpMVVcq44KvC96rQ4wu64d/aujq.u',NULL,NULL,NULL,'','Isaac','','','','',NULL,NULL,NULL,'','','','','','','','','null',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2026-08-04 21:46:26','2026-08-04 20:18:10',NULL,NULL,NULL,'177.245.204.87','177.245.204.87',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL);

--
-- Table structure for table `llx_user_alert`
--

CREATE TABLE `llx_user_alert` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `fk_contact` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_user_alert`
--


--
-- Table structure for table `llx_user_clicktodial`
--

CREATE TABLE `llx_user_clicktodial` (
  `fk_user` int(11) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `login` varchar(32) DEFAULT NULL,
  `pass` varchar(64) DEFAULT NULL,
  `poste` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_user_clicktodial`
--


--
-- Table structure for table `llx_user_employment`
--

CREATE TABLE `llx_user_employment` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref` varchar(50) DEFAULT NULL,
  `ref_ext` varchar(50) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `job` varchar(128) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `salary` double(24,8) DEFAULT NULL,
  `salaryextra` double(24,8) DEFAULT NULL,
  `weeklyhours` double(16,8) DEFAULT NULL,
  `dateemployment` date DEFAULT NULL,
  `dateemploymentend` date DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_employment` (`ref`,`entity`),
  KEY `fk_user_employment_fk_user` (`fk_user`),
  CONSTRAINT `fk_user_employment_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_user_employment`
--


--
-- Table structure for table `llx_user_extrafields`
--

CREATE TABLE `llx_user_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_user_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_user_extrafields`
--


--
-- Table structure for table `llx_user_param`
--

CREATE TABLE `llx_user_param` (
  `fk_user` int(11) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `param` varchar(180) NOT NULL,
  `value` text NOT NULL,
  UNIQUE KEY `uk_user_param` (`fk_user`,`param`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_user_param`
--

INSERT INTO `llx_user_param` VALUES (1,1,'MAIN_BOXES_1','1'),(1,1,'MAIN_SELECTEDFIELDS_contactlist','p.address,p.lastname,p.firstname,p.zip,p.phone,p.phone_mobile,p.email,s.nom,p.priv,p.statut,'),(1,1,'MAIN_SELECTEDFIELDS_invoicelist','f.type,f.ref,f.datef,f.date_lim_reglement,s.nom,s.name_alias,ef.fechacfdi,ef.cfdi,ef.observaciones,f.total_ht,ef.uuid,f.total_ttc,dynamount_payed,rtp,u.login,ef.foliorep,f.fk_statut,'),(1,1,'MAIN_SELECTEDFIELDS_movementlist','m.fk_user_author,m.rowid,m.datem,p.ref,e.ref,m.inventorycode,m.label,origin,m.value,'),(1,1,'MAIN_SELECTEDFIELDS_orderlist','c.note_private,c.ref,s.nom,c.date_commande,c.date_delivery,c.total_ht,u.login,shippable,c.facture,c.fk_statut,'),(1,1,'MAIN_SELECTEDFIELDS_productlist','p.tva_tx,p.ref,p.label,p.sellprice,p.minbuyprice,p.stock,p.tosell,p.tobuy,'),(1,1,'MAIN_SELECTEDFIELDS_thirdpartylist','ef.usocfdi,s.nom,s.name_alias,s.code_client,s.address,s.zip,s.phone,typent.code,customerorsupplier,ef.ultimacompra,s.datec,s.status,'),(5,1,'MAIN_BOXES_0','1'),(7,1,'MAIN_BOXES_0','1');

--
-- Table structure for table `llx_user_rib`
--

CREATE TABLE `llx_user_rib` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `label` varchar(30) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `code_banque` varchar(128) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  `bic` varchar(11) DEFAULT NULL,
  `iban_prefix` varchar(34) DEFAULT NULL,
  `domiciliation` varchar(255) DEFAULT NULL,
  `proprio` varchar(60) DEFAULT NULL,
  `owner_address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_user_rib`
--


--
-- Table structure for table `llx_user_rights`
--

CREATE TABLE `llx_user_rights` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_user` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_rights` (`entity`,`fk_user`,`fk_id`),
  KEY `fk_user_rights_fk_user_user` (`fk_user`),
  CONSTRAINT `fk_user_rights_fk_user_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=1982 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_user_rights`
--

INSERT INTO `llx_user_rights` VALUES (933,1,1,11),(934,1,1,12),(935,1,1,13),(936,1,1,14),(937,1,1,15),(938,1,1,16),(939,1,1,19),(940,1,1,21),(941,1,1,22),(942,1,1,24),(943,1,1,25),(944,1,1,26),(945,1,1,27),(946,1,1,28),(947,1,1,31),(948,1,1,32),(949,1,1,34),(950,1,1,38),(951,1,1,39),(952,1,1,61),(953,1,1,62),(954,1,1,64),(955,1,1,67),(956,1,1,68),(957,1,1,69),(958,1,1,70),(959,1,1,71),(960,1,1,72),(961,1,1,74),(962,1,1,75),(963,1,1,76),(964,1,1,78),(965,1,1,79),(966,1,1,81),(967,1,1,82),(968,1,1,84),(969,1,1,86),(970,1,1,87),(971,1,1,88),(972,1,1,89),(973,1,1,95),(974,1,1,101),(975,1,1,102),(976,1,1,104),(977,1,1,105),(978,1,1,106),(979,1,1,109),(980,1,1,111),(981,1,1,112),(982,1,1,113),(983,1,1,114),(984,1,1,115),(985,1,1,116),(986,1,1,117),(987,1,1,121),(988,1,1,122),(989,1,1,125),(990,1,1,126),(991,1,1,130),(992,1,1,241),(993,1,1,242),(994,1,1,243),(995,1,1,251),(996,1,1,252),(997,1,1,253),(998,1,1,254),(999,1,1,255),(1000,1,1,256),(1001,1,1,262),(1002,1,1,281),(1003,1,1,282),(1004,1,1,283),(1005,1,1,286),(1006,1,1,331),(1007,1,1,332),(1008,1,1,333),(1009,1,1,341),(1010,1,1,342),(1011,1,1,343),(1012,1,1,344),(1013,1,1,351),(1014,1,1,352),(1015,1,1,353),(1016,1,1,354),(1017,1,1,358),(1243,1,1,431),(1018,1,1,531),(1019,1,1,532),(1020,1,1,534),(1021,1,1,538),(1022,1,1,610),(1023,1,1,611),(1024,1,1,612),(1025,1,1,651),(1026,1,1,652),(1027,1,1,653),(1028,1,1,661),(1029,1,1,662),(1030,1,1,663),(1031,1,1,1001),(1032,1,1,1002),(1033,1,1,1003),(1034,1,1,1004),(1035,1,1,1005),(1036,1,1,1011),(1037,1,1,1012),(1038,1,1,1101),(1039,1,1,1102),(1040,1,1,1104),(1041,1,1,1109),(1042,1,1,1121),(1043,1,1,1122),(1044,1,1,1123),(1045,1,1,1124),(1046,1,1,1125),(1047,1,1,1126),(1048,1,1,1181),(1049,1,1,1182),(1050,1,1,1183),(1051,1,1,1184),(1052,1,1,1185),(1053,1,1,1186),(1054,1,1,1187),(1055,1,1,1188),(1056,1,1,1189),(1057,1,1,1191),(1058,1,1,1201),(1059,1,1,1202),(1060,1,1,1231),(1061,1,1,1232),(1062,1,1,1233),(1063,1,1,1234),(1064,1,1,1235),(1065,1,1,1236),(1066,1,1,1251),(1067,1,1,1321),(1068,1,1,1322),(1069,1,1,1421),(1822,1,1,2401),(1813,1,1,2402),(1823,1,1,2403),(1847,1,1,2411),(1838,1,1,2412),(1848,1,1,2413),(1857,1,1,2414),(1070,1,1,2610),(1071,1,1,3301),(1072,1,1,23001),(1073,1,1,23002),(1074,1,1,23003),(1075,1,1,23004),(1076,1,1,59001),(1077,1,1,59002),(1078,1,1,59003),(1079,1,1,941601),(1080,1,1,941602),(1081,1,1,941603),(1082,1,1,941604),(1083,1,1,941605),(1084,1,1,941606),(1085,1,1,900100101),(1086,1,1,900100102),(1087,1,1,900100103),(1475,1,3,11),(1476,1,3,12),(1477,1,3,13),(1478,1,3,14),(1479,1,3,15),(1480,1,3,16),(1481,1,3,19),(1473,1,3,81),(1474,1,3,82),(1472,1,3,121),(1482,1,3,1321),(1483,1,3,1322),(1651,1,4,11),(1652,1,4,12),(1653,1,4,13),(1654,1,4,14),(1655,1,4,15),(1656,1,4,16),(1657,1,4,19),(1658,1,4,21),(1659,1,4,22),(1660,1,4,24),(1661,1,4,25),(1662,1,4,26),(1663,1,4,27),(1664,1,4,28),(1665,1,4,31),(1666,1,4,32),(1667,1,4,34),(1668,1,4,38),(1669,1,4,39),(1670,1,4,61),(1671,1,4,62),(1672,1,4,64),(1673,1,4,67),(1674,1,4,68),(1675,1,4,69),(1676,1,4,70),(1677,1,4,71),(1678,1,4,72),(1679,1,4,74),(1680,1,4,75),(1681,1,4,76),(1682,1,4,78),(1683,1,4,79),(1684,1,4,81),(1685,1,4,82),(1686,1,4,84),(1687,1,4,86),(1688,1,4,87),(1689,1,4,88),(1690,1,4,89),(1691,1,4,95),(1692,1,4,101),(1693,1,4,102),(1694,1,4,104),(1695,1,4,105),(1696,1,4,106),(1697,1,4,109),(1698,1,4,111),(1699,1,4,112),(1700,1,4,113),(1701,1,4,114),(1702,1,4,115),(1703,1,4,116),(1704,1,4,117),(1705,1,4,121),(1706,1,4,122),(1707,1,4,125),(1708,1,4,126),(1709,1,4,130),(1710,1,4,241),(1711,1,4,242),(1712,1,4,243),(1713,1,4,251),(1714,1,4,252),(1715,1,4,253),(1716,1,4,254),(1717,1,4,255),(1718,1,4,256),(1719,1,4,262),(1720,1,4,281),(1721,1,4,282),(1722,1,4,283),(1723,1,4,286),(1724,1,4,331),(1725,1,4,332),(1726,1,4,333),(1727,1,4,341),(1728,1,4,342),(1729,1,4,343),(1730,1,4,344),(1731,1,4,351),(1732,1,4,352),(1733,1,4,353),(1734,1,4,354),(1735,1,4,358),(1736,1,4,431),(1737,1,4,531),(1738,1,4,532),(1739,1,4,534),(1740,1,4,538),(1741,1,4,610),(1742,1,4,611),(1743,1,4,612),(1744,1,4,651),(1745,1,4,652),(1746,1,4,653),(1747,1,4,661),(1748,1,4,662),(1749,1,4,663),(1750,1,4,1001),(1751,1,4,1002),(1752,1,4,1003),(1753,1,4,1004),(1754,1,4,1005),(1755,1,4,1011),(1756,1,4,1012),(1757,1,4,1101),(1758,1,4,1102),(1759,1,4,1104),(1760,1,4,1109),(1761,1,4,1121),(1762,1,4,1122),(1763,1,4,1123),(1764,1,4,1124),(1765,1,4,1125),(1766,1,4,1126),(1767,1,4,1181),(1768,1,4,1182),(1769,1,4,1183),(1770,1,4,1184),(1771,1,4,1185),(1772,1,4,1186),(1773,1,4,1187),(1774,1,4,1188),(1775,1,4,1189),(1776,1,4,1191),(1777,1,4,1201),(1778,1,4,1202),(1779,1,4,1231),(1780,1,4,1232),(1781,1,4,1233),(1782,1,4,1234),(1783,1,4,1235),(1784,1,4,1236),(1785,1,4,1251),(1786,1,4,1321),(1787,1,4,1322),(1788,1,4,1421),(1789,1,4,2610),(1790,1,4,3301),(1791,1,4,23001),(1792,1,4,23002),(1793,1,4,23003),(1794,1,4,23004),(1795,1,4,59001),(1796,1,4,59002),(1797,1,4,59003),(1798,1,4,941601),(1799,1,4,941602),(1800,1,4,941603),(1801,1,4,941604),(1802,1,4,941605),(1803,1,4,941606),(1804,1,4,900100101),(1805,1,4,900100102),(1806,1,4,900100103),(778,1,5,11),(779,1,5,12),(780,1,5,13),(781,1,5,14),(782,1,5,15),(783,1,5,16),(784,1,5,19),(785,1,5,21),(786,1,5,22),(787,1,5,24),(788,1,5,25),(789,1,5,26),(790,1,5,27),(791,1,5,28),(792,1,5,31),(793,1,5,32),(794,1,5,34),(795,1,5,38),(796,1,5,39),(797,1,5,61),(798,1,5,62),(799,1,5,64),(800,1,5,67),(801,1,5,68),(802,1,5,69),(803,1,5,70),(804,1,5,71),(805,1,5,72),(806,1,5,74),(807,1,5,75),(808,1,5,76),(809,1,5,78),(810,1,5,79),(811,1,5,81),(812,1,5,82),(813,1,5,84),(814,1,5,86),(815,1,5,87),(816,1,5,88),(817,1,5,89),(818,1,5,95),(819,1,5,101),(820,1,5,102),(821,1,5,104),(822,1,5,105),(823,1,5,106),(824,1,5,109),(825,1,5,111),(826,1,5,112),(827,1,5,113),(828,1,5,114),(829,1,5,115),(830,1,5,116),(831,1,5,117),(832,1,5,121),(833,1,5,122),(834,1,5,125),(835,1,5,126),(836,1,5,130),(837,1,5,241),(838,1,5,242),(839,1,5,243),(840,1,5,251),(841,1,5,252),(842,1,5,253),(843,1,5,254),(844,1,5,255),(845,1,5,256),(846,1,5,262),(847,1,5,281),(848,1,5,282),(849,1,5,283),(850,1,5,286),(851,1,5,331),(852,1,5,332),(853,1,5,333),(854,1,5,341),(855,1,5,342),(856,1,5,343),(857,1,5,344),(858,1,5,351),(859,1,5,352),(860,1,5,353),(861,1,5,354),(862,1,5,358),(1244,1,5,431),(863,1,5,531),(864,1,5,532),(865,1,5,534),(866,1,5,538),(867,1,5,610),(868,1,5,611),(869,1,5,612),(870,1,5,651),(871,1,5,652),(872,1,5,653),(873,1,5,661),(874,1,5,662),(875,1,5,663),(876,1,5,1001),(877,1,5,1002),(878,1,5,1003),(879,1,5,1004),(880,1,5,1005),(881,1,5,1011),(882,1,5,1012),(883,1,5,1101),(884,1,5,1102),(885,1,5,1104),(886,1,5,1109),(887,1,5,1121),(888,1,5,1122),(889,1,5,1123),(890,1,5,1124),(891,1,5,1125),(892,1,5,1126),(893,1,5,1181),(894,1,5,1182),(895,1,5,1183),(896,1,5,1184),(897,1,5,1185),(898,1,5,1186),(899,1,5,1187),(900,1,5,1188),(901,1,5,1189),(902,1,5,1191),(903,1,5,1201),(904,1,5,1202),(905,1,5,1231),(906,1,5,1232),(907,1,5,1233),(908,1,5,1234),(909,1,5,1235),(910,1,5,1236),(911,1,5,1251),(912,1,5,1321),(913,1,5,1322),(914,1,5,1421),(1824,1,5,2401),(1815,1,5,2402),(1825,1,5,2403),(1849,1,5,2411),(1840,1,5,2412),(1850,1,5,2413),(1858,1,5,2414),(915,1,5,2610),(916,1,5,3301),(917,1,5,23001),(918,1,5,23002),(919,1,5,23003),(920,1,5,23004),(921,1,5,59001),(922,1,5,59002),(923,1,5,59003),(924,1,5,941601),(925,1,5,941602),(926,1,5,941603),(927,1,5,941604),(928,1,5,941605),(929,1,5,941606),(930,1,5,900100101),(931,1,5,900100102),(932,1,5,900100103),(424,1,7,11),(425,1,7,12),(426,1,7,13),(427,1,7,14),(428,1,7,15),(429,1,7,16),(430,1,7,19),(433,1,7,31),(434,1,7,32),(435,1,7,34),(436,1,7,38),(437,1,7,39),(462,1,7,81),(463,1,7,82),(464,1,7,84),(465,1,7,86),(466,1,7,87),(467,1,7,88),(468,1,7,89),(438,1,7,111),(439,1,7,112),(440,1,7,113),(441,1,7,114),(442,1,7,115),(443,1,7,116),(444,1,7,117),(407,1,7,121),(408,1,7,122),(409,1,7,125),(410,1,7,126),(411,1,7,130),(412,1,7,262),(413,1,7,281),(414,1,7,282),(415,1,7,283),(416,1,7,286),(431,1,7,1321),(432,1,7,1322),(469,1,7,1421),(445,1,7,900100101),(446,1,7,900100102),(447,1,7,900100103),(471,1,8,31),(472,1,8,32),(473,1,8,34),(474,1,8,38),(475,1,8,39),(635,1,8,121),(636,1,8,122),(637,1,8,125),(638,1,8,126),(639,1,8,130),(640,1,8,262),(641,1,8,281),(642,1,8,282),(643,1,8,283),(644,1,8,286),(523,1,8,331),(524,1,8,332),(525,1,8,333),(470,1,8,343),(483,1,8,651),(484,1,8,652),(485,1,8,653),(486,1,8,661),(487,1,8,662),(488,1,8,663),(476,1,8,1001),(477,1,8,1002),(478,1,8,1003),(479,1,8,1004),(480,1,8,1005),(481,1,8,1011),(482,1,8,1012),(629,1,8,1121),(630,1,8,1122),(631,1,8,1123),(632,1,8,1124),(633,1,8,1125),(634,1,8,1126),(613,1,8,1181),(614,1,8,1182),(615,1,8,1183),(616,1,8,1184),(617,1,8,1185),(618,1,8,1186),(619,1,8,1187),(620,1,8,1188),(621,1,8,1189),(622,1,8,1191),(623,1,8,1231),(624,1,8,1232),(625,1,8,1233),(626,1,8,1234),(627,1,8,1235),(628,1,8,1236),(1492,1,9,11),(1493,1,9,12),(1494,1,9,13),(1495,1,9,14),(1496,1,9,15),(1497,1,9,16),(1498,1,9,19),(685,1,9,31),(686,1,9,32),(687,1,9,34),(688,1,9,38),(689,1,9,39),(674,1,9,81),(675,1,9,82),(676,1,9,84),(677,1,9,86),(678,1,9,87),(679,1,9,88),(680,1,9,89),(1508,1,9,101),(1509,1,9,102),(1510,1,9,104),(1511,1,9,105),(1512,1,9,106),(1513,1,9,109),(657,1,9,121),(658,1,9,122),(659,1,9,125),(660,1,9,126),(661,1,9,130),(682,1,9,241),(683,1,9,242),(684,1,9,243),(662,1,9,262),(663,1,9,281),(664,1,9,282),(665,1,9,283),(666,1,9,286),(1524,1,9,331),(1525,1,9,332),(1526,1,9,333),(690,1,9,531),(691,1,9,532),(692,1,9,534),(693,1,9,538),(1501,1,9,1001),(1502,1,9,1002),(1503,1,9,1003),(1504,1,9,1004),(1505,1,9,1005),(1506,1,9,1011),(1507,1,9,1012),(1514,1,9,1101),(1515,1,9,1102),(1516,1,9,1104),(1517,1,9,1109),(1499,1,9,1321),(1500,1,9,1322),(681,1,9,1421),(1518,1,9,941601),(1519,1,9,941602),(1520,1,9,941603),(1521,1,9,941604),(1522,1,9,941605),(1523,1,9,941606),(719,1,10,11),(720,1,10,12),(721,1,10,13),(722,1,10,14),(723,1,10,15),(724,1,10,16),(725,1,10,19),(704,1,10,21),(705,1,10,22),(706,1,10,24),(707,1,10,25),(708,1,10,26),(709,1,10,27),(710,1,10,28),(747,1,10,31),(748,1,10,32),(749,1,10,34),(750,1,10,38),(751,1,10,39),(711,1,10,81),(712,1,10,82),(713,1,10,84),(714,1,10,86),(715,1,10,87),(716,1,10,88),(717,1,10,89),(694,1,10,121),(695,1,10,122),(696,1,10,125),(697,1,10,126),(698,1,10,130),(744,1,10,241),(745,1,10,242),(746,1,10,243),(699,1,10,262),(700,1,10,281),(701,1,10,282),(702,1,10,283),(703,1,10,286),(775,1,10,331),(776,1,10,332),(777,1,10,333),(752,1,10,531),(753,1,10,532),(754,1,10,534),(755,1,10,538),(762,1,10,1001),(763,1,10,1002),(764,1,10,1003),(765,1,10,1004),(766,1,10,1005),(767,1,10,1011),(768,1,10,1012),(756,1,10,1121),(757,1,10,1122),(758,1,10,1123),(759,1,10,1124),(760,1,10,1125),(761,1,10,1126),(728,1,10,1181),(729,1,10,1182),(730,1,10,1183),(731,1,10,1184),(732,1,10,1185),(733,1,10,1186),(734,1,10,1187),(735,1,10,1188),(736,1,10,1189),(737,1,10,1191),(738,1,10,1231),(739,1,10,1232),(740,1,10,1233),(741,1,10,1234),(742,1,10,1235),(743,1,10,1236),(726,1,10,1321),(727,1,10,1322),(718,1,10,1421),(769,1,10,941601),(770,1,10,941602),(771,1,10,941603),(772,1,10,941604),(773,1,10,941605),(774,1,10,941606),(1088,1,11,11),(1089,1,11,12),(1090,1,11,13),(1091,1,11,14),(1092,1,11,15),(1093,1,11,16),(1094,1,11,19),(1095,1,11,21),(1096,1,11,22),(1097,1,11,24),(1098,1,11,25),(1099,1,11,26),(1100,1,11,27),(1101,1,11,28),(1102,1,11,31),(1103,1,11,32),(1104,1,11,34),(1105,1,11,38),(1106,1,11,39),(1107,1,11,61),(1108,1,11,62),(1109,1,11,64),(1110,1,11,67),(1111,1,11,68),(1112,1,11,69),(1113,1,11,70),(1114,1,11,71),(1115,1,11,72),(1116,1,11,74),(1117,1,11,75),(1118,1,11,76),(1119,1,11,78),(1120,1,11,79),(1121,1,11,81),(1122,1,11,82),(1123,1,11,84),(1124,1,11,86),(1125,1,11,87),(1126,1,11,88),(1127,1,11,89),(1128,1,11,95),(1129,1,11,101),(1130,1,11,102),(1131,1,11,104),(1132,1,11,105),(1133,1,11,106),(1134,1,11,109),(1135,1,11,111),(1136,1,11,112),(1137,1,11,113),(1138,1,11,114),(1139,1,11,115),(1140,1,11,116),(1141,1,11,117),(1142,1,11,121),(1143,1,11,122),(1144,1,11,125),(1145,1,11,126),(1146,1,11,130),(1147,1,11,241),(1148,1,11,242),(1149,1,11,243),(1150,1,11,251),(1151,1,11,252),(1152,1,11,253),(1153,1,11,254),(1154,1,11,255),(1155,1,11,256),(1156,1,11,262),(1157,1,11,281),(1158,1,11,282),(1159,1,11,283),(1160,1,11,286),(1161,1,11,331),(1162,1,11,332),(1163,1,11,333),(1164,1,11,341),(1165,1,11,342),(1166,1,11,343),(1167,1,11,344),(1168,1,11,351),(1169,1,11,352),(1170,1,11,353),(1171,1,11,354),(1172,1,11,358),(1245,1,11,431),(1173,1,11,531),(1174,1,11,532),(1175,1,11,534),(1176,1,11,538),(1177,1,11,610),(1178,1,11,611),(1179,1,11,612),(1180,1,11,651),(1181,1,11,652),(1182,1,11,653),(1183,1,11,661),(1184,1,11,662),(1185,1,11,663),(1186,1,11,1001),(1187,1,11,1002),(1188,1,11,1003),(1189,1,11,1004),(1190,1,11,1005),(1191,1,11,1011),(1192,1,11,1012),(1193,1,11,1101),(1194,1,11,1102),(1195,1,11,1104),(1196,1,11,1109),(1197,1,11,1121),(1198,1,11,1122),(1199,1,11,1123),(1200,1,11,1124),(1201,1,11,1125),(1202,1,11,1126),(1203,1,11,1181),(1204,1,11,1182),(1205,1,11,1183),(1206,1,11,1184),(1207,1,11,1185),(1208,1,11,1186),(1209,1,11,1187),(1210,1,11,1188),(1211,1,11,1189),(1212,1,11,1191),(1213,1,11,1201),(1214,1,11,1202),(1215,1,11,1231),(1216,1,11,1232),(1217,1,11,1233),(1218,1,11,1234),(1219,1,11,1235),(1220,1,11,1236),(1221,1,11,1251),(1222,1,11,1321),(1223,1,11,1322),(1224,1,11,1421),(1826,1,11,2401),(1817,1,11,2402),(1827,1,11,2403),(1851,1,11,2411),(1842,1,11,2412),(1852,1,11,2413),(1859,1,11,2414),(1225,1,11,2610),(1226,1,11,3301),(1227,1,11,23001),(1228,1,11,23002),(1229,1,11,23003),(1230,1,11,23004),(1231,1,11,59001),(1232,1,11,59002),(1233,1,11,59003),(1234,1,11,941601),(1235,1,11,941602),(1236,1,11,941603),(1237,1,11,941604),(1238,1,11,941605),(1239,1,11,941606),(1240,1,11,900100101),(1241,1,11,900100102),(1242,1,11,900100103),(1247,1,12,11),(1248,1,12,12),(1249,1,12,13),(1250,1,12,14),(1251,1,12,15),(1252,1,12,16),(1253,1,12,19),(1254,1,12,21),(1255,1,12,22),(1256,1,12,24),(1257,1,12,25),(1258,1,12,26),(1259,1,12,27),(1260,1,12,28),(1261,1,12,31),(1262,1,12,32),(1263,1,12,34),(1264,1,12,38),(1265,1,12,39),(1266,1,12,61),(1267,1,12,62),(1268,1,12,64),(1269,1,12,67),(1270,1,12,68),(1271,1,12,69),(1272,1,12,70),(1273,1,12,71),(1274,1,12,72),(1275,1,12,74),(1276,1,12,75),(1277,1,12,76),(1278,1,12,78),(1279,1,12,79),(1280,1,12,81),(1281,1,12,82),(1282,1,12,84),(1283,1,12,86),(1284,1,12,87),(1285,1,12,88),(1286,1,12,89),(1287,1,12,95),(1288,1,12,101),(1289,1,12,102),(1290,1,12,104),(1291,1,12,105),(1292,1,12,106),(1293,1,12,109),(1294,1,12,111),(1295,1,12,112),(1296,1,12,113),(1297,1,12,114),(1298,1,12,115),(1299,1,12,116),(1300,1,12,117),(1301,1,12,121),(1302,1,12,122),(1303,1,12,125),(1304,1,12,126),(1305,1,12,130),(1306,1,12,241),(1307,1,12,242),(1308,1,12,243),(1309,1,12,251),(1310,1,12,252),(1311,1,12,253),(1312,1,12,254),(1313,1,12,255),(1314,1,12,256),(1315,1,12,262),(1316,1,12,281),(1317,1,12,282),(1318,1,12,283),(1319,1,12,286),(1320,1,12,331),(1321,1,12,332),(1322,1,12,333),(1323,1,12,341),(1324,1,12,342),(1325,1,12,343),(1326,1,12,344),(1327,1,12,351),(1328,1,12,352),(1329,1,12,353),(1330,1,12,354),(1331,1,12,358),(1332,1,12,431),(1333,1,12,531),(1334,1,12,532),(1335,1,12,534),(1336,1,12,538),(1337,1,12,610),(1338,1,12,611),(1339,1,12,612),(1340,1,12,651),(1341,1,12,652),(1342,1,12,653),(1343,1,12,661),(1344,1,12,662),(1345,1,12,663),(1346,1,12,1001),(1347,1,12,1002),(1348,1,12,1003),(1349,1,12,1004),(1350,1,12,1005),(1351,1,12,1011),(1352,1,12,1012),(1353,1,12,1101),(1354,1,12,1102),(1355,1,12,1104),(1356,1,12,1109),(1357,1,12,1121),(1358,1,12,1122),(1359,1,12,1123),(1360,1,12,1124),(1361,1,12,1125),(1362,1,12,1126),(1363,1,12,1181),(1364,1,12,1182),(1365,1,12,1183),(1366,1,12,1184),(1367,1,12,1185),(1368,1,12,1186),(1369,1,12,1187),(1370,1,12,1188),(1371,1,12,1189),(1372,1,12,1191),(1373,1,12,1201),(1374,1,12,1202),(1375,1,12,1231),(1376,1,12,1232),(1377,1,12,1233),(1378,1,12,1234),(1379,1,12,1235),(1380,1,12,1236),(1381,1,12,1251),(1382,1,12,1321),(1383,1,12,1322),(1384,1,12,1421),(1828,1,12,2401),(1819,1,12,2402),(1829,1,12,2403),(1853,1,12,2411),(1844,1,12,2412),(1854,1,12,2413),(1860,1,12,2414),(1385,1,12,2610),(1386,1,12,3301),(1387,1,12,23001),(1388,1,12,23002),(1389,1,12,23003),(1390,1,12,23004),(1391,1,12,59001),(1392,1,12,59002),(1393,1,12,59003),(1394,1,12,941601),(1395,1,12,941602),(1396,1,12,941603),(1397,1,12,941604),(1398,1,12,941605),(1399,1,12,941606),(1400,1,12,900100101),(1401,1,12,900100102),(1402,1,12,900100103),(1404,1,13,11),(1405,1,13,12),(1406,1,13,13),(1407,1,13,14),(1408,1,13,15),(1409,1,13,16),(1410,1,13,19),(1411,1,13,1321),(1412,1,13,1322),(1414,1,14,11),(1415,1,14,12),(1416,1,14,13),(1417,1,14,14),(1418,1,14,15),(1419,1,14,16),(1420,1,14,19),(1451,1,14,31),(1452,1,14,32),(1453,1,14,34),(1454,1,14,38),(1455,1,14,39),(1484,1,14,81),(1485,1,14,82),(1486,1,14,84),(1487,1,14,86),(1488,1,14,87),(1489,1,14,88),(1490,1,14,89),(1441,1,14,121),(1442,1,14,122),(1443,1,14,125),(1444,1,14,126),(1445,1,14,130),(1871,1,14,241),(1446,1,14,262),(1447,1,14,281),(1448,1,14,282),(1449,1,14,283),(1450,1,14,286),(1463,1,14,610),(1464,1,14,611),(1465,1,14,612),(1466,1,14,651),(1467,1,14,652),(1468,1,14,653),(1469,1,14,661),(1470,1,14,662),(1471,1,14,663),(1456,1,14,1001),(1457,1,14,1002),(1458,1,14,1003),(1459,1,14,1004),(1460,1,14,1005),(1461,1,14,1011),(1462,1,14,1012),(1421,1,14,1321),(1422,1,14,1322),(1491,1,14,1421),(1423,1,14,900100101),(1424,1,14,900100102),(1425,1,14,900100103),(1562,1,15,11),(1563,1,15,12),(1564,1,15,13),(1565,1,15,14),(1566,1,15,15),(1567,1,15,16),(1568,1,15,19),(1547,1,15,21),(1548,1,15,22),(1549,1,15,24),(1550,1,15,25),(1551,1,15,26),(1552,1,15,27),(1553,1,15,28),(1590,1,15,31),(1591,1,15,32),(1592,1,15,34),(1593,1,15,38),(1594,1,15,39),(1628,1,15,61),(1629,1,15,62),(1630,1,15,64),(1631,1,15,67),(1632,1,15,68),(1633,1,15,69),(1634,1,15,70),(1535,1,15,71),(1536,1,15,72),(1531,1,15,75),(1532,1,15,76),(1533,1,15,78),(1534,1,15,79),(1554,1,15,81),(1555,1,15,82),(1556,1,15,84),(1557,1,15,86),(1558,1,15,87),(1559,1,15,88),(1560,1,15,89),(1650,1,15,95),(1612,1,15,101),(1613,1,15,102),(1614,1,15,104),(1615,1,15,105),(1616,1,15,106),(1617,1,15,109),(1639,1,15,111),(1640,1,15,112),(1641,1,15,113),(1642,1,15,114),(1643,1,15,115),(1644,1,15,116),(1645,1,15,117),(1537,1,15,121),(1538,1,15,122),(1539,1,15,125),(1540,1,15,126),(1541,1,15,130),(1587,1,15,241),(1588,1,15,242),(1589,1,15,243),(1867,1,15,251),(1864,1,15,253),(1866,1,15,255),(1868,1,15,256),(1542,1,15,262),(1543,1,15,281),(1544,1,15,282),(1545,1,15,283),(1546,1,15,286),(1869,1,15,342),(1870,1,15,343),(1595,1,15,531),(1596,1,15,532),(1597,1,15,534),(1598,1,15,538),(1605,1,15,1001),(1608,1,15,1004),(1609,1,15,1005),(1610,1,15,1011),(1611,1,15,1012),(1618,1,15,1101),(1619,1,15,1102),(1620,1,15,1104),(1621,1,15,1109),(1599,1,15,1121),(1600,1,15,1122),(1601,1,15,1123),(1602,1,15,1124),(1603,1,15,1125),(1604,1,15,1126),(1571,1,15,1181),(1572,1,15,1182),(1573,1,15,1183),(1574,1,15,1184),(1575,1,15,1185),(1576,1,15,1186),(1577,1,15,1187),(1578,1,15,1188),(1579,1,15,1189),(1580,1,15,1191),(1581,1,15,1231),(1582,1,15,1232),(1583,1,15,1233),(1584,1,15,1234),(1585,1,15,1235),(1586,1,15,1236),(1569,1,15,1321),(1570,1,15,1322),(1561,1,15,1421),(1830,1,15,2401),(1821,1,15,2402),(1831,1,15,2403),(1855,1,15,2411),(1846,1,15,2412),(1856,1,15,2413),(1861,1,15,2414),(1635,1,15,23001),(1636,1,15,23002),(1637,1,15,23003),(1638,1,15,23004),(1622,1,15,941601),(1623,1,15,941602),(1624,1,15,941603),(1625,1,15,941604),(1626,1,15,941605),(1627,1,15,941606),(1899,1,17,11),(1900,1,17,12),(1901,1,17,13),(1902,1,17,14),(1903,1,17,15),(1904,1,17,16),(1905,1,17,19),(1884,1,17,21),(1885,1,17,22),(1886,1,17,24),(1887,1,17,25),(1888,1,17,26),(1889,1,17,27),(1890,1,17,28),(1934,1,17,31),(1935,1,17,32),(1936,1,17,34),(1937,1,17,38),(1938,1,17,39),(1972,1,17,61),(1973,1,17,62),(1974,1,17,64),(1975,1,17,67),(1976,1,17,68),(1977,1,17,69),(1978,1,17,70),(1891,1,17,81),(1892,1,17,82),(1893,1,17,84),(1894,1,17,86),(1895,1,17,87),(1896,1,17,88),(1897,1,17,89),(1956,1,17,101),(1957,1,17,102),(1958,1,17,104),(1959,1,17,105),(1960,1,17,106),(1961,1,17,109),(1874,1,17,121),(1875,1,17,122),(1876,1,17,125),(1877,1,17,126),(1878,1,17,130),(1931,1,17,241),(1932,1,17,242),(1933,1,17,243),(1879,1,17,262),(1880,1,17,281),(1881,1,17,282),(1882,1,17,283),(1883,1,17,286),(1979,1,17,331),(1980,1,17,332),(1981,1,17,333),(1873,1,17,431),(1939,1,17,531),(1940,1,17,532),(1941,1,17,534),(1942,1,17,538),(1949,1,17,1001),(1950,1,17,1002),(1951,1,17,1003),(1952,1,17,1004),(1953,1,17,1005),(1954,1,17,1011),(1955,1,17,1012),(1962,1,17,1101),(1963,1,17,1102),(1964,1,17,1104),(1965,1,17,1109),(1943,1,17,1121),(1944,1,17,1122),(1945,1,17,1123),(1946,1,17,1124),(1947,1,17,1125),(1948,1,17,1126),(1908,1,17,1181),(1909,1,17,1182),(1910,1,17,1183),(1911,1,17,1184),(1912,1,17,1185),(1913,1,17,1186),(1914,1,17,1187),(1915,1,17,1188),(1916,1,17,1189),(1917,1,17,1191),(1918,1,17,1231),(1919,1,17,1232),(1920,1,17,1233),(1921,1,17,1234),(1922,1,17,1235),(1923,1,17,1236),(1906,1,17,1321),(1907,1,17,1322),(1898,1,17,1421),(1924,1,17,2401),(1925,1,17,2402),(1926,1,17,2403),(1927,1,17,2411),(1928,1,17,2412),(1929,1,17,2413),(1930,1,17,2414),(1966,1,17,941601),(1967,1,17,941602),(1968,1,17,941603),(1969,1,17,941604),(1970,1,17,941605),(1971,1,17,941606);

--
-- Table structure for table `llx_usergroup`
--

CREATE TABLE `llx_usergroup` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(180) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `note` text DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_name` (`nom`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_usergroup`
--


--
-- Table structure for table `llx_usergroup_extrafields`
--

CREATE TABLE `llx_usergroup_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_usergroup_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_usergroup_extrafields`
--


--
-- Table structure for table `llx_usergroup_rights`
--

CREATE TABLE `llx_usergroup_rights` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_usergroup` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_rights` (`entity`,`fk_usergroup`,`fk_id`),
  KEY `fk_usergroup_rights_fk_usergroup` (`fk_usergroup`),
  CONSTRAINT `fk_usergroup_rights_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `llx_usergroup` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_usergroup_rights`
--


--
-- Table structure for table `llx_usergroup_user`
--

CREATE TABLE `llx_usergroup_user` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_user` int(11) NOT NULL,
  `fk_usergroup` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_user` (`entity`,`fk_user`,`fk_usergroup`),
  KEY `fk_usergroup_user_fk_user` (`fk_user`),
  KEY `fk_usergroup_user_fk_usergroup` (`fk_usergroup`),
  CONSTRAINT `fk_usergroup_user_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_usergroup_user_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `llx_usergroup` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_usergroup_user`
--



