-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 21, 2024 at 04:23 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `dmpythondb`
--

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

--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` bigint(20) NOT NULL,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES
(1, 'Can add log entry', 1, 'add_logentry'),
(2, 'Can change log entry', 1, 'change_logentry'),
(3, 'Can delete log entry', 1, 'delete_logentry'),
(4, 'Can view log entry', 1, 'view_logentry'),
(5, 'Can add permission', 2, 'add_permission'),
(6, 'Can change permission', 2, 'change_permission'),
(7, 'Can delete permission', 2, 'delete_permission'),
(8, 'Can view permission', 2, 'view_permission'),
(9, 'Can add group', 3, 'add_group'),
(10, 'Can change group', 3, 'change_group'),
(11, 'Can delete group', 3, 'delete_group'),
(12, 'Can view group', 3, 'view_group'),
(13, 'Can add content type', 4, 'add_contenttype'),
(14, 'Can change content type', 4, 'change_contenttype'),
(15, 'Can delete content type', 4, 'delete_contenttype'),
(16, 'Can view content type', 4, 'view_contenttype'),
(17, 'Can add session', 5, 'add_session'),
(18, 'Can change session', 5, 'change_session'),
(19, 'Can delete session', 5, 'delete_session'),
(20, 'Can view session', 5, 'view_session'),
(21, 'Can add user', 6, 'add_customuser'),
(22, 'Can change user', 6, 'change_customuser'),
(23, 'Can delete user', 6, 'delete_customuser'),
(24, 'Can view user', 6, 'view_customuser'),
(25, 'Can add directory', 7, 'add_directory'),
(26, 'Can change directory', 7, 'change_directory'),
(27, 'Can delete directory', 7, 'delete_directory'),
(28, 'Can view directory', 7, 'view_directory');

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

--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext DEFAULT NULL,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) UNSIGNED NOT NULL CHECK (`action_flag` >= 0),
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES
(1, 'admin', 'logentry'),
(3, 'auth', 'group'),
(2, 'auth', 'permission'),
(4, 'contenttypes', 'contenttype'),
(6, 'dmapp', 'customuser'),
(7, 'dmapp', 'directory'),
(5, 'sessions', 'session');

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

--
-- Table structure for table `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` bigint(20) NOT NULL,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `django_migrations`
--

INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES
(1, 'contenttypes', '0001_initial', '2024-05-16 05:48:29.371203'),
(2, 'contenttypes', '0002_remove_content_type_name', '2024-05-16 05:48:29.430000'),
(3, 'auth', '0001_initial', '2024-05-16 05:48:29.675034'),
(4, 'auth', '0002_alter_permission_name_max_length', '2024-05-16 05:48:29.737089'),
(5, 'auth', '0003_alter_user_email_max_length', '2024-05-16 05:48:29.748060'),
(6, 'auth', '0004_alter_user_username_opts', '2024-05-16 05:48:29.755688'),
(7, 'auth', '0005_alter_user_last_login_null', '2024-05-16 05:48:29.764046'),
(8, 'auth', '0006_require_contenttypes_0002', '2024-05-16 05:48:29.767818'),
(9, 'auth', '0007_alter_validators_add_error_messages', '2024-05-16 05:48:29.775869'),
(10, 'auth', '0008_alter_user_username_max_length', '2024-05-16 05:48:29.782770'),
(11, 'auth', '0009_alter_user_last_name_max_length', '2024-05-16 05:48:29.793021'),
(12, 'auth', '0010_alter_group_name_max_length', '2024-05-16 05:48:29.804440'),
(13, 'auth', '0011_update_proxy_permissions', '2024-05-16 05:48:29.814451'),
(14, 'auth', '0012_alter_user_first_name_max_length', '2024-05-16 05:48:29.822238'),
(15, 'dmapp', '0001_initial', '2024-05-16 05:48:30.114999'),
(16, 'admin', '0001_initial', '2024-05-16 05:48:30.213001'),
(17, 'admin', '0002_logentry_remove_auto_add', '2024-05-16 05:48:30.226189'),
(18, 'admin', '0003_logentry_add_action_flag_choices', '2024-05-16 05:48:30.236110'),
(19, 'sessions', '0001_initial', '2024-05-16 05:48:30.267092'),
(20, 'dmapp', '0002_directory', '2024-05-16 06:59:40.235894'),
(21, 'dmapp', '0003_rename_city_directory_city', '2024-05-16 07:05:37.546983');

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

--
-- Table structure for table `django_session`
--

CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `django_session`
--

INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES
('2ptfxdd70a3gg7m52y078bn3oi14hcc2', '.eJxVjEEOwiAQRe_C2hDo0AIu3fcMZGBGqRpISrsy3l1JutDtf-_9lwi4bznsjdewkDgLLU6_W8T04NIB3bHcqky1bOsSZVfkQZucK_Hzcrh_Bxlb7vWEcYisEBNHAMLR66Qm58GAHoB9AksWAKavqYgdDprRoLPqakay4v0B-uA4HA:1s7wUW:ISoJNphwdvqCn5aUxwLs6EgzXMxxOlAQgjSR4Rlleyw', '2024-05-31 12:15:16.274656'),
('vzzu60rbael0l00spjm4ks5pb727tgom', '.eJxVjDsOwjAQBe_iGln-ZE2Wkj5nsHa9Fg4gW4qTCnF3iJQC2jcz76UibWuJW89LnEVdlFWn340pPXLdgdyp3ppOra7LzHpX9EG7nprk5_Vw_w4K9fKtBxjk7DBhAAqMjrIjT4nZEbDBAaw3I4YRmb0VMVaIBKx1AgwoXr0_2oU3uw:1s9QCc:JqvRxktAzTxyPbEvm66xqejnSeYlurX1UTWsgS-PsH8', '2024-06-04 14:10:54.223681');

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

--
-- Table structure for table `dmapp_customuser`
--

CREATE TABLE `dmapp_customuser` (
  `id` bigint(20) NOT NULL,
  `password` varchar(128) NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) NOT NULL,
  `first_name` varchar(150) NOT NULL,
  `last_name` varchar(150) NOT NULL,
  `email` varchar(254) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  `user_type` varchar(50) NOT NULL,
  `profile_pic` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dmapp_customuser`
