-- Database: `bm_business_db`

-- Table structure for table `admin_users`
CREATE TABLE `admin_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
  
);

-- Default Admin User (Password: admin123)
-- You can generate a new hash using PHP `password_hash('yourpassword', PASSWORD_DEFAULT)`
INSERT INTO `admin_users` (`username`, `password`) VALUES
('admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi');

-- Table structure for table `services`
CREATE TABLE `services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
);

-- Dummy Data for Services (matching existing website structure roughly)
INSERT INTO `services` (`title`, `description`, `image_url`) VALUES
('Development of IOCL Retail Outlet', 'Complete setup and development of IOCL retail outlets.', 'our servies image/Our Services/Petro-Pump-Retail-Outlet.jpeg'),
('Fabrication Works', 'High quality fabrication for industrial needs.', 'our servies image/Our Services/fabrication_wor.jpeg'),
('Development Of Road', 'Infrastructure development and road mapping.', 'our servies image/Our Services/Development_road.jpeg'),
('Interior Work', 'Modern interior designing and execution.', 'our servies image/Our Services/interior_work.jpeg'),
('Aluminium Work', 'Premium aluminium fabrication and fitting.', 'our servies image/Our Services/Aluminium_work.jpeg'),
('Building Construction', 'Comprehensive building construction services ensuring stability and excellence.', 'our servies image/Our Services/Construction_of_Building.jpeg'),
('BPCL Retail Outlets', 'Specialized development and setup for BPCL retail outlets.', 'our servies image/Our Services/BPCL.jpeg'),
('HPCL Projects', 'Execution of HPCL infrastructure and retail projects.', 'our servies image/Our Services/HPCL.jpeg');

-- Table structure for table `pages`
CREATE TABLE `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_name` varchar(50) NOT NULL, -- e.g., 'home_intro', 'about_us'
  `title` varchar(255),
  `content` text NOT NULL,
  PRIMARY KEY (`id`)
);

-- APP NOTE: We will use `page_name` to fetch specific content blocks.
INSERT INTO `pages` (`page_name`, `title`, `content`) VALUES
('home_intro', 'Welcome to BALIMEEN', '“Driven by our mission to build responsibly and serve with integrity, Balimeen Private Limited provides efficient, high-quality construction services while creating meaningful employment opportunities that contribute to the growth of communities and society as a whole.”'),
('about_full', 'About Balimeen Private Limited', 'Welcome to Balimeen Private Limited, a trusted and emerging name in the construction industry. We specialize in delivering high-quality construction services with a strong commitment to innovation, efficiency, and customer satisfaction.\n\nWith a team of highly skilled and experienced professionals, we ensure that every project—whether big or small—is executed with precision, reliability, and excellence. Our goal is not just to construct buildings, but to create long-lasting value and strengthen the trust of our clients.\n\nAt Balimeen Private Limited, we also believe in contributing to society. Our main mission is to increase employment opportunities and support the growth of our community.');

-- Table structure for table `contact_messages`
CREATE TABLE `contact_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
);
