-- Dumping data for table `llx_product_customer_price_log`
--


--
-- Table structure for table `llx_product_extrafields`
--

CREATE TABLE `llx_product_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_product_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_extrafields`
--


--
-- Table structure for table `llx_product_fournisseur_price`
--

CREATE TABLE `llx_product_fournisseur_price` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_product` int(11) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `ref_fourn` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `desc_fourn` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_availability` int(11) DEFAULT NULL,
  `price` double(24,8) DEFAULT 0.00000000,
  `quantity` double DEFAULT NULL,
  `remise_percent` double NOT NULL DEFAULT 0,
  `remise` double NOT NULL DEFAULT 0,
  `unitprice` double(24,8) DEFAULT 0.00000000,
  `charges` double(24,8) DEFAULT 0.00000000,
  `default_vat_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `barcode` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT NULL,
  `tva_tx` double(6,3) NOT NULL,
  `localtax1_tx` double(6,3) DEFAULT 0.000,
  `localtax1_type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT 0.000,
  `localtax2_type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `info_bits` int(11) NOT NULL DEFAULT 0,
  `fk_user` int(11) DEFAULT NULL,
  `fk_supplier_price_expression` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `delivery_time_days` int(11) DEFAULT NULL,
  `supplier_reputation` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `packaging` varchar(64) 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_unitprice` double(24,8) DEFAULT NULL,
  `multicurrency_price` double(24,8) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_fournisseur_price_ref` (`ref_fourn`,`fk_soc`,`quantity`,`entity`),
  UNIQUE KEY `uk_product_barcode` (`barcode`,`fk_barcode_type`,`entity`),
  KEY `idx_product_fournisseur_price_fk_user` (`fk_user`),
  KEY `idx_product_fourn_price_fk_product` (`fk_product`,`entity`),
  KEY `idx_product_fourn_price_fk_soc` (`fk_soc`,`entity`),
  KEY `idx_product_barcode` (`barcode`),
  KEY `idx_product_fk_barcode_type` (`fk_barcode_type`),
  CONSTRAINT `fk_product_fournisseur_price_barcode_type` FOREIGN KEY (`fk_barcode_type`) REFERENCES `llx_c_barcode_type` (`rowid`),
  CONSTRAINT `fk_product_fournisseur_price_fk_product` FOREIGN KEY (`fk_product`) REFERENCES `llx_product` (`rowid`),
  CONSTRAINT `fk_product_fournisseur_price_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_fournisseur_price`
--


--
-- Table structure for table `llx_product_fournisseur_price_extrafields`
--

CREATE TABLE `llx_product_fournisseur_price_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_product_fournisseur_price_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_fournisseur_price_extrafields`
--


--
-- Table structure for table `llx_product_fournisseur_price_log`
--

CREATE TABLE `llx_product_fournisseur_price_log` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `fk_product_fournisseur` int(11) NOT NULL,
  `price` double(24,8) DEFAULT 0.00000000,
  `quantity` double DEFAULT NULL,
  `fk_user` int(11) 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_unitprice` double(24,8) DEFAULT NULL,
  `multicurrency_price` double(24,8) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_fournisseur_price_log`
--


--
-- Table structure for table `llx_product_lang`
--

CREATE TABLE `llx_product_lang` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product` int(11) NOT NULL DEFAULT 0,
  `lang` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_lang` (`fk_product`,`lang`),
  CONSTRAINT `fk_product_lang_fk_product` FOREIGN KEY (`fk_product`) REFERENCES `llx_product` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_lang`
--


--
-- Table structure for table `llx_product_lot`
--

CREATE TABLE `llx_product_lot` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT 1,
  `fk_product` int(11) NOT NULL,
  `batch` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `eatby` date DEFAULT NULL,
  `sellby` date DEFAULT NULL,
  `eol_date` datetime DEFAULT NULL,
  `manufacturing_date` datetime DEFAULT NULL,
  `scrapping_date` datetime 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,
  `import_key` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_lot` (`fk_product`,`batch`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_lot`
--


--
-- Table structure for table `llx_product_lot_extrafields`
--

CREATE TABLE `llx_product_lot_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_product_lot_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_lot_extrafields`
--


--
-- Table structure for table `llx_product_perentity`
--

CREATE TABLE `llx_product_perentity` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product` int(11) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `accountancy_code_sell` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_sell_intra` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_sell_export` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_buy` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_buy_intra` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_buy_export` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pmp` double(24,8) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_perentity` (`fk_product`,`entity`),
  KEY `idx_product_perentity_fk_product` (`fk_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_perentity`
--


--
-- Table structure for table `llx_product_price`
--

CREATE TABLE `llx_product_price` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_product` int(11) NOT NULL,
  `date_price` datetime NOT NULL,
  `price_level` smallint(6) DEFAULT 1,
  `price` double(24,8) DEFAULT NULL,
  `price_ttc` double(24,8) DEFAULT NULL,
  `price_min` double(24,8) DEFAULT NULL,
  `price_min_ttc` double(24,8) DEFAULT NULL,
  `price_base_type` varchar(3) COLLATE utf8_unicode_ci DEFAULT 'HT',
  `default_vat_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tva_tx` double(6,3) NOT NULL DEFAULT 0.000,
  `recuperableonly` int(11) NOT NULL DEFAULT 0,
  `localtax1_tx` double(6,3) DEFAULT 0.000,
  `localtax1_type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT 0.000,
  `localtax2_type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `fk_user_author` int(11) DEFAULT NULL,
  `tosell` tinyint(4) DEFAULT 1,
  `price_by_qty` int(11) NOT NULL DEFAULT 0,
  `fk_price_expression` int(11) DEFAULT NULL,
  `import_key` varchar(14) 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_price` double(24,8) DEFAULT NULL,
  `multicurrency_price_ttc` double(24,8) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_product_price_fk_user_author` (`fk_user_author`),
  KEY `idx_product_price_fk_product` (`fk_product`),
  CONSTRAINT `fk_product_price_product` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_product_price_user_author` FOREIGN KEY (`fk_product`) REFERENCES `llx_product` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_price`
--

INSERT INTO `llx_product_price` (`rowid`, `entity`, `tms`, `fk_product`, `date_price`, `price_level`, `price`, `price_ttc`, `price_min`, `price_min_ttc`, `price_base_type`, `default_vat_code`, `tva_tx`, `recuperableonly`, `localtax1_tx`, `localtax1_type`, `localtax2_tx`, `localtax2_type`, `fk_user_author`, `tosell`, `price_by_qty`, `fk_price_expression`, `import_key`, `fk_multicurrency`, `multicurrency_code`, `multicurrency_tx`, `multicurrency_price`, `multicurrency_price_ttc`) VALUES (1,2,'2021-10-15 13:16:23',191,'2021-10-15 13:16:23',1,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,20.000,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,1.00000000,NULL,NULL),(2,2,'2021-10-15 13:16:34',309,'2021-10-15 13:16:34',1,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,20.000,0,0.000,'0',0.000,'0',1,0,0,NULL,NULL,NULL,NULL,1.00000000,NULL,NULL),(3,2,'2021-10-15 13:16:58',310,'2021-10-15 13:16:58',1,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,20.000,0,0.000,'0',0.000,'0',1,0,0,NULL,NULL,NULL,NULL,1.00000000,NULL,NULL);

--
-- Table structure for table `llx_product_price_by_qty`
--

CREATE TABLE `llx_product_price_by_qty` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product_price` int(11) NOT NULL,
  `price` double(24,8) DEFAULT 0.00000000,
  `price_base_type` varchar(3) COLLATE utf8_unicode_ci DEFAULT 'HT',
  `quantity` double DEFAULT NULL,
  `remise_percent` double NOT NULL DEFAULT 0,
  `remise` double NOT NULL DEFAULT 0,
  `unitprice` double(24,8) DEFAULT 0.00000000,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) 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_price` double(24,8) DEFAULT NULL,
  `multicurrency_price_ttc` double(24,8) DEFAULT 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`),
  UNIQUE KEY `uk_product_price_by_qty_level` (`fk_product_price`,`quantity`),
  KEY `idx_product_price_by_qty_fk_product_price` (`fk_product_price`),
  CONSTRAINT `fk_product_price_by_qty_fk_product_price` FOREIGN KEY (`fk_product_price`) REFERENCES `llx_product_price` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_price_by_qty`
--


--
-- Table structure for table `llx_product_pricerules`
--

CREATE TABLE `llx_product_pricerules` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `level` int(11) NOT NULL,
  `fk_level` int(11) NOT NULL,
  `var_percent` double NOT NULL,
  `var_min_percent` double NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `unique_level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_pricerules`
--


--
-- Table structure for table `llx_product_stock`
--

CREATE TABLE `llx_product_stock` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_product` int(11) NOT NULL,
  `fk_entrepot` int(11) NOT NULL,
  `reel` double DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_stock` (`fk_product`,`fk_entrepot`),
  KEY `idx_product_stock_fk_product` (`fk_product`),
  KEY `idx_product_stock_fk_entrepot` (`fk_entrepot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_stock`
--


--
-- Table structure for table `llx_product_warehouse_properties`
--

CREATE TABLE `llx_product_warehouse_properties` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_product` int(11) NOT NULL,
  `fk_entrepot` int(11) NOT NULL,
  `seuil_stock_alerte` float DEFAULT 0,
  `desiredstock` float DEFAULT 0,
  `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_product_warehouse_properties`
--


--
-- Table structure for table `llx_projet`
--

CREATE TABLE `llx_projet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `dateo` date DEFAULT NULL,
  `datee` date DEFAULT NULL,
  `ref` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_creat` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `public` int(11) DEFAULT NULL,
  `fk_statut` int(11) NOT NULL DEFAULT 0,
  `fk_opp_status` int(11) DEFAULT NULL,
  `opp_percent` double(5,2) DEFAULT NULL,
  `fk_opp_status_end` int(11) DEFAULT NULL,
  `date_close` datetime DEFAULT NULL,
  `fk_user_close` int(11) DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_public` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `email_msgid` varchar(175) COLLATE utf8_unicode_ci DEFAULT NULL,
  `opp_amount` double(24,8) DEFAULT NULL,
  `budget_amount` double(24,8) DEFAULT NULL,
  `usage_opportunity` int(11) DEFAULT 0,
  `usage_task` int(11) DEFAULT 1,
  `usage_bill_time` int(11) DEFAULT 0,
  `usage_organize_event` int(11) DEFAULT 0,
  `accept_conference_suggestions` int(11) DEFAULT 0,
  `accept_booth_suggestions` int(11) DEFAULT 0,
  `price_registration` double(24,8) DEFAULT NULL,
  `price_booth` double(24,8) DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_main_doc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_projet_ref` (`ref`,`entity`),
  KEY `idx_projet_fk_soc` (`fk_soc`),
  CONSTRAINT `fk_projet_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_projet`
--


--
-- Table structure for table `llx_projet_extrafields`
--

CREATE TABLE `llx_projet_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_projet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_projet_extrafields`
--


--
-- Table structure for table `llx_projet_task`
--

CREATE TABLE `llx_projet_task` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_projet` int(11) NOT NULL,
  `fk_task_parent` int(11) NOT NULL DEFAULT 0,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `dateo` datetime DEFAULT NULL,
  `datee` datetime DEFAULT NULL,
  `datev` datetime DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `duration_effective` double DEFAULT 0,
  `planned_workload` double DEFAULT 0,
  `progress` int(11) DEFAULT 0,
  `priority` int(11) DEFAULT 0,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT 0,
  `note_private` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_public` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `rang` int(11) DEFAULT 0,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_projet_task_ref` (`ref`,`entity`),
  KEY `idx_projet_task_fk_projet` (`fk_projet`),
  KEY `idx_projet_task_fk_user_creat` (`fk_user_creat`),
  KEY `idx_projet_task_fk_user_valid` (`fk_user_valid`),
  CONSTRAINT `fk_projet_task_fk_projet` FOREIGN KEY (`fk_projet`) REFERENCES `llx_projet` (`rowid`),
  CONSTRAINT `fk_projet_task_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_projet_task_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_projet_task`
--


--
-- Table structure for table `llx_projet_task_extrafields`
--

CREATE TABLE `llx_projet_task_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_projet_task_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_projet_task_extrafields`
--


--
-- Table structure for table `llx_projet_task_time`
--

CREATE TABLE `llx_projet_task_time` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_task` int(11) NOT NULL,
  `task_date` date DEFAULT NULL,
  `task_datehour` datetime DEFAULT NULL,
  `task_date_withhour` int(11) DEFAULT 0,
  `task_duration` double DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `thm` double(24,8) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `invoice_line_id` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `note` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_projet_task_time_task` (`fk_task`),
  KEY `idx_projet_task_time_date` (`task_date`),
  KEY `idx_projet_task_time_datehour` (`task_datehour`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_projet_task_time`
--


--
-- Table structure for table `llx_propal`
--

