-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: database:3306
-- Generation Time: Apr 24, 2026 at 01:27 PM
-- Server version: 8.0.45
-- PHP Version: 8.3.26

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: `nepallandbroker`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT '1',
  `deviceToken` json DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `deletedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `name`, `email`, `username`, `password`, `isActive`, `deviceToken`, `role`, `createdAt`, `updatedAt`, `deletedAt`) VALUES
(1, 'Admin', 'admin@gmail.com', 'admin', '$2b$10$P85GuASDA6sDqk60pC3j2.rfT2Ir8opiJYXLAMkHrSitjMCas2euO', 1, NULL, NULL, '2026-04-24 16:30:30', '2026-04-24 16:30:30', NULL);

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

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `citizenship` varchar(255) DEFAULT NULL,
  `bankDeposit` varchar(255) DEFAULT NULL,
  `requestForm` varchar(255) DEFAULT NULL,
  `shareType` varchar(255) DEFAULT NULL,
  `pan` varchar(255) DEFAULT NULL,
  `nid` varchar(255) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `file` varchar(255) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` int NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` int NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `general_settings`
--

CREATE TABLE `general_settings` (
  `id` int NOT NULL,
  `group` varchar(255) DEFAULT NULL,
  `key` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `value` longtext,
  `title` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `infos` json DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `general_settings`
--

INSERT INTO `general_settings` (`id`, `group`, `key`, `type`, `value`, `title`, `file`, `infos`, `createdAt`, `updatedAt`) VALUES
(1, 'banner', 'banner-1777031634462', NULL, 'https://nepallandbroker.com', 'Nepal Land Broker Pvt Ltd', 'uploads/generalSettings/1777031634717.webp', NULL, '2026-04-24 17:38:54', '2026-04-24 17:38:54'),
(2, 'about', 'overview', NULL, '{\"description\":\"<p><strong>Nepal’s Regulated Pioneer in Land &amp; Investment Management.</strong></p><p></p><p><strong>Nepal Land Broker Pvt. Ltd.</strong> is a premier, government-licensed real estate brokerage and investment firm (License No: <strong>BRK1837701</strong>) dedicated to bringing transparency, legal integrity, and corporate professionalism to Nepal’s property market.</p><p>Established in 2082 (2025 AD), we emerged as a response to the evolving regulatory landscape of Nepal. With the government now mandating licensed brokers for high-value transactions, we serve as the authorized bridge between buyers and sellers, ensuring every deal is backed by rigorous legal verification and ethical standards.</p><p>Beyond brokerage, we are a multi-sectoral investment powerhouse. Our expertise spans across Real Estate, Infrastructure (Hydropower &amp; Cable Cars), and Capital Markets, making us a unique partner for both individual homeowners and institutional investors.</p><p><strong>Why We Are Different:</strong></p><ul><li><p><strong>Nationwide Authority:</strong> Licensed to operate across all major Metropolitan and Sub-Metropolitan cities, from Kathmandu and Pokhara to Biratnagar and Dhangadhi.</p></li><li><p><strong>Legal Compliance:</strong> We strictly adhere to the Land Revenue Act and the latest directives from the Department of Land Management and Archive.</p></li><li><p><strong>Institutional Strength:</strong> We don\'t just \\\"find\\\" land; we manage investments, facilitate technology transfers, and provide engineering consultancy.</p></li></ul>\",\"highlightedContent\":\"<p><strong>Scope of Services (Segmented for Clarity)</strong></p><p>To reflect your Memorandum of Association (MOA), your services should be categorized into four distinct pillars:</p>\",\"bulletPointContent\":\"<p><strong>I. Licensed Real Estate Brokerage</strong></p><ul><li><p><strong>Certified Property Transactions:</strong> Authorized brokerage for residential, commercial, and agricultural land with a focus on high-value transactions (3 Crores+).</p></li><li><p><strong>Title Verification &amp; Documentation:</strong> Handling the complexities of Malpot (Land Revenue) and Napi (Survey) documentation to ensure \\\"clean\\\" titles.</p></li><li><p><strong>Strategic Land Acquisition:</strong> Helping corporate clients and developers identify and acquire prime plots for large-scale projects.</p></li></ul><p><strong>II. Investment &amp; Portfolio Management (PMS)</strong></p><ul><li><p><strong>Diversified Capital Investment:</strong> We facilitate and manage investments in Mutual Funds, SIPs, Private Equity, and Venture Capital.</p></li><li><p><strong>Real Estate Investment Trusts:</strong> Providing a corporate structure for group investments in high-yield property markets.</p></li><li><p><strong>Wealth Consulting:</strong> Professional advisory on wealth growth through a mix of property and financial instruments.</p></li></ul><p><strong>III. Infrastructure &amp; Industrial Support</strong></p><ul><li><p><strong>Hydro &amp; Energy Solutions:</strong> Importing and distributing specialized machinery (Turbines, Gondolas, Penstock pipes) for Nepal’s booming energy sector.</p></li><li><p><strong>Technology Transfer:</strong> Facilitating partnerships with international firms for cable car, tourism, and green energy projects.</p></li><li><p><strong>Manpower &amp; Training:</strong> Providing skilled human resources and technical training for large-scale infrastructure projects.</p></li></ul><p><strong>IV. Corporate &amp; Engineering Consultancy</strong></p><ul><li><p><strong>Management Advisory:</strong> Consulting services for business operations, capital management, and loan facilitation.</p></li><li><p><strong>Engineering Services:</strong> Providing technical expertise for project feasibility and construction management.</p></li><li><p><strong>Intellectual Property:</strong> Handling the purchase, sale, and licensing of intellectual assets and new research.</p></li></ul><p></p>\"}', NULL, 'uploads/generalSettings/1777031703428.webp', NULL, '2026-04-24 17:40:03', '2026-04-24 17:40:03'),
(3, 'home', 'aboutUsHomeData', NULL, '{\"aboutUsContent\":\"<p><strong>Nepal’s Regulated Pioneer in Land &amp; Investment Management.</strong></p><p></p><p><strong>Nepal Land Broker Pvt. Ltd.</strong> is a premier, government-licensed real estate brokerage and investment firm (License No: <strong>BRK1837701</strong>) dedicated to bringing transparency, legal integrity, and corporate professionalism to Nepal’s property market.</p><p>Established in 2082 (2025 AD), we emerged as a response to the evolving regulatory landscape of Nepal. With the government now mandating licensed brokers for high-value transactions, we serve as the authorized bridge between buyers and sellers, ensuring every deal is backed by rigorous legal verification and ethical standards.</p><p>Beyond brokerage, we are a multi-sectoral investment powerhouse. Our expertise spans across Real Estate, Infrastructure (Hydropower &amp; Cable Cars), and Capital Markets, making us a unique partner for both individual homeowners and institutional investors.</p>\",\"highlightedContent\":\"<p><strong>Why We Are Different:</strong></p><ul><li><p><strong>Nationwide Authority:</strong> Licensed to operate across all major Metropolitan and Sub-Metropolitan cities, from Kathmandu and Pokhara to Biratnagar and Dhangadhi.</p></li><li><p><strong>Legal Compliance:</strong> We strictly adhere to the Land Revenue Act and the latest directives from the Department of Land Management and Archive.</p></li><li><p><strong>Institutional Strength:</strong> We don\'t just \\\"find\\\" land; we manage investments, facilitate technology transfers, and provide engineering consultancy.</p></li></ul>\"}', NULL, NULL, NULL, '2026-04-24 17:45:53', '2026-04-24 17:45:53'),
(4, 'prabhu-steels-settings', 'prabhu-steels-settings', NULL, 'settings', 'Settings', NULL, '{\"mail\": \"nepallandbroker@gmail.com\", \"location\": \"Tinkune Kathmandu Nepal\", \"tiktokLink\": \"https://tiktok.com\", \"phoneNumber\": \" +977-9851172399\", \"twitterLink\": \"https://twitter.com\", \"youtubeLink\": \"https://youtube.com\", \"branchOffice\": \"\", \"facebookLink\": \"https://facebook.com\", \"linkedinLink\": \"https://linkedin.com\", \"openingHours\": \"Sun-Fri 10:00am to 6:00pm\", \"copyrightText\": \"All Rights Reserved by Nepal Land Broker Pvt Ltd\", \"instagramLink\": \"https://instagram.com\", \"phoneNumberII\": \" +977-9851172399\", \"whatsAppNumber\": \" +977-9851172399\", \"registrationOffice\": \"\"}', '2026-04-24 18:07:04', '2026-04-24 18:07:04'),
(5, 'favicon', 'favicon', NULL, 'favicon', 'Favicon', 'uploads/generalSettings/1777033348419.webp', NULL, '2026-04-24 18:07:28', '2026-04-24 18:07:28'),
(6, NULL, 'homeSeo', NULL, '{\"title\":\"Nepal Land Broker Pvt. Ltd. | Licensed Real Estate & Investment Firm\",\"description\":\"Nepal\'s government-licensed real estate brokerage (License No: BRK1837701). Expert property transactions, investment management & infrastructure consultancy across Nepal.\",\"keywords\":\"Nepal land broker, licensed real estate Nepal, property broker Kathmandu, land investment Nepal, real estate brokerage Nepal, BRK1837701, property management Nepal, Nepal real estate firm\"}', 'Home', NULL, NULL, '2026-04-24 18:10:42', '2026-04-24 18:10:42'),
(7, NULL, 'overviewSeo', NULL, '{\"title\":\"Company Overview | Nepal Land Broker Pvt. Ltd.\",\"description\":\"Get a complete overview of Nepal Land Broker Pvt. Ltd. — a regulated, multi-sectoral investment and real estate firm established in 2082 BS with nationwide operating authority.\",\"keywords\":\"Nepal Land Broker overview, real estate company Nepal, licensed broker Nepal 2025, property investment firm Nepal, Kathmandu real estate company, regulated broker Nepal\"}', 'Overview', NULL, NULL, '2026-04-24 18:11:03', '2026-04-24 18:11:03'),
(8, NULL, 'strategicObjectiveSeo', NULL, '{\"title\":\"Strategic Objectives | Nepal Land Broker Pvt. Ltd.\",\"description\":\"Explore our strategic vision for transforming Nepal\'s real estate market through legal compliance, corporate professionalism, and diversified investment across property and infrastructure.\",\"keywords\":\"real estate strategy Nepal, land broker objectives, property market Nepal vision, transparent real estate Nepal, investment strategy Nepal, regulated property firm\"}', 'Strategic Objective', NULL, NULL, '2026-04-24 18:11:24', '2026-04-24 18:11:24'),
(9, NULL, 'corporateGovernanceSeo', NULL, '{\"title\":\"Corporate Governance | Nepal Land Broker Pvt. Ltd.\",\"description\":\"Nepal Land Broker follows strict corporate governance standards — adhering to the Land Revenue Act, Department of Land Management directives, and transparent ethical business practices.\",\"keywords\":\"corporate governance Nepal, real estate compliance Nepal, Land Revenue Act Nepal, ethical real estate broker, property law Nepal, Department of Land Management Nepal\"}', 'Corporate Governance', NULL, NULL, '2026-04-24 18:11:45', '2026-04-24 18:11:45'),
(10, NULL, 'boardOfDirectorsSeo', NULL, '{\"title\":\"Board of Directors | Nepal Land Broker Pvt. Ltd.\",\"description\":\"Meet the experienced Board of Directors guiding Nepal Land Broker Pvt. Ltd. — bringing leadership in real estate, finance, infrastructure, and investment management to Nepal\'s property sector.\",\"keywords\":\"Nepal Land Broker board, real estate directors Nepal, property firm leadership Nepal, investment board Nepal, land broker management\"}', 'Board of Directors', NULL, NULL, '2026-04-24 18:12:05', '2026-04-24 18:12:05'),
(11, NULL, 'managementTeamSeo', NULL, '{\"title\":\"Management Team | Nepal Land Broker Pvt. Ltd.\",\"description\":\"Our professional management team drives Nepal Land Broker\'s mission — combining expertise in real estate brokerage, capital markets, infrastructure, and legal compliance across Nepal.\\n\",\"keywords\":\"Nepal Land Broker team, real estate professionals Nepal, property management team, brokerage experts Nepal, investment managers Nepal\"}', 'Management Team', NULL, NULL, '2026-04-24 18:12:23', '2026-04-24 18:12:23'),
(12, NULL, 'noticeBoardSeo', NULL, '{\"title\":\"Notice Board | Announcements — Nepal Land Broker Pvt. Ltd.\",\"description\":\"Stay updated with the latest official announcements, regulatory notices, and company updates from Nepal Land Broker Pvt. Ltd. — Nepal\'s premier licensed real estate brokerage.\",\"keywords\":\"Nepal Land Broker notices, real estate announcements Nepal, property news Nepal, land broker updates, official notices Nepal real estate\"}', 'Notice Board', NULL, NULL, '2026-04-24 18:12:39', '2026-04-24 18:12:39'),
(13, NULL, 'projectsSeo', NULL, '{\"title\":\"Projects | Real Estate & Infrastructure — Nepal Land Broker\",\"description\":\"Explore Nepal Land Broker\'s active projects in residential land, commercial real estate, hydropower infrastructure, and cable car technology across Nepal\'s major cities.\",\"keywords\":\"Nepal real estate projects, land development Nepal, hydropower projects Nepal, cable car investment Nepal, infrastructure projects Nepal, commercial property projects\"}', 'Projects', NULL, NULL, '2026-04-24 18:12:56', '2026-04-24 18:12:56'),
(14, NULL, 'faqsSeo', NULL, '{\"title\":\"FAQs | Real Estate & Investment Questions — Nepal Land Broker\",\"description\":\"Find answers to frequently asked questions about licensed property brokerage, land transactions, title verification, investment services, and documentation in Nepal.\",\"keywords\":\"real estate FAQ Nepal, property buying Nepal questions, land title verification Nepal, licensed broker FAQ, investment FAQ Nepal, Malpot documentation Nepal\"}', 'FAQs', NULL, NULL, '2026-04-24 18:13:22', '2026-04-24 18:13:22'),
(15, NULL, 'gallerySeo', NULL, '{\"title\":\"Gallery | Properties & Projects — Nepal Land Broker Pvt. Ltd.\",\"description\":\"Browse our photo gallery featuring verified land listings, completed property transactions, infrastructure projects, and corporate events from Nepal Land Broker Pvt. Ltd.\",\"keywords\":\"Nepal property gallery, real estate photos Nepal, land listings Nepal, property images Kathmandu, Nepal Land Broker gallery\"}', 'Gallery', NULL, NULL, '2026-04-24 18:13:43', '2026-04-24 18:13:43'),
(16, NULL, 'portfolioSeo', NULL, '{\"title\":\"Investment Portfolio | Real Estate & Capital Markets — Nepal Land Broker\",\"description\":\"Discover Nepal Land Broker\'s diversified investment portfolio — spanning prime real estate, mutual funds, SIPs, private equity, hydropower, and REITs across Nepal.\",\"keywords\":\"Nepal real estate portfolio, land investment portfolio Nepal, mutual funds Nepal, SIP investment Nepal, private equity Nepal, REIT Nepal, hydropower investment\"}', 'Portfolio', NULL, NULL, '2026-04-24 18:14:02', '2026-04-24 18:14:02'),
(17, NULL, 'contactSeo', NULL, '{\"title\":\"Contact Us | Nepal Land Broker Pvt. Ltd. — Kathmandu, Nepal\",\"description\":\"Get in touch with Nepal Land Broker Pvt. Ltd. for licensed property brokerage, investment advisory, and infrastructure consultancy. Serving Kathmandu, Pokhara, Biratnagar & more.\",\"keywords\":\"contact Nepal Land Broker, real estate office Kathmandu, property broker contact Nepal, land broker phone Nepal, investment firm contact Kathmandu\"}', 'Contact', NULL, NULL, '2026-04-24 18:14:24', '2026-04-24 18:14:24'),
(18, NULL, 'requestShareSeo', NULL, '{\"title\":\"Request Share | Invest in Nepal Land Broker Pvt. Ltd.\",\"description\":\"Interested in investing? Request share information for Nepal Land Broker Pvt. Ltd. — Nepal\'s licensed real estate and multi-sectoral investment company established in 2082 BS.\\n\",\"keywords\":\"Nepal Land Broker shares, invest in real estate Nepal, property company shares Nepal, land broker equity Nepal, share request Nepal\"}', 'Request Share', NULL, NULL, '2026-04-24 18:15:04', '2026-04-24 18:15:04');

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` int NOT NULL,
  `galleryId` int NOT NULL,
  `type` varchar(255) DEFAULT 'Gallery',
  `file` varchar(255) NOT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `popups`
