-- Table structure for table `llx_societe_prices`
--

CREATE TABLE `llx_societe_prices` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT 0,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `price_level` tinyint(4) DEFAULT 1,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_prices`
--


--
-- Table structure for table `llx_societe_remise`
--

CREATE TABLE `llx_societe_remise` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_soc` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `remise_client` double(6,3) NOT NULL DEFAULT 0.000,
  `note` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_remise`
--


--
-- Table structure for table `llx_societe_remise_except`
--

CREATE TABLE `llx_societe_remise_except` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_soc` int(11) NOT NULL,
  `discount_type` int(11) NOT NULL DEFAULT 0,
  `datec` datetime DEFAULT NULL,
  `amount_ht` double(24,8) NOT NULL,
  `amount_tva` double(24,8) NOT NULL DEFAULT 0.00000000,
  `amount_ttc` double(24,8) NOT NULL DEFAULT 0.00000000,
  `tva_tx` double(6,3) NOT NULL DEFAULT 0.000,
  `vat_src_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT '',
  `fk_user` int(11) NOT NULL,
  `fk_facture_line` int(11) DEFAULT NULL,
  `fk_facture` int(11) DEFAULT NULL,
  `fk_facture_source` int(11) DEFAULT NULL,
  `fk_invoice_supplier_line` int(11) DEFAULT NULL,
  `fk_invoice_supplier` int(11) DEFAULT NULL,
  `fk_invoice_supplier_source` int(11) DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `multicurrency_amount_ht` double(24,8) NOT NULL DEFAULT 0.00000000,
  `multicurrency_amount_tva` double(24,8) NOT NULL DEFAULT 0.00000000,
  `multicurrency_amount_ttc` double(24,8) NOT NULL DEFAULT 0.00000000,
  PRIMARY KEY (`rowid`),
  KEY `idx_societe_remise_except_fk_user` (`fk_user`),
  KEY `idx_societe_remise_except_fk_soc` (`fk_soc`),
  KEY `idx_societe_remise_except_fk_facture_line` (`fk_facture_line`),
  KEY `idx_societe_remise_except_fk_facture` (`fk_facture`),
  KEY `idx_societe_remise_except_fk_facture_source` (`fk_facture_source`),
  KEY `idx_societe_remise_except_discount_type` (`discount_type`),
  KEY `fk_soc_remise_fk_invoice_supplier_line` (`fk_invoice_supplier_line`),
  KEY `fk_societe_remise_fk_invoice_supplier_source` (`fk_invoice_supplier`),
  CONSTRAINT `fk_soc_remise_fk_facture_line` FOREIGN KEY (`fk_facture_line`) REFERENCES `llx_facturedet` (`rowid`),
  CONSTRAINT `fk_soc_remise_fk_invoice_supplier_line` FOREIGN KEY (`fk_invoice_supplier_line`) REFERENCES `llx_facture_fourn_det` (`rowid`),
  CONSTRAINT `fk_soc_remise_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `llx_facture` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_facture_source` FOREIGN KEY (`fk_facture_source`) REFERENCES `llx_facture` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_invoice_supplier` FOREIGN KEY (`fk_invoice_supplier`) REFERENCES `llx_facture_fourn` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_invoice_supplier_source` FOREIGN KEY (`fk_invoice_supplier`) REFERENCES `llx_facture_fourn` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_remise_except`
--


--
-- Table structure for table `llx_societe_remise_supplier`
--

CREATE TABLE `llx_societe_remise_supplier` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_soc` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `remise_supplier` double(6,3) NOT NULL DEFAULT 0.000,
  `note` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_remise_supplier`
--


--
-- Table structure for table `llx_societe_rib`
--

CREATE TABLE `llx_societe_rib` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ban',
  `label` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_soc` int(11) NOT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_banque` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_guichet` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cle_rib` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bic` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iban_prefix` varchar(34) COLLATE utf8_unicode_ci DEFAULT NULL,
  `domiciliation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `proprio` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `owner_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_rib` smallint(6) NOT NULL DEFAULT 0,
  `rum` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_rum` date DEFAULT NULL,
  `frstrecur` varchar(16) COLLATE utf8_unicode_ci DEFAULT 'FRST',
  `last_four` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cvn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `exp_date_month` int(11) DEFAULT NULL,
  `exp_date_year` int(11) DEFAULT NULL,
  `country_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `approved` int(11) DEFAULT 0,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ending_date` date DEFAULT NULL,
  `max_total_amount_of_all_payments` double(24,8) DEFAULT NULL,
  `preapproval_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `starting_date` date DEFAULT NULL,
  `total_amount_of_all_payments` double(24,8) DEFAULT NULL,
  `stripe_card_ref` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stripe_account` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ipaddress` varchar(68) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_rib` (`label`,`fk_soc`),
  KEY `llx_societe_rib_fk_societe` (`fk_soc`),
  CONSTRAINT `llx_societe_rib_fk_societe` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_rib`
--


--
-- Table structure for table `llx_socpeople`
--

CREATE TABLE `llx_socpeople` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_soc` int(11) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref_ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `civility` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `firstname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `town` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_departement` int(11) DEFAULT NULL,
  `fk_pays` int(11) DEFAULT 0,
  `birthday` date DEFAULT NULL,
  `poste` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_perso` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_mobile` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `socialnetworks` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `jabberid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `linkedin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `snapchat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `googleplus` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `youtube` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `whatsapp` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_email` smallint(6) NOT NULL DEFAULT 0,
  `priv` smallint(6) NOT NULL DEFAULT 0,
  `fk_prospectcontactlevel` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_stcommcontact` int(11) NOT NULL DEFAULT 0,
  `fk_user_creat` int(11) DEFAULT 0,
  `fk_user_modif` int(11) DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_public` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_lang` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `canvas` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `statut` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`rowid`),
  KEY `idx_socpeople_fk_soc` (`fk_soc`),
  KEY `idx_socpeople_fk_user_creat` (`fk_user_creat`),
  CONSTRAINT `fk_socpeople_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_socpeople_user_creat_user_rowid` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=11944 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_socpeople`
--

INSERT INTO `llx_socpeople` VALUES (11943,'2021-08-04 09:13:02','2021-08-04 09:16:11',20854,1,'','MME','DUPONT','Nathalie','','','',NULL,1,NULL,'DIRIG','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,'',0,210,210,'','',NULL,NULL,NULL,1);

--
-- Table structure for table `llx_socpeople_extrafields`
--

CREATE TABLE `llx_socpeople_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `newsletter` int(1) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_socpeople_extrafields` (`fk_object`)
) ENGINE=InnoDB AUTO_INCREMENT=9368 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_socpeople_extrafields`
--

INSERT INTO `llx_socpeople_extrafields` VALUES (9367,'2021-08-04 09:16:11',11943,NULL,1);

--
-- Table structure for table `llx_stock_mouvement`
--

CREATE TABLE `llx_stock_mouvement` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datem` datetime DEFAULT NULL,
  `fk_product` int(11) NOT NULL,
  `batch` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `eatby` date DEFAULT NULL,
  `sellby` date DEFAULT NULL,
  `fk_entrepot` int(11) NOT NULL,
  `value` double DEFAULT NULL,
  `price` double(24,8) DEFAULT 0.00000000,
  `type_mouvement` smallint(6) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `inventorycode` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_project` int(11) DEFAULT NULL,
  `fk_origin` int(11) DEFAULT NULL,
  `origintype` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_projet` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`rowid`),
  KEY `idx_stock_mouvement_fk_product` (`fk_product`),
  KEY `idx_stock_mouvement_fk_entrepot` (`fk_entrepot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_stock_mouvement`
--


--
-- 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 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_subscription` (`fk_adherent`,`dateadh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_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) COLLATE utf8_unicode_ci NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref_ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_int` varchar(255) COLLATE utf8_unicode_ci 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,
  `tva` double(24,8) DEFAULT 0.00000000,
  `localtax1` double(24,8) DEFAULT 0.00000000,
  `localtax2` double(24,8) DEFAULT 0.00000000,
  `total` double(24,8) DEFAULT 0.00000000,
  `fk_account` int(11) DEFAULT NULL,
  `fk_currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_public` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_main_doc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_livraison` date DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci 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=utf8 COLLATE=utf8_unicode_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_remise_except` int(11) DEFAULT NULL,
  `vat_src_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT '',
  `tva_tx` double(6,3) DEFAULT 0.000,
  `localtax1_tx` double(6,3) DEFAULT 0.000,
  `localtax1_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT 0.000,
  `localtax2_type` varchar(10) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci 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=utf8 COLLATE=utf8_unicode_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `leftpos` float DEFAULT NULL,
  `toppos` float DEFAULT NULL,
  `floor` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `llx_ticket`
--

CREATE TABLE `llx_ticket` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT 1,
  `ref` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `track_id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `fk_soc` int(11) DEFAULT 0,
  `fk_project` int(11) DEFAULT 0,
  `origin_email` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_create` int(11) DEFAULT NULL,
  `fk_user_assign` int(11) DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_statut` int(11) DEFAULT NULL,
  `resolution` int(11) DEFAULT NULL,
  `progress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `timing` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type_code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `severity_code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `date_read` datetime DEFAULT NULL,
  `date_close` datetime DEFAULT NULL,
  `notify_tiers_at_create` tinyint(4) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email_msgid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_ticket_track_id` (`track_id`),
  UNIQUE KEY `uk_ticket_ref` (`ref`,`entity`),
  KEY `idx_ticket_entity` (`entity`),
  KEY `idx_ticket_fk_soc` (`fk_soc`),
  KEY `idx_ticket_fk_user_assign` (`fk_user_assign`),
  KEY `idx_ticket_fk_project` (`fk_project`),
  KEY `idx_ticket_fk_statut` (`fk_statut`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_ticket`
--


--
-- Table structure for table `llx_ticket_extrafields`
--

CREATE TABLE `llx_ticket_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_ticket_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_ticket_extrafields`
--


