-- Dumping data for table `B65479115_c_typent`
--
INSERT INTO `B65479115_c_typent` VALUES (0,'TE_UNKNOWN','-',NULL,1,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (1,'TE_STARTUP','Start-up',NULL,0,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (2,'TE_GROUP','Grand groupe',NULL,1,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (3,'TE_MEDIUM','PME/PMI',NULL,1,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (4,'TE_SMALL','TPE',NULL,1,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (5,'TE_ADMIN','Administration',NULL,1,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (6,'TE_WHOLE','Grossiste',NULL,0,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (7,'TE_RETAIL','Revendeur',NULL,0,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (8,'TE_PRIVATE','Particulier',NULL,1,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (100,'TE_OTHER','Autres',NULL,1,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (231,'TE_A_RI','Responsable Inscripto (typo A)',23,0,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (232,'TE_B_RNI','Responsable No Inscripto (typo B)',23,0,NULL,0);
INSERT INTO `B65479115_c_typent` VALUES (233,'TE_C_FE','Consumidor Final/Exento (typo C)',23,0,NULL,0);




--
-- Table structure for table `B65479115_c_units`
--
CREATE TABLE `B65479115_c_units` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(3) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `short_label` varchar(5) DEFAULT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_c_units_code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_c_units`
--
INSERT INTO `B65479115_c_units` VALUES (1,'P','piece','p',1);
INSERT INTO `B65479115_c_units` VALUES (2,'SET','set','se',1);
INSERT INTO `B65479115_c_units` VALUES (3,'S','second','s',1);
INSERT INTO `B65479115_c_units` VALUES (4,'H','hour','h',1);
INSERT INTO `B65479115_c_units` VALUES (5,'D','day','d',1);
INSERT INTO `B65479115_c_units` VALUES (6,'KG','kilogram','kg',1);
INSERT INTO `B65479115_c_units` VALUES (7,'G','gram','g',1);
INSERT INTO `B65479115_c_units` VALUES (8,'M','meter','m',1);
INSERT INTO `B65479115_c_units` VALUES (9,'LM','linear meter','lm',1);
INSERT INTO `B65479115_c_units` VALUES (10,'M2','square meter','m2',1);
INSERT INTO `B65479115_c_units` VALUES (11,'M3','cubic meter','m3',1);
INSERT INTO `B65479115_c_units` VALUES (12,'L','liter','l',1);




--
-- Table structure for table `B65479115_c_ziptown`
--
CREATE TABLE `B65479115_c_ziptown` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(5) DEFAULT NULL,
  `fk_county` int(11) DEFAULT NULL,
  `fk_pays` int(11) NOT NULL DEFAULT '0',
  `zip` varchar(10) NOT NULL,
  `town` varchar(180) NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_ziptown_fk_pays` (`zip`,`town`,`fk_pays`),
  KEY `idx_c_ziptown_fk_county` (`fk_county`),
  KEY `idx_c_ziptown_fk_pays` (`fk_pays`),
  KEY `idx_c_ziptown_zip` (`zip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_c_ziptown`
--




--
-- Table structure for table `B65479115_categorie`
--
CREATE TABLE `B65479115_categorie` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_parent` int(11) NOT NULL DEFAULT '0',
  `label` varchar(180) NOT NULL,
  `type` tinyint(4) NOT NULL DEFAULT '1',
  `description` text,
  `color` varchar(8) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `visible` tinyint(4) NOT NULL DEFAULT '1',
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_categorie_ref` (`entity`,`fk_parent`,`label`,`type`),
  KEY `idx_categorie_type` (`type`),
  KEY `idx_categorie_label` (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categorie`
--




--
-- Table structure for table `B65479115_categorie_account`
--
CREATE TABLE `B65479115_categorie_account` (
  `fk_categorie` int(11) NOT NULL,
  `fk_account` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`fk_categorie`,`fk_account`),
  KEY `idx_categorie_account_fk_categorie` (`fk_categorie`),
  KEY `idx_categorie_account_fk_account` (`fk_account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categorie_account`
--




--
-- Table structure for table `B65479115_categorie_contact`
--
CREATE TABLE `B65479115_categorie_contact` (
  `fk_categorie` int(11) NOT NULL,
  `fk_socpeople` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`fk_categorie`,`fk_socpeople`),
  KEY `idx_categorie_contact_fk_categorie` (`fk_categorie`),
  KEY `idx_categorie_contact_fk_socpeople` (`fk_socpeople`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categorie_contact`
--




--
-- Table structure for table `B65479115_categorie_fournisseur`
--
CREATE TABLE `B65479115_categorie_fournisseur` (
  `fk_categorie` int(11) NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`fk_categorie`,`fk_soc`),
  KEY `idx_categorie_fournisseur_fk_categorie` (`fk_categorie`),
  KEY `idx_categorie_fournisseur_fk_societe` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categorie_fournisseur`
--




--
-- Table structure for table `B65479115_categorie_lang`
--
CREATE TABLE `B65479115_categorie_lang` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_category` int(11) NOT NULL DEFAULT '0',
  `lang` varchar(5) NOT NULL DEFAULT '0',
  `label` varchar(255) NOT NULL,
  `description` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_category_lang` (`fk_category`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categorie_lang`
--




--
-- Table structure for table `B65479115_categorie_member`
--
CREATE TABLE `B65479115_categorie_member` (
  `fk_categorie` int(11) NOT NULL,
  `fk_member` int(11) NOT NULL,
  PRIMARY KEY (`fk_categorie`,`fk_member`),
  KEY `idx_categorie_member_fk_categorie` (`fk_categorie`),
  KEY `idx_categorie_member_fk_member` (`fk_member`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categorie_member`
--




--
-- Table structure for table `B65479115_categorie_product`
--
CREATE TABLE `B65479115_categorie_product` (
  `fk_categorie` int(11) NOT NULL,
  `fk_product` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`fk_categorie`,`fk_product`),
  KEY `idx_categorie_product_fk_categorie` (`fk_categorie`),
  KEY `idx_categorie_product_fk_product` (`fk_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categorie_product`
--




--
-- Table structure for table `B65479115_categorie_project`
--
CREATE TABLE `B65479115_categorie_project` (
  `fk_categorie` int(11) NOT NULL,
  `fk_project` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`fk_categorie`,`fk_project`),
  KEY `idx_categorie_project_fk_categorie` (`fk_categorie`),
  KEY `idx_categorie_project_fk_project` (`fk_project`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categorie_project`
--




--
-- Table structure for table `B65479115_categorie_societe`
--
CREATE TABLE `B65479115_categorie_societe` (
  `fk_categorie` int(11) NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`fk_categorie`,`fk_soc`),
  KEY `idx_categorie_societe_fk_categorie` (`fk_categorie`),
  KEY `idx_categorie_societe_fk_societe` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categorie_societe`
--




--
-- Table structure for table `B65479115_categorie_user`
--
CREATE TABLE `B65479115_categorie_user` (
  `fk_categorie` int(11) NOT NULL,
  `fk_user` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`fk_categorie`,`fk_user`),
  KEY `idx_categorie_user_fk_categorie` (`fk_categorie`),
  KEY `idx_categorie_user_fk_user` (`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categorie_user`
--




--
-- Table structure for table `B65479115_categories_extrafields`
--
CREATE TABLE `B65479115_categories_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_categories_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_categories_extrafields`
--




--
-- Table structure for table `B65479115_chargesociales`
--
CREATE TABLE `B65479115_chargesociales` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(16) DEFAULT NULL,
  `date_ech` datetime NOT NULL,
  `libelle` varchar(80) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `date_creation` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_type` int(11) NOT NULL,
  `fk_account` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `amount` double(24,8) NOT NULL DEFAULT '0.00000000',
  `paye` smallint(6) NOT NULL DEFAULT '0',
  `periode` date DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_chargesociales`
--




--
-- Table structure for table `B65479115_commande`
--
CREATE TABLE `B65479115_commande` (
  `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) NOT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `date_creation` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  `date_commande` 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_user_cloture` int(11) DEFAULT NULL,
  `source` smallint(6) DEFAULT NULL,
  `fk_statut` smallint(6) DEFAULT '0',
  `amount_ht` double(24,8) DEFAULT '0.00000000',
  `remise_percent` double DEFAULT '0',
  `remise_absolue` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `tva` double(24,8) DEFAULT '0.00000000',
  `localtax1` double(24,8) DEFAULT '0.00000000',
  `localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT '0.00000000',
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `facture` tinyint(4) DEFAULT '0',
  `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,
  `date_livraison` date DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `fk_warehouse` int(11) DEFAULT NULL,
  `fk_availability` int(11) DEFAULT NULL,
  `fk_input_reason` int(11) DEFAULT NULL,
  `fk_delivery_address` int(11) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_commande_ref` (`ref`,`entity`),
  KEY `idx_commande_fk_soc` (`fk_soc`),
  KEY `idx_commande_fk_user_author` (`fk_user_author`),
  KEY `idx_commande_fk_user_valid` (`fk_user_valid`),
  KEY `idx_commande_fk_user_cloture` (`fk_user_cloture`),
  KEY `idx_commande_fk_projet` (`fk_projet`),
  KEY `idx_commande_fk_account` (`fk_account`),
  KEY `idx_commande_fk_currency` (`fk_currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_commande`
--




--
-- Table structure for table `B65479115_commande_extrafields`
--
CREATE TABLE `B65479115_commande_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_commande_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_commande_extrafields`
--




--
-- Table structure for table `B65479115_commande_fournisseur`
--
CREATE TABLE `B65479115_commande_fournisseur` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(180) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_supplier` varchar(255) DEFAULT NULL,
  `fk_soc` int(11) NOT NULL,
  `fk_projet` int(11) DEFAULT '0',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `date_creation` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_approve` datetime DEFAULT NULL,
  `date_approve2` datetime DEFAULT NULL,
  `date_commande` 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_user_approve` int(11) DEFAULT NULL,
  `fk_user_approve2` int(11) DEFAULT NULL,
  `source` smallint(6) NOT NULL,
  `fk_statut` smallint(6) DEFAULT '0',
  `billed` smallint(6) DEFAULT '0',
  `amount_ht` double(24,8) DEFAULT '0.00000000',
  `remise_percent` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `tva` double(24,8) DEFAULT '0.00000000',
  `localtax1` double(24,8) DEFAULT '0.00000000',
  `localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT '0.00000000',
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `date_livraison` datetime DEFAULT NULL,
  `fk_account` int(11) DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `fk_input_method` int(11) DEFAULT '0',
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_commande_fournisseur_ref` (`ref`,`fk_soc`,`entity`),
  KEY `idx_commande_fournisseur_fk_soc` (`fk_soc`),
  KEY `billed` (`billed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_commande_fournisseur`
--




--
-- Table structure for table `B65479115_commande_fournisseur_dispatch`
--
CREATE TABLE `B65479115_commande_fournisseur_dispatch` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_commande` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `fk_commandefourndet` int(11) DEFAULT NULL,
  `qty` float DEFAULT NULL,
  `fk_entrepot` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `batch` varchar(30) DEFAULT NULL,
  `eatby` date DEFAULT NULL,
  `sellby` date DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  KEY `idx_commande_fournisseur_dispatch_fk_commande` (`fk_commande`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_commande_fournisseur_dispatch`
--




--
-- Table structure for table `B65479115_commande_fournisseur_extrafields`
--
CREATE TABLE `B65479115_commande_fournisseur_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_commande_fournisseur_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_commande_fournisseur_extrafields`
--




--
-- Table structure for table `B65479115_commande_fournisseur_log`
--
CREATE TABLE `B65479115_commande_fournisseur_log` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datelog` datetime NOT NULL,
  `fk_commande` int(11) NOT NULL,
  `fk_statut` smallint(6) NOT NULL,
  `fk_user` int(11) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_commande_fournisseur_log`
--




--
-- Table structure for table `B65479115_commande_fournisseurdet`
--
CREATE TABLE `B65479115_commande_fournisseurdet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_commande` int(11) NOT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `ref` varchar(50) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `description` text,
  `vat_src_code` varchar(10) DEFAULT '',
  `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',
  `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',
  `special_code` int(11) DEFAULT '0',
  `rang` int(11) DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  `fk_unit` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_commande_fournisseurdet`
--




--
-- Table structure for table `B65479115_commande_fournisseurdet_extrafields`
--
CREATE TABLE `B65479115_commande_fournisseurdet_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_commande_fournisseurdet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_commande_fournisseurdet_extrafields`
--




--
-- Table structure for table `B65479115_commandedet`
--
CREATE TABLE `B65479115_commandedet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_commande` int(11) NOT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `description` text,
  `vat_src_code` varchar(10) DEFAULT '',
  `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',
  `fk_remise_except` int(11) DEFAULT NULL,
  `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,
  `import_key` varchar(14) DEFAULT NULL,
  `fk_commandefourndet` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  KEY `idx_commandedet_fk_commande` (`fk_commande`),
  KEY `idx_commandedet_fk_product` (`fk_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_commandedet`
--




--
-- Table structure for table `B65479115_commandedet_extrafields`
--
CREATE TABLE `B65479115_commandedet_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_commandedet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_commandedet_extrafields`
--




--
-- Table structure for table `B65479115_comment`
--
CREATE TABLE `B65479115_comment` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `description` text NOT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_element` int(11) DEFAULT NULL,
  `element_type` varchar(50) DEFAULT NULL,
  `entity` int(11) DEFAULT '1',
  `import_key` varchar(125) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_comment`
--




--
-- Table structure for table `B65479115_const`
--
CREATE TABLE `B65479115_const` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(180) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `value` text NOT NULL,
  `type` varchar(6) DEFAULT NULL,
  `visible` tinyint(4) NOT NULL DEFAULT '1',
  `note` text,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_const` (`name`,`entity`)
) ENGINE=InnoDB AUTO_INCREMENT=593 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_const`
--
INSERT INTO `B65479115_const` VALUES (2,'MAIN_FEATURES_LEVEL',0,0,'chaine',1,'Level of features to show: -1=stable+deprecated, 0=stable only (default), 1=stable+experimental, 2=stable+experimental+development','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (3,'MAILING_LIMIT_SENDBYWEB',0,25,'chaine',1,'Number of targets to defined packet size when sending mass email','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (4,'MAIN_ENABLE_LOG_TO_HTML',0,0,'chaine',1,'If this option is set to 1, it is possible to see log output at end of HTML sources by adding paramater logtohtml=1 on URL. Module log must also be enabled.','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (5,'MAIN_SECURITY_CSRF_WITH_TOKEN',0,0,'chaine',1,'If this option is set to 1, a CSRF protection using an antiCSRF token is added.','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (6,'SYSLOG_HANDLERS',0,'[\"mod_syslog_file\"]','chaine',0,'Which logger to use','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (7,'SYSLOG_FILE',0,'DOL_DATA_ROOT/dolibarr.log','chaine',0,'Directory where to write log file','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (8,'SYSLOG_LEVEL',0,7,'chaine',0,'Level of debug info to show','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (9,'MAIN_UPLOAD_DOC',0,2048,'chaine',0,'Max size for file upload (0 means no upload allowed)','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (10,'MAIN_ENABLE_OVERWRITE_TRANSLATION',1,1,'chaine',0,'Enable translation overwrite','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (11,'MAIN_ENABLE_DEFAULT_VALUES',1,1,'chaine',0,'Enable default value overwrite','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (16,'MAIN_SIZE_LISTE_LIMIT',0,25,'chaine',0,'Longueur maximum des listes','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (17,'MAIN_SIZE_SHORTLIST_LIMIT',0,3,'chaine',0,'Longueur maximum des listes courtes (fiche client)','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (18,'MAIN_MENU_STANDARD',0,'eldy_menu.php','chaine',0,'Menu manager for internal users','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (19,'MAIN_MENUFRONT_STANDARD',0,'eldy_menu.php','chaine',0,'Menu manager for external users','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (20,'MAIN_MENU_SMARTPHONE',0,'eldy_menu.php','chaine',0,'Menu manager for internal users using smartphones','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (21,'MAIN_MENUFRONT_SMARTPHONE',0,'eldy_menu.php','chaine',0,'Menu manager for external users using smartphones','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (22,'MAIN_DELAY_ACTIONS_TODO',1,7,'chaine',0,'Tolérance de retard avant alerte (en jours) sur actions planifiées non réalisées','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (23,'MAIN_DELAY_ORDERS_TO_PROCESS',1,2,'chaine',0,'Tolérance de retard avant alerte (en jours) sur commandes clients non traitées','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (24,'MAIN_DELAY_SUPPLIER_ORDERS_TO_PROCESS',1,7,'chaine',0,'Tolérance de retard avant alerte (en jours) sur commandes fournisseurs non traitées','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (28,'MAIN_DELAY_SUPPLIER_BILLS_TO_PAY',1,2,'chaine',0,'Tolérance de retard avant alerte (en jours) sur factures fournisseur impayées','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (33,'MAIN_DELAY_EXPENSEREPORTS_TO_PAY',1,31,'chaine',0,'Tolérance de retard avant alerte (en jours) sur les notes de frais impayées','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (34,'MAIN_FIX_FOR_BUGGED_MTA',1,1,'chaine',1,'Set constant to fix email ending from PHP with some linux ike system','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (35,'MAILING_EMAIL_FROM',1,'dolibarr@domain.com','chaine',0,'EMail emmetteur pour les envois d emailings','2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (36,'PRODUCT_ADDON_PDF_ODT_PATH',1,'DOL_DATA_ROOT/doctemplates/products','chaine',0,NULL,'2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (37,'CONTRACT_ADDON_PDF_ODT_PATH',1,'DOL_DATA_ROOT/doctemplates/contracts','chaine',0,NULL,'2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (38,'USERGROUP_ADDON_PDF_ODT_PATH',1,'DOL_DATA_ROOT/doctemplates/usergroups','chaine',0,NULL,'2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (39,'USER_ADDON_PDF_ODT_PATH',1,'DOL_DATA_ROOT/doctemplates/users','chaine',0,NULL,'2018-03-06 16:23:16');
INSERT INTO `B65479115_const` VALUES (40,'MAIN_MODULE_USER',0,1,NULL,0,'{\"authorid\":0,\"ip\":\"192.168.1.119\"}','2018-03-06 16:23:48');
INSERT INTO `B65479115_const` VALUES (42,'MAIN_SECURITY_SALT',0,20180306165058,'chaine',0,'','2018-03-06 16:23:48');
INSERT INTO `B65479115_const` VALUES (43,'MAIN_SECURITY_HASH_ALGO',0,'sha1md5','chaine',0,'','2018-03-06 16:23:48');
INSERT INTO `B65479115_const` VALUES (44,'MAIN_VERSION_FIRST_INSTALL',0,'7.0.0','chaine',0,'Dolibarr version when first install','2018-03-06 16:23:48');
INSERT INTO `B65479115_const` VALUES (45,'MAIN_VERSION_LAST_INSTALL',0,'7.0.0','chaine',0,'Dolibarr version when last install','2018-03-06 16:23:48');
INSERT INTO `B65479115_const` VALUES (47,'MAIN_MODULE_SALARIES',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:27:56');
INSERT INTO `B65479115_const` VALUES (48,'SALARIES_ACCOUNTING_ACCOUNT_PAYMENT',1,421,'chaine',0,NULL,'2018-03-06 16:27:56');
INSERT INTO `B65479115_const` VALUES (49,'SALARIES_ACCOUNTING_ACCOUNT_CHARGE',1,641,'chaine',0,NULL,'2018-03-06 16:27:56');
INSERT INTO `B65479115_const` VALUES (50,'MAIN_MODULE_EXPENSEREPORT',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:27:58');
INSERT INTO `B65479115_const` VALUES (51,'MAIN_MODULE_EXPENSEREPORT_TABS_0',1,'user:+expensereport:ExpenseReport:expensereport:$user->rights->expensereport->lire:/expensereport/list.php?mainmenu=hrm&id=__ID__','chaine',0,NULL,'2018-03-06 16:27:58');
INSERT INTO `B65479115_const` VALUES (52,'EXPENSEREPORT_ADDON_PDF',1,'standard','chaine',0,'Name of manager to build PDF expense reports documents','2018-03-06 16:27:58');
INSERT INTO `B65479115_const` VALUES (53,'EXPENSEREPORT_ADDON',1,'mod_expensereport_jade','chaine',0,'Name of manager to generate expense report ref number','2018-03-06 16:27:58');
INSERT INTO `B65479115_const` VALUES (55,'MAIN_MODULE_HOLIDAY',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:28:02');
INSERT INTO `B65479115_const` VALUES (56,'MAIN_MODULE_HOLIDAY_TABS_0',1,'user:+paidholidays:CPTitreMenu:holiday:$user->rights->holiday->read:/holiday/list.php?mainmenu=hrm&id=__ID__','chaine',0,NULL,'2018-03-06 16:28:02');
INSERT INTO `B65479115_const` VALUES (58,'ADHERENT_ADDON_PDF',1,'standard','chaine',0,'Name of PDF model of member','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (59,'ADHERENT_MAIL_RESIL',1,'Votre adhésion vient d\'être résiliée.
\nNous espérons vous revoir très bientôt','texte',0,'Mail de résiliation','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (60,'ADHERENT_MAIL_VALID',1,'Votre adhésion vient d\'être validée. 
\nVoici le rappel de vos coordonnées (toute information erronée entrainera la non validation de votre inscription) :
\n
\n__INFOS__
\n
\n','texte',0,'Mail de validation','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (61,'ADHERENT_MAIL_VALID_SUBJECT',1,'Votre adhésion a été validée','chaine',0,'Sujet du mail de validation','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (62,'ADHERENT_MAIL_RESIL_SUBJECT',1,'Résiliation de votre adhésion','chaine',0,'Sujet du mail de résiliation','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (63,'ADHERENT_MAIL_FROM',1,'','chaine',0,'From des mails','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (64,'ADHERENT_MAIL_COTIS',1,'Bonjour __FIRSTNAME__,
\nCet email confirme que votre cotisation a été reçue
\net enregistrée','texte',0,'Mail de validation de cotisation','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (65,'ADHERENT_MAIL_COTIS_SUBJECT',1,'Reçu de votre cotisation','chaine',0,'Sujet du mail de validation de cotisation','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (66,'ADHERENT_CARD_HEADER_TEXT',1,'__YEAR__','chaine',0,'Texte imprimé sur le haut de la carte adhérent','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (67,'ADHERENT_CARD_FOOTER_TEXT',1,'__COMPANY__','chaine',0,'Texte imprimé sur le bas de la carte adhérent','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (68,'ADHERENT_CARD_TEXT',1,'__FULLNAME__
\nID: __ID__
\n__EMAIL__
\n__ADDRESS__
\n__ZIP__ __TOWN__
\n__COUNTRY__','texte',0,'Text to print on member cards','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (69,'ADHERENT_MAILMAN_ADMINPW',1,'','chaine',0,'Mot de passe Admin des liste mailman','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (70,'ADHERENT_BANK_ACCOUNT',1,'','chaine',0,'ID du Compte banquaire utilise','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (71,'ADHERENT_BANK_CATEGORIE',1,'','chaine',0,'ID de la catégorie bancaire des cotisations','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (72,'ADHERENT_ETIQUETTE_TYPE',1,'L7163','chaine',0,'Type of address sheets','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (73,'ADHERENT_ETIQUETTE_TEXT',1,'__FULLNAME__\n__ADDRESS__\n__ZIP__ __TOWN__\n__COUNTRY%','texte',0,'Text to print on member address sheets','2018-03-06 16:28:10');
INSERT INTO `B65479115_const` VALUES (74,'MAIN_MODULE_FACTURE',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:29:46');
INSERT INTO `B65479115_const` VALUES (75,'FACTURE_ADDON',1,'mod_facture_terre','chaine',0,'Name of numbering numerotation rules of invoice','2018-03-06 16:29:46');
INSERT INTO `B65479115_const` VALUES (77,'FACTURE_ADDON_PDF_ODT_PATH',1,'DOL_DATA_ROOT/doctemplates/invoices','chaine',0,NULL,'2018-03-06 16:29:46');
INSERT INTO `B65479115_const` VALUES (78,'MAIN_MODULE_SOCIETE',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:29:47');
INSERT INTO `B65479115_const` VALUES (79,'SOCIETE_CODECLIENT_ADDON',1,'mod_codeclient_monkey','chaine',0,'Module to control third parties codes','2018-03-06 16:29:47');
INSERT INTO `B65479115_const` VALUES (80,'SOCIETE_CODECOMPTA_ADDON',1,'mod_codecompta_panicum','chaine',0,'Module to control third parties codes','2018-03-06 16:29:47');
INSERT INTO `B65479115_const` VALUES (82,'COMPANY_ADDON_PDF_ODT_PATH',1,'DOL_DATA_ROOT/doctemplates/thirdparties','chaine',0,NULL,'2018-03-06 16:29:47');
INSERT INTO `B65479115_const` VALUES (83,'SOCIETE_ADD_REF_IN_LIST',1,0,'yesno',0,'Display customer ref into select list','2018-03-06 16:29:47');
INSERT INTO `B65479115_const` VALUES (84,'MAIN_MODULE_TAX',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:29:50');
INSERT INTO `B65479115_const` VALUES (85,'MAIN_MODULE_LOAN',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:29:53');
INSERT INTO `B65479115_const` VALUES (86,'LOAN_ACCOUNTING_ACCOUNT_CAPITAL',1,164,'chaine',0,NULL,'2018-03-06 16:29:53');
INSERT INTO `B65479115_const` VALUES (87,'LOAN_ACCOUNTING_ACCOUNT_INSURANCE',1,6162,'chaine',0,NULL,'2018-03-06 16:29:53');
INSERT INTO `B65479115_const` VALUES (88,'MAIN_MODULE_BANQUE',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:29:58');
INSERT INTO `B65479115_const` VALUES (89,'MAIN_MODULE_PRELEVEMENT',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:30:02');
INSERT INTO `B65479115_const` VALUES (90,'BANK_ADDON_PDF',1,'sepamandate','chaine',0,'Name of manager to generate SEPA mandate','2018-03-06 16:30:02');
INSERT INTO `B65479115_const` VALUES (91,'MAIN_MODULE_MARGIN',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (92,'MAIN_MODULE_MARGIN_TABS_0',1,'product:+margin:Margins:margins:$user->rights->margins->liretous:/margin/tabs/productMargins.php?id=__ID__','chaine',0,NULL,'2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (93,'MAIN_MODULE_MARGIN_TABS_1',1,'thirdparty:+margin:Margins:margins:empty($user->societe_id) && $user->rights->margins->liretous && ($object->client > 0):/margin/tabs/thirdpartyMargins.php?socid=__ID__','chaine',0,NULL,'2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (94,'MARGIN_TYPE',1,'costprice','chaine',0,'Rule for margin calculation by default','2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (95,'MAIN_MODULE_PROPALE',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (96,'PROPALE_ADDON_PDF',1,'azur','chaine',0,'Name of the proposal generation manager in PDF format','2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (97,'PROPALE_ADDON',1,'mod_propale_marbre','chaine',0,'Name of proposal numbering manager','2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (98,'PROPALE_VALIDITY_DURATION',1,15,'chaine',0,'Duration of validity of business proposals','2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (99,'PROPALE_ADDON_PDF_ODT_PATH',1,'DOL_DATA_ROOT/doctemplates/proposals','chaine',0,NULL,'2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (100,'MAIN_MODULE_PRODUCT',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (101,'PRODUCT_CODEPRODUCT_ADDON',1,'mod_codeproduct_leopard','chaine',0,'Module to control product codes','2018-03-06 16:30:05');
INSERT INTO `B65479115_const` VALUES (104,'MAIN_COMPANY_CODE_ALWAYS_REQUIRED',1,1,'chaine',0,'With this constants on, third party code is always required whatever is numbering module behaviour','2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (105,'MAIN_BANK_ACCOUNTANCY_CODE_ALWAYS_REQUIRED',1,1,'chaine',0,'With this constants on, bank account number is always required','2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (106,'ACCOUNTING_ACCOUNT_SUSPENSE',1,471,'chaine',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (107,'ACCOUNTING_ACCOUNT_TRANSFER_CASH',1,58,'chaine',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (108,'CHARTOFACCOUNTS',1,2,'chaine',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (109,'ACCOUNTING_EXPORT_MODELCSV',1,1,'chaine',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (110,'ACCOUNTING_LENGTH_GACCOUNT',1,'','chaine',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (111,'ACCOUNTING_LENGTH_AACCOUNT',1,'','chaine',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (112,'ACCOUNTING_LIST_SORT_VENTILATION_TODO',1,1,'yesno',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (113,'ACCOUNTING_LIST_SORT_VENTILATION_DONE',1,1,'yesno',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (114,'ACCOUNTING_EXPORT_DATE',1,'%d%m%Y','chaine',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (115,'ACCOUNTING_EXPORT_SEPARATORCSV',1,',','string',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (116,'ACCOUNTING_EXPORT_FORMAT',1,'csv','chaine',0,NULL,'2018-03-06 16:30:20');
INSERT INTO `B65479115_const` VALUES (117,'MAIN_MODULE_SERVICE',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:30:26');
INSERT INTO `B65479115_const` VALUES (119,'STOCK_ALLOW_NEGATIVE_TRANSFER',1,1,'chaine',1,NULL,'2018-03-06 16:30:29');
INSERT INTO `B65479115_const` VALUES (120,'MAIN_MODULE_PROJET',1,1,NULL,0,'{\"authorid\":\"1\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:31:09');
INSERT INTO `B65479115_const` VALUES (121,'PROJECT_ADDON_PDF',1,'baleine','chaine',0,'Name of PDF/ODT project manager class','2018-03-06 16:31:09');
INSERT INTO `B65479115_const` VALUES (122,'PROJECT_ADDON',1,'mod_project_simple','chaine',0,'Name of Numbering Rule project manager class','2018-03-06 16:31:09');
INSERT INTO `B65479115_const` VALUES (123,'PROJECT_ADDON_PDF_ODT_PATH',1,'DOL_DATA_ROOT/doctemplates/projects','chaine',0,NULL,'2018-03-06 16:31:09');
INSERT INTO `B65479115_const` VALUES (124,'PROJECT_TASK_ADDON_PDF',1,'','chaine',0,'Name of PDF/ODT tasks manager class','2018-03-06 16:31:09');
INSERT INTO `B65479115_const` VALUES (125,'PROJECT_TASK_ADDON',1,'mod_task_simple','chaine',0,'Name of Numbering Rule task manager class','2018-03-06 16:31:09');
INSERT INTO `B65479115_const` VALUES (126,'PROJECT_TASK_ADDON_PDF_ODT_PATH',1,'DOL_DATA_ROOT/doctemplates/tasks','chaine',0,NULL,'2018-03-06 16:31:09');
INSERT INTO `B65479115_const` VALUES (127,'PROJECT_USE_OPPORTUNITIES',1,1,'chaine',0,NULL,'2018-03-06 16:31:09');
INSERT INTO `B65479115_const` VALUES (181,'MAIN_INFO_SOCIETE_LOGO',1,'logo.JPG','chaine',0,'','2018-03-06 16:43:10');
INSERT INTO `B65479115_const` VALUES (182,'MAIN_INFO_SOCIETE_LOGO_SMALL',1,'logo_small.jpg','chaine',0,'','2018-03-06 16:43:10');
INSERT INTO `B65479115_const` VALUES (183,'MAIN_INFO_SOCIETE_LOGO_MINI',1,'logo_mini.jpg','chaine',0,'','2018-03-06 16:43:10');
INSERT INTO `B65479115_const` VALUES (192,'MAIN_MODULE_IMPORT',1,1,NULL,0,'{\"authorid\":\"2\",\"ip\":\"192.168.1.119\"}','2018-03-06 16:53:57');
INSERT INTO `B65479115_const` VALUES (225,'MAIN_DELAY_PROJECT_TO_CLOSE',1,7,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (226,'MAIN_DELAY_TASKS_TODO',1,7,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (227,'MAIN_DELAY_PROPALS_TO_CLOSE',1,31,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (228,'MAIN_DELAY_PROPALS_TO_BILL',1,7,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (229,'MAIN_DELAY_CUSTOMER_BILLS_UNPAYED',1,10,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (230,'MAIN_DELAY_NOT_ACTIVATED_SERVICES',1,0,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (231,'MAIN_DELAY_RUNNING_SERVICES',1,0,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (232,'MAIN_DELAY_TRANSACTIONS_TO_CONCILIATE',1,62,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (233,'MAIN_DELAY_CHEQUES_TO_DEPOSIT',1,0,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (234,'MAIN_DELAY_MEMBERS',1,31,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (235,'MAIN_DELAY_EXPENSEREPORTS',1,15,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (236,'MAIN_DISABLE_METEO',1,1,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (237,'MAIN_METEO_LEVEL0',1,0,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (238,'MAIN_METEO_LEVEL1',1,10,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (239,'MAIN_METEO_LEVEL2',1,20,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (240,'MAIN_METEO_LEVEL3',1,30,'chaine',0,'','2018-03-06 17:03:37');
INSERT INTO `B65479115_const` VALUES (367,'MAIN_MODULE_FOURNISSEUR',1,1,NULL,0,'{\"authorid\":\"2\",\"ip\":\"192.168.1.119\"}','2018-03-06 17:36:47');
INSERT INTO `B65479115_const` VALUES (368,'COMMANDE_SUPPLIER_ADDON_PDF',1,'muscadet','chaine',0,'Nom du gestionnaire de generation des bons de commande en PDF','2018-03-06 17:36:47');
INSERT INTO `B65479115_const` VALUES (369,'COMMANDE_SUPPLIER_ADDON_NUMBER',1,'mod_commande_fournisseur_muguet','chaine',0,'Nom du gestionnaire de numerotation des commandes fournisseur','2018-03-06 17:36:47');
INSERT INTO `B65479115_const` VALUES (370,'INVOICE_SUPPLIER_ADDON_NUMBER',1,'mod_facture_fournisseur_cactus','chaine',0,'Nom du gestionnaire de numerotation des factures fournisseur','2018-03-06 17:36:47');
INSERT INTO `B65479115_const` VALUES (371,'MAIN_MODULE_COMPTABILITE',1,1,NULL,0,'{\"authorid\":\"2\",\"ip\":\"192.168.1.119\"}','2018-03-06 17:43:19');
INSERT INTO `B65479115_const` VALUES (372,'ACCOUNTING_MODE',1,'CREANCES-DETTES','chaine',0,'','2018-03-06 17:45:44');
INSERT INTO `B65479115_const` VALUES (378,'PRELEVEMENT_ID_BANKACCOUNT',1,2,'chaine',0,'','2018-03-06 18:13:49');
INSERT INTO `B65479115_const` VALUES (379,'PRELEVEMENT_USER',1,1,'chaine',0,'','2018-03-06 18:13:49');
INSERT INTO `B65479115_const` VALUES (467,'FACTURE_ADDON_PDF',1,'addapta','chaine',0,'','2018-03-07 09:54:37');
INSERT INTO `B65479115_const` VALUES (486,'MAIN_BOXES_MAXLINES',1,5,'',0,'','2018-03-09 14:59:18');
INSERT INTO `B65479115_const` VALUES (495,'MAIN_MENU_STANDARD',1,'eldy_menu.php','chaine',0,'','2018-03-09 15:04:00');
INSERT INTO `B65479115_const` VALUES (496,'MAIN_MENU_SMARTPHONE',1,'eldy_menu.php','chaine',0,'','2018-03-09 15:04:00');
INSERT INTO `B65479115_const` VALUES (497,'MAIN_MENUFRONT_STANDARD',1,'eldy_menu.php','chaine',0,'','2018-03-09 15:04:00');
INSERT INTO `B65479115_const` VALUES (498,'MAIN_MENUFRONT_SMARTPHONE',1,'eldy_menu.php','chaine',0,'','2018-03-09 15:04:00');
INSERT INTO `B65479115_const` VALUES (500,'MAIN_MENU_HIDE_UNAUTHORIZED',1,1,'chaine',0,'','2018-03-09 15:04:53');
INSERT INTO `B65479115_const` VALUES (501,'MAIN_LANG_DEFAULT',1,'es_ES','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (502,'MAIN_MULTILANGS',1,0,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (503,'MAIN_THEME',1,'md','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (504,'THEME_ELDY_TOPMENU_BACK1',1,'255,170,86','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (505,'THEME_ELDY_VERMENU_BACK1',1,'255,227,201','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (506,'THEME_ELDY_LINEIMPAIR1',1,'255,255,255','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (507,'THEME_ELDY_LINEIMPAIR2',1,'255,255,255','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (508,'THEME_ELDY_LINEPAIR1',1,'255,227,201','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (509,'THEME_ELDY_LINEPAIR2',1,'255,227,201','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (510,'THEME_ELDY_USE_HOVER',1,'ff7f00','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (511,'MAIN_SIZE_LISTE_LIMIT',1,100,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (512,'MAIN_SIZE_SHORTLIST_LIMIT',1,3,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (513,'MAIN_DISABLE_JAVASCRIPT',1,0,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (514,'MAIN_BUTTON_HIDE_UNAUTHORIZED',1,1,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (515,'MAIN_START_WEEK',1,1,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (516,'MAIN_DEFAULT_WORKING_DAYS',1,'1-5','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (517,'MAIN_DEFAULT_WORKING_HOURS',1,'9-18','chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (518,'MAIN_SHOW_LOGO',1,1,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (519,'MAIN_FIRSTNAME_NAME_POSITION',1,0,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (520,'MAIN_HELPCENTER_DISABLELINK',0,1,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (521,'MAIN_HELP_DISABLELINK',0,1,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (522,'MAIN_BUGTRACK_ENABLELINK',1,0,'chaine',0,'','2018-03-09 15:05:50');
INSERT INTO `B65479115_const` VALUES (523,'USER_PASSWORD_PATTERN',1,'8;1;1;1;3;1','chaine',0,'','2018-03-09 15:08:26');
INSERT INTO `B65479115_const` VALUES (525,'MAIN_DISABLE_ALL_MAILS',1,0,'chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (526,'MAIN_MAIL_SENDMODE',1,'smtps','chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (527,'MAIN_MAIL_SMTP_PORT',1,25,'chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (528,'MAIN_MAIL_SMTP_SERVER',1,'mail.addapta.com','chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (529,'MAIN_MAIL_SMTPS_ID',1,'ADM.Informacion@addapta.com','chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (530,'MAIN_MAIL_SMTPS_PW',1,'4Dd4pt422','chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (531,'MAIN_MAIL_EMAIL_TLS',1,0,'chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (532,'MAIN_MAIL_EMAIL_STARTTLS',1,0,'chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (533,'MAIN_MAIL_EMAIL_FROM',1,'ADM.Informacion@addapta.com','chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (534,'MAIN_MAIL_ERRORS_TO',1,'SIS.Arquitectura@addapta.com','chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (535,'MAIN_MAIL_AUTOCOPY_TO',1,'ADM.Facturacion@addapta.com','chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (536,'MAIN_MAIL_DEFAULT_FROMTYPE',1,'company','chaine',0,'','2018-03-09 15:20:40');
INSERT INTO `B65479115_const` VALUES (573,'MAIN_INFO_SOCIETE_COUNTRY',1,'4:ES:España','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (574,'MAIN_INFO_SOCIETE_NOM',1,'Addapta IT Partner, S.L.','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (575,'MAIN_INFO_SOCIETE_ADDRESS',1,'C/. Llull, 321','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (576,'MAIN_INFO_SOCIETE_TOWN',1,'Barcelona','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (577,'MAIN_INFO_SOCIETE_ZIP',1,'08019','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (578,'MAIN_INFO_SOCIETE_STATE',1,524,'chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (579,'MAIN_MONNAIE',1,'EUR','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (580,'MAIN_INFO_SOCIETE_TEL',1,935995018,'chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (581,'MAIN_INFO_SOCIETE_MAIL',1,'ADM.Informacion@addapta.com','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (582,'MAIN_INFO_SOCIETE_WEB',1,'http://www.addapta.com','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (583,'MAIN_INFO_CAPITAL',1,3000,'chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (584,'MAIN_INFO_SOCIETE_FORME_JURIDIQUE',1,405,'chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (585,'MAIN_INFO_SIREN',1,'B67182907','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (586,'MAIN_INFO_APE',1,6202,'chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (587,'SOCIETE_FISCAL_MONTH_START',1,1,'chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (588,'FACTURE_TVAOPTION',1,1,'chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (589,'FACTURE_LOCAL_TAX1_OPTION',1,'localtax1off','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (590,'FACTURE_LOCAL_TAX2_OPTION',1,'localtax2off','chaine',0,'','2018-03-12 14:20:31');
INSERT INTO `B65479115_const` VALUES (592,'SYSTEMTOOLS_MYSQLDUMP',1,'/usr/bin/mysqldump','chaine',0,'','2018-03-13 09:48:34');




--
-- Table structure for table `B65479115_contrat`
--
CREATE TABLE `B65479115_contrat` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(255) DEFAULT NULL,
  `ref_customer` varchar(255) DEFAULT NULL,
  `ref_supplier` varchar(255) DEFAULT NULL,
  `ref_ext` varchar(255) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `date_contrat` datetime DEFAULT NULL,
  `statut` smallint(6) DEFAULT '0',
  `mise_en_service` datetime DEFAULT NULL,
  `fin_validite` datetime DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  `fk_soc` int(11) NOT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `fk_commercial_signature` int(11) DEFAULT NULL,
  `fk_commercial_suivi` int(11) DEFAULT NULL,
  `fk_user_author` int(11) NOT NULL DEFAULT '0',
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_mise_en_service` int(11) DEFAULT NULL,
  `fk_user_cloture` int(11) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_contrat_ref` (`ref`,`entity`),
  KEY `idx_contrat_fk_soc` (`fk_soc`),
  KEY `idx_contrat_fk_user_author` (`fk_user_author`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_contrat`
--




--
-- Table structure for table `B65479115_contrat_extrafields`
--
CREATE TABLE `B65479115_contrat_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_contrat_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_contrat_extrafields`
--




--
-- Table structure for table `B65479115_contratdet`
--
CREATE TABLE `B65479115_contratdet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_contrat` int(11) NOT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `statut` smallint(6) DEFAULT '0',
  `label` text,
  `description` text,
  `fk_remise_except` int(11) DEFAULT NULL,
  `date_commande` datetime DEFAULT NULL,
  `date_ouverture_prevue` datetime DEFAULT NULL,
  `date_ouverture` datetime DEFAULT NULL,
  `date_fin_validite` datetime DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  `vat_src_code` varchar(10) DEFAULT '',
  `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 NOT NULL,
  `remise_percent` double DEFAULT '0',
  `subprice` double(24,8) DEFAULT '0.00000000',
  `price_ht` double DEFAULT NULL,
  `remise` double DEFAULT '0',
  `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 '1',
  `info_bits` int(11) DEFAULT '0',
  `buy_price_ht` double(24,8) DEFAULT NULL,
  `fk_product_fournisseur_price` int(11) DEFAULT NULL,
  `fk_user_author` int(11) NOT NULL DEFAULT '0',
  `fk_user_ouverture` int(11) DEFAULT NULL,
  `fk_user_cloture` int(11) DEFAULT NULL,
  `commentaire` text,
  `fk_unit` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  KEY `idx_contratdet_fk_contrat` (`fk_contrat`),
  KEY `idx_contratdet_fk_product` (`fk_product`),
  KEY `idx_contratdet_date_ouverture_prevue` (`date_ouverture_prevue`),
  KEY `idx_contratdet_date_ouverture` (`date_ouverture`),
  KEY `idx_contratdet_date_fin_validite` (`date_fin_validite`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_contratdet`
--




--
-- Table structure for table `B65479115_contratdet_extrafields`
--
CREATE TABLE `B65479115_contratdet_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_contratdet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_contratdet_extrafields`
--




--
-- Table structure for table `B65479115_contratdet_log`
--
CREATE TABLE `B65479115_contratdet_log` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_contratdet` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `statut` smallint(6) NOT NULL,
  `fk_user_author` int(11) NOT NULL,
  `commentaire` text,
  PRIMARY KEY (`rowid`),
  KEY `idx_contratdet_log_fk_contratdet` (`fk_contratdet`),
  KEY `idx_contratdet_log_date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_contratdet_log`
--




--
-- Table structure for table `B65479115_cronjob`
--
CREATE TABLE `B65479115_cronjob` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `jobtype` varchar(10) NOT NULL,
  `label` text NOT NULL,
  `command` varchar(255) DEFAULT NULL,
  `classesname` varchar(255) DEFAULT NULL,
  `objectname` varchar(255) DEFAULT NULL,
  `methodename` varchar(255) DEFAULT NULL,
  `params` text,
  `md5params` varchar(32) DEFAULT NULL,
  `module_name` varchar(255) DEFAULT NULL,
  `priority` int(11) DEFAULT '0',
  `datelastrun` datetime DEFAULT NULL,
  `datenextrun` datetime DEFAULT NULL,
  `datestart` datetime DEFAULT NULL,
  `dateend` datetime DEFAULT NULL,
  `datelastresult` datetime DEFAULT NULL,
  `lastresult` text,
  `lastoutput` text,
  `unitfrequency` varchar(255) NOT NULL DEFAULT '3600',
  `frequency` int(11) NOT NULL DEFAULT '0',
  `maxrun` int(11) NOT NULL DEFAULT '0',
  `nbrun` int(11) DEFAULT NULL,
  `autodelete` int(11) DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '1',
  `processing` int(11) NOT NULL DEFAULT '0',
  `test` varchar(255) DEFAULT '1',
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_mod` int(11) DEFAULT NULL,
  `fk_mailing` int(11) DEFAULT NULL,
  `note` text,
  `libname` varchar(255) DEFAULT NULL,
  `entity` int(11) DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `idx_cronjob_status` (`status`),
  KEY `idx_cronjob_datelastrun` (`datelastrun`),
  KEY `idx_cronjob_datenextrun` (`datenextrun`),
  KEY `idx_cronjob_datestart` (`datestart`),
  KEY `idx_cronjob_dateend` (`dateend`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_cronjob`
--
INSERT INTO `B65479115_cronjob` VALUES (1,'2018-03-06 16:29:46','2018-03-06 16:56:57','method','RecurringInvoices',NULL,'compta/facture/class/facture-rec.class.php','FactureRec','createRecurringInvoices',NULL,NULL,'facture',50,NULL,NULL,'2018-03-06 16:56:57',NULL,NULL,NULL,NULL,86400,1,0,NULL,0,1,0,1,NULL,NULL,NULL,'Generate recurring invoices',NULL,1);




--
-- Table structure for table `B65479115_default_values`
--
CREATE TABLE `B65479115_default_values` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `type` varchar(10) DEFAULT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `page` varchar(255) DEFAULT NULL,
  `param` varchar(255) DEFAULT NULL,
  `value` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_default_values` (`type`,`entity`,`user_id`,`page`,`param`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_default_values`
--




--
-- Table structure for table `B65479115_deplacement`
--
CREATE TABLE `B65479115_deplacement` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dated` datetime DEFAULT NULL,
  `fk_user` int(11) NOT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `type` varchar(12) NOT NULL,
  `fk_statut` int(11) NOT NULL DEFAULT '1',
  `km` double DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT '0',
  `note_private` text,
  `note_public` text,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_deplacement`
--




--
-- Table structure for table `B65479115_document_model`
--
CREATE TABLE `B65479115_document_model` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `type` varchar(20) NOT NULL,
  `libelle` varchar(255) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_document_model` (`nom`,`type`,`entity`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_document_model`
--
INSERT INTO `B65479115_document_model` VALUES (1,'standard',1,'expensereport',NULL,NULL);
INSERT INTO `B65479115_document_model` VALUES (2,'standard',1,'member',NULL,NULL);
INSERT INTO `B65479115_document_model` VALUES (4,'sepamandate',1,'bankaccount',NULL,NULL);
INSERT INTO `B65479115_document_model` VALUES (5,'azur',1,'propal',NULL,NULL);
INSERT INTO `B65479115_document_model` VALUES (6,'',1,'task',NULL,NULL);
INSERT INTO `B65479115_document_model` VALUES (7,'muscadet',1,'order_supplier',NULL,NULL);
INSERT INTO `B65479115_document_model` VALUES (9,'addapta',1,'invoice','addapta',NULL);




--
-- Table structure for table `B65479115_don`
--
CREATE TABLE `B65479115_don` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `datedon` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `fk_payment` int(11) DEFAULT NULL,
  `paid` smallint(6) NOT NULL DEFAULT '0',
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `societe` varchar(50) DEFAULT NULL,
  `address` text,
  `zip` varchar(30) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `fk_country` int(11) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(24) DEFAULT NULL,
  `phone_mobile` varchar(24) DEFAULT NULL,
  `public` smallint(6) NOT NULL DEFAULT '1',
  `fk_projet` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `fk_user_author` int(11) NOT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_don`
--




--
-- Table structure for table `B65479115_don_extrafields`
--
CREATE TABLE `B65479115_don_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_don_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_don_extrafields`
--




--
-- Table structure for table `B65479115_ecm_directories`
--
CREATE TABLE `B65479115_ecm_directories` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(64) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_parent` int(11) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `cachenbofdoc` int(11) NOT NULL DEFAULT '0',
  `fullpath` varchar(750) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `date_c` datetime DEFAULT NULL,
  `date_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_c` int(11) DEFAULT NULL,
  `fk_user_m` int(11) DEFAULT NULL,
  `acl` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_ecm_directories` (`label`,`fk_parent`,`entity`),
  KEY `idx_ecm_directories_fk_user_c` (`fk_user_c`),
  KEY `idx_ecm_directories_fk_user_m` (`fk_user_m`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_ecm_directories`
--




--
-- Table structure for table `B65479115_ecm_files`
--
CREATE TABLE `B65479115_ecm_files` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) DEFAULT NULL,
  `label` varchar(128) NOT NULL,
  `share` varchar(128) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `filepath` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `src_object_type` varchar(32) DEFAULT NULL,
  `src_object_id` int(11) DEFAULT NULL,
  `fullpath_orig` varchar(750) DEFAULT NULL,
  `description` text,
  `keywords` varchar(750) DEFAULT NULL,
  `cover` text,
  `position` int(11) DEFAULT NULL,
  `gen_or_uploaded` varchar(12) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `date_c` datetime DEFAULT NULL,
  `date_m` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_c` int(11) DEFAULT NULL,
  `fk_user_m` int(11) DEFAULT NULL,
  `acl` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_ecm_files` (`filepath`,`filename`),
  KEY `idx_ecm_files_label` (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_ecm_files`
--




--
-- Table structure for table `B65479115_element_contact`
--
CREATE TABLE `B65479115_element_contact` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datecreate` datetime DEFAULT NULL,
  `statut` smallint(6) DEFAULT '5',
  `element_id` int(11) NOT NULL,
  `fk_c_type_contact` int(11) NOT NULL,
  `fk_socpeople` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_element_contact_idx1` (`element_id`,`fk_c_type_contact`,`fk_socpeople`),
  KEY `idx_element_contact_fk_socpeople` (`fk_socpeople`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_element_contact`
--




--
-- Table structure for table `B65479115_element_element`
--
CREATE TABLE `B65479115_element_element` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_source` int(11) NOT NULL,
  `sourcetype` varchar(32) NOT NULL,
  `fk_target` int(11) NOT NULL,
  `targettype` varchar(32) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_element_element_idx1` (`fk_source`,`sourcetype`,`fk_target`,`targettype`),
  KEY `idx_element_element_fk_target` (`fk_target`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_element_element`
--




--
-- Table structure for table `B65479115_element_resources`
--
CREATE TABLE `B65479115_element_resources` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `element_id` int(11) DEFAULT NULL,
  `element_type` varchar(64) DEFAULT NULL,
  `resource_id` int(11) DEFAULT NULL,
  `resource_type` varchar(64) DEFAULT NULL,
  `busy` int(11) DEFAULT NULL,
  `mandatory` int(11) DEFAULT NULL,
  `duree` double DEFAULT NULL,
  `fk_user_create` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_element_resources_idx1` (`resource_id`,`resource_type`,`element_id`,`element_type`),
  KEY `idx_element_element_element_id` (`element_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_element_resources`
--




--
-- Table structure for table `B65479115_entrepot`
--
CREATE TABLE `B65479115_entrepot` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(255) NOT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `entity` int(11) NOT NULL DEFAULT '1',
  `description` text,
  `lieu` varchar(64) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `fk_departement` int(11) DEFAULT NULL,
  `fk_pays` int(11) DEFAULT '0',
  `statut` tinyint(4) DEFAULT '1',
  `fk_user_author` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `fk_parent` int(11) DEFAULT '0',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_entrepot_label` (`ref`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_entrepot`
--




--
-- Table structure for table `B65479115_establishment`
--
CREATE TABLE `B65479115_establishment` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `name` 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',
  `profid1` varchar(20) DEFAULT NULL,
  `profid2` varchar(20) DEFAULT NULL,
  `profid3` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `fk_user_author` int(11) NOT NULL,
  `fk_user_mod` int(11) DEFAULT NULL,
  `datec` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_establishment`
--




--
-- Table structure for table `B65479115_event_element`
--
CREATE TABLE `B65479115_event_element` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_source` int(11) NOT NULL,
  `fk_target` int(11) NOT NULL,
  `targettype` varchar(32) NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_event_element`
--




--
-- Table structure for table `B65479115_events`
--
CREATE TABLE `B65479115_events` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(32) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `dateevent` datetime DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `description` varchar(250) NOT NULL,
  `ip` varchar(250) NOT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `fk_object` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_events_dateevent` (`dateevent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_events`
--




--
-- Table structure for table `B65479115_expedition`
--
CREATE TABLE `B65479115_expedition` (
  `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,
  `fk_projet` int(11) DEFAULT NULL,
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_int` varchar(255) DEFAULT NULL,
  `ref_customer` varchar(255) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `date_delivery` datetime DEFAULT NULL,
  `date_expedition` datetime DEFAULT NULL,
  `fk_address` int(11) DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `tracking_number` varchar(50) DEFAULT NULL,
  `fk_statut` smallint(6) DEFAULT '0',
  `billed` smallint(6) DEFAULT '0',
  `height` float DEFAULT NULL,
  `width` float DEFAULT NULL,
  `size_units` int(11) DEFAULT NULL,
  `size` float DEFAULT NULL,
  `weight_units` int(11) DEFAULT NULL,
  `weight` float DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_expedition_uk_ref` (`ref`,`entity`),
  KEY `idx_expedition_fk_soc` (`fk_soc`),
  KEY `idx_expedition_fk_user_author` (`fk_user_author`),
  KEY `idx_expedition_fk_user_valid` (`fk_user_valid`),
  KEY `idx_expedition_fk_shipping_method` (`fk_shipping_method`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_expedition`
--




--
-- Table structure for table `B65479115_expedition_extrafields`
--
CREATE TABLE `B65479115_expedition_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_expedition_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_expedition_extrafields`
--




--
-- Table structure for table `B65479115_expeditiondet`
--
CREATE TABLE `B65479115_expeditiondet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_expedition` int(11) NOT NULL,
  `fk_origin_line` int(11) DEFAULT NULL,
  `fk_entrepot` int(11) DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `rang` int(11) DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `idx_expeditiondet_fk_expedition` (`fk_expedition`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_expeditiondet`
--




--
-- Table structure for table `B65479115_expeditiondet_batch`
--
CREATE TABLE `B65479115_expeditiondet_batch` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_expeditiondet` int(11) NOT NULL,
  `eatby` date DEFAULT NULL,
  `sellby` date DEFAULT NULL,
  `batch` varchar(30) DEFAULT NULL,
  `qty` double NOT NULL DEFAULT '0',
  `fk_origin_stock` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_fk_expeditiondet` (`fk_expeditiondet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_expeditiondet_batch`
--




--
-- Table structure for table `B65479115_expeditiondet_extrafields`
--
CREATE TABLE `B65479115_expeditiondet_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_expeditiondet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_expeditiondet_extrafields`
--




--
-- Table structure for table `B65479115_expensereport`
--
CREATE TABLE `B65479115_expensereport` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(50) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_number_int` int(11) DEFAULT NULL,
  `ref_ext` int(11) DEFAULT NULL,
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `total_tva` double(24,8) DEFAULT '0.00000000',
  `localtax1` double(24,8) DEFAULT '0.00000000',
  `localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT '0.00000000',
  `date_debut` date NOT NULL,
  `date_fin` date NOT NULL,
  `date_create` datetime NOT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_approve` datetime DEFAULT NULL,
  `date_refuse` datetime DEFAULT NULL,
  `date_cancel` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_author` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_user_validator` int(11) DEFAULT NULL,
  `fk_user_approve` int(11) DEFAULT NULL,
  `fk_user_refuse` int(11) DEFAULT NULL,
  `fk_user_cancel` int(11) DEFAULT NULL,
  `fk_statut` int(11) NOT NULL,
  `fk_c_paiement` int(11) DEFAULT NULL,
  `paid` smallint(6) NOT NULL DEFAULT '0',
  `note_public` text,
  `note_private` text,
  `detail_refuse` varchar(255) DEFAULT NULL,
  `detail_cancel` varchar(255) DEFAULT NULL,
  `integration_compta` int(11) DEFAULT NULL,
  `fk_bank_account` int(11) DEFAULT NULL,
  `model_pdf` varchar(50) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_expensereport_uk_ref` (`ref`,`entity`),
  KEY `idx_expensereport_date_debut` (`date_debut`),
  KEY `idx_expensereport_date_fin` (`date_fin`),
  KEY `idx_expensereport_fk_statut` (`fk_statut`),
  KEY `idx_expensereport_fk_user_author` (`fk_user_author`),
  KEY `idx_expensereport_fk_user_valid` (`fk_user_valid`),
  KEY `idx_expensereport_fk_user_approve` (`fk_user_approve`),
  KEY `idx_expensereport_fk_refuse` (`fk_user_approve`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_expensereport`
--




--
-- Table structure for table `B65479115_expensereport_det`
--
CREATE TABLE `B65479115_expensereport_det` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_expensereport` int(11) NOT NULL,
  `fk_c_type_fees` int(11) NOT NULL,
  `fk_c_exp_tax_cat` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `comments` text NOT NULL,
  `product_type` int(11) DEFAULT '-1',
  `qty` double NOT NULL,
  `value_unit` double NOT NULL,
  `remise_percent` double DEFAULT NULL,
  `vat_src_code` varchar(10) DEFAULT '',
  `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,
  `total_ht` double(24,8) NOT NULL DEFAULT '0.00000000',
  `total_tva` double(24,8) NOT NULL DEFAULT '0.00000000',
  `total_localtax1` double(24,8) DEFAULT '0.00000000',
  `total_localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) NOT NULL DEFAULT '0.00000000',
  `date` date NOT NULL,
  `info_bits` int(11) DEFAULT '0',
  `special_code` int(11) DEFAULT '0',
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  `fk_facture` int(11) DEFAULT '0',
  `fk_code_ventilation` int(11) DEFAULT '0',
  `rang` int(11) DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  `rule_warning_message` text,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_expensereport_det`
--




--
-- Table structure for table `B65479115_expensereport_extrafields`
--
CREATE TABLE `B65479115_expensereport_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_expensereport_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_expensereport_extrafields`
--




--
-- Table structure for table `B65479115_expensereport_ik`
--
CREATE TABLE `B65479115_expensereport_ik` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_c_exp_tax_cat` int(11) NOT NULL DEFAULT '0',
  `fk_range` int(11) NOT NULL DEFAULT '0',
  `coef` double NOT NULL DEFAULT '0',
  `ikoffset` double NOT NULL DEFAULT '0',
  `active` int(11) DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_expensereport_ik`
--
INSERT INTO `B65479115_expensereport_ik` VALUES (1,NULL,'2018-03-06 16:23:16',4,1,0.41,0,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (2,NULL,'2018-03-06 16:23:16',4,2,0.244,824,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (3,NULL,'2018-03-06 16:23:16',4,3,0.286,0,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (4,NULL,'2018-03-06 16:23:16',5,4,0.493,0,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (5,NULL,'2018-03-06 16:23:16',5,5,0.277,1082,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (6,NULL,'2018-03-06 16:23:16',5,6,0.332,0,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (7,NULL,'2018-03-06 16:23:16',6,7,0.543,0,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (8,NULL,'2018-03-06 16:23:16',6,8,0.305,1180,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (9,NULL,'2018-03-06 16:23:16',6,9,0.364,0,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (10,NULL,'2018-03-06 16:23:16',7,10,0.568,0,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (11,NULL,'2018-03-06 16:23:16',7,11,0.32,1244,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (12,NULL,'2018-03-06 16:23:16',7,12,0.382,0,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (13,NULL,'2018-03-06 16:23:16',8,13,0.595,0,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (14,NULL,'2018-03-06 16:23:16',8,14,0.337,1288,1);
INSERT INTO `B65479115_expensereport_ik` VALUES (15,NULL,'2018-03-06 16:23:16',8,15,0.401,0,1);




--
-- Table structure for table `B65479115_expensereport_rules`
--
CREATE TABLE `B65479115_expensereport_rules` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dates` datetime NOT NULL,
  `datee` datetime NOT NULL,
  `amount` double(24,8) NOT NULL,
  `restrictive` tinyint(4) NOT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `fk_usergroup` int(11) DEFAULT NULL,
  `fk_c_type_fees` int(11) NOT NULL,
  `code_expense_rules_type` varchar(50) NOT NULL,
  `is_for_all` tinyint(4) DEFAULT '0',
  `entity` int(11) DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_expensereport_rules`
--




--
-- Table structure for table `B65479115_export_compta`
--
CREATE TABLE `B65479115_export_compta` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(12) NOT NULL,
  `date_export` datetime NOT NULL,
  `fk_user` int(11) NOT NULL,
  `note` text,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_export_compta`
--




--
-- Table structure for table `B65479115_export_model`
--
CREATE TABLE `B65479115_export_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,
  `filter` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_export_model` (`label`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_export_model`
--




--
-- Table structure for table `B65479115_extrafields`
--
CREATE TABLE `B65479115_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `elementtype` varchar(64) NOT NULL DEFAULT 'member',
  `label` varchar(255) NOT NULL,
  `type` varchar(8) DEFAULT NULL,
  `size` varchar(8) DEFAULT NULL,
  `fieldcomputed` text,
  `fielddefault` varchar(255) DEFAULT NULL,
  `fieldunique` int(11) DEFAULT '0',
  `fieldrequired` int(11) DEFAULT '0',
  `perms` varchar(255) DEFAULT NULL,
  `enabled` varchar(255) DEFAULT NULL,
  `pos` int(11) DEFAULT '0',
  `alwayseditable` int(11) DEFAULT '0',
  `param` text,
  `list` int(11) DEFAULT '1',
  `langs` varchar(64) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_extrafields_name` (`name`,`entity`,`elementtype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_extrafields`
--




--
-- Table structure for table `B65479115_facture`
--
CREATE TABLE `B65479115_facture` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `facnumber` 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,
  `type` smallint(6) NOT NULL DEFAULT '0',
  `increment` varchar(10) DEFAULT NULL,
  `fk_soc` int(11) NOT NULL,
  `datec` datetime DEFAULT NULL,
  `datef` date DEFAULT NULL,
  `date_pointoftax` date DEFAULT NULL,
  `date_valid` date DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `paye` smallint(6) NOT NULL DEFAULT '0',
  `amount` double(24,8) NOT NULL DEFAULT '0.00000000',
  `remise_percent` double DEFAULT '0',
  `remise_absolue` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `close_code` varchar(16) DEFAULT NULL,
  `close_note` varchar(128) DEFAULT NULL,
  `tva` double(24,8) DEFAULT '0.00000000',
  `localtax1` double(24,8) DEFAULT '0.00000000',
  `localtax2` double(24,8) DEFAULT '0.00000000',
  `revenuestamp` double(24,8) DEFAULT '0.00000000',
  `total` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT '0.00000000',
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_fac_rec_source` int(11) DEFAULT NULL,
  `fk_facture_source` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `fk_account` int(11) DEFAULT NULL,
  `fk_currency` varchar(3) DEFAULT NULL,
  `fk_cond_reglement` int(11) NOT NULL DEFAULT '1',
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `date_lim_reglement` date DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `situation_cycle_ref` smallint(6) DEFAULT NULL,
  `situation_counter` smallint(6) DEFAULT NULL,
  `situation_final` smallint(6) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_facture_uk_facnumber` (`facnumber`,`entity`),
  KEY `idx_facture_fk_soc` (`fk_soc`),
  KEY `idx_facture_fk_user_author` (`fk_user_author`),
  KEY `idx_facture_fk_user_valid` (`fk_user_valid`),
  KEY `idx_facture_fk_facture_source` (`fk_facture_source`),
  KEY `idx_facture_fk_projet` (`fk_projet`),
  KEY `idx_facture_fk_account` (`fk_account`),
  KEY `idx_facture_fk_currency` (`fk_currency`),
  KEY `idx_facture_fk_statut` (`fk_statut`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facture`
--




--
-- Table structure for table `B65479115_facture_extrafields`
--
CREATE TABLE `B65479115_facture_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_facture_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facture_extrafields`
--




--
-- Table structure for table `B65479115_facture_fourn`
--
CREATE TABLE `B65479115_facture_fourn` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(180) NOT NULL,
  `ref_supplier` varchar(180) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) DEFAULT NULL,
  `type` smallint(6) NOT NULL DEFAULT '0',
  `fk_soc` int(11) NOT NULL,
  `datec` datetime DEFAULT NULL,
  `datef` date DEFAULT NULL,
  `date_pointoftax` date DEFAULT NULL,
  `date_valid` date DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `libelle` varchar(255) DEFAULT NULL,
  `paye` smallint(6) NOT NULL DEFAULT '0',
  `amount` double(24,8) NOT NULL DEFAULT '0.00000000',
  `remise` double(24,8) DEFAULT '0.00000000',
  `close_code` varchar(16) DEFAULT NULL,
  `close_note` varchar(128) DEFAULT NULL,
  `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',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `total_tva` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT '0.00000000',
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_facture_source` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `fk_account` int(11) DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `date_lim_reglement` date DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_facture_fourn_ref` (`ref`,`entity`),
  UNIQUE KEY `uk_facture_fourn_ref_supplier` (`ref_supplier`,`fk_soc`,`entity`),
  KEY `idx_facture_fourn_date_lim_reglement` (`date_lim_reglement`),
  KEY `idx_facture_fourn_fk_soc` (`fk_soc`),
  KEY `idx_facture_fourn_fk_user_author` (`fk_user_author`),
  KEY `idx_facture_fourn_fk_user_valid` (`fk_user_valid`),
  KEY `idx_facture_fourn_fk_projet` (`fk_projet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facture_fourn`
--




--
-- Table structure for table `B65479115_facture_fourn_det`
--
CREATE TABLE `B65479115_facture_fourn_det` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_facture_fourn` int(11) NOT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `ref` varchar(50) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `description` text,
  `pu_ht` double(24,8) DEFAULT NULL,
  `pu_ttc` double(24,8) DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT '0',
  `vat_src_code` varchar(10) DEFAULT '',
  `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,
  `total_ht` double(24,8) DEFAULT NULL,
  `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,
  `product_type` int(11) DEFAULT '0',
  `date_start` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `info_bits` int(11) DEFAULT '0',
  `fk_code_ventilation` int(11) NOT NULL DEFAULT '0',
  `special_code` int(11) DEFAULT '0',
  `rang` int(11) DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  `fk_unit` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  KEY `idx_facture_fourn_det_fk_facture` (`fk_facture_fourn`),
  KEY `idx_facture_fourn_det_fk_product` (`fk_product`),
  KEY `idx_facture_fourn_det_fk_code_ventilation` (`fk_code_ventilation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facture_fourn_det`
--




--
-- Table structure for table `B65479115_facture_fourn_det_extrafields`
--
CREATE TABLE `B65479115_facture_fourn_det_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_facture_fourn_det_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facture_fourn_det_extrafields`
--




--
-- Table structure for table `B65479115_facture_fourn_extrafields`
--
CREATE TABLE `B65479115_facture_fourn_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_facture_fourn_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facture_fourn_extrafields`
--




--
-- Table structure for table `B65479115_facture_rec`
--
CREATE TABLE `B65479115_facture_rec` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `titre` varchar(100) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_soc` int(11) NOT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `suspended` int(11) DEFAULT '0',
  `amount` double(24,8) NOT NULL DEFAULT '0.00000000',
  `remise` double DEFAULT '0',
  `remise_percent` double DEFAULT '0',
  `remise_absolue` double DEFAULT '0',
  `vat_src_code` varchar(10) DEFAULT '',
  `tva` double(24,8) DEFAULT '0.00000000',
  `localtax1` double(24,8) DEFAULT '0.00000000',
  `localtax2` double(24,8) DEFAULT '0.00000000',
  `revenuestamp` double(24,8) DEFAULT '0.00000000',
  `total` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT '0.00000000',
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT '0',
  `fk_mode_reglement` int(11) DEFAULT '0',
  `date_lim_reglement` date DEFAULT NULL,
  `fk_account` int(11) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `modelpdf` varchar(255) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  `usenewprice` int(11) DEFAULT '0',
  `frequency` int(11) DEFAULT NULL,
  `unit_frequency` varchar(2) DEFAULT 'm',
  `date_when` datetime DEFAULT NULL,
  `date_last_gen` datetime DEFAULT NULL,
  `nb_gen_done` int(11) DEFAULT NULL,
  `nb_gen_max` int(11) DEFAULT NULL,
  `auto_validate` int(11) DEFAULT '0',
  `generate_pdf` int(11) DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_facture_rec_uk_titre` (`titre`,`entity`),
  KEY `idx_facture_rec_fk_soc` (`fk_soc`),
  KEY `idx_facture_rec_fk_user_author` (`fk_user_author`),
  KEY `idx_facture_rec_fk_projet` (`fk_projet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facture_rec`
--




--
-- Table structure for table `B65479115_facture_rec_extrafields`
--
CREATE TABLE `B65479115_facture_rec_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_facture_rec_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facture_rec_extrafields`
--




--
-- Table structure for table `B65479115_facturedet`
--
CREATE TABLE `B65479115_facturedet` (
  `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,
  `label` varchar(255) DEFAULT NULL,
  `description` text,
  `vat_src_code` varchar(10) DEFAULT '',
  `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',
  `fk_remise_except` int(11) DEFAULT NULL,
  `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,
  `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,
  `fk_code_ventilation` int(11) NOT NULL DEFAULT '0',
  `special_code` int(11) DEFAULT '0',
  `rang` int(11) DEFAULT '0',
  `fk_contract_line` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `situation_percent` double DEFAULT NULL,
  `fk_prev_id` int(11) DEFAULT NULL,
  `fk_unit` int(11) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_fk_remise_except` (`fk_remise_except`,`fk_facture`),
  KEY `idx_facturedet_fk_facture` (`fk_facture`),
  KEY `idx_facturedet_fk_product` (`fk_product`),
  KEY `idx_facturedet_fk_code_ventilation` (`fk_code_ventilation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facturedet`
--




--
-- Table structure for table `B65479115_facturedet_extrafields`
--
CREATE TABLE `B65479115_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 `B65479115_facturedet_extrafields`
--




--
-- Table structure for table `B65479115_facturedet_rec`
--
CREATE TABLE `B65479115_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,
  `vat_src_code` varchar(10) DEFAULT '',
  `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,
  `import_key` varchar(14) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facturedet_rec`
--




--
-- Table structure for table `B65479115_facturedet_rec_extrafields`
--
CREATE TABLE `B65479115_facturedet_rec_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_rec_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_facturedet_rec_extrafields`
--




--
-- Table structure for table `B65479115_fichinter`
--
CREATE TABLE `B65479115_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,
  `ref_ext` varchar(255) DEFAULT 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',
  `dateo` date DEFAULT NULL,
  `datee` date DEFAULT NULL,
  `datet` date DEFAULT NULL,
  `duree` double DEFAULT NULL,
  `description` text,
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_fichinter_ref` (`ref`,`entity`),
  KEY `idx_fichinter_fk_soc` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_fichinter`
--




--
-- Table structure for table `B65479115_fichinter_extrafields`
--
CREATE TABLE `B65479115_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 `B65479115_fichinter_extrafields`
--




--
-- Table structure for table `B65479115_fichinterdet`
--
CREATE TABLE `B65479115_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_fichinterdet`
--




--
-- Table structure for table `B65479115_fichinterdet_extrafields`
--
CREATE TABLE `B65479115_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 `B65479115_fichinterdet_extrafields`
--




--
-- Table structure for table `B65479115_holiday`
--
CREATE TABLE `B65479115_holiday` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) DEFAULT NULL,
  `ref_ext` varchar(255) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_user` int(11) NOT NULL,
  `fk_user_create` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_type` int(11) NOT 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,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_holiday_entity` (`entity`),
  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 `B65479115_holiday`
--




--
-- Table structure for table `B65479115_holiday_config`
--
CREATE TABLE `B65479115_holiday_config` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `value` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_holiday_config` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_holiday_config`
--
INSERT INTO `B65479115_holiday_config` VALUES (1,'lastUpdate',20180306182514);




--
-- Table structure for table `B65479115_holiday_logs`
--
CREATE TABLE `B65479115_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,
  `fk_type` int(11) NOT NULL,
  `type_action` varchar(255) NOT NULL,
  `prev_solde` varchar(255) NOT NULL,
  `new_solde` varchar(255) NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_holiday_logs`
--




--
-- Table structure for table `B65479115_holiday_users`
--
CREATE TABLE `B65479115_holiday_users` (
  `fk_user` int(11) NOT NULL,
  `fk_type` int(11) NOT NULL,
  `nb_holiday` double NOT NULL DEFAULT '0',
  UNIQUE KEY `uk_holiday_users` (`fk_user`,`fk_type`,`nb_holiday`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_holiday_users`
--




--
-- Table structure for table `B65479115_import_model`
--
CREATE TABLE `B65479115_import_model` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL DEFAULT '0',
  `label` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `field` text NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_import_model` (`label`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_import_model`
--
INSERT INTO `B65479115_import_model` VALUES (1,2,'ImpTerceros','societe_1','2=s.nom,3=s.status,4=s.client,5=s.fournisseur,8=s.code_client,9=s.code_fournisseur,10=s.code_compta,11=s.code_compta_fournisseur,12=s.address,13=s.zip,14=s.town,15=s.fk_departement,16=s.fk_pays,17=s.phone,18=s.fax,19=s.url,20=s.email,22=s.siren,23=s.siret,24=s.ape,25=s.idprof4,26=s.idprof5,27=s.idprof6,28=s.tva_intra,29=s.capital,30=s.note_private,31=s.note_public,32=s.fk_typent,33=s.fk_effectif,34=s.fk_forme_juridique,35=s.fk_prospectlevel,36=s.fk_stcomm,21=s.default_lang,39=s.barcode,6=s.datec');




--
-- Table structure for table `B65479115_inventory`
--
CREATE TABLE `B65479115_inventory` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT '0',
  `ref` varchar(48) DEFAULT NULL,
  `date_creation` 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,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_warehouse` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `date_inventory` datetime DEFAULT NULL,
  `date_validation` datetime DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_inventory_ref` (`ref`,`entity`),
  KEY `idx_inventory_tms` (`tms`),
  KEY `idx_inventory_date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_inventory`
--




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

--
-- Dumping data for table `B65479115_inventorydet`
--




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

--
-- Dumping data for table `B65479115_links`
--




--
-- Table structure for table `B65479115_livraison`
--
CREATE TABLE `B65479115_livraison` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ref` varchar(30) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_soc` int(11) NOT NULL,
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_int` varchar(255) DEFAULT NULL,
  `ref_customer` varchar(255) 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,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_livraison_uk_ref` (`ref`,`entity`),
  KEY `idx_livraison_fk_soc` (`fk_soc`),
  KEY `idx_livraison_fk_user_author` (`fk_user_author`),
  KEY `idx_livraison_fk_user_valid` (`fk_user_valid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_livraison`
--




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

--
-- Dumping data for table `B65479115_livraison_extrafields`
--




--
-- Table structure for table `B65479115_livraisondet`
--
CREATE TABLE `B65479115_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_livraisondet`
--




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

--
-- Dumping data for table `B65479115_livraisondet_extrafields`
--




--
-- Table structure for table `B65479115_loan`
--
CREATE TABLE `B65479115_loan` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `label` varchar(80) NOT NULL,
  `fk_bank` int(11) DEFAULT NULL,
  `capital` double(24,8) NOT NULL DEFAULT '0.00000000',
  `datestart` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `nbterm` double DEFAULT NULL,
  `rate` double NOT NULL,
  `note_private` text,
  `note_public` text,
  `capital_position` double(24,8) DEFAULT '0.00000000',
  `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_projet` int(11) 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 `B65479115_loan`
--




--
-- Table structure for table `B65479115_loan_schedule`
--
CREATE TABLE `B65479115_loan_schedule` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_loan` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount_capital` double(24,8) DEFAULT '0.00000000',
  `amount_insurance` double(24,8) DEFAULT '0.00000000',
  `amount_interest` double(24,8) DEFAULT '0.00000000',
  `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 `B65479115_loan_schedule`
--




--
-- Table structure for table `B65479115_localtax`
--
CREATE TABLE `B65479115_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 `B65479115_localtax`
--




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

--
-- Dumping data for table `B65479115_mailing`
--




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

--
-- Dumping data for table `B65479115_mailing_cibles`
--




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

--
-- Dumping data for table `B65479115_menu`
--
INSERT INTO `B65479115_menu` VALUES (1,'all',1,'margins','left','billing','margins',-1,'billing',NULL,100,'/margin/index.php','','Margins','margins',NULL,'$user->rights->margins->liretous','$conf->margin->enabled',2,'2018-03-06 16:30:05');




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

--
-- Dumping data for table `B65479115_multicurrency`
--




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

--
-- Dumping data for table `B65479115_multicurrency_rate`
--




--
-- Table structure for table `B65479115_notify`
--
CREATE TABLE `B65479115_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,
  `fk_contact` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `type` varchar(16) DEFAULT 'email',
  `type_target` varchar(16) 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 `B65479115_notify`
--




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

--
-- Dumping data for table `B65479115_notify_def`
--




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

--
-- Dumping data for table `B65479115_notify_def_object`
--




--
-- Table structure for table `B65479115_oauth_state`
--
CREATE TABLE `B65479115_oauth_state` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `service` varchar(36) DEFAULT NULL,
  `state` varchar(128) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `fk_adherent` int(11) DEFAULT NULL,
  `entity` int(11) DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_oauth_state`
--




--
-- Table structure for table `B65479115_oauth_token`
--
CREATE TABLE `B65479115_oauth_token` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `service` varchar(36) DEFAULT NULL,
  `token` text,
  `fk_user` int(11) DEFAULT NULL,
  `fk_adherent` int(11) DEFAULT NULL,
  `entity` int(11) DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_oauth_token`
--




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

--
-- Dumping data for table `B65479115_onlinesignature`
--




--
-- Table structure for table `B65479115_opensurvey_comments`
--
CREATE TABLE `B65479115_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 `B65479115_opensurvey_comments`
--




--
-- Table structure for table `B65479115_opensurvey_formquestions`
--
CREATE TABLE `B65479115_opensurvey_formquestions` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `id_sondage` varchar(16) DEFAULT NULL,
  `question` text,
  `available_answers` text,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_opensurvey_formquestions`
--




--
-- Table structure for table `B65479115_opensurvey_sondage`
--
CREATE TABLE `B65479115_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 DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `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 `B65479115_opensurvey_sondage`
--




--
-- Table structure for table `B65479115_opensurvey_user_formanswers`
--
CREATE TABLE `B65479115_opensurvey_user_formanswers` (
  `fk_user_survey` int(11) NOT NULL,
  `fk_question` int(11) NOT NULL,
  `reponses` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_opensurvey_user_formanswers`
--




--
-- Table structure for table `B65479115_opensurvey_user_studs`
--
CREATE TABLE `B65479115_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 `B65479115_opensurvey_user_studs`
--




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

--
-- Dumping data for table `B65479115_overwrite_trans`
--




--
-- Table structure for table `B65479115_paiement`
--
CREATE TABLE `B65479115_paiement` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) NOT NULL,
  `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',
  `multicurrency_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 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_paiement`
--




--
-- Table structure for table `B65479115_paiement_facture`
--
CREATE TABLE `B65479115_paiement_facture` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_paiement` int(11) DEFAULT NULL,
  `fk_facture` int(11) DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_paiement_facture` (`fk_paiement`,`fk_facture`),
  KEY `idx_paiement_facture_fk_facture` (`fk_facture`),
  KEY `idx_paiement_facture_fk_paiement` (`fk_paiement`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_paiement_facture`
--




--
-- Table structure for table `B65479115_paiementcharge`
--
CREATE TABLE `B65479115_paiementcharge` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_charge` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `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 `B65479115_paiementcharge`
--




--
-- Table structure for table `B65479115_paiementfourn`
--
CREATE TABLE `B65479115_paiementfourn` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) DEFAULT NULL,
  `entity` int(11) DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  `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',
  `model_pdf` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_paiementfourn`
--




--
-- Table structure for table `B65479115_paiementfourn_facturefourn`
--
CREATE TABLE `B65479115_paiementfourn_facturefourn` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_paiementfourn` int(11) DEFAULT NULL,
  `fk_facturefourn` int(11) DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_paiementfourn_facturefourn` (`fk_paiementfourn`,`fk_facturefourn`),
  KEY `idx_paiementfourn_facturefourn_fk_facture` (`fk_facturefourn`),
  KEY `idx_paiementfourn_facturefourn_fk_paiement` (`fk_paiementfourn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_paiementfourn_facturefourn`
--




--
-- Table structure for table `B65479115_payment_donation`
--
CREATE TABLE `B65479115_payment_donation` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_donation` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `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 `B65479115_payment_donation`
--




--
-- Table structure for table `B65479115_payment_expensereport`
--
CREATE TABLE `B65479115_payment_expensereport` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_expensereport` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `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 `B65479115_payment_expensereport`
--




--
-- Table structure for table `B65479115_payment_loan`
--
CREATE TABLE `B65479115_payment_loan` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_loan` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount_capital` double(24,8) DEFAULT '0.00000000',
  `amount_insurance` double(24,8) DEFAULT '0.00000000',
  `amount_interest` double(24,8) DEFAULT '0.00000000',
  `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 `B65479115_payment_loan`
--




--
-- Table structure for table `B65479115_payment_salary`
--
CREATE TABLE `B65479115_payment_salary` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `fk_user` int(11) NOT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `salary` double(24,8) DEFAULT NULL,
  `amount` double(24,8) NOT NULL DEFAULT '0.00000000',
  `fk_typepayment` int(11) NOT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `datesp` date DEFAULT NULL,
  `dateep` date DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `note` text,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_payment_salary_ref` (`num_payment`),
  KEY `idx_payment_salary_user` (`fk_user`,`entity`),
  KEY `idx_payment_salary_datep` (`datep`),
  KEY `idx_payment_salary_datesp` (`datesp`),
  KEY `idx_payment_salary_dateep` (`dateep`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_payment_salary`
--




--
-- Table structure for table `B65479115_payment_various`
--
CREATE TABLE `B65479115_payment_various` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `num_payment` varchar(50) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `sens` smallint(6) NOT NULL DEFAULT '0',
  `amount` double(24,8) NOT NULL DEFAULT '0.00000000',
  `fk_typepayment` int(11) NOT NULL,
  `accountancy_code` varchar(32) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `note` text,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_payment_various`
--




--
-- Table structure for table `B65479115_prelevement_bons`
--
CREATE TABLE `B65479115_prelevement_bons` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(12) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `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 `B65479115_prelevement_bons`
--




--
-- Table structure for table `B65479115_prelevement_facture`
--
CREATE TABLE `B65479115_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_prelevement_facture`
--




--
-- Table structure for table `B65479115_prelevement_facture_demande`
--
CREATE TABLE `B65479115_prelevement_facture_demande` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_facture` int(11) NOT NULL,
  `amount` double(24,8) 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(128) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_prelevement_facture_demande`
--




--
-- Table structure for table `B65479115_prelevement_lignes`
--
CREATE TABLE `B65479115_prelevement_lignes` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_prelevement_bons` int(11) DEFAULT NULL,
  `fk_soc` int(11) NOT NULL,
  `statut` smallint(6) DEFAULT '0',
  `client_nom` varchar(255) DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `code_banque` varchar(128) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  `note` text,
  PRIMARY KEY (`rowid`),
  KEY `idx_prelevement_lignes_fk_prelevement_bons` (`fk_prelevement_bons`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_prelevement_lignes`
--




--
-- Table structure for table `B65479115_prelevement_rejet`
--
CREATE TABLE `B65479115_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 `B65479115_prelevement_rejet`
--




--
-- Table structure for table `B65479115_printing`
--
CREATE TABLE `B65479115_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 `B65479115_printing`
--




--
-- Table structure for table `B65479115_product`
--
CREATE TABLE `B65479115_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,
  `fk_parent` int(11) DEFAULT '0',
  `label` varchar(255) NOT NULL,
  `description` text,
  `note_public` 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',
  `cost_price` double(24,8) DEFAULT NULL,
  `default_vat_code` varchar(10) DEFAULT NULL,
  `tva_tx` double(6,3) DEFAULT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) NOT NULL DEFAULT '0',
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `tosell` tinyint(4) DEFAULT '1',
  `tobuy` tinyint(4) DEFAULT '1',
  `onportal` tinyint(4) DEFAULT '0',
  `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 NULL,
  `url` varchar(255) DEFAULT NULL,
  `barcode` varchar(180) DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT NULL,
  `accountancy_code_sell` varchar(32) DEFAULT NULL,
  `accountancy_code_sell_intra` varchar(32) DEFAULT NULL,
  `accountancy_code_sell_export` 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,
  `width` float DEFAULT NULL,
  `width_units` tinyint(4) DEFAULT NULL,
  `height` float DEFAULT NULL,
  `height_units` tinyint(4) DEFAULT NULL,
  `surface` float DEFAULT NULL,
  `surface_units` tinyint(4) DEFAULT NULL,
  `volume` float DEFAULT NULL,
  `volume_units` tinyint(4) DEFAULT NULL,
  `stock` double DEFAULT NULL,
  `pmp` double(24,8) NOT NULL DEFAULT '0.00000000',
  `fifo` double(24,8) DEFAULT NULL,
  `lifo` double(24,8) DEFAULT NULL,
  `canvas` varchar(32) DEFAULT NULL,
  `finished` tinyint(4) DEFAULT NULL,
  `hidden` tinyint(4) DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `fk_price_expression` int(11) DEFAULT NULL,
  `desiredstock` int(11) DEFAULT '0',
  `fk_unit` int(11) DEFAULT NULL,
  `price_autogen` tinyint(4) DEFAULT '0',
  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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product`
--




--
-- Table structure for table `B65479115_product_association`
--
CREATE TABLE `B65479115_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 `B65479115_product_association`
--




--
-- Table structure for table `B65479115_product_attribute`
--
CREATE TABLE `B65479115_product_attribute` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `rang` int(11) NOT NULL DEFAULT '0',
  `entity` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_attribute_ref` (`ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_attribute`
--




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

--
-- Dumping data for table `B65479115_product_attribute_combination`
--




--
-- Table structure for table `B65479115_product_attribute_combination2val`
--
CREATE TABLE `B65479115_product_attribute_combination2val` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_prod_combination` int(11) NOT NULL,
  `fk_prod_attr` int(11) NOT NULL,
  `fk_prod_attr_val` int(11) NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_attribute_combination2val`
--




--
-- Table structure for table `B65479115_product_attribute_value`
--
CREATE TABLE `B65479115_product_attribute_value` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product_attribute` int(11) NOT NULL,
  `ref` varchar(180) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_attribute_value` (`fk_product_attribute`,`ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_attribute_value`
--




--
-- Table structure for table `B65479115_product_batch`
--
CREATE TABLE `B65479115_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`),
  UNIQUE KEY `uk_product_batch` (`fk_product_stock`,`batch`),
  KEY `idx_fk_product_stock` (`fk_product_stock`),
  KEY `idx_batch` (`batch`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_batch`
--




--
-- Table structure for table `B65479115_product_customer_price`
--
CREATE TABLE `B65479115_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',
  `default_vat_code` varchar(10) DEFAULT NULL,
  `tva_tx` double(6,3) DEFAULT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) NOT NULL DEFAULT '0',
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_customer_price`
--




--
-- Table structure for table `B65479115_product_customer_price_log`
--
CREATE TABLE `B65479115_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 DEFAULT '0',
  `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',
  `default_vat_code` varchar(10) DEFAULT NULL,
  `tva_tx` double(6,3) DEFAULT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) NOT NULL DEFAULT '0',
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_customer_price_log`
--




--
-- Table structure for table `B65479115_product_extrafields`
--
CREATE TABLE `B65479115_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 `B65479115_product_extrafields`
--




--
-- Table structure for table `B65479115_product_fournisseur_price`
--
CREATE TABLE `B65479115_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',
  `default_vat_code` varchar(10) DEFAULT NULL,
  `tva_tx` double(6,3) NOT NULL,
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) NOT NULL DEFAULT '0',
  `info_bits` int(11) NOT NULL DEFAULT '0',
  `fk_user` int(11) DEFAULT NULL,
  `fk_supplier_price_expression` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `delivery_time_days` int(11) DEFAULT NULL,
  `supplier_reputation` varchar(10) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_price` double(24,8) DEFAULT NULL,
  `multicurrency_price_ttc` double(24,8) 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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_fournisseur_price`
--




--
-- Table structure for table `B65479115_product_fournisseur_price_log`
--
CREATE TABLE `B65479115_product_fournisseur_price_log` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `fk_product_fournisseur` int(11) NOT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `quantity` double DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_price` double(24,8) DEFAULT NULL,
  `multicurrency_price_ttc` double(24,8) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_fournisseur_price_log`
--




--
-- Table structure for table `B65479115_product_lang`
--
CREATE TABLE `B65479115_product_lang` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product` int(11) NOT NULL DEFAULT '0',
  `lang` varchar(5) NOT NULL DEFAULT '0',
  `label` varchar(255) NOT NULL,
  `description` text,
  `note` text,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_lang` (`fk_product`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_lang`
--




--
-- Table structure for table `B65479115_product_lot`
--
CREATE TABLE `B65479115_product_lot` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT '1',
  `fk_product` int(11) NOT NULL,
  `batch` varchar(30) DEFAULT NULL,
  `eatby` date DEFAULT NULL,
  `sellby` date DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_lot` (`fk_product`,`batch`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_lot`
--




--
-- Table structure for table `B65479115_product_lot_extrafields`
--
CREATE TABLE `B65479115_product_lot_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_product_lot_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_lot_extrafields`
--




--
-- Table structure for table `B65479115_product_price`
--
CREATE TABLE `B65479115_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',
  `default_vat_code` varchar(10) DEFAULT NULL,
  `tva_tx` double(6,3) NOT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) NOT NULL DEFAULT '0',
  `fk_user_author` int(11) DEFAULT NULL,
  `tosell` tinyint(4) DEFAULT '1',
  `price_by_qty` int(11) NOT NULL DEFAULT '0',
  `fk_price_expression` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_price` double(24,8) DEFAULT NULL,
  `multicurrency_price_ttc` double(24,8) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_product_price_fk_user_author` (`fk_user_author`),
  KEY `idx_product_price_fk_product` (`fk_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_price`
--




--
-- Table structure for table `B65479115_product_price_by_qty`
--
CREATE TABLE `B65479115_product_price_by_qty` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product_price` int(11) NOT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `price_base_type` varchar(3) DEFAULT 'HT',
  `quantity` double DEFAULT NULL,
  `remise_percent` double NOT NULL DEFAULT '0',
  `remise` double NOT NULL DEFAULT '0',
  `unitprice` double(24,8) DEFAULT '0.00000000',
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_price` double(24,8) DEFAULT NULL,
  `multicurrency_price_ttc` double(24,8) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_price_by_qty_level` (`fk_product_price`,`quantity`),
  KEY `idx_product_price_by_qty_fk_product_price` (`fk_product_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_price_by_qty`
--




--
-- Table structure for table `B65479115_product_pricerules`
--
CREATE TABLE `B65479115_product_pricerules` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `level` int(11) NOT NULL,
  `fk_level` int(11) NOT NULL,
  `var_percent` float NOT NULL,
  `var_min_percent` float NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `unique_level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_pricerules`
--




--
-- Table structure for table `B65479115_product_stock`
--
CREATE TABLE `B65479115_product_stock` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product` int(11) NOT NULL,
  `fk_entrepot` int(11) NOT NULL,
  `reel` double DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_stock` (`fk_product`,`fk_entrepot`),
  KEY `idx_product_stock_fk_product` (`fk_product`),
  KEY `idx_product_stock_fk_entrepot` (`fk_entrepot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_stock`
--




--
-- Table structure for table `B65479115_product_warehouse_properties`
--
CREATE TABLE `B65479115_product_warehouse_properties` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product` int(11) NOT NULL,
  `fk_entrepot` int(11) NOT NULL,
  `seuil_stock_alerte` int(11) DEFAULT '0',
  `desiredstock` int(11) DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_product_warehouse_properties`
--




--
-- Table structure for table `B65479115_projet`
--
CREATE TABLE `B65479115_projet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dateo` date DEFAULT NULL,
  `datee` date DEFAULT NULL,
  `ref` varchar(50) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `title` varchar(255) NOT NULL,
  `description` text,
  `fk_user_creat` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `public` int(11) DEFAULT NULL,
  `fk_statut` int(11) NOT NULL DEFAULT '0',
  `fk_opp_status` int(11) DEFAULT NULL,
  `opp_percent` double(5,2) DEFAULT NULL,
  `date_close` datetime DEFAULT NULL,
  `fk_user_close` int(11) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `opp_amount` double(24,8) DEFAULT NULL,
  `budget_amount` double(24,8) DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_projet_ref` (`ref`,`entity`),
  KEY `idx_projet_fk_soc` (`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_projet`
--




--
-- Table structure for table `B65479115_projet_extrafields`
--
CREATE TABLE `B65479115_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 `B65479115_projet_extrafields`
--




--
-- Table structure for table `B65479115_projet_task`
--
CREATE TABLE `B65479115_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_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `note_private` text,
  `note_public` text,
  `rang` int(11) DEFAULT '0',
  `model_pdf` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_projet_task_ref` (`ref`,`entity`),
  KEY `idx_projet_task_fk_projet` (`fk_projet`),
  KEY `idx_projet_task_fk_user_creat` (`fk_user_creat`),
  KEY `idx_projet_task_fk_user_valid` (`fk_user_valid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_projet_task`
--




--
-- Table structure for table `B65479115_projet_task_extrafields`
--
CREATE TABLE `B65479115_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 `B65479115_projet_task_extrafields`
--




--
-- Table structure for table `B65479115_projet_task_time`
--
CREATE TABLE `B65479115_projet_task_time` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_task` int(11) NOT NULL,
  `task_date` date DEFAULT NULL,
  `task_datehour` datetime DEFAULT NULL,
  `task_date_withhour` int(11) DEFAULT '0',
  `task_duration` double DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `thm` double(24,8) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `invoice_line_id` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `datec` date DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `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 `B65479115_projet_task_time`
--




--
-- Table structure for table `B65479115_propal`
--
CREATE TABLE `B65479115_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,
  `last_main_doc` 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,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_delivery_address` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_propal_ref` (`ref`,`entity`),
  KEY `idx_propal_fk_soc` (`fk_soc`),
  KEY `idx_propal_fk_user_author` (`fk_user_author`),
  KEY `idx_propal_fk_user_valid` (`fk_user_valid`),
  KEY `idx_propal_fk_user_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_propal`
--




--
-- Table structure for table `B65479115_propal_extrafields`
--
CREATE TABLE `B65479115_propal_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_propal_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_propal_extrafields`
--




--
-- Table structure for table `B65479115_propal_merge_pdf_product`
--
CREATE TABLE `B65479115_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 `B65479115_propal_merge_pdf_product`
--




--
-- Table structure for table `B65479115_propaldet`
--
CREATE TABLE `B65479115_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,
  `vat_src_code` varchar(10) DEFAULT '',
  `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,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  KEY `idx_propaldet_fk_propal` (`fk_propal`),
  KEY `idx_propaldet_fk_product` (`fk_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_propaldet`
--




--
-- Table structure for table `B65479115_propaldet_extrafields`
--
CREATE TABLE `B65479115_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 `B65479115_propaldet_extrafields`
--




--
-- Table structure for table `B65479115_resource`
--
CREATE TABLE `B65479115_resource` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref` varchar(255) DEFAULT NULL,
  `asset_number` varchar(255) DEFAULT NULL,
  `description` text,
  `fk_code_type_resource` varchar(32) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `note_public` text,
  `note_private` text,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_country` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_resource_ref` (`ref`,`entity`),
  KEY `fk_code_type_resource_idx` (`fk_code_type_resource`),
  KEY `idx_resource_fk_country` (`fk_country`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_resource`
--




--
-- Table structure for table `B65479115_resource_extrafields`
--
CREATE TABLE `B65479115_resource_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_resource_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_resource_extrafields`
--




--
-- Table structure for table `B65479115_rights_def`
--
CREATE TABLE `B65479115_rights_def` (
  `id` int(11) NOT NULL,
  `libelle` varchar(255) DEFAULT NULL,
  `module` varchar(64) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `perms` varchar(50) DEFAULT NULL,
  `subperms` varchar(50) DEFAULT NULL,
  `type` varchar(1) DEFAULT NULL,
  `bydefault` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_rights_def`
--
INSERT INTO `B65479115_rights_def` VALUES (11,'Read invoices','facture',1,'lire',NULL,'a',0);
INSERT INTO `B65479115_rights_def` VALUES (12,'Create and update invoices','facture',1,'creer',NULL,'a',0);
INSERT INTO `B65479115_rights_def` VALUES (13,'Devalidate invoices','facture',1,'invoice_advance','unvalidate','a',0);
INSERT INTO `B65479115_rights_def` VALUES (14,'Validate invoices','facture',1,'invoice_advance','validate','a',0);
INSERT INTO `B65479115_rights_def` VALUES (15,'Send invoices by email','facture',1,'invoice_advance','send','a',0);
INSERT INTO `B65479115_rights_def` VALUES (16,'Issue payments on invoices','facture',1,'paiement',NULL,'a',0);
INSERT INTO `B65479115_rights_def` VALUES (19,'Delete invoices','facture',1,'supprimer',NULL,'a',0);
INSERT INTO `B65479115_rights_def` VALUES (21,'Read commercial proposals','propale',1,'lire',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (22,'Create and update commercial proposals','propale',1,'creer',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (24,'Validate commercial proposals','propale',1,'propal_advance','validate','d',0);
INSERT INTO `B65479115_rights_def` VALUES (25,'Send commercial proposals to customers','propale',1,'propal_advance','send','d',0);
INSERT INTO `B65479115_rights_def` VALUES (26,'Close commercial proposals','propale',1,'cloturer',NULL,'d',0);
INSERT INTO `B65479115_rights_def` VALUES (27,'Delete commercial proposals','propale',1,'supprimer',NULL,'d',0);
INSERT INTO `B65479115_rights_def` VALUES (28,'Exporting commercial proposals and attributes','propale',1,'export',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (31,'Lire les produits','produit',1,'lire',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (32,'Creer/modifier les produits','produit',1,'creer',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (34,'Supprimer les produits','produit',1,'supprimer',NULL,'d',0);
INSERT INTO `B65479115_rights_def` VALUES (38,'Exporter les produits','produit',1,'export',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (41,'Read projects and tasks (shared projects or projects I am contact for). Can also enter time consumed on assigned tasks (timesheet)','projet',1,'lire',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (42,'Create/modify projects and tasks (shared projects or projects I am contact for)','projet',1,'creer',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (44,'Delete project and tasks (shared projects or projects I am contact for)','projet',1,'supprimer',NULL,'d',0);
INSERT INTO `B65479115_rights_def` VALUES (45,'Export projects','projet',1,'export',NULL,'d',0);
INSERT INTO `B65479115_rights_def` VALUES (91,'Lire les charges','tax',1,'charges','lire','r',0);
INSERT INTO `B65479115_rights_def` VALUES (92,'Creer/modifier les charges','tax',1,'charges','creer','w',0);
INSERT INTO `B65479115_rights_def` VALUES (93,'Supprimer les charges','tax',1,'charges','supprimer','d',0);
INSERT INTO `B65479115_rights_def` VALUES (94,'Exporter les charges','tax',1,'charges','export','r',0);
INSERT INTO `B65479115_rights_def` VALUES (95,'Lire CA, bilans, resultats','compta',1,'resultat','lire','r',0);
INSERT INTO `B65479115_rights_def` VALUES (111,'Lire les comptes bancaires','banque',1,'lire',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (112,'Creer/modifier montant/supprimer ecriture bancaire','banque',1,'modifier',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (113,'Configurer les comptes bancaires (creer, gerer categories)','banque',1,'configurer',NULL,'a',0);
INSERT INTO `B65479115_rights_def` VALUES (114,'Rapprocher les ecritures bancaires','banque',1,'consolidate',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (115,'Exporter transactions et releves','banque',1,'export',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (116,'Virements entre comptes','banque',1,'transfer',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (117,'Gerer les envois de cheques','banque',1,'cheque',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (121,'Read third parties','societe',1,'lire',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (122,'Create and update third parties','societe',1,'creer',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (125,'Delete third parties','societe',1,'supprimer',NULL,'d',0);
INSERT INTO `B65479115_rights_def` VALUES (126,'Export third parties','societe',1,'export',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (141,'Read all projects and tasks (also private projects I am not contact for)','projet',1,'all','lire','r',0);
INSERT INTO `B65479115_rights_def` VALUES (142,'Create/modify all projects and tasks (also private projects I am not contact for). Can also enter time consumed on assigned tasks (timesheet)','projet',1,'all','creer','w',0);
INSERT INTO `B65479115_rights_def` VALUES (144,'Delete all projects and tasks (also private projects I am not contact for)','projet',1,'all','supprimer','d',0);
INSERT INTO `B65479115_rights_def` VALUES (151,'Read direct debit payment orders','prelevement',1,'bons','lire','r',0);
INSERT INTO `B65479115_rights_def` VALUES (152,'Create/modify a direct debit payment order','prelevement',1,'bons','creer','w',0);
INSERT INTO `B65479115_rights_def` VALUES (153,'Send/Transmit direct debit payment orders','prelevement',1,'bons','send','a',0);
INSERT INTO `B65479115_rights_def` VALUES (154,'Record Credits/Rejects of direct debit payment orders','prelevement',1,'bons','credit','a',0);
INSERT INTO `B65479115_rights_def` VALUES (251,'Consulter les autres utilisateurs','user',1,'user','lire','r',0);
INSERT INTO `B65479115_rights_def` VALUES (252,'Consulter les permissions des autres utilisateurs','user',1,'user_advance','readperms','r',0);
INSERT INTO `B65479115_rights_def` VALUES (253,'Creer/modifier utilisateurs internes et externes','user',1,'user','creer','w',0);
INSERT INTO `B65479115_rights_def` VALUES (254,'Creer/modifier utilisateurs externes seulement','user',1,'user_advance','write','w',0);

INSERT INTO `B65479115_rights_def` VALUES (256,'Supprimer ou desactiver les autres utilisateurs','user',1,'user','supprimer','d',0);
INSERT INTO `B65479115_rights_def` VALUES (262,'Read all third parties by internal users (otherwise only if commercial contact). Not effective for external users (limited to themselves).','societe',1,'client','voir','r',0);
INSERT INTO `B65479115_rights_def` VALUES (281,'Read contacts','societe',1,'contact','lire','r',0);
INSERT INTO `B65479115_rights_def` VALUES (282,'Create and update contact','societe',1,'contact','creer','w',0);
INSERT INTO `B65479115_rights_def` VALUES (283,'Delete contacts','societe',1,'contact','supprimer','d',0);
INSERT INTO `B65479115_rights_def` VALUES (286,'Export contacts','societe',1,'contact','export','d',0);
INSERT INTO `B65479115_rights_def` VALUES (341,'Consulter ses propres permissions','user',1,'self_advance','readperms','r',0);
INSERT INTO `B65479115_rights_def` VALUES (342,'Creer/modifier ses propres infos utilisateur','user',1,'self','creer','w',0);

INSERT INTO `B65479115_rights_def` VALUES (344,'Modifier ses propres permissions','user',1,'self_advance','writeperms','w',0);
INSERT INTO `B65479115_rights_def` VALUES (351,'Consulter les groupes','user',1,'group_advance','read','r',0);
INSERT INTO `B65479115_rights_def` VALUES (352,'Consulter les permissions des groupes','user',1,'group_advance','readperms','r',0);
INSERT INTO `B65479115_rights_def` VALUES (353,'Creer/modifier les groupes et leurs permissions','user',1,'group_advance','write','w',0);
INSERT INTO `B65479115_rights_def` VALUES (354,'Supprimer ou desactiver les groupes','user',1,'group_advance','delete','d',0);
INSERT INTO `B65479115_rights_def` VALUES (358,'Exporter les utilisateurs','user',1,'user','export','r',0);
INSERT INTO `B65479115_rights_def` VALUES (501,'Read employee contracts/salaries','salaries',1,'read',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (502,'Create/modify employee contracts/salaries','salaries',1,'write',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (511,'Read payment of salaries','salaries',1,'payment','read','w',0);
INSERT INTO `B65479115_rights_def` VALUES (512,'Create/modify payment of salaries','salaries',1,'payment','write','w',0);
INSERT INTO `B65479115_rights_def` VALUES (514,'Delete contracts/salaries','salaries',1,'delete',NULL,'d',0);
INSERT INTO `B65479115_rights_def` VALUES (517,'Export employee contracts and salaries payments','salaries',1,'export',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (520,'Read loans','loan',1,'read',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (522,'Create/modify loans','loan',1,'write',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (524,'Delete loans','loan',1,'delete',NULL,'d',0);
INSERT INTO `B65479115_rights_def` VALUES (525,'Access loan calculator','loan',1,'calc',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (527,'Export loans','loan',1,'export',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (531,'Lire les services','service',1,'lire',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (532,'Creer/modifier les services','service',1,'creer',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (534,'Supprimer les services','service',1,'supprimer',NULL,'d',0);
INSERT INTO `B65479115_rights_def` VALUES (538,'Exporter les services','service',1,'export',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (771,'Read expense reports (yours and your subordinates)','expensereport',1,'lire',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (772,'Create/modify expense reports','expensereport',1,'creer',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (773,'Delete expense reports','expensereport',1,'supprimer',NULL,'d',0);
INSERT INTO `B65479115_rights_def` VALUES (775,'Approve expense reports','expensereport',1,'approve',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (776,'Pay expense reports','expensereport',1,'to_paid',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (777,'Read expense reports of everybody','expensereport',1,'readall',NULL,'r',1);
INSERT INTO `B65479115_rights_def` VALUES (778,'Create expense reports for everybody','expensereport',1,'writeall_advance',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (779,'Export expense reports','expensereport',1,'export',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (1181,'Consulter les fournisseurs','fournisseur',1,'lire',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (1182,'Consulter les commandes fournisseur','fournisseur',1,'commande','lire','r',0);
INSERT INTO `B65479115_rights_def` VALUES (1183,'Creer une commande fournisseur','fournisseur',1,'commande','creer','w',0);
INSERT INTO `B65479115_rights_def` VALUES (1184,'Valider une commande fournisseur','fournisseur',1,'supplier_order_advance','validate','w',0);
INSERT INTO `B65479115_rights_def` VALUES (1185,'Approuver une commande fournisseur','fournisseur',1,'commande','approuver','w',0);
INSERT INTO `B65479115_rights_def` VALUES (1186,'Commander une commande fournisseur','fournisseur',1,'commande','commander','w',0);
INSERT INTO `B65479115_rights_def` VALUES (1187,'Receptionner une commande fournisseur','fournisseur',1,'commande','receptionner','d',0);
INSERT INTO `B65479115_rights_def` VALUES (1188,'Supprimer une commande fournisseur','fournisseur',1,'commande','supprimer','d',0);
INSERT INTO `B65479115_rights_def` VALUES (1189,'Check/Uncheck a supplier order reception','fournisseur',1,'commande_advance','check','w',0);
INSERT INTO `B65479115_rights_def` VALUES (1231,'Consulter les factures fournisseur','fournisseur',1,'facture','lire','r',0);
INSERT INTO `B65479115_rights_def` VALUES (1232,'Creer une facture fournisseur','fournisseur',1,'facture','creer','w',0);
INSERT INTO `B65479115_rights_def` VALUES (1233,'Valider une facture fournisseur','fournisseur',1,'supplier_invoice_advance','validate','w',0);
INSERT INTO `B65479115_rights_def` VALUES (1234,'Supprimer une facture fournisseur','fournisseur',1,'facture','supprimer','d',0);
INSERT INTO `B65479115_rights_def` VALUES (1235,'Envoyer les factures par mail','fournisseur',1,'supplier_invoice_advance','send','a',0);
INSERT INTO `B65479115_rights_def` VALUES (1236,'Exporter les factures fournisseurs, attributs et reglements','fournisseur',1,'facture','export','r',0);
INSERT INTO `B65479115_rights_def` VALUES (1237,'Exporter les commande fournisseurs, attributs','fournisseur',1,'commande','export','r',0);
INSERT INTO `B65479115_rights_def` VALUES (1251,'Run mass imports of external data (data load)','import',1,'run',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (1321,'Export customer invoices, attributes and payments','facture',1,'facture','export','r',0);
INSERT INTO `B65479115_rights_def` VALUES (1322,'Re-open a fully paid invoice','facture',1,'invoice_advance','reopen','r',0);
INSERT INTO `B65479115_rights_def` VALUES (20001,'Read your own holidays','holiday',1,'read',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (20002,'Create/modify your own holidays','holiday',1,'write',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (20003,'Delete holidays','holiday',1,'delete',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (20004,'Read holidays for everybody','holiday',1,'read_all',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (20005,'Create/modify holidays for everybody','holiday',1,'write_all',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (20006,'Setup holidays of users (setup and update balance)','holiday',1,'define_holiday',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (59001,'Visualiser les marges','margins',1,'liretous',NULL,'r',0);
INSERT INTO `B65479115_rights_def` VALUES (59002,'Définir les marges','margins',1,'creer',NULL,'w',0);
INSERT INTO `B65479115_rights_def` VALUES (59003,'Read every user margin','margins',1,'read','all','r',0);




--
-- Table structure for table `B65479115_societe`
--
CREATE TABLE `B65479115_societe` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(128) DEFAULT NULL,
  `name_alias` varchar(128) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_int` varchar(255) 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',
  `fk_account` 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(24,8) DEFAULT NULL,
  `fk_stcomm` int(11) NOT NULL DEFAULT '0',
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `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,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) 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,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `tva_assuj` tinyint(4) DEFAULT '1',
  `localtax1_assuj` tinyint(4) DEFAULT '0',
  `localtax1_value` double(6,3) DEFAULT NULL,
  `localtax2_assuj` tinyint(4) DEFAULT '0',
  `localtax2_value` double(6,3) DEFAULT NULL,
  `barcode` varchar(180) 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,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` 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=377 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `B65479115_societe`
--
INSERT INTO `B65479115_societe` VALUES (189,'Isabel Rodríguez Fernández',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-12 14:17:28',1,'019',NULL,NULL,NULL,'C/. Sant Josep, 59 Baixos','08520','Les Franqueses del Vallés',0,4,0,938473075,9384924125,'www.azor-serveis.com','azor-serveis@azor-serveis.com',NULL,0,8,NULL,NULL,'52163977T',NULL,8690,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (190,'CSI Partner Spain, S.L.U.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-14 00:37:52',0,'039',NULL,NULL,NULL,'Av. Diagonal, 514 3º Local 4','08006','Barcelona',0,4,0,902442050,902442052,'www.csipartner.es','griselda.cami@csipartner.es',NULL,NULL,3,0,NULL,'B63853055',NULL,4651,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (192,'Outservico Informática, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-14 19:03:30',0,141,NULL,NULL,NULL,'Calle Tarragona, 149-151, 5ª planta','08015','Barcelona',0,4,0,NULL,NULL,'www.outservico.net','j.lizana@outservico.net',NULL,NULL,3,0,NULL,'B61717088',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (193,'Supremo Coffee Systems, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-14 19:26:52',1,'061',NULL,NULL,NULL,'Santa Margarida de Boada Vell, 21','08184','Palau-Solità i Plegamans',0,4,0,NULL,NULL,'www.supremocs.es','administracion@supremocs.es',NULL,NULL,3,0,NULL,'B65787921',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (194,'ARTEMI NOLLA GRUP GESTIÓ DE RESTAURANTS, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-14 19:50:11',1,'020',NULL,NULL,NULL,'C/ Diputació, 273, Pral.','08007','Barcelona',0,4,0,934677020,934677045,'www.angrup.com','mllop@angrup.com',NULL,NULL,3,0,NULL,'B62840673',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (195,'EDICIONES Y ESTUDIOS S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-14 20:09:51',0,'052',NULL,NULL,NULL,'C/ Enrique Larreta, 5-1ª',28036,'Madrid',0,4,0,NULL,NULL,'www.edicionesyestudios.com','jmurraca@edicionesyestudios.com',NULL,NULL,3,0,NULL,'B28921195',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (196,'Kawasaki Motors Europe NV',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-14 20:17:58',1,'036',NULL,NULL,NULL,'José Agustín Goytisolo 29 -31','08908','Hospitalet de Llobregat',0,4,0,NULL,NULL,'www.kawasaki.es','l.ensenyat@kawasaki.es',NULL,NULL,2,NULL,NULL,'W0032780I',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (197,'BRILLIANT IBÉRICA, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-14 21:00:02',1,'029',NULL,NULL,NULL,'Av. Castilla, 1, Centro Empresarial Best Point',28830,'Madrid',0,4,0,NULL,NULL,NULL,'robertoperez@icam.es',NULL,NULL,3,0,NULL,'B59147629',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (198,'everis BPO S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-14 21:22:36',1,122,NULL,NULL,NULL,'Avda Diagonal, 605','08028','Barcelona',0,4,0,917491010,NULL,NULL,'spain.supplier.invoices@everis.com',NULL,NULL,2,0,NULL,'B91251082',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (199,'PQD Análisis',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-14 22:35:52',1,'099',NULL,NULL,NULL,'C/ Ulises 108, 2ª Planta',28043,'Madrid',0,4,0,NULL,NULL,NULL,'rgranados@pqd.es',NULL,NULL,3,0,NULL,'B85769099',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (201,'TIC AND TAG CONSULTORIA, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-14 23:44:52',1,NULL,NULL,NULL,NULL,'C/. Londres, 37 5º','08029','Barcelona',0,4,0,NULL,NULL,NULL,'xlopez@tic-tag.es',NULL,NULL,3,0,NULL,'B65932469',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (203,'Telefónica de España, S.A.U.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-16 16:36:14',1,NULL,NULL,NULL,NULL,'Gran Vía, 20',28013,'Madrid',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A82018474',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (204,'Orange Spagne, S.A.U.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-16 18:03:02',1,NULL,NULL,NULL,NULL,'Paseo del Club Deportivo, 1 Edif. 8 Parque Emp. La Finca',28223,'Pozuelo de Alarcón',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A82009812',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (206,'CINC BUSINESS CENTER, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-17 11:08:03',1,NULL,NULL,NULL,NULL,'C/ Llull, 321','08019','Barcelona',0,4,0,933030060,933030080,'www.cinc.es','enric.urreta@cinc.es',NULL,0,3,0,NULL,'B17912833',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (207,'Viva Aqua Service Spain, S.A.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-17 11:20:37',1,NULL,NULL,NULL,NULL,'Calle Brosquill, S/N Pol. Ind. Nº 7',46540,'El Puig',0,4,0,638937361,NULL,NULL,'juan.canumil@viva-aquaservice.com',NULL,NULL,3,0,NULL,'A41810920',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (208,'Sociedad Estatal Correos y Telégrafos, S.A.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-17 11:27:55',1,NULL,NULL,NULL,NULL,'Vía Dublín, 7',28042,'Madrid',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A83052407',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (212,'Material Informático - Varios',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-17 12:39:29',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (213,'EMBUTIDOS Y JAMONES DIAZ S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-17 16:51:02',1,124,NULL,NULL,NULL,'C/ LLUVIA Nº 21',28918,'LEGANÉS',0,4,0,NULL,NULL,'www.jamonesyembutidosdiaz.com','info@jamonesyembutidosdiaz.com',NULL,NULL,3,0,NULL,'B83860064',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (214,'TENYCOL, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-17 17:53:32',1,142,NULL,NULL,NULL,'C/ Pisuerga, 33 Pol. Ind Sta Margarita','08223','Terrassa',0,4,0,NULL,NULL,NULL,'tonibeltran@tenycol.com',NULL,NULL,3,0,NULL,'B08264806',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (215,'CHATARRAS R. GARCIA, S.A.U.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-17 18:20:58',1,'025',NULL,NULL,NULL,'AV. VERGE DE MONTSERRAT, 10','08820','El Prat de Llobregat',0,4,0,NULL,NULL,'www.chargsa.com','ana@chargsa.com',NULL,0,3,0,NULL,'A58372525',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (216,'Asesores Titulados S.A.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-17 18:37:07',0,132,NULL,NULL,NULL,'C/ Trópico nº 6, Pol.Ind. Las Monjas Edificio ATISA',28850,'Torrejón de Ardoz',0,4,0,NULL,NULL,'www.atisa.es','m.monforte@atisa.es',NULL,NULL,3,0,NULL,'A28713667',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (217,'PC Componentes y Multimedia, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-18 15:19:31',1,NULL,NULL,NULL,NULL,'Avda Europa, 2-3 Pol.Ind. Las Salinas',30840,'Alhama de Murcia',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B73347494',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (218,'SOLRED, S.A.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-18 16:41:37',1,NULL,NULL,NULL,NULL,'Méndez Álvaro, 44',28045,'MADRID',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A79707345',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (219,'HOTEL GRILL ALCALA DE HENARES, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-03-18 17:13:39',1,NULL,NULL,NULL,NULL,'Calle Fausto Elhuyar, 3',28806,'Alcalá de Henares',0,4,0,918025612,918029741,NULL,'madrid.alcala@campanile.com',NULL,NULL,2,0,NULL,'B62949763',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (221,'Egregia Activos, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-04-07 13:13:42',1,133,NULL,NULL,NULL,'Aragón, 383 P.9','08013','Barcelona',0,4,0,NULL,NULL,NULL,'elisa.luque@egregia.net',NULL,NULL,3,0,NULL,'B66025271',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (222,'Motorlife Comunicación S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-04-10 11:04:08',0,94,NULL,NULL,NULL,'Ctra. Fuencarral a Alcobendas, 44 Edif. 6 loft L37',28110,'ALGETE',0,4,0,NULL,NULL,NULL,'msant@motorlife.es',NULL,NULL,3,0,NULL,'B85773836',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (233,'Sibaix Computers, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-04-13 17:51:09',1,NULL,NULL,NULL,NULL,'Av. Congost, 4','08760','Martorell',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B61180899',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (236,'BanSabadell Renting, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-04-17 12:29:11',1,NULL,NULL,NULL,NULL,'Parque de A.E. Can Sant Joan Calle Sena, 12','08017','Sant Cugat del Vallés',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'B60854932',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (237,'PARLEM TELECOM CIA. DE TELEC., S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-05-05 14:19:40',1,'0143',NULL,NULL,NULL,'C/ Alaba 61, 5º','08005','Barcelona',0,4,0,NULL,NULL,'www.parlem.com','emercader@parlem.com',NULL,NULL,3,0,NULL,'B65851446',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (238,'Rubes Editorial S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-05-13 13:42:35',0,80,NULL,NULL,NULL,'Girona 36, local','08010','Barcelona',0,4,0,NULL,NULL,NULL,'gerencia@rubes.es',NULL,NULL,0,NULL,NULL,'B60478351',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (239,'Desarrollos Informáticos Diusframi S.L',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-05-14 15:16:39',1,144,NULL,NULL,NULL,'Rufino González, 32',28037,'Madrid',0,4,0,NULL,NULL,NULL,'forte@did.grupodiusframi.com',NULL,NULL,2,0,NULL,'B85612950',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (240,'Magatzem d\'Idees, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-05-17 11:40:59',1,121,NULL,NULL,NULL,'Ramon Turró, 203 1P','08005','Barcelona',0,4,0,NULL,NULL,NULL,'admin@mdi-co.eu',NULL,NULL,3,0,NULL,'B60695251',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (241,'Sinergia LEDs S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-06-29 10:16:23',0,NULL,NULL,NULL,NULL,'Ronda Guinardó 62 Bajo 2 08025-Barcelona','08025','Barcelona',0,4,0,615150408,NULL,NULL,'administracion@sinergialeds.com',NULL,NULL,3,0,NULL,'B66432329',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (243,'Media Markt Diagonal Mar',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-07-14 14:13:26',1,NULL,NULL,NULL,NULL,'CC Diagonal Mar','08019','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A63736284',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (245,'Repsol Comercial de Productos Petrolíferos, SA',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-07-14 14:35:37',1,NULL,NULL,NULL,NULL,'Méndez Álvaro, 44',28045,'MADRID',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A80298839',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (246,'Qloudea - Informática Serrano Mas, SL - Fashion PC\'s',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-07-14 15:54:52',1,NULL,NULL,NULL,NULL,'Hilarión Eslava, 178','03204','Elx',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B53947149',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (247,'Serrano - Rodríguez, SCP',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-07-14 16:07:42',1,NULL,NULL,NULL,NULL,'Plomo, 10-12','08038','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'J60240116',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (249,'RENFE Viajeros, SA',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-07-14 16:25:50',1,NULL,NULL,NULL,NULL,'Avda. Pio XII, 110',28036,'Madrid',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A86868189',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (250,'Holiday Autos',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-07-14 16:59:54',1,NULL,NULL,NULL,NULL,'GLORIETA DE ATOCHA S/N',28045,'MADRID',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'E4693898K',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (251,'Hostelería Franycer, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-07-14 17:53:49',1,NULL,NULL,NULL,NULL,'CC Glorias Av. Diagonal, 280 local 405','08002','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B65049041',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (252,'Personal Computer Green, SLU',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-07-14 18:07:40',1,NULL,NULL,NULL,NULL,'SEPULVEDA, 172 TIENDA 2','08011','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B61195202',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (253,'Tagliadrians Barcot, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-07-14 18:27:30',1,NULL,NULL,NULL,NULL,'CC Glorias Av. Diagonal, 208','08010','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B64416654',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (254,'Ornina, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-07-14 18:33:48',1,NULL,NULL,NULL,NULL,'AV DIAGONAL, 661 671 HOTEL REY JUAN CARLOS I','08028','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B65344210',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (274,'SIXT RENT A CAR S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-09-07 11:59:34',1,NULL,NULL,NULL,NULL,'Carrer del Canal de Sant Jordi 29','07610','Palma de Mallorca',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'B07947591',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (275,'José Guitart',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-09-15 09:29:09',1,NULL,NULL,NULL,NULL,'Carrer del Garbell 18','08800','Vilanova i la Geltrú',0,4,0,626226604,NULL,NULL,'jose.guitart@gmail.com',NULL,NULL,8,0,NULL,'52429245D',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (276,'Eptisa Servicios de Ingeniería, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-10-01 09:57:51',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0,NULL,NULL,'www.eptisa.com/es/','raul.cuadrado@ti.eptisa.com',NULL,NULL,3,0,NULL,'B85097962',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,2,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (277,'GRUPO GENERALI ESPAÑA, Agrupación de Interés Económico',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-10-13 09:35:53',1,'062',NULL,NULL,NULL,'Calle Orense, 2',28020,'Madrid',0,4,0,NULL,NULL,NULL,'giulia.dinapoli@generali.com',NULL,NULL,2,0,NULL,'V81570335',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (290,'SOAIN SOFTWARE ASSOCIATES CORPORATION SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-10-19 18:23:12',1,NULL,NULL,NULL,NULL,'CALLE ANABEL SEGURA, 11 EDF ALBATROS A',28108,'ALCOBENDAS',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'B85083400',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (292,'GESTION DE PUNTOS DE VENTA GESPEVESA SA',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-10-20 11:29:08',1,NULL,NULL,NULL,NULL,'PASEO DE LA CASTELLANA, 257 1 IZQD.',28046,'MADRID',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'A81931214',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (296,'Material Oficina - Varios',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-10-20 12:36:45',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (298,'Parking',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-10-20 15:21:03',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (299,'YHERLA, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-11-18 11:45:14',1,118,NULL,NULL,NULL,'Paseo les Massies, 11','08780','Pallejà',0,4,0,639353070,NULL,NULL,'jordi@yherla.cat',NULL,NULL,3,0,NULL,'B60517984',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (300,'Outservico Utilities Services, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2015-12-16 21:41:00',0,NULL,NULL,NULL,NULL,'CALLE ALBASANZ, 61',28037,'MADRID',0,4,0,913756771,915041942,'www.outservico.net','a.hernandez@outservico.net',NULL,NULL,3,0,NULL,'B85417202',NULL,3514,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (302,'Marcil, SA',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-01-29 11:29:24',1,NULL,NULL,NULL,NULL,'Johann Sebastian Bach, 24','08021','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'A08510364',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (321,'ACENS TECHNOLOGIES SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-01-31 11:38:02',1,NULL,NULL,NULL,NULL,'C/ San Rafael 14',28108,'ALCOBENDAS',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B8494873',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (322,'Eptisa Tecnologías de la Información, S.A.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-02-02 09:29:39',1,NULL,NULL,NULL,NULL,'Calle Emilio Muñoz, 35-37',28037,'Madrid',0,4,0,915949500,902011530,'www.eptisa.es','raul.cuadrado@ti.eptisa.com',NULL,NULL,2,0,NULL,'A79851341',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (324,'Transportes',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-02-05 11:20:12',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (325,'Pau González Albiñana',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-03-14 19:13:39',1,NULL,NULL,NULL,NULL,'C/ Josep Carner 24','08233','Vacarisses',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,8,0,NULL,'45644168R',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (326,'ASSESSORIA CATAFAL, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-04-13 12:00:20',1,NULL,NULL,NULL,NULL,'CL BAC DE RODA 176 EN','08020','Barcelona',0,4,0,932661074,932661633,NULL,NULL,NULL,NULL,3,0,NULL,'B61511614',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (327,'ADAMO TELECOM IBERIA S.A,',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-04-13 12:21:02',1,NULL,NULL,NULL,NULL,'C/ LLACUNA, 22','08005,','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A65232357',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (328,'IKEA IBERICA, S.A.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-04-13 14:52:43',1,NULL,NULL,NULL,NULL,'AV. MATAPIÑONERA, 9',28703,'San Sebastián de los Reyes',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A28812618',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (329,'Proksa Asesores inmobiliarios, S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-04-25 06:48:55',0,146,NULL,NULL,NULL,'Rambla de Sant Sebastià , 71','08921','Santa Coloma de Gramanet',0,4,0,934686007,NULL,'www.proksa.es','p.breton@proksa.es',NULL,NULL,3,0,NULL,'B66576604',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (331,'Time Logistic S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-05-20 10:21:23',0,147,NULL,NULL,NULL,'C/ Duran I Jorda, 6-8','08960','Sant Just Desvern',0,4,0,NULL,NULL,NULL,'jariza@festina.com',NULL,NULL,2,0,NULL,'B61756490',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (332,'Daniel Rodríguez Prieto','',1,NULL,NULL,0,NULL,'2018-03-09 15:57:15','2016-06-29 10:38:28',1,NULL,'SU1803-0001',NULL,NULL,'Francesc Ferrer i Guardia, 2D Int. 6-3','08100','Mollet del Valles, España',0,4,0,649693995,NULL,NULL,'dani.rodriguez@idaliza.com',NULL,NULL,8,NULL,NULL,'46654792M','','','','','','','0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,2,1,0,NULL,NULL,NULL,NULL,NULL,1,NULL,'0.000',NULL,'0.000',NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,0,'');
INSERT INTO `B65479115_societe` VALUES (333,'VIAJES EL CORTE INGLÉS, S.A.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-07-11 19:25:00',1,NULL,NULL,NULL,NULL,'Hermosilla, 112',28009,'Madrid',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A2822981',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (334,'Peaje',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-07-12 18:42:46',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (336,'Festina Lotus S.A.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-08-01 23:53:55',0,NULL,NULL,NULL,NULL,'C/ VELAZQUEZ 150 3-1',28002,'Madrid',0,4,0,NULL,NULL,NULL,'jariza@festina.com',NULL,NULL,2,0,NULL,'A08663684',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (337,'FNAC',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-08-16 14:43:37',1,NULL,NULL,NULL,NULL,'Paseo de la Finca, 11, 2ª planta',28223,'Pozuelo de Alarcón',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A80500200',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (338,'Carrefour',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-08-16 15:21:23',1,NULL,NULL,NULL,NULL,'Calle Llacuna, 155','08018','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A28425270',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (341,'Anovo Ibérica Madrid, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-11-02 08:35:18',1,'012',NULL,NULL,NULL,'Isla de la Palma 32 Nave 15-16',28703,'San Sebastián de los Reyes',0,4,0,NULL,NULL,NULL,'jjmarcos@anovo.com',NULL,NULL,3,0,NULL,'B82479197',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (342,'GEHOZAS, SL Hotel Madrid Las Rozas',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-11-23 16:52:08',1,NULL,NULL,NULL,NULL,'Crta. A Coruña (NVI) km 22,5',28230,'Las Rozas',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'B84079649',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (343,'Awan Sport Europa S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-11-23 19:22:55',0,NULL,NULL,NULL,NULL,'C/ Modena, 30',28230,'Las Rozas',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,2,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (344,'AECSA APARCAMIENTOS ESTELA CASANOVAS S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-11-24 15:52:33',1,NULL,NULL,NULL,NULL,'Dr. August Pi i Sunyer 3 Local 2','08034','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B58630286',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (346,'FNMT - Fábrica Nacional de Moneda y Timbre',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-12-02 21:29:36',1,NULL,NULL,NULL,NULL,'C/ Jorge Juan, 106',28009,'Madrid',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,'Q2826004J',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (347,'Juan Carlos Alonso Álvarez',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2016-12-16 13:44:26',1,NULL,NULL,NULL,NULL,'Av. Diagonal, 117','08005','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,8,0,NULL,'35549354W',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (349,'Endesa',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-01-09 12:07:53',1,NULL,NULL,NULL,NULL,'Ribera del Loira, 60',28042,'Madrid',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A81948077',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (350,'Media Markt Getafe',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-01-10 14:44:04',1,NULL,NULL,NULL,NULL,'Río Guadalquivir, 13 CC Nassica',28906,'Getafe',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A62348305',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (352,'MAPFRE ESPAÑA, COMPAÑIA DE SEGUROS Y REASEGUROS SA',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-01-23 12:41:13',1,NULL,NULL,NULL,NULL,'CARRETERA DE POZUELO (M-515), 50',28222,'MAJADAHONDA',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A28141935',NULL,6512,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (353,'Apple Distribution International',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-01-23 17:50:44',1,NULL,NULL,NULL,NULL,'Hollyhill Industrial Estate',NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'N0072469J',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (354,'Banco de Sabadell, S.A.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-02-15 17:54:07',1,NULL,NULL,NULL,NULL,'Pl. de Sant Roc, 20','08205','Sabadell',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A08000143',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (355,'Precintia Internacional, S.A.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-03-19 08:30:27',1,NULL,NULL,NULL,NULL,'c/ Vic, 26-28','08120','La Llagosta',0,4,0,NULL,NULL,NULL,'jaime.baucells@precintia.com',NULL,NULL,3,0,NULL,'A08843252',NULL,2229,NULL,NULL,NULL,NULL,'2542230.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (356,'Meridiana Courier, SL - MRW',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-03-21 19:15:53',1,NULL,NULL,NULL,NULL,NULL,'08018','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B60450319',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (357,'Paradores de Turismo de España, SME, SA',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-03-23 10:39:14',1,NULL,NULL,NULL,NULL,'José Abascal, 2-4, planta 6',28003,'Madrid',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,'A79855201',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (358,'Siemens (Cornella)',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-04-05 11:02:13',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (359,'REINPE BAIX LLOBREGAT, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-04-19 15:52:26',1,'0150',NULL,NULL,NULL,'C/ FRANCESC SANTACANA, 5','08760','Martorell',0,4,0,937735151,NULL,'www.reinpe.cat','sat@reinpe.cat',NULL,0,3,0,NULL,'B59093211',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (360,'Gema E Santiago Garrido',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-05-16 11:05:35',1,NULL,NULL,NULL,NULL,'Ernest Lluch 21 2 2','08904','Hospitalet de Llobregat',0,4,0,652811977,NULL,'www.divinossabores.com','gemaesantiago@gmail.com',NULL,NULL,8,0,NULL,'46733781N',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (361,'Anticipa',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-05-28 13:40:57',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,2,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (362,'Neopost','',1,NULL,NULL,0,NULL,'2018-03-09 15:54:59','2017-06-17 08:41:06',1,'CU1803-0002',NULL,NULL,NULL,'',NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','','0.00000000',0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,2,1,0,NULL,NULL,NULL,NULL,NULL,1,NULL,'0.000',NULL,'0.000',NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,0,'');
INSERT INTO `B65479115_societe` VALUES (363,'Serlotor, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-06-20 11:30:34',1,NULL,NULL,NULL,NULL,'C/ Miquel Servet 13 Pol.ind Sesrovires','08635','Sant Esteve de Sesrrovires',0,4,0,NULL,NULL,NULL,'esther.casado@serlotor.com',NULL,NULL,3,0,NULL,'B65739278',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (364,'Hotel Izán Trujillo',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-07-11 13:06:16',1,NULL,NULL,NULL,NULL,'Plaza del Campillo, 1',10200,'Trujillo',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'B82811571',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (366,'Hotel Cristina',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-07-11 16:19:19',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'A78312469',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (367,'Hotel Ciudad de Cordoba',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-07-11 16:23:23',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'B14532147',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (368,'Jamón Jarote, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-07-12 16:22:51',1,NULL,NULL,NULL,NULL,'Av. del Matadero, 40',14440,'Villanueva de Córdoba',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B14320733',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (371,'MATTIELLO VENETO S.L.',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2017-11-29 11:18:51',1,152,NULL,NULL,NULL,'C/Joaquim Blume 7','08205','Sabadell',0,4,0,NULL,NULL,NULL,'administracion@mattielloveneto.es',NULL,NULL,3,0,NULL,'B66836909',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (372,'Nova Fincas','',1,NULL,NULL,0,NULL,'2018-03-09 15:53:51','2017-12-14 11:00:04',1,'CU1803-0001',NULL,NULL,NULL,'',NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','','0.00000000',0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,2,1,0,NULL,NULL,NULL,NULL,NULL,1,NULL,'0.000',NULL,'0.000',NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,0,'');
INSERT INTO `B65479115_societe` VALUES (374,'Hotel Entredos servicios Hoteleros, SL',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2018-01-23 20:28:35',1,NULL,NULL,NULL,NULL,NULL,37770,'Guijuelo',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'B37420940',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (375,'José Antonio Camacho Martínez',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2018-02-06 16:05:41',1,NULL,NULL,NULL,NULL,'Calle Navarra 67, atico 1','08401','Granollers',0,4,0,'+34652642129',NULL,NULL,'josecamacho85@gmail.com',NULL,0,8,0,NULL,'47703149E',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);
INSERT INTO `B65479115_societe` VALUES (376,'Copistería TPI',NULL,1,NULL,NULL,0,NULL,'2018-03-06 17:09:50','2018-02-20 12:27:21',1,NULL,NULL,NULL,NULL,'María Aguiló, 92','08005','Barcelona',0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,3,0,NULL,'46758536L',NULL,NULL,NULL,NULL,NULL,NULL,'0.00000000',0,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,0,0,0,2,NULL,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,20180306173700,NULL,NULL,NULL,NULL);




--
