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

START TRANSACTION;



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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int NOT NULL,
  `title` varchar(300) NOT NULL,
  `image` varchar(300) NOT NULL,
  `orderid` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `title`, `image`, `orderid`) VALUES
(37, '', '37-9263-Untitled-design-(3).png', 0),
(35, '', '35-6351-Untitled-design-(1).png', 0),
(36, '', '36-3119-Untitled-design-(2).png', 0),
(32, '', '32-9087-Untitled-design-(1).png', 0);

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `category_id` int NOT NULL,
  `category_name` varchar(300) NOT NULL,
  `orderid` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`category_id`, `category_name`, `orderid`) VALUES
(1, 'Category One', 1),
(2, 'Category Two', 2),
(3, 'Category Three', 3),
(4, 'Category four', 4),
(5, 'Category Five', 5),
(6, 'Category Six', 6),
(7, 'Category Seven', 7);

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

--
-- Table structure for table `complements`
--

CREATE TABLE `complements` (
  `complement_id` int NOT NULL,
  `complement_name` varchar(300) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `complement_email` varchar(300) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `complement_phone` varchar(30) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `complement_location` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `complement_message` longtext CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `complement_status` int NOT NULL,
  `complement_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

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

CREATE TABLE `contacts` (
  `contact_id` int NOT NULL,
  `full_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `phone` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `email` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `message` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `adddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`contact_id`, `full_name`, `phone`, `email`, `message`, `adddate`) VALUES
(1, 'love', '9876543210', 'luvupreet8@gmail.com', 'demo test', '2023-09-17 10:02:06');

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

--
-- Table structure for table `content_table`
--

CREATE TABLE `content_table` (
  `content_title` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `page_title` varchar(300) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `content_desc` longtext CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `content_image` varchar(300) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `orderid` int NOT NULL,
  `status` varchar(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'c'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `content_table`
--

INSERT INTO `content_table` (`content_title`, `page_title`, `content_desc`, `content_image`, `orderid`, `status`) VALUES
('home', 'Welcome To Jyoti Dabral Interiors', 'Welcome to the homepage of Jyoti Dabral, a renowned interior designer based in Dehradun, Uttarakhand. With vast experience designing over 8lakh sqft of individual homes and around 10lakh sqft of commercial properties, Jyoti Dabral has established herself as one of the leading interior designers in the industry.<br>\r\nJyoti Dabral has a keen eye for detail and a passion for creating beautiful and functional spaces that reflect the personality and lifestyle of her clients. She has worked on various projects, from small apartments to large commercial spaces, and has received accolades for her exceptional work.', 'ssabgurukul-8127-newBSKlogo.png', 0, 'c'),
('mission', 'MISSION', '', 'mission-2950-newBSKlogo.png', 0, 'c'),
('aboutus', 'Welcome To Jyoti Dabral Interiors', '<div>Welcome to the homepage of Jyoti Dabral, a renowned interior designer based in Dehradun, Uttarakhand. With vast experience designing over 8lakh sqft of individual homes and around 10lakh sqft of commercial properties, Jyoti Dabral has established herself as one of the leading interior designers in the industry.</div><div><br></div><div>Jyoti Dabral has a keen eye for detail and a passion for creating beautiful and functional spaces that reflect the personality and lifestyle of her clients. She has worked on various projects, from small apartments to large commercial spaces, and has received accolades for her exceptional work.</div>', '1694495057507717.jpg', 0, 'c'),
('vision', 'VISION', '<div><font color=\"#000099\" face=\"times new roman\" size=\"2\"><br></font></div>', 'vision-7424-sant.png', 0, 'c'),
('contact', 'Address', '<b>Jyoti Dabral Interiors</b><br><div><div>Address: Shop No- F20-21 Second Floor, Crossroads Mall, 1 Old Survey Road Dehra Dun, Uttarakhand, India 248001</div><div>Tel: +(91) 0135 409 9520</div><div>Email: jyotidabralinteriors@gmail.com</div><div><br></div><div><br></div><div><br></div></div>', '', 0, 'c'),
('ceo', 'I am Jyoti Dabral', '<p class=\"MsoNormal\" style=\"text-align: justify;\"><font color=\"#000033\" size=\"2\">Dapibus nec vitae ante mattis. Aliquam phasellus ac dui augue in. Sed aliquet in egestas hac at proin sed quam. Etiam aliquet sagittis non, massa cum pulvinar. Et in leo, tempus purus vestibulum ut blandit et mi. Odio massa purus vel praesent arcu enim elit felis viverra.</font></p><p class=\"MsoNormal\" style=\"text-align: justify;\"><font color=\"#000033\" size=\"2\"><br></font></p><p class=\"MsoNormal\" style=\"text-align: justify;\"><font color=\"#000033\" size=\"2\">Magna aliquam interdum mattis ipsum arcu. Elit odio elit viverra quis metus amet eleifend amet. Vet suspendisse faucibus tempor ipsum integer.</font></p><p class=\"MsoNormal\" style=\"text-align: justify;\"><font color=\"#000033\" size=\"2\"><br></font></p><p class=\"MsoNormal\" style=\"text-align: justify;\"><font color=\"#000033\" size=\"2\"><b>Jyoti Dabral</b></font></p><p class=\"MsoNormal\" style=\"text-align: justify;\"><font color=\"#000033\" size=\"2\"><br></font></p><p class=\"MsoNormal\" style=\"text-align: justify;\"><font color=\"#000033\" size=\"2\">CEO - Jyoti Dabral Interiors</font></p>', '17026532992820dsc05035.jpg', 0, 'c'),
('chairman', 'From The President\'s Desk', '<div><div><font size=\"4\"><b style=\"\">S. Birinder Singh Sidhu, DGP (RETD.)&nbsp;</b></font></div><div><font size=\"3\">President,&nbsp;</font><span style=\"font-size: small;\">G.H.G.Ujjagar Hari Trust,&nbsp;</span><span style=\"font-size: small;\">Sidhwan Khurd</span></div></div><div><br></div><div>&nbsp; &nbsp; A hearty welcome to all the freshers at G.H.G. Institute of Law for Women, Sidhwan Khurd.&nbsp; Congratulations at being inducted as a proud member of fraternity at Sidhwan Khurd Group of Educational Institutions which has not only pioneered the cause of women\'s education and empowerment in Punjab for over a century, but also delivered globally, some of the finest specimens of educated and accomplished young ladies, groomed in traditional values of our culture.&nbsp;</div><div><br></div>&nbsp; &nbsp; While the institute that you have chosen to shape your destiny is just over a decade old, it stands way beyond it\'sni years in its reputation and achievements. This bears testimony to the untiring effort put in by our highly qualified and dedicated Principal and Staff not only in imparting professional academic excellence (both theoretical 8and practical) but also emphasizing exposure to extra curricular activities for attainment of physical fitness, stamina but all rounder balanced personality development.&nbsp;<br><br>&nbsp; &nbsp; &nbsp; Our Management and staff are committed to the cause, that&nbsp; you should not only thoroughly enjoy&nbsp; your academic experience in this institute but always carry&nbsp; pleasant and nostalgic memories of your Alma mater\'s idyllic, pollution-free salubrious surroundings coupled with its modern facilities and amenities.&nbsp;<div><br>&nbsp; &nbsp; &nbsp; &nbsp;Not one\'s to rest on our laurels,&nbsp; our Management, and team of professional faculty is&nbsp; constantly engaged in&nbsp; the futher improving the existing infrastructure, acquiring new aids to modern teaching methods and exposing you all to a higher level of legal luminaries as guest lecturers as part of our overall effort to enrich your academic experience at G. H. G.&nbsp; Institute of Law for Women.</div><div><br></div><div>&nbsp; &nbsp; &nbsp; &nbsp; Waheguru bless you all with a&nbsp; bright future.&nbsp;<br>&nbsp; &nbsp; &nbsp;<p class=\"MsoNormal\" style=\"text-align:justify;text-justify:inter-ideograph;\r\nline-height:200%\"><span style=\"font-size:14.0pt;line-height:200%;font-family:\r\n\" times=\"\" new=\"\" roman\",serif\"=\"\"><o:p></o:p></span></p></div>', '1602080485536650_img-20200824-wa0001.jpg', 0, 'c'),
('courses', 'Courses Available', '<p class=\"MsoNormal\" style=\"margin-left:.5in;text-indent:-.5in\"><o:p></o:p></p>', '', 0, 'c'),
('admissions', 'Eligibility Criteria', '<h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><font size=\"4\" face=\"times new roman\" style=\"font-weight: normal;\">1.&nbsp; &nbsp;B.A. LL.B. (Hons) (Five years Integrated Course)</font></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><span style=\"text-indent: -0.5in; font-weight: normal;\"><font size=\"4\" face=\"times new roman\">&nbsp; &nbsp;&nbsp;</font></span></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><span style=\"text-indent: -0.5in; font-weight: normal;\"><font size=\"4\" face=\"times new roman\">&nbsp; &nbsp; &nbsp; Minimum 50% marks in aggregate in 10+2 (in any stream), Minimum 45% marks in case of SC/ST candidates</font></span></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><font size=\"4\" face=\"times new roman\" style=\"font-weight: normal;\"><br></font></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><font size=\"4\" face=\"times new roman\" style=\"font-weight: normal;\">2.&nbsp; &nbsp;LL.B. (Three years &nbsp;Course)</font></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><span style=\"font-weight: normal;\"><font size=\"4\" face=\"times new roman\">&nbsp; &nbsp; &nbsp;Minimum 45% marks in aggregate in graduation (in any stream), Minimum 40% marks for &nbsp;SC/ST candidates</font><font size=\"4\" face=\"times new roman\"><br></font><font size=\"4\" face=\"times new roman\"><br></font></span></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><span style=\"font-weight: normal;\"><font size=\"4\" face=\"times new roman\">3.&nbsp; Number of Seats Available:<br></font><font size=\"4\" face=\"times new roman\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</font></span></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><span style=\"font-weight: normal;\"><font size=\"4\" face=\"times new roman\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1. B.A. LL.B. (Hons) (Five years Integrated Course)&nbsp; &nbsp; &nbsp; &nbsp; = &nbsp;60 Seats<br></font><font size=\"4\" face=\"times new roman\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2. LL.B. (Three years &nbsp;Course) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;<span style=\"text-indent: -0.5in;\">60 Seats</span></font><span style=\"text-indent: -0.5in;\"><font size=\"4\" face=\"times new roman\"><br></font></span><span style=\"text-indent: -0.5in;\"><font size=\"4\" face=\"times new roman\"><br></font></span></span></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><span style=\"font-weight: normal;\"><span style=\"text-indent: -0.5in;\"><font size=\"4\" face=\"times new roman\">4.&nbsp; &nbsp;Medium of Instruction<br></font></span><span style=\"text-indent: -0.5in;\"><font size=\"4\" face=\"times new roman\"><br></font></span></span></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><span style=\"text-indent: -0.5in; font-weight: normal;\"><font size=\"4\" face=\"times new roman\">&nbsp; &nbsp; &nbsp; The medium of instruction of examination is \"English\" only.</font></span></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><span style=\"text-indent: -0.5in; font-weight: normal;\"><font size=\"4\" face=\"times new roman\"><br></font></span></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><span style=\"text-indent: -0.5in; font-weight: normal;\"><font size=\"4\" face=\"times new roman\">5.&nbsp; &nbsp;Pattern of Selection</font></span></h4><h4 style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><span style=\"font-weight: normal;\"><font size=\"4\" face=\"times new roman\"><span style=\"text-indent: -0.5in;\">&nbsp; &nbsp; &nbsp;The candidates have to submit their admission form, attached with the prospectus-cum-information brochure&nbsp;</span><span style=\"text-indent: -0.5in;\">duly completed in all respects along with the attested photocopies of certificates mentioned below :&nbsp;<br></span></font><span style=\"text-indent: -0.5in;\"><font size=\"4\" face=\"times new roman\">&nbsp;i. &nbsp; Matriculation Certificate.<br></font></span><span style=\"text-indent: -0.5in;\"><font size=\"4\" face=\"times new roman\">&nbsp;ii. &nbsp;10+2 passing certificate and Detail Marks Card.<br></font></span><span style=\"text-indent: -0.5in;\"><font size=\"4\" face=\"times new roman\">&nbsp;iii. &nbsp;Graduation Degree and Detail Marks Card for B.A.LL.B (Hons) ( five years Integrated course).<br></font></span><font size=\"4\" face=\"times new roman\">&nbsp;iv. &nbsp;Character certificate from Principal of school/college last attended.<br></font><font size=\"4\" face=\"times new roman\">&nbsp;v. &nbsp; Migration certificate in case of those who passed out their graduation from a university other than Panjab University Chandigarh.&nbsp;</font></span></h4><p class=\"MsoListParagraphCxSpFirst\" style=\"text-align: justify; margin-left: 0.75in; text-indent: -0.5in;\"><br></p>', '', 0, 'c'),
('achiever', 'Achievments', 'Manjinder Kaur', '', 0, 'c'),
('secretary', 'From The Secretary\'s Desk', '<font color=\"#660000\" size=\"5\"><b>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; S. Harmail Singh&nbsp; Sidhu</b></font><div align=\"justify\"><font size=\"3\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Secretary</font></div><div align=\"justify\"><span style=\"font-size: small;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; G.H.G. Ujjagar Hari Trust</span></div><div align=\"justify\"><div><font size=\"2\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; Sidhwan Khurd</font></div></div><div><font size=\"2\"><br></font></div><div><font size=\"2\"><div><div><b>“The only good is knowledge and the only evil is ignoranceâ€<span class=\"Apple-tab-span\" style=\"white-space:pre\">	</span>-<span class=\"Apple-tab-span\" style=\"white-space:pre\">	</span>Socrates......</b></div><div style=\"text-align: justify;\"><br></div><div style=\"text-align: justify;\">&nbsp; &nbsp; &nbsp; G.H.G. Institute of Law for Women, Sidhwan Khurd is a premier Law Institute working in the field of girls education in the state of Punjab.</div><div style=\"text-align: justify;\">It has started in 2006 and within a very short span of time it has gained momentum to reach up to the highest standard in the field of legal studies.</div><div style=\"text-align: justify;\"><br></div><div style=\"text-align: justify;\">&nbsp; &nbsp; &nbsp;G.H.G. Institute of Law for Women, Sidhwan Khurd is situated in the lap of nature surrounded by peaceful and serene environment. This law institute is committed towards imparting meaningful education and knowledge to its girl students. The well qualified, trained and dedicated faculty members of this institution have their endless efforts through adopting effective and skilled teaching methodology to raise the standards of the studies.&nbsp;</div><div style=\"text-align: justify;\">&nbsp; &nbsp; &nbsp;I wish luck to the new and old students for their studies and appreciate the efforts of the teachers to bring this institution among the top law colleges of the state.</div></div><div><br></div><div><br></div></font></div>', '1602083577224860_img-20200824-wa0002.jpg', 0, 'c');

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `course_id` int NOT NULL,
  `course_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `course_desc` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `course_duration` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `course_elig` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`course_id`, `course_name`, `course_desc`, `course_duration`, `course_elig`) VALUES