--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `note` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_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_ext` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_int` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `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) COLLATE utf8_unicode_ci NOT NULL,
  `pass_encoding` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass_crypted` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass_temp` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `api_key` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gender` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `civility` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `firstname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `town` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_state` int(11) DEFAULT 0,
  `fk_country` int(11) DEFAULT 0,
  `birth` date DEFAULT NULL,
  `job` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `office_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `office_fax` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_mobile` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `personal_mobile` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `personal_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `socialnetworks` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `signature` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin` smallint(6) DEFAULT 0,
  `module_comm` smallint(6) DEFAULT 1,
  `module_compta` smallint(6) DEFAULT 1,
  `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,
  `note_public` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datelastlogin` datetime DEFAULT NULL,
  `datepreviouslogin` datetime DEFAULT NULL,
  `iplastlogin` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ippreviouslogin` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `egroupware_id` int(11) DEFAULT NULL,
  `ldap_sid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `statut` tinyint(4) DEFAULT 1,
  `photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lang` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `color` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `barcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT 0,
  `accountancy_code` varchar(32) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_range` int(11) DEFAULT NULL,
  `default_c_exp_tax_cat` int(11) DEFAULT NULL,
  `fk_warehouse` int(11) DEFAULT NULL,
  `datelastpassvalidation` datetime DEFAULT NULL,
  `datestartvalidity` datetime DEFAULT NULL,
  `dateendvalidity` datetime DEFAULT NULL,
  `idpers1` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idpers2` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idpers3` varchar(128) COLLATE utf8_unicode_ci 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=313 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_user` VALUES (1,0,NULL,NULL,1,0,'2021-01-26 15:23:12','2021-01-26 15:23:12',NULL,NULL,'superadmin',NULL,NULL,'$2y$10$Sefyld/DmUBQUuPBd5GDuOGdSvYLJe4qRjh2yb46IeaZSmO7dU2E.',NULL,NULL,'',NULL,'SuperAdmin','','','','',NULL,NULL,NULL,'','','','','','','','null','',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-08-18 09:43:33','2021-08-13 11:36:50',NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,NULL,NULL,1,0,'2021-03-04 14:02:14','2021-05-25 09:39:07',NULL,NULL,'yconstant@paie-rh.com',NULL,NULL,'$2y$10$2FSK.4RvcYMN7rDh8uo/2.jTfUVjybYEmba8ga4.nFhTJbITdcs5a',NULL,'48gd71cx','man','','CONSTANT','Yann','','','',NULL,NULL,NULL,'','','','','','','','[]','',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-08-18 07:12:26','2021-08-17 12:07:14',NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,1,NULL,NULL,1,0,'2021-04-16 08:59:08','2021-04-16 15:06:58',NULL,NULL,'mdotto@paie-rh.com',NULL,NULL,'$2y$10$/LRXmEH1oOgHBldNkYwblekFsIpGTNPqbzyUcGG44zVoyyOft7C/6',NULL,'wbrmzfj9','woman',NULL,'DOTTO','Manon','','','',NULL,NULL,NULL,'','0559303032','','','','MDOTTO@paie-rh.com','','[]','',0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-04-16 15:06:10',NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,NULL,NULL,1,0,'2021-04-16 09:00:07','2021-05-25 09:39:26',NULL,NULL,'ndupont@paie-rh.com',NULL,NULL,'$2y$10$bw47Ent6Zvd8AHMGhqozx.WD3JHTKsPbyIWVEyAaRhDDO9o8OFI1S',NULL,'3c86qrbv','woman','','DUPONT','Nathalie','','','',NULL,NULL,NULL,'','','','','','NDUPONT@paie-rh.com','','[]','',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-07-20 13:36:59','2021-07-20 10:13:25',NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,0,NULL,NULL,1,0,'2021-04-16 09:01:46','2021-07-29 08:29:06',NULL,NULL,'aquetu@paie-rh.com',NULL,NULL,'$2y$10$FKnG2faTQZ40BXvfGwBeM.8fL4Cncl1dWrdZzzcfDWZvpR35vFZgC',NULL,'r2803vng','man','','QUETU','Alexandre','12 rue Gambetta','64000','PAU',71,1,'1976-05-23','Communication / Marketing','+33(0)5 59 30 07 77','','+33(0)7 78 32 12 97','','aquetu@paie-rh.com','','[]','',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-07-29 12:11:09','2021-07-29 08:28:11',NULL,NULL,NULL,'',NULL,1,'aquetu_round.png',NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,'2021-04-01',NULL,40.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(136,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'adelmas',NULL,NULL,NULL,NULL,NULL,'','','DELMAS','Adrien','','','SAINT PIERRE DU MONT',NULL,NULL,NULL,'Gestionnaire de paie','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(137,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'apereira',NULL,NULL,NULL,NULL,NULL,'','','PEREIRA-OLIVIER','Alexandra','','','PAU',NULL,NULL,NULL,'','0547413252','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(138,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-07-30 07:00:12',NULL,NULL,'aquetu',NULL,NULL,NULL,NULL,NULL,'','','QUETU','Alexandre','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-08-06 13:00:23','2021-08-05 09:02:13',NULL,NULL,NULL,'',NULL,1,'aquetu_round.png',NULL,'008d96',NULL,0,'',0,NULL,NULL,NULL,NULL,'2021-04-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(139,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'amondin',NULL,NULL,NULL,NULL,NULL,'','','MONDIN','Aline','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(141,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'arebillart',NULL,NULL,NULL,NULL,NULL,'','','REBILLART','Amélie','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(142,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'aclaude',NULL,NULL,NULL,NULL,NULL,'','','CLAUDE','Audrey','','','',NULL,NULL,NULL,'','0547413227','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(143,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'ahernandez',NULL,NULL,NULL,NULL,NULL,'','','HERNANDEZ','Audrey','','','PAU',NULL,NULL,NULL,'','0559300777','','','','','','[]','',0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-07-29 09:57:54','2021-07-29 09:16:27',NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(144,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'aclarens',NULL,NULL,NULL,NULL,NULL,'','','CLARENS','Aurélie','','','PAU',NULL,NULL,NULL,'','0547413093','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(145,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'bcosse',NULL,NULL,NULL,NULL,NULL,'','','COSSÉ','Bastien','','','PAU',NULL,NULL,NULL,'','0547413204','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(146,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'bmartin',NULL,NULL,NULL,NULL,NULL,'','','MARTIN','Bastien','','','BEGLES',NULL,NULL,NULL,'Gestionnaire de paie','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(147,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-04-29 11:34:27',NULL,NULL,'cbourdil',NULL,NULL,NULL,NULL,NULL,'',NULL,'BOURDIL','Camille','','','PAU',NULL,NULL,NULL,'','05 47 41 32 26','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(148,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'cmutti',NULL,NULL,NULL,NULL,NULL,'','','MUTTI','Camille','','','BORDEAUX',NULL,NULL,NULL,'Gestionnaire de paie','0547413237','','','','','','[]','',0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-08-02 08:22:31','2021-07-30 14:19:02',NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(149,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'csalinas',NULL,NULL,NULL,NULL,NULL,'','','SALINAS','Camille','','','PAU',NULL,NULL,NULL,'','0547413250','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(150,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'cthoreau',NULL,NULL,NULL,NULL,NULL,'','','THOREAU','Cassandra','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(151,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'CD',NULL,NULL,NULL,NULL,NULL,'','','DUMORA','Catherine','','','PAU',NULL,NULL,NULL,'','0559302526','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(152,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'claborde',NULL,NULL,NULL,NULL,NULL,'','','LABORDE','Charlène','','','PAU',NULL,NULL,NULL,'','0547413200','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(153,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'cguicharnaud',NULL,NULL,NULL,NULL,NULL,'','','GUICHARNAUD','Chloé','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(154,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'cchaboche',NULL,NULL,NULL,NULL,NULL,'','','CHABOCHE','Christel','','','Mont de Marsan',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(155,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'ccazenave',NULL,NULL,NULL,NULL,NULL,'','','CAZENAVE','Claire','','','PAU',NULL,NULL,NULL,'','0547413204','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(156,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'cprex',NULL,NULL,NULL,NULL,NULL,'','','PREX','Coralie','','','PAU',NULL,NULL,NULL,'','0547413167','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(157,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'cblandamour',NULL,NULL,NULL,NULL,NULL,'','','BLANDAMOUR','Cédric','','','PAU',NULL,NULL,NULL,'','0547413174','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(158,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'cmonnier',NULL,NULL,NULL,NULL,NULL,'','','MONNIER','Céline','','','PAU',NULL,NULL,NULL,'','05 47 41 30 96','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(159,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'dtonelli',NULL,NULL,NULL,NULL,NULL,'','','TONELLI','Damien','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(160,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'drecksiedler',NULL,NULL,NULL,NULL,NULL,'','','RECKSIEDLER','Daniela','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(161,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'demoprh',NULL,NULL,NULL,NULL,NULL,'','','PRH','Demo','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(162,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'eeymery',NULL,NULL,NULL,NULL,NULL,'','','EYMERY','Eloise','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(163,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'ecampistron',NULL,NULL,NULL,NULL,NULL,'','','CAMPISTRON','Emilie','','','PAU',NULL,NULL,NULL,'','0547413075','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(164,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'elabatsabay',NULL,NULL,NULL,NULL,NULL,'','','LABAT SABAY','Emma','','','PAU',NULL,NULL,NULL,'','0547413202','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(165,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'fmargalejo',NULL,NULL,NULL,NULL,NULL,'','','MARGALEJO','Fanny','','','PAU',NULL,NULL,NULL,'','0547413225','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(166,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'fdestampa',NULL,NULL,NULL,NULL,NULL,'','','DE STAMPA','Florent','','','PAU',NULL,NULL,NULL,'','0559309409','','0607563608','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(167,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'ftodeschini',NULL,NULL,NULL,NULL,NULL,'','','TODESCHINI','Floriane','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(168,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'fnussli',NULL,NULL,NULL,NULL,NULL,'','','NUSSLI','Franck','','','PAU',NULL,NULL,NULL,'','','','0648666856','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(169,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'gtremblay',NULL,NULL,NULL,NULL,NULL,'','','TREMBLAY','Gabriel','','','PAU',NULL,NULL,NULL,'','0547413240','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(170,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'gdupouy',NULL,NULL,NULL,NULL,NULL,'','','DUPOUY','Guillaume','','','PAU',NULL,NULL,NULL,'','05 47 41 32 47','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(171,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'gernest',NULL,NULL,NULL,NULL,NULL,'','','ERNEST','Géraldine','','','Mont de Marsan',NULL,NULL,NULL,'','0547413170','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(172,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'hlassalle',NULL,NULL,NULL,NULL,NULL,'','','LASSALLE','Hugo','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(173,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'ijacquot',NULL,NULL,NULL,NULL,NULL,'','','JACQUOT','Isabelle','','','PAU',NULL,NULL,NULL,'','0547413176','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(174,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'isutter',NULL,NULL,NULL,NULL,NULL,'','','SUTTER','Isabelle','','','BEGLES',NULL,NULL,NULL,'Gestionnaire de paie','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(175,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'ibranger',NULL,NULL,NULL,NULL,NULL,'','','BRANGER','Iñaki','','','PAU',NULL,NULL,NULL,'','0547413206','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(176,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'jpsomprou',NULL,NULL,NULL,NULL,NULL,'','','SOMPROU','Jean Pierrre','','','PAU',NULL,NULL,NULL,'','0547413072','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(177,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'jpdefoort',NULL,NULL,NULL,NULL,NULL,'','','DEFOORT','Jean-Paul','','','',NULL,NULL,NULL,'','05 47 41 32 07','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(178,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'jtoulouse',NULL,NULL,NULL,NULL,NULL,'','','TOULOUSE','Jennifer','','','PAU',NULL,NULL,NULL,'','0547413074','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(179,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'jblanco',NULL,NULL,NULL,NULL,NULL,'','','BLANCO','Jessica','','','PAU',NULL,NULL,NULL,'','0547413203','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(180,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'jdestampa',NULL,NULL,NULL,NULL,NULL,'','','DE STAMPA','Joelle','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(181,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'jbrowang',NULL,NULL,NULL,NULL,NULL,'','','BROWANG','Julien','','','Mont de Marsan',NULL,NULL,NULL,'','0559307787','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(182,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'juridique',NULL,NULL,NULL,NULL,NULL,'','','','Juridique','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(183,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'ksauvestre',NULL,NULL,NULL,NULL,NULL,'','','SAUVESTRE','Karine','','','Mont de Marsan',NULL,NULL,NULL,'','0547413233','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(184,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'kepinat',NULL,NULL,NULL,NULL,NULL,'','','EPINAT','Kathleen','','','Mont de Marsan',NULL,NULL,NULL,'','0547413175','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(185,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'ldossantos',NULL,NULL,NULL,NULL,NULL,'','','DOS SANTOS','Laura','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(186,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'llanzolla',NULL,NULL,NULL,NULL,NULL,'','','LANZOLLA','Laura','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(187,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'lperez',NULL,NULL,NULL,NULL,NULL,'','','PEREZ','Laura','','','PAU',NULL,NULL,NULL,'','0547413173','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(188,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'ldelucq',NULL,NULL,NULL,NULL,NULL,'','','DELUCQ','Lionel','','','PAU',NULL,NULL,NULL,'','0547413248','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(189,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'lberthelon',NULL,NULL,NULL,NULL,NULL,'','','BERTHELON','Loriane','','','',NULL,NULL,NULL,'','NC','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(190,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'lcoves',NULL,NULL,NULL,NULL,NULL,'','','COVES','Lucie','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(191,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'lduffron',NULL,NULL,NULL,NULL,NULL,'','','DUFFRON','Lucie','','','',NULL,NULL,NULL,'','0547413227','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(192,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'lgrenier',NULL,NULL,NULL,NULL,NULL,'','','GRENIER','Lucie','','','PAU',NULL,NULL,NULL,'','05 47 41 31 66','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(193,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'ldarricau',NULL,NULL,NULL,NULL,NULL,'','','DARRICAU','Lucille','','','PAU',NULL,NULL,NULL,'','0547413253','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(194,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'lalberghi',NULL,NULL,NULL,NULL,NULL,'','','DESSOUT-ALBERGHI','Léa','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(195,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mdavid',NULL,NULL,NULL,NULL,NULL,'','','DAVID','Magali','','','BEGLES',NULL,NULL,NULL,'Gestionnaire de paie','0547413236','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(196,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mcattin',NULL,NULL,NULL,NULL,NULL,'','','CATTIN','Magalie','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(197,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'meliceyri',NULL,NULL,NULL,NULL,NULL,'','','ELICEYRI','Maider','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(198,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mdufau',NULL,NULL,NULL,NULL,NULL,'','','DUFAU','Malaurie','','','PAU',NULL,NULL,NULL,'Gestionnaire de paie','05 47 41 30 78','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(199,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mdotto',NULL,NULL,NULL,NULL,NULL,'','','DOTTO','Manon','','','PAU',NULL,NULL,NULL,'','0559303032','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(200,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mdanonville',NULL,NULL,NULL,NULL,NULL,'','','DANONVILLE','Marie','','','PAU',NULL,NULL,NULL,'Gestionnaire de paie','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(201,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'medomblides',NULL,NULL,NULL,NULL,NULL,'','','DOMBLIDES','Marie-Eve','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(202,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mmichel',NULL,NULL,NULL,NULL,NULL,'','','MICHEL','Marion','','','PAU',NULL,NULL,NULL,'','0547413079','','','','','','[]','',0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-07-29 09:22:15',NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(203,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mroger',NULL,NULL,NULL,NULL,NULL,'','','ROGER','Marion','','','PAU',NULL,NULL,NULL,'Gestionnaire de paie','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(204,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-06-24 10:00:10',NULL,NULL,'mmicholet',NULL,NULL,NULL,NULL,NULL,'','','MICHOLET','Mélissa','','','',NULL,NULL,NULL,'','0559302527','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(205,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mdupuis',NULL,NULL,NULL,NULL,NULL,'','','DUPUIS','Morgane','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(206,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mjuignet',NULL,NULL,NULL,NULL,NULL,'','','JUIGNET','Mélanie','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(207,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mmaio',NULL,NULL,NULL,NULL,NULL,'','','MAIO DA SILVA','Mélanie','','','PAU',NULL,NULL,NULL,'','05 47 41 31 65','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(208,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'nmangin',NULL,NULL,NULL,NULL,NULL,'','','MANGIN','Nadège','','','PAU',NULL,NULL,NULL,'','0524363530','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(209,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-04-29 11:34:28',NULL,NULL,'nbetbeze',NULL,NULL,NULL,NULL,NULL,'',NULL,'BETBEZE','Nathalie','','','BORDEAUX',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(210,0,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-07-20 14:00:11',NULL,NULL,'ndupont',NULL,NULL,NULL,NULL,NULL,'','','DUPONT','Nathalie','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-08-16 14:04:31','2021-08-05 09:25:12',NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(211,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'nvigne',NULL,NULL,NULL,NULL,NULL,'','','VIGNE','Nathalie','','','',NULL,NULL,NULL,'','05 47 41 32 46','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(212,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'nmoulia',NULL,NULL,NULL,NULL,NULL,'','','MOULIA','Nicolas','','','PAU',NULL,NULL,NULL,'','0547413179','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(213,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'npironneau',NULL,NULL,NULL,NULL,NULL,'','','PIRONNEAU','Nicolas','','','PAU',NULL,NULL,NULL,'','0559303031','','0675006043','','','','[]','',0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-07-26 09:58:15','2021-07-20 10:06:41',NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(214,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'ocouralet',NULL,NULL,NULL,NULL,NULL,'','','COURALET','Océane','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(215,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'testPRH',NULL,NULL,NULL,NULL,NULL,'','','PRH','PRH Test','','','Mont de Marsan',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(216,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'pcanguilhem',NULL,NULL,NULL,NULL,NULL,'','','CANGUILHEM','Patrice','','','PAU',NULL,NULL,NULL,'','0559309408','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(217,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'psom',NULL,NULL,NULL,NULL,NULL,'','','SOM','Pierre','','','PAU',NULL,NULL,NULL,'','0547413171','','0628797247','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(218,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'rrenou',NULL,NULL,NULL,NULL,NULL,'','','RENOU','Rodolphe','','','PAU',NULL,NULL,NULL,'','0547413229','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(219,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'rferlat',NULL,NULL,NULL,NULL,NULL,'','','FERLAT','Romain','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(220,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'salleaccueil',NULL,NULL,NULL,NULL,NULL,'','','Salle d\'accueil','','','','Pau',NULL,NULL,NULL,'','372','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(221,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'salleformation',NULL,NULL,NULL,NULL,NULL,'','','','','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(222,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'sallereunion',NULL,NULL,NULL,NULL,NULL,'','','Salle de réunion','','','','Pau',NULL,NULL,NULL,'','370','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(223,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'sripolli',NULL,NULL,NULL,NULL,NULL,'','','RIPOLLI','Sandra','','','PAU',NULL,NULL,NULL,'Gestionnaire de Paie','05 47 41 32 31','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(224,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'splaza',NULL,NULL,NULL,NULL,NULL,'','','PLAZA','Sandrine','','','PAU',NULL,NULL,NULL,'','0547413071','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(225,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'slabarthe',NULL,NULL,NULL,NULL,NULL,'','','LABARTHE','Seb','','','Mont de Marsan',NULL,NULL,NULL,'','0547413077','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(226,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'secours',NULL,NULL,NULL,NULL,NULL,'','','','Secours','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(227,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'sdelencquesaing',NULL,NULL,NULL,NULL,NULL,'','','DE LENCQUESAING','Sophie','','','PAU',NULL,NULL,NULL,'','05597788','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(228,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'slevesque',NULL,NULL,NULL,NULL,NULL,'','','LEVESQUE','Sophie','','','Pau',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(229,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'acces1',NULL,NULL,NULL,NULL,NULL,'','','','Stage Accès 1','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(230,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'acces2',NULL,NULL,NULL,NULL,NULL,'','','','Stage Accès 2','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(231,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'acces3',NULL,NULL,NULL,NULL,NULL,'','','','Stage Accès 3','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(232,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'sburlas',NULL,NULL,NULL,NULL,NULL,'','','BURLAS','STEPHAN','','','PAU',NULL,NULL,NULL,'','05 59 30 77 78','','0628797248','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(233,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'svicente',NULL,NULL,NULL,NULL,NULL,'','','VICENTE','Stéphane','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(234,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'sniquet',NULL,NULL,NULL,NULL,NULL,'','','NIQUET','Stéphanie','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(235,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'srelaix',NULL,NULL,NULL,NULL,NULL,'','','RELAIX','Séverine','','','BORDEAUX',NULL,NULL,NULL,'Gestionnaire de paie','0547413235','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(236,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'testosp',NULL,NULL,NULL,NULL,NULL,'','','OSP','Test','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(237,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'tuser25',NULL,NULL,'$2y$10$3pxynjDWcO86sChadmJwXuey/5dxIo2ypNwuQkR/8vYLjKnYjoTsS',NULL,NULL,'','','USER25','Test','','','',NULL,NULL,NULL,'','0102030405','','','','','','[]','',0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-04-29 11:27:45',NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(238,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'tlacoste',NULL,NULL,NULL,NULL,NULL,'','','LACOSTE','Thibaut','','','PAU',NULL,NULL,NULL,'','0547413076','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(239,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'tberterreix',NULL,NULL,NULL,NULL,NULL,'','','BERTERREIX MUSCAR','Thomas','','','PAU',NULL,NULL,NULL,'','0547413172','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(240,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'valvarez',NULL,NULL,NULL,NULL,NULL,'','','ALVAREZ','Valérie','','','PAU',NULL,NULL,NULL,'','0559300512','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(241,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'vberdinel',NULL,NULL,NULL,NULL,NULL,'','','BERDINEL','Vanessa','','','SAINT PIERRE DU MONT',NULL,NULL,NULL,'Gestionnaire de paie','0547413078','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(242,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'vfosse',NULL,NULL,NULL,NULL,NULL,'','','FOSSE','Vincent','','','',NULL,NULL,NULL,'','0559300777','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(243,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'vlassabe',NULL,NULL,NULL,NULL,NULL,'','','LASSABE','Vincent','','','BAYONNE',NULL,NULL,NULL,'','0559413095','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(244,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'vlassalle',NULL,NULL,NULL,NULL,NULL,'','','LASSALLE','Vincent','','','PAU',NULL,NULL,NULL,'','0524363533','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(245,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'vdavid',NULL,NULL,NULL,NULL,NULL,'','','DAVID','Virginie','','','PAU',NULL,NULL,NULL,'','0547413247','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(246,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'vricart',NULL,NULL,NULL,NULL,NULL,'','','RICART','Virginie','','','SAINT PIERRE DU MONT',NULL,NULL,NULL,'Gestionnaire de paie','0547413257','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(247,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'welcome',NULL,NULL,NULL,NULL,NULL,'','','','Welcome','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(248,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'withingsemployees',NULL,NULL,NULL,NULL,NULL,'','','employees','Withings','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(249,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'agarik_test',NULL,NULL,NULL,NULL,NULL,'','','','agarik_test','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(250,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'agarik_test2',NULL,NULL,NULL,NULL,NULL,'','','','','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(251,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'agarik_test3',NULL,NULL,NULL,NULL,NULL,'','','','','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(252,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'applitv',NULL,NULL,NULL,NULL,NULL,'','','tv','appli','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(253,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'cnp',NULL,NULL,NULL,NULL,NULL,'','','','cnp','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(254,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'copysud',NULL,NULL,NULL,NULL,NULL,'','','','copysud','','','PAU',NULL,NULL,NULL,'Gestionnaire de paie','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(255,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'formation2',NULL,NULL,NULL,NULL,NULL,'','','2','formation','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(256,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'formation3',NULL,NULL,NULL,NULL,NULL,'','','3','formation','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(257,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'formation4',NULL,NULL,NULL,NULL,NULL,'','','4','formation','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(258,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'formation5',NULL,NULL,NULL,NULL,NULL,'','','5','formation','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(259,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'formation1',NULL,NULL,NULL,NULL,NULL,'','','1','formation','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-05-25 07:01:41','2021-05-19 15:42:48',NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(260,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'formation_agarik',NULL,NULL,NULL,NULL,NULL,'','','','','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(261,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:08',NULL,NULL,'gestionpaie',NULL,NULL,NULL,NULL,NULL,'','','','gestionpaie','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(262,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'mfgs',NULL,NULL,NULL,NULL,NULL,'','','','mfgs','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(263,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'pvirement',NULL,NULL,NULL,NULL,NULL,'','','','pvirement','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(264,1,NULL,NULL,1,0,'2021-04-29 11:11:38','2021-05-21 17:00:09',NULL,NULL,'reunion',NULL,NULL,NULL,NULL,NULL,'','','','reunion','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(265,1,NULL,NULL,1,0,'2021-04-29 14:53:05','2021-05-21 17:00:02',NULL,NULL,'tuseridc',NULL,NULL,NULL,NULL,'56ngymfx','','','USERIDC','Test','','','',NULL,NULL,NULL,'','0102030405','','','','','','[]','',0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-05-14 13:19:35','2021-05-14 13:18:02',NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(266,1,NULL,NULL,1,0,'2021-04-29 14:54:52','2021-05-21 17:00:02',NULL,NULL,'admindws',NULL,NULL,NULL,NULL,NULL,'','','DWS','Admin','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(267,1,NULL,NULL,1,0,'2021-04-29 14:54:52','2021-05-21 17:00:02',NULL,NULL,'ccabri',NULL,NULL,NULL,NULL,NULL,'','','CABRI','Camille','','','Pau',NULL,NULL,NULL,'Technicien Data Analyst','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(268,1,NULL,NULL,1,0,'2021-04-29 14:54:52','2021-05-21 17:00:02',NULL,NULL,'gheugas',NULL,NULL,NULL,NULL,NULL,'','','HEUGAS','Gilles','','','Pau',NULL,NULL,NULL,'Responsable projet ID','05 47 41 32 55','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(269,1,NULL,NULL,1,0,'2021-04-29 14:54:52','2021-05-21 17:00:02',NULL,NULL,'jchampagnol',NULL,NULL,NULL,NULL,NULL,'','','CHAMPAGNOL','Julien','','','Pau',NULL,NULL,NULL,'Technicien Data Analyst','0547413177','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(270,1,NULL,NULL,1,0,'2021-04-29 14:54:52','2021-05-21 17:00:02',NULL,NULL,'mguitter',NULL,NULL,NULL,NULL,NULL,'','','GUITTER','MARC','','','PAU',NULL,NULL,NULL,'','0559307779','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(271,1,NULL,NULL,1,0,'2021-04-29 14:54:52','2021-05-21 17:00:02',NULL,NULL,'mtessier',NULL,NULL,NULL,NULL,NULL,'','','TESSIER','Marion','','','Pau',NULL,NULL,NULL,'Technicien Data Analyst','0547413233','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(272,1,NULL,NULL,1,0,'2021-04-29 14:54:52','2021-05-21 17:00:02',NULL,NULL,'mlavergne',NULL,NULL,NULL,NULL,NULL,'','','LAVERGNE','Maxime','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(273,0,NULL,NULL,1,0,'2021-04-29 14:54:52','2021-07-29 15:00:02',NULL,NULL,'yconstant',NULL,NULL,'$2y$10$Uak.rCnlIJcFx/88l3kYi.BeKWfeFPgwsSZS7Zl2o8omr0uAHs9Wu',NULL,NULL,'man','','CONSTANT','YANN','','','PAU',NULL,NULL,NULL,'Technicien Data Analyst','05 47 41 32 32','','0622393651','','','','[]','',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-07-29 14:42:44',NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(274,1,NULL,NULL,1,0,'2021-04-29 14:54:52','2021-05-21 17:00:02',NULL,NULL,'support',NULL,NULL,NULL,NULL,NULL,'','','','Support','','','PAU',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(275,1,NULL,NULL,1,0,'2021-04-29 14:54:52','2021-05-21 17:00:02',NULL,NULL,'usertvdws',NULL,NULL,NULL,NULL,NULL,'','','','usertvdws','','','',NULL,NULL,NULL,'Stagiaire','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(276,1,NULL,NULL,1,0,'2021-05-14 12:22:20','2021-05-21 17:00:09',NULL,NULL,'mdomblides',NULL,NULL,NULL,NULL,NULL,'','','DOMBLIDES','Marine','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(277,1,NULL,NULL,1,0,'2021-05-14 12:22:20','2021-05-21 17:00:09',NULL,NULL,'nperez',NULL,NULL,NULL,NULL,NULL,'','','PEREZ','Nerea','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(278,1,NULL,NULL,1,0,'2021-05-20 16:00:10','2021-05-21 17:00:09',NULL,NULL,'stestaud',NULL,NULL,NULL,NULL,NULL,'','','TESTAUD','Sandrine','','','',NULL,NULL,NULL,'','0524363542','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(279,1,NULL,NULL,1,0,'2021-05-25 10:00:12','2021-05-25 11:00:12',NULL,NULL,'vguillou',NULL,NULL,NULL,NULL,NULL,'','','GUILLOU','Virginie','','','',NULL,NULL,NULL,'','0524363544','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(280,1,NULL,NULL,1,0,'2021-05-25 15:00:11','2021-05-25 16:00:11',NULL,NULL,'gmatha',NULL,NULL,NULL,NULL,NULL,'','','MATHA','Gwladys','','','',NULL,NULL,NULL,'','05 24 36 35 43','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(281,1,NULL,NULL,1,0,'2021-05-25 15:00:11','2021-05-25 16:00:11',NULL,NULL,'mhumbert',NULL,NULL,NULL,NULL,NULL,'','','HUMBERT','Magali','','','',NULL,NULL,NULL,'','05 24 36 35 44','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(282,1,NULL,NULL,1,0,'2021-06-09 15:00:02','2021-06-09 16:00:02',NULL,NULL,'tfonc2',NULL,NULL,NULL,NULL,NULL,'','','FONC2','Test','','','',NULL,NULL,NULL,'','0102030405','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(283,1,NULL,NULL,1,0,'2021-06-09 15:00:12','2021-06-09 16:00:14',NULL,NULL,'tfonc1',NULL,NULL,NULL,NULL,NULL,'','','FONC1','Test','','','',NULL,NULL,NULL,'','0102030405','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(284,1,NULL,NULL,1,0,'2021-06-10 08:00:02','2021-06-10 09:00:02',NULL,NULL,'tfonc3',NULL,NULL,NULL,NULL,NULL,'','','FONC3','Test','','','',NULL,NULL,NULL,'','0102030405','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(285,1,NULL,NULL,1,0,'2021-06-10 10:00:12','2021-06-10 11:00:12',NULL,NULL,'tfonc111',NULL,NULL,NULL,NULL,NULL,'','','FONC111','Test','','','',NULL,NULL,NULL,'','0102030405','','','','','','[]','',0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-06-11 12:57:27',NULL,NULL,NULL,NULL,'?',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(286,1,NULL,NULL,1,0,'2021-06-10 15:00:02','2021-06-10 16:00:03',NULL,NULL,'tfonc333',NULL,NULL,NULL,NULL,NULL,'','','FONC333','Test','','','',NULL,NULL,NULL,'','0102030405','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(287,1,NULL,NULL,1,0,'2021-06-14 13:00:02','2021-06-14 14:00:02',NULL,NULL,'tfonc222',NULL,NULL,NULL,NULL,NULL,'','','FONC222','Test','','','',NULL,NULL,NULL,'','0102030405','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(288,1,NULL,NULL,1,0,'2021-06-24 13:00:12','2021-06-24 14:00:12',NULL,NULL,'mnovallas',NULL,NULL,NULL,NULL,NULL,'','','NOVALLAS','Magali','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(289,1,NULL,NULL,1,0,'2021-06-25 14:00:02','2021-06-25 15:00:02',NULL,NULL,'tuser',NULL,NULL,NULL,NULL,NULL,'','','USER','Test','','','',NULL,NULL,NULL,'','0102030405','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(290,1,NULL,NULL,1,0,'2021-06-28 07:00:10','2021-06-28 08:00:12',NULL,NULL,'ebaratie',NULL,NULL,NULL,NULL,NULL,'','','BARATIE','Emilie','','','',NULL,NULL,NULL,'','0559330777','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(291,1,NULL,NULL,1,0,'2021-06-28 09:00:12','2021-06-28 10:00:11',NULL,NULL,'elajoie',NULL,NULL,NULL,NULL,NULL,'','','LAJOIE','Eloïse','','','',NULL,NULL,NULL,'','0547413244','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(292,1,NULL,NULL,1,0,'2021-06-29 14:00:11','2021-06-29 15:00:12',NULL,NULL,'aeugui',NULL,NULL,NULL,NULL,NULL,'','','EUGUI','Ander','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(293,1,NULL,NULL,1,0,'2021-06-29 14:00:11','2021-06-29 15:00:12',NULL,NULL,'elbilequera',NULL,NULL,NULL,NULL,NULL,'','','BILEQUERA','Estiven Luis','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(294,1,NULL,NULL,1,0,'2021-07-08 13:00:13','2021-07-08 13:00:13',NULL,NULL,'tuser2',NULL,NULL,NULL,NULL,NULL,'','','USER2','Test','','','',NULL,NULL,NULL,'','0102030405','','','','','','null','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(296,1,NULL,NULL,1,0,'2021-07-12 09:00:12','2021-07-12 10:00:12',NULL,NULL,'ldelaunay',NULL,NULL,NULL,NULL,NULL,'','','DELAUNAY','Léa','','','',NULL,NULL,NULL,'','0547413079','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(297,1,NULL,NULL,1,0,'2021-07-15 10:00:13','2021-07-15 11:00:12',NULL,NULL,'nemma',NULL,NULL,NULL,NULL,NULL,'','','EMMA','Naïs','','','',NULL,NULL,NULL,'','0547413248','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(298,1,NULL,NULL,1,0,'2021-07-16 08:00:12','2021-07-16 09:00:11',NULL,NULL,'amoreno',NULL,NULL,NULL,NULL,NULL,'','','MORENO','Amaia','','','PAU',NULL,NULL,NULL,'','05 47 41 32 59','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(299,1,NULL,NULL,1,0,'2021-07-22 15:00:10','2021-07-22 16:00:11',NULL,NULL,'atournier',NULL,NULL,NULL,NULL,NULL,'','','TOURNIER','Aliénor','','','',NULL,NULL,NULL,'','0547413171','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(300,1,NULL,NULL,1,0,'2021-07-23 14:00:11','2021-07-23 15:00:12',NULL,NULL,'cabelloc',NULL,NULL,NULL,NULL,NULL,'','','BELLOC','Charles-amaury','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(301,1,NULL,NULL,1,0,'2021-07-27 08:00:11','2021-07-27 09:00:10',NULL,NULL,'mcastronovo',NULL,NULL,NULL,NULL,NULL,'','','CASTRONOVO','Mélanie','','','',NULL,NULL,NULL,'','05 24 36 35 45','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(303,1,NULL,NULL,1,0,'2021-07-29 11:00:11','2021-07-29 12:00:09',NULL,NULL,'acarneiro',NULL,NULL,NULL,NULL,NULL,'','','CARNEIRO','Adélaïde','','','',NULL,NULL,NULL,'','05 59 30 07 77','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(304,1,NULL,NULL,1,0,'2021-07-30 08:00:09','2021-07-30 09:00:12',NULL,NULL,'jmagnan',NULL,NULL,NULL,NULL,NULL,'','','MAGNAN','Jules','','','',NULL,NULL,NULL,'','05 47 41 32 56','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(305,1,NULL,NULL,1,0,'2021-07-30 10:00:12','2021-07-30 11:00:09',NULL,NULL,'nbidalun',NULL,NULL,NULL,NULL,NULL,'','','BIDALUN','Nicolas','','','',NULL,NULL,NULL,'','0559595959','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(306,1,NULL,NULL,1,0,'2021-07-30 11:00:09','2021-07-30 12:00:11',NULL,NULL,'hdufourcq',NULL,NULL,NULL,NULL,NULL,'','','DUFOURCQ','Hugues','','','',NULL,NULL,NULL,'','05 50 50 50 50','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(307,1,NULL,NULL,1,0,'2021-08-02 09:00:13','2021-08-02 10:00:13',NULL,NULL,'apareilh',NULL,NULL,NULL,NULL,NULL,'','','PAREILH-PEYROU','Alizée','','','',NULL,NULL,NULL,'','05 47 41 30 96','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(308,1,NULL,NULL,1,0,'2021-08-02 10:00:13','2021-08-02 11:00:10',NULL,NULL,'odagri',NULL,NULL,NULL,NULL,NULL,'','','DAGRI','Olga','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(309,1,NULL,NULL,1,0,'2021-08-02 11:00:10','2021-08-02 12:00:11',NULL,NULL,'cchaumont',NULL,NULL,NULL,NULL,NULL,'','','CHAUMONT','Cindy','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(310,1,NULL,NULL,1,0,'2021-08-02 14:00:10','2021-08-02 15:00:11',NULL,NULL,'ntancrez',NULL,NULL,NULL,NULL,NULL,'','','TANCREZ','Noémie','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(311,1,NULL,NULL,1,0,'2021-08-02 14:00:10','2021-08-02 15:00:11',NULL,NULL,'vmounier',NULL,NULL,NULL,NULL,NULL,'','','MOUNIER','Virginie','','','',NULL,NULL,NULL,'','','','','','','','[]','',0,1,1,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,NULL,NULL,NULL,NULL,NULL,NULL),(312,1,NULL,NULL,1,0,'2021-08-18 06:00:09','2021-08-18 07:00:13',NULL,NULL,'rnyingoneango',NULL,NULL,NULL,NULL,NULL,'','','NYINGONE ANGO','Raissa','','','',NULL,NULL,NULL,'','0524363546','','','','','','[]','',0,1,1,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,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=utf8 COLLATE=utf8_unicode_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `login` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poste` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_ext` varchar(50) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci 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=utf8 COLLATE=utf8_unicode_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_user_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_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) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `uk_user_param` (`fk_user`,`param`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_user_param` VALUES (1,1,'MAIN_BOXES_0','1'),(1,1,'MAIN_SELECTEDFIELDS_thirdpartylist','country.code_iso,ef.moisclotureexec,s.nom,s.name_alias,s.code_client,s.town,s.zip,s.phone,typent.code,customerorsupplier,s.status,'),(1,1,'MAIN_SELECTEDFIELDS_userlist','u.datec,u.login,u.lastname,u.firstname,u.email,u.fk_soc,u.datelastlogin,u.statut,'),(2,1,'MAIN_SELECTEDFIELDS_/societe/contact.php','t.name,t.poste,t.address,t.statut,'),(6,1,'MAIN_BOXES_0','1'),(213,1,'MAIN_SELECTEDFIELDS_customerlist','s.code_client,s.email,s.address,s.town,s.phone,staff.code,ef.startmission,ef.ged,ef.datecrea,ef.missiontype,ef.initialnumberemployee,ef.activity,ef.internalpaysolution,ef.ccn,s.nom,s.zip,');

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_banque` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_guichet` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cle_rib` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bic` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iban_prefix` varchar(34) COLLATE utf8_unicode_ci DEFAULT NULL,
  `domiciliation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `proprio` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `owner_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_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=3632 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_user_rights` VALUES (2976,1,1,11),(2977,1,1,12),(2978,1,1,13),(2979,1,1,14),(2980,1,1,15),(2981,1,1,16),(2982,1,1,19),(2983,1,1,21),(2984,1,1,22),(2985,1,1,24),(2986,1,1,25),(2987,1,1,26),(2988,1,1,27),(2989,1,1,28),(360,1,1,41),(361,1,1,42),(362,1,1,44),(363,1,1,45),(364,1,1,91),(365,1,1,92),(366,1,1,93),(367,1,1,94),(368,1,1,111),(369,1,1,112),(370,1,1,113),(371,1,1,114),(372,1,1,115),(373,1,1,116),(374,1,1,117),(2990,1,1,121),(2991,1,1,122),(2992,1,1,125),(2993,1,1,126),(379,1,1,141),(380,1,1,142),(381,1,1,144),(2994,1,1,161),(2995,1,1,162),(2996,1,1,163),(2997,1,1,164),(2998,1,1,165),(2999,1,1,167),(3000,1,1,241),(3001,1,1,242),(3002,1,1,243),(3003,1,1,251),(3004,1,1,252),(3005,1,1,253),(3006,1,1,254),(3007,1,1,255),(3008,1,1,256),(3009,1,1,262),(3010,1,1,281),(3011,1,1,282),(3012,1,1,283),(3013,1,1,286),(3014,1,1,331),(3015,1,1,332),(3016,1,1,333),(3017,1,1,341),(3018,1,1,342),(3019,1,1,343),(3020,1,1,344),(3021,1,1,351),(3022,1,1,352),(3023,1,1,353),(3024,1,1,354),(3025,1,1,358),(3026,1,1,430),(3027,1,1,531),(3028,1,1,532),(3029,1,1,534),(3030,1,1,538),(413,1,1,1181),(414,1,1,1182),(415,1,1,1183),(416,1,1,1184),(417,1,1,1185),(418,1,1,1186),(419,1,1,1187),(420,1,1,1188),(421,1,1,1189),(422,1,1,1191),(3319,1,1,1201),(3320,1,1,1202),(423,1,1,1231),(424,1,1,1232),(425,1,1,1233),(426,1,1,1234),(427,1,1,1235),(428,1,1,1236),(429,1,1,1251),(3031,1,1,1321),(3032,1,1,1322),(3033,1,1,2401),(3034,1,1,2402),(3035,1,1,2403),(3036,1,1,2411),(3037,1,1,2412),(3038,1,1,2413),(3039,1,1,2414),(3040,1,1,2501),(3041,1,1,2503),(3042,1,1,2515),(3043,1,1,3200),(3044,1,1,3301),(434,1,1,50401),(435,1,1,50411),(436,1,1,50412),(437,1,1,50414),(438,1,1,50415),(439,1,1,50418),(440,1,1,50420),(441,1,1,50430),(442,1,1,50440),(3619,1,1,432505),(3608,1,1,432506),(3620,1,1,432507),(2395,1,1,500000),(2394,1,1,500001),(2396,1,1,500002),(3048,1,1,4324510),(3049,1,1,4324511),(3050,1,1,4324512),(3051,1,1,4324513),(3052,1,1,4324514),(3053,1,1,4324515),(3621,1,2,432505),(3610,1,2,432506),(3622,1,2,432507),(477,1,4,430),(3623,1,5,432505),(3612,1,5,432506),(3624,1,5,432507),(532,1,6,251),(533,1,6,252),(534,1,6,253),(535,1,6,254),(536,1,6,255),(537,1,6,256),(546,1,6,341),(547,1,6,342),(548,1,6,343),(549,1,6,344),(550,1,6,351),(551,1,6,352),(552,1,6,353),(553,1,6,354),(554,1,6,358),(3625,1,6,432505),(3614,1,6,432506),(3626,1,6,432507),(569,1,6,500000),(570,1,6,500001),(571,1,6,500002),(572,1,6,4324510),(573,1,6,4324511),(574,1,6,4324512),(575,1,6,4324513),(576,1,6,4324514),(577,1,6,4324515),(578,1,7,430),(579,1,7,4324510),(580,1,7,4324511),(581,1,7,4324512),(582,1,7,4324514),(583,1,7,4324515),(584,1,8,430),(585,1,8,4324510),(586,1,8,4324511),(587,1,8,4324512),(588,1,8,4324514),(589,1,8,4324515),(590,1,9,430),(591,1,9,4324510),(592,1,9,4324511),(593,1,9,4324512),(594,1,9,4324514),(595,1,9,4324515),(596,1,10,430),(597,1,10,4324510),(598,1,10,4324511),(599,1,10,4324512),(600,1,10,4324514),(601,1,10,4324515),(602,1,11,430),(603,1,11,4324510),(604,1,11,4324511),(605,1,11,4324512),(606,1,11,4324514),(607,1,11,4324515),(608,1,12,430),(609,1,12,4324510),(610,1,12,4324511),(611,1,12,4324512),(612,1,12,4324514),(613,1,12,4324515),(614,1,13,430),(615,1,13,4324510),(616,1,13,4324511),(617,1,13,4324512),(618,1,13,4324514),(619,1,13,4324515),(620,1,14,430),(621,1,14,4324510),(622,1,14,4324511),(623,1,14,4324512),(624,1,14,4324514),(625,1,14,4324515),(626,1,15,430),(627,1,15,4324510),(628,1,15,4324511),(629,1,15,4324512),(630,1,15,4324514),(631,1,15,4324515),(632,1,16,430),(633,1,16,4324510),(634,1,16,4324511),(635,1,16,4324512),(636,1,16,4324514),(637,1,16,4324515),(638,1,17,430),(639,1,17,4324510),(640,1,17,4324511),(641,1,17,4324512),(642,1,17,4324514),(643,1,17,4324515),(644,1,18,430),(645,1,18,4324510),(646,1,18,4324511),(647,1,18,4324512),(648,1,18,4324514),(649,1,18,4324515),(650,1,19,430),(651,1,19,4324510),(652,1,19,4324511),(653,1,19,4324512),(654,1,19,4324514),(655,1,19,4324515),(656,1,20,430),(657,1,20,4324510),(658,1,20,4324511),(659,1,20,4324512),(660,1,20,4324514),(661,1,20,4324515),(662,1,21,430),(663,1,21,4324510),(664,1,21,4324511),(665,1,21,4324512),(666,1,21,4324514),(667,1,21,4324515),(668,1,22,430),(669,1,22,4324510),(670,1,22,4324511),(671,1,22,4324512),(672,1,22,4324514),(673,1,22,4324515),(674,1,23,430),(675,1,23,4324510),(676,1,23,4324511),(677,1,23,4324512),(678,1,23,4324514),(679,1,23,4324515),(680,1,24,430),(681,1,24,4324510),(682,1,24,4324511),(683,1,24,4324512),(684,1,24,4324514),(685,1,24,4324515),(686,1,25,430),(687,1,25,4324510),(688,1,25,4324511),(689,1,25,4324512),(690,1,25,4324514),(691,1,25,4324515),(692,1,26,430),(693,1,26,4324510),(694,1,26,4324511),(695,1,26,4324512),(696,1,26,4324514),(697,1,26,4324515),(698,1,27,430),(699,1,27,4324510),(700,1,27,4324511),(701,1,27,4324512),(702,1,27,4324514),(703,1,27,4324515),(704,1,28,430),(705,1,28,4324510),(706,1,28,4324511),(707,1,28,4324512),(708,1,28,4324514),(709,1,28,4324515),(710,1,29,430),(711,1,29,4324510),(712,1,29,4324511),(713,1,29,4324512),(714,1,29,4324514),(715,1,29,4324515),(716,1,30,430),(717,1,30,4324510),(718,1,30,4324511),(719,1,30,4324512),(720,1,30,4324514),(721,1,30,4324515),(722,1,31,430),(723,1,31,4324510),(724,1,31,4324511),(725,1,31,4324512),(726,1,31,4324514),(727,1,31,4324515),(728,1,32,430),(729,1,32,4324510),(730,1,32,4324511),(731,1,32,4324512),(732,1,32,4324514),(733,1,32,4324515),(734,1,33,430),(735,1,33,4324510),(736,1,33,4324511),(737,1,33,4324512),(738,1,33,4324514),(739,1,33,4324515),(740,1,34,430),(741,1,34,4324510),(742,1,34,4324511),(743,1,34,4324512),(744,1,34,4324514),(745,1,34,4324515),(746,1,35,430),(747,1,35,4324510),(748,1,35,4324511),(749,1,35,4324512),(750,1,35,4324514),(751,1,35,4324515),(752,1,36,430),(753,1,36,4324510),(754,1,36,4324511),(755,1,36,4324512),(756,1,36,4324514),(757,1,36,4324515),(758,1,37,430),(759,1,37,4324510),(760,1,37,4324511),(761,1,37,4324512),(762,1,37,4324514),(763,1,37,4324515),(764,1,38,430),(765,1,38,4324510),(766,1,38,4324511),(767,1,38,4324512),(768,1,38,4324514),(769,1,38,4324515),(770,1,39,430),(771,1,39,4324510),(772,1,39,4324511),(773,1,39,4324512),(774,1,39,4324514),(775,1,39,4324515),(776,1,40,430),(777,1,40,4324510),(778,1,40,4324511),(779,1,40,4324512),(780,1,40,4324514),(781,1,40,4324515),(782,1,41,430),(783,1,41,4324510),(784,1,41,4324511),(785,1,41,4324512),(786,1,41,4324514),(787,1,41,4324515),(788,1,42,430),(789,1,42,4324510),(790,1,42,4324511),(791,1,42,4324512),(792,1,42,4324514),(793,1,42,4324515),(794,1,43,430),(795,1,43,4324510),(796,1,43,4324511),(797,1,43,4324512),(798,1,43,4324514),(799,1,43,4324515),(800,1,44,430),(801,1,44,4324510),(802,1,44,4324511),(803,1,44,4324512),(804,1,44,4324514),(805,1,44,4324515),(806,1,45,430),(807,1,45,4324510),(808,1,45,4324511),(809,1,45,4324512),(810,1,45,4324514),(811,1,45,4324515),(812,1,46,430),(813,1,46,4324510),(814,1,46,4324511),(815,1,46,4324512),(816,1,46,4324514),(817,1,46,4324515),(818,1,47,430),(819,1,47,4324510),(820,1,47,4324511),(821,1,47,4324512),(822,1,47,4324514),(823,1,47,4324515),(824,1,48,430),(825,1,48,4324510),(826,1,48,4324511),(827,1,48,4324512),(828,1,48,4324514),(829,1,48,4324515),(830,1,49,430),(831,1,49,4324510),(832,1,49,4324511),(833,1,49,4324512),(834,1,49,4324514),(835,1,49,4324515),(836,1,50,430),(837,1,50,4324510),(838,1,50,4324511),(839,1,50,4324512),(840,1,50,4324514),(841,1,50,4324515),(842,1,51,430),(843,1,51,4324510),(844,1,51,4324511),(845,1,51,4324512),(846,1,51,4324514),(847,1,51,4324515),(848,1,52,430),(849,1,52,4324510),(850,1,52,4324511),(851,1,52,4324512),(852,1,52,4324514),(853,1,52,4324515),(854,1,53,430),(855,1,53,4324510),(856,1,53,4324511),(857,1,53,4324512),(858,1,53,4324514),(859,1,53,4324515),(860,1,54,430),(861,1,54,4324510),(862,1,54,4324511),(863,1,54,4324512),(864,1,54,4324514),(865,1,54,4324515),(866,1,55,430),(867,1,55,4324510),(868,1,55,4324511),(869,1,55,4324512),(870,1,55,4324514),(871,1,55,4324515),(872,1,56,430),(873,1,56,4324510),(874,1,56,4324511),(875,1,56,4324512),(876,1,56,4324514),(877,1,56,4324515),(878,1,57,430),(879,1,57,4324510),(880,1,57,4324511),(881,1,57,4324512),(882,1,57,4324514),(883,1,57,4324515),(884,1,58,430),(885,1,58,4324510),(886,1,58,4324511),(887,1,58,4324512),(888,1,58,4324514),(889,1,58,4324515),(890,1,59,430),(891,1,59,4324510),(892,1,59,4324511),(893,1,59,4324512),(894,1,59,4324514),(895,1,59,4324515),(896,1,60,430),(897,1,60,4324510),(898,1,60,4324511),(899,1,60,4324512),(900,1,60,4324514),(901,1,60,4324515),(902,1,61,430),(903,1,61,4324510),(904,1,61,4324511),(905,1,61,4324512),(906,1,61,4324514),(907,1,61,4324515),(908,1,62,430),(909,1,62,4324510),(910,1,62,4324511),(911,1,62,4324512),(912,1,62,4324514),(913,1,62,4324515),(914,1,63,430),(915,1,63,4324510),(916,1,63,4324511),(917,1,63,4324512),(918,1,63,4324514),(919,1,63,4324515),(920,1,64,430),(921,1,64,4324510),(922,1,64,4324511),(923,1,64,4324512),(924,1,64,4324514),(925,1,64,4324515),(926,1,65,430),(927,1,65,4324510),(928,1,65,4324511),(929,1,65,4324512),(930,1,65,4324514),(931,1,65,4324515),(932,1,66,430),(933,1,66,4324510),(934,1,66,4324511),(935,1,66,4324512),(936,1,66,4324514),(937,1,66,4324515),(938,1,67,430),(939,1,67,4324510),(940,1,67,4324511),(941,1,67,4324512),(942,1,67,4324514),(943,1,67,4324515),(944,1,68,430),(945,1,68,4324510),(946,1,68,4324511),(947,1,68,4324512),(948,1,68,4324514),(949,1,68,4324515),(950,1,69,430),(951,1,69,4324510),(952,1,69,4324511),(953,1,69,4324512),(954,1,69,4324514),(955,1,69,4324515),(956,1,70,430),(957,1,70,4324510),(958,1,70,4324511),(959,1,70,4324512),(960,1,70,4324514),(961,1,70,4324515),(962,1,71,430),(963,1,71,4324510),(964,1,71,4324511),(965,1,71,4324512),(966,1,71,4324514),(967,1,71,4324515),(968,1,72,430),(969,1,72,4324510),(970,1,72,4324511),(971,1,72,4324512),(972,1,72,4324514),(973,1,72,4324515),(974,1,73,430),(975,1,73,4324510),(976,1,73,4324511),(977,1,73,4324512),(978,1,73,4324514),(979,1,73,4324515),(980,1,74,430),(981,1,74,4324510),(982,1,74,4324511),(983,1,74,4324512),(984,1,74,4324514),(985,1,74,4324515),(986,1,75,430),(987,1,75,4324510),(988,1,75,4324511),(989,1,75,4324512),(990,1,75,4324514),(991,1,75,4324515),(992,1,76,430),(993,1,76,4324510),(994,1,76,4324511),(995,1,76,4324512),(996,1,76,4324514),(997,1,76,4324515),(998,1,77,430),(999,1,77,4324510),(1000,1,77,4324511),(1001,1,77,4324512),(1002,1,77,4324514),(1003,1,77,4324515),(1004,1,78,430),(1005,1,78,4324510),(1006,1,78,4324511),(1007,1,78,4324512),(1008,1,78,4324514),(1009,1,78,4324515),(1010,1,79,430),(1011,1,79,4324510),(1012,1,79,4324511),(1013,1,79,4324512),(1014,1,79,4324514),(1015,1,79,4324515),(1016,1,80,430),(1017,1,80,4324510),(1018,1,80,4324511),(1019,1,80,4324512),(1020,1,80,4324514),(1021,1,80,4324515),(1022,1,81,430),(1023,1,81,4324510),(1024,1,81,4324511),(1025,1,81,4324512),(1026,1,81,4324514),(1027,1,81,4324515),(1028,1,82,430),(1029,1,82,4324510),(1030,1,82,4324511),(1031,1,82,4324512),(1032,1,82,4324514),(1033,1,82,4324515),(1034,1,83,430),(1035,1,83,4324510),(1036,1,83,4324511),(1037,1,83,4324512),(1038,1,83,4324514),(1039,1,83,4324515),(1040,1,84,430),(1041,1,84,4324510),(1042,1,84,4324511),(1043,1,84,4324512),(1044,1,84,4324514),(1045,1,84,4324515),(1046,1,85,430),(1047,1,85,4324510),(1048,1,85,4324511),(1049,1,85,4324512),(1050,1,85,4324514),(1051,1,85,4324515),(1052,1,86,430),(1053,1,86,4324510),(1054,1,86,4324511),(1055,1,86,4324512),(1056,1,86,4324514),(1057,1,86,4324515),(1058,1,87,430),(1059,1,87,4324510),(1060,1,87,4324511),(1061,1,87,4324512),(1062,1,87,4324514),(1063,1,87,4324515),(1064,1,88,430),(1065,1,88,4324510),(1066,1,88,4324511),(1067,1,88,4324512),(1068,1,88,4324514),(1069,1,88,4324515),(1070,1,89,430),(1071,1,89,4324510),(1072,1,89,4324511),(1073,1,89,4324512),(1074,1,89,4324514),(1075,1,89,4324515),(1076,1,90,430),(1077,1,90,4324510),(1078,1,90,4324511),(1079,1,90,4324512),(1080,1,90,4324514),(1081,1,90,4324515),(1082,1,91,430),(1083,1,91,4324510),(1084,1,91,4324511),(1085,1,91,4324512),(1086,1,91,4324514),(1087,1,91,4324515),(1088,1,92,430),(1089,1,92,4324510),(1090,1,92,4324511),(1091,1,92,4324512),(1092,1,92,4324514),(1093,1,92,4324515),(1094,1,93,430),(1095,1,93,4324510),(1096,1,93,4324511),(1097,1,93,4324512),(1098,1,93,4324514),(1099,1,93,4324515),(1100,1,94,430),(1101,1,94,4324510),(1102,1,94,4324511),(1103,1,94,4324512),(1104,1,94,4324514),(1105,1,94,4324515),(1106,1,95,430),(1107,1,95,4324510),(1108,1,95,4324511),(1109,1,95,4324512),(1110,1,95,4324514),(1111,1,95,4324515),(1112,1,96,430),(1113,1,96,4324510),(1114,1,96,4324511),(1115,1,96,4324512),(1116,1,96,4324514),(1117,1,96,4324515),(1118,1,97,430),(1119,1,97,4324510),(1120,1,97,4324511),(1121,1,97,4324512),(1122,1,97,4324514),(1123,1,97,4324515),(1124,1,98,430),(1125,1,98,4324510),(1126,1,98,4324511),(1127,1,98,4324512),(1128,1,98,4324514),(1129,1,98,4324515),(1130,1,99,430),(1131,1,99,4324510),(1132,1,99,4324511),(1133,1,99,4324512),(1134,1,99,4324514),(1135,1,99,4324515),(1136,1,100,430),(1137,1,100,4324510),(1138,1,100,4324511),(1139,1,100,4324512),(1140,1,100,4324514),(1141,1,100,4324515),(1142,1,101,430),(1143,1,101,4324510),(1144,1,101,4324511),(1145,1,101,4324512),(1146,1,101,4324514),(1147,1,101,4324515),(1148,1,102,430),(1149,1,102,4324510),(1150,1,102,4324511),(1151,1,102,4324512),(1152,1,102,4324514),(1153,1,102,4324515),(1154,1,103,430),(1155,1,103,4324510),(1156,1,103,4324511),(1157,1,103,4324512),(1158,1,103,4324514),(1159,1,103,4324515),(1160,1,104,430),(1161,1,104,4324510),(1162,1,104,4324511),(1163,1,104,4324512),(1164,1,104,4324514),(1165,1,104,4324515),(1166,1,105,430),(1167,1,105,4324510),(1168,1,105,4324511),(1169,1,105,4324512),(1170,1,105,4324514),(1171,1,105,4324515),(1172,1,106,430),(1173,1,106,4324510),(1174,1,106,4324511),(1175,1,106,4324512),(1176,1,106,4324514),(1177,1,106,4324515),(1178,1,107,430),(1179,1,107,4324510),(1180,1,107,4324511),(1181,1,107,4324512),(1182,1,107,4324514),(1183,1,107,4324515),(1184,1,108,430),(1185,1,108,4324510),(1186,1,108,4324511),(1187,1,108,4324512),(1188,1,108,4324514),(1189,1,108,4324515),(1190,1,109,430),(1191,1,109,4324510),(1192,1,109,4324511),(1193,1,109,4324512),(1194,1,109,4324514),(1195,1,109,4324515),(1196,1,110,430),(1197,1,110,4324510),(1198,1,110,4324511),(1199,1,110,4324512),(1200,1,110,4324514),(1201,1,110,4324515),(1202,1,111,430),(1203,1,111,4324510),(1204,1,111,4324511),(1205,1,111,4324512),(1206,1,111,4324514),(1207,1,111,4324515),(1208,1,112,430),(1209,1,112,4324510),(1210,1,112,4324511),(1211,1,112,4324512),(1212,1,112,4324514),(1213,1,112,4324515),(1214,1,113,430),(1215,1,113,4324510),(1216,1,113,4324511),(1217,1,113,4324512),(1218,1,113,4324514),(1219,1,113,4324515),(1220,1,114,430),(1221,1,114,4324510),(1222,1,114,4324511),(1223,1,114,4324512),(1224,1,114,4324514),(1225,1,114,4324515),(1226,1,115,430),(1227,1,115,4324510),(1228,1,115,4324511),(1229,1,115,4324512),(1230,1,115,4324514),(1231,1,115,4324515),(1232,1,116,430),(1233,1,116,4324510),(1234,1,116,4324511),(1235,1,116,4324512),(1236,1,116,4324514),(1237,1,116,4324515),(1238,1,117,430),(1239,1,117,4324510),(1240,1,117,4324511),(1241,1,117,4324512),(1242,1,117,4324514),(1243,1,117,4324515),(1244,1,118,430),(1245,1,118,4324510),(1246,1,118,4324511),(1247,1,118,4324512),(1248,1,118,4324514),(1249,1,118,4324515),(1250,1,119,430),(1251,1,119,4324510),(1252,1,119,4324511),(1253,1,119,4324512),(1254,1,119,4324514),(1255,1,119,4324515),(1256,1,120,430),(1257,1,120,4324510),(1258,1,120,4324511),(1259,1,120,4324512),(1260,1,120,4324514),(1261,1,120,4324515),(1262,1,121,430),(1263,1,121,4324510),(1264,1,121,4324511),(1265,1,121,4324512),(1266,1,121,4324514),(1267,1,121,4324515),(1268,1,122,430),(1269,1,122,4324510),(1270,1,122,4324511),(1271,1,122,4324512),(1272,1,122,4324514),(1273,1,122,4324515),(1274,1,123,430),(1275,1,123,4324510),(1276,1,123,4324511),(1277,1,123,4324512),(1278,1,123,4324514),(1279,1,123,4324515),(1280,1,124,430),(1281,1,124,4324510),(1282,1,124,4324511),(1283,1,124,4324512),(1284,1,124,4324514),(1285,1,124,4324515),(1286,1,125,430),(1287,1,125,4324510),(1288,1,125,4324511),(1289,1,125,4324512),(1290,1,125,4324514),(1291,1,125,4324515),(1292,1,126,430),(1293,1,126,4324510),(1294,1,126,4324511),(1295,1,126,4324512),(1296,1,126,4324514),(1297,1,126,4324515),(1298,1,127,430),(1299,1,127,4324510),(1300,1,127,4324511),(1301,1,127,4324512),(1302,1,127,4324514),(1303,1,127,4324515),(1304,1,128,430),(1305,1,128,4324510),(1306,1,128,4324511),(1307,1,128,4324512),(1308,1,128,4324514),(1309,1,128,4324515),(1310,1,129,430),(1311,1,129,4324510),(1312,1,129,4324511),(1313,1,129,4324512),(1314,1,129,4324514),(1315,1,129,4324515),(1316,1,130,430),(1317,1,130,4324510),(1318,1,130,4324511),(1319,1,130,4324512),(1320,1,130,4324514),(1321,1,130,4324515),(1322,1,131,430),(1323,1,131,4324510),(1324,1,131,4324511),(1325,1,131,4324512),(1326,1,131,4324514),(1327,1,131,4324515),(1328,1,132,430),(1329,1,132,4324510),(1330,1,132,4324511),(1331,1,132,4324512),(1332,1,132,4324514),(1333,1,132,4324515),(1334,1,133,430),(1335,1,133,4324510),(1336,1,133,4324511),(1337,1,133,4324512),(1338,1,133,4324514),(1339,1,133,4324515),(1340,1,134,430),(1341,1,134,4324510),(1342,1,134,4324511),(1343,1,134,4324512),(1344,1,134,4324514),(1345,1,134,4324515),(1346,1,135,430),(1347,1,135,4324510),(1348,1,135,4324511),(1349,1,135,4324512),(1350,1,135,4324514),(1351,1,135,4324515),(1352,1,136,430),(1353,1,136,4324510),(1354,1,136,4324511),(1355,1,136,4324512),(1356,1,136,4324514),(1357,1,136,4324515),(1358,1,137,430),(1359,1,137,4324510),(1360,1,137,4324511),(1361,1,137,4324512),(1362,1,137,4324514),(1363,1,137,4324515),(1365,1,138,4324510),(1366,1,138,4324511),(1367,1,138,4324512),(1368,1,138,4324514),(1369,1,138,4324515),(1370,1,139,430),(1371,1,139,4324510),(1372,1,139,4324511),(1373,1,139,4324512),(1374,1,139,4324514),(1375,1,139,4324515),(1382,1,141,430),(1383,1,141,4324510),(1384,1,141,4324511),(1385,1,141,4324512),(1386,1,141,4324514),(1387,1,141,4324515),(1388,1,142,430),(1389,1,142,4324510),(1390,1,142,4324511),(1391,1,142,4324512),(1392,1,142,4324514),(1393,1,142,4324515),(3277,1,143,121),(3278,1,143,126),(3330,1,143,262),(3284,1,143,281),(3281,1,143,282),(3283,1,143,283),(3285,1,143,286),(1394,1,143,430),(1395,1,143,4324510),(1396,1,143,4324511),(1397,1,143,4324512),(1398,1,143,4324514),(1399,1,143,4324515),(1400,1,144,430),(1401,1,144,4324510),(1402,1,144,4324511),(1403,1,144,4324512),(1404,1,144,4324514),(1405,1,144,4324515),(1406,1,145,430),(1407,1,145,4324510),(1408,1,145,4324511),(1409,1,145,4324512),(1410,1,145,4324514),(1411,1,145,4324515),(1412,1,146,430),(1413,1,146,4324510),(1414,1,146,4324511),(1415,1,146,4324512),(1416,1,146,4324514),(1417,1,146,4324515),(1418,1,147,430),(1419,1,147,4324510),(1420,1,147,4324511),(1421,1,147,4324512),(1422,1,147,4324514),(1423,1,147,4324515),(3265,1,148,121),(3266,1,148,126),(3339,1,148,262),(3274,1,148,281),(3269,1,148,282),(3273,1,148,283),(3275,1,148,286),(1424,1,148,430),(1425,1,148,4324510),(1426,1,148,4324511),(1427,1,148,4324512),(1428,1,148,4324514),(1429,1,148,4324515),(1430,1,149,430),(1431,1,149,4324510),(1432,1,149,4324511),(1433,1,149,4324512),(1434,1,149,4324514),(1435,1,149,4324515),(1436,1,150,430),(1437,1,150,4324510),(1438,1,150,4324511),(1439,1,150,4324512),(1440,1,150,4324514),(1441,1,150,4324515),(1442,1,151,430),(1443,1,151,4324510),(1444,1,151,4324511),(1445,1,151,4324512),(1446,1,151,4324514),(1447,1,151,4324515),(1448,1,152,430),(1449,1,152,4324510),(1450,1,152,4324511),(1451,1,152,4324512),(1452,1,152,4324514),(1453,1,152,4324515),(1454,1,153,430),(1455,1,153,4324510),(1456,1,153,4324511),(1457,1,153,4324512),(1458,1,153,4324514),(1459,1,153,4324515),(1460,1,154,430),(1461,1,154,4324510),(1462,1,154,4324511),(1463,1,154,4324512),(1464,1,154,4324514),(1465,1,154,4324515),(1466,1,155,430),(1467,1,155,4324510),(1468,1,155,4324511),(1469,1,155,4324512),(1470,1,155,4324514),(1471,1,155,4324515),(3287,1,156,121),(3288,1,156,126),(3338,1,156,262),(3294,1,156,281),(3291,1,156,282),(3293,1,156,283),(3295,1,156,286),(1472,1,156,430),(1473,1,156,4324510),(1474,1,156,4324511),(1475,1,156,4324512),(1476,1,156,4324514),(1477,1,156,4324515),(1478,1,157,430),(1479,1,157,4324510),(1480,1,157,4324511),(1481,1,157,4324512),(1482,1,157,4324514),(1483,1,157,4324515),(1484,1,158,430),(1485,1,158,4324510),(1486,1,158,4324511),(1487,1,158,4324512),(1488,1,158,4324514),(1489,1,158,4324515),(1490,1,159,430),(1491,1,159,4324510),(1492,1,159,4324511),(1493,1,159,4324512),(1494,1,159,4324514),(1495,1,159,4324515),(1496,1,160,430),(1497,1,160,4324510),(1498,1,160,4324511),(1499,1,160,4324512),(1500,1,160,4324514),(1501,1,160,4324515),(1502,1,161,430),(1503,1,161,4324510),(1504,1,161,4324511),(1505,1,161,4324512),(1506,1,161,4324514),(1507,1,161,4324515),(1508,1,162,430),(1509,1,162,4324510),(1510,1,162,4324511),(1511,1,162,4324512),(1512,1,162,4324514),(1513,1,162,4324515),(1514,1,163,430),(1515,1,163,4324510),(1516,1,163,4324511),(1517,1,163,4324512),(1518,1,163,4324514),(1519,1,163,4324515),(1520,1,164,430),(1521,1,164,4324510),(1522,1,164,4324511),(1523,1,164,4324512),(1524,1,164,4324514),(1525,1,164,4324515),(1526,1,165,430),(1527,1,165,4324510),(1528,1,165,4324511),(1529,1,165,4324512),(1530,1,165,4324514),(1531,1,165,4324515),(1532,1,166,430),(1533,1,166,4324510),(1534,1,166,4324511),(1535,1,166,4324512),(1536,1,166,4324514),(1537,1,166,4324515),(1538,1,167,430),(1539,1,167,4324510),(1540,1,167,4324511),(1541,1,167,4324512),(1542,1,167,4324514),(1543,1,167,4324515),(1544,1,168,430),(1545,1,168,4324510),(1546,1,168,4324511),(1547,1,168,4324512),(1548,1,168,4324514),(1549,1,168,4324515),(1550,1,169,430),(1551,1,169,4324510),(1552,1,169,4324511),(1553,1,169,4324512),(1554,1,169,4324514),(1555,1,169,4324515),(1556,1,170,430),(1557,1,170,4324510),(1558,1,170,4324511),(1559,1,170,4324512),(1560,1,170,4324514),(1561,1,170,4324515),(1562,1,171,430),(1563,1,171,4324510),(1564,1,171,4324511),(1565,1,171,4324512),(1566,1,171,4324514),(1567,1,171,4324515),(1568,1,172,430),(1569,1,172,4324510),(1570,1,172,4324511),(1571,1,172,4324512),(1572,1,172,4324514),(1573,1,172,4324515),(1574,1,173,430),(1575,1,173,4324510),(1576,1,173,4324511),(1577,1,173,4324512),(1578,1,173,4324514),(1579,1,173,4324515),(1580,1,174,430),(1581,1,174,4324510),(1582,1,174,4324511),(1583,1,174,4324512),(1584,1,174,4324514),(1585,1,174,4324515),(1586,1,175,430),(1587,1,175,4324510),(1588,1,175,4324511),(1589,1,175,4324512),(1590,1,175,4324514),(1591,1,175,4324515),(1592,1,176,430),(1593,1,176,4324510),(1594,1,176,4324511),(1595,1,176,4324512),(1596,1,176,4324514),(1597,1,176,4324515),(1598,1,177,430),(1599,1,177,4324510),(1600,1,177,4324511),(1601,1,177,4324512),(1602,1,177,4324514),(1603,1,177,4324515),(1604,1,178,430),(1605,1,178,4324510),(1606,1,178,4324511),(1607,1,178,4324512),(1608,1,178,4324514),(1609,1,178,4324515),(1610,1,179,430),(1611,1,179,4324510),(1612,1,179,4324511),(1613,1,179,4324512),(1614,1,179,4324514),(1615,1,179,4324515),(1616,1,180,430),(1617,1,180,4324510),(1618,1,180,4324511),(1619,1,180,4324512),(1620,1,180,4324514),(1621,1,180,4324515),(1622,1,181,430),(1623,1,181,4324510),(1624,1,181,4324511),(1625,1,181,4324512),(1626,1,181,4324514),(1627,1,181,4324515),(1628,1,182,430),(1629,1,182,4324510),(1630,1,182,4324511),(1631,1,182,4324512),(1632,1,182,4324514),(1633,1,182,4324515),(1634,1,183,430),(1635,1,183,4324510),(1636,1,183,4324511),(1637,1,183,4324512),(1638,1,183,4324514),(1639,1,183,4324515),(1640,1,184,430),(1641,1,184,4324510),(1642,1,184,4324511),(1643,1,184,4324512),(1644,1,184,4324514),(1645,1,184,4324515),(1646,1,185,430),(1647,1,185,4324510),(1648,1,185,4324511),(1649,1,185,4324512),(1650,1,185,4324514),(1651,1,185,4324515),(1652,1,186,430),(1653,1,186,4324510),(1654,1,186,4324511),(1655,1,186,4324512),(1656,1,186,4324514),(1657,1,186,4324515),(3234,1,187,121),(3237,1,187,126),(3337,1,187,262),(3239,1,187,281),(3240,1,187,282),(3241,1,187,283),(3242,1,187,286),(1658,1,187,430),(3258,1,187,4324510),(3259,1,187,4324511),(3260,1,187,4324512),(3262,1,187,4324514),(3263,1,187,4324515),(1664,1,188,430),(1665,1,188,4324510),(1666,1,188,4324511),(1667,1,188,4324512),(1668,1,188,4324514),(1669,1,188,4324515),(1670,1,189,430),(1671,1,189,4324510),(1672,1,189,4324511),(1673,1,189,4324512),(1674,1,189,4324514),(1675,1,189,4324515),(1676,1,190,430),(1677,1,190,4324510),(1678,1,190,4324511),(1679,1,190,4324512),(1680,1,190,4324514),(1681,1,190,4324515),(1682,1,191,430),(1683,1,191,4324510),(1684,1,191,4324511),(1685,1,191,4324512),(1686,1,191,4324514),(1687,1,191,4324515),(1688,1,192,430),(1689,1,192,4324510),(1690,1,192,4324511),(1691,1,192,4324512),(1692,1,192,4324514),(1693,1,192,4324515),(1694,1,193,430),(1695,1,193,4324510),(1696,1,193,4324511),(1697,1,193,4324512),(1698,1,193,4324514),(1699,1,193,4324515),(1700,1,194,430),(1701,1,194,4324510),(1702,1,194,4324511),(1703,1,194,4324512),(1704,1,194,4324514),(1705,1,194,4324515),(1706,1,195,430),(1707,1,195,4324510),(1708,1,195,4324511),(1709,1,195,4324512),(1710,1,195,4324514),(1711,1,195,4324515),(1712,1,196,430),(1713,1,196,4324510),(1714,1,196,4324511),(1715,1,196,4324512),(1716,1,196,4324514),(1717,1,196,4324515),(1718,1,197,430),(1719,1,197,4324510),(1720,1,197,4324511),(1721,1,197,4324512),(1722,1,197,4324514),(1723,1,197,4324515),(1724,1,198,430),(1725,1,198,4324510),(1726,1,198,4324511),(1727,1,198,4324512),(1728,1,198,4324514),(1729,1,198,4324515),(1730,1,199,430),(1731,1,199,4324510),(1732,1,199,4324511),(1733,1,199,4324512),(1734,1,199,4324514),(1735,1,199,4324515),(1736,1,200,430),(1737,1,200,4324510),(1738,1,200,4324511),(1739,1,200,4324512),(1740,1,200,4324514),(1741,1,200,4324515),(1742,1,201,430),(1743,1,201,4324510),(1744,1,201,4324511),(1745,1,201,4324512),(1746,1,201,4324514),(1747,1,201,4324515),(3249,1,202,121),(3250,1,202,126),(3329,1,202,262),(3256,1,202,281),(3253,1,202,282),(3255,1,202,283),(3257,1,202,286),(1748,1,202,430),(1749,1,202,4324510),(1750,1,202,4324511),(1751,1,202,4324512),(1752,1,202,4324514),(1753,1,202,4324515),(1754,1,203,430),(1755,1,203,4324510),(1756,1,203,4324511),(1757,1,203,4324512),(1758,1,203,4324514),(1759,1,203,4324515),(1760,1,204,430),(1761,1,204,4324510),(1762,1,204,4324511),(1763,1,204,4324512),(1764,1,204,4324514),(1765,1,204,4324515),(1766,1,205,430),(1767,1,205,4324510),(1768,1,205,4324511),(1769,1,205,4324512),(1770,1,205,4324514),(1771,1,205,4324515),(1772,1,206,430),(1773,1,206,4324510),(1774,1,206,4324511),(1775,1,206,4324512),(1776,1,206,4324514),(1777,1,206,4324515),(1778,1,207,430),(1779,1,207,4324510),(1780,1,207,4324511),(1781,1,207,4324512),(1782,1,207,4324514),(1783,1,207,4324515),(1784,1,208,430),(1785,1,208,4324510),(1786,1,208,4324511),(1787,1,208,4324512),(1788,1,208,4324514),(1789,1,208,4324515),(1790,1,209,430),(1791,1,209,4324510),(1792,1,209,4324511),(1793,1,209,4324512),(1794,1,209,4324514),(1795,1,209,4324515),(3627,1,210,432505),(3616,1,210,432506),(3628,1,210,432507),(3228,1,210,4324510),(1798,1,210,4324511),(1799,1,210,4324512),(3229,1,210,4324513),(1800,1,210,4324514),(1801,1,210,4324515),(1802,1,211,430),(1803,1,211,4324510),(1804,1,211,4324511),(1805,1,211,4324512),(1806,1,211,4324514),(1807,1,211,4324515),(1808,1,212,430),(1809,1,212,4324510),(1810,1,212,4324511),(1811,1,212,4324512),(1812,1,212,4324514),(1813,1,212,4324515),(1815,1,213,4324510),(1816,1,213,4324511),(1817,1,213,4324512),(1818,1,213,4324514),(1819,1,213,4324515),(1820,1,214,430),(1821,1,214,4324510),(1822,1,214,4324511),(1823,1,214,4324512),(1824,1,214,4324514),(1825,1,214,4324515),(1826,1,215,430),(1827,1,215,4324510),(1828,1,215,4324511),(1829,1,215,4324512),(1830,1,215,4324514),(1831,1,215,4324515),(1832,1,216,430),(1833,1,216,4324510),(1834,1,216,4324511),(1835,1,216,4324512),(1836,1,216,4324514),(1837,1,216,4324515),(1838,1,217,430),(1839,1,217,4324510),(1840,1,217,4324511),(1841,1,217,4324512),(1842,1,217,4324514),(1843,1,217,4324515),(1844,1,218,430),(1845,1,218,4324510),(1846,1,218,4324511),(1847,1,218,4324512),(1848,1,218,4324514),(1849,1,218,4324515),(1850,1,219,430),(1851,1,219,4324510),(1852,1,219,4324511),(1853,1,219,4324512),(1854,1,219,4324514),(1855,1,219,4324515),(1856,1,220,430),(1857,1,220,4324510),(1858,1,220,4324511),(1859,1,220,4324512),(1860,1,220,4324514),(1861,1,220,4324515),(1862,1,221,430),(1863,1,221,4324510),(1864,1,221,4324511),(1865,1,221,4324512),(1866,1,221,4324514),(1867,1,221,4324515),(1868,1,222,430),(1869,1,222,4324510),(1870,1,222,4324511),(1871,1,222,4324512),(1872,1,222,4324514),(1873,1,222,4324515),(1874,1,223,430),(1875,1,223,4324510),(1876,1,223,4324511),(1877,1,223,4324512),(1878,1,223,4324514),(1879,1,223,4324515),(1880,1,224,430),(1881,1,224,4324510),(1882,1,224,4324511),(1883,1,224,4324512),(1884,1,224,4324514),(1885,1,224,4324515),(1886,1,225,430),(1887,1,225,4324510),(1888,1,225,4324511),(1889,1,225,4324512),(1890,1,225,4324514),(1891,1,225,4324515),(1892,1,226,430),(1893,1,226,4324510),(1894,1,226,4324511),(1895,1,226,4324512),(1896,1,226,4324514),(1897,1,226,4324515),(1898,1,227,430),(1899,1,227,4324510),(1900,1,227,4324511),(1901,1,227,4324512),(1902,1,227,4324514),(1903,1,227,4324515),(1904,1,228,430),(1905,1,228,4324510),(1906,1,228,4324511),(1907,1,228,4324512),(1908,1,228,4324514),(1909,1,228,4324515),(1910,1,229,430),(1911,1,229,4324510),(1912,1,229,4324511),(1913,1,229,4324512),(1914,1,229,4324514),(1915,1,229,4324515),(1916,1,230,430),(1917,1,230,4324510),(1918,1,230,4324511),(1919,1,230,4324512),(1920,1,230,4324514),(1921,1,230,4324515),(1922,1,231,430),(1923,1,231,4324510),(1924,1,231,4324511),(1925,1,231,4324512),(1926,1,231,4324514),(1927,1,231,4324515),(1928,1,232,430),(1929,1,232,4324510),(1930,1,232,4324511),(1931,1,232,4324512),(1932,1,232,4324514),(1933,1,232,4324515),(1934,1,233,430),(1935,1,233,4324510),(1936,1,233,4324511),(1937,1,233,4324512),(1938,1,233,4324514),(1939,1,233,4324515),(1940,1,234,430),(1941,1,234,4324510),(1942,1,234,4324511),(1943,1,234,4324512),(1944,1,234,4324514),(1945,1,234,4324515),(1946,1,235,430),(1947,1,235,4324510),(1948,1,235,4324511),(1949,1,235,4324512),(1950,1,235,4324514),(1951,1,235,4324515),(1952,1,236,430),(1953,1,236,4324510),(1954,1,236,4324511),(1955,1,236,4324512),(1956,1,236,4324514),(1957,1,236,4324515),(1958,1,237,430),(1959,1,237,4324510),(1960,1,237,4324511),(1961,1,237,4324512),(1962,1,237,4324514),(1963,1,237,4324515),(1964,1,238,430),(1965,1,238,4324510),(1966,1,238,4324511),(1967,1,238,4324512),(1968,1,238,4324514),(1969,1,238,4324515),(1970,1,239,430),(1971,1,239,4324510),(1972,1,239,4324511),(1973,1,239,4324512),(1974,1,239,4324514),(1975,1,239,4324515),(1976,1,240,430),(1977,1,240,4324510),(1978,1,240,4324511),(1979,1,240,4324512),(1980,1,240,4324514),(1981,1,240,4324515),(1982,1,241,430),(1983,1,241,4324510),(1984,1,241,4324511),(1985,1,241,4324512),(1986,1,241,4324514),(1987,1,241,4324515),(1988,1,242,430),(1989,1,242,4324510),(1990,1,242,4324511),(1991,1,242,4324512),(1992,1,242,4324514),(1993,1,242,4324515),(1994,1,243,430),(1995,1,243,4324510),(1996,1,243,4324511),(1997,1,243,4324512),(1998,1,243,4324514),(1999,1,243,4324515),(2000,1,244,430),(2001,1,244,4324510),(2002,1,244,4324511),(2003,1,244,4324512),(2004,1,244,4324514),(2005,1,244,4324515),(2006,1,245,430),(2007,1,245,4324510),(2008,1,245,4324511),(2009,1,245,4324512),(2010,1,245,4324514),(2011,1,245,4324515),(2012,1,246,430),(2013,1,246,4324510),(2014,1,246,4324511),(2015,1,246,4324512),(2016,1,246,4324514),(2017,1,246,4324515),(2018,1,247,430),(2019,1,247,4324510),(2020,1,247,4324511),(2021,1,247,4324512),(2022,1,247,4324514),(2023,1,247,4324515),(2024,1,248,430),(2025,1,248,4324510),(2026,1,248,4324511),(2027,1,248,4324512),(2028,1,248,4324514),(2029,1,248,4324515),(2030,1,249,430),(2031,1,249,4324510),(2032,1,249,4324511),(2033,1,249,4324512),(2034,1,249,4324514),(2035,1,249,4324515),(2036,1,250,430),(2037,1,250,4324510),(2038,1,250,4324511),(2039,1,250,4324512),(2040,1,250,4324514),(2041,1,250,4324515),(2042,1,251,430),(2043,1,251,4324510),(2044,1,251,4324511),(2045,1,251,4324512),(2046,1,251,4324514),(2047,1,251,4324515),(2048,1,252,430),(2049,1,252,4324510),(2050,1,252,4324511),(2051,1,252,4324512),(2052,1,252,4324514),(2053,1,252,4324515),(2054,1,253,430),(2055,1,253,4324510),(2056,1,253,4324511),(2057,1,253,4324512),(2058,1,253,4324514),(2059,1,253,4324515),(2060,1,254,430),(2061,1,254,4324510),(2062,1,254,4324511),(2063,1,254,4324512),(2064,1,254,4324514),(2065,1,254,4324515),(2066,1,255,430),(2067,1,255,4324510),(2068,1,255,4324511),(2069,1,255,4324512),(2070,1,255,4324514),(2071,1,255,4324515),(2072,1,256,430),(2073,1,256,4324510),(2074,1,256,4324511),(2075,1,256,4324512),(2076,1,256,4324514),(2077,1,256,4324515),(2078,1,257,430),(2079,1,257,4324510),(2080,1,257,4324511),(2081,1,257,4324512),(2082,1,257,4324514),(2083,1,257,4324515),(2084,1,258,430),(2085,1,258,4324510),(2086,1,258,4324511),(2087,1,258,4324512),(2088,1,258,4324514),(2089,1,258,4324515),(2090,1,259,430),(2091,1,259,4324510),(2092,1,259,4324511),(2093,1,259,4324512),(2094,1,259,4324514),(2095,1,259,4324515),(2096,1,260,430),(2097,1,260,4324510),(2098,1,260,4324511),(2099,1,260,4324512),(2100,1,260,4324514),(2101,1,260,4324515),(2102,1,261,430),(2103,1,261,4324510),(2104,1,261,4324511),(2105,1,261,4324512),(2106,1,261,4324514),(2107,1,261,4324515),(2108,1,262,430),(2109,1,262,4324510),(2110,1,262,4324511),(2111,1,262,4324512),(2112,1,262,4324514),(2113,1,262,4324515),(2114,1,263,430),(2115,1,263,4324510),(2116,1,263,4324511),(2117,1,263,4324512),(2118,1,263,4324514),(2119,1,263,4324515),(2120,1,264,430),(2121,1,264,4324510),(2122,1,264,4324511),(2123,1,264,4324512),(2124,1,264,4324514),(2125,1,264,4324515),(2126,1,265,430),(2127,1,265,4324510),(2128,1,265,4324511),(2129,1,265,4324512),(2130,1,265,4324514),(2131,1,265,4324515),(2132,1,266,430),(2133,1,266,4324510),(2134,1,266,4324511),(2135,1,266,4324512),(2136,1,266,4324514),(2137,1,266,4324515),(2138,1,267,430),(2139,1,267,4324510),(2140,1,267,4324511),(2141,1,267,4324512),(2142,1,267,4324514),(2143,1,267,4324515),(2144,1,268,430),(2145,1,268,4324510),(2146,1,268,4324511),(2147,1,268,4324512),(2148,1,268,4324514),(2149,1,268,4324515),(2150,1,269,430),(2151,1,269,4324510),(2152,1,269,4324511),(2153,1,269,4324512),(2154,1,269,4324514),(2155,1,269,4324515),(2156,1,270,430),(2157,1,270,4324510),(2158,1,270,4324511),(2159,1,270,4324512),(2160,1,270,4324514),(2161,1,270,4324515),(2162,1,271,430),(2163,1,271,4324510),(2164,1,271,4324511),(2165,1,271,4324512),(2166,1,271,4324514),(2167,1,271,4324515),(2168,1,272,430),(2169,1,272,4324510),(2170,1,272,4324511),(2171,1,272,4324512),(2172,1,272,4324514),(2173,1,272,4324515),(3629,1,273,432505),(3618,1,273,432506),(3630,1,273,432507),(2175,1,273,4324510),(2176,1,273,4324511),(2177,1,273,4324512),(2178,1,273,4324514),(2179,1,273,4324515),(2180,1,274,430),(2181,1,274,4324510),(2182,1,274,4324511),(2183,1,274,4324512),(2184,1,274,4324514),(2185,1,274,4324515),(2186,1,275,430),(2187,1,275,4324510),(2188,1,275,4324511),(2189,1,275,4324512),(2190,1,275,4324514),(2191,1,275,4324515),(2319,1,276,430),(2320,1,276,4324510),(2321,1,276,4324511),(2322,1,276,4324512),(2323,1,276,4324514),(2324,1,276,4324515),(2325,1,277,430),(2326,1,277,4324510),(2327,1,277,4324511),(2328,1,277,4324512),(2329,1,277,4324514),(2330,1,277,4324515),(2331,1,278,430),(2332,1,278,4324510),(2333,1,278,4324511),(2334,1,278,4324512),(2335,1,278,4324514),(2336,1,278,4324515),(2506,1,279,430),(2507,1,279,4324510),(2508,1,279,4324511),(2509,1,279,4324512),(2510,1,279,4324514),(2511,1,279,4324515),(2512,1,280,430),(2513,1,280,4324510),(2514,1,280,4324511),(2515,1,280,4324512),(2516,1,280,4324514),(2517,1,280,4324515),(2518,1,281,430),(2519,1,281,4324510),(2520,1,281,4324511),(2521,1,281,4324512),(2522,1,281,4324514),(2523,1,281,4324515),(2564,1,282,430),(2565,1,282,4324510),(2566,1,282,4324511),(2567,1,282,4324512),(2568,1,282,4324514),(2569,1,282,4324515),(2570,1,283,430),(2571,1,283,4324510),(2572,1,283,4324511),(2573,1,283,4324512),(2574,1,283,4324514),(2575,1,283,4324515),(2576,1,284,430),(2577,1,284,4324510),(2578,1,284,4324511),(2579,1,284,4324512),(2580,1,284,4324514),(2581,1,284,4324515),(2582,1,285,430),(2583,1,285,4324510),(2584,1,285,4324511),(2585,1,285,4324512),(2586,1,285,4324514),(2587,1,285,4324515),(2588,1,286,430),(2589,1,286,4324510),(2590,1,286,4324511),(2591,1,286,4324512),(2592,1,286,4324514),(2593,1,286,4324515),(2594,1,287,430),(2595,1,287,4324510),(2596,1,287,4324511),(2597,1,287,4324512),(2598,1,287,4324514),(2599,1,287,4324515),(2680,1,288,430),(2681,1,288,4324510),(2682,1,288,4324511),(2683,1,288,4324512),(2684,1,288,4324514),(2685,1,288,4324515),(2686,1,289,430),(2687,1,289,4324510),(2688,1,289,4324511),(2689,1,289,4324512),(2690,1,289,4324514),(2691,1,289,4324515),(2692,1,290,430),(2693,1,290,4324510),(2694,1,290,4324511),(2695,1,290,4324512),(2696,1,290,4324514),(2697,1,290,4324515),(2698,1,291,430),(2699,1,291,4324510),(2700,1,291,4324511),(2701,1,291,4324512),(2702,1,291,4324514),(2703,1,291,4324515),(2704,1,292,430),(2705,1,292,4324510),(2706,1,292,4324511),(2707,1,292,4324512),(2708,1,292,4324514),(2709,1,292,4324515),(2710,1,293,430),(2711,1,293,4324510),(2712,1,293,4324511),(2713,1,293,4324512),(2714,1,293,4324514),(2715,1,293,4324515),(3174,1,294,430),(3175,1,294,4324510),(3176,1,294,4324511),(3177,1,294,4324512),(3178,1,294,4324514),(3179,1,294,4324515),(3186,1,296,430),(3187,1,296,4324510),(3188,1,296,4324511),(3189,1,296,4324512),(3190,1,296,4324514),(3191,1,296,4324515),(3192,1,297,430),(3193,1,297,4324510),(3194,1,297,4324511),(3195,1,297,4324512),(3196,1,297,4324514),(3197,1,297,4324515),(3198,1,298,430),(3199,1,298,4324510),(3200,1,298,4324511),(3201,1,298,4324512),(3202,1,298,4324514),(3203,1,298,4324515),(3296,1,299,430),(3297,1,299,4324510),(3298,1,299,4324511),(3299,1,299,4324512),(3300,1,299,4324514),(3301,1,299,4324515),(3302,1,300,430),(3303,1,300,4324510),(3304,1,300,4324511),(3305,1,300,4324512),(3306,1,300,4324514),(3307,1,300,4324515),(3308,1,301,430),(3309,1,301,4324510),(3310,1,301,4324511),(3311,1,301,4324512),(3312,1,301,4324514),(3313,1,301,4324515),(3340,1,303,430),(3341,1,303,4324510),(3342,1,303,4324511),(3343,1,303,4324512),(3344,1,303,4324514),(3345,1,303,4324515),(3353,1,304,430),(3354,1,305,430),(3355,1,306,430),(3356,1,307,430),(3357,1,308,430),(3358,1,309,430),(3359,1,310,430),(3360,1,311,430),(3631,1,312,430);

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

