(7349,'2025-04-04 17:45:07','2025-04-04 17:45:07',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12516 validada',NULL,NULL,7393,'facture',NULL,0),(7350,'2025-04-04 17:49:07','2025-04-04 17:49:07',1,NULL,NULL,NULL,1,-66,15.00000000,2,5,'Factura 12517 validada',NULL,NULL,7394,'facture',NULL,0),(7351,'2025-04-04 18:13:46','2025-04-04 18:13:46',1,NULL,NULL,NULL,1,-242,18.00000000,2,5,'Factura 12518 validada',NULL,NULL,7395,'facture',NULL,0),(7352,'2025-04-04 18:15:24','2025-04-04 18:15:24',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12519 validada',NULL,NULL,7396,'facture',NULL,0),(7353,'2025-04-05 16:29:53','2025-04-05 16:29:53',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12520 validada',NULL,NULL,7397,'facture',NULL,0),(7354,'2025-04-07 11:02:23','2025-04-07 11:02:23',7,NULL,NULL,NULL,1,-1100,49.88000000,2,5,'Factura 12521 validada',NULL,NULL,7398,'facture',NULL,0),(7355,'2025-04-07 19:58:51','2025-04-07 19:58:51',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12522 validada',NULL,NULL,7399,'facture',NULL,0),(7356,'2025-04-07 21:09:04','2025-04-07 21:09:04',1,NULL,NULL,NULL,1,-1205.4,13.00000000,2,5,'Factura 12523 validada',NULL,NULL,7400,'facture',NULL,0),(7357,'2025-04-07 21:34:25','2025-04-07 21:34:25',1,NULL,NULL,NULL,1,-506,16.00000000,2,5,'Factura 12524 validada',NULL,NULL,7401,'facture',NULL,0),(7358,'2025-04-07 22:16:37','2025-04-07 22:16:37',1,NULL,NULL,NULL,1,-176,18.00000000,2,5,'Factura 12525 validada',NULL,NULL,7402,'facture',NULL,0),(7359,'2025-04-07 22:20:01','2025-04-07 22:20:01',1,NULL,NULL,NULL,1,-440,15.00000000,2,5,'Factura 12526 validada',NULL,NULL,7403,'facture',NULL,0),(7360,'2025-04-07 22:22:06','2025-04-07 22:22:06',18,NULL,NULL,NULL,1,-440,16.00000000,2,5,'Factura 12527 validada',NULL,NULL,7404,'facture',NULL,0),(7361,'2025-04-07 22:47:39','2025-04-07 22:47:39',1,NULL,NULL,NULL,1,-176,18.00000000,2,5,'Factura 12528 validada',NULL,NULL,7405,'facture',NULL,0),(7362,'2025-04-08 15:43:08','2025-04-08 15:43:08',1,NULL,NULL,NULL,1,440,0.00000000,3,5,'Regresar factura 12513 al estado de borrador',NULL,NULL,7390,'facture',NULL,0),(7363,'2025-04-08 18:47:24','2025-04-08 18:47:24',1,NULL,NULL,NULL,1,-330,14.50000000,2,5,'Factura 12529 validada',NULL,NULL,7406,'facture',NULL,0),(7364,'2025-04-09 16:59:06','2025-04-09 16:59:06',1,NULL,NULL,NULL,1,-1100,14.50000000,2,5,'Factura 12530 validada',NULL,NULL,7407,'facture',NULL,0),(7365,'2025-04-09 19:35:04','2025-04-09 19:35:04',1,NULL,NULL,NULL,1,-220,14.50000000,2,5,'Factura 12531 validada',NULL,NULL,7408,'facture',NULL,0),(7366,'2025-04-09 22:38:23','2025-04-09 22:38:23',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12532 validada',NULL,NULL,7409,'facture',NULL,0),(7367,'2025-04-09 22:38:23','2025-04-09 22:38:23',5,NULL,NULL,NULL,1,-500.2,8.00000000,2,5,'Factura 12532 validada',NULL,NULL,7409,'facture',NULL,0),(7368,'2025-04-09 22:40:16','2025-04-09 22:40:16',1,NULL,NULL,NULL,1,-330,17.00000000,2,5,'Factura 12533 validada',NULL,NULL,7410,'facture',NULL,0),(7369,'2025-04-09 22:40:16','2025-04-09 22:40:16',5,NULL,NULL,NULL,1,-500.2,8.00000000,2,5,'Factura 12533 validada',NULL,NULL,7410,'facture',NULL,0),(7372,'2025-04-10 15:24:23','2025-04-10 15:24:23',1,NULL,NULL,NULL,1,-110,14.50000000,2,5,'Factura 12534 validada',NULL,NULL,7412,'facture',NULL,0),(7373,'2025-04-10 15:24:23','2025-04-10 15:24:23',5,NULL,NULL,NULL,1,-15,160.00000000,2,5,'Factura 12534 validada',NULL,NULL,7412,'facture',NULL,0),(7374,'2025-04-10 15:25:50','2025-04-10 15:25:50',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12535 validada',NULL,NULL,7413,'facture',NULL,0),(7375,'2025-04-10 15:32:45','2025-04-10 15:32:45',1,NULL,NULL,NULL,1,-396,15.00000000,2,5,'Factura 12536 validada',NULL,NULL,7414,'facture',NULL,0),(7376,'2025-04-10 15:35:47','2025-04-10 15:35:47',1,NULL,NULL,NULL,1,-220,15.00000000,2,5,'Factura 12537 validada',NULL,NULL,7415,'facture',NULL,0),(7377,'2025-04-10 15:38:08','2025-04-10 15:38:08',1,NULL,NULL,NULL,1,-880,14.50000000,2,5,'Factura 12538 validada',NULL,NULL,7416,'facture',NULL,0),(7378,'2025-04-10 15:41:55','2025-04-10 15:41:55',1,NULL,NULL,NULL,1,-66,15.00000000,2,5,'Factura 12539 validada',NULL,NULL,7417,'facture',NULL,0),(7379,'2025-04-10 15:45:02','2025-04-10 15:45:02',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12540 validada',NULL,NULL,7418,'facture',NULL,0),(7380,'2025-04-10 15:48:24','2025-04-10 15:48:24',1,NULL,NULL,NULL,1,-330,18.00000000,2,5,'Factura 12541 validada',NULL,NULL,7419,'facture',NULL,0),(7381,'2025-04-10 15:56:31','2025-04-10 15:56:31',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12542 validada',NULL,NULL,7420,'facture',NULL,0),(7382,'2025-04-10 15:58:03','2025-04-10 15:58:03',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12543 validada',NULL,NULL,7421,'facture',NULL,0),(7383,'2025-04-11 14:48:33','2025-04-11 14:48:33',1,NULL,NULL,NULL,1,-682,14.50000000,2,5,'Factura 12544 validada',NULL,NULL,7424,'facture',NULL,0),(7384,'2025-04-12 01:47:09','2025-04-12 01:47:09',1,NULL,NULL,NULL,1,-330,14.50000000,2,5,'Factura 12545 validada',NULL,NULL,7425,'facture',NULL,0),(7385,'2025-04-12 18:01:28','2025-04-12 18:01:28',1,NULL,NULL,NULL,1,-880,14.50000000,2,5,'Factura 12546 validada',NULL,NULL,7422,'facture',NULL,0),(7386,'2025-04-12 18:57:12','2025-04-12 18:57:12',1,NULL,NULL,NULL,1,-330,14.50000000,2,5,'Factura 12547 validada',NULL,NULL,7426,'facture',NULL,0),(7387,'2025-04-14 17:07:47','2025-04-14 17:07:47',13,NULL,NULL,NULL,1,-3087,71.00000000,2,5,'Factura 12548 validada',NULL,NULL,7428,'facture',NULL,0),(7388,'2025-04-14 17:09:37','2025-04-14 17:09:37',7,NULL,NULL,NULL,1,-30000,2.50000000,2,5,'Factura 12549 validada',NULL,NULL,7427,'facture',NULL,0),(7389,'2025-04-14 18:36:01','2025-04-14 18:36:01',55,NULL,NULL,NULL,1,-30000,2.50000000,2,5,'Factura 12550 validada',NULL,NULL,7429,'facture',NULL,0),(7390,'2025-04-14 18:58:35','2025-04-14 18:58:35',1,NULL,NULL,NULL,1,-1320,14.50000000,2,5,'Factura 12551 validada',NULL,NULL,7430,'facture',NULL,0),(7391,'2025-04-14 19:03:47','2025-04-14 19:03:47',1,NULL,NULL,NULL,1,-18,330.00000000,2,5,'Factura 12552 validada',NULL,NULL,7431,'facture',NULL,0),(7392,'2025-04-14 19:12:34','2025-04-14 19:12:34',1,NULL,NULL,NULL,1,-660,14.50000000,2,5,'Factura 12553 validada',NULL,NULL,7432,'facture',NULL,0),(7397,'2025-04-14 19:19:44','2025-04-14 19:19:44',1,NULL,NULL,NULL,1,-660,15.00000000,2,5,'Factura 12554 validada',NULL,NULL,7433,'facture',NULL,0),(7398,'2025-04-14 19:19:44','2025-04-14 19:19:44',5,NULL,NULL,NULL,1,-20,160.00000000,2,5,'Factura 12554 validada',NULL,NULL,7433,'facture',NULL,0),(7399,'2025-04-14 19:23:04','2025-04-14 19:23:04',1,NULL,NULL,NULL,1,-66,18.00000000,2,5,'Factura 12555 validada',NULL,NULL,7434,'facture',NULL,0),(7400,'2025-04-14 19:25:46','2025-04-14 19:25:46',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12556 validada',NULL,NULL,7435,'facture',NULL,0),(7401,'2025-04-14 19:28:17','2025-04-14 19:28:17',1,NULL,NULL,NULL,1,-220,18.00000000,2,5,'Factura 12557 validada',NULL,NULL,7436,'facture',NULL,0),(7402,'2025-04-14 19:41:07','2025-04-14 19:41:07',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12558 validada',NULL,NULL,7437,'facture',NULL,0),(7403,'2025-04-14 19:45:16','2025-04-14 19:45:16',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12559 validada',NULL,NULL,7438,'facture',NULL,0),(7404,'2025-04-14 19:48:24','2025-04-14 19:48:24',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12560 validada',NULL,NULL,7439,'facture',NULL,0),(7407,'2025-04-15 21:53:00','2025-04-15 21:53:00',7,NULL,NULL,NULL,1,-1000,54.00000000,2,5,'Factura 12561 validada',NULL,NULL,7440,'facture',NULL,0),(7408,'2025-04-15 21:53:00','2025-04-15 21:53:00',56,NULL,NULL,NULL,1,-1,950.00000000,2,5,'Factura 12561 validada',NULL,NULL,7440,'facture',NULL,0),(7409,'2025-04-16 18:20:46','2025-04-16 18:20:46',1,NULL,NULL,NULL,1,-330,15.00000000,2,5,'Factura 12562 validada',NULL,NULL,7441,'facture',NULL,0),(7410,'2025-04-16 18:23:25','2025-04-16 18:23:25',1,NULL,NULL,NULL,1,-220,14.50000000,2,5,'Factura 12563 validada',NULL,NULL,7442,'facture',NULL,0),(7411,'2025-04-21 17:21:34','2025-04-21 17:21:34',1,NULL,NULL,NULL,1,-660,15.00000000,2,5,'Factura 12564 validada',NULL,NULL,7444,'facture',NULL,0),(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);

--
-- 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=14 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,'2025-07-30 21:27:07','2025-07-30 21:17:03',NULL,NULL,NULL,'187.189.102.220','189.203.103.242',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','2023-04-13 22:56:29',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,1,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','2025-05-17 19:47:48',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,0,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-07-29 19:12:49',NULL,NULL,'temo',NULL,NULL,'$2y$10$OkIAMxo9mKCIyG19Y7H84e7xqZMbLNyXIe5gvLuLf2GrBRwju6Uvi',NULL,NULL,NULL,'','Temo','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2025-07-30 22:16:48','2025-07-30 20:46:53',NULL,NULL,NULL,'177.245.193.159','177.245.193.159',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','2023-10-02 17:58:44',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,1,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-05-13 20:01:56',NULL,NULL,'ventas',NULL,NULL,'$2y$10$KnnPpRhoHWc4CNt5OWm4XOuJlakwJOTKFmlb4quDEqHcIpNfFPF7W',NULL,NULL,NULL,'','Ventas','','','','',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),(10,1,'',NULL,0,1,0,'2025-05-13 20:03:21','2025-05-13 20:03:21',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,1,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-05-13 20:11:30',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,1,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-07-29 19:10:31',NULL,NULL,'mabel.carbonfiro',NULL,NULL,'$2y$10$Rple6fRGsuksKqCJ/CbIV.Cg1SlrG60mIdegTfEASJpFeoFgLJkAi',NULL,NULL,'woman','','Ahumada','Mabel','','','',NULL,NULL,NULL,'','','','','','','','','null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2025-07-31 05:33:30','2025-07-31 02:13:56',NULL,NULL,NULL,'177.249.168.238','177.249.168.238',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-07-29 19:35:42',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,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_invoicelist','ef.foliorep,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,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.finished,p.ref,p.label,p.sellprice,p.minbuyprice,p.desiredstock,p.stock,stock_virtual,ef.claveprodserv,ef.umed,ef.observacionesproduct,p.tosell,p.tobuy,'),(1,1,'MAIN_SELECTEDFIELDS_thirdpartylist','s.nom,s.name_alias,s.code_client,s.address,s.zip,s.phone,typent.code,customerorsupplier,s.datec,s.status,'),(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=1413 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),(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),(89,1,3,11),(90,1,3,12),(91,1,3,13),(92,1,3,14),(93,1,3,15),(94,1,3,16),(95,1,3,19),(96,1,3,31),(97,1,3,32),(98,1,3,34),(99,1,3,38),(100,1,3,39),(101,1,3,71),(102,1,3,72),(103,1,3,74),(104,1,3,75),(105,1,3,76),(106,1,3,78),(107,1,3,79),(108,1,3,81),(109,1,3,82),(110,1,3,84),(111,1,3,86),(112,1,3,87),(113,1,3,88),(114,1,3,89),(115,1,3,121),(116,1,3,122),(117,1,3,125),(118,1,3,126),(119,1,3,130),(120,1,3,251),(121,1,3,252),(122,1,3,253),(123,1,3,254),(124,1,3,255),(125,1,3,256),(126,1,3,262),(127,1,3,281),(128,1,3,282),(129,1,3,283),(130,1,3,286),(131,1,3,341),(132,1,3,342),(133,1,3,343),(134,1,3,344),(135,1,3,351),(136,1,3,352),(137,1,3,353),(138,1,3,354),(139,1,3,358),(140,1,3,1181),(141,1,3,1182),(142,1,3,1183),(143,1,3,1184),(144,1,3,1185),(145,1,3,1186),(146,1,3,1187),(147,1,3,1188),(148,1,3,1189),(149,1,3,1191),(150,1,3,1201),(151,1,3,1202),(152,1,3,1231),(153,1,3,1232),(154,1,3,1233),(155,1,3,1234),(156,1,3,1235),(157,1,3,1236),(158,1,3,1251),(159,1,3,1321),(160,1,3,1322),(161,1,3,1421),(176,1,4,11),(177,1,4,12),(178,1,4,13),(179,1,4,14),(180,1,4,15),(181,1,4,16),(182,1,4,19),(183,1,4,31),(184,1,4,32),(185,1,4,34),(186,1,4,38),(187,1,4,39),(188,1,4,71),(189,1,4,72),(190,1,4,74),(191,1,4,75),(192,1,4,76),(193,1,4,78),(194,1,4,79),(195,1,4,81),(196,1,4,82),(197,1,4,84),(198,1,4,86),(199,1,4,87),(200,1,4,88),(201,1,4,89),(202,1,4,111),(203,1,4,112),(204,1,4,113),(205,1,4,114),(206,1,4,115),(207,1,4,116),(208,1,4,117),(209,1,4,121),(210,1,4,122),(211,1,4,125),(212,1,4,126),(213,1,4,130),(214,1,4,251),(215,1,4,252),(216,1,4,253),(217,1,4,254),(218,1,4,255),(219,1,4,256),(220,1,4,262),(221,1,4,281),(222,1,4,282),(223,1,4,283),(224,1,4,286),(225,1,4,341),(226,1,4,342),(227,1,4,343),(228,1,4,344),(229,1,4,351),(230,1,4,352),(231,1,4,353),(232,1,4,354),(233,1,4,358),(234,1,4,1181),(235,1,4,1182),(236,1,4,1183),(237,1,4,1184),(238,1,4,1185),(239,1,4,1186),(240,1,4,1187),(241,1,4,1188),(242,1,4,1189),(243,1,4,1191),(244,1,4,1201),(245,1,4,1202),(246,1,4,1231),(247,1,4,1232),(248,1,4,1233),(249,1,4,1234),(250,1,4,1235),(251,1,4,1236),(252,1,4,1251),(253,1,4,1321),(254,1,4,1322),(255,1,4,1421),(256,1,4,2610),(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),(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),(667,1,9,21),(668,1,9,22),(669,1,9,24),(670,1,9,25),(671,1,9,26),(672,1,9,27),(673,1,9,28),(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),(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),(690,1,9,531),(691,1,9,532),(692,1,9,534),(693,1,9,538),(681,1,9,1421),(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),(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),(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),(1403,1,13,431),(1411,1,13,1321),(1412,1,13,1322);

--
-- 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`
--