(1, 'B.A.LL.B. (Hons)', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore suscipit, inventore aliquid incidunt, quasi error! Natus esse rem eaque asperiores eligendi dicta quidem iure, excepturi doloremque eius neque autem sint error qui tenetur, modi provident aut, maiores laudantium reiciendis expedita. Eligendi\r\n\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit. Labore voluptatem officiis quod animi possimus a, iure nam sunt quas aperiam non recusandae reprehenderit, nesciunt cumque pariatur totam repellendus delectus? Maxime quasi earum nobis, dicta, aliquam facere reiciendis, delectus voluptas, ea assumenda blanditiis placeat dignissimos quas iusto repellat cumque.', '5 Years Integrated Course', '<ul><li>10+2 exam (in any stream)</li><li>Minimum 50 % marks for General, minimum &nbsp;45% marks for SC/ST candidates in aggregate in 10+2</li></ul>'),
(2, 'LL.B.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore suscipit, inventore aliquid incidunt, quasi error! Natus esse rem eaque asperiores eligendi dicta quidem iure, excepturi doloremque eius neque autem sint error qui tenetur, modi provident aut, maiores laudantium reiciendis expedita. Eligendi\r\n\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit. Labore voluptatem officiis quod animi possimus a, iure nam sunt quas aperiam non recusandae reprehenderit, nesciunt cumque pariatur totam repellendus delectus? Maxime quasi earum nobis, dicta, aliquam facere reiciendis, delectus voluptas, ea assumenda blanditiis placeat dignissimos quas iusto repellat cumque.', '3 years Course', '<ul><li>Minimum 45 % markes in aggregate in graduation (in any stream), minimum 40% markes for SC/ST candidates.</li></ul>');

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `department_id` int NOT NULL,
  `department_name` varchar(300) NOT NULL,
  `department_img` varchar(300) NOT NULL,
  `department_desc` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`department_id`, `department_name`, `department_img`, `department_desc`) VALUES