CREATE TABLE `llx_usergroup` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(180) COLLATE utf8_unicode_ci 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 COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_name` (`nom`,`entity`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_usergroup` VALUES (2,'custom services manager',1,'2021-04-23 08:22:22','2021-04-23 08:22:22',NULL,NULL),(3,'TEAM 10',1,'2021-04-23 08:30:33','2021-04-23 08:30:33',NULL,NULL),(4,'TEA 00',1,'2021-05-24 19:48:50','2021-05-24 19:48:50',NULL,NULL),(5,'TESTEUR',1,'2021-07-06 12:49:32','2021-07-06 12:49:32',NULL,NULL);

--
-- 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_usergroup_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_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 AUTO_INCREMENT=276 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_usergroup_rights` VALUES (202,1,5,11),(203,1,5,12),(204,1,5,13),(205,1,5,14),(206,1,5,15),(207,1,5,16),(208,1,5,19),(209,1,5,21),(210,1,5,22),(211,1,5,24),(212,1,5,25),(213,1,5,26),(214,1,5,27),(215,1,5,28),(216,1,5,121),(217,1,5,122),(218,1,5,125),(219,1,5,126),(220,1,5,161),(221,1,5,162),(222,1,5,163),(223,1,5,164),(224,1,5,165),(225,1,5,167),(226,1,5,241),(227,1,5,242),(228,1,5,243),(229,1,5,251),(230,1,5,252),(231,1,5,253),(232,1,5,254),(233,1,5,255),(234,1,5,256),(235,1,5,262),(236,1,5,281),(237,1,5,282),(238,1,5,283),(239,1,5,286),(240,1,5,331),(241,1,5,332),(242,1,5,333),(243,1,5,341),(244,1,5,342),(245,1,5,343),(246,1,5,344),(247,1,5,351),(248,1,5,352),(249,1,5,353),(250,1,5,354),(251,1,5,358),(253,1,5,531),(254,1,5,532),(255,1,5,534),(256,1,5,538),(257,1,5,1201),(258,1,5,1202),(259,1,5,1321),(260,1,5,1322),(261,1,5,2401),(262,1,5,2402),(263,1,5,2403),(264,1,5,2411),(265,1,5,2412),(266,1,5,2413),(267,1,5,2414),(268,1,5,2501),(269,1,5,2503),(270,1,5,2515),(273,1,5,432505),(274,1,5,432506),(275,1,5,432507),(111,1,5,4324510),(112,1,5,4324511),(113,1,5,4324512),(114,1,5,4324513),(115,1,5,4324514),(116,1,5,4324515);

--
-- 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 AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_usergroup_user` VALUES (12,1,2,5),(13,1,5,5),(6,1,6,3),(11,1,6,5),(18,1,138,5),(7,1,181,4),(17,1,210,5),(10,1,213,5),(8,1,232,4),(16,1,273,5);

