-- Table structure for table `llx_facturedet_extrafields`
--

CREATE TABLE `llx_facturedet_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_facturedet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_facturedet_extrafields`
--


--
-- Table structure for table `llx_facturedet_rec`
--

CREATE TABLE `llx_facturedet_rec` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_facture` int(11) NOT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `product_type` int(11) DEFAULT '0',
  `label` varchar(255) DEFAULT NULL,
  `description` text,
  `tva_tx` double(6,3) DEFAULT NULL,
  `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',
  `subprice` double(24,8) DEFAULT NULL,
  `price` double(24,8) DEFAULT NULL,
  `total_ht` double(24,8) DEFAULT NULL,
  `total_tva` double(24,8) DEFAULT NULL,
  `total_localtax1` double(24,8) DEFAULT '0.00000000',
  `total_localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT NULL,
  `info_bits` int(11) DEFAULT '0',
  `special_code` int(10) unsigned DEFAULT '0',
  `rang` int(11) DEFAULT '0',
  `fk_contract_line` int(11) DEFAULT NULL,
  `fk_unit` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `fk_facturedet_rec_fk_unit` (`fk_unit`),
  CONSTRAINT `fk_facturedet_rec_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `llx_c_units` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_facturedet_rec`
--


--
-- Table structure for table `llx_fichinter`
--

CREATE TABLE `llx_fichinter` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) NOT NULL,
  `fk_projet` int(11) DEFAULT '0',
  `fk_contrat` int(11) DEFAULT '0',
  `ref` varchar(30) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `datei` date 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) DEFAULT '0',
  `duree` double DEFAULT NULL,
  `description` text,
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `ref_ext` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_fichinter_ref` (`ref`,`entity`),
  KEY `idx_fichinter_fk_soc` (`fk_soc`),
  CONSTRAINT `fk_fichinter_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_fichinter`
--

INSERT INTO `llx_fichinter` (`rowid`, `fk_soc`, `fk_projet`, `fk_contrat`, `ref`, `entity`, `tms`, `datec`, `date_valid`, `datei`, `fk_user_author`, `fk_user_modif`, `fk_user_valid`, `fk_statut`, `duree`, `description`, `note_private`, `note_public`, `model_pdf`, `extraparams`, `ref_ext`) VALUES (2,5,0,0,'(PROV2)',1,'2016-06-20 19:18:55','2016-06-20 21:18:55',NULL,NULL,1,NULL,NULL,0,NULL,NULL,NULL,NULL,'soleil',NULL,NULL),(3,5,0,0,'(PROV3)',1,'2016-06-20 19:22:32','2016-06-20 21:21:53',NULL,NULL,1,NULL,NULL,0,14400,NULL,NULL,NULL,'soleil',NULL,NULL);

--
-- Table structure for table `llx_fichinter_extrafields`
--

CREATE TABLE `llx_fichinter_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_ficheinter_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_fichinter_extrafields`
--


--
-- Table structure for table `llx_fichinterdet`
--

CREATE TABLE `llx_fichinterdet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_fichinter` int(11) DEFAULT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `description` text,
  `duree` int(11) DEFAULT NULL,
  `rang` int(11) DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `idx_fichinterdet_fk_fichinter` (`fk_fichinter`),
  CONSTRAINT `fk_fichinterdet_fk_fichinter` FOREIGN KEY (`fk_fichinter`) REFERENCES `llx_fichinter` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_fichinterdet`
--

INSERT INTO `llx_fichinterdet` (`rowid`, `fk_fichinter`, `fk_parent_line`, `date`, `description`, `duree`, `rang`) VALUES (1,3,NULL,'2016-06-20 08:00:00','fdssdlknfjlkdsjflksdj',14400,0);

--
-- Table structure for table `llx_fichinterdet_extrafields`
--

CREATE TABLE `llx_fichinterdet_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_ficheinterdet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_fichinterdet_extrafields`
--


--
-- Table structure for table `llx_holiday`
--

CREATE TABLE `llx_holiday` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL,
  `fk_user_create` int(11) DEFAULT NULL,
  `date_create` datetime NOT NULL,
  `description` varchar(255) NOT NULL,
  `date_debut` date NOT NULL,
  `date_fin` date NOT NULL,
  `halfday` int(11) DEFAULT '0',
  `statut` int(11) NOT NULL DEFAULT '1',
  `fk_validator` int(11) NOT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `date_refuse` datetime DEFAULT NULL,
  `fk_user_refuse` int(11) DEFAULT NULL,
  `date_cancel` datetime DEFAULT NULL,
  `fk_user_cancel` int(11) DEFAULT NULL,
  `detail_refuse` varchar(250) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `fk_type` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  KEY `idx_holiday_fk_user` (`fk_user`),
  KEY `idx_holiday_fk_user_create` (`fk_user_create`),
  KEY `idx_holiday_date_create` (`date_create`),
  KEY `idx_holiday_date_debut` (`date_debut`),
  KEY `idx_holiday_date_fin` (`date_fin`),
  KEY `idx_holiday_fk_validator` (`fk_validator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_holiday`
--


--
-- Table structure for table `llx_holiday_config`
--

CREATE TABLE `llx_holiday_config` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_holiday_config`
--

INSERT INTO `llx_holiday_config` (`rowid`, `name`, `value`) VALUES (1,'userGroup',NULL),(2,'lastUpdate',NULL),(3,'nbUser',NULL),(4,'delayForRequest','31'),(5,'AlertValidatorDelay','0'),(6,'AlertValidatorSolde','0'),(7,'nbHolidayDeducted','1'),(8,'nbHolidayEveryMonth','2.08334');

--
-- Table structure for table `llx_holiday_events`
--

CREATE TABLE `llx_holiday_events` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `name` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_holiday_name` (`name`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_holiday_events`
--


--
-- Table structure for table `llx_holiday_logs`
--

CREATE TABLE `llx_holiday_logs` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `date_action` datetime NOT NULL,
  `fk_user_action` int(11) NOT NULL,
  `fk_user_update` int(11) NOT NULL,
  `type_action` varchar(255) NOT NULL,
  `prev_solde` varchar(255) NOT NULL,
  `new_solde` varchar(255) NOT NULL,
  `fk_type` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_holiday_logs`
--


--
-- Table structure for table `llx_holiday_users`
--

CREATE TABLE `llx_holiday_users` (
  `fk_user` int(11) NOT NULL,
  `nb_holiday` double NOT NULL DEFAULT '0',
  `fk_type` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_holiday_users`
--


--
-- Table structure for table `llx_import_model`
--

CREATE TABLE `llx_import_model` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL DEFAULT '0',
  `label` varchar(50) NOT NULL,
  `type` varchar(20) NOT NULL,
  `field` text NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_import_model` (`label`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_import_model`
--


--
-- Table structure for table `llx_invoice_merged_pdf`
--

CREATE TABLE `llx_invoice_merged_pdf` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_facture` int(11) NOT NULL,
  `file_name` varchar(200) NOT 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_invoice_merged_pdf`
--


