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

START TRANSACTION;



--
-- Database: `ftv_models`
--

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

--
-- Table structure for table `api_keys`
--

CREATE TABLE `api_keys` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `my_key` varchar(40) NOT NULL,
  `level` int(2) NOT NULL,
  `ignore_limits` tinyint(1) NOT NULL DEFAULT 0,
  `is_private_key` tinyint(1) NOT NULL DEFAULT 0,
  `ip_addresses` text DEFAULT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `api_keys`
--

INSERT INTO `api_keys` (`id`, `user_id`, `my_key`, `level`, `ignore_limits`, `is_private_key`, `ip_addresses`, `date_created`) VALUES
(1, 0, '28F77ADCD4DB9', 0, 0, 0, NULL, '2022-11-08 14:41:37');

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

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

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(100) NOT NULL,
  `image` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `dob` varchar(255) NOT NULL,
  `phone_no` varchar(50) NOT NULL,
  `height` varchar(20) NOT NULL,
  `marrital_status` varchar(20) NOT NULL,
  `applied_for` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `gender` int(11) NOT NULL,
  `role_id` int(11) NOT NULL COMMENT '1=Admin,2=users',
  `is_active` int(1) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `user` (`id`, `name`, `email`, `image`, `password`, `dob`, `phone_no`, `height`, `marrital_status`, `applied_for`, `state`, `city`, `gender`, `role_id`, `is_active`, `created_at`) VALUES
(4, 'satej chauhan', 'satejbharat123@gmail.com', 'default.jpg', '0', '2022', '7897897895', '172', '1', '1', 'Maharashtra', 'Mumbai', 0, 2, 1, '2022-10-04 10:45:26'),
(5, 'Aarti', 'ingaleaarti956@gmail.com', 'default.jpg', '$2y$10$8xr08hDQrJD4H.vxPlBEZObr9JtHh1U8wd1oCV9UdoSAaBBSYTGey', '2022-10-04', '7897897895', '166', '2', '3', 'Arunachal Pradesh', 'Bondila', 0, 2, 1, '2022-10-04 10:49:07'),
(6, 'Hemant', 'hemant.karekar15@gmail.com', 'user.jpg', '$2y$10$nUwXRkHdES/YUpOV7aKzVeDdxMWuaph7pcwFhU8dpGaWsjOUN753i', '2022-10-03', '7897897895', '172', '2', '2', 'Maharashtra', 'Mumbai', 0, 1, 1, '2022-10-04 10:50:06'),
(7, 'rupali', 'pendkalkarrupaliv@gmail.com', 'default.jpg', '$2y$10$oiI7M0tfM1V7HrbXoiA8yOdlgJ5LDvaz2yYPHdpQoRxsp/LkzeFXq', '1999-06-21', '7897897895', '155', '1', '2', 'Maharashtra', 'Mumbai', 0, 2, 0, '2022-10-07 12:51:06'),
(8, 'satej chauhan', 'satej.eleplace@gmail.com', 'default.jpg', '$2y$10$BvFvM/6FElJGLN9Y5LwKx.yL4TbyixouRaAWoxiEUgOEjtNlvAYkm', '1997-02-28', '8805159984', '166', '1', '2', 'Maharashtra', 'Mumbai', 0, 2, 1, '2022-10-07 12:55:24'),
(9, 'Gignesh name', 'jignesh@yopmail.com', 'user1.jpg', '$2y$10$BwAoSaOPI7omqGpw.J4i/upLGgJ0ClJQshwwpD39eeZStTJaI8OiG', '1993-01-12', '1232131234', '172', '1', '2', 'Bihar', 'Areraj', 0, 2, 1, '2022-10-07 15:44:28'),
(10, 'Akashay', 'helloakashay27@gmail.com', 'default.jpg', '$2y$10$uitVUYBtMdrGAnhS3scy8uhHrs896TMDxfexz1nb6Y/fuTkOs1kc.', '2000-10-20', '8897452145', '180', '2', '3', 'Maharashtra', 'Mumbai', 0, 2, 0, '2022-10-17 18:15:48'),
(11, 'Akshay Shinde', 'helloakshay27@gmail.com', 'user2.jpg', '$2y$10$xTZjGYz9WCmBa9Jdhm3obej/wWI7MWL2lODkEiAhPTexiC5hqY452', '2000-05-20', '8974458774', '180', '2', '3', 'Maharashtra', 'Mumbai', 0, 2, 1, '2022-10-17 18:18:20');

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

--
-- Table structure for table `user_access_menu`
--

CREATE TABLE `user_access_menu` (
  `id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_access_menu`
--

INSERT INTO `user_access_menu` (`id`, `role_id`, `menu_id`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 2, 2),
(4, 1, 3),
(9, 1, 5);

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

--
-- Table structure for table `user_menu`
--

CREATE TABLE `user_menu` (
  `id` int(11) NOT NULL,
  `menu` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_menu`
--

INSERT INTO `user_menu` (`id`, `menu`) VALUES
(1, 'Admin'),
(2, 'User'),
(3, 'Menu'),
(4, 'test'),
(5, 'Reports');

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

--
-- Table structure for table `user_role`
--

CREATE TABLE `user_role` (
  `id` int(11) NOT NULL,
  `role` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` (`id`, `role`) VALUES
(1, 'Administrator'),
(2, 'Member');

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

--
-- Table structure for table `user_sub_menu`
--

CREATE TABLE `user_sub_menu` (
  `id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  `title` varchar(128) NOT NULL,
  `url` varchar(128) NOT NULL,
  `icon` varchar(128) NOT NULL,
  `is_active` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_sub_menu`
--

INSERT INTO `user_sub_menu` (`id`, `menu_id`, `title`, `url`, `icon`, `is_active`) VALUES
(1, 1, 'Dashboard', 'admin', 'fas fa-fw fa-tachometer-alt', 1),
(2, 2, 'My Profile', 'user', 'fas fa-fw fa-user', 1),
(3, 2, 'Edit Profile', 'user/edit', 'fas fa-fw fa-user-edit', 1),
(4, 3, 'Menu Management', 'menu', 'fas fa-fw fa-folder', 1),
(5, 3, 'Submenu Management', 'menu/submenu', 'fas fa-fw fa-folder-open', 1),
(7, 1, 'Role', 'admin/role', 'fas fa-fw fa-user-tie', 1),
(8, 2, 'Change Password', 'user/changepassword', 'fas fa-fw fa-key', 1),
(11, 5, 'User List', 'admin/users', 'fas fa-fw fa fa-users', 1);

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

--
-- Table structure for table `user_token`
--

CREATE TABLE `user_token` (
  `id` int(11) NOT NULL,
  `email` varchar(128) NOT NULL,
  `token` varchar(128) NOT NULL,
  `date_created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_token`
--

INSERT INTO `user_token` (`id`, `email`, `token`, `date_created`) VALUES
(1, 'pendkalkarrupaliv@gmail.com', 'rmLLo08fXhf2mozeubyBntpdEiJRB9uwbV/SF80Akdc=', 1665127266),
(5, 'helloakashay27@gmail.com', 'ln+eTaend/PK2kuoFBpVtbfA6sq9B0eZH99en5YC4C0=', 1666010748),
(6, 'helloakshay27@gmail.com', 'GdeAKbImmgyzxWYOMSrG8bZrrrPjK5adZ4bdIdVo8Vs=', 1666010900);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

