--
-- Host: localhost    Database: pragmatech
-- ------------------------------------------------------


--
-- Table structure for table `dpt_user`
--

CREATE TABLE `dpt_user` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT 1,
  `ref_employee` varchar(50) DEFAULT NULL,
  `ref_ext` varchar(50) DEFAULT NULL,
  `employee` tinyint(4) DEFAULT 1,
  `fk_establishment` int(11) DEFAULT 0,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `login` varchar(50) NOT NULL,
  `pass_encoding` varchar(24) DEFAULT NULL,
  `pass` varchar(128) DEFAULT NULL,
  `pass_crypted` varchar(128) DEFAULT NULL,
  `pass_temp` varchar(128) DEFAULT NULL,
  `api_key` varchar(128) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `civility` varchar(6) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(25) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `fk_state` int(11) DEFAULT 0,
  `fk_country` int(11) DEFAULT 0,
  `birth` date DEFAULT NULL,
  `job` varchar(128) DEFAULT NULL,
  `office_phone` varchar(20) DEFAULT NULL,
  `office_fax` varchar(20) DEFAULT NULL,
  `user_mobile` varchar(20) DEFAULT NULL,
  `personal_mobile` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `personal_email` varchar(255) DEFAULT NULL,
  `socialnetworks` text DEFAULT NULL,
  `signature` text DEFAULT NULL,
  `admin` smallint(6) DEFAULT 0,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_socpeople` int(11) DEFAULT NULL,
  `fk_member` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `fk_user_expense_validator` int(11) DEFAULT NULL,
  `fk_user_holiday_validator` int(11) DEFAULT NULL,
  `note_public` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `datelastlogin` datetime DEFAULT NULL,
  `datepreviouslogin` datetime DEFAULT NULL,
  `egroupware_id` int(11) DEFAULT NULL,
  `ldap_sid` varchar(255) DEFAULT NULL,
  `openid` varchar(255) DEFAULT NULL,
  `statut` tinyint(4) DEFAULT 1,
  `photo` varchar(255) DEFAULT NULL,
  `lang` varchar(6) DEFAULT NULL,
  `color` varchar(6) DEFAULT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT 0,
  `accountancy_code` varchar(32) DEFAULT NULL,
  `nb_holiday` int(11) DEFAULT 0,
  `thm` double(24,8) DEFAULT NULL,
  `tjm` double(24,8) DEFAULT NULL,
  `salary` double(24,8) DEFAULT NULL,
  `salaryextra` double(24,8) DEFAULT NULL,
  `dateemployment` date DEFAULT NULL,
  `weeklyhours` double(16,8) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `default_range` int(11) DEFAULT NULL,
  `default_c_exp_tax_cat` int(11) DEFAULT NULL,
  `dateemploymentend` date DEFAULT NULL,
  `fk_warehouse` int(11) DEFAULT NULL,
  `iplastlogin` varchar(250) DEFAULT NULL,
  `ippreviouslogin` varchar(250) DEFAULT NULL,
  `datelastpassvalidation` datetime DEFAULT NULL,
  `datestartvalidity` datetime DEFAULT NULL,
  `dateendvalidity` datetime DEFAULT NULL,
  `idpers1` varchar(128) DEFAULT NULL,
  `idpers2` varchar(128) DEFAULT NULL,
  `idpers3` varchar(128) DEFAULT NULL,
  `national_registration_number` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_login` (`login`,`entity`),
  UNIQUE KEY `uk_user_fk_socpeople` (`fk_socpeople`),
  UNIQUE KEY `uk_user_fk_member` (`fk_member`),
  UNIQUE KEY `uk_user_api_key` (`api_key`),
  KEY `idx_user_fk_societe` (`fk_soc`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dpt_user`
--

INSERT INTO `dpt_user` VALUES (1,0,'',NULL,1,0,'2018-05-07 12:04:21','2023-04-28 12:59:08',NULL,NULL,'SuperAdmin',NULL,NULL,'f8610ec589daebd50b177b9c6e268e8def086162',NULL,'JRHwhO475aLJLb94Q4hyk2U1By0cta3L','man','','Barrouillet','Nicolas','7 rue Larrouy','64140','LONS',71,1,'1977-08-30','Gérant','','','','','nicolas@pragma-tech.fr','','[]','Nicolas Barrouillet<br />\r\n06.82.95.20.81<br />\r\n05.59.62.04.88<br />\r\n7 rue Larrouy 64140 LONS<br />\r\n<img alt=\"\" src=\"/viewimage.php?modulepart=medias&amp;entity=1&amp;file=image/color_logo_with_background.png\" style=\"height:75px; width:250px\" /><br />\r\n&nbsp;',1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2023-09-18 21:04:59','2023-09-18 10:23:09',NULL,'',NULL,1,'logo only.png',NULL,'56aaff',NULL,0,'455',0,35.00000000,175.00000000,NULL,NULL,'2018-01-18',NULL,NULL,NULL,NULL,NULL,NULL,'109.31.18.98','212.114.20.191',NULL,NULL,NULL,NULL,NULL,NULL,''),(2,0,'',NULL,1,0,'2018-05-07 12:19:14','2023-07-27 15:00:54',NULL,NULL,'LAUDEBAT',NULL,NULL,'29f03413b87820f19fe403563058cd6cc775f315',NULL,'qh3zyd6b','woman','MME','LAUDEBAT','Stéphanie','5 rue de las Bartouilles','64110','Gelos',71,1,'1977-09-22','','','','','','stephanie@pragma-tech.fr','','[]','<br />\r\n<br />\r\nSinc&egrave;res salutations<br />\r\nSt&eacute;phanie Laudebat<br />\r\nResponsable administrative et comptable<br />\r\n0607372486<br />\r\n<img alt=\"\" src=\"/viewimage.php?modulepart=medias&amp;entity=1&amp;file=image/color_logo_with_background.png\" style=\"height:75px; width:250px\" /><br />\r\n&nbsp;',1,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2023-09-18 09:13:32','2023-09-15 21:00:49',NULL,'',NULL,1,'unnamed.jpeg',NULL,'7f00ff',NULL,0,'421',0,35.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'212.114.20.191','109.31.18.98',NULL,NULL,NULL,NULL,NULL,NULL,''),(3,1,'',NULL,1,0,'2023-01-06 15:42:13','2023-08-09 08:27:30',NULL,NULL,'a.avaullée',NULL,NULL,'452e59cf756aeef274f8a6a59f94a8590563840c',NULL,'AcrKTOH4AqTu','man','MR','AVAULLÉE','Arnaud','','','',NULL,NULL,'2001-04-03','ALTERNANT','','','','','arnaud@pragma-tech.fr','','[]','',0,NULL,NULL,NULL,1,NULL,NULL,'','',NULL,'2023-09-12 09:44:14','2023-09-11 17:12:15',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'421',0,35.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'212.114.25.129','212.114.25.129',NULL,NULL,NULL,NULL,NULL,NULL,''),(4,1,'',NULL,1,0,'2023-07-03 09:16:29','2023-08-09 08:27:46',NULL,NULL,'m.barrouillet',NULL,NULL,'8596308390bb3207d769d4f32d7089a3682884ba',NULL,NULL,'woman','','Barrouillet','Margaux','','','',NULL,NULL,NULL,'','','','','','margaux.barrouillet@laposte.net','','[]','',0,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,'2023-08-31 14:41:53','2023-08-31 13:23:24',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,35.00000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'212.114.25.129','212.114.25.129',NULL,NULL,NULL,NULL,NULL,NULL,'');


