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

START TRANSACTION;



--
-- Database: `crosslinkdb`
--

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

--
-- Table structure for table `application_list`
--

CREATE TABLE `application_list` (
  `id` bigint(20) NOT NULL,
  `itemcode` longtext,
  `computername` longtext,
  `datedeployed` date DEFAULT NULL,
  `status` longtext,
  `datepullout` date DEFAULT NULL,
  `statuspullout` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `application_list`
--

INSERT INTO `application_list` (`id`, `itemcode`, `computername`, `datedeployed`, `status`, `datepullout`, `statuspullout`) VALUES
(1, 'KASPERSKY03', 'PC19', '2022-11-10', 'Deployed', NULL, NULL),
(2, 'KASPEPERSKY02', 'PC21', '2022-11-22', 'Deployed', NULL, NULL);

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

--
-- Table structure for table `assigned_user`
--

CREATE TABLE `assigned_user` (
  `id` bigint(20) NOT NULL,
  `idnumber` longtext,
  `computername` longtext,
  `datedeployed` date DEFAULT NULL,
  `status` longtext,
  `datepullout` date DEFAULT NULL,
  `statuspullout` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `assigned_user`
--

INSERT INTO `assigned_user` (`id`, `idnumber`, `computername`, `datedeployed`, `status`, `datepullout`, `statuspullout`) VALUES
(1, '492080921', 'PC78', '2022-10-11', 'Deployed', NULL, NULL),
(2, '510081622', 'PC95', '2022-10-11', 'Deployed', NULL, NULL),
(3, '391080320', 'PC92', '2022-10-11', 'Deployed', NULL, NULL),
(4, '142100616', 'PC91', '2022-10-11', 'Deployed', NULL, NULL),
(5, '83101915', 'PC90', '2022-10-11', 'Deployed', NULL, NULL),
(6, '517092022', 'PC96', '2022-10-11', 'Deployed', NULL, NULL),
(7, '44042513', 'PC85', '2022-10-11', 'Deployed', NULL, NULL),
(8, '97041316', 'PC84', '2022-10-11', 'Deployed', NULL, NULL),
(9, '389072120', 'PC97', '2022-10-11', 'Deployed', NULL, NULL),
(10, '44042513', 'PC16', '2022-10-11', 'Deployed', NULL, NULL),
(11, '97041316', 'PC17', '2022-10-11', 'Deployed', NULL, NULL),
(12, '263052818', 'PC98', '2022-10-11', 'Deployed', NULL, NULL),
(13, '213061617', 'PC19', '2022-10-11', 'Deployed', NULL, NULL),
(14, '51080513', 'PC20', '2022-10-11', 'Deployed', NULL, NULL),
(15, '139092516', 'PC21', '2022-10-11', 'Deployed', NULL, NULL),
(16, '450021521', 'PC26', '2022-10-11', 'Deployed', '2022-11-14', 'Pullout'),
(17, '401101920', 'PC28', '2022-10-11', 'Deployed', NULL, NULL),
(18, '442012521', 'PC81', '2022-10-11', 'Deployed', NULL, NULL),
(19, '29040710', 'PC30', '2022-10-11', 'Deployed', NULL, NULL),
(20, '202040617', 'PC32', '2022-10-11', 'Deployed', NULL, NULL),
(21, '516091922', 'PC36', '2022-10-11', 'Deployed', NULL, NULL),
(22, '49071513', 'PC37', '2022-10-11', 'Deployed', NULL, NULL),
(23, '130083016', 'PC40', '2022-10-11', 'Deployed', '2022-11-16', 'Pullout'),
(24, '389072120', 'PC41', '2022-10-11', 'Deployed', NULL, NULL),
(25, '4042898', 'PC03', '2022-10-11', 'Deployed', NULL, NULL),
(26, '41070212', 'PC10', '2022-10-11', 'Deployed', NULL, NULL),
(27, '5010300', 'PC01', '2022-10-11', 'Deployed', NULL, NULL),
(28, '502032822', 'PC82', '2022-10-11', 'Deployed', NULL, NULL),
(29, '40021812', 'PC99', '2022-10-11', 'Deployed', NULL, NULL),
(30, '109052616', 'PC31', '2022-10-12', 'Deployed', NULL, NULL),
(31, '23110308', 'PC100', '2022-10-12', 'Deployed', NULL, NULL),
(32, '71070615', 'PC101', '2022-10-12', 'Deployed', NULL, NULL),
(33, '17061807', 'PC39', '2022-10-12', 'Deployed', NULL, NULL),
(34, '113061016', 'PC102', '2022-10-12', 'Deployed', NULL, NULL),
(35, '333062419', 'PC48', '2022-10-12', 'Deployed', NULL, NULL),
(36, '110053016', 'PC65', '2022-10-12', 'Deployed', NULL, NULL),
(37, '68051815', 'PC43', '2022-10-12', 'Deployed', NULL, NULL),
(38, '37080111', 'PC02', '2022-10-12', 'Deployed', NULL, NULL),
(39, '6062400', 'PC04', '2022-10-12', 'Deployed', NULL, NULL),
(40, '214072617', 'PC08', '2022-10-12', 'Deployed', NULL, NULL),
(41, '3020592', 'PC05', '2022-10-12', 'Deployed', NULL, NULL),
(42, '60021814', 'PC79', '2022-10-12', 'Deployed', NULL, NULL),
(43, '23110308', 'PC06', '2022-10-12', 'Deployed', NULL, NULL),
(44, '16060607', 'PC62', '2022-10-12', 'Deployed', NULL, NULL),
(45, '118070516', 'PC13', '2022-10-13', 'Deployed', NULL, NULL),
(46, '82100515', 'PC35', '2022-10-17', 'Deployed', NULL, NULL),
(47, '323061019', 'PC51', '2022-10-20', 'Deployed', NULL, NULL),
(48, '508080922', 'PC53', '2022-10-20', 'Deployed', NULL, NULL),
(49, '20020108', 'PC64', '2022-10-20', 'Deployed', NULL, NULL),
(50, '335070119', 'PC103', '2022-10-20', 'Deployed', NULL, NULL),
(51, '519091422', 'PC50', '2022-10-20', 'Deployed', NULL, NULL),
(52, '2160911', 'PC09', '2022-10-20', 'Deployed', NULL, NULL),
(53, '150112816', 'PC69', '2022-10-20', 'Deployed', NULL, NULL),
(54, '65091914', 'PC75', '2022-10-20', 'Deployed', NULL, NULL),
(55, '83101915', 'PC15', '2022-10-20', 'Deployed', NULL, NULL),
(56, '299031419', 'PC14', '2022-10-20', 'Deployed', NULL, NULL),
(57, '401101920', 'PC29', '2022-10-20', 'Deployed', NULL, NULL),
(58, '325061119', 'PC74', '2022-10-21', 'Deployed', NULL, NULL),
(59, '320052719', 'PC56', '2022-10-21', 'Deployed', NULL, NULL),
(60, '340070919', 'PC54', '2022-10-21', 'Deployed', NULL, NULL),
(61, '488071921', 'PC52', '2022-10-21', 'Deployed', NULL, NULL),
(62, '515090122', 'PC61', '2022-10-21', 'Deployed', NULL, NULL),
(63, '413112420', 'PC60', '2022-10-21', 'Deployed', NULL, NULL),
(64, '486071621', 'PC58', '2022-10-21', 'Deployed', NULL, NULL),
(65, '458033121', 'PC59', '2022-10-21', 'Deployed', NULL, NULL),
(66, '390072020', 'PC70', '2022-10-21', 'Deployed', NULL, NULL),
(67, '294010819', 'PC71', '2022-10-21', 'Deployed', NULL, NULL),
(68, '142100616', 'PC27', '2022-10-21', 'Deployed', NULL, NULL),
(69, '120071516', 'PC34', '2022-10-21', 'Deployed', NULL, NULL),
(70, '333062419', 'PC49', '2022-10-21', 'Deployed', NULL, NULL),
(71, '40021812', 'PC83', '2022-10-21', 'Deployed', NULL, NULL),
(72, '492080921', 'PC94', '2022-10-21', 'Deployed', '2022-11-17', 'Pullout'),
(73, '321060619', 'PC7', '2022-10-21', 'Deployed', NULL, NULL),
(74, '290012819', 'PC18', '2022-10-21', 'Deployed', NULL, NULL),
(75, '87020916', 'PC42', '2022-10-21', 'Deployed', NULL, NULL),
(76, '508080922', 'PC57', '2022-10-21', 'Deployed', NULL, NULL),
(77, '356100719', 'PC47', '2022-10-25', 'Deployed', NULL, NULL),
(78, '78082515', 'PC76', '2022-10-25', 'Deployed', NULL, NULL),
(79, '78082515', 'PC77', '2022-10-25', 'Deployed', NULL, NULL),
(80, '261070405', 'PC11', '2022-10-26', 'Deployed', NULL, NULL),
(81, '57110413', 'PC33', '2022-10-26', 'Deployed', NULL, NULL),
(82, '18070207', 'PC38', '2022-10-26', 'Deployed', NULL, NULL),
(83, '57110413', 'PC44', '2022-10-26', 'Deployed', NULL, NULL),
(84, '30060810', 'PC63', '2022-10-26', 'Deployed', NULL, NULL),
(85, '494091321', 'PC66', '2022-10-26', 'Deployed', NULL, NULL),
(86, '509080822', 'ACER104', '2022-11-11', 'Deployed', NULL, NULL),
(87, '450021521', 'Lenovo105', '2022-11-14', 'Deployed', NULL, NULL),
(88, '517092022', 'HP106', '2022-11-17', 'Deployed', '2022-12-05', 'Pullout'),
(89, '492080921', 'PC26', '2022-11-17', 'Deployed', NULL, NULL),
(90, '482060721', 'DELL109', '2022-11-24', 'Deployed', NULL, NULL),
(91, '118070516', 'Redmi106', '2022-11-24', 'Deployed', NULL, NULL),
(92, '459040821', 'DELL110', '2022-11-28', 'Deployed', NULL, NULL),
(93, '517092022', 'Lenovo108', '2022-12-05', 'Deployed', NULL, NULL),
(94, '21081108', 'Asus111', '2022-12-09', 'Deployed', NULL, NULL),
(95, '82100515', 'Asus112', '2022-12-15', 'Deployed', '2022-12-15', 'Pullout'),
(96, '87020916', 'Asus113', '2022-12-15', 'Deployed', '2022-12-16', 'Pullout'),
(97, '321060619', 'Asus112', '2022-12-15', 'Deployed', '2022-12-16', 'Pullout'),
(98, '82100515', 'Asus114', '2022-12-15', 'Deployed', '2022-12-16', 'Pullout'),
(99, '87020916', 'Asus112', '2022-12-16', 'Deployed', NULL, NULL),
(100, '321060619', 'Asus114', '2022-12-16', 'Deployed', NULL, NULL),
(101, '28022310', 'Asus116', '2023-01-06', 'Deployed', NULL, NULL),
(102, '185010210', 'Asus115', '2023-01-06', 'Deployed', NULL, NULL),
(103, '78082515', 'Acer117', '2023-01-20', 'Deployed', NULL, NULL),
(104, '290012819', 'Acer118', '2023-01-20', 'Deployed', NULL, NULL),
(105, '82100515', 'Asus120', '2023-01-20', 'Deployed', NULL, NULL),
(106, '523120722', 'Acer121', '2023-01-27', 'Deployed', NULL, NULL),
(107, '530011423', 'Acer122', '2023-01-27', 'Deployed', NULL, NULL),
(108, '504041822', 'Acer123', '2023-01-27', 'Deployed', NULL, NULL),
(109, '528011023', 'Acer119', '2023-01-27', 'Deployed', NULL, NULL);

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

--
-- Table structure for table `computer_registration`
--

CREATE TABLE `computer_registration` (
  `id` bigint(20) NOT NULL,
  `computer` longtext,
  `type` longtext,
  `os` longtext,
  `dateissued` longtext,
  `serial` longtext,
  `brand` longtext,
  `processor` longtext,
  `datepurchased` longtext,
  `price` double DEFAULT NULL,
  `status` longtext,
  `remarks` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `computer_registration`
--

INSERT INTO `computer_registration` (`id`, `computer`, `type`, `os`, `dateissued`, `serial`, `brand`, `processor`, `datepurchased`, `price`, `status`, `remarks`) VALUES
(1, 'PC01', 'Laptop', 'Windows 10 Home Single Language', NULL, 'CND1096H9V', 'HP', 'Core i7, 11 Gen', NULL, 67000, 'Working', NULL),
(2, 'PC02', 'Laptop', NULL, NULL, 'MLBND0CX04U74845E', 'Asus Vivobook', NULL, NULL, NULL, 'Working', NULL),
(3, 'PC03', 'Laptop', NULL, NULL, 'CND04196PY', 'HP Envy', NULL, NULL, NULL, 'Working', NULL),
(4, 'PC04', 'Laptop', NULL, NULL, 'NXAYCSP004151237713400', 'Acer Aspire', 'Intel core i7, 11th Gen', NULL, NULL, 'Working', NULL),
(5, 'PC05', 'Laptop', NULL, NULL, 'C02DC0WHML7J', 'Apple MACBook Pro 2020', 'Quad Core Intel Core i5', '2020-10-02', 116990, 'Working', NULL),
(6, 'PC06', 'Laptop', NULL, NULL, '5CD15169B4', 'HP Pavilion', NULL, NULL, NULL, 'Working', NULL),
(8, 'PC08', 'Laptop', 'Windows 11 Home Single Language', NULL, 'PF1VP3WX', 'Lenovo', 'Intel core i7', NULL, NULL, 'Working', NULL),
(9, 'PC09', 'Laptop', NULL, NULL, '1D610-20BF-4CC7-B6D4-89126336d4B', 'HP Pavilion', NULL, NULL, NULL, 'Working', NULL),
(10, 'PC10', 'Laptop', NULL, NULL, 'CND1064TTB', 'HP', NULL, NULL, NULL, 'Working', NULL),
(11, 'PC11', 'Laptop', NULL, NULL, '8HGMFT2', 'Dell', NULL, NULL, NULL, 'Working', NULL),
(13, 'PC13', 'Laptop', NULL, NULL, 'M7NOXV21360830E', 'Asus', 'Intel Core i5, 11th Gen', NULL, NULL, 'Working', NULL),
(14, 'PC14', 'Laptop', NULL, NULL, '5CD038M0BC', 'HP Pavilion', 'Intel core i7', NULL, NULL, 'Working', NULL),
(16, 'PC16', 'Laptop', 'Window 10 Home Single Language', NULL, '5CG011D0G3', 'HP', NULL, NULL, NULL, 'Working', NULL),
(17, 'PC17', 'Laptop', 'Windows 10 Home Single Language', NULL, '5CG011D06N', 'HP', NULL, NULL, NULL, 'Working', NULL),
(19, 'PC19', 'Laptop', 'Windows 11 Home Single Language', NULL, '5CG011D07D', 'HP', NULL, NULL, NULL, 'Working', NULL),
(20, 'PC20', 'Laptop', NULL, NULL, '8BGT763', 'Dell Vostro', NULL, NULL, NULL, 'Working', NULL),
(21, 'PC21', 'Laptop', 'Windows 10 Single Home Language', NULL, 'NHQ9MsP008115166683400', 'Acer Nitro', 'AMD Ryzen 5', NULL, NULL, 'Working', NULL),
(26, 'PC26', 'Laptop', 'Windows 10 Home Single Language', NULL, 'D7N0CX297522298', 'Asus', NULL, NULL, NULL, 'Working', NULL),
(27, 'PC27', 'Laptop', 'Windows 10 Home Single Language', NULL, '8CG0035T6Y', 'HP Envy', 'Intel core i7', NULL, NULL, 'Working', NULL),
(28, 'PC28', 'Laptop', 'Windows 10', NULL, 'LAN0cX00Z411414', 'Asus Vivobook', NULL, NULL, NULL, 'Working', NULL),
(29, 'PC29', 'Laptop', NULL, NULL, 'NXA1WP002106099143400', 'Acer Aspire 5', NULL, NULL, NULL, 'Working', NULL),
(30, 'PC30', 'Desktop', 'Windows 10 Home Single Language', NULL, '4CE044203H', 'HP', 'Core i3', NULL, NULL, 'Working', NULL),
(31, 'PC31', 'Laptop', 'Windows 10 Home Single Language', NULL, 'DW5LLT2', 'Dell', NULL, NULL, NULL, 'Working', NULL),
(32, 'PC32', 'Laptop', NULL, NULL, '2RPYFW2', 'Dell Inspiron', NULL, NULL, NULL, 'Working', NULL),
(33, 'PC33', 'Desktop', 'Windows 10 Home Single Language', NULL, 'DTBCASP00390403B053000', 'Acer Aspire', 'Intel core i7', NULL, NULL, 'Working', NULL),
(34, 'PC34', 'Laptop', 'Windows 10', NULL, '5CG0488LGP', 'HP Radeon', 'Intel Core i5', NULL, NULL, 'Working', NULL),
(35, 'PC35', 'Desktop', 'Windows 10 Home Single Language', NULL, 'DTBCASP0038451AD303000', 'Acer Aspire', 'Intel core i7', NULL, NULL, 'Working', NULL),
(36, 'PC36', 'Laptop', 'Windows 11 Home Single Language', NULL, '5CG011D07F', 'HP', 'AMD Ryzen 7', NULL, NULL, 'Working', NULL),
(37, 'PC37', 'Laptop', NULL, NULL, '5CG011D08W', 'HP', NULL, NULL, NULL, 'Working', NULL),
(38, 'PC38', 'Desktop', NULL, NULL, '590-POXXX', 'HP Pavilion', NULL, NULL, NULL, 'Working', NULL),
(39, 'PC39', 'Laptop', 'Windows 11 Home Single Language', NULL, '135000', 'Dell Inspiron', 'Intel core i7, 11 Gen', NULL, NULL, 'Working', NULL),
(40, 'PC40', 'Desktop', NULL, NULL, '4CE0210SW0', 'HP Pavilion', NULL, NULL, NULL, 'Working', NULL),
(41, 'PC41', 'Laptop', 'Windows 10 Home Single Language', NULL, 'SCG011D0DV', NULL, 'AMD Ryzen 7', NULL, NULL, 'Working', NULL),
(43, 'PC43', 'Laptop', 'Window', NULL, 'PF32TTSL', 'IDEAPAD 3', 'Intel core i5, 11th Gen', NULL, NULL, 'Working', NULL),
(44, 'PC44', 'Desktop', NULL, NULL, 'DTBCASP0038451AD4A3000', 'Acer', NULL, NULL, NULL, 'Working', NULL),
(47, 'PC47', 'Laptop', 'Windows 11 Home Single Language', NULL, '8CG915MCCR', 'HP Pavilion', 'Intel core i7', NULL, NULL, 'Working', NULL),
(48, 'PC48', 'Desktop', 'Windows 10 Home Single Language', NULL, '8CG9182XYZ', 'HP Pavilion', 'Intel core i7', NULL, NULL, 'Working', NULL),
(49, 'PC49', 'Laptop', NULL, NULL, 'NXG0HSP0015170B2B13400', 'Acer', NULL, NULL, NULL, 'Working', NULL),
(50, 'PC50', 'Desktop', 'Windows 10 Home Single Language', NULL, '37ZSFW2', 'HP', 'Intel core i3', NULL, NULL, 'Working', NULL),
(51, 'PC51', 'Desktop', 'Windows 11 Home Single Language', NULL, '4CE9331V3R', 'HP Pavilion', 'Intel core i5', NULL, NULL, 'Working', NULL),
(52, 'PC52', 'Desktop', NULL, NULL, '4CE0390PSW', 'HP Pavilion', NULL, NULL, NULL, 'Working', NULL),
(53, 'PC53', 'Desktop', 'Windows 10 Pro', NULL, 'DTVPPSP34084705E5C9600', 'Acer Veriton', 'Intel core i7', NULL, NULL, 'Working', NULL),
(54, 'PC54', 'Desktop', NULL, NULL, 'DTVPPSP34084705E7C9600', 'Aces Veriton', NULL, NULL, NULL, 'Working', NULL),
(56, 'PC56', 'Desktop', NULL, NULL, '8CG915MCDD', 'HP Pavilion', NULL, NULL, NULL, 'Working', NULL),
(57, 'PC57', 'Desktop', NULL, NULL, 'DTVPPSP34084705EC9600', 'Acer', NULL, NULL, NULL, 'Working', NULL),
(58, 'PC58', 'Desktop', NULL, NULL, '8CG910H43B', 'Acer', NULL, NULL, NULL, 'Working', NULL),
(59, 'PC59', 'Desktop', NULL, NULL, '8CG9081YP1', 'HP Pavilion', NULL, NULL, NULL, 'Working', NULL),
(60, 'PC60', 'Desktop', NULL, NULL, '8CG8348STM', 'HP Slim', NULL, NULL, NULL, 'Working', NULL),
(61, 'PC61', 'Desktop', NULL, NULL, '8CG910H430', 'Acer', NULL, NULL, NULL, 'Working', NULL),
(62, 'PC62', 'Desktop', 'Windows 10 Home Single Language', NULL, 'NXVLUSP02R0382011B76', NULL, 'Intel core i7', NULL, NULL, 'Working', NULL),
(63, 'PC63', 'Desktop', NULL, NULL, '8CG9060SRS/1CR0010JQQ', 'HP', NULL, NULL, NULL, 'Working', NULL),
(64, 'PC64', 'Desktop', 'Windows 10 Home Single Language', NULL, '4CE0322DNQ', 'HP Pavilion', 'Intel core i7', NULL, NULL, 'Working', NULL),
(65, 'PC65', 'Laptop', 'Windows 10 Home Single Language', NULL, 'PF0FYDLJ', 'Lenovo', 'Intel core i7', NULL, NULL, 'Working', NULL),
(66, 'PC66', 'Desktop', NULL, NULL, '38889JLGX53', 'Dell Vostro', NULL, NULL, NULL, 'Working', NULL),
(69, 'PC69', 'Laptop', 'Intel core i5, 11th Gen', NULL, 'M7NOCV213958307', 'Asus', NULL, NULL, NULL, 'Working', NULL),
(70, 'PC70', 'Desktop', 'Windows 10 Home Single Language', NULL, 'PF0JBGW', 'Lenovo', 'Intel core i7', NULL, NULL, 'Working', NULL),
(71, 'PC71', 'Desktop', 'Windows 10 Home Single Language', NULL, 'MMT6GSS06673902585', 'Acer', 'Intel core i7', NULL, NULL, 'Working', NULL),
(74, 'PC74', 'Desktop', 'Windows 10 Home Single Language', NULL, '4CE4422BP', 'HP', 'Intel core i3', NULL, NULL, 'Working', NULL),
(75, 'PC75', 'Laptop', 'Windows 11 Home Single Language', NULL, 'CND1103CBB', 'HP', 'Intel Core i5, 11th Gen', NULL, NULL, 'Working', NULL),
(76, 'PC76', NULL, NULL, NULL, 'PF077RUG', 'Lenovo', NULL, NULL, NULL, 'Working', NULL),
(77, 'PC77', NULL, NULL, NULL, '02800807396', 'Acer Aspire', NULL, NULL, NULL, 'Working', NULL),
(79, 'PC79', 'Laptop', NULL, NULL, 'M6N0CV08837923A', 'Asus Silver', NULL, NULL, NULL, 'Working', NULL),
(81, 'PC81', NULL, NULL, NULL, 'NXA1WSP002106099143400', 'Acer Aspire', NULL, NULL, NULL, 'Working', NULL),
(82, 'PC82', 'Laptop', NULL, NULL, 'NXA2ASP00H2021D783400', 'Acer Aspire', NULL, '2022-09-07', NULL, 'Working', NULL),
(83, 'PC83', 'Laptop', NULL, NULL, 'N1NOCX038955601A', 'Asus Vivobook', NULL, '2022-10-07', NULL, 'Working', NULL),
(90, 'PC90', 'Laptop', 'Windows 11 Home Single Language', NULL, 'B3QXFW2', 'Dell', NULL, NULL, NULL, 'Working', NULL),
(94, 'PC94', 'Laptop', 'Windows 10', NULL, 'NXVLFSP03G0370990F7600', 'Acer', 'Intel core i3', NULL, NULL, 'Working', 'keyboard number 1 and 3 not working'),
(95, 'PC95', 'Laptop', 'Windows 10 Home Single Language', NULL, '8CG9424V9x', 'HP Pavilion', 'Intel core i7', NULL, NULL, 'Working', NULL),
(98, 'PC98', 'Laptop', 'Windows 11 Home Single Language', NULL, 'LAN0CX03D01941B', 'Asus Vivobook', NULL, NULL, NULL, 'Working', NULL),
(100, 'PC100', 'Laptop', NULL, NULL, '5DC15169B4', 'HP Pavilion', NULL, NULL, NULL, 'Working', NULL),
(101, 'PC101', 'Desktop', 'Windows 10 Pro', NULL, 'No serial / device id: F2DEB3D9-552F-ADB6-7C0797228473', NULL, NULL, NULL, NULL, 'Working', NULL),
(102, 'PC102', 'Laptop', NULL, NULL, 'PF2JFYAJ', 'IDEAPAD SLIM 5', NULL, NULL, NULL, 'Working', NULL),
(103, 'PC103', 'Desktop', NULL, NULL, 'NXVLUSP02R011B7600', 'Acer', 'Intel core i7, 10th Gen', NULL, NULL, 'Working', NULL),
(104, 'PC7', 'Desktop', NULL, NULL, '4CE0390PVB', 'HP', NULL, NULL, NULL, 'Working', NULL),
(105, 'PC18', 'Desktop', NULL, NULL, '4CE0390PW7', 'HP', NULL, NULL, NULL, 'Working', NULL),
(106, 'PC42', 'Desktop', NULL, NULL, '8CG910H439', 'HP', NULL, NULL, NULL, 'Working', NULL),
(107, 'ACER104', 'Laptop', 'Windows 11 Home Single Language', '2022-11-11', 'NXAB1SP00520102CDB3400', 'Acer Swift 3', 'AMD Ryzen 5 5500U with Radeon Graphics 2.10 GHz', NULL, NULL, 'Working', NULL),
(108, 'Lenovo105', 'Laptop', 'Windows 11 Home Single Language', '2022-11-14', 'PF3MD9L7', 'Lenovo IdealPad Slim 3', '11th Gen Intel(R) Core(TM) i3-1115G4 @ 3.00GHz', '2022-11-14', NULL, 'Working', NULL),
(109, 'HP106', 'Desktop', 'Windows 10 Pro', NULL, '8CG9060SW0', 'HP', 'Intel(R) Core(TM) i3-8100 CPU @ 3.60 GHz', NULL, NULL, 'Working', 'won\'t open after being off for days'),
(110, 'HP107', 'Desktop', 'Windows 11 Home Single Language', NULL, '8CG919838G', 'HP', 'Intel(R) Core(TM) i3-8100 CPU @ 3.60GHz', NULL, NULL, 'Working', 'won\'t open after being off for days'),
(111, 'Redmi106', 'Laptop', 'Windows 11 Home Single Language', '2022-11-21', '41392/32U401184', 'Redmi', '11th Gen Intel(R) Core(TM) i3-1115G4 @ 3.00GHz', '2022-11-21', NULL, 'Working', NULL),
(112, 'Lenovo108', 'Desktop', 'Windows 11 Home Single Language', NULL, 'R3051AWF', 'Lenovo', 'Intel(R) Core(TM) i3-7100 CPU @ 3.90GHz 3.91GHz', NULL, NULL, 'Working', NULL),
(113, 'DELL109', 'Laptop', 'Windows 11 Home Single Language', NULL, 'CCY2663', 'Dell', 'Intel(R) Core(TM) i5-10300H CPU @ 2.50GHz', NULL, NULL, 'Working', NULL),
(114, 'DELL110', 'Desktop', NULL, NULL, '36K8R13', 'DELL', NULL, NULL, NULL, 'Working', NULL),
(115, 'Asus111', 'Laptop', 'Windows 10 Home Single Language', '2022-12-09', 'M6N0LP023693235', 'Asus ZenBook 13', '11th Gen Intel(R) Core(TM) i5-1135G7 @ 2.40GHz 2.42GHz', '2022-12-09', NULL, 'Working', NULL),
(116, 'Asus112', 'Laptop', 'Windows 11 Home Single Language', '2022-12-15', 'MCN0CX16P70350D', 'Asus Vivobook Pro 14 OLED', '11th Gen Intel(R) Core(TM) i5-11300H @ 3.10GHz 3.11GHz', '2022-12-15', NULL, 'Working', NULL),
(117, 'Asus113', 'Laptop', 'Windows 11 Home Single Language', '2022-12-15', 'MCN0CX16P652509', 'Asus Vivobook Pro 14 OLED', '11th Gen Intel(R) Core(TM) i5-11300H @ 3.10GHz 3.11GHz', '2022-12-15', NULL, 'Repair', 'mousepad laptop are detached'),
(118, 'Asus114', 'Laptop', 'Windows 11 Home Single Language', '2022-12-15', 'MCN0CX16P691506', 'Asus Vivobook Pro 14 OLED', '11th Gen Intel(R) Core(TM) i5-11300H @ 3.10GHz 3.11GHz', '2022-12-15', NULL, 'Working', NULL),
(119, 'Asus115', 'Laptop', 'Windows 11 Home Single Language', '2022-12-23', 'N7NRCX03R621288', 'Asus TUF Gaming A15', 'AMD Ryzen 7 4800H with Radeon Graphics 2.90 GHz', '2022-12-23', NULL, 'Working', NULL),
(120, 'Asus116', 'Laptop', 'Windows 11 Home Single Language', '2023-01-06', 'N8NRCX04B57332B', 'Asus TUF Gaming A15', 'AMD Ryzen 7 4800H with Radeon Graphics 2.90 GHz', '2023-01-06', NULL, 'Working', NULL),
(121, 'Acer117', 'Desktop', 'Windows 11 Home Single Language', '2023-01-20', 'DTBHVSP008247002499600', 'Acer Aspire TC', '12th Gen Intel Core i-512400 2.50 GHz', '2023-01-20', NULL, 'Working', NULL),
(122, 'Acer118', 'Desktop', 'Windows 11 Home Single Language', '2023-01-20', 'DTBHVSP008247002609600', 'Acer Aspire TC', '12th Gen Intel Core i-512400 2.50 GHz', '2023-01-20', NULL, 'Working', NULL),
(123, 'Acer119', 'Desktop', 'Windows 11 Home Single Language', '2023-01-20', 'DTBHVSP008247001DA9600', 'Acer Aspire TC', '12th Gen Intel Core i-512400 2.50 GHz', '2023-01-20', NULL, 'Working', NULL),
(124, 'Asus120', 'Laptop', 'Windows 11 Home Single Language', '2023-01-20', 'MCN0CX16P64350A', 'Asus Vivobook Pro 14 OLED', '11th Gen Intel(R) Core(TM) i5-11300H @ 3.10GHz 3.11GHz', '2023-01-20', NULL, 'Working', NULL),
(125, 'Acer121', 'Desktop', 'Windows 11 Home Single Language', '2023-01-27', 'DTBHVSP008247001FA9600', 'Acer Aspire TC', '12th Gen Intel Core i-512400 2.50 GHz', '2023-01-27', NULL, 'Working', NULL),
(126, 'Acer122', 'Desktop', 'Windows 11 Home Single Language', '2023-01-27', 'DTBHVSP0082470021F9600', 'Acer Aspire TC', '12th Gen Intel Core i-512400 2.50 GHz', '2023-01-27', NULL, 'Working', NULL),
(127, 'Acer123', 'Desktop', 'Windows 11 Home Single Language', '2023-01-27', 'DTBHVSP008247001F89600', 'Acer Aspire TC', '12th Gen Intel Core i-512400 2.50 GHz', '2023-01-27', NULL, 'Working', NULL);

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

--
-- Table structure for table `employee_info`
--

CREATE TABLE `employee_info` (
  `id` bigint(20) NOT NULL,
  `idnumber` longtext,
  `lastname` longtext,
  `firstname` longtext,
  `middlename` longtext,
  `position` longtext,
  `designated` longtext,
  `status` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `employee_info`
--

INSERT INTO `employee_info` (`id`, `idnumber`, `lastname`, `firstname`, `middlename`, `position`, `designated`, `status`) VALUES
(1, '1015991', 'Pizarro', 'Fernando', 'Flores', 'Chief Executive Officer', NULL, 'Active'),
(2, '3020592', 'Barrios Jr.', 'Dionado', 'Nudas', 'Contracts Manager', NULL, 'Active'),
(3, '185010210', 'Carian', 'Marvin', 'Gengoyon', 'Forman / Site Supervisor', NULL, 'Active'),
(4, '4042898', 'Baguio', 'Suney', 'Aranua', 'Finance Manager', NULL, 'Active'),
(5, '5010300', 'Alapad', 'Genevie', 'Marteja', 'Purchasing Manager', NULL, 'Active'),
(6, '6062400', 'Perez', 'Pedro', 'Dahabaz', 'Senior Engineering Manager', NULL, 'Active'),
(7, '238071900', 'Adonis', 'Christoper', 'Maat', 'Logistics Driver', NULL, 'Active'),
(8, '7092000', 'Gawiden', 'Mather', 'Gal-Awan', 'Powerhouse Operator', NULL, 'Active'),
(9, '8051101', 'Roxas', 'Teodoro', 'Tanyag', 'Maintenance Engineer-Mechanical', NULL, 'Active'),
(10, '219070412', 'Bandayrel', 'Jonel', 'Boado', 'Foreman / Site Supervisor', NULL, 'Active'),
(11, '181090101', 'Varela Jr.', 'Juanecio', 'Lamela', 'Project Supervisor', NULL, 'Active'),
(12, '182042402', 'Fajardo', 'Balbino', 'Balmeo', 'Foreman / Site Supervisor', NULL, 'Active'),
(13, '183032903', 'Llenas', 'Robert', 'Paredes', 'Electrician', NULL, 'Active'),
(14, '215010704', 'Cawili', 'Conrad', 'Cruz', 'Warehouse Custodian', NULL, 'Active'),
(15, '261070405', 'Caparros', 'Jan Wilfred', 'Aguilar', 'Project Manager', NULL, 'Active'),
(16, '11101805', 'Bengaora', 'Reynaldo', 'Dele', 'Liason Officer', NULL, 'Active'),
(17, '12032406', 'Villanueva', 'Samuel', 'De Guzman', 'Project Manager', NULL, 'Active'),
(18, '13070206', 'Puno', 'Sulplicio', 'Sayson Jr.', 'Drups Tech', NULL, 'Active'),
(19, '15012407', 'Lizardo', 'Alvaro', 'Javier', 'Design Engineer', NULL, 'Active'),
(20, '17061807', 'Pereyra', 'Russel', 'Revilla', 'Human Resource & Safety Head-Assistant', NULL, 'Active'),
(21, '16060607', 'Lagunzad', 'Kent Mark', 'Gabaleo', 'Senior Project Manager', NULL, 'Active'),
(22, '18070207', 'Palangeo', 'Carlos', 'Benito', 'Design Engineer', NULL, 'Active'),
(23, '20020108', 'Villasitar', 'Joely', 'Baguio', 'Draughtsman', NULL, 'Active'),
(24, '184080808', 'Martin', 'Alfredo', 'Rivera', 'Technician', NULL, 'Active'),
(25, '21081108', 'Valentino', 'Francis Brian', 'Paragua', 'Sales Manager', NULL, 'Active'),
(26, '183020106', 'Albeus', 'Alvin', 'Bernal', 'Electrician', NULL, 'Active'),
(27, '23110308', 'Recto', 'Junzit Claro', 'Manaois', 'Operations Manager', NULL, 'Active'),
(28, '25120109', 'Pizarro', 'Mark Anthony', 'Hernandez', 'Chief Operating Officer', NULL, 'Active'),
(29, '26120109', 'Austria', 'Jaime', 'Cristobal', 'Contract & Purchasing Director / Quality Director', NULL, 'Active'),
(30, '28022310', 'Sanchez', 'Richard', 'Damot', 'Senior Project Manager', NULL, 'Active'),
(31, '29040710', 'Corales', 'Leandro', 'Espinosa', 'Purchasing Executive', NULL, 'Active'),
(32, '30060810', 'Sartillo Jr.', 'Jaime', 'Lecaroz', 'Safety Officer', NULL, 'Active'),
(33, '188060911', 'Sanchez Jr.', 'Prudencio', 'Arpon', 'Electrician', NULL, 'Active'),
(34, '37080111', 'Tonio Jr.', 'Jose', 'Laput', 'Construction Manager', NULL, 'Active'),
(35, '39090211', 'Pizarro', 'Jaqueline Marie', 'Ligon', 'Finance / Admin / Operation VP', NULL, 'Active'),
(36, '2160911', 'De Guia', 'Jenina Mari', 'Pagunsan', 'Administration Executive', NULL, 'Active'),
(37, '40021812', 'De Castro', 'Rowena', 'Macdon', 'Project Manager', NULL, 'Active'),
(38, '41070212', 'De Palma', 'Samuel', 'Manalo', 'Design & Development Project', NULL, 'Active'),
(39, '214072617', 'Narag', 'Manalo', 'Discipulo', 'Project Manager / Design Engineer', NULL, 'Active'),
(40, '294010819', 'Rodriguez', 'Edrian', 'Tenoria', 'Draughtsman', NULL, 'Active'),
(41, '44042513', 'Pabon', 'Guadalupe', 'Viray', 'Accounting Executive', NULL, 'Active'),
(42, '46052413', 'Aguila', 'Marriel', 'De Leon', 'Human Resource & Safety Manager', NULL, 'Active'),
(43, '49071513', 'Calungsod', 'Marilou', 'Salido', 'Accounting Executive', NULL, 'Active'),
(44, '51080513', 'Gabrillo', 'Azalea', 'Diaz', 'Administrative Executive', NULL, 'Active'),
(45, '57110413', 'Antonio', 'Nina Camille', 'Mendez', 'Site Administrative Executive', NULL, 'Active'),
(46, '60021814', 'Recalde', 'Diana Mae', 'Piguerra', 'Project Manager', NULL, 'Active'),
(47, '134090816', 'Dinulos', 'Adrianne', 'Briones', 'Warehouse Custodian', NULL, 'Active'),
(48, '223071514', 'Corla', 'Marben', 'Sotis', 'Project in Charge', NULL, 'Active'),
(49, '65091914', 'Semilla', 'Ana Marie', 'Baguio', 'Site Administrative Executive', NULL, 'Active'),
(50, '173092214', 'Serrano', 'Nazer', 'Narvaez', 'Project in Charge', NULL, 'Active'),
(51, '195061415', 'Baguio', 'Jimmy', 'Aranua', 'Electrician', NULL, 'Active'),
(52, '147110716', 'Olano', 'Alexis Merk', 'Arlanza', 'Project in Charge', NULL, 'Active'),
(53, '194032115', 'Bergonia', 'Mark Breinard', 'Ancheta', 'Logistics Driver', NULL, 'Active'),
(54, '68051815', 'Manuel', 'Ron Mechee', 'Angeles', 'Project Manager', NULL, 'Active'),
(55, '225061415', 'Cordial', 'Froilan', 'Suazo', 'Civil / Helper', NULL, 'Active'),
(56, '229061415', 'Mier', 'Alphe', 'Apoya', 'Electrician', NULL, 'Active'),
(57, '224061415', 'Cordial', 'Fernando', 'Banadera', 'TIle Setter / Installer / Civil', NULL, 'Active'),
(58, '71070615', 'Arcelon', 'Janssen Jay', 'Dujali', 'Draughtsman', NULL, 'Active'),
(59, '81090915', 'Cabrera', 'Alvin', 'Soriano', 'Design Engineer', NULL, 'Active'),
(60, '175100115', 'Viscayda', 'Edwin', 'Camacho', 'Purchasing Messanger', NULL, 'Active'),
(61, '78082515', 'Marquez', 'Ruderick', 'Panopio', 'Draughtsman', NULL, 'Active'),
(62, '82100515', 'Barela', 'Roberto', 'Gonce Jr.', 'Design Engineer', NULL, 'Active'),
(63, '83101915', 'Yamamoto', 'Aiko', 'Fusana', 'Sales Engineer', NULL, 'Active'),
(64, '87020916', 'Perillo', 'Azalea Muriele', 'Saguid', 'Project Manager', NULL, 'Active'),
(65, '97041316', 'Mendoza', 'Liberty', 'Roadilla', 'Accounting Executive', NULL, 'Active'),
(66, '113061016', 'Bituin', 'Tim Robert', 'Lumba', 'Project in Charge', NULL, 'Active'),
(67, '109052616', 'Dangeros', 'Cristina', 'Javier', 'Accounting Executive', NULL, 'Active'),
(68, '110053016', 'Rivera', 'Karl Edward', 'Lontayao', 'Project Manager', NULL, 'Active'),
(69, '114062016', 'Mendoza', 'Joseph Mari', 'Valencia', 'Project Manager', NULL, 'Active'),
(70, '116063016', 'Bucar', 'Edgar', 'Mullera', 'Foreman Electrician / Site Supervisor', NULL, 'Active'),
(71, '118070516', 'Pitogo', 'Ronaelette', 'Padua', 'Project Manager', NULL, 'Active'),
(72, '120071516', 'Javier', 'Monica', 'Alfaro', 'Human Resource & Safety Head-Assistant', NULL, 'Active'),
(73, '127082216', 'Saing', 'Ryan', 'Gawiden', 'Maintenance Logistics', NULL, 'Active'),
(74, '129082516', 'Navalona', 'Paulino', 'Pacheo', 'Logistics Helper', NULL, 'Active'),
(75, '130083016', 'Garcia', 'Reinaldo', 'Nunal', 'Purchasing Executive', NULL, 'Active'),
(76, '139092516', 'Santos', 'Chancellor', 'Reyes', 'Site Administrative Executive', NULL, 'Active'),
(77, '230093016', 'Paiman', 'Jerry', 'Chavez', 'Logistics Driver', NULL, 'Active'),
(78, '142100616', 'Matos', 'Hazel', 'Pesuelo', 'Purchasing Executive', NULL, 'Active'),
(79, '231111616', 'Maganti', 'Joel', 'Matawaran', 'Boomtruck Operator', NULL, 'Active'),
(80, '150112816', 'Susana', 'Numeriano Jr.', 'Amosco', 'Safety Officer', NULL, 'Active'),
(81, '239020217', 'Ordas li', 'Reynaldo', 'Geroca', 'Logistics Driver', NULL, 'Active'),
(82, '158021317', 'Francisco', 'Christian James', 'Reyes', 'Project Engineer', NULL, 'Active'),
(83, '211030217', 'Cabais', 'Rogelio', 'C.', 'Driver / Logistics', NULL, 'Active'),
(84, '233030717', 'Bayotas', 'Irwin', 'Mercado', 'Design Engineer', NULL, 'Active'),
(85, '169032817', 'Pedroza', 'Charmaine', 'Edama', 'Quality System Admin Executive', NULL, 'Active'),
(86, '171040317', 'Monsalud', 'Ariel', 'Villaruel', 'Design Engineer', NULL, 'Active'),
(87, '202040617', 'Ingles', 'Wendie Marie', 'Catacutan', 'Accounting Executive', NULL, 'Active'),
(88, '249052617', 'Baroga', 'Renan', 'Roxas', 'Pipe Fitter', NULL, 'Active'),
(89, '207052917', 'Espenida', 'John Paul', 'Guardian', 'Maintenance Operator', NULL, 'Active'),
(90, '213061617', 'Comia', 'Jerline', 'Cortas', 'Quality System Admin Executive', NULL, 'Active'),
(91, '252102317', 'Pugal', 'Jackie', 'Decina', 'Site Administration Executive', NULL, 'Active'),
(92, '258040318', 'Mamaril', 'Regin', 'Delos Santos', 'Project in Charge', NULL, 'Active'),
(93, '263052818', 'San Jose', 'Jackie', 'Severo', 'Executive Secretary', NULL, 'Active'),
(94, '268082018', 'Sanchez', 'Nonito Jr.', 'Malabuyoc', 'Safety Officer', NULL, 'Active'),
(95, '277110918', 'Jamlang', 'Francisco', 'Ramos', 'Technician / Welder', NULL, 'Active'),
(96, '280112818', 'De Dios', 'Joel', 'Flores', 'Technician / Painter', NULL, 'Active'),
(97, '284121018', 'Altamera', 'Isidro Jay', 'Camu', 'Technician / Scaffolder', NULL, 'Active'),
(98, '290012819', 'Cerdenia', 'Ronald', 'Domalaon', 'Safety Officer', NULL, 'Active'),
(99, '297021819', 'Tambis', 'Jeremy Nicole', 'Makiling', 'Site Administration Executive', NULL, 'Active'),
(100, '299031419', 'Epan', 'Christen', 'Bernardo', 'Design Engineer', NULL, 'Active'),
(101, '313051019', 'Malabanan', 'Marvin', 'Pantas', 'Safety Officer', NULL, 'Active'),
(102, '317052319', 'Osesao', 'Romeo', 'Rivera', 'Scaffolder', NULL, 'Active'),
(103, '321060619', 'Recto', 'Jose Claro V', 'Manaois', 'Project Engineer', NULL, 'Active'),
(104, '323061019', 'Hipolito', 'Lady Katelien', 'Alfonso', 'Site Administration Executive', NULL, 'Active'),
(105, '325061119', 'Francia', 'Mark Jay', 'Argarin', 'Safety Officer', NULL, 'Active'),
(106, '333062419', 'Santos', 'Jeron', 'Balagtas', 'QA / QC Engineer', NULL, 'Active'),
(107, '335070119', 'Rafanan', 'Melissa', 'Oro', 'Site Administration Executive', NULL, 'Active'),
(108, '336070219', 'Hernandez', 'Saul Darius', 'Romasanta', 'Project Engineer', NULL, 'Active'),
(109, '340070919', 'Lalas', 'Edmar', 'Sagun', 'QA /QC Engineer', NULL, 'Active'),
(110, '354090419', 'Obias', 'Roderick', 'Anosa', 'Utility', NULL, 'Active'),
(111, '356100719', 'Castillo', 'Laurence', 'Flores', 'Project Engineer', NULL, 'Active'),
(112, '191071412', 'Isla', 'Viloria', NULL, 'Site Supervisor', NULL, 'Active'),
(113, '320052719', 'Pacia', 'Peter Paul', 'Belga', 'Draughtsman', NULL, 'Active'),
(114, '384061520', 'Alfonso', 'Al', 'Gabiazon', 'Maintenance Operator', NULL, 'Active'),
(115, '385070620', 'Hortillosa', 'Neormel Penn', 'Buenafe', 'Logistics Assistant', NULL, 'Active'),
(116, '389072120', 'Timpog', 'Joana Mae', 'Ocampo', 'Accounting Executive', NULL, 'Active'),
(117, '390072020', 'Limosnero', 'Ellen Grace', 'Galos', 'Site Administration Executive', NULL, 'Active'),
(118, '391080320', 'De Guzman', 'Yvonne', 'Lago', 'Technical Sourcing Engineer', NULL, 'Active'),
(119, '392081020', 'Carreon', 'Erica', 'Vergara', 'QA / QC Engineer', NULL, 'Active'),
(120, '400100820', 'Laguin', 'Stephen', 'Basilio', 'Drups Supervisor - Project Engineer', NULL, 'Active'),
(121, '401101920', 'Pena', 'Mark Joseph', 'Mayuga', 'Purchasing Executive', NULL, 'Active'),
(122, '413112420', 'Lapira', 'Ivy', 'Sicat', 'Project Nurse', NULL, 'Active'),
(123, '428010521', 'Lorenzo', 'Mauro Jr.', 'Isidro', 'Draughtsman', NULL, 'Active'),
(124, '435011121', 'Patdu', 'Petunia', 'Villasor', 'Safety Officer', NULL, 'Active'),
(125, '442012521', 'Monsalud', 'Paul Henry', 'Villaruel', 'Project Scheduler / Planner', NULL, 'Active'),
(126, '450021521', 'Miguel', 'Trina Faith', 'Villanueva', 'Purchasing Executive', NULL, 'Active'),
(127, '457032921', 'Alvarez', 'Lynard Jake', 'Antipolo', 'Warehouse Supervisor', NULL, 'Active'),
(128, '458033121', 'Santos', 'Neil Tristan', 'Belga', 'Safety Officer', NULL, 'Active'),
(129, '459040821', 'Achacoso', 'Bryan Christian', NULL, 'Warehouse Custodian', NULL, 'Active'),
(130, '462051021', 'Jetomo', 'Mark Anthony', 'M', 'Project Engineer', NULL, 'Active'),
(131, '463021421', 'Paler', 'Jonas', 'Capua', 'Electrician', NULL, 'Active'),
(132, '467052421', 'Alicoben', 'Alvin James', 'Recto', 'Electrician', NULL, 'Active'),
(133, '469052421', 'Gregorio', 'Jayson', 'Estabaya', 'Electrician', NULL, 'Active'),
(134, '470052421', 'Lopez', 'Marlon', 'Melo', 'Electrician', NULL, 'Active'),
(135, '472052421', 'Pascual', 'Angelo Jr.', 'Morales', 'Electrician', NULL, 'Active'),
(136, '474052921', 'Pensader', 'Ryan', 'Gardoque', 'Electrician', NULL, 'Active'),
(137, '476053121', 'Agustin', 'Steven', 'Macairan', 'Electrician', NULL, 'Active'),
(138, '481060421', 'Francisco', 'Hernandez', 'C', 'Warehouse Manager', NULL, 'Active'),
(139, '482060721', 'Villeza', 'Fernando', 'Mendoza', 'Purchasing Executive', NULL, 'Active'),
(140, '483062821', 'Peralta', 'Danilo', 'Cudjao', 'Safety Officer', NULL, 'Active'),
(141, '486071621', 'Gaza', 'Jones', 'Castro', 'Safety Officer', NULL, 'Active'),
(142, '488071921', 'Carlos', 'Nerry', 'Rivera', 'Project Manager', NULL, 'Active'),
(143, '490080221', 'Guinoban', 'Marvin', 'Visco', 'Project Manager', NULL, 'Active'),
(144, '492080921', 'Abadies', 'Rubelyn', 'Magsayo', 'Receptionist', NULL, 'Active'),
(145, '494091321', 'Lara', 'Frederick', 'Santander', 'Warehouse Custodian', NULL, 'Active'),
(146, '496111021', 'Anadon', 'Keed', 'Camdano', 'Foreman', NULL, 'Active'),
(147, '497111821', 'Paytocan', 'Gordon', 'Rebleza', 'Project Engineer', NULL, 'Active'),
(148, '499011322', 'Guiao', 'Howell', 'Aquino', 'Warehouse Custodian', NULL, 'Active'),
(149, '500031822', 'Mina', 'Joseph Allen', NULL, 'Logistics Driver', NULL, 'Active'),
(150, '502032822', 'Panganiban', 'May Sherry', 'Gurrobat', 'Sales Engineer', NULL, 'Active'),
(151, '503032222', 'Bantillo', 'Regalado Jr.', 'Panesta', 'Electrician', NULL, 'Active'),
(152, '504041822', 'Posadas', 'Rodel', 'Robles', 'Safety Officer', NULL, 'Active'),
(153, '505050622', 'Polido', 'Roland', 'Orin', 'Foreman', NULL, 'Active'),
(154, '506072622', 'Magsico', 'Reynaldo', 'Barcebal', 'Electrician', NULL, 'Active'),
(155, '507072722', 'ROyo', 'Juluis', 'Santos', 'Safety Officer', NULL, 'Active'),
(156, '508080922', 'Vitug', 'Ralph Mycko', 'Endraca', 'Draughtsman', NULL, 'Active'),
(157, '509080822', 'Camba', 'Kimberly', 'Balleras', 'Human Resource & Safety Head-Assistant', NULL, 'Active'),
(158, '510081622', 'Santelices', 'Vicente', 'Castillo', 'Computer Programmer', 'QSAE', 'Active'),
(159, '511081822', 'Tigson', 'Johnmar', 'Geguillan', 'Quantity Surveyor', NULL, 'Active'),
(160, '512082222', 'Diaz', 'Renz', 'Datu', 'Project Engineer', NULL, 'Active'),
(161, '513082222', 'Duldulao', 'Wilson', 'Cabias', 'Draughtsman', NULL, 'Active'),
(162, '514081622', 'Balaengan', 'Rosewin', 'Ebas', 'Material Controller', NULL, 'Active'),
(163, '515090122', 'Yumul', 'Jayce', 'Cabrera', 'Warehouse Supervisor', NULL, 'Active'),
(164, '516091922', 'Villanueva', 'Cathy', 'Tajanlangit', 'Quality System Admin Executive', NULL, 'Active'),
(165, '517092022', 'Tolentino', 'Maria Liberty', 'Cunanan', 'Human Resource & Safety Head-Assistant', NULL, 'Active'),
(166, '5181092122', 'Sinday', 'Ofelia', 'Doroja', 'Safety & Logistics Admin Executive', NULL, 'Active'),
(167, '519091422', 'Landicho', 'Glenard', 'Lobaton', 'Safety Officer', NULL, 'Active'),
(168, '523120722', 'Saguisa', 'Alvynnia Johanna', NULL, 'QA/AC Engineer', 'Operation', NULL),
(169, '530011423', 'Farao-ed', 'Zerzex Adrian Lee', NULL, 'Project Engineer', 'Operation', NULL),
(170, '528011023', 'Enriquez', 'Jun', NULL, 'Material Controller', 'Operation', NULL);

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `item_category`
--

CREATE TABLE `item_category` (
  `id` bigint(20) NOT NULL,
  `category` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `item_category`
--

INSERT INTO `item_category` (`id`, `category`) VALUES
(1, 'Keyboard'),
(2, 'Cord'),
(3, 'Storage'),
(4, 'Memory'),
(5, 'Driver'),
(6, 'Sim Card'),
(7, 'Cellphone');

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

--
-- Table structure for table `item_list`
--

CREATE TABLE `item_list` (
  `id` bigint(20) NOT NULL,
  `itemcode` longtext,
  `itemcategory` longtext,
  `brand` longtext,
  `itemdescription` longtext,
  `price` double DEFAULT NULL,
  `datepurchased` longtext,
  `status` longtext,
  `deploystatus` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `item_list`
--

INSERT INTO `item_list` (`id`, `itemcode`, `itemcategory`, `brand`, `itemdescription`, `price`, `datepurchased`, `status`, `deploystatus`) VALUES
(1, 'SN2002701308097', '2', 'HDMI UGREEN', 'Black 1.5m', NULL, '2022-11-14', NULL, 'Deploy'),
(2, 'SN2002701357805', '2', 'HDMI UGREEN', 'Black 1.5m', NULL, '2022-11-14', NULL, NULL),
(3, 'SN2002701308331', '2', 'HDMI UGREEN', 'Black 1.5m', NULL, '2022-11-14', NULL, 'Deploy'),
(4, 'Asus01', '1', 'Asus', 'Black wired keyboard', NULL, '2022-11-14', NULL, NULL),
(5, 'Sandisk01', '3', 'Sandisk', '128 GB', NULL, '2022-11-14', NULL, 'Deploy'),
(6, 'Sandisk02', '3', 'Sandisk', '128 GB', NULL, '2022-11-14', NULL, 'Deploy'),
(7, '2233E652F00B', '3', 'Crucial', '250 GB', NULL, '2022-11-14', NULL, NULL),
(8, 'K004478', '4', 'Kingston', '8GB DDR4 2666MHz', NULL, '2022-11-14', NULL, NULL),
(9, 'K001403', '4', 'Kingston', '8GB DDR4 2666MHz', NULL, '2022-11-14', NULL, 'Deploy'),
(10, 'Seagate1', '3', 'Seagate', 'P/N:691918-003', NULL, NULL, NULL, NULL),
(11, 'HP03', '5', 'HP', 'Super Multi DVD Writer', NULL, NULL, NULL, NULL),
(12, 'Memory04', '4', 'no brand', 'SN:S10484953 4GB memory', NULL, NULL, NULL, NULL),
(13, 'SIM05', '6', 'Globe', NULL, NULL, NULL, NULL, NULL),
(14, 'Samsung06', '7', 'Samsung', 'Samsung Galaxy A12 Black', NULL, NULL, NULL, NULL),
(15, 'Globe07', '6', 'Globe', 'Globe 5G Sim card / 4213-1402-1127-6297', NULL, '2023-01-06', NULL, NULL),
(16, 'Samsung08', '7', 'Samsung', 'SN:R9JR505DTFP, Galaxy A11', NULL, NULL, NULL, NULL);

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

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

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

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(5, '2014_10_12_000000_create_users_table', 1),
(6, '2014_10_12_100000_create_password_resets_table', 1),
(7, '2019_08_19_000000_create_failed_jobs_table', 1),
(8, '2019_12_14_000001_create_personal_access_tokens_table', 1);

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

--
-- Table structure for table `other_checklist`
--

CREATE TABLE `other_checklist` (
  `id` bigint(20) NOT NULL,
  `idnumber` longtext,
  `computername` longtext,
  `checklist_number` bigint(20) DEFAULT NULL,
  `checklist_item` longtext,
  `findings` longtext,
  `remarks` longtext,
  `datecheck` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `peripheral_list`
--

CREATE TABLE `peripheral_list` (
  `id` bigint(20) NOT NULL,
  `itemcode` longtext,
  `computername` longtext,
  `datedeployed` date DEFAULT NULL,
  `status` longtext,
  `datepullout` date DEFAULT NULL,
  `statuspullout` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `peripheral_list`
--

INSERT INTO `peripheral_list` (`id`, `itemcode`, `computername`, `datedeployed`, `status`, `datepullout`, `statuspullout`) VALUES
(1, 'SN2002701308097', 'PC95', '2022-11-16', 'Deployed', NULL, NULL),
(2, 'SN2002701308331', 'PC08', '2022-11-16', 'Deployed', NULL, NULL),
(3, 'K001403', 'Lenovo108', '2022-11-22', 'Deployed', NULL, NULL);

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

--
-- Table structure for table `preventive_maintenance`
--

CREATE TABLE `preventive_maintenance` (
  `id` bigint(20) NOT NULL,
  `itemcode` longtext,
  `computername` longtext,
  `datedeployed` date DEFAULT NULL,
  `datecheck` date DEFAULT NULL,
  `status` longtext,
  `remarks` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `preventive_maintenance_software`
--

CREATE TABLE `preventive_maintenance_software` (
  `id` bigint(20) NOT NULL,
  `itemcode` longtext,
  `computername` longtext,
  `datedeployed` date DEFAULT NULL,
  `datecheck` date DEFAULT NULL,
  `remarks` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `application_list`
--
ALTER TABLE `application_list`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `assigned_user`
--
ALTER TABLE `assigned_user`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;

--
-- AUTO_INCREMENT for table `computer_registration`
--
ALTER TABLE `computer_registration`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=128;

--
-- AUTO_INCREMENT for table `employee_info`
--
ALTER TABLE `employee_info`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=171;

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

--
-- AUTO_INCREMENT for table `item_category`
--
ALTER TABLE `item_category`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `item_list`
--
ALTER TABLE `item_list`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

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

--
-- AUTO_INCREMENT for table `peripheral_list`
--
ALTER TABLE `peripheral_list`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

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

