/*
 Navicat Premium Data Transfer

 Source Server         : MAISON
 Source Server Type    : MariaDB
 Source Server Version : 100504
 Source Host           : localhost:3306
 Source Schema         : rofl0364_ridba001

 Target Server Type    : MariaDB
 Target Server Version : 100504
 File Encoding         : 65001

 Date: 20/10/2020 16:43:18
*/


-- ----------------------------
-- Table structure for dg_access_log
-- ----------------------------
CREATE TABLE `dg_access_log`  (
  `id` INT NOT NULL AUTO_INCREMENT COMMENT 'identifiant de ligne',
  `u_name` VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
  `adresse_ip` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
  `action` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT 'intervention utilisateur',
  `debut` VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
  `fin` VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
  `log_out` VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
  `duree` INT GENERATED ALWAYS AS (timestampdiff(SECOND,`debut`,`fin`)) PERSISTENT COMMENT 'durée en secondes (fin-debut)',
  `session_id` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ID session pour séparer les sessions le même jour',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 156817 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Journal des connections des employés qui utilisent Expertresa' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dg_access_log
-- ----------------------------
INSERT INTO `dg_access_log` VALUES (156810, 'fanny', 'CORE_i5-4460', 'LOGIN', '2020-10-19 10:43:49', '2020-10-19 10:43:49', 'NOT LOGGED OUT', DEFAULT, '5f8cfd4a0fd12');
INSERT INTO `dg_access_log` VALUES (156811, 'fanny', 'CORE_i5-4460', 'Calendrier', '2020-10-19 10:43:55', '2020-10-19 10:44:01', 'NOT LOGGED OUT', DEFAULT, '5f8cfd4a0fd12');
INSERT INTO `dg_access_log` VALUES (156812, 'fanny', 'CORE_i5-4460', 'HEB-HEB-ENT', '2020-10-19 10:44:01', '2020-10-19 10:44:04', 'NOT LOGGED OUT', DEFAULT, '5f8cfd4a0fd12');
INSERT INTO `dg_access_log` VALUES (156813, 'fanny', 'CORE_i5-4460', 'TIE-EXT-CLI', '2020-10-19 10:44:04', '2020-10-19 10:44:04', 'NOT LOGGED OUT', DEFAULT, '5f8cfd4a0fd12');
INSERT INTO `dg_access_log` VALUES (156814, 'fanny', 'CORE_i5-4460', 'LOGIN', '2020-10-19 10:44:40', '2020-10-19 10:44:40', 'NOT LOGGED OUT', DEFAULT, '5f8cfd93442ac');
INSERT INTO `dg_access_log` VALUES (156815, 'fanny', 'CORE_i5-4460', 'Calendrier', '2020-10-19 10:44:49', '2020-10-19 10:45:15', 'NOT LOGGED OUT', DEFAULT, '5f8cfd93442ac');
INSERT INTO `dg_access_log` VALUES (156816, 'fanny', 'CORE_i5-4460', 'TIE-EXT-CLI', '2020-10-19 10:45:15', '2020-10-19 10:45:15', 'NOT LOGGED OUT', DEFAULT, '5f8cfd93442ac');

