/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19-12.0.2-MariaDB, for osx10.20 (arm64)
--
-- Host: localhost    Database: brickwal_m1_ds
-- ------------------------------------------------------
-- Server version	12.0.2-MariaDB

/*!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' */;
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `roles` (`id`, `name`, `description`, `is_system`, `created_at`, `updated_at`) VALUES (1,'Admin','System Administrator - Full Access',1,'2025-10-26 14:24:24','2025-11-01 15:08:04'),
(70,'Accounts Payable Manager','Full AP module access including vendor management, payment approvals, and AP reporting.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(72,'Accounts Receivable Manager','Full AR module access including customer payments, credit management, and AR reporting.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(76,'VP/Director of Sales','Full sales and CRM access with pricing approval, discount authority, and team management.',0,'2025-11-08 17:16:14','2025-11-15 12:33:55'),
(77,'Sales Manager','Sales team and account management',0,'2025-11-08 17:16:14','2025-11-11 13:53:56'),
(78,'Sales Representative','Customer relationship management and order processing',0,'2025-11-08 17:16:14','2025-11-11 13:53:56'),
(79,'Customer Service Manager','Full customer service access including ticket management, returns, and CS reporting.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(80,'Customer Service Representative','Handle support tickets, process returns, view customer information.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(81,'VP/Director of Operations','Full operations access including inventory, purchasing, and warehouse management.',0,'2025-11-08 17:16:14','2025-11-15 12:33:55'),
(82,'Warehouse Manager','Manage inventory, approve transfers and adjustments, warehouse reporting.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(85,'Purchasing Manager','Full purchasing access including supplier management, PO approvals, and procurement reports.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(87,'Inventory Controller','Manage inventory levels, reorder points, stock adjustments, and inventory reporting.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(88,'VP/Director of Manufacturing','Full manufacturing access including production planning, BOM management, and MRP.',0,'2025-11-08 17:16:14','2025-11-15 12:33:55'),
(92,'Quality Manager','Full quality control access including inspection plans, non-conformance management, and quality reports.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(93,'Quality Inspector','Perform inspections, record test results, create NCRs. Cannot modify inspection plans.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(96,'HR Coordinator','Employee records, recruitment coordination, training scheduling. No compensation access.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(97,'Recruiting Manager','Full recruitment module access including job postings, interviews, offers, and hiring reports.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(99,'Payroll Manager','Full payroll access with tax filing and payroll reporting.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(100,'System Administrator','Full system access including security, configuration, integrations, and system reports.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(101,'IT Manager','User management, system configuration, backup management, and IT dashboards.',0,'2025-11-08 17:16:14','2025-11-08 17:16:14'),
(108,'CEO','Chief Executive Officer - Full strategic oversight and business administration',0,'2025-11-11 13:50:13','2025-11-11 13:50:13'),
(110,'CFO','Chief Financial Officer - Complete financial oversight and control',0,'2025-11-11 13:53:56','2025-11-11 13:53:56'),
(111,'CTO','Chief Technology Officer',0,'2025-11-15 11:52:00','2025-11-15 11:52:00'),
(112,'COO','Chief Operating Officer - Operations, manufacturing, and supply chain oversight',0,'2025-11-11 13:53:56','2025-11-11 13:53:56'),
(116,'VP/Director of HR','Human resources and talent management',0,'2025-11-11 13:53:56','2025-11-15 12:33:55'),
(121,'Controller','Senior accounting oversight and financial reporting',0,'2025-11-11 13:53:56','2025-11-11 13:53:56'),
(126,'Software Engineer','Software development and technical implementation',0,'2025-11-11 13:53:56','2025-11-11 13:53:56'),
(127,'Product Manager','Product strategy and roadmap management',0,'2025-11-11 13:53:56','2025-11-11 13:53:56'),
(130,'President, Batteries & Tech','President of Batteries & Tech division, reports to CTO',0,'2025-11-15 11:54:33','2026-02-06 17:54:01'),
(131,'VP/Director of Production','VP or Director of Production - manages production operations and team',0,'2025-11-15 12:35:17','2025-11-15 12:35:17'),
(132,'VP/Director of Business Development','VP or Director of Business Development - handles new business and partnerships',0,'2025-11-15 12:35:17','2025-11-15 12:35:17'),
(133,'VP/Director of Autonomous Systems','VP or Director of Autonomous Systems - leads autonomous technology initiatives',0,'2025-11-15 12:35:17','2025-11-15 12:35:17'),
(134,'Test Role','Used to Test Security',0,'2025-11-30 14:10:19','2025-11-30 14:10:19'),
(135,'Standard User','Basic user with access to dashboard, email, calendar, messaging, and profile management. No access to sensitive business data or administrative functions.',0,'2025-12-18 13:02:12','2025-12-18 13:02:12'),
(136,'FTZ Manager','',0,'2026-01-02 12:57:52','2026-01-02 12:57:52'),
(137,'Chief of Cyber','Cyber Division Lead role',0,'2026-02-06 15:32:31','2026-02-06 15:32:31'),
(138,'Chief Executive Officer','Chief Executive Officer - Executive',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(139,'Chief Financial Officer','Chief Financial Officer - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(140,'Chief Operating Officer','Chief Operating Officer - Operations',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(141,'Chief Technology Officer','Chief Technology Officer - IT',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(142,'VP of Sales','VP of Sales - Sales',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(143,'VP of Human Resources','VP of Human Resources - HR',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(144,'VP of Manufacturing','VP of Manufacturing - Manufacturing',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(145,'VP of Finance','VP of Finance - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(146,'Director of Accounting','Director of Accounting - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(147,'Director of Financial Planning','Director of Financial Planning - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(148,'Director of Sales Operations','Director of Sales Operations - Sales',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(149,'Director of Customer Success','Director of Customer Success - Sales',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(150,'Director of Manufacturing','Director of Manufacturing - Manufacturing',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(151,'Director of Supply Chain','Director of Supply Chain - Operations',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(152,'Director of Quality Assurance','Director of Quality Assurance - Manufacturing',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(153,'Director of HR Operations','Director of HR Operations - HR',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(154,'Director of Talent Acquisition','Director of Talent Acquisition - HR',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(155,'Director of IT','Director of IT - IT',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(156,'Accounting Manager','Accounting Manager - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(157,'Quality Control Manager','Quality Control Manager - Manufacturing',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(158,'Inventory Control Manager','Inventory Control Manager - Operations',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(159,'Accounting Supervisor','Accounting Supervisor - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(160,'AP Supervisor','AP Supervisor - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(161,'AR Supervisor','AR Supervisor - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(162,'Sales Team Lead - East','Sales Team Lead - East - Sales',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(163,'Sales Team Lead - West','Sales Team Lead - West - Sales',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(164,'Sales Team Lead - Central','Sales Team Lead - Central - Sales',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(165,'Customer Service Lead','Customer Service Lead - Sales',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(166,'Quality Inspector Lead','Quality Inspector Lead - Manufacturing',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(167,'Shipping Supervisor','Shipping Supervisor - Operations',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(168,'Receiving Supervisor','Receiving Supervisor - Operations',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(169,'Purchasing Agent Lead','Purchasing Agent Lead - Operations',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(170,'HR Coordinator Lead','HR Coordinator Lead - HR',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(171,'Recruiter Lead','Recruiter Lead - HR',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(172,'IT Support Lead','IT Support Lead - IT',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(173,'AP Clerk','AP Clerk - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(174,'AR Clerk','AR Clerk - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(175,'Payroll Specialist','Payroll Specialist - Finance',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(176,'Senior Sales Representative','Senior Sales Representative - Sales',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(177,'HR Assistant','HR Assistant - HR',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(178,'Systems Administrator','Systems Administrator - IT',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(179,'Database Administrator','Database Administrator - IT',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(180,'Senior Software Engineer','Senior Software Engineer - Engineering',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(181,'Senior Product Manager','Senior Product Manager - Product',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(182,'Customer Support Specialist','Customer Support Specialist - Support',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(183,'Customer Support Manager','Customer Support Manager - Support',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(184,'President','President - Battery & Energy Technologies',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(185,'Director of Operations','Director of Operations - Operations',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(186,'Administrator','Administrator - Admin',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(187,'VP of Production','VP of Production - Manufacturing',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(188,'VP of Business Development','VP of Business Development - Business Development',0,'2026-02-06 17:56:43','2026-02-06 17:56:43'),
(189,'VP of Autonomous Systems','VP of Autonomous Systems - Autonomous Systems',0,'2026-02-06 17:56:43','2026-02-06 17:56:43');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
commit;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */;
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;

-- Dump completed on 2026-02-10  8:55:15