(8, 'Non-Teaching Staff', '', ''),
(2, 'Computer', '', ''),
(4, 'Hindi', '', ''),
(6, 'Punjabi', '', ''),
(7, 'Law', '', ''),
(9, 'English', '', ''),
(10, 'History', '', ''),
(11, 'Sociology', '', ''),
(12, 'Political Science', '', ''),
(13, 'Economics', '', '');

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

--
-- Table structure for table `facilities`
--

CREATE TABLE `facilities` (
  `facility_id` int NOT NULL,
  `facility_name` varchar(300) NOT NULL,
  `facility_img` varchar(300) NOT NULL,
  `facility_desc` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `facilities`
--

INSERT INTO `facilities` (`facility_id`, `facility_name`, `facility_img`, `facility_desc`) VALUES
(1, 'DESIGN & PLANNING', '1-5975-DSC_0033.JPG', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.'),
(11, 'EXTERIOR &DESIGNING', '11-7912-medicul.jpg', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.'),
(9, 'CUSTOM SOLUTIONS', '9-4398-hostel.jpg', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.'),
(10, 'CUSTOME & SOLUTIONS', '10-9359-bus.jpg', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.'),
(4, 'AUTHOR’S CONTRO', '4-5565-DSC_0008.JPG', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.'),
(7, 'CREATING CONCEPT', '7-2801-IMG-20150728-WA0043.jpg', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.'),
(8, 'FURNITURE & DECOR', '8-2116-obc-1.jpg', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.');

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

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

CREATE TABLE `galleries` (
  `gallery_id` int NOT NULL,
  `gallery_title` varchar(300) NOT NULL,
  `gallery_image` varchar(300) NOT NULL,
  `orderid` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galleries`
--

INSERT INTO `galleries` (`gallery_id`, `gallery_title`, `gallery_image`, `orderid`) VALUES
(1, 'Living Room', '', 0),
(2, 'Shop', '', 0),
(3, 'Misc', '', 0);

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

--
-- Table structure for table `galleries_imgs`
--

CREATE TABLE `galleries_imgs` (
  `imgid` int NOT NULL,
  `type_id` int NOT NULL,
  `type` varchar(1) NOT NULL DEFAULT 'I',
  `img` varchar(200) NOT NULL,
  `orderid` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galleries_imgs`
--

INSERT INTO `galleries_imgs` (`imgid`, `type_id`, `type`, `img`, `orderid`) VALUES
(106, 1, 'I', 'a-(1390).JPG', 0),
(107, 1, 'I', 'IMG-20150728-WA0025.jpg', 0),
(102, 2, 'I', 'IMG-20150728-WA0010.jpg', 4),
(103, 2, 'I', 'IMG-20150728-WA0071.jpg', 3),
(104, 2, 'I', 'IMG-20150728-WA0082.jpg', 2),
(60, 3, 'I', 'IMG-20150728-WA0017.jpg', 18),
(61, 3, 'I', 'IMG-20150728-WA0015.jpg', 10),
(62, 3, 'I', 'IMG-20150728-WA0016.jpg', 21),
(63, 3, 'I', 'IMG-20150728-WA0020.jpg', 23),
(64, 3, 'I', 'IMG-20150728-WA0018.jpg', 12),
(65, 3, 'I', 'IMG-20150728-WA0019.jpg', 22),
(66, 3, 'I', 'IMG-20150728-WA0026.jpg', 24),
(67, 3, 'I', 'IMG-20150728-WA0027.jpg', 25),
(68, 3, 'I', 'IMG-20150728-WA0028.jpg', 14),
(69, 3, 'I', 'IMG-20150728-WA0050.jpg', 15),
(70, 3, 'I', 'IMG-20150728-WA0068.jpg', 26),
(71, 3, 'I', 'IMG-20150728-WA0074.jpg', 6),
(72, 3, 'I', 'IMG-20150728-WA0029.jpg', 9),
(73, 3, 'I', 'IMG-20150728-WA0075.jpg', 1),
(74, 3, 'I', 'IMG-20150728-WA0080.jpg', 2),
(75, 3, 'I', 'IMG-20150728-WA0079.jpg', 17),
(76, 3, 'I', 'IMG-20150728-WA0081.jpg', 3),
(55, 3, 'I', 'IMG-20150728-WA0015.jpg', 8),
(83, 3, 'I', 'IMG-20150728-WA0088.jpg', 11),
(82, 3, 'I', 'IMG-20150728-WA0087.jpg', 5),
(81, 3, 'I', 'IMG-20150728-WA0089.jpg', 7),
(80, 3, 'I', 'IMG-20150728-WA0086.jpg', 27),
(79, 3, 'I', 'IMG-20150728-WA0084.jpg', 4),
(78, 3, 'I', 'IMG-20150728-WA0085.jpg', 16),
(77, 3, 'I', 'IMG-20150728-WA0083.jpg', 19),
(105, 1, 'I', 'a-(1061).JPG', 0),
(84, 3, 'I', 'IMG-20150728-WA0092.jpg', 20),
(85, 3, 'I', 'IMG-20150728-WA0091.jpg', 13),
(86, 4, 'I', 'IMG-20150728-WA0011.jpg', 7),
(87, 4, 'I', 'IMG-20150728-WA0012.jpg', 1),
(88, 4, 'I', 'IMG-20150728-WA0021.jpg', 3),
(89, 4, 'I', 'IMG-20150728-WA0014.jpg', 6),
(90, 4, 'I', 'IMG-20150728-WA0013.jpg', 4),
(91, 4, 'I', 'IMG-20150728-WA0022.jpg', 2),
(92, 4, 'I', 'IMG-20150728-WA0023.jpg', 5),
(124, 8, 'I', 'IMG-20150901-WA0098.jpg', 1),
(125, 8, 'I', 'IMG-20150901-WA0096.jpg', 2),
(130, 8, 'I', 'IMG-20150728-WA0059.jpg', 3),
(127, 8, 'I', 'IMG-20150901-WA0103.jpg', 4),
(128, 9, 'I', 'IMG-20150901-WA0094.jpg', 0),
(129, 9, 'I', 'IMG-20150728-WA0036.jpg', 0),
(131, 8, 'I', 'IMG-20150728-WA0061.jpg', 5),
(132, 10, 'I', 'IMG-20150728-WA0032.jpg', 1),
(133, 2, 'I', 'IMG-20150728-WA0031.jpg', 1),
(134, 11, 'I', 'IMG-20150728-WA0063.jpg', 1),
(135, 11, 'I', 'IMG-20150728-WA0060.jpg', 3),
(136, 11, 'I', 'IMG-20150728-WA0058.jpg', 2);

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

--
-- Table structure for table `icategories`
--

CREATE TABLE `icategories` (
  `category_id` int NOT NULL,
  `category_name` varchar(300) NOT NULL,
  `orderid` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `icategories`
--

INSERT INTO `icategories` (`category_id`, `category_name`, `orderid`) VALUES
(1, 'Session 2019-20', 1),
(2, 'Session 2020-21', 2);

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

--
-- Table structure for table `mail_settings`
--

CREATE TABLE `mail_settings` (
  `email` varchar(200) NOT NULL,
  `new_inquiry` text NOT NULL,
  `newsletter` text NOT NULL,
  `newsletter_inquiry` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mail_settings`
--

INSERT INTO `mail_settings` (`email`, `new_inquiry`, `newsletter`, `newsletter_inquiry`) VALUES
('luvupreet88@gmail.com', 'Thanks for Contact Us', 'info@vnswoodworks.com', 'Thanks For Newsletter Subscription');

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

--
-- Table structure for table `punchline`
--

CREATE TABLE `punchline` (
  `id` int NOT NULL,
  `ptitle` text NOT NULL,
  `pstatus` varchar(1) NOT NULL DEFAULT 'N',
  `pupdate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `punchline`
--

INSERT INTO `punchline` (`id`, `ptitle`, `pstatus`, `pupdate`) VALUES
(1, 'HAPPY NEW YEAR, 2021', 'Y', '0000-00-00 00:00:00');

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

--
-- Table structure for table `social_links`
--

CREATE TABLE `social_links` (
  `social_link_id` int NOT NULL,
  `contact_no` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `facebook_link` varchar(300) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `twitter_link` varchar(300) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `linked_link` varchar(300) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `youtube_link` varchar(300) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `insta_link` varchar(300) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `site_logo` varchar(300) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `social_links`
--

INSERT INTO `social_links` (`social_link_id`, `contact_no`, `facebook_link`, `twitter_link`, `linked_link`, `youtube_link`, `insta_link`, `site_logo`) VALUES
(1, '+91 0161 222 3252', 'https://www.facebook.com/jdelegantinteriors', 'https://twitter.com/', 'https://in.linkedin.com/in/jyoti-dabral-8732b0213', 'https://www.youtube.com/channel/UC6a0rRO9B3AX-5cnGSHIgeQ/about', 'https://www.instagram.com/jyoti.dabral/?hl=en', '1-6396-logo.png');

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

--
-- Table structure for table `staffs`
--

CREATE TABLE `staffs` (
  `staff_id` int NOT NULL,
  `staff_title` varchar(300) NOT NULL,
  `department_id` int NOT NULL,
  `staff_education` varchar(300) NOT NULL,
  `staff_experience` varchar(300) NOT NULL,
  `staff_designation` varchar(300) NOT NULL,
  `staff_image` varchar(300) NOT NULL,
  `orderid` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staffs`
--

INSERT INTO `staffs` (`staff_id`, `staff_title`, `department_id`, `staff_education`, `staff_experience`, `staff_designation`, `staff_image`, `orderid`) VALUES
(4, 'Dr. Santosha Kumar Nayak', 7, 'Ph.D.(Law), Ph.D.(Psychology)', '', 'Principal / Public Information Officer', '4-2732-principal-1.jpg', 1),
(2, 'Gurpreet Kaur', 5, 'M.Ed.', '5 Year', 'Asstt.Professor', '2-3650-discussion-author-02.jpg', 2),
(3, 'Priyanka', 3, 'MA (Eng)', '2 Year', 'Asstt.Professor', '3-8687-image-01.jpg', 3),
(6, 'Dr. Shweta Dhand', 7, 'B.Com, LL.M., Ph.D (Law), UGC/NET(Law)', '', 'Assistant Professor', '6-8495-shewta.jpg', 5),
(7, 'Ms. Baljeet Kaur', 7, 'M.A. (Pol.Sc.), LL.M., UGC/NET (Law), Ph.D. (Pursuing)', '', 'Assistant Professor', '7-1504-baljit.jpg', 6),
(8, 'Ms. Jaspal Kaur', 7, 'M.A.(Pol.Sc.), LL.M., UGC/NET (Law), Ph.D (pursuing)', '', 'Assistant Professor', '8-3385-jaspal.jpg', 7),
(9, 'Ms. Neelam Rani', 7, 'M.A (English), LL.M., UGC/NET (Law), Ph.D. (Pursuing), Computer (Fundamental & Desktop Publishing)', '', 'Assistant Professor', '9-9935-Photo_105.jpg', 8),
(10, 'Dr.  Jaswinder', 7, 'B.Com., LL.M., UGC/NET (Law), Ph.D. (Law), Computer (Basics)', '', 'Assistant Professor', '10-9572-jaswinder.jpg', 9),
(34, 'Dr. Lovely Sharma', 4, 'M.A., Ph.D (Hindi Literature)', '', 'Assistant Professor', '34-7306-IMG-20161110-WA0010[1].jpg', 11),
(18, 'Dr.  Harvinder Kaur', 7, 'LL.M., UGC/NET (Law), Ph.D.(Law)', '', 'Assistant Professor', '18-3535-harvinder.jpg', 10),
(42, 'Mr. Vineet Gupta', 7, 'M.A. (English), LL.M, UGC/NET (Law), UGC/NET (Criminology )', '', 'Assistant Professor', '42-2163-IMG_5055-copy.jpg', 14),
(22, 'Mr. Rajiv Bhatia', 7, 'B.Com., LL.B., LL.M.', '', 'Advocate', '22-9687-011.jpg', 22),
(37, 'Ms. Harpreet Kaur', 6, 'M.A.,M.Phil.(Punjabi), UGC/NET (Punjabi)', '', 'Assistant Professor', '37-5879-IMG-20161110-WA0009[1].jpg', 12),
(24, 'Ms. Abhilasha Kapoor', 8, 'M.A. (Hindi), M.A. (Sociology), M.Lib.', '', 'Librarian', '24-1225-abihilash.jpg', 21),
(53, 'Ms. Manpreet Kaur', 12, 'M.A. (POL.SC.), M.ED, UGC/NET(POL.SC.)', '', 'Assistant Professor', '53-3618-IMG_20190804_160250.JPG', 19),
(54, 'Dr. Navdeep Kaur', 9, 'M. A. (English), M. Phil, Ph. D,  B. Ed.', '', 'Guest Faculty', '54-5113-IMG-20190804-WA0012.jpg', 18),
(48, 'Dr. Jasbir kaur', 7, 'M. A. (Pol SC.) LL. M,  Ph.D.(Law) , UGC/NET(Law)', '', 'Assistant Professor', '48-8046-IMG-20200817-WA0007.jpg', 17);

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

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `subscriber_id` int NOT NULL,
  `sname` varchar(300) NOT NULL,
  `email` varchar(300) NOT NULL,
  `adddate` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subscribers`
--

INSERT INTO `subscribers` (`subscriber_id`, `sname`, `email`, `adddate`) VALUES
(1, '', 'luvupreet88@gmail.com', '2023-09-17');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `testimonial_id` int NOT NULL,
  `testimonial_name` varchar(300) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `testimonial_description` longtext CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `testimonial_company` varchar(300) NOT NULL,
  `image` varchar(300) NOT NULL,
  `orderid` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`testimonial_id`, `testimonial_name`, `testimonial_description`, `testimonial_company`, `image`, `orderid`) VALUES
(1, 'Anurag Gupta', 'Amazing understanding of the Client\'s taste and needs. Has a good eye on space utility and creativity is tailor made and unique to the client.Value for Investments.', 'Customer', '1-3371-student-testimonial.jpg', 0),
(6, 'Shraddha Negi', 'Jyoti Dabral- has been a known name in Dehradun for a decade now. You may know her also as JD Elegant. She has just diversified herself into an experiential center too. Both her beautiful showrooms are situated at cross roads mall Dehradun. She has also launched products like upholstery under her brand name available only at Crossroads Mall. Her vision for her clients brief is followed throughly with structured and professional services.  She is an expert at understanding,  undertaking and the timely delivery of all her projects. Her forte is end to end residential and restaurant projects. She excels in bespoke services as well. Catering to your every minutest of details without a whim that is JD - Jyoti Dabral. Look out!! for her soon to be launched a detailed design virtual experience only for her esteemed clients!!!\r\nI look forward to do business with you soon!', 'Customer', '', 0),
(2, 'Mdshahbaz Khan', 'I had a great experience Getting my House Interior and Exterior Facade work done from the firm. I m very Happy with their working details about the designs and Implemention on site as per Design. Moreover the Actual Furnishing came out to be even More appealing than the 3ds provided. I m very Happy with the work. Will recommend everyone looking for nice Elegant Interiors in their Budget determined.', 'Customer', '2-8452-discussion-author-02.jpg', 0),
(5, 'Shimona Rana', 'We got our home done with Jyoti ma\'am few months back and we\'re amazed by he\'s great talent and hardwork. She\'s very professional with her work. We really love our new home. Thankyou so much ma\'am.', 'Customer', '', 0),
(3, 'Shuchita Srivastava', 'Jyoti Dabral is a magician. She can transform a simple flat/villa into a stunningly beautiful dream house. I am in awe of her design abilities and creativity. Her choice of theme, color combinations and utilization of lights are absolutely fantastic. Undoubtedly, she is the best interior decorator in Dehradun.', 'Customer', '3-6983-image-04.jpg', 0),
(4, 'Archana Aswal', 'Jyoti has great understanding of the clients taste and can make your imagination come to life (and give you a better and more utilitarian version). Her designs are masterpieces, the workmanship absolutely gorgeous and sturdy.', 'Customer', '', 0),
(7, 'Vikas Dewan', 'My experience of getting the work done was fabulous right from designing , planning and execution.  Thank you team JB to have done a superb job .', 'Customer', '', 0),
(8, 'Sanjay Pant', 'Bedroom design, Living room design, Drawing-room design , Interior design for our home done with satisfaction and quality.\r\nPositive: Professionalism, Quality', 'Customer', '', 0),
(9, 'parul agarwal', 'Looking for Bespoke products? Perfect place for all our needs. Their services and product quality speaks for them.', 'Customer', '', 0),
(10, 'Harish Chandhok', 'Have had fantastic and wonderful experience regarding interiors for our Villa at Panache Valley with Jyoti ,\r\n\r\nProfessionalism and dedication personified\r\nThanks', 'Customer', '', 0),
(11, 'Manjari Khanwalkar', 'Great fan of JD’s aesthetic sense, contemporary designs and awesome colour schemes. Keep Rocking Lady!', 'Customer', '', 0),
(12, 'Sanjay Joshi', 'One of best interior and furniture manufacturer in Dehradun\r\nI would like to recommend everyone in Dehradun', 'Customer', '', 0),
(13, 'Manan Chadha', 'Best in the business. Professional and client oriented approach. 💯 …', 'Customer', '', 0),
(14, 'Poonam Bisht', 'Great experience with Dabral Furnitures…ðŸ‘ …', 'Customer', '', 0),
(15, 'Manvi Manglik', 'Amazing work and with in time', 'Customer', '', 0),
(16, 'Pooja Purohit', 'Amazing and aesthetic work', 'Customer', '', 0),
(17, 'chandrakanta Rana', 'Beautiful work', 'Customer', '', 0),
(18, 'Keshav Ajmani', 'AMAZING AMAZING AMAZING', 'Customer', '', 0);

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

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `video_id` int NOT NULL,
  `video_title` text NOT NULL,
  `video_code` text NOT NULL,
  `video_desc` text NOT NULL,
  `orderid` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`video_id`, `video_title`, `video_code`, `video_desc`, `orderid`) VALUES
(16, 'The Grand Launch', '<iframe style=\"\"min-height:200px;\" width=\"100%\" src=\"https://www.youtube.com/embed/pkCSNRLKPtk?si=dfsvcN7DeV1N1GiL\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></iframe>', 'Here\'s our 2nd office & 1st Interiors Experience Centre in Uttarakhand. Thank you for your love & support! 😊\r\nMissed the update? We\'re open! Please visit us. \r\n\r\nðŸ“ Crossroads Mall, E.C. Road, Dehradun\r\n\r\n#JD #jdelegantinteriors #homedesign #interiors #interiordesigner #houserenovation #revamp #dabralsfurnitureforever', 1),
(7, 'Interiors Reveal of 3 BHK Apartment by Jyoti Dabral', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/p0hFjqpkkYM?si=rxzP5pWUlkDpNPaX\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></iframe>', 'A home is the best place in the whole world and Diwali the best time of the year to celebrate in the Home. Wonderful People and Amazing experience in being a part of their journey.  \r\n\r\nJyoti Dabral \r\n9557007770\r\njyotidabralinteriors@gmail.com', 2),
(11, 'Capital Heights Apartments, GMS Road', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/VFmr8cEJt48?si=Ewd9Jn82ggQyPcFe\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></iframe>', 'Welcome to our channel! In this video, we\'re excited to share the incredible transformation of our client\'s home. When they first approached us, their house was in a state of disrepair with dead pigeons littering the floors. It was clear that the home had been neglected for quite some time and needed a lot of work.\r\n\r\nOur team of experts went to work, and after two months of hard work and dedication, the house was completely transformed. The transformation was nothing short of a miracle, and the end result is a beautiful dream home that our clients are absolutely thrilled with.\r\n\r\nIn this video, we\'ll take you on a tour of the house, showcasing the dramatic changes that were made. Every detail of this renovation was carefully thought out to ensure that the final product was exactly what our clients had envisioned.\r\n\r\nOur goal was to make sure that our clients\' dream home became a reality, and we\'re proud to say that we achieved that goal.\r\n\r\nThank you for watching, and we hope that this video inspires you to take on your own home renovation projects. Don\'t forget to subscribe to our channel for more inspiring renovation stories and helpful tips and tricks.', 3),
(12, 'Beautiful Family 4 BHK Home Interiors in Pacific Golf Estate, Dehradun, Uttarakhand.', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/LdhcEUx0ix4?si=UOKKHUmXtLmdZgc7\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen></iframe>', 'Ready to Live Home aesthetically done by Jyoti Dabral taking into consideration each & every nuance of functionality, utility & elegance. \r\n#4bhkapartments  #interiors #dehradun #interiordesign #furniture #furnituredesign #bespokeinteriors #homeinterior #furnishing #fanzart #beautifulhomes #homedecor #uttarakhand #devbhoomi #beentheredoonthat #doon', 4);

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

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `complements`
--
ALTER TABLE `complements`
  ADD PRIMARY KEY (`complement_id`);

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

--
-- Indexes for table `content_table`
--
ALTER TABLE `content_table`
  ADD PRIMARY KEY (`content_title`);

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`course_id`);

--
-- Indexes for table `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`department_id`);

--
-- Indexes for table `facilities`
--
ALTER TABLE `facilities`
  ADD PRIMARY KEY (`facility_id`);

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

--
-- Indexes for table `galleries_imgs`
--
ALTER TABLE `galleries_imgs`
  ADD PRIMARY KEY (`imgid`);

--
-- Indexes for table `icategories`
--
ALTER TABLE `icategories`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `mail_settings`
--
ALTER TABLE `mail_settings`
  ADD PRIMARY KEY (`email`);

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

--
-- Indexes for table `social_links`
--
ALTER TABLE `social_links`
  ADD PRIMARY KEY (`social_link_id`);

--
-- Indexes for table `staffs`
--
ALTER TABLE `staffs`
  ADD PRIMARY KEY (`staff_id`);

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`subscriber_id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`testimonial_id`);

--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
  ADD PRIMARY KEY (`video_id`);

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `category_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `complements`
--
ALTER TABLE `complements`
  MODIFY `complement_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `contact_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
  MODIFY `course_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `department_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `facilities`
--
ALTER TABLE `facilities`
  MODIFY `facility_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `gallery_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `galleries_imgs`
--
ALTER TABLE `galleries_imgs`
  MODIFY `imgid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=153;

--
-- AUTO_INCREMENT for table `icategories`
--
ALTER TABLE `icategories`
  MODIFY `category_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `social_links`
--
ALTER TABLE `social_links`
  MODIFY `social_link_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `staffs`
--
ALTER TABLE `staffs`
  MODIFY `staff_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `subscriber_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `testimonial_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `videos`
--
ALTER TABLE `videos`
  MODIFY `video_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
COMMIT;

