-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 20, 2026 at 10:21 PM
-- Server version: 10.6.22-MariaDB-ubu2204
-- PHP Version: 8.4.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `ahmedkelani_ai-arms`
--

-- --------------------------------------------------------

--
-- Table structure for table `bit_data`
--

CREATE TABLE `bit_data` (
  `id` int(11) NOT NULL,
  `file_id` int(11) NOT NULL,
  `Bit_Number` text DEFAULT NULL,
  `IADC` text DEFAULT NULL,
  `Size` text DEFAULT NULL,
  `Manufacturer` text DEFAULT NULL,
  `Serial_Number` text DEFAULT NULL,
  `Type` text DEFAULT NULL,
  `Jets` text DEFAULT NULL,
  `TFA` text DEFAULT NULL,
  `MD_In` text DEFAULT NULL,
  `MD_Out` text DEFAULT NULL,
  `TVD_Out` text DEFAULT NULL,
  `Feet` text DEFAULT NULL,
  `Hours` text DEFAULT NULL,
  `Average_ROP` text DEFAULT NULL,
  `WOB` text DEFAULT NULL,
  `RPM` text DEFAULT NULL,
  `I_Row` text DEFAULT NULL,
  `O_Row` text DEFAULT NULL,
  `DC` text DEFAULT NULL,
  `Loc` text DEFAULT NULL,
  `B` text DEFAULT NULL,
  `G` text DEFAULT NULL,
  `Pressure` text DEFAULT NULL,
  `GPM` text DEFAULT NULL,
  `Jet_Vel` text DEFAULT NULL,
  `DP_Av` text DEFAULT NULL,
  `DC_Av` text DEFAULT NULL,
  `Bit_HHP` text DEFAULT NULL,
  `Other` text DEFAULT NULL,
  `POOH_Reason` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bulks`
--

CREATE TABLE `bulks` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `BULK` text DEFAULT NULL,
  `Value` text DEFAULT NULL,
  `Drill_Wtr` text DEFAULT NULL,
  `Pot_Wtr` text DEFAULT NULL,
  `Fuel_BBLS` text DEFAULT NULL,
  `Barite_SX` text DEFAULT NULL,
  `Bentonite_SX` text DEFAULT NULL,
  `Cement_G_SX` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `Company` text DEFAULT NULL,
  `Category` text DEFAULT NULL,
  `No_of_Persons` text DEFAULT NULL,
  `Operating_Hrs` text DEFAULT NULL,
  `On_Location_Hrs` text DEFAULT NULL,
  `total` varchar(200) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `drill_string`
--

CREATE TABLE `drill_string` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `OrderNum` text DEFAULT NULL,
  `Component` text DEFAULT NULL,
  `Provider` text DEFAULT NULL,
  `Nominal_Size` text DEFAULT NULL,
  `Joints` text DEFAULT NULL,
  `OD_Size` text DEFAULT NULL,
  `ID_Size` text DEFAULT NULL,
  `Length` text DEFAULT NULL,
  `Top_Thread` text DEFAULT NULL,
  `Bottom_Thread` text DEFAULT NULL,
  `Weight` text DEFAULT NULL,
  `Grade` text DEFAULT NULL,
  `Class` text DEFAULT NULL,
  `Serial` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `drill_string_floats`
--

CREATE TABLE `drill_string_floats` (
  `id` int(11) NOT NULL,
  `file_id` int(11) NOT NULL,
  `Float` text DEFAULT NULL,
  `BHA_Hrs` text DEFAULT NULL,
  `String_Wt` text DEFAULT NULL,
  `Pick_Up` text DEFAULT NULL,
  `Slack_Off` text DEFAULT NULL,
  `Rot_Torque` text DEFAULT NULL,
  `Jars` text DEFAULT NULL,
  `Serial_Hrs` text DEFAULT NULL,
  `Shock` text DEFAULT NULL,
  `Sub` text DEFAULT NULL,
  `Mud_Motor` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `first_table`
--

CREATE TABLE `first_table` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `date` text DEFAULT NULL,
  `well_no_and_charge` text DEFAULT NULL,
  `Wellbores` text DEFAULT NULL,
  `Objective` varchar(500) DEFAULT NULL,
  `rig` text DEFAULT NULL,
  `Foreman_Engineer` text DEFAULT NULL,
  `Engineer` varchar(500) DEFAULT NULL,
  `Manager` varchar(500) DEFAULT NULL,
  `THURAYA_RIG_FORMAN` text DEFAULT NULL,
  `RIG_FORMAN_VSAT` varchar(500) DEFAULT NULL,
  `CONTRACTOR_CLERK` varchar(500) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `fourth_table`
--

CREATE TABLE `fourth_table` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `Lateral` text DEFAULT NULL,
  `Survey_MD` text DEFAULT NULL,
  `Angle` text DEFAULT NULL,
  `Azimuth` text DEFAULT NULL,
  `CLength` text DEFAULT NULL,
  `TVD` text DEFAULT NULL,
  `NS_Coordinate` text DEFAULT NULL,
  `EW_Coordinate` text DEFAULT NULL,
  `Vertical_Sec` text DEFAULT NULL,
  `DLS` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lost_time_details`
--

CREATE TABLE `lost_time_details` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED DEFAULT NULL,
  `From_To` text DEFAULT NULL,
  `Hrs` text DEFAULT NULL,
  `Cum_Hrs` text DEFAULT NULL,
  `LT_ID` text DEFAULT NULL,
  `Parent_LT_ID` text DEFAULT NULL,
  `Type` text DEFAULT NULL,
  `Cause` text DEFAULT NULL,
  `Object` text DEFAULT NULL,
  `Resp_Co` text DEFAULT NULL,
  `Depth` text DEFAULT NULL,
  `LT_Summary` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mail_configs`
--

CREATE TABLE `mail_configs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `password` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `miscellaneous`
--

CREATE TABLE `miscellaneous` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `BOP_Test` text DEFAULT NULL,
  `BOP_Drills` text DEFAULT NULL,
  `Wind` text DEFAULT NULL,
  `Sea` text DEFAULT NULL,
  `Weather` text DEFAULT NULL,
  `DSLTA` text DEFAULT NULL,
  `Safety_Meeting` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mud_data`
--

CREATE TABLE `mud_data` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `Weight_PCF` text DEFAULT NULL,
  `Funnel_SEC` text DEFAULT NULL,
  `FiltrateWL_HTHP` text DEFAULT NULL,
  `FiltrateWL_API` text DEFAULT NULL,
  `PV` text DEFAULT NULL,
  `YP` text DEFAULT NULL,
  `Electrical_Stability_Volts` text DEFAULT NULL,
  `RPM_3_6` text DEFAULT NULL,
  `Gels_Sec_Min` text DEFAULT NULL,
  `PH` text DEFAULT NULL,
  `CA_PPM` text DEFAULT NULL,
  `CL_PPM` text DEFAULT NULL,
  `FL_Temp` text DEFAULT NULL,
  `Cake_HTHP` text DEFAULT NULL,
  `Cake_API` text DEFAULT NULL,
  `Water_Vol` text DEFAULT NULL,
  `Oil_Vol` text DEFAULT NULL,
  `Solids_Vol` text DEFAULT NULL,
  `Sand_Vol` text DEFAULT NULL,
  `LGS` text DEFAULT NULL,
  `MBT` text DEFAULT NULL,
  `Mud_type` text DEFAULT NULL,
  `PPT_Spurt` text DEFAULT NULL,
  `PPT_Total` text DEFAULT NULL,
  `Water_Well` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mud_treatment`
--

CREATE TABLE `mud_treatment` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `material` varchar(200) DEFAULT NULL,
  `quantity` varchar(200) DEFAULT NULL,
  `unit` varchar(200) DEFAULT NULL,
  `MUD_TREATMENT` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `multiple_files`
--

CREATE TABLE `multiple_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reg_name` varchar(191) NOT NULL,
  `sec_name` varchar(191) NOT NULL,
  `file_path` varchar(191) NOT NULL,
  `upload_date` date NOT NULL,
  `is_parsed` tinyint(4) NOT NULL DEFAULT 0,
  `third_table_parsed` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `secret` varchar(100) NOT NULL,
  `redirect` text NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) NOT NULL,
  `access_token_id` varchar(100) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `other_data_table`