--

INSERT INTO `dmapp_customuser` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`, `user_type`, `profile_pic`) VALUES
(1, 'pbkdf2_sha256$390000$2OWN6IQJiTVGWz7lUtame1$6W9Mrd7yvdYTK6br/Tl2SKyeLYM97SpGnXR7imOVydc=', '2024-05-21 14:10:54.223681', 1, 'admin', 'Admin', 'User', 'admin@gmail.com', 1, 1, '2024-05-16 05:49:02.425353', '1', 'media/profile_pic/gallery_09.jpg');

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

--
-- Table structure for table `dmapp_customuser_groups`
--

CREATE TABLE `dmapp_customuser_groups` (
  `id` bigint(20) NOT NULL,
  `customuser_id` bigint(20) NOT NULL,
  `group_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `dmapp_customuser_user_permissions`
--

CREATE TABLE `dmapp_customuser_user_permissions` (
  `id` bigint(20) NOT NULL,
  `customuser_id` bigint(20) NOT NULL,
  `permission_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `dmapp_directory`
--

CREATE TABLE `dmapp_directory` (
  `id` bigint(20) NOT NULL,
  `fullname` varchar(200) NOT NULL,
  `profession` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `mobilenumber` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `address` longtext NOT NULL,
  `status` varchar(1) NOT NULL,
  `creationdate` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dmapp_directory`
--

INSERT INTO `dmapp_directory` (`id`, `fullname`, `profession`, `email`, `mobilenumber`, `city`, `address`, `status`, `creationdate`, `updated_at`) VALUES
(1, 'Rakesh Sharma', 'Software Developer', 'rakesh@gmail.com', '7987987987', 'Ghaziabad', 'O-908, GHU, Block-7', '1', '2024-05-16 07:06:20.225363', '2024-05-17 05:30:12.657765'),
(2, 'John Doe', 'Software Developer', 'johndoe@test.com', '8979778797', 'Kanpur', 'P-908,  Block-7', '1', '2024-05-16 07:11:36.427530', '2024-05-16 07:11:36.427530'),
(3, 'Test', 'Civil Services', 'test@gmail.com', '5456465465', 'Gwalior', 'J-789', '1', '2024-05-16 10:58:26.600087', '2024-05-16 10:58:26.600087'),
(4, 'John Doe', 'Accountant', 'jhndoe12@test.com', '5567891236', 'Varanasi', 'L-908', '2', '2024-05-16 10:59:19.445759', '2024-05-16 10:59:19.445759'),
(5, 'Harish Kumar', 'Teacher', 'harish@gmail.com', '9898989898', 'Meerut', 'Shastri Nagar', '1', '2024-05-16 11:00:26.977449', '2024-05-16 11:00:26.977449'),
(6, 'Ram', 'Government Employee', 'ram@gmail.com', '7987897987', 'K-789', 'O-908, GHU, Block-7', '1', '2024-05-16 11:01:20.117296', '2024-05-16 11:01:20.117296'),
(8, 'Seema Roy', 'Freelnacer', 'seema@gmail.com', '6498746897', 'Ghaziabad', 'O-908, GHU, Block-7', '1', '2024-05-16 11:02:34.975382', '2024-05-19 17:07:28.601088'),
(9, 'Garima Singh', 'Software Analyst', 'garima@gmail.com', '4454654646', 'Aligarh', 'j-900', '1', '2024-05-16 11:03:36.430427', '2024-05-16 11:03:36.430427'),
(10, 'Shergil Singh', 'Accountant', 'sukh@gmail.com', '1234567899', 'Ghaziabad', 'P-908, GHU, Block-7', '2', '2024-05-16 11:04:06.977830', '2024-05-16 11:04:06.977830'),
(11, 'Khushi Sharma', 'Teacher', 'khushi@gmail.com', '6565448979', 'Meerut', 'L-9008', '1', '2024-05-16 11:04:47.814859', '2024-05-16 11:04:47.814859'),
(12, 'Manju Kuswaha', 'Data Analyst', 'manju@gmail.com', '9797979779', 'Gorakhpur', 'O-908, GHU, Block-7', '2', '2024-05-16 11:05:40.669787', '2024-05-16 11:05:40.669787'),
(13, 'Abir Singh', 'Telly Caller', 'abir@gmail.com', '7898979879', 'New Delhi', 'Laxmi Nagar', '1', '2024-05-16 11:06:39.615623', '2024-05-16 11:06:39.615623'),
(14, 'Teena', 'Executive', 'teena@gmail.com', '2311278978', 'Ghaziabad', 'O-908, GHU, Block-7', '2', '2024-05-16 11:11:26.850897', '2024-05-19 17:10:10.231585'),
(15, 'Kiran', 'hhhkhkh', 'gj@gmail.com', '7979797979', 'hkj', 'hk', '1', '2024-05-16 11:12:02.921461', '2024-05-16 11:51:47.869287'),
(17, 'Anuj kumar', 'Software Developer', 'ak2321@g.com', '1425365412', 'New Delhi', 'Mayur Vihar New Delhi', '1', '2024-05-19 17:06:34.027751', '2024-05-19 17:06:34.027751');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `auth_group`
--
ALTER TABLE `auth_group`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  ADD KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`);

--
-- Indexes for table `auth_permission`
--
ALTER TABLE `auth_permission`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`);

