-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 17, 2026 at 11:43 PM -- Server version: 10.11.19-MariaDB-cll-lve-log -- PHP Version: 8.4.25 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: `stiffsec_stiffwebdata` -- -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` int(11) NOT NULL, `username` varchar(80) DEFAULT NULL, `password_hash` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `username`, `password_hash`, `created_at`) VALUES (1, 'admin', '240be518fabd2724d0b9eb8cfa481bcb6069a89ef3d8e33ef22ce752459a7d07', '2026-09-17 23:40:21'); -- -------------------------------------------------------- -- -- Table structure for table `cities` -- CREATE TABLE `cities` ( `id` int(11) NOT NULL, `state_id` int(11) DEFAULT NULL, `name` varchar(120) DEFAULT NULL, `slug` varchar(140) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `cities` -- INSERT INTO `cities` (`id`, `state_id`, `name`, `slug`) VALUES (1, 1, 'Gurgaon', 'gurgaon'), (2, 1, 'Faridabad', 'faridabad'), (3, 2, 'Delhi', 'delhi'), (4, 3, 'Noida', 'noida'), (5, 3, 'Greater Noida', 'greater-noida'), (6, 3, 'Ghaziabad', 'ghaziabad'), (7, 4, 'Mumbai', 'mumbai'), (8, 4, 'Pune', 'pune'), (9, 5, 'Chennai', 'chennai'), (10, 6, 'Kolkata', 'kolkata'); -- -------------------------------------------------------- -- -- Table structure for table `enquiries` -- CREATE TABLE `enquiries` ( `id` int(11) NOT NULL, `name` varchar(120) DEFAULT NULL, `mobile` varchar(40) DEFAULT NULL, `city` varchar(120) DEFAULT NULL, `service` varchar(120) DEFAULT NULL, `message` text DEFAULT NULL, `source` varchar(180) DEFAULT NULL, `created_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `faqs` -- CREATE TABLE `faqs` ( `id` int(11) NOT NULL, `page_id` int(11) DEFAULT NULL, `question` varchar(255) DEFAULT NULL, `answer` text DEFAULT NULL, `sort_order` int(11) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `faqs` -- INSERT INTO `faqs` (`id`, `page_id`, `question`, `answer`, `sort_order`) VALUES (1, NULL, 'How can I hire security guards?', 'Share your city, site type, duty timing and number of guards. The team will suggest a suitable manpower plan.', 1), (2, NULL, 'Can I get replacement support?', 'Yes, replacement support can be planned as per service terms and staff availability.', 2), (3, NULL, 'Do you provide bouncers for one day events?', 'Yes, bouncers can be provided for one-day events, parties, weddings and corporate functions.', 3), (4, NULL, 'Can pages be edited from admin panel?', 'Yes, every page content, meta title, meta description, keywords, banner and location mapping can be edited from admin.', 4); -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` int(11) NOT NULL, `department` varchar(180) DEFAULT NULL, `title` varchar(180) DEFAULT NULL, `city` varchar(180) DEFAULT NULL, `description` text DEFAULT NULL, `status` varchar(20) DEFAULT NULL, `created_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `jobs` -- INSERT INTO `jobs` (`id`, `department`, `title`, `city`, `description`, `status`, `created_at`) VALUES (1, 'Management Department', 'Director General Manager', 'Multiple Cities', 'Senior management profile for operations, planning and team leadership.', 'active', '2026-09-17 23:40:21'), (2, 'Management Department', 'General Manager', 'Multiple Cities', 'General management profile for manpower service operations.', 'active', '2026-09-17 23:40:21'), (3, 'Management Department', 'Director General Manager Account', 'Multiple Cities', 'Accounts leadership and finance process management.', 'active', '2026-09-17 23:40:21'), (4, 'Management Department', 'General Manager Account', 'Multiple Cities', 'Accounts management and client billing coordination.', 'active', '2026-09-17 23:40:21'), (5, 'Management Department', 'Senior Manager Account', 'Multiple Cities', 'Senior accounts and reporting profile.', 'active', '2026-09-17 23:40:21'), (6, 'Management Department', 'Account Executive', 'Multiple Cities', 'Accounts executive profile for billing and documentation.', 'active', '2026-09-17 23:40:21'), (7, 'Department Of Operation', 'General Manager Operation', 'Multiple Cities', 'Operations leadership for deployment and field coordination.', 'active', '2026-09-17 23:40:21'), (8, 'Department Of Operation', 'Operation Manager', 'Multiple Cities', 'Manage site operations, staff duty and client coordination.', 'active', '2026-09-17 23:40:21'), (9, 'Department Of Operation', 'Area Manager', 'Multiple Cities', 'Area-level manpower and client handling role.', 'active', '2026-09-17 23:40:21'), (10, 'Department Of Operation', 'Field Officer', 'Multiple Cities', 'Field visit, staff follow-up and client support.', 'active', '2026-09-17 23:40:21'), (11, 'Department Of Marketing', 'General Manager Marketing', 'Multiple Cities', 'Marketing leadership and business development.', 'active', '2026-09-17 23:40:21'), (12, 'Department Of Marketing', 'Senior Manager Marketing', 'Multiple Cities', 'Senior sales and marketing role.', 'active', '2026-09-17 23:40:21'), (13, 'Department Of Marketing', 'Marketing Executive', 'Multiple Cities', 'Client calling, field marketing and lead follow-up.', 'active', '2026-09-17 23:40:21'), (14, 'HR Department', 'DGM Human Resources', 'Multiple Cities', 'HR leadership for recruitment and manpower pipeline.', 'active', '2026-09-17 23:40:21'), (15, 'HR Department', 'General Manager HR', 'Multiple Cities', 'HR management profile.', 'active', '2026-09-17 23:40:21'), (16, 'HR Department', 'Senior Manager HR', 'Multiple Cities', 'Recruitment and HR process profile.', 'active', '2026-09-17 23:40:21'), (17, 'HR Department', 'Senior Executive HR', 'Multiple Cities', 'HR executive profile.', 'active', '2026-09-17 23:40:21'), (18, 'HR Department', 'Executive HR', 'Multiple Cities', 'Recruitment calling and candidate coordination.', 'active', '2026-09-17 23:40:21'), (19, 'Ground Staff', 'Assignment Manager', 'Multiple Cities', 'Assignment and site staff coordination.', 'active', '2026-09-17 23:40:21'), (20, 'Ground Staff', 'Chief Security Officer', 'Multiple Cities', 'Senior security operations profile.', 'active', '2026-09-17 23:40:21'), (21, 'Ground Staff', 'Security Officer', 'Multiple Cities', 'Security officer profile for site management.', 'active', '2026-09-17 23:40:21'), (22, 'Ground Staff', 'Personal Security Officer', 'Multiple Cities', 'PSO profile for personal security.', 'active', '2026-09-17 23:40:21'), (23, 'Ground Staff', 'Bouncer', 'Multiple Cities', 'Bouncer profile for event and private duty.', 'active', '2026-09-17 23:40:21'), (24, 'Ground Staff', 'Security Supervisor', 'Multiple Cities', 'Security supervisor profile.', 'active', '2026-09-17 23:40:21'), (25, 'Ground Staff', 'Security Head Guard', 'Multiple Cities', 'Head guard profile for shift supervision.', 'active', '2026-09-17 23:40:21'), (26, 'Ground Staff', 'Security Guard', 'Multiple Cities', 'Security guard duty for office, society, factory and site.', 'active', '2026-09-17 23:40:21'), (27, 'Ground Staff', 'Fire Fighter', 'Multiple Cities', 'Fire safety support staff.', 'active', '2026-09-17 23:40:21'), (28, 'Ground Staff', 'Fire Officer', 'Multiple Cities', 'Fire officer role.', 'active', '2026-09-17 23:40:21'), (29, 'Management Of Facility', 'Director General Manager Facility', 'Multiple Cities', 'Facility management leadership profile.', 'active', '2026-09-17 23:40:21'), (30, 'Management Of Facility', 'General Manager Facility', 'Multiple Cities', 'Facility general management role.', 'active', '2026-09-17 23:40:21'), (31, 'Management Of Facility', 'Operation Manager Facility', 'Multiple Cities', 'Facility operations management profile.', 'active', '2026-09-17 23:40:21'), (32, 'Management Of Facility', 'Senior Manager Facility', 'Multiple Cities', 'Senior facility management profile.', 'active', '2026-09-17 23:40:21'), (33, 'Management Of Facility', 'Field Officer Facility', 'Multiple Cities', 'Facility field officer role.', 'active', '2026-09-17 23:40:21'), (34, 'Management Of Facility', 'Facility Manager', 'Multiple Cities', 'Facility manager profile.', 'active', '2026-09-17 23:40:21'), (35, 'Management Of Facility', 'Supervisor Housekeeping', 'Multiple Cities', 'Housekeeping supervisor profile.', 'active', '2026-09-17 23:40:21'), (36, 'Management Of Facility', 'House Keeper', 'Multiple Cities', 'Housekeeping staff profile.', 'active', '2026-09-17 23:40:21'), (37, 'Management Of Facility', 'Mali', 'Multiple Cities', 'Gardener / Mali profile.', 'active', '2026-09-17 23:40:21'); -- -------------------------------------------------------- -- -- Table structure for table `job_applications` -- CREATE TABLE `job_applications` ( `id` int(11) NOT NULL, `job_id` int(11) DEFAULT NULL, `name` varchar(160) DEFAULT NULL, `mobile` varchar(40) DEFAULT NULL, `email` varchar(160) DEFAULT NULL, `city` varchar(120) DEFAULT NULL, `experience` varchar(120) DEFAULT NULL, `current_salary` varchar(80) DEFAULT NULL, `expected_salary` varchar(80) DEFAULT NULL, `qualification` varchar(160) DEFAULT NULL, `address` text DEFAULT NULL, `message` text DEFAULT NULL, `resume` text DEFAULT NULL, `status` varchar(40) DEFAULT NULL, `created_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `localities` -- CREATE TABLE `localities` ( `id` int(11) NOT NULL, `city_id` int(11) DEFAULT NULL, `name` varchar(160) DEFAULT NULL, `slug` varchar(180) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `localities` -- INSERT INTO `localities` (`id`, `city_id`, `name`, `slug`) VALUES (1, 1, 'Sector 21', 'sector-21'), (2, 1, 'DLF Phase 1', 'dlf-phase-1'), (3, 1, 'DLF Phase 2', 'dlf-phase-2'), (4, 1, 'Cyber City', 'cyber-city'), (5, 1, 'Udyog Vihar', 'udyog-vihar'), (6, 1, 'Sohna Road', 'sohna-road'), (7, 1, 'Golf Course Road', 'golf-course-road'), (8, 1, 'Manesar', 'manesar'), (9, 3, 'Rohini', 'rohini'), (10, 3, 'Dwarka', 'dwarka'), (11, 3, 'Karol Bagh', 'karol-bagh'), (12, 3, 'Laxmi Nagar', 'laxmi-nagar'), (13, 4, 'Sector 62', 'sector-62'), (14, 4, 'Sector 63', 'sector-63'), (15, 4, 'Film City', 'film-city'); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `id` int(11) NOT NULL, `title` varchar(220) DEFAULT NULL, `slug` varchar(240) DEFAULT NULL, `h1` varchar(255) DEFAULT NULL, `subtitle` varchar(180) DEFAULT NULL, `summary` text DEFAULT NULL, `content` longtext DEFAULT NULL, `meta_title` varchar(255) DEFAULT NULL, `meta_description` text DEFAULT NULL, `meta_keywords` text DEFAULT NULL, `base_keyword` varchar(180) DEFAULT NULL, `location_type` enum('none','state','city') DEFAULT 'none', `state_id` int(11) DEFAULT NULL, `city_id` int(11) DEFAULT NULL, `banner_image` text DEFAULT NULL, `status` varchar(30) DEFAULT 'published', `sort_order` int(11) DEFAULT 0, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `pages` -- INSERT INTO `pages` (`id`, `title`, `slug`, `h1`, `subtitle`, `summary`, `content`, `meta_title`, `meta_description`, `meta_keywords`, `base_keyword`, `location_type`, `state_id`, `city_id`, `banner_image`, `status`, `sort_order`, `created_at`, `updated_at`) VALUES (1, 'Security Guard Services', 'security-guard-services', 'Security Guard Services', 'Verified Security Manpower', 'Hire trained security guards for office, society, factory, warehouse and residential requirements.', '

Professional Security Guard Services

We provide trained and documented security guards for day shift, night shift, temporary duty and monthly contracts. Our process focuses on manpower planning, duty briefing, grooming and replacement support.

', 'Security Guard Services | Stiff Security', 'Professional security guard services for commercial, residential and industrial sites.', 'security guard services, security agency, hire security guard', 'security guard services', 'none', NULL, NULL, 'https://images.unsplash.com/photo-1486406146926-c627a92ad1ab?auto=format&fit=crop&w=900&q=80', 'published', 1, '2026-09-17 23:40:21', '2026-09-17 23:40:21'), (2, 'Security Company in Haryana', 'security-company-in-haryana', 'Security Company in Haryana', 'State Level Security Services', 'Security, bouncer, housekeeping and facility manpower across major Haryana cities.', '

Security Company in Haryana

This state page automatically shows all cities added under Haryana from admin panel. Add more cities once and they will appear here.

', 'Security Company in Haryana', 'Security company in Haryana for guard, bouncer and housekeeping manpower.', 'security company in haryana', 'security company', 'state', 1, NULL, 'https://images.unsplash.com/photo-1486406146926-c627a92ad1ab?auto=format&fit=crop&w=900&q=80', 'published', 2, '2026-09-17 23:40:21', '2026-09-17 23:40:21'), (3, 'Security Company in Gurgaon', 'security-company-in-gurgaon', 'Security Company in Gurgaon', 'City Level Security Services', 'Security guard, bouncer, housekeeping and facility manpower in Gurgaon localities.', '

Security Company in Gurgaon

This city page automatically shows all Gurgaon localities added from admin panel. Bulk paste localities once and use them for local SEO blocks.

', 'Security Company in Gurgaon', 'Security company in Gurgaon with locality-wise service coverage.', 'security company in gurgaon', 'security company', 'city', 1, 1, 'https://images.unsplash.com/photo-1486406146926-c627a92ad1ab?auto=format&fit=crop&w=900&q=80', 'published', 3, '2026-09-17 23:40:21', '2026-09-17 23:40:21'), (4, 'Bouncer Service', 'bouncer-service', 'Bouncer Service', 'Event & Private Bouncers', 'Hire professional bouncers for events, parties, clubs, weddings and private functions.', '

Bouncer Services

We provide bouncer manpower for event entry, crowd control, VIP movement, private parties, weddings and corporate functions.

', 'Bouncer Service | Stiff Security', 'Professional bouncer service for events and private security.', 'bouncer service, hire bouncer', 'bouncer service', 'none', NULL, NULL, 'https://images.unsplash.com/photo-1492684223066-81342ee5ff30?auto=format&fit=crop&w=900&q=80', 'published', 4, '2026-09-17 23:40:21', '2026-09-17 23:40:21'), (5, 'Housekeeping Services', 'housekeeping-services', 'Housekeeping Services', 'Commercial Housekeeping Staff', 'Housekeeping staff for office, society, factory, hospital, mall and warehouse requirements.', '

Housekeeping Staff Provider

Deploy housekeeping staff for daily cleaning, maintenance, washroom care, pantry support and site hygiene.

', 'Housekeeping Services | Stiff Security', 'Professional housekeeping manpower services.', 'housekeeping services, housekeeping agency', 'housekeeping services', 'none', NULL, NULL, 'https://images.unsplash.com/photo-1581578731548-c64695cc6952?auto=format&fit=crop&w=900&q=80', 'published', 5, '2026-09-17 23:40:21', '2026-09-17 23:40:21'); -- -------------------------------------------------------- -- -- Table structure for table `services` -- CREATE TABLE `services` ( `id` int(11) NOT NULL, `title` varchar(180) DEFAULT NULL, `slug` varchar(200) DEFAULT NULL, `short_description` text DEFAULT NULL, `image` text DEFAULT NULL, `icon` varchar(80) DEFAULT NULL, `status` varchar(20) DEFAULT 'active', `sort_order` int(11) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `services` -- INSERT INTO `services` (`id`, `title`, `slug`, `short_description`, `image`, `icon`, `status`, `sort_order`) VALUES (1, 'Security Guard Services', 'security-guard-services', 'Trained guards for office, society, factory, warehouse and residential sites.', 'https://images.unsplash.com/photo-1486406146926-c627a92ad1ab?auto=format&fit=crop&w=900&q=80', 'bi bi-shield-check', 'active', 1), (2, 'Bouncer Services', 'bouncer-service', 'Professional bouncers for events, clubs, parties, weddings and private functions.', 'https://images.unsplash.com/photo-1492684223066-81342ee5ff30?auto=format&fit=crop&w=900&q=80', 'bi bi-person-arms-up', 'active', 2), (3, 'Housekeeping Services', 'housekeeping-services', 'Housekeeping manpower for offices, malls, hospitals, factories and societies.', 'https://images.unsplash.com/photo-1581578731548-c64695cc6952?auto=format&fit=crop&w=900&q=80', 'bi bi-stars', 'active', 3), (4, 'Facility Management', 'facility-management-services', 'Soft facility manpower, office support and site operations support.', 'https://images.unsplash.com/photo-1497366754035-f200968a6e72?auto=format&fit=crop&w=900&q=80', 'bi bi-building-gear', 'active', 4), (5, 'Bodyguard & PSO', 'bodyguard-service', 'Personal security officers and bodyguard support for VIP and executive protection.', 'https://images.unsplash.com/photo-1551836022-d5d88e9218df?auto=format&fit=crop&w=900&q=80', 'bi bi-person-lock', 'active', 5), (6, 'Event Security', 'event-security-services', 'Crowd management, entry gate support and event security manpower.', 'https://images.unsplash.com/photo-1511578314322-379afb476865?auto=format&fit=crop&w=900&q=80', 'bi bi-calendar-event', 'active', 6), (7, 'Cleaning Staff', 'cleaning-services', 'Cleaning and janitorial staff for commercial and industrial sites.', 'https://images.unsplash.com/photo-1527515637462-cff94eecc1ac?auto=format&fit=crop&w=900&q=80', 'bi bi-brush', 'active', 7), (8, 'Office Support Staff', 'office-support-staff', 'Office boy, pantry boy, helper and support manpower services.', 'https://images.unsplash.com/photo-1556761175-b413da4baf72?auto=format&fit=crop&w=900&q=80', 'bi bi-people', 'active', 8); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `setting_key` varchar(120) NOT NULL, `setting_value` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`setting_key`, `setting_value`) VALUES ('address', 'Gurgaon, Haryana'), ('ai_meta_tags', 'security guard agency, bouncer service, housekeeping staff, facility management, manpower services'), ('bing_verification', ''), ('custom_head_code', ''), ('email', 'info@stiffsecurity.com'), ('facebook_domain_verification', ''), ('footer_about', 'Verified manpower support for societies, offices, factories, warehouses, events, hospitals, schools and commercial sites.'), ('google_ads_verification', ''), ('google_site_verification', ''), ('home_description', 'Professional manpower agency for security guards, bouncers, housekeeping staff, facility management and support staff.'), ('home_title', 'Stiff Security | Security Guard, Bouncer, Housekeeping & Facility Management'), ('logo', 'assets/img/logo.png'), ('phone', '+91-0000000000'), ('site_name', 'Stiff Security General Services Pvt. Ltd.'), ('site_url', 'https://example.com'), ('whatsapp', '+91-0000000000'); -- -------------------------------------------------------- -- -- Table structure for table `states` -- CREATE TABLE `states` ( `id` int(11) NOT NULL, `name` varchar(120) DEFAULT NULL, `slug` varchar(140) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `states` -- INSERT INTO `states` (`id`, `name`, `slug`) VALUES (1, 'Haryana', 'haryana'), (2, 'Delhi', 'delhi'), (3, 'Uttar Pradesh', 'uttar-pradesh'), (4, 'Maharashtra', 'maharashtra'), (5, 'Tamil Nadu', 'tamil-nadu'), (6, 'West Bengal', 'west-bengal'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`); -- -- Indexes for table `cities` -- ALTER TABLE `cities` ADD PRIMARY KEY (`id`), ADD KEY `state_id` (`state_id`); -- -- Indexes for table `enquiries` -- ALTER TABLE `enquiries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `faqs` -- ALTER TABLE `faqs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `job_applications` -- ALTER TABLE `job_applications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `localities` -- ALTER TABLE `localities` ADD PRIMARY KEY (`id`), ADD KEY `city_id` (`city_id`); -- -- Indexes for table `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`); -- -- Indexes for table `services` -- ALTER TABLE `services` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`setting_key`); -- -- Indexes for table `states` -- ALTER TABLE `states` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `cities` -- ALTER TABLE `cities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `enquiries` -- ALTER TABLE `enquiries` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `faqs` -- ALTER TABLE `faqs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- AUTO_INCREMENT for table `job_applications` -- ALTER TABLE `job_applications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `localities` -- ALTER TABLE `localities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `pages` -- ALTER TABLE `pages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `services` -- ALTER TABLE `services` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `states` -- ALTER TABLE `states` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- Constraints for dumped tables -- -- -- Constraints for table `cities` -- ALTER TABLE `cities` ADD CONSTRAINT `cities_ibfk_1` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE; -- -- Constraints for table `localities` -- ALTER TABLE `localities` ADD CONSTRAINT `localities_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `cities` (`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 */;