--

CREATE TABLE `popups` (
  `id` int NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `portfolios`
--

CREATE TABLE `portfolios` (
  `id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` int NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `additionalInfo` json DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int NOT NULL,
  `header` varchar(255) DEFAULT NULL,
  `footer` varchar(255) DEFAULT NULL,
  `footerText` longtext,
  `primaryColor` varchar(255) DEFAULT NULL,
  `primaryLightcolor` varchar(255) DEFAULT NULL,
  `secondaryColor` varchar(255) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `header`, `footer`, `footerText`, `primaryColor`, `primaryLightcolor`, `secondaryColor`, `createdAt`, `updatedAt`) VALUES
(1, 'uploads/themes/1777030302362-header.png', 'uploads/themes/1777030302380-footer.png', 'All Rights Reserved by Nepal Land Broker Pvt. Ltd.', '#0059ab', '#f0f7ff', '#1ba952', '2026-04-24 17:16:42', '2026-04-24 17:16:42');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `galleryId` (`galleryId`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `applications`
--
ALTER TABLE `applications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `general_settings`
--
ALTER TABLE `general_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `popups`
--
ALTER TABLE `popups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `portfolios`
--
ALTER TABLE `portfolios`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `teams`
--
ALTER TABLE `teams`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `themes`
--
ALTER TABLE `themes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `images`
--
ALTER TABLE `images`
  ADD CONSTRAINT `images_ibfk_1` FOREIGN KEY (`galleryId`) REFERENCES `galleries` (`id`) ON DELETE CASCADE;
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 */;