--
-- 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`)
) 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(30) 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,
  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_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_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 NOT NULL DEFAULT '0',
  `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 DEFAULT '0',
  `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',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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


--
-- 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(60) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `sujet` varchar(60) 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(160) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `source_type` varchar(16) DEFAULT NULL,
  `date_envoi` datetime 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(24) DEFAULT NULL,
  `fk_leftmenu` varchar(24) 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` varchar(255) DEFAULT NULL,
  `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=15627 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,'margins','left','accountancy','margins',-1,'accountancy',NULL,100,'/margin/index.php','','Margins','margins',NULL,'1','$user->rights->margins->liretous',2,'2014-10-01 15:10:08'),(5215,'all',1,'resource','left','tools','resource',-1,'tools',NULL,100,'/resource/list.php','','MenuResourceIndex','resource',NULL,'$user->rights->resource->read','1',0,'2015-12-04 10:57:22'),(5216,'all',1,'resource','left','tools',NULL,-1,'tools','resource',101,'/resource/add.php','','MenuResourceAdd','resource',NULL,'$user->rights->resource->read','1',0,'2015-12-04 10:57:22'),(10422,'all',1,'ecm','top','ecm',NULL,0,NULL,NULL,100,'/ecm/index.php','','MenuECM','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload || $user->rights->ecm->setup','$conf->ecm->enabled',2,'2016-02-07 20:06:22'),(10423,'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,'2016-02-07 20:06:22'),(10424,'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,'2016-02-07 20:06:22'),(10425,'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',2,'2016-02-07 20:06:22'),(10426,'auguria',1,'','top','home','',0,NULL,NULL,10,'/index.php?mainmenu=home&amp;leftmenu=','','Home','',-1,'','1',2,'2016-02-07 20:06:23'),(10427,'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,'2016-02-07 20:06:23'),(10428,'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,'2016-02-07 20:06:23'),(10430,'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->fournisseur->enabled || $conf->contrat->enabled || $conf->ficheinter->enabled',2,'2016-02-07 20:06:23'),(10431,'auguria',1,'comptabilite|accounting|facture|deplacement|don|tax|salaries|loa','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->deplacement->lire || $user->rights->don->lire || $user->rights->tax->charges->lire || $user->rights->salaries->read || $u','$conf->comptabilite->enabled || $conf->accounting->enabled || $conf->facture->enabled || $conf->deplacement->enabled || $conf->don->enabled  || $conf->tax->enabled || $conf->salaries->enabled || $conf->loan->enabled',2,'2016-02-07 20:06:23'),(10432,'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,'2016-02-07 20:06:23'),(10433,'auguria',1,'mailing|export|import|opensurvey','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','$conf->mailing->enabled || $conf->export->enabled || $conf->import->enabled || $conf->opensurvey->enabled',2,'2016-02-07 20:06:23'),(10438,'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,'2016-02-07 20:06:23'),(10439,'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,'2016-02-07 20:06:23'),(10440,'auguria',1,'hrm','top','hrm','',0,NULL,NULL,80,'/compta/hrm.php?mainmenu=hrm&amp;leftmenu=','','HRM','holiday',-1,'$user->rights->holiday->write || $user->rights->deplacement->lire || $user->rights->expensereport->lire','$conf->holiday->enabled || $conf->deplacement->enabled || $conf->expensereport->enabled',0,'2016-02-07 20:06:23'),(10525,'auguria',1,'','left','home','setup',10426,NULL,NULL,0,'/admin/index.php?leftmenu=setup','','Setup','admin',0,'','$user->admin',2,'2016-02-07 20:06:23'),(10526,'auguria',1,'','left','home','',10525,NULL,NULL,1,'/admin/company.php?leftmenu=setup','','MenuCompanySetup','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10527,'auguria',1,'','left','home','',10525,NULL,NULL,4,'/admin/ihm.php?leftmenu=setup','','GUISetup','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10528,'auguria',1,'','left','home','',10525,NULL,NULL,2,'/admin/modules.php?leftmenu=setup','','Modules','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10529,'auguria',1,'','left','home','',10525,NULL,NULL,6,'/admin/boxes.php?leftmenu=setup','','Boxes','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10530,'auguria',1,'','left','home','',10525,NULL,NULL,3,'/admin/menus.php?leftmenu=setup','','Menus','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10531,'auguria',1,'','left','home','',10525,NULL,NULL,7,'/admin/delais.php?leftmenu=setup','','Alerts','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10532,'auguria',1,'','left','home','',10525,NULL,NULL,10,'/admin/pdf.php?leftmenu=setup','','PDF','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10533,'auguria',1,'','left','home','',10525,NULL,NULL,8,'/admin/security_other.php?leftmenu=setup','','Security','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10534,'auguria',1,'','left','home','',10525,NULL,NULL,11,'/admin/mails.php?leftmenu=setup','','Emails','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10535,'auguria',1,'','left','home','',10525,NULL,NULL,9,'/admin/limits.php?leftmenu=setup','','MenuLimits','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10536,'auguria',1,'','left','home','',10525,NULL,NULL,13,'/admin/dict.php?leftmenu=setup','','Dictionary','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10537,'auguria',1,'','left','home','',10525,NULL,NULL,14,'/admin/const.php?leftmenu=setup','','OtherSetup','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10538,'auguria',1,'','left','home','',10525,NULL,NULL,12,'/admin/sms.php?leftmenu=setup','','SMS','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10539,'auguria',1,'','left','home','',10525,NULL,NULL,4,'/admin/translation.php?leftmenu=setup','','Translation','admin',1,'','$leftmenu==\"setup\"',2,'2016-02-07 20:06:23'),(10626,'auguria',1,'','left','home','',10725,NULL,NULL,0,'/admin/system/dolibarr.php?leftmenu=admintools','','InfoDolibarr','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10627,'auguria',1,'','left','home','',10626,NULL,NULL,2,'/admin/system/modules.php?leftmenu=admintools','','Modules','admin',2,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10628,'auguria',1,'','left','home','',10626,NULL,NULL,3,'/admin/triggers.php?leftmenu=admintools','','Triggers','admin',2,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10630,'auguria',1,'','left','home','',10725,NULL,NULL,1,'/admin/system/browser.php?leftmenu=admintools','','InfoBrowser','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10631,'auguria',1,'','left','home','',10725,NULL,NULL,2,'/admin/system/os.php?leftmenu=admintools','','InfoOS','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10632,'auguria',1,'','left','home','',10725,NULL,NULL,3,'/admin/system/web.php?leftmenu=admintools','','InfoWebServer','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10633,'auguria',1,'','left','home','',10725,NULL,NULL,4,'/admin/system/phpinfo.php?leftmenu=admintools','','InfoPHP','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10635,'auguria',1,'','left','home','',10725,NULL,NULL,5,'/admin/system/database.php?leftmenu=admintools','','InfoDatabase','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10725,'auguria',1,'','left','home','admintools',10426,NULL,NULL,2,'/admin/tools/index.php?leftmenu=admintools','','SystemTools','admin',0,'','$user->admin',2,'2016-02-07 20:06:23'),(10726,'auguria',1,'','left','home','',10725,NULL,NULL,6,'/admin/tools/dolibarr_export.php?leftmenu=admintools','','Backup','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10727,'auguria',1,'','left','home','',10725,NULL,NULL,7,'/admin/tools/dolibarr_import.php?leftmenu=admintools','','Restore','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10730,'auguria',1,'','left','home','',10725,NULL,NULL,8,'/admin/tools/update.php?leftmenu=admintools','','MenuUpgrade','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10731,'auguria',1,'','left','home','',10725,NULL,NULL,9,'/admin/tools/eaccelerator.php?leftmenu=admintools','','EAccelerator','admin',1,'','$leftmenu==\"admintools\" && function_exists(\"eaccelerator_info\")',2,'2016-02-07 20:06:23'),(10732,'auguria',1,'','left','home','',10725,NULL,NULL,10,'/admin/tools/listevents.php?leftmenu=admintools','','Audit','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10733,'auguria',1,'','left','home','',10725,NULL,NULL,11,'/admin/tools/listsessions.php?leftmenu=admintools','','Sessions','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10734,'auguria',1,'','left','home','',10725,NULL,NULL,12,'/admin/tools/purge.php?leftmenu=admintools','','Purge','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10735,'auguria',1,'','left','home','',10725,NULL,NULL,13,'/support/index.php?leftmenu=admintools','_blank','HelpCenter','help',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10736,'auguria',1,'','left','home','',10725,NULL,NULL,14,'/admin/system/about.php?leftmenu=admintools','','About','admin',1,'','$leftmenu==\"admintools\"',2,'2016-02-07 20:06:23'),(10825,'auguria',1,'','left','home','users',10426,NULL,NULL,4,'/user/home.php?leftmenu=users','','MenuUsersAndGroups','users',0,'','1',2,'2016-02-07 20:06:23'),(10826,'auguria',1,'','left','home','',10825,NULL,NULL,0,'/user/index.php?leftmenu=users','','Users','users',1,'$user->rights->user->user->lire || $user->admin','$leftmenu==\"users\"',2,'2016-02-07 20:06:23'),(10827,'auguria',1,'','left','home','',10826,NULL,NULL,0,'/user/card.php?leftmenu=users&amp;action=create','','NewUser','users',2,'$user->rights->user->user->creer || $user->admin','$leftmenu==\"users\"',2,'2016-02-07 20:06:23'),(10828,'auguria',1,'','left','home','',10825,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,'2016-02-07 20:06:23'),(10829,'auguria',1,'','left','home','',10828,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,'2016-02-07 20:06:23'),(10925,'auguria',1,'','left','companies','thirdparties',10427,NULL,NULL,0,'/societe/index.php?leftmenu=thirdparties','','ThirdParty','companies',0,'$user->rights->societe->lire','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(10926,'auguria',1,'','left','companies','',10925,NULL,NULL,0,'/societe/soc.php?action=create','','MenuNewThirdParty','companies',1,'$user->rights->societe->lire','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(10927,'auguria',1,'','left','companies','',10925,NULL,NULL,0,'/societe/list.php?action=create','','List','companies',1,'$user->rights->societe->lire','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(10928,'auguria',1,'','left','companies','',10925,NULL,NULL,5,'/fourn/list.php?leftmenu=suppliers','','ListSuppliersShort','suppliers',1,'$user->rights->societe->lire && $user->rights->fournisseur->lire','$conf->societe->enabled && $conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(10929,'auguria',1,'','left','companies','',10928,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,'2016-02-07 20:06:23'),(10931,'auguria',1,'','left','companies','',10925,NULL,NULL,3,'/comm/prospect/list.php?leftmenu=prospects','','ListProspectsShort','companies',1,'$user->rights->societe->lire','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(10932,'auguria',1,'','left','companies','',10931,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,'2016-02-07 20:06:23'),(10934,'auguria',1,'','left','companies','',10925,NULL,NULL,4,'/comm/list.php?leftmenu=customers','','ListCustomersShort','companies',1,'$user->rights->societe->lire','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(10935,'auguria',1,'','left','companies','',10934,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,'2016-02-07 20:06:23'),(11025,'auguria',1,'','left','companies','contacts',10427,NULL,NULL,1,'/contact/list.php?leftmenu=contacts','','ContactsAddresses','companies',0,'$user->rights->societe->lire','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(11026,'auguria',1,'','left','companies','',11025,NULL,NULL,0,'/contact/card.php?leftmenu=contacts&amp;action=create','','NewContactAddress','companies',1,'$user->rights->societe->creer','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(11027,'auguria',1,'','left','companies','',11025,NULL,NULL,1,'/contact/list.php?leftmenu=contacts','','List','companies',1,'$user->rights->societe->lire','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(11029,'auguria',1,'','left','companies','',11027,NULL,NULL,1,'/contact/list.php?leftmenu=contacts&amp;type=p','','ThirdPartyProspects','companies',2,'$user->rights->societe->contact->lire','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(11030,'auguria',1,'','left','companies','',11027,NULL,NULL,2,'/contact/list.php?leftmenu=contacts&amp;type=c','','ThirdPartyCustomers','companies',2,'$user->rights->societe->contact->lire','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(11031,'auguria',1,'','left','companies','',11027,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,'2016-02-07 20:06:23'),(11032,'auguria',1,'','left','companies','',11027,NULL,NULL,4,'/contact/list.php?leftmenu=contacts&amp;type=o','','Others','companies',2,'$user->rights->societe->contact->lire','$conf->societe->enabled',2,'2016-02-07 20:06:23'),(11075,'auguria',1,'','left','companies','cat',10427,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,'2016-02-07 20:06:23'),(11076,'auguria',1,'','left','companies','',11075,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,'2016-02-07 20:06:23'),(11085,'auguria',1,'','left','companies','cat',10427,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,'2016-02-07 20:06:23'),(11086,'auguria',1,'','left','companies','',11085,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,'2016-02-07 20:06:23'),(11095,'auguria',1,'','left','companies','cat',10427,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,'2016-02-07 20:06:23'),(11096,'auguria',1,'','left','companies','',11095,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,'2016-02-07 20:06:23'),(11525,'auguria',1,'','left','commercial','propals',10430,NULL,NULL,4,'/comm/propal/index.php?leftmenu=propals','','Prop','propal',0,'$user->rights->propale->lire','$conf->propal->enabled',2,'2016-02-07 20:06:23'),(11526,'auguria',1,'','left','commercial','',11525,NULL,NULL,0,'/comm/propal.php?action=create&amp;leftmenu=propals','','NewPropal','propal',1,'$user->rights->propale->creer','$conf->propal->enabled',2,'2016-02-07 20:06:23'),(11527,'auguria',1,'','left','commercial','',11525,NULL,NULL,1,'/comm/propal/list.php?leftmenu=propals','','List','propal',1,'$user->rights->propale->lire','$conf->propal->enabled',2,'2016-02-07 20:06:23'),(11528,'auguria',1,'','left','commercial','',11527,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,'2016-02-07 20:06:23'),(11529,'auguria',1,'','left','commercial','',11527,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,'2016-02-07 20:06:23'),(11530,'auguria',1,'','left','commercial','',11527,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,'2016-02-07 20:06:23'),(11531,'auguria',1,'','left','commercial','',11527,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,'2016-02-07 20:06:23'),(11532,'auguria',1,'','left','commercial','',11527,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,'2016-02-07 20:06:23'),(11535,'auguria',1,'','left','commercial','',11525,NULL,NULL,4,'/comm/propal/stats/index.php?leftmenu=propals','','Statistics','propal',1,'$user->rights->propale->lire','$conf->propal->enabled',2,'2016-02-07 20:06:23'),(11625,'auguria',1,'','left','commercial','orders',10430,NULL,NULL,5,'/commande/index.php?leftmenu=orders','','CustomersOrders','orders',0,'$user->rights->commande->lire','$conf->commande->enabled',2,'2016-02-07 20:06:23'),(11626,'auguria',1,'','left','commercial','',11625,NULL,NULL,0,'/commande/card.php?action=create&amp;leftmenu=orders','','NewOrder','orders',1,'$user->rights->commande->creer','$conf->commande->enabled',2,'2016-02-07 20:06:23'),(11627,'auguria',1,'','left','commercial','',11625,NULL,NULL,1,'/commande/list.php?leftmenu=orders','','List','orders',1,'$user->rights->commande->lire','$conf->commande->enabled',2,'2016-02-07 20:06:23'),(11628,'auguria',1,'','left','commercial','',11627,NULL,NULL,2,'/commande/list.php?leftmenu=orders&amp;viewstatut=0','','StatusOrderDraftShort','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2016-02-07 20:06:23'),(11629,'auguria',1,'','left','commercial','',11627,NULL,NULL,3,'/commande/list.php?leftmenu=orders&amp;viewstatut=1','','StatusOrderValidated','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2016-02-07 20:06:23'),(11630,'auguria',1,'','left','commercial','',11627,NULL,NULL,4,'/commande/list.php?leftmenu=orders&amp;viewstatut=2','','StatusOrderOnProcessShort','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2016-02-07 20:06:23'),(11631,'auguria',1,'','left','commercial','',11627,NULL,NULL,5,'/commande/list.php?leftmenu=orders&amp;viewstatut=3','','StatusOrderToBill','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2016-02-07 20:06:23'),(11632,'auguria',1,'','left','commercial','',11627,NULL,NULL,6,'/commande/list.php?leftmenu=orders&amp;viewstatut=4','','StatusOrderProcessed','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2016-02-07 20:06:23'),(11633,'auguria',1,'','left','commercial','',11627,NULL,NULL,7,'/commande/list.php?leftmenu=orders&amp;viewstatut=-1','','StatusOrderCanceledShort','orders',1,'$user->rights->commande->lire','$conf->commande->enabled && $leftmenu==\"orders\"',2,'2016-02-07 20:06:23'),(11634,'auguria',1,'','left','commercial','',11625,NULL,NULL,4,'/commande/stats/index.php?leftmenu=orders','','Statistics','orders',1,'$user->rights->commande->lire','$conf->commande->enabled',2,'2016-02-07 20:06:23'),(11725,'auguria',1,'','left','commercial','sendings',10428,NULL,NULL,6,'/expedition/index.php?leftmenu=sendings','','Shipments','sendings',0,'$user->rights->expedition->lire','$conf->expedition->enabled',2,'2016-02-07 20:06:23'),(11726,'auguria',1,'','left','commercial','',11725,NULL,NULL,0,'/expedition/card.php?action=create2&leftmenu=sendings','','NewSending','sendings',1,'$user->rights->expedition->creer','$conf->expedition->enabled && $leftmenu==\"sendings\"',2,'2016-02-07 20:06:23'),(11727,'auguria',1,'','left','commercial','',11725,NULL,NULL,1,'/expedition/list.php?leftmenu=sendings','','List','sendings',1,'$user->rights->expedition->lire','$conf->expedition->enabled && $leftmenu==\"sendings\"',2,'2016-02-07 20:06:23'),(11728,'auguria',1,'','left','commercial','',11725,NULL,NULL,2,'/expedition/stats/index.php?leftmenu=sendings','','Statistics','sendings',1,'$user->rights->expedition->lire','$conf->expedition->enabled && $leftmenu==\"sendings\"',2,'2016-02-07 20:06:23'),(11825,'auguria',1,'','left','commercial','contracts',10430,NULL,NULL,7,'/contrat/index.php?leftmenu=contracts','','Contracts','contracts',0,'$user->rights->contrat->lire','$conf->contrat->enabled',2,'2016-02-07 20:06:23'),(11826,'auguria',1,'','left','commercial','',11825,NULL,NULL,0,'/contrat/card.php?&action=create&amp;leftmenu=contracts','','NewContract','contracts',1,'$user->rights->contrat->creer','$conf->contrat->enabled',2,'2016-02-07 20:06:23'),(11827,'auguria',1,'','left','commercial','',11825,NULL,NULL,1,'/contrat/list.php?leftmenu=contracts','','List','contracts',1,'$user->rights->contrat->lire','$conf->contrat->enabled',2,'2016-02-07 20:06:23'),(11828,'auguria',1,'','left','commercial','',11825,NULL,NULL,2,'/contrat/services.php?leftmenu=contracts','','MenuServices','contracts',1,'$user->rights->contrat->lire','$conf->contrat->enabled',2,'2016-02-07 20:06:23'),(11829,'auguria',1,'','left','commercial','',11828,NULL,NULL,0,'/contrat/services.php?leftmenu=contracts&amp;mode=0','','MenuInactiveServices','contracts',2,'$user->rights->contrat->lire','$conf->contrat->enabled&&$leftmenu==\"contracts\"',2,'2016-02-07 20:06:23'),(11830,'auguria',1,'','left','commercial','',11828,NULL,NULL,1,'/contrat/services.php?leftmenu=contracts&amp;mode=4','','MenuRunningServices','contracts',2,'$user->rights->contrat->lire','$conf->contrat->enabled&&$leftmenu==\"contracts\"',2,'2016-02-07 20:06:23'),(11831,'auguria',1,'','left','commercial','',11828,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,'2016-02-07 20:06:23'),(11832,'auguria',1,'','left','commercial','',11828,NULL,NULL,3,'/contrat/services.php?leftmenu=contracts&amp;mode=5','','MenuClosedServices','contracts',2,'$user->rights->contrat->lire','$conf->contrat->enabled&&$leftmenu==\"contracts\"',2,'2016-02-07 20:06:23'),(11925,'auguria',1,'','left','commercial','ficheinter',10430,NULL,NULL,8,'/fichinter/list.php?leftmenu=ficheinter','','Interventions','interventions',0,'$user->rights->ficheinter->lire','$conf->ficheinter->enabled',2,'2016-02-07 20:06:23'),(11926,'auguria',1,'','left','commercial','',11925,NULL,NULL,0,'/fichinter/card.php?action=create&amp;leftmenu=ficheinter','','NewIntervention','interventions',1,'$user->rights->ficheinter->creer','$conf->ficheinter->enabled',2,'2016-02-07 20:06:23'),(11927,'auguria',1,'','left','commercial','',11925,NULL,NULL,1,'/fichinter/list.php?leftmenu=ficheinter','','List','interventions',1,'$user->rights->ficheinter->lire','$conf->ficheinter->enabled',2,'2016-02-07 20:06:23'),(12025,'auguria',1,'','left','accountancy','supplier_bills',10431,NULL,NULL,3,'/fourn/facture/list.php?leftmenu=suppliers_bills','','BillsSuppliers','bills',0,'$user->rights->fournisseur->facture->lire','$conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(12026,'auguria',1,'','left','accountancy','',12025,NULL,NULL,0,'/fourn/facture/card.php?action=create&amp;leftmenu=suppliers_bills','','NewBill','bills',1,'$user->rights->fournisseur->facture->creer','$conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(12027,'auguria',1,'','left','accountancy','',12025,NULL,NULL,1,'/fourn/facture/impayees.php?leftmenu=suppliers_bills','','Unpaid','bills',1,'$user->rights->fournisseur->facture->lire','$conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(12028,'auguria',1,'','left','accountancy','',12025,NULL,NULL,2,'/fourn/facture/paiement.php?leftmenu=suppliers_bills','','Payments','bills',1,'$user->rights->fournisseur->facture->lire','$conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(12029,'auguria',1,'','left','accountancy','',12025,NULL,NULL,8,'/compta/facture/stats/index.php?leftmenu=customers_bills&mode=supplier','','Statistics','bills',1,'$user->rights->fournisseur->facture->lire','$conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(12125,'auguria',1,'','left','accountancy','customer_bills',10431,NULL,NULL,3,'/compta/facture/list.php?leftmenu=customers_bills','','BillsCustomers','bills',0,'$user->rights->facture->lire','$conf->facture->enabled',2,'2016-02-07 20:06:23'),(12126,'auguria',1,'','left','accountancy','',12125,NULL,NULL,3,'/compta/facture.php?action=create&amp;leftmenu=customers_bills','','NewBill','bills',1,'$user->rights->facture->creer','$conf->facture->enabled',2,'2016-02-07 20:06:23'),(12127,'auguria',1,'','left','accountancy','',12125,NULL,NULL,5,'/compta/facture/fiche-rec.php?leftmenu=customers_bills','','ListOfTemplates','bills',1,'$user->rights->facture->lire','$conf->facture->enabled',2,'2016-02-07 20:06:23'),(12128,'auguria',1,'','left','accountancy','',12125,NULL,NULL,7,'/compta/facture/mergepdftool.php?action=facturer&amp;leftmenu=customers_bills','','MergingPDFTool','bills',1,'$user->rights->facture->lire','$conf->facture->enabled',2,'2016-02-07 20:06:23'),(12129,'auguria',1,'','left','accountancy','',12125,NULL,NULL,6,'/compta/paiement/list.php?leftmenu=customers_bills','','Payments','bills',1,'$user->rights->facture->lire','$conf->facture->enabled',2,'2016-02-07 20:06:23'),(12130,'auguria',1,'','left','accountancy','',12125,NULL,NULL,4,'/compta/facture/list.php?leftmenu=customers_bills','','List','bills',1,'$user->rights->facture->lire','$conf->facture->enabled',2,'2016-02-07 20:06:23'),(12135,'auguria',1,'','left','accountancy','',12129,NULL,NULL,1,'/compta/paiement/rapport.php?leftmenu=customers_bills','','Reportings','bills',2,'$user->rights->facture->lire','$conf->facture->enabled',2,'2016-02-07 20:06:23'),(12136,'auguria',1,'','left','accountancy','checks',10439,NULL,NULL,9,'/compta/paiement/cheque/index.php?leftmenu=checks&amp;mainmenu=bank','','MenuChequeDeposits','bills',0,'$user->rights->banque->lire','! empty($conf->banque->enabled) && (! empty($conf->facture->enabled)) || ! empty($conf->global->MAIN_MENU_CHEQUE_DEPOSIT_ON)',2,'2016-02-07 20:06:23'),(12137,'auguria',1,'','left','accountancy','',12136,NULL,NULL,0,'/compta/paiement/cheque/card.php?leftmenu=checks&amp;action=new','','NewCheckDeposit','compta',1,'$user->rights->banque->lire','! empty($conf->banque->enabled) && (! empty($conf->facture->enabled)) || ! empty($conf->global->MAIN_MENU_CHEQUE_DEPOSIT_ON)',2,'2016-02-07 20:06:23'),(12138,'auguria',1,'','left','accountancy','',12136,NULL,NULL,1,'/compta/paiement/cheque/list.php?leftmenu=checks','','List','bills',1,'$user->rights->banque->lire','! empty($conf->banque->enabled) && (! empty($conf->facture->enabled)) || ! empty($conf->global->MAIN_MENU_CHEQUE_DEPOSIT_ON)',2,'2016-02-07 20:06:23'),(12139,'auguria',1,'','left','accountancy','',12125,NULL,NULL,8,'/compta/facture/stats/index.php?leftmenu=customers_bills','','Statistics','bills',1,'$user->rights->facture->lire','$conf->facture->enabled',2,'2016-02-07 20:06:23'),(12145,'auguria',1,'','left','accountancy','',12130,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,'2016-02-07 20:06:23'),(12146,'auguria',1,'','left','accountancy','',12130,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,'2016-02-07 20:06:23'),(12147,'auguria',1,'','left','accountancy','',12130,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,'2016-02-07 20:06:23'),(12148,'auguria',1,'','left','accountancy','',12130,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,'2016-02-07 20:06:23'),(12325,'auguria',1,'','left','accountancy','orders',10431,NULL,NULL,3,'/commande/list.php?leftmenu=orders&amp;viewstatut=3','','MenuOrdersToBill','orders',0,'$user->rights->commande->lire','$conf->commande->enabled',0,'2016-02-07 20:06:23'),(12425,'auguria',1,'','left','accountancy','donations',10431,NULL,NULL,4,'/don/index.php?leftmenu=donations&amp;mainmenu=accountancy','','Donations','donations',0,'$user->rights->don->lire','$conf->don->enabled',2,'2016-02-07 20:06:23'),(12426,'auguria',1,'','left','accountancy','',12425,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,'2016-02-07 20:06:23'),(12427,'auguria',1,'','left','accountancy','',12425,NULL,NULL,1,'/don/list.php?leftmenu=donations&amp;mainmenu=accountancy','','List','donations',1,'$user->rights->don->lire','$conf->don->enabled && $leftmenu==\"donations\"',2,'2016-02-07 20:06:23'),(12525,'auguria',1,'','left','accountancy','tripsandexpenses',10440,NULL,NULL,5,'/compta/deplacement/index.php?leftmenu=tripsandexpenses','','TripsAndExpenses','trips',0,'$user->rights->deplacement->lire','$conf->deplacement->enabled',0,'2016-02-07 20:06:23'),(12526,'auguria',1,'','left','accountancy','',12525,NULL,NULL,1,'/compta/deplacement/card.php?action=create&amp;leftmenu=tripsandexpenses','','New','trips',1,'$user->rights->deplacement->creer','$conf->deplacement->enabled',0,'2016-02-07 20:06:23'),(12527,'auguria',1,'','left','accountancy','',12525,NULL,NULL,2,'/compta/deplacement/list.php?leftmenu=tripsandexpenses','','List','trips',1,'$user->rights->deplacement->lire','$conf->deplacement->enabled',0,'2016-02-07 20:06:23'),(12528,'auguria',1,'','left','accountancy','',12525,NULL,NULL,2,'/compta/deplacement/stats/index.php?leftmenu=tripsandexpenses','','Statistics','trips',1,'$user->rights->deplacement->lire','$conf->deplacement->enabled',0,'2016-02-07 20:06:23'),(12625,'auguria',1,'','left','accountancy','tax',10431,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,'2016-02-07 20:06:23'),(12635,'auguria',1,'','left','accountancy','tax_sal',12625,NULL,NULL,1,'/compta/salaries/index.php?leftmenu=tax_salary&amp;mainmenu=accountancy','','Salaries','salaries',1,'$user->rights->salaries->read','$conf->salaries->enabled',0,'2016-02-07 20:06:23'),(12636,'auguria',1,'','left','accountancy','',12635,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,'2016-02-07 20:06:23'),(12637,'auguria',1,'','left','accountancy','',12635,NULL,NULL,3,'/compta/salaries/index.php?leftmenu=tax_salary','','Payments','companies',2,'$user->rights->salaries->read','$conf->salaries->enabled && $leftmenu==\"tax_salary\"',0,'2016-02-07 20:06:23'),(12645,'auguria',1,'','left','accountancy','tax_loan',12625,NULL,NULL,1,'/loan/index.php?leftmenu=tax_loan&amp;mainmenu=accountancy','','Loans','loan',1,'$user->rights->loan->read','$conf->loan->enabled',0,'2016-02-07 20:06:23'),(12646,'auguria',1,'','left','accountancy','',12645,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,'2016-02-07 20:06:23'),(12647,'auguria',1,'','left','accountancy','',12645,NULL,NULL,3,'/loan/index.php?leftmenu=tax_loan','','Payments','companies',2,'$user->rights->loan->read','$conf->loan->enabled && $leftmenu==\"tax_loan\"',0,'2016-02-07 20:06:23'),(12648,'auguria',1,'','left','accountancy','',12645,NULL,NULL,4,'/loan/calc.php?leftmenu=tax_loan','','Calculator','companies',2,'$user->rights->loan->calc','$conf->loan->enabled && $leftmenu==\"tax_loan\"',0,'2016-02-07 20:06:23'),(12675,'auguria',1,'','left','accountancy','tax_social',12625,NULL,NULL,1,'/compta/sociales/index.php?leftmenu=tax_social','','SocialContributions','',1,'$user->rights->tax->charges->lire','$conf->tax->enabled',0,'2016-02-07 20:06:23'),(12676,'auguria',1,'','left','accountancy','',12675,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,'2016-02-07 20:06:23'),(12677,'auguria',1,'','left','accountancy','',12675,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,'2016-02-07 20:06:23'),(12725,'auguria',1,'','left','accountancy','tax_vat',12625,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,'2016-02-07 20:06:23'),(12726,'auguria',1,'','left','accountancy','',12725,NULL,NULL,0,'/compta/tva/card.php?leftmenu=tax_vat&amp;action=create','','NewPayment','companies',2,'$user->rights->tax->charges->creer','$conf->tax->enabled && empty($conf->global->TAX_DISABLE_VAT_MENUS) && $leftmenu==\"tax_vat\"',0,'2016-02-07 20:06:23'),(12727,'auguria',1,'','left','accountancy','',12725,NULL,NULL,1,'/compta/tva/reglement.php?leftmenu=tax_vat','','Payments','companies',2,'$user->rights->tax->charges->lire','$conf->tax->enabled && empty($conf->global->TAX_DISABLE_VAT_MENUS) && $leftmenu==\"tax_vat\"',0,'2016-02-07 20:06:23'),(12728,'auguria',1,'','left','accountancy','',12725,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,'2016-02-07 20:06:23'),(12729,'auguria',1,'','left','accountancy','',12725,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,'2016-02-07 20:06:23'),(12825,'auguria',1,'','left','accountancy','ventil_customer',10431,NULL,NULL,8,'/accountancy/customer/index.php?leftmenu=ventil_customer','','CustomersVentilation','accountancy',0,'$user->rights->accounting->ventilation->read','$conf->accounting->enabled',0,'2016-02-07 20:06:23'),(12826,'auguria',1,'','left','accountancy','',12825,NULL,NULL,0,'/accountancy/customer/list.php','','ToDispatch','accountancy',1,'$user->rights->accounting->ventilation->dispatch','$conf->accounting->enabled && $leftmenu==\"ventil_customer\"',0,'2016-02-07 20:06:23'),(12827,'auguria',1,'','left','accountancy','',12825,NULL,NULL,1,'/accountancy/customer/lines.php','','Dispatched','accountancy',1,'$user->rights->accounting->ventilation->read','$conf->accounting->enabled && $leftmenu==\"ventil_customer\"',0,'2016-02-07 20:06:23'),(12835,'auguria',1,'','left','accountancy','ventil_supplier',10431,NULL,NULL,9,'/accountancy/supplier/index.php?leftmenu=ventil_supplier','','SuppliersVentilation','accountancy',0,'$user->rights->accounting->ventilation->read','$conf->accounting->enabled && $conf->fournisseur->enabled',0,'2016-02-07 20:06:23'),(12836,'auguria',1,'','left','accountancy','',12835,NULL,NULL,0,'/accountancy/supplier/list.php','','ToDispatch','accountancy',1,'$user->rights->accounting->ventilation->dispatch','$conf->accounting->enabled && $conf->fournisseur->enabled && $leftmenu==\"ventil_supplier\"',0,'2016-02-07 20:06:23'),(12837,'auguria',1,'','left','accountancy','',12835,NULL,NULL,1,'/accountancy/supplier/lines.php','','Dispatched','accountancy',1,'$user->rights->accounting->ventilation->read','$conf->accounting->enabled && $conf->fournisseur->enabled && $leftmenu==\"ventil_supplier\"',0,'2016-02-07 20:06:23'),(12925,'auguria',1,'','left','accountancy','withdraw',10439,NULL,NULL,9,'/compta/prelevement/index.php?leftmenu=withdraw&amp;mainmenu=bank','','StandingOrders','withdrawals',0,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled',2,'2016-02-07 20:06:23'),(12927,'auguria',1,'','left','accountancy','',12925,NULL,NULL,0,'/compta/prelevement/create.php?leftmenu=withdraw','','NewStandingOrder','withdrawals',1,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled && $leftmenu==\"withdraw\"',2,'2016-02-07 20:06:23'),(12928,'auguria',1,'','left','accountancy','',12925,NULL,NULL,2,'/compta/prelevement/bons.php?leftmenu=withdraw','','WithdrawalsReceipts','withdrawals',1,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled && $leftmenu==\"withdraw\"',2,'2016-02-07 20:06:23'),(12929,'auguria',1,'','left','accountancy','',12925,NULL,NULL,3,'/compta/prelevement/list.php?leftmenu=withdraw','','WithdrawalsLines','withdrawals',1,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled && $leftmenu==\"withdraw\"',2,'2016-02-07 20:06:23'),(12931,'auguria',1,'','left','accountancy','',12925,NULL,NULL,5,'/compta/prelevement/rejets.php?leftmenu=withdraw','','Rejects','withdrawals',1,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled && $leftmenu==\"withdraw\"',2,'2016-02-07 20:06:23'),(12932,'auguria',1,'','left','accountancy','',12925,NULL,NULL,6,'/compta/prelevement/stats.php?leftmenu=withdraw','','Statistics','withdrawals',1,'$user->rights->prelevement->bons->lire','$conf->prelevement->enabled && $leftmenu==\"withdraw\"',2,'2016-02-07 20:06:23'),(13025,'auguria',1,'','left','accountancy','bank',10439,NULL,NULL,1,'/compta/bank/index.php?leftmenu=bank&amp;mainmenu=bank','','MenuBankCash','banks',0,'$user->rights->banque->lire','$conf->banque->enabled',0,'2016-02-07 20:06:23'),(13026,'auguria',1,'','left','accountancy','',13025,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,'2016-02-07 20:06:23'),(13027,'auguria',1,'','left','accountancy','',13025,NULL,NULL,1,'/compta/bank/categ.php?leftmenu=bank','','Rubriques','categories',1,'$user->rights->banque->configurer','$conf->banque->enabled && ($leftmenu==\"bank\" || $leftmenu==\"checks\" || $leftmenu==\"withdraw\")',0,'2016-02-07 20:06:23'),(13028,'auguria',1,'','left','accountancy','',13025,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,'2016-02-07 20:06:23'),(13029,'auguria',1,'','left','accountancy','',13025,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,'2016-02-07 20:06:23'),(13031,'auguria',1,'','left','accountancy','',13025,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,'2016-02-07 20:06:23'),(13125,'auguria',1,'','left','accountancy','ca',10431,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 || $conf->accounting->enabled',0,'2016-02-07 20:06:23'),(13126,'auguria',1,'','left','accountancy','',13125,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 || $conf->accounting->enabled && $leftmenu==\"ca\"',0,'2016-02-07 20:06:23'),(13127,'auguria',1,'','left','accountancy','',13126,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 || $conf->accounting->enabled && $leftmenu==\"ca\"',0,'2016-02-07 20:06:23'),(13128,'auguria',1,'','left','accountancy','',13125,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 || $conf->accounting->enabled && $leftmenu==\"ca\"',0,'2016-02-07 20:06:23'),(13129,'auguria',1,'','left','accountancy','',13128,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 || $conf->accounting->enabled && $leftmenu==\"ca\"',0,'2016-02-07 20:06:23'),(13130,'auguria',1,'','left','accountancy','',13128,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 || $conf->accounting->enabled && $leftmenu==\"ca\"',0,'2016-02-07 20:06:23'),(13131,'auguria',1,'','left','accountancy','',13125,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,'2016-02-07 20:06:23'),(13132,'auguria',1,'','left','accountancy','',13125,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,'2016-02-07 20:06:23'),(13133,'auguria',1,'','left','accountancy','',13128,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 || $conf->accounting->enabled && $leftmenu==\"ca\"',0,'2016-02-07 20:06:23'),(13145,'auguria',1,'','left','accountancy','bookkeeping',10431,NULL,NULL,12,'/accountancy/bookkeeping/list.php?leftmenu=bookkeeping','','Bookkeeping','accountancy',0,'$user->rights->accounting->mouvements->lire','$conf->accounting->enabled',0,'2016-02-07 20:06:23'),(13146,'auguria',1,'','left','accountancy','',13145,NULL,NULL,0,'/accountancy/bookkeeping/listbyyear.php','','ByYear','accountancy',1,'$user->rights->accounting->mouvements->lire','$conf->accounting->enabled && $leftmenu==\"bookkeeping\"',0,'2016-02-07 20:06:23'),(13147,'auguria',1,'','left','accountancy','',13145,NULL,NULL,1,'/accountancy/bookkeeping/balancebymonth.php','','AccountBalanceByMonth','accountancy',1,'$user->rights->accounting->mouvements->lire','$conf->accounting->enabled && $leftmenu==\"bookkeeping\"',0,'2016-02-07 20:06:23'),(13175,'auguria',1,'','left','home','',10431,NULL,NULL,20,'/accountancy/admin/fiscalyear.php?leftmenu=setup','','Fiscalyear','accountancy',1,'$user->rights->accounting->fiscalyear','$conf->accounting->enabled',2,'2016-02-07 20:06:23'),(13176,'auguria',1,'','left','home','',10431,NULL,NULL,21,'/accountancy/admin/account.php?mainmenu=accountancy','','Chartofaccounts','accountancy',1,'$user->rights->accounting->chartofaccount','$conf->accounting->enabled',2,'2016-02-07 20:06:23'),(13225,'auguria',1,'','left','products','product',10428,NULL,NULL,0,'/product/index.php?leftmenu=product&amp;type=0','','Products','products',0,'$user->rights->produit->lire','$conf->product->enabled',2,'2016-02-07 20:06:23'),(13226,'auguria',1,'','left','products','',13225,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,'2016-02-07 20:06:23'),(13227,'auguria',1,'','left','products','',13225,NULL,NULL,1,'/product/list.php?leftmenu=product&amp;type=0','','List','products',1,'$user->rights->produit->lire','$conf->product->enabled',2,'2016-02-07 20:06:23'),(13228,'auguria',1,'','left','products','',13225,NULL,NULL,4,'/product/reassort.php?type=0','','Stocks','products',1,'$user->rights->produit->lire && $user->rights->stock->lire','$conf->product->enabled',2,'2016-02-07 20:06:23'),(13229,'auguria',1,'','left','products','',13225,NULL,NULL,6,'/product/popuprop.php?leftmenu=stats&amp;type=0','','Statistics','main',1,'$user->rights->produit->lire','$conf->propal->enabled',2,'2016-02-07 20:06:23'),(13230,'auguria',1,'','left','products','',13225,NULL,NULL,5,'/product/reassortlot.php?type=0','','StocksByLotSerial','products',1,'$user->rights->produit->lire && $user->rights->stock->lire','$conf->productbatch->enabled',2,'2016-02-07 20:06:23'),(13325,'auguria',1,'','left','products','service',10428,NULL,NULL,1,'/product/index.php?leftmenu=service&amp;type=1','','Services','products',0,'$user->rights->service->lire','$conf->service->enabled',2,'2016-02-07 20:06:23'),(13326,'auguria',1,'','left','products','',13325,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,'2016-02-07 20:06:23'),(13327,'auguria',1,'','left','products','',13325,NULL,NULL,1,'/product/list.php?leftmenu=service&amp;type=1','','List','products',1,'$user->rights->service->lire','$conf->service->enabled',2,'2016-02-07 20:06:23'),(13328,'auguria',1,'','left','products','',13325,NULL,NULL,5,'/product/popuprop.php?leftmenu=stats&amp;type=1','','Statistics','main',1,'$user->rights->service->lire','$conf->propal->enabled',2,'2016-02-07 20:06:23'),(13525,'auguria',1,'','left','products','stock',10428,NULL,NULL,3,'/product/stock/index.php?leftmenu=stock','','Stock','stocks',0,'$user->rights->stock->lire','$conf->stock->enabled',2,'2016-02-07 20:06:23'),(13526,'auguria',1,'','left','products','',13525,NULL,NULL,0,'/product/stock/card.php?action=create','','MenuNewWarehouse','stocks',1,'$user->rights->stock->creer','$conf->stock->enabled',2,'2016-02-07 20:06:23'),(13527,'auguria',1,'','left','products','',13525,NULL,NULL,1,'/product/stock/list.php','','List','stocks',1,'$user->rights->stock->lire','$conf->stock->enabled',2,'2016-02-07 20:06:23'),(13529,'auguria',1,'','left','products','',13525,NULL,NULL,3,'/product/stock/mouvement.php','','Movements','stocks',1,'$user->rights->stock->mouvement->lire','$conf->stock->enabled',2,'2016-02-07 20:06:23'),(13530,'auguria',1,'','left','products','',13525,NULL,NULL,4,'/product/stock/replenish.php','','Replenishments','stocks',1,'$user->rights->stock->mouvement->creer && $user->rights->fournisseur->lire','$conf->stock->enabled && $conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(13531,'auguria',1,'','left','products','',13525,NULL,NULL,5,'/product/stock/massstockmove.php','','StockTransfer','stocks',1,'$user->rights->stock->mouvement->creer','$conf->stock->enabled',2,'2016-02-07 20:06:23'),(13625,'auguria',1,'','left','products','cat',10428,NULL,NULL,4,'/categories/index.php?leftmenu=cat&amp;type=0','','Categories','categories',0,'$user->rights->categorie->lire','$conf->categorie->enabled',2,'2016-02-07 20:06:23'),(13626,'auguria',1,'','left','products','',13625,NULL,NULL,0,'/categories/card.php?action=create&amp;type=0','','NewCategory','categories',1,'$user->rights->categorie->creer','$conf->categorie->enabled',2,'2016-02-07 20:06:23'),(14025,'auguria',1,'','left','project','projects',10432,NULL,NULL,0,'/projet/index.php?leftmenu=projects','','Projects','projects',0,'$user->rights->projet->lire','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14026,'auguria',1,'','left','project','',14025,NULL,NULL,1,'/projet/card.php?leftmenu=projects&amp;action=create','','NewProject','projects',1,'$user->rights->projet->creer','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14027,'auguria',1,'','left','project','',14025,NULL,NULL,2,'/projet/list.php?leftmenu=projects','','List','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14035,'auguria',1,'','left','project','myprojects',10432,NULL,NULL,0,'/projet/index.php?leftmenu=projects&amp;mode=mine','','MyProjects','projects',0,'$user->rights->projet->lire','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14036,'auguria',1,'','left','project','',14035,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,'2016-02-07 20:06:23'),(14037,'auguria',1,'','left','project','',14035,NULL,NULL,2,'/projet/list.php?leftmenu=projects&amp;mode=mine','','List','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14125,'auguria',1,'','left','project','',10432,NULL,NULL,0,'/projet/activity/index.php?leftmenu=projects','','Activities','projects',0,'$user->rights->projet->lire','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14126,'auguria',1,'','left','project','',14125,NULL,NULL,1,'/projet/tasks.php?leftmenu=projects&amp;action=create','','NewTask','projects',1,'$user->rights->projet->creer','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14127,'auguria',1,'','left','project','',14125,NULL,NULL,2,'/projet/tasks/index.php?leftmenu=projects','','List','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14128,'auguria',1,'','left','project','',14125,NULL,NULL,3,'/projet/activity/perweek.php?leftmenu=projects','','NewTimeSpent','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14225,'auguria',1,'','left','project','',10432,NULL,NULL,0,'/projet/activity/index.php?leftmenu=projects&amp;mode=mine','','MyActivities','projects',0,'$user->rights->projet->lire','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14226,'auguria',1,'','left','project','',14225,NULL,NULL,1,'/projet/tasks.php?leftmenu=projects&amp;action=create&amp;mode=mine','','NewTask','projects',1,'$user->rights->projet->creer','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14227,'auguria',1,'','left','project','',14225,NULL,NULL,2,'/projet/tasks/index.php?leftmenu=projects&amp;mode=mine','','List','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14228,'auguria',1,'','left','project','',14225,NULL,NULL,3,'/projet/activity/perweek.php?leftmenu=projects&amp;mode=mine','','NewTimeSpent','projects',1,'$user->rights->projet->lire','$conf->projet->enabled',2,'2016-02-07 20:06:23'),(14325,'auguria',1,'','left','tools','mailing',10433,NULL,NULL,0,'/comm/mailing/index.php?leftmenu=mailing','','EMailings','mails',0,'$user->rights->mailing->lire','$conf->mailing->enabled',0,'2016-02-07 20:06:23'),(14326,'auguria',1,'','left','tools','',14325,NULL,NULL,0,'/comm/mailing/card.php?leftmenu=mailing&amp;action=create','','NewMailing','mails',1,'$user->rights->mailing->creer','$conf->mailing->enabled',0,'2016-02-07 20:06:23'),(14327,'auguria',1,'','left','tools','',14325,NULL,NULL,1,'/comm/mailing/list.php?leftmenu=mailing','','List','mails',1,'$user->rights->mailing->lire','$conf->mailing->enabled',0,'2016-02-07 20:06:23'),(14525,'auguria',1,'','left','tools','export',10433,NULL,NULL,2,'/exports/index.php?leftmenu=export','','FormatedExport','exports',0,'$user->rights->export->lire','$conf->export->enabled',2,'2016-02-07 20:06:23'),(14526,'auguria',1,'','left','tools','',14525,NULL,NULL,0,'/exports/export.php?leftmenu=export','','NewExport','exports',1,'$user->rights->export->creer','$conf->export->enabled',2,'2016-02-07 20:06:23'),(14555,'auguria',1,'','left','tools','import',10433,NULL,NULL,2,'/imports/index.php?leftmenu=import','','FormatedImport','exports',0,'$user->rights->import->run','$conf->import->enabled',2,'2016-02-07 20:06:23'),(14556,'auguria',1,'','left','tools','',14555,NULL,NULL,0,'/imports/import.php?leftmenu=import','','NewImport','exports',1,'$user->rights->import->run','$conf->import->enabled',2,'2016-02-07 20:06:23'),(14625,'auguria',1,'','left','members','members',10438,NULL,NULL,0,'/adherents/index.php?leftmenu=members&amp;mainmenu=members','','Members','members',0,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14626,'auguria',1,'','left','members','',14625,NULL,NULL,0,'/adherents/card.php?leftmenu=members&amp;action=create','','NewMember','members',1,'$user->rights->adherent->creer','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14627,'auguria',1,'','left','members','',14625,NULL,NULL,1,'/adherents/list.php','','List','members',1,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14628,'auguria',1,'','left','members','',14627,NULL,NULL,2,'/adherents/list.php?leftmenu=members&amp;statut=-1','','MenuMembersToValidate','members',2,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14629,'auguria',1,'','left','members','',14627,NULL,NULL,3,'/adherents/list.php?leftmenu=members&amp;statut=1','','MenuMembersValidated','members',2,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14630,'auguria',1,'','left','members','',14627,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,'2016-02-07 20:06:23'),(14631,'auguria',1,'','left','members','',14627,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,'2016-02-07 20:06:23'),(14632,'auguria',1,'','left','members','',14627,NULL,NULL,6,'/adherents/list.php?leftmenu=members&amp;statut=0','','MenuMembersResiliated','members',2,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14633,'auguria',1,'','left','members','',14625,NULL,NULL,7,'/adherents/stats/geo.php?leftmenu=members&amp;mode=memberbycountry','','MenuMembersStats','members',1,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14725,'auguria',1,'','left','members','',10438,NULL,NULL,1,'/adherents/index.php?leftmenu=members&amp;mainmenu=members','','Subscriptions','compta',0,'$user->rights->adherent->cotisation->lire','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14726,'auguria',1,'','left','members','',14725,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,'2016-02-07 20:06:23'),(14727,'auguria',1,'','left','members','',14725,NULL,NULL,1,'/adherents/cotisations.php?leftmenu=members','','List','compta',1,'$user->rights->adherent->cotisation->lire','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14728,'auguria',1,'','left','members','',14725,NULL,NULL,7,'/adherents/stats/index.php?leftmenu=members','','MenuMembersStats','members',1,'$user->rights->adherent->lire','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14925,'auguria',1,'','left','members','export',10438,NULL,NULL,3,'/adherents/index.php?leftmenu=export&amp;mainmenu=members','','Exports','members',0,'$user->rights->adherent->export','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14926,'auguria',1,'','left','members','',14925,NULL,NULL,0,'/exports/index.php?leftmenu=export','','Datas','members',1,'$user->rights->adherent->export','$conf->adherent->enabled && $conf->export->enabled',2,'2016-02-07 20:06:23'),(14927,'auguria',1,'','left','members','',14925,NULL,NULL,1,'/adherents/htpasswd.php?leftmenu=export','','Filehtpasswd','members',1,'$user->rights->adherent->export','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(14928,'auguria',1,'','left','members','',14925,NULL,NULL,2,'/adherents/cartes/carte.php?leftmenu=export','','MembersCards','members',1,'$user->rights->adherent->export','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(15125,'auguria',1,'','left','members','setup',10438,NULL,NULL,5,'/adherents/type.php?leftmenu=setup&amp;mainmenu=members','','MembersTypes','members',0,'$user->rights->adherent->configurer','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(15126,'auguria',1,'','left','members','',15125,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,'2016-02-07 20:06:23'),(15127,'auguria',1,'','left','members','',15125,NULL,NULL,1,'/adherents/type.php?leftmenu=setup&amp;mainmenu=members','','List','members',1,'$user->rights->adherent->configurer','$conf->adherent->enabled',2,'2016-02-07 20:06:23'),(15425,'auguria',1,'','left','hrm','hrm',10440,NULL,NULL,1,'/holiday/list.php?&leftmenu=hrm','','CPTitreMenu','holiday',0,'$user->rights->holiday->read','$conf->holiday->enabled',0,'2016-02-07 20:06:23'),(15426,'auguria',1,'','left','hrm','',15425,NULL,NULL,1,'/holiday/card.php?&action=request','','MenuAddCP','holiday',1,'$user->rights->holiday->write','$conf->holiday->enabled',0,'2016-02-07 20:06:23'),(15427,'auguria',1,'','left','hrm','',15425,NULL,NULL,1,'/holiday/list.php?&leftmenu=hrm','','List','holiday',1,'$user->rights->holiday->read','$conf->holiday->enabled',0,'2016-02-07 20:06:23'),(15428,'auguria',1,'','left','hrm','',15427,NULL,NULL,1,'/holiday/list.php?select_statut=2&leftmenu=hrm','','ListToApprove','trips',2,'$user->rights->holiday->read','$conf->holiday->enabled',0,'2016-02-07 20:06:23'),(15429,'auguria',1,'','left','hrm','',15425,NULL,NULL,2,'/holiday/define_holiday.php?&action=request','','MenuConfCP','holiday',1,'$user->rights->holiday->define_holiday','$conf->holiday->enabled',0,'2016-02-07 20:06:23'),(15430,'auguria',1,'','left','hrm','',15425,NULL,NULL,3,'/holiday/view_log.php?&action=request','','MenuLogCP','holiday',1,'$user->rights->holiday->define_holiday','$conf->holiday->enabled',0,'2016-02-07 20:06:23'),(15431,'auguria',1,'','left','hrm','',15425,NULL,NULL,4,'/holiday/month_report.php?&action=request','','MenuReportMonth','holiday',1,'$user->rights->holiday->define_holiday','$conf->holiday->enabled',0,'2016-02-07 20:06:23'),(15525,'auguria',1,'','left','commercial','orders_suppliers',10430,NULL,NULL,6,'/fourn/commande/index.php?leftmenu=orders_suppliers','','SuppliersOrders','orders',0,'$user->rights->fournisseur->commande->lire','$conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(15526,'auguria',1,'','left','commercial','',15525,NULL,NULL,0,'/fourn/commande/card.php?action=create&amp;leftmenu=orders_suppliers','','NewOrder','orders',1,'$user->rights->fournisseur->commande->creer','$conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(15527,'auguria',1,'','left','commercial','',15525,NULL,NULL,1,'/fourn/commande/list.php?leftmenu=orders_suppliers&amp;viewstatut=0','','List','orders',1,'$user->rights->fournisseur->commande->lire','$conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(15533,'auguria',1,'','left','commercial','',15525,NULL,NULL,7,'/commande/stats/index.php?leftmenu=orders_suppliers&amp;mode=supplier','','Statistics','orders',1,'$user->rights->fournisseur->commande->lire','$conf->fournisseur->enabled',2,'2016-02-07 20:06:23'),(15625,'auguria',1,'','left','members','cat',10438,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,'2016-02-07 20:06:23'),(15626,'auguria',1,'','left','members','',15625,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,'2016-02-07 20:06:23');

--
-- 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,
  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) NOT 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_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_sondage`