--

CREATE TABLE `other_data_table` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `comment` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `out_of_scops`
--

CREATE TABLE `out_of_scops` (
  `id` bigint(200) NOT NULL,
  `file_id` bigint(200) DEFAULT NULL,
  `From_To` text DEFAULT NULL,
  `Hrs` text DEFAULT NULL,
  `Cum_Hrs` text DEFAULT NULL,
  `Doos_Id` text DEFAULT NULL,
  `Category` text DEFAULT NULL,
  `Type` text DEFAULT NULL,
  `Out_Summary` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `repair_table`
--

CREATE TABLE `repair_table` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `Instrumentation` text DEFAULT NULL,
  `Other` text DEFAULT NULL,
  `Reporter` text DEFAULT NULL,
  `Computer` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `saved_queries`
--

CREATE TABLE `saved_queries` (
  `id` int(11) NOT NULL,
  `name` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `reg_names` text DEFAULT NULL,
  `query_text` text NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `saved_quiries`
--

CREATE TABLE `saved_quiries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `query_text` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `second_table`
--

CREATE TABLE `second_table` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `Depth` text DEFAULT NULL,
  `Last_24_hr_operations` text DEFAULT NULL,
  `Next_24_hr_plan` text DEFAULT NULL,
  `Location` text DEFAULT NULL,
  `next_location` text DEFAULT NULL,
  `Days_Since_Spud_and_Date` text DEFAULT NULL,
  `Formation_tops` text DEFAULT NULL,
  `Prev_Depth` text DEFAULT NULL,
  `Depth_Comments` text DEFAULT NULL,
  `Liner_Size_TOL_MD_TVD` text DEFAULT NULL,
  `Last_Csg_Size_MD_TVD` text DEFAULT NULL,
  `Footage` text DEFAULT NULL,
  `Distance_from_DHA` text DEFAULT NULL,
  `Circ` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `third_table`
--

CREATE TABLE `third_table` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `Hrs` text DEFAULT NULL,
  `From_To` text DEFAULT NULL,
  `Lateral` text DEFAULT NULL,
  `Hole_size` text DEFAULT NULL,
  `Cat` text DEFAULT NULL,
  `Major_OP` text DEFAULT NULL,
  `Action` text DEFAULT NULL,
  `Object` text DEFAULT NULL,
  `Resp_Co` text DEFAULT NULL,
  `Hole_depth` text DEFAULT NULL,
  `Event_depth` text DEFAULT NULL,
  `Summary_of_Operations` text DEFAULT NULL,
  `LT_TYPE` text DEFAULT NULL,
  `LT_ID` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `trucks`
--

CREATE TABLE `trucks` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` int(10) UNSIGNED NOT NULL,
  `truck` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) NOT NULL,
  `mac_address` varchar(500) DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `package` varchar(300) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `google2fa_secret` text DEFAULT NULL,
  `google2fa_enabled` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `zip_files`
--

CREATE TABLE `zip_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file_name` varchar(191) NOT NULL,
  `file_path` varchar(191) NOT NULL,
  `upload_date` date NOT NULL,
  `is_parsed` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bit_data`
--
ALTER TABLE `bit_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `bulks`
--
ALTER TABLE `bulks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);
ALTER TABLE `companies` ADD FULLTEXT KEY `Company` (`Company`);

--
-- Indexes for table `drill_string`
--
ALTER TABLE `drill_string`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `drill_string_floats`
--
ALTER TABLE `drill_string_floats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `first_table`
--
ALTER TABLE `first_table`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `fourth_table`
--
ALTER TABLE `fourth_table`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `lost_time_details`
--
ALTER TABLE `lost_time_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `mail_configs`
--
ALTER TABLE `mail_configs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mail_configs_email_unique` (`email`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `miscellaneous`
--
ALTER TABLE `miscellaneous`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `mud_data`
--
ALTER TABLE `mud_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `mud_treatment`
--
ALTER TABLE `mud_treatment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `multiple_files`
--
ALTER TABLE `multiple_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `upload_date` (`upload_date`),
  ADD KEY `reg_name` (`reg_name`),
  ADD KEY `sec_name` (`sec_name`);

--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);

