-- MariaDB dump 10.19 Distrib 10.4.28-MariaDB, for osx10.10 (x86_64) -- -- Host: 127.0.0.1 Database: cmms -- ------------------------------------------------------ -- Server version 10.4.28-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' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `asset_categories` -- DROP TABLE IF EXISTS `asset_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `asset_categories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `assetCount` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `asset_categories` -- LOCK TABLES `asset_categories` WRITE; /*!40000 ALTER TABLE `asset_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `asset_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `asset_machine_types` -- DROP TABLE IF EXISTS `asset_machine_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `asset_machine_types` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `assetCount` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `asset_machine_types` -- LOCK TABLES `asset_machine_types` WRITE; /*!40000 ALTER TABLE `asset_machine_types` DISABLE KEYS */; /*!40000 ALTER TABLE `asset_machine_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `asset_usages` -- DROP TABLE IF EXISTS `asset_usages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `asset_usages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `asset_id` varchar(255) DEFAULT NULL, `asset_name` varchar(255) NOT NULL, `reading_date` datetime DEFAULT NULL, `reading_km` double DEFAULT NULL, `reading_hours` double DEFAULT NULL, `recorded_by` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `asset_usages` -- LOCK TABLES `asset_usages` WRITE; /*!40000 ALTER TABLE `asset_usages` DISABLE KEYS */; /*!40000 ALTER TABLE `asset_usages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assets` -- DROP TABLE IF EXISTS `assets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `assets` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `organisation_id` varchar(255) NOT NULL DEFAULT 'ORG-1', `plant_id` varchar(255) DEFAULT NULL, `name` varchar(255) NOT NULL, `category_id` varchar(255) DEFAULT NULL, `type_id` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'Active', `health` int(11) NOT NULL DEFAULT 100, `parent_id` varchar(255) DEFAULT NULL, `serial` varchar(255) DEFAULT NULL, `brand` varchar(255) DEFAULT NULL, `model` varchar(255) DEFAULT NULL, `installDate` varchar(255) DEFAULT NULL, `warranty` varchar(255) DEFAULT NULL, `lastPM` varchar(255) DEFAULT NULL, `nextPM` varchar(255) DEFAULT NULL, `wos` int(11) NOT NULL DEFAULT 0, `location` varchar(255) DEFAULT NULL, `department` varchar(255) DEFAULT NULL, `subDepartment` varchar(255) DEFAULT NULL, `section` varchar(255) DEFAULT NULL, `healthHistory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`healthHistory`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assets` -- LOCK TABLES `assets` WRITE; /*!40000 ALTER TABLE `assets` DISABLE KEYS */; /*!40000 ALTER TABLE `assets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `audit_logs` -- DROP TABLE IF EXISTS `audit_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `audit_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` varchar(255) NOT NULL, `user_name` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `module` varchar(255) NOT NULL, `target_id` varchar(255) NOT NULL, `details` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `audit_logs` -- LOCK TABLES `audit_logs` WRITE; /*!40000 ALTER TABLE `audit_logs` DISABLE KEYS */; /*!40000 ALTER TABLE `audit_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` bigint(20) NOT NULL, PRIMARY KEY (`key`), KEY `cache_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` bigint(20) NOT NULL, PRIMARY KEY (`key`), KEY `cache_locks_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) NOT NULL, `connection` varchar(255) NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`), KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `inventory_categories` -- DROP TABLE IF EXISTS `inventory_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `inventory_categories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `itemCount` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `inventory_categories` -- LOCK TABLES `inventory_categories` WRITE; /*!40000 ALTER TABLE `inventory_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `inventory_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `inventory_items` -- DROP TABLE IF EXISTS `inventory_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `inventory_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `organisation_id` varchar(255) NOT NULL DEFAULT 'ORG-1', `plant_id` varchar(255) DEFAULT NULL, `name` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `item_type` varchar(255) NOT NULL DEFAULT 'Spare Part', `unit` varchar(255) NOT NULL, `stock` int(11) NOT NULL DEFAULT 0, `min_stock` int(11) NOT NULL DEFAULT 0, `cost` double NOT NULL DEFAULT 0, `supplier` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `usedMTD` int(11) NOT NULL DEFAULT 0, `attachment` varchar(255) DEFAULT NULL, `sub_item` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `inventory_items` -- LOCK TABLES `inventory_items` WRITE; /*!40000 ALTER TABLE `inventory_items` DISABLE KEYS */; /*!40000 ALTER TABLE `inventory_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` smallint(5) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `maint_work_requests` -- DROP TABLE IF EXISTS `maint_work_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `maint_work_requests` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `organisation_id` varchar(255) NOT NULL DEFAULT 'ORG-1', `plant_id` varchar(255) DEFAULT NULL, `asset_id` varchar(255) DEFAULT NULL, `requestor_id` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `priority` varchar(255) NOT NULL DEFAULT 'Medium', `status` varchar(255) NOT NULL DEFAULT 'Pending', `work_order_id` varchar(255) DEFAULT NULL, `requestorName` varchar(255) DEFAULT NULL, `assetName` varchar(255) DEFAULT NULL, `plantName` varchar(255) DEFAULT NULL, `attachment` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `maint_work_requests` -- LOCK TABLES `maint_work_requests` WRITE; /*!40000 ALTER TABLE `maint_work_requests` DISABLE KEYS */; /*!40000 ALTER TABLE `maint_work_requests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_07_01_094126_create_asset_categories_table',1),(5,'2026_07_01_094126_create_asset_machine_types_table',1),(6,'2026_07_01_094126_create_plants_table',1),(7,'2026_07_01_094127_create_assets_table',1),(8,'2026_07_01_094127_create_inventory_categories_table',1),(9,'2026_07_01_094127_create_work_orders_table',1),(10,'2026_07_01_094128_create_inventory_items_table',1),(11,'2026_07_01_094128_create_p_m_schedules_table',1),(12,'2026_07_01_094128_create_team_users_table',1),(13,'2026_07_01_094129_create_maint_work_requests_table',1),(14,'2026_07_01_100000_create_asset_usages_table',1),(15,'2026_07_01_100000_create_suppliers_table',1),(16,'2026_07_01_100001_create_audit_logs_table',1),(17,'2026_07_01_100001_create_module_accesses_table',1),(18,'2026_07_01_100001_create_notifications_table',1),(19,'2026_07_01_100002_create_notification_channels_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `module_accesses` -- DROP TABLE IF EXISTS `module_accesses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `module_accesses` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role` varchar(255) NOT NULL, `module` varchar(255) NOT NULL, `isVisible` tinyint(1) NOT NULL DEFAULT 1, `isAccessible` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `module_accesses` -- LOCK TABLES `module_accesses` WRITE; /*!40000 ALTER TABLE `module_accesses` DISABLE KEYS */; /*!40000 ALTER TABLE `module_accesses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notification_channels` -- DROP TABLE IF EXISTS `notification_channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notification_channels` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(255) NOT NULL, `enabled` tinyint(1) NOT NULL DEFAULT 1, `frequency` varchar(255) NOT NULL DEFAULT 'Immediate', `topics` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`topics`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notification_channels` -- LOCK TABLES `notification_channels` WRITE; /*!40000 ALTER TABLE `notification_channels` DISABLE KEYS */; /*!40000 ALTER TABLE `notification_channels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` varchar(255) DEFAULT NULL, `title` varchar(255) NOT NULL, `message` text NOT NULL, `module` varchar(255) DEFAULT NULL, `is_read` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `p_m_schedules` -- DROP TABLE IF EXISTS `p_m_schedules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `p_m_schedules` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `organisation_id` varchar(255) NOT NULL DEFAULT 'ORG-1', `plant_id` varchar(255) DEFAULT NULL, `asset_id` varchar(255) DEFAULT NULL, `title` varchar(255) NOT NULL, `frequency` varchar(255) NOT NULL, `trigger_type` varchar(255) NOT NULL, `interval_value` int(11) DEFAULT NULL, `next_due` varchar(255) DEFAULT NULL, `last_done` varchar(255) DEFAULT NULL, `assigned_to` varchar(255) DEFAULT NULL, `last_notified_at` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'Scheduled', `compliance` int(11) NOT NULL DEFAULT 100, `estHours` double NOT NULL DEFAULT 0, `assetName` varchar(255) DEFAULT NULL, `plantName` varchar(255) DEFAULT NULL, `assigneeName` varchar(255) DEFAULT NULL, `trigger` varchar(255) DEFAULT NULL, `thresholdKm` double DEFAULT NULL, `thresholdHours` double DEFAULT NULL, `checklist` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `p_m_schedules` -- LOCK TABLES `p_m_schedules` WRITE; /*!40000 ALTER TABLE `p_m_schedules` DISABLE KEYS */; /*!40000 ALTER TABLE `p_m_schedules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plants` -- DROP TABLE IF EXISTS `plants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `plants` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `organisation_id` varchar(255) NOT NULL DEFAULT 'ORG-1', `name` varchar(255) NOT NULL, `location` varchar(255) DEFAULT NULL, `timezone` varchar(255) DEFAULT NULL, `department` varchar(255) DEFAULT NULL, `sub_department` varchar(255) DEFAULT NULL, `section` varchar(255) DEFAULT NULL, `assets` int(11) NOT NULL DEFAULT 0, `active_wos` int(11) NOT NULL DEFAULT 0, `departments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`departments`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `plants` -- LOCK TABLES `plants` WRITE; /*!40000 ALTER TABLE `plants` DISABLE KEYS */; /*!40000 ALTER TABLE `plants` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` VALUES ('ANMDWXEmusx7YyuIcFqVLmMu0P8wa6ZxhWX5RkMh',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:153.0) Gecko/20100101 Firefox/153.0','eyJfdG9rZW4iOiJvMFBSV0ttd3JPaVJzbUoxZ21PZkFHTFpaUklkcE9vODg1YTVoSTR1IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAwIiwicm91dGUiOm51bGx9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19',1784271081),('lc49QaKKgexyw3njie5D0v6WkHfQNpYpl9SF5hke',NULL,'127.0.0.1','curl/8.13.0','eyJfdG9rZW4iOiJOdTBGYjNYWVpZRkNyV1pMeDljYVFGVjNFNms1aFBEdlFPT09zMTZpIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1782923939),('S4W04RE5gmWeJT3YL4ccXwh3ReJaYDEyvtSB8bUK',NULL,'127.0.0.1','curl/8.13.0','eyJfdG9rZW4iOiJzMFg2NUM3SUNEamh0TVFENElrY05nb2hCYXVrMll5U0Y3REs1Y1ZMIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDEwIiwicm91dGUiOm51bGx9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19',1784271000),('xWUs3ggQ4NaYEBb6TGbT791Vt0UiYTbvlyzieozv',NULL,'127.0.0.1','curl/8.13.0','eyJfdG9rZW4iOiJEbnA0NGoxdVRybndhazJ2Z1piMjYwZ0tpZGxEYjhWeVUzOXN2MG5vIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDEwIiwicm91dGUiOm51bGx9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19',1784271049); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `suppliers` -- DROP TABLE IF EXISTS `suppliers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `suppliers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `organisation_id` varchar(255) NOT NULL DEFAULT 'ORG-1', `name` varchar(255) NOT NULL, `contact_person` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `category` varchar(255) DEFAULT NULL, `items_supplied` int(11) NOT NULL DEFAULT 0, `sub_item` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `suppliers` -- LOCK TABLES `suppliers` WRITE; /*!40000 ALTER TABLE `suppliers` DISABLE KEYS */; /*!40000 ALTER TABLE `suppliers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `team_users` -- DROP TABLE IF EXISTS `team_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `team_users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `organisation_id` varchar(255) NOT NULL DEFAULT 'ORG-1', `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `role` varchar(255) NOT NULL, `plant` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'Active', `last_login` varchar(255) DEFAULT NULL, `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permissions`)), `password` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `team_users_email_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `team_users` -- LOCK TABLES `team_users` WRITE; /*!40000 ALTER TABLE `team_users` DISABLE KEYS */; /*!40000 ALTER TABLE `team_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `work_orders` -- DROP TABLE IF EXISTS `work_orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `work_orders` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `organisation_id` varchar(255) NOT NULL DEFAULT 'ORG-1', `plant_id` varchar(255) DEFAULT NULL, `asset_id` varchar(255) DEFAULT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `priority` varchar(255) NOT NULL DEFAULT 'Medium', `status` varchar(255) NOT NULL DEFAULT 'Open', `type` varchar(255) NOT NULL DEFAULT 'Corrective', `assignee_id` varchar(255) DEFAULT NULL, `created_by` varchar(255) DEFAULT NULL, `due_date` varchar(255) DEFAULT NULL, `completed_at` varchar(255) DEFAULT NULL, `assetName` varchar(255) DEFAULT NULL, `plantName` varchar(255) DEFAULT NULL, `assigneeName` varchar(255) DEFAULT NULL, `category` varchar(255) DEFAULT NULL, `estHours` double NOT NULL DEFAULT 0, `tools` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`tools`)), `materials` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`materials`)), `rescheduleReason` varchar(255) DEFAULT NULL, `requestorName` varchar(255) DEFAULT NULL, `requestorPosition` varchar(255) DEFAULT NULL, `supervisor` varchar(255) DEFAULT NULL, `faultImage` varchar(255) DEFAULT NULL, `employeesNeeded` int(11) NOT NULL DEFAULT 0, `actualHours` double DEFAULT NULL, `actualPeople` int(11) DEFAULT NULL, `notes` text DEFAULT NULL, `progress` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `work_orders` -- LOCK TABLES `work_orders` WRITE; /*!40000 ALTER TABLE `work_orders` DISABLE KEYS */; /*!40000 ALTER TABLE `work_orders` 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 2026-07-17 9:54:04