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

START TRANSACTION;



--
-- Database: `esuporta`
--

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

--
-- Table structure for table `all_requests`
--

CREATE TABLE `all_requests` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `remarks` varchar(100) NOT NULL,
  `date_received` date NOT NULL DEFAULT current_timestamp(),
  `date_accomplished` date NOT NULL,
  `tracking_no` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `all_requests`
--

INSERT INTO `all_requests` (`id`, `username`, `type`, `status`, `remarks`, `date_received`, `date_accomplished`, `tracking_no`) VALUES
(1, 'AliAldin VanTirasol ', '', '', '', '2024-02-16', '0000-00-00', 'B862681A'),
(2, 'AliAldin VanTirasol ', 'CREATE DEPED EMAIL', '', '', '2024-02-16', '0000-00-00', 'B166581A'),
(3, 'AliAldin VanTirasol ', 'CREATE DEPED EMAIL', 'ONGOING', '', '2024-02-16', '0000-00-00', 'B245879A'),
(4, 'alialdinvan', 'CREATE DEPED EMAIL', 'ONGOING', '', '2024-02-16', '0000-00-00', 'B455420A'),
(5, 'alialdinvan', 'CREATE DEPED EMAIL', 'ONGOING', '', '2024-02-16', '0000-00-00', 'B336021A'),
(6, 'alialdinvan', 'CREATE DEPED EMAIL', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-16', '2024-02-22', ''),
(7, 'alialdinvan', 'RESET DEPED EMAIL', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-16', '2024-02-22', ''),
(8, 'alialdinvan', 'CREATE DEPED EMAIL', 'ONGOING', '', '2024-02-16', '0000-00-00', 'B26287A'),
(9, 'alialdinvan', 'CREATE DEPED EMAIL', 'ONGOING', '', '2024-02-16', '0000-00-00', 'B643109A'),
(10, 'alialdinvan', 'CREATE DEPED EMAIL', 'DONE', 'Sent to your email.THank you!', '2024-02-16', '2024-02-16', 'B449820A'),
(11, 'alialdinvan', 'CREATE DEPED EMAIL', 'ONGOING', '', '2024-02-16', '0000-00-00', 'B806805A'),
(12, 'alialdinvan', 'RESET DEPED EMAIL', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-16', '2024-02-22', ''),
(13, 'alialdinvan', 'RESET DEPED EMAIL', 'ONGOING', '', '2024-02-16', '0000-00-00', 'C519482D'),
(14, 'alialdinvan', 'RESET DEPED EMAIL', 'DONE', 'Sent to your email.THank you!', '2024-02-16', '2024-02-16', 'C365896D'),
(15, 'alialdinvan', 'RESET DUPLICATE EMAIL', 'DONE', 'Sent to your email.THank you!', '2024-02-16', '2024-02-16', 'E49400F'),
(16, 'alialdinvan', 'RESET DUPLICATE EMAIL', 'DONE', 'Sent to your email.THank you!', '2024-02-16', '2024-02-16', 'E309022F'),
(17, 'alialdinvan', 'RESET DUPLICATE EMAIL', 'DONE', 'Sent to your email.THank you!', '2024-02-16', '2024-02-16', 'E817021F'),
(18, 'alialdinvan', 'RESET DUPLICATE EMAIL', 'DONE', 'Sent to your email.THank you!', '2024-02-16', '2024-02-16', 'E178647F'),
(19, 'alialdinvan', 'RESET DUPLICATE EMAIL', 'DONE', 'Sent to your email.THank you!', '2024-02-16', '2024-02-16', 'E288205F'),
(20, 'alialdinvan', 'RESET DUPLICATE EMAIL', 'ONGOING', '', '2024-02-16', '0000-00-00', 'G772384H'),
(21, 'alialdinvan', 'REQUEST O365 ACCOUNT', 'ONGOING', '', '2024-02-16', '0000-00-00', 'G774285H'),
(22, 'alialdinvan', 'REQUEST O365 ACCOUNT', 'ONGOING', '', '2024-02-16', '0000-00-00', 'G43952H'),
(23, 'alialdinvan', 'REQUEST O365 ACCOUNT', 'ONGOING', '', '2024-02-16', '0000-00-00', 'G741651H'),
(24, 'alialdinvan', 'REQUEST O365 ACCOUNT', 'ONGOING', '', '2024-02-16', '0000-00-00', 'G364421H'),
(25, 'alialdinvan', 'REQUEST O365 ACCOUNT', 'DONE', 'Done,please check your personal email.Thank you!', '2024-02-16', '2024-02-16', 'G293732H'),
(26, 'ALDINVAN', 'REQUEST O365 ACCOUNT', 'ONGOING', '', '2024-02-22', '0000-00-00', 'I563099J'),
(27, 'ALDINVAN', 'RESET O365 ACCOUNT', 'DONE', 'Sent to your email.THank you!', '2024-02-22', '2024-02-22', 'I151363J'),
(28, 'ALDINVAN', 'RESET O365 ACCOUNT', 'DONE', 'Done, please check details sent to your personal email.Thank you!', '2024-02-22', '2024-02-22', 'I380308J'),
(29, 'ALDINVAN', 'DELETE O365 ACCOUNT', 'DONE', 'Deleted.Thank you!', '2024-02-22', '2024-02-22', 'K5268L'),
(30, 'ALDINVAN', 'DELETE O365 ACCOUNT', 'DONE', 'Deleted.Thank you!', '2024-02-22', '2024-02-22', 'K472340L'),
(31, 'ALDINVAN', 'RESET O365 ACCOUNT', 'DONE', 'Done, please check details sent to your personal email.Thank you!', '2024-02-22', '2024-02-22', 'M10717N'),
(32, 'ALDINVAN', 'RESET O365 ACCOUNT', 'DONE', 'Update sent to your email.Thank you!', '2024-02-22', '2024-02-22', 'M11377N'),
(33, 'ALDINVAN', 'RESET O365 ACCOUNT', 'DONE', 'Update sent to your email.Thank you!', '2024-02-22', '2024-02-22', 'M103496N'),
(34, 'ALDINVAN', 'DELETE O365 ACCOUNT', 'ONGOING', '', '2024-02-22', '0000-00-00', 'O177411P'),
(35, 'ALDINVAN', 'UPDATE O365 ACCOUNT', 'DONE', 'Done,please details on your personal email.Thank you!', '2024-02-22', '2024-02-22', 'O115474P'),
(36, 'ALDINVAN', 'UPDATE O365 ACCOUNT', 'DONE', 'Done,please details on your personal email.Thank you!', '2024-02-22', '2024-02-22', 'O556022P'),
(37, 'ALDINVAN', 'RESET O365 ACCOUNT', 'DONE', 'Done, please check details sent to your personal email.Thank you!', '2024-02-22', '2024-02-22', 'Q647202R'),
(38, 'ALDINVAN', 'RESET SCHOOL O365 ACCOUNT', 'DONE', 'Done, please check  the details you personal email.Thank you!', '2024-02-22', '2024-02-22', 'Q582352R'),
(39, 'ALDINVAN', 'RESET SCHOOL O365 ACCOUNT', 'DONE', 'Done, please check  the details you personal email.Thank you!', '2024-02-22', '2024-02-22', 'Q173676R'),
(40, 'ALDINVAN', 'CREATION DPDS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', ''),
(41, 'ALDINVAN', 'CREATION DPDS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', ''),
(42, 'ALDINVAN', 'CREATION DPDS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', ''),
(43, 'ALDINVAN', 'CREATION DPDS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', ''),
(44, 'ALDINVAN', 'CREATION DPDS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', 'S560458T'),
(45, 'ALDINVAN', 'CREATION DPDS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', 'S625965T'),
(46, 'ALDINVAN', 'RESET DPDS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', ''),
(47, 'ALDINVAN', 'RESET DPDS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', ''),
(48, 'ALDINVAN', 'RESET DPDS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', 'U44428V'),
(49, 'ALDINVAN', 'RESET DPDS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', 'U75303V'),
(50, 'ALDINVAN', 'UPDATE DEPED EMAIL', 'DONE', 'Information update and was sent to your email.Thank you!', '2024-02-22', '2024-02-22', 'W659933X'),
(51, 'ALDINVAN', 'UPDATE DEPED EMAIL', 'DONE', 'Information update and was sent to your email.Thank you!', '2024-02-22', '2024-02-22', 'W32676X'),
(52, 'ALDINVAN', 'CREATION WINS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', ''),
(53, 'ALDINVAN', 'CREATION WINS', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', ''),
(54, 'ALDINVAN', 'CREATION WINS', 'DONE', 'Done,please check your personal email.Thank you!', '2024-02-22', '2024-02-22', 'Y17803Z'),
(55, 'ALDINVAN', 'CREATION WINS', 'DONE', 'Done,please check your personal email.Thank you!', '2024-02-22', '2024-02-22', 'Y477631Z'),
(56, 'ALDINVAN', 'RESET WINS ACCOUNT', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', ''),
(57, 'ALDINVAN', 'RESET WINS ACCOUNT', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', ''),
(58, 'ALDINVAN', 'RESET WINS ACCOUNT', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', 'A786010A'),
(59, 'ALDINVAN', 'RESET WINS ACCOUNT', 'DONE', 'Done, please check  the details on your personal email.Thank you!', '2024-02-22', '2024-02-22', 'A782150A'),
(60, 'ALDINVAN', 'RESET WINS ACCOUNT', 'ONGOING', '', '2024-02-22', '0000-00-00', ''),
(61, 'ALDINVAN', 'RESET WINS ACCOUNT', 'ONGOING', '', '2024-02-22', '0000-00-00', 'A6568292'),
(62, 'ALDINVAN', 'DHCP TECHNICAL ASSISTANCE', 'ONGOING', '', '2024-02-22', '0000-00-00', 'A7822972');

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

--
-- Table structure for table `correction_o365`
--

CREATE TABLE `correction_o365` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `o365_acc` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL DEFAULT current_timestamp(),
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `correction_o365`
--

INSERT INTO `correction_o365` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `o365_acc`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, 'M11377N', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'dfdsfsfs', 'DONE', '2024-02-22', '1', 'Update sent to your ', '2024-02-22'),
(0, 'M103496N', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'vxcbxcbcxbxcbcxbdfhttjh', 'DONE', '2024-02-22', '1', 'Update sent to your ', '2024-02-22');

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

--
-- Table structure for table `cre_0365_acc`
--

CREATE TABLE `cre_0365_acc` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL DEFAULT current_timestamp(),
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL,
  `sc_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `cre_0365_acc`
--

INSERT INTO `cre_0365_acc` (`id`, `tracking_no`, `username`, `fullname`, `email`, `designation`, `deped_email`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`, `sc_id`) VALUES
(0, 'G772384H', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', '574cda1f81ea411d326698a570d0c3dc', 'aldinvan.ali@deped.gov.ph', 'DONE', '2024-02-16', '15', 'Account information ', '2024-02-16', 0),
(0, 'G774285H', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', '574cda1f81ea411d326698a570d0c3dc', 'aldinvan.ali@deped.gov.ph', 'DONE', '2024-02-16', '15', 'Account information ', '2024-02-16', 0),
(0, 'G43952H', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', '574cda1f81ea411d326698a570d0c3dc', 'aldinvan.ali@deped.gov.ph', 'DONE', '2024-02-16', '15', 'Account information ', '2024-02-16', 0),
(0, 'G741651H', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', '574cda1f81ea411d326698a570d0c3dc', 'aldinvan.ali@deped.gov.ph', 'DONE', '2024-02-16', '15', 'Account information ', '2024-02-16', 55555),
(0, 'G364421H', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', '574cda1f81ea411d326698a570d0c3dc', 'aldinvan.ali@deped.gov.ph', 'DONE', '2024-02-16', '15', 'Account information ', '2024-02-16', 55555),
(0, 'G293732H', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', '574cda1f81ea411d326698a570d0c3dc', 'aldinvan.ali@deped.gov.ph', 'DONE', '2024-02-16', '15', 'Done,please check yo', '2024-02-16', 55555),
(0, 'I563099J', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', '', '', 'ONGOING', '2024-02-22', '15', '', '0000-00-00', 0);

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

--
-- Table structure for table `cre_deped_email`
--

CREATE TABLE `cre_deped_email` (
  `id` int(11) NOT NULL DEFAULT 0,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL DEFAULT current_timestamp(),
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL,
  `tracking_no` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `cre_deped_email`
--

INSERT INTO `cre_deped_email` (`id`, `username`, `fullname`, `email`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`, `tracking_no`) VALUES
(1, 'admingsdgsdgdg', 'ddgsgdfsdgdg', 'dsgggg@gmail.com', 'DONE', '0000-00-00', '0', 'Sent to your email. ', '0000-00-00', ''),
(2, '0123', 'ALIALDIN VANTIRASOL ', 'dsgggg@gmail.com', 'DONE', '0000-00-00', '0', 'Sent to your email.T', '0000-00-00', ''),
(3, 'VANALIDIN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'DONE', '0000-00-00', '0', 'Sent to your email.T', '0000-00-00', ''),
(4, 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'DONE', '0000-00-00', '0', 'Sent to your email.T', '0000-00-00', ''),
(0, '', 'AliAldin VanTirasol ', '8007e77a0cd63c8460c8192330c0c951', 'DONE', '2024-02-16', '', 'Sent to your email.T', '2024-02-16', 'B862681A'),
(0, '', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'DONE', '2024-02-16', '', 'Sent to your email.T', '2024-02-16', 'B862681A'),
(0, '', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'DONE', '2024-02-16', '', 'Sent to your email.T', '2024-02-16', 'B862681A'),
(0, '', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'DONE', '2024-02-16', '', 'Sent to your email.T', '2024-02-16', 'B166581A'),
(0, '', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'DONE', '2024-02-16', '', 'Sent to your email.T', '2024-02-16', 'B245879A'),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'DONE', '2024-02-16', '', 'Sent to your email.T', '2024-02-16', 'B455420A'),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'DONE', '2024-02-16', '', 'Sent to your email.T', '2024-02-16', 'B336021A'),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'DONE', '2024-02-16', '2', 'Sent to your email.T', '2024-02-16', 'B26287A'),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'DONE', '2024-02-16', '2', 'Sent to your email.T', '2024-02-16', 'B643109A'),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'DONE', '2024-02-16', '2', 'Sent to your email.T', '2024-02-16', 'B449820A'),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'DONE', '2024-02-16', '2', 'Sent to your email.T', '2024-02-16', 'B806805A');

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

--
-- Table structure for table `cre_dpds`
--

CREATE TABLE `cre_dpds` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `sc_id` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL DEFAULT current_timestamp(),
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `cre_dpds`
--

INSERT INTO `cre_dpds` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `location`, `sc_id`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'SDO', '', 'DONE', '2024-02-22', '1', 'Done, please check t', '2024-02-22'),
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'SDO', '', 'DONE', '2024-02-22', '1', 'Done, please check t', '2024-02-22'),
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'SDO', '', 'DONE', '2024-02-22', '1', 'Done, please check t', '2024-02-22'),
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'SDO', '', 'DONE', '2024-02-22', '1', 'Done, please check t', '2024-02-22'),
(0, 'S560458T', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'SDO', '', 'DONE', '2024-02-22', '1', 'Done, please check t', '2024-02-22'),
(0, 'S625965T', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'SDO', '', 'DONE', '2024-02-22', '1', 'Done, please check t', '2024-02-22');

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

--
-- Table structure for table `cre_wind_acc`
--

CREATE TABLE `cre_wind_acc` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `sc_id` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL DEFAULT current_timestamp(),
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `cre_wind_acc`
--

INSERT INTO `cre_wind_acc` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `location`, `sc_id`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'SDO', '', 'DONE', '2024-02-22', '1', 'Account information ', '2024-02-22'),
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'SDO', '', 'DONE', '2024-02-22', '1', 'Account information ', '2024-02-22'),
(0, 'Y17803Z', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'SDO', '', 'DONE', '2024-02-22', '1', 'Account information ', '2024-02-22'),
(0, 'Y477631Z', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'SDO', '', 'DONE', '2024-02-22', '1', 'Account information ', '2024-02-22');

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

--
-- Table structure for table `delete_o365`
--

CREATE TABLE `delete_o365` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `o365_acc` varchar(100) NOT NULL,
  `reason_del` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL DEFAULT current_timestamp(),
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `delete_o365`
--

INSERT INTO `delete_o365` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `o365_acc`, `reason_del`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, 'K5268L', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'aldinvan.ali0365@deped.gov.ph', 'duplicate', 'DONE', '2024-02-22', '2', 'Deleted.Thank you!', '2024-02-22'),
(0, 'K472340L', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'dfdsfsfs', 'fsfsfsdfsfs', 'DONE', '2024-02-22', '1', 'Deleted.Thank you!', '2024-02-22'),
(0, 'O177411P', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'aldinvan.ali0365@deped.gov.ph', '', 'ONGOING', '2024-02-22', '1', '', '0000-00-00');

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

--
-- Table structure for table `dup_email`
--

CREATE TABLE `dup_email` (
  `id` int(11) NOT NULL DEFAULT 0,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `dup_email` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL DEFAULT current_timestamp(),
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL,
  `tracking_no` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `dup_email`
--

INSERT INTO `dup_email` (`id`, `username`, `fullname`, `email`, `dup_email`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`, `tracking_no`) VALUES
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', '', 'DONE', '2024-02-16', '2', 'Dupl;icate account d', '2024-02-16', 'E49400F'),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', '', 'DONE', '2024-02-16', '2', 'Dupl;icate account d', '2024-02-16', 'E309022F'),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', '', 'DONE', '2024-02-16', '2', 'Dupl;icate account d', '2024-02-16', 'E817021F'),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'dfsfgsdgsgdgdsgsd', 'DONE', '2024-02-16', '2', 'Dupl;icate account d', '2024-02-16', 'E178647F'),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'alialdinccan@!gmail.com', 'DONE', '2024-02-16', '2', 'Dupl;icate account d', '2024-02-16', 'E288205F');

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

--
-- Table structure for table `information`
--

CREATE TABLE `information` (
  `id` int(11) NOT NULL DEFAULT 0,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `district` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `role` varchar(20) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `sc_id` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `information`
--

INSERT INTO `information` (`id`, `username`, `fullname`, `location`, `district`, `deped_email`, `email`, `password`, `role`, `designation`, `sc_id`) VALUES
(1, 'admingsdgsdgdg', 'ddgsgdfsdgdg', 'gsdgsg', 'gsgg', 'dsgggg@gmail.com', 'dsgggg@gmail.com', 'b59c67bf196a4758191e42f76670ceba', 'ADMIN', '', ''),
(2, '0123', 'ALIALDIN VANTIRASOL ', 'n/a', 'SDO', 'dsgggg@gmail.com', 'dsgggg@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'ADMIN', '', ''),
(3, 'VANALIDIN', 'ALDIN VAN ALI', 'SDO', 'N/A', 'aldinvan.ali@deped.gov.ph', 'vanalialdin@gmail.com', '223a0a05d0985d391a128401233a4e3b', 'ADMIN', '', ''),
(4, 'ALDINVAN', 'ALDIN VAN ALI', 'SDO', 'N/A', 'aldinvan.ali@deped.gov.ph', 'vanalialdin@gmail.com', '223a0a05d0985d391a128401233a4e3b', 'USER', '', ''),
(0, 'alialdinvan', 'AliAldin VanTirasol ', 'Tingga Sorosoro Integrated School', 'District 6', 'aldinvan.ali@deped.gov.ph', 'vanalialdin@gmail.com', '0f359740bd1cda994f8b55330c86d845', 'USER', '574cda1f81ea411d326698a570d0c3dc', '55555');

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

--
-- Table structure for table `req_dhcp_ass`
--

CREATE TABLE `req_dhcp_ass` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `dhcp_batch` varchar(100) NOT NULL,
  `dhcp_issue` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL DEFAULT current_timestamp(),
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `req_dhcp_ass`
--

INSERT INTO `req_dhcp_ass` (`id`, `tracking_no`, `username`, `fullname`, `email`, `location`, `dhcp_batch`, `dhcp_issue`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, 'A7822972', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'SDO', '', '', 'ONGOING', '2024-02-22', '2', '', '0000-00-00');

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

--
-- Table structure for table `res_deped_per`
--

CREATE TABLE `res_deped_per` (
  `id` int(11) NOT NULL,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL DEFAULT current_timestamp(),
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `res_deped_per`
--

INSERT INTO `res_deped_per` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(1, '0', 'admingsdgsdgdg', 'ddgsgdfsdgdg', 'dsgggg@gmail.com', '', 'DONE', '0000-00-00', '0', 'Sent to your email. ', '0000-00-00'),
(2, '0', '0123', 'ALIALDIN VANTIRASOL ', 'dsgggg@gmail.com', '', 'DONE', '0000-00-00', '0', 'Sent to your email.T', '0000-00-00'),
(3, '0', 'VANALIDIN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', '', 'DONE', '0000-00-00', '0', 'Sent to your email.T', '0000-00-00'),
(4, '0', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', '', 'DONE', '0000-00-00', '0', 'Sent to your email.T', '0000-00-00'),
(0, '', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'DONE', '0000-00-00', '', 'Dupl;icate account d', '2024-02-16'),
(0, '', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'DONE', '0000-00-00', '2', 'Dupl;icate account d', '2024-02-16'),
(0, '', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'DONE', '0000-00-00', '2', 'Dupl;icate account d', '2024-02-16'),
(0, 'C519482D', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'DONE', '0000-00-00', '2', 'Dupl;icate account d', '2024-02-16'),
(0, 'C365896D', 'alialdinvan', 'AliAldin VanTirasol ', 'vanalialdin@gmail.com', '', 'DONE', '0000-00-00', '2', 'Dupl;icate account d', '2024-02-16');

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

--
-- Table structure for table `res_dpds`
--

CREATE TABLE `res_dpds` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `dpds_acc` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL,
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `res_dpds`
--

INSERT INTO `res_dpds` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `dpds_acc`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'dgsggdsgdsgdsgdgsg', 'DONE', '0000-00-00', '1', 'Done, please check t', '2024-02-22'),
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'hahahahahah', 'DONE', '0000-00-00', '1', 'Done, please check t', '2024-02-22'),
(0, 'U44428V', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'ggggg', 'DONE', '0000-00-00', '1', 'Done, please check t', '2024-02-22'),
(0, 'U75303V', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'ggggfdddddd', 'DONE', '0000-00-00', '1', 'Done, please check t', '2024-02-22');

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

--
-- Table structure for table `res_o365_pass`
--

CREATE TABLE `res_o365_pass` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `o365_acc` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL,
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `res_o365_pass`
--

INSERT INTO `res_o365_pass` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `o365_acc`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, 'I151363J', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', '', 'aldinvan.ali@deped.gov.ph', 'DONE', '0000-00-00', '2', 'Done, please check d', '2024-02-22'),
(0, 'I380308J', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', '', 'aldinvan.ali0365@deped.gov.ph', 'DONE', '0000-00-00', '2', 'Done, please check d', '2024-02-22'),
(0, 'M10717N', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'dfdsfsfs', 'DONE', '0000-00-00', '1', 'Done, please check d', '2024-02-22'),
(0, 'Q647202R', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', '', 'dsdgsgdsggdg', 'DONE', '0000-00-00', '1', 'Done, please check d', '2024-02-22');

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

--
-- Table structure for table `res_school_o365`
--

CREATE TABLE `res_school_o365` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `o365_acc` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL,
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `res_school_o365`
--

INSERT INTO `res_school_o365` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `o365_acc`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, 'Q582352R', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', '', 'dvsdzvdsvvGdfg', 'DONE', '0000-00-00', '1', 'Done, please check  ', '2024-02-22'),
(0, 'Q173676R', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'dvgsgsdgdggsdgsd', 'DONE', '0000-00-00', '1', 'Done, please check  ', '2024-02-22');

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

--
-- Table structure for table `res_wind_acc`
--

CREATE TABLE `res_wind_acc` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `wins_acct` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL,
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `res_wind_acc`
--

INSERT INTO `res_wind_acc` (`id`, `tracking_no`, `username`, `fullname`, `email`, `location`, `wins_acct`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'SDO', 'dgsdgggfhfdhgdfhdf', 'DONE', '0000-00-00', '1', 'Done, please check y', '2024-02-22'),
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'SDO', '', 'DONE', '0000-00-00', '1', 'Done, please check y', '2024-02-22'),
(0, 'A786010A', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'SDO', '', 'DONE', '0000-00-00', '1', 'Done, please check y', '2024-02-22'),
(0, 'A782150A', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'SDO', '', 'DONE', '0000-00-00', '1', 'Done, please check y', '2024-02-22'),
(0, '', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'SDO', '', 'ONGOING', '0000-00-00', '1', '', '0000-00-00'),
(0, 'A6568292', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'SDO', '', 'ONGOING', '0000-00-00', '1', '', '0000-00-00');

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

--
-- Table structure for table `update_info`
--

CREATE TABLE `update_info` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL,
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `update_info`
--

INSERT INTO `update_info` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, 'W659933X', 'ALDINVAN', 'ALDIN VAN ALI', 'aldinvan.ali@deped.gov.ph', 'vanalialdin@gmail.com', 'DONE', '0000-00-00', '2', 'Information update a', '2024-02-22'),
(0, 'W32676X', 'ALDINVAN', 'ALDIN VAN ALI', 'aldinvan.ali@deped.gov.ph', 'vanalialdin@gmail.com', 'DONE', '0000-00-00', '2', 'Information update a', '2024-02-22');

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

--
-- Table structure for table `update_o365`
--

CREATE TABLE `update_o365` (
  `id` int(11) NOT NULL DEFAULT 0,
  `tracking_no` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `deped_email` varchar(100) NOT NULL,
  `o365_acc` varchar(100) NOT NULL,
  `reason_update` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_received` date NOT NULL,
  `remaining_days` varchar(100) NOT NULL,
  `remarks` varchar(20) NOT NULL,
  `date_accomplished` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `update_o365`
--

INSERT INTO `update_o365` (`id`, `tracking_no`, `username`, `fullname`, `email`, `deped_email`, `o365_acc`, `reason_update`, `status`, `date_received`, `remaining_days`, `remarks`, `date_accomplished`) VALUES
(0, 'O115474P', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'xcvxvxvxv', '', 'DONE', '0000-00-00', '1', 'Done,please details ', '2024-02-22'),
(0, 'O556022P', 'ALDINVAN', 'ALDIN VAN ALI', 'vanalialdin@gmail.com', 'aldinvan.ali@deped.gov.ph', 'xgsgsgg', 'dsgsgsdggsgs', 'DONE', '0000-00-00', '1', 'Done,please details ', '2024-02-22');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `role` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `role`) VALUES
(1, 'admingsdgsdgdg', 'b59c67bf196a4758191e42f76670ceba', 'ADMIN'),
(2, '0123', 'e10adc3949ba59abbe56e057f20f883e', 'ADMIN'),
(3, 'VANALIDIN', '223a0a05d0985d391a128401233a4e3b', 'ADMIN'),
(4, 'ALDINVAN', '223a0a05d0985d391a128401233a4e3b', 'USER'),
(5, 'alialdinvan', '0f359740bd1cda994f8b55330c86d845', 'USER');

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

