-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `switchmadeag`
--

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

--
-- Table structure for table `company_letterhead`
--

CREATE TABLE `company_letterhead` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_size` float NOT NULL,
  `upload_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `company_letterhead`
--

INSERT INTO `company_letterhead` (`id`, `file_name`, `file_path`, `file_size`, `upload_date`) VALUES
(1, 'SWITCH-MADE AFRICA.docx', 'uploads/SWITCH-MADE AFRICA.docx', 0.17, '2024-07-18 10:36:19'),
(2, 'SWITCH-MADE DUBAI.docx', 'uploads/SWITCH-MADE DUBAI.docx', 0.17, '2024-07-18 10:36:42'),
(3, 'SWITCH-MADE FRANCE .docx', 'uploads/SWITCH-MADE FRANCE .docx', 0.24, '2024-07-18 10:39:19'),
(4, 'SWITCH-MADE FZ LLC-.docx', 'uploads/SWITCH-MADE FZ LLC-.docx', 0.1, '2024-07-18 10:39:27'),
(5, 'SWITCH-MADE GROUP.docx', 'uploads/SWITCH-MADE GROUP.docx', 0.17, '2024-07-18 10:39:34'),
(6, 'SWITCH-MADE QFC.docx', 'uploads/SWITCH-MADE QFC.docx', 0.24, '2024-07-18 10:39:41');

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

--
-- Table structure for table `company_profile`
--

CREATE TABLE `company_profile` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_size` float NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `upload_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `company_profile`
--

INSERT INTO `company_profile` (`id`, `file_name`, `file_size`, `file_path`, `upload_date`) VALUES
(2, 'SWITCH MADE 2023 FRENCH V2.pdf', 13.43, 'uploads/SWITCH MADE 2023 FRENCH V2.pdf', '2024-07-18 12:49:34'),
(3, 'SWITCH MADE 2023 ENGLISH V2.pdf', 13.44, 'uploads/SWITCH MADE 2023 ENGLISH V2.pdf', '2024-07-18 12:49:57'),
(5, 'Switch Made Middle East - ISO 9001 2015.pdf', 0.07, 'uploads/Switch Made Middle East - ISO 9001 2015.pdf', '2024-07-18 13:11:16');

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

--
-- Table structure for table `deletedrecords`
--

