-- MySQL dump 10.13  Distrib 8.0.42, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: handsdb
-- ------------------------------------------------------
-- Server version	8.0.42

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 */;

--
-- Table structure for table `activity_logs`
--

DROP TABLE IF EXISTS `activity_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `activity_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_username` (`username`),
  CONSTRAINT `activity_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `activity_logs`
--

LOCK TABLES `activity_logs` WRITE;
/*!40000 ALTER TABLE `activity_logs` DISABLE KEYS */;
INSERT INTO `activity_logs` VALUES (1,1,'sbastola','User logged in via AD','Username: sbastola','::1','2025-11-27 15:10:37'),(2,1,'sbastola','Category added','Name: Gloves','::1','2025-11-27 15:12:02'),(3,1,'sbastola','Size added','Size: M','::1','2025-11-27 15:12:10'),(4,1,'sbastola','Location added','Name: Bracebridge','::1','2025-11-27 15:12:20'),(5,1,'sbastola','Department added','Name: Human Resource','::1','2025-11-27 15:12:30'),(6,1,'sbastola','Seller added','Name: Jethro Factory','::1','2025-11-27 15:12:41'),(7,1,'sbastola','Type added','Name: Winter','::1','2025-11-27 15:13:02'),(8,1,'sbastola','User logged out','Username: sbastola','::1','2025-11-27 18:22:09'),(9,NULL,'admin','Failed login attempt','Invalid credentials | IP: ::1',NULL,'2025-11-27 18:41:36'),(10,1,'sbastola','User logged in via AD','Username: sbastola','::1','2025-11-27 18:41:46'),(11,1,'sbastola','Product added','Part Number: WG-001, Type ID: 1','::1','2025-11-27 18:46:34'),(12,1,'sbastola','Stock added','sbastola added 12222 M  to Bracebridge warehouse','::1','2025-11-27 18:46:55'),(13,1,'sbastola','Stock removed','sbastola gave 2000 M  to Human Resource from Bracebridge','::1','2025-11-27 18:47:24'),(14,1,'sbastola','Location added','Name: Barrie','::1','2025-11-27 18:47:41'),(15,1,'sbastola','Stock transferred','sbastola transferred 4000 M  from Bracebridge to Barrie','::1','2025-11-27 18:48:02'),(16,1,'sbastola','Stock removed','sbastola gave 6220 M  to Human Resource from Bracebridge','::1','2025-11-27 18:48:46'),(17,1,'sbastola','User logged out','Username: sbastola','::1','2025-11-27 18:56:45'),(18,1,'sbastola','User logged in via AD','Username: sbastola','::1','2025-11-27 18:56:57'),(19,1,'sbastola','Report generated','Type: Low Stock Report','::1','2025-11-27 18:57:07'),(20,1,'sbastola','Report generated','Type: Transaction Report','::1','2025-11-27 18:57:15'),(21,1,'sbastola','Report generated','Type: Inventory Report','::1','2025-11-27 18:57:20'),(22,1,'sbastola','Report generated','Type: Inventory Report','::1','2025-11-27 18:57:41'),(23,1,'sbastola','Report generated','Type: Inventory Report','::1','2025-11-27 18:57:55'),(24,1,'sbastola','Report generated','Type: Low Stock Report','::1','2025-11-27 18:58:09'),(25,1,'sbastola','User logged out','Username: sbastola','::1','2025-11-27 18:59:41'),(26,1,'sbastola','User logged in via AD','Username: sbastola','::1','2025-11-27 19:07:05'),(27,1,'sbastola','Category added','Name: Pipes','::1','2025-11-27 19:08:19'),(28,1,'sbastola','Type added','Name: straight pipe','::1','2025-11-27 19:09:09'),(29,1,'sbastola','Product added','Part Number: sdfsd, Type ID: 2','::1','2025-11-27 19:09:35'),(30,1,'sbastola','Stock added','sbastola added 12345 M  to Barrie warehouse','::1','2025-11-27 19:10:04'),(31,1,'sbastola','Stock removed','sbastola gave 1200 M  to Human Resource from Barrie','::1','2025-11-27 19:10:31'),(32,1,'sbastola','Report generated','Type: Inventory Report','::1','2025-11-27 19:10:59'),(33,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.69','2025-11-27 20:26:00'),(34,1,'sbastola','User logged out','Username: sbastola','192.168.3.69','2025-11-27 20:47:28'),(35,NULL,'admin','Failed login attempt','Invalid credentials | IP: 192.168.3.69',NULL,'2025-11-27 20:47:34'),(36,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.69','2025-11-27 20:57:00'),(37,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.4','2025-11-27 21:03:06'),(38,2,'tvanekelenburg','User logged in via AD','Username: tvanekelenburg','192.168.3.25','2025-11-28 18:04:58'),(39,1,'sbastola','User logged out','Username: sbastola','192.168.3.58','2025-11-28 19:14:29'),(40,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.58','2025-11-28 19:14:40'),(41,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.4','2025-11-28 20:01:52'),(42,1,'sbastola','Report generated','Type: Low Stock Report','192.168.3.58','2025-11-28 20:35:02'),(43,1,'sbastola','Report generated','Type: Low Stock Report','192.168.3.58','2025-11-28 20:35:48'),(44,1,'sbastola','Report generated','Type: Transaction Report','192.168.3.58','2025-11-28 20:36:13'),(45,1,'sbastola','Report generated','Type: Low Stock Report','192.168.3.58','2025-11-28 20:48:32'),(46,1,'sbastola','User logged out','Username: sbastola','192.168.3.58','2025-11-28 20:57:21'),(47,3,'localadmin','User logged in (local)','Username: localadmin','192.168.3.58','2025-11-28 20:57:34'),(48,3,'localadmin','All toast templates reset','localadmin reset all toast templates to defaults','192.168.3.58','2025-11-28 20:58:11'),(49,3,'localadmin','User logged out','Username: localadmin','192.168.3.58','2025-11-28 20:58:21'),(50,3,'localadmin','User logged in (local)','Username: localadmin','192.168.3.58','2025-11-28 20:58:43'),(51,3,'localadmin','User logged out','Username: localadmin','192.168.3.58','2025-11-28 20:59:06'),(52,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.58','2025-11-28 20:59:16'),(53,1,'sbastola','Size added','Size: S','192.168.3.58','2025-11-28 21:02:18'),(54,1,'sbastola','Size added','Size: L','192.168.3.58','2025-11-28 21:02:21'),(55,1,'sbastola','Size added','Size: XL','192.168.3.58','2025-11-28 21:02:25'),(56,1,'sbastola','Size added','Size: 2XL','192.168.3.58','2025-11-28 21:02:28'),(57,1,'sbastola','Size added','Size: 3XL','192.168.3.58','2025-11-28 21:02:32'),(58,1,'sbastola','Size added','Size: 4XL','192.168.3.58','2025-11-28 21:02:35'),(59,1,'sbastola','Size added','Size: XS','192.168.3.58','2025-11-28 21:02:40'),(60,1,'sbastola','Size added','Size: One Size','192.168.3.58','2025-11-28 21:03:07'),(61,1,'sbastola','User logged out','Username: sbastola','99.233.40.157','2025-11-28 23:19:07'),(62,NULL,'localadmin','Failed login attempt','Invalid credentials | IP: 99.233.40.157',NULL,'2025-11-28 23:19:22'),(63,NULL,'localadmin','Failed login attempt','Invalid credentials | IP: 99.233.40.157',NULL,'2025-11-28 23:19:38'),(64,3,'localadmin','User logged in (local)','Username: localadmin','99.233.40.157','2025-11-28 23:19:46'),(65,NULL,'admin','Failed login attempt','Invalid credentials | IP: 99.233.40.157',NULL,'2025-11-29 04:01:10'),(66,4,'cdietl','User logged in via AD','Username: cdietl','192.168.3.62','2025-12-01 18:08:23'),(67,4,'cdietl','User logged in via AD','Username: cdietl','192.168.3.128','2025-12-02 20:00:08'),(68,4,'cdietl','User logged in via AD','Username: cdietl','192.168.3.56','2025-12-09 13:32:50'),(69,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.75','2025-12-09 16:27:14'),(70,1,'sbastola','Employee added','Name: Suraj Bastola, Employee #: 2038','192.168.3.75','2025-12-09 17:24:25'),(71,1,'sbastola','Stock removed','sbastola gave 345 M  to employee Suraj Bastola from Barrie','192.168.3.75','2025-12-09 17:25:07'),(72,1,'sbastola','Stock removed','sbastola gave 345 M  to department Human Resource from Barrie','192.168.3.75','2025-12-09 17:25:28'),(73,1,'sbastola','Report generated','Type: Transaction Report','192.168.3.75','2025-12-09 17:44:35'),(74,1,'sbastola','Stock removed','sbastola gave 34 M  to Human Resource from Barrie','192.168.3.75','2025-12-09 17:52:50'),(75,1,'sbastola','Report generated','Type: Transaction Report','192.168.3.75','2025-12-09 17:53:29'),(76,1,'sbastola','Report generated','Type: Transaction Report','192.168.3.75','2025-12-09 17:54:20'),(77,1,'sbastola','Department added','Name: IT','192.168.3.75','2025-12-09 17:58:37'),(78,1,'sbastola','Report generated','Type: Transaction Report','192.168.3.75','2025-12-09 17:58:58'),(79,1,'sbastola','Report generated','Type: Transaction Report','192.168.3.75','2025-12-09 18:02:15'),(80,1,'sbastola','Report generated','Type: Transaction Report','192.168.3.75','2025-12-09 18:02:30'),(81,1,'sbastola','Report generated','Type: Transaction Report','192.168.3.75','2025-12-09 18:02:35'),(82,1,'sbastola','Report generated','Type: Transaction Report','192.168.3.75','2025-12-09 18:02:48'),(83,1,'sbastola','Employee added','Name: Cassie Dietl, Employee #: 1234','192.168.3.75','2025-12-09 19:15:57'),(84,1,'sbastola','Employee added','Name: Cody Green, Employee #: 4321','192.168.3.75','2025-12-09 19:16:10'),(85,1,'sbastola','Category added','Name: Hats','192.168.3.75','2025-12-09 19:16:25'),(86,1,'sbastola','Category added','Name: boots','192.168.3.75','2025-12-09 19:16:30'),(87,1,'sbastola','Type added','Name: Winter Boots','192.168.3.75','2025-12-09 19:16:44'),(88,1,'sbastola','Type added','Name: black hats','192.168.3.75','2025-12-09 19:16:54'),(89,1,'sbastola','Type added','Name: Steel Toe','192.168.3.75','2025-12-09 19:17:05'),(90,1,'sbastola','Type added','Name: Dhaka','192.168.3.75','2025-12-09 19:17:13'),(91,1,'sbastola','Location added','Name: Ontario','192.168.3.75','2025-12-09 19:17:27'),(92,1,'sbastola','Location added','Name: Toronto','192.168.3.75','2025-12-09 19:17:31'),(93,1,'sbastola','Department added','Name: Payroll','192.168.3.75','2025-12-09 19:17:41'),(94,1,'sbastola','Department added','Name: SM','192.168.3.75','2025-12-09 19:17:44'),(95,1,'sbastola','Department added','Name: Electrical','192.168.3.75','2025-12-09 19:17:57'),(96,1,'sbastola','Seller added','Name: John Supplies','192.168.3.75','2025-12-09 19:18:40'),(97,1,'sbastola','Seller added','Name: Jane Sells','192.168.3.75','2025-12-09 19:19:13'),(98,5,'pperrier','User logged in via AD','Username: pperrier','192.168.2.179','2025-12-09 21:40:36'),(99,1,'sbastola','User logged in via AD','Username: sbastola','104.28.198.70','2025-12-10 14:31:48'),(100,2,'tvanekelenburg','Category added','Name: First Aid','199.34.71.242','2025-12-10 14:48:05'),(101,2,'tvanekelenburg','Category added','Name: Winter Gear','199.34.71.242','2025-12-10 14:49:06'),(102,2,'tvanekelenburg','Category updated','ID: 3, Name: Hard Hats','199.34.71.242','2025-12-10 14:49:22'),(103,2,'tvanekelenburg','Category updated','ID: 1, Name: Gloves','199.34.71.242','2025-12-10 14:49:44'),(104,2,'tvanekelenburg','Category added','Name: Vests','199.34.71.242','2025-12-10 14:51:00'),(105,2,'tvanekelenburg','Category added','Name: Summer Gear','199.34.71.242','2025-12-10 14:51:50'),(106,2,'tvanekelenburg','Category updated','ID: 3, Name: Hard Hats and Hard hat Accessories','199.34.71.242','2025-12-10 14:55:20'),(107,3,'localadmin','User logged out','Username: localadmin','192.168.3.75','2025-12-10 15:19:52'),(108,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.75','2025-12-10 15:20:01'),(109,1,'sbastola','User logged out','Username: sbastola','192.168.3.75','2025-12-10 15:22:59'),(110,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.75','2025-12-10 15:23:08'),(111,2,'tvanekelenburg','Category updated','ID: 2, Name: PPE','199.34.71.242','2025-12-10 15:47:06'),(112,2,'tvanekelenburg','Category updated','ID: 4, Name: go bucket supplies','199.34.71.242','2025-12-10 15:48:50'),(113,2,'tvanekelenburg','Category added','Name: Miscellaneous','199.34.71.242','2025-12-10 15:49:32'),(114,2,'tvanekelenburg','Department added','Name: Construction','199.34.71.242','2025-12-10 15:59:09'),(115,2,'tvanekelenburg','Department added','Name: Materials','199.34.71.242','2025-12-10 15:59:17'),(116,2,'tvanekelenburg','Department added','Name: Huntsville CDMC','199.34.71.242','2025-12-10 15:59:30'),(117,2,'tvanekelenburg','Department added','Name: Simcoe CDMC','199.34.71.242','2025-12-10 15:59:36'),(118,2,'tvanekelenburg','Department added','Name: North Bay CDMC','199.34.71.242','2025-12-10 15:59:44'),(119,2,'tvanekelenburg','Department added','Name: Shop','199.34.71.242','2025-12-10 15:59:59'),(120,2,'tvanekelenburg','Department updated','ID: 4, Name: Office','199.34.71.242','2025-12-10 16:00:20'),(121,2,'tvanekelenburg','Location added','Name: sea can','199.34.71.242','2025-12-10 16:00:44'),(122,2,'tvanekelenburg','Location updated','ID: 5, Name: Sea Can','199.34.71.242','2025-12-10 16:00:56'),(123,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.75','2025-12-10 17:07:41'),(124,2,'tvanekelenburg','Department added','Name: H&S Department','199.34.71.242','2025-12-10 17:40:49'),(125,2,'tvanekelenburg','Category added','Name: Administrative','199.34.71.242','2025-12-10 17:52:44'),(126,2,'tvanekelenburg','Category added','Name: signs','199.34.71.242','2025-12-10 17:52:53'),(127,2,'tvanekelenburg','Category updated','ID: 10, Name: Administrative','199.34.71.242','2025-12-10 17:53:16'),(128,1,'sbastola','User logged out','Username: sbastola','192.168.3.75','2025-12-10 18:15:21'),(129,NULL,'localadmin','Failed login attempt','Invalid credentials | IP: 192.168.3.75',NULL,'2025-12-10 18:15:34'),(130,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.75','2025-12-10 18:15:43'),(131,1,'sbastola','User logged in via AD','Username: sbastola','94.156.30.136','2025-12-11 03:27:13'),(132,1,'sbastola','Type deleted','ID: 4','94.156.30.136','2025-12-11 03:29:15'),(133,1,'sbastola','Type deleted','ID: 6','94.156.30.136','2025-12-11 03:29:22'),(134,1,'sbastola','Type deleted','ID: 2','94.156.30.136','2025-12-11 03:29:33'),(135,1,'sbastola','Type deleted','ID: 1','94.156.30.136','2025-12-11 03:29:35'),(136,1,'sbastola','Type deleted','ID: 3','94.156.30.136','2025-12-11 03:29:38'),(137,1,'sbastola','User logged out','Username: sbastola','104.28.198.70','2025-12-11 15:51:35'),(138,1,'sbastola','User logged in via AD','Username: sbastola','104.28.198.70','2025-12-11 15:52:18'),(139,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.100','2025-12-15 14:44:48'),(140,1,'sbastola','User logged out','Username: sbastola','192.168.3.100','2025-12-15 14:50:58'),(141,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.100','2025-12-15 14:51:37'),(142,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.100','2025-12-15 14:54:51'),(143,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.59','2025-12-15 14:56:21'),(144,6,'cgreen','User logged in via AD','Username: cgreen','192.168.2.198','2025-12-15 15:23:27'),(145,1,'sbastola','Product added','Part Number: sample001, Type ID: 1','192.168.3.59','2025-12-15 16:10:50'),(146,1,'sbastola','Stock added','sbastola added 12 S  to Barrie warehouse','192.168.3.59','2025-12-15 16:11:03'),(147,1,'sbastola','User logged out','Username: sbastola','192.168.3.59','2025-12-15 16:15:26'),(148,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.59','2025-12-15 16:15:41'),(149,1,'sbastola','User logged out','Username: sbastola','192.168.3.59','2025-12-15 16:19:59'),(150,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.59','2025-12-15 16:20:10'),(151,1,'sbastola','User logged out','Username: sbastola','192.168.3.59','2025-12-15 16:20:27'),(152,NULL,'sbastola','Failed login attempt','Invalid credentials | IP: 192.168.3.59',NULL,'2025-12-15 16:20:33'),(153,1,'sbastola','User logged in via AD','Username: sbastola','192.168.3.59','2025-12-15 16:20:54'),(154,1,'sbastola','Department deleted','ID: 2','192.168.3.59','2025-12-15 16:47:57'),(155,1,'sbastola','Location deleted','ID: 2','192.168.3.59','2025-12-15 16:48:08'),(156,1,'sbastola','Employee deleted','ID: 1','192.168.3.59','2025-12-15 16:48:57'),(157,1,'sbastola','Employee updated','ID: 3, Name: Cody Green','192.168.3.59','2025-12-15 16:49:09'),(158,1,'sbastola','Employee updated','ID: 1, Name: Suraj Bastola','192.168.3.59','2025-12-15 16:49:25'),(159,1,'sbastola','Employee updated','ID: 1, Name: Suraj Bastola','192.168.3.59','2025-12-15 16:49:32'),(160,1,'sbastola','Seller deleted','ID: 1','192.168.3.59','2025-12-15 16:49:47'),(161,2,'tvanekelenburg','User logged in via AD','Username: tvanekelenburg','192.168.2.179','2025-12-16 17:14:07'),(162,2,'tvanekelenburg','Location deleted','ID: 3','192.168.2.179','2025-12-16 18:07:18'),(163,2,'tvanekelenburg','Location deleted','ID: 4','192.168.2.179','2025-12-16 18:12:41'),(164,1,'sbastola','User logged in via AD','Username: sbastola','192.168.2.195','2025-12-19 13:59:58'),(165,1,'sbastola','User logged in via AD','Username: sbastola','192.168.2.195','2025-12-19 14:05:17'),(166,1,'sbastola','Product added','Part Number: Example product 1, Type ID: 1','192.168.2.195','2025-12-19 14:47:01'),(167,1,'sbastola','Stock added','sbastola added 40   to Bracebridge warehouse','192.168.2.195','2025-12-19 14:58:54'),(168,1,'sbastola','Report generated','Type: Transaction Report','192.168.2.195','2025-12-19 16:47:54'),(169,1,'sbastola','Report generated','Type: Inventory Report','192.168.2.195','2025-12-19 16:47:56');
/*!40000 ALTER TABLE `activity_logs` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2025-12-19 13:45:41