--

CREATE TABLE `llx_opensurvey_sondage` (
  `id_sondage` varchar(16) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `commentaires` text,
  `mail_admin` varchar(128) DEFAULT NULL,
  `nom_admin` varchar(64) DEFAULT NULL,
  `fk_user_creat` int(11) NOT NULL,
  `titre` text NOT NULL,
  `date_fin` datetime NOT NULL,
  `format` varchar(2) NOT NULL,
  `mailsonde` tinyint(4) NOT NULL DEFAULT '0',
  `allow_comments` tinyint(4) NOT NULL DEFAULT '1',
  `allow_spy` tinyint(4) NOT NULL DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sujet` text,
  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_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_order_merged_pdf`
--

CREATE TABLE `llx_order_merged_pdf` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_commande` int(11) NOT NULL,
  `file_name` varchar(200) NOT 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_order_merged_pdf`
--


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

CREATE TABLE `llx_paiement` (
  `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,
  `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',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_paiement` (`rowid`, `entity`, `datec`, `tms`, `datep`, `amount`, `fk_paiement`, `num_paiement`, `note`, `fk_bank`, `fk_user_creat`, `fk_user_modif`, `statut`, `fk_export_compta`) VALUES (1,1,'2016-06-21 14:17:15','2016-06-21 12:17:15','2016-06-21 12:00:00',18768.24000000,2,'','',2,4,NULL,0,0),(2,1,'2016-06-24 14:56:26','2016-06-24 12:56:26','2016-06-24 12:00:00',79464.00000000,2,'','',3,4,NULL,0,0),(3,1,'2016-06-24 15:02:17','2016-06-24 13:02:17','2016-06-24 12:00:00',47520.00000000,2,'','',4,4,NULL,0,0),(4,1,'2016-06-24 15:08:25','2016-06-24 13:08:25','2016-06-24 12:00:00',-3600.00000000,2,'','',5,4,NULL,0,0),(5,1,'2016-06-24 15:09:08','2016-06-24 13:09:08','2016-06-24 12:00:00',14400.00000000,2,'','',6,4,NULL,0,0),(6,1,'2016-06-24 15:12:13','2016-06-24 13:12:13','2016-06-24 12:00:00',12096.00000000,2,'','',7,4,NULL,0,0),(7,1,'2016-06-24 15:16:38','2016-06-24 13:16:38','2016-06-24 12:00:00',3600.00000000,2,'','',8,4,NULL,0,0),(8,1,'2016-06-24 15:20:34','2016-06-24 13:20:34','2016-06-24 12:00:00',9928.80000000,2,'','',9,4,NULL,0,0),(9,1,'2016-06-24 15:23:15','2016-06-24 13:23:15','2016-05-30 12:00:00',1560.00000000,2,'','',10,4,NULL,0,0),(10,1,'2016-07-01 11:38:58','2016-07-01 09:38:58','2016-07-01 12:00:00',2340.00000000,2,'','',11,4,NULL,0,0),(11,1,'2016-07-29 14:22:21','2016-07-29 12:22:21','2016-07-25 12:00:00',40132.32000000,2,'','',12,4,NULL,0,0),(12,1,'2016-09-02 14:21:01','2016-09-02 12:21:01','2016-08-05 12:00:00',16135.56000000,2,'','',13,4,NULL,0,0),(13,1,'2016-09-02 14:24:35','2016-09-02 12:24:35','2016-08-17 12:00:00',37152.00000000,2,'','',14,4,NULL,0,0),(14,1,'2016-09-16 14:40:31','2016-09-16 12:40:31','2016-09-12 12:00:00',19580.40000000,2,'','',15,4,NULL,0,0),(15,1,'2016-09-16 14:41:33','2016-09-16 12:41:33','2016-09-16 12:00:00',170.88000000,2,'','',16,4,NULL,0,0),(16,1,'2016-09-30 11:22:56','2016-09-30 09:22:56','2016-09-26 12:00:00',12384.00000000,2,'','',17,4,NULL,0,0),(17,1,'2016-10-13 11:30:08','2016-10-13 09:30:09','2016-10-13 12:00:00',14428.80000000,2,'','',18,4,NULL,0,0),(18,1,'2016-10-13 11:30:50','2016-10-13 09:30:50','2016-10-07 12:00:00',5160.00000000,2,'','',19,4,NULL,0,0),(19,1,'2016-11-17 15:11:24','2016-11-17 14:11:24','2016-11-04 12:00:00',12384.00000000,2,'','',20,4,NULL,0,0),(20,1,'2016-11-17 15:12:42','2016-11-17 14:12:42','2016-11-11 12:00:00',26672.88000000,2,'','',21,4,NULL,0,0),(21,1,'2016-12-23 10:45:38','2016-12-23 09:45:38','2016-12-12 12:00:00',12384.00000000,2,'','',22,4,NULL,0,0),(22,1,'2017-01-06 11:15:36','2017-01-06 10:15:36','2017-01-06 12:00:00',12384.00000000,2,'','',23,4,NULL,0,0),(23,1,'2017-01-16 08:36:48','2017-01-16 07:36:48','2017-01-14 12:00:00',39485.16000000,2,'','',24,4,NULL,0,0),(24,1,'2017-03-03 15:38:07','2017-03-03 14:38:07','2017-02-06 12:00:00',6239.64000000,2,'','',25,4,NULL,0,0),(25,1,'2017-03-03 15:39:09','2017-03-03 14:39:09','2017-02-15 12:00:00',24348.12000000,2,'','',26,4,NULL,0,0),(26,1,'2017-03-03 15:40:51','2017-03-03 14:40:51','2017-03-03 12:00:00',58788.00000000,2,'','',27,4,NULL,0,0),(27,1,'2017-03-15 08:57:12','2017-03-15 07:57:12','2017-03-15 12:00:00',34932.00000000,2,'','',28,4,NULL,0,0),(28,1,'2017-04-07 18:07:19','2017-04-07 16:07:19','2017-04-07 12:00:00',30408.00000000,2,'','',29,4,NULL,0,0),(29,1,'2017-05-18 10:28:14','2017-05-18 08:28:14','2017-05-16 12:00:00',22479.00000000,2,'','',30,4,NULL,0,0),(30,1,'2017-05-18 10:31:17','2017-05-18 08:31:17','2017-05-12 12:00:00',7800.00000000,2,'','',31,4,NULL,0,0),(31,1,'2017-05-18 10:51:08','2017-05-18 08:51:08','2017-04-10 12:00:00',20070.00000000,2,'','',32,4,NULL,0,0),(32,1,'2017-06-09 15:59:32','2017-06-09 13:59:32','2017-06-09 12:00:00',7800.00000000,2,'','',33,4,NULL,0,0),(33,1,'2017-06-16 10:25:43','2017-06-16 08:25:43','2017-06-16 12:00:00',11418.00000000,2,'','',34,4,NULL,0,0),(34,1,'2017-06-16 10:26:59','2017-06-16 08:27:00','2017-06-16 12:00:00',35250.00000000,2,'','',35,4,NULL,0,0),(35,1,'2017-07-07 09:54:02','2017-07-07 07:54:02','2017-06-30 12:00:00',3876.00000000,2,'','',36,4,NULL,0,0),(36,1,'2017-07-07 09:54:53','2017-07-07 07:54:53','2017-07-07 12:00:00',6192.00000000,2,'','',37,4,NULL,0,0),(37,1,'2017-07-12 11:26:57','2017-07-12 09:26:57','2017-07-10 12:00:00',35652.00000000,2,'','',38,4,NULL,0,0),(38,1,'2017-07-25 08:49:13','2017-07-25 06:49:14','2017-07-25 12:00:00',11920.80000000,2,'','',39,4,NULL,0,0),(39,1,'2017-09-29 14:57:23','2017-09-29 12:57:23','2017-09-29 12:00:00',41286.00000000,2,'','',40,4,NULL,0,0),(40,1,'2017-09-29 14:59:02','2017-09-29 12:59:02','2017-09-29 12:00:00',17623.08000000,2,'','',41,4,NULL,0,0),(41,1,'2017-09-29 14:59:42','2017-09-29 12:59:42','2017-09-29 12:00:00',1200.00000000,2,'','',42,4,NULL,0,0),(42,1,'2017-09-29 15:05:55','2017-09-29 13:05:55','2017-09-29 12:00:00',23439.00000000,2,'','',43,4,NULL,0,0),(43,1,'2017-09-29 15:06:49','2017-09-29 13:06:49','2017-09-29 12:00:00',22962.00000000,2,'','',44,4,NULL,0,0),(44,1,'2017-09-29 15:08:16','2017-09-29 13:08:16','2017-09-29 12:00:00',8571.60000000,2,'','',45,4,NULL,0,0),(45,1,'2017-09-29 15:10:08','2017-09-29 13:10:08','2017-09-29 12:00:00',13462.80000000,2,'','',46,4,NULL,0,0),(46,1,'2017-09-29 15:11:23','2017-09-29 13:11:23','2017-09-29 12:00:00',7998.00000000,2,'','',47,4,NULL,0,0),(47,1,'2017-11-14 08:29:59','2017-11-14 07:30:00','2017-11-14 12:00:00',10494.00000000,2,'','',48,4,NULL,0,0),(48,1,'2017-11-14 09:18:49','2017-11-14 08:18:49','2017-11-14 12:00:00',1440.00000000,2,'','',49,4,NULL,0,0),(49,1,'2017-11-21 18:17:56','2017-11-21 17:17:57','2017-11-15 12:00:00',24985.21000000,2,'','',50,4,NULL,0,0),(50,1,'2017-11-21 18:19:52','2017-11-21 17:19:52','2017-11-17 12:00:00',16707.00000000,2,'','',51,4,NULL,0,0),(51,1,'2017-11-21 18:20:32','2017-11-21 17:20:32','2017-11-17 12:00:00',3354.00000000,2,'','',52,4,NULL,0,0),(52,1,'2017-11-22 09:28:54','2017-11-22 08:28:54','2017-10-16 12:00:00',22644.00000000,2,'','',53,4,NULL,0,0),(53,1,'2017-11-22 09:29:44','2017-11-22 08:29:44','2017-10-16 12:00:00',1786.00000000,2,'','',54,4,NULL,0,0),(54,1,'2017-11-22 09:30:40','2017-11-22 08:30:40','2017-10-17 12:00:00',17814.00000000,2,'','',55,4,NULL,0,0),(55,1,'2018-01-17 18:27:50','2018-01-17 17:27:50','2018-01-17 12:00:00',9308.40000000,2,'','',56,4,NULL,0,0),(56,1,'2018-01-17 18:30:06','2018-01-17 17:30:06','2018-01-16 12:00:00',24366.00000000,2,'','',57,4,NULL,0,0),(57,1,'2018-01-17 18:42:34','2018-01-17 17:42:34','2017-12-19 12:00:00',12990.00000000,2,'','',58,4,NULL,0,0),(58,1,'2018-01-17 18:43:57','2018-01-17 17:43:57','2017-12-19 12:00:00',27048.00000000,2,'','',59,4,NULL,0,0),(59,1,'2018-01-18 16:48:18','2018-01-18 15:48:18','2017-12-14 12:00:00',24513.06000000,2,'','',60,4,NULL,0,0),(60,1,'2018-01-31 18:10:21','2018-01-31 17:10:21','2018-01-19 12:00:00',25355.16000000,2,'','',61,4,NULL,0,0),(61,1,'2018-02-13 09:14:12','2018-02-13 08:14:12','2018-02-12 12:00:00',8272.80000000,2,'','',62,4,NULL,0,0),(62,1,'2018-02-13 09:15:40','2018-02-13 08:15:41','2018-02-12 12:00:00',16656.00000000,2,'','',63,4,NULL,0,0),(63,1,'2018-02-13 09:16:40','2018-02-13 08:16:40','2018-02-13 12:00:00',18840.00000000,2,'','',64,4,NULL,0,0),(64,1,'2018-03-16 11:49:27','2018-03-16 10:49:27','2018-03-14 12:00:00',6720.00000000,2,'','',65,4,NULL,0,0),(65,1,'2018-03-16 11:51:27','2018-03-16 10:51:27','2018-03-14 12:00:00',29028.00000000,2,'','',66,4,NULL,0,0),(66,1,'2018-03-16 11:57:21','2018-03-16 10:57:22','2018-03-15 12:00:00',36075.00000000,2,'','',67,4,NULL,0,0),(67,1,'2018-04-09 15:36:42','2018-04-09 13:36:42','2018-04-09 12:00:00',26337.00000000,2,'','',68,4,NULL,0,0),(68,1,'2018-04-09 15:38:08','2018-04-09 13:38:08','2018-04-09 12:00:00',9650.09000000,2,'','',69,4,NULL,0,0),(69,1,'2018-05-15 10:51:40','2018-05-15 08:51:41','2018-05-15 12:00:00',4116.00000000,2,'','',70,4,NULL,0,0),(70,1,'2018-05-15 10:54:25','2018-05-15 08:54:25','2018-05-15 12:00:00',32760.00000000,2,'','',71,4,NULL,0,0),(71,1,'2018-05-15 11:26:43','2018-05-15 09:26:43','2018-04-10 12:00:00',8782.80000000,2,'','',72,4,NULL,0,0),(72,1,'2018-05-15 13:43:42','2018-05-15 11:43:42','2018-04-13 12:00:00',19513.15000000,2,'','',73,4,NULL,0,0),(73,1,'2018-07-06 12:02:25','2018-07-06 10:02:25','2018-07-06 12:00:00',7680.00000000,2,'','',74,4,NULL,0,0),(74,1,'2018-07-06 12:04:10','2018-07-06 10:04:10','2018-07-06 12:00:00',37020.00000000,2,'','',75,4,NULL,0,0),(75,1,'2018-07-06 12:05:36','2018-07-06 10:05:36','2018-07-06 12:00:00',25874.42000000,2,'','',76,4,NULL,0,0),(76,1,'2018-07-25 09:30:53','2018-07-25 07:30:53','2018-07-25 12:00:00',50145.00000000,2,'','',77,4,NULL,0,0),(77,1,'2018-07-25 09:32:34','2018-07-25 07:32:35','2018-07-25 12:00:00',29101.20000000,2,'','',78,4,NULL,0,0),(78,1,'2018-07-25 09:33:42','2018-07-25 07:33:42','2018-07-25 12:00:00',10584.00000000,2,'','',79,4,NULL,0,0),(79,1,'2018-08-23 11:41:45','2018-08-23 09:41:46','2018-08-23 12:00:00',29695.39000000,2,'','',80,4,NULL,0,0),(80,1,'2018-08-23 14:26:49','2018-08-23 12:26:49','2018-08-23 12:00:00',8379.23000000,2,'','',81,4,NULL,0,0),(81,1,'2018-09-12 11:00:40','2018-09-12 09:00:40','2018-09-12 12:00:00',18028.80000000,2,'','',82,4,NULL,0,0),(82,1,'2018-09-12 11:01:42','2018-09-12 09:01:42','2018-09-12 12:00:00',29125.80000000,2,'','',83,4,NULL,0,0),(83,1,'2018-09-12 11:02:23','2018-09-12 09:02:23','2018-09-12 12:00:00',9.00000000,2,'','',84,4,NULL,0,0),(84,1,'2018-09-12 11:03:45','2018-09-12 09:03:45','2018-09-12 12:00:00',32661.73000000,2,'','',85,4,NULL,0,0),(85,1,'2018-09-18 17:08:31','2018-09-18 15:08:31','2018-09-18 12:00:00',31074.00000000,2,'','',86,4,NULL,0,0),(86,1,'2018-09-18 17:09:29','2018-09-18 15:09:29','2018-09-18 12:00:00',31374.00000000,2,'','',87,4,NULL,0,0),(87,1,'2018-10-12 13:33:31','2018-10-12 11:33:32','2018-10-12 12:00:00',16758.71000000,2,'','',88,4,NULL,0,0),(88,1,'2018-10-12 13:34:30','2018-10-12 11:34:30','2018-10-12 12:00:00',8592.60000000,2,'','',89,4,NULL,0,0),(89,1,'2018-10-12 16:37:42','2018-10-12 14:37:42','2018-10-12 12:00:00',4857.60000000,2,'','',90,4,NULL,0,0),(90,1,'2018-10-12 16:41:31','2018-10-12 14:41:31','2018-10-12 12:00:00',7536.00000000,2,'','',91,4,NULL,0,0),(91,1,'2018-10-17 15:23:51','2018-10-17 13:23:51','2018-10-17 12:00:00',30756.00000000,2,'','',92,4,NULL,0,0);

--
-- 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',
  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 AUTO_INCREMENT=320 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_paiement_facture` (`rowid`, `fk_paiement`, `fk_facture`, `amount`) VALUES (1,1,28,5896.80000000),(2,1,29,12682.80000000),(3,1,35,188.64000000),(4,2,8,20640.00000000),(5,2,14,21672.00000000),(6,2,20,18576.00000000),(7,2,23,18576.00000000),(8,3,1,3600.00000000),(9,3,5,8064.00000000),(10,3,6,6048.00000000),(11,3,7,8064.00000000),(12,3,9,3600.00000000),(13,3,11,6048.00000000),(14,3,12,6048.00000000),(15,3,13,6048.00000000),(16,4,22,-3600.00000000),(17,5,15,14400.00000000),(18,6,16,6048.00000000),(19,6,18,6048.00000000),(20,7,19,3600.00000000),(21,8,17,4032.00000000),(22,8,21,5896.80000000),(23,9,26,1560.00000000),(24,10,34,2340.00000000),(25,11,24,3600.00000000),(26,11,25,5896.80000000),(27,11,30,6552.00000000),(28,11,31,11289.60000000),(29,11,33,11113.20000000),(30,11,36,1653.60000000),(31,11,37,27.12000000),(32,12,43,16135.56000000),(33,13,27,17544.00000000),(34,13,38,19608.00000000),(35,14,41,11113.20000000),(36,14,42,8467.20000000),(37,15,46,170.88000000),(38,16,39,12384.00000000),(39,17,44,8467.20000000),(40,17,45,5961.60000000),(41,18,47,5160.00000000),(42,19,48,12384.00000000),(43,20,49,10522.80000000),(44,20,50,16135.56000000),(45,20,51,14.52000000),(46,21,52,12384.00000000),(47,22,57,12384.00000000),(48,23,53,21045.60000000),(49,23,54,16135.56000000),(50,23,55,2304.00000000),(51,24,56,2880.00000000),(52,24,59,2640.00000000),(53,24,60,719.64000000),(54,25,63,19581.60000000),(55,25,64,4608.00000000),(56,25,65,158.52000000),(57,26,58,2520.00000000),(58,26,61,10320.00000000),(59,26,62,14280.00000000),(60,26,66,17220.00000000),(61,26,67,14448.00000000),(62,27,69,13332.00000000),(63,27,71,21600.00000000),(64,28,72,14448.00000000),(65,28,73,15960.00000000),(66,29,79,13779.00000000),(67,29,80,5220.00000000),(68,29,81,3480.00000000),(69,30,77,7800.00000000),(70,31,68,7482.00000000),(71,31,74,696.00000000),(72,31,75,1044.00000000),(73,31,76,10848.00000000),(74,32,84,7800.00000000),(75,33,86,6240.00000000),(76,33,87,588.00000000),(77,33,88,4104.00000000),(78,33,89,486.00000000),(79,34,78,7200.00000000),(80,34,82,10812.00000000),(81,34,83,6438.00000000),(82,34,85,10800.00000000),(83,35,90,3876.00000000),(84,36,91,6192.00000000),(85,37,92,18000.00000000),(86,37,102,12084.00000000),(87,37,103,5568.00000000),(88,38,97,4531.20000000),(89,38,98,480.00000000),(90,38,99,4144.80000000),(91,38,100,480.00000000),(92,38,101,2284.80000000),(93,39,93,10080.00000000),(94,39,94,1104.00000000),(95,39,95,8664.00000000),(96,39,96,1026.00000000),(97,39,113,8640.00000000),(98,39,115,552.00000000),(99,39,117,10032.00000000),(100,39,118,1188.00000000),(101,40,127,7680.00000000),(102,40,128,276.00000000),(103,40,129,8664.00000000),(104,40,134,1003.08000000),(105,41,104,1200.00000000),(106,42,105,3600.00000000),(107,42,106,6960.00000000),(108,42,107,12879.00000000),(109,43,130,12402.00000000),(110,43,131,6960.00000000),(111,43,132,3600.00000000),(112,44,108,1920.00000000),(113,44,109,2400.00000000),(114,44,110,960.00000000),(115,44,111,1851.60000000),(116,44,112,1440.00000000),(117,45,119,480.00000000),(118,45,120,3116.40000000),(119,45,121,3398.40000000),(120,45,122,1440.00000000),(121,45,123,480.00000000),(122,45,124,1440.00000000),(123,45,125,2628.00000000),(124,45,135,480.00000000),(125,46,116,7998.00000000),(126,47,149,1920.00000000),(127,47,150,2232.00000000),(128,47,151,2481.60000000),(129,47,152,2420.40000000),(130,47,153,960.00000000),(131,47,158,480.00000000),(132,48,136,960.00000000),(133,48,137,480.00000000),(134,49,147,6240.00000000),(135,49,148,276.00000000),(136,49,154,9576.00000000),(137,49,155,7200.00000000),(138,49,159,1693.21000000),(139,50,156,3828.00000000),(140,50,157,12879.00000000),(141,51,126,3354.00000000),(142,52,133,5400.00000000),(143,52,138,2880.00000000),(144,52,139,492.00000000),(145,52,141,5472.00000000),(146,52,142,8400.00000000),(147,53,143,1786.00000000),(148,54,144,6264.00000000),(149,54,145,7950.00000000),(150,54,146,3600.00000000),(151,55,180,480.00000000),(152,55,181,3145.20000000),(153,55,182,1920.00000000),(154,55,183,1920.00000000),(155,55,184,1843.20000000),(156,56,175,12828.00000000),(157,56,176,7938.00000000),(158,56,177,3600.00000000),(159,57,165,3589.20000000),(160,57,166,480.00000000),(161,57,167,1920.00000000),(162,57,169,2637.60000000),(163,57,170,1440.00000000),(164,57,171,2923.20000000),(165,58,160,3600.00000000),(166,58,161,9582.00000000),(167,58,162,13866.00000000),(168,59,163,4800.00000000),(169,59,164,276.00000000),(170,59,172,7200.00000000),(171,59,173,2205.06000000),(172,59,174,10032.00000000),(173,60,178,7200.00000000),(174,60,179,552.00000000),(175,60,185,9576.00000000),(176,60,186,3600.00000000),(177,60,187,899.16000000),(178,60,188,2880.00000000),(179,60,189,648.00000000),(180,61,193,480.00000000),(181,61,194,842.40000000),(182,61,195,3590.40000000),(183,61,196,1440.00000000),(184,61,197,1440.00000000),(185,61,203,480.00000000),(186,62,190,5760.00000000),(187,62,191,336.00000000),(188,62,192,1440.00000000),(189,62,202,9120.00000000),(190,63,198,3600.00000000),(191,63,199,5670.00000000),(192,63,201,9570.00000000),(193,64,206,2880.00000000),(194,64,208,1920.00000000),(195,64,209,1440.00000000),(196,64,210,480.00000000),(197,65,204,9600.00000000),(198,65,205,276.00000000),(199,65,211,10032.00000000),(200,65,212,9120.00000000),(201,66,200,3780.00000000),(202,66,214,3600.00000000),(203,66,215,7938.00000000),(204,66,216,7938.00000000),(205,66,217,12819.00000000),(206,67,229,7371.00000000),(207,67,230,12720.00000000),(208,67,231,2646.00000000),(209,67,232,3600.00000000),(210,68,213,530.09000000),(211,68,227,9120.00000000),(212,69,237,960.00000000),(213,69,238,3156.00000000),(214,70,241,8127.00000000),(215,70,242,13833.00000000),(216,70,243,10800.00000000),(217,71,220,480.00000000),(218,71,221,2400.00000000),(219,71,222,722.40000000),(220,71,223,1920.00000000),(221,71,224,1920.00000000),(222,71,225,960.00000000),(223,71,226,380.40000000),(224,72,218,9120.00000000),(225,72,219,336.00000000),(226,72,228,9600.00000000),(227,72,233,457.15000000),(228,73,263,7680.00000000),(229,74,234,12480.00000000),(230,74,235,336.00000000),(231,74,236,3840.00000000),(232,74,239,9804.00000000),(233,74,240,10560.00000000),(234,75,250,5280.00000000),(235,75,251,1920.00000000),(236,75,257,3840.00000000),(237,75,258,2400.00000000),(238,75,259,2880.00000000),(239,75,260,1118.42000000),(240,75,261,8436.00000000),(241,76,246,7182.00000000),(242,76,247,12084.00000000),(243,76,248,3720.00000000),(244,76,249,1920.00000000),(245,76,275,5952.00000000),(246,76,277,10017.00000000),(247,76,278,5670.00000000),(248,76,279,3600.00000000),(249,77,252,1920.00000000),(250,77,253,960.00000000),(251,77,254,7690.80000000),(252,77,255,960.00000000),(253,77,265,2257.20000000),(254,77,267,4710.00000000),(255,77,268,1440.00000000),(256,77,269,960.00000000),(257,77,270,1920.00000000),(258,77,271,4536.00000000),(259,77,272,1747.20000000),(260,78,264,1920.00000000),(261,78,273,8664.00000000),(262,79,285,8160.00000000),(263,79,286,9576.00000000),(264,79,287,8640.00000000),(265,79,288,336.00000000),(266,79,289,1920.00000000),(267,79,300,1063.39000000),(268,80,274,8160.00000000),(269,80,280,219.23000000),(270,81,292,7762.80000000),(271,81,293,1050.00000000),(272,81,294,2698.80000000),(273,81,295,1440.00000000),(274,81,296,960.00000000),(275,81,297,960.00000000),(276,81,298,2724.00000000),(277,81,299,433.20000000),(278,82,293,9000.00000000),(279,82,310,12474.00000000),(280,82,311,1440.00000000),(281,82,312,2178.60000000),(282,82,313,960.00000000),(283,82,314,480.00000000),(284,82,315,2593.20000000),(285,83,312,9.00000000),(286,84,305,9600.00000000),(287,84,306,276.00000000),(288,84,307,1920.00000000),(289,84,316,10560.00000000),(290,84,317,273.73000000),(291,84,318,10032.00000000),(292,85,281,3600.00000000),(293,85,282,7182.00000000),(294,85,283,13038.00000000),(295,85,284,7254.00000000),(296,86,301,3600.00000000),(297,86,302,7560.00000000),(298,86,303,12402.00000000),(299,86,304,7812.00000000),(300,87,323,438.71000000),(301,87,325,10320.00000000),(302,87,326,4560.00000000),(303,87,327,1440.00000000),(304,88,328,480.00000000),(305,88,329,480.00000000),(306,88,330,480.00000000),(307,88,333,1722.00000000),(308,88,334,5430.60000000),(309,89,256,601.20000000),(310,89,290,3600.00000000),(311,89,291,656.40000000),(312,90,308,4800.00000000),(313,90,309,750.00000000),(314,90,331,1200.00000000),(315,90,332,786.00000000),(316,91,319,10800.00000000),(317,91,320,6138.00000000),(318,91,321,4914.00000000),(319,91,322,8904.00000000);

--
-- 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 DEFAULT '0',
  `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,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` datetime DEFAULT NULL,
  `amount` double DEFAULT '0',
  `fk_user_author` 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',
  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',
  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 DEFAULT '0',
  `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 DEFAULT '0',
  `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 DEFAULT '0',
  `amount_insurance` double DEFAULT '0',
  `amount_interest` double DEFAULT '0',
  `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,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user` int(11) NOT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `salary` double DEFAULT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `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_creat` 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_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 DEFAULT '0',
  `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 NOT 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(7) 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 DEFAULT '0',
  `code_banque` varchar(7) 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',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `tosell` tinyint(4) DEFAULT '1',
  `tobuy` tinyint(4) DEFAULT '1',
  `tobatch` tinyint(4) NOT NULL DEFAULT '0',
  `fk_product_type` int(11) DEFAULT '0',
  `duration` varchar(6) DEFAULT NULL,
  `seuil_stock_alerte` int(11) DEFAULT '0',
  `url` varchar(255) DEFAULT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT NULL,
  `accountancy_code_sell` varchar(32) DEFAULT NULL,
  `accountancy_code_buy` varchar(32) 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` int(11) 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',
  `fk_price_expression` int(11) DEFAULT NULL,
  `fk_unit` 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`),
  CONSTRAINT `fk_product_barcode_type` FOREIGN KEY (`fk_barcode_type`) REFERENCES `llx_c_barcode_type` (`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=5 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`, `localtax2_tx`, `fk_user_author`, `fk_user_modif`, `tosell`, `tobuy`, `tobatch`, `fk_product_type`, `duration`, `seuil_stock_alerte`, `url`, `barcode`, `fk_barcode_type`, `accountancy_code_sell`, `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`, `fk_price_expression`, `fk_unit`) VALUES (1,'SE1410-001',1,NULL,'2014-10-04 17:56:58','2014-10-04 15:57:56',0,0,'AMOA','Assistance à la conduite de projet','Assistance à la direction de projet du coté utilisateur','',NULL,0.00000000,0.00000000,0.00000000,0.00000000,'',0.000,0,0.000,0.000,1,NULL,1,0,0,1,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL),(2,'SE1410-002',1,NULL,'2014-10-04 18:01:03','2014-10-04 16:08:53',0,0,'Direction de projet','','','',1,650.00000000,780.00000000,580.00000000,696.00000000,'HT',20.000,0,0.000,0.000,1,NULL,1,0,0,1,'d',NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL),(3,'SE1410-003',1,NULL,'2014-10-04 18:10:34','2014-10-04 16:11:33',0,0,'Support technique','Support technique sur logiciel','','',NULL,550.00000000,660.00000000,480.00000000,576.00000000,'HT',20.000,0,0.000,0.000,1,NULL,1,0,0,1,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL),(4,'SE1601-004',1,NULL,'2016-01-15 15:00:26','2016-01-15 14:00:55',0,0,'Support administratif','','','',NULL,280.00000000,280.00000000,0.00000000,0.00000000,'HT',0.000,0,0.000,0.000,4,NULL,1,1,0,1,'',NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,'',0,0,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_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) NOT NULL,
  `qty` double NOT NULL DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_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,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `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_product_customer_price_fk_product` FOREIGN KEY (`fk_product`) REFERENCES `llx_product` (`rowid`),
  CONSTRAINT `fk_product_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',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) 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,
  `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',
  `unitcharges` double(24,8) DEFAULT '0.00000000',
  `tva_tx` double(6,3) NOT 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,
  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,
  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,
  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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_product_lang` (`rowid`, `fk_product`, `lang`, `label`, `description`, `note`) VALUES (1,4,'fr_FR','Support administratif','','');

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

CREATE TABLE `llx_product_price` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product` int(11) NOT NULL,
  `date_price` datetime NOT NULL,
  `price_level` smallint(6) DEFAULT '1',
  `price` double(24,8) DEFAULT NULL,
  `price_ttc` double(24,8) DEFAULT NULL,
  `price_min` double(24,8) DEFAULT NULL,
  `price_min_ttc` double(24,8) DEFAULT NULL,
  `price_base_type` varchar(3) DEFAULT 'HT',
  `tva_tx` double(6,3) NOT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `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,
  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=10 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`, `recuperableonly`, `localtax1_tx`, `localtax2_tx`, `fk_user_author`, `tosell`, `price_by_qty`, `import_key`, `fk_price_expression`) VALUES (1,1,'2014-10-04 15:56:58',1,'2014-10-04 17:56:58',1,0.00000000,0.00000000,0.00000000,0.00000000,'',0.000,0,0.000,0.000,1,1,0,NULL,NULL),(3,1,'2014-10-04 16:08:31',2,'2014-10-04 18:08:31',1,890.00000000,1068.00000000,650.00000000,780.00000000,'HT',20.000,0,0.000,0.000,1,1,0,NULL,NULL),(4,1,'2014-10-04 16:08:53',2,'2014-10-04 18:08:53',2,650.00000000,780.00000000,580.00000000,696.00000000,'HT',20.000,0,0.000,0.000,1,1,0,NULL,NULL),(6,1,'2014-10-04 16:11:14',3,'2014-10-04 18:11:13',1,650.00000000,780.00000000,550.00000000,660.00000000,'HT',20.000,0,0.000,0.000,1,1,0,NULL,NULL),(7,1,'2014-10-04 16:11:33',3,'2014-10-04 18:11:33',2,550.00000000,660.00000000,480.00000000,576.00000000,'HT',20.000,0,0.000,0.000,1,1,0,NULL,NULL),(8,1,'2016-01-15 14:00:26',4,'2016-01-15 15:00:26',1,0.00000000,0.00000000,0.00000000,0.00000000,'',0.000,0,0.000,0.000,4,1,0,NULL,NULL),(9,1,'2016-01-15 14:00:55',4,'2016-01-15 15:00:55',1,280.00000000,280.00000000,0.00000000,0.00000000,'HT',0.000,0,0.000,0.000,4,1,0,NULL,NULL);

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

