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

START TRANSACTION;



--
-- Database: `qamari`
--

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

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

CREATE TABLE `users` (
  `Id` smallint(5) UNSIGNED NOT NULL,
  `Username` longtext NOT NULL,
  `Password` longtext NOT NULL,
  `Role` longtext NOT NULL,
  `JoinDate` date DEFAULT NULL,
  `BirthDate` date DEFAULT NULL,
  `UpdatedAt` datetime(6) NOT NULL,
  `Gender` longtext DEFAULT NULL,
  `Data` longtext DEFAULT NULL,
  `Email` longtext DEFAULT NULL,
  `Bio` longtext DEFAULT NULL,
  `Phone` longtext DEFAULT NULL,
  `Status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`Id`, `Username`, `Password`, `Role`, `JoinDate`, `BirthDate`, `UpdatedAt`, `Gender`, `Data`, `Email`, `Bio`, `Phone`, `Status`) VALUES
(2, '123456789', '', 'user', '2025-08-28', NULL, '2025-08-28 18:12:21.226145', NULL, NULL, '123456789@nxt-level.com', NULL, '123456789', 0);

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

--
-- Table structure for table `__efmigrationshistory`
--

CREATE TABLE `__efmigrationshistory` (
  `MigrationId` varchar(150) NOT NULL,
  `ProductVersion` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `__efmigrationshistory`
--

INSERT INTO `__efmigrationshistory` (`MigrationId`, `ProductVersion`) VALUES
('20250828160510_init', '9.0.8');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `__efmigrationshistory`
--
ALTER TABLE `__efmigrationshistory`
  ADD PRIMARY KEY (`MigrationId`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `Id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