CREATE TABLE `llx_propal` (
  `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,
  `ref_client` 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,
  `datep` date DEFAULT NULL,
  `fin_validite` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_signature` 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_signature` int(11) DEFAULT NULL,
  `fk_user_cloture` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT 0,
  `price` double DEFAULT 0,
  `remise_percent` double DEFAULT 0,
  `remise_absolue` double DEFAULT 0,
  `remise` double DEFAULT 0,
  `total_ht` double(24,8) DEFAULT 0.00000000,
  `total_tva` double(24,8) DEFAULT 0.00000000,
  `localtax1` double(24,8) DEFAULT 0.00000000,
  `localtax2` double(24,8) DEFAULT 0.00000000,
  `total_ttc` double(24,8) DEFAULT 0.00000000,
  `fk_account` int(11) DEFAULT NULL,
  `fk_currency` varchar(3) 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,
  `fk_warehouse` int(11) DEFAULT NULL,
  `fk_availability` int(11) DEFAULT NULL,
  `fk_input_reason` int(11) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_delivery_address` int(11) 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`),
  UNIQUE KEY `uk_propal_ref` (`ref`,`entity`),
  KEY `idx_propal_fk_soc` (`fk_soc`),
  KEY `idx_propal_fk_user_author` (`fk_user_author`),
  KEY `idx_propal_fk_user_valid` (`fk_user_valid`),
  KEY `idx_propal_fk_user_signature` (`fk_user_signature`),
  KEY `idx_propal_fk_user_cloture` (`fk_user_cloture`),
  KEY `idx_propal_fk_projet` (`fk_projet`),
  KEY `idx_propal_fk_account` (`fk_account`),
  KEY `idx_propal_fk_currency` (`fk_currency`),
  KEY `idx_propal_fk_warehouse` (`fk_warehouse`),
  CONSTRAINT `fk_propal_fk_projet` FOREIGN KEY (`fk_projet`) REFERENCES `llx_projet` (`rowid`),
  CONSTRAINT `fk_propal_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_propal_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_propal_fk_user_cloture` FOREIGN KEY (`fk_user_cloture`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_propal_fk_user_signature` FOREIGN KEY (`fk_user_signature`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_propal_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_propal`
--


--
-- Table structure for table `llx_propal_extrafields`
--

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

--
-- Dumping data for table `llx_propal_extrafields`
--


--
-- Table structure for table `llx_propal_merge_pdf_product`
--

CREATE TABLE `llx_propal_merge_pdf_product` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product` int(11) NOT NULL,
  `file_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_mod` int(11) NOT NULL,
  `datec` datetime 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_propal_merge_pdf_product`
--


--
-- Table structure for table `llx_propaldet`
--

CREATE TABLE `llx_propaldet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_propal` 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,
  `fk_unit` int(11) 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,
  PRIMARY KEY (`rowid`),
  KEY `idx_propaldet_fk_propal` (`fk_propal`),
  KEY `idx_propaldet_fk_product` (`fk_product`),
  KEY `fk_propaldet_fk_unit` (`fk_unit`),
  CONSTRAINT `fk_propaldet_fk_propal` FOREIGN KEY (`fk_propal`) REFERENCES `llx_propal` (`rowid`),
  CONSTRAINT `fk_propaldet_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_propaldet`
--


--
-- Table structure for table `llx_propaldet_extrafields`
--

CREATE TABLE `llx_propaldet_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,
  `show_total_ht` int(10) DEFAULT NULL,
  `show_reduc` int(10) DEFAULT NULL,
  `roomreservation_label_resa` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `roomreservation_room_resa` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `roomreservation_event_id` int(255) DEFAULT NULL,
  `roomreservation_total` double(24,8) DEFAULT NULL,
  `roomreservation_total_ttc` double(24,8) DEFAULT NULL,
  `roomreservation_start_date_resa` datetime DEFAULT NULL,
  `roomreservation_end_date_resa` datetime DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_propaldet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_propaldet_extrafields`
--


--
-- Table structure for table `llx_reception`
--

CREATE TABLE `llx_reception` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `ref` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_soc` int(11) NOT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `ref_ext` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_int` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_supplier` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `date_delivery` datetime DEFAULT NULL,
  `date_reception` datetime DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `tracking_number` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_statut` smallint(6) DEFAULT 0,
  `billed` smallint(6) DEFAULT 0,
  `height` float DEFAULT NULL,
  `width` float DEFAULT NULL,
  `size_units` int(11) DEFAULT NULL,
  `size` float DEFAULT NULL,
  `weight_units` int(11) DEFAULT NULL,
  `weight` float 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,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_reception_uk_ref` (`ref`,`entity`),
  KEY `idx_reception_fk_soc` (`fk_soc`),
  KEY `idx_reception_fk_user_author` (`fk_user_author`),
  KEY `idx_reception_fk_user_valid` (`fk_user_valid`),
  KEY `idx_reception_fk_shipping_method` (`fk_shipping_method`),
  CONSTRAINT `fk_reception_fk_shipping_method` FOREIGN KEY (`fk_shipping_method`) REFERENCES `llx_c_shipment_mode` (`rowid`),
  CONSTRAINT `fk_reception_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_reception_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_reception_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_reception`
--


--
-- Table structure for table `llx_reception_extrafields`
--

CREATE TABLE `llx_reception_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_reception_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_reception_extrafields`
--


--
-- Table structure for table `llx_recruitment_recruitmentcandidature`
--

CREATE TABLE `llx_recruitment_recruitmentcandidature` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '(PROV)',
  `fk_recruitmentjobposition` int(11) DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_public` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` smallint(6) NOT NULL,
  `firstname` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastname` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_birth` date DEFAULT NULL,
  `remuneration_requested` int(11) DEFAULT NULL,
  `remuneration_proposed` int(11) DEFAULT NULL,
  `email_msgid` varchar(175) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_recruitment_origin` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_recruitmentcandidature_email_msgid` (`email_msgid`),
  KEY `idx_recruitment_recruitmentcandidature_rowid` (`rowid`),
  KEY `idx_recruitment_recruitmentcandidature_ref` (`ref`),
  KEY `llx_recruitment_recruitmentcandidature_fk_user_creat` (`fk_user_creat`),
  KEY `idx_recruitment_recruitmentcandidature_status` (`status`),
  CONSTRAINT `llx_recruitment_recruitmentcandidature_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_recruitment_recruitmentcandidature`
--


--
-- Table structure for table `llx_recruitment_recruitmentcandidature_extrafields`
--

CREATE TABLE `llx_recruitment_recruitmentcandidature_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_recruitmentcandidature_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_recruitment_recruitmentcandidature_extrafields`
--


--
-- Table structure for table `llx_recruitment_recruitmentjobposition`
--

CREATE TABLE `llx_recruitment_recruitmentjobposition` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '(PROV)',
  `entity` int(11) NOT NULL DEFAULT 1,
  `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `qty` int(11) NOT NULL DEFAULT 1,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_project` int(11) DEFAULT NULL,
  `fk_user_recruiter` int(11) DEFAULT NULL,
  `email_recruiter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_supervisor` int(11) DEFAULT NULL,
  `fk_establishment` int(11) DEFAULT NULL,
  `date_planned` date DEFAULT NULL,
  `remuneration_suggested` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_public` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `last_main_doc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` smallint(6) NOT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_recruitment_recruitmentjobposition_rowid` (`rowid`),
  KEY `idx_recruitment_recruitmentjobposition_ref` (`ref`),
  KEY `idx_recruitment_recruitmentjobposition_fk_soc` (`fk_soc`),
  KEY `idx_recruitment_recruitmentjobposition_fk_project` (`fk_project`),
  KEY `llx_recruitment_recruitmentjobposition_fk_user_recruiter` (`fk_user_recruiter`),
  KEY `llx_recruitment_recruitmentjobposition_fk_user_supervisor` (`fk_user_supervisor`),
  KEY `llx_recruitment_recruitmentjobposition_fk_establishment` (`fk_establishment`),
  KEY `llx_recruitment_recruitmentjobposition_fk_user_creat` (`fk_user_creat`),
  KEY `idx_recruitment_recruitmentjobposition_status` (`status`),
  CONSTRAINT `llx_recruitment_recruitmentjobposition_fk_establishment` FOREIGN KEY (`fk_establishment`) REFERENCES `llx_establishment` (`rowid`),
  CONSTRAINT `llx_recruitment_recruitmentjobposition_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `llx_recruitment_recruitmentjobposition_fk_user_recruiter` FOREIGN KEY (`fk_user_recruiter`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `llx_recruitment_recruitmentjobposition_fk_user_supervisor` FOREIGN KEY (`fk_user_supervisor`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_recruitment_recruitmentjobposition`
--


--
-- Table structure for table `llx_recruitment_recruitmentjobposition_extrafields`
--

CREATE TABLE `llx_recruitment_recruitmentjobposition_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_recruitmentjobposition_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_recruitment_recruitmentjobposition_extrafields`
--


--
-- Table structure for table `llx_resource`
--

CREATE TABLE `llx_resource` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `asset_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_code_type_resource` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `date_valid` 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_statut` smallint(6) NOT NULL DEFAULT 0,
  `note_public` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_country` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_resource_ref` (`ref`,`entity`),
  KEY `fk_code_type_resource_idx` (`fk_code_type_resource`),
  KEY `idx_resource_fk_country` (`fk_country`),
  CONSTRAINT `fk_resource_fk_country` FOREIGN KEY (`fk_country`) REFERENCES `llx_c_country` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_resource`
--


--
-- Table structure for table `llx_resource_extrafields`
--

CREATE TABLE `llx_resource_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_resource_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_resource_extrafields`
--


--
-- Table structure for table `llx_rights_def`
--

CREATE TABLE `llx_rights_def` (
  `id` int(11) NOT NULL,
  `libelle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `module` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `module_position` int(11) NOT NULL DEFAULT 0,
  `family_position` int(11) NOT NULL DEFAULT 0,
  `entity` int(11) NOT NULL DEFAULT 1,
  `perms` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subperms` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bydefault` tinyint(4) DEFAULT 0,
  PRIMARY KEY (`id`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_rights_def`
--

INSERT INTO `llx_rights_def` (`id`, `libelle`, `module`, `module_position`, `family_position`, `entity`, `perms`, `subperms`, `type`, `bydefault`) VALUES (11,'Read invoices','facture',11,0,1,'lire',NULL,'a',0),(11,'Read invoices','facture',11,0,2,'lire',NULL,'a',0),(11,'Read invoices','facture',11,0,3,'lire',NULL,'a',0),(12,'Create and update invoices','facture',11,0,1,'creer',NULL,'a',0),(12,'Create and update invoices','facture',11,0,2,'creer',NULL,'a',0),(12,'Create and update invoices','facture',11,0,3,'creer',NULL,'a',0),(13,'Devalidate invoices','facture',11,0,1,'invoice_advance','unvalidate','a',0),(13,'Devalidate invoices','facture',11,0,2,'invoice_advance','unvalidate','a',0),(13,'Devalidate invoices','facture',11,0,3,'invoice_advance','unvalidate','a',0),(14,'Validate invoices','facture',11,0,1,'invoice_advance','validate','a',0),(14,'Validate invoices','facture',11,0,2,'invoice_advance','validate','a',0),(14,'Validate invoices','facture',11,0,3,'invoice_advance','validate','a',0),(15,'Send invoices by email','facture',11,0,1,'invoice_advance','send','a',0),(15,'Send invoices by email','facture',11,0,2,'invoice_advance','send','a',0),(15,'Send invoices by email','facture',11,0,3,'invoice_advance','send','a',0),(16,'Issue payments on invoices','facture',11,0,1,'paiement',NULL,'a',0),(16,'Issue payments on invoices','facture',11,0,2,'paiement',NULL,'a',0),(16,'Issue payments on invoices','facture',11,0,3,'paiement',NULL,'a',0),(19,'Delete invoices','facture',11,0,1,'supprimer',NULL,'a',0),(19,'Delete invoices','facture',11,0,2,'supprimer',NULL,'a',0),(19,'Delete invoices','facture',11,0,3,'supprimer',NULL,'a',0),(21,'Read commercial proposals','propale',10,0,1,'lire',NULL,'r',0),(21,'Read commercial proposals','propale',10,0,2,'lire',NULL,'r',0),(21,'Read commercial proposals','propale',10,0,3,'lire',NULL,'r',0),(22,'Create and update commercial proposals','propale',10,0,1,'creer',NULL,'w',0),(22,'Create and update commercial proposals','propale',10,0,2,'creer',NULL,'w',0),(22,'Create and update commercial proposals','propale',10,0,3,'creer',NULL,'w',0),(24,'Validate commercial proposals','propale',10,0,1,'propal_advance','validate','d',0),(24,'Validate commercial proposals','propale',10,0,2,'propal_advance','validate','d',0),(24,'Validate commercial proposals','propale',10,0,3,'propal_advance','validate','d',0),(25,'Send commercial proposals to customers','propale',10,0,1,'propal_advance','send','d',0),(25,'Send commercial proposals to customers','propale',10,0,2,'propal_advance','send','d',0),(25,'Send commercial proposals to customers','propale',10,0,3,'propal_advance','send','d',0),(26,'Close commercial proposals','propale',10,0,1,'propal_advance','close','d',0),(26,'Close commercial proposals','propale',10,0,2,'propal_advance','close','d',0),(26,'Close commercial proposals','propale',10,0,3,'propal_advance','close','d',0),(27,'Delete commercial proposals','propale',10,0,1,'supprimer',NULL,'d',0),(27,'Delete commercial proposals','propale',10,0,2,'supprimer',NULL,'d',0),(27,'Delete commercial proposals','propale',10,0,3,'supprimer',NULL,'d',0),(28,'Exporting commercial proposals and attributes','propale',10,0,1,'export',NULL,'r',0),(28,'Exporting commercial proposals and attributes','propale',10,0,2,'export',NULL,'r',0),(28,'Exporting commercial proposals and attributes','propale',10,0,3,'export',NULL,'r',0),(31,'Read products','produit',26,0,1,'lire',NULL,'r',0),(31,'Read products','produit',26,0,2,'lire',NULL,'r',0),(31,'Read products','produit',26,0,3,'lire',NULL,'r',0),(32,'Create/modify products','produit',26,0,1,'creer',NULL,'w',0),(32,'Create/modify products','produit',26,0,2,'creer',NULL,'w',0),(32,'Create/modify products','produit',26,0,3,'creer',NULL,'w',0),(34,'Delete products','produit',26,0,1,'supprimer',NULL,'d',0),(34,'Delete products','produit',26,0,2,'supprimer',NULL,'d',0),(34,'Delete products','produit',26,0,3,'supprimer',NULL,'d',0),(38,'Export products','produit',26,0,1,'export',NULL,'r',0),(38,'Export products','produit',26,0,2,'export',NULL,'r',0),(38,'Export products','produit',26,0,3,'export',NULL,'r',0),(39,'Ignore minimum price','produit',26,0,1,'ignore_price_min_advance',NULL,'r',0),(39,'Ignore minimum price','produit',26,0,2,'ignore_price_min_advance',NULL,'r',0),(39,'Ignore minimum price','produit',26,0,3,'ignore_price_min_advance',NULL,'r',0),(81,'Read sales orders','commande',11,0,1,'lire',NULL,'r',0),(81,'Read sales orders','commande',11,0,2,'lire',NULL,'r',0),(81,'Read sales orders','commande',11,0,3,'lire',NULL,'r',0),(82,'Creeat/modify sales orders','commande',11,0,1,'creer',NULL,'w',0),(82,'Creeat/modify sales orders','commande',11,0,2,'creer',NULL,'w',0),(82,'Creeat/modify sales orders','commande',11,0,3,'creer',NULL,'w',0),(84,'Validate sales orders','commande',11,0,1,'order_advance','validate','d',0),(84,'Validate sales orders','commande',11,0,2,'order_advance','validate','d',0),(84,'Validate sales orders','commande',11,0,3,'order_advance','validate','d',0),(86,'Send sale orders by email','commande',11,0,1,'order_advance','send','d',0),(86,'Send sale orders by email','commande',11,0,2,'order_advance','send','d',0),(86,'Send sale orders by email','commande',11,0,3,'order_advance','send','d',0),(87,'Close sale orders','commande',11,0,1,'order_advance','close','d',0),(87,'Close sale orders','commande',11,0,2,'order_advance','close','d',0),(87,'Close sale orders','commande',11,0,3,'order_advance','close','d',0),(88,'Cancel sale orders','commande',11,0,1,'order_advance','annuler','d',0),(88,'Cancel sale orders','commande',11,0,2,'order_advance','annuler','d',0),(88,'Cancel sale orders','commande',11,0,3,'order_advance','annuler','d',0),(89,'Delete sales orders','commande',11,0,1,'supprimer',NULL,'d',0),(89,'Delete sales orders','commande',11,0,2,'supprimer',NULL,'d',0),(89,'Delete sales orders','commande',11,0,3,'supprimer',NULL,'d',0),(91,'Lire les charges','tax',50,0,1,'charges','lire','r',0),(91,'Lire les charges','tax',50,0,2,'charges','lire','r',0),(91,'Lire les charges','tax',50,0,3,'charges','lire','r',0),(92,'Creer/modifier les charges','tax',50,0,1,'charges','creer','w',0),(92,'Creer/modifier les charges','tax',50,0,2,'charges','creer','w',0),(92,'Creer/modifier les charges','tax',50,0,3,'charges','creer','w',0),(93,'Supprimer les charges','tax',50,0,1,'charges','supprimer','d',0),(93,'Supprimer les charges','tax',50,0,2,'charges','supprimer','d',0),(93,'Supprimer les charges','tax',50,0,3,'charges','supprimer','d',0),(94,'Exporter les charges','tax',50,0,1,'charges','export','r',0),(94,'Exporter les charges','tax',50,0,2,'charges','export','r',0),(94,'Exporter les charges','tax',50,0,3,'charges','export','r',0),(111,'Read bank account and transactions','banque',51,0,1,'lire',NULL,'r',0),(111,'Read bank account and transactions','banque',51,0,2,'lire',NULL,'r',0),(111,'Read bank account and transactions','banque',51,0,3,'lire',NULL,'r',0),(112,'Creer/modifier montant/supprimer ecriture bancaire','banque',51,0,1,'modifier',NULL,'w',0),(112,'Creer/modifier montant/supprimer ecriture bancaire','banque',51,0,2,'modifier',NULL,'w',0),(112,'Creer/modifier montant/supprimer ecriture bancaire','banque',51,0,3,'modifier',NULL,'w',0),(113,'Configurer les comptes bancaires (creer, gerer categories)','banque',51,0,1,'configurer',NULL,'a',0),(113,'Configurer les comptes bancaires (creer, gerer categories)','banque',51,0,2,'configurer',NULL,'a',0),(113,'Configurer les comptes bancaires (creer, gerer categories)','banque',51,0,3,'configurer',NULL,'a',0),(114,'Rapprocher les ecritures bancaires','banque',51,0,1,'consolidate',NULL,'w',0),(114,'Rapprocher les ecritures bancaires','banque',51,0,2,'consolidate',NULL,'w',0),(114,'Rapprocher les ecritures bancaires','banque',51,0,3,'consolidate',NULL,'w',0),(115,'Exporter transactions et releves','banque',51,0,1,'export',NULL,'r',0),(115,'Exporter transactions et releves','banque',51,0,2,'export',NULL,'r',0),(115,'Exporter transactions et releves','banque',51,0,3,'export',NULL,'r',0),(116,'Virements entre comptes','banque',51,0,1,'transfer',NULL,'w',0),(116,'Virements entre comptes','banque',51,0,2,'transfer',NULL,'w',0),(116,'Virements entre comptes','banque',51,0,3,'transfer',NULL,'w',0),(117,'Gerer les envois de cheques','banque',51,0,1,'cheque',NULL,'w',0),(117,'Gerer les envois de cheques','banque',51,0,2,'cheque',NULL,'w',0),(117,'Gerer les envois de cheques','banque',51,0,3,'cheque',NULL,'w',0),(121,'Read third parties','societe',9,0,1,'lire',NULL,'r',0),(121,'Read third parties','societe',9,0,2,'lire',NULL,'r',0),(121,'Read third parties','societe',9,0,3,'lire',NULL,'r',0),(122,'Create and update third parties','societe',9,0,1,'creer',NULL,'w',0),(122,'Create and update third parties','societe',9,0,2,'creer',NULL,'w',0),(122,'Create and update third parties','societe',9,0,3,'creer',NULL,'w',0),(125,'Delete third parties','societe',9,0,1,'supprimer',NULL,'d',0),(125,'Delete third parties','societe',9,0,2,'supprimer',NULL,'d',0),(125,'Delete third parties','societe',9,0,3,'supprimer',NULL,'d',0),(126,'Export third parties','societe',9,0,1,'export',NULL,'r',0),(126,'Export third parties','societe',9,0,2,'export',NULL,'r',0),(126,'Export third parties','societe',9,0,3,'export',NULL,'r',0),(161,'Lire les contrats','contrat',0,0,1,'lire',NULL,'r',0),(162,'Creer / modifier les contrats','contrat',0,0,1,'creer',NULL,'w',0),(163,'Activer un service d\'un contrat','contrat',0,0,1,'activer',NULL,'w',0),(164,'Desactiver un service d\'un contrat','contrat',0,0,1,'desactiver',NULL,'w',0),(165,'Supprimer un contrat','contrat',0,0,1,'supprimer',NULL,'d',0),(167,'Export contracts','contrat',0,0,1,'export',NULL,'r',0),(241,'Lire les categories','categorie',20,0,1,'lire',NULL,'r',0),(241,'Lire les categories','categorie',20,0,2,'lire',NULL,'r',0),(241,'Lire les categories','categorie',20,0,3,'lire',NULL,'r',0),(242,'Creer/modifier les categories','categorie',20,0,1,'creer',NULL,'w',0),(242,'Creer/modifier les categories','categorie',20,0,2,'creer',NULL,'w',0),(242,'Creer/modifier les categories','categorie',20,0,3,'creer',NULL,'w',0),(243,'Supprimer les categories','categorie',20,0,1,'supprimer',NULL,'d',0),(243,'Supprimer les categories','categorie',20,0,2,'supprimer',NULL,'d',0),(243,'Supprimer les categories','categorie',20,0,3,'supprimer',NULL,'d',0),(251,'Consulter les autres utilisateurs','user',5,0,1,'user','lire','r',0),(251,'Consulter les autres utilisateurs','user',5,0,2,'user','lire','r',0),(251,'Consulter les autres utilisateurs','user',5,0,3,'user','lire','r',0),(252,'Consulter les permissions des autres utilisateurs','user',5,0,1,'user_advance','readperms','r',0),(252,'Consulter les permissions des autres utilisateurs','user',5,0,2,'user_advance','readperms','r',0),(252,'Consulter les permissions des autres utilisateurs','user',5,0,3,'user_advance','readperms','r',0),(253,'Creer/modifier utilisateurs internes et externes','user',5,0,1,'user','creer','w',0),(253,'Creer/modifier utilisateurs internes et externes','user',5,0,2,'user','creer','w',0),(253,'Creer/modifier utilisateurs internes et externes','user',5,0,3,'user','creer','w',0),(254,'Creer/modifier utilisateurs externes seulement','user',5,0,1,'user_advance','write','w',0),(254,'Creer/modifier utilisateurs externes seulement','user',5,0,2,'user_advance','write','w',0),(254,'Creer/modifier utilisateurs externes seulement','user',5,0,3,'user_advance','write','w',0),(255,'Modifier le mot de passe des autres utilisateurs','user',5,0,1,'user','password','w',0),(255,'Modifier le mot de passe des autres utilisateurs','user',5,0,2,'user','password','w',0),(255,'Modifier le mot de passe des autres utilisateurs','user',5,0,3,'user','password','w',0),(256,'Supprimer ou desactiver les autres utilisateurs','user',5,0,1,'user','supprimer','d',0),(256,'Supprimer ou desactiver les autres utilisateurs','user',5,0,2,'user','supprimer','d',0),(256,'Supprimer ou desactiver les autres utilisateurs','user',5,0,3,'user','supprimer','d',0),(262,'Read all third parties (and their objects) by internal users (otherwise only if commercial contact). Not effective for external users (limited to themselves).','societe',9,0,1,'client','voir','r',0),(262,'Read all third parties (and their objects) by internal users (otherwise only if commercial contact). Not effective for external users (limited to themselves).','societe',9,0,2,'client','voir','r',0),(262,'Read all third parties (and their objects) by internal users (otherwise only if commercial contact). Not effective for external users (limited to themselves).','societe',9,0,3,'client','voir','r',0),(281,'Read contacts','societe',9,0,1,'contact','lire','r',0),(281,'Read contacts','societe',9,0,2,'contact','lire','r',0),(281,'Read contacts','societe',9,0,3,'contact','lire','r',0),(282,'Create and update contact','societe',9,0,1,'contact','creer','w',0),(282,'Create and update contact','societe',9,0,2,'contact','creer','w',0),(282,'Create and update contact','societe',9,0,3,'contact','creer','w',0),(283,'Delete contacts','societe',9,0,1,'contact','supprimer','d',0),(283,'Delete contacts','societe',9,0,2,'contact','supprimer','d',0),(283,'Delete contacts','societe',9,0,3,'contact','supprimer','d',0),(286,'Export contacts','societe',9,0,1,'contact','export','d',0),(286,'Export contacts','societe',9,0,2,'contact','export','d',0),(286,'Export contacts','societe',9,0,3,'contact','export','d',0),(331,'Lire les bookmarks','bookmark',50,0,1,'lire',NULL,'r',0),(331,'Lire les bookmarks','bookmark',50,0,2,'lire',NULL,'r',0),(331,'Lire les bookmarks','bookmark',50,0,3,'lire',NULL,'r',0),(332,'Creer/modifier les bookmarks','bookmark',50,0,1,'creer',NULL,'r',0),(332,'Creer/modifier les bookmarks','bookmark',50,0,2,'creer',NULL,'r',0),(332,'Creer/modifier les bookmarks','bookmark',50,0,3,'creer',NULL,'r',0),(333,'Supprimer les bookmarks','bookmark',50,0,1,'supprimer',NULL,'r',0),(333,'Supprimer les bookmarks','bookmark',50,0,2,'supprimer',NULL,'r',0),(333,'Supprimer les bookmarks','bookmark',50,0,3,'supprimer',NULL,'r',0),(341,'Consulter ses propres permissions','user',5,0,1,'self_advance','readperms','r',0),(341,'Consulter ses propres permissions','user',5,0,2,'self_advance','readperms','r',0),(341,'Consulter ses propres permissions','user',5,0,3,'self_advance','readperms','r',0),(342,'Creer/modifier ses propres infos utilisateur','user',5,0,1,'self','creer','w',0),(342,'Creer/modifier ses propres infos utilisateur','user',5,0,2,'self','creer','w',0),(342,'Creer/modifier ses propres infos utilisateur','user',5,0,3,'self','creer','w',0),(343,'Modifier son propre mot de passe','user',5,0,1,'self','password','w',0),(343,'Modifier son propre mot de passe','user',5,0,2,'self','password','w',0),(343,'Modifier son propre mot de passe','user',5,0,3,'self','password','w',0),(344,'Modifier ses propres permissions','user',5,0,1,'self_advance','writeperms','w',0),(344,'Modifier ses propres permissions','user',5,0,2,'self_advance','writeperms','w',0),(344,'Modifier ses propres permissions','user',5,0,3,'self_advance','writeperms','w',0),(351,'Consulter les groupes','user',5,0,1,'group_advance','read','r',0),(351,'Consulter les groupes','user',5,0,2,'group_advance','read','r',0),(351,'Consulter les groupes','user',5,0,3,'group_advance','read','r',0),(352,'Consulter les permissions des groupes','user',5,0,1,'group_advance','readperms','r',0),(352,'Consulter les permissions des groupes','user',5,0,2,'group_advance','readperms','r',0),(352,'Consulter les permissions des groupes','user',5,0,3,'group_advance','readperms','r',0),(353,'Creer/modifier les groupes et leurs permissions','user',5,0,1,'group_advance','write','w',0),(353,'Creer/modifier les groupes et leurs permissions','user',5,0,2,'group_advance','write','w',0),(353,'Creer/modifier les groupes et leurs permissions','user',5,0,3,'group_advance','write','w',0),(354,'Supprimer ou desactiver les groupes','user',5,0,1,'group_advance','delete','d',0),(354,'Supprimer ou desactiver les groupes','user',5,0,2,'group_advance','delete','d',0),(354,'Supprimer ou desactiver les groupes','user',5,0,3,'group_advance','delete','d',0),(358,'Exporter les utilisateurs','user',5,0,1,'user','export','r',0),(358,'Exporter les utilisateurs','user',5,0,2,'user','export','r',0),(358,'Exporter les utilisateurs','user',5,0,3,'user','export','r',0),(511,'Read employee salaries and payments (yours and your subordinates)','salaries',50,0,2,'read',NULL,'r',0),(512,'Create/modify payments of empoyee salaries','salaries',50,0,2,'write',NULL,'w',0),(514,'Delete payments of employee salary','salaries',50,0,2,'delete',NULL,'d',0),(517,'Read salaries and payments of all employees','salaries',50,0,2,'readall',NULL,'r',0),(519,'Export payments of employee salaries','salaries',50,0,2,'export',NULL,'r',0),(531,'Read services','service',29,0,1,'lire',NULL,'r',0),(531,'Read services','service',29,0,2,'lire',NULL,'r',0),(531,'Read services','service',29,0,3,'lire',NULL,'r',0),(532,'Create/modify services','service',29,0,1,'creer',NULL,'w',0),(532,'Create/modify services','service',29,0,2,'creer',NULL,'w',0),(532,'Create/modify services','service',29,0,3,'creer',NULL,'w',0),(534,'Delete les services','service',29,0,1,'supprimer',NULL,'d',0),(534,'Delete les services','service',29,0,2,'supprimer',NULL,'d',0),(534,'Delete les services','service',29,0,3,'supprimer',NULL,'d',0),(538,'Export services','service',29,0,1,'export',NULL,'r',0),(538,'Export services','service',29,0,2,'export',NULL,'r',0),(538,'Export services','service',29,0,3,'export',NULL,'r',0),(1001,'Lire les stocks','stock',39,0,1,'lire',NULL,'r',0),(1001,'Lire les stocks','stock',39,0,2,'lire',NULL,'r',0),(1002,'Creer/Modifier les stocks','stock',39,0,1,'creer',NULL,'w',0),(1002,'Creer/Modifier les stocks','stock',39,0,2,'creer',NULL,'w',0),(1003,'Supprimer les stocks','stock',39,0,1,'supprimer',NULL,'d',0),(1003,'Supprimer les stocks','stock',39,0,2,'supprimer',NULL,'d',0),(1004,'Lire mouvements de stocks','stock',39,0,1,'mouvement','lire','r',0),(1004,'Lire mouvements de stocks','stock',39,0,2,'mouvement','lire','r',0),(1005,'Creer/modifier mouvements de stocks','stock',39,0,1,'mouvement','creer','w',0),(1005,'Creer/modifier mouvements de stocks','stock',39,0,2,'mouvement','creer','w',0),(1011,'inventoryReadPermission','stock',39,0,1,'inventory_advance','read','w',0),(1011,'inventoryReadPermission','stock',39,0,2,'inventory_advance','read','w',0),(1012,'inventoryCreatePermission','stock',39,0,1,'inventory_advance','write','w',0),(1012,'inventoryCreatePermission','stock',39,0,2,'inventory_advance','write','w',0),(1181,'Consulter les fournisseurs','fournisseur',12,0,1,'lire',NULL,'r',0),(1181,'Consulter les fournisseurs','fournisseur',12,0,2,'lire',NULL,'r',0),(1181,'Consulter les fournisseurs','fournisseur',12,0,3,'lire',NULL,'r',0),(1182,'Consulter les commandes fournisseur','fournisseur',12,0,1,'commande','lire','r',0),(1182,'Consulter les commandes fournisseur','fournisseur',12,0,2,'commande','lire','r',0),(1182,'Consulter les commandes fournisseur','fournisseur',12,0,3,'commande','lire','r',0),(1183,'Creer une commande fournisseur','fournisseur',12,0,1,'commande','creer','w',0),(1183,'Creer une commande fournisseur','fournisseur',12,0,2,'commande','creer','w',0),(1183,'Creer une commande fournisseur','fournisseur',12,0,3,'commande','creer','w',0),(1184,'Valider une commande fournisseur','fournisseur',12,0,1,'supplier_order_advance','validate','w',0),(1184,'Valider une commande fournisseur','fournisseur',12,0,2,'supplier_order_advance','validate','w',0),(1184,'Valider une commande fournisseur','fournisseur',12,0,3,'supplier_order_advance','validate','w',0),(1185,'Approuver une commande fournisseur','fournisseur',12,0,1,'commande','approuver','w',0),(1185,'Approuver une commande fournisseur','fournisseur',12,0,2,'commande','approuver','w',0),(1185,'Approuver une commande fournisseur','fournisseur',12,0,3,'commande','approuver','w',0),(1186,'Commander une commande fournisseur','fournisseur',12,0,1,'commande','commander','w',0),(1186,'Commander une commande fournisseur','fournisseur',12,0,2,'commande','commander','w',0),(1186,'Commander une commande fournisseur','fournisseur',12,0,3,'commande','commander','w',0),(1187,'Receptionner une commande fournisseur','fournisseur',12,0,1,'commande','receptionner','d',0),(1187,'Receptionner une commande fournisseur','fournisseur',12,0,2,'commande','receptionner','d',0),(1187,'Receptionner une commande fournisseur','fournisseur',12,0,3,'commande','receptionner','d',0),(1188,'Supprimer une commande fournisseur','fournisseur',12,0,1,'commande','supprimer','d',0),(1188,'Supprimer une commande fournisseur','fournisseur',12,0,2,'commande','supprimer','d',0),(1188,'Supprimer une commande fournisseur','fournisseur',12,0,3,'commande','supprimer','d',0),(1189,'Check/Uncheck a supplier order reception','fournisseur',12,0,1,'commande_advance','check','w',0),(1189,'Check/Uncheck a supplier order reception','fournisseur',12,0,2,'commande_advance','check','w',0),(1189,'Check/Uncheck a supplier order reception','fournisseur',12,0,3,'commande_advance','check','w',0),(1191,'Exporter les commande fournisseurs, attributs','fournisseur',12,0,1,'commande','export','r',0),(1191,'Exporter les commande fournisseurs, attributs','fournisseur',12,0,2,'commande','export','r',0),(1191,'Exporter les commande fournisseurs, attributs','fournisseur',12,0,3,'commande','export','r',0),(1231,'Consulter les factures fournisseur','fournisseur',12,0,1,'facture','lire','r',0),(1231,'Consulter les factures fournisseur','fournisseur',12,0,2,'facture','lire','r',0),(1231,'Consulter les factures fournisseur','fournisseur',12,0,3,'facture','lire','r',0),(1232,'Creer une facture fournisseur','fournisseur',12,0,1,'facture','creer','w',0),(1232,'Creer une facture fournisseur','fournisseur',12,0,2,'facture','creer','w',0),(1232,'Creer une facture fournisseur','fournisseur',12,0,3,'facture','creer','w',0),(1233,'Valider une facture fournisseur','fournisseur',12,0,1,'supplier_invoice_advance','validate','w',0),(1233,'Valider une facture fournisseur','fournisseur',12,0,2,'supplier_invoice_advance','validate','w',0),(1233,'Valider une facture fournisseur','fournisseur',12,0,3,'supplier_invoice_advance','validate','w',0),(1234,'Supprimer une facture fournisseur','fournisseur',12,0,1,'facture','supprimer','d',0),(1234,'Supprimer une facture fournisseur','fournisseur',12,0,2,'facture','supprimer','d',0),(1234,'Supprimer une facture fournisseur','fournisseur',12,0,3,'facture','supprimer','d',0),(1235,'Envoyer les factures par mail','fournisseur',12,0,1,'supplier_invoice_advance','send','a',0),(1235,'Envoyer les factures par mail','fournisseur',12,0,2,'supplier_invoice_advance','send','a',0),(1235,'Envoyer les factures par mail','fournisseur',12,0,3,'supplier_invoice_advance','send','a',0),(1236,'Exporter les factures fournisseurs, attributs et reglements','fournisseur',12,0,1,'facture','export','r',0),(1236,'Exporter les factures fournisseurs, attributs et reglements','fournisseur',12,0,2,'facture','export','r',0),(1236,'Exporter les factures fournisseurs, attributs et reglements','fournisseur',12,0,3,'facture','export','r',0),(1251,'Run mass imports of external data (data load)','import',0,0,1,'run',NULL,'r',0),(1251,'Run mass imports of external data (data load)','import',0,0,2,'run',NULL,'r',0),(1321,'Export customer invoices, attributes and payments','facture',11,0,1,'facture','export','r',0),(1321,'Export customer invoices, attributes and payments','facture',11,0,2,'facture','export','r',0),(1321,'Export customer invoices, attributes and payments','facture',11,0,3,'facture','export','r',0),(1322,'Re-open a fully paid invoice','facture',11,0,1,'invoice_advance','reopen','r',0),(1322,'Re-open a fully paid invoice','facture',11,0,2,'invoice_advance','reopen','r',0),(1322,'Re-open a fully paid invoice','facture',11,0,3,'invoice_advance','reopen','r',0),(1421,'Export sales orders and attributes','commande',11,0,1,'commande','export','r',0),(1421,'Export sales orders and attributes','commande',11,0,2,'commande','export','r',0),(1421,'Export sales orders and attributes','commande',11,0,3,'commande','export','r',0),(2401,'Read actions/tasks linked to his account','agenda',15,0,1,'myactions','read','r',0),(2401,'Read actions/tasks linked to his account','agenda',15,0,2,'myactions','read','r',1),(2401,'Read actions/tasks linked to his account','agenda',15,0,3,'myactions','read','r',0),(2402,'Create/modify actions/tasks linked to his account','agenda',15,0,1,'myactions','create','w',0),(2402,'Create/modify actions/tasks linked to his account','agenda',15,0,2,'myactions','create','w',0),(2402,'Create/modify actions/tasks linked to his account','agenda',15,0,3,'myactions','create','w',0),(2403,'Delete actions/tasks linked to his account','agenda',15,0,1,'myactions','delete','w',0),(2403,'Delete actions/tasks linked to his account','agenda',15,0,2,'myactions','delete','w',0),(2403,'Delete actions/tasks linked to his account','agenda',15,0,3,'myactions','delete','w',0),(2411,'Read actions/tasks of others','agenda',15,0,1,'allactions','read','r',0),(2411,'Read actions/tasks of others','agenda',15,0,2,'allactions','read','r',0),(2411,'Read actions/tasks of others','agenda',15,0,3,'allactions','read','r',0),(2412,'Create/modify actions/tasks of others','agenda',15,0,1,'allactions','create','w',0),(2412,'Create/modify actions/tasks of others','agenda',15,0,2,'allactions','create','w',0),(2412,'Create/modify actions/tasks of others','agenda',15,0,3,'allactions','create','w',0),(2413,'Delete actions/tasks of others','agenda',15,0,1,'allactions','delete','w',0),(2413,'Delete actions/tasks of others','agenda',15,0,2,'allactions','delete','w',0),(2413,'Delete actions/tasks of others','agenda',15,0,3,'allactions','delete','w',0),(2414,'Export actions/tasks of others','agenda',15,0,1,'export',NULL,'w',0),(2414,'Export actions/tasks of others','agenda',15,0,2,'export',NULL,'w',0),(2414,'Export actions/tasks of others','agenda',15,0,3,'export',NULL,'w',0),(3201,'Read archived events and fingerprints','blockedlog',0,0,1,'read',NULL,'w',0),(5001,'Read entities (For superadmin users)','multicompany',100001,0,1,'read',NULL,'r',0),(5001,'Read entities (For superadmin users)','multicompany',100001,0,2,'read',NULL,'r',0),(5001,'Read entities (For superadmin users)','multicompany',100001,0,3,'read',NULL,'r',0),(5002,'Create/modify entities (For superadmin users)','multicompany',100001,0,1,'write',NULL,'w',0),(5002,'Create/modify entities (For superadmin users)','multicompany',100001,0,2,'write',NULL,'w',0),(5002,'Create/modify entities (For superadmin users)','multicompany',100001,0,3,'write',NULL,'w',0),(5003,'Delete entities (For superadmin users)','multicompany',100001,0,1,'delete',NULL,'d',0),(5003,'Delete entities (For superadmin users)','multicompany',100001,0,2,'delete',NULL,'d',0),(5003,'Delete entities (For superadmin users)','multicompany',100001,0,3,'delete',NULL,'d',0),(5011,'Read shared third parties','multicompany',100001,0,1,'thirdparty','read','r',0),(5011,'Read shared third parties','multicompany',100001,0,2,'thirdparty','read','r',1),(5011,'Read shared third parties','multicompany',100001,0,3,'thirdparty','read','r',0),(5012,'Create/modify shared third parties','multicompany',100001,0,1,'thirdparty','write','w',0),(5012,'Create/modify shared third parties','multicompany',100001,0,2,'thirdparty','write','w',0),(5012,'Create/modify shared third parties','multicompany',100001,0,3,'thirdparty','write','w',0),(5013,'Delete shared third parties','multicompany',100001,0,1,'thirdparty','delete','d',0),(5013,'Delete shared third parties','multicompany',100001,0,2,'thirdparty','delete','d',0),(5013,'Delete shared third parties','multicompany',100001,0,3,'thirdparty','delete','d',0),(5021,'Read shared contacts','multicompany',100001,0,1,'contact','read','r',0),(5021,'Read shared contacts','multicompany',100001,0,2,'contact','read','r',1),(5021,'Read shared contacts','multicompany',100001,0,3,'contact','read','r',0),(5022,'Create/modify shared contacts','multicompany',100001,0,1,'contact','write','w',0),(5022,'Create/modify shared contacts','multicompany',100001,0,2,'contact','write','w',0),(5022,'Create/modify shared contacts','multicompany',100001,0,3,'contact','write','w',0),(5023,'Delete shared contacts','multicompany',100001,0,1,'contact','delete','d',0),(5023,'Delete shared contacts','multicompany',100001,0,2,'contact','delete','d',0),(5023,'Delete shared contacts','multicompany',100001,0,3,'contact','delete','d',0),(5031,'Read shared products/services','multicompany',100001,0,1,'product','read','r',0),(5031,'Read shared products/services','multicompany',100001,0,2,'product','read','r',0),(5031,'Read shared products/services','multicompany',100001,0,3,'product','read','r',0),(5032,'Create/modify shared products/services','multicompany',100001,0,1,'product','write','w',0),(5032,'Create/modify shared products/services','multicompany',100001,0,2,'product','write','w',0),(5032,'Create/modify shared products/services','multicompany',100001,0,3,'product','write','w',0),(5033,'Delete shared products/services','multicompany',100001,0,1,'product','delete','d',0),(5033,'Delete shared products/services','multicompany',100001,0,2,'product','delete','d',0),(5033,'Delete shared products/services','multicompany',100001,0,3,'product','delete','d',0),(5041,'Read shared customer proposals','multicompany',100001,0,1,'propal','read','r',0),(5041,'Read shared customer proposals','multicompany',100001,0,2,'propal','read','r',0),(5041,'Read shared customer proposals','multicompany',100001,0,3,'propal','read','r',0),(5042,'Create/modify shared customer proposals','multicompany',100001,0,1,'propal','write','w',0),(5042,'Create/modify shared customer proposals','multicompany',100001,0,2,'propal','write','w',0),(5042,'Create/modify shared customer proposals','multicompany',100001,0,3,'propal','write','w',0),(5043,'Validate shared customer proposals','multicompany',100001,0,1,'propal_advance','validate','d',0),(5043,'Validate shared customer proposals','multicompany',100001,0,2,'propal_advance','validate','d',0),(5043,'Validate shared customer proposals','multicompany',100001,0,3,'propal_advance','validate','d',0),(5044,'Send shared customer proposals','multicompany',100001,0,1,'propal_advance','send','d',0),(5044,'Send shared customer proposals','multicompany',100001,0,2,'propal_advance','send','d',0),(5044,'Send shared customer proposals','multicompany',100001,0,3,'propal_advance','send','d',0),(5045,'Close shared customer proposals','multicompany',100001,0,1,'propal','close','d',0),(5045,'Close shared customer proposals','multicompany',100001,0,2,'propal','close','d',0),(5045,'Close shared customer proposals','multicompany',100001,0,3,'propal','close','d',0),(5046,'Delete shared customer proposals','multicompany',100001,0,1,'propal','delete','d',0),(5046,'Delete shared customer proposals','multicompany',100001,0,2,'propal','delete','d',0),(5046,'Delete shared customer proposals','multicompany',100001,0,3,'propal','delete','d',0),(5051,'Read shared customer orders','multicompany',100001,0,1,'order','read','r',0),(5051,'Read shared customer orders','multicompany',100001,0,2,'order','read','r',0),(5051,'Read shared customer orders','multicompany',100001,0,3,'order','read','r',0),(5052,'Close shared customer orders','multicompany',100001,0,1,'order','write','w',0),(5052,'Close shared customer orders','multicompany',100001,0,2,'order','write','w',0),(5052,'Close shared customer orders','multicompany',100001,0,3,'order','write','w',0),(5054,'Validate shared customer orders','multicompany',100001,0,1,'order_advance','validate','d',0),(5054,'Validate shared customer orders','multicompany',100001,0,2,'order_advance','validate','d',0),(5054,'Validate shared customer orders','multicompany',100001,0,3,'order_advance','validate','d',0),(5056,'Send shared customer orders','multicompany',100001,0,1,'order_advance','send','d',0),(5056,'Send shared customer orders','multicompany',100001,0,2,'order_advance','send','d',0),(5056,'Send shared customer orders','multicompany',100001,0,3,'order_advance','send','d',0),(5057,'Close shared customer orders','multicompany',100001,0,1,'order','close','d',0),(5057,'Close shared customer orders','multicompany',100001,0,2,'order','close','d',0),(5057,'Close shared customer orders','multicompany',100001,0,3,'order','close','d',0),(5058,'Cancel shared customer orders','multicompany',100001,0,1,'order_advance','cancel','d',0),(5058,'Cancel shared customer orders','multicompany',100001,0,2,'order_advance','cancel','d',0),(5058,'Cancel shared customer orders','multicompany',100001,0,3,'order_advance','cancel','d',0),(5059,'Delete shared customer orders','multicompany',100001,0,1,'order','delete','d',0),(5059,'Delete shared customer orders','multicompany',100001,0,2,'order','delete','d',0),(5059,'Delete shared customer orders','multicompany',100001,0,3,'order','delete','d',0),(5061,'Read shared customer invoices','multicompany',100001,0,1,'invoice','read','a',0),(5061,'Read shared customer invoices','multicompany',100001,0,2,'invoice','read','a',0),(5061,'Read shared customer invoices','multicompany',100001,0,3,'invoice','read','a',0),(5062,'Create/modify shared customer invoices','multicompany',100001,0,1,'invoice','write','a',0),(5062,'Create/modify shared customer invoices','multicompany',100001,0,2,'invoice','write','a',0),(5062,'Create/modify shared customer invoices','multicompany',100001,0,3,'invoice','write','a',0),(5063,'Devalidate shared customer invoices','multicompany',100001,0,1,'invoice_advance','unvalidate','a',0),(5063,'Devalidate shared customer invoices','multicompany',100001,0,2,'invoice_advance','unvalidate','a',0),(5063,'Devalidate shared customer invoices','multicompany',100001,0,3,'invoice_advance','unvalidate','a',0),(5064,'Validate shared customer invoices','multicompany',100001,0,1,'invoice_advance','validate','a',0),(5064,'Validate shared customer invoices','multicompany',100001,0,2,'invoice_advance','validate','a',0),(5064,'Validate shared customer invoices','multicompany',100001,0,3,'invoice_advance','validate','a',0),(5065,'Send shared customer invoices','multicompany',100001,0,1,'invoice_advance','send','a',0),(5065,'Send shared customer invoices','multicompany',100001,0,2,'invoice_advance','send','a',0),(5065,'Send shared customer invoices','multicompany',100001,0,3,'invoice_advance','send','a',0),(5066,'Issue payments on shared customer invoices','multicompany',100001,0,1,'invoice','payment','a',0),(5066,'Issue payments on shared customer invoices','multicompany',100001,0,2,'invoice','payment','a',0),(5066,'Issue payments on shared customer invoices','multicompany',100001,0,3,'invoice','payment','a',0),(5067,'Re-open a fully paid shared customer invoices','multicompany',100001,0,1,'invoice_advance','reopen','r',0),(5067,'Re-open a fully paid shared customer invoices','multicompany',100001,0,2,'invoice_advance','reopen','r',0),(5067,'Re-open a fully paid shared customer invoices','multicompany',100001,0,3,'invoice_advance','reopen','r',0),(5069,'Delete shared customer invoices','multicompany',100001,0,1,'invoice','delete','a',0),(5069,'Delete shared customer invoices','multicompany',100001,0,2,'invoice','delete','a',0),(5069,'Delete shared customer invoices','multicompany',100001,0,3,'invoice','delete','a',0),(23001,'Read cron jobs','cron',0,0,1,'read',NULL,'w',0),(23002,'Create cron Jobs','cron',0,0,1,'create',NULL,'w',0),(23003,'Delete cron Jobs','cron',0,0,1,'delete',NULL,'w',0),(23004,'Execute cron Jobs','cron',0,0,1,'execute',NULL,'w',0),(50401,'Bind products and invoices with accounting accounts','accounting',61,0,1,'bind','write','r',0),(50401,'Bind products and invoices with accounting accounts','accounting',61,0,2,'bind','write','r',0),(50401,'Bind products and invoices with accounting accounts','accounting',61,0,3,'bind','write','r',0),(50411,'Read operations in Ledger','accounting',61,0,1,'mouvements','lire','r',0),(50411,'Read operations in Ledger','accounting',61,0,2,'mouvements','lire','r',0),(50411,'Read operations in Ledger','accounting',61,0,3,'mouvements','lire','r',0),(50412,'Write/Edit operations in Ledger','accounting',61,0,1,'mouvements','creer','w',0),(50412,'Write/Edit operations in Ledger','accounting',61,0,2,'mouvements','creer','w',0),(50412,'Write/Edit operations in Ledger','accounting',61,0,3,'mouvements','creer','w',0),(50414,'Delete operations in Ledger','accounting',61,0,1,'mouvements','supprimer','d',0),(50414,'Delete operations in Ledger','accounting',61,0,2,'mouvements','supprimer','d',0),(50414,'Delete operations in Ledger','accounting',61,0,3,'mouvements','supprimer','d',0),(50415,'Delete all operations by year and journal in Ledger','accounting',61,0,1,'mouvements','supprimer_tous','d',0),(50415,'Delete all operations by year and journal in Ledger','accounting',61,0,2,'mouvements','supprimer_tous','d',0),(50415,'Delete all operations by year and journal in Ledger','accounting',61,0,3,'mouvements','supprimer_tous','d',0),(50418,'Export operations of the Ledger','accounting',61,0,1,'mouvements','export','r',0),(50418,'Export operations of the Ledger','accounting',61,0,2,'mouvements','export','r',0),(50418,'Export operations of the Ledger','accounting',61,0,3,'mouvements','export','r',0),(50420,'Report and export reports (turnover, balance, journals, ledger)','accounting',61,0,1,'comptarapport','lire','r',0),(50420,'Report and export reports (turnover, balance, journals, ledger)','accounting',61,0,2,'comptarapport','lire','r',0),(50420,'Report and export reports (turnover, balance, journals, ledger)','accounting',61,0,3,'comptarapport','lire','r',0),(50430,'Manage fiscal periods, validate movements and close periods','accounting',61,0,1,'fiscalyear','write','r',0),(50430,'Manage fiscal periods, validate movements and close periods','accounting',61,0,2,'fiscalyear','write','r',0),(50430,'Manage fiscal periods, validate movements and close periods','accounting',61,0,3,'fiscalyear','write','r',0),(50440,'Manage chart of accounts, setup of accountancy','accounting',61,0,1,'chartofaccount',NULL,'r',0),(50440,'Manage chart of accounts, setup of accountancy','accounting',61,0,2,'chartofaccount',NULL,'r',0),(50440,'Manage chart of accounts, setup of accountancy','accounting',61,0,3,'chartofaccount',NULL,'r',0),(56001,'Read ticket','ticket',60,0,1,'read',NULL,'r',0),(56001,'Read ticket','ticket',60,0,2,'read',NULL,'r',0),(56002,'Create les tickets','ticket',60,0,1,'write',NULL,'w',0),(56002,'Create les tickets','ticket',60,0,2,'write',NULL,'w',0),(56003,'Delete les tickets','ticket',60,0,1,'delete',NULL,'d',0),(56003,'Delete les tickets','ticket',60,0,2,'delete',NULL,'d',0),(56004,'Manage tickets','ticket',60,0,1,'manage',NULL,'w',0),(56004,'Manage tickets','ticket',60,0,2,'manage',NULL,'w',0),(59001,'Visualiser les marges','margins',55,0,3,'liretous',NULL,'r',0),(59002,'Définir les marges','margins',55,0,3,'creer',NULL,'w',0),(59003,'Read every user margin','margins',55,0,3,'read','all','r',0),(432511,'Read objects of ImportASPCM','importaspcm',0,0,2,'read',NULL,'w',0),(432512,'Create/Update objects of ImportASPCM','importaspcm',0,0,2,'write',NULL,'w',0),(432513,'Delete objects of ImportASPCM','importaspcm',0,0,2,'delete',NULL,'w',0),(941601,'Lire les receptions','reception',40,0,2,'lire',NULL,'r',0),(941601,'Lire les receptions','reception',40,0,3,'lire',NULL,'r',0),(941602,'Creer modifier les receptions','reception',40,0,2,'creer',NULL,'w',0),(941602,'Creer modifier les receptions','reception',40,0,3,'creer',NULL,'w',0),(941603,'Valider les receptions','reception',40,0,2,'reception_advance','validate','d',0),(941603,'Valider les receptions','reception',40,0,3,'reception_advance','validate','d',0),(941604,'Envoyer les receptions aux clients','reception',40,0,2,'reception_advance','send','d',0),(941604,'Envoyer les receptions aux clients','reception',40,0,3,'reception_advance','send','d',0),(941605,'Exporter les receptions','reception',40,0,2,'reception','export','r',0),(941605,'Exporter les receptions','reception',40,0,3,'reception','export','r',0),(941606,'Supprimer les receptions','reception',40,0,2,'supprimer',NULL,'d',0),(941606,'Supprimer les receptions','reception',40,0,3,'supprimer',NULL,'d',0),(858369821,'SwitchUsers','userswitcher',100500,0,1,'use',NULL,'u',1),(858369821,'SwitchUsers','userswitcher',100500,0,2,'use',NULL,'u',0),(858369821,'SwitchUsers','userswitcher',100500,0,3,'use',NULL,'u',1);

--
-- Table structure for table `llx_salary`
--

CREATE TABLE `llx_salary` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_user` int(11) NOT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `salary` double(24,8) DEFAULT NULL,
  `amount` double(24,8) NOT NULL DEFAULT 0.00000000,
  `fk_projet` int(11) DEFAULT NULL,
  `fk_typepayment` int(11) NOT NULL,
  `num_payment` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datesp` date DEFAULT NULL,
  `dateep` date DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `note` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_bank` int(11) DEFAULT NULL,
  `paye` smallint(6) NOT NULL DEFAULT 0,
  `fk_account` int(11) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_salary`
--


--
-- Table structure for table `llx_salary_extrafields`
--

CREATE TABLE `llx_salary_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_salary_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_salary_extrafields`
--


--
-- Table structure for table `llx_session`
--

CREATE TABLE `llx_session` (
  `session_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `session_variable` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_accessed` datetime NOT NULL,
  `fk_user` int(11) NOT NULL,
  `remote_ip` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_agent` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_session`
--


--
-- Table structure for table `llx_societe`
--

CREATE TABLE `llx_societe` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name_alias` varchar(128) COLLATE utf8_unicode_ci DEFAULT 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,
  `statut` tinyint(4) DEFAULT 0,
  `parent` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `code_client` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_fournisseur` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_compta` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_compta_fournisseur` varchar(24) 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_departement` int(11) DEFAULT 0,
  `fk_pays` int(11) DEFAULT 0,
  `fk_account` int(11) DEFAULT 0,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `socialnetworks` text 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,
  `fk_effectif` int(11) DEFAULT 0,
  `fk_typent` int(11) DEFAULT NULL,
  `fk_forme_juridique` int(11) DEFAULT 0,
  `fk_currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `siren` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `siret` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ape` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idprof4` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idprof5` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idprof6` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tva_intra` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `capital` double(24,8) DEFAULT NULL,
  `fk_stcomm` int(11) NOT NULL DEFAULT 0,
  `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,
  `prefix_comm` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `client` tinyint(4) DEFAULT 0,
  `fournisseur` tinyint(4) DEFAULT 0,
  `supplier_account` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_prospectlevel` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `customer_bad` tinyint(4) DEFAULT 0,
  `customer_rate` double DEFAULT 0,
  `supplier_rate` double DEFAULT 0,
  `remise_client` double DEFAULT 0,
  `remise_supplier` double DEFAULT 0,
  `mode_reglement` tinyint(4) DEFAULT NULL,
  `cond_reglement` tinyint(4) DEFAULT NULL,
  `transport_mode` tinyint(4) DEFAULT NULL,
  `mode_reglement_supplier` tinyint(4) DEFAULT NULL,
  `cond_reglement_supplier` tinyint(4) DEFAULT NULL,
  `transport_mode_supplier` tinyint(4) DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `tva_assuj` tinyint(4) DEFAULT 1,
  `localtax1_assuj` tinyint(4) DEFAULT 0,
  `localtax1_value` double(6,3) DEFAULT NULL,
  `localtax2_assuj` tinyint(4) DEFAULT 0,
  `localtax2_value` double(6,3) DEFAULT NULL,
  `barcode` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT 0,
  `price_level` int(11) DEFAULT NULL,
  `outstanding_limit` double(24,8) DEFAULT NULL,
  `order_min_amount` double(24,8) DEFAULT NULL,
  `supplier_order_min_amount` double(24,8) DEFAULT NULL,
  `default_lang` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `logo_squarred` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `canvas` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_warehouse` int(11) DEFAULT NULL,
  `webservices_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `webservices_key` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_sell` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_buy` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_prefix_comm` (`prefix_comm`,`entity`),
  UNIQUE KEY `uk_societe_code_client` (`code_client`,`entity`),
  UNIQUE KEY `uk_societe_code_fournisseur` (`code_fournisseur`,`entity`),
  UNIQUE KEY `uk_societe_barcode` (`barcode`,`fk_barcode_type`,`entity`),
  KEY `idx_societe_user_creat` (`fk_user_creat`),
  KEY `idx_societe_user_modif` (`fk_user_modif`),
  KEY `idx_societe_stcomm` (`fk_stcomm`),
  KEY `idx_societe_pays` (`fk_pays`),
  KEY `idx_societe_account` (`fk_account`),
  KEY `idx_societe_prospectlevel` (`fk_prospectlevel`),
  KEY `idx_societe_typent` (`fk_typent`),
  KEY `idx_societe_forme_juridique` (`fk_forme_juridique`),
  KEY `idx_societe_shipping_method` (`fk_shipping_method`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe`
--

INSERT INTO `llx_societe` (`rowid`, `nom`, `name_alias`, `entity`, `ref_ext`, `ref_int`, `statut`, `parent`, `status`, `code_client`, `code_fournisseur`, `code_compta`, `code_compta_fournisseur`, `address`, `zip`, `town`, `fk_departement`, `fk_pays`, `fk_account`, `phone`, `fax`, `url`, `email`, `socialnetworks`, `skype`, `twitter`, `facebook`, `linkedin`, `instagram`, `snapchat`, `googleplus`, `youtube`, `whatsapp`, `fk_effectif`, `fk_typent`, `fk_forme_juridique`, `fk_currency`, `siren`, `siret`, `ape`, `idprof4`, `idprof5`, `idprof6`, `tva_intra`, `capital`, `fk_stcomm`, `note_private`, `note_public`, `model_pdf`, `prefix_comm`, `client`, `fournisseur`, `supplier_account`, `fk_prospectlevel`, `fk_incoterms`, `location_incoterms`, `customer_bad`, `customer_rate`, `supplier_rate`, `remise_client`, `remise_supplier`, `mode_reglement`, `cond_reglement`, `transport_mode`, `mode_reglement_supplier`, `cond_reglement_supplier`, `transport_mode_supplier`, `fk_shipping_method`, `tva_assuj`, `localtax1_assuj`, `localtax1_value`, `localtax2_assuj`, `localtax2_value`, `barcode`, `fk_barcode_type`, `price_level`, `outstanding_limit`, `order_min_amount`, `supplier_order_min_amount`, `default_lang`, `logo`, `logo_squarred`, `canvas`, `fk_warehouse`, `webservices_url`, `webservices_key`, `accountancy_code_sell`, `accountancy_code_buy`, `tms`, `datec`, `fk_user_creat`, `fk_user_modif`, `fk_multicurrency`, `multicurrency_code`, `import_key`) VALUES (1,'ABL ASSOCIES','',2,NULL,NULL,1,NULL,1,'ABL',NULL,NULL,NULL,'PAU CITE MULTIMEDIA BATIMENT D 3 RUE THOMAS EDISON','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'sandrine.ganzagain@abl-avocats.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(2,'ACSIE','',2,NULL,NULL,1,NULL,1,'ACSIE',NULL,NULL,NULL,'1, rue Thomas Edison BATIMENT B','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(3,'SITEL','',2,NULL,NULL,1,NULL,1,'ACTI',NULL,NULL,NULL,'COMPTABILITE FOURNISSEURS 52, Boulevard Haussmann','75009','PARIS',82,1,0,'',NULL,NULL,'compta@sitel.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(4,'ADEFIM AQUITAINE','',2,NULL,NULL,1,NULL,1,'ADEFIM',NULL,NULL,NULL,'4, rue des frères d Orbigny','64075','PAU CEDEX',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(5,'ADS 64 - Agence Petits-fils','',2,NULL,NULL,1,NULL,1,'ADS',NULL,NULL,NULL,'2, RUE THOMAS EDISON','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'pierre.laran@petits-fils.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(6,'AFIS FORMATION','',2,NULL,NULL,1,NULL,1,'AFIS',NULL,NULL,NULL,'Bâtiment B 1, rue Thomas Edison','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'contact@afis-formation.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(7,'ALLIADIS','',2,NULL,NULL,1,NULL,1,'ALLIA',NULL,NULL,NULL,'3 IMPASSE DES CHENES CS 88633','79026','NIORT CEDEX',86,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(8,'ALPHA MAINTENANCE','',2,NULL,NULL,1,NULL,1,'ALPHA',NULL,NULL,NULL,'18, rue l Amiral Cécile N° TVA : FR92410577100','76100','ROUEN',83,1,0,'02 35 73 39 19',NULL,NULL,'ALPHAMAINTENANCE@email.basware.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(9,'ALT CONSEIL','',2,NULL,NULL,1,NULL,1,'ALTCONS',NULL,NULL,NULL,'2 RUE THOMAS EDISON','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(10,'LHH ALTEDIA','',2,NULL,NULL,1,NULL,1,'ALTEDIA',NULL,NULL,NULL,'SERVICE COMPTABILITÉ FOURNISSEURS 7/11 QUAI ANDRE CITROEN CS 81614','75015','PARIS',82,1,0,'',NULL,NULL,'serv.fournisseursLHH@lhh.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(11,'ANGLOFILE','',2,NULL,NULL,1,NULL,1,'ANGLO',NULL,NULL,NULL,'PAU CITE MULTIMEDIA BAT C 4, rue Thomas Edison','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'contact@anglofile.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(12,'EURL ANN EVENTS','',2,NULL,NULL,1,NULL,1,'ANNEVEN',NULL,NULL,NULL,'5, rue l Estap','9110','ORLU',98,1,0,'',NULL,NULL,'as.martuchou@events.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(13,'ANTROPICA','',2,NULL,NULL,1,NULL,1,'ANTROPI',NULL,NULL,NULL,'2, rue Thomas Edison BATIMENT A','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(14,'AQUITAINE RECRUTEMENT','',2,NULL,NULL,1,NULL,1,'AQUITAI',NULL,NULL,NULL,'IMMEUBLE PELUS PLAZA ENTREE D 16 RUE PYTHAGORE','33700','MERIGNAC',40,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(15,'PARENTS ELEVES ARTHEZ D ASSON','',2,NULL,NULL,1,NULL,1,'ASSOART',NULL,NULL,NULL,'LE BOURG','64800','ARTHEZ D ASSON',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(16,'GROUPE AVEM','',2,NULL,NULL,1,NULL,1,'ATEM',NULL,NULL,NULL,'Service comptabilité - TSA 70090','69307','LYON Cedex 07',76,1,0,'',NULL,NULL,'factures@avem-groupe.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(17,'GIE AXA FRANCE','',2,NULL,NULL,1,NULL,1,'AXA',NULL,NULL,NULL,'Centre de gestion les Terrasses  TSA 16709','95901','CERGY PONTOISE CEDEX',102,1,0,'',NULL,NULL,'Factures.pdf.simple@axa.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(18,'Mme BAUDRY-JAMBES Christelle','',2,NULL,NULL,1,NULL,1,'BAUDRY',NULL,NULL,NULL,'PAU CITE MULTIMEDIA BAT A 2, rue Thomas Edison','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'president@aspcm.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(19,'AGENCE BLISS','',2,NULL,NULL,1,NULL,1,'BLISS',NULL,NULL,NULL,'13 RUE JOHANNES KEPLER ZONE EUROPA','64000','PAU',71,1,0,'',NULL,NULL,'emmanuel@agencebliss.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(20,'BME CONSULTING FRANCE','',2,NULL,NULL,1,NULL,1,'BME',NULL,NULL,NULL,'20, Chemin Louis Chirpaz Allée C','69130','ECULLY',76,1,0,'',NULL,NULL,'invoice@sourcing-force.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(21,'SELAS EGIDE','',2,NULL,NULL,1,NULL,1,'BRENAC',NULL,NULL,NULL,'23 RUE DELCASSE A L ATTENTION DE Marjorie CHAPOT','9000','FOIX',97,1,0,'',NULL,NULL,'sandrine.paroche@mj-athena.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(22,'CAPBP','',2,NULL,NULL,1,NULL,1,'CAPBP',NULL,NULL,NULL,'HOTEL DE FRANCE','64000','PAU',71,1,0,'',NULL,NULL,'c.bovio@agglo-pau.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(23,'EMC COMPUTER SYSTEMS France SA','',2,NULL,NULL,1,NULL,1,'CAPTIVA',NULL,NULL,NULL,'Accounts Payable PO BOX 756 South City Delivery Off TOGHER','0','CORK IRELAND',0,8,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(24,'CAROIL','',2,NULL,NULL,1,NULL,1,'CAROIL',NULL,NULL,NULL,'51, rue d Anjou','75008','PARIS',82,1,0,'',NULL,NULL,'JeanLouis.Rossi@caroil.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(25,'CAVAILLE','PHILIPPE',2,NULL,NULL,1,NULL,1,'CAVAILL',NULL,NULL,NULL,'Société AXA 3 rue Thomas Edison','64000','PAU',71,1,0,'',NULL,NULL,'philippe.cavaille@axa.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(26,'CDAPBP','',2,NULL,NULL,1,NULL,1,'CDAPBP',NULL,NULL,NULL,'Service Emploi et valorisation des compétences','64000','PAU',71,1,0,'',NULL,NULL,'abernoussihazim@agglo-pau.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(27,'CITYA PYRENEES OCEAN','',2,NULL,NULL,1,NULL,1,'CITYA',NULL,NULL,NULL,'241, Boulevard de la Paix','64000','PAU',71,1,0,'05 59 11 09 00',NULL,NULL,'pyreneesocean.facturations@citya.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(28,'CNFPT','',2,NULL,NULL,1,NULL,1,'CNFPT',NULL,NULL,NULL,'7, rue Mickael Faraday BP 552','64010','PAU CEDEX',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(29,'MME COMMENGES Marie-Laure','',2,NULL,NULL,1,NULL,1,'COMMENG',NULL,NULL,NULL,'41, rue du plateau','64320','LEE',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(30,'COSOLUCE','',2,NULL,NULL,1,NULL,1,'COSOLUC',NULL,NULL,NULL,'20, rue Johannes Kepler','64000','PAU',71,1,0,'05 59 14 03 47',NULL,NULL,'contact@cosoluce.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(31,'BANQUE COURTOIS','',2,NULL,NULL,1,NULL,1,'COURTOI',NULL,NULL,NULL,'Service communication 33, rue de Rémusat','31000','TOULOUSE',38,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(32,'CREASUD','',2,NULL,NULL,1,NULL,1,'CREASUD',NULL,NULL,NULL,'93-97 rue du Souvenir Français','64230','LESCAR',71,1,0,'',NULL,NULL,'contact@creasud.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(33,'CREATIV EXPERTIZ SUD-OUEST','',2,NULL,NULL,1,NULL,1,'CREATIV',NULL,NULL,NULL,'Rue du 8 mai 1945 Zone Jean Zay','33150','CENON',40,1,0,'',NULL,NULL,'comptabilite@creativexpertiz.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(34,'DEF','',2,NULL,NULL,1,NULL,1,'DEF',NULL,NULL,NULL,'9, rue du Saule Trapu Parc d activité‚ TECHNELLYS  BAT E','91300','MASSY',98,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(35,'HOLDING DESPAGNET PATRICK','',2,NULL,NULL,1,NULL,1,'DESPA',NULL,NULL,NULL,'ROUTE DE PAU','64800','ARROS DE NAY',71,1,0,'',NULL,NULL,'celine.suarez@despagnet.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(36,'DIVERS','',2,NULL,NULL,1,NULL,1,'DIVERS',NULL,NULL,NULL,'','0','',0,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(37,'SAS DON DU SENS','',2,NULL,NULL,1,NULL,1,'DON',NULL,NULL,NULL,'Bâtiment C 4, rue Thomas Edison','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'sebastiengaume65@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(38,'ECONOCOM INFOGERANCE SYSTEMES','',2,NULL,NULL,1,NULL,1,'ECONOCO',NULL,NULL,NULL,'Service Comptabilité Fournisseurs 21, Avenue Descartes','92350','LE PLESSIS-ROBINSON',99,1,0,'',NULL,NULL,'comptafourn.econocomservices@econocom.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(39,'EDEN AUTO SERVICES','',2,NULL,NULL,1,NULL,1,'EDENAUT',NULL,NULL,NULL,' A l attention de M. STIERLEN Eric 28 AVENUE DIDIER DAURAT','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(40,'CAISSE D EPARGNE AQUITAINE POITOU CHARENTES','',2,NULL,NULL,1,NULL,1,'EPARGNE',NULL,NULL,NULL,'18 AVENUE DE LA GARE','40100','DAX',47,1,0,'',NULL,NULL,'muriel.audebert@ceapc.caisse-epargne.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(41,'ERYMA Groupe SOGETREL','',2,NULL,NULL,1,NULL,1,'ERY',NULL,NULL,NULL,'Service comptabilité fournisseurs 5, rue St Léon  CS 90132','54003','NANCY',61,1,0,'',NULL,NULL,'factures.fournisseurs@eryma.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(42,'GROUPE ESC PAU','',2,NULL,NULL,1,NULL,1,'ESC',NULL,NULL,NULL,'3 RUE SAINT JOHN PERSE BP 7512','64075','PAU CEDEX',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(43,'SCI ESPACE EDISON','',2,NULL,NULL,1,NULL,1,'ESPEDIS',NULL,NULL,NULL,'9 RUE DE BEAUGENCY','64320','IDRON',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(44,'SCI ESPACE MULTIMEDIA','',2,NULL,NULL,1,NULL,1,'ESPMULT',NULL,NULL,NULL,'9 RUE DE BEAUGENCY','64320','IDRON',71,1,0,'',NULL,NULL,'bernard.bailacq@gmail.com;api.64.didier@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(45,'EUROGAGE','',2,NULL,NULL,1,NULL,1,'EUROGAG',NULL,NULL,NULL,'738 rue Yves Kermen','92100','BOULOGNE-BILLANCOURT',99,1,0,'',NULL,NULL,'compta@eurogage.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(46,'FORTIORI','',2,NULL,NULL,1,NULL,1,'FORTIOR',NULL,NULL,NULL,'1 RUE JACQUES RUEFF SILIC 13','92160','ANTONY',99,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(47,'FRANCE TELEVISIONS','',2,NULL,NULL,1,NULL,1,'FRANCE',NULL,NULL,NULL,'POLE FRANCE 3 AQUITAINE SERVICE COMPTABLE 136 RUE ERNEST RENAN','33075','BORDEAUX Cedex',40,1,0,'',NULL,NULL,'FTV.facture@francetv.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(48,'GASTELLU','Cathy',2,NULL,NULL,1,NULL,1,'GASTELL',NULL,NULL,NULL,'15 route de Nay','64420','LUCGARIER',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(49,'GASTON II & GASTON IX','',2,NULL,NULL,1,NULL,1,'GASTON',NULL,NULL,NULL,'2 RUE THOMAS EDISON BATIMENT A','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'sandrine.paroche@mj-athena.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(50,'GENERALI VIE','',2,NULL,NULL,1,NULL,1,'GENERAL',NULL,NULL,NULL,'DET- 162925V TSA 60011','75442','PARIS Cedex 09',82,1,0,'',NULL,NULL,'numfacturefgx@generali.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(51,'GIHP-AQUITAINE','',2,NULL,NULL,1,NULL,1,'GIHP',NULL,NULL,NULL,'436 Avenue de Verdun','33700','MERIGNAC',40,1,0,'',NULL,NULL,'bmasse@gihp-aquitaine.org',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(52,'LECLERC','GEORGES',2,NULL,NULL,1,NULL,1,'GL',NULL,NULL,NULL,'CALL ONE - S. ABDELLI 7/9 RUE VAILLANT COUTURIER','92301','LEVALLOIS PERRET CEDEX',99,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(53,'HARAS DU HAMEAU','',2,NULL,NULL,1,NULL,1,'HARAS',NULL,NULL,NULL,'7, chemin castagnou','64110','RONTIGNON',71,1,0,'',NULL,NULL,'president@aspcm.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(54,'HERMES','',2,NULL,NULL,1,NULL,1,'HERMES',NULL,NULL,NULL,'4 RUE THOMAS EDISON PAU CITE MULTIMEDIA BATIMENT C','64054','PAU CEDEX 9',71,1,0,'',NULL,NULL,'annie.lelin@groupe-pronoia.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(55,'HEWLETT-PACKARD','',2,NULL,NULL,1,NULL,1,'HPE',NULL,NULL,NULL,'Centre de Compétences France SAS 4, rue Paul Lafargue','92800','PUTEAUX',99,1,0,'',NULL,NULL,'HPEInvoicesEMEA@cushwake.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(56,'IDEAL Meetings & Events','',2,NULL,NULL,1,NULL,1,'IDEAL',NULL,NULL,NULL,'53, rue Raspail','92300','LEVALLOIS-PERRET',99,1,0,'',NULL,NULL,'rachel@idealmeetingsevents.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(57,'IDELIS','',2,NULL,NULL,1,NULL,1,'IDELIS',NULL,NULL,NULL,'Avenue Larribau','64051','PAU CEDEX 9',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(58,'INEXYS','',2,NULL,NULL,1,NULL,1,'INEX',NULL,NULL,NULL,'2, rue Thomas Edison','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(59,'INITIATIVES PREVENTION','',2,NULL,NULL,1,NULL,1,'INITIAT',NULL,NULL,NULL,'3 rue Paulin Talabot','93400','SAINT-OUEN',100,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(60,'IN SITU','',2,NULL,NULL,1,NULL,1,'INSITU',NULL,NULL,NULL,'26, ter rue Gardenat Lapostol','92150','SURESNES',99,1,0,'',NULL,NULL,'tessier@insitu.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(61,'INTERENERGIES','',2,NULL,NULL,1,NULL,1,'INTER',NULL,NULL,NULL,'ZAC du Pesqué Square du Moulin BP 424','64140','LONS',71,1,0,'',NULL,NULL,'fabien.soubirou@inter-energies.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(62,'SCI JADE','',2,NULL,NULL,1,NULL,1,'JADE',NULL,NULL,NULL,'7 CHEMIN DE CASTAGNOU','64110','RONTIGNON',71,1,0,'',NULL,NULL,'president@aspcm.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(63,'JIBE','',2,NULL,NULL,1,NULL,1,'JIBE',NULL,NULL,NULL,'1 CHEMIN DES CRÊTES','64320','IDRON',71,1,0,'06 83 88 33 72',NULL,NULL,'jlbailacq@wanadoo.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(64,'JIVE','',2,NULL,NULL,1,NULL,1,'JIVE',NULL,NULL,NULL,'27 AVENUE PASTEUR','64110','GELOS',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(65,'JM SERVICES','',2,NULL,NULL,1,NULL,1,'JM',NULL,NULL,NULL,'2, rue Thomas Edison BATIMENT A','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'jmservices64@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(66,'POSTE-IMMO','',2,NULL,NULL,1,NULL,1,'LAPOST1',NULL,NULL,NULL,'Direction Régionale Sud Ouest Atlantique 52, rue Georges Bonnac CS 51753','33093','BORDEAUX',40,1,0,'',NULL,NULL,'sandrine2.laporte@laposte.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(67,'LA POSTE','',2,NULL,NULL,1,NULL,1,'LAPOST2','SU2110-00001','411LAPOS',NULL,'',NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-1,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,'',NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','2021-10-15 14:10:54',NULL,NULL,1,0,'','pragmainit'),(68,'LEADER ACADEMY','',2,NULL,NULL,1,NULL,1,'LEADER',NULL,NULL,NULL,'39 rue Pointe Cadet','42000','SAINT-ETIENNE',49,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(69,'SELARL FHB','',2,NULL,NULL,1,NULL,1,'LIVOLSI',NULL,NULL,NULL,'Comptabilité fournisseurs 3 RUE BERNADOU','64100','BAYONNE',71,1,0,'09 72 30 20 40',NULL,NULL,'fanny.debelvalet@fhbx.eu',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(70,'LOCAPOSTE','',2,NULL,NULL,1,NULL,1,'LOCAPOS',NULL,NULL,NULL,'Direction Régionale Sud Ouest Atlantique 52, rue Georges Bonnac CS 51753','33093','BORDEAUX',40,1,0,'',NULL,NULL,'sandrine2.laporte@laposte.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(71,'LOCATION SERVICE','',2,NULL,NULL,1,NULL,1,'LOCSERV',NULL,NULL,NULL,'CHEMIN DE LA GRAVETTE','64400','OLORON SAINTE MARIE',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(72,'MAISON DES COMMUNES','',2,NULL,NULL,1,NULL,1,'MAISON',NULL,NULL,NULL,'Rue Auguste Renoir CS 40609','64006','PAU CEDEX',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(73,'MATTEI COMPRESSEURS','',2,NULL,NULL,1,NULL,1,'MATTEI',NULL,NULL,NULL,'2, rue Thomas Edison','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'olivier.sable@matteigroup.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(74,'Me GALLARDO','',2,NULL,NULL,1,NULL,1,'MEGALLA',NULL,NULL,NULL,'2, rue Thomas Edison BATIMENT A','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'contact@ledroit.net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(75,'METRA Christophe','',2,NULL,NULL,1,NULL,1,'METRA',NULL,NULL,NULL,'3, rue des Albaredes','12400','SAINT-AFFRIQUE',19,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(76,'MGI CONSULTANTS','',2,NULL,NULL,1,NULL,1,'MGICONS',NULL,NULL,NULL,'11 RUE TEHERAN','75008','PARIS',82,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(77,'MIDDLE WEB','',2,NULL,NULL,1,NULL,1,'MIDDLE',NULL,NULL,NULL,'4, rue Thomas Edison BATIMENT C','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'contact@middleweb.net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(78,'MS BUSINESS','',2,NULL,NULL,1,NULL,1,'MSBUSIN',NULL,NULL,NULL,'2 RUE THOMAS EDISON','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(79,'NANDOU Services','',2,NULL,NULL,1,NULL,1,'NANDOU',NULL,NULL,NULL,'7, chemin castagnou','64110','RONTIGNON',71,1,0,'',NULL,NULL,'president@aspcm.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(80,'ORIENT ACTION','',2,NULL,NULL,1,NULL,1,'ORIENT',NULL,NULL,NULL,'2 rue Thomas Edison','64000','PAU',71,1,0,'',NULL,NULL,'francois.lamy@orientaction-groupe.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(81,'SCI OSSAU','',2,NULL,NULL,1,NULL,1,'OSS',NULL,NULL,NULL,'BATIMENT E 3, rue Ada Byon','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'accounting.ses@seaowlgroup.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(82,'S.C.3i.','',2,NULL,NULL,1,NULL,1,'PACTHOD',NULL,NULL,NULL,'4 RUE THOMAS EDISON BATIMENT C','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'spacthod@sc3i.net ; julie.lopvet@sc3i.net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(83,'PARITEL OPERATEUR','',2,NULL,NULL,1,NULL,1,'PARITEL',NULL,NULL,NULL,'Immeuble Colombie 60 Avenue de l Europe','92270','BOIS-COLOMBES',99,1,0,'',NULL,NULL,'compta-fournisseur@paritel.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(84,'PEGASE ENGINEERING SUPPORT','',2,NULL,NULL,1,NULL,1,'PEGASE',NULL,NULL,NULL,'2, rue Thomas Edison Batiment A','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(85,'PLH CONSEIL','',2,NULL,NULL,1,NULL,1,'PLH',NULL,NULL,NULL,'BATIMENT A 2, rue Thomas Edison','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'plahillonne@plhconseil.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(86,'HCPV','',2,NULL,NULL,1,NULL,1,'POINTVI',NULL,NULL,NULL,'5 rue de Rome','75008','PARIS',82,1,0,'',NULL,NULL,'compta@giepointvision.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(87,'POLE EMPLOI','',2,NULL,NULL,1,NULL,1,'POLE',NULL,NULL,NULL,'2, rue Pierre de Gennes','64140','LONS',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(88,'PREV CONSEIL','',2,NULL,NULL,1,NULL,1,'PREV',NULL,NULL,NULL,'10, Impasse de la Reine Margot','64320','IDRON',71,1,0,'',NULL,NULL,'contact@prev-conseil.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(89,'PRH SARL','',2,NULL,NULL,1,NULL,1,'PRH',NULL,NULL,NULL,'1, rue Thomas Edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(90,'PKF ARSILON','',2,NULL,NULL,1,NULL,1,'PWC',NULL,NULL,NULL,'Bâtiment C 4, rue Thomas Edison - BP 7501','64075','PAU Cedex',71,1,0,'',NULL,NULL,'factures.fournisseurs@arsilon.com ; francoise.abadie@arsilon.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(91,'REPORT ONE','',2,NULL,NULL,1,NULL,1,'REPORTO',NULL,NULL,NULL,'11, Villa GAUDELET','75011','PARIS',82,1,0,'',NULL,NULL,'compta@report-one.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(92,'C.H. ROBINSON FRANCE SAS','',2,NULL,NULL,1,NULL,1,'ROBINSO',NULL,NULL,NULL,'4, rue Thomas Edison','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'Jerome.Husson@chrobinson.com;Stephanie.Datchary@chrobinson.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(93,'SARL SAGEC SUD ATLANTIQUE','',2,NULL,NULL,1,NULL,1,'SAGEC',NULL,NULL,NULL,'A l attention de Mme Valérie OTEGUI 69, avenue de Bayonne Residence Aitzi','64600','ANGLET',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(94,'SAIPEM','',2,NULL,NULL,1,NULL,1,'SAIPEM',NULL,NULL,NULL,'Batiment F 16, rue Michael Faraday','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'Laetitia.GRANGE@saipem.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(95,'SCHNEIDER ELECTRIC FRANCE','',2,NULL,NULL,1,NULL,1,'SCHNEID',NULL,NULL,NULL,'CSP FOURNISSEURS','38246','MEYLAN CEDEX',45,1,0,'',NULL,NULL,'invoices-sef@schneider-electric.com; Joelle.GUELIN@schneider-electric.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(96,'SCI ARTOUSTE','',2,NULL,NULL,1,NULL,1,'SCIARTO',NULL,NULL,NULL,'3 RUE ADA BYRON','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'accounting.ses@seaowlgroup.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(97,'PAU BÂT D','',2,NULL,NULL,1,NULL,1,'SCID',NULL,NULL,NULL,'2 RUE THOMAS EDISON','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(98,'SCI DUBOIS','',2,NULL,NULL,1,NULL,1,'SCIDUBO',NULL,NULL,NULL,'7 CHEMIN DE CASTAGNOU','64110','RONTIGNON',71,1,0,'',NULL,NULL,'president@aspcm.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(99,'PAU HLP','',2,NULL,NULL,1,NULL,1,'SCIPAUH',NULL,NULL,NULL,'ROUTE DE PAU','64800','ARROS DE NAY',71,1,0,'',NULL,NULL,'celine.suarez@despagnet.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(100,'SEAOWL ENERGY SERVICES','',2,NULL,NULL,1,NULL,1,'SEAOWL',NULL,NULL,NULL,'Batiment E 3, rue Ada Byron','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'accounting.ses@seaowlgroup.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(101,'GROUPE SECA SA','',2,NULL,NULL,1,NULL,1,'SECA',NULL,NULL,NULL,'1 et 2 rue du DauphinÔ BP 189','59305','VALENCIENNES CEDEX',66,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(102,'SEM PAU PYRENEES BATIMENT A','',2,NULL,NULL,1,NULL,1,'SEM',NULL,NULL,NULL,'2, rue Thomas Edison','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'f.etienne@sempp.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(103,'SEM PAU PYRENEES BAT B','',2,NULL,NULL,1,NULL,1,'SEMB',NULL,NULL,NULL,'2, rue Thomas Edison','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(104,'SEM PAU PYRENEES BATIMENT C','',2,NULL,NULL,1,NULL,1,'SEMC',NULL,NULL,NULL,'2, rue Thomas Edison','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'f.etienne@sempp.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(105,'SEM PAU PYRENEES BAT F','',2,NULL,NULL,1,NULL,1,'SEMF',NULL,NULL,NULL,'2 rue Thomas EDISON','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'f.etienne@sempp.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(106,'SEM PAU PYRENEES BATIMENT H','',2,NULL,NULL,1,NULL,1,'SEMH',NULL,NULL,NULL,'2, rue Thomas Edison','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'f.etienne@sempp.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(107,'SENIOR AND CO','',2,NULL,NULL,1,NULL,1,'SENI',NULL,NULL,NULL,'M. David ALPHONSINE 5 BIS CAMI DE SALECHE','65100','OMEX',72,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(108,'SETREL','',2,NULL,NULL,1,NULL,1,'SETREL',NULL,NULL,NULL,'1, rue Thomas Edison','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'celine.suarez@despagnet.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(109,'SHEM','',2,NULL,NULL,1,NULL,1,'SHEM',NULL,NULL,NULL,'1, rue Louis Renault BP 13383','31133','BALMA CEDEX',38,1,0,'',NULL,NULL,'Comptabilite.shem@shem.engie.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(110,'SOFRESID ENGINEERING','',2,NULL,NULL,1,NULL,1,'SOFRENG',NULL,NULL,NULL,'PAU CITE MULTIMEDIA BAT F 16, Rue Michael Faraday','64054','PAU CEDEX 9',71,1,0,'',NULL,NULL,'sofsudouest@sofresid.com;Christophe.Driessen@sofresid.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(111,'SAS SOP MULTIMEDIA','',2,NULL,NULL,1,NULL,1,'SOPMULT',NULL,NULL,NULL,'1, Allées Catherine de Bourbon','64000','PAU',71,1,0,'',NULL,NULL,'v.fontang@pe-a.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(112,'SOP SEA','',2,NULL,NULL,1,NULL,1,'SOPSEA',NULL,NULL,NULL,'1, Allée Catherine de Bourbon','64000','PAU',71,1,0,'',NULL,NULL,'v.fontang@pe-a.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(113,'AGENCE BLISS','',2,NULL,NULL,1,NULL,1,'SOS',NULL,NULL,NULL,'13 RUE JOHANNES KEPLER ZONE EUROPA','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(114,'SPIE OIL & GAS SERVICE','',2,NULL,NULL,1,NULL,1,'SPIEOIL',NULL,NULL,NULL,'10 AVENUE DE L ENTREPRISE','95863','CERGY PONTOISE',102,1,0,'',NULL,NULL,'compta-fournisseur.sogs@spie.com;corinne.fabre@spie.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(115,'SQUARE HABITAT ENTREP.&COMMERC','',2,NULL,NULL,1,NULL,1,'SQUARE',NULL,NULL,NULL,'62, rue Carnot','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(116,'SSLE','',2,NULL,NULL,1,NULL,1,'SSLE',NULL,NULL,NULL,'4, rue Thomas Edison','64054','PAU Cedex 09',71,1,0,'',NULL,NULL,'contact@ssle.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(117,'SUD OUEST IMMOBILER','',2,NULL,NULL,1,NULL,1,'SUD',NULL,NULL,NULL,'4, rue Thomas Edison BATIMENT C','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'tmayet@agencepie.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(118,'TEREGA','',2,NULL,NULL,1,NULL,1,'TEREGA',NULL,NULL,NULL,'40, Avenue de l Europe CS 20522','64010','PAU CEDEX',71,1,0,'',NULL,NULL,'valerie.castaing@terega.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(119,'TOSHIBA RÉGION SUD-OUEST','',2,NULL,NULL,1,NULL,1,'TOSHIBA',NULL,NULL,NULL,'4 Rue Brindejonc des Moulinais','31500','TOULOUSE',38,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(120,'UBIGREEN','',2,NULL,NULL,1,NULL,1,'UBIGREE',NULL,NULL,NULL,'425 Rue Jean Rostand','31670','LABÈGE',38,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(121,'UMANIS MANAGED SERVICES','',2,NULL,NULL,1,NULL,1,'UMANIS',NULL,NULL,NULL,'S. ABDELLI 7/9 RUE VAILLANT COUTURIER BP 7','92301','LEVALLOIS PERRET CEDEX',99,1,0,'',NULL,NULL,'umscompta@umanis.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(122,'V2I FR SAS','',2,NULL,NULL,1,NULL,1,'V2I',NULL,NULL,NULL,'2, rue Thomas Edison','64054','Pau Cedex 09',71,1,0,'',NULL,NULL,'d.simon@v2i.be',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(123,'VAREL EUROPE','',2,NULL,NULL,1,NULL,1,'VAREL',NULL,NULL,NULL,'BATIMENT C  1, rue Ada Byron','64054','PAU Cedex 09',71,1,0,'05 59 14 48 25',NULL,NULL,'pparies@varel.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(124,'GmbH','WEATHERFORD ENERGY SERVICES',2,NULL,NULL,1,NULL,1,'WEATHER',NULL,NULL,NULL,'Münchner Strasse 52 ','30855','LANGENHAGEN',0,5,0,'',NULL,NULL,'germany.payables@weatherford.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(125,'SES - Seaowl Energy Services','',2,NULL,NULL,1,NULL,1,'WELL',NULL,NULL,NULL,'PAU CITE MULTIMEDIA BAT E 3, rue Ada Byron','64054','PAU CEDEX 09',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 14:34:55',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(126,'WEEK ME UP','',3,NULL,NULL,1,NULL,1,'CLIENT',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:36',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(127,'LA MINUTE VIN','',3,NULL,NULL,1,NULL,1,'MVIN',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:33',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(128,'ADAPEI 64','',3,NULL,NULL,1,NULL,1,'ADAP',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:31',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(129,'ALIMENTATION','',3,NULL,NULL,1,NULL,1,'ALIM',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:28',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(130,'BIEN ETRE','',3,NULL,NULL,1,NULL,1,'BETR',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:26',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(131,'BILLETERIE & BON D\'ACHAT','',3,NULL,NULL,1,NULL,1,'BILL',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:24',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(132,'CONCIERGERIE','',3,NULL,NULL,1,NULL,1,'CONC',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:21',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(133,'PRODUITS COSMETIQUES','',3,NULL,NULL,1,NULL,1,'COSM',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:19',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(134,'BOISSONS','',3,NULL,NULL,1,NULL,1,'BOIS',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:17',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(135,'PLACES DE MATCHS','',3,NULL,NULL,1,NULL,1,'MATC',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(136,'BIJOUX','',3,NULL,NULL,1,NULL,1,'BIJO',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:44:11',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(137,'BANQUE','',3,NULL,NULL,1,NULL,1,'BANK',NULL,NULL,NULL,'4 rue thomas edison','64000','PAU',71,1,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 08:59:13',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(138,'FOURNISSEURS DIVERS',NULL,2,NULL,NULL,1,NULL,1,NULL,'DIVER',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:01:32',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(139,'ORANGE',NULL,2,NULL,NULL,1,NULL,1,NULL,'ORANGE',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(140,'IBERDROLA',NULL,2,NULL,NULL,1,NULL,1,NULL,'IBER',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(141,'PROMOCASH',NULL,2,NULL,NULL,1,NULL,1,NULL,'PROMO',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(142,'PLAQUE-O-MATIC',NULL,2,NULL,NULL,1,NULL,1,NULL,'PLAQUE',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(143,'ELIS FONTAINE',NULL,2,NULL,NULL,1,NULL,1,NULL,'ELIS',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(144,'ROUSSILLE',NULL,2,NULL,NULL,1,NULL,1,NULL,'ROUSSILLE',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(145,'TOSHIBA COPIEUR',NULL,2,NULL,NULL,1,NULL,1,NULL,'THOSHIBA',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(146,'INVESTITEL',NULL,2,NULL,NULL,1,NULL,1,NULL,'INVEST',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(147,'BERGOULI',NULL,2,NULL,NULL,1,NULL,1,NULL,'BERG',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(148,'VEOLIA',NULL,2,NULL,NULL,1,NULL,1,NULL,'VEOLIA',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(149,'VILLE PAU SCE EAUX',NULL,2,NULL,NULL,1,NULL,1,NULL,'VILLE',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(150,'CABINET CHEVALERE',NULL,2,NULL,NULL,1,NULL,1,NULL,'CEC',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(151,'CAZET',NULL,2,NULL,NULL,1,NULL,1,NULL,'CAZET',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(152,'CAVE DE GAN',NULL,2,NULL,NULL,1,NULL,1,NULL,'CAVEGAN',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(153,'CAVE DU PALAIS',NULL,2,NULL,NULL,1,NULL,1,NULL,'CAVEPA',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(154,'SODEXO',NULL,2,NULL,NULL,1,NULL,1,NULL,'SODEXO',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(155,'CREA-SUD',NULL,2,NULL,NULL,1,NULL,1,NULL,'CREA',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(156,'CHRONOPOST',NULL,2,NULL,NULL,1,NULL,1,NULL,'CHRONO',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(157,'ENI',NULL,2,NULL,NULL,1,NULL,1,NULL,'ENI',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(158,'ECONET',NULL,2,NULL,NULL,1,NULL,1,NULL,'ECONET',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(159,'ECONET MULTISERVICES',NULL,2,NULL,NULL,1,NULL,1,NULL,'ECOMULT',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(160,'HELIANTIS',NULL,2,NULL,NULL,1,NULL,1,NULL,'HELIANTIS',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(161,'JPG',NULL,2,NULL,NULL,1,NULL,1,NULL,'JPG',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(162,'LA POSTE',NULL,2,NULL,NULL,1,NULL,1,NULL,'POSTE',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(163,'ADOBE',NULL,2,NULL,NULL,1,NULL,1,NULL,'ADOBE',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(164,'APPLE',NULL,2,NULL,NULL,1,NULL,1,NULL,'APPLE',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(165,'BIJOU',NULL,2,NULL,NULL,1,NULL,1,NULL,'BIJOU',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(166,'CTS',NULL,2,NULL,NULL,1,NULL,1,NULL,'CTS',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(167,'DML TRAITEUR',NULL,2,NULL,NULL,1,NULL,1,NULL,'DML',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(168,'ESAT LA HAMEAU',NULL,2,NULL,NULL,1,NULL,1,NULL,'ESAT',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(169,'FERME A DOMICILE',NULL,2,NULL,NULL,1,NULL,1,NULL,'FERME',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(170,'GUILHEM ET FILS',NULL,2,NULL,NULL,1,NULL,1,NULL,'GUIL',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(171,'I CONCEPT',NULL,2,NULL,NULL,1,NULL,1,NULL,'ICONCEP',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(172,'INCH',NULL,2,NULL,NULL,1,NULL,1,NULL,'INCH',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(173,'ISOFAC',NULL,2,NULL,NULL,1,NULL,1,NULL,'ISOFAC',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(174,'2ISR',NULL,2,NULL,NULL,1,NULL,1,NULL,'ISR',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(175,'LOUNGE UP',NULL,2,NULL,NULL,1,NULL,1,NULL,'LOUNGE',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(176,'LVR BOULANGERIE',NULL,2,NULL,NULL,1,NULL,1,NULL,'LVR',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(177,'QUADIENT /NEOPOST',NULL,2,NULL,NULL,1,NULL,1,NULL,'NEOPOST',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(178,'NESPRESSO',NULL,2,NULL,NULL,1,NULL,1,NULL,'NESPRES',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(179,'PAU SOLS SOUPLES',NULL,2,NULL,NULL,1,NULL,1,NULL,'PAUSOLS',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(180,'PRAGMA-TECH',NULL,2,NULL,NULL,1,NULL,1,NULL,'PRAGMA',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(181,'SECURITAS',NULL,2,NULL,NULL,1,NULL,1,NULL,'SECURIT',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(182,'SMAC ASSISTANCE SERVICE',NULL,2,NULL,NULL,1,NULL,1,NULL,'SMAC',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(183,'SOCOMEC',NULL,2,NULL,NULL,1,NULL,1,NULL,'SOCOMEC',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(184,'SOPRASSISTANCE',NULL,2,NULL,NULL,1,NULL,1,NULL,'SOPRA',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(185,'OLLINK /THD',NULL,2,NULL,NULL,1,NULL,1,NULL,'THD',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(186,'TOQUES ET GOURMANDISES',NULL,2,NULL,NULL,1,NULL,1,NULL,'TOQUES',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit'),(187,'DAVID VELLA',NULL,2,NULL,NULL,1,NULL,1,NULL,'VELLA',NULL,NULL,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-15 14:21:14',NULL,NULL,NULL,NULL,NULL,'pragmainit');

--
-- Table structure for table `llx_societe_account`
--

CREATE TABLE `llx_societe_account` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT 1,
  `login` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `pass_encoding` varchar(24) 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,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_website` int(11) DEFAULT NULL,
  `site` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `site_account` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `key_account` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_last_login` datetime DEFAULT NULL,
  `date_previous_login` datetime DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_account_login_website_soc` (`entity`,`fk_soc`,`login`,`site`,`fk_website`),
  UNIQUE KEY `uk_societe_account_key_account_soc` (`entity`,`fk_soc`,`key_account`,`site`,`fk_website`),
  KEY `idx_societe_account_rowid` (`rowid`),
  KEY `idx_societe_account_login` (`login`),
  KEY `idx_societe_account_status` (`status`),
  KEY `idx_societe_account_fk_website` (`fk_website`),
  KEY `idx_societe_account_fk_soc` (`fk_soc`),
  CONSTRAINT `llx_societe_account_fk_societe` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `llx_societe_account_fk_website` FOREIGN KEY (`fk_website`) REFERENCES `llx_website` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_account`
--


--
-- Table structure for table `llx_societe_address`
--

CREATE TABLE `llx_societe_address` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `label` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_soc` int(11) DEFAULT 0,
  `name` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `town` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_pays` int(11) DEFAULT 0,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_address`
--


--
-- Table structure for table `llx_societe_commerciaux`
--

CREATE TABLE `llx_societe_commerciaux` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_commerciaux` (`fk_soc`,`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_commerciaux`
--


--
-- Table structure for table `llx_societe_contacts`
--

CREATE TABLE `llx_societe_contacts` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `date_creation` datetime NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `fk_c_type_contact` int(11) NOT NULL,
  `fk_socpeople` 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`),
  UNIQUE KEY `idx_societe_contacts_idx1` (`entity`,`fk_soc`,`fk_c_type_contact`,`fk_socpeople`),
  KEY `fk_societe_contacts_fk_c_type_contact` (`fk_c_type_contact`),
  KEY `fk_societe_contacts_fk_soc` (`fk_soc`),
  KEY `fk_societe_contacts_fk_socpeople` (`fk_socpeople`),
  CONSTRAINT `fk_societe_contacts_fk_c_type_contact` FOREIGN KEY (`fk_c_type_contact`) REFERENCES `llx_c_type_contact` (`rowid`),
  CONSTRAINT `fk_societe_contacts_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_societe_contacts_fk_socpeople` FOREIGN KEY (`fk_socpeople`) REFERENCES `llx_socpeople` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_contacts`
--


--
-- Table structure for table `llx_societe_extrafields`
--

CREATE TABLE `llx_societe_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,
  `signature_link` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `txaspcm` double(10,2) DEFAULT NULL,
  `importaspcm_numdept` int(3) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_extrafields` (`fk_object`),
  UNIQUE KEY `uk_societe_extrafields_importaspcm_numdept` (`importaspcm_numdept`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_extrafields`
--

INSERT INTO `llx_societe_extrafields` (`rowid`, `tms`, `fk_object`, `import_key`, `signature_link`, `txaspcm`, `importaspcm_numdept`) VALUES (1,'2021-10-06 07:32:44',1,NULL,NULL,NULL,NULL),(2,'2021-10-15 12:38:59',126,NULL,NULL,2.60,NULL),(4,'2021-10-15 14:10:54',67,NULL,NULL,NULL,NULL);

--
-- Table structure for table `llx_societe_perentity`
--

CREATE TABLE `llx_societe_perentity` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `accountancy_code_sell` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_buy` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_perentity` (`fk_soc`,`entity`),
  KEY `idx_societe_perentity_fk_soc` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_perentity`
--


--
-- 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 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(255) 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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


--
-- 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,
  `total_tva` double(24,8) DEFAULT 0.00000000,
  `localtax1` double(24,8) DEFAULT 0.00000000,
  `localtax2` double(24,8) DEFAULT 0.00000000,
  `total_ttc` double(24,8) DEFAULT 0.00000000,
  `fk_account` int(11) DEFAULT NULL,
  `fk_currency` varchar(3) 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`),
  KEY `idx_supplier_proposal_extrafields` (`fk_object`)
) 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,
  `show_total_ht` int(10) DEFAULT NULL,
  `show_reduc` int(10) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_supplier_proposaldet_extrafields` (`fk_object`)
) 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,
  `email_msgid` varchar(255) COLLATE utf8_unicode_ci DEFAULT 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`),
  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,
  `paye` smallint(6) NOT NULL DEFAULT 0,
  `fk_account` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) 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,
  `admin` smallint(6) DEFAULT 0,
  `employee` tinyint(4) DEFAULT 1,
  `fk_establishment` int(11) DEFAULT 0,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `login` varchar(50) 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,
  `signature` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `socialnetworks` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_socpeople` int(11) DEFAULT NULL,
  `fk_member` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `fk_user_expense_validator` int(11) DEFAULT NULL,
  `fk_user_holiday_validator` int(11) DEFAULT NULL,
  `idpers1` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idpers2` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idpers3` varchar(128) COLLATE utf8_unicode_ci 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,
  `datelastpassvalidation` datetime DEFAULT NULL,
  `datestartvalidity` datetime DEFAULT NULL,
  `dateendvalidity` 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,
  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=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_user` (`rowid`, `entity`, `ref_ext`, `ref_int`, `admin`, `employee`, `fk_establishment`, `datec`, `tms`, `fk_user_creat`, `fk_user_modif`, `login`, `pass_encoding`, `pass`, `pass_crypted`, `pass_temp`, `api_key`, `gender`, `civility`, `lastname`, `firstname`, `address`, `zip`, `town`, `fk_state`, `fk_country`, `birth`, `job`, `office_phone`, `office_fax`, `user_mobile`, `personal_mobile`, `email`, `personal_email`, `signature`, `socialnetworks`, `fk_soc`, `fk_socpeople`, `fk_member`, `fk_user`, `fk_user_expense_validator`, `fk_user_holiday_validator`, `idpers1`, `idpers2`, `idpers3`, `note_public`, `note`, `model_pdf`, `datelastlogin`, `datepreviouslogin`, `datelastpassvalidation`, `datestartvalidity`, `dateendvalidity`, `iplastlogin`, `ippreviouslogin`, `egroupware_id`, `ldap_sid`, `openid`, `statut`, `photo`, `lang`, `color`, `barcode`, `fk_barcode_type`, `accountancy_code`, `nb_holiday`, `thm`, `tjm`, `salary`, `salaryextra`, `dateemployment`, `dateemploymentend`, `weeklyhours`, `import_key`, `default_range`, `default_c_exp_tax_cat`, `fk_warehouse`) VALUES (1,0,NULL,NULL,1,1,0,'2021-10-01 14:19:31','2021-10-01 14:19:31',NULL,NULL,'superadmin',NULL,NULL,'$2y$10$iU88tN9ic0O/mHlRhH.x6u08C0TYc5oL41l5RneVBJL5pl9Dvjlyq',NULL,NULL,'','','SuperAdmin','','','','',NULL,NULL,NULL,'','','','','','','','','null',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2021-10-28 09:14:29','2021-10-22 13:33:13',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,3,NULL,NULL,0,1,0,'2021-10-15 12:33:51','2021-10-15 12:42:38',NULL,NULL,'WMUP',NULL,'YA0sKpPxgi0hkmW1wtHz','$2y$10$aNcKjdHo/XKTSmNO0TekMO3Ral3t./6rQ6kmGdoLOiLNT1njEHb.K',NULL,'L224m2OdaupLQ318S9FRVwwXOqsgGz14','other','','WMUP','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,2,NULL,NULL,0,1,0,'2021-10-15 13:05:04','2021-10-15 13:11:17',NULL,NULL,'ALPHA',NULL,'itUiiqHtujC6','$2y$10$fMUZCc.hyz4X6cN4vfG5QeQW6cAulLNaoYvv2K3eKLK.EAmKxr01i',NULL,NULL,NULL,'','SALLE ALPHA','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'aa56ff',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,2,NULL,NULL,0,1,0,'2021-10-15 13:08:32','2021-10-15 13:11:05',NULL,NULL,'BETA',NULL,'PLdRsMf0dpgL','$2y$10$K5N08dOcwgK8gblSOYC2JuTreVTxTCKTkaCKqAGl/z3g6mxfrdK.S',NULL,NULL,NULL,'','SALLE BETA','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'56ffff',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,2,NULL,NULL,0,1,0,'2021-10-15 13:09:03','2021-10-15 13:10:50',NULL,NULL,'KAPPA',NULL,'WnEAMBEHyjFU','$2y$10$lvY881TygYAKUVYmR1BQ5OT2Ob6vnh.QH4dztBU6PJcAQ7QKcDSr6',NULL,NULL,NULL,'','SALLE KAPPA','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'aaff56',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,2,NULL,NULL,0,1,0,'2021-10-15 13:09:16','2021-10-15 13:10:36',NULL,NULL,'GEODE',NULL,'26U3UWEJZGq5','$2y$10$uykU8avlIk5yIVsK8aGgRuMYq7mrMZ.1nyVpNOnrOJAKQB4TDiwSW',NULL,NULL,NULL,'','GEODE','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'ffff56',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,2,NULL,NULL,0,1,0,'2021-10-15 13:09:30','2021-10-15 13:10:21',NULL,NULL,'SEM',NULL,'ESBCfO98NzwF','$2y$10$03Q6/pws9yZCT4ik4/e6Bukszkp0DRzHHGpeEQG9h2NOcq2pd/Cs2',NULL,NULL,NULL,'','SALLE SEM','','','','',NULL,NULL,NULL,'','','','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,1,NULL,NULL,'ffaa56',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

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

CREATE TABLE `llx_user_alert` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `fk_contact` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=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,
  `roomreservation_time` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `roomreservation_product` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `roomreservation_capacity` int(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_user_extrafields` (`fk_object`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_user_extrafields` (`rowid`, `tms`, `fk_object`, `import_key`, `roomreservation_time`, `roomreservation_product`, `roomreservation_capacity`) VALUES (13,'2021-10-15 13:20:06',3,NULL,'310,191,309','190',20),(14,'2021-10-15 13:20:33',4,NULL,'310,191,309','190',20),(15,'2021-10-15 13:22:53',5,NULL,'310,191,309','190',20),(16,'2021-10-15 13:23:17',6,NULL,'310,191,309','190',100),(17,'2021-10-15 13:23:40',7,NULL,'310,191,309','190',15);

--
-- 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` (`fk_user`, `entity`, `param`, `value`) VALUES (1,3,'MAIN_BOXES_0','1'),(1,2,'MAIN_SELECTEDFIELDS_invoicelist','f.ref,f.datef,f.date_lim_reglement,s.nom,s.name_alias,s.zip,f.total_ht,f.total_ttc,u.login,f.fk_statut,');

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

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

INSERT INTO `llx_user_rights` (`rowid`, `entity`, `fk_user`, `fk_id`) VALUES (98,1,1,11),(92,1,1,12),(93,1,1,13),(94,1,1,14),(95,1,1,15),(97,1,1,16),(99,1,1,19),(24,1,1,21),(18,1,1,22),(19,1,1,24),(20,1,1,25),(21,1,1,26),(23,1,1,27),(25,1,1,28),(142,1,1,31),(137,1,1,32),(139,1,1,34),(141,1,1,38),(143,1,1,39),(33,1,1,81),(28,1,1,82),(29,1,1,84),(30,1,1,86),(31,1,1,87),(32,1,1,88),(34,1,1,89),(107,1,1,91),(104,1,1,92),(106,1,1,93),(108,1,1,94),(120,1,1,111),(111,1,1,112),(113,1,1,113),(115,1,1,114),(117,1,1,115),(119,1,1,116),(121,1,1,117),(6,1,1,121),(3,1,1,122),(5,1,1,125),(7,1,1,126),(63,1,1,161),(56,1,1,162),(58,1,1,163),(60,1,1,164),(62,1,1,165),(64,1,1,167),(165,1,1,241),(164,1,1,242),(166,1,1,243),(8,1,1,262),(14,1,1,281),(11,1,1,282),(13,1,1,283),(15,1,1,286),(170,1,1,331),(169,1,1,332),(171,1,1,333),(149,1,1,531),(146,1,1,532),(148,1,1,534),(150,1,1,538),(154,1,1,1001),(153,1,1,1002),(155,1,1,1003),(157,1,1,1004),(158,1,1,1005),(160,1,1,1011),(161,1,1,1012),(65,1,1,1181),(79,1,1,1182),(68,1,1,1183),(69,1,1,1184),(71,1,1,1185),(73,1,1,1186),(75,1,1,1187),(78,1,1,1188),(76,1,1,1189),(80,1,1,1191),(88,1,1,1231),(83,1,1,1232),(84,1,1,1233),(86,1,1,1234),(87,1,1,1235),(89,1,1,1236),(172,1,1,1251),(100,1,1,1321),(101,1,1,1322),(35,1,1,1421),(46,1,1,2401),(45,1,1,2402),(47,1,1,2403),(51,1,1,2411),(50,1,1,2412),(52,1,1,2413),(53,1,1,2414),(180,1,1,3201),(185,1,1,5001),(184,1,1,5002),(186,1,1,5003),(190,1,1,5011),(189,1,1,5012),(191,1,1,5013),(195,1,1,5021),(194,1,1,5022),(196,1,1,5023),(200,1,1,5031),(199,1,1,5032),(201,1,1,5033),(209,1,1,5041),(204,1,1,5042),(205,1,1,5043),(206,1,1,5044),(208,1,1,5045),(210,1,1,5046),(219,1,1,5051),(213,1,1,5052),(214,1,1,5054),(215,1,1,5056),(217,1,1,5057),(218,1,1,5058),(220,1,1,5059),(230,1,1,5061),(223,1,1,5062),(224,1,1,5063),(225,1,1,5064),(226,1,1,5065),(228,1,1,5066),(229,1,1,5067),(231,1,1,5069),(178,1,1,23001),(175,1,1,23002),(177,1,1,23003),(179,1,1,23004),(123,1,1,50401),(131,1,1,50411),(126,1,1,50412),(128,1,1,50414),(130,1,1,50415),(132,1,1,50418),(133,1,1,50420),(134,1,1,50430),(122,1,1,50440),(41,1,1,56001),(38,1,1,56002),(40,1,1,56003),(42,1,1,56004),(181,1,1,858369821),(790,1,2,858369821),(945,1,3,2401),(946,1,3,5011),(947,1,3,5021),(948,1,4,2401),(949,1,4,5011),(950,1,4,5021),(951,1,5,2401),(952,1,5,5011),(953,1,5,5021),(954,1,6,2401),(955,1,6,5011),(956,1,6,5021),(957,1,7,2401),(958,1,7,5011),(959,1,7,5021),(367,2,1,11),(359,2,1,12),(360,2,1,13),(361,2,1,14),(362,2,1,15),(365,2,1,16),(368,2,1,19),(267,2,1,21),(259,2,1,22),(260,2,1,24),(261,2,1,25),(262,2,1,26),(265,2,1,27),(268,2,1,28),(442,2,1,31),(434,2,1,32),(437,2,1,34),(440,2,1,38),(443,2,1,39),(279,2,1,81),(273,2,1,82),(274,2,1,84),(275,2,1,86),(276,2,1,87),(277,2,1,88),(280,2,1,89),(380,2,1,91),(375,2,1,92),(378,2,1,93),(381,2,1,94),(409,2,1,111),(395,2,1,112),(398,2,1,113),(401,2,1,114),(404,2,1,115),(407,2,1,116),(410,2,1,117),(241,2,1,121),(236,2,1,122),(239,2,1,125),(242,2,1,126),(484,2,1,241),(482,2,1,242),(485,2,1,243),(243,2,1,262),(253,2,1,281),(248,2,1,282),(251,2,1,283),(254,2,1,286),(492,2,1,331),(490,2,1,332),(493,2,1,333),(389,2,1,511),(384,2,1,512),(386,2,1,514),(388,2,1,517),(390,2,1,519),(458,2,1,531),(453,2,1,532),(456,2,1,534),(459,2,1,538),(447,2,1,651),(446,2,1,652),(448,2,1,653),(466,2,1,1001),(464,2,1,1002),(467,2,1,1003),(471,2,1,1004),(472,2,1,1005),(476,2,1,1011),(477,2,1,1012),(311,2,1,1181),(332,2,1,1182),(316,2,1,1183),(317,2,1,1184),(320,2,1,1185),(323,2,1,1186),(326,2,1,1187),(330,2,1,1188),(327,2,1,1189),(333,2,1,1191),(345,2,1,1231),(338,2,1,1232),(339,2,1,1233),(342,2,1,1234),(343,2,1,1235),(346,2,1,1236),(960,2,1,1251),(369,2,1,1321),(370,2,1,1322),(281,2,1,1421),(299,2,1,2401),(297,2,1,2402),(300,2,1,2403),(307,2,1,2411),(305,2,1,2412),(308,2,1,2413),(309,2,1,2414),(412,2,1,50401),(425,2,1,50411),(417,2,1,50412),(420,2,1,50414),(423,2,1,50415),(426,2,1,50418),(428,2,1,50420),(429,2,1,50430),(411,2,1,50440),(291,2,1,56001),(286,2,1,56002),(289,2,1,56003),(292,2,1,56004),(943,2,1,432511),(942,2,1,432512),(944,2,1,432513),(353,2,1,941601),(349,2,1,941602),(350,2,1,941603),(351,2,1,941604),(352,2,1,941605),(354,2,1,941606),(494,2,1,858369821),(618,3,1,11),(608,3,1,12),(609,3,1,13),(610,3,1,14),(611,3,1,15),(615,3,1,16),(619,3,1,19),(788,3,1,21),(778,3,1,22),(779,3,1,24),(780,3,1,25),(781,3,1,26),(785,3,1,27),(789,3,1,28),(706,3,1,31),(695,3,1,32),(699,3,1,34),(703,3,1,38),(707,3,1,39),(539,3,1,81),(532,3,1,82),(533,3,1,84),(534,3,1,86),(535,3,1,87),(536,3,1,88),(540,3,1,89),(635,3,1,91),(628,3,1,92),(632,3,1,93),(636,3,1,94),(662,3,1,111),(643,3,1,112),(647,3,1,113),(651,3,1,114),(655,3,1,115),(659,3,1,116),(663,3,1,117),(508,3,1,121),(501,3,1,122),(505,3,1,125),(509,3,1,126),(755,3,1,241),(752,3,1,242),(756,3,1,243),(510,3,1,262),(524,3,1,281),(517,3,1,282),(521,3,1,283),(525,3,1,286),(766,3,1,331),(763,3,1,332),(767,3,1,333),(721,3,1,531),(714,3,1,532),(718,3,1,534),(722,3,1,538),(544,3,1,1181),(572,3,1,1182),(551,3,1,1183),(552,3,1,1184),(556,3,1,1185),(560,3,1,1186),(564,3,1,1187),(569,3,1,1188),(565,3,1,1189),(573,3,1,1191),(589,3,1,1231),(580,3,1,1232),(581,3,1,1233),(585,3,1,1234),(586,3,1,1235),(590,3,1,1236),(620,3,1,1321),(621,3,1,1322),(541,3,1,1421),(732,3,1,2401),(729,3,1,2402),(733,3,1,2403),(743,3,1,2411),(740,3,1,2412),(744,3,1,2413),(745,3,1,2414),(665,3,1,50401),(683,3,1,50411),(672,3,1,50412),(676,3,1,50414),(680,3,1,50415),(684,3,1,50418),(687,3,1,50420),(688,3,1,50430),(664,3,1,50440),(769,3,1,59001),(770,3,1,59002),(771,3,1,59003),(600,3,1,941601),(595,3,1,941602),(596,3,1,941603),(597,3,1,941604),(598,3,1,941605),(601,3,1,941606),(768,3,1,858369821),(791,3,2,11),(792,3,2,12),(793,3,2,13),(794,3,2,14),(795,3,2,15),(796,3,2,16),(797,3,2,19),(798,3,2,21),(799,3,2,22),(800,3,2,24),(801,3,2,25),(802,3,2,26),(803,3,2,27),(804,3,2,28),(805,3,2,31),(806,3,2,32),(807,3,2,34),(808,3,2,38),(809,3,2,39),(810,3,2,81),(811,3,2,82),(812,3,2,84),(813,3,2,86),(814,3,2,87),(815,3,2,88),(816,3,2,89),(817,3,2,91),(818,3,2,92),(819,3,2,93),(820,3,2,94),(821,3,2,111),(822,3,2,112),(823,3,2,113),(824,3,2,114),(825,3,2,115),(826,3,2,116),(827,3,2,117),(828,3,2,121),(829,3,2,122),(830,3,2,125),(831,3,2,126),(832,3,2,241),(833,3,2,242),(834,3,2,243),(835,3,2,251),(836,3,2,252),(837,3,2,253),(838,3,2,254),(839,3,2,255),(840,3,2,256),(841,3,2,262),(842,3,2,281),(843,3,2,282),(844,3,2,283),(845,3,2,286),(846,3,2,331),(847,3,2,332),(848,3,2,333),(849,3,2,341),(850,3,2,342),(851,3,2,343),(852,3,2,344),(853,3,2,351),(854,3,2,352),(855,3,2,353),(856,3,2,354),(857,3,2,358),(858,3,2,531),(859,3,2,532),(860,3,2,534),(861,3,2,538),(862,3,2,1181),(863,3,2,1182),(864,3,2,1183),(865,3,2,1184),(866,3,2,1185),(867,3,2,1186),(868,3,2,1187),(869,3,2,1188),(870,3,2,1189),(871,3,2,1191),(872,3,2,1231),(873,3,2,1232),(874,3,2,1233),(875,3,2,1234),(876,3,2,1235),(877,3,2,1236),(878,3,2,1321),(879,3,2,1322),(880,3,2,1421),(881,3,2,2401),(882,3,2,2402),(883,3,2,2403),(884,3,2,2411),(885,3,2,2412),(886,3,2,2413),(887,3,2,2414),(888,3,2,5001),(889,3,2,5002),(890,3,2,5003),(891,3,2,5011),(892,3,2,5012),(893,3,2,5013),(894,3,2,5021),(895,3,2,5022),(896,3,2,5023),(897,3,2,5031),(898,3,2,5032),(899,3,2,5033),(900,3,2,5041),(901,3,2,5042),(902,3,2,5043),(903,3,2,5044),(904,3,2,5045),(905,3,2,5046),(906,3,2,5051),(907,3,2,5052),(908,3,2,5054),(909,3,2,5056),(910,3,2,5057),(911,3,2,5058),(912,3,2,5059),(913,3,2,5061),(914,3,2,5062),(915,3,2,5063),(916,3,2,5064),(917,3,2,5065),(918,3,2,5066),(919,3,2,5067),(920,3,2,5069),(921,3,2,50401),(922,3,2,50411),(923,3,2,50412),(924,3,2,50414),(925,3,2,50415),(926,3,2,50418),(927,3,2,50420),(928,3,2,50430),(929,3,2,50440),(930,3,2,59001),(931,3,2,59002),(932,3,2,59003),(933,3,2,941601),(934,3,2,941602),(935,3,2,941603),(936,3,2,941604),(937,3,2,941605),(938,3,2,941606),(939,3,2,858369821);

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

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

INSERT INTO `llx_usergroup` (`rowid`, `nom`, `entity`, `datec`, `tms`, `note`, `model_pdf`) VALUES (1,'SALLE',2,'2021-10-15 13:02:26','2021-10-15 13:02:26','roomreservation',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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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

INSERT INTO `llx_usergroup_user` (`rowid`, `entity`, `fk_user`, `fk_usergroup`) VALUES (1,2,3,1),(2,2,4,1),(4,2,5,1),(3,2,6,1),(5,2,7,1);

--
-- 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,
  `position` int(11) DEFAULT 0,
  `lastaccess` datetime DEFAULT NULL,
  `pageviews_month` bigint(20) unsigned DEFAULT 0,
  `pageviews_total` bigint(20) unsigned DEFAULT 0,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  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,
  `allowed_in_frames` int(11) DEFAULT 0,
  `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,
  `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_workstation_workstation`
--

CREATE TABLE `llx_workstation_workstation` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '(PROV)',
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(7) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_public` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity` int(11) DEFAULT 1,
  `note_private` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` smallint(6) NOT NULL,
  `nb_operators_required` int(11) DEFAULT NULL,
  `thm_operator_estimated` double DEFAULT NULL,
  `thm_machine_estimated` double DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_workstation_workstation_rowid` (`rowid`),
  KEY `idx_workstation_workstation_ref` (`ref`),
  KEY `fk_workstation_workstation_fk_user_creat` (`fk_user_creat`),
  KEY `idx_workstation_workstation_status` (`status`),
  CONSTRAINT `fk_workstation_workstation_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_workstation_workstation`
--


--
-- Table structure for table `llx_workstation_workstation_resource`
--

CREATE TABLE `llx_workstation_workstation_resource` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_resource` int(11) DEFAULT NULL,
  `fk_workstation` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_workstation_workstation_resource`
--


--
-- Table structure for table `llx_workstation_workstation_usergroup`
--

CREATE TABLE `llx_workstation_workstation_usergroup` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_usergroup` int(11) DEFAULT NULL,
  `fk_workstation` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_workstation_workstation_usergroup`
--


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



