-- Dumping data for table `llx_inventory`
--


--
-- Table structure for table `llx_inventorydet`
--

CREATE TABLE `llx_inventorydet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_inventory` int(11) DEFAULT '0',
  `fk_warehouse` int(11) DEFAULT '0',
  `fk_product` int(11) DEFAULT '0',
  `batch` varchar(30) DEFAULT NULL,
  `qty_view` double DEFAULT NULL,
  `qty_stock` double DEFAULT NULL,
  `qty_regulated` double DEFAULT NULL,
  `pmp` double DEFAULT '0',
  `pa` double DEFAULT '0',
  `new_pmp` double DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `idx_inventorydet_tms` (`tms`),
  KEY `idx_inventorydet_datec` (`datec`),
  KEY `idx_inventorydet_fk_inventory` (`fk_inventory`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_inventorydet`
--


--
-- Table structure for table `llx_links`
--

CREATE TABLE `llx_links` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datea` datetime NOT NULL,
  `url` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `objecttype` varchar(255) NOT NULL,
  `objectid` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_links` (`objectid`,`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_links`
--


--
-- Table structure for table `llx_livraison`
--

CREATE TABLE `llx_livraison` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ref` varchar(30) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_soc` int(11) NOT NULL,
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_int` varchar(30) DEFAULT NULL,
  `ref_customer` varchar(30) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `date_delivery` datetime DEFAULT NULL,
  `fk_address` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) DEFAULT '0',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_livraison_uk_ref` (`ref`,`entity`),
  KEY `idx_livraison_fk_soc` (`fk_soc`),
  KEY `idx_livraison_fk_user_author` (`fk_user_author`),
  KEY `idx_livraison_fk_user_valid` (`fk_user_valid`),
  CONSTRAINT `fk_livraison_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_livraison_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_livraison_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_livraison`
--


--
-- Table structure for table `llx_livraison_extrafields`
--

CREATE TABLE `llx_livraison_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_livraison_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_livraison_extrafields`
--


--
-- Table structure for table `llx_livraisondet`
--

CREATE TABLE `llx_livraisondet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_livraison` int(11) DEFAULT NULL,
  `fk_origin_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `description` text,
  `qty` double DEFAULT NULL,
  `subprice` double(24,8) DEFAULT '0.00000000',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `rang` int(11) DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `idx_livraisondet_fk_expedition` (`fk_livraison`),
  CONSTRAINT `fk_livraisondet_fk_livraison` FOREIGN KEY (`fk_livraison`) REFERENCES `llx_livraison` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_livraisondet`
--


--
-- Table structure for table `llx_livraisondet_extrafields`
--

CREATE TABLE `llx_livraisondet_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_livraisondet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_livraisondet_extrafields`
--


--
-- Table structure for table `llx_loan`
--

CREATE TABLE `llx_loan` (
  `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,
  `label` varchar(80) NOT NULL,
  `fk_bank` int(11) DEFAULT NULL,
  `capital` double(24,8) DEFAULT NULL,
  `datestart` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `nbterm` double DEFAULT NULL,
  `rate` double NOT NULL,
  `note_private` text,
  `note_public` text,
  `capital_position` double(24,8) DEFAULT NULL,
  `date_position` date DEFAULT NULL,
  `paid` smallint(6) NOT NULL DEFAULT '0',
  `accountancy_account_capital` varchar(32) DEFAULT NULL,
  `accountancy_account_insurance` varchar(32) DEFAULT NULL,
  `accountancy_account_interest` varchar(32) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  `fk_projet` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_loan`
--


--
-- Table structure for table `llx_loan_schedule`
--

CREATE TABLE `llx_loan_schedule` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_loan` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount_capital` double(24,8) DEFAULT NULL,
  `amount_insurance` double(24,8) DEFAULT NULL,
  `amount_interest` double(24,8) DEFAULT NULL,
  `fk_typepayment` int(11) NOT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `fk_bank` int(11) NOT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_loan_schedule`
--


--
-- Table structure for table `llx_localtax`
--

CREATE TABLE `llx_localtax` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `localtaxtype` tinyint(4) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `note` text,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_localtax`
--


--
-- Table structure for table `llx_mailing`
--

CREATE TABLE `llx_mailing` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `statut` smallint(6) DEFAULT '0',
  `titre` varchar(128) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `sujet` varchar(128) DEFAULT NULL,
  `body` mediumtext,
  `bgcolor` varchar(8) DEFAULT NULL,
  `bgimage` varchar(255) DEFAULT NULL,
  `cible` varchar(60) DEFAULT NULL,
  `nbemail` int(11) DEFAULT NULL,
  `email_from` varchar(160) DEFAULT NULL,
  `email_replyto` varchar(160) DEFAULT NULL,
  `email_errorsto` varchar(160) DEFAULT NULL,
  `tag` varchar(128) DEFAULT NULL,
  `date_creat` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_appro` datetime DEFAULT NULL,
  `date_envoi` datetime DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_user_appro` int(11) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `joined_file1` varchar(255) DEFAULT NULL,
  `joined_file2` varchar(255) DEFAULT NULL,
  `joined_file3` varchar(255) DEFAULT NULL,
  `joined_file4` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_mailing`
--


--
-- Table structure for table `llx_mailing_cibles`
--

CREATE TABLE `llx_mailing_cibles` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_mailing` int(11) NOT NULL,
  `fk_contact` int(11) NOT NULL,
  `lastname` varchar(160) DEFAULT NULL,
  `firstname` varchar(160) DEFAULT NULL,
  `email` varchar(160) NOT NULL,
  `other` varchar(255) DEFAULT NULL,
  `tag` varchar(128) DEFAULT NULL,
  `statut` smallint(6) NOT NULL DEFAULT '0',
  `source_url` varchar(255) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `source_type` varchar(16) DEFAULT NULL,
  `date_envoi` datetime DEFAULT NULL,
  `error_text` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mailing_cibles` (`fk_mailing`,`email`),
  KEY `idx_mailing_cibles_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_mailing_cibles`
--


--
-- Table structure for table `llx_menu`
--

CREATE TABLE `llx_menu` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `menu_handler` varchar(16) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `module` varchar(64) DEFAULT NULL,
  `type` varchar(4) NOT NULL,
  `mainmenu` varchar(100) NOT NULL,
  `leftmenu` varchar(100) DEFAULT NULL,
  `fk_menu` int(11) NOT NULL,
  `fk_mainmenu` varchar(100) DEFAULT NULL,
  `fk_leftmenu` varchar(100) DEFAULT NULL,
  `position` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `target` varchar(100) DEFAULT NULL,
  `titre` varchar(255) NOT NULL,
  `langs` varchar(100) DEFAULT NULL,
  `level` smallint(6) DEFAULT NULL,
  `perms` text,
  `enabled` varchar(255) DEFAULT '1',
  `usertype` int(11) NOT NULL DEFAULT '0',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_menu_uk_menu` (`menu_handler`,`fk_menu`,`position`,`url`,`entity`),
  KEY `idx_menu_menuhandler_type` (`menu_handler`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=10432 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_menu`
--