--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indexes for table `other_data_table`
--
ALTER TABLE `other_data_table`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `out_of_scops`
--
ALTER TABLE `out_of_scops`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `repair_table`
--
ALTER TABLE `repair_table`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);

--
-- Indexes for table `saved_queries`
--
ALTER TABLE `saved_queries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `saved_quiries`
--
ALTER TABLE `saved_quiries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `second_table`
--
ALTER TABLE `second_table`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`),
  ADD KEY `footage` (`file_id`,`Footage`(100));

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `third_table`
--
ALTER TABLE `third_table`
  ADD PRIMARY KEY (`id`),
  ADD KEY `file_id` (`file_id`);
ALTER TABLE `third_table` ADD FULLTEXT KEY `Hole_depth` (`Hole_depth`);
ALTER TABLE `third_table` ADD FULLTEXT KEY `Hole_depth_2` (`Hole_depth`);

--
-- Indexes for table `trucks`
--
ALTER TABLE `trucks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `zip_files`
--
ALTER TABLE `zip_files`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bit_data`
--
ALTER TABLE `bit_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bulks`
--
ALTER TABLE `bulks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `drill_string`
--
ALTER TABLE `drill_string`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `drill_string_floats`
--
ALTER TABLE `drill_string_floats`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `first_table`
--
ALTER TABLE `first_table`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fourth_table`
--
ALTER TABLE `fourth_table`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lost_time_details`
--
ALTER TABLE `lost_time_details`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mail_configs`
--
ALTER TABLE `mail_configs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `miscellaneous`
--
ALTER TABLE `miscellaneous`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mud_data`
--
ALTER TABLE `mud_data`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mud_treatment`
--
ALTER TABLE `mud_treatment`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `multiple_files`
--
ALTER TABLE `multiple_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `other_data_table`
--
ALTER TABLE `other_data_table`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `out_of_scops`
--
ALTER TABLE `out_of_scops`
  MODIFY `id` bigint(200) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `repair_table`
--
ALTER TABLE `repair_table`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `saved_queries`
--
ALTER TABLE `saved_queries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `saved_quiries`
--
ALTER TABLE `saved_quiries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `second_table`
--
ALTER TABLE `second_table`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `third_table`
--
ALTER TABLE `third_table`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `trucks`
--
ALTER TABLE `trucks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `zip_files`
--
ALTER TABLE `zip_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!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 */;