CREATE TABLE `llx_product_price_by_qty` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product_price` int(11) NOT NULL,
  `date_price` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `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',
  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_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,
  `pmp` double(24,8) NOT NULL DEFAULT '0.00000000',
  `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 DEFAULT CHARSET=utf8;

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


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

CREATE TABLE `llx_projet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `datec` date 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,
  `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,
  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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_projet` (`rowid`, `fk_soc`, `datec`, `tms`, `dateo`, `datee`, `ref`, `entity`, `title`, `description`, `fk_user_creat`, `public`, `fk_statut`, `fk_opp_status`, `note_private`, `note_public`, `model_pdf`, `budget_amount`, `date_close`, `fk_user_close`, `opp_amount`) VALUES (1,5,'2015-09-25','2016-06-20 19:25:03','2015-10-05','2016-06-30','PJ1509-0001',1,'Assistance ADV/ADP','assistance mise en place 9001',4,0,0,NULL,NULL,NULL,'baleine',12000.00000000,NULL,NULL,NULL);

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

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

INSERT INTO `llx_propal` (`rowid`, `ref`, `entity`, `ref_ext`, `ref_int`, `ref_client`, `fk_soc`, `fk_projet`, `tms`, `datec`, `datep`, `fin_validite`, `date_valid`, `date_cloture`, `fk_user_author`, `fk_user_modif`, `fk_user_valid`, `fk_user_cloture`, `fk_statut`, `price`, `remise_percent`, `remise_absolue`, `remise`, `total_ht`, `tva`, `localtax1`, `localtax2`, `total`, `fk_account`, `fk_currency`, `fk_cond_reglement`, `fk_mode_reglement`, `note_private`, `note_public`, `model_pdf`, `date_livraison`, `fk_shipping_method`, `fk_availability`, `fk_input_reason`, `import_key`, `extraparams`, `fk_delivery_address`, `fk_incoterms`, `location_incoterms`) VALUES (1,'DV1410-0001',1,NULL,NULL,'na',1,NULL,'2016-02-19 11:01:15','2014-10-04 18:34:46','2014-10-04','2014-10-19 12:00:00','2015-12-04 11:59:18','2016-02-19 12:01:15',1,NULL,3,1,4,0,NULL,NULL,0,4060.00000000,812.00000000,0.00000000,0.00000000,4872.00000000,NULL,NULL,1,2,'','','azur',NULL,NULL,4,8,NULL,NULL,NULL,NULL,NULL),(2,'DV1603-0001',1,NULL,NULL,'Chargé de recrutement',5,NULL,'2016-06-24 13:20:34','2016-03-14 17:49:36','2016-03-14','2016-03-29 13:00:00','2016-03-29 21:04:51','2016-03-29 21:12:09',4,NULL,4,4,4,0,NULL,NULL,0,5600.00000000,1120.00000000,0.00000000,0.00000000,6720.00000000,NULL,NULL,9,2,'','Aide &agrave; l&#39;organisation du recrutement','azur',NULL,NULL,0,0,NULL,NULL,NULL,0,''),(3,'(PROV3)',1,NULL,NULL,'',5,NULL,'2016-03-29 15:01:17','2016-03-29 16:58:30','2016-04-04','2016-04-19 12:00:00',NULL,NULL,4,NULL,NULL,NULL,0,0,NULL,NULL,0,10640.00000000,2128.00000000,0.00000000,0.00000000,12768.00000000,NULL,NULL,9,2,'','','azur',NULL,NULL,0,0,NULL,NULL,NULL,0,''),(4,'DV1605-0001',1,NULL,NULL,'Consultant gestion',5,NULL,'2016-05-27 14:35:06','2016-05-27 16:17:43','2016-05-27','2016-06-11 12:00:00','2016-05-27 16:21:46','2016-05-27 16:35:06',4,NULL,4,4,2,0,NULL,NULL,0,17080.00000000,3416.00000000,0.00000000,0.00000000,20496.00000000,NULL,NULL,9,2,'','','azur',NULL,NULL,0,0,NULL,NULL,NULL,0,'');

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

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