INSERT INTO `llx_menu` (`rowid`, `menu_handler`, `entity`, `module`, `type`, `mainmenu`, `leftmenu`, `fk_menu`, `fk_mainmenu`, `fk_leftmenu`, `position`, `url`, `target`, `titre`, `langs`, `level`, `perms`, `enabled`, `usertype`, `tms`) VALUES (5,'all',1,'cashdesk','top','cashdesk',NULL,0,NULL,NULL,100,'/cashdesk/index.php?user=__LOGIN__','pointofsale','CashDeskMenu','cashdesk',NULL,'$user->rights->cashdesk->use','$conf->cashdesk->enabled',0,'2017-02-24 11:07:20'),(5211,'auguria',1,'','top','home','',0,NULL,NULL,10,'/index.php?mainmenu=home&amp;leftmenu=','','Home','',-1,'','1',2,'2019-05-02 13:01:25'),(5212,'auguria',1,'societe|fournisseur','top','companies','',0,NULL,NULL,20,'/societe/index.php?mainmenu=companies&amp;leftmenu=','','ThirdParties','companies',-1,'$user->rights->societe->lire || $user->rights->societe->contact->lire','( ! empty($conf->societe->enabled) && (empty($conf->global->SOCIETE_DISABLE_PROSPECTS) || empty($conf->global->SOCIETE_DISABLE_CUSTOMERS))) || ! empty($conf->fournisseur->enabled)',2,'2019-05-02 13:01:25'),(5213,'auguria',1,'product|service','top','products','',0,NULL,NULL,30,'/product/index.php?mainmenu=products&amp;leftmenu=','','Products/Services','products',-1,'$user->rights->produit->lire||$user->rights->service->lire','$conf->product->enabled || $conf->service->enabled',0,'2019-05-02 13:01:25'),(5215,'auguria',1,'propal|commande|fournisseur|contrat|ficheinter','top','commercial','',0,NULL,NULL,40,'/comm/index.php?mainmenu=commercial&amp;leftmenu=','','Commercial','commercial',-1,'$user->rights->societe->lire || $user->rights->societe->contact->lire','$conf->propal->enabled || $conf->commande->enabled || $conf->supplier_order->enabled || $conf->contrat->enabled || $conf->ficheinter->enabled',2,'2019-05-02 13:01:25'),(5216,'auguria',1,'comptabilite|accounting|facture|don|tax|salaries|loan','top','accountancy','',0,NULL,NULL,50,'/compta/index.php?mainmenu=accountancy&amp;leftmenu=','','MenuFinancial','compta',-1,'$user->rights->compta->resultat->lire || $user->rights->accounting->plancompte->lire || $user->rights->facture->lire|| $user->rights->don->lire || $user->rights->tax->charges->lire || $user->rights->salaries->read || $user->rights->loan->read','$conf->comptabilite->enabled || $conf->accounting->enabled || $conf->facture->enabled || $conf->don->enabled  || $conf->tax->enabled || $conf->salaries->enabled || $conf->supplier_invoice->enabled || $conf->loan->enabled',2,'2019-05-02 13:01:25'),(5217,'auguria',1,'projet','top','project','',0,NULL,NULL,70,'/projet/index.php?mainmenu=project&amp;leftmenu=','','Projects','projects',-1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(5218,'auguria',1,'mailing|export|import|opensurvey|resource','top','tools','',0,NULL,NULL,90,'/core/tools.php?mainmenu=tools&amp;leftmenu=','','Tools','other',-1,'$user->rights->mailing->lire || $user->rights->export->lire || $user->rights->import->run || $user->rights->opensurvey->read || $user->rights->resource->read','$conf->mailing->enabled || $conf->export->enabled || $conf->import->enabled || $conf->opensurvey->enabled || $conf->resource->enabled',2,'2019-05-02 13:01:25'),(5223,'auguria',1,'adherent','top','members','',0,NULL,NULL,110,'/adherents/index.php?mainmenu=members&amp;leftmenu=','','Members','members',-1,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(5224,'auguria',1,'banque|prelevement','top','bank','',0,NULL,NULL,60,'/compta/bank/index.php?mainmenu=bank&amp;leftmenu=bank','','MenuBankCash','banks',-1,'$user->rights->banque->lire || $user->rights->prelevement->bons->lire','$conf->banque->enabled || $conf->prelevement->enabled',0,'2019-05-02 13:01:25'),(5225,'auguria',1,'hrm|holiday|deplacement|expensereport','top','hrm','',0,NULL,NULL,80,'/hrm/hrm.php?mainmenu=hrm&amp;leftmenu=','','HRM','holiday',-1,'$user->rights->hrm->employee->read || $user->rights->holiday->write || $user->rights->deplacement->lire || $user->rights->expensereport->lire','$conf->hrm->enabled || $conf->holiday->enabled || $conf->deplacement->enabled || $conf->expensereport->enabled',0,'2019-05-02 13:01:25'),(5300,'auguria',1,'','left','home','',5211,NULL,NULL,0,'/index.php','','Dashboard','',0,'','1',2,'2019-05-02 13:01:25'),(5310,'auguria',1,'','left','home','setup',5211,NULL,NULL,1,'/admin/index.php?leftmenu=setup','','Setup','admin',0,'','$user->admin',2,'2019-05-02 13:01:25'),(5311,'auguria',1,'','left','home','',5310,NULL,NULL,1,'/admin/company.php?leftmenu=setup','','MenuCompanySetup','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5312,'auguria',1,'','left','home','',5310,NULL,NULL,4,'/admin/ihm.php?leftmenu=setup','','GUISetup','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5313,'auguria',1,'','left','home','',5310,NULL,NULL,2,'/admin/modules.php?leftmenu=setup','','Modules','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5314,'auguria',1,'','left','home','',5310,NULL,NULL,6,'/admin/boxes.php?leftmenu=setup','','Boxes','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5315,'auguria',1,'','left','home','',5310,NULL,NULL,3,'/admin/menus.php?leftmenu=setup','','Menus','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5316,'auguria',1,'','left','home','',5310,NULL,NULL,7,'/admin/delais.php?leftmenu=setup','','Alerts','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5317,'auguria',1,'','left','home','',5310,NULL,NULL,10,'/admin/pdf.php?leftmenu=setup','','PDF','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5318,'auguria',1,'','left','home','',5310,NULL,NULL,8,'/admin/security_other.php?leftmenu=setup','','Security','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5319,'auguria',1,'','left','home','',5310,NULL,NULL,11,'/admin/mails.php?leftmenu=setup','','Emails','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5320,'auguria',1,'','left','home','',5310,NULL,NULL,9,'/admin/limits.php?leftmenu=setup','','MenuLimits','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5321,'auguria',1,'','left','home','',5310,NULL,NULL,13,'/admin/dict.php?leftmenu=setup','','Dictionary','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5322,'auguria',1,'','left','home','',5310,NULL,NULL,14,'/admin/const.php?leftmenu=setup','','OtherSetup','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5323,'auguria',1,'','left','home','',5310,NULL,NULL,12,'/admin/sms.php?leftmenu=setup','','SMS','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5324,'auguria',1,'','left','home','',5310,NULL,NULL,4,'/admin/translation.php?leftmenu=setup','','Translation','admin',1,'','$leftmenu==\"setup\"',2,'2019-05-02 13:01:25'),(5325,'auguria',1,'','left','home','',5310,NULL,NULL,4,'/accountancy/admin/fiscalyear.php?mainmenu=setup','','Fiscalyear','admin',1,'','$leftmenu==\"setup\" && $conf->accounting->enabled',2,'2019-05-02 13:01:25'),(5411,'auguria',1,'','left','home','',5510,NULL,NULL,0,'/admin/system/dolibarr.php?leftmenu=admintools','','InfoDolibarr','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5412,'auguria',1,'','left','home','',5411,NULL,NULL,2,'/admin/system/modules.php?leftmenu=admintools','','Modules','admin',2,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5413,'auguria',1,'','left','home','',5411,NULL,NULL,3,'/admin/triggers.php?leftmenu=admintools','','Triggers','admin',2,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5415,'auguria',1,'','left','home','',5510,NULL,NULL,1,'/admin/system/browser.php?leftmenu=admintools','','InfoBrowser','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5416,'auguria',1,'','left','home','',5510,NULL,NULL,2,'/admin/system/os.php?leftmenu=admintools','','InfoOS','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5417,'auguria',1,'','left','home','',5510,NULL,NULL,3,'/admin/system/web.php?leftmenu=admintools','','InfoWebServer','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5418,'auguria',1,'','left','home','',5510,NULL,NULL,4,'/admin/system/phpinfo.php?leftmenu=admintools','','InfoPHP','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5420,'auguria',1,'','left','home','',5510,NULL,NULL,5,'/admin/system/database.php?leftmenu=admintools','','InfoDatabase','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5510,'auguria',1,'','left','home','admintools',5211,NULL,NULL,2,'/admin/tools/index.php?leftmenu=admintools','','AdminTools','admin',0,'','$user->admin',2,'2019-05-02 13:01:25'),(5511,'auguria',1,'','left','home','',5510,NULL,NULL,6,'/admin/tools/dolibarr_export.php?leftmenu=admintools','','Backup','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5512,'auguria',1,'','left','home','',5510,NULL,NULL,7,'/admin/tools/dolibarr_import.php?leftmenu=admintools','','Restore','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5515,'auguria',1,'','left','home','',5510,NULL,NULL,8,'/admin/tools/update.php?leftmenu=admintools','','MenuUpgrade','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5516,'auguria',1,'','left','home','',5510,NULL,NULL,9,'/admin/tools/eaccelerator.php?leftmenu=admintools','','EAccelerator','admin',1,'','$leftmenu==\"admintools\" && function_exists(\"eaccelerator_info\")',2,'2019-05-02 13:01:25'),(5517,'auguria',1,'','left','home','',5510,NULL,NULL,10,'/admin/tools/listevents.php?leftmenu=admintools','','Audit','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5518,'auguria',1,'','left','home','',5510,NULL,NULL,11,'/admin/tools/listsessions.php?leftmenu=admintools','','Sessions','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5519,'auguria',1,'','left','home','',5510,NULL,NULL,12,'/admin/tools/purge.php?leftmenu=admintools','','Purge','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5520,'auguria',1,'','left','home','',5510,NULL,NULL,13,'/support/index.php?leftmenu=admintools','_blank','HelpCenter','help',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5521,'auguria',1,'','left','home','',5510,NULL,NULL,14,'/admin/system/about.php?leftmenu=admintools','','About','admin',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5530,'auguria',1,'','left','home','',5510,NULL,NULL,0,'/product/admin/product_tools.php?mainmenu=home&amp;leftmenu=admintools','','ProductVatMassChange','products',1,'','$leftmenu==\"admintools\"',2,'2019-05-02 13:01:25'),(5531,'auguria',1,'','left','home','',5510,NULL,NULL,0,'/accountancy/admin/productaccount.php?mainmenu=home&amp;leftmenu=admintools','','InitAccountancy','accountancy',1,'','$leftmenu==\"admintools\" && $conf->accounting->enabled',2,'2019-05-02 13:01:25'),(5610,'auguria',1,'','left','home','users',5211,NULL,NULL,4,'/user/home.php?leftmenu=users','','MenuUsersAndGroups','users',0,'','1',2,'2019-05-02 13:01:25'),(5611,'auguria',1,'','left','home','',5610,NULL,NULL,0,'/user/index.php?leftmenu=users','','Users','users',1,'$user->rights->user->user->lire || $user->admin','$leftmenu==\"users\"',2,'2019-05-02 13:01:25'),(5612,'auguria',1,'','left','home','',5611,NULL,NULL,0,'/user/card.php?leftmenu=users&amp;action=create','','NewUser','users',2,'$user->rights->user->user->creer || $user->admin','$leftmenu==\"users\"',2,'2019-05-02 13:01:25'),(5613,'auguria',1,'','left','home','',5610,NULL,NULL,1,'/user/group/index.php?leftmenu=users','','Groups','users',1,'($conf->global->MAIN_USE_ADVANCED_PERMS?$user->rights->user->group_advance->read:$user->rights->user->user->lire) || $user->admin','$leftmenu==\"users\"',2,'2019-05-02 13:01:25'),(5614,'auguria',1,'','left','home','',5613,NULL,NULL,0,'/user/group/card.php?leftmenu=users&amp;action=create','','NewGroup','users',2,'($conf->global->MAIN_USE_ADVANCED_PERMS?$user->rights->user->group_advance->write:$user->rights->user->user->creer) || $user->admin','$leftmenu==\"users\"',2,'2019-05-02 13:01:25'),(5710,'auguria',1,'','left','companies','thirdparties',5212,NULL,NULL,0,'/societe/index.php?leftmenu=thirdparties','','ThirdParty','companies',0,'$user->rights->societe->lire','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5711,'auguria',1,'','left','companies','',5710,NULL,NULL,0,'/societe/soc.php?action=create','','MenuNewThirdParty','companies',1,'$user->rights->societe->lire','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5712,'auguria',1,'','left','companies','',5710,NULL,NULL,0,'/societe/list.php?action=create','','List','companies',1,'$user->rights->societe->lire','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5713,'auguria',1,'','left','companies','',5710,NULL,NULL,5,'/societe/list.php?type=f&leftmenu=suppliers','','ListSuppliersShort','suppliers',1,'$user->rights->societe->lire && $user->rights->fournisseur->lire','$conf->societe->enabled && $conf->fournisseur->enabled',2,'2019-05-02 13:01:25'),(5714,'auguria',1,'','left','companies','',5713,NULL,NULL,0,'/societe/soc.php?leftmenu=supplier&amp;action=create&amp;type=f','','NewSupplier','suppliers',2,'$user->rights->societe->creer','$conf->societe->enabled && $conf->fournisseur->enabled',2,'2019-05-02 13:01:25'),(5716,'auguria',1,'','left','companies','',5710,NULL,NULL,3,'/societe/list.php?type=p&leftmenu=prospects','','ListProspectsShort','companies',1,'$user->rights->societe->lire','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5717,'auguria',1,'','left','companies','',5716,NULL,NULL,0,'/societe/soc.php?leftmenu=prospects&amp;action=create&amp;type=p','','MenuNewProspect','companies',2,'$user->rights->societe->creer','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5719,'auguria',1,'','left','companies','',5710,NULL,NULL,4,'/societe/list.php?type=c&leftmenu=customers','','ListCustomersShort','companies',1,'$user->rights->societe->lire','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5720,'auguria',1,'','left','companies','',5719,NULL,NULL,0,'/societe/soc.php?leftmenu=customers&amp;action=create&amp;type=c','','MenuNewCustomer','companies',2,'$user->rights->societe->creer','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5810,'auguria',1,'','left','companies','contacts',5212,NULL,NULL,1,'/contact/list.php?leftmenu=contacts','','ContactsAddresses','companies',0,'$user->rights->societe->lire','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5811,'auguria',1,'','left','companies','',5810,NULL,NULL,0,'/contact/card.php?leftmenu=contacts&amp;action=create','','NewContactAddress','companies',1,'$user->rights->societe->creer','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5812,'auguria',1,'','left','companies','',5810,NULL,NULL,1,'/contact/list.php?leftmenu=contacts','','List','companies',1,'$user->rights->societe->lire','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5814,'auguria',1,'','left','companies','',5812,NULL,NULL,1,'/contact/list.php?leftmenu=contacts&amp;type=p','','ThirdPartyProspects','companies',2,'$user->rights->societe->contact->lire','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5815,'auguria',1,'','left','companies','',5812,NULL,NULL,2,'/contact/list.php?leftmenu=contacts&amp;type=c','','ThirdPartyCustomers','companies',2,'$user->rights->societe->contact->lire','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5816,'auguria',1,'','left','companies','',5812,NULL,NULL,3,'/contact/list.php?leftmenu=contacts&amp;type=f','','ThirdPartySuppliers','companies',2,'$user->rights->societe->contact->lire','$conf->societe->enabled && $conf->fournisseur->enabled',2,'2019-05-02 13:01:25'),(5817,'auguria',1,'','left','companies','',5812,NULL,NULL,4,'/contact/list.php?leftmenu=contacts&amp;type=o','','Others','companies',2,'$user->rights->societe->contact->lire','$conf->societe->enabled',2,'2019-05-02 13:01:25'),(5860,'auguria',1,'','left','companies','cat',5212,NULL,NULL,3,'/categories/index.php?leftmenu=cat&amp;type=1','','SuppliersCategoriesShort','categories',0,'$user->rights->categorie->lire','$conf->societe->enabled && $conf->categorie->enabled',2,'2019-05-02 13:01:25'),(5861,'auguria',1,'','left','companies','',5860,NULL,NULL,0,'/categories/card.php?action=create&amp;type=1','','NewCategory','categories',1,'$user->rights->categorie->creer','$conf->societe->enabled && $conf->categorie->enabled',2,'2019-05-02 13:01:25'),(5870,'auguria',1,'','left','companies','cat',5212,NULL,NULL,4,'/categories/index.php?leftmenu=cat&amp;type=2','','CustomersProspectsCategoriesShort','categories',0,'$user->rights->categorie->lire','$conf->fournisseur->enabled && $conf->categorie->enabled',2,'2019-05-02 13:01:25'),(5871,'auguria',1,'','left','companies','',5870,NULL,NULL,0,'/categories/card.php?action=create&amp;type=2','','NewCategory','categories',1,'$user->rights->categorie->creer','$conf->fournisseur->enabled && $conf->categorie->enabled',2,'2019-05-02 13:01:25'),(5880,'auguria',1,'','left','companies','cat',5212,NULL,NULL,3,'/categories/index.php?leftmenu=cat&amp;type=4','','ContactCategoriesShort','categories',0,'$user->rights->categorie->lire','$conf->societe->enabled && $conf->categorie->enabled',2,'2019-05-02 13:01:25'),(5881,'auguria',1,'','left','companies','',5880,NULL,NULL,0,'/categories/card.php?action=create&amp;type=4','','NewCategory','categories',1,'$user->rights->categorie->creer','$conf->societe->enabled && $conf->categorie->enabled',2,'2019-05-02 13:01:25'),(6310,'auguria',1,'','left','commercial','propals',5215,NULL,NULL,4,'/comm/propal/index.php?leftmenu=propals','','Prop','propal',0,'$user->rights->propale->lire','$conf->propal->enabled',2,'2019-05-02 13:01:25'),(6311,'auguria',1,'','left','commercial','',6310,NULL,NULL,0,'/comm/propal/card.php?action=create&amp;leftmenu=propals','','NewPropal','propal',1,'$user->rights->propale->creer','$conf->propal->enabled',2,'2019-05-02 13:01:25'),(6312,'auguria',1,'','left','commercial','',6310,NULL,NULL,1,'/comm/propal/list.php?leftmenu=propals','','List','propal',1,'$user->rights->propale->lire','$conf->propal->enabled',2,'2019-05-02 13:01:25'),(6313,'auguria',1,'','left','commercial','',6312,NULL,NULL,2,'/comm/propal/list.php?leftmenu=propals&amp;viewstatut=0','','PropalsDraft','propal',1,'$user->rights->propale->lire','$conf->propal->enabled && $leftmenu==\"propals\"',2,'2019-05-02 13:01:25'),(6314,'auguria',1,'','left','commercial','',6312,NULL,NULL,3,'/comm/propal/list.php?leftmenu=propals&amp;viewstatut=1','','PropalsOpened','propal',1,'$user->rights->propale->lire','$conf->propal->enabled && $leftmenu==\"propals\"',2,'2019-05-02 13:01:25'),(6315,'auguria',1,'','left','commercial','',6312,NULL,NULL,4,'/comm/propal/list.php?leftmenu=propals&amp;viewstatut=2','','PropalStatusSigned','propal',1,'$user->rights->propale->lire','$conf->propal->enabled && $leftmenu==\"propals\"',2,'2019-05-02 13:01:25'),(6316,'auguria',1,'','left','commercial','',6312,NULL,NULL,5,'/comm/propal/list.php?leftmenu=propals&amp;viewstatut=3','','PropalStatusNotSigned','propal',1,'$user->rights->propale->lire','$conf->propal->enabled && $leftmenu==\"propals\"',2,'2019-05-02 13:01:25'),(6317,'auguria',1,'','left','commercial','',6312,NULL,NULL,6,'/comm/propal/list.php?leftmenu=propals&amp;viewstatut=4','','PropalStatusBilled','propal',1,'$user->rights->propale->lire','$conf->propal->enabled && $leftmenu==\"propals\"',2,'2019-05-02 13:01:25'),(6320,'auguria',1,'','left','commercial','',6310,NULL,NULL,4,'/comm/propal/stats/index.php?leftmenu=propals','','Statistics','propal',1,'$user->rights->propale->lire','$conf->propal->enabled',2,'2019-05-02 13:01:25'),(6410,'auguria',1,'','left','commercial','orders',5215,NULL,NULL,5,'/commande/index.php?leftmenu=orders','','CustomersOrders','orders',0,'$user->rights->commande->lire','$conf->commande->enabled',2,'2019-05-02 13:01:25'),(6411,'auguria',1,'','left','commercial','',6410,NULL,NULL,0,'/commande/card.php?action=create&amp;leftmenu=orders','','NewOrder','orders',1,'$user->rights->commande->creer','$conf->commande->enabled',2,'2019-05-02 13:01:25'),(6412,'auguria',1,'','left','commercial','',6410,NULL,NULL,1,'/commande/list.php?leftmenu=orders','','List','orders',1,'$user->rights->commande->lire','$conf->commande->enabled',2,'2019-05-02 13:01:25'),(6413,'auguria',1,'','left','commercial','',6412,NULL,NULL,2,'/commande/list.php?leftmenu=orders&amp;viewstatut=0','','StatusOrderDraftShort','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2019-05-02 13:01:25'),(6414,'auguria',1,'','left','commercial','',6412,NULL,NULL,3,'/commande/list.php?leftmenu=orders&amp;viewstatut=1','','StatusOrderValidated','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2019-05-02 13:01:25'),(6415,'auguria',1,'','left','commercial','',6412,NULL,NULL,4,'/commande/list.php?leftmenu=orders&amp;viewstatut=2','','StatusOrderOnProcessShort','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2019-05-02 13:01:25'),(6416,'auguria',1,'','left','commercial','',6412,NULL,NULL,5,'/commande/list.php?leftmenu=orders&amp;viewstatut=3','','StatusOrderToBill','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2019-05-02 13:01:25'),(6417,'auguria',1,'','left','commercial','',6412,NULL,NULL,6,'/commande/list.php?leftmenu=orders&amp;viewstatut=4','','StatusOrderProcessed','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2019-05-02 13:01:25'),(6418,'auguria',1,'','left','commercial','',6412,NULL,NULL,7,'/commande/list.php?leftmenu=orders&amp;viewstatut=-1','','StatusOrderCanceledShort','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2019-05-02 13:01:25'),(6419,'auguria',1,'','left','commercial','',6410,NULL,NULL,4,'/commande/stats/index.php?leftmenu=orders','','Statistics','orders',1,'$user->rights->commande->lire','$conf->commande->enabled',2,'2019-05-02 13:01:25'),(6510,'auguria',1,'','left','commercial','sendings',5213,NULL,NULL,6,'/expedition/index.php?leftmenu=sendings','','Shipments','sendings',0,'$user->rights->expedition->lire','$conf->expedition->enabled',2,'2019-05-02 13:01:25'),(6511,'auguria',1,'','left','commercial','',6510,NULL,NULL,0,'/expedition/card.php?action=create2&leftmenu=sendings','','NewSending','sendings',1,'$user->rights->expedition->creer','$conf->expedition->enabled && $leftmenu==\"sendings\"',2,'2019-05-02 13:01:25'),(6512,'auguria',1,'','left','commercial','',6510,NULL,NULL,1,'/expedition/list.php?leftmenu=sendings','','List','sendings',1,'$user->rights->expedition->lire','$conf->expedition->enabled && $leftmenu==\"sendings\"',2,'2019-05-02 13:01:25'),(6513,'auguria',1,'','left','commercial','',6510,NULL,NULL,2,'/expedition/stats/index.php?leftmenu=sendings','','Statistics','sendings',1,'$user->rights->expedition->lire','$conf->expedition->enabled && $leftmenu==\"sendings\"',2,'2019-05-02 13:01:25'),(6610,'auguria',1,'','left','commercial','contracts',5215,NULL,NULL,7,'/contrat/index.php?leftmenu=contracts','','Contracts','contracts',0,'$user->rights->contrat->lire','$conf->contrat->enabled',2,'2019-05-02 13:01:25'),(6611,'auguria',1,'','left','commercial','',6610,NULL,NULL,0,'/contrat/card.php?&action=create&amp;leftmenu=contracts','','NewContract','contracts',1,'$user->rights->contrat->creer','$conf->contrat->enabled',2,'2019-05-02 13:01:25'),(6612,'auguria',1,'','left','commercial','',6610,NULL,NULL,1,'/contrat/list.php?leftmenu=contracts','','List','contracts',1,'$user->rights->contrat->lire','$conf->contrat->enabled',2,'2019-05-02 13:01:25'),(6613,'auguria',1,'','left','commercial','',6610,NULL,NULL,2,'/contrat/services.php?leftmenu=contracts','','MenuServices','contracts',1,'$user->rights->contrat->lire','$conf->contrat->enabled',2,'2019-05-02 13:01:25'),(6614,'auguria',1,'','left','commercial','',6613,NULL,NULL,0,'/contrat/services.php?leftmenu=contracts&amp;mode=0','','MenuInactiveServices','contracts',2,'$user->rights->contrat->lire','$conf->contrat->enabled&&$leftmenu==\"contracts\"',2,'2019-05-02 13:01:25'),(6615,'auguria',1,'','left','commercial','',6613,NULL,NULL,1,'/contrat/services.php?leftmenu=contracts&amp;mode=4','','MenuRunningServices','contracts',2,'$user->rights->contrat->lire','$conf->contrat->enabled&&$leftmenu==\"contracts\"',2,'2019-05-02 13:01:25'),(6616,'auguria',1,'','left','commercial','',6613,NULL,NULL,2,'/contrat/services.php?leftmenu=contracts&amp;mode=4&amp;filter=expired','','MenuExpiredServices','contracts',2,'$user->rights->contrat->lire','$conf->contrat->enabled&&$leftmenu==\"contracts\"',2,'2019-05-02 13:01:25'),(6617,'auguria',1,'','left','commercial','',6613,NULL,NULL,3,'/contrat/services.php?leftmenu=contracts&amp;mode=5','','MenuClosedServices','contracts',2,'$user->rights->contrat->lire','$conf->contrat->enabled&&$leftmenu==\"contracts\"',2,'2019-05-02 13:01:25'),(6710,'auguria',1,'','left','commercial','ficheinter',5215,NULL,NULL,8,'/fichinter/list.php?leftmenu=ficheinter','','Interventions','interventions',0,'$user->rights->ficheinter->lire','$conf->ficheinter->enabled',2,'2019-05-02 13:01:25'),(6711,'auguria',1,'','left','commercial','',6710,NULL,NULL,0,'/fichinter/card.php?action=create&amp;leftmenu=ficheinter','','NewIntervention','interventions',1,'$user->rights->ficheinter->creer','$conf->ficheinter->enabled',2,'2019-05-02 13:01:25'),(6712,'auguria',1,'','left','commercial','',6710,NULL,NULL,1,'/fichinter/list.php?leftmenu=ficheinter','','List','interventions',1,'$user->rights->ficheinter->lire','$conf->ficheinter->enabled',2,'2019-05-02 13:01:25'),(6713,'auguria',1,'','left','commercial','',6710,NULL,NULL,2,'/fichinter/stats/index.php?leftmenu=ficheinter','','Statistics','interventions',1,'$user->rights->ficheinter->lire','$conf->ficheinter->enabled',2,'2019-05-02 13:01:25'),(6810,'auguria',1,'','left','accountancy','supplier_bills',5216,NULL,NULL,3,'/fourn/facture/list.php?leftmenu=suppliers_bills','','BillsSuppliers','bills',0,'$user->rights->fournisseur->facture->lire','$conf->supplier_invoice->enabled',2,'2019-05-02 13:01:25'),(6811,'auguria',1,'','left','accountancy','',6810,NULL,NULL,0,'/fourn/facture/card.php?action=create&amp;leftmenu=suppliers_bills','','NewBill','bills',1,'$user->rights->fournisseur->facture->creer','$conf->supplier_invoice->enabled',2,'2019-05-02 13:01:25'),(6812,'auguria',1,'','left','accountancy','',6810,NULL,NULL,1,'/fourn/facture/impayees.php?leftmenu=suppliers_bills','','Unpaid','bills',1,'$user->rights->fournisseur->facture->lire','$conf->supplier_invoice->enabled',2,'2019-05-02 13:01:25'),(6813,'auguria',1,'','left','accountancy','',6810,NULL,NULL,2,'/fourn/facture/paiement.php?leftmenu=suppliers_bills','','Payments','bills',1,'$user->rights->fournisseur->facture->lire','$conf->supplier_invoice->enabled',2,'2019-05-02 13:01:25'),(6814,'auguria',1,'','left','accountancy','',6810,NULL,NULL,8,'/compta/facture/stats/index.php?leftmenu=customers_bills&mode=supplier','','Statistics','bills',1,'$user->rights->fournisseur->facture->lire','$conf->supplier_invoice->enabled',2,'2019-05-02 13:01:25'),(6910,'auguria',1,'','left','accountancy','customer_bills',5216,NULL,NULL,3,'/compta/facture/list.php?leftmenu=customers_bills','','BillsCustomers','bills',0,'$user->rights->facture->lire','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(6911,'auguria',1,'','left','accountancy','',6910,NULL,NULL,3,'/compta/facture.php?action=create&amp;leftmenu=customers_bills','','NewBill','bills',1,'$user->rights->facture->creer','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(6912,'auguria',1,'','left','accountancy','',6910,NULL,NULL,5,'/compta/facture/fiche-rec.php?leftmenu=customers_bills','','ListOfTemplates','bills',1,'$user->rights->facture->lire','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(6914,'auguria',1,'','left','accountancy','',6910,NULL,NULL,6,'/compta/paiement/list.php?leftmenu=customers_bills','','Payments','bills',1,'$user->rights->facture->lire','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(6915,'auguria',1,'','left','accountancy','',6910,NULL,NULL,4,'/compta/facture/list.php?leftmenu=customers_bills','','List','bills',1,'$user->rights->facture->lire','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(6920,'auguria',1,'','left','accountancy','',6914,NULL,NULL,1,'/compta/paiement/rapport.php?leftmenu=customers_bills','','Reportings','bills',2,'$user->rights->facture->lire','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(6921,'auguria',1,'','left','accountancy','checks',5224,NULL,NULL,9,'/compta/paiement/cheque/index.php?leftmenu=checks&amp;mainmenu=bank','','MenuChequeDeposits','bills',0,'$user->rights->banque->lire','empty($conf->global->BANK_DISABLE_CHECK_DEPOSIT) && ! empty($conf->banque->enabled) && (! empty($conf->facture->enabled) || ! empty($conf->global->MAIN_MENU_CHEQUE_DEPOSIT_ON))',2,'2019-05-02 13:01:25'),(6922,'auguria',1,'','left','accountancy','',6921,NULL,NULL,0,'/compta/paiement/cheque/card.php?leftmenu=checks&amp;action=new','','NewCheckDeposit','compta',1,'$user->rights->banque->lire','empty($conf->global->BANK_DISABLE_CHECK_DEPOSIT) && ! empty($conf->banque->enabled) && (! empty($conf->facture->enabled) || ! empty($conf->global->MAIN_MENU_CHEQUE_DEPOSIT_ON))',2,'2019-05-02 13:01:25'),(6923,'auguria',1,'','left','accountancy','',6921,NULL,NULL,1,'/compta/paiement/cheque/list.php?leftmenu=checks','','List','bills',1,'$user->rights->banque->lire','empty($conf->global->BANK_DISABLE_CHECK_DEPOSIT) && ! empty($conf->banque->enabled) && (! empty($conf->facture->enabled) || ! empty($conf->global->MAIN_MENU_CHEQUE_DEPOSIT_ON))',2,'2019-05-02 13:01:25'),(6924,'auguria',1,'','left','accountancy','',6910,NULL,NULL,8,'/compta/facture/stats/index.php?leftmenu=customers_bills','','Statistics','bills',1,'$user->rights->facture->lire','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(6930,'auguria',1,'','left','accountancy','',6915,NULL,NULL,1,'/compta/facture/list.php?leftmenu=customers_bills&amp;search_status=0','','BillShortStatusDraft','bills',2,'$user->rights->facture->lire','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(6931,'auguria',1,'','left','accountancy','',6915,NULL,NULL,2,'/compta/facture/list.php?leftmenu=customers_bills&amp;search_status=1','','BillShortStatusNotPaid','bills',2,'$user->rights->facture->lire','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(6932,'auguria',1,'','left','accountancy','',6915,NULL,NULL,3,'/compta/facture/list.php?leftmenu=customers_bills&amp;search_status=2','','BillShortStatusPaid','bills',2,'$user->rights->facture->lire','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(6933,'auguria',1,'','left','accountancy','',6915,NULL,NULL,4,'/compta/facture/list.php?leftmenu=customers_bills&amp;search_status=3','','BillShortStatusCanceled','bills',2,'$user->rights->facture->lire','$conf->facture->enabled',2,'2019-05-02 13:01:25'),(7110,'auguria',1,'','left','accountancy','orders',5216,NULL,NULL,3,'/commande/list.php?leftmenu=orders&amp;viewstatut=3','','MenuOrdersToBill','orders',0,'$user->rights->commande->lire','$conf->commande->enabled',0,'2019-05-02 13:01:25'),(7210,'auguria',1,'','left','accountancy','donations',5216,NULL,NULL,4,'/don/index.php?leftmenu=donations&amp;mainmenu=accountancy','','Donations','donations',0,'$user->rights->don->lire','$conf->don->enabled',2,'2019-05-02 13:01:25'),(7211,'auguria',1,'','left','accountancy','',7210,NULL,NULL,0,'/don/card.php?leftmenu=donations&amp;mainmenu=accountancy&amp;action=create','','NewDonation','donations',1,'$user->rights->don->creer','$conf->don->enabled && $leftmenu==\"donations\"',2,'2019-05-02 13:01:25'),(7212,'auguria',1,'','left','accountancy','',7210,NULL,NULL,1,'/don/list.php?leftmenu=donations&amp;mainmenu=accountancy','','List','donations',1,'$user->rights->don->lire','$conf->don->enabled && $leftmenu==\"donations\"',2,'2019-05-02 13:01:25'),(7310,'auguria',1,'','left','accountancy','tripsandexpenses',5225,NULL,NULL,5,'/compta/deplacement/index.php?leftmenu=tripsandexpenses','','TripsAndExpenses','trips',0,'$user->rights->deplacement->lire','$conf->deplacement->enabled',0,'2019-05-02 13:01:25'),(7311,'auguria',1,'','left','accountancy','',7310,NULL,NULL,1,'/compta/deplacement/card.php?action=create&amp;leftmenu=tripsandexpenses','','New','trips',1,'$user->rights->deplacement->creer','$conf->deplacement->enabled',0,'2019-05-02 13:01:25'),(7312,'auguria',1,'','left','accountancy','',7310,NULL,NULL,2,'/compta/deplacement/list.php?leftmenu=tripsandexpenses','','List','trips',1,'$user->rights->deplacement->lire','$conf->deplacement->enabled',0,'2019-05-02 13:01:25'),(7313,'auguria',1,'','left','accountancy','',7310,NULL,NULL,2,'/compta/deplacement/stats/index.php?leftmenu=tripsandexpenses','','Statistics','trips',1,'$user->rights->deplacement->lire','$conf->deplacement->enabled',0,'2019-05-02 13:01:25'),(7410,'auguria',1,'','left','accountancy','tax',5216,NULL,NULL,6,'/compta/charges/index.php?leftmenu=tax&amp;mainmenu=accountancy','','MenuSpecialExpenses','compta',0,'(! empty($conf->tax->enabled) && $user->rights->tax->charges->lire) || (! empty($conf->salaries->enabled) && $user->rights->salaries->read)','$conf->tax->enabled || $conf->salaries->enabled',0,'2019-05-02 13:01:25'),(7420,'auguria',1,'','left','accountancy','tax_sal',7410,NULL,NULL,1,'/compta/salaries/index.php?leftmenu=tax_salary&amp;mainmenu=accountancy','','Salaries','salaries',1,'$user->rights->salaries->read','$conf->salaries->enabled',0,'2019-05-02 13:01:25'),(7421,'auguria',1,'','left','accountancy','',7420,NULL,NULL,2,'/compta/salaries/card.php?leftmenu=tax_salary&amp;action=create','','NewPayment','companies',2,'$user->rights->salaries->write','$conf->salaries->enabled && $leftmenu==\"tax_salary\"',0,'2019-05-02 13:01:25'),(7422,'auguria',1,'','left','accountancy','',7420,NULL,NULL,3,'/compta/salaries/index.php?leftmenu=tax_salary','','Payments','companies',2,'$user->rights->salaries->read','$conf->salaries->enabled && $leftmenu==\"tax_salary\"',0,'2019-05-02 13:01:25'),(7430,'auguria',1,'','left','accountancy','tax_loan',7410,NULL,NULL,1,'/loan/index.php?leftmenu=tax_loan&amp;mainmenu=accountancy','','Loans','loan',1,'$user->rights->loan->read','$conf->loan->enabled',0,'2019-05-02 13:01:25'),(7431,'auguria',1,'','left','accountancy','',7430,NULL,NULL,2,'/loan/card.php?leftmenu=tax_loan&amp;action=create','','NewLoan','loan',2,'$user->rights->loan->write','$conf->loan->enabled && $leftmenu==\"tax_loan\"',0,'2019-05-02 13:01:25'),(7433,'auguria',1,'','left','accountancy','',7430,NULL,NULL,4,'/loan/calc.php?leftmenu=tax_loan','','Calculator','companies',2,'$user->rights->loan->calc','$conf->loan->enabled && $leftmenu==\"tax_loan\" && ! empty($conf->global->LOAN_SHOW_CALCULATOR)',0,'2019-05-02 13:01:25'),(7460,'auguria',1,'','left','accountancy','tax_social',7410,NULL,NULL,1,'/compta/sociales/index.php?leftmenu=tax_social','','SocialContributions','',1,'$user->rights->tax->charges->lire','$conf->tax->enabled',0,'2019-05-02 13:01:25'),(7461,'auguria',1,'','left','accountancy','',7460,NULL,NULL,2,'/compta/sociales/charges.php?leftmenu=tax_social&amp;action=create','','MenuNewSocialContribution','',2,'$user->rights->tax->charges->creer','$conf->tax->enabled && $leftmenu==\"tax_social\"',0,'2019-05-02 13:01:25'),(7462,'auguria',1,'','left','accountancy','',7460,NULL,NULL,3,'/compta/charges/index.php?leftmenu=tax_social&amp;mainmenu=accountancy&amp;mode=sconly','','Payments','',2,'$user->rights->tax->charges->lire','$conf->tax->enabled && $leftmenu==\"tax_social\"',0,'2019-05-02 13:01:25'),(7510,'auguria',1,'','left','accountancy','tax_vat',7410,NULL,NULL,7,'/compta/tva/index.php?leftmenu=tax_vat&amp;mainmenu=accountancy','','VAT','companies',1,'$user->rights->tax->charges->lire','$conf->tax->enabled && empty($conf->global->TAX_DISABLE_VAT_MENUS)',0,'2019-05-02 13:01:25'),(7511,'auguria',1,'','left','accountancy','',7510,NULL,NULL,0,'/compta/tva/card.php?leftmenu=tax_vat&amp;action=create','','New','companies',2,'$user->rights->tax->charges->creer','$conf->tax->enabled && empty($conf->global->TAX_DISABLE_VAT_MENUS) && $leftmenu==\"tax_vat\"',0,'2019-05-02 13:01:25'),(7512,'auguria',1,'','left','accountancy','',7510,NULL,NULL,1,'/compta/tva/reglement.php?leftmenu=tax_vat','','List','companies',2,'$user->rights->tax->charges->lire','$conf->tax->enabled && empty($conf->global->TAX_DISABLE_VAT_MENUS) && $leftmenu==\"tax_vat\"',0,'2019-05-02 13:01:25'),(7513,'auguria',1,'','left','accountancy','',7510,NULL,NULL,2,'/compta/tva/clients.php?leftmenu=tax_vat','','ReportByCustomers','companies',2,'$user->rights->tax->charges->lire','$conf->tax->enabled && empty($conf->global->TAX_DISABLE_VAT_MENUS) && $leftmenu==\"tax_vat\"',0,'2019-05-02 13:01:25'),(7514,'auguria',1,'','left','accountancy','',7510,NULL,NULL,3,'/compta/tva/quadri_detail.php?leftmenu=tax_vat','','ReportByQuarter','companies',2,'$user->rights->tax->charges->lire','$conf->tax->enabled && empty($conf->global->TAX_DISABLE_VAT_MENUS) && $leftmenu==\"tax_vat\"',0,'2019-05-02 13:01:25'),(7610,'auguria',1,'','left','accountancy','accounting',5216,NULL,NULL,7,'/accountancy/customer/index.php?leftmenu=accounting','','MenuAccountancy','accountancy',0,'! empty($conf->accounting->enabled) || $user->rights->accounting->ventilation->read || $user->rights->accounting->ventilation->dispatch || $user->rights->compta->resultat->lire','$conf->accounting->enabled',0,'2019-05-02 13:01:25'),(7611,'auguria',1,'','left','accountancy','dispatch_customer',7610,NULL,NULL,1,'/accountancy/customer/index.php?leftmenu=dispatch_customer','','CustomersVentilation','accountancy',1,'$user->rights->accounting->ventilation->read','$conf->accounting->enabled',0,'2019-05-02 13:01:25'),(7612,'auguria',1,'','left','accountancy','',7611,NULL,NULL,2,'/accountancy/customer/list.php','','ToDispatch','accountancy',2,'$user->rights->accounting->ventilation->dispatch','$conf->accounting->enabled && $leftmenu==\"dispatch_customer\"',0,'2019-05-02 13:01:25'),(7613,'auguria',1,'','left','accountancy','',7611,NULL,NULL,3,'/accountancy/customer/lines.php','','Dispatched','accountancy',2,'$user->rights->accounting->ventilation->read','$conf->accounting->enabled && $leftmenu==\"dispatch_customer\"',0,'2019-05-02 13:01:25'),(7620,'auguria',1,'','left','accountancy','ventil_supplier',7610,NULL,NULL,4,'/accountancy/supplier/index.php?leftmenu=dispatch_supplier','','SuppliersVentilation','accountancy',1,'$user->rights->accounting->ventilation->read','$conf->accounting->enabled && $conf->fournisseur->enabled',0,'2019-05-02 13:01:25'),(7621,'auguria',1,'','left','accountancy','',7620,NULL,NULL,5,'/accountancy/supplier/list.php','','ToDispatch','accountancy',2,'$user->rights->accounting->ventilation->dispatch','$conf->accounting->enabled && $conf->fournisseur->enabled && $leftmenu==\"dispatch_supplier\"',0,'2019-05-02 13:01:25'),(7622,'auguria',1,'','left','accountancy','',7620,NULL,NULL,6,'/accountancy/supplier/lines.php','','Dispatched','accountancy',2,'$user->rights->accounting->ventilation->read','$conf->accounting->enabled && $conf->fournisseur->enabled && $leftmenu==\"dispatch_supplier\"',0,'2019-05-02 13:01:25'),(7640,'auguria',1,'','left','accountancy','bookkeeping',7610,NULL,NULL,15,'/accountancy/bookkeeping/list.php','','Bookkeeping','accountancy',1,'$user->rights->accounting->mouvements->lire','$conf->accounting->enabled',0,'2019-05-02 13:01:25'),(7645,'auguria',1,'','left','accountancy','balance',7610,NULL,NULL,16,'/accountancy/bookkeeping/balance.php','','AccountBalance','accountancy',1,'$user->rights->accounting->mouvements->lire','$conf->accounting->enabled',0,'2019-05-02 13:01:25'),(7650,'auguria',1,'','left','accountancy','report',7610,NULL,NULL,17,'/accountancy/report/result.php?leftmenu=ca&amp;mainmenu=accountancy','','Reportings','main',1,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->accounting->enabled',0,'2019-05-02 13:01:25'),(7651,'auguria',1,'','left','accountancy','',7650,NULL,NULL,18,'/accountancy/report/result.php?leftmenu=ca','','ReportInOut','main',2,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->accounting->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7652,'auguria',1,'','left','accountancy','',7650,NULL,NULL,19,'/compta/resultat/index.php?leftmenu=ca','','ByExpenseIncome','main',3,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->accounting->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7653,'auguria',1,'','left','accountancy','',7650,NULL,NULL,20,'/compta/resultat/clientfourn.php?leftmenu=ca','','ByCompanies','main',3,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->accounting->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7654,'auguria',1,'','left','accountancy','',7650,NULL,NULL,21,'/compta/stats/index.php?leftmenu=ca','','ReportTurnover','main',2,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->accounting->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7655,'auguria',1,'','left','accountancy','',7650,NULL,NULL,22,'/compta/stats/casoc.php?leftmenu=ca','','ByCompanies','main',3,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->accounting->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7656,'auguria',1,'','left','accountancy','',7650,NULL,NULL,23,'/compta/stats/cabyuser.php?leftmenu=ca','','ByUsers','main',3,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->accounting->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7657,'auguria',1,'','left','accountancy','',7650,NULL,NULL,24,'/compta/stats/cabyprodserv.php?leftmenu=ca','','ByProductsAndServices','main',3,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->accounting->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7661,'auguria',1,'','left','home','',7610,NULL,NULL,25,'/accountancy/admin/account.php?mainmenu=accountancy','','Chartofaccounts','admin',1,'$user->rights->accounting->chartofaccount','$conf->accounting->enabled',0,'2019-05-02 13:01:25'),(7710,'auguria',1,'','left','accountancy','withdraw',5224,NULL,NULL,9,'/compta/prelevement/index.php?leftmenu=withdraw&amp;mainmenu=bank','','StandingOrders','withdrawals',0,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled',2,'2019-05-02 13:01:25'),(7712,'auguria',1,'','left','accountancy','',7710,NULL,NULL,0,'/compta/prelevement/create.php?leftmenu=withdraw','','NewStandingOrder','withdrawals',1,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled && $leftmenu==\"withdraw\"',2,'2019-05-02 13:01:25'),(7713,'auguria',1,'','left','accountancy','',7710,NULL,NULL,2,'/compta/prelevement/bons.php?leftmenu=withdraw','','WithdrawalsReceipts','withdrawals',1,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled && $leftmenu==\"withdraw\"',2,'2019-05-02 13:01:25'),(7714,'auguria',1,'','left','accountancy','',7710,NULL,NULL,3,'/compta/prelevement/list.php?leftmenu=withdraw','','WithdrawalsLines','withdrawals',1,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled && $leftmenu==\"withdraw\"',2,'2019-05-02 13:01:25'),(7716,'auguria',1,'','left','accountancy','',7710,NULL,NULL,5,'/compta/prelevement/rejets.php?leftmenu=withdraw','','Rejects','withdrawals',1,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled && $leftmenu==\"withdraw\"',2,'2019-05-02 13:01:25'),(7717,'auguria',1,'','left','accountancy','',7710,NULL,NULL,6,'/compta/prelevement/stats.php?leftmenu=withdraw','','Statistics','withdrawals',1,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled && $leftmenu==\"withdraw\"',2,'2019-05-02 13:01:25'),(7810,'auguria',1,'','left','accountancy','bank',5224,NULL,NULL,1,'/compta/bank/index.php?leftmenu=bank&amp;mainmenu=bank','','MenuBankCash','banks',0,'$user->rights->banque->lire','$conf->banque->enabled',0,'2019-05-02 13:01:25'),(7811,'auguria',1,'','left','accountancy','',7810,NULL,NULL,0,'/compta/bank/card.php?action=create&amp;leftmenu=bank','','MenuNewFinancialAccount','banks',1,'$user->rights->banque->configurer','$conf->banque->enabled && ($leftmenu==\"bank\" || $leftmenu==\"checks\" || $leftmenu==\"withdraw\")',0,'2019-05-02 13:01:25'),(7813,'auguria',1,'','left','accountancy','',7810,NULL,NULL,2,'/compta/bank/search.php?leftmenu=bank','','ListTransactions','banks',1,'$user->rights->banque->lire','$conf->banque->enabled && ($leftmenu==\"bank\" || $leftmenu==\"checks\" || $leftmenu==\"withdraw\")',0,'2019-05-02 13:01:25'),(7814,'auguria',1,'','left','accountancy','',7810,NULL,NULL,3,'/compta/bank/budget.php?leftmenu=bank','','ListTransactionsByCategory','banks',1,'$user->rights->banque->lire','$conf->banque->enabled && ($leftmenu==\"bank\" || $leftmenu==\"checks\" || $leftmenu==\"withdraw\")',0,'2019-05-02 13:01:25'),(7816,'auguria',1,'','left','accountancy','',7810,NULL,NULL,5,'/compta/bank/virement.php?leftmenu=bank','','BankTransfers','banks',1,'$user->rights->banque->transfer','$conf->banque->enabled && ($leftmenu==\"bank\" || $leftmenu==\"checks\" || $leftmenu==\"withdraw\")',0,'2019-05-02 13:01:25'),(7860,'auguria',1,'','left','accountancy','cat',5224,NULL,NULL,4,'/categories/index.php?leftmenu=cat&amp;type=5','','Categories','categories',0,'$user->rights->categorie->lire','$conf->categorie->enabled',2,'2019-05-02 13:01:25'),(7861,'auguria',1,'','left','accountancy','',7860,NULL,NULL,0,'/categories/card.php?action=create&amp;type=5','','NewCategory','categories',1,'$user->rights->categorie->creer','$conf->categorie->enabled',2,'2019-05-02 13:01:25'),(7910,'auguria',1,'','left','accountancy','ca',5216,NULL,NULL,11,'/compta/resultat/index.php?leftmenu=ca&amp;mainmenu=accountancy','','Reportings','main',0,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->comptabilite->enabled',0,'2019-05-02 13:01:25'),(7911,'auguria',1,'','left','accountancy','',7910,NULL,NULL,0,'/compta/resultat/index.php?leftmenu=ca','','ReportInOut','main',1,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->comptabilite->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7912,'auguria',1,'','left','accountancy','',7911,NULL,NULL,0,'/compta/resultat/clientfourn.php?leftmenu=ca','','ByCompanies','main',2,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->comptabilite->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7913,'auguria',1,'','left','accountancy','',7910,NULL,NULL,1,'/compta/stats/index.php?leftmenu=ca','','ReportTurnover','main',1,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->comptabilite->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7914,'auguria',1,'','left','accountancy','',7913,NULL,NULL,0,'/compta/stats/casoc.php?leftmenu=ca','','ByCompanies','main',2,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->comptabilite->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7915,'auguria',1,'','left','accountancy','',7913,NULL,NULL,1,'/compta/stats/cabyuser.php?leftmenu=ca','','ByUsers','main',2,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->comptabilite->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7916,'auguria',1,'','left','accountancy','',7910,NULL,NULL,1,'/compta/journal/sellsjournal.php?leftmenu=ca','','SellsJournal','main',1,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->comptabilite->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7917,'auguria',1,'','left','accountancy','',7910,NULL,NULL,1,'/compta/journal/purchasesjournal.php?leftmenu=ca','','PurchasesJournal','main',1,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->comptabilite->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(7918,'auguria',1,'','left','accountancy','',7913,NULL,NULL,1,'/compta/stats/cabyprodserv.php?leftmenu=ca','','ByProductsAndServices','main',2,'$user->rights->compta->resultat->lire || $user->rights->accounting->comptarapport->lire','$conf->comptabilite->enabled && $leftmenu==\"ca\"',0,'2019-05-02 13:01:25'),(8010,'auguria',1,'','left','products','product',5213,NULL,NULL,0,'/product/index.php?leftmenu=product&amp;type=0','','Products','products',0,'$user->rights->produit->lire','$conf->product->enabled',2,'2019-05-02 13:01:25'),(8011,'auguria',1,'','left','products','',8010,NULL,NULL,0,'/product/card.php?leftmenu=product&amp;action=create&amp;type=0','','NewProduct','products',1,'$user->rights->produit->creer','$conf->product->enabled',2,'2019-05-02 13:01:25'),(8012,'auguria',1,'','left','products','',8010,NULL,NULL,1,'/product/list.php?leftmenu=product&amp;type=0','','List','products',1,'$user->rights->produit->lire','$conf->product->enabled',2,'2019-05-02 13:01:25'),(8013,'auguria',1,'','left','products','',8010,NULL,NULL,4,'/product/reassort.php?type=0','','Stocks','products',1,'$user->rights->produit->lire && $user->rights->stock->lire','$conf->product->enabled',2,'2019-05-02 13:01:25'),(8014,'auguria',1,'','left','products','',8010,NULL,NULL,6,'/product/stats/card.php?id=all&amp;leftmenu=stats&amp;type=0','','Statistics','main',1,'$user->rights->produit->lire','$conf->propal->enabled',2,'2019-05-02 13:01:25'),(8015,'auguria',1,'','left','products','',8010,NULL,NULL,5,'/product/reassortlot.php?type=0','','StocksByLotSerial','products',1,'$user->rights->produit->lire && $user->rights->stock->lire','$conf->productbatch->enabled',2,'2019-05-02 13:01:25'),(8110,'auguria',1,'','left','products','service',5213,NULL,NULL,1,'/product/index.php?leftmenu=service&amp;type=1','','Services','products',0,'$user->rights->service->lire','$conf->service->enabled',2,'2019-05-02 13:01:25'),(8111,'auguria',1,'','left','products','',8110,NULL,NULL,0,'/product/card.php?leftmenu=service&amp;action=create&amp;type=1','','NewService','products',1,'$user->rights->service->creer','$conf->service->enabled',2,'2019-05-02 13:01:25'),(8112,'auguria',1,'','left','products','',8110,NULL,NULL,1,'/product/list.php?leftmenu=service&amp;type=1','','List','products',1,'$user->rights->service->lire','$conf->service->enabled',2,'2019-05-02 13:01:25'),(8113,'auguria',1,'','left','products','',8110,NULL,NULL,5,'/product/stats/card.php?id=all&amp;leftmenu=stats&amp;type=1','','Statistics','main',1,'$user->rights->service->lire','$conf->propal->enabled',2,'2019-05-02 13:01:25'),(8310,'auguria',1,'','left','products','stock',5213,NULL,NULL,3,'/product/stock/index.php?leftmenu=stock','','Stock','stocks',0,'$user->rights->stock->lire','$conf->stock->enabled',2,'2019-05-02 13:01:25'),(8311,'auguria',1,'','left','products','',8310,NULL,NULL,0,'/product/stock/card.php?action=create','','MenuNewWarehouse','stocks',1,'$user->rights->stock->creer','$conf->stock->enabled',2,'2019-05-02 13:01:25'),(8312,'auguria',1,'','left','products','',8310,NULL,NULL,1,'/product/stock/list.php','','List','stocks',1,'$user->rights->stock->lire','$conf->stock->enabled',2,'2019-05-02 13:01:25'),(8314,'auguria',1,'','left','products','',8310,NULL,NULL,3,'/product/stock/mouvement.php','','Movements','stocks',1,'$user->rights->stock->mouvement->lire','$conf->stock->enabled',2,'2019-05-02 13:01:25'),(8315,'auguria',1,'','left','products','',8310,NULL,NULL,4,'/product/stock/replenish.php','','Replenishments','stocks',1,'$user->rights->stock->mouvement->creer && $user->rights->fournisseur->lire','$conf->stock->enabled && $conf->supplier_order->enabled',2,'2019-05-02 13:01:25'),(8316,'auguria',1,'','left','products','',8310,NULL,NULL,5,'/product/stock/massstockmove.php','','MassStockTransferShort','stocks',1,'$user->rights->stock->mouvement->creer','$conf->stock->enabled',2,'2019-05-02 13:01:25'),(8410,'auguria',1,'','left','products','cat',5213,NULL,NULL,4,'/categories/index.php?leftmenu=cat&amp;type=0','','Categories','categories',0,'$user->rights->categorie->lire','$conf->categorie->enabled',2,'2019-05-02 13:01:25'),(8411,'auguria',1,'','left','products','',8410,NULL,NULL,0,'/categories/card.php?action=create&amp;type=0','','NewCategory','categories',1,'$user->rights->categorie->creer','$conf->categorie->enabled',2,'2019-05-02 13:01:25'),(8810,'auguria',1,'','left','project','projects',5217,NULL,NULL,0,'/projet/index.php?leftmenu=projects','','Projects','projects',0,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(8811,'auguria',1,'','left','project','',8810,NULL,NULL,1,'/projet/card.php?leftmenu=projects&amp;action=create','','NewProject','projects',1,'$user->rights->projet->creer','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(8812,'auguria',1,'','left','project','',8810,NULL,NULL,2,'/projet/list.php?leftmenu=projects','','List','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(8820,'auguria',1,'','left','project','myprojects',5217,NULL,NULL,0,'/projet/index.php?leftmenu=projects&amp;mode=mine','','MyProjects','projects',0,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(8821,'auguria',1,'','left','project','',8820,NULL,NULL,1,'/projet/card.php?leftmenu=projects&amp;action=create&amp;mode=mine','','NewProject','projects',1,'$user->rights->projet->creer','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(8822,'auguria',1,'','left','project','',8820,NULL,NULL,2,'/projet/list.php?leftmenu=projects&amp;mode=mine','','List','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(8910,'auguria',1,'','left','project','',5217,NULL,NULL,0,'/projet/activity/index.php?leftmenu=projects','','Activities','projects',0,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(8911,'auguria',1,'','left','project','',8910,NULL,NULL,1,'/projet/tasks.php?leftmenu=projects&amp;action=create','','NewTask','projects',1,'$user->rights->projet->creer','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(8912,'auguria',1,'','left','project','',8910,NULL,NULL,2,'/projet/tasks/list.php?leftmenu=projects','','List','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(8913,'auguria',1,'','left','project','',8910,NULL,NULL,3,'/projet/activity/perweek.php?leftmenu=projects','','NewTimeSpent','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(9010,'auguria',1,'','left','project','',5217,NULL,NULL,0,'/projet/activity/index.php?leftmenu=projects&amp;mode=mine','','MyActivities','projects',0,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(9011,'auguria',1,'','left','project','',9010,NULL,NULL,1,'/projet/tasks.php?leftmenu=projects&amp;action=create','','NewTask','projects',1,'$user->rights->projet->creer','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(9012,'auguria',1,'','left','project','',9010,NULL,NULL,2,'/projet/tasks/list.php?leftmenu=projects&amp;mode=mine','','List','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(9013,'auguria',1,'','left','project','',9010,NULL,NULL,3,'/projet/activity/perweek.php?leftmenu=projects&amp;mode=mine','','NewTimeSpent','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2019-05-02 13:01:25'),(9110,'auguria',1,'','left','tools','mailing',5218,NULL,NULL,0,'/comm/mailing/index.php?leftmenu=mailing','','EMailings','mails',0,'$user->rights->mailing->lire','$conf->mailing->enabled',0,'2019-05-02 13:01:25'),(9111,'auguria',1,'','left','tools','',9110,NULL,NULL,0,'/comm/mailing/card.php?leftmenu=mailing&amp;action=create','','NewMailing','mails',1,'$user->rights->mailing->creer','$conf->mailing->enabled',0,'2019-05-02 13:01:25'),(9112,'auguria',1,'','left','tools','',9110,NULL,NULL,1,'/comm/mailing/list.php?leftmenu=mailing','','List','mails',1,'$user->rights->mailing->lire','$conf->mailing->enabled',0,'2019-05-02 13:01:25'),(9310,'auguria',1,'','left','tools','export',5218,NULL,NULL,2,'/exports/index.php?leftmenu=export','','FormatedExport','exports',0,'$user->rights->export->lire','$conf->export->enabled',2,'2019-05-02 13:01:25'),(9311,'auguria',1,'','left','tools','',9310,NULL,NULL,0,'/exports/export.php?leftmenu=export','','NewExport','exports',1,'$user->rights->export->creer','$conf->export->enabled',2,'2019-05-02 13:01:25'),(9340,'auguria',1,'','left','tools','import',5218,NULL,NULL,2,'/imports/index.php?leftmenu=import','','FormatedImport','exports',0,'$user->rights->import->run','$conf->import->enabled',2,'2019-05-02 13:01:25'),(9341,'auguria',1,'','left','tools','',9340,NULL,NULL,0,'/imports/import.php?leftmenu=import','','NewImport','exports',1,'$user->rights->import->run','$conf->import->enabled',2,'2019-05-02 13:01:25'),(9410,'auguria',1,'','left','members','members',5223,NULL,NULL,0,'/adherents/index.php?leftmenu=members&amp;mainmenu=members','','Members','members',0,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9411,'auguria',1,'','left','members','',9410,NULL,NULL,0,'/adherents/card.php?leftmenu=members&amp;action=create','','NewMember','members',1,'$user->rights->adherent->creer','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9412,'auguria',1,'','left','members','',9410,NULL,NULL,1,'/adherents/list.php','','List','members',1,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9413,'auguria',1,'','left','members','',9412,NULL,NULL,2,'/adherents/list.php?leftmenu=members&amp;statut=-1','','MenuMembersToValidate','members',2,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9414,'auguria',1,'','left','members','',9412,NULL,NULL,3,'/adherents/list.php?leftmenu=members&amp;statut=1','','MenuMembersValidated','members',2,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9415,'auguria',1,'','left','members','',9412,NULL,NULL,4,'/adherents/list.php?leftmenu=members&amp;statut=1&amp;filter=outofdate','','MenuMembersNotUpToDate','members',2,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9416,'auguria',1,'','left','members','',9412,NULL,NULL,5,'/adherents/list.php?leftmenu=members&amp;statut=1&amp;filter=uptodate','','MenuMembersUpToDate','members',2,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9417,'auguria',1,'','left','members','',9412,NULL,NULL,6,'/adherents/list.php?leftmenu=members&amp;statut=0','','MenuMembersResiliated','members',2,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9418,'auguria',1,'','left','members','',9410,NULL,NULL,7,'/adherents/stats/geo.php?leftmenu=members&amp;mode=memberbycountry','','MenuMembersStats','members',1,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9510,'auguria',1,'','left','members','',5223,NULL,NULL,1,'/adherents/index.php?leftmenu=members&amp;mainmenu=members','','Subscriptions','compta',0,'$user->rights->adherent->cotisation->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9511,'auguria',1,'','left','members','',9510,NULL,NULL,0,'/adherents/list.php?statut=-1&amp;leftmenu=accountancy&amp;mainmenu=members','','NewSubscription','compta',1,'$user->rights->adherent->cotisation->creer','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9512,'auguria',1,'','left','members','',9510,NULL,NULL,1,'/adherents/cotisations.php?leftmenu=members','','List','compta',1,'$user->rights->adherent->cotisation->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9513,'auguria',1,'','left','members','',9510,NULL,NULL,7,'/adherents/stats/index.php?leftmenu=members','','MenuMembersStats','members',1,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9710,'auguria',1,'','left','members','export',5223,NULL,NULL,3,'/adherents/index.php?leftmenu=export&amp;mainmenu=members','','Exports','members',0,'$user->rights->adherent->export','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9711,'auguria',1,'','left','members','',9710,NULL,NULL,0,'/exports/index.php?leftmenu=export','','Datas','members',1,'$user->rights->adherent->export','$conf->adherent->enabled && $conf->export->enabled',2,'2019-05-02 13:01:25'),(9712,'auguria',1,'','left','members','',9710,NULL,NULL,1,'/adherents/htpasswd.php?leftmenu=export','','Filehtpasswd','members',1,'$user->rights->adherent->export','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9713,'auguria',1,'','left','members','',9710,NULL,NULL,2,'/adherents/cartes/carte.php?leftmenu=export','','MembersCards','members',1,'$user->rights->adherent->export','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9810,'auguria',1,'','left','hrm','hrm',5225,NULL,NULL,1,'/user/index.php?&leftmenu=hrm&mode=employee','','Employees','hrm',0,'$user->rights->hrm->employee->read','$conf->hrm->enabled',0,'2019-05-02 13:01:25'),(9811,'auguria',1,'','left','hrm','',9810,NULL,NULL,1,'/user/card.php?&action=create','','NewEmployee','hrm',1,'$user->rights->hrm->employee->write','$conf->hrm->enabled',0,'2019-05-02 13:01:25'),(9812,'auguria',1,'','left','hrm','',9810,NULL,NULL,2,'/user/index.php?$leftmenu=hrm&mode=employee','','List','hrm',1,'$user->rights->hrm->employee->read','$conf->hrm->enabled',0,'2019-05-02 13:01:25'),(9910,'auguria',1,'','left','members','setup',5223,NULL,NULL,5,'/adherents/type.php?leftmenu=setup&amp;mainmenu=members','','MembersTypes','members',0,'$user->rights->adherent->configurer','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9911,'auguria',1,'','left','members','',9910,NULL,NULL,0,'/adherents/type.php?leftmenu=setup&amp;mainmenu=members&amp;action=create','','New','members',1,'$user->rights->adherent->configurer','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(9912,'auguria',1,'','left','members','',9910,NULL,NULL,1,'/adherents/type.php?leftmenu=setup&amp;mainmenu=members','','List','members',1,'$user->rights->adherent->configurer','$conf->adherent->enabled',2,'2019-05-02 13:01:25'),(10210,'auguria',1,'','left','hrm','hrm',5225,NULL,NULL,1,'/holiday/list.php?&leftmenu=hrm','','CPTitreMenu','holiday',0,'$user->rights->holiday->read','$conf->holiday->enabled',0,'2019-05-02 13:01:25'),(10211,'auguria',1,'','left','hrm','',10210,NULL,NULL,1,'/holiday/card.php?&action=request','','MenuAddCP','holiday',1,'$user->rights->holiday->write','$conf->holiday->enabled',0,'2019-05-02 13:01:25'),(10212,'auguria',1,'','left','hrm','',10210,NULL,NULL,1,'/holiday/list.php?&leftmenu=hrm','','List','holiday',1,'$user->rights->holiday->read','$conf->holiday->enabled',0,'2019-05-02 13:01:25'),(10213,'auguria',1,'','left','hrm','',10212,NULL,NULL,1,'/holiday/list.php?select_statut=2&leftmenu=hrm','','ListToApprove','trips',2,'$user->rights->holiday->read','$conf->holiday->enabled',0,'2019-05-02 13:01:25'),(10214,'auguria',1,'','left','hrm','',10210,NULL,NULL,2,'/holiday/define_holiday.php?&action=request','','MenuConfCP','holiday',1,'$user->rights->holiday->define_holiday','$conf->holiday->enabled',0,'2019-05-02 13:01:25'),(10215,'auguria',1,'','left','hrm','',10210,NULL,NULL,3,'/holiday/view_log.php?&action=request','','MenuLogCP','holiday',1,'$user->rights->holiday->define_holiday','$conf->holiday->enabled',0,'2019-05-02 13:01:25'),(10310,'auguria',1,'','left','commercial','orders_suppliers',5215,NULL,NULL,6,'/fourn/commande/index.php?leftmenu=orders_suppliers','','SuppliersOrders','orders',0,'$user->rights->fournisseur->commande->lire','$conf->supplier_order->enabled',2,'2019-05-02 13:01:25'),(10311,'auguria',1,'','left','commercial','',10310,NULL,NULL,0,'/fourn/commande/card.php?action=create&amp;leftmenu=orders_suppliers','','NewOrder','orders',1,'$user->rights->fournisseur->commande->creer','$conf->supplier_order->enabled',2,'2019-05-02 13:01:25'),(10312,'auguria',1,'','left','commercial','',10310,NULL,NULL,1,'/fourn/commande/list.php?leftmenu=orders_suppliers&amp;viewstatut=0','','List','orders',1,'$user->rights->fournisseur->commande->lire','$conf->supplier_order->enabled',2,'2019-05-02 13:01:25'),(10318,'auguria',1,'','left','commercial','',10310,NULL,NULL,7,'/commande/stats/index.php?leftmenu=orders_suppliers&amp;mode=supplier','','Statistics','orders',1,'$user->rights->fournisseur->commande->lire','$conf->supplier_order->enabled',2,'2019-05-02 13:01:25'),(10410,'auguria',1,'','left','members','cat',5223,NULL,NULL,3,'/categories/index.php?leftmenu=cat&amp;type=3','','MembersCategoriesShort','categories',0,'$user->rights->categorie->lire','$conf->adherent->enabled && $conf->categorie->enabled',2,'2019-05-02 13:01:25'),(10411,'auguria',1,'','left','members','',10410,NULL,NULL,0,'/categories/card.php?action=create&amp;type=3','','NewCategory','categories',1,'$user->rights->categorie->creer','$conf->adherent->enabled && $conf->categorie->enabled',2,'2019-05-02 13:01:25'),(10428,'all',1,'ecm','top','ecm',NULL,0,NULL,NULL,82,'/ecm/index.php','','MenuECM','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload || $user->rights->ecm->setup','$conf->ecm->enabled',2,'2019-06-06 20:30:19'),(10429,'all',1,'ecm','left','ecm','ecm',-1,'ecm',NULL,101,'/ecm/index.php?mainmenu=ecm&leftmenu=ecm','','ECMArea','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload','$user->rights->ecm->read || $user->rights->ecm->upload',2,'2019-06-06 20:30:20'),(10430,'all',1,'ecm','left','ecm','ecm_manual',-1,'ecm','ecm',102,'/ecm/index.php?action=file_manager&mainmenu=ecm&leftmenu=ecm','','ECMSectionsManual','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload','$user->rights->ecm->read || $user->rights->ecm->upload',2,'2019-06-06 20:30:20'),(10431,'all',1,'ecm','left','ecm',NULL,-1,'ecm','ecm',103,'/ecm/index_auto.php?action=file_manager&mainmenu=ecm&leftmenu=ecm','','ECMSectionsAuto','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload','($user->rights->ecm->read || $user->rights->ecm->upload) && ! empty($conf->global->ECM_AUTO_TREE_ENABLED)',2,'2019-06-06 20:30:20');

--
-- Table structure for table `llx_multicurrency`
--

CREATE TABLE `llx_multicurrency` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `date_create` datetime DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `entity` int(11) DEFAULT '1',
  `fk_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_multicurrency`
--


--
-- Table structure for table `llx_multicurrency_rate`
--

CREATE TABLE `llx_multicurrency_rate` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `date_sync` datetime DEFAULT NULL,
  `rate` double NOT NULL DEFAULT '0',
  `fk_multicurrency` int(11) NOT NULL,
  `entity` int(11) DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_multicurrency_rate`
--


--
-- Table structure for table `llx_notify`
--

CREATE TABLE `llx_notify` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `daten` datetime DEFAULT NULL,
  `fk_action` int(11) NOT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `type` varchar(16) DEFAULT 'email',
  `fk_contact` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `objet_type` varchar(24) NOT NULL,
  `objet_id` int(11) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `type_target` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_notify`
--


--
-- Table structure for table `llx_notify_def`
--

CREATE TABLE `llx_notify_def` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` date DEFAULT NULL,
  `fk_action` int(11) NOT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_contact` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `type` varchar(16) DEFAULT 'email',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_notify_def`
--


--
-- Table structure for table `llx_notify_def_object`
--

CREATE TABLE `llx_notify_def_object` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `objet_type` varchar(16) DEFAULT NULL,
  `objet_id` int(11) NOT NULL,
  `type_notif` varchar(16) DEFAULT 'browser',
  `date_notif` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `moreparam` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_notify_def_object`
--


--
-- Table structure for table `llx_oauth_state`
--

CREATE TABLE `llx_oauth_state` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `service` varchar(36) DEFAULT NULL,
  `state` varchar(128) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `fk_adherent` int(11) DEFAULT NULL,
  `entity` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_oauth_state`
--


--
-- Table structure for table `llx_oauth_token`
--

CREATE TABLE `llx_oauth_token` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `service` varchar(36) DEFAULT NULL,
  `token` text,
  `fk_user` int(11) DEFAULT NULL,
  `fk_adherent` int(11) DEFAULT NULL,
  `entity` int(11) DEFAULT NULL,
  `tokenstring` text,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_oauth_token`
--


--
-- Table structure for table `llx_onlinesignature`
--

CREATE TABLE `llx_onlinesignature` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `object_type` varchar(32) NOT NULL,
  `object_id` int(11) NOT NULL,
  `datec` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `name` varchar(255) NOT NULL,
  `ip` varchar(128) DEFAULT NULL,
  `pathoffile` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_onlinesignature`
--


--
-- Table structure for table `llx_opensurvey_comments`
--

CREATE TABLE `llx_opensurvey_comments` (
  `id_comment` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_sondage` char(16) NOT NULL,
  `comment` text NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `usercomment` text,
  PRIMARY KEY (`id_comment`),
  KEY `idx_id_comment` (`id_comment`),
  KEY `idx_id_sondage` (`id_sondage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_opensurvey_comments`
--


--
-- Table structure for table `llx_opensurvey_formquestions`
--

CREATE TABLE `llx_opensurvey_formquestions` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `id_sondage` varchar(16) DEFAULT NULL,
  `question` text,
  `available_answers` text,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_opensurvey_formquestions`
--


--
-- Table structure for table `llx_opensurvey_sondage`
--

CREATE TABLE `llx_opensurvey_sondage` (
  `id_sondage` varchar(16) NOT NULL,
  `commentaires` text,
  `mail_admin` varchar(128) DEFAULT NULL,
  `nom_admin` varchar(64) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `titre` text NOT NULL,
  `date_fin` datetime DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `format` varchar(2) NOT NULL,
  `mailsonde` tinyint(4) NOT NULL DEFAULT '0',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sujet` text,
  `entity` int(11) NOT NULL DEFAULT '1',
  `allow_comments` tinyint(4) NOT NULL DEFAULT '1',
  `allow_spy` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_sondage`),
  KEY `idx_date_fin` (`date_fin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_opensurvey_sondage`
--


--
-- Table structure for table `llx_opensurvey_user_formanswers`
--

CREATE TABLE `llx_opensurvey_user_formanswers` (
  `fk_user_survey` int(11) NOT NULL,
  `fk_question` int(11) NOT NULL,
  `reponses` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_opensurvey_user_formanswers`
--


--
-- Table structure for table `llx_opensurvey_user_studs`
--

CREATE TABLE `llx_opensurvey_user_studs` (
  `id_users` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(64) NOT NULL,
  `id_sondage` varchar(16) NOT NULL,
  `reponses` varchar(100) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_users`),
  KEY `idx_opensurvey_user_studs_id_users` (`id_users`),
  KEY `idx_opensurvey_user_studs_nom` (`nom`),
  KEY `idx_opensurvey_user_studs_id_sondage` (`id_sondage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_opensurvey_user_studs`
--


--
-- Table structure for table `llx_overwrite_trans`
--

CREATE TABLE `llx_overwrite_trans` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `lang` varchar(5) DEFAULT NULL,
  `transkey` varchar(128) DEFAULT NULL,
  `transvalue` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_overwrite_trans` (`lang`,`transkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_overwrite_trans`
--


--
-- Table structure for table `llx_paiement`
--

CREATE TABLE `llx_paiement` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) NOT NULL DEFAULT '',
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `fk_paiement` int(11) NOT NULL,
  `num_paiement` varchar(50) DEFAULT NULL,
  `note` text,
  `fk_bank` int(11) NOT NULL DEFAULT '0',
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `statut` smallint(6) NOT NULL DEFAULT '0',
  `fk_export_compta` int(11) NOT NULL DEFAULT '0',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  `ext_payment_id` varchar(128) DEFAULT NULL,
  `ext_payment_site` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_paiement`
--


--
-- Table structure for table `llx_paiement_facture`
--

CREATE TABLE `llx_paiement_facture` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_paiement` int(11) DEFAULT NULL,
  `fk_facture` int(11) DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_paiement_facture` (`fk_paiement`,`fk_facture`),
  KEY `idx_paiement_facture_fk_facture` (`fk_facture`),
  KEY `idx_paiement_facture_fk_paiement` (`fk_paiement`),
  CONSTRAINT `fk_paiement_facture_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `llx_facture` (`rowid`),
  CONSTRAINT `fk_paiement_facture_fk_paiement` FOREIGN KEY (`fk_paiement`) REFERENCES `llx_paiement` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_paiement_facture`
--


--
-- Table structure for table `llx_paiementcharge`
--

CREATE TABLE `llx_paiementcharge` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_charge` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT NULL,
  `fk_typepaiement` int(11) NOT NULL,
  `num_paiement` varchar(50) DEFAULT NULL,
  `note` text,
  `fk_bank` int(11) NOT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_paiementcharge`
--


--
-- Table structure for table `llx_paiementfourn`
--

CREATE TABLE `llx_paiementfourn` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) DEFAULT NULL,
  `entity` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_paiement` int(11) NOT NULL,
  `num_paiement` varchar(50) DEFAULT NULL,
  `note` text,
  `fk_bank` int(11) NOT NULL,
  `statut` smallint(6) NOT NULL DEFAULT '0',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  `model_pdf` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_paiementfourn`
--


--
-- Table structure for table `llx_paiementfourn_facturefourn`
--

CREATE TABLE `llx_paiementfourn_facturefourn` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_paiementfourn` int(11) DEFAULT NULL,
  `fk_facturefourn` int(11) DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_paiementfourn_facturefourn` (`fk_paiementfourn`,`fk_facturefourn`),
  KEY `idx_paiementfourn_facturefourn_fk_facture` (`fk_facturefourn`),
  KEY `idx_paiementfourn_facturefourn_fk_paiement` (`fk_paiementfourn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_paiementfourn_facturefourn`
--


--
-- Table structure for table `llx_payment_donation`
--

CREATE TABLE `llx_payment_donation` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_donation` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT NULL,
  `fk_typepayment` int(11) NOT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `note` text,
  `fk_bank` int(11) NOT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_payment_donation`
--


--
-- Table structure for table `llx_payment_expensereport`
--

CREATE TABLE `llx_payment_expensereport` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_expensereport` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT NULL,
  `fk_typepayment` int(11) NOT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `note` text,
  `fk_bank` int(11) NOT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_payment_expensereport`
--


--
-- Table structure for table `llx_payment_loan`
--

CREATE TABLE `llx_payment_loan` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_loan` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount_capital` double(24,8) DEFAULT NULL,
  `amount_insurance` double(24,8) DEFAULT NULL,
  `amount_interest` double(24,8) DEFAULT NULL,
  `fk_typepayment` int(11) NOT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `fk_bank` int(11) NOT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_payment_loan`
--


--
-- Table structure for table `llx_payment_salary`
--

CREATE TABLE `llx_payment_salary` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) 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) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `fk_typepayment` int(11) NOT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `datesp` date DEFAULT NULL,
  `dateep` date DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `note` text,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_payment_salary_ref` (`num_payment`),
  KEY `idx_payment_salary_user` (`fk_user`,`entity`),
  KEY `idx_payment_salary_datep` (`datep`),
  KEY `idx_payment_salary_datesp` (`datesp`),
  KEY `idx_payment_salary_dateep` (`dateep`),
  CONSTRAINT `fk_payment_salary_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_payment_salary`
--


--
-- Table structure for table `llx_payment_various`
--

CREATE TABLE `llx_payment_various` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `sens` smallint(6) NOT NULL DEFAULT '0',
  `amount` double(24,8) NOT NULL DEFAULT '0.00000000',
  `fk_typepayment` int(11) NOT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `accountancy_code` varchar(32) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `note` text,
  `fk_bank` 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;

--
-- Dumping data for table `llx_payment_various`
--


--
-- Table structure for table `llx_pos_cash_fence`
--

CREATE TABLE `llx_pos_cash_fence` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref` varchar(64) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `opening` double(24,8) DEFAULT '0.00000000',
  `cash` double(24,8) DEFAULT '0.00000000',
  `card` double(24,8) DEFAULT '0.00000000',
  `cheque` double(24,8) DEFAULT '0.00000000',
  `status` int(11) DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `date_valid` datetime DEFAULT NULL,
  `day_close` int(11) DEFAULT NULL,
  `month_close` int(11) DEFAULT NULL,
  `year_close` int(11) DEFAULT NULL,
  `posmodule` varchar(30) DEFAULT NULL,
  `posnumber` varchar(30) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_pos_cash_fence`
--


--
-- Table structure for table `llx_prelevement_bons`
--

CREATE TABLE `llx_prelevement_bons` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(12) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT NULL,
  `statut` smallint(6) DEFAULT '0',
  `credite` smallint(6) DEFAULT '0',
  `note` text,
  `date_trans` datetime DEFAULT NULL,
  `method_trans` smallint(6) DEFAULT NULL,
  `fk_user_trans` int(11) DEFAULT NULL,
  `date_credit` datetime DEFAULT NULL,
  `fk_user_credit` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_prelevement_bons_ref` (`ref`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_prelevement_bons`
--


--
-- Table structure for table `llx_prelevement_facture`
--

CREATE TABLE `llx_prelevement_facture` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_facture` int(11) NOT NULL,
  `fk_prelevement_lignes` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_prelevement_facture_fk_prelevement_lignes` (`fk_prelevement_lignes`),
  CONSTRAINT `fk_prelevement_facture_fk_prelevement_lignes` FOREIGN KEY (`fk_prelevement_lignes`) REFERENCES `llx_prelevement_lignes` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_prelevement_facture`
--


--
-- Table structure for table `llx_prelevement_facture_demande`
--

CREATE TABLE `llx_prelevement_facture_demande` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_facture` int(11) NOT NULL,
  `amount` double(24,8) DEFAULT NULL,
  `date_demande` datetime NOT NULL,
  `traite` smallint(6) DEFAULT '0',
  `date_traite` datetime DEFAULT NULL,
  `fk_prelevement_bons` int(11) DEFAULT NULL,
  `fk_user_demande` int(11) NOT NULL,
  `code_banque` varchar(128) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_prelevement_facture_demande`
--


--
-- Table structure for table `llx_prelevement_lignes`
--

CREATE TABLE `llx_prelevement_lignes` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_prelevement_bons` int(11) DEFAULT NULL,
  `fk_soc` int(11) NOT NULL,
  `statut` smallint(6) DEFAULT '0',
  `client_nom` varchar(255) DEFAULT NULL,
  `amount` double(24,8) DEFAULT NULL,
  `code_banque` varchar(128) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  `note` text,
  PRIMARY KEY (`rowid`),
  KEY `idx_prelevement_lignes_fk_prelevement_bons` (`fk_prelevement_bons`),
  CONSTRAINT `fk_prelevement_lignes_fk_prelevement_bons` FOREIGN KEY (`fk_prelevement_bons`) REFERENCES `llx_prelevement_bons` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_prelevement_lignes`
--


--
-- Table structure for table `llx_prelevement_rejet`
--

CREATE TABLE `llx_prelevement_rejet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_prelevement_lignes` int(11) DEFAULT NULL,
  `date_rejet` datetime DEFAULT NULL,
  `motif` int(11) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `fk_user_creation` int(11) DEFAULT NULL,
  `note` text,
  `afacturer` tinyint(4) DEFAULT '0',
  `fk_facture` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_prelevement_rejet`
--


--
-- Table structure for table `llx_printer_ipp`
--

CREATE TABLE `llx_printer_ipp` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `printer_name` text NOT NULL,
  `printer_location` text NOT NULL,
  `printer_uri` varchar(255) NOT NULL,
  `copy` int(11) NOT NULL DEFAULT '1',
  `module` varchar(16) NOT NULL,
  `login` varchar(32) NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_printer_ipp`
--


--
-- Table structure for table `llx_printing`
--

CREATE TABLE `llx_printing` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `printer_name` text NOT NULL,
  `printer_location` text NOT NULL,
  `printer_id` varchar(255) NOT NULL,
  `copy` int(11) NOT NULL DEFAULT '1',
  `module` varchar(16) NOT NULL,
  `driver` varchar(16) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_printing`
--


--
-- Table structure for table `llx_product`
--

CREATE TABLE `llx_product` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(128) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `virtual` tinyint(4) NOT NULL DEFAULT '0',
  `fk_parent` int(11) DEFAULT '0',
  `label` varchar(255) NOT NULL,
  `description` text,
  `note` text,
  `customcode` varchar(32) DEFAULT NULL,
  `fk_country` int(11) DEFAULT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `price_ttc` double(24,8) DEFAULT '0.00000000',
  `price_min` double(24,8) DEFAULT '0.00000000',
  `price_min_ttc` double(24,8) DEFAULT '0.00000000',
  `price_base_type` varchar(3) DEFAULT 'HT',
  `tva_tx` double(6,3) DEFAULT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) NOT NULL DEFAULT '0',
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `tosell` tinyint(4) DEFAULT '1',
  `tobuy` tinyint(4) DEFAULT '1',
  `onportal` smallint(6) DEFAULT '0',
  `fk_product_type` int(11) DEFAULT '0',
  `duration` varchar(6) DEFAULT NULL,
  `seuil_stock_alerte` int(11) DEFAULT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT NULL,
  `accountancy_code_sell` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_sell_intra` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_sell_export` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountancy_code_buy` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `partnumber` varchar(32) DEFAULT NULL,
  `weight` float DEFAULT NULL,
  `weight_units` tinyint(4) DEFAULT NULL,
  `length` float DEFAULT NULL,
  `length_units` tinyint(4) DEFAULT NULL,
  `surface` float DEFAULT NULL,
  `surface_units` tinyint(4) DEFAULT NULL,
  `volume` float DEFAULT NULL,
  `volume_units` tinyint(4) DEFAULT NULL,
  `stock` double DEFAULT NULL,
  `pmp` double(24,8) NOT NULL DEFAULT '0.00000000',
  `fifo` double(24,8) DEFAULT NULL,
  `lifo` double(24,8) DEFAULT NULL,
  `canvas` varchar(32) DEFAULT NULL,
  `finished` tinyint(4) DEFAULT NULL,
  `hidden` tinyint(4) DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  `desiredstock` int(11) DEFAULT '0',
  `url` varchar(255) DEFAULT NULL,
  `tobatch` tinyint(4) NOT NULL DEFAULT '0',
  `fk_price_expression` int(11) DEFAULT NULL,
  `fk_unit` int(11) DEFAULT NULL,
  `cost_price` double(24,8) DEFAULT NULL,
  `default_vat_code` varchar(10) DEFAULT NULL,
  `price_autogen` smallint(6) DEFAULT '0',
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT '',
  `width` float DEFAULT NULL,
  `width_units` tinyint(4) DEFAULT NULL,
  `height` float DEFAULT NULL,
  `height_units` tinyint(4) DEFAULT NULL,
  `fk_default_warehouse` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_ref` (`ref`,`entity`),
  UNIQUE KEY `uk_product_barcode` (`barcode`,`fk_barcode_type`,`entity`),
  KEY `idx_product_label` (`label`),
  KEY `idx_product_barcode` (`barcode`),
  KEY `idx_product_import_key` (`import_key`),
  KEY `idx_product_seuil_stock_alerte` (`seuil_stock_alerte`),
  KEY `idx_product_fk_country` (`fk_country`),
  KEY `idx_product_fk_user_author` (`fk_user_author`),
  KEY `idx_product_fk_barcode_type` (`fk_barcode_type`),
  KEY `fk_product_fk_unit` (`fk_unit`),
  KEY `fk_product_default_warehouse` (`fk_default_warehouse`),
  CONSTRAINT `fk_product_barcode_type` FOREIGN KEY (`fk_barcode_type`) REFERENCES `llx_c_barcode_type` (`rowid`),
  CONSTRAINT `fk_product_default_warehouse` FOREIGN KEY (`fk_default_warehouse`) REFERENCES `llx_entrepot` (`rowid`),
  CONSTRAINT `fk_product_fk_country` FOREIGN KEY (`fk_country`) REFERENCES `llx_c_country` (`rowid`),
  CONSTRAINT `fk_product_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `llx_c_units` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_product`
--

INSERT INTO `llx_product` (`rowid`, `ref`, `entity`, `ref_ext`, `datec`, `tms`, `virtual`, `fk_parent`, `label`, `description`, `note`, `customcode`, `fk_country`, `price`, `price_ttc`, `price_min`, `price_min_ttc`, `price_base_type`, `tva_tx`, `recuperableonly`, `localtax1_tx`, `localtax1_type`, `localtax2_tx`, `localtax2_type`, `fk_user_author`, `fk_user_modif`, `tosell`, `tobuy`, `onportal`, `fk_product_type`, `duration`, `seuil_stock_alerte`, `barcode`, `fk_barcode_type`, `accountancy_code_sell`, `accountancy_code_sell_intra`, `accountancy_code_sell_export`, `accountancy_code_buy`, `partnumber`, `weight`, `weight_units`, `length`, `length_units`, `surface`, `surface_units`, `volume`, `volume_units`, `stock`, `pmp`, `fifo`, `lifo`, `canvas`, `finished`, `hidden`, `import_key`, `desiredstock`, `url`, `tobatch`, `fk_price_expression`, `fk_unit`, `cost_price`, `default_vat_code`, `price_autogen`, `note_public`, `model_pdf`, `width`, `width_units`, `height`, `height_units`, `fk_default_warehouse`) VALUES (1,'sav-001-M',1,NULL,'2017-02-24 12:11:48','2019-05-02 12:43:09',0,0,'Savon Nature','Savon Nature 6% surgras','','',NULL,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',140,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-2149,0.00000000,NULL,NULL,'',1,0,NULL,210,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(2,'sav-002-M',1,NULL,'2017-02-24 12:16:02','2019-05-02 12:43:09',0,0,'Savon Argile Verte','','','',NULL,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',140,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-2103,0.00000000,NULL,NULL,'',1,0,NULL,210,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(3,'sav-003-M',1,NULL,'2017-03-20 15:27:02','2019-05-02 12:43:09',0,0,'Savon Argile Jaune (Lait de Brebis)','','','',1,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',210,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-1565,0.00000000,NULL,NULL,'',1,0,NULL,280,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(4,'deo-001-M',1,NULL,'2017-03-20 15:31:57','2019-05-02 12:43:09',0,0,'Déodorant Palmarosa','','','',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',50,NULL,NULL,'',NULL,NULL,'',NULL,NULL,-3,NULL,0,NULL,0,NULL,0,-4957,0.00000000,NULL,NULL,'',1,0,NULL,100,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(5,'deo-002-M',1,NULL,'2017-03-20 15:41:08','2019-05-02 12:43:09',0,0,'Déodorant Menthe','','','',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',50,NULL,NULL,'',NULL,NULL,'',NULL,NULL,-3,NULL,0,NULL,0,NULL,0,-2042,0.00000000,NULL,NULL,'',1,0,NULL,100,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(6,'deo-003-M',1,NULL,'2017-03-20 15:42:40','2019-05-02 12:43:09',0,0,'Déodorant Litsée','','','',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',50,NULL,NULL,'',NULL,NULL,'',NULL,NULL,-3,NULL,0,NULL,0,NULL,0,-1887,0.00000000,NULL,NULL,'',1,0,NULL,100,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(7,'sav-004-M',1,NULL,'2017-03-20 15:43:21','2019-05-02 12:43:09',0,0,'Savon Avoine','','','',1,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',210,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-1893,0.00000000,NULL,NULL,'',1,0,NULL,350,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(8,'sav-005-M',1,NULL,'2017-03-20 15:45:27','2019-05-02 12:43:09',0,0,'Savon Lavande','','','',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',140,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-1144,0.00000000,NULL,NULL,'',1,0,NULL,210,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(9,'sav-006-M',1,NULL,'2017-03-20 15:50:59','2019-05-02 12:43:09',0,0,'Savon Calendula et Agrumes','','','',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',280,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-1572,0.00000000,NULL,NULL,'',0,0,NULL,420,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(10,'sav-008-M',1,NULL,'2017-03-20 15:52:07','2019-05-02 12:43:09',0,0,'Savon Pachouli Benjoin (Lait de Brebis)','','','',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',210,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-1775,0.00000000,NULL,NULL,'',1,0,NULL,280,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(11,'sav-009-M',1,NULL,'2017-03-20 15:53:00','2019-05-02 12:43:09',0,0,'Savon Lavandin Patchouli (Lait de Brebis)','','','',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',210,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-1361,0.00000000,NULL,NULL,'',1,0,NULL,280,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(12,'sav-007-M',1,NULL,'2017-03-20 15:56:26','2019-05-02 12:43:09',0,0,'Savon Orange et Graines','','','',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',140,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-795,0.00000000,NULL,NULL,'',1,0,NULL,210,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(13,'sav-010-M',1,NULL,'2017-03-20 15:58:43','2019-05-02 12:43:09',0,0,'Savon Mandarine Basilic (Lait de Brebis)','','','',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',140,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-910,0.00000000,NULL,NULL,'',1,0,NULL,210,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(14,'sav-multi-M',1,NULL,'2017-03-20 16:01:43','2019-05-02 12:43:09',0,0,'Multitâches','','','',1,1.40000000,1.40000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',200,NULL,NULL,'',NULL,NULL,'',NULL,60,-3,NULL,0,NULL,0,NULL,0,-586,0.00000000,NULL,NULL,'',1,0,NULL,300,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(15,'sav-rasage-M',1,NULL,'2017-03-20 16:02:33','2019-05-02 12:43:09',0,0,'Savon de Rasage','','','',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',50,NULL,NULL,'',NULL,NULL,'',NULL,120,-3,NULL,0,NULL,0,NULL,0,-399,0.00000000,NULL,NULL,'',1,0,NULL,100,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(16,'shamp-001-M',1,NULL,'2017-03-20 16:06:48','2019-05-02 12:43:09',0,0,'Shampoing Thym','','','',1,3.20000000,3.20000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',200,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-2005,0.00000000,NULL,NULL,'',1,0,NULL,300,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(17,'shamp-002-M',1,NULL,'2017-03-20 16:09:13','2019-05-02 12:43:09',0,0,'Shampoing Romarin','','','',1,3.20000000,3.20000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',200,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-2358,0.00000000,NULL,NULL,'',1,0,NULL,300,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(18,'gal-001-M',1,NULL,'2017-03-20 16:10:44','2019-05-02 12:43:09',0,0,'Galet Nature','','','',NULL,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',20,NULL,NULL,'',NULL,NULL,'',NULL,NULL,0,NULL,0,NULL,0,NULL,0,-74,0.00000000,NULL,NULL,'',NULL,0,NULL,30,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(19,'gal-002-M',1,NULL,'2017-03-20 16:11:34','2019-05-02 12:43:09',0,0,'Galet Boisé','','','',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',20,NULL,NULL,'',NULL,NULL,'',NULL,35,-3,NULL,0,NULL,0,NULL,0,-17,0.00000000,NULL,NULL,'',1,0,NULL,30,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(20,'gal-003-M',1,NULL,'2017-03-20 16:12:19','2019-05-02 12:43:09',0,0,'Galet Causse','','','',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',20,NULL,NULL,'',NULL,NULL,'',NULL,35,-3,NULL,0,NULL,0,NULL,0,-29,0.00000000,NULL,NULL,'',1,0,NULL,30,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(21,'gal-004-M',1,NULL,'2017-03-20 16:15:35','2019-05-02 12:43:09',0,0,'Galet Acidulé','','','',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',20,NULL,NULL,'',NULL,NULL,'',NULL,35,-3,NULL,0,NULL,0,NULL,0,-27,0.00000000,NULL,NULL,'',1,0,NULL,30,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(22,'gal-005-M',1,NULL,'2017-03-20 16:17:52','2019-05-02 12:43:09',0,0,'Galet Détente','','','',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',20,NULL,NULL,'',NULL,NULL,'',NULL,35,-3,NULL,0,NULL,0,NULL,0,-44,0.00000000,NULL,NULL,'',1,0,NULL,30,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(23,'PAT-ChN-pt-M',1,NULL,'2017-03-21 15:53:54','2019-05-02 12:43:09',0,0,'Pâte à Tartiner Chocolat-Noisette-230g','','','',1,2.66000000,2.66000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,230,-3,NULL,0,NULL,0,NULL,0,-2004,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(24,'PAT-ChN-gd-M',1,NULL,'2017-03-21 15:55:25','2019-05-02 12:43:09',0,0,'Pâte à tartiner Chocolat Noisette-420g','','','',1,4.55000000,4.55000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,420,-3,NULL,0,NULL,0,NULL,0,-1287,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(25,'PAT-ChB-pt-M',1,NULL,'2017-03-21 18:36:00','2019-05-02 12:43:09',0,0,'Pâte à Tartiner Chocolat Banane-230g','','','',1,2.66000000,2.66000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,230,-3,NULL,0,NULL,0,NULL,0,-451,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(26,'PAT-ChB-gd-M',1,NULL,'2017-03-21 18:37:09','2019-05-02 12:43:09',0,0,'Pâte à Tartiner Chocolat-Banane-420g','','','',1,4.55000000,4.55000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,420,-3,NULL,0,NULL,0,NULL,0,-161,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(27,'PKL-Cgt-pt-M',1,NULL,'2017-03-21 18:38:45','2019-05-02 12:43:09',0,0,'Pickles de courgette-220g','','','',1,2.45000000,2.45000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,220,-3,NULL,0,NULL,0,NULL,0,-146,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(28,'PKL-Cgt-gd-M',1,NULL,'2017-03-21 18:39:57','2019-05-02 12:43:09',0,0,'Pickles Courgettes-420g','','','',1,3.85000000,3.85000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,420,-3,NULL,0,NULL,0,NULL,0,-128,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(29,'CFT-Cht-pt-M',1,NULL,'2017-03-21 18:44:49','2019-05-02 12:43:09',0,0,'Confiture de châtaigne-220g','','','',1,2.45000000,2.45000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,230,-3,NULL,0,NULL,0,NULL,0,-385,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(30,'CFT-Cht-gd-M',1,NULL,'2017-03-21 18:47:43','2019-05-02 12:43:09',0,0,'Confiture de Châtaigne- 430g','','','',1,3.85000000,3.85000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,420,-3,NULL,0,NULL,0,NULL,0,-308,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(31,'PAT-ChN-gd-D',1,NULL,'2017-03-21 21:10:54','2019-05-02 12:43:09',0,0,'Pâte à Tartiner Chocolat-Noisette-420g','','','',1,6.50000000,6.50000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,420,-3,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(32,'CFT-Cht-gd-D',1,NULL,'2017-03-21 21:12:41','2019-05-02 12:43:09',0,0,'Confiture de Châtaigne','','','',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,420,-3,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(34,'M-pastel02',1,NULL,'2017-03-22 13:49:00','2019-05-02 12:43:09',0,0,'savon pastel cade','','','',1,1.90000000,1.90000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-144,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(35,'M-pastel03',1,NULL,'2017-03-22 13:50:24','2019-05-02 12:43:09',0,0,'savon pastel \"exfoliant\"','savon exfoliant','','',1,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-144,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(36,'M-pastel01',1,NULL,'2017-03-22 14:01:28','2019-05-02 12:43:09',0,0,'savon pastel\"gros cube\"','savon au pastel 200g','','',1,3.50000000,3.50000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,200,-3,NULL,0,NULL,0,NULL,0,-210,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(37,'pots_220g',1,NULL,'2017-05-19 16:04:32','2019-05-02 12:43:09',0,0,'pates a tartiner, pickles','mélange de pots 220g','','',1,3.10000000,3.10000000,0.00000000,0.00000000,'TTC',0.000,0,0.000,'0',0.000,'0',1,NULL,1,1,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,0.22,0,NULL,0,NULL,0,NULL,0,-50,0.00000000,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(38,'sav-lain-M',1,NULL,'2017-06-14 22:35:41','2019-05-02 12:43:09',0,0,'tout doux laineux','argile jaune dans laine','','',1,3.20000000,3.20000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,100,-3,NULL,0,NULL,0,NULL,0,-25,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(39,'deo-004-M',1,NULL,'2018-03-14 14:52:19','2019-05-02 12:43:09',0,0,'Déodorant Lavande','','','',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,95,-3,NULL,0,NULL,0,60,-6,-916,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(41,'BAL01',1,NULL,'2019-01-25 16:52:26','2019-05-02 12:43:09',0,0,'baume à lèvres- orange gingembre','','','',NULL,1.85000000,1.85000000,0.00000000,0.00000000,'TTC',0.000,0,0.000,'0',0.000,'0',1,NULL,1,1,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,5,-3,NULL,0,NULL,0,9,-6,-35,0.00000000,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(42,'LES01',1,NULL,'2019-02-04 23:06:01','2019-05-02 12:43:09',0,0,'LESSIVE en copeaux à dissoudre','copeaux de savons à dissoudre pour obtenir 3 litres de lessive','','',1,5.00000000,5.00000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,NULL,1,0,0,0,'',NULL,NULL,NULL,'',NULL,NULL,'',NULL,250,-3,NULL,0,NULL,0,NULL,0,-20,0.00000000,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(43,'SAV-50-01',1,NULL,'2019-05-29 08:16:53','2019-05-29 06:18:24',0,0,'Savon bois de cade -50g','savon alambic du larzac','','',NULL,1.40000000,1.40000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,'',NULL,NULL,NULL,'','','','',NULL,50,-3,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,'',1,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(44,'SAV-012',1,NULL,'2019-05-29 08:21:10','2019-05-29 06:21:10',0,0,'savon bois de cade','','','',NULL,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,'',NULL,NULL,NULL,'','','','',NULL,100,-3,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(45,'sav-013-M',1,NULL,'2019-06-03 13:42:51','2019-06-03 11:42:51',0,0,'savon Karité','','','',NULL,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,'',NULL,NULL,NULL,'','','','',NULL,100,-3,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL),(46,'shamp-03-M',1,NULL,'2019-06-03 13:44:33','2019-06-03 11:45:10',0,0,'sampoing doux prune','à l\'huile d\'amandon de prune','','',NULL,3.20000000,3.20000000,0.00000000,0.00000000,'HT',0.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,'',NULL,NULL,NULL,'','','','',NULL,100,-3,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,NULL,'',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `llx_product_association`
--

CREATE TABLE `llx_product_association` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product_pere` int(11) NOT NULL DEFAULT '0',
  `fk_product_fils` int(11) NOT NULL DEFAULT '0',
  `qty` double DEFAULT NULL,
  `incdec` int(11) DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_association` (`fk_product_pere`,`fk_product_fils`),
  KEY `idx_product_association_fils` (`fk_product_fils`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_product_association`
--


--
-- Table structure for table `llx_product_attribute`
--

CREATE TABLE `llx_product_attribute` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `rang` int(11) NOT NULL DEFAULT '0',
  `entity` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `unique_ref` (`ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_product_attribute`
--


--
-- Table structure for table `llx_product_attribute_combination`
--

CREATE TABLE `llx_product_attribute_combination` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product_parent` int(11) NOT NULL,
  `fk_product_child` int(11) NOT NULL,
  `variation_price` float NOT NULL,
  `variation_price_percentage` int(11) DEFAULT NULL,
  `variation_weight` float NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_product_attribute_combination`
--


--
-- Table structure for table `llx_product_attribute_combination2val`
--

CREATE TABLE `llx_product_attribute_combination2val` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_prod_combination` int(11) NOT NULL,
  `fk_prod_attr` int(11) NOT NULL,
  `fk_prod_attr_val` int(11) NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_product_attribute_combination2val`
--


--
-- Table structure for table `llx_product_attribute_value`
--

CREATE TABLE `llx_product_attribute_value` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product_attribute` int(11) NOT NULL,
  `ref` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_attribute_value` (`fk_product_attribute`,`ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_product_attribute_value`
--


--
-- Table structure for table `llx_product_batch`
--

CREATE TABLE `llx_product_batch` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product_stock` int(11) NOT NULL,
  `eatby` datetime DEFAULT NULL,
  `sellby` datetime DEFAULT NULL,
  `batch` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `qty` double NOT NULL DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_batch` (`fk_product_stock`,`batch`),
  KEY `idx_fk_product_stock` (`fk_product_stock`),
  KEY `ix_fk_product_stock` (`fk_product_stock`),
  CONSTRAINT `fk_product_batch_fk_product_stock` FOREIGN KEY (`fk_product_stock`) REFERENCES `llx_product_stock` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_product_batch`
--


--
-- Table structure for table `llx_product_customer_price`
--

CREATE TABLE `llx_product_customer_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) NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `price_ttc` double(24,8) DEFAULT '0.00000000',
  `price_min` double(24,8) DEFAULT '0.00000000',
  `price_min_ttc` double(24,8) DEFAULT '0.00000000',
  `price_base_type` varchar(3) DEFAULT 'HT',
  `tva_tx` double(6,3) DEFAULT NULL,
  `default_vat_code` varchar(10) DEFAULT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) NOT NULL DEFAULT '0',
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_customer_price_fk_product_fk_soc` (`fk_product`,`fk_soc`),
  KEY `idx_product_customer_price_fk_user` (`fk_user`),
  KEY `idx_product_customer_price_fk_soc` (`fk_soc`),
  CONSTRAINT `fk_customer_price_fk_product` FOREIGN KEY (`fk_product`) REFERENCES `llx_product` (`rowid`),
  CONSTRAINT `fk_customer_price_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_product_customer_price_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_product_customer_price`
--


--
-- Table structure for table `llx_product_customer_price_log`
--

CREATE TABLE `llx_product_customer_price_log` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `fk_product` int(11) NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `price_ttc` double(24,8) DEFAULT '0.00000000',
  `price_min` double(24,8) DEFAULT '0.00000000',
  `price_min_ttc` double(24,8) DEFAULT '0.00000000',
  `price_base_type` varchar(3) DEFAULT 'HT',
  `tva_tx` double(6,3) DEFAULT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) NOT NULL DEFAULT '0',
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `default_vat_code` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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) DEFAULT NULL,
  `desc_fourn` text,
  `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',
  `tva_tx` double(6,3) NOT NULL,
  `default_vat_code` varchar(10) DEFAULT NULL,
  `info_bits` int(11) NOT NULL DEFAULT '0',
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `fk_supplier_price_expression` int(11) DEFAULT NULL,
  `delivery_time_days` int(11) DEFAULT NULL,
  `supplier_reputation` varchar(10) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_unitprice` double(24,8) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_price` double(24,8) DEFAULT NULL,
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_fournisseur_price_ref` (`ref_fourn`,`fk_soc`,`quantity`,`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`),
  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;

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


--
-- 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) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_price` double(24,8) DEFAULT NULL,
  `multicurrency_unitprice` double(24,8) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 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) NOT NULL DEFAULT '0',
  `label` varchar(255) NOT NULL,
  `description` text,
  `note` text,
  `import_key` varchar(14) 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;

--
-- 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(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `eatby` date DEFAULT NULL,
  `sellby` date 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;

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

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


--
-- 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 DEFAULT 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) DEFAULT 'HT',
  `tva_tx` double(6,3) NOT NULL,
  `default_vat_code` varchar(10) DEFAULT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) 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',
  `import_key` varchar(14) DEFAULT NULL,
  `fk_price_expression` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_price` double(24,8) DEFAULT '0.00000000',
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `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_product`) REFERENCES `llx_product` (`rowid`),
  CONSTRAINT `fk_product_price_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

--
-- 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`, `tva_tx`, `default_vat_code`, `recuperableonly`, `localtax1_tx`, `localtax1_type`, `localtax2_tx`, `localtax2_type`, `fk_user_author`, `tosell`, `price_by_qty`, `import_key`, `fk_price_expression`, `fk_multicurrency`, `multicurrency_code`, `multicurrency_price`, `multicurrency_tx`, `multicurrency_price_ttc`) VALUES (1,1,'2017-02-24 11:11:48',1,'2017-02-24 12:11:48',1,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(2,1,'2017-02-24 11:16:02',2,'2017-02-24 12:16:02',1,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(3,1,'2017-03-20 14:27:02',3,'2017-03-20 15:27:02',1,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(4,1,'2017-03-20 14:31:57',4,'2017-03-20 15:31:57',1,5.00000000,5.00000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(5,1,'2017-03-20 14:41:08',5,'2017-03-20 15:41:08',1,5.00000000,5.00000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(6,1,'2017-03-20 14:42:40',6,'2017-03-20 15:42:40',1,5.00000000,5.00000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(7,1,'2017-03-20 14:43:21',7,'2017-03-20 15:43:21',1,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(8,1,'2017-03-20 14:45:27',8,'2017-03-20 15:45:27',1,2.80000000,2.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(9,1,'2017-03-20 14:50:59',9,'2017-03-20 15:50:59',1,2.80000000,2.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(10,1,'2017-03-20 14:52:07',10,'2017-03-20 15:52:07',1,2.80000000,2.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(11,1,'2017-03-20 14:53:00',11,'2017-03-20 15:53:00',1,2.80000000,2.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(12,1,'2017-03-20 14:56:26',12,'2017-03-20 15:56:26',1,2.80000000,2.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(13,1,'2017-03-20 14:58:43',13,'2017-03-20 15:58:43',1,2.80000000,2.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(14,1,'2017-03-20 15:01:43',14,'2017-03-20 16:01:43',1,0.00000000,0.00000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(15,1,'2017-03-20 15:02:33',15,'2017-03-20 16:02:33',1,5.00000000,5.00000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(16,1,'2017-03-20 15:06:48',16,'2017-03-20 16:06:48',1,3.20000000,3.20000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(17,1,'2017-03-20 15:07:35',14,'2017-03-20 16:07:35',1,1.40000000,1.40000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(18,1,'2017-03-20 15:08:04',15,'2017-03-20 16:08:04',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(19,1,'2017-03-20 15:09:13',17,'2017-03-20 16:09:13',1,3.20000000,3.20000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(20,1,'2017-03-20 15:10:44',18,'2017-03-20 16:10:44',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(21,1,'2017-03-20 15:11:34',19,'2017-03-20 16:11:34',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(22,1,'2017-03-20 15:12:19',20,'2017-03-20 16:12:19',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(23,1,'2017-03-20 15:15:35',21,'2017-03-20 16:15:35',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(24,1,'2017-03-20 15:17:52',22,'2017-03-20 16:17:52',1,3.75000000,3.75000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(25,1,'2017-03-21 14:53:54',23,'2017-03-21 15:53:54',1,2.66000000,2.66000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(26,1,'2017-03-21 14:55:25',24,'2017-03-21 15:55:25',1,4.55000000,4.55000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(27,1,'2017-03-21 17:36:00',25,'2017-03-21 18:36:00',1,2.66000000,2.66000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(28,1,'2017-03-21 17:37:09',26,'2017-03-21 18:37:09',1,4.55000000,4.55000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(29,1,'2017-03-21 17:38:45',27,'2017-03-21 18:38:45',1,2.45000000,2.45000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(30,1,'2017-03-21 17:39:57',28,'2017-03-21 18:39:57',1,3.85000000,3.85000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(31,1,'2017-03-21 17:44:49',29,'2017-03-21 18:44:49',1,2.45000000,2.45000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(32,1,'2017-03-21 17:47:43',30,'2017-03-21 18:47:43',1,3.85000000,3.85000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(33,1,'2017-03-21 20:10:54',31,'2017-03-21 21:10:54',1,6.50000000,6.50000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(34,1,'2017-03-21 20:12:41',32,'2017-03-21 21:12:41',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(36,1,'2017-03-22 12:49:00',34,'2017-03-22 13:49:00',1,1.90000000,1.90000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(37,1,'2017-03-22 12:50:24',35,'2017-03-22 13:50:24',1,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(38,1,'2017-03-22 13:01:28',36,'2017-03-22 14:01:28',1,3.50000000,3.50000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(39,1,'2017-05-19 14:04:32',37,'2017-05-19 16:04:32',1,3.10000000,3.10000000,0.00000000,0.00000000,'TTC',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(40,1,'2017-06-14 20:35:41',38,'2017-06-14 22:35:41',1,3.20000000,3.20000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(41,1,'2017-09-05 19:33:24',4,'2017-09-05 21:33:24',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(42,1,'2017-09-05 19:33:59',4,'2017-09-05 21:33:59',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(43,1,'2017-09-05 19:35:23',5,'2017-09-05 21:35:23',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(44,1,'2017-09-05 19:36:35',6,'2017-09-05 21:36:35',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(45,1,'2018-01-22 16:49:35',8,'2018-01-22 17:49:35',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(46,1,'2018-01-22 16:50:38',9,'2018-01-22 17:50:38',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(47,1,'2018-01-22 16:51:30',12,'2018-01-22 17:51:30',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(48,1,'2018-01-22 16:52:52',10,'2018-01-22 17:52:52',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(49,1,'2018-01-22 16:53:37',11,'2018-01-22 17:53:37',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(50,1,'2018-01-22 16:54:19',13,'2018-01-22 17:54:19',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(51,1,'2018-03-14 13:52:19',39,'2018-03-14 14:52:19',1,5.50000000,5.50000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(53,1,'2019-01-25 15:52:26',41,'2019-01-25 16:52:26',1,1.85000000,1.85000000,0.00000000,0.00000000,'TTC',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(54,1,'2019-02-04 22:06:01',42,'2019-02-04 23:06:01',1,5.00000000,5.00000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(56,1,'2019-05-29 06:18:24',43,'2019-05-29 08:18:24',1,1.40000000,1.40000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(57,1,'2019-05-29 06:21:10',44,'2019-05-29 08:21:10',1,2.40000000,2.40000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(58,1,'2019-06-03 11:42:51',45,'2019-06-03 13:42:51',1,1.80000000,1.80000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,NULL),(59,1,'2019-06-03 11:44:33',46,'2019-06-03 13:44:33',1,3.20000000,3.20000000,0.00000000,0.00000000,'HT',0.000,NULL,0,0.000,'0',0.000,'0',1,1,0,NULL,NULL,NULL,NULL,0.00000000,1.00000000,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',
  `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,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) DEFAULT NULL,
  `price_base_type` varchar(3) DEFAULT 'HT',
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) 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`),
  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;

--
-- 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` float NOT NULL,
  `var_min_percent` float NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `unique_level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 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) 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 AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_product_stock` (`rowid`, `tms`, `fk_product`, `fk_entrepot`, `reel`, `import_key`) VALUES (1,'2019-04-26 10:50:52',1,1,-2149,NULL),(2,'2019-04-29 12:40:10',17,1,-2358,NULL),(3,'2019-04-29 12:40:10',4,1,-4957,NULL),(4,'2019-04-29 12:40:10',5,1,-2042,NULL),(5,'2019-04-27 15:10:00',6,1,-1887,NULL),(6,'2019-04-29 12:40:10',16,1,-2005,NULL),(7,'2019-04-25 15:32:42',15,1,-399,NULL),(8,'2019-04-25 15:37:42',14,1,-586,NULL),(9,'2019-04-23 16:06:09',18,1,-74,NULL),(10,'2019-04-23 16:06:09',19,1,-17,NULL),(11,'2019-04-23 16:06:09',20,1,-29,NULL),(12,'2019-04-23 16:06:09',21,1,-27,NULL),(13,'2019-04-23 16:06:09',22,1,-44,NULL),(14,'2019-04-26 10:50:52',2,1,-2103,NULL),(15,'2019-04-26 10:50:52',3,1,-1565,NULL),(16,'2019-04-26 10:50:52',7,1,-1893,NULL),(17,'2019-04-26 10:50:52',8,1,-1144,NULL),(18,'2019-04-26 10:50:52',9,1,-1572,NULL),(19,'2019-04-26 10:50:52',12,1,-795,NULL),(20,'2019-04-26 10:50:52',10,1,-1775,NULL),(21,'2019-04-25 15:37:42',11,1,-1361,NULL),(22,'2019-04-04 11:28:48',13,1,-910,NULL),(23,'2018-04-08 14:03:35',36,1,-210,NULL),(24,'2018-04-08 14:03:35',35,1,-144,NULL),(25,'2018-09-01 08:26:53',26,1,-161,NULL),(26,'2019-04-25 15:34:04',24,1,-1287,NULL),(27,'2018-09-26 09:10:06',25,1,-451,NULL),(28,'2019-04-25 15:34:04',23,1,-2004,NULL),(29,'2019-04-22 12:54:27',29,1,-385,NULL),(30,'2019-04-22 12:54:27',30,1,-308,NULL),(31,'2017-05-19 14:08:54',37,1,-50,NULL),(32,'2019-01-17 16:53:02',27,1,-146,NULL),(33,'2018-07-29 16:28:30',38,1,-25,NULL),(34,'2019-04-16 19:21:59',28,1,-128,NULL),(35,'2018-04-08 14:03:35',34,1,-144,NULL),(36,'2019-04-29 12:40:10',39,1,-916,NULL),(37,'2019-04-23 16:06:09',41,1,-35,NULL),(38,'2019-02-04 22:13:04',42,1,-20,NULL);

