
--
-- 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=9 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-03-13 02:59:43','2025-03-04 21:24:35',NULL,NULL,NULL,'177.248.46.59','189.203.106.253',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','2023-04-21 23:13:13',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','2023-10-02 17:58:38',NULL,NULL,'temo',NULL,NULL,'$2y$10$jCCbpuRAqoN9/1ABr491SezgvIo1CGxeg9YKb383f/qWgZ.1uAYre',NULL,NULL,NULL,'','Temo','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2025-03-13 19:51:38','2025-03-13 17:26:08',NULL,NULL,NULL,'172.225.103.56','104.28.50.32',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','2024-02-20 17:43:15',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,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','f.fk_cond_reglement,f.ref,f.datef,f.date_lim_reglement,s.nom,s.name_alias,s.zip,ef.fechacfdi,ef.cfdi,ef.observaciones,f.total_ht,ef.usocfdi,ef.formapagocfdi,ef.formapago,ef.estatuscancelacion,ef.uuid,f.total_ttc,dynamount_payed,rtp,u.login,ef.motivocancelacion,ef.foliosustitucion,ef.fechacancelacion,ef.estatusuuid,ef.rep,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_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.siren,s.nom,s.name_alias,s.code_client,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=645 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `llx_user_rights` VALUES (69,1,1,11),(63,1,1,12),(64,1,1,13),(65,1,1,14),(66,1,1,15),(68,1,1,16),(70,1,1,19),(280,1,1,21),(274,1,1,22),(275,1,1,24),(276,1,1,25),(277,1,1,26),(279,1,1,27),(281,1,1,28),(8,1,1,31),(3,1,1,32),(5,1,1,34),(7,1,1,38),(9,1,1,39),(602,1,1,61),(595,1,1,62),(599,1,1,64),(603,1,1,67),(606,1,1,68),(608,1,1,69),(610,1,1,70),(84,1,1,71),(79,1,1,72),(81,1,1,74),(85,1,1,75),(83,1,1,76),(87,1,1,78),(88,1,1,79),(33,1,1,81),(28,1,1,82),(29,1,1,84),(30,1,1,86),(31,1,1,87),(32,1,1,88),(34,1,1,89),(576,1,1,101),(567,1,1,102),(570,1,1,104),(572,1,1,105),(574,1,1,106),(577,1,1,109),(174,1,1,111),(165,1,1,112),(167,1,1,113),(169,1,1,114),(171,1,1,115),(173,1,1,116),(175,1,1,117),(15,1,1,121),(12,1,1,122),(14,1,1,125),(16,1,1,126),(17,1,1,130),(18,1,1,262),(24,1,1,281),(21,1,1,282),(23,1,1,283),(25,1,1,286),(495,1,1,331),(492,1,1,332),(496,1,1,333),(509,1,1,531),(502,1,1,532),(506,1,1,534),(510,1,1,538),(519,1,1,610),(516,1,1,611),(520,1,1,612),(285,1,1,651),(284,1,1,652),(286,1,1,653),(290,1,1,661),(289,1,1,662),(291,1,1,663),(261,1,1,1001),(260,1,1,1002),(262,1,1,1003),(264,1,1,1004),(265,1,1,1005),(267,1,1,1011),(268,1,1,1012),(588,1,1,1101),(583,1,1,1102),(586,1,1,1104),(589,1,1,1109),(544,1,1,1121),(529,1,1,1122),(533,1,1,1123),(537,1,1,1124),(541,1,1,1125),(545,1,1,1126),(36,1,1,1181),(50,1,1,1182),(39,1,1,1183),(40,1,1,1184),(42,1,1,1185),(44,1,1,1186),(46,1,1,1187),(49,1,1,1188),(47,1,1,1189),(51,1,1,1191),(75,1,1,1201),(76,1,1,1202),(59,1,1,1231),(54,1,1,1232),(55,1,1,1233),(57,1,1,1234),(58,1,1,1235),(60,1,1,1236),(73,1,1,1251),(71,1,1,1321),(72,1,1,1322),(35,1,1,1421),(162,1,1,2610),(257,1,1,3301),(458,1,1,23001),(451,1,1,23002),(455,1,1,23003),(459,1,1,23004),(269,1,1,59001),(270,1,1,59002),(271,1,1,59003),(560,1,1,941601),(551,1,1,941602),(554,1,1,941603),(556,1,1,941604),(558,1,1,941605),(561,1,1,941606),(403,1,1,900100101),(400,1,1,900100102),(404,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),(292,1,5,11),(293,1,5,12),(294,1,5,13),(295,1,5,14),(296,1,5,15),(297,1,5,16),(298,1,5,19),(299,1,5,21),(300,1,5,22),(301,1,5,24),(302,1,5,25),(303,1,5,26),(304,1,5,27),(305,1,5,28),(306,1,5,31),(307,1,5,32),(308,1,5,34),(309,1,5,38),(310,1,5,39),(604,1,5,61),(597,1,5,62),(601,1,5,64),(605,1,5,67),(607,1,5,68),(609,1,5,69),(611,1,5,70),(311,1,5,71),(312,1,5,72),(313,1,5,74),(314,1,5,75),(315,1,5,76),(316,1,5,78),(317,1,5,79),(318,1,5,81),(319,1,5,82),(320,1,5,84),(321,1,5,86),(322,1,5,87),(323,1,5,88),(324,1,5,89),(578,1,5,101),(569,1,5,102),(571,1,5,104),(573,1,5,105),(575,1,5,106),(579,1,5,109),(325,1,5,111),(326,1,5,112),(327,1,5,113),(328,1,5,114),(329,1,5,115),(330,1,5,116),(331,1,5,117),(332,1,5,121),(333,1,5,122),(334,1,5,125),(335,1,5,126),(336,1,5,130),(337,1,5,251),(338,1,5,252),(339,1,5,253),(340,1,5,254),(341,1,5,255),(342,1,5,256),(343,1,5,262),(344,1,5,281),(345,1,5,282),(346,1,5,283),(347,1,5,286),(497,1,5,331),(494,1,5,332),(498,1,5,333),(348,1,5,341),(349,1,5,342),(350,1,5,343),(351,1,5,344),(352,1,5,351),(353,1,5,352),(354,1,5,353),(355,1,5,354),(356,1,5,358),(511,1,5,531),(504,1,5,532),(508,1,5,534),(512,1,5,538),(521,1,5,610),(518,1,5,611),(522,1,5,612),(357,1,5,651),(358,1,5,652),(359,1,5,653),(360,1,5,661),(361,1,5,662),(362,1,5,663),(363,1,5,1001),(364,1,5,1002),(365,1,5,1003),(366,1,5,1004),(367,1,5,1005),(368,1,5,1011),(369,1,5,1012),(590,1,5,1101),(585,1,5,1102),(587,1,5,1104),(591,1,5,1109),(546,1,5,1121),(531,1,5,1122),(535,1,5,1123),(539,1,5,1124),(543,1,5,1125),(547,1,5,1126),(370,1,5,1181),(371,1,5,1182),(372,1,5,1183),(373,1,5,1184),(374,1,5,1185),(375,1,5,1186),(376,1,5,1187),(377,1,5,1188),(378,1,5,1189),(379,1,5,1191),(380,1,5,1201),(381,1,5,1202),(382,1,5,1231),(383,1,5,1232),(384,1,5,1233),(385,1,5,1234),(386,1,5,1235),(387,1,5,1236),(388,1,5,1251),(389,1,5,1321),(390,1,5,1322),(391,1,5,1421),(392,1,5,2610),(393,1,5,3301),(460,1,5,23001),(453,1,5,23002),(457,1,5,23003),(461,1,5,23004),(394,1,5,59001),(395,1,5,59002),(396,1,5,59003),(562,1,5,941601),(553,1,5,941602),(555,1,5,941603),(557,1,5,941604),(559,1,5,941605),(563,1,5,941606),(405,1,5,900100101),(402,1,5,900100102),(406,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);

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