--
-- Indexes for table `django_admin_log`
--
ALTER TABLE `django_admin_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  ADD KEY `django_admin_log_user_id_c564eba6_fk_dmapp_customuser_id` (`user_id`);

--
-- Indexes for table `django_content_type`
--
ALTER TABLE `django_content_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`);

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

--
-- Indexes for table `django_session`
--
ALTER TABLE `django_session`
  ADD PRIMARY KEY (`session_key`),
  ADD KEY `django_session_expire_date_a5c62663` (`expire_date`);

--
-- Indexes for table `dmapp_customuser`
--
ALTER TABLE `dmapp_customuser`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Indexes for table `dmapp_customuser_groups`
--
ALTER TABLE `dmapp_customuser_groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `dmapp_customuser_groups_customuser_id_group_id_92ea0b85_uniq` (`customuser_id`,`group_id`),
  ADD KEY `dmapp_customuser_groups_group_id_29800c3c_fk_auth_group_id` (`group_id`);

--
-- Indexes for table `dmapp_customuser_user_permissions`
--
ALTER TABLE `dmapp_customuser_user_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `dmapp_customuser_user_pe_customuser_id_permission_df787f5e_uniq` (`customuser_id`,`permission_id`),
  ADD KEY `dmapp_customuser_use_permission_id_b91cfba4_fk_auth_perm` (`permission_id`);

--
-- Indexes for table `dmapp_directory`
--
ALTER TABLE `dmapp_directory`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `auth_group`
--
ALTER TABLE `auth_group`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `django_admin_log`
--
ALTER TABLE `django_admin_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
  ADD CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  ADD CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);

--
-- Constraints for table `auth_permission`
--
ALTER TABLE `auth_permission`
  ADD CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`);

--
-- Constraints for table `django_admin_log`
--
ALTER TABLE `django_admin_log`
  ADD CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  ADD CONSTRAINT `django_admin_log_user_id_c564eba6_fk_dmapp_customuser_id` FOREIGN KEY (`user_id`) REFERENCES `dmapp_customuser` (`id`);

--
-- Constraints for table `dmapp_customuser_groups`
--
ALTER TABLE `dmapp_customuser_groups`
  ADD CONSTRAINT `dmapp_customuser_gro_customuser_id_b8b0f9dc_fk_dmapp_cus` FOREIGN KEY (`customuser_id`) REFERENCES `dmapp_customuser` (`id`),
  ADD CONSTRAINT `dmapp_customuser_groups_group_id_29800c3c_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);

--
-- Constraints for table `dmapp_customuser_user_permissions`
--
ALTER TABLE `dmapp_customuser_user_permissions`
  ADD CONSTRAINT `dmapp_customuser_use_customuser_id_b37ba881_fk_dmapp_cus` FOREIGN KEY (`customuser_id`) REFERENCES `dmapp_customuser` (`id`),
  ADD CONSTRAINT `dmapp_customuser_use_permission_id_b91cfba4_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