--
-- 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` int(11) DEFAULT '0',
  `desiredstock` int(11) DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 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) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `title` varchar(255) NOT NULL,
  `description` text,
  `fk_user_creat` int(11) NOT NULL,
  `public` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `fk_opp_status` int(11) DEFAULT NULL,
  `opp_percent` double(5,2) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `budget_amount` double(24,8) DEFAULT NULL,
  `date_close` datetime DEFAULT NULL,
  `fk_user_close` int(11) DEFAULT NULL,
  `opp_amount` double(24,8) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `bill_time` int(11) DEFAULT '0',
  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;

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

--
-- 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) 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) NOT NULL,
  `description` text,
  `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_valid` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `note_private` text,
  `note_public` text,
  `rang` int(11) DEFAULT '0',
  `model_pdf` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `fk_user_modif` int(11) 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;

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

--
-- 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,
  `note` text,
  `invoice_id` int(11) DEFAULT NULL,
  `invoice_line_id` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `datec` date DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  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;

--
-- 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) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_int` varchar(255) DEFAULT NULL,
  `ref_client` varchar(255) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` date DEFAULT NULL,
  `fin_validite` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_user_cloture` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `price` double DEFAULT '0',
  `remise_percent` double DEFAULT '0',
  `remise_absolue` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `tva` double(24,8) DEFAULT '0.00000000',
  `localtax1` double(24,8) DEFAULT '0.00000000',
  `localtax2` double(24,8) DEFAULT '0.00000000',
  `total` double(24,8) DEFAULT '0.00000000',
  `fk_account` int(11) DEFAULT NULL,
  `fk_currency` varchar(3) DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `date_livraison` date DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `fk_availability` int(11) DEFAULT NULL,
  `fk_input_reason` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_delivery_address` int(11) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) 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',
  `last_main_doc` varchar(255) DEFAULT NULL,
  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_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`),
  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_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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) NOT NULL,
  `lang` varchar(5) 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) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 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) DEFAULT NULL,
  `description` text,
  `fk_remise_except` int(11) DEFAULT NULL,
  `tva_tx` double(6,3) DEFAULT '0.000',
  `vat_src_code` varchar(10) DEFAULT '',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `price` double DEFAULT NULL,
  `subprice` double(24,8) DEFAULT '0.00000000',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `total_tva` double(24,8) DEFAULT '0.00000000',
  `total_localtax1` double(24,8) DEFAULT '0.00000000',
  `total_localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT '0.00000000',
  `product_type` int(11) DEFAULT '0',
  `date_start` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `info_bits` int(11) DEFAULT '0',
  `buy_price_ht` double(24,8) DEFAULT '0.00000000',
  `fk_product_fournisseur_price` int(11) DEFAULT NULL,
  `special_code` int(11) DEFAULT '0',
  `rang` int(11) DEFAULT '0',
  `fk_unit` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) 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;

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

--
-- Dumping data for table `llx_propaldet_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) DEFAULT NULL,
  `asset_number` varchar(255) DEFAULT NULL,
  `description` text,
  `fk_code_type_resource` varchar(32) DEFAULT NULL,
  `note_public` text,
  `note_private` text,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `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',
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_country` int(11) DEFAULT NULL,
  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;

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

