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

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

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


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

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

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


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

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

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


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

CREATE TABLE `llx_societe_contacts` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `date_creation` datetime NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `fk_c_type_contact` int(11) NOT NULL,
  `fk_socpeople` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_societe_contacts_idx1` (`entity`,`fk_soc`,`fk_c_type_contact`,`fk_socpeople`),
  KEY `fk_societe_contacts_fk_c_type_contact` (`fk_c_type_contact`),
  KEY `fk_societe_contacts_fk_soc` (`fk_soc`),
  KEY `fk_societe_contacts_fk_socpeople` (`fk_socpeople`),
  CONSTRAINT `fk_societe_contacts_fk_c_type_contact` FOREIGN KEY (`fk_c_type_contact`) REFERENCES `llx_c_type_contact` (`rowid`),
  CONSTRAINT `fk_societe_contacts_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_societe_contacts_fk_socpeople` FOREIGN KEY (`fk_socpeople`) REFERENCES `llx_socpeople` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_societe_contacts` (`rowid`, `entity`, `date_creation`, `fk_soc`, `fk_c_type_contact`, `fk_socpeople`, `tms`, `import_key`) VALUES (1,2,'2022-01-11 12:53:48',25,60,1,'2022-01-11 12:53:48',NULL);

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

CREATE TABLE `llx_societe_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `signature_link` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `importaspcm_numdept` int(3) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_extrafields` (`fk_object`),
  UNIQUE KEY `uk_societe_extrafields_importaspcm_numdept` (`importaspcm_numdept`)
) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_societe_extrafields` (`rowid`, `tms`, `fk_object`, `import_key`, `signature_link`, `importaspcm_numdept`) VALUES (1,'2021-10-06 07:32:44',1,NULL,NULL,NULL),(2,'2021-10-15 12:38:59',126,NULL,NULL,NULL),(9,'2021-11-18 15:41:50',2,NULL,NULL,NULL),(10,'2021-11-18 15:54:47',199,NULL,NULL,NULL),(11,'2021-11-18 15:55:27',252,NULL,NULL,NULL),(12,'2021-11-19 13:37:22',205,NULL,NULL,NULL),(13,'2021-12-08 13:52:03',202,NULL,NULL,NULL),(14,'2021-12-08 13:59:44',39,NULL,NULL,NULL),(15,'2021-12-08 14:01:07',86,NULL,NULL,NULL),(17,'2022-01-03 17:37:40',73,NULL,NULL,NULL),(18,'2022-01-03 19:54:04',132,NULL,NULL,NULL),(19,'2022-01-03 19:55:17',32,NULL,NULL,NULL),(23,'2022-01-10 21:01:33',13,NULL,NULL,NULL),(25,'2022-01-10 21:04:42',58,NULL,NULL,NULL),(28,'2022-01-10 21:06:11',67,NULL,NULL,NULL),(31,'2022-01-10 21:07:09',75,NULL,NULL,NULL),(32,'2022-01-10 21:08:02',85,NULL,NULL,NULL),(34,'2022-01-11 15:39:31',92,NULL,NULL,NULL),(35,'2022-01-13 15:09:36',89,NULL,NULL,NULL),(39,'2022-01-13 19:42:54',219,NULL,NULL,NULL),(40,'2022-01-13 19:43:10',110,NULL,NULL,NULL),(42,'2022-01-13 20:40:23',500,NULL,NULL,NULL),(44,'2022-01-13 20:42:46',513,NULL,NULL,NULL),(47,'2022-01-13 20:59:21',77,NULL,NULL,NULL),(50,'2022-01-14 16:19:20',118,NULL,NULL,NULL),(51,'2022-01-17 11:24:26',501,NULL,NULL,NULL),(52,'2022-01-17 16:20:49',184,NULL,NULL,NULL),(53,'2022-01-18 09:47:54',159,NULL,NULL,NULL),(55,'2022-01-18 09:52:01',169,NULL,NULL,NULL),(56,'2022-01-18 09:54:40',174,NULL,NULL,NULL),(57,'2022-01-18 09:55:09',175,NULL,NULL,NULL),(59,'2022-01-18 09:56:05',172,NULL,NULL,NULL),(61,'2022-01-18 09:58:18',179,NULL,NULL,NULL),(62,'2022-01-18 10:00:14',183,NULL,NULL,NULL),(63,'2022-01-18 10:06:26',192,NULL,NULL,NULL),(64,'2022-01-18 10:22:23',507,NULL,NULL,NULL),(66,'2022-01-18 10:31:28',523,NULL,NULL,NULL),(71,'2022-01-18 10:42:57',124,NULL,NULL,NULL),(73,'2022-01-18 10:43:45',128,NULL,NULL,NULL),(76,'2022-01-18 10:45:04',130,NULL,NULL,NULL),(77,'2022-01-18 10:45:56',131,NULL,NULL,NULL),(79,'2022-01-18 10:46:25',135,NULL,NULL,NULL),(80,'2022-01-18 10:46:29',136,NULL,NULL,NULL),(81,'2022-01-18 10:51:09',137,NULL,NULL,NULL),(82,'2022-01-18 10:51:32',138,NULL,NULL,NULL),(83,'2022-01-18 10:54:24',142,NULL,NULL,NULL),(85,'2022-01-18 10:55:04',143,NULL,NULL,NULL),(86,'2022-01-18 10:55:58',144,NULL,NULL,NULL),(87,'2022-01-18 10:56:40',145,NULL,NULL,NULL),(88,'2022-01-18 10:57:08',146,NULL,NULL,NULL),(89,'2022-01-18 10:57:21',148,NULL,NULL,NULL),(90,'2022-01-18 10:57:27',149,NULL,NULL,NULL),(91,'2022-01-18 10:57:32',150,NULL,NULL,NULL),(92,'2022-01-18 10:57:58',151,NULL,NULL,NULL),(93,'2022-01-18 10:58:03',152,NULL,NULL,NULL),(94,'2022-01-18 10:58:10',153,NULL,NULL,NULL),(95,'2022-01-18 10:58:25',154,NULL,NULL,NULL),(96,'2022-01-18 10:59:08',155,NULL,NULL,NULL),(97,'2022-01-18 10:59:42',158,NULL,NULL,NULL),(98,'2022-01-18 10:59:49',160,NULL,NULL,NULL),(99,'2022-01-18 10:59:54',161,NULL,NULL,NULL),(100,'2022-01-18 11:00:24',162,NULL,NULL,NULL),(101,'2022-01-18 11:00:34',163,NULL,NULL,NULL),(102,'2022-01-18 11:01:28',164,NULL,NULL,NULL),(103,'2022-01-18 11:01:38',165,NULL,NULL,NULL),(104,'2022-01-18 11:01:50',166,NULL,NULL,NULL),(105,'2022-01-18 11:01:55',167,NULL,NULL,NULL),(106,'2022-01-18 11:01:59',168,NULL,NULL,NULL),(107,'2022-01-18 11:02:07',170,NULL,NULL,NULL),(109,'2022-01-18 11:03:57',173,NULL,NULL,NULL),(110,'2022-01-18 11:04:20',176,NULL,NULL,NULL),(111,'2022-01-18 11:04:31',177,NULL,NULL,NULL),(112,'2022-01-18 11:04:37',178,NULL,NULL,NULL),(113,'2022-01-18 11:04:46',180,NULL,NULL,NULL),(114,'2022-01-18 11:04:56',181,NULL,NULL,NULL),(115,'2022-01-18 11:05:02',182,NULL,NULL,NULL),(116,'2022-01-18 11:05:10',185,NULL,NULL,NULL),(117,'2022-01-18 11:05:15',186,NULL,NULL,NULL),(119,'2022-01-18 11:05:29',187,NULL,NULL,NULL),(120,'2022-01-18 11:05:36',188,NULL,NULL,NULL),(122,'2022-01-18 11:07:11',189,NULL,NULL,NULL),(123,'2022-01-18 11:07:24',190,NULL,NULL,NULL),(124,'2022-01-18 11:07:32',191,NULL,NULL,NULL),(125,'2022-01-18 11:07:43',193,NULL,NULL,NULL),(126,'2022-01-18 11:07:51',194,NULL,NULL,NULL),(127,'2022-01-18 11:08:05',195,NULL,NULL,NULL),(128,'2022-01-18 11:08:12',196,NULL,NULL,NULL),(129,'2022-01-18 11:09:29',197,NULL,NULL,NULL),(130,'2022-01-18 11:09:39',198,NULL,NULL,NULL),(131,'2022-01-18 11:10:48',122,NULL,NULL,NULL),(132,'2022-01-18 11:18:18',147,NULL,NULL,NULL),(133,'2022-01-18 11:24:16',171,NULL,NULL,NULL),(134,'2022-01-18 11:30:11',119,NULL,NULL,NULL),(135,'2022-01-18 11:30:18',120,NULL,NULL,NULL),(136,'2022-01-18 11:31:05',141,NULL,NULL,NULL),(137,'2022-01-18 11:31:28',156,NULL,NULL,NULL),(138,'2022-01-18 15:01:50',223,NULL,NULL,NULL),(139,'2022-01-18 15:20:34',200,NULL,NULL,NULL),(140,'2022-01-18 15:25:55',247,NULL,NULL,NULL),(141,'2022-01-18 15:35:23',253,NULL,NULL,NULL),(142,'2022-01-18 15:39:09',254,NULL,NULL,NULL),(143,'2022-01-18 15:49:38',233,NULL,NULL,NULL),(145,'2022-01-18 15:52:49',510,NULL,NULL,NULL),(146,'2022-01-18 15:58:49',215,NULL,NULL,NULL),(147,'2022-01-18 16:48:13',211,NULL,NULL,NULL),(148,'2022-01-18 17:27:20',508,NULL,NULL,NULL),(149,'2022-01-20 14:01:02',526,NULL,NULL,NULL),(150,'2022-01-20 15:15:37',527,NULL,NULL,NULL),(151,'2022-01-20 20:57:21',528,NULL,NULL,NULL),(152,'2022-01-20 20:58:50',529,NULL,NULL,NULL),(153,'2022-01-21 08:30:42',518,NULL,NULL,NULL),(157,'2022-01-21 09:20:01',530,NULL,NULL,NULL),(158,'2022-01-21 14:22:26',509,NULL,NULL,NULL),(159,'2022-01-21 14:26:22',486,NULL,NULL,NULL),(160,'2022-01-21 14:28:42',115,NULL,NULL,NULL),(161,'2022-01-21 14:33:56',491,NULL,NULL,NULL),(162,'2022-01-21 14:35:26',515,NULL,NULL,NULL),(163,'2022-01-21 14:37:35',516,NULL,NULL,NULL),(164,'2022-01-21 14:48:36',504,NULL,NULL,NULL),(165,'2022-01-21 15:12:03',127,NULL,NULL,NULL),(166,'2022-01-21 15:17:13',502,NULL,NULL,NULL),(167,'2022-01-21 15:18:41',494,NULL,NULL,NULL),(168,'2022-01-21 15:42:57',498,NULL,NULL,NULL),(169,'2022-01-24 09:19:28',531,NULL,NULL,NULL),(175,'2022-01-24 14:05:26',532,NULL,NULL,NULL),(176,'2022-01-24 14:11:41',524,NULL,NULL,NULL),(177,'2022-01-24 15:52:19',490,NULL,NULL,NULL),(178,'2022-01-24 16:06:10',496,NULL,NULL,NULL),(179,'2022-01-25 10:30:15',134,NULL,NULL,NULL),(180,'2022-01-27 09:01:29',533,NULL,NULL,NULL),(181,'2022-01-27 13:57:01',203,NULL,NULL,NULL),(182,'2022-01-27 14:27:26',129,NULL,NULL,NULL),(184,'2022-01-27 15:46:40',21,NULL,NULL,NULL),(186,'2022-01-28 08:18:48',534,NULL,NULL,NULL);

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

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

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


--
-- Table structure for table `llx_societe_prices`
--

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

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


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

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

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


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

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

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

INSERT INTO `llx_societe_remise_except` (`rowid`, `entity`, `fk_soc`, `discount_type`, `datec`, `amount_ht`, `amount_tva`, `amount_ttc`, `tva_tx`, `vat_src_code`, `fk_user`, `fk_facture_line`, `fk_facture`, `fk_facture_source`, `fk_invoice_supplier_line`, `fk_invoice_supplier`, `fk_invoice_supplier_source`, `description`, `multicurrency_amount_ht`, `multicurrency_amount_tva`, `multicurrency_amount_ttc`) VALUES (1,2,202,1,'2022-01-25 09:53:13',8.83000000,0.00000000,8.83000000,0.000,'',11,NULL,NULL,NULL,NULL,NULL,3909,'(EXCESS PAID)',0.00000000,0.00000000,0.00000000);

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

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

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


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

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

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


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

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

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

INSERT INTO `llx_socpeople` (`rowid`, `datec`, `tms`, `fk_soc`, `entity`, `ref_ext`, `civility`, `lastname`, `firstname`, `address`, `zip`, `town`, `fk_departement`, `fk_pays`, `birthday`, `poste`, `phone`, `phone_perso`, `phone_mobile`, `fax`, `email`, `socialnetworks`, `jabberid`, `skype`, `twitter`, `facebook`, `linkedin`, `instagram`, `snapchat`, `googleplus`, `youtube`, `whatsapp`, `photo`, `no_email`, `priv`, `fk_prospectcontactlevel`, `fk_stcommcontact`, `fk_user_creat`, `fk_user_modif`, `note_private`, `note_public`, `default_lang`, `canvas`, `import_key`, `statut`) VALUES (1,'2022-01-11 12:47:44','2022-01-11 12:53:48',25,1,NULL,'','.','','2 Rue Thomas Edison PAU CITE MULTIMEDIA Bâtiment A','64054','PAU CEDEX 09',NULL,1,NULL,'','','','','','contact@anglofile.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,'',0,11,1,'','',NULL,NULL,NULL,1),(2,'2022-01-11 15:40:45','2022-01-11 15:40:45',92,1,NULL,'MR','ROMEUR','JEAN-PIERRE','13 RUE MAUBEC','64230','LESCAR',NULL,1,NULL,'','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,10,10,'','',NULL,NULL,NULL,1),(3,'2022-01-11 16:17:12','2022-01-11 16:17:12',78,1,NULL,'','ANZIL','BRUNO','6 PASSAGE DE L\'EUROPE','64000','PAU',NULL,1,NULL,'','','','','','bruno.anzil@nalta.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,10,10,'','',NULL,NULL,NULL,1),(4,'2022-01-13 11:02:27','2022-01-13 11:02:27',NULL,1,NULL,'MME','SUHIT SAINT LOUBOUE','','','','',NULL,1,NULL,'','','','','','contact@ssle.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,10,10,'','',NULL,NULL,NULL,1),(5,'2022-01-13 14:01:23','2022-01-13 14:01:23',106,1,NULL,'MME','SUHIT SAINT LOUBOUE','','','','',NULL,1,NULL,'','','','','','contact@ssle.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,10,10,'','',NULL,NULL,NULL,1),(6,'2022-01-13 14:29:30','2022-01-13 14:29:30',29,1,NULL,'','LAUDEBAT','STEPHANIE','','','',NULL,1,NULL,'','','','','','comptabilite@aspcm.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,10,10,'','',NULL,NULL,NULL,1),(7,'2022-01-13 20:40:46','2022-01-13 20:40:46',500,2,NULL,'MME','GUELIN','Joelle','CSP FOURNISSEURS','38246','MEYLAN CEDEX',NULL,1,NULL,'','','','','','Joelle.GUELIN@schneider-electric.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,1,1,'','',NULL,NULL,NULL,1),(8,'2022-01-13 20:41:41','2022-01-17 11:23:06',501,2,NULL,'MR','DRIESSEN','Christophe','PAU CITE MULTIMEDIA BAT F \r\n16, Rue Michael Faraday','64054','PAU CEDEX 9',NULL,1,NULL,'','','','','','Christophe.Driessen@sofresid.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,'',0,1,11,'','',NULL,NULL,NULL,1),(9,'2022-01-13 20:43:03','2022-01-13 20:43:03',513,2,NULL,'','LOPVET','Julie','4 RUE THOMAS EDISON BATIMENT C','64054','PAU CEDEX 09',NULL,1,NULL,'','','','','','julie.lopvet@sc3i.net','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,1,1,'','',NULL,NULL,NULL,1),(10,'2022-01-13 20:43:43','2022-01-21 15:31:50',515,2,NULL,'','ALMEIDA','Ana-Sofia','Bâtiment C 4, rue Thomas Edison - BP 7501','64075','PAU Cedex',NULL,1,NULL,'','','','','','ana-sofia.almeida@arsilon.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,'',0,1,11,'','',NULL,NULL,NULL,1),(11,'2022-01-13 20:45:54','2022-01-13 20:45:54',516,2,NULL,'','Datchary','Stéphanie','','','',NULL,1,NULL,'','','','','','stephanie.datchary@chrobinson.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,1,1,'','',NULL,NULL,NULL,1),(12,'2022-01-13 20:58:07','2022-01-13 20:58:07',193,2,NULL,'','FABRE','Corinne','10 AVENUE DE L ENTREPRISE','95863','CERGY PONTOISE',NULL,1,NULL,'','','','','','corinne.fabre@spie.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,1,1,'','',NULL,NULL,NULL,1),(13,'2022-01-13 20:59:49','2022-01-13 20:59:49',77,2,NULL,'','Didier','','9 RUE DE BEAURENGY','64320','IDRON',NULL,1,NULL,'','','','','','api.64.didier@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,1,1,'','',NULL,NULL,NULL,1),(14,'2022-01-14 16:21:16','2022-01-14 16:21:17',118,2,NULL,'MME','GANZAGAIN','Sandrine','','','',NULL,1,NULL,'','','','','','sandrine.ganzagain@abl-avocats.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,11,11,'','',NULL,NULL,NULL,1),(15,'2022-01-20 08:26:34','2022-01-20 08:26:34',128,2,NULL,'MR','ABINA','Baptiste','Centre de gestion les Terrasses\r\nTSA 16709','95901','CERGY PONTOISE CEDEX',NULL,1,NULL,'','','','','','baptiste.abina@axa.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(16,'2022-01-20 09:11:38','2022-01-20 09:11:38',490,2,NULL,'MME','LAMBERT','VIRGINIE','2, rue Thomas Edison BATIMENT A','64054','PAU Cedex 09',NULL,1,NULL,'','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(17,'2022-01-20 14:16:19','2022-01-20 14:16:19',138,2,NULL,'','HAURE','GAELLE','','','',NULL,1,NULL,'','','','','','Gaelle.HAURE@cnfpt.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(18,'2022-01-20 14:33:13','2022-01-20 14:33:13',482,2,NULL,'MME','WAWRZKOW','ANNA MARIE','2 rue thomas edison,\r\naspcm bat A','64000','PAU',NULL,1,NULL,'','','','','','am.waw@anglofile.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(19,'2022-01-20 15:17:15','2022-01-20 15:17:15',527,2,NULL,'MME','Fernandes-Coz','GHISLAINE','4 RUE THOMAS EDISON','64000','PAU',NULL,1,NULL,'','06.62.49.23.71','','','','ghislaine.coz@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(20,'2022-01-21 09:12:41','2022-01-21 09:17:40',498,2,NULL,'','SCI JARDINS DU PARC','','2, RUE THOMAS EDISON\r\nBATIEMENT A','64054','CEDEX 09',NULL,1,NULL,'','06 073 72 48','','','','plahillonne@plhconseil.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,'',0,11,1,'','',NULL,NULL,NULL,1),(22,'2022-01-21 09:46:49','2022-01-21 09:46:49',140,2,NULL,'','Mann','ISABELLE','20 RUE JOHANNES KEPLER','64000','PAU',NULL,1,NULL,'','05 59 14 03 43','','','','i-mann@cosoluce.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(23,'2022-01-21 09:52:53','2022-01-21 09:52:53',128,2,NULL,'MR','CAVAILLE','PHILIPPE','3 rue Thomas Edison\r\n\r\nBat. D 1er étage','64000','PAU',NULL,1,NULL,'','','','06 17 67 71 16','','philippe.cavaille@axa.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(24,'2022-01-21 09:56:33','2022-01-21 09:57:35',504,2,NULL,'MME','BUCHOT','STEPHANIE','1 rue Ada Byron 64000','64000','PAU',NULL,1,NULL,'','','','05 59 11 38 00','','stephanie.buchot@sitel.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(25,'2022-01-21 10:03:40','2022-01-21 10:03:40',512,2,NULL,'MR','LAMY','FRANCOIS','2 RUE THOMAS EDISON BAT A','64000','PAU',NULL,1,NULL,'','','','06.01.99.21.56','','francois.lamy@orientaction-groupe.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(26,'2022-01-21 10:13:43','2022-01-21 10:13:43',86,2,NULL,'MME','LECORRE','ANITA','52 rue Georges Bonnac','33093','BORDEAUX',NULL,1,NULL,'','','','07 63 45 13 54','','anita.lecorre@laposte.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(27,'2022-01-21 10:26:50','2022-01-21 10:28:11',86,2,NULL,'MME','CLEMENT','ESTELLE','DIRECTION DES VENTES ENTREPRISES\r\n\r\nGARONNE ADOUR\r\n\r\n7 RUE FARADAY\r\n\r\nCS 80582','64064','PAU CEDEX',NULL,1,NULL,'','','','07 62 57 71 95','','estelle.clement@laposte.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(28,'2022-01-21 10:35:59','2022-01-21 10:35:59',491,2,NULL,'MME','LE LIN','ANNIE','4 RUE THOMAS EDISON','64000','PAU',NULL,1,NULL,'','','','05.24.36.47.00','','lelinannie.kfc@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(29,'2022-01-21 13:49:06','2022-01-21 13:49:06',164,2,NULL,'MME','MARQUES','Christine','3 RUE THOMAS EDISON','64000','PAU',NULL,1,NULL,'','09.72.30.20.40','','','','christine.marques@fhbx.eu','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(30,'2022-01-21 14:01:36','2022-01-21 14:01:36',86,2,NULL,'MME','HURTAUD','LYDIE','7 RUE FARADAY','64000','PAU',NULL,1,NULL,'','07 62 57 77 92','','','','lydie.hurtaud@laposte.fr','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(31,'2022-01-21 15:52:40','2022-01-21 15:53:42',498,2,NULL,'MR','LACAZE','CHRISTOPHE','2 RUE THOMAS EDISON','64000','PAU',NULL,1,NULL,'','05 59 72 56 56','','','','clacaze@plhconseil.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(32,'2022-01-24 09:21:09','2022-01-24 09:21:09',531,2,NULL,'MME','ROUBY','KARINE','Avenu de la vallée de l\'Ossau','64121','SERRES CASTET',NULL,1,NULL,'','','','0663091217','','karinawaz@gmail.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1),(33,'2022-01-24 12:46:44','2022-01-24 13:03:46',524,2,NULL,'','YEP YEP PARACHUTISME','','Mr ADNET\r\n5 rue Pe doü Boscq','64420','ANDOINS',NULL,1,NULL,'','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,'',0,11,11,'','',NULL,NULL,NULL,1),(34,'2022-01-24 13:49:21','2022-01-24 13:52:06',532,2,NULL,'','Emmanuel GELY','','','','',NULL,1,NULL,'','','','','','','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,0,'',0,11,11,'','',NULL,NULL,NULL,1),(35,'2022-01-27 13:19:26','2022-01-27 13:19:26',151,2,NULL,'MME','LASTISNERES','NATHALIE','13 RUE FARADAY','64000','PAU',NULL,1,NULL,'','0559059110','','','','Nathalie.LASTISNERES@generali.com','[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',0,15,15,'','',NULL,NULL,NULL,1);

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

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

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


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

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

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


--
-- Table structure for table `llx_subscription`
--

CREATE TABLE `llx_subscription` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `fk_adherent` int(11) DEFAULT NULL,
  `fk_type` int(11) DEFAULT NULL,
  `dateadh` datetime DEFAULT NULL,
  `datef` datetime DEFAULT NULL,
  `subscription` double(24,8) DEFAULT NULL,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_subscription` (`fk_adherent`,`dateadh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_subscription`
--


--
-- Table structure for table `llx_supplier_proposal`
--

CREATE TABLE `llx_supplier_proposal` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref_ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_int` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_user_cloture` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT 0,
  `price` double DEFAULT 0,
  `remise_percent` double DEFAULT 0,
  `remise_absolue` double DEFAULT 0,
  `remise` double DEFAULT 0,
  `total_ht` double(24,8) DEFAULT 0.00000000,
  `total_tva` double(24,8) DEFAULT 0.00000000,
  `localtax1` double(24,8) DEFAULT 0.00000000,
  `localtax2` double(24,8) DEFAULT 0.00000000,
  `total_ttc` double(24,8) DEFAULT 0.00000000,
  `fk_account` int(11) DEFAULT NULL,
  `fk_currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_public` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_main_doc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_livraison` date DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT 1.00000000,
  `multicurrency_total_ht` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_tva` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_ttc` double(24,8) DEFAULT 0.00000000,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_supplier_proposal`
--


--
-- Table structure for table `llx_supplier_proposal_extrafields`
--

CREATE TABLE `llx_supplier_proposal_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_supplier_proposal_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_supplier_proposal_extrafields`
--


--
-- Table structure for table `llx_supplier_proposaldet`
--

CREATE TABLE `llx_supplier_proposaldet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_supplier_proposal` int(11) NOT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_remise_except` int(11) DEFAULT NULL,
  `vat_src_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT '',
  `tva_tx` double(6,3) DEFAULT 0.000,
  `localtax1_tx` double(6,3) DEFAULT 0.000,
  `localtax1_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT 0.000,
  `localtax2_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT 0,
  `remise` double DEFAULT 0,
  `price` double DEFAULT NULL,
  `subprice` double(24,8) DEFAULT 0.00000000,
  `total_ht` double(24,8) DEFAULT 0.00000000,
  `total_tva` double(24,8) DEFAULT 0.00000000,
  `total_localtax1` double(24,8) DEFAULT 0.00000000,
  `total_localtax2` double(24,8) DEFAULT 0.00000000,
  `total_ttc` double(24,8) DEFAULT 0.00000000,
  `product_type` int(11) DEFAULT 0,
  `date_start` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `info_bits` int(11) DEFAULT 0,
  `buy_price_ht` double(24,8) DEFAULT 0.00000000,
  `fk_product_fournisseur_price` int(11) DEFAULT NULL,
  `special_code` int(11) DEFAULT 0,
  `rang` int(11) DEFAULT 0,
  `ref_fourn` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_ht` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_tva` double(24,8) DEFAULT 0.00000000,
  `multicurrency_total_ttc` double(24,8) DEFAULT 0.00000000,
  `fk_unit` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_supplier_proposaldet_fk_supplier_proposal` (`fk_supplier_proposal`),
  KEY `idx_supplier_proposaldet_fk_product` (`fk_product`),
  KEY `fk_supplier_proposaldet_fk_unit` (`fk_unit`),
  CONSTRAINT `fk_supplier_proposaldet_fk_supplier_proposal` FOREIGN KEY (`fk_supplier_proposal`) REFERENCES `llx_supplier_proposal` (`rowid`),
  CONSTRAINT `fk_supplier_proposaldet_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `llx_c_units` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_supplier_proposaldet`
--


--
-- Table structure for table `llx_supplier_proposaldet_extrafields`
--

CREATE TABLE `llx_supplier_proposaldet_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `show_total_ht` int(10) DEFAULT NULL,
  `show_reduc` int(10) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_supplier_proposaldet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_supplier_proposaldet_extrafields`
--


--
-- Table structure for table `llx_takepos_floor_tables`
--

CREATE TABLE `llx_takepos_floor_tables` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `leftpos` float DEFAULT NULL,
  `toppos` float DEFAULT NULL,
  `floor` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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

INSERT INTO `llx_ticket` (`rowid`, `entity`, `ref`, `track_id`, `fk_soc`, `fk_project`, `origin_email`, `fk_user_create`, `fk_user_assign`, `subject`, `message`, `fk_statut`, `resolution`, `progress`, `timing`, `type_code`, `category_code`, `severity_code`, `datec`, `date_read`, `date_close`, `notify_tiers_at_create`, `email_msgid`, `tms`, `import_key`) VALUES (1,2,'TS2201-0011','h59i1g6df81f3prj',504,NULL,NULL,15,14,'cuvette wc femme','Bonjour,\r\n\r\nJe vous remercie de changer la cuvette du 1er toilette femme du 2ème étage ainsi que la plaque du plafond dans le toilette handicapé du 2ème étage s’il vous plaît.',3,NULL,'0','NORMAL','SANI','NOR','NORMAL','2022-01-20 10:30:45','2022-01-20 10:37:04',NULL,0,NULL,'2022-01-21 16:39:30',NULL),(2,2,'TS2104-0001','7tovNS8zVc6UFE8V',502,0,NULL,15,14,'TICKETS UMANIS VU AVEC JEROME','Bonjour,  Suite à notre entrevue de ce mercredi 21 Avril avec Jérôme pouvez-vous svp ouvrir des tickets pour les points que nous avons abordés :  -          Remplacement de certaines dalles du faux plafond.  -          Voir s\'il reste un carré de moquette gris clair pour changement d\'un carré qui est taché.  -          Un filet d\'eau coule lorsqu\'on tire la chasse du WC handicapé femme  -          Nettoyage du groupe électrogène  Merci par avance.  Bonne journée.  Cordialement',3,NULL,NULL,'NORMAL','CHAU','DEV','NORMAL','2021-04-22 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:49:50','pragmainit'),(3,2,'TS2108-0002','ptt4yee07hz03lcy',134,0,NULL,15,14,'climatisation défaillante','Bonjour, Malgré plusieurs interventions, la climatisation de l\'aile ouest des bureaux ne fonctionne toujours pas . Merci de bien vouloir ouvrir un nouveau ticket Cordialement / Regards Richard Sausset                                                                 International Sourcing / Expediting manager   ',3,NULL,NULL,'NORMAL','CLIM','DEV','NORMAL','2021-08-11 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:52:08','pragmainit'),(4,2,'TS2109-0003','w6xjkg81ee30feak',173,0,NULL,15,14,'PROBLEME CLIMATISATION','Bonjour,  Nous avons toujours un problème de climatisation dans le box médecin. Pouvez vous faire le nécessaire s\'il vous plaît?  Vous en remerciant par avance.  Cordialement.  le secrétariat POINT VISION PAU ',3,NULL,NULL,'NORMAL','CLIM','DEV','NORMAL','2021-09-10 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:52:33','pragmainit'),(5,2,'TS2109-0004','frkmguc8iln0dcqy',504,0,NULL,15,14,'PROBLEME CLIMATISATION','Bonjour,  Je vous remercie d\'intervenir sur la climatisation au fond du grand plateau au 1er étage car elle ne fonctionne pas correctement s\'il vous plaît.  Cordialement, Stéphanie BUCHOT',3,NULL,NULL,'NORMAL','CLIM','EXP','NORMAL','2021-09-22 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:52:33','pragmainit'),(6,2,'TS2109-0005','12tvfpaejs2z66kf',145,0,NULL,15,14,'PROBLEME CLIM','Bonjour,   La climatisation dans le bureau de Monsieur Lamy dans le Centre d\'Affaires fait du bruit même sur le niveau 1.  Pouvez-vous intervenir ?   Merci d\'avance,  ',3,NULL,NULL,'NORMAL','CLIM','DEV','NORMAL','2021-09-27 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:52:33','pragmainit'),(7,2,'TS2110-0006','zdn1gaod7n9chnjc',491,0,NULL,15,14,'DEFAUT DE CHAUFFAGE ','Bonjour ,  La société HERMES au bâtiment C a des dysfonctionnements  sur les chauffages, certains soufflent de l\'air froid et non de l\'air chaud.  Merci pour votre intervention ',3,NULL,NULL,'NORMAL','CHAU','EXP','NORMAL','2021-10-25 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:52:33','pragmainit'),(8,2,'TS2111-0007','drw31cggwgr40g0j',501,0,NULL,15,14,'PROBLEME CHAUFFAGE','Bonsoir,  Comme constaté ce soir en présence de Jérôme, la cassette de chauffage du bureau C113 (1er étage Aile C) ne s\'enclenche pas lorsqu\'on la sollicite via la télécommande.  De plus le logiciel de la GTC indique « fenêtre ouverte » or il n\'y a pas de fenêtre qu\'on puisse ouvrir dans ce bureau…  Comme convenu je demande l\'ouverture d\'un ticket pour une vérification future des raccordements existants / carte de pilotage.  D\'avance merci pour l\'ouverture du ticket et la prochaine intervention.  Bonne soirée.  Bien cordialement,  Christophe DRIESSEN Sans titre',3,NULL,NULL,'NORMAL','CHAU','EXP','NORMAL','2021-11-09 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:52:33','pragmainit'),(9,2,'TS2111-0008','0tklo432uaqkht18',181,0,NULL,15,14,'DEFAUT DE CHAUFFAGE ','Bonjour.  Nous avons un problème de chauffage dans un bureau à l\'étage (dernier bureau à gauche).  Pourriez-vous nous envoyer un technicien ?  Merci d\'avance. Cordialement, Best regards, C уважением,  Julia VOLKOV  Logistics Coordinator SeaOwl Energy Services ',3,NULL,NULL,'NORMAL','CHAU','EXP','NORMAL','2021-11-17 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:52:33','pragmainit'),(10,2,'TS2111-0009','2jrunp7366h37b5v',501,0,NULL,15,14,' Pb évacuation urinoirs 1er étage','Bonjour à toutes et tous,  Nos soucis d\'évacuation ne se sont pas améliorés et ce sont maintenant tous les urinoirs du 1er étage qui sont concernés.  En plus de ceux de l\'aile B s\'ajoute ceux des toilettes centrales (face aux escaliers).  Je serai présent sur site demain et à votre disposition pour une constatation.   D\'autre part, je sollicite également votre visite pour refaire l\'appoint en eau des ballons des pompes à chaleur et vérifier par la même occasion sur la GTC deux temporisations lumières sur 2 postes collaborateurs du RDC.  Par avance merci de votre passage.  Bien cordialement,',3,NULL,NULL,'NORMAL','SANI','DEV','NORMAL','2021-11-25 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:52:33','pragmainit'),(11,2,'TS2112-0010','kvix374a6k6876mv',NULL,0,NULL,15,14,'GACHES DEFECTUEUSES','Bonjour,  Nous avons constaté que la gâche de la porte d\'entrée du centre d\'affaire ainsi que celle de la Géode ne se ferment pas correctement.  Merci pour votre future intervention',3,NULL,NULL,'NORMAL','SERR','EXP','NORMAL','2021-12-03 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(12,2,'TS2201-0001','j575m7ey9ny55t7k',491,0,NULL,15,14,'Commande de 5 stores ','  Bonjour Jérôme,  Ci-dessous une demande d\'Hermes concernant les stores.   Bien cordialement.   Bonjour, Nous aimerions commander 5 stores pour nos locaux, pouvez-vous faire le nécessaire ?  Dans l\'attente de votre retour.  Cordialement.  Le lin Annie',3,NULL,NULL,'NORMAL','SERR','DEV','NORMAL','2022-01-06 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(13,2,'TS2201-0002','q5q768jb42b8nye3',504,0,NULL,15,14,'DEFAUT DE CHAUFFAGE ','Bonjour,  Je vous remercie d\'intervenir dans le local CSE car le chauffage souffle de l\'air frais s\'il vous plaît.  Cordialement,  Stéphanie BUCHOT',3,NULL,NULL,'NORMAL','CHAU','EXP','NORMAL','2022-01-07 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(14,2,'TS2201-0003','893c6ffe6twi44u4',182,0,NULL,15,14,'REMPLACEMENT PLAQUES FAUX-PLAFOND','Bonjour Jérôme,  Merci de bien vouloir prévoir une intervention sur les plaques de faux-plafond au niveau du local ménage du hall du bâtiment A, on y voit des traces (cf photos ci-jointes). Identifier les fuites, les traiter et remplacer les plaques. Remplacer aussi les plaques avec traces noires.  Une petite plaque à remplacer également vers l\'ascenseur.   En te remerciant d\'avance.  Bien cordialemen',3,NULL,NULL,'NORMAL','PLAQ','EXP','NORMAL','2022-01-07 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(15,2,'TS2201-0004','vi4i3ip3i68e228b',491,0,NULL,15,14,'PANNE CHAUFFAGE','Bonjour,  Nous sommes le bureau Hermes de la cité multimedia, depuis ce matin nous n\'avons pas de chauffage dans nos bureaux.  Merci  Cordialement,',3,NULL,NULL,'NORMAL','CHAU','DEV','NORMAL','2022-01-11 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(16,2,'TS2201-0005','863p5h4dq83yuiy2',118,0,NULL,15,14,'FUITE AU LAFOND ','Bonjour Je vous remercie de bien vouloir demander à Interénergie d\'intervenir dans nos locaux pour un problème de fuites au plafond dans nos locaux.   Cordialement.',3,NULL,NULL,'NORMAL','PLOM','DEV','NORMAL','2022-01-14 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(17,2,'TS2201-0006','f6357a7vb847fjzt',181,0,NULL,15,14,'DEFAUT DE CHAUFFAGE ','Bonjour  Nous avons un problème de chauffage dans tous les bureaux à l\'étage.  Pourriez-vous nous envoyer un technicien ?  Merci d\'avance.  Cordialement,  Julia VOLKOV  ',3,NULL,NULL,'NORMAL','CHAU','EXP','NORMAL','2022-01-17 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(18,2,'TS2201-0007','c4jx87w62845dycj',490,0,NULL,15,17,'MANQUE ESSUIE-MAIN','Bonjour,  Il n\'y a plus d\'essuie-mains dans les toilettes femmes du cabinet.   Merci de bien vouloir demander à la femme de ménage d\'y remédier.     Cordialement.   Jean-Michel GALLARDO  Avocat   ',3,NULL,NULL,'NORMAL','SANI','EXP','NORMAL','2022-01-17 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(19,2,'TS2201-0008','2683u4njhb46xtp8',188,0,NULL,15,14,'DEFAUT PORTE ENTREE','Bonjour,  Cela fait plusieurs semaines que la porte d\'entrée du bâtiment B ne ferme plus.  Pourriez-vous prévoir la réparation rapidement. Nous avons dans le local sous l\'escalier du matériel.',3,NULL,NULL,'NORMAL','ACC','DEV','NORMAL','2022-01-17 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(20,2,'TS2201-0009','xah96n5r9r954m5v',504,0,NULL,15,14,'defaut chauffage','Bonjour,  Je vous remercie d\'intervenir dans l\'espace admin du rez de chaussée car le système dégage de l\'air froid ou tiède s\'il vous plaît.   Cordialement,   Stéphanie BUCHOT',3,NULL,NULL,'NORMAL','CHAU','EXP','NORMAL','2022-01-17 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(21,2,'TS2201-0010','9t84z9vt9bpj744t',504,0,NULL,15,14,'DEFAUT DE CHAUFFAGE ','Bonjour,  Je vous remercie d\'intervenir dans la salle de formation du 1er étage car le système de chauffage envoie de l\'air froid s\'il vous plaît.  Cordialement,  Stéphanie BUCHOT',3,NULL,NULL,'NORMAL','CHAU','EXP','NORMAL','2022-01-18 00:00:00','2022-01-04 00:00:00',NULL,NULL,NULL,'2022-01-21 16:54:47','pragmainit'),(22,2,'TS2201-0012','n4q6cggo37ta2k7p',118,NULL,NULL,15,14,'Problème de sonnette','Monsieur,\r\n\r\n\r\nJe me permets de prendre contact avec vous car nous avons un soucis avec la sonnette de la porte d’entrée.\r\n\r\n\r\nPourriez-vous intervenir s’il vous plait .\r\n\r\n\r\nBien cordialement,',3,NULL,'0',NULL,'ELEC','NOR','NORMAL','2022-01-27 09:32:18','2022-01-27 10:05:20',NULL,1,NULL,'2022-01-27 12:07:22',NULL),(23,2,'TS2201-0013','5smyt7sny2z2ngcw',502,NULL,NULL,15,14,'porte cassée','Bonjour,\r\n\r\n\r\nNous demandons svp une intervention urgente pour la porte à l’entrée du Bâtiment H qui est cassée, du coup ouverte jour et nuit.\r\n\r\n\r\nVous en remerciant par avance.\r\n\r\nP.S. : Mathieu est sur place si besoin.',3,NULL,'0',NULL,'SERR','OTHER','HIGH','2022-01-27 09:45:05','2022-01-27 10:05:44',NULL,0,NULL,'2022-01-27 11:29:38',NULL),(24,2,'TS2201-0014','7duzyyiqouv53g69',184,NULL,NULL,15,14,'DEMENAGEMENT DU MOBILIER','Comme évoqué au mois de décembre, il faudrait déménager le mobilier des deux bureaux du fond des anciens locaux de Schneider dans l\'ancien espace Anglofile.\r\nMerci de prévoir l\'intervention urgemment car Alpes contrôles va bientôt s\'installer.',8,NULL,'100',NULL,'OTHER','OTHER','NORMAL','2022-01-27 09:55:15','2022-01-27 10:03:41','2022-01-27 10:56:47',1,NULL,'2022-01-27 10:56:47',NULL),(25,2,'TS2201-0015','1ydvvxetw9yknua1',515,NULL,NULL,15,14,'PROBLEME DE CHAUFFAGE','Bonjour,\r\n\r\nIl semble qu’il y ait un problème de chauffage d’une des deux zones de nos bureaux.\r\n\r\nLa partie coté salle serveur est bien plus froide que l’autre.\r\n\r\n \r\nPourriez-vous s’il vous plait faire intervenir qqn afin de résoudre ce problème.',3,NULL,'0',NULL,'CHAU','NOR','NORMAL','2022-01-27 10:14:22','2022-01-27 10:35:21',NULL,0,NULL,'2022-01-27 10:42:08',NULL);

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

CREATE TABLE `llx_ticket_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `batimentticket` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `espaceticket` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_ticket_extrafields` (`fk_object`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_ticket_extrafields` (`rowid`, `tms`, `fk_object`, `import_key`, `batimentticket`, `espaceticket`) VALUES (13,'2022-01-21 16:57:39',11,NULL,'8',NULL),(15,'2022-01-21 17:03:56',13,NULL,'11','108'),(27,'2022-01-21 17:04:30',21,NULL,'10','108'),(28,'2022-01-21 17:05:02',17,NULL,'13','121'),(29,'2022-01-21 17:05:27',18,NULL,'8','71'),(30,'2022-01-21 17:06:12',19,NULL,'9','80'),(31,'2022-01-21 17:06:21',20,NULL,'10','108'),(32,'2022-01-21 17:06:29',16,NULL,'12','118'),(33,'2022-01-21 17:06:37',15,NULL,'10','105'),(34,'2022-01-21 17:07:20',14,NULL,'8','76'),(35,'2022-01-21 17:07:28',12,NULL,'10','105'),(36,'2022-01-21 17:07:52',10,NULL,'14','124'),(37,'2022-01-21 17:07:59',9,NULL,'13','121'),(38,'2022-01-21 17:08:05',8,NULL,'14','124'),(39,'2022-01-21 17:08:13',7,NULL,'10','105'),(40,'2022-01-21 17:08:19',6,NULL,'8','89'),(41,'2022-01-21 17:08:29',5,NULL,'10','108'),(42,'2022-01-21 17:08:45',4,NULL,'15','126'),(43,'2022-01-21 17:08:53',3,NULL,'15','128'),(44,'2022-01-21 17:08:59',2,NULL,'16','132'),(45,'2022-01-27 09:30:29',1,NULL,'11','108'),(50,'2022-01-27 10:29:58',22,NULL,'12','118'),(51,'2022-01-27 10:31:13',23,NULL,'16','132'),(52,'2022-01-27 10:32:43',24,NULL,'10','85'),(53,'2022-01-27 10:33:03',25,NULL,'10','96');

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

CREATE TABLE `llx_tva` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `datec` datetime DEFAULT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `amount` double(24,8) NOT NULL DEFAULT 0.00000000,
  `fk_typepayment` int(11) DEFAULT NULL,
  `num_payment` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `note` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `paye` smallint(6) NOT NULL DEFAULT 0,
  `fk_account` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_tva`
--


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

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

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


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

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

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


--
-- Table structure for table `llx_user_employment`
--

CREATE TABLE `llx_user_employment` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_ext` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `job` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL,
  `salary` double(24,8) DEFAULT NULL,
  `salaryextra` double(24,8) DEFAULT NULL,
  `weeklyhours` double(16,8) DEFAULT NULL,
  `dateemployment` date DEFAULT NULL,
  `dateemploymentend` date DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_employment` (`ref`,`entity`),
  KEY `fk_user_employment_fk_user` (`fk_user`),
  CONSTRAINT `fk_user_employment_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user_employment`
--


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

CREATE TABLE `llx_user_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `roomreservation_time` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `roomreservation_product` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `roomreservation_capacity` int(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_user_extrafields` (`fk_object`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_user_extrafields` (`rowid`, `tms`, `fk_object`, `import_key`, `roomreservation_time`, `roomreservation_product`, `roomreservation_capacity`) VALUES (19,'2022-01-09 14:18:13',11,NULL,NULL,NULL,NULL),(43,'2022-01-19 21:24:16',6,NULL,'635,636,637,638','397',110),(55,'2022-01-20 09:30:23',15,NULL,NULL,NULL,NULL),(56,'2022-01-20 09:50:32',3,NULL,'410,627,628,629,630','397,409',10),(57,'2022-01-20 09:51:36',16,NULL,'633,632,631,634','397,409',30),(58,'2022-01-20 09:52:17',4,NULL,'410,627,628,629,630','397,409',18),(59,'2022-01-20 09:52:44',5,NULL,'410,627,628,629,630','397,409',14),(60,'2022-01-20 09:53:38',7,NULL,'410,627,628,629,630','397,409',15),(67,'2022-01-27 10:20:44',1,NULL,NULL,NULL,NULL),(69,'2022-01-27 11:06:00',18,NULL,NULL,NULL,NULL),(70,'2022-01-27 11:10:12',17,NULL,NULL,NULL,NULL),(72,'2022-01-27 16:35:48',14,NULL,NULL,NULL,NULL);

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

CREATE TABLE `llx_user_param` (
  `fk_user` int(11) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `param` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `uk_user_param` (`fk_user`,`param`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `llx_user_param` (`fk_user`, `entity`, `param`, `value`) VALUES (1,1,'MAIN_BOXES_0','1'),(1,3,'MAIN_BOXES_0','1'),(1,1,'MAIN_SELECTEDFIELDS_contractlist','ef.montantDerniereFacturation,ef.batimentcontrat,ef.depotgarantie,ef.indice,ef.dureebail,c.ref,s.nom,s.zip,c.date_contrat,lower_planned_end_date,status,'),(1,1,'MAIN_SELECTEDFIELDS_invoicelist','f.ref_client,f.ref,f.datef,f.date_lim_reglement,s.nom,s.name_alias,s.zip,f.total_ht,f.total_ttc,u.login,f.fk_statut,'),(1,2,'MAIN_SELECTEDFIELDS_invoicelist','ef.batimentfacture,f.ref,f.ref_client,f.datef,f.date_lim_reglement,s.nom,f.total_ht,f.total_ttc,f.fk_statut,'),(1,1,'MAIN_SELECTEDFIELDS_placelist','t.fk_parent_label,t.ref,t.label,t.type,t.fk_owner,t.address,t.postal_code,t.surface,t.points,'),(1,1,'MAIN_SELECTEDFIELDS_productservicelist','p.accountancy_code_sell,p.ref,p.label,p.sellprice,p.minbuyprice,p.desiredstock,p.stock,p.tosell,p.tobuy,'),(1,1,'MAIN_SELECTEDFIELDS_rentslist','t.end,t.start,t.depotgarantie,t.loyer,t.indiceval,t.indice,t.fk_contrat,'),(1,1,'MAIN_SELECTEDFIELDS_servicelist','p.accountancy_code_buy,p.accountancy_code_sell,p.ref,p.label,p.sellprice,p.tosell,p.tobuy,'),(1,2,'MAIN_SELECTEDFIELDS_servicelist','p.accountancy_code_buy,p.accountancy_code_sell,p.ref,p.label,p.duration,p.sellprice,p.minbuyprice,p.desiredstock,p.stock,p.tosell,p.tobuy,'),(1,2,'MAIN_SELECTEDFIELDS_supplierinvoicelist','f.ref,f.ref_supplier,s.nom,f.date_lim_reglement,f.datef,ef.batimentfacturefourn,f.total_ttc,f.fk_statut,'),(1,1,'MAIN_SELECTEDFIELDS_thirdpartylist','s.address,s.nom,s.code_client,s.zip,s.phone,customerorsupplier,ef.signature_link,s.status,'),(1,2,'MAIN_SELECTEDFIELDS_ticketlist','ef.espaceticket,t.subject,ef.batimentticket,t.ref,t.type_code,t.category_code,t.severity_code,t.fk_soc,t.progress,t.fk_statut,t.import_key,'),(1,1,'MAIN_SELECTEDFIELDS_userlist','u.login,u.lastname,u.firstname,u.fk_user,u.office_phone,u.user_mobile,u.email,u.fk_soc,u.datelastlogin,u.statut,'),(11,2,'MAIN_BOXES_0','1'),(11,2,'MAIN_SELECTEDFIELDS_customerlist','s.email,s.nom,s.name_alias,s.code_client,s.code_compta,s.zip,s.phone,typent.code,customerorsupplier,s.status,'),(11,2,'MAIN_SELECTEDFIELDS_invoicelist','ef.batimentfacture,f.ref,f.ref_client,f.datef,f.date_lim_reglement,s.nom,f.total_ht,f.total_ttc,u.login,f.fk_statut,'),(11,2,'MAIN_SELECTEDFIELDS_invoicetemplatelist','f.datec,f.titre,f.frequency,f.date_when,f.nb_gen_done,s.nom,f.unit_frequency,recurring,f.total_ttc,f.total_ht,status,'),(11,2,'MAIN_SELECTEDFIELDS_supplierinvoicelist','f.total_ttc,f.ref,u.login,f.ref_supplier,s.nom,f.date_lim_reglement,f.datef,ef.batimentfacturefourn,f.fk_cond_reglement,f.fk_mode_reglement,f.total_ht,f.fk_statut,');

--
-- Table structure for table `llx_user_perentity`
--

CREATE TABLE `llx_user_perentity` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `fk_user` int(11) NOT NULL,
  `office_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `office_fax` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_mobile` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `personal_mobile` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `personal_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `signature` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_user_perentity_fk_user` (`entity`,`fk_user`),
  KEY `fk_user_perentity_fk_user` (`fk_user`),
  CONSTRAINT `fk_user_perentity_entity` FOREIGN KEY (`entity`) REFERENCES `llx_entity` (`rowid`),
  CONSTRAINT `fk_user_perentity_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user_perentity`
--


--
-- Table structure for table `llx_user_rib`
--

CREATE TABLE `llx_user_rib` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT 1,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `label` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_banque` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_guichet` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cle_rib` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bic` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iban_prefix` varchar(34) COLLATE utf8_unicode_ci DEFAULT NULL,
  `domiciliation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `proprio` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `owner_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user_rib`
--


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

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

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

INSERT INTO `llx_user_rights` (`rowid`, `entity`, `fk_user`, `fk_id`) VALUES (3531,1,1,11),(3511,1,1,12),(3516,1,1,13),(3519,1,1,14),(3522,1,1,15),(3526,1,1,16),(3532,1,1,19),(24,1,1,21),(18,1,1,22),(19,1,1,24),(20,1,1,25),(21,1,1,26),(23,1,1,27),(25,1,1,28),(142,1,1,31),(137,1,1,32),(139,1,1,34),(141,1,1,38),(143,1,1,39),(3498,1,1,81),(3481,1,1,82),(3486,1,1,84),(3489,1,1,86),(3492,1,1,87),(3495,1,1,88),(3499,1,1,89),(107,1,1,91),(104,1,1,92),(106,1,1,93),(108,1,1,94),(3450,1,1,111),(3421,1,1,112),(3427,1,1,113),(3433,1,1,114),(3439,1,1,115),(3445,1,1,116),(3451,1,1,117),(3654,1,1,121),(3643,1,1,122),(3649,1,1,125),(3655,1,1,126),(2083,1,1,161),(2060,1,1,162),(2066,1,1,163),(2072,1,1,164),(2078,1,1,165),(2084,1,1,167),(165,1,1,241),(164,1,1,242),(166,1,1,243),(3765,1,1,251),(3708,1,1,252),(3712,1,1,253),(3717,1,1,254),(3721,1,1,255),(3727,1,1,256),(3660,1,1,262),(3678,1,1,281),(3667,1,1,282),(3673,1,1,283),(3679,1,1,286),(170,1,1,331),(169,1,1,332),(171,1,1,333),(3732,1,1,341),(3735,1,1,342),(3738,1,1,343),(3741,1,1,344),(3759,1,1,351),(3748,1,1,352),(3754,1,1,353),(3760,1,1,354),(3766,1,1,358),(2950,1,1,431),(3633,1,1,531),(3622,1,1,532),(3628,1,1,534),(3634,1,1,538),(154,1,1,1001),(153,1,1,1002),(155,1,1,1003),(157,1,1,1004),(158,1,1,1005),(160,1,1,1011),(161,1,1,1012),(3543,1,1,1181),(3585,1,1,1182),(3550,1,1,1183),(3555,1,1,1184),(3559,1,1,1185),(3565,1,1,1186),(3571,1,1,1187),(3580,1,1,1188),(3576,1,1,1189),(3586,1,1,1191),(3612,1,1,1231),(3595,1,1,1232),(3600,1,1,1233),(3604,1,1,1234),(3609,1,1,1235),(3613,1,1,1236),(172,1,1,1251),(3537,1,1,1321),(3540,1,1,1322),(3504,1,1,1421),(3393,1,1,2401),(3388,1,1,2402),(3394,1,1,2403),(3408,1,1,2411),(3403,1,1,2412),(3409,1,1,2413),(3414,1,1,2414),(180,1,1,3201),(3309,1,1,3301),(2454,1,1,5001),(2443,1,1,5002),(2455,1,1,5003),(2487,1,1,5011),(2476,1,1,5012),(2488,1,1,5013),(2520,1,1,5021),(2509,1,1,5022),(2521,1,1,5023),(2553,1,1,5031),(2542,1,1,5032),(2554,1,1,5033),(2604,1,1,5041),(2575,1,1,5042),(2584,1,1,5043),(2587,1,1,5044),(2593,1,1,5045),(2605,1,1,5046),(2658,1,1,5051),(2626,1,1,5052),(2635,1,1,5054),(2638,1,1,5056),(2644,1,1,5057),(2653,1,1,5058),(2659,1,1,5059),(2715,1,1,5061),(2680,1,1,5062),(2689,1,1,5063),(2692,1,1,5064),(2695,1,1,5065),(2701,1,1,5066),(2710,1,1,5067),(2716,1,1,5069),(3471,1,1,23001),(3460,1,1,23002),(3466,1,1,23003),(3472,1,1,23004),(3348,1,1,50401),(3372,1,1,50411),(3355,1,1,50412),(3361,1,1,50414),(3367,1,1,50415),(3373,1,1,50418),(3378,1,1,50420),(3381,1,1,50430),(3345,1,1,50440),(3699,1,1,56001),(3688,1,1,56002),(3694,1,1,56003),(3700,1,1,56004),(4079,1,1,50000001),(4074,1,1,50000002),(4080,1,1,50000003),(3771,1,1,858369821),(945,1,3,2401),(946,1,3,5011),(947,1,3,5021),(948,1,4,2401),(949,1,4,5011),(950,1,4,5021),(951,1,5,2401),(952,1,5,5011),(953,1,5,5021),(957,1,7,2401),(958,1,7,5011),(959,1,7,5021),(3533,1,8,11),(3513,1,8,12),(3517,1,8,13),(3520,1,8,14),(3523,1,8,15),(3528,1,8,16),(3534,1,8,19),(3500,1,8,81),(3483,1,8,82),(3487,1,8,84),(3490,1,8,86),(3493,1,8,87),(3496,1,8,88),(3501,1,8,89),(3452,1,8,111),(3423,1,8,112),(3429,1,8,113),(3435,1,8,114),(3441,1,8,115),(3447,1,8,116),(3453,1,8,117),(3656,1,8,121),(3645,1,8,122),(3651,1,8,125),(3657,1,8,126),(2085,1,8,161),(2062,1,8,162),(2068,1,8,163),(2074,1,8,164),(2080,1,8,165),(2086,1,8,167),(3767,1,8,251),(3709,1,8,252),(3714,1,8,253),(3718,1,8,254),(3723,1,8,255),(3729,1,8,256),(3661,1,8,262),(3680,1,8,281),(3669,1,8,282),(3675,1,8,283),(3681,1,8,286),(3733,1,8,341),(3736,1,8,342),(3739,1,8,343),(3742,1,8,344),(3761,1,8,351),(3750,1,8,352),(3756,1,8,353),(3762,1,8,354),(3768,1,8,358),(2951,1,8,431),(3635,1,8,531),(3624,1,8,532),(3630,1,8,534),(3636,1,8,538),(3544,1,8,1181),(3587,1,8,1182),(3552,1,8,1183),(3556,1,8,1184),(3561,1,8,1185),(3567,1,8,1186),(3573,1,8,1187),(3582,1,8,1188),(3577,1,8,1189),(3588,1,8,1191),(3614,1,8,1231),(3597,1,8,1232),(3601,1,8,1233),(3606,1,8,1234),(3610,1,8,1235),(3615,1,8,1236),(3538,1,8,1321),(3541,1,8,1322),(3505,1,8,1421),(3395,1,8,2401),(3390,1,8,2402),(3396,1,8,2403),(3410,1,8,2411),(3405,1,8,2412),(3411,1,8,2413),(3415,1,8,2414),(3310,1,8,3301),(2458,1,8,5001),(2447,1,8,5002),(2459,1,8,5003),(2491,1,8,5011),(2480,1,8,5012),(2492,1,8,5013),(2524,1,8,5021),(2513,1,8,5022),(2525,1,8,5023),(2557,1,8,5031),(2546,1,8,5032),(2558,1,8,5033),(2608,1,8,5041),(2579,1,8,5042),(2585,1,8,5043),(2588,1,8,5044),(2597,1,8,5045),(2609,1,8,5046),(2662,1,8,5051),(2630,1,8,5052),(2636,1,8,5054),(2639,1,8,5056),(2648,1,8,5057),(2654,1,8,5058),(2663,1,8,5059),(2719,1,8,5061),(2684,1,8,5062),(2690,1,8,5063),(2693,1,8,5064),(2696,1,8,5065),(2705,1,8,5066),(2711,1,8,5067),(2720,1,8,5069),(3473,1,8,23001),(3462,1,8,23002),(3468,1,8,23003),(3474,1,8,23004),(3349,1,8,50401),(3374,1,8,50411),(3357,1,8,50412),(3363,1,8,50414),(3369,1,8,50415),(3375,1,8,50418),(3379,1,8,50420),(3382,1,8,50430),(3346,1,8,50440),(3701,1,8,56001),(3690,1,8,56002),(3696,1,8,56003),(3702,1,8,56004),(4081,1,8,50000001),(4076,1,8,50000002),(4082,1,8,50000003),(3772,1,8,858369821),(3535,1,9,11),(3515,1,9,12),(3518,1,9,13),(3521,1,9,14),(3524,1,9,15),(3530,1,9,16),(3536,1,9,19),(3502,1,9,81),(3485,1,9,82),(3488,1,9,84),(3491,1,9,86),(3494,1,9,87),(3497,1,9,88),(3503,1,9,89),(3454,1,9,111),(3425,1,9,112),(3431,1,9,113),(3437,1,9,114),(3443,1,9,115),(3449,1,9,116),(3455,1,9,117),(3658,1,9,121),(3647,1,9,122),(3653,1,9,125),(3659,1,9,126),(2087,1,9,161),(2064,1,9,162),(2070,1,9,163),(2076,1,9,164),(2082,1,9,165),(2088,1,9,167),(3769,1,9,251),(3710,1,9,252),(3716,1,9,253),(3719,1,9,254),(3725,1,9,255),(3731,1,9,256),(3662,1,9,262),(3682,1,9,281),(3671,1,9,282),(3677,1,9,283),(3683,1,9,286),(3734,1,9,341),(3737,1,9,342),(3740,1,9,343),(3743,1,9,344),(3763,1,9,351),(3752,1,9,352),(3758,1,9,353),(3764,1,9,354),(3770,1,9,358),(2952,1,9,431),(3637,1,9,531),(3626,1,9,532),(3632,1,9,534),(3638,1,9,538),(3545,1,9,1181),(3589,1,9,1182),(3554,1,9,1183),(3557,1,9,1184),(3563,1,9,1185),(3569,1,9,1186),(3575,1,9,1187),(3584,1,9,1188),(3578,1,9,1189),(3590,1,9,1191),(3616,1,9,1231),(3599,1,9,1232),(3602,1,9,1233),(3608,1,9,1234),(3611,1,9,1235),(3617,1,9,1236),(3539,1,9,1321),(3542,1,9,1322),(3506,1,9,1421),(3397,1,9,2401),(3392,1,9,2402),(3398,1,9,2403),(3412,1,9,2411),(3407,1,9,2412),(3413,1,9,2413),(3416,1,9,2414),(3311,1,9,3301),(2462,1,9,5001),(2451,1,9,5002),(2463,1,9,5003),(2495,1,9,5011),(2484,1,9,5012),(2496,1,9,5013),(2528,1,9,5021),(2517,1,9,5022),(2529,1,9,5023),(2561,1,9,5031),(2550,1,9,5032),(2562,1,9,5033),(2612,1,9,5041),(2583,1,9,5042),(2586,1,9,5043),(2589,1,9,5044),(2601,1,9,5045),(2613,1,9,5046),(2666,1,9,5051),(2634,1,9,5052),(2637,1,9,5054),(2640,1,9,5056),(2652,1,9,5057),(2655,1,9,5058),(2667,1,9,5059),(2723,1,9,5061),(2688,1,9,5062),(2691,1,9,5063),(2694,1,9,5064),(2697,1,9,5065),(2709,1,9,5066),(2712,1,9,5067),(2724,1,9,5069),(3475,1,9,23001),(3464,1,9,23002),(3470,1,9,23003),(3476,1,9,23004),(3350,1,9,50401),(3376,1,9,50411),(3359,1,9,50412),(3365,1,9,50414),(3371,1,9,50415),(3377,1,9,50418),(3380,1,9,50420),(3383,1,9,50430),(3347,1,9,50440),(3703,1,9,56001),(3692,1,9,56002),(3698,1,9,56003),(3704,1,9,56004),(4083,1,9,50000001),(4078,1,9,50000002),(4084,1,9,50000003),(3773,1,9,858369821),(3308,1,15,431),(4023,1,16,858369821),(4054,1,17,858369821),(4097,1,18,858369821),(367,2,1,11),(359,2,1,12),(360,2,1,13),(361,2,1,14),(362,2,1,15),(365,2,1,16),(368,2,1,19),(267,2,1,21),(259,2,1,22),(260,2,1,24),(261,2,1,25),(262,2,1,26),(265,2,1,27),(268,2,1,28),(442,2,1,31),(434,2,1,32),(437,2,1,34),(440,2,1,38),(443,2,1,39),(4039,2,1,61),(4028,2,1,62),(4034,2,1,64),(4040,2,1,67),(4045,2,1,68),(4048,2,1,69),(4051,2,1,70),(279,2,1,81),(273,2,1,82),(274,2,1,84),(275,2,1,86),(276,2,1,87),(277,2,1,88),(280,2,1,89),(380,2,1,91),(375,2,1,92),(378,2,1,93),(381,2,1,94),(409,2,1,111),(395,2,1,112),(398,2,1,113),(401,2,1,114),(404,2,1,115),(407,2,1,116),(410,2,1,117),(241,2,1,121),(236,2,1,122),(239,2,1,125),(242,2,1,126),(484,2,1,241),(482,2,1,242),(485,2,1,243),(243,2,1,262),(253,2,1,281),(248,2,1,282),(251,2,1,283),(254,2,1,286),(492,2,1,331),(490,2,1,332),(493,2,1,333),(3984,2,1,431),(389,2,1,511),(384,2,1,512),(386,2,1,514),(388,2,1,517),(390,2,1,519),(458,2,1,531),(453,2,1,532),(456,2,1,534),(459,2,1,538),(447,2,1,651),(446,2,1,652),(448,2,1,653),(466,2,1,1001),(464,2,1,1002),(467,2,1,1003),(471,2,1,1004),(472,2,1,1005),(476,2,1,1011),(477,2,1,1012),(311,2,1,1181),(332,2,1,1182),(316,2,1,1183),(317,2,1,1184),(320,2,1,1185),(323,2,1,1186),(326,2,1,1187),(330,2,1,1188),(327,2,1,1189),(333,2,1,1191),(4091,2,1,1201),(4092,2,1,1202),(345,2,1,1231),(338,2,1,1232),(339,2,1,1233),(342,2,1,1234),(343,2,1,1235),(346,2,1,1236),(960,2,1,1251),(369,2,1,1321),(370,2,1,1322),(281,2,1,1421),(299,2,1,2401),(297,2,1,2402),(300,2,1,2403),(307,2,1,2411),(305,2,1,2412),(308,2,1,2413),(309,2,1,2414),(4085,2,1,3201),(3789,2,1,23001),(3778,2,1,23002),(3784,2,1,23003),(3790,2,1,23004),(412,2,1,50401),(425,2,1,50411),(417,2,1,50412),(420,2,1,50414),(423,2,1,50415),(426,2,1,50418),(428,2,1,50420),(429,2,1,50430),(411,2,1,50440),(291,2,1,56001),(286,2,1,56002),(289,2,1,56003),(292,2,1,56004),(4002,2,1,63001),(3991,2,1,63002),(3997,2,1,63003),(4003,2,1,63004),(943,2,1,432511),(942,2,1,432512),(944,2,1,432513),(353,2,1,941601),(349,2,1,941602),(350,2,1,941603),(351,2,1,941604),(352,2,1,941605),(354,2,1,941606),(2808,2,1,50000001),(2797,2,1,50000002),(2809,2,1,50000003),(2749,2,1,125042001),(494,2,1,858369821),(2113,2,8,11),(2114,2,8,12),(2115,2,8,13),(2116,2,8,14),(2117,2,8,15),(2118,2,8,16),(2119,2,8,19),(2120,2,8,21),(2121,2,8,22),(2122,2,8,24),(2123,2,8,25),(2124,2,8,26),(2125,2,8,27),(2126,2,8,28),(2127,2,8,31),(2128,2,8,32),(2129,2,8,34),(2130,2,8,38),(2131,2,8,39),(4041,2,8,61),(4030,2,8,62),(4036,2,8,64),(4042,2,8,67),(4046,2,8,68),(4049,2,8,69),(4052,2,8,70),(2132,2,8,81),(2133,2,8,82),(2134,2,8,84),(2135,2,8,86),(2136,2,8,87),(2137,2,8,88),(2138,2,8,89),(2139,2,8,91),(2140,2,8,92),(2141,2,8,93),(2142,2,8,94),(2143,2,8,111),(2144,2,8,112),(2145,2,8,113),(2146,2,8,114),(2147,2,8,115),(2148,2,8,116),(2149,2,8,117),(2150,2,8,121),(2151,2,8,122),(2152,2,8,125),(2153,2,8,126),(2154,2,8,241),(2155,2,8,242),(2156,2,8,243),(2157,2,8,251),(2158,2,8,252),(2159,2,8,253),(2160,2,8,254),(2161,2,8,255),(2162,2,8,256),(2163,2,8,262),(2164,2,8,281),(2165,2,8,282),(2166,2,8,283),(2167,2,8,286),(2168,2,8,331),(2169,2,8,332),(2170,2,8,333),(2171,2,8,341),(2172,2,8,342),(2173,2,8,343),(2174,2,8,344),(2175,2,8,351),(2176,2,8,352),(2177,2,8,353),(2178,2,8,354),(2179,2,8,358),(3985,2,8,431),(2180,2,8,511),(2181,2,8,512),(2182,2,8,514),(2183,2,8,517),(2184,2,8,519),(2185,2,8,531),(2186,2,8,532),(2187,2,8,534),(2188,2,8,538),(2189,2,8,1001),(2190,2,8,1002),(2191,2,8,1003),(2192,2,8,1004),(2193,2,8,1005),(2194,2,8,1011),(2195,2,8,1012),(2196,2,8,1181),(2197,2,8,1182),(2198,2,8,1183),(2199,2,8,1184),(2200,2,8,1185),(2201,2,8,1186),(2202,2,8,1187),(2203,2,8,1188),(2204,2,8,1189),(2205,2,8,1191),(4093,2,8,1201),(4094,2,8,1202),(2206,2,8,1231),(2207,2,8,1232),(2208,2,8,1233),(2209,2,8,1234),(2210,2,8,1235),(2211,2,8,1236),(2212,2,8,1251),(2213,2,8,1321),(2214,2,8,1322),(2215,2,8,1421),(2216,2,8,2401),(2217,2,8,2402),(2218,2,8,2403),(2219,2,8,2411),(2220,2,8,2412),(2221,2,8,2413),(2222,2,8,2414),(4086,2,8,3201),(2223,2,8,5001),(2224,2,8,5002),(2225,2,8,5003),(2226,2,8,5011),(2227,2,8,5012),(2228,2,8,5013),(2229,2,8,5021),(2230,2,8,5022),(2231,2,8,5023),(2232,2,8,5031),(2233,2,8,5032),(2234,2,8,5033),(2235,2,8,5041),(2236,2,8,5042),(2237,2,8,5043),(2238,2,8,5044),(2239,2,8,5045),(2240,2,8,5046),(2241,2,8,5051),(2242,2,8,5052),(2243,2,8,5054),(2244,2,8,5056),(2245,2,8,5057),(2246,2,8,5058),(2247,2,8,5059),(2248,2,8,5061),(2249,2,8,5062),(2250,2,8,5063),(2251,2,8,5064),(2252,2,8,5065),(2253,2,8,5066),(2254,2,8,5067),(2255,2,8,5069),(3791,2,8,23001),(3780,2,8,23002),(3786,2,8,23003),(3792,2,8,23004),(2256,2,8,50401),(2257,2,8,50411),(2258,2,8,50412),(2259,2,8,50414),(2260,2,8,50415),(2261,2,8,50418),(2262,2,8,50420),(2263,2,8,50430),(2264,2,8,50440),(2265,2,8,56001),(2266,2,8,56002),(2267,2,8,56003),(2268,2,8,56004),(4004,2,8,63001),(3993,2,8,63002),(3999,2,8,63003),(4005,2,8,63004),(2269,2,8,432511),(2270,2,8,432512),(2271,2,8,432513),(2272,2,8,941601),(2273,2,8,941602),(2274,2,8,941603),(2275,2,8,941604),(2276,2,8,941605),(2277,2,8,941606),(2812,2,8,50000001),(2801,2,8,50000002),(2813,2,8,50000003),(2750,2,8,125042001),(2281,2,8,858369821),(4043,2,9,61),(4032,2,9,62),(4038,2,9,64),(4044,2,9,67),(4047,2,9,68),(4050,2,9,69),(4053,2,9,70),(3986,2,9,431),(4095,2,9,1201),(4096,2,9,1202),(4087,2,9,3201),(3793,2,9,23001),(3782,2,9,23002),(3788,2,9,23003),(3794,2,9,23004),(4006,2,9,63001),(3995,2,9,63002),(4001,2,9,63003),(4007,2,9,63004),(2816,2,9,50000001),(2805,2,9,50000002),(2817,2,9,50000003),(2751,2,9,125042001),(2986,2,11,11),(2987,2,11,12),(2988,2,11,13),(2989,2,11,14),(2990,2,11,15),(2991,2,11,16),(2993,2,11,21),(2994,2,11,22),(2995,2,11,24),(2996,2,11,25),(2997,2,11,26),(2998,2,11,27),(2999,2,11,28),(3000,2,11,31),(3001,2,11,32),(3002,2,11,34),(3003,2,11,38),(3004,2,11,39),(3005,2,11,81),(3006,2,11,82),(3007,2,11,84),(3008,2,11,86),(3009,2,11,87),(3010,2,11,88),(3011,2,11,89),(3012,2,11,91),(3013,2,11,92),(3014,2,11,93),(3015,2,11,94),(3016,2,11,111),(3017,2,11,112),(3018,2,11,113),(3019,2,11,114),(3020,2,11,115),(3021,2,11,116),(3022,2,11,117),(3023,2,11,121),(3024,2,11,122),(3025,2,11,125),(3026,2,11,126),(3027,2,11,241),(3028,2,11,242),(3029,2,11,243),(3030,2,11,251),(3031,2,11,252),(3033,2,11,254),(3036,2,11,262),(3037,2,11,281),(3038,2,11,282),(3039,2,11,283),(3040,2,11,286),(3041,2,11,331),(3042,2,11,332),(3043,2,11,333),(3044,2,11,341),(3045,2,11,342),(3046,2,11,343),(3047,2,11,344),(3048,2,11,351),(3049,2,11,352),(3050,2,11,353),(3051,2,11,354),(3052,2,11,358),(3053,2,11,511),(3054,2,11,512),(3055,2,11,514),(3056,2,11,517),(3057,2,11,519),(3058,2,11,531),(3059,2,11,532),(3060,2,11,534),(3061,2,11,538),(3062,2,11,1001),(3063,2,11,1002),(3064,2,11,1003),(3065,2,11,1004),(3066,2,11,1005),(3067,2,11,1011),(3068,2,11,1012),(3069,2,11,1181),(3070,2,11,1182),(3071,2,11,1183),(3072,2,11,1184),(3073,2,11,1185),(3074,2,11,1186),(3075,2,11,1187),(3076,2,11,1188),(3077,2,11,1189),(3078,2,11,1191),(3079,2,11,1231),(3080,2,11,1232),(3081,2,11,1233),(3083,2,11,1235),(3084,2,11,1236),(3085,2,11,1251),(3086,2,11,1321),(3087,2,11,1322),(3088,2,11,1421),(3089,2,11,2401),(3090,2,11,2402),(3091,2,11,2403),(3092,2,11,2411),(3093,2,11,2412),(3094,2,11,2413),(3095,2,11,2414),(3096,2,11,5001),(3097,2,11,5002),(3098,2,11,5003),(3099,2,11,5011),(3100,2,11,5012),(3101,2,11,5013),(3102,2,11,5021),(3103,2,11,5022),(3104,2,11,5023),(3105,2,11,5031),(3106,2,11,5032),(3107,2,11,5033),(3108,2,11,5041),(3109,2,11,5042),(3110,2,11,5043),(3111,2,11,5044),(3112,2,11,5045),(3113,2,11,5046),(3114,2,11,5051),(3115,2,11,5052),(3116,2,11,5054),(3117,2,11,5056),(3118,2,11,5057),(3119,2,11,5058),(3120,2,11,5059),(3121,2,11,5061),(3122,2,11,5062),(3123,2,11,5063),(3124,2,11,5064),(3125,2,11,5065),(3126,2,11,5066),(3127,2,11,5067),(3128,2,11,5069),(3129,2,11,50401),(3130,2,11,50411),(3131,2,11,50412),(3132,2,11,50414),(3133,2,11,50415),(3134,2,11,50418),(3135,2,11,50420),(3136,2,11,50430),(3137,2,11,50440),(3138,2,11,56001),(3139,2,11,56002),(3140,2,11,56003),(3141,2,11,56004),(3142,2,11,432511),(3143,2,11,432512),(3144,2,11,432513),(3145,2,11,941601),(3146,2,11,941602),(3147,2,11,941603),(3148,2,11,941604),(3149,2,11,941605),(3150,2,11,941606),(3151,2,11,50000001),(3152,2,11,50000002),(3153,2,11,50000003),(3154,2,11,125042001),(618,3,1,11),(608,3,1,12),(609,3,1,13),(610,3,1,14),(611,3,1,15),(615,3,1,16),(619,3,1,19),(788,3,1,21),(778,3,1,22),(779,3,1,24),(780,3,1,25),(781,3,1,26),(785,3,1,27),(789,3,1,28),(706,3,1,31),(695,3,1,32),(699,3,1,34),(703,3,1,38),(707,3,1,39),(539,3,1,81),(532,3,1,82),(533,3,1,84),(534,3,1,86),(535,3,1,87),(536,3,1,88),(540,3,1,89),(635,3,1,91),(628,3,1,92),(632,3,1,93),(636,3,1,94),(662,3,1,111),(643,3,1,112),(647,3,1,113),(651,3,1,114),(655,3,1,115),(659,3,1,116),(663,3,1,117),(508,3,1,121),(501,3,1,122),(505,3,1,125),(509,3,1,126),(755,3,1,241),(752,3,1,242),(756,3,1,243),(510,3,1,262),(524,3,1,281),(517,3,1,282),(521,3,1,283),(525,3,1,286),(766,3,1,331),(763,3,1,332),(767,3,1,333),(721,3,1,531),(714,3,1,532),(718,3,1,534),(722,3,1,538),(544,3,1,1181),(572,3,1,1182),(551,3,1,1183),(552,3,1,1184),(556,3,1,1185),(560,3,1,1186),(564,3,1,1187),(569,3,1,1188),(565,3,1,1189),(573,3,1,1191),(589,3,1,1231),(580,3,1,1232),(581,3,1,1233),(585,3,1,1234),(586,3,1,1235),(590,3,1,1236),(620,3,1,1321),(621,3,1,1322),(541,3,1,1421),(732,3,1,2401),(729,3,1,2402),(733,3,1,2403),(743,3,1,2411),(740,3,1,2412),(744,3,1,2413),(745,3,1,2414),(665,3,1,50401),(683,3,1,50411),(672,3,1,50412),(676,3,1,50414),(680,3,1,50415),(684,3,1,50418),(687,3,1,50420),(688,3,1,50430),(664,3,1,50440),(769,3,1,59001),(770,3,1,59002),(771,3,1,59003),(600,3,1,941601),(595,3,1,941602),(596,3,1,941603),(597,3,1,941604),(598,3,1,941605),(601,3,1,941606),(2775,3,1,50000001),(2764,3,1,50000002),(2776,3,1,50000003),(768,3,1,858369821),(2282,3,8,11),(2283,3,8,12),(2284,3,8,13),(2285,3,8,14),(2286,3,8,15),(2287,3,8,16),(2288,3,8,19),(2289,3,8,21),(2290,3,8,22),(2291,3,8,24),(2292,3,8,25),(2293,3,8,26),(2294,3,8,27),(2295,3,8,28),(2296,3,8,31),(2297,3,8,32),(2298,3,8,34),(2299,3,8,38),(2300,3,8,39),(2301,3,8,81),(2302,3,8,82),(2303,3,8,84),(2304,3,8,86),(2305,3,8,87),(2306,3,8,88),(2307,3,8,89),(2308,3,8,91),(2309,3,8,92),(2310,3,8,93),(2311,3,8,94),(2312,3,8,111),(2313,3,8,112),(2314,3,8,113),(2315,3,8,114),(2316,3,8,115),(2317,3,8,116),(2318,3,8,117),(2319,3,8,121),(2320,3,8,122),(2321,3,8,125),(2322,3,8,126),(2323,3,8,241),(2324,3,8,242),(2325,3,8,243),(2326,3,8,251),(2327,3,8,252),(2328,3,8,253),(2329,3,8,254),(2330,3,8,255),(2331,3,8,256),(2332,3,8,262),(2333,3,8,281),(2334,3,8,282),(2335,3,8,283),(2336,3,8,286),(2337,3,8,331),(2338,3,8,332),(2339,3,8,333),(2340,3,8,341),(2341,3,8,342),(2342,3,8,343),(2343,3,8,344),(2344,3,8,351),(2345,3,8,352),(2346,3,8,353),(2347,3,8,354),(2348,3,8,358),(2349,3,8,531),(2350,3,8,532),(2351,3,8,534),(2352,3,8,538),(2353,3,8,1181),(2354,3,8,1182),(2355,3,8,1183),(2356,3,8,1184),(2357,3,8,1185),(2358,3,8,1186),(2359,3,8,1187),(2360,3,8,1188),(2361,3,8,1189),(2362,3,8,1191),(2363,3,8,1231),(2364,3,8,1232),(2365,3,8,1233),(2366,3,8,1234),(2367,3,8,1235),(2368,3,8,1236),(2369,3,8,1321),(2370,3,8,1322),(2371,3,8,1421),(2372,3,8,2401),(2373,3,8,2402),(2374,3,8,2403),(2375,3,8,2411),(2376,3,8,2412),(2377,3,8,2413),(2378,3,8,2414),(2379,3,8,5001),(2380,3,8,5002),(2381,3,8,5003),(2382,3,8,5011),(2383,3,8,5012),(2384,3,8,5013),(2385,3,8,5021),(2386,3,8,5022),(2387,3,8,5023),(2388,3,8,5031),(2389,3,8,5032),(2390,3,8,5033),(2391,3,8,5041),(2392,3,8,5042),(2393,3,8,5043),(2394,3,8,5044),(2395,3,8,5045),(2396,3,8,5046),(2397,3,8,5051),(2398,3,8,5052),(2399,3,8,5054),(2400,3,8,5056),(2401,3,8,5057),(2402,3,8,5058),(2403,3,8,5059),(2404,3,8,5061),(2405,3,8,5062),(2406,3,8,5063),(2407,3,8,5064),(2408,3,8,5065),(2409,3,8,5066),(2410,3,8,5067),(2411,3,8,5069),(2412,3,8,50401),(2413,3,8,50411),(2414,3,8,50412),(2415,3,8,50414),(2416,3,8,50415),(2417,3,8,50418),(2418,3,8,50420),(2419,3,8,50430),(2420,3,8,50440),(2421,3,8,59001),(2422,3,8,59002),(2423,3,8,59003),(2424,3,8,941601),(2425,3,8,941602),(2426,3,8,941603),(2427,3,8,941604),(2428,3,8,941605),(2429,3,8,941606),(2779,3,8,50000001),(2768,3,8,50000002),(2780,3,8,50000003),(2430,3,8,858369821),(2783,3,9,50000001),(2772,3,9,50000002),(2784,3,9,50000003),(3156,3,11,11),(3157,3,11,12),(3158,3,11,13),(3159,3,11,14),(3160,3,11,15),(3161,3,11,16),(3162,3,11,19),(3163,3,11,21),(3164,3,11,22),(3165,3,11,24),(3166,3,11,25),(3167,3,11,26),(3168,3,11,27),(3169,3,11,28),(3170,3,11,31),(3171,3,11,32),(3172,3,11,34),(3173,3,11,38),(3174,3,11,39),(3175,3,11,81),(3176,3,11,82),(3177,3,11,84),(3178,3,11,86),(3179,3,11,87),(3180,3,11,88),(3181,3,11,89),(3182,3,11,91),(3183,3,11,92),(3184,3,11,93),(3185,3,11,94),(3186,3,11,111),(3187,3,11,112),(3188,3,11,113),(3189,3,11,114),(3190,3,11,115),(3191,3,11,116),(3192,3,11,117),(3193,3,11,121),(3194,3,11,122),(3195,3,11,125),(3196,3,11,126),(3197,3,11,241),(3198,3,11,242),(3199,3,11,243),(3200,3,11,251),(3201,3,11,252),(3202,3,11,253),(3203,3,11,254),(3204,3,11,255),(3205,3,11,256),(3206,3,11,262),(3207,3,11,281),(3208,3,11,282),(3209,3,11,283),(3210,3,11,286),(3211,3,11,331),(3212,3,11,332),(3213,3,11,333),(3214,3,11,341),(3215,3,11,342),(3216,3,11,343),(3217,3,11,344),(3218,3,11,351),(3219,3,11,352),(3220,3,11,353),(3221,3,11,354),(3222,3,11,358),(3223,3,11,531),(3224,3,11,532),(3225,3,11,534),(3226,3,11,538),(3227,3,11,1181),(3228,3,11,1182),(3229,3,11,1183),(3230,3,11,1184),(3231,3,11,1185),(3232,3,11,1186),(3233,3,11,1187),(3234,3,11,1188),(3235,3,11,1189),(3236,3,11,1191),(3237,3,11,1231),(3238,3,11,1232),(3239,3,11,1233),(3240,3,11,1234),(3241,3,11,1235),(3242,3,11,1236),(3243,3,11,1321),(3244,3,11,1322),(3245,3,11,1421),(3246,3,11,2401),(3247,3,11,2402),(3248,3,11,2403),(3249,3,11,2411),(3250,3,11,2412),(3251,3,11,2413),(3252,3,11,2414),(3253,3,11,5001),(3254,3,11,5002),(3255,3,11,5003),(3256,3,11,5011),(3257,3,11,5012),(3258,3,11,5013),(3259,3,11,5021),(3260,3,11,5022),(3261,3,11,5023),(3262,3,11,5031),(3263,3,11,5032),(3264,3,11,5033),(3265,3,11,5041),(3266,3,11,5042),(3267,3,11,5043),(3268,3,11,5044),(3269,3,11,5045),(3270,3,11,5046),(3271,3,11,5051),(3272,3,11,5052),(3273,3,11,5054),(3274,3,11,5056),(3275,3,11,5057),(3276,3,11,5058),(3277,3,11,5059),(3278,3,11,5061),(3279,3,11,5062),(3280,3,11,5063),(3281,3,11,5064),(3282,3,11,5065),(3283,3,11,5066),(3284,3,11,5067),(3285,3,11,5069),(3286,3,11,50401),(3287,3,11,50411),(3288,3,11,50412),(3289,3,11,50414),(3290,3,11,50415),(3291,3,11,50418),(3292,3,11,50420),(3293,3,11,50430),(3294,3,11,50440),(3295,3,11,59001),(3296,3,11,59002),(3297,3,11,59003),(3298,3,11,941601),(3299,3,11,941602),(3300,3,11,941603),(3301,3,11,941604),(3302,3,11,941605),(3303,3,11,941606),(3304,3,11,50000001),(3305,3,11,50000002),(3306,3,11,50000003),(3307,3,11,858369821);

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

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

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

INSERT INTO `llx_usergroup` (`rowid`, `nom`, `entity`, `datec`, `tms`, `note`, `model_pdf`) VALUES (2,'ADMIN',0,'2021-11-23 13:17:22','2021-11-23 13:17:22',NULL,NULL),(3,'WMUP',0,'2021-12-02 14:20:34','2021-12-02 14:20:34',NULL,NULL),(4,'ASPCM COMPTABILITE',0,'2021-12-30 08:18:58','2021-12-30 07:18:58',NULL,NULL),(5,'PRESIDENCE ASPCM',0,'2021-12-30 08:21:57','2021-12-30 07:21:57',NULL,NULL),(6,'SEM COMPTABILITE',0,'2021-12-30 08:23:07','2021-12-30 07:23:07',NULL,NULL),(7,'SEMPP ASSISTANTE',0,'2021-12-30 08:26:15','2021-12-30 07:26:15',NULL,NULL),(8,'PRESTATAIRE',0,'2021-12-30 08:26:33','2021-12-30 07:26:33',NULL,NULL),(9,'ACCUEIL',0,'2022-01-09 10:44:55','2022-01-09 10:44:55',NULL,NULL),(16,'SALLE',2,'2022-01-18 20:06:24','2022-01-18 21:22:49','roomreservation',NULL),(19,'SALLE',1,'2022-01-19 19:47:24','2022-01-19 19:47:24','roomreservation',NULL);

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

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

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


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

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

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

INSERT INTO `llx_usergroup_rights` (`rowid`, `entity`, `fk_usergroup`, `fk_id`) VALUES (1,1,2,11),(2,1,2,12),(3,1,2,13),(4,1,2,14),(5,1,2,15),(6,1,2,16),(7,1,2,19),(8,1,2,21),(9,1,2,22),(10,1,2,24),(11,1,2,25),(12,1,2,26),(13,1,2,27),(14,1,2,28),(15,1,2,31),(16,1,2,32),(17,1,2,34),(18,1,2,38),(19,1,2,39),(20,1,2,81),(21,1,2,82),(22,1,2,84),(23,1,2,86),(24,1,2,87),(25,1,2,88),(26,1,2,89),(27,1,2,91),(28,1,2,92),(29,1,2,93),(30,1,2,94),(31,1,2,111),(32,1,2,112),(33,1,2,113),(34,1,2,114),(35,1,2,115),(36,1,2,116),(37,1,2,117),(38,1,2,121),(39,1,2,122),(40,1,2,125),(41,1,2,126),(42,1,2,161),(43,1,2,162),(44,1,2,163),(45,1,2,164),(46,1,2,165),(47,1,2,167),(48,1,2,241),(49,1,2,242),(50,1,2,243),(51,1,2,251),(52,1,2,252),(53,1,2,253),(54,1,2,254),(55,1,2,255),(56,1,2,256),(57,1,2,262),(58,1,2,281),(59,1,2,282),(60,1,2,283),(61,1,2,286),(62,1,2,331),(63,1,2,332),(64,1,2,333),(65,1,2,341),(66,1,2,342),(67,1,2,343),(68,1,2,344),(69,1,2,351),(70,1,2,352),(71,1,2,353),(72,1,2,354),(73,1,2,358),(74,1,2,531),(75,1,2,532),(76,1,2,534),(77,1,2,538),(78,1,2,1001),(79,1,2,1002),(80,1,2,1003),(81,1,2,1004),(82,1,2,1005),(83,1,2,1011),(84,1,2,1012),(85,1,2,1181),(86,1,2,1182),(87,1,2,1183),(88,1,2,1184),(89,1,2,1185),(90,1,2,1186),(91,1,2,1187),(92,1,2,1188),(93,1,2,1189),(94,1,2,1191),(95,1,2,1231),(96,1,2,1232),(97,1,2,1233),(98,1,2,1234),(99,1,2,1235),(100,1,2,1236),(101,1,2,1251),(102,1,2,1321),(103,1,2,1322),(104,1,2,1421),(105,1,2,2401),(106,1,2,2402),(107,1,2,2403),(108,1,2,2411),(109,1,2,2412),(110,1,2,2413),(111,1,2,2414),(112,1,2,3201),(113,1,2,5001),(114,1,2,5002),(115,1,2,5003),(116,1,2,5011),(117,1,2,5012),(118,1,2,5013),(119,1,2,5021),(120,1,2,5022),(121,1,2,5023),(122,1,2,5031),(123,1,2,5032),(124,1,2,5033),(125,1,2,5041),(126,1,2,5042),(127,1,2,5043),(128,1,2,5044),(129,1,2,5045),(130,1,2,5046),(131,1,2,5051),(132,1,2,5052),(133,1,2,5054),(134,1,2,5056),(135,1,2,5057),(136,1,2,5058),(137,1,2,5059),(138,1,2,5061),(139,1,2,5062),(140,1,2,5063),(141,1,2,5064),(142,1,2,5065),(143,1,2,5066),(144,1,2,5067),(145,1,2,5069),(146,1,2,23001),(147,1,2,23002),(148,1,2,23003),(149,1,2,23004),(150,1,2,50401),(151,1,2,50411),(152,1,2,50412),(153,1,2,50414),(154,1,2,50415),(155,1,2,50418),(156,1,2,50420),(157,1,2,50430),(158,1,2,50440),(159,1,2,56001),(160,1,2,56002),(161,1,2,56003),(162,1,2,56004),(163,1,2,50000001),(164,1,2,50000002),(165,1,2,50000003),(166,1,2,858369821),(634,1,3,11),(635,1,3,12),(636,1,3,13),(637,1,3,14),(638,1,3,15),(639,1,3,16),(640,1,3,19),(641,1,3,21),(642,1,3,22),(643,1,3,24),(644,1,3,25),(645,1,3,26),(646,1,3,27),(647,1,3,28),(648,1,3,31),(649,1,3,32),(650,1,3,34),(651,1,3,38),(652,1,3,39),(653,1,3,81),(654,1,3,82),(655,1,3,84),(656,1,3,86),(657,1,3,87),(658,1,3,88),(659,1,3,89),(660,1,3,91),(661,1,3,92),(662,1,3,93),(663,1,3,94),(664,1,3,111),(665,1,3,112),(666,1,3,113),(667,1,3,114),(668,1,3,115),(669,1,3,116),(670,1,3,117),(671,1,3,121),(672,1,3,122),(673,1,3,125),(674,1,3,126),(675,1,3,161),(676,1,3,162),(677,1,3,163),(678,1,3,164),(679,1,3,165),(680,1,3,167),(681,1,3,241),(682,1,3,242),(683,1,3,243),(684,1,3,251),(685,1,3,252),(686,1,3,253),(687,1,3,254),(688,1,3,255),(689,1,3,256),(690,1,3,262),(691,1,3,281),(692,1,3,282),(693,1,3,283),(694,1,3,286),(695,1,3,331),(696,1,3,332),(697,1,3,333),(698,1,3,341),(699,1,3,342),(700,1,3,343),(701,1,3,344),(702,1,3,351),(703,1,3,352),(704,1,3,353),(705,1,3,354),(706,1,3,358),(707,1,3,531),(708,1,3,532),(709,1,3,534),(710,1,3,538),(711,1,3,1001),(712,1,3,1002),(713,1,3,1003),(714,1,3,1004),(715,1,3,1005),(716,1,3,1011),(717,1,3,1012),(718,1,3,1181),(719,1,3,1182),(720,1,3,1183),(721,1,3,1184),(722,1,3,1185),(723,1,3,1186),(724,1,3,1187),(725,1,3,1188),(726,1,3,1189),(727,1,3,1191),(728,1,3,1231),(729,1,3,1232),(730,1,3,1233),(731,1,3,1234),(732,1,3,1235),(733,1,3,1236),(734,1,3,1251),(735,1,3,1321),(736,1,3,1322),(737,1,3,1421),(738,1,3,2401),(739,1,3,2402),(740,1,3,2403),(741,1,3,2411),(742,1,3,2412),(743,1,3,2413),(744,1,3,2414),(745,1,3,3201),(746,1,3,5001),(747,1,3,5002),(748,1,3,5003),(749,1,3,5011),(750,1,3,5012),(751,1,3,5013),(752,1,3,5021),(753,1,3,5022),(754,1,3,5023),(755,1,3,5031),(756,1,3,5032),(757,1,3,5033),(758,1,3,5041),(759,1,3,5042),(760,1,3,5043),(761,1,3,5044),(762,1,3,5045),(763,1,3,5046),(764,1,3,5051),(765,1,3,5052),(766,1,3,5054),(767,1,3,5056),(768,1,3,5057),(769,1,3,5058),(770,1,3,5059),(771,1,3,5061),(772,1,3,5062),(773,1,3,5063),(774,1,3,5064),(775,1,3,5065),(776,1,3,5066),(777,1,3,5067),(778,1,3,5069),(779,1,3,23001),(780,1,3,23002),(781,1,3,23003),(782,1,3,23004),(783,1,3,50401),(784,1,3,50411),(785,1,3,50412),(786,1,3,50414),(787,1,3,50415),(788,1,3,50418),(789,1,3,50420),(790,1,3,50430),(791,1,3,50440),(792,1,3,56001),(793,1,3,56002),(794,1,3,56003),(795,1,3,56004),(796,1,3,50000001),(797,1,3,50000002),(798,1,3,50000003),(799,1,3,858369821),(1248,1,4,31),(1235,1,4,121),(1249,1,4,161),(1242,1,4,241),(1232,1,4,251),(1236,1,4,262),(1239,1,4,281),(1252,1,4,331),(1245,1,4,531),(1260,1,4,1181),(1254,1,4,56001),(1255,1,4,50000001),(1256,1,4,50000002),(1257,1,4,50000003),(1505,1,5,11),(1499,1,5,21),(1535,1,5,31),(1502,1,5,81),(1558,1,5,91),(1561,1,5,111),(1495,1,5,121),(1496,1,5,122),(1546,1,5,161),(1541,1,5,241),(1542,1,5,242),(1480,1,5,251),(1485,1,5,262),(1491,1,5,281),(1492,1,5,282),(1554,1,5,331),(1555,1,5,332),(1481,1,5,342),(1545,1,5,531),(1508,1,5,1181),(1511,1,5,1182),(1514,1,5,1231),(1531,1,5,2401),(1532,1,5,2402),(1527,1,5,2411),(1524,1,5,2412),(1570,1,5,5051),(1567,1,5,50420),(1563,1,5,56001),(1477,1,5,50000001),(997,1,6,11),(998,1,6,12),(999,1,6,13),(1000,1,6,14),(1001,1,6,15),(1002,1,6,16),(1003,1,6,19),(990,1,6,21),(991,1,6,22),(992,1,6,24),(993,1,6,25),(994,1,6,26),(995,1,6,27),(996,1,6,28),(1032,1,6,31),(1033,1,6,32),(1034,1,6,34),(1035,1,6,38),(1036,1,6,39),(1150,1,6,81),(1151,1,6,82),(1152,1,6,84),(1153,1,6,86),(1154,1,6,87),(1155,1,6,88),(1156,1,6,89),(1057,1,6,111),(1058,1,6,112),(1059,1,6,113),(1060,1,6,114),(1061,1,6,115),(1062,1,6,116),(1063,1,6,117),(981,1,6,121),(982,1,6,122),(983,1,6,125),(984,1,6,126),(1467,1,6,161),(1029,1,6,241),(1030,1,6,242),(1031,1,6,243),(977,1,6,251),(985,1,6,262),(986,1,6,281),(987,1,6,282),(988,1,6,283),(989,1,6,286),(1054,1,6,331),(1055,1,6,332),(1056,1,6,333),(979,1,6,342),(980,1,6,343),(1037,1,6,531),(1038,1,6,532),(1039,1,6,534),(1040,1,6,538),(1041,1,6,1001),(1042,1,6,1002),(1043,1,6,1003),(1044,1,6,1004),(1045,1,6,1005),(1046,1,6,1011),(1047,1,6,1012),(1006,1,6,1181),(1007,1,6,1182),(1008,1,6,1183),(1009,1,6,1184),(1010,1,6,1185),(1011,1,6,1186),(1012,1,6,1187),(1013,1,6,1188),(1014,1,6,1189),(1015,1,6,1191),(1016,1,6,1231),(1017,1,6,1232),(1018,1,6,1233),(1019,1,6,1234),(1020,1,6,1235),(1021,1,6,1236),(1004,1,6,1321),(1005,1,6,1322),(1157,1,6,1421),(1022,1,6,2401),(1023,1,6,2402),(1024,1,6,2403),(1025,1,6,2411),(1026,1,6,2412),(1027,1,6,2413),(1028,1,6,2414),(1064,1,6,50401),(1065,1,6,50411),(1066,1,6,50412),(1067,1,6,50414),(1068,1,6,50415),(1069,1,6,50418),(1070,1,6,50420),(1071,1,6,50430),(1072,1,6,50440),(1159,1,6,56001),(969,1,6,50000001),(970,1,6,50000002),(971,1,6,50000003),(1171,1,7,121),(1172,1,7,122),(1174,1,7,126),(1474,1,7,161),(1188,1,7,241),(1189,1,7,242),(1175,1,7,262),(1176,1,7,281),(1177,1,7,282),(1178,1,7,283),(1179,1,7,286),(1196,1,7,331),(1197,1,7,332),(1198,1,7,333),(1170,1,7,342),(1182,1,7,1181),(1207,1,7,56001),(1208,1,7,56002),(1209,1,7,56003),(1210,1,7,56004),(1211,1,7,50000001),(1212,1,7,50000002),(1213,1,7,50000003),(167,2,2,11),(168,2,2,12),(169,2,2,13),(170,2,2,14),(171,2,2,15),(172,2,2,16),(173,2,2,19),(174,2,2,21),(175,2,2,22),(176,2,2,24),(177,2,2,25),(178,2,2,26),(179,2,2,27),(180,2,2,28),(181,2,2,31),(182,2,2,32),(183,2,2,34),(184,2,2,38),(185,2,2,39),(186,2,2,81),(187,2,2,82),(188,2,2,84),(189,2,2,86),(190,2,2,87),(191,2,2,88),(192,2,2,89),(193,2,2,91),(194,2,2,92),(195,2,2,93),(196,2,2,94),(197,2,2,111),(198,2,2,112),(199,2,2,113),(200,2,2,114),(201,2,2,115),(202,2,2,116),(203,2,2,117),(204,2,2,121),(205,2,2,122),(206,2,2,125),(207,2,2,126),(208,2,2,241),(209,2,2,242),(210,2,2,243),(211,2,2,251),(212,2,2,252),(213,2,2,253),(214,2,2,254),(215,2,2,255),(216,2,2,256),(217,2,2,262),(218,2,2,281),(219,2,2,282),(220,2,2,283),(221,2,2,286),(222,2,2,331),(223,2,2,332),(224,2,2,333),(225,2,2,341),(226,2,2,342),(227,2,2,343),(228,2,2,344),(229,2,2,351),(230,2,2,352),(231,2,2,353),(232,2,2,354),(233,2,2,358),(234,2,2,511),(235,2,2,512),(236,2,2,514),(237,2,2,517),(238,2,2,519),(239,2,2,531),(240,2,2,532),(241,2,2,534),(242,2,2,538),(243,2,2,1001),(244,2,2,1002),(245,2,2,1003),(246,2,2,1004),(247,2,2,1005),(248,2,2,1011),(249,2,2,1012),(250,2,2,1181),(251,2,2,1182),(252,2,2,1183),(253,2,2,1184),(254,2,2,1185),(255,2,2,1186),(256,2,2,1187),(257,2,2,1188),(258,2,2,1189),(259,2,2,1191),(260,2,2,1231),(261,2,2,1232),(262,2,2,1233),(263,2,2,1234),(264,2,2,1235),(265,2,2,1236),(266,2,2,1251),(267,2,2,1321),(268,2,2,1322),(269,2,2,1421),(270,2,2,2401),(271,2,2,2402),(272,2,2,2403),(273,2,2,2411),(274,2,2,2412),(275,2,2,2413),(276,2,2,2414),(277,2,2,5001),(278,2,2,5002),(279,2,2,5003),(280,2,2,5011),(281,2,2,5012),(282,2,2,5013),(283,2,2,5021),(284,2,2,5022),(285,2,2,5023),(286,2,2,5031),(287,2,2,5032),(288,2,2,5033),(289,2,2,5041),(290,2,2,5042),(291,2,2,5043),(292,2,2,5044),(293,2,2,5045),(294,2,2,5046),(295,2,2,5051),(296,2,2,5052),(297,2,2,5054),(298,2,2,5056),(299,2,2,5057),(300,2,2,5058),(301,2,2,5059),(302,2,2,5061),(303,2,2,5062),(304,2,2,5063),(305,2,2,5064),(306,2,2,5065),(307,2,2,5066),(308,2,2,5067),(309,2,2,5069),(310,2,2,50401),(311,2,2,50411),(312,2,2,50412),(313,2,2,50414),(314,2,2,50415),(315,2,2,50418),(316,2,2,50420),(317,2,2,50430),(318,2,2,50440),(319,2,2,56001),(320,2,2,56002),(321,2,2,56003),(322,2,2,56004),(323,2,2,432511),(324,2,2,432512),(325,2,2,432513),(326,2,2,941601),(327,2,2,941602),(328,2,2,941603),(329,2,2,941604),(330,2,2,941605),(331,2,2,941606),(332,2,2,50000001),(333,2,2,50000002),(334,2,2,50000003),(335,2,2,858369821),(800,2,3,11),(801,2,3,12),(802,2,3,13),(803,2,3,14),(804,2,3,15),(805,2,3,16),(806,2,3,19),(807,2,3,21),(808,2,3,22),(809,2,3,24),(810,2,3,25),(811,2,3,26),(812,2,3,27),(813,2,3,28),(814,2,3,31),(815,2,3,32),(816,2,3,34),(817,2,3,38),(818,2,3,39),(819,2,3,81),(820,2,3,82),(821,2,3,84),(822,2,3,86),(823,2,3,87),(824,2,3,88),(825,2,3,89),(826,2,3,91),(827,2,3,92),(828,2,3,93),(829,2,3,94),(830,2,3,111),(831,2,3,112),(832,2,3,113),(833,2,3,114),(834,2,3,115),(835,2,3,116),(836,2,3,117),(837,2,3,121),(838,2,3,122),(839,2,3,125),(840,2,3,126),(841,2,3,241),(842,2,3,242),(843,2,3,243),(844,2,3,251),(845,2,3,252),(846,2,3,253),(847,2,3,254),(848,2,3,255),(849,2,3,256),(850,2,3,262),(851,2,3,281),(852,2,3,282),(853,2,3,283),(854,2,3,286),(855,2,3,331),(856,2,3,332),(857,2,3,333),(858,2,3,341),(859,2,3,342),(860,2,3,343),(861,2,3,344),(862,2,3,351),(863,2,3,352),(864,2,3,353),(865,2,3,354),(866,2,3,358),(867,2,3,511),(868,2,3,512),(869,2,3,514),(870,2,3,517),(871,2,3,519),(872,2,3,531),(873,2,3,532),(874,2,3,534),(875,2,3,538),(876,2,3,1001),(877,2,3,1002),(878,2,3,1003),(879,2,3,1004),(880,2,3,1005),(881,2,3,1011),(882,2,3,1012),(883,2,3,1181),(884,2,3,1182),(885,2,3,1183),(886,2,3,1184),(887,2,3,1185),(888,2,3,1186),(889,2,3,1187),(890,2,3,1188),(891,2,3,1189),(892,2,3,1191),(893,2,3,1231),(894,2,3,1232),(895,2,3,1233),(896,2,3,1234),(897,2,3,1235),(898,2,3,1236),(899,2,3,1251),(900,2,3,1321),(901,2,3,1322),(902,2,3,1421),(903,2,3,2401),(904,2,3,2402),(905,2,3,2403),(906,2,3,2411),(907,2,3,2412),(908,2,3,2413),(909,2,3,2414),(910,2,3,5001),(911,2,3,5002),(912,2,3,5003),(913,2,3,5011),(914,2,3,5012),(915,2,3,5013),(916,2,3,5021),(917,2,3,5022),(918,2,3,5023),(919,2,3,5031),(920,2,3,5032),(921,2,3,5033),(922,2,3,5041),(923,2,3,5042),(924,2,3,5043),(925,2,3,5044),(926,2,3,5045),(927,2,3,5046),(928,2,3,5051),(929,2,3,5052),(930,2,3,5054),(931,2,3,5056),(932,2,3,5057),(933,2,3,5058),(934,2,3,5059),(935,2,3,5061),(936,2,3,5062),(937,2,3,5063),(938,2,3,5064),(939,2,3,5065),(940,2,3,5066),(941,2,3,5067),(942,2,3,5069),(943,2,3,50401),(944,2,3,50411),(945,2,3,50412),(946,2,3,50414),(947,2,3,50415),(948,2,3,50418),(949,2,3,50420),(950,2,3,50430),(951,2,3,50440),(952,2,3,56001),(953,2,3,56002),(954,2,3,56003),(955,2,3,56004),(956,2,3,432511),(957,2,3,432512),(958,2,3,432513),(959,2,3,941601),(960,2,3,941602),(961,2,3,941603),(962,2,3,941604),(963,2,3,941605),(964,2,3,941606),(965,2,3,50000001),(966,2,3,50000002),(967,2,3,50000003),(968,2,3,858369821),(1581,2,5,11),(1579,2,5,21),(1589,2,5,31),(1601,2,5,61),(1580,2,5,81),(1596,2,5,91),(1597,2,5,111),(1577,2,5,121),(1578,2,5,122),(1593,2,5,161),(1590,2,5,241),(1591,2,5,242),(1572,2,5,251),(1574,2,5,262),(1575,2,5,281),(1576,2,5,282),(1594,2,5,331),(1595,2,5,332),(1573,2,5,342),(1592,2,5,531),(1602,2,5,1001),(1582,2,5,1181),(1583,2,5,1182),(1584,2,5,1231),(1587,2,5,2401),(1588,2,5,2402),(1586,2,5,2411),(1585,2,5,2412),(1599,2,5,50420),(1598,2,5,56001),(1571,2,5,50000001),(1603,2,5,125042001),(1267,2,6,56001),(1268,2,6,56002),(1459,2,8,121),(1462,2,8,56001),(1463,2,8,56002),(1464,2,8,56003),(1465,2,8,56004),(1466,2,8,125042001),(1090,2,9,21),(1091,2,9,22),(1092,2,9,24),(1093,2,9,25),(1094,2,9,26),(1095,2,9,27),(1096,2,9,28),(1117,2,9,31),(1097,2,9,81),(1098,2,9,82),(1099,2,9,84),(1100,2,9,86),(1101,2,9,87),(1102,2,9,88),(1103,2,9,89),(1083,2,9,121),(1084,2,9,122),(1112,2,9,241),(1113,2,9,242),(1114,2,9,243),(1075,2,9,251),(1085,2,9,262),(1088,2,9,281),(1089,2,9,282),(1132,2,9,331),(1133,2,9,332),(1134,2,9,333),(1076,2,9,342),(1077,2,9,343),(1120,2,9,531),(1125,2,9,1001),(1122,2,9,1004),(1123,2,9,1005),(1104,2,9,1421),(1105,2,9,2401),(1106,2,9,2402),(1107,2,9,2403),(1108,2,9,2411),(1109,2,9,2412),(1110,2,9,2413),(1111,2,9,2414),(1141,2,9,5011),(1144,2,9,5021),(1145,2,9,5022),(1135,2,9,56001),(1136,2,9,56002),(1137,2,9,56003),(1138,2,9,56004),(1126,2,9,941601),(1127,2,9,941602),(1128,2,9,941603),(1129,2,9,941604),(1130,2,9,941605),(1148,2,9,50000001),(1149,2,9,125042001),(1283,2,16,11),(1284,2,16,12),(1285,2,16,13),(1286,2,16,14),(1287,2,16,15),(1288,2,16,16),(1289,2,16,19),(1290,2,16,21),(1291,2,16,22),(1292,2,16,24),(1293,2,16,25),(1294,2,16,26),(1295,2,16,27),(1296,2,16,28),(1297,2,16,31),(1298,2,16,32),(1299,2,16,34),(1300,2,16,38),(1301,2,16,39),(1302,2,16,81),(1303,2,16,82),(1304,2,16,84),(1305,2,16,86),(1306,2,16,87),(1307,2,16,88),(1308,2,16,89),(1309,2,16,91),(1310,2,16,92),(1311,2,16,93),(1312,2,16,94),(1313,2,16,111),(1314,2,16,112),(1315,2,16,113),(1316,2,16,114),(1317,2,16,115),(1318,2,16,116),(1319,2,16,117),(1320,2,16,121),(1321,2,16,122),(1322,2,16,125),(1323,2,16,126),(1324,2,16,241),(1325,2,16,242),(1326,2,16,243),(1327,2,16,251),(1328,2,16,252),(1329,2,16,253),(1330,2,16,254),(1331,2,16,255),(1332,2,16,256),(1333,2,16,262),(1334,2,16,281),(1335,2,16,282),(1336,2,16,283),(1337,2,16,286),(1338,2,16,331),(1339,2,16,332),(1340,2,16,333),(1341,2,16,341),(1342,2,16,342),(1343,2,16,343),(1344,2,16,344),(1345,2,16,351),(1346,2,16,352),(1347,2,16,353),(1348,2,16,354),(1349,2,16,358),(1350,2,16,511),(1351,2,16,512),(1352,2,16,514),(1353,2,16,517),(1354,2,16,519),(1355,2,16,531),(1356,2,16,532),(1357,2,16,534),(1358,2,16,538),(1359,2,16,1001),(1360,2,16,1002),(1361,2,16,1003),(1362,2,16,1004),(1363,2,16,1005),(1364,2,16,1011),(1365,2,16,1012),(1366,2,16,1181),(1367,2,16,1182),(1368,2,16,1183),(1369,2,16,1184),(1370,2,16,1185),(1371,2,16,1186),(1372,2,16,1187),(1373,2,16,1188),(1374,2,16,1189),(1375,2,16,1191),(1376,2,16,1231),(1377,2,16,1232),(1378,2,16,1233),(1379,2,16,1234),(1380,2,16,1235),(1381,2,16,1236),(1382,2,16,1251),(1383,2,16,1321),(1384,2,16,1322),(1385,2,16,1421),(1386,2,16,2401),(1387,2,16,2402),(1388,2,16,2403),(1389,2,16,2411),(1390,2,16,2412),(1391,2,16,2413),(1392,2,16,2414),(1393,2,16,5001),(1394,2,16,5002),(1395,2,16,5003),(1396,2,16,5011),(1397,2,16,5012),(1398,2,16,5013),(1399,2,16,5021),(1400,2,16,5022),(1401,2,16,5023),(1402,2,16,5031),(1403,2,16,5032),(1404,2,16,5033),(1405,2,16,5041),(1406,2,16,5042),(1407,2,16,5043),(1408,2,16,5044),(1409,2,16,5045),(1410,2,16,5046),(1411,2,16,5051),(1412,2,16,5052),(1413,2,16,5054),(1414,2,16,5056),(1415,2,16,5057),(1416,2,16,5058),(1417,2,16,5059),(1418,2,16,5061),(1419,2,16,5062),(1420,2,16,5063),(1421,2,16,5064),(1422,2,16,5065),(1423,2,16,5066),(1424,2,16,5067),(1425,2,16,5069),(1426,2,16,23001),(1427,2,16,23002),(1428,2,16,23003),(1429,2,16,23004),(1430,2,16,50401),(1431,2,16,50411),(1432,2,16,50412),(1433,2,16,50414),(1434,2,16,50415),(1435,2,16,50418),(1436,2,16,50420),(1437,2,16,50430),(1438,2,16,50440),(1439,2,16,56001),(1440,2,16,56002),(1441,2,16,56003),(1442,2,16,56004),(1443,2,16,432511),(1444,2,16,432512),(1445,2,16,432513),(1446,2,16,941601),(1447,2,16,941602),(1448,2,16,941603),(1449,2,16,941604),(1450,2,16,941605),(1451,2,16,941606),(1452,2,16,50000001),(1453,2,16,50000002),(1454,2,16,50000003),(1455,2,16,125042001),(1456,2,16,858369821),(336,3,2,11),(337,3,2,12),(338,3,2,13),(339,3,2,14),(340,3,2,15),(341,3,2,16),(342,3,2,19),(343,3,2,21),(344,3,2,22),(345,3,2,24),(346,3,2,25),(347,3,2,26),(348,3,2,27),(349,3,2,28),(350,3,2,31),(351,3,2,32),(352,3,2,34),(353,3,2,38),(354,3,2,39),(355,3,2,81),(356,3,2,82),(357,3,2,84),(358,3,2,86),(359,3,2,87),(360,3,2,88),(361,3,2,89),(362,3,2,91),(363,3,2,92),(364,3,2,93),(365,3,2,94),(366,3,2,111),(367,3,2,112),(368,3,2,113),(369,3,2,114),(370,3,2,115),(371,3,2,116),(372,3,2,117),(373,3,2,121),(374,3,2,122),(375,3,2,125),(376,3,2,126),(377,3,2,241),(378,3,2,242),(379,3,2,243),(380,3,2,251),(381,3,2,252),(382,3,2,253),(383,3,2,254),(384,3,2,255),(385,3,2,256),(386,3,2,262),(387,3,2,281),(388,3,2,282),(389,3,2,283),(390,3,2,286),(391,3,2,331),(392,3,2,332),(393,3,2,333),(394,3,2,341),(395,3,2,342),(396,3,2,343),(397,3,2,344),(398,3,2,351),(399,3,2,352),(400,3,2,353),(401,3,2,354),(402,3,2,358),(403,3,2,531),(404,3,2,532),(405,3,2,534),(406,3,2,538),(407,3,2,1181),(408,3,2,1182),(409,3,2,1183),(410,3,2,1184),(411,3,2,1185),(412,3,2,1186),(413,3,2,1187),(414,3,2,1188),(415,3,2,1189),(416,3,2,1191),(417,3,2,1231),(418,3,2,1232),(419,3,2,1233),(420,3,2,1234),(421,3,2,1235),(422,3,2,1236),(423,3,2,1321),(424,3,2,1322),(425,3,2,1421),(426,3,2,2401),(427,3,2,2402),(428,3,2,2403),(429,3,2,2411),(430,3,2,2412),(431,3,2,2413),(432,3,2,2414),(433,3,2,5001),(434,3,2,5002),(435,3,2,5003),(436,3,2,5011),(437,3,2,5012),(438,3,2,5013),(439,3,2,5021),(440,3,2,5022),(441,3,2,5023),(442,3,2,5031),(443,3,2,5032),(444,3,2,5033),(445,3,2,5041),(446,3,2,5042),(447,3,2,5043),(448,3,2,5044),(449,3,2,5045),(450,3,2,5046),(451,3,2,5051),(452,3,2,5052),(453,3,2,5054),(454,3,2,5056),(455,3,2,5057),(456,3,2,5058),(457,3,2,5059),(458,3,2,5061),(459,3,2,5062),(460,3,2,5063),(461,3,2,5064),(462,3,2,5065),(463,3,2,5066),(464,3,2,5067),(465,3,2,5069),(466,3,2,50401),(467,3,2,50411),(468,3,2,50412),(469,3,2,50414),(470,3,2,50415),(471,3,2,50418),(472,3,2,50420),(473,3,2,50430),(474,3,2,50440),(475,3,2,59001),(476,3,2,59002),(477,3,2,59003),(478,3,2,941601),(479,3,2,941602),(480,3,2,941603),(481,3,2,941604),(482,3,2,941605),(483,3,2,941606),(484,3,2,858369821),(485,3,3,11),(486,3,3,12),(487,3,3,13),(488,3,3,14),(489,3,3,15),(490,3,3,16),(491,3,3,19),(492,3,3,21),(493,3,3,22),(494,3,3,24),(495,3,3,25),(496,3,3,26),(497,3,3,27),(498,3,3,28),(499,3,3,31),(500,3,3,32),(501,3,3,34),(502,3,3,38),(503,3,3,39),(504,3,3,81),(505,3,3,82),(506,3,3,84),(507,3,3,86),(508,3,3,87),(509,3,3,88),(510,3,3,89),(511,3,3,91),(512,3,3,92),(513,3,3,93),(514,3,3,94),(515,3,3,111),(516,3,3,112),(517,3,3,113),(518,3,3,114),(519,3,3,115),(520,3,3,116),(521,3,3,117),(522,3,3,121),(523,3,3,122),(524,3,3,125),(525,3,3,126),(526,3,3,241),(527,3,3,242),(528,3,3,243),(529,3,3,251),(530,3,3,252),(531,3,3,253),(532,3,3,254),(533,3,3,255),(534,3,3,256),(535,3,3,262),(536,3,3,281),(537,3,3,282),(538,3,3,283),(539,3,3,286),(540,3,3,331),(541,3,3,332),(542,3,3,333),(543,3,3,341),(544,3,3,342),(545,3,3,343),(546,3,3,344),(547,3,3,351),(548,3,3,352),(549,3,3,353),(550,3,3,354),(551,3,3,358),(552,3,3,531),(553,3,3,532),(554,3,3,534),(555,3,3,538),(556,3,3,1181),(557,3,3,1182),(558,3,3,1183),(559,3,3,1184),(560,3,3,1185),(561,3,3,1186),(562,3,3,1187),(563,3,3,1188),(564,3,3,1189),(565,3,3,1191),(566,3,3,1231),(567,3,3,1232),(568,3,3,1233),(569,3,3,1234),(570,3,3,1235),(571,3,3,1236),(572,3,3,1321),(573,3,3,1322),(574,3,3,1421),(575,3,3,2401),(576,3,3,2402),(577,3,3,2403),(578,3,3,2411),(579,3,3,2412),(580,3,3,2413),(581,3,3,2414),(582,3,3,5001),(583,3,3,5002),(584,3,3,5003),(585,3,3,5011),(586,3,3,5012),(587,3,3,5013),(588,3,3,5021),(589,3,3,5022),(590,3,3,5023),(591,3,3,5031),(592,3,3,5032),(593,3,3,5033),(594,3,3,5041),(595,3,3,5042),(596,3,3,5043),(597,3,3,5044),(598,3,3,5045),(599,3,3,5046),(600,3,3,5051),(601,3,3,5052),(602,3,3,5054),(603,3,3,5056),(604,3,3,5057),(605,3,3,5058),(606,3,3,5059),(607,3,3,5061),(608,3,3,5062),(609,3,3,5063),(610,3,3,5064),(611,3,3,5065),(612,3,3,5066),(613,3,3,5067),(614,3,3,5069),(615,3,3,50401),(616,3,3,50411),(617,3,3,50412),(618,3,3,50414),(619,3,3,50415),(620,3,3,50418),(621,3,3,50420),(622,3,3,50430),(623,3,3,50440),(624,3,3,59001),(625,3,3,59002),(626,3,3,59003),(627,3,3,941601),(628,3,3,941602),(629,3,3,941603),(630,3,3,941604),(631,3,3,941605),(632,3,3,941606),(633,3,3,858369821),(1614,3,5,11),(1612,3,5,21),(1622,3,5,31),(1613,3,5,81),(1629,3,5,91),(1630,3,5,111),(1610,3,5,121),(1611,3,5,122),(1626,3,5,161),(1623,3,5,241),(1624,3,5,242),(1605,3,5,251),(1607,3,5,262),(1608,3,5,281),(1609,3,5,282),(1627,3,5,331),(1628,3,5,332),(1606,3,5,342),(1625,3,5,531),(1615,3,5,1181),(1616,3,5,1182),(1617,3,5,1231),(1620,3,5,2401),(1621,3,5,2402),(1619,3,5,2411),(1618,3,5,2412),(1633,3,5,5051),(1632,3,5,50420),(1631,3,5,56001),(1604,3,5,50000001);

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

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

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

INSERT INTO `llx_usergroup_user` (`rowid`, `entity`, `fk_user`, `fk_usergroup`) VALUES (9,1,1,2),(6,1,8,2),(18,1,10,6),(13,1,11,4),(19,1,13,7),(10,2,1,2),(33,2,3,16),(34,2,4,16),(35,2,5,16),(32,2,6,16),(36,2,7,16),(7,2,8,2),(14,2,11,4),(16,2,12,5),(20,2,14,8),(21,2,15,9),(37,2,16,16),(38,2,17,8),(39,2,18,8),(11,3,1,2),(8,3,8,2),(12,3,9,3),(15,3,11,4),(17,3,12,5);

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

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

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


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

CREATE TABLE `llx_website_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_website_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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


--
-- Table structure for table `llx_workstation_workstation`
--

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

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


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

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

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


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

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

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


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

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

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