CREATE TABLE `deletedrecords` (
  `DeletedID` int(11) NOT NULL,
  `ProductID` int(11) NOT NULL,
  `SMProductCode` varchar(255) DEFAULT NULL,
  `ProductReference` varchar(255) DEFAULT NULL,
  `ProductName` varchar(255) DEFAULT NULL,
  `ProductPicture` varchar(255) DEFAULT NULL,
  `ProductOutline` varchar(255) DEFAULT NULL,
  `LedType` varchar(255) DEFAULT NULL,
  `SystemPower` varchar(255) DEFAULT NULL,
  `LumminareEfficacy` varchar(255) DEFAULT NULL,
  `LumenOutput` varchar(255) DEFAULT NULL,
  `Lifetime` varchar(255) DEFAULT NULL,
  `LuminaireType` varchar(255) DEFAULT NULL,
  `LOR` varchar(255) DEFAULT NULL,
  `UGR` varchar(255) DEFAULT NULL,
  `CCT` varchar(255) DEFAULT NULL,
  `BeamAngle` varchar(255) DEFAULT NULL,
  `CRI` varchar(255) DEFAULT NULL,
  `McAdamsSDCM` varchar(255) DEFAULT NULL,
  `IPRating` varchar(255) DEFAULT NULL,
  `IKRating` varchar(255) DEFAULT NULL,
  `Dimension` varchar(255) DEFAULT NULL,
  `MountingType` varchar(255) DEFAULT NULL,
  `Adjustability` varchar(255) DEFAULT NULL,
  `BodyMaterial` varchar(255) DEFAULT NULL,
  `ReflectorAndOptics` varchar(255) DEFAULT NULL,
  `Diffuser` varchar(255) DEFAULT NULL,
  `DriverMountingType` varchar(255) DEFAULT NULL,
  `Dimming` varchar(255) DEFAULT NULL,
  `DiverVoltage` varchar(255) DEFAULT NULL,
  `DMXDecoder` varchar(255) DEFAULT NULL,
  `Notes` text DEFAULT NULL,
  `UserID` int(11) DEFAULT NULL,
  `DeletedAt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `driverdetails`
--

CREATE TABLE `driverdetails` (
  `ProductID` int(11) DEFAULT NULL,
  `DriverMountingType` varchar(255) DEFAULT NULL,
  `Dimming` varchar(255) DEFAULT NULL,
  `DiverVoltage` varchar(255) DEFAULT NULL,
  `DMXDecoder` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `driverdetails`
--

INSERT INTO `driverdetails` (`ProductID`, `DriverMountingType`, `Dimming`, `DiverVoltage`, `DMXDecoder`, `user_id`) VALUES
(22, 'Integrated', 'DALI', 'Constant Current', 'Inbuilt', 1),
(23, 'Integrated', 'DALI', 'Constant Current', 'Inbuilt', 1),
(24, 'Integrated', 'DALI', 'Constant Current', 'Inbuilt', 1),
(25, 'Remote', 'DALI', 'Constant Current', 'Inbuilt', 2),
(26, 'Integrated', 'DALI', 'Constant Current', 'Inbuilt', 2),
(27, 'Integrated', 'DALI', 'Constant Current', 'Inbuilt', 3),
(28, 'Remote', 'DALI', 'Constant Voltage – 12 VDC', 'N/A', 4);

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

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `ClaimID` int(11) NOT NULL,
  `EmployeeName` varchar(255) DEFAULT NULL,
  `EmployeeEmail` varchar(255) DEFAULT NULL,
  `Department` varchar(255) DEFAULT NULL,
  `MonthClaiming` varchar(255) DEFAULT NULL,
  `CompanyEntity` varchar(255) DEFAULT NULL,
  `Currency` varchar(255) DEFAULT NULL,
  `DateSubmitted` datetime DEFAULT current_timestamp(),
  `ItemDescription` varchar(255) DEFAULT NULL,
  `ExpenseCategory` varchar(255) DEFAULT NULL,
  `Amount` varchar(255) DEFAULT NULL,
  `GrandTotal` varchar(255) DEFAULT NULL,
  `UserID` int(11) DEFAULT NULL,
  `Items` text DEFAULT NULL,
  `Files` text DEFAULT NULL,
  `Status` varchar(50) DEFAULT 'Pending',
  `Comments` text DEFAULT NULL,
  `ReviewedBy` varchar(100) DEFAULT NULL,
  `ReviewDate` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` (`ClaimID`, `EmployeeName`, `EmployeeEmail`, `Department`, `MonthClaiming`, `CompanyEntity`, `Currency`, `DateSubmitted`, `ItemDescription`, `ExpenseCategory`, `Amount`, `GrandTotal`, `UserID`, `Items`, `Files`, `Status`, `Comments`, `ReviewedBy`, `ReviewDate`) VALUES
(21, 'Lyanne Tiamsim Revuelta', 'ltiamsim@switch-made.com', 'Sales', 'January', 'SM Middle East', 'USD', '2024-07-02 10:00:19', NULL, NULL, NULL, '59.00', 9, '[{\"description\":\"e\"},{\"category\":\"Utility\"},{\"amount\":\"2\"},{\"description\":\"ee\"},{\"category\":\"Utility\"},{\"amount\":\"33\"},{\"description\":\"ee\"},{\"category\":\"Utility\"},{\"amount\":\"24\"}]', '[\"uploads\\/CEILING RECESSED SPOTLIGHT.pdf\"]', 'Declined', '', 'agatbunton@switch-made.com', '2024-07-02 13:42:58'),
(23, 'Lyanne Tiamsim Revuelta', 'ltiamsim@switch-made.com', 'Sales', 'January', 'SM Middle East', 'USD', '2024-07-02 11:08:43', NULL, NULL, NULL, '14.00', 9, '[{\"description\":\"Mouse\"},{\"category\":\"Utility\"},{\"amount\":\"2\"},{\"description\":\"TAXI \"},{\"category\":\"Transportation\"},{\"amount\":\"12\"}]', '[\"uploads\\/A9pkpyov_1aiumir_wmc.pdf\"]', 'Approved', '', 'ltiamsim@switch-made.com', '2024-07-03 06:44:03'),
(26, 'Lyanne Tiamsim Revuelta', 'ltiamsim@switch-made.com', 'Accounts', 'May', 'SM Middle East', 'AED', '2024-07-02 15:07:26', NULL, NULL, NULL, '3632.00', 9, '[{\"description\":\"TEST 1\"},{\"category\":\"Others\"},{\"amount\":\"1234\"},{\"description\":\"TEST 2\"},{\"category\":\"Advertising\"},{\"amount\":\"2398\"}]', '[\"uploads\\/mig 1 r.pdf\"]', 'Pending', NULL, NULL, '2024-07-02 13:09:28'),
(27, 'Lyanne Tiamsim Revuelta', 'ltiamsim@switch-made.com', 'Sales', 'January', 'SM Middle East', 'USD', '2024-07-02 15:43:03', NULL, NULL, NULL, '4697.00', 9, '[{\"description\":\"TEST 1\"},{\"category\":\"Client Gifts\"},{\"amount\":\"252\"},{\"description\":\"TEST 2\"},{\"category\":\"Travel Expenses\"},{\"amount\":\"4445\"}]', '[\"uploads\\/Ceiling Recessed Downlight IP-Rated.pdf\",\"uploads\\/CEILING RECESSED SPOTLIGHT.pdf\",\"uploads\\/chrome.pdf\",\"uploads\\/D1.pdf\"]', 'Pending', NULL, NULL, '2024-07-02 13:09:28'),
(28, 'Lyanne Tiamsim Revuelta', 'ltiamsim@switch-made.com', 'Sales', 'January', 'SM Middle East', 'USD', '2024-07-02 15:57:15', NULL, NULL, NULL, '1234.00', 9, '[{\"description\":\"Mouse\"},{\"category\":\"Fuel Costs\"},{\"amount\":\"1234\"}]', '[\"uploads\\/View Expense.pdf\"]', 'Pending', NULL, NULL, '2024-07-02 13:09:28'),
(31, 'Jeremy Loisel', 'jloisel@switch-made.com', 'Sales', 'January', 'SM Middle East', 'QAR', '2024-07-03 14:30:42', NULL, NULL, NULL, '12312.00', 10, '[{\"description\":\"Mouse\"},{\"category\":\"Office Supplies\"},{\"amount\":\"12312\"}]', '[\"uploads\\/gas-fuel-receipt-sample.jpg\"]', 'Pending', NULL, NULL, '2024-07-03 10:30:42'),
(34, 'Mohammad Ageeb Mohammad Faisal', 'mageeb@switch-made.com', 'Design', 'August', 'SM Middle East', 'AED', '2024-07-03 16:28:25', NULL, NULL, NULL, '4435.00', 8, '[{\"description\":\"Mouse\"},{\"category\":\"Utility\"},{\"amount\":\"4435\"}]', '[\"uploads\\/gas-fuel-receipt-sample.jpg\"]', 'Pending', NULL, NULL, '2024-07-03 12:28:25'),
(35, 'Janette Pascual', 'jpascal@switch-made.com', 'Supply Chain', 'May', 'SM Middle East', 'AED', '2024-07-03 16:29:11', NULL, NULL, NULL, '546.00', 12, '[{\"description\":\"TAXI \"},{\"category\":\"Transportation\"},{\"amount\":\"546\"}]', '[\"uploads\\/gas-fuel-receipt-sample.jpg\"]', 'Pending', NULL, NULL, '2024-07-03 12:29:11'),
(37, 'Eduard Mekeres', 'emekeres@switch-made.com', 'Sales', 'January', 'SM Middle East', 'QAR', '2024-07-03 16:31:20', NULL, NULL, NULL, '5353.00', 4, '[{\"description\":\"TEST 1\"},{\"category\":\"Postage & Shipping\"},{\"amount\":\"5353\"}]', '[\"uploads\\/gas-fuel-receipt-sample.jpg\"]', 'Pending', NULL, NULL, '2024-07-03 12:31:20');

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

--
-- Table structure for table `generaldetails`
--

CREATE TABLE `generaldetails` (
  `ProductID` int(11) DEFAULT NULL,
  `CCT` varchar(255) DEFAULT NULL,
  `BeamAngle` varchar(255) DEFAULT NULL,
  `CRI` varchar(255) DEFAULT NULL,
  `McAdamsSDCM` varchar(255) DEFAULT NULL,
  `IPRating` varchar(255) DEFAULT NULL,
  `IKRating` varchar(255) DEFAULT NULL,
  `Dimension` varchar(255) DEFAULT NULL,
  `MountingType` varchar(255) DEFAULT NULL,
  `Adjustability` varchar(255) DEFAULT NULL,
  `BodyMaterial` varchar(255) DEFAULT NULL,
  `ReflectorAndOptics` varchar(255) DEFAULT NULL,
  `Diffuser` varchar(255) DEFAULT NULL,
  `LuminaireType` varchar(255) DEFAULT NULL,
  `LOR` varchar(255) DEFAULT NULL,
  `UGR` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `generaldetails`
--

INSERT INTO `generaldetails` (`ProductID`, `CCT`, `BeamAngle`, `CRI`, `McAdamsSDCM`, `IPRating`, `IKRating`, `Dimension`, `MountingType`, `Adjustability`, `BodyMaterial`, `ReflectorAndOptics`, `Diffuser`, `LuminaireType`, `LOR`, `UGR`, `user_id`) VALUES
(22, '4000K', '120 Degree', '80', '≤4', 'IP20', 'IK10', '125x152x12', 'Ceiling Recessed', 'Fixed', 'White', 'Opal', 'Opal', 'Down Light', '12', '9', 1),
(23, '3000K', '120 Degree', '80', '≤4', 'IP20', 'IK10', '125x152x12', 'Ceiling Recessed', 'Fixed', 'White', 'Opal', 'Opal', 'Panel Light', '12%', '6', 1),
(24, '4000K', '130 Degree', '80', '≤4', 'IP20', 'IK10', '125x152x12', 'Ceiling Suspended', 'Adjustable', 'White', 'Opal', 'Opal', 'Down Light Wallwasher', '18%', '6', 1),
(25, '3000K', '130 Degree', '80', '≤3', 'IP20', 'IK10', '125x152x12', 'Ceiling Surface', 'Adjustable', 'Black', 'Opal', 'Prismatic', 'Down Light', '12', '6', 2),
(26, '4000K', '130 Degree', '80', '≤2', 'IP20', 'IK10', '125x152x12', 'Ceiling Recessed', 'Fixed', 'White', 'Opal', 'Opal', 'Spot Light', '18%', '6', 2),
(27, '4000K', '120 Degree', '80', '≤5', 'IP20', 'IK10', '125x152x12', 'Ceiling Recessed', 'Fixed', 'White', 'Opal', 'Opal', 'Down Light Wallwasher', '18%', '6', 3),
(28, '3000K', '120D', '>70', 'N/A', 'IP68', 'N/A', 'L48 x H8.8 mm', 'Surface Mounted', 'N/A', 'White', 'PC Lens', 'Clear', 'LED Module', 'N/A', 'N/A', 4);

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

--
-- Table structure for table `interactive_catalogues`
--

CREATE TABLE `interactive_catalogues` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_size` decimal(10,2) NOT NULL,
  `upload_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interactive_catalogues`
--

INSERT INTO `interactive_catalogues` (`id`, `file_name`, `file_path`, `file_size`, `upload_date`) VALUES
(9, 'CE-CRUG.pdf', 'uploads/CE-CRUG.pdf', 0.75, '2024-07-18 12:25:23');

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

--
-- Table structure for table `itinventory`
--

CREATE TABLE `itinventory` (
  `ID` int(11) NOT NULL,
  `DeviceSerialNumber` varchar(100) NOT NULL,
  `DeviceName` varchar(100) NOT NULL,
  `Description` text NOT NULL,
  `Vendor` varchar(100) NOT NULL,
  `WhoIsUsing` varchar(100) NOT NULL,
  `Department` varchar(100) NOT NULL,
  `Status` varchar(50) NOT NULL,
  `Comments` text DEFAULT NULL,
  `Archived` tinyint(1) DEFAULT 0,
  `CreatedAt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `itinventory`
--

INSERT INTO `itinventory` (`ID`, `DeviceSerialNumber`, `DeviceName`, `Description`, `Vendor`, `WhoIsUsing`, `Department`, `Status`, `Comments`, `Archived`, `CreatedAt`) VALUES
(1, 'SMPC0001', 'ASUS ROG ZEPHYRUS', 'GAMING LAPTOP', 'Asus', 'Aldrich Gatbunton', 'Design / Marketing', 'In-use', 'NONE', 0, '2024-07-16 05:42:25'),
(2, 'SMPC0002', 'System Unit', 'Shine\'s Old PC unit', 'Corsair', 'None', 'Design / Marketing', 'Not in use', 'Kept in the office storage area. Working properly.', 0, '2024-07-16 07:28:45'),
(3, 'SMPC0003', 'HP PAVILLION BLK', 'None', 'HP', 'Corentin Raud', 'Sales', 'In-use', 'Brand New Laptop GIven to Corentin', 0, '2024-07-16 07:38:00'),
(4, 'SMPC0004', 'HP PAVILLION BLK', 'None', 'HP', 'None', 'Sales', 'Not in use', 'Alicia Zamit\'s Previous Laptop', 0, '2024-07-16 07:38:59'),
(5, 'SMPC0005', 'HP PAVILLION BLK', 'None', 'HP', 'None', 'Sales', 'Not in use', 'New Sales Laptop / Currently with Accounts Department Cabinet', 0, '2024-07-16 07:43:53'),
(6, 'SMPC0006', 'HP PAVILLION BLK', 'None', 'HP', 'Shrinidhi Shetty', 'HR & Accounts', 'In-use', 'EA\'s Laptop (Myriam\'s Previous Laptop)', 0, '2024-07-16 07:45:00'),
(7, 'SMPC0007', 'HP PAVILLION SLV', 'None', 'HP', 'Lyanne Tiamsim', 'HR & Accounts', 'In-use', 'New laptop given to accounts', 0, '2024-07-16 07:45:53'),
(8, 'SMPC0008', 'HP PAVILLION SLV', 'None', 'HP', 'Janette Pascual', 'Supply Chain', 'In-use', 'Previously used by Sales (Zain)', 0, '2024-07-16 07:46:49'),
(9, 'SMPC0009', 'HP PAVILLION BLK', 'None', 'HP', 'Shiju Varghese', 'Supply Chain', 'In-use', 'Previously used by Sales (Ranjith)', 0, '2024-07-16 07:47:33'),
(10, 'SMPC0010', 'HP PAVILLION SLV', 'None', 'HP', 'None', 'Supply Chain', 'Not in use', 'Ridwan\'s Old Laptop', 1, '2024-07-16 07:48:41'),
(11, 'SMPC0011', 'HP Omen Gaming Laptop', 'None', 'HP', 'Asif Rahman', 'Technical', 'In-use', 'Musheer\'s Old PC that was passed to Ageeb after.', 0, '2024-07-16 07:49:53'),
(12, 'SMPC0012', 'HP Omen Gaming Laptop', 'Spare', 'HP', 'None', 'Technical', 'Not in use', 'Ageeb\'s Old Laptop. Used for Lighting Programming', 0, '2024-07-16 07:51:38'),
(13, 'SMPC0013', 'ASUS ROG ZEPHYRUS', 'New Design Team Laptop | Latest ROG Model', 'Asus', 'Mohammad Ageeb Mohammad Faisal', 'Technical', 'In-use', 'None', 0, '2024-07-16 07:56:40'),
(14, 'SMSC0001', '27\" Monitor', '27\" Monitor, includes, VGA Cable', 'Samsung', 'Aldrich Gatbunton', 'Design / Marketing', 'In-use', 'Brand New Monitor | First Tag', 0, '2024-07-16 07:58:36'),
(15, 'SMSC0002', '24\" Monitor', 'Old Monitor', 'Samsung', 'None', 'Design / Marketing', 'Damaged', 'Finance Manager\'s Old Monitor', 0, '2024-07-16 08:01:16'),
(16, 'SMSC0003', '24\" Monitor', 'None', 'HP', 'Shiju Varghese', 'Supply Chain', 'In-use', 'None', 0, '2024-07-16 08:02:10'),
(17, 'SMSC0004', '25\" Monitor', 'Spare monitor sitting in the supply chain department', 'HP', 'None', 'Supply Chain', 'Not in use', 'Spare monitor sitting in the supply chain department', 0, '2024-07-16 08:03:29'),
(18, 'SMSC0005', '24\" Curved Monitor', 'Currently used by Margaux', 'Samsung', 'None', 'HR & Accounts', 'In-use', 'Margaux Monitor', 0, '2024-07-16 08:04:48'),
(19, 'SMSC0006', '24\" Monitor', 'With HDMI Cable (UGREEN)', 'Samsung', 'Janette Pascual', 'Supply Chain', 'In-use', 'Old Monitor in the reception', 0, '2024-07-16 08:06:10'),
(20, 'SMSC0007', '20\" Monitor', 'Sales Spare Monitor', 'HP', 'None', 'Sales', 'Not in use', 'Sales Spare Monitor', 0, '2024-07-16 08:06:59'),
(21, 'SMSC0008', '27\" Monitor', 'None', 'BENQ', 'Corentin Raud', 'Sales', 'In-use', 'Jeremy B\'s old monitor', 0, '2024-07-16 08:08:14'),
(22, 'SMSC0009', '20\" Monitor', 'Spare', 'Samsung', 'None', 'Sales', 'Not in use', 'Spare Monitor | Used in CCTV', 0, '2024-07-16 08:09:24'),
(23, 'SMSC0010', '22\" Monitor', 'Spare', 'Samsung', 'None', 'Sales', 'Not in use', 'Spare', 0, '2024-07-16 08:10:19'),
(24, 'SMSC0011', '24\" Monitor', 'None', 'Samsung', 'Shrinidhi Shetty', 'HR & Accounts', 'In-use', 'None', 0, '2024-07-16 08:10:57'),
(25, 'SMSC0012', '27\" Monitor', 'Shine\'s Old Monitor', 'Samsung', 'Lyanne Tiamsim', 'HR & Accounts', 'In-use', 'None', 0, '2024-07-16 08:11:44'),
(26, 'SMSC0013', '27\" Monitor', 'Spare Monitor', 'LG', 'None', 'Technical', 'Not in use', 'Spare', 0, '2024-07-16 08:19:12'),
(27, 'SMSC0014', '27\" Monitor', 'None', 'HP', 'Asif Rahman', 'Technical', 'In-use', 'None', 0, '2024-07-16 08:19:48'),
(28, 'SMSC0014', '27\" Monitor', 'None', 'Samsung', 'Mohammad Ageeb Mohammad Faisal', 'Technical', 'In-use', 'None', 0, '2024-07-16 08:20:46'),
(29, 'SMSC0015', '24\" Monitor', 'None', 'Samsung', 'Jeremy Loisel', 'CEO Office', 'In-use', 'None', 0, '2024-07-16 08:21:59'),
(30, 'SMPH0001', 'iPhone XS Gold', 'Matthieu\'s Old Phone ', 'Apple', 'Lyanne Tiamsim', 'HR & Accounts', 'In-use', 'Broken Back Glass / Earpiece Problem', 0, '2024-07-16 08:23:39'),
(31, 'SMPH0002', 'iPhone SE White', 'None', 'Apple', 'Shrinidhi Shetty', 'HR & Accounts', 'In-use', 'None', 0, '2024-07-16 08:25:16'),
(32, 'SMPH0003', 'iPhone SE Product Red', 'None', 'Apple', 'Corentin Raud', 'Sales', 'In-use', 'None', 0, '2024-07-16 08:26:11'),
(33, 'SMPH0004', 'iPhone XR 256 GB WHT', 'None', 'Apple', 'Janette Pascual', 'Supply Chain', 'In-use', 'None', 0, '2024-07-16 08:27:37'),
(34, 'SMPH0005', 'iPhone 12 Pro Pacific Blue', 'None', 'Apple', 'Mohammad Ageeb Mohammad Faisal', 'Technical', 'In-use', 'None', 0, '2024-07-16 08:28:16'),
(35, 'SMPH0006', 'IPhone SE 128 GB Space Grey', 'None', 'Apple', 'Shiju Varghese', 'Supply Chain', 'In-use', 'None', 0, '2024-07-16 08:29:02');

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

--
-- Table structure for table `it_supplies_requests`
--

CREATE TABLE `it_supplies_requests` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `department` varchar(255) NOT NULL,
  `item` varchar(255) NOT NULL,
  `quantity` int(11) NOT NULL,
  `reason` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `request_date` datetime NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `approval_status` enum('Pending','Approved','Declined') DEFAULT 'Pending',
  `approved_by` varchar(255) DEFAULT NULL,
  `comments` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `it_supplies_requests`
--

INSERT INTO `it_supplies_requests` (`id`, `user_id`, `username`, `fullname`, `department`, `item`, `quantity`, `reason`, `image`, `link`, `request_date`, `price`, `approval_status`, `approved_by`, `comments`) VALUES
(27, 3, 'dpasquier@switch-made.com', 'David Pasquier', 'France Sales', 'Printer', 2, 'new', 'uploads/LED-MODULE--outline-3.jpg', '', '2024-07-18 08:13:29', 4678.00, 'Approved', 'agatbunton@switch-made.com', 's'),
(28, 6, 'dloisel@switch-made.com', 'Dimitri Loisel', 'France Sales', 'Printer', 1, 'ssd', 'uploads/SOLA-Q copy.jpg', '', '2024-07-18 09:10:23', 4000.00, 'Declined', 'agatbunton@switch-made.com', 'd'),
(29, 5, 'craud@switch-made.com', 'Corentin Raud', 'Sales', 'Phone Case', 1, 'daser', 'uploads/LED-MODULE-3.jpg', '', '2024-07-18 09:32:55', 5000.00, 'Approved', 'agatbunton@switch-made.com', 'sdss');

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

--
-- Table structure for table `leaverequests`
--

CREATE TABLE `leaverequests` (
  `LeaveID` int(11) NOT NULL,
  `UserID` int(11) DEFAULT NULL,
  `EmployeeName` varchar(255) NOT NULL,
  `EmployeeEmail` varchar(255) NOT NULL,
  `Department` varchar(255) NOT NULL,
  `DatesRequesting` text NOT NULL,
  `Comment` text DEFAULT NULL,
  `UseVacationTime` enum('Yes','No') DEFAULT 'No',
  `LeaveStatus` varchar(255) NOT NULL,
  `SupervisorComment` text DEFAULT NULL,
  `DateSubmitted` timestamp NOT NULL DEFAULT current_timestamp(),
  `StartDate` date DEFAULT NULL,
  `EndDate` date DEFAULT NULL,
  `MedicalCertificate` varchar(255) DEFAULT NULL,
  `NumberOfDays` decimal(10,2) DEFAULT NULL,
  `HalfDay` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `leaverequests`
--

INSERT INTO `leaverequests` (`LeaveID`, `UserID`, `EmployeeName`, `EmployeeEmail`, `Department`, `DatesRequesting`, `Comment`, `UseVacationTime`, `LeaveStatus`, `SupervisorComment`, `DateSubmitted`, `StartDate`, `EndDate`, `MedicalCertificate`, `NumberOfDays`, `HalfDay`) VALUES
(55, 4, 'Eduard Mekeres', 'emekeres@switch-made.com', 'Sales', '2024-07-05 to 2024-07-06', 'Annual Leave', 'Yes', 'Pending', NULL, '2024-07-05 10:34:44', '2024-07-05', '2024-07-06', NULL, 1.00, 0),
(56, 5, 'Corentin Raud', 'craud@switch-made.com', 'Sales', '2024-07-05 to 2024-07-05', 'Annual Leave', 'Yes', 'Pending', NULL, '2024-07-05 10:35:01', '2024-07-05', '2024-07-05', NULL, 1.00, 0),
(57, 12, 'Janette Pascual', 'jpascal@switch-made.com', 'Supply Chain', '2024-07-06 to 2024-07-08', 'Annual Leave', 'Yes', 'Approved', 'approved by JL', '2024-07-05 10:35:13', '2024-07-06', '2024-07-08', NULL, 1.00, 0),
(58, 9, 'Lyanne Tiamsim', 'ltiamsim@switch-made.com', 'HR Accounts', '2024-07-05 to 2024-07-09', 'Annual Leave', 'Yes', 'Approved', 'approve', '2024-07-05 10:35:27', '2024-07-05', '2024-07-09', NULL, 3.00, 0),
(59, 14, 'Shrinidhi Shetty', 'sshetty@switch-made.com', 'HR Accounts', '2024-07-05 to 2024-07-17', 'Annual Leave', 'Yes', 'Approved', 'Approved by JL', '2024-07-05 10:35:38', '2024-07-05', '2024-07-17', NULL, 9.00, 0),
(60, 11, 'Shiju Varghese', 'svarghese@switch-made.com', 'Supply Chain', '2024-07-04 to 2024-07-12', 'Annual Leave', 'Yes', 'Declined', 'S', '2024-07-05 10:35:57', '2024-07-04', '2024-07-12', NULL, 7.00, 0),
(62, 6, 'Dimitri Loisel', 'dloisel@switch-made.com', 'France Sales', '2024-07-05 to 2024-07-08', 'Annual Leave', 'Yes', 'Pending', NULL, '2024-07-05 10:37:02', '2024-07-05', '2024-07-08', NULL, 2.00, 0),
(63, 7, 'Catherine Ahouandjinou', 'cadjn@switch-made.com', 'Africa Sales', '2024-07-05 to 2024-07-09', 'Annual Leave', 'Yes', 'Pending', NULL, '2024-07-05 10:37:22', '2024-07-05', '2024-07-09', NULL, 3.00, 0),
(66, 1, 'Aldrich Gatbunton', 'agatbunton@switch-made.com', 'Design', '2024-07-15 to 2024-07-15', 'Sick Leave', 'Yes', 'Approved', 'Approve', '2024-07-15 09:54:33', '2024-07-15', '2024-07-15', 'uploads/AG Invoice July.pdf', 1.00, 0),
(74, 15, 'Asif Rahman', 'arahman@switch-made.com', 'Technical', '2024-07-15 to 2024-07-15', 'Annual Leave', 'Yes', 'Approved', 'Approved', '2024-07-15 10:35:59', '2024-07-15', '2024-07-15', '', 1.00, 0),
(75, 15, 'Asif Rahman', 'arahman@switch-made.com', 'Technical', '2024-07-15 to 2024-07-22', 'Annual Leave', 'Yes', 'LineManagerApproved', 'ssasa', '2024-07-15 12:59:07', '2024-07-15', '2024-07-22', NULL, 6.00, 0),
(76, 1, 'Aldrich Gatbunton', 'agatbunton@switch-made.com', 'Design', '2024-07-29 to 2024-08-05', 'Annual Leave', 'Yes', 'Pending', NULL, '2024-07-15 13:11:03', '2024-07-29', '2024-08-05', NULL, 6.00, 0),
(77, 3, 'David Pasquier', 'dpasquier@switch-made.com', 'France Sales', '2024-07-22 to 2024-07-22', 'Annual Leave', 'Yes', 'Pending', NULL, '2024-07-15 13:11:50', '2024-07-22', '2024-07-22', NULL, 1.00, 0),
(78, 13, 'Shinu Damodaran', 'sdamodaran@switch-made.com', 'Supply Chain', '2024-07-15 to 2024-07-22', 'Annual Leave', 'Yes', 'Pending', NULL, '2024-07-15 13:18:12', '2024-07-15', '2024-07-22', NULL, 6.00, 0),
(79, 8, 'Mohammad Ageeb Mohammad Faisal', 'mageeb@switch-made.com', 'Technical', '2024-07-15 to 2024-07-22', 'Annual Leave', 'Yes', 'Pending', NULL, '2024-07-15 13:19:02', '2024-07-15', '2024-07-22', NULL, 6.00, 0),
(80, 14, 'Shrinidhi Shetty', 'sshetty@switch-made.com', 'HR Accounts', '2024-07-16 to 2024-07-17', 'Sick Leave', 'Yes', 'Approved', 'APproved By JL', '2024-07-16 05:14:41', '2024-07-16', '2024-07-17', 'uploads/AG Invoice July.pdf', 2.00, 0);

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

--
-- Table structure for table `leddetails`
--

CREATE TABLE `leddetails` (
  `ProductID` int(11) DEFAULT NULL,
  `LedType` varchar(255) DEFAULT NULL,
  `SystemPower` varchar(255) DEFAULT NULL,
  `LumminareEfficacy` varchar(255) DEFAULT NULL,
  `LumenOutput` varchar(255) DEFAULT NULL,
  `Lifetime` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `leddetails`
--

INSERT INTO `leddetails` (`ProductID`, `LedType`, `SystemPower`, `LumminareEfficacy`, `LumenOutput`, `Lifetime`, `user_id`) VALUES
(22, 'COB', '10W', '180 lm/W', '2000 lm', '≥40,000 Hrs', 1),
(23, 'COB', '10W', '180 lm/W', '2000 lm', '≥40,000 Hrs', 1),
(24, 'COB', '10W', '180 lm/W', '2000 lm', '≥40,000 Hrs', 1),
(25, 'COB', '10W', '180 lm/W', '2000 lm', '≥50,000 Hrs', 2),
(26, 'COB', '10W', '180 lm/W', '2000 lm', '≥30,000 Hrs', 2),
(27, 'COB', '10W', '180 lm/W', '2000 lm', '≥40,000 Hrs', 3),
(28, 'SMD', '1.24 W Nominal / 1.30 W Maximum', '121lm/W @ 6500K', '635lm / Meter', '≥50,000 Hrs', 4);

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

--
-- Table structure for table `misc`
--

CREATE TABLE `misc` (
  `ProductID` int(11) DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `misc`
--

INSERT INTO `misc` (`ProductID`, `Notes`, `user_id`) VALUES
(22, '$stmt->bind_param(\"issssssssssssssssssssssssssssi\", \r\n    $productID, $SMProductCode, $ProductReference, $ProductName, \r\n    $ProductPicture, $ProductOutline, $LedType, $SystemPower, \r\n    $LumminareEfficacy, $LumenOutput, $Lifetime, $LuminaireType, \r\n   ', 1),
(23, 'Sign in with an administrator account\r\nTo sign in to admin.google.com, use an administrator account for a managed Google service, such as Google Workspace or Cloud Identity. Learn more about Google accounts', 1),
(24, 'Sign in with an administrator account\r\nTo sign in to admin.google.com, use an administrator account for a managed Google service, such as Google Workspace or Cloud Identity. Learn more about Google accounts', 1),
(25, 'rewrtewte', 2),
(26, 'dasfsadfdafasdfasdf', 2),
(27, 'joljljk', 3),
(28, 'N/A', 4);

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

--
-- Table structure for table `officesuppliesinventory`
--

CREATE TABLE `officesuppliesinventory` (
  `ID` int(11) NOT NULL,
  `SeriesNumber` varchar(50) NOT NULL,
  `ItemDescription` varchar(255) NOT NULL,
  `OpeningQuantity` int(11) NOT NULL,
  `Used` int(11) NOT NULL DEFAULT 0,
  `StockInOffice` int(11) NOT NULL DEFAULT 0,
  `StockInWarehouse` int(11) NOT NULL DEFAULT 0,
  `TotalAvailableStock` int(11) GENERATED ALWAYS AS (`OpeningQuantity` - `Used` + `StockInOffice` + `StockInWarehouse`) STORED,
  `Notes` text DEFAULT NULL,
  `Archived` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `officesuppliesinventory`
--

INSERT INTO `officesuppliesinventory` (`ID`, `SeriesNumber`, `ItemDescription`, `OpeningQuantity`, `Used`, `StockInOffice`, `StockInWarehouse`, `Notes`, `Archived`) VALUES
(23, '1', 'Success Stories Book V3 with USB', 500, 500, 18, 90, 'None', 0),
(24, '2', 'Stress Ball', 100, 100, 8, 0, 'None', 0),
(25, '3', 'Paper Bag', 1000, 1000, 220, 130, 'None', 0),
(26, '4', 'Sun Shade', 100, 100, 4, 0, 'None', 0),
(27, '5', 'Pencil', 1000, 1000, 390, 0, 'None', 0),
(28, '6', 'Old Note Pads (With Spring)', 500, 500, 35, 0, 'None / Address in the Notepad is an old address of SM', 0),
(29, '7', 'New Note Pads (Bind)', 500, 500, 12, 0, 'None', 0),
(30, '8', 'Packing Tape', 502, 502, 15, 206, 'None', 0),
(31, '9', 'USB Stick', 1500, 1500, 500, 0, 'Metal USB / Some were used to place inside the Success Stories Book', 0),
(32, '10', 'USB Box', 1000, 1000, 516, 0, 'None', 0),
(33, '11', 'Catalogue Sleeve', 500, 500, 15, 40, 'Extra for Success Stories Book cover V3', 0),
(34, '12', 'Connecting2Gulf Leaflet', 500, 500, 160, 0, 'None', 0),
(35, '13', 'Metal Plate (Big)', 10, 10, 7, 0, 'Used for luggages of cevon sample', 0),
(36, '14', 'Metal Plate (Small)', 10, 10, 7, 0, 'used for cevon sample luggage', 0),
(37, '15', 'Non-Wooven Bags (Eco Bags)', 1000, 1000, 150, 631, 'None', 0);

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

--
-- Table structure for table `org_chart`
--

CREATE TABLE `org_chart` (
  `id` int(11) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `upload_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `org_chart`
--

INSERT INTO `org_chart` (`id`, `file_path`, `upload_date`) VALUES
(1, 'uploads/ORG3.jpg', '2024-07-18 08:06:01'),
(2, 'uploads/download.jpg', '2024-07-18 08:06:09'),
(3, 'uploads/ORG3.jpg', '2024-07-18 08:06:17');

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

--
-- Table structure for table `presentation_templates`
--

CREATE TABLE `presentation_templates` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_size` float NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `upload_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `presentation_templates`
--

INSERT INTO `presentation_templates` (`id`, `file_name`, `file_size`, `file_path`, `upload_date`) VALUES
(2, 'SM PRESENTATION TEMPLATE V2.pptx', 0.54, 'uploads/SM PRESENTATION TEMPLATE V2.pptx', '2024-07-18 08:38:03'),
(3, 'SM PRESENTATION TEMPLATE GENERAL (SM LOGO ONLY).pptx', 0.59, 'uploads/SM PRESENTATION TEMPLATE GENERAL (SM LOGO ONLY).pptx', '2024-07-18 08:41:29'),
(4, 'SM PRESENTATION TEMPLATE GENERAL.pptx', 0.81, 'uploads/SM PRESENTATION TEMPLATE GENERAL.pptx', '2024-07-18 08:41:39'),
(5, 'SM PRESENTATION TEMPLATE V1.pptx', 0.77, 'uploads/SM PRESENTATION TEMPLATE V1.pptx', '2024-07-18 10:22:20');

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

--
-- Table structure for table `productdetails`
--

CREATE TABLE `productdetails` (
  `ProductID` int(11) NOT NULL,
  `SMProductCode` varchar(255) DEFAULT NULL,
  `ProductReference` varchar(255) DEFAULT NULL,
  `ProductPicture` varchar(255) DEFAULT NULL,
  `ProductOutline` varchar(255) DEFAULT NULL,
  `ProductName` varchar(255) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_archived` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `productdetails`
--

INSERT INTO `productdetails` (`ProductID`, `SMProductCode`, `ProductReference`, `ProductPicture`, `ProductOutline`, `ProductName`, `user_id`, `created_at`, `is_archived`) VALUES
(22, 'EXT02084', 'L01', 'ALDL0876-1.jpg', 'A9q8uyn3_1aiumhu_wmc.png', 'PIXEL ROUND', 1, '2024-06-28 10:52:30', 1),
(23, 'EXT02084', 'L01', 'ALDL0876-1.jpg', 'MINI REO II OK 92737.jpg', 'KOOKI', 1, '2024-06-28 13:21:08', 1),
(24, 'EXT02084', 'L01', 'MINI REO II OK 92737.jpg', 'A9q8uyn3_1aiumhu_wmc.png', 'CARA 20', 1, '2024-06-28 13:22:00', 1),
(25, 'EXT02084', 'L01', 'ALDL0876-1.jpg', 'chrome.png', 'CARA 90', 2, '2024-06-28 20:44:47', 0),
(26, 'EXT02084', 'L01', 'MINI REO II OK 92737.jpg', 'A9q8uyn3_1aiumhu_wmc.png', 'PALAOS', 2, '2024-06-28 20:56:30', 1),
(27, 'EXT02084', 'L01', 'ALDL0876-1.jpg', 'A9q8uyn3_1aiumhu_wmc.png', 'PIXEL ROUND', 3, '2024-06-28 21:37:28', 1),
(28, 'NA', 'NA', 'LED-MODULE-3.jpg', 'LED-MODULE--outline-3.jpg', 'LED Module 3', 4, '2024-07-17 05:56:55', 0);

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

--
-- Table structure for table `product_leaflet`
--

CREATE TABLE `product_leaflet` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_size` float NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `upload_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_leaflet`
--

INSERT INTO `product_leaflet` (`id`, `file_name`, `file_size`, `file_path`, `upload_date`) VALUES
(1, 'BLACKMOON LEAFLET.pdf', 4.28163, 'uploads/BLACKMOON LEAFLET.pdf', '2024-07-18 13:07:28'),
(2, 'CELESTIA LEAFLET.pdf', 12.417, 'uploads/CELESTIA LEAFLET.pdf', '2024-07-18 13:08:41'),
(4, 'MAGNETIC LEAFLET.pdf', 11.2281, 'uploads/MAGNETIC LEAFLET.pdf', '2024-07-18 13:10:10');

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

--
-- Table structure for table `product_pictures`
--

CREATE TABLE `product_pictures` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_size` float NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `upload_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `category` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_pictures`
--

INSERT INTO `product_pictures` (`id`, `file_name`, `file_size`, `file_path`, `upload_date`, `category`) VALUES
(1, 'Alter 6.jpg', 0, 'uploads/Alter 6.jpg', '2024-07-18 13:24:22', 'Indoor'),
(2, 'beta 8.jpg', 2, 'uploads/beta 8.jpg', '2024-07-18 13:24:22', 'Indoor'),
(3, 'beta 15 suspended.jpg', 2, 'uploads/beta 15 suspended.jpg', '2024-07-18 13:24:22', 'Indoor'),
(4, 'beta 15.jpg', 3, 'uploads/beta 15.jpg', '2024-07-18 13:24:22', 'Indoor'),
(5, 'beta 20 suspended.jpg', 2, 'uploads/beta 20 suspended.jpg', '2024-07-18 13:24:22', 'Indoor'),
(6, 'beta 20.jpg', 3, 'uploads/beta 20.jpg', '2024-07-18 13:24:31', 'Indoor'),
(7, 'beta ceiling mounted.jpg', 0, 'uploads/beta ceiling mounted.jpg', '2024-07-18 13:24:31', 'Indoor'),
(8, 'beta suspended.jpg', 0, 'uploads/beta suspended.jpg', '2024-07-18 13:24:31', 'Indoor'),
(9, 'beta TRACK.jpg', 0, 'uploads/beta TRACK.jpg', '2024-07-18 13:24:31', 'Indoor'),
(10, 'blackmoon -  wh-bk.jpg', 2, 'uploads/blackmoon -  wh-bk.jpg', '2024-07-18 13:24:31', 'Indoor'),
(11, 'blackmoon -  wh-hgb.jpg', 2, 'uploads/blackmoon -  wh-hgb.jpg', '2024-07-18 13:24:31', 'Indoor'),
(12, 'blackmoon - bk-bk.jpg', 2, 'uploads/blackmoon - bk-bk.jpg', '2024-07-18 13:24:31', 'Indoor'),
(13, 'blackmoon - bk-fs.jpg', 2, 'uploads/blackmoon - bk-fs.jpg', '2024-07-18 13:24:31', 'Indoor'),
(14, 'blackmoon - bk-hgb.jpg', 2, 'uploads/blackmoon - bk-hgb.jpg', '2024-07-18 13:24:42', 'Indoor'),
(15, 'BLACKMOON - bk-hgs.jpg', 2, 'uploads/BLACKMOON - bk-hgs.jpg', '2024-07-18 13:24:42', 'Indoor'),
(16, 'BLACKMOON - bk-wh.jpg', 2, 'uploads/BLACKMOON - bk-wh.jpg', '2024-07-18 13:24:42', 'Indoor'),
(17, 'BLACKMOON - gd-gd.jpg', 2, 'uploads/BLACKMOON - gd-gd.jpg', '2024-07-18 13:24:42', 'Indoor'),
(18, 'blackmoon - r.jpg', 2, 'uploads/blackmoon - r.jpg', '2024-07-18 13:24:42', 'Indoor'),
(19, 'blackmoon - s.jpg', 3, 'uploads/blackmoon - s.jpg', '2024-07-18 13:24:42', 'Indoor'),
(20, 'BLACKMOON - wh-gd.jpg', 2, 'uploads/BLACKMOON - wh-gd.jpg', '2024-07-18 13:24:42', 'Indoor'),
(21, 'BLACKMOON - wh-hgb.jpg', 2, 'uploads/BLACKMOON - wh-hgb.jpg', '2024-07-18 13:24:42', 'Indoor'),
(22, 'BLACKMOON - wh-wh.jpg', 2, 'uploads/BLACKMOON - wh-wh.jpg', '2024-07-18 13:24:53', 'Indoor'),
(23, 'blackmoon 3.jpg', 2, 'uploads/blackmoon 3.jpg', '2024-07-18 13:24:53', 'Indoor'),
(24, 'BLACKMOON 8 - r.jpg', 2, 'uploads/BLACKMOON 8 - r.jpg', '2024-07-18 13:24:53', 'Indoor'),
(25, 'BLACKMOON 8 - s.jpg', 3, 'uploads/BLACKMOON 8 - s.jpg', '2024-07-18 13:24:53', 'Indoor'),
(26, 'blackmoon 8  suspended.jpg', 2, 'uploads/blackmoon 8  suspended.jpg', '2024-07-18 13:24:53', 'Indoor'),
(27, 'blackmoon 8  track.jpg', 2, 'uploads/blackmoon 8  track.jpg', '2024-07-18 13:24:53', 'Indoor'),
(28, 'blackmoon 8 Adjustable.jpg', 3, 'uploads/blackmoon 8 Adjustable.jpg', '2024-07-18 13:24:53', 'Indoor'),
(29, 'blackmoon 8.jpg', 3, 'uploads/blackmoon 8.jpg', '2024-07-18 13:24:53', 'Indoor'),
(30, 'BLACKMOON 10 - II.jpg', 2, 'uploads/BLACKMOON 10 - II.jpg', '2024-07-18 13:25:04', 'Indoor'),
(31, 'BLACKMOON 10 - r.jpg', 2, 'uploads/BLACKMOON 10 - r.jpg', '2024-07-18 13:25:04', 'Indoor'),
(32, 'BLACKMOON 10 - s.jpg', 2, 'uploads/BLACKMOON 10 - s.jpg', '2024-07-18 13:25:04', 'Indoor'),
(33, 'blackmoon 10  track.jpg', 2, 'uploads/blackmoon 10  track.jpg', '2024-07-18 13:25:04', 'Indoor'),
(34, 'blackmoon 10 Adjustable.jpg', 3, 'uploads/blackmoon 10 Adjustable.jpg', '2024-07-18 13:25:04', 'Indoor'),
(35, 'blackmoon 10 suspended.jpg', 2, 'uploads/blackmoon 10 suspended.jpg', '2024-07-18 13:25:04', 'Indoor'),
(36, 'blackmoon 10.jpg', 2, 'uploads/blackmoon 10.jpg', '2024-07-18 13:25:04', 'Indoor'),
(37, 'BLACKMOON 10-R Adj..jpg', 3, 'uploads/BLACKMOON 10-R Adj..jpg', '2024-07-18 13:25:04', 'Indoor'),
(38, 'BLACKMOON 14 - II.jpg', 2, 'uploads/BLACKMOON 14 - II.jpg', '2024-07-18 13:26:37', 'Indoor'),
(39, 'BLACKMOON 14 - r.jpg', 2, 'uploads/BLACKMOON 14 - r.jpg', '2024-07-18 13:26:37', 'Indoor'),
(40, 'BLACKMOON 14 - s.jpg', 3, 'uploads/BLACKMOON 14 - s.jpg', '2024-07-18 13:26:37', 'Indoor'),
(41, 'blackmoon 14  track.jpg', 2, 'uploads/blackmoon 14  track.jpg', '2024-07-18 13:26:37', 'Indoor'),
(42, 'blackmoon 14 Adjustable.jpg', 3, 'uploads/blackmoon 14 Adjustable.jpg', '2024-07-18 13:26:37', 'Indoor'),
(43, 'blackmoon 14 suspended.jpg', 2, 'uploads/blackmoon 14 suspended.jpg', '2024-07-18 13:26:37', 'Indoor'),
(44, 'blackmoon 14.jpg', 3, 'uploads/blackmoon 14.jpg', '2024-07-18 13:26:37', 'Indoor'),
(45, 'BLACKMOON 14-R Adj..jpg', 0, 'uploads/BLACKMOON 14-R Adj..jpg', '2024-07-18 13:26:37', 'Indoor'),
(46, 'BLACKMOON 14 - II.jpg', 2, 'uploads/BLACKMOON 14 - II.jpg', '2024-07-18 13:26:58', 'Indoor'),
(47, 'BLACKMOON 14 - r.jpg', 2, 'uploads/BLACKMOON 14 - r.jpg', '2024-07-18 13:26:58', 'Indoor'),
(48, 'BLACKMOON 14 - s.jpg', 3, 'uploads/BLACKMOON 14 - s.jpg', '2024-07-18 13:26:58', 'Indoor'),
(49, 'blackmoon 14  track.jpg', 2, 'uploads/blackmoon 14  track.jpg', '2024-07-18 13:26:58', 'Indoor'),
(50, 'blackmoon 14 Adjustable.jpg', 3, 'uploads/blackmoon 14 Adjustable.jpg', '2024-07-18 13:26:58', 'Indoor'),
(51, 'blackmoon 14 suspended.jpg', 2, 'uploads/blackmoon 14 suspended.jpg', '2024-07-18 13:26:58', 'Indoor'),
(52, 'blackmoon 14.jpg', 3, 'uploads/blackmoon 14.jpg', '2024-07-18 13:26:58', 'Indoor'),
(53, 'BLACKMOON 14-R Adj..jpg', 0, 'uploads/BLACKMOON 14-R Adj..jpg', '2024-07-18 13:26:58', 'Indoor'),
(54, 'blackmoon 20  track.jpg', 2, 'uploads/blackmoon 20  track.jpg', '2024-07-18 13:37:59', 'Indoor'),
(55, 'blackmoon 20 suspended.jpg', 2, 'uploads/blackmoon 20 suspended.jpg', '2024-07-18 13:37:59', 'Indoor'),
(56, 'blackmoon 20.jpg', 3, 'uploads/blackmoon 20.jpg', '2024-07-18 13:37:59', 'Indoor'),
(57, 'blackmoon 28.jpg', 3, 'uploads/blackmoon 28.jpg', '2024-07-18 13:37:59', 'Indoor'),
(58, 'BLACKMOON- bk-gd.jpg', 2, 'uploads/BLACKMOON- bk-gd.jpg', '2024-07-18 13:37:59', 'Indoor'),
(59, 'BLACKMOON ceiling recessed.jpg', 2, 'uploads/BLACKMOON ceiling recessed.jpg', '2024-07-18 13:37:59', 'Indoor'),
(60, 'BLACKMOON II - bk-fs.jpg', 2, 'uploads/BLACKMOON II - bk-fs.jpg', '2024-07-18 13:37:59', 'Indoor'),
(61, 'BLACKMOON II - bk-gd.jpg', 2, 'uploads/BLACKMOON II - bk-gd.jpg', '2024-07-18 13:37:59', 'Indoor'),
(62, 'BLACKMOON II - bk-hgs.jpg', 2, 'uploads/BLACKMOON II - bk-hgs.jpg', '2024-07-18 13:38:18', 'Indoor'),
(63, 'BLACKMOON II - bk-wh.jpg', 2, 'uploads/BLACKMOON II - bk-wh.jpg', '2024-07-18 13:38:18', 'Indoor'),
(64, 'blackmoon II - s.jpg', 3, 'uploads/blackmoon II - s.jpg', '2024-07-18 13:38:18', 'Indoor'),
(65, 'BLACKMOON II - wh-gd.jpg', 2, 'uploads/BLACKMOON II - wh-gd.jpg', '2024-07-18 13:38:18', 'Indoor'),
(66, 'BLACKMOON II - wh-hgs.jpg', 2, 'uploads/BLACKMOON II - wh-hgs.jpg', '2024-07-18 13:38:18', 'Indoor'),
(67, 'BLACKMOON II - wh-wh.jpg', 2, 'uploads/BLACKMOON II - wh-wh.jpg', '2024-07-18 13:38:18', 'Indoor'),
(68, 'BLACKMOON R - bk-fs.jpg', 3, 'uploads/BLACKMOON R - bk-fs.jpg', '2024-07-18 13:38:18', 'Indoor'),
(69, 'BLACKMOON R - bk-gd.jpg', 3, 'uploads/BLACKMOON R - bk-gd.jpg', '2024-07-18 13:38:18', 'Indoor');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `deletedrecords`
--
ALTER TABLE `deletedrecords`
  ADD PRIMARY KEY (`DeletedID`);

--
-- Indexes for table `driverdetails`
--
ALTER TABLE `driverdetails`
  ADD KEY `ProductID` (`ProductID`);

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`ClaimID`);

--
-- Indexes for table `generaldetails`
--
ALTER TABLE `generaldetails`
  ADD KEY `ProductID` (`ProductID`);

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

--
-- Indexes for table `itinventory`
--
ALTER TABLE `itinventory`
  ADD PRIMARY KEY (`ID`);

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

--
-- Indexes for table `leaverequests`
--
ALTER TABLE `leaverequests`
  ADD PRIMARY KEY (`LeaveID`),
  ADD KEY `UserID` (`UserID`);

--
-- Indexes for table `leddetails`
--
ALTER TABLE `leddetails`
  ADD KEY `ProductID` (`ProductID`);

--
-- Indexes for table `misc`
--
ALTER TABLE `misc`
  ADD KEY `ProductID` (`ProductID`);

--
-- Indexes for table `officesuppliesinventory`
--
ALTER TABLE `officesuppliesinventory`
  ADD PRIMARY KEY (`ID`);

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

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

--
-- Indexes for table `productdetails`
--
ALTER TABLE `productdetails`
  ADD PRIMARY KEY (`ProductID`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `company_letterhead`
--
ALTER TABLE `company_letterhead`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `company_profile`
--
ALTER TABLE `company_profile`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `deletedrecords`
--
ALTER TABLE `deletedrecords`
  MODIFY `DeletedID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `ClaimID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `interactive_catalogues`
--
ALTER TABLE `interactive_catalogues`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `itinventory`
--
ALTER TABLE `itinventory`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `it_supplies_requests`
--
ALTER TABLE `it_supplies_requests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `leaverequests`
--
ALTER TABLE `leaverequests`
  MODIFY `LeaveID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `officesuppliesinventory`
--
ALTER TABLE `officesuppliesinventory`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `org_chart`
--
ALTER TABLE `org_chart`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `presentation_templates`
--
ALTER TABLE `presentation_templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `productdetails`
--
ALTER TABLE `productdetails`
  MODIFY `ProductID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `product_leaflet`
--
ALTER TABLE `product_leaflet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `product_pictures`
--
ALTER TABLE `product_pictures`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `driverdetails`
--
ALTER TABLE `driverdetails`
  ADD CONSTRAINT `driverdetails_ibfk_1` FOREIGN KEY (`ProductID`) REFERENCES `productdetails` (`ProductID`);

--
-- Constraints for table `generaldetails`
--
ALTER TABLE `generaldetails`
  ADD CONSTRAINT `generaldetails_ibfk_1` FOREIGN KEY (`ProductID`) REFERENCES `productdetails` (`ProductID`);

--
-- Constraints for table `it_supplies_requests`
--
ALTER TABLE `it_supplies_requests`
  ADD CONSTRAINT `it_supplies_requests_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `userlogin` (`UserID`);

--
-- Constraints for table `leaverequests`
--
ALTER TABLE `leaverequests`
  ADD CONSTRAINT `leaverequests_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `userlogin` (`UserID`);

--
-- Constraints for table `leddetails`
--
ALTER TABLE `leddetails`
  ADD CONSTRAINT `leddetails_ibfk_1` FOREIGN KEY (`ProductID`) REFERENCES `productdetails` (`ProductID`);

--
-- Constraints for table `misc`
--
ALTER TABLE `misc`
  ADD CONSTRAINT `misc_ibfk_1` FOREIGN KEY (`ProductID`) REFERENCES `productdetails` (`ProductID`);
COMMIT;