--
-- Table structure for table `llx_website`
--

CREATE TABLE `llx_website` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type_container` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'page',
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `maincolor` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `maincolorbis` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lang` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `otherlang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `fk_default_home` int(11) DEFAULT NULL,
  `use_manifest` int(11) DEFAULT NULL,
  `virtualhost` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `position` int(11) DEFAULT 0,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_website_ref` (`ref`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_website`
--


--
-- Table structure for table `llx_website_extrafields`
--

CREATE TABLE `llx_website_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_website_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_website_extrafields`
--


--
-- Table structure for table `llx_website_page`
--

CREATE TABLE `llx_website_page` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_website` int(11) NOT NULL,
  `type_container` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'page',
  `pageurl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `aliasalt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lang` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_page` int(11) DEFAULT NULL,
  `htmlheader` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `grabbed_from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `author_alias` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `allowed_in_frames` int(11) DEFAULT 0,
  `object_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_object` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_website_page_url` (`fk_website`,`pageurl`),
  CONSTRAINT `fk_website_page_website` FOREIGN KEY (`fk_website`) REFERENCES `llx_website` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_website_page`
--


--
-- Table structure for table `llx_zapier_hook`
--

CREATE TABLE `llx_zapier_hook` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `module` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `action` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `fk_user` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_zapier_hook`
--


--
-- Table structure for table `llx_zapier_hook_extrafields`
--

CREATE TABLE `llx_zapier_hook_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) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_zapier_hook_extrafields`
--


--
-- Dumping events for database 'paierhdolibarr'
--

--
-- Dumping routines for database 'paierhdolibarr'
--


