/*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 `positions`
--

LOCK TABLES `positions` WRITE;
/*!40000 ALTER TABLE `positions` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `positions` (`id`, `title`, `department`, `description`, `level`, `reports_to_position_id`, `is_active`, `role_id`, `created_at`, `updated_at`) VALUES (1,'Chief Executive Officer','Executive','CEO - Top executive position','Executive',NULL,1,138,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(2,'Chief Financial Officer','Finance','CFO - Financial oversight','Executive',1,1,139,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(3,'Chief Operating Officer','Operations','COO - Operations oversight','Executive',1,1,140,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(4,'Chief Technology Officer','IT','CTO - Technology oversight','Executive',1,1,141,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(5,'VP of Sales','Sales','Sales leadership','Executive',1,1,142,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(6,'VP of Human Resources','HR','HR leadership','Executive',1,1,143,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(7,'VP of Manufacturing','Manufacturing','Manufacturing leadership','Executive',3,1,144,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(8,'VP of Finance','Finance','Finance leadership','Executive',2,1,145,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(9,'Director of Accounting','Finance','Accounting operations director','Director',8,1,146,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(10,'Director of Financial Planning','Finance','FP&A director','Director',8,1,147,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(11,'Director of Sales Operations','Sales','Sales operations director','Director',5,1,148,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(12,'Director of Customer Success','Sales','Customer success director','Director',5,1,149,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(13,'Director of Manufacturing','Manufacturing','Manufacturing operations director','Director',7,1,150,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(14,'Director of Supply Chain','Operations','Supply chain director','Director',3,1,151,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(15,'Director of Quality Assurance','Manufacturing','Quality director','Director',7,1,152,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(16,'Director of HR Operations','HR','HR operations director','Director',6,1,153,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(17,'Director of Talent Acquisition','HR','Recruitment director','Director',6,1,154,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(18,'Director of IT','IT','IT infrastructure director','Director',4,1,155,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(19,'Accounting Manager','Finance','Manages accounting team','Manager',9,1,156,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(28,'Quality Control Manager','Manufacturing','QC team manager','Manager',15,1,157,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(31,'Inventory Control Manager','Operations','Inventory management','Manager',14,1,158,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(33,'Recruiting Manager','HR','Recruitment team manager','Manager',17,1,97,'2025-11-08 17:16:14','2025-11-15 12:03:48'),
(36,'Accounting Supervisor','Finance','Supervises accounting staff','Lead',19,1,159,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(37,'AP Supervisor','Finance','Supervises AP staff','Lead',NULL,1,160,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(38,'AR Supervisor','Finance','Supervises AR staff','Lead',NULL,1,161,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(39,'Sales Team Lead - East','Sales','East team lead','Lead',NULL,1,162,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(40,'Sales Team Lead - West','Sales','West team lead','Lead',NULL,1,163,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(41,'Sales Team Lead - Central','Sales','Central team lead','Lead',NULL,1,164,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(42,'Customer Service Lead','Sales','CS team lead','Lead',NULL,1,165,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(44,'Quality Inspector Lead','Manufacturing','QC lead','Lead',28,1,166,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(46,'Shipping Supervisor','Operations','Shipping supervisor','Lead',NULL,1,167,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(47,'Receiving Supervisor','Operations','Receiving supervisor','Lead',NULL,1,168,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(48,'Purchasing Agent Lead','Operations','Lead buyer','Lead',NULL,1,169,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(49,'HR Coordinator Lead','HR','HR team lead','Lead',NULL,1,170,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(50,'Recruiter Lead','HR','Recruitment team lead','Lead',33,1,171,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(51,'IT Support Lead','IT','IT support lead','Lead',NULL,1,172,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(55,'AP Clerk','Finance','Accounts payable clerk','Mid',37,1,173,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(56,'AR Clerk','Finance','Accounts receivable clerk','Mid',38,1,174,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(57,'Payroll Specialist','Finance','Payroll processing','Mid',NULL,1,175,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(58,'Senior Sales Representative','Sales','Senior sales position','Senior',NULL,1,176,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(71,'HR Assistant','HR','HR support','Entry',50,1,177,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(74,'Systems Administrator','IT','System administration','Senior',NULL,1,178,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(75,'Database Administrator','IT','Database management','Senior',NULL,1,179,'2025-11-08 17:16:14','2026-02-06 17:57:39'),
(77,'Senior Software Engineer','Engineering',NULL,'Senior',NULL,1,180,'2025-11-10 17:33:43','2026-02-06 17:57:39'),
(80,'Senior Product Manager','Product',NULL,'Senior',NULL,1,181,'2025-11-10 17:33:43','2026-02-06 17:57:39'),
(91,'Customer Support Specialist','Support',NULL,'Mid',NULL,1,182,'2025-11-10 17:33:43','2026-02-06 17:57:39'),
(92,'Customer Support Manager','Support',NULL,'Manager',NULL,1,183,'2025-11-10 17:33:43','2026-02-06 17:57:39'),
(110,'President','Battery & Energy Technologies','','Director',4,1,184,'2025-11-15 00:03:04','2026-02-06 17:57:39'),
(111,'Director of Operations','Operations','','Director',1,1,185,'2025-11-15 00:23:53','2026-02-06 17:57:39'),
(112,'Administrator','Admin',NULL,'Executive',NULL,1,186,'2025-11-15 11:49:26','2026-02-06 17:57:39'),
(114,'VP of Production','Manufacturing','','Executive',1,1,187,'2025-11-15 12:35:43','2026-02-06 17:57:39'),
(115,'VP of Business Development','Business Development',NULL,'Executive',NULL,1,188,'2025-11-15 12:35:43','2026-02-06 17:57:39'),
(116,'VP of Autonomous Systems','Autonomous Systems',NULL,'Executive',NULL,1,189,'2025-11-15 12:35:43','2026-02-06 17:57:39'),
(117,'President, Batteries & Tech',NULL,NULL,'Executive',NULL,1,130,'2025-11-15 18:23:48','2026-02-06 17:57:39'),
(118,'Chief of Cyber','IT','Cyber Division Lead - Oversees cybersecurity operations','Lead',3,1,137,'2026-02-06 15:24:36','2026-02-06 15:32:43'),
(119,'Admin','Executive','System Administrator - Full Access','Executive',NULL,1,1,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(120,'Accounts Payable Manager','Finance','Full AP module access including vendor management, payment approvals, and AP reporting.','Manager',NULL,1,70,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(121,'Accounts Receivable Manager','Finance','Full AR module access including customer payments, credit management, and AR reporting.','Manager',NULL,1,72,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(122,'VP/Director of Sales','Sales','Full sales and CRM access with pricing approval, discount authority, and team management.','Executive',NULL,1,76,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(123,'Sales Manager','Sales','Sales team and account management','Manager',NULL,1,77,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(124,'Sales Representative','Sales','Customer relationship management and order processing','Mid',NULL,1,78,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(125,'Customer Service Manager','Support','Full customer service access including ticket management, returns, and CS reporting.','Manager',NULL,1,79,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(126,'Customer Service Representative','Support','Handle support tickets, process returns, view customer information.','Mid',NULL,1,80,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(127,'VP/Director of Operations','IT','Full operations access including inventory, purchasing, and warehouse management.','Executive',NULL,1,81,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(128,'Warehouse Manager','Operations','Manage inventory, approve transfers and adjustments, warehouse reporting.','Manager',NULL,1,82,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(129,'Purchasing Manager','Operations','Full purchasing access including supplier management, PO approvals, and procurement reports.','Manager',NULL,1,85,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(130,'Inventory Controller','Finance','Manage inventory levels, reorder points, stock adjustments, and inventory reporting.','Manager',NULL,1,87,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(131,'VP/Director of Manufacturing','IT','Full manufacturing access including production planning, BOM management, and MRP.','Executive',NULL,1,88,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(132,'Quality Manager','IT','Full quality control access including inspection plans, non-conformance management, and quality reports.','Manager',NULL,1,92,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(133,'Quality Inspector','IT','Perform inspections, record test results, create NCRs. Cannot modify inspection plans.','Executive',NULL,1,93,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(134,'HR Coordinator','HR','Employee records, recruitment coordination, training scheduling. No compensation access.','Executive',NULL,1,96,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(135,'Payroll Manager','General','Full payroll access with tax filing and payroll reporting.','Manager',NULL,1,99,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(136,'System Administrator','IT','Full system access including security, configuration, integrations, and system reports.','Mid',NULL,1,100,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(137,'IT Manager','IT','User management, system configuration, backup management, and IT dashboards.','Manager',NULL,1,101,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(142,'VP/Director of HR','HR','Human resources and talent management','Executive',NULL,1,116,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(143,'Controller','Finance','Senior accounting oversight and financial reporting','Manager',NULL,1,121,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(144,'Software Engineer','IT','Software development and technical implementation','Mid',NULL,1,126,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(145,'Product Manager','General','Product strategy and roadmap management','Manager',NULL,1,127,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(146,'VP/Director of Production','IT','VP or Director of Production - manages production operations and team','Executive',NULL,1,131,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(147,'VP/Director of Business Development','IT','VP or Director of Business Development - handles new business and partnerships','Executive',NULL,1,132,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(148,'VP/Director of Autonomous Systems','IT','VP or Director of Autonomous Systems - leads autonomous technology initiatives','Executive',NULL,1,133,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(149,'Test Role','General','Used to Test Security','Mid',NULL,1,134,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(150,'Standard User','General','Basic user with access to dashboard, email, calendar, messaging, and profile management. No access to sensitive business data or administrative functions.','Mid',NULL,1,135,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(151,'FTZ Manager','General','','Manager',NULL,1,136,'2026-02-06 18:01:52','2026-02-06 18:01:52'),
(182,'VP of Operations','Operations',NULL,'VP',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(183,'Technical Support Specialist','Batteries',NULL,'Specialist',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(184,'Engineer','Information Systems',NULL,'Engineer',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(185,'Director','Trusted Systems & Compliance',NULL,'Director',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(186,'Executive Vice President','Battery & Energy Storage',NULL,'EVP',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(187,'Director','Frames & Structures',NULL,'Director',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(188,'Director','Propulsion & Actuation',NULL,'Director',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(189,'Director','Autonomous Systems',NULL,'Director',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(190,'Director','Strategic Educational Tools',NULL,'Director',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(191,'Director','Advanced Materials & Composites',NULL,'Director',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(192,'Director','Electronics & Control Systems',NULL,'Director',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(193,'Engineer','Propulsion & Actuation',NULL,'Engineer',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(194,'Engineer','Drones & Robotics',NULL,'Engineer',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14'),
(195,'Engineer','Artificial Intelligence',NULL,'Engineer',NULL,1,NULL,'2026-02-10 13:01:14','2026-02-10 13:01:14');
/*!40000 ALTER TABLE `positions` 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:10
