-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 17, 2024 at 03:01 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: `squarel`
--

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

--
-- Table structure for table `sql_about_us`
--

CREATE TABLE `sql_about_us` (
  `abo_id` int(11) NOT NULL,
  `abo_slug` varchar(250) DEFAULT NULL,
  `abo_title` varchar(250) DEFAULT NULL,
  `abo_description` text NOT NULL,
  `abo_media` varchar(250) DEFAULT NULL,
  `abo_media_alt` varchar(100) DEFAULT NULL,
  `abo_status` tinyint(1) NOT NULL DEFAULT 1,
  `abo_created_at` datetime NOT NULL,
  `abo_updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sql_about_us`
--

INSERT INTO `sql_about_us` (`abo_id`, `abo_slug`, `abo_title`, `abo_description`, `abo_media`, `abo_media_alt`, `abo_status`, `abo_created_at`, `abo_updated_at`) VALUES
(1, 'home', '3DSQUAREL is one of the world’s leading 3D Architectural Visualization and Physical Scale Model Company.', 'We turn dreams and visions into an incredible reality, breathe life into your ideas and create soul-stirring visualizations. At Dawn Digital, we work together in unison to produce things of breathtaking beauty that are a treat for the senses and passion for the heart.\r\n\r\nAs a boutique studio operating in the realm of digital graphics technology, we aim to evolve into a leading global visual creative solutions provider.', NULL, NULL, 1, '2024-05-17 11:39:52', NULL),
(2, NULL, NULL, 'We at 3DSQUAREL seek to create concepts that attract and move audiences across the world. Our constant endeavor is 100% client satisfaction and each project in our impressive portfolio takes us closer and closer to being a one-stop solutions provider to clients from various industries. Our customer satis­fac­tion is not only reflected by our sales numbers but also in our enduring rela­tion­ships. Inter­nally and exter­nally, our dedi­ca­tion to our team and clients is among the longest in the industry', NULL, NULL, 1, '2024-05-17 11:39:52', NULL);

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

--
-- Table structure for table `sql_career`
--

CREATE TABLE `sql_career` (
  `car_id` int(11) NOT NULL,
  `car_title` varchar(250) NOT NULL,
  `car_desc` text DEFAULT NULL,
  `car_salary` varchar(100) DEFAULT NULL,
  `car_start_date` datetime DEFAULT NULL,
  `car_end_date` datetime DEFAULT NULL,
  `car_location` text DEFAULT NULL,
  `car_status` tinyint(1) NOT NULL DEFAULT 1,
  `car_created_at` datetime NOT NULL,
  `car_updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sql_clients`
--

CREATE TABLE `sql_clients` (
  `cli_id` int(11) NOT NULL,
  `cli_title` varchar(250) DEFAULT NULL,
  `cli_image` varchar(250) DEFAULT NULL,
  `cli_image_alt` varchar(250) DEFAULT NULL,
  `cli_status` tinyint(1) NOT NULL DEFAULT 1,
  `cli_order` int(11) DEFAULT NULL,
  `cli_created_at` datetime NOT NULL,
  `cli_updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sql_counters`
--

CREATE TABLE `sql_counters` (
  `cou_id` int(11) NOT NULL,
  `cou_title` varchar(250) NOT NULL,
  `cou_value` varchar(250) NOT NULL,
  `cou_status` tinyint(1) NOT NULL DEFAULT 1,
  `cou_created_at` datetime NOT NULL,
  `cou_updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sql_counters`
--

INSERT INTO `sql_counters` (`cou_id`, `cou_title`, `cou_value`, `cou_status`, `cou_created_at`, `cou_updated_at`) VALUES
(1, 'Years In Business', '14', 1, '2024-05-17 10:00:10', NULL),
(2, 'Projects Completed', '32000', 1, '2024-05-17 10:00:10', NULL),
(3, 'Renderds Images', '8000', 1, '2024-05-17 10:00:40', NULL),
(4, '3D Films', '200', 1, '2024-05-17 10:00:40', NULL);

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

--
-- Table structure for table `sql_enquiry`
--

CREATE TABLE `sql_enquiry` (
  `enq_id` int(11) NOT NULL,
  `enq_name` varchar(250) NOT NULL,
  `enq_email` varchar(250) NOT NULL,
  `enq_subject` text NOT NULL,
  `enq_msg` text NOT NULL,
  `enq_created_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sql_gallery`
--

CREATE TABLE `sql_gallery` (
  `gal_id` int(11) NOT NULL,
  `gal_title` varchar(250) DEFAULT NULL,
  `gal_location` varchar(200) DEFAULT NULL,
  `gal_cat` varchar(100) DEFAULT NULL,
  `gal_media` text NOT NULL,
  `gal_media_alt` text DEFAULT NULL,
  `gal_media_type` int(2) DEFAULT 1 COMMENT '1: media , 2:video, 3: url',
  `gal_status` tinyint(1) NOT NULL DEFAULT 1,
  `gal_sort_order` int(11) NOT NULL,
  `gal_created_at` datetime NOT NULL,
  `gal_updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sql_pages_data`
--

CREATE TABLE `sql_pages_data` (
  `pag_id` int(11) NOT NULL,
  `pag_title` varchar(250) NOT NULL,
  `pag_image` varchar(250) NOT NULL,
  `pag_desc` text DEFAULT NULL,
  `pag_meta_title` text DEFAULT NULL,
  `pag_meta_desc` text DEFAULT NULL,
  `pag_meta_keyword` text DEFAULT NULL,
  `pag_header_media` varchar(250) DEFAULT NULL,
  `pag_slug` varchar(100) DEFAULT NULL,
  `pag_status` int(11) NOT NULL,
  `pag_created_at` datetime NOT NULL,
  `pag_updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sql_projects`
--

CREATE TABLE `sql_projects` (
  `pro_id` int(11) NOT NULL,
  `pro_image` varchar(250) NOT NULL,
  `pro_type` tinyint(2) NOT NULL DEFAULT 1 COMMENT '1: image, 2: video, 3: url',
  `pro_title` varchar(250) DEFAULT NULL,
  `pro_location` varchar(250) DEFAULT NULL,
  `pro_short_desc` varchar(250) DEFAULT NULL,
  `pro_cat` varchar(250) DEFAULT 'all',
  `pro_desc` text DEFAULT NULL,
  `pro_status` tinyint(1) NOT NULL DEFAULT 1,
  `pro_sort_order` int(11) NOT NULL,
  `pro_created_at` datetime NOT NULL,
  `pro_updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sql_services`
--

CREATE TABLE `sql_services` (
  `ser_id` int(11) NOT NULL,
  `ser_title` varchar(250) NOT NULL,
  `ser_short_desc` text DEFAULT NULL,
  `ser_desc` text DEFAULT NULL,
  `ser_status` tinyint(1) NOT NULL DEFAULT 1,
  `ser_sort_order` int(11) NOT NULL,
  `ser_media` varchar(250) DEFAULT NULL,
  `ser_media_alt` varchar(250) DEFAULT NULL,
  `ser_meta_title` text DEFAULT NULL,
  `ser_meta_keyword` text DEFAULT NULL,
  `ser_meta_description` text DEFAULT NULL,
  `ser_created_at` datetime NOT NULL,
  `ser_updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sql_services`
--

INSERT INTO `sql_services` (`ser_id`, `ser_title`, `ser_short_desc`, `ser_desc`, `ser_status`, `ser_sort_order`, `ser_media`, `ser_media_alt`, `ser_meta_title`, `ser_meta_keyword`, `ser_meta_description`, `ser_created_at`, `ser_updated_at`) VALUES
(1, 'Interior Renderings', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '2024-05-17 11:14:12', NULL),
(2, 'Exterior Renderings', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', NULL, 1, 2, NULL, NULL, NULL, NULL, NULL, '2024-05-17 11:14:12', NULL),
(3, 'Walktrough', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', NULL, 1, 3, NULL, NULL, NULL, NULL, NULL, '2024-05-17 11:14:12', NULL),
(4, '3D Flour Plan', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', NULL, 1, 4, NULL, NULL, NULL, NULL, NULL, '2024-05-17 11:14:12', NULL),
(5, '360 Tour', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', NULL, 1, 5, NULL, NULL, NULL, NULL, NULL, '2024-05-17 11:14:12', NULL),
(6, 'VR/AR', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', NULL, 1, 6, NULL, NULL, NULL, NULL, NULL, '2024-05-17 11:14:12', NULL),
(7, 'Drone Shoots', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', NULL, 1, 7, NULL, NULL, NULL, NULL, NULL, '2024-05-17 11:14:12', NULL),
(8, 'Physical Scale Model', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', NULL, 1, 8, NULL, NULL, NULL, NULL, NULL, '2024-05-17 11:14:12', NULL);

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

--
-- Table structure for table `sql_settings`
--

CREATE TABLE `sql_settings` (
  `set_id` int(11) NOT NULL,
  `set_name` varchar(250) DEFAULT NULL,
  `set_logo` varchar(250) DEFAULT NULL,
  `set_fav_icon` varchar(250) DEFAULT NULL,
  `set_media` varchar(250) DEFAULT NULL,
  `set_social_url` text DEFAULT NULL,
  `set_mobile_no` varchar(250) DEFAULT NULL,
  `set_email` varchar(250) DEFAULT NULL,
  `set_address` text DEFAULT NULL,
  `set_meta_title` text DEFAULT NULL,
  `set_meta_keyword` text DEFAULT NULL,
  `set_meta_description` text DEFAULT NULL,
  `set_location_url` text DEFAULT NULL,
  `set_created_at` datetime NOT NULL,
  `set_updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sql_settings`
--

INSERT INTO `sql_settings` (`set_id`, `set_name`, `set_logo`, `set_fav_icon`, `set_media`, `set_social_url`, `set_mobile_no`, `set_email`, `set_address`, `set_meta_title`, `set_meta_keyword`, `set_meta_description`, `set_location_url`, `set_created_at`, `set_updated_at`) VALUES
(1, '3DSquarel', NULL, NULL, NULL, NULL, '+91 123456789', 'hello@3dsquarel.com', 'B-34 , Second Floor, Sector 67, Noida Pin-201301', '3DSquarel', '3DSquarel', '3DSquarel', NULL, '2024-05-17 10:40:59', NULL);

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

--
-- Table structure for table `sql_testimonials`
--

CREATE TABLE `sql_testimonials` (
  `tes_id` int(11) NOT NULL,
  `tes_title` varchar(250) NOT NULL,
  `tes_image` varchar(250) DEFAULT NULL,
  `tes_desc` text DEFAULT NULL,
  `tes_status` tinyint(1) NOT NULL DEFAULT 1,
  `tes_sort_order` int(11) DEFAULT NULL,
  `tes_tagline` varchar(100) NOT NULL,
  `tes_created_at` datetime NOT NULL,
  `tes_updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sql_testimonials`
--

INSERT INTO `sql_testimonials` (`tes_id`, `tes_title`, `tes_image`, `tes_desc`, `tes_status`, `tes_sort_order`, `tes_tagline`, `tes_created_at`, `tes_updated_at`) VALUES
(1, 'John Wick', NULL, ' Lorem ipsum dolor sit amet consectetur adipisicing elit.\n\n                                    Deserunt, quasi. Molestias id ducimus hic.', 1, NULL, 'CEO', '2024-05-17 10:37:26', NULL),
(2, 'Adem Wick', NULL, ' Lorem ipsum dolor sit amet consectetur adipisicing elit.\n\n                                    Deserunt, quasi. Molestias id ducimus hic.', 1, NULL, 'CEO', '2024-05-17 10:37:26', NULL),
(3, 'john Wick', NULL, ' Lorem ipsum dolor sit amet consectetur adipisicing elit.\r\n\r\n                                    Deserunt, quasi. Molestias id ducimus hic.', 1, NULL, 'CEO', '2024-05-17 10:37:26', NULL),
(4, 'Rock Tyson', NULL, ' Lorem ipsum dolor sit amet consectetur adipisicing elit.\r\n\r\n                                    Deserunt, quasi. Molestias id ducimus hic.', 1, NULL, 'CEO', '2024-05-17 10:37:26', NULL);

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

--
-- Table structure for table `sql_users`
--

CREATE TABLE `sql_users` (
  `usr_id` int(11) NOT NULL,
  `usr_name` varchar(100) NOT NULL,
  `uar_password` varchar(250) NOT NULL,
  `usr_unique_pin` int(11) DEFAULT NULL,
  `usr_screen_name` varchar(250) DEFAULT NULL,
  `usr_email` varchar(100) DEFAULT NULL,
  `usr_phone` varchar(100) DEFAULT NULL,
  `usr_profile_pic` varchar(250) DEFAULT NULL,
  `usr_password_reset_pin` varchar(100) DEFAULT NULL,
  `usr_password_reset_time` datetime DEFAULT NULL,
  `usr_status` tinyint(1) DEFAULT NULL,
  `usr_last_login` datetime DEFAULT NULL,
  `usr_login_attempts` int(11) DEFAULT NULL,
  `usr_login_attempts_lock_time` datetime DEFAULT NULL,
  `usr_ip_information` text DEFAULT NULL,
  `usr_created_date` datetime NOT NULL,
  `usr_modified_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `sql_about_us`
--
ALTER TABLE `sql_about_us`
  ADD PRIMARY KEY (`abo_id`);

--
-- Indexes for table `sql_career`
--
ALTER TABLE `sql_career`
  ADD PRIMARY KEY (`car_id`);

--
-- Indexes for table `sql_clients`
--
ALTER TABLE `sql_clients`
  ADD PRIMARY KEY (`cli_id`);

--
-- Indexes for table `sql_counters`
--
ALTER TABLE `sql_counters`
  ADD PRIMARY KEY (`cou_id`);

--
-- Indexes for table `sql_enquiry`
--
ALTER TABLE `sql_enquiry`
  ADD PRIMARY KEY (`enq_id`);

--
-- Indexes for table `sql_gallery`
--
ALTER TABLE `sql_gallery`
  ADD PRIMARY KEY (`gal_id`);

--
-- Indexes for table `sql_pages_data`
--
ALTER TABLE `sql_pages_data`
  ADD PRIMARY KEY (`pag_id`);

--
-- Indexes for table `sql_projects`
--
ALTER TABLE `sql_projects`
  ADD PRIMARY KEY (`pro_id`);

--
-- Indexes for table `sql_services`
--
ALTER TABLE `sql_services`
  ADD PRIMARY KEY (`ser_id`);

--
-- Indexes for table `sql_settings`
--
ALTER TABLE `sql_settings`
  ADD PRIMARY KEY (`set_id`);

--
-- Indexes for table `sql_testimonials`
--
ALTER TABLE `sql_testimonials`
  ADD PRIMARY KEY (`tes_id`);

--
-- Indexes for table `sql_users`
--
ALTER TABLE `sql_users`
  ADD PRIMARY KEY (`usr_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `sql_career`
--
ALTER TABLE `sql_career`
  MODIFY `car_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sql_clients`
--
ALTER TABLE `sql_clients`
  MODIFY `cli_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sql_counters`
--
ALTER TABLE `sql_counters`
  MODIFY `cou_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sql_enquiry`
--
ALTER TABLE `sql_enquiry`
  MODIFY `enq_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sql_gallery`
--
ALTER TABLE `sql_gallery`
  MODIFY `gal_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sql_pages_data`
--
ALTER TABLE `sql_pages_data`
  MODIFY `pag_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sql_projects`
--
ALTER TABLE `sql_projects`
  MODIFY `pro_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sql_services`
--
ALTER TABLE `sql_services`
  MODIFY `ser_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

--
-- AUTO_INCREMENT for table `sql_testimonials`
--
ALTER TABLE `sql_testimonials`
  MODIFY `tes_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sql_users`
--
ALTER TABLE `sql_users`
  MODIFY `usr_id` int(11) NOT NULL AUTO_INCREMENT;
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 */;
