-- MariaDB dump 10.19  Distrib 10.5.18-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: hive_log
-- ------------------------------------------------------
-- Server version	10.5.18-MariaDB-0+deb11u1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `hive_log`
--

/*!40000 DROP DATABASE IF EXISTS `hive_log`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `hive_log` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `hive_log`;

--
-- Table structure for table `_h_user_connexion`
--

DROP TABLE IF EXISTS `_h_user_connexion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `_h_user_connexion` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `from` char(45) DEFAULT NULL,
  `at` int(10) unsigned DEFAULT NULL,
  `type` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='User: connexion history';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `_h_user_connexion`
--

LOCK TABLES `_h_user_connexion` WRITE;
/*!40000 ALTER TABLE `_h_user_connexion` DISABLE KEYS */;
INSERT INTO `_h_user_connexion` VALUES (1,'bee-smart','167774986',1608509081,2),(2,'bee-smart','167774986',1608509088,2),(3,'bee-smart','167774986',1608509232,1),(4,'bee-smart','2886732032',1608584405,2),(5,'bee-smart','2886732032',1612993833,1),(6,'bee-smart','167774982',1613210638,2),(7,'bee-smart','167774982',1613210650,1),(8,'bee-smart','167775238',1627918467,1),(9,'bee-smart','2886732032',1673015565,1),(10,'bee-smart','2886732032',1673345380,1),(11,'bee-smart','2886732032',1673348085,2),(12,'bee-smart','2886732032',1673348091,1);
/*!40000 ALTER TABLE `_h_user_connexion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_user__connexion_history`
--

DROP TABLE IF EXISTS `log_user__connexion_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_user__connexion_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `usename` varchar(255) DEFAULT NULL,
  `from` int(10) unsigned DEFAULT NULL,
  `type` tinyint(1) unsigned DEFAULT NULL,
  `at` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_user__connexion_history`
--

LOCK TABLES `log_user__connexion_history` WRITE;
/*!40000 ALTER TABLE `log_user__connexion_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_user__connexion_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_user__history`
--

DROP TABLE IF EXISTS `log_user__history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_user__history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `usename` varchar(255) DEFAULT NULL,
  `type` tinyint(1) unsigned DEFAULT NULL,
  `at` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_user__history`
--

LOCK TABLES `log_user__history` WRITE;
/*!40000 ALTER TABLE `log_user__history` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_user__history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_user__password`
--

DROP TABLE IF EXISTS `log_user__password`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_user__password` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL,
  `password` char(255) DEFAULT NULL,
  `at` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_user__password`
--

LOCK TABLES `log_user__password` WRITE;
/*!40000 ALTER TABLE `log_user__password` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_user__password` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'hive_log'
--

--
-- Dumping routines for database 'hive_log'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-08-04 14:42:03