--
-- Host: localhost    Database: vw
-- ------------------------------------------------------


--
-- Sequence structure for `maintain_seq`
--

DROP SEQUENCE IF EXISTS `maintain_seq`;
CREATE SEQUENCE `maintain_seq` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 cache 1000 nocycle ENGINE=InnoDB;
SELECT SETVAL(`maintain_seq`, 3001, 0);

--
-- Sequence structure for `seq_company`
--

DROP SEQUENCE IF EXISTS `seq_company`;
CREATE SEQUENCE `seq_company` start with 2 minvalue 1 maxvalue 9223372036854775806 increment by 1 cache 1000 nocycle ENGINE=InnoDB;
SELECT SETVAL(`seq_company`, 1002, 0);

--
-- Sequence structure for `seq_uda`
--

DROP SEQUENCE IF EXISTS `seq_uda`;
CREATE SEQUENCE `seq_uda` start with 3 minvalue 1 maxvalue 9223372036854775806 increment by 1 cache 1000 nocycle ENGINE=InnoDB;
SELECT SETVAL(`seq_uda`, 1003, 0);

--
-- Table structure for table `application`
--

CREATE TABLE `application` (
  `app_id` int(11) NOT NULL,
  `app_name` varchar(50) NOT NULL,
  `app_url` varchar(255) NOT NULL,
  `app_comment` text DEFAULT NULL,
  `app_disabled` char(1) NOT NULL DEFAULT '0',
  `app_ulogin` varchar(100) NOT NULL,
  `app_udate` timestamp NOT NULL DEFAULT current_timestamp(),
  `app_label` varchar(255) NOT NULL,
  `app_autoload` char(1) NOT NULL DEFAULT '0',
  `app_uuid` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`app_id`),
  UNIQUE KEY `app_name` (`app_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `application`
--

INSERT INTO `application` VALUES (1,'vw','vw.kipki.be',NULL,'0','admin','2020-04-23 18:00:00','VW','0',NULL);

--
-- Table structure for table `choice`
--

CREATE TABLE `choice` (
  `ch_field` varchar(50) NOT NULL,
  `ch_code` varchar(50) NOT NULL,
  `ch_seq` varchar(50) DEFAULT NULL,
  `ch_label` varchar(250) NOT NULL,
  `ch_display` mediumtext DEFAULT 1,
  PRIMARY KEY (`ch_field`,`ch_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `choice`
--

INSERT INTO `choice` VALUES ('gender','female','10','Female','1'),('gender','male','20','Male','1'),('vehicle','t3','10','T3','1');

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `comp_id` int(11) NOT NULL,
  `comp_name` varchar(100) NOT NULL,
  `comp_description` text DEFAULT NULL,
  `comp_udate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `comp_uid` varchar(50) NOT NULL,
  PRIMARY KEY (`comp_id`),
  KEY `comp_uid` (`comp_uid`),
  CONSTRAINT `company_ibfk_1` FOREIGN KEY (`comp_uid`) REFERENCES `users` (`u_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `company`
--

INSERT INTO `company` VALUES (1,'kipki',NULL,'2024-03-03 07:52:10','025cdf406fb91c5db45d228f1fe1aa2f'),(2,'Lete','','2024-03-04 23:00:00','025cdf406fb91c5db45d228f1fe1aa2f');

--
-- Table structure for table `email`
--

CREATE TABLE `email` (
  `email_id` varchar(50) NOT NULL,
  `email_description` varchar(255) DEFAULT NULL,
  `email_body` text NOT NULL,
  `email_subject` varchar(255) NOT NULL,
  `email_to` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email`
--

INSERT INTO `email` VALUES ('lost_password','Sent to the client when lost password link is clicked','<p> </p>\r\n<div style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #ffffff; width: 100.09%; height: 1062px; padding-bottom: 20px; background-color: #ffffff;\" align=\"center\">\r\n<table class=\"w600\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; margin: auto; background-color: #ffffff;\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\r\n<tbody>\r\n<tr>\r\n<td class=\"w30\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #ffffff;\" width=\"30\"> </td>\r\n<td class=\"w540\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: left; line-height: 0px; background-color: #ffffff;\" width=\"540\"><img src=\"https://my.hello-hostel.eu/images/mail/logo_hh.png\" border=\"0\" alt=\"\" width=\"100\" />       </td>\r\n<td class=\"w30\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; background-color: #ffffff;\" width=\"30\" height=\"122\"> </td>\r\n</tr>\r\n<tr>\r\n<td class=\"w30\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #ffffff; background-color: #b9cf00;\" width=\"30\"> </td>\r\n<td class=\"w540\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #ffffff; text-align: center; background-color: #b9cf00;\" width=\"540\" height=\"25\"> </td>\r\n<td class=\"w30\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #ffffff; text-align: center; background-color: #b9cf00;\" width=\"60\"> </td>\r\n</tr>\r\n<tr>\r\n<td class=\"w600\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: center; background-color: #ffffff;\" colspan=\"3\" width=\"600\" height=\"25\"> </td>\r\n</tr>\r\n<tr>\r\n<td class=\"w30\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: center; background-color: #ffffff;\" width=\"30\"> </td>\r\n<td class=\"w540\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: justify; background-color: #ffffff;\" width=\"540\">\r\n	<br /> \r\n	<span style=\"font-family: arial,helvetica,sans-serif;\">\r\n		<span style=\"font-family: arial,helvetica,sans-serif;\">\r\n			<span style=\"font-size: 14px;\">\r\n				Hello,<br />\r\n				<br />\r\n				You have requested a password reset for your myVOO account.<br />\r\n				<br />\r\n				If you made this request, click on the button below to create your new password. Otherwise, please ignore this email.<br />\r\n			</span><br /><br />\r\n			<div style=\'width:100%; text-align:center;\'>\r\n			<a href=\"%link%\" style=\'display: block; width: 200px; height: 25px; background: #4E9CAF; padding: 10px; text-align: center; text-decoration: none; cursor: pointer; font-size:16px; border-radius: 5px; color: white; line-height: 25px;\'>I reset my password</a></div>\r\n			<span style=\"font-family: arial,helvetica,sans-serif;\">\r\n				<span style=\"font-size: 14px;\">\r\n					<br /> <br /> \r\n					We look forward to seeing you soon,<br />\r\n					Customer Service <br /><br /> \r\n					BRUSSELS HELLO HOSTEL TEAM<br /> \r\n					All information on: <a href=\"http://www.hello-hostel.eu\">www.hello-hostel.eu</a><br /> \r\n					Mail : <a href=\"mailto:hhbook@hello-hostel.eu\">hhbook@hello-hostel.eu</a><br /> \r\n					SMS and WhatsApp : +32 471 93 59 27<br /> \r\n					Central Phone + 32 2 318 11 11<br /> \r\n				</span> \r\n			</span> \r\n			<br />  \r\n		</span>\r\n	</span>\r\n<div style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: left;\"> </div>\r\n<div style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: right;\"><strong><em> </em></strong></div>\r\n<h2 style=\"color: #b9cf00 !important; font-size: 14px; font-weight: bold; margin-top: 20px; border-bottom: 1px solid #d6d6d6; padding-bottom: 4px; text-align: center;\"><a href=\"http://www.hello-hostel.eu\" target=\"_blank\" rel=\"noopener\"> Visit our website ! </a></h2>\r\n<div style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: center;\"> </div>\r\n<div style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: center;\">Brussels Helo-Hostel asbl <br />  </div>\r\n</td>\r\n<td class=\"w30\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: center; background-color: #ffffff;\" width=\"30\"> </td>\r\n</tr>\r\n<tr style=\"line-height: 0px;\">\r\n<td class=\"w600\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: center; line-height: 0px; background-color: #efefef;\" colspan=\"3\" valign=\"top\" width=\"600\"> </td>\r\n</tr>\r\n<tr style=\"line-height: 0px;\">\r\n<td class=\"w600\" style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #575757; text-align: center; line-height: 0px; background-color: #efefef;\" colspan=\"3\" valign=\"top\" width=\"600\"><img src=\"https://my.hello-hostel.eu/images/mail/end_mail.png\" border=\"0\" alt=\"--\" width=\"600\" height=\"24\" /></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>','VW - Password recovery process',NULL);

--
-- Table structure for table `fuseaction`
--

CREATE TABLE `fuseaction` (
  `app_name` varchar(50) NOT NULL DEFAULT 'vw',
  `fuse_id` int(11) NOT NULL,
  `fuse_label` varchar(50) NOT NULL,
  `fuse_description` mediumtext DEFAULT NULL,
  `fuse_pagetitle` varchar(255) NOT NULL DEFAULT 'Hello-hostel',
  `fuse_pageicon` varchar(255) NOT NULL DEFAULT 'hello-hostel.ico',
  PRIMARY KEY (`app_name`,`fuse_id`),
  KEY `fuse_id` (`fuse_id`),
  CONSTRAINT `fuseaction_ibfk_1` FOREIGN KEY (`app_name`) REFERENCES `application` (`app_name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fuseaction`
--

INSERT INTO `fuseaction` VALUES ('vw',0,'home.*','','VW','vw.ico'),('vw',1,'logout.*','','VW','vw.ico'),('vw',2,'login.*','','VW','vw.ico'),('vw',3,'home.dsp_page',NULL,'VW - Main','vw.ico'),('vw',4,'maintain.*',NULL,'VW - Maintain','vw.ico'),('vw',5,'view_administration_menu',NULL,'',''),('vw',6,'company.*',NULL,'Company','vw.ico'),('vw',7,'form_users.*',NULL,'VW','vw.ico'),('vw',8,'form_users.otherapp_manager',NULL,'','vw.ico'),('vw',9,'def_fa.*',NULL,'','vw.ico'),('vw',10,'applicaiotn.get_fuse_list',NULL,'','');

--
-- Table structure for table `fuseaction_groupe`
--

CREATE TABLE `fuseaction_groupe` (
  `app_name` varchar(50) NOT NULL DEFAULT 'vw',
  `g_id` int(11) NOT NULL,
  `fuse_id` int(11) NOT NULL,
  PRIMARY KEY (`app_name`,`g_id`,`fuse_id`),
  KEY `g_id` (`g_id`),
  KEY `app_name` (`app_name`,`fuse_id`),
  CONSTRAINT `fuseaction_groupe_ibfk_1` FOREIGN KEY (`app_name`, `g_id`) REFERENCES `groupe` (`app_name`, `g_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fuseaction_groupe_ibfk_2` FOREIGN KEY (`app_name`, `fuse_id`) REFERENCES `fuseaction` (`app_name`, `fuse_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fuseaction_groupe`
--

INSERT INTO `fuseaction_groupe` VALUES ('vw',0,2),('vw',0,3),('vw',1,0),('vw',1,1),('vw',1,4),('vw',1,5),('vw',1,6),('vw',1,7),('vw',1,9),('vw',1,10),('vw',2,4);

--
-- Table structure for table `groupe`
--

CREATE TABLE `groupe` (
  `app_name` varchar(50) NOT NULL DEFAULT 'vw',
  `g_id` int(11) NOT NULL,
  `g_label` varchar(255) NOT NULL,
  `g_description` mediumtext DEFAULT NULL,
  `g_order` int(11) DEFAULT NULL,
  `g_display` char(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`app_name`,`g_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `groupe`
--

INSERT INTO `groupe` VALUES ('vw',0,'Everyone','No specific access rights ... Just Home and login...	\r\n',NULL,'1'),('vw',1,'administrator','Access to all functionalities	\r\n',NULL,'1'),('vw',2,'User',NULL,30,'1');

--
-- Table structure for table `help`
--

CREATE TABLE `help` (
  `h_page` varchar(50) NOT NULL,
  `h_text` text DEFAULT NULL,
  `h_ulogin` varchar(100) NOT NULL,
  `h_udate` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `help`
--


--
-- Table structure for table `log_sql`
--

CREATE TABLE `log_sql` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `log_description` mediumtext DEFAULT NULL,
  `log_action` varchar(50) DEFAULT NULL,
  `log_comment` mediumtext DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `log_sql`
--

INSERT INTO `log_sql` VALUES (1,'2024-02-27 15:53:10','update vw.maintain set m_id= 9,m_date= date(\'2024-02-26\'),m_kms= 111333,m_description= \'sssddd\',m_comment= \'xxxfff\',m_udate= date(\'2024-02-27\'),m_uid= \'025cdf406fb91c5db45d228f1fe1aa2f\'  where 1=1 and m_id=\'9\'','update',''),(2,'2024-02-28 11:47:16','update vw.maintain set m_id= 20,m_vehicle_field= \'vehicle\',m_vehicle_code= \'t3\',m_date= date(\'2024-02-06\'),m_kms= 32300,m_description= \'Nouvel alternateur  courroie accessoire\',m_comment= \'Commandé chez Van quality part (https://van-quality-parts.fr/)\',m_udate= date(\'2024-02-28\'),m_uid= \'025cdf406fb91c5db45d228f1fe1aa2f\'  where 1=1 and m_id=\'20\'','update',''),(3,'2024-02-28 12:03:15','update vw.maintain set m_id= 20,m_vehicle_field= \'vehicle\',m_vehicle_code= \'t3\',m_date= date(\'2024-02-06\'),m_kms= 32300,m_description= \'- Nouvel alternateur\\n- courroie accessoire\',m_comment= \'Commandé chez Van quality part (https://van-quality-parts.fr/)\',m_udate= date(\'2024-02-28\'),m_uid= \'025cdf406fb91c5db45d228f1fe1aa2f\'  where 1=1 and m_id=\'20\'','update',''),(4,'2024-02-28 12:03:36','update vw.maintain set m_id= 12,m_vehicle_field= \'vehicle\',m_vehicle_code= \'t3\',m_date= date(\'2023-06-06\'),m_kms= 25742,m_description= \'- Vidange huile 10w40 6.5l\\n- Filtre huile\\n- Filtre mazout\\n- Filtre air\',m_comment= \'\',m_udate= date(\'2024-02-28\'),m_uid= \'025cdf406fb91c5db45d228f1fe1aa2f\'  where 1=1 and m_id=\'12\'','update',''),(5,'2024-02-28 12:04:00','update vw.maintain set m_id= 19,m_vehicle_field= \'vehicle\',m_vehicle_code= \'t3\',m_date= date(\'2024-02-08\'),m_kms= 32356,m_description= \'courroie de distribution\',m_comment= \'Hans\',m_udate= date(\'2024-02-28\'),m_uid= \'025cdf406fb91c5db45d228f1fe1aa2f\'  where 1=1 and m_id=\'19\'','update',''),(6,'2024-02-28 16:52:32','update users set u_lostpwd= \'65df64d0be6aa--65df64d0be6b7\'  where u_email=\'stephane.geerts@gmail.com\'','update','1054'),(7,'2024-02-28 16:57:44','update users set u_lostpwd= \'65df6608539fe--65df660853a0a\'  where u_email=\'stephane.geerts@gmail.com\'','update','1054'),(8,'2024-02-28 17:01:29','update users set u_lostpwd= \'65df66e9a8f6f--65df66e9a8f7a\'  where u_email=\'stephane.geerts@gmail.com\'','update','1054'),(9,'2024-02-28 17:04:49','update users set u_lostpwd= \'65df67b1e3139--65df67b1e313f\'  where u_email=\'stephane.geerts@gmail.com\'','update','1054'),(10,'2024-02-28 17:04:58','update users set u_lostpwd= \'65df67bae9037--65df67bae9044\'  where u_email=\'stephane.geerts@gmail.com\'','update','1054'),(11,'2024-02-28 17:07:50','update users set u_lostpwd= \'65df686699bdc--65df686699be2\'  where u_email=\'stephane.geerts@gmail.com\'','update','1054'),(12,'2024-02-28 17:10:36','update users set u_lostpwd= \'65df690c7d253--65df690c7d264\'  where u_email=\'stephane.geerts@gmail.com\'','update','1054'),(13,'2024-02-28 17:10:57','update users set u_lostpwd= \'65df692119bcd--65df692119bdb\'  where u_email=\'stephane.geerts@gmail.com\'','update','1054'),(14,'2024-02-28 17:11:42','update users set u_lostpwd= \'65df694eec68c--65df694eec69a\'  where u_email=\'stephane.geerts@gmail.com\'','update','1054'),(15,'2024-02-28 17:12:29','update users set u_lostpwd= \'65df697d1d360--65df697d1d36d\'  where u_email=\'stephane.geerts@gmail.com\'','update','1054'),(16,'2024-02-28 17:20:57','update users set u_lostpwd= \'65df6b79e9929--65df6b79e9937\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(17,'2024-02-28 17:21:50','update users set u_lostpwd= \'65df6bae9bc04--65df6bae9bc0b\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(18,'2024-02-28 17:22:43','update users set u_lostpwd= \'65df6be3a5bf1--65df6be3a5bff\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(19,'2024-02-28 17:24:01','update users set u_lostpwd= \'65df6c3115231--65df6c3115238\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(20,'2024-02-28 17:25:11','update users set u_lostpwd= \'65df6c77247a9--65df6c77247b6\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(21,'2024-02-28 17:26:12','update users set u_lostpwd= \'65df6cb468959--65df6cb468965\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(22,'2024-02-28 17:27:04','update users set u_lostpwd= \'65df6ce89c59a--65df6ce89c5a7\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(23,'2024-02-28 17:31:42','update users set u_lostpwd= \'65df6dfe45e0a--65df6dfe45e16\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(24,'2024-02-28 17:32:02','update users set u_lostpwd= \'65df6e12466fe--65df6e1246708\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(25,'2024-02-28 17:36:30','update users set u_lostpwd= \'65df6f1eaf275--65df6f1eaf282\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(26,'2024-02-29 07:05:52','update users set u_lostpwd= \'65e02cd0e9776--65e02cd0e9782\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(27,'2024-02-29 07:07:47','update users set u_lostpwd= \'65e02d4388970--65e02d438897b\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(28,'2024-02-29 07:10:02','update users set u_lostpwd= \'65e02dca558bf--65e02dca558cd\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(29,'2024-02-29 07:15:02','update users set u_lostpwd= \'65e02ef67e508--65e02ef67e516\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(30,'2024-02-29 07:15:02','update users set u_lostpwd= \'65e02ef685d20--65e02ef685d2c\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(31,'2024-02-29 07:15:02','update users set u_lostpwd= \'65e02ef68a409--65e02ef68a412\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(32,'2024-02-29 07:15:02','update users set u_lostpwd= \'65e02ef68db25--65e02ef68db2d\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(33,'2024-02-29 07:15:02','update users set u_lostpwd= \'65e02ef6919b7--65e02ef6919c0\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(34,'2024-02-29 07:15:11','update users set u_lostpwd= \'65e02efff279e--65e02efff27aa\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(35,'2024-02-29 07:15:39','update users set u_lostpwd= \'65e02f1bd690e--65e02f1bd691a\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(36,'2024-02-29 07:17:50','update users set u_lostpwd= \'65e02f9ed6d82--65e02f9ed6d8e\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(37,'2024-02-29 07:19:01','update users set u_lostpwd= \'65e02fe5015d6--65e02fe5015e4\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(38,'2024-02-29 07:19:51','update users set u_lostpwd= \'\',u_password= \'0e698a8ffc1a0af622c7b4db3cb750cc\'  where u_id=\'025cdf406fb91c5db45d228f1fe1aa2f\'','update',''),(39,'2024-02-29 07:20:19','update users set u_lostpwd= \'65e030330a9ec--65e030330a9f2\'  where u_email=\'stephane.geerts@gmail.com\'','update',''),(40,'2024-02-29 07:20:54','update users set u_lostpwd= \'\',u_password= \'eb0dd2c0772851258c2945f11e44048a\'  where u_id=\'025cdf406fb91c5db45d228f1fe1aa2f\'','update',''),(41,'2024-03-04 08:01:01','update vw.users set u_id= \'025cdf406fb91c5db45d228f1fe1aa2f\',u_login= \'stephane.geerts@gmail.com\',u_gen_code= \'male\',comp_id= \'1\',u_lastname= \'Geerts\',u_firstname= \'Stéphane\',u_email= \'stephane.geerts@gmail.com\',u_ip= \'\'  where 1=1 and u_id=\'025cdf406fb91c5db45d228f1fe1aa2f\'','update',''),(42,'2024-03-04 08:01:24','update vw.users set u_id= \'025cdf406fb91c5db45d228f1fe1aa2f\',u_login= \'stephane.geerts@gmail.com\',u_gen_code= \'male\',comp_id= \'1\',u_lastname= \'Geerts\',u_firstname= \'Stéphane\',u_email= \'stephane.geerts@gmail.com\',u_ip= \'\'  where 1=1 and u_id=\'025cdf406fb91c5db45d228f1fe1aa2f\'','update',''),(43,'2024-03-04 08:08:54','update vw.users set u_id= \'025cdf406fb91c5db45d228f1fe1aa2f\',u_login= \'stephane.geerts@gmail.com\',u_gen_code= \'male\',comp_id= \'1\',u_lastname= \'Geerts\',u_firstname= \'Stéphane\',u_email= \'stephane.geerts@gmail.com\',u_ip= \'\'  where 1=1 and u_id=\'025cdf406fb91c5db45d228f1fe1aa2f\'','update',''),(44,'2024-03-04 08:09:30','update vw.users set u_id= \'025cdf406fb91c5db45d228f1fe1aa2f\',u_login= \'stephane.geerts@gmail.com\',u_gen_code= \'male\',comp_id= \'1\',u_lastname= \'Geerts\',u_firstname= \'Stéphane\',u_email= \'stephane.geerts@gmail.com\',u_ip= \'\'  where 1=1 and u_id=\'025cdf406fb91c5db45d228f1fe1aa2f\'','update',''),(45,'2024-03-04 08:09:56','update vw.users set u_id= \'025cdf406fb91c5db45d228f1fe1aa2f\',u_login= \'stephane.geerts@gmail.com\',u_gen_code= \'male\',comp_id= \'1\',u_lastname= \'Geerts\',u_firstname= \'Stéphane\',u_email= \'stephane.geerts@gmail.com\',u_ip= \'\'  where 1=1 and u_id=\'025cdf406fb91c5db45d228f1fe1aa2f\'','update',''),(46,'2024-03-04 08:10:19','update vw.users set u_id= \'025cdf406fb91c5db45d228f1fe1aa2f\',u_login= \'stephane.geerts@gmail.com\',u_gen_code= \'male\',comp_id= \'1\',u_lastname= \'Geerts\',u_firstname= \'Stéphane\',u_email= \'stephane.geerts@gmail.com\',u_ip= \'\'  where 1=1 and u_id=\'025cdf406fb91c5db45d228f1fe1aa2f\'','update',''),(47,'2024-03-04 08:13:44','update vw.users set u_id= \'473e5983856bda75801e586b41741627\',u_login= \'test&test.te\',u_password= \'b0baee9d279d34fa1dfd71aadb908c3f\',u_gen_code= \'male\',comp_id= \'0\',u_lastname= \'a\',u_firstname= \'q\',u_email= \'\',u_ip= \'\'  where 1=1 and u_id=\'473e5983856bda75801e586b41741627\'','update',''),(48,'2024-03-04 08:13:52','update vw.users set u_id= \'473e5983856bda75801e586b41741627\',u_login= \'test&test.te\',u_gen_code= \'male\',comp_id= \'0\',u_lastname= \'a\',u_firstname= \'q\',u_email= \'\',u_ip= \'\'  where 1=1 and u_id=\'473e5983856bda75801e586b41741627\'','update',''),(49,'2024-03-04 08:18:57','update vw.users set u_id= \'473e5983856bda75801e586b41741627\',u_login= \'test@test.te\',u_gen_code= \'male\',comp_id= \'0\',u_lastname= \'a\',u_firstname= \'q\',u_email= \'\',u_ip= \'\'  where 1=1 and u_id=\'473e5983856bda75801e586b41741627\'','update',''),(50,'2024-06-10 16:04:50','update vw.maintain set m_id= 1005,comp_id= 1,m_vehicle_field= \'vehicle\',m_vehicle_code= \'t3\',m_date= date(\'2024-03-05\'),m_kms= 133208,m_description= \'- Visses collecteurs échappement\\n- vidange huile 10w40 6.5 litres\\n- filtre huile\',m_comment= \'\',m_udate= date(\'2024-06-10\'),m_uid= \'025cdf406fb91c5db45d228f1fe1aa2f\'  where 1=1 and m_id=\'1005\'','update',''),(51,'2024-06-20 17:12:43','update vw.maintain set m_id= 2001,comp_id= 1,m_vehicle_field= \'vehicle\',m_vehicle_code= \'t3\',m_date= date(\'2024-06-10\'),m_kms= 142748,m_description= \'- Vidange huile: 6 litres 10w40\\n- filtre huile\\n- filtre mazout\\n- filtre air\\n- échappement\',m_comment= \'\',m_udate= date(\'2024-06-20\'),m_uid= \'025cdf406fb91c5db45d228f1fe1aa2f\'  where 1=1 and m_id=\'2001\'','update','');

--
-- Table structure for table `maintain`
--

CREATE TABLE `maintain` (
  `m_id` int(11) NOT NULL,
  `m_vehicle_field` varchar(50) NOT NULL DEFAULT 'vehicle',
  `m_vehicle_code` varchar(50) NOT NULL DEFAULT 't3',
  `m_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `m_kms` int(11) NOT NULL,
  `m_description` text NOT NULL,
  `m_comment` text DEFAULT NULL,
  `comp_id` int(11) NOT NULL,
  `m_uid` varchar(50) NOT NULL COMMENT 'user last update',
  `m_udate` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`m_id`),
  KEY `m_uid` (`m_uid`),
  KEY `m_vehicle_field` (`m_vehicle_field`,`m_vehicle_code`),
  KEY `comp_id` (`comp_id`),
  CONSTRAINT `maintain_ibfk_1` FOREIGN KEY (`m_uid`) REFERENCES `users` (`u_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `maintain_ibfk_2` FOREIGN KEY (`m_vehicle_field`, `m_vehicle_code`) REFERENCES `choice` (`ch_field`, `ch_code`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `maintain_ibfk_3` FOREIGN KEY (`comp_id`) REFERENCES `company` (`comp_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `maintain`
--

INSERT INTO `maintain` VALUES (12,'vehicle','t3','2023-06-05 22:00:00',25742,'- Vidange huile 10w40 6.5l\n- Filtre huile\n- Filtre mazout\n- Filtre air','',1,'025cdf406fb91c5db45d228f1fe1aa2f','2024-02-27 23:00:00'),(19,'vehicle','t3','2024-02-07 23:00:00',32356,'courroie de distribution','Hans',1,'025cdf406fb91c5db45d228f1fe1aa2f','2024-02-27 23:00:00'),(20,'vehicle','t3','2024-02-05 23:00:00',32300,'- Nouvel alternateur\n- courroie accessoire','Commandé chez Van quality part (https://van-quality-parts.fr/)',1,'025cdf406fb91c5db45d228f1fe1aa2f','2024-02-27 23:00:00'),(1005,'vehicle','t3','2024-03-04 23:00:00',133208,'- Visses collecteurs échappement\n- vidange huile 10w40 6.5 litres\n- filtre huile','',1,'025cdf406fb91c5db45d228f1fe1aa2f','2024-06-09 22:00:00'),(2001,'vehicle','t3','2024-06-09 22:00:00',142748,'- Vidange huile: 6 litres 10w40\n- filtre huile\n- filtre mazout\n- filtre air\n- échappement','',1,'025cdf406fb91c5db45d228f1fe1aa2f','2024-06-19 22:00:00');

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `menu_id` int(11) NOT NULL,
  `menu_label` varchar(255) NOT NULL,
  `menu_alt` varchar(255) DEFAULT NULL,
  `menu_href` varchar(255) DEFAULT NULL,
  `menu_fuseaction` varchar(255) DEFAULT NULL,
  `menu_condition` mediumtext DEFAULT NULL,
  `menu_order` varchar(10) NOT NULL,
  `menu_target` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` VALUES (1,'Login','Login','index.php?fuseaction=login.dsp_login','login.dsp_login','#(($_SESSION[\"user\"]->getId() != 0 & $_SESSION[\"user\"]->getId() != \"\" && $_SESSION[\"user\"]->getId() != -1)?0:1)#','1',NULL),(2,'Logout','','index.php?fuseaction=logout.act_logout','logout.act_logout','#(($_SESSION[\"user\"]->getId() != 0 & $_SESSION[\"user\"]->getId() != \"\" && $_SESSION[\"user\"]->getId() != -1)?1:0)#','9900',NULL),(3,'Maintain',NULL,'index.php?fuseaction=form.dsp_list&form=maintain','maintain.dsp_list',NULL,'1000',NULL),(5,'Administration',NULL,NULL,'view_administration_menu',NULL,'8000',NULL),(6,'Company',NULL,'index.php?fuseaction=form.dsp_list&form=company','company.dsp_list',NULL,'8010',NULL),(7,'User',NULL,'index.php?fuseaction=form.dsp_list&form=form_users','form_users.dsp_list',NULL,'8020',NULL);

--
-- Table structure for table `parameters`
--

CREATE TABLE `parameters` (
  `param_id` decimal(10,0) NOT NULL,
  `param_page` varchar(50) NOT NULL,
  `param_name` varchar(30) NOT NULL,
  `param_value` varchar(50) NOT NULL,
  `param_comment` varchar(4000) DEFAULT NULL,
  `param_tip` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `parameters`
--


--
-- Table structure for table `sequence_data`
--

CREATE TABLE `sequence_data` (
  `sequence_name` varchar(100) NOT NULL,
  `sequence_increment` int(11) unsigned NOT NULL DEFAULT 1,
  `sequence_min_value` int(11) unsigned NOT NULL DEFAULT 1,
  `sequence_max_value` bigint(20) unsigned NOT NULL DEFAULT 18446744073709551615,
  `sequence_cur_value` bigint(20) unsigned DEFAULT 1,
  `sequence_cycle` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_data`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `u_id` varchar(50) NOT NULL,
  `u_login` varchar(50) NOT NULL,
  `u_password` varchar(50) NOT NULL,
  `u_lastname` varchar(50) NOT NULL,
  `u_firstname` varchar(50) NOT NULL,
  `u_email` varchar(255) DEFAULT NULL,
  `u_gen_code` varchar(50) DEFAULT NULL COMMENT 'choie with ch_field=''gender''',
  `comp_id` int(11) NOT NULL,
  `u_lastlogin` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `u_barcode` varchar(50) DEFAULT NULL,
  `u_disabled` char(1) NOT NULL DEFAULT '0',
  `u_credit` decimal(10,0) NOT NULL DEFAULT 0,
  `u_default_fa` varchar(255) NOT NULL DEFAULT 'ticket.dsp_insert',
  `u_ip` varchar(50) DEFAULT NULL,
  `u_lostpwd` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`u_id`),
  KEY `comp_id` (`comp_id`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`comp_id`) REFERENCES `company` (`comp_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES ('025cdf406fb91c5db45d228f1fe1aa2f','stephane.geerts@gmail.com','eb0dd2c0772851258c2945f11e44048a','Geerts','Stéphane','stephane.geerts@gmail.com','male',1,'2024-03-04 08:01:01','99956','0',10,'form.dsp_list&form=entretien','',''),('7e7a2178090df9b2f3fa51c191d18b43','lete.christian@gmail.com','698d51a19d8a121ce581499d7b701668','Lete','Christian','','male',2,'2024-03-05 16:57:42',NULL,'0',0,'ticket.dsp_insert','',NULL);

--
-- Table structure for table `users_def_fa`
--

CREATE TABLE `users_def_fa` (
  `u_id` varchar(50) NOT NULL,
  `app_name` varchar(50) NOT NULL,
  `fuse_id` int(11) DEFAULT NULL,
  `form_id` varchar(60) DEFAULT NULL,
  `uda_id` int(11) NOT NULL,
  PRIMARY KEY (`uda_id`),
  KEY `u_id` (`u_id`),
  CONSTRAINT `users_def_fa_ibfk_1` FOREIGN KEY (`u_id`) REFERENCES `users` (`u_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_def_fa`
--

INSERT INTO `users_def_fa` VALUES ('025cdf406fb91c5db45d228f1fe1aa2f','vw',NULL,'maintain',1),('7e7a2178090df9b2f3fa51c191d18b43','vw',NULL,'maintain',5);

--
-- Table structure for table `users_groupe`
--

CREATE TABLE `users_groupe` (
  `u_id` varchar(50) NOT NULL,
  `g_id` int(11) NOT NULL,
  PRIMARY KEY (`u_id`,`g_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_groupe`
--

INSERT INTO `users_groupe` VALUES ('',2),('0',2),('025cdf406fb91c5db45d228f1fe1aa2f',1),('0702c34f72fff326197a364641810e2c',2),('473e5983856bda75801e586b41741627',2),('61ce01c76834063a716f11ea195e0ad7',2),('784574a95b49c005ac8370e2da78ffa1',2),('7e7a2178090df9b2f3fa51c191d18b43',2),('e3c69f83794ec807fa770d3824bb092c',2),('ea4db4a768545a03e623f849a69c4b7d',2);

--
-- Table structure for table `word`
--

CREATE TABLE `word` (
  `w_id` varchar(50) NOT NULL,
  `w_label_fr` mediumtext NOT NULL,
  `w_label_en` mediumtext DEFAULT NULL,
  `w_label_es` mediumtext DEFAULT NULL,
  PRIMARY KEY (`w_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `word`
--

INSERT INTO `word` VALUES ('accessright','Droit d\'accès','Access rights',NULL),('add_email','Insérer un Email','Add an Email',NULL),('administration','Administration','Administration',NULL),('amount_greater_that_0','La montant doit être plus grand que  0','Ths amount must be greater than 0',NULL),('bancontact','Bancontact','Bancontact',''),('btn_back','Retour','Back',''),('btn_cancel','Annuler','Cancel',NULL),('btn_close','Fermer','Close',NULL),('btn_delete','Supprimer','Delete',NULL),('btn_edit','Editer','Edit',NULL),('btn_first','Premier','First',NULL),('btn_last','Dernier','Last',NULL),('btn_login','Login','Login',NULL),('btn_next','Suivant','Next',NULL),('choose','Choisir','Choose',NULL),('create_account','Créer un compte','Create account',NULL),('email_address','Adresse e-mail','E-mail address',NULL),('english','English','English','English'),('français','Français','Français',NULL),('inavlid_username_or_password','Nom d\'utilisateur ou mot de passe invalide','Ivaid username or password',NULL),('logged_in','Identifié','Logged in',NULL),('lost_passowrd','Mot de passe oublié ?','Forgot password ?',NULL),('password','Mot de passe','Password',NULL),('progress_label_send','Envoi en cours ...','Send in progress',NULL),('save_success','Enregistré avec succès','Save success',NULL);