INSERT INTO `llx_propal_extrafields` (`rowid`, `tms`, `fk_object`, `import_key`, `newline`) VALUES (1,'2014-10-04 16:34:46',1,NULL,'0'),(2,'2016-03-14 16:49:36',2,NULL,'0'),(3,'2016-03-29 14:58:30',3,NULL,'0'),(4,'2016-05-27 14:17:43',4,NULL,'0');

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

CREATE TABLE `llx_propal_merged_pdf` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_propal` int(11) NOT NULL,
  `file_name` varchar(200) NOT 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_merged_pdf`
--


--
-- 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',
  `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,
  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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_propaldet`
--

INSERT INTO `llx_propaldet` (`rowid`, `fk_propal`, `fk_parent_line`, `fk_product`, `label`, `description`, `fk_remise_except`, `tva_tx`, `localtax1_tx`, `localtax1_type`, `localtax2_tx`, `localtax2_type`, `qty`, `remise_percent`, `remise`, `price`, `subprice`, `total_ht`, `total_tva`, `total_localtax1`, `total_localtax2`, `total_ttc`, `product_type`, `date_start`, `date_end`, `info_bits`, `buy_price_ht`, `fk_product_fournisseur_price`, `special_code`, `rang`, `fk_unit`) VALUES (1,1,NULL,1,NULL,'Assistance à la conduite de projet\r\nAssistance au cadrage du besoin et à l\'installation de la solution ERP retenue',NULL,20.000,0.000,'0',0.000,'0',7,0,0,580,580.00000000,4060.00000000,812.00000000,0.00000000,0.00000000,4872.00000000,1,NULL,NULL,0,400.00000000,NULL,0,1,NULL),(2,2,NULL,NULL,NULL,'Aide au recrutement',NULL,20.000,0.000,'0',0.000,'0',20,0,0,NULL,280.00000000,5600.00000000,1120.00000000,0.00000000,0.00000000,6720.00000000,1,NULL,NULL,0,0.00000000,NULL,0,1,NULL),(3,3,NULL,NULL,NULL,'Prestations d&#39;&eacute;tudes dans le domaine administratif',NULL,20.000,0.000,'0',0.000,'0',38,0,0,NULL,280.00000000,10640.00000000,2128.00000000,0.00000000,0.00000000,12768.00000000,1,NULL,NULL,0,0.00000000,NULL,0,1,NULL),(4,4,NULL,NULL,NULL,'Etude, mise en place des outils et des tableaux de bords de gestion',NULL,20.000,0.000,'0',0.000,'0',61,0,0,NULL,280.00000000,17080.00000000,3416.00000000,0.00000000,0.00000000,20496.00000000,1,NULL,NULL,0,0.00000000,NULL,0,1,NULL);

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

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


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