--
-- 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) DEFAULT NULL,
  `module` varchar(64) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `perms` varchar(50) DEFAULT NULL,
  `subperms` varchar(50) DEFAULT NULL,
  `type` varchar(1) DEFAULT NULL,
  `bydefault` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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



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

CREATE TABLE `llx_societe` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(128) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_int` varchar(60) DEFAULT NULL,
  `statut` tinyint(4) DEFAULT '0',
  `parent` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1',
  `code_client` varchar(24) DEFAULT NULL,
  `code_fournisseur` varchar(24) DEFAULT NULL,
  `code_compta` varchar(24) DEFAULT NULL,
  `code_compta_fournisseur` varchar(24) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(25) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `fk_departement` int(11) DEFAULT '0',
  `fk_pays` int(11) DEFAULT '0',
  `phone` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `skype` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `googleplus` varchar(255) DEFAULT NULL,
  `snapchat` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `fk_effectif` int(11) DEFAULT '0',
  `fk_typent` int(11) DEFAULT '0',
  `fk_forme_juridique` int(11) DEFAULT '0',
  `fk_currency` varchar(3) DEFAULT NULL,
  `siren` varchar(128) DEFAULT NULL,
  `siret` varchar(128) DEFAULT NULL,
  `ape` varchar(128) DEFAULT NULL,
  `idprof4` varchar(128) DEFAULT NULL,
  `idprof5` varchar(128) DEFAULT NULL,
  `idprof6` varchar(128) DEFAULT NULL,
  `tva_intra` varchar(20) DEFAULT NULL,
  `capital` double(24,8) DEFAULT NULL,
  `fk_stcomm` int(11) NOT NULL DEFAULT '0',
  `note_private` text,
  `note_public` text,
  `prefix_comm` varchar(5) DEFAULT NULL,
  `client` tinyint(4) DEFAULT '0',
  `fournisseur` tinyint(4) DEFAULT '0',
  `supplier_account` varchar(32) DEFAULT NULL,
  `fk_prospectlevel` varchar(12) DEFAULT NULL,
  `customer_bad` tinyint(4) DEFAULT '0',
  `customer_rate` double DEFAULT '0',
  `supplier_rate` double DEFAULT '0',
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `remise_client` double DEFAULT '0',
  `remise_supplier` double DEFAULT '0',
  `mode_reglement` tinyint(4) DEFAULT NULL,
  `cond_reglement` tinyint(4) DEFAULT NULL,
  `mode_reglement_supplier` tinyint(4) DEFAULT NULL,
  `cond_reglement_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(255) 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) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `canvas` varchar(32) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `webservices_url` varchar(255) DEFAULT NULL,
  `webservices_key` varchar(128) DEFAULT NULL,
  `name_alias` varchar(128) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `fk_account` int(11) DEFAULT NULL,
  `fk_entrepot` int(11) DEFAULT '0',
  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_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_barcode` (`barcode`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_societe` (`rowid`, `nom`, `entity`, `ref_ext`, `ref_int`, `statut`, `parent`, `tms`, `datec`, `status`, `code_client`, `code_fournisseur`, `code_compta`, `code_compta_fournisseur`, `address`, `zip`, `town`, `fk_departement`, `fk_pays`, `phone`, `fax`, `url`, `email`, `skype`, `whatsapp`, `youtube`, `googleplus`, `snapchat`, `instagram`, `facebook`, `twitter`, `fk_effectif`, `fk_typent`, `fk_forme_juridique`, `fk_currency`, `siren`, `siret`, `ape`, `idprof4`, `idprof5`, `idprof6`, `tva_intra`, `capital`, `fk_stcomm`, `note_private`, `note_public`, `prefix_comm`, `client`, `fournisseur`, `supplier_account`, `fk_prospectlevel`, `customer_bad`, `customer_rate`, `supplier_rate`, `fk_user_creat`, `fk_user_modif`, `remise_client`, `remise_supplier`, `mode_reglement`, `cond_reglement`, `mode_reglement_supplier`, `cond_reglement_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`, `canvas`, `import_key`, `webservices_url`, `webservices_key`, `name_alias`, `fk_incoterms`, `location_incoterms`, `model_pdf`, `fk_multicurrency`, `multicurrency_code`, `fk_account`, `fk_entrepot`) VALUES (1,'Biocoop Cahors Bellecroix',1,NULL,NULL,0,NULL,'2017-02-24 11:27:26','2017-02-24 12:27:26',1,NULL,NULL,NULL,NULL,'','46000','Cahors',48,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(2,'Au coeur des racines',1,NULL,NULL,0,NULL,'2017-03-20 16:15:04','2017-03-20 17:15:04',1,NULL,NULL,NULL,NULL,'Cabridelle','46150','BOISSIERES',48,1,'0565237317',NULL,NULL,'aucoeurdesracines@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(3,'Au sens Bio',1,NULL,NULL,0,NULL,'2017-03-20 16:35:15','2017-03-20 17:35:15',1,NULL,NULL,NULL,NULL,'1 avenue président Georges Pompidou','46100','FIGEAC',0,1,'0565343169',NULL,NULL,'asbcommande@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(4,'BIOCOOP Trinité',1,NULL,NULL,0,NULL,'2017-03-20 20:55:31','2017-03-20 17:37:13',1,NULL,NULL,NULL,NULL,'7 rue de la trinité','31000','TOULOUSE',33,1,'0534424919',NULL,NULL,'bio-trinite@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(5,'BIOCOOP Sarlat SARL le sarladais',1,NULL,NULL,0,NULL,'2017-03-20 16:40:08','2017-03-20 17:40:08',1,NULL,NULL,NULL,NULL,'La gendonie basse','24200','SARLAT',26,1,'0553590310',NULL,NULL,'biocoopsarlat@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(6,'BIOCOOP Villefranche',1,NULL,NULL,0,NULL,'2017-03-20 16:42:13','2017-03-20 17:42:13',1,NULL,NULL,NULL,NULL,'102 bis avenue du quercy','12200','VILLEFRANCHE DE ROUERGUE',13,1,'0565451492',NULL,NULL,'biocoop.villefranche@yahoo.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(7,'BIOCOOP Campana',1,NULL,NULL,0,NULL,'2017-03-20 16:44:24','2017-03-20 17:44:24',1,NULL,NULL,NULL,NULL,'Les moutiers \r\n8 avenue de l\'entreprise','12000','RODEZ',13,1,'0565784257',NULL,NULL,'campana12@wanadoo.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(8,'BIOCOOP Jaurès',1,NULL,NULL,0,NULL,'2017-03-20 20:54:55','2017-03-20 17:46:43',1,NULL,NULL,NULL,NULL,'32 allées Jean Jaurès','31000','Toulouse',33,1,'0562579025',NULL,NULL,'bio-jaures@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(9,'HAPPY BIO SHOP',1,NULL,NULL,0,NULL,'2017-03-20 20:55:45','2017-03-20 17:54:05',1,NULL,NULL,NULL,NULL,'152 rue Emile Combes','33000','Bordeaux',35,1,'0626804027',NULL,NULL,'happybioshop@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(10,'BIOCOOP Marmande',1,NULL,NULL,0,NULL,'2017-03-20 20:55:17','2017-03-20 17:57:41',1,NULL,NULL,NULL,NULL,'ZAC de la plaine\r\nroute de Bordeaux','47200','MARMANDE',49,1,'0553208443',NULL,NULL,'nal.marmande@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(11,'BIOCOOP Lou Cussou',1,NULL,NULL,0,NULL,'2018-09-02 16:36:33','2017-03-20 18:00:14',1,NULL,NULL,NULL,NULL,'61 bd Camille Marbo','12400','Saint Affrique',13,1,'0565495398',NULL,NULL,'loucussou@free.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(12,'BIOCOOP Champ libre BIAS',1,NULL,NULL,0,NULL,'2017-03-20 20:54:13','2017-03-20 18:17:28',1,NULL,NULL,NULL,NULL,'401 avenue de Bordeaux','47300','Villeneuve sur lot',49,1,'0553019576',NULL,NULL,'biocoopchamplibre@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(13,'Retour aux sources',1,NULL,NULL,0,NULL,'2017-03-20 17:20:02','2017-03-20 18:20:02',1,NULL,NULL,NULL,NULL,'11 rue Gauthier 1 er','77140','Nemours',79,1,'0177032994',NULL,NULL,'emmanuellefabre@yahoo.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(14,'Boutique l\'authentique',1,NULL,NULL,0,NULL,'2018-04-16 07:41:24','2017-03-20 18:22:48',1,NULL,NULL,NULL,NULL,'118 avenue des campings','34340','Marseillan plage',36,1,'0630391637',NULL,NULL,'fabiennevaresano@yahoo.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(15,'BIOCOOP Cahors Cathedrale',1,NULL,NULL,0,NULL,'2017-03-20 17:25:25','2017-03-20 18:25:25',1,NULL,NULL,NULL,NULL,'75 place clément Marot','46000','Cahors',48,1,'0565241400',NULL,NULL,'biocoopcathedrale@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(16,'BIOCOOP Le pré du verger',1,NULL,NULL,0,NULL,'2017-03-20 17:28:04','2017-03-20 18:28:04',1,NULL,NULL,NULL,NULL,'559 avenue Roger Salengro','92370','Chaville',94,1,'0141152260',NULL,NULL,'contact@lepreverger.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(17,'BIOCOOP Albi',1,NULL,NULL,0,NULL,'2017-03-20 17:29:31','2017-03-20 18:29:31',1,NULL,NULL,NULL,NULL,'9 rue du puech petit','81000','ALBI',0,1,'0581023398',NULL,NULL,'chane.christophe@laposte.net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(18,'BIOCOOP Fumel',1,NULL,NULL,0,NULL,'2017-03-20 17:58:41','2017-03-20 18:32:36',1,NULL,NULL,NULL,NULL,'ZA du haut agenais','47500','Montayral',49,1,'0553403342',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(19,'Badie créations',1,NULL,NULL,0,NULL,'2017-03-20 17:36:42','2017-03-20 18:36:42',1,NULL,NULL,NULL,NULL,'14 rue Alsace Lorraine','34000','SETE',36,1,'0628183077',NULL,NULL,'reginemaire@sfr.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(20,'BIOCOOP vivre bio en bouriane',1,NULL,NULL,0,NULL,'2017-03-20 17:58:22','2017-03-20 18:38:37',1,NULL,NULL,NULL,NULL,'route de cahors','46300','Gourdon',48,1,'0565320747',NULL,NULL,'biocoopgourdon@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(21,'BIOCOOP Pais d\'Oc',1,NULL,NULL,0,NULL,'2017-03-20 17:57:35','2017-03-20 18:44:17',1,NULL,NULL,NULL,NULL,'150 route de pézenas','34500','Béziers',36,1,'0467115737',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(22,'BIOCOOP Montauban',1,NULL,NULL,0,NULL,'2017-03-20 17:46:40','2017-03-20 18:46:40',1,NULL,NULL,NULL,NULL,'1630 avenue de Fonneuve','82000','Montauban',84,1,'0563030742',NULL,NULL,'montmosecnal@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(23,'La petite -SCOP OZON',1,NULL,NULL,0,NULL,'2017-03-20 17:48:51','2017-03-20 18:48:51',1,NULL,NULL,NULL,NULL,'épicerie itinérante','46250','Marminiac',26,1,'0607039425',NULL,NULL,'myriam.scattolin@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(24,'BIOCOOP Lunel',1,NULL,NULL,0,NULL,'2017-03-20 17:51:03','2017-03-20 18:51:03',1,NULL,NULL,NULL,NULL,'268 chemin de la vidourlenque','34400','Lunel',36,1,'0954635319',NULL,NULL,'biocoop.lunel@free.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(25,'Epicerie Del Pais',1,NULL,NULL,0,NULL,'2017-03-20 17:52:44','2017-03-20 18:52:44',1,NULL,NULL,NULL,NULL,'11 bd victor Hugo','12400','Saint Affrique',13,1,'0565496828',NULL,NULL,'lepicerie.delpais@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(26,'BIOCOOP Belleville en Bio',1,NULL,NULL,0,NULL,'2017-03-20 17:54:58','2017-03-20 18:54:58',1,NULL,NULL,NULL,NULL,'620 rue de Belleville','75020','Paris',77,1,'0140333868',NULL,NULL,'belleville.en.bio@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(27,'Fred le Gregam',1,NULL,NULL,0,NULL,'2017-03-21 18:20:37','2017-03-21 19:20:36',1,NULL,NULL,NULL,NULL,'','31000','TOULOUSE',33,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(28,'le panier naturel',1,NULL,NULL,0,NULL,'2017-03-21 19:42:15','2017-03-21 20:42:15',1,NULL,NULL,NULL,NULL,'5 place Jeanne Ramels Cals','81170','Cordes sur ciel',83,1,'0563560692',NULL,NULL,'le-panier-naturel@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(29,'SAS DMTF-atelier du sculpteur',1,NULL,NULL,0,NULL,'2017-03-21 19:50:01','2017-03-21 20:45:48',1,NULL,NULL,NULL,NULL,'4 rue chapelle des pénitents','34150','saint guilhem le désert',36,1,'0467577279',NULL,NULL,'latelierdusculpteur@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(30,'MaThera',1,NULL,NULL,0,NULL,'2017-03-22 12:57:02','2017-03-22 13:57:02',1,NULL,NULL,NULL,NULL,'20 place Charles Portal','81170','Cordes sur ciel',83,1,'0563560155',NULL,NULL,'mathera@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(31,'l\'épicerie du coin',1,NULL,NULL,0,NULL,'2017-03-29 20:38:19','2017-03-29 22:38:19',1,NULL,NULL,NULL,NULL,'place du faubourg','12270','Najac',13,1,NULL,NULL,NULL,'contact@epicerieducoin.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(33,'Biocoop saint pardoux',1,NULL,NULL,0,NULL,'2017-03-30 11:34:12','2017-03-29 22:43:10',1,NULL,NULL,NULL,NULL,'Zone croix de Lugat','47','saint pardoux',49,1,'0777061549',NULL,NULL,'biocoop.stpardoux@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(34,'Biocoop Montredon',1,NULL,NULL,0,NULL,'2017-03-29 20:46:08','2017-03-29 22:46:08',1,NULL,NULL,NULL,NULL,'2 rue d\'Ariane','31240','l\'Union',33,1,'0562303360',NULL,NULL,'biocoop.montredon@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(35,'BioMinervois',1,NULL,NULL,0,NULL,'2017-03-29 20:50:27','2017-03-29 22:50:27',1,NULL,NULL,NULL,NULL,'18 avenue d\'homps','34210','Olonzac',36,1,'0468323197',NULL,NULL,'biominervois@laposte.net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(36,'Abbaye Sylvanès',1,NULL,NULL,0,NULL,'2017-04-03 10:08:22','2017-04-03 11:45:45',1,NULL,NULL,NULL,NULL,'le bourg','12360','Sylvanès',0,1,'0565982020',NULL,NULL,'librairie@sylvanes.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(37,'La Recharge',1,NULL,NULL,0,NULL,'2017-04-25 19:58:19','2017-04-03 12:12:03',1,NULL,NULL,NULL,NULL,'38 rue saint Colombe','33000','Bordeaux',35,1,'0612230294',NULL,NULL,'jules.rivet@la-recharge.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(38,'O Savon- SARL Alysav',1,NULL,NULL,0,NULL,'2017-04-04 12:19:44','2017-04-04 14:19:44',1,NULL,NULL,NULL,NULL,'10 rue Michelet','82000','Montauban',84,1,'0563915126',NULL,NULL,'osavon@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(39,'PASTORALIA',1,NULL,NULL,0,NULL,'2017-04-17 19:49:59','2017-04-17 21:49:59',1,NULL,NULL,NULL,NULL,'Route de Bournac','12400','Saint Affrique',13,1,'0565981033',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(40,'Gabriel Coulet',1,NULL,NULL,0,NULL,'2017-04-17 19:51:26','2017-04-17 21:51:26',1,NULL,NULL,NULL,NULL,'Magasin de vente Roquefort\r\n3 avenue de Lauras','12250','Roquefort',13,1,'0565599021',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(41,'Biocoop Purpan',1,NULL,NULL,0,NULL,'2017-04-25 11:22:26','2017-04-25 13:22:26',1,NULL,NULL,NULL,NULL,'5 rue Georges Vedel','31000','TOULOUSE',33,1,'0534366101',NULL,NULL,'biocoop.purpan@wanadoo.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(42,'Le grand panier Bio',1,NULL,NULL,0,NULL,'2017-05-05 11:29:12','2017-05-05 13:29:12',1,NULL,NULL,NULL,NULL,'702 RD 613\r\ntel 04 67 04 80 02','34740','Vendargues',36,1,'0467048002',NULL,NULL,'legrandpanierbio34@hotmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(43,'Biocoop Ephebio',1,NULL,NULL,0,NULL,'2017-08-10 14:27:28','2017-05-09 09:41:02',1,NULL,NULL,NULL,NULL,'zone commerciale « les portes du Littoral »\r\nroute de Sète   -  \r\n\r\n\r\nTél. : 04.67.00.49.71','34300','AGDE',0,1,'0467004971',NULL,NULL,'jeromebiocoopagde@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(44,'ALTIA',1,NULL,NULL,0,NULL,'2017-05-09 19:37:25','2017-05-09 21:37:25',1,NULL,NULL,NULL,NULL,'Hameau de Moulès','12540','Fondamente',13,1,'0663041524',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(45,'Beauté Bio',1,NULL,NULL,0,NULL,'2017-05-12 06:54:10','2017-05-12 08:54:10',1,NULL,NULL,NULL,NULL,'1 chemin Tambourré\r\n\r\n0672541218','64121','Montardon',0,1,'0672541218',NULL,NULL,'beautebio@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(46,'Comptoir Paysan',1,NULL,NULL,0,NULL,'2017-05-17 14:00:37','2017-05-17 16:00:36',1,NULL,NULL,NULL,NULL,'Le mas de compeyre\r\n\r\n\r\n05.65.59.84.11','12520','Compeyre',13,1,'0565598411',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(47,'la quercynoise-association',1,NULL,NULL,0,NULL,'2017-05-19 14:06:22','2017-05-19 16:05:48',1,NULL,NULL,NULL,NULL,'puy l\'eveque','46700','puy l\'eveque',48,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(48,'BIOSTAR',1,NULL,NULL,0,NULL,'2017-05-30 19:55:43','2017-05-30 21:55:43',1,NULL,NULL,NULL,NULL,'la fontaine de bontemps\r\nroute de souillac','24200','SARLAT',26,1,'0553595303',NULL,NULL,'biostar24@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(49,'Biocoop Marianne',1,NULL,NULL,0,NULL,'2017-05-31 12:42:25','2017-05-31 14:42:25',1,NULL,NULL,NULL,NULL,'181 place ernest Granier','34000','Montpellier',0,1,'0967329890',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(50,'la vie au naturel',1,NULL,NULL,0,NULL,'2017-08-10 14:26:13','2017-06-05 21:43:39',1,NULL,NULL,NULL,NULL,'21 avenue d\'alzon\r\n\r\n\r\n0467812467','30120','Le Vigan',13,1,'0467812467',NULL,NULL,'lavieaunaturel@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(51,'SAS comptoir du carreau',1,NULL,NULL,0,NULL,'2017-06-12 12:04:59','2017-06-12 14:03:45',1,NULL,NULL,NULL,NULL,'12 bd saint jacques','75014','PARIS',0,1,'0622823884',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(52,'le fournil a la ferme',1,NULL,NULL,0,NULL,'2017-07-03 06:51:35','2017-07-03 08:51:35',1,NULL,NULL,NULL,NULL,'chez marcel  et murielle fabreguette','12540','cornus',0,1,'0647653091',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(53,'l\'Epi bio',1,NULL,NULL,0,NULL,'2017-07-17 05:47:40','2017-07-17 07:47:40',1,NULL,NULL,NULL,NULL,'9 cours de l\'Yser\r\n\r\n0553881640','47400','TONNEINS',0,1,'0553881640',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(54,'SARL chambert',1,NULL,NULL,0,NULL,'2017-08-09 10:25:38','2017-07-20 11:59:44',1,NULL,NULL,NULL,NULL,'les haut coteaux','46700','Floressas',48,1,'0608098550',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(55,'SAS Vautier',1,NULL,NULL,0,NULL,'2017-07-29 11:00:46','2017-07-29 13:00:46',1,NULL,NULL,NULL,NULL,'8à8\r\nRoute du lac\r\n\r\n\r\n0645966489','46210','Latronquière',0,1,'0645966489',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(56,'Biocoop La primaube',1,NULL,NULL,0,NULL,'2017-08-10 14:30:28','2017-08-10 16:30:28',1,NULL,NULL,NULL,NULL,'32 place de l\'étoile','12450','La primaube',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(57,'Biocoop Blagnac',1,NULL,NULL,0,NULL,'2017-09-04 08:08:49','2017-09-04 10:08:49',1,NULL,NULL,NULL,NULL,'2 rue Henri Matisse','31700','Blagnac',0,1,'0676656593',NULL,NULL,'bio-blagnac@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(58,'BOEMBIO',1,NULL,NULL,0,NULL,'2017-09-25 20:47:28','2017-09-25 22:47:28',1,NULL,NULL,NULL,NULL,'9 rue Arnaud Bernard\r\n\r\n\r\n0677778919','31000','TOULOUSE',33,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(59,'La Ruche qui dit Oui',1,NULL,NULL,0,NULL,'2017-09-27 20:17:46','2017-09-27 22:17:46',1,NULL,NULL,NULL,NULL,'',NULL,NULL,33,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(60,'biocoop capdenac',1,NULL,NULL,0,NULL,'2017-11-13 18:52:16','2017-10-05 08:52:06',1,NULL,NULL,NULL,NULL,'le vern','46100','capdenac le haut',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(61,'La Super Epicerie',1,NULL,NULL,0,NULL,'2017-10-16 12:47:11','2017-10-16 14:47:11',1,NULL,NULL,NULL,NULL,'105 avenue Jean Jaurès\r\n\r\n\r\n0677398354','69600','OULLINS',0,1,'0478566972',NULL,NULL,'laure.helene.viallon.halle@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(62,'Biocoop Montignac',1,NULL,NULL,0,NULL,'2017-11-13 18:39:51','2017-10-26 16:25:21',1,NULL,NULL,NULL,NULL,'Route des Eyzies\r\nLes rives\r\n\r\n\r\n0553512291','24290','Montignac',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(63,'Chateau Lugagnac',1,NULL,NULL,0,NULL,'2017-11-08 21:04:45','2017-11-08 22:04:45',1,NULL,NULL,NULL,NULL,'chateau de LUGAGNAC','12640','RIVIERE SUR TARN',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(64,'le campestre',1,NULL,NULL,0,NULL,'2019-01-17 15:29:15','2017-11-22 00:53:50',1,NULL,NULL,NULL,NULL,'214 avenue de la mairie','31810','Vernet',0,1,'0963528511',NULL,NULL,'le-campestre@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(65,'O LOCAL BIO',1,NULL,NULL,0,NULL,'2018-01-22 22:05:07','2017-11-22 00:54:53',1,NULL,NULL,NULL,NULL,'143 grande rue saint michel','31000','TOULOUSE',33,1,NULL,NULL,NULL,'contact@olocalbio.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(66,'SA CEJUSYL',1,NULL,NULL,0,NULL,'2018-03-15 14:49:08','2018-01-31 21:54:31',1,NULL,NULL,NULL,NULL,'1 chemin des gaulies','46220','Prayssac',0,1,'0565303555',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(67,'SA LEODE',1,NULL,NULL,0,NULL,'2018-01-31 20:55:59','2018-01-31 21:55:59',1,NULL,NULL,NULL,NULL,'14 rue des platanes','46700','puy l\'eveque',48,1,'0565213170',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(68,'St Cirq Bien Etre',1,NULL,NULL,0,NULL,'2018-02-07 20:29:34','2018-02-07 21:29:34',1,NULL,NULL,NULL,NULL,'rue de la Peyrolerie','46330','Saint cirq Lapopie',0,1,NULL,NULL,NULL,'cachulo46@yahoo.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(69,'Biocoop La plantula',1,NULL,NULL,0,NULL,'2018-03-15 14:50:02','2018-03-15 15:50:02',1,NULL,NULL,NULL,NULL,'7 rue de la basse','66500','PRADES',0,1,'0468960858',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(70,'Ceci & Cela (minimes)',1,NULL,NULL,0,NULL,'2018-04-24 06:43:44','2018-04-24 08:43:44',1,NULL,NULL,NULL,NULL,'16 avenue des minimes','31000','TOULOUSE',33,1,'06689233381',NULL,NULL,'amandine@ceci-et-cela.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(71,'Ceci & Cela (baour lormian)',1,NULL,NULL,0,NULL,'2018-04-24 06:44:55','2018-04-24 08:44:55',1,NULL,NULL,NULL,NULL,'7 rue baour Lormian','31000','TOULOUSE',33,1,'0689233381',NULL,NULL,'amandine@ceci-et-cela.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(72,'Les Comptoirs de la Bio',1,NULL,NULL,0,NULL,'2018-06-14 06:32:27','2018-06-14 08:32:27',1,NULL,NULL,NULL,NULL,'LCB MONTAUBAN\r\n2 impasse Daguerre','82000','Montauban',84,1,'0563669790',NULL,NULL,'marine.sahki@lescomptoirsdelabio.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(73,'Adeline cavalli',1,NULL,NULL,0,NULL,'2018-06-28 08:51:55','2018-06-28 10:51:55',1,NULL,NULL,NULL,NULL,'4 rue Georges Frèche','34920','LE CRES',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(74,'la vie claire',1,NULL,NULL,0,NULL,'2018-07-11 13:43:27','2018-07-11 15:43:27',1,NULL,NULL,NULL,NULL,'9 avenue colonel Pardes','46220','Prayssac',0,1,'0565352219',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(75,'croquant stock',1,NULL,NULL,0,NULL,'2018-07-30 11:36:53','2018-07-30 13:36:53',1,NULL,NULL,NULL,NULL,'3 rue des gantiers','12200','VILLEFRANCHE DE ROUERGUE',13,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(76,'biocoop COPERNIC',1,NULL,NULL,0,NULL,'2018-08-29 09:40:40','2018-08-29 11:40:40',1,NULL,NULL,NULL,NULL,'2 allée Nicolas Copernic\r\n\r\n0549655062','79300','BRESSUIRE',0,1,'0549655062',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(77,'KILOGRAMME',1,NULL,NULL,0,NULL,'2018-09-01 08:20:42','2018-09-01 10:15:56',1,NULL,NULL,NULL,NULL,'37 rue poulet','75018','PARIS',0,1,'0677162415',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(78,'chateau Lugagnac- franck Palau',1,NULL,NULL,0,NULL,'2018-09-05 19:55:52','2018-09-05 21:55:52',1,NULL,NULL,NULL,NULL,'Chateau Lugagnac','12640','RIVIERE SUR TARN',0,1,'0614904661',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(79,'kati',1,NULL,NULL,0,NULL,'2018-09-12 16:02:11','2018-09-12 18:02:11',1,NULL,NULL,NULL,NULL,'villeflanque','64','villeflanque',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(80,'Alambic du larzac',1,NULL,NULL,0,NULL,'2018-11-15 13:10:56','2018-11-15 14:10:56',1,NULL,NULL,NULL,NULL,'Egalières','12230','l\'hospitalet du larzac',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(81,'groupement d\'achat (bonhomme&mirashi)',1,NULL,NULL,0,NULL,'2018-11-19 08:26:05','2018-11-19 09:26:05',1,NULL,NULL,NULL,NULL,'58 rue Henri Fabre','12000','RODEZ',13,1,'0686041368',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(82,'le monde d\'Orélie',1,NULL,NULL,0,NULL,'2018-11-26 09:28:21','2018-11-26 10:28:21',1,NULL,NULL,NULL,NULL,'6 galerie du midi','31250','REVEL',0,1,'0561465332',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(83,'Association de la ruche des chartrons',1,NULL,NULL,0,NULL,'2018-11-29 19:44:32','2018-11-29 20:44:32',1,NULL,NULL,NULL,NULL,'34 cours Balguerie-Stuttenberg','33000','Bordeaux',35,1,'0644001321',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(84,'TERRE MERE',1,NULL,NULL,0,NULL,'2018-12-19 07:58:58','2018-12-19 08:58:58',1,NULL,NULL,NULL,NULL,'Direction Brenac\r\nD92 avenue de marides','11500','QUILLAN',0,1,'0468696569',NULL,NULL,'terre.mere@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(85,'sarah sainsaulieu',1,NULL,NULL,0,NULL,'2019-03-04 12:43:28','2019-03-04 13:43:28',1,NULL,NULL,NULL,NULL,'104 rue de port royal\r\nFermer du Rhodon','78470','Saint Remy les chevreuses',80,1,'0685905725',NULL,NULL,'sarah@sainsaulieu.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(86,'la ruche de la serre- Laure Jandar',1,NULL,NULL,0,NULL,'2019-04-04 11:45:13','2019-04-03 18:49:51',1,NULL,NULL,NULL,NULL,'Montesquieu\r\nVolvestre',NULL,NULL,0,1,NULL,NULL,NULL,'laruchedelaserre@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(87,'BIOCOOP Courondelle (Béziers)',1,NULL,NULL,0,NULL,'2019-04-08 11:59:06','2019-04-08 13:59:06',1,NULL,NULL,NULL,NULL,'161 rue Micheline Ostermeyer','34500','Béziers',36,1,'0687381576',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(88,'QUERCY TRANSPORT',1,NULL,NULL,0,NULL,'2019-04-17 12:46:28','2019-04-17 14:46:28',1,NULL,NULL,NULL,NULL,'ZAC grand camp','46090','MERCUES',0,1,'0565303900',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,0,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(89,'QUERCY TRANSPORT',1,NULL,NULL,0,NULL,'2019-04-17 12:51:39','2019-04-17 14:51:39',1,NULL,NULL,NULL,NULL,'ZAC grand camp','46090','MERCUES',0,1,'0565303900',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(90,'Blacon du lot',1,NULL,NULL,0,NULL,'2019-04-18 07:47:34','2019-04-18 09:47:34',1,NULL,NULL,NULL,NULL,'','46220','Prayssac',0,1,'0565224249',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(91,'Balcon du lot',1,NULL,NULL,0,NULL,'2019-04-18 07:48:46','2019-04-18 09:48:46',1,NULL,NULL,NULL,NULL,'','46220','Prayssac',0,1,'0565224249',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(92,'BIO Logique',1,NULL,NULL,0,NULL,'2019-04-22 12:44:16','2019-04-22 14:44:15',1,NULL,NULL,NULL,NULL,'6 rue du château','33480','CASTELNAU DE MEDOC',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(93,'Beauty Boop',1,NULL,NULL,0,NULL,'2019-04-25 11:51:36','2019-04-25 13:51:36',1,NULL,NULL,NULL,NULL,'37 avenue des vignes planes','66400','CERET',0,1,'0608367817',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0.00000000,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(94,'Herboristerie du Larzac',1,NULL,NULL,0,NULL,'2019-06-03 20:09:18','2019-06-03 22:09:18',1,NULL,NULL,NULL,NULL,'le bourg','12230','La couvertoirade',0,1,NULL,NULL,NULL,'matthew.auge@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,1,0,NULL,'',0,0,0,1,1,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,NULL,NULL,0,'',NULL,0);

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

CREATE TABLE `llx_societe_account` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT '1',
  `key_account` varchar(128) DEFAULT NULL,
  `login` varchar(128) NOT NULL,
  `pass_encoding` varchar(24) DEFAULT NULL,
  `pass_crypted` varchar(128) DEFAULT NULL,
  `pass_temp` varchar(128) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `site` varchar(128) DEFAULT NULL,
  `fk_website` int(11) DEFAULT NULL,
  `note_private` text,
  `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) 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;

--
-- 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) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT '0',
  `name` varchar(60) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `fk_pays` int(11) DEFAULT '0',
  `phone` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `note` text,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_commerciaux` (`fk_soc`,`fk_user`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_societe_commerciaux` (`rowid`, `fk_soc`, `fk_user`, `import_key`) VALUES (1,1,1,NULL),(2,2,1,NULL),(3,3,1,NULL),(4,4,1,NULL),(5,5,1,NULL),(6,6,1,NULL),(7,7,1,NULL),(8,8,1,NULL),(9,9,1,NULL),(10,10,1,NULL),(11,11,1,NULL),(12,12,1,NULL),(13,13,1,NULL),(14,14,1,NULL),(15,15,1,NULL),(16,16,1,NULL),(17,17,1,NULL),(18,18,1,NULL),(19,19,1,NULL),(20,20,1,NULL),(21,21,1,NULL),(22,22,1,NULL),(23,23,1,NULL),(24,24,1,NULL),(25,25,1,NULL),(26,26,1,NULL),(27,27,1,NULL),(28,28,1,NULL),(29,29,1,NULL),(30,30,1,NULL),(31,31,1,NULL),(32,32,1,NULL),(33,33,1,NULL),(34,34,1,NULL),(35,35,1,NULL),(36,36,1,NULL),(37,37,1,NULL),(38,38,1,NULL),(39,39,1,NULL),(40,40,1,NULL),(41,41,1,NULL),(42,42,1,NULL),(43,43,1,NULL),(44,44,1,NULL),(45,45,1,NULL),(46,46,1,NULL),(47,47,1,NULL),(48,48,1,NULL),(49,49,1,NULL),(50,50,1,NULL),(51,51,1,NULL),(52,52,1,NULL),(53,53,1,NULL),(54,54,1,NULL),(55,55,1,NULL),(56,56,1,NULL),(57,57,1,NULL),(58,58,1,NULL),(59,59,1,NULL),(60,60,1,NULL),(61,61,1,NULL),(62,62,1,NULL),(63,63,1,NULL),(64,64,1,NULL),(65,65,1,NULL),(66,66,1,NULL),(67,67,1,NULL),(68,68,1,NULL),(69,69,1,NULL),(70,70,1,NULL),(71,71,1,NULL),(72,72,1,NULL),(73,73,1,NULL),(74,74,1,NULL),(75,75,1,NULL),(76,76,1,NULL),(77,77,1,NULL),(78,78,1,NULL),(79,79,1,NULL),(80,80,1,NULL),(81,81,1,NULL),(82,82,1,NULL),(83,83,1,NULL),(84,84,1,NULL),(85,85,1,NULL),(86,86,1,NULL),(87,87,1,NULL),(88,88,1,NULL),(89,89,1,NULL),(90,90,1,NULL),(91,91,1,NULL),(92,92,1,NULL),(93,93,1,NULL);

--
-- 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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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


--
-- Table structure for table `llx_societe_log`
--

CREATE TABLE `llx_societe_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datel` datetime DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_statut` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `author` varchar(30) DEFAULT NULL,
  `label` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_societe_log`
--


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

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

--
-- 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',
  `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,
  `description` text 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',
  `fk_invoice_supplier_line` int(11) DEFAULT NULL,
  `fk_invoice_supplier` int(11) DEFAULT NULL,
  `fk_invoice_supplier_source` int(11) DEFAULT NULL,
  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 `fk_soc_remise_fk_invoice_supplier_line` (`fk_invoice_supplier_line`),
  KEY `fk_societe_remise_fk_invoice_supplier_source` (`fk_invoice_supplier`),
  KEY `idx_societe_remise_except_discount_type` (`discount_type`),
  CONSTRAINT `fk_soc_remise_fk_invoice_supplier_line` FOREIGN KEY (`fk_invoice_supplier_line`) REFERENCES `llx_facture_fourn_det` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `llx_facture` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_facture_line` FOREIGN KEY (`fk_facture_line`) REFERENCES `llx_facturedet` (`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_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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) NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `label` varchar(30) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `code_banque` varchar(128) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  `bic` varchar(20) DEFAULT NULL,
  `iban_prefix` varchar(34) DEFAULT NULL,
  `domiciliation` varchar(255) DEFAULT NULL,
  `proprio` varchar(60) DEFAULT NULL,
  `owner_address` varchar(255) DEFAULT NULL,
  `default_rib` smallint(6) NOT NULL DEFAULT '0',
  `rum` varchar(32) DEFAULT NULL,
  `date_rum` date DEFAULT NULL,
  `frstrecur` varchar(16) DEFAULT 'FRST',
  `import_key` varchar(14) DEFAULT NULL,
  `last_four` varchar(4) DEFAULT NULL,
  `card_type` varchar(255) DEFAULT NULL,
  `cvn` varchar(255) DEFAULT NULL,
  `exp_date_month` int(11) DEFAULT NULL,
  `exp_date_year` int(11) DEFAULT NULL,
  `country_code` varchar(10) DEFAULT NULL,
  `approved` int(11) DEFAULT '0',
  `email` varchar(255) DEFAULT NULL,
  `ending_date` date DEFAULT NULL,
  `max_total_amount_of_all_payments` double(24,8) DEFAULT NULL,
  `preapproval_key` varchar(255) DEFAULT NULL,
  `starting_date` date DEFAULT NULL,
  `total_amount_of_all_payments` double(24,8) DEFAULT NULL,
  `stripe_card_ref` varchar(128) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `comment` varchar(255) DEFAULT NULL,
  `ipaddress` varchar(68) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 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) DEFAULT NULL,
  `civility` varchar(6) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(25) DEFAULT NULL,
  `town` varchar(255) DEFAULT NULL,
  `fk_departement` int(11) DEFAULT NULL,
  `fk_pays` int(11) DEFAULT '0',
  `birthday` date DEFAULT NULL,
  `poste` varchar(80) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `phone_perso` varchar(30) DEFAULT NULL,
  `phone_mobile` varchar(30) DEFAULT NULL,
  `fax` varchar(30) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `jabberid` varchar(255) DEFAULT NULL,
  `skype` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `googleplus` varchar(255) DEFAULT NULL,
  `snapchat` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `no_email` smallint(6) NOT NULL DEFAULT '0',
  `priv` smallint(6) NOT NULL DEFAULT '0',
  `fk_user_creat` int(11) DEFAULT '0',
  `fk_user_modif` int(11) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `default_lang` varchar(6) DEFAULT NULL,
  `canvas` varchar(32) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `statut` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  KEY `idx_socpeople_fk_soc` (`fk_soc`),
  KEY `idx_socpeople_fk_user_creat` (`fk_user_creat`),
  CONSTRAINT `fk_socpeople_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_socpeople_user_creat_user_rowid` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_socpeople` (`rowid`, `datec`, `tms`, `fk_soc`, `entity`, `ref_ext`, `civility`, `lastname`, `firstname`, `address`, `zip`, `town`, `fk_departement`, `fk_pays`, `birthday`, `poste`, `phone`, `phone_perso`, `phone_mobile`, `fax`, `email`, `jabberid`, `skype`, `whatsapp`, `youtube`, `googleplus`, `snapchat`, `instagram`, `facebook`, `twitter`, `photo`, `no_email`, `priv`, `fk_user_creat`, `fk_user_modif`, `note_private`, `note_public`, `default_lang`, `canvas`, `import_key`, `statut`) VALUES (1,'2017-03-21 20:49:14','2017-03-21 19:49:14',29,1,NULL,'MME','colin','chrystel','Lieu dit Fons de Boulay','34150','Puechabon',36,1,NULL,'','','','','','latelierdusculpteur@gmail.com','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1),(2,'2017-10-29 12:01:06','2019-02-04 22:03:22',51,1,NULL,'','adresse livraison','','14 rue Alphonse Baudin','75011','PARIS',NULL,1,NULL,'','','','0622823884','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,'','',NULL,NULL,NULL,1);

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

CREATE TABLE `llx_socpeople_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_socpeople_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

