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

START TRANSACTION;



--
-- Database: `iomt`
--

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `email` varchar(100) NOT NULL,
  `name` text NOT NULL,
  `dob` text NOT NULL,
  `gender` text NOT NULL,
  `password` varchar(100) NOT NULL,
  `social` int NOT NULL,
  `timestamp` varchar(100) NOT NULL,
  `otp` int NOT NULL,
  `photoURL` varchar(2000) NOT NULL,
  `city` text NOT NULL,
  `state` text NOT NULL,
  `verified` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`email`, `name`, `dob`, `gender`, `password`, `social`, `timestamp`, `otp`, `photoURL`, `city`, `state`, `verified`) VALUES
('ichbinadittyadey@gmail.com', 'Adittya Dey', '01-01-1999', 'M', '$2y$10$CERpKdQxHB9M9KcHYJKvyu3YRHyFo7Z6/HWdCnraIYZhbCE02MSX.', 0, '19-03-2023 00:11', 7532, 'xyzaschyvbdjui', 'XYZ', 'WXYZ', 0),
('pratikchanda2000.pc@gmail.com', 'Pratik Chanda', '30-12-2000', 'M', '$2y$10$ikB3GNSpcipO1MwmpBoDSOF9CgbZcg6xhbJ/cGlCfBAvoYvSl/.wO', 0, '10-03-2023 23:13', 2681, 'xyzaschyvbdjui', 'Tezpur', 'Assam', 0),
('tanu.gitee02@gmail.com', 'Tanushree  Das', '01-01-2002', 'M', '$2y$10$.IFMpcchwBfhAffaq2SVJ.liKUdmWC8xfqfku1XePID6Pnmmv.v9.', 0, '25-06-2023 15:50', 3194, 'photoURL', 'NONE', 'NONE', 0);

--
-- Indexes for dumped tables
--

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