CREATE TABLE `llx_rights_def` (
  `id` int(11) NOT NULL DEFAULT '0',
  `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`
--

INSERT INTO `llx_rights_def` (`id`, `libelle`, `module`, `entity`, `perms`, `subperms`, `type`, `bydefault`) VALUES (11,'Lire les factures','facture',1,'lire',NULL,'a',1),(12,'Creer/modifier les factures','facture',1,'creer',NULL,'a',0),(13,'Dévalider les factures','facture',1,'invoice_advance','unvalidate','a',0),(14,'Valider les factures','facture',1,'invoice_advance','validate','a',0),(15,'Envoyer les factures par mail','facture',1,'invoice_advance','send','a',0),(16,'Emettre des paiements sur les factures','facture',1,'paiement',NULL,'a',0),(19,'Supprimer les factures','facture',1,'supprimer',NULL,'a',0),(21,'Lire les propositions commerciales','propale',1,'lire',NULL,'r',1),(22,'Creer/modifier les propositions commerciales','propale',1,'creer',NULL,'w',0),(24,'Valider les propositions commerciales','propale',1,'valider',NULL,'d',0),(25,'Envoyer les propositions commerciales aux clients','propale',1,'propal_advance','send','d',0),(26,'Cloturer les propositions commerciales','propale',1,'cloturer',NULL,'d',0),(27,'Supprimer les propositions commerciales','propale',1,'supprimer',NULL,'d',0),(28,'Exporter les propositions commerciales et attributs','propale',1,'export',NULL,'r',0),(31,'Lire les produits','produit',1,'lire',NULL,'r',1),(32,'Creer/modifier les produits','produit',1,'creer',NULL,'w',0),(34,'Supprimer les produits','produit',1,'supprimer',NULL,'d',0),(38,'Exporter les produits','produit',1,'export',NULL,'r',0),(41,'Lire les projets et tâches (partagés ou dont je suis contact)','projet',1,'lire',NULL,'r',1),(42,'Creer/modifier les projets et tâches (partagés ou dont je suis contact)','projet',1,'creer',NULL,'w',0),(44,'Supprimer les projets et tâches (partagés ou dont je suis contact)','projet',1,'supprimer',NULL,'d',0),(45,'Exporter les projets','projet',1,'export',NULL,'d',0),(61,'Lire les fiches d\'intervention','ficheinter',1,'lire',NULL,'r',1),(62,'Creer/modifier les fiches d\'intervention','ficheinter',1,'creer',NULL,'w',0),(64,'Supprimer les fiches d\'intervention','ficheinter',1,'supprimer',NULL,'d',0),(67,'Exporter les fiches interventions','ficheinter',1,'export',NULL,'r',0),(68,'Envoyer les fiches d\'intervention par courriel','ficheinter',1,'ficheinter_advance','send','r',0),(81,'Lire les commandes clients','commande',1,'lire',NULL,'r',1),(82,'Creer/modifier les commandes clients','commande',1,'creer',NULL,'w',0),(84,'Valider les commandes clients','commande',1,'order_advance','validate','d',0),(86,'Envoyer les commandes clients','commande',1,'order_advance','send','d',0),(87,'Cloturer les commandes clients','commande',1,'cloturer',NULL,'d',0),(88,'Annuler les commandes clients','commande',1,'order_advance','annuler','d',0),(89,'Supprimer les commandes clients','commande',1,'supprimer',NULL,'d',0),(91,'Lire les charges','tax',1,'charges','lire','r',1),(92,'Creer/modifier les charges','tax',1,'charges','creer','w',0),(93,'Supprimer les charges','tax',1,'charges','supprimer','d',0),(94,'Exporter les charges','tax',1,'charges','export','r',0),(95,'Lire CA, bilans, resultats','compta',1,'resultat','lire','r',1),(96,'Parametrer la ventilation','compta',1,'ventilation','parametrer','r',0),(97,'Lire les ventilations de factures','compta',1,'ventilation','lire','r',1),(98,'Ventiler les lignes de factures','compta',1,'ventilation','creer','r',0),(111,'Lire les comptes bancaires','banque',1,'lire',NULL,'r',1),(112,'Creer/modifier montant/supprimer ecriture bancaire','banque',1,'modifier',NULL,'w',0),(113,'Configurer les comptes bancaires (creer, gerer categories)','banque',1,'configurer',NULL,'a',0),(114,'Rapprocher les ecritures bancaires','banque',1,'consolidate',NULL,'w',0),(115,'Exporter transactions et releves','banque',1,'export',NULL,'r',0),(116,'Virements entre comptes','banque',1,'transfer',NULL,'w',0),(117,'Gerer les envois de cheques','banque',1,'cheque',NULL,'w',0),(121,'Lire les societes','societe',1,'lire',NULL,'r',1),(122,'Creer modifier les societes','societe',1,'creer',NULL,'w',0),(125,'Supprimer les societes','societe',1,'supprimer',NULL,'d',0),(126,'Exporter les societes','societe',1,'export',NULL,'r',0),(141,'Lire tous les projets et tâches (y compris prives qui ne me sont pas affectes)','projet',1,'all','lire','r',0),(142,'Creer/modifier tous les projets et tâches (y compris prives qui ne me sont pas affectes)','projet',1,'all','creer','w',0),(144,'Supprimer tous les projets et tâches (y compris prives qui ne me sont pas affectes)','projet',1,'all','supprimer','d',0),(161,'Lire les contrats','contrat',1,'lire',NULL,'r',1),(162,'Creer / modifier les contrats','contrat',1,'creer',NULL,'w',0),(163,'Activer un service d\'un contrat','contrat',1,'activer',NULL,'w',0),(164,'Desactiver un service d\'un contrat','contrat',1,'desactiver',NULL,'w',0),(165,'Supprimer un contrat','contrat',1,'supprimer',NULL,'d',0),(167,'Export contracts','contrat',1,'export',NULL,'r',0),(171,'Lire ses notes de frais et deplacements et celles de sa hierarchy','deplacement',1,'lire',NULL,'r',1),(172,'Creer/modifier une note de frais et deplacements','deplacement',1,'creer',NULL,'w',0),(173,'Supprimer les notes de frais et deplacements','deplacement',1,'supprimer',NULL,'d',0),(174,'Lire toutes les notes de frais','deplacement',1,'readall',NULL,'d',0),(178,'Exporter les notes de frais et deplacements','deplacement',1,'export',NULL,'d',0),(241,'Lire les categories','categorie',1,'lire',NULL,'r',1),(242,'Creer/modifier les categories','categorie',1,'creer',NULL,'w',0),(243,'Supprimer les categories','categorie',1,'supprimer',NULL,'d',0),(251,'Consulter les autres utilisateurs','user',1,'user','lire','r',0),(252,'Consulter les permissions des autres utilisateurs','user',1,'user_advance','readperms','r',0),(253,'Creer/modifier utilisateurs internes et externes','user',1,'user','creer','w',0),(254,'Creer/modifier utilisateurs externes seulement','user',1,'user_advance','write','w',0),(255,'Modifier le mot de passe des autres utilisateurs','user',1,'user','password','w',0),(256,'Supprimer ou desactiver les autres utilisateurs','user',1,'user','supprimer','d',0),(262,'Consulter tous les tiers par utilisateurs internes (sinon uniquement si contact commercial). Non effectif pour utilisateurs externes (tjs limités à eux-meme).','societe',1,'client','voir','r',1),(281,'Lire les contacts','societe',1,'contact','lire','r',1),(282,'Creer modifier les contacts','societe',1,'contact','creer','w',0),(283,'Supprimer les contacts','societe',1,'contact','supprimer','d',0),(286,'Exporter les contacts','societe',1,'contact','export','d',0),(341,'Consulter ses propres permissions','user',1,'self_advance','readperms','r',1),(342,'Creer/modifier ses propres infos utilisateur','user',1,'self','creer','w',1),(343,'Modifier son propre mot de passe','user',1,'self','password','w',1),(344,'Modifier ses propres permissions','user',1,'self_advance','writeperms','w',1),(351,'Consulter les groupes','user',1,'group_advance','read','r',0),(352,'Consulter les permissions des groupes','user',1,'group_advance','readperms','r',0),(353,'Creer/modifier les groupes et leurs permissions','user',1,'group_advance','write','w',0),(354,'Supprimer ou desactiver les groupes','user',1,'group_advance','delete','d',0),(358,'Exporter les utilisateurs','user',1,'user','export','r',0),(510,'Read salaries','salaries',1,'read',NULL,'r',0),(512,'Create/modify salaries','salaries',1,'write',NULL,'w',0),(514,'Delete salaries','salaries',1,'delete',NULL,'d',0),(517,'Export salaries','salaries',1,'export',NULL,'r',0),(531,'Lire les services','service',1,'lire',NULL,'r',1),(532,'Creer/modifier les services','service',1,'creer',NULL,'w',0),(534,'Supprimer les services','service',1,'supprimer',NULL,'d',0),(538,'Exporter les services','service',1,'export',NULL,'r',0),(1181,'Consulter les fournisseurs','fournisseur',1,'lire',NULL,'r',1),(1182,'Consulter les commandes fournisseur','fournisseur',1,'commande','lire','r',1),(1183,'Creer une commande fournisseur','fournisseur',1,'commande','creer','w',0),(1184,'Valider une commande fournisseur','fournisseur',1,'supplier_order_advance','validate','w',0),(1185,'Approuver une commande fournisseur','fournisseur',1,'commande','approuver','w',0),(1186,'Commander une commande fournisseur','fournisseur',1,'commande','commander','w',0),(1187,'Receptionner une commande fournisseur','fournisseur',1,'commande','receptionner','d',0),(1188,'Supprimer une commande fournisseur','fournisseur',1,'commande','supprimer','d',0),(1189,'Check/Uncheck a supplier order reception','fournisseur',1,'commande_advance','check','w',0),(1201,'Lire les exports','export',1,'lire',NULL,'r',1),(1202,'Creer/modifier un export','export',1,'creer',NULL,'w',0),(1231,'Consulter les factures fournisseur','fournisseur',1,'facture','lire','r',1),(1232,'Creer une facture fournisseur','fournisseur',1,'facture','creer','w',0),(1233,'Valider une facture fournisseur','fournisseur',1,'supplier_invoice_advance','validate','w',0),(1234,'Supprimer une facture fournisseur','fournisseur',1,'facture','supprimer','d',0),(1235,'Envoyer les factures par mail','fournisseur',1,'supplier_invoice_advance','send','a',0),(1236,'Exporter les factures fournisseurs, attributs et reglements','fournisseur',1,'facture','export','r',0),(1237,'Exporter les commande fournisseurs, attributs','fournisseur',1,'commande','export','r',0),(1251,'Run mass imports of external data (data load)','import',1,'run',NULL,'r',0),(1321,'Exporter les factures clients, attributs et reglements','facture',1,'facture','export','r',0),(1421,'Exporter les commandes clients et attributs','commande',1,'commande','export','r',0),(2501,'Consulter/Télécharger les documents','ecm',1,'read',NULL,'r',1),(2503,'Soumettre ou supprimer des documents','ecm',1,'upload',NULL,'w',1),(2515,'Administrer les rubriques de documents','ecm',1,'setup',NULL,'w',1),(20001,'Read your own holidays','holiday',1,'read',NULL,'w',1),(20002,'Create/modify your own holidays','holiday',1,'write',NULL,'w',1),(20003,'Delete holidays','holiday',1,'delete',NULL,'w',0),(20004,'Read holidays for everybody','holiday',1,'read_all',NULL,'w',0),(20005,'Create/modify holidays for everybody','holiday',1,'write_all',NULL,'w',0),(20006,'Setup holidays of users (setup and update balance)','holiday',1,'define_holiday',NULL,'w',0),(59001,'Visualiser les marges','margins',1,'liretous',NULL,'r',1),(59002,'Définir les marges','margins',1,'creer',NULL,'w',0),(59003,'Read every user margin','margins',1,'read','all','r',0),(63001,'Read resources','resource',1,'read',NULL,'w',0),(63002,'Create/Modify resources','resource',1,'write',NULL,'w',0),(63003,'Delete resources','resource',1,'delete',NULL,'w',0),(63004,'Link resources','resource',1,'link',NULL,'w',0),(300101,'Consulter les infos du modele','ultimatepdf',1,'read',NULL,'r',1),(300102,'Modifier la fiche du modele','ultimatepdf',1,'write',NULL,'w',0);

--
-- 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(128) 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,
  `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 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',
  `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,
  `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,
  `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,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_prefix_comm` (`prefix_comm`,`entity`),
  UNIQUE KEY `uk_societe_code_client` (`code_client`,`entity`),
  UNIQUE KEY `uk_societe_code_fournisseur` (`code_fournisseur`,`entity`),
  UNIQUE KEY `uk_societe_barcode` (`barcode`,`fk_barcode_type`,`entity`),
  KEY `idx_societe_user_creat` (`fk_user_creat`),
  KEY `idx_societe_user_modif` (`fk_user_modif`)
) ENGINE=InnoDB AUTO_INCREMENT=14 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`, `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`, `mode_reglement`, `cond_reglement`, `mode_reglement_supplier`, `cond_reglement_supplier`, `tva_assuj`, `localtax1_assuj`, `localtax1_value`, `localtax2_assuj`, `localtax2_value`, `barcode`, `fk_barcode_type`, `price_level`, `outstanding_limit`, `default_lang`, `logo`, `canvas`, `import_key`, `webservices_url`, `webservices_key`, `name_alias`, `fk_incoterms`, `location_incoterms`) VALUES (1,'DG INNOVATIONS',1,NULL,NULL,0,NULL,'2016-02-19 11:01:04','2014-10-04 18:22:03',1,'CL1410-0001',NULL,'411CL14100001',NULL,'75, rue Jules GUESDES','69230','saint genis laval',71,1,'0478815519',NULL,'www.dg-innovations.com','loanne@dg-innovations.com',NULL,1,4,57,NULL,'803878362','80387836200018','','','','','',25000,1,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'ORCHESTRA - PREMAMAN',1,NULL,NULL,0,NULL,'2016-01-29 14:52:33','2015-08-18 18:32:06',1,'CL1508-0001','CF1508-0001','411CL15080001','401CF15080001','ZAC Saint Antoine\r\n200 avenue des Tamaris','34130','SAINT AUNES',0,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'398471565','39847156501990','4771Z','','','','',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,NULL),(3,'EUROTAB GROUP',1,NULL,NULL,0,NULL,'2015-08-25 12:46:09','2015-08-25 14:46:09',1,'CL1508-0002',NULL,'411CL15080002',NULL,'Zac des Peyrardes','42170','Saint Just Saint Rambert',0,1,'0477021212',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,2,0,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'HAULOTTE GROUP',1,NULL,NULL,0,NULL,'2015-08-25 12:57:24','2015-08-25 14:50:15',1,'CL1508-0003',NULL,'411CL15080003',NULL,'La Péronnière, 27 Rue d\'Onzion','42152','L\'HORME',0,1,'0477292424',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,2,0,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'NOVAXIOM GROUP',1,NULL,NULL,0,NULL,'2016-01-29 13:11:42','2015-08-25 14:53:19',1,'CL1508-0004',NULL,'411CL15080004',NULL,'23 Rue Jules Vallès','69100','VILLEURBANNE',0,1,'0472838870',NULL,NULL,NULL,NULL,4,3,57,NULL,'420824971','42082497100014','7112B','','','','',362000,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,'fr_FR',NULL,NULL,NULL,NULL,NULL,'',0,NULL),(6,'SPIE SUD EST',1,NULL,NULL,0,NULL,'2015-08-25 12:54:29','2015-08-25 14:54:29',1,'CL1508-0005',NULL,'411CL15080005',NULL,'4 Avenue Jean Jaurès','69320','FEYZIN',0,1,'0472211200',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,2,0,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'SPC CONSULTANTS',1,NULL,NULL,0,NULL,'2016-05-30 08:25:46','2015-08-25 14:55:48',1,'CL1508-0006',NULL,'411CL15080006',NULL,'Parc Inopolis\r\n204 Route de Vourles','69230','Saint-Genis-Laval',0,1,'0472671234',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'343762308','34376230800033','','','','','',136000,0,NULL,NULL,NULL,3,0,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,NULL),(8,'COURBON',1,NULL,NULL,0,NULL,'2017-07-25 06:45:52','2016-11-18 15:30:57',1,'CL1611-0001','CF1611-0001','411CL16110001','401CF16110001','70 rue de la Montat','42000','ST ETIENNE',44,1,'0477593434',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'584501563','58450156300012','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,2,9,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,NULL),(9,'CEGID',1,NULL,NULL,0,NULL,'2017-06-02 08:38:23','2017-04-26 15:55:15',1,'CL1704-0001','CF1704-0001','411CL17040001','401CF17040001','52 Quai Paul Sédallian','69009','Lyon',0,1,'0811884888',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'410218010','41021801000032','','','','','',0,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,'fr_FR',NULL,NULL,NULL,NULL,NULL,'',0,NULL),(10,'ANDROS et Compagnie',1,NULL,NULL,0,NULL,'2018-07-31 09:51:50','2017-04-26 16:17:17',1,'CL1704-0002','CF1704-0002','411CL17040002','401CF17040002','ZI','46130','BIARS SUR CERE',0,1,'0565101010',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'395287519','39528751900015','','','','','FR13428682447',0,0,NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,4,4,0,2,9,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,NULL),(12,'CONCERTO RH',1,NULL,NULL,0,NULL,'2017-06-02 09:32:30','2017-06-02 11:25:40',1,'CL1706-0001',NULL,'411CL17060001',NULL,'1 rue de la Brosse','42400','SAINT CHAMOND',0,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'522899277','52289927700027','','','','','',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,4,4,0,2,9,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,NULL),(13,'ANDROS SNC',1,NULL,NULL,0,NULL,'2018-07-31 09:53:02','2018-07-12 15:53:50',1,'CL1807-0001',NULL,'411CL18070001',NULL,'ZI','46130','BIARS SUR CERE',0,1,'0565101010',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'428682447','42868244700019','','','','','',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,4,4,0,2,9,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,NULL);

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

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

INSERT INTO `llx_societe_commerciaux` (`rowid`, `fk_soc`, `fk_user`) VALUES (1,1,3),(2,2,4),(3,3,4),(4,4,4),(5,5,4),(6,6,4),(7,7,4),(8,8,4),(9,9,4),(10,10,4),(12,12,4),(13,13,4);

--
-- 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,
  `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,
  `fk_soc` int(11) NOT NULL,
  `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,
  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`),
  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_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_rib`
--

CREATE TABLE `llx_societe_rib` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `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(7) 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,
  `frstrecur` varchar(16) DEFAULT 'FRST',
  `import_key` varchar(14) 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(128) 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,
  `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`, `no_email`, `priv`, `fk_user_creat`, `fk_user_modif`, `note_private`, `note_public`, `default_lang`, `canvas`, `import_key`, `statut`) VALUES (1,'2014-10-04 18:27:23','2014-10-04 16:27:23',1,1,NULL,'MR','PERRIER','Lionnel','75, rue Jules GUESDES','69230','saint genis laval',71,1,NULL,'Directeur Commercial','','','0658161333','','lperrier@dg-innovations.com','','',0,0,1,1,'','',NULL,NULL,NULL,1),(2,'2014-10-04 18:31:34','2014-10-04 16:31:34',1,1,NULL,'MLE','POIZAT','Loanne','75, rue Jules GUESDES','69230','saint genis laval',71,1,NULL,'Responsable marketing','','','','','loanne@dg-innovations.com','','',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`
--


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

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

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


--
-- Table structure for table `llx_tva`
--

CREATE TABLE `llx_tva` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `fk_typepayment` int(11) DEFAULT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `note` text,
  `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_tva`
--


--
-- Table structure for table `llx_ultimatepdf`
--

CREATE TABLE `llx_ultimatepdf` (
  `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,
  `label` varchar(255) NOT NULL,
  `description` text,
  `datec` datetime DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `options` text,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  KEY `idx_ultimatepdf_label` (`fk_user_creat`),
  CONSTRAINT `fk_ultimatepdf_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_ultimatepdf`
--

INSERT INTO `llx_ultimatepdf` (`rowid`, `entity`, `tms`, `label`, `description`, `datec`, `fk_user_creat`, `options`, `active`) VALUES (1,1,'2014-10-02 15:46:10','Mod&egrave;le ma&icirc;tre','C&#039;est le mod&egrave;le par d&eacute;faut','2014-10-02 17:46:10',1,'{\"bgcolor\":\"aad4ff\",\"bordercolor\":\"003f7f\",\"textcolor\":\"191919\",\"dashdotted\":\"8, 2\",\"withref\":\"no\",\"withoutvat\":\"no\"}',1);

--
-- Table structure for table `llx_user`
--

CREATE TABLE `llx_user` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(50) DEFAULT NULL,
  `ref_int` varchar(50) 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,
  `login` varchar(24) NOT NULL,
  `pass` varchar(32) DEFAULT NULL,
  `pass_crypted` varchar(128) DEFAULT NULL,
  `pass_temp` varchar(32) DEFAULT NULL,
  `api_key` varchar(128) DEFAULT NULL,
  `civility` varchar(6) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(25) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `fk_state` int(11) DEFAULT '0',
  `fk_country` int(11) DEFAULT '0',
  `job` varchar(128) DEFAULT NULL,
  `skype` varchar(255) DEFAULT NULL,
  `office_phone` varchar(20) DEFAULT NULL,
  `office_fax` varchar(20) DEFAULT NULL,
  `user_mobile` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `signature` text,
  `admin` smallint(6) DEFAULT '0',
  `module_comm` smallint(6) DEFAULT '1',
  `module_compta` smallint(6) DEFAULT '1',
  `fk_soc` int(11) DEFAULT NULL,
  `fk_socpeople` int(11) DEFAULT NULL,
  `fk_member` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `thm` double(24,8) DEFAULT NULL,
  `note` text,
  `datelastlogin` datetime DEFAULT NULL,
  `datepreviouslogin` datetime DEFAULT NULL,
  `egroupware_id` int(11) DEFAULT NULL,
  `ldap_sid` varchar(255) DEFAULT NULL,
  `openid` varchar(255) DEFAULT NULL,
  `statut` tinyint(4) DEFAULT '1',
  `photo` varchar(255) DEFAULT NULL,
  `lang` varchar(6) DEFAULT NULL,
  `color` varchar(6) DEFAULT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT '0',
  `accountancy_code` varchar(32) DEFAULT NULL,
  `nb_holiday` int(11) DEFAULT '0',
  `salary` double(24,8) DEFAULT NULL,
  `tjm` double(24,8) DEFAULT NULL,
  `salaryextra` double(24,8) DEFAULT NULL,
  `weeklyhours` double(16,8) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_login` (`login`,`entity`),
  UNIQUE KEY `uk_user_fk_socpeople` (`fk_socpeople`),
  UNIQUE KEY `uk_user_fk_member` (`fk_member`),
  KEY `idx_user_api_key` (`api_key`),
  KEY `idx_user_fk_societe` (`fk_soc`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_user` (`rowid`, `entity`, `ref_ext`, `ref_int`, `datec`, `tms`, `fk_user_creat`, `fk_user_modif`, `login`, `pass`, `pass_crypted`, `pass_temp`, `api_key`, `civility`, `lastname`, `firstname`, `address`, `zip`, `town`, `fk_state`, `fk_country`, `job`, `skype`, `office_phone`, `office_fax`, `user_mobile`, `email`, `signature`, `admin`, `module_comm`, `module_compta`, `fk_soc`, `fk_socpeople`, `fk_member`, `fk_user`, `thm`, `note`, `datelastlogin`, `datepreviouslogin`, `egroupware_id`, `ldap_sid`, `openid`, `statut`, `photo`, `lang`, `color`, `barcode`, `fk_barcode_type`, `accountancy_code`, `nb_holiday`, `salary`, `tjm`, `salaryextra`, `weeklyhours`, `gender`) VALUES (1,0,NULL,NULL,'2014-09-30 21:47:10','2014-09-30 19:47:10',NULL,NULL,'admin','lf652429','8b8a67c311ef3069d5044dee423df3ce',NULL,NULL,NULL,'SuperAdmin','','','','',NULL,NULL,'','','','','','','',1,1,1,NULL,NULL,NULL,NULL,NULL,'','2018-10-27 18:17:37','2018-07-31 20:37:34',NULL,'',NULL,1,NULL,NULL,NULL,NULL,0,'',0,NULL,NULL,NULL,NULL,NULL),(2,0,NULL,NULL,'2014-10-01 18:18:08','2016-09-16 17:45:15',NULL,NULL,'LBT','bzrc4qg7','f613c0389b46a252b0a7aff4a92c5121',NULL,NULL,NULL,'BORRET','Laurent','','','',NULL,NULL,'PDG','','','','','laurent.borret@nexiium.com','',0,1,1,NULL,NULL,NULL,NULL,NULL,'','2018-10-22 16:51:22','2018-10-22 16:02:22',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL),(3,0,NULL,NULL,'2014-10-01 18:19:50','2015-08-18 12:55:26',NULL,NULL,'FLE','fl19vb69','8350027df1f82065822e5e2c073407b0',NULL,NULL,NULL,'LAVABRE','François','','','',NULL,NULL,'','','','','','flavabre@qat-consulting.com','',1,1,1,NULL,NULL,NULL,NULL,NULL,'','2018-10-22 17:02:53','2018-09-09 11:20:51',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL),(4,1,NULL,NULL,'2015-08-18 17:47:32','2016-06-20 14:49:19',NULL,NULL,'FALE','fh69df390','5f8c20c086843c01103102bb9cf07248',NULL,NULL,NULL,'LAVABRE','Fanny','','','',NULL,NULL,'Resp Agence','','','','0660048662','fanny.lavabre@nexiium.com','',0,1,1,NULL,NULL,NULL,2,NULL,'','2018-10-17 15:21:31','2018-10-12 16:36:46',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,'woman');

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

CREATE TABLE `llx_user_alert` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `fk_contact` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_user_alert`
--


--
-- Table structure for table `llx_user_clicktodial`
--

CREATE TABLE `llx_user_clicktodial` (
  `fk_user` int(11) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `login` varchar(32) DEFAULT NULL,
  `pass` varchar(64) DEFAULT NULL,
  `poste` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `llx_user_clicktodial`
--


--
-- Table structure for table `llx_user_extrafields`
--

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

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


--
-- Table structure for table `llx_user_param`
--

CREATE TABLE `llx_user_param` (
  `fk_user` int(11) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `param` varchar(64) NOT NULL,
  `value` varchar(255) NOT NULL,
  UNIQUE KEY `uk_user_param` (`fk_user`,`param`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_user_param` (`fk_user`, `entity`, `param`, `value`) VALUES (4,1,'MAIN_BOXES_0','1');

--
-- Table structure for table `llx_user_rights`
--

CREATE TABLE `llx_user_rights` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_rights` (`fk_user`,`fk_id`),
  CONSTRAINT `fk_user_rights_fk_user_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=1274 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_user_rights` (`rowid`, `fk_user`, `fk_id`) VALUES (1108,1,11),(1095,1,12),(1098,1,13),(1100,1,14),(1102,1,15),(1105,1,16),(1109,1,19),(276,1,21),(268,1,22),(270,1,24),(271,1,25),(273,1,26),(275,1,27),(277,1,28),(298,1,31),(295,1,32),(297,1,34),(299,1,38),(253,1,41),(250,1,42),(252,1,44),(254,1,45),(111,1,61),(108,1,62),(110,1,64),(112,1,67),(113,1,68),(1058,1,81),(1045,1,82),(1048,1,84),(1050,1,86),(1053,1,87),(1056,1,88),(1059,1,89),(184,1,91),(181,1,92),(183,1,93),(185,1,94),(134,1,95),(135,1,96),(137,1,97),(138,1,98),(177,1,111),(168,1,112),(170,1,113),(172,1,114),(174,1,115),(176,1,116),(178,1,117),(1174,1,121),(1167,1,122),(1171,1,125),(1175,1,126),(258,1,141),(257,1,142),(259,1,144),(82,1,161),(77,1,162),(79,1,163),(81,1,164),(83,1,165),(1078,1,171),(1067,1,172),(1071,1,173),(1075,1,174),(1079,1,178),(303,1,241),(302,1,242),(304,1,243),(1248,1,251),(1210,1,252),(1213,1,253),(1216,1,254),(1219,1,255),(1223,1,256),(1178,1,262),(1190,1,281),(1183,1,282),(1187,1,283),(1191,1,286),(1226,1,341),(1228,1,342),(1230,1,343),(1232,1,344),(1244,1,351),(1237,1,352),(1241,1,353),(1245,1,354),(1249,1,358),(191,1,510),(188,1,512),(190,1,514),(192,1,517),(1204,1,531),(1197,1,532),(1201,1,534),(1205,1,538),(1114,1,1181),(1160,1,1182),(1119,1,1183),(1122,1,1184),(1125,1,1185),(1129,1,1186),(1133,1,1187),(1139,1,1188),(1136,1,1189),(261,1,1201),(262,1,1202),(1156,1,1231),(1145,1,1232),(1148,1,1233),(1151,1,1234),(1154,1,1235),(1157,1,1236),(1161,1,1237),(263,1,1251),(1112,1,1321),(1062,1,1421),(1088,1,2501),(1085,1,2503),(1089,1,2515),(1270,1,20001),(1255,1,20002),(1259,1,20003),(1263,1,20004),(1267,1,20005),(1271,1,20006),(264,1,59001),(265,1,59002),(828,1,63001),(821,1,63002),(825,1,63003),(829,1,63004),(365,1,300101),(366,1,300102),(305,2,11),(306,2,21),(307,2,31),(308,2,41),(309,2,61),(310,2,81),(311,2,91),(312,2,95),(313,2,97),(314,2,111),(315,2,121),(316,2,161),(317,2,171),(318,2,241),(319,2,262),(320,2,281),(321,2,341),(322,2,342),(323,2,343),(324,2,344),(325,2,531),(326,2,1181),(327,2,1182),(328,2,1201),(329,2,1231),(330,2,2501),(331,2,2503),(332,2,2515),(333,2,59001),(1110,3,11),(1097,3,12),(1099,3,13),(1101,3,14),(1103,3,15),(1107,3,16),(1111,3,19),(335,3,21),(336,3,31),(337,3,41),(338,3,61),(1060,3,81),(1047,3,82),(1049,3,84),(1051,3,86),(1055,3,87),(1057,3,88),(1061,3,89),(340,3,91),(341,3,95),(342,3,97),(343,3,111),(1176,3,121),(1169,3,122),(1173,3,125),(1177,3,126),(345,3,161),(1080,3,171),(1069,3,172),(1073,3,173),(1077,3,174),(1081,3,178),(347,3,241),(1250,3,251),(1211,3,252),(1215,3,253),(1217,3,254),(1221,3,255),(1225,3,256),(1179,3,262),(1192,3,281),(1185,3,282),(1189,3,283),(1193,3,286),(1227,3,341),(1229,3,342),(1231,3,343),(1233,3,344),(1246,3,351),(1239,3,352),(1243,3,353),(1247,3,354),(1251,3,358),(1206,3,531),(1199,3,532),(1203,3,534),(1207,3,538),(1115,3,1181),(1162,3,1182),(1121,3,1183),(1123,3,1184),(1127,3,1185),(1131,3,1186),(1135,3,1187),(1141,3,1188),(1137,3,1189),(357,3,1201),(1158,3,1231),(1147,3,1232),(1149,3,1233),(1153,3,1234),(1155,3,1235),(1159,3,1236),(1163,3,1237),(1113,3,1321),(1063,3,1421),(1090,3,2501),(1087,3,2503),(1091,3,2515),(1272,3,20001),(1257,3,20002),(1261,3,20003),(1265,3,20004),(1269,3,20005),(1273,3,20006),(362,3,59001),(830,3,63001),(823,3,63002),(827,3,63003),(831,3,63004),(367,3,300101),(368,3,300102),(561,4,11),(562,4,21),(563,4,31),(564,4,41),(565,4,61),(594,4,81),(595,4,82),(596,4,84),(597,4,86),(598,4,87),(599,4,88),(600,4,89),(567,4,91),(568,4,95),(569,4,97),(570,4,111),(571,4,121),(602,4,161),(603,4,162),(604,4,163),(605,4,164),(606,4,165),(607,4,167),(573,4,171),(591,4,241),(592,4,242),(593,4,243),(575,4,262),(576,4,281),(577,4,341),(578,4,342),(579,4,343),(580,4,344),(581,4,531),(582,4,1181),(583,4,1182),(584,4,1201),(585,4,1231),(601,4,1421),(586,4,2501),(587,4,2503),(588,4,2515),(589,4,59001),(590,4,300101);

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

CREATE TABLE `llx_usergroup` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `note` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_name` (`nom`,`entity`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_usergroup` (`rowid`, `nom`, `entity`, `datec`, `tms`, `note`) VALUES (1,'Gestionnaire',1,'2014-10-01 18:14:45','2014-10-01 16:14:45',''),(2,'Administrateur',1,'2015-08-18 17:58:24','2015-08-18 15:58:24','');

--
-- Table structure for table `llx_usergroup_extrafields`
--

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

--
-- Dumping data for table `llx_usergroup_extrafields`
--


--
-- Table structure for table `llx_usergroup_rights`
--

CREATE TABLE `llx_usergroup_rights` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_usergroup` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `fk_usergroup` (`fk_usergroup`,`fk_id`),
  CONSTRAINT `fk_usergroup_rights_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `llx_usergroup` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8;

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

INSERT INTO `llx_usergroup_rights` (`rowid`, `fk_usergroup`, `fk_id`) VALUES (37,1,11),(38,1,12),(39,1,13),(40,1,14),(41,1,15),(42,1,16),(43,1,19),(73,1,21),(74,1,22),(75,1,24),(76,1,25),(77,1,26),(78,1,27),(79,1,28),(80,1,31),(81,1,32),(82,1,34),(83,1,38),(66,1,41),(67,1,42),(68,1,44),(69,1,45),(45,1,61),(46,1,62),(47,1,64),(48,1,67),(49,1,68),(11,1,81),(12,1,82),(13,1,84),(14,1,86),(15,1,87),(16,1,88),(17,1,89),(103,1,91),(104,1,92),(105,1,93),(106,1,94),(19,1,95),(20,1,96),(21,1,97),(22,1,98),(1,1,111),(2,1,112),(3,1,113),(4,1,114),(5,1,115),(6,1,116),(7,1,117),(94,1,121),(95,1,122),(96,1,125),(97,1,126),(70,1,141),(71,1,142),(72,1,144),(23,1,161),(24,1,162),(25,1,163),(26,1,164),(27,1,165),(28,1,171),(29,1,172),(30,1,173),(31,1,178),(8,1,241),(9,1,242),(10,1,243),(107,1,251),(108,1,252),(109,1,253),(110,1,254),(111,1,255),(112,1,256),(98,1,262),(99,1,281),(100,1,282),(101,1,283),(102,1,286),(113,1,341),(114,1,342),(115,1,343),(116,1,344),(117,1,351),(118,1,352),(119,1,353),(120,1,354),(121,1,358),(86,1,510),(87,1,512),(88,1,514),(89,1,517),(90,1,531),(91,1,532),(92,1,534),(93,1,538),(50,1,1181),(51,1,1182),(52,1,1183),(53,1,1184),(54,1,1185),(55,1,1186),(56,1,1187),(57,1,1188),(35,1,1201),(36,1,1202),(58,1,1231),(59,1,1232),(60,1,1233),(61,1,1234),(62,1,1235),(63,1,1236),(64,1,1237),(44,1,1321),(18,1,1421),(32,1,2501),(33,1,2503),(34,1,2515),(84,1,59001),(85,1,59002),(163,2,11),(164,2,12),(165,2,13),(166,2,14),(167,2,15),(168,2,16),(169,2,19),(205,2,21),(206,2,22),(207,2,24),(208,2,25),(209,2,26),(210,2,27),(211,2,28),(194,2,31),(195,2,32),(196,2,34),(197,2,38),(198,2,41),(199,2,42),(200,2,44),(201,2,45),(171,2,61),(172,2,62),(173,2,64),(174,2,67),(175,2,68),(135,2,81),(136,2,82),(137,2,84),(138,2,86),(139,2,87),(140,2,88),(141,2,89),(229,2,91),(230,2,92),(231,2,93),(232,2,94),(143,2,95),(144,2,96),(145,2,97),(146,2,98),(125,2,111),(126,2,112),(127,2,113),(128,2,114),(129,2,115),(130,2,116),(131,2,117),(220,2,121),(221,2,122),(222,2,125),(223,2,126),(202,2,141),(203,2,142),(204,2,144),(147,2,161),(148,2,162),(149,2,163),(150,2,164),(151,2,165),(152,2,167),(153,2,171),(154,2,172),(155,2,173),(156,2,174),(157,2,178),(132,2,241),(133,2,242),(134,2,243),(235,2,251),(236,2,252),(237,2,253),(238,2,254),(239,2,255),(240,2,256),(224,2,262),(225,2,281),(226,2,282),(227,2,283),(228,2,286),(241,2,341),(242,2,342),(243,2,343),(244,2,344),(245,2,351),(246,2,352),(247,2,353),(248,2,354),(249,2,358),(212,2,510),(213,2,512),(214,2,514),(215,2,517),(216,2,531),(217,2,532),(218,2,534),(219,2,538),(176,2,1181),(177,2,1182),(178,2,1183),(179,2,1184),(180,2,1185),(181,2,1186),(182,2,1187),(183,2,1188),(161,2,1201),(162,2,1202),(184,2,1231),(185,2,1232),(186,2,1233),(187,2,1234),(188,2,1235),(189,2,1236),(190,2,1237),(191,2,1251),(170,2,1321),(142,2,1421),(158,2,2501),(159,2,2503),(160,2,2515),(192,2,59001),(193,2,59002),(233,2,300101),(234,2,300102);

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

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

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

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


