-- Youth Network Bansgadhi (युवा सञ्जाल बाँसगढी) -- MySQL / MariaDB database with dummy data
-- Import:  mysql -u USER -p DATABASE < ynb_database.sql
-- Demo logins (CHANGE BEFORE GOING LIVE):  admin@example.com / password   |   member@example.com / password
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) NULL DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `membership_no` varchar(255) NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) NULL DEFAULT NULL,
  `user_agent` text NULL DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `job_batches`;
CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` text NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `menu_items`;
CREATE TABLE `menu_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint unsigned DEFAULT NULL,
  `label` varchar(255) NOT NULL,
  `label_ne` varchar(255) NULL DEFAULT NULL,
  `url` varchar(255) NULL DEFAULT NULL,
  `icon` varchar(255) NULL DEFAULT NULL,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_items_parent_id_index` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `sliders`;
CREATE TABLE `sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `title_ne` varchar(255) NULL DEFAULT NULL,
  `subtitle` text NULL DEFAULT NULL,
  `subtitle_ne` text NULL DEFAULT NULL,
  `image` varchar(255) NULL DEFAULT NULL,
  `button_text` varchar(255) NULL DEFAULT NULL,
  `button_text_ne` varchar(255) NULL DEFAULT NULL,
  `button_url` varchar(255) NULL DEFAULT NULL,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `ticker_items`;
CREATE TABLE `ticker_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `text` varchar(255) NOT NULL,
  `text_ne` varchar(255) NULL DEFAULT NULL,
  `url` varchar(255) NULL DEFAULT NULL,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `programs`;
CREATE TABLE `programs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `icon` varchar(255) NULL DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `title_ne` varchar(255) NULL DEFAULT NULL,
  `summary` text NULL DEFAULT NULL,
  `summary_ne` text NULL DEFAULT NULL,
  `details` text NULL DEFAULT NULL,
  `details_ne` text NULL DEFAULT NULL,
  `bullets` json DEFAULT NULL,
  `bullets_ne` json DEFAULT NULL,
  `image` varchar(255) NULL DEFAULT NULL,
  `on_home` tinyint(1) NOT NULL DEFAULT 0,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `programs_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `key_values`;
CREATE TABLE `key_values` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `letter` varchar(4) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ne` varchar(255) NULL DEFAULT NULL,
  `bullets` json DEFAULT NULL,
  `bullets_ne` json DEFAULT NULL,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `mission_points`;
CREATE TABLE `mission_points` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lead` varchar(255) NOT NULL,
  `lead_ne` varchar(255) NULL DEFAULT NULL,
  `text` text NULL DEFAULT NULL,
  `text_ne` text NULL DEFAULT NULL,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `org_blocks`;
CREATE TABLE `org_blocks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ne` varchar(255) NULL DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `body_ne` longtext DEFAULT NULL,
  `image` varchar(255) NULL DEFAULT NULL,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `org_blocks_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `leaders`;
CREATE TABLE `leaders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `name_ne` varchar(255) NULL DEFAULT NULL,
  `position` varchar(255) NOT NULL,
  `position_ne` varchar(255) NULL DEFAULT NULL,
  `bio` text NULL DEFAULT NULL,
  `photo` varchar(255) NULL DEFAULT NULL,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `reports`;
CREATE TABLE `reports` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `year` varchar(20) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ne` varchar(255) NULL DEFAULT NULL,
  `file_url` varchar(255) NULL DEFAULT NULL,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ne` varchar(255) NULL DEFAULT NULL,
  `excerpt` text NULL DEFAULT NULL,
  `excerpt_ne` text NULL DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `body_ne` longtext DEFAULT NULL,
  `image` varchar(255) NULL DEFAULT NULL,
  `author` varchar(255) NULL DEFAULT NULL,
  `published_at` datetime DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `posts_slug_unique` (`slug`),
  KEY `posts_type_index` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `gallery_items`;
CREATE TABLE `gallery_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL DEFAULT 'photo',
  `title` varchar(255) NOT NULL,
  `title_ne` varchar(255) NULL DEFAULT NULL,
  `image` varchar(255) NULL DEFAULT NULL,
  `video_url` varchar(255) NULL DEFAULT NULL,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `members`;
CREATE TABLE `members` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `membership_no` varchar(255) NULL DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `name_ne` varchar(255) NULL DEFAULT NULL,
  `member_type` varchar(30) NOT NULL DEFAULT 'General',
  `designation` varchar(255) NULL DEFAULT NULL,
  `district` varchar(255) NULL DEFAULT NULL,
  `province` varchar(255) NULL DEFAULT NULL,
  `photo` varchar(255) NULL DEFAULT NULL,
  `joined_on` date DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `useful_links`;
CREATE TABLE `useful_links` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) NOT NULL,
  `label_ne` varchar(255) NULL DEFAULT NULL,
  `url` varchar(255) NOT NULL,
  `sort` int unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ne` varchar(255) NULL DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `body_ne` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pages_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `membership_applications`;
CREATE TABLE `membership_applications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(40) NOT NULL,
  `dob` date DEFAULT NULL,
  `gender` varchar(20) NULL DEFAULT NULL,
  `address` varchar(255) NULL DEFAULT NULL,
  `district` varchar(255) NULL DEFAULT NULL,
  `occupation` varchar(255) NULL DEFAULT NULL,
  `education` varchar(255) NULL DEFAULT NULL,
  `member_type` varchar(30) NOT NULL DEFAULT 'General',
  `interests` varchar(255) NULL DEFAULT NULL,
  `message` text NULL DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `member_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `contact_messages`;
CREATE TABLE `contact_messages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(40) NULL DEFAULT NULL,
  `subject` varchar(255) NULL DEFAULT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `donations`;
CREATE TABLE `donations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NULL DEFAULT NULL,
  `phone` varchar(40) NULL DEFAULT NULL,
  `amount` decimal(12,2) NOT NULL,
  `purpose` varchar(255) NULL DEFAULT NULL,
  `method` varchar(40) NULL DEFAULT NULL,
  `message` text NULL DEFAULT NULL,
  `is_anonymous` tinyint(1) NOT NULL DEFAULT 0,
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `migrations` (`migration`, `batch`) VALUES
('0001_01_01_000000_create_users_table', 1),
('0001_01_01_000001_create_cache_table', 1),
('0001_01_01_000002_create_jobs_table', 1),
('2026_11_14_000001_create_ynb_tables', 1);

INSERT INTO `users` (`name`, `email`, `email_verified_at`, `password`, `remember_token`, `is_admin`, `membership_no`, `created_at`, `updated_at`) VALUES
('Site Admin', 'admin@example.com', NULL, '$2y$12$lLm8KMhhSgASfZGJnTUo3eHvpx5ULLxaSEh9plhcnJbEUL03fE6cW', NULL, 1, NULL, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Demo Member', 'member@example.com', NULL, '$2y$12$lLm8KMhhSgASfZGJnTUo3eHvpx5ULLxaSEh9plhcnJbEUL03fE6cW', NULL, 0, 'YNB-2024-001', '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `settings` (`key`, `value`, `created_at`, `updated_at`) VALUES
('site_name', 'Youth Network Bansgadhi', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('site_name_ne', 'युवा सञ्जाल बाँसगढी', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('short_name', 'YNB', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('tagline', 'Empowering Youth, Building Community', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('tagline_ne', 'युवा सशक्तीकरण, समुदाय निर्माण', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('meta_description', 'Youth Network Bansgadhi is a youth-led network in Bansgadhi, Bardiya working on leadership, skills, health, environment and community service. (Demo site with dummy content.)', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('logo', 'images/logo.svg', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('header_figure', 'images/figure.svg', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('header_figure_name', 'Our Inspiration', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('address', 'Bansgadhi Municipality-4, Bardiya, Lumbini Province, Nepal', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('address_ne', 'बाँसगढी नगरपालिका-४, बर्दिया, लुम्बिनी प्रदेश, नेपाल', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('phone', '+977-9800000000', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('email', 'info@example.org', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('facebook', 'https://facebook.com/', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('instagram', 'https://instagram.com/', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('x', 'https://x.com/', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('linkedin', 'https://linkedin.com/', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('youtube', 'https://youtube.com/', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('map_embed', 'https://www.openstreetmap.org/export/embed.html?bbox=81.40%2C28.28%2C81.62%2C28.44&layer=mapnik&marker=28.36%2C81.52', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('color_primary', '#C8102E', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('color_secondary', '#0F2B5B', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('color_accent', '#E85D04', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('established', '2018', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('reg_no', 'DEMO-REG-0000', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('pan_no', '000000000', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('swc_no', 'DEMO-SWC-0000', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('about_text', 'Youth Network Bansgadhi (YNB) is a youth-led network based in Bansgadhi, Bardiya. We bring young people together to build leadership, learn practical skills and serve their communities. YNB works as a bridge between the energy of young people and the opportunities they deserve, giving them a platform to take part in local development while growing personally and professionally.', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('about_text_ne', 'युवा सञ्जाल बाँसगढी (YNB) बर्दियाको बाँसगढीमा आधारित युवा नेतृत्वको सञ्जाल हो। हामी युवालाई नेतृत्व विकास गर्न, व्यावहारिक सीप सिक्न र समुदायको सेवा गर्न एकजुट गर्छौं। YNB युवाको ऊर्जा र उनीहरूले पाउनुपर्ने अवसरबीचको पुलको रूपमा काम गर्दै स्थानीय विकासमा सहभागी हुँदै व्यक्तिगत र व्यावसायिक रूपमा अघि बढ्ने मञ्च उपलब्ध गराउँछ।', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('vision_text', 'A self-reliant, inclusive and green Bansgadhi where every young person has quality education, fair opportunities and a dignified life, and contributes to the progress of Nepal.', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('vision_text_ne', 'हरेक युवाले गुणस्तरीय शिक्षा, समान अवसर र सम्मानजनक जीवन पाउने तथा नेपालको प्रगतिमा योगदान दिने आत्मनिर्भर, समावेशी र हरियो बाँसगढी निर्माण गर्ने।', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('join_quote', '“The future of Nepal is in the hands of its youth — and your hands can help shape it.”', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('join_quote_ne', '“नेपालको भविष्य युवाको हातमा छ — त्यसलाई आकार दिन तपाईंको हात पनि जोडिन सक्छ।”', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('join_p1', 'We welcome people from every background who care about leadership and community impact:', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('join_p1_ne', 'नेतृत्व र सामुदायिक प्रभावमा चासो राख्ने सबै पृष्ठभूमिका व्यक्तिलाई हामी स्वागत गर्छौं:', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('join_audience', 'Students and recent graduates\nYoung professionals and entrepreneurs\nVolunteers and social workers\nTeachers, artists and sportspeople\nNepali youth living abroad', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('join_audience_ne', 'विद्यार्थी तथा नयाँ स्नातक\nयुवा पेशाकर्मी तथा उद्यमी\nस्वयंसेवक तथा सामाजिक कार्यकर्ता\nशिक्षक, कलाकार तथा खेलाडी\nविदेशमा रहेका नेपाली युवा', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('join_p2', 'Become a member of Youth Network Bansgadhi and connect with a lively network of young leaders and change-makers working for their communities.', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('join_p2_ne', 'युवा सञ्जाल बाँसगढीको सदस्य बनेर आफ्नो समुदायका लागि काम गर्ने युवा नेता र परिवर्तनकर्ताको जीवन्त सञ्जालमा जोडिनुहोस्।', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('join_p3', 'Membership is more than a card — it is a chance to contribute, collaborate and lead projects that strengthen young people and the nation.', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('join_p3_ne', 'सदस्यता केवल परिचयपत्र होइन — यो युवा र राष्ट्रलाई सबल बनाउने परियोजनामा योगदान दिने, सहकार्य गर्ने र नेतृत्व लिने अवसर हो।', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('cta_text', 'Join hundreds of young change-makers who are already creating impact in their communities. Your journey starts here.', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('cta_text_ne', 'आफ्नो समुदायमा पहिले नै प्रभाव पारिरहेका सयौँ युवा परिवर्तनकर्तासँग जोडिनुहोस्। तपाईंको यात्रा यहींबाट सुरु हुन्छ।', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('donate_intro', 'Your support funds youth training, health camps, plantation drives and scholarships in Bansgadhi. Choose a purpose and a method below and we will confirm your pledge. (Demo page — no real payment is processed.)', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('bank_name', 'Demo Bank Ltd., Bansgadhi Branch', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('bank_account_name', 'Youth Network Bansgadhi', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('bank_account_no', '0000-0000-0000-0000', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('esewa_id', '9800000000', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('khalti_id', '9800000000', '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `menu_items` (`parent_id`, `label`, `label_ne`, `url`, `icon`, `sort`, `is_active`, `created_at`, `updated_at`) VALUES
(NULL, 'Home', 'गृहपृष्ठ', '/', 'house', 1, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(NULL, 'Organisation', 'संस्था', '/organisation', 'building', 2, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(2, 'About YNB', 'YNB को बारेमा', '/organisation#about', NULL, 1, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(2, 'Vision & Mission', 'दूरदृष्टि र ध्येय', '/organisation#vision-mission', NULL, 2, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(2, 'Our Inspiration', 'हाम्रो प्रेरणा', '/organisation#inspiration', NULL, 3, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(2, 'Leadership', 'नेतृत्व', '/organisation#leadership', NULL, 4, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(2, 'Organisation Structure', 'संगठन संरचना', '/organisation#structure', NULL, 5, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(2, 'Legal Status', 'कानुनी हैसियत', '/organisation#legal', NULL, 6, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(2, 'Annual Reports', 'वार्षिक प्रतिवेदन', '/organisation#reports', NULL, 7, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(2, 'Privacy Policy', 'गोपनीयता नीति', '/privacypolicy', NULL, 8, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(NULL, 'Programs', 'कार्यक्रम', '/programs', 'layers', 3, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(11, 'Sports Activities', 'खेलकुद गतिविधि', '/programs#sports', NULL, 1, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(11, 'Skills Development', 'सीप विकास', '/programs#skills', NULL, 2, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(11, 'Youth Empowerment', 'युवा सशक्तीकरण', '/programs#empowerment', NULL, 3, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(11, 'Blood Donation Camp', 'रक्तदान शिविर', '/programs#blood-donation', NULL, 4, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(11, 'Clean Nepal Campaign', 'स्वच्छ नेपाल अभियान', '/programs#clean-nepal', NULL, 5, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(11, 'Green Nepal Mission', 'हरियो नेपाल मिसन', '/programs#green-nepal', NULL, 6, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(11, 'Fit Nepal Movement', 'फिट नेपाल अभियान', '/programs#fit-nepal', NULL, 7, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(NULL, 'News & Media', 'समाचार र मिडिया', '/news', 'newspaper', 4, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(19, 'Photo Gallery', 'फोटो ग्यालरी', '/gallery#photos', NULL, 1, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(19, 'Video Gallery', 'भिडियो ग्यालरी', '/gallery#videos', NULL, 2, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(19, 'Press Release', 'प्रेस विज्ञप्ति', '/pressrelease', NULL, 3, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(19, 'Blogs / Articles', 'ब्लग / लेख', '/articles', NULL, 4, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(19, 'News', 'समाचार', '/news', NULL, 5, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(NULL, 'Contact', 'सम्पर्क', '/contact', 'phone', 5, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(NULL, 'Members', 'सदस्य', '/members', 'users', 6, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(26, 'Apply for Membership', 'सदस्यताका लागि आवेदन', '/becomemember', NULL, 1, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(26, 'Already a Member? Login', 'पहिले नै सदस्य? लगइन', '/membership', NULL, 2, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(26, 'Our Members', 'हाम्रा सदस्यहरू', '/ourmembers', NULL, 3, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
(NULL, 'Donate', 'सहयोग', '/donate', 'heart-handshake', 7, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `sliders` (`title`, `title_ne`, `subtitle`, `subtitle_ne`, `image`, `button_text`, `button_text_ne`, `button_url`, `sort`, `is_active`, `created_at`, `updated_at`) VALUES
('Empowering Youth, Building Bansgadhi', 'युवा सशक्तीकरण, समृद्ध बाँसगढी', 'Leadership, skills and service for the next generation of Nepal.', 'नेपालको नयाँ पुस्ताका लागि नेतृत्व, सीप र सेवा।', 'images/slide-1.svg', 'Become a Member', 'सदस्य बन्नुहोस्', '/becomemember', 1, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Skills for Every Young Person', 'हरेक युवाका लागि सीप', 'Free workshops in digital literacy, entrepreneurship and vocational training across Bardiya.', 'बर्दियाभर डिजिटल साक्षरता, उद्यमशीलता र व्यावसायिक तालिमका निःशुल्क कार्यशाला।', 'images/slide-2.svg', 'Explore Programs', 'कार्यक्रम हेर्नुहोस्', '/programs', 2, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Together for a Green and Healthy Nepal', 'हरियो र स्वस्थ नेपालका लागि सँगै', 'Plantation drives, clean-up campaigns and blood donation camps led by local volunteers.', 'स्थानीय स्वयंसेवकको नेतृत्वमा वृक्षरोपण, सरसफाइ अभियान र रक्तदान शिविर।', 'images/slide-3.svg', 'Support Our Work', 'हाम्रो काममा सहयोग', '/donate', 3, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `ticker_items` (`text`, `text_ne`, `url`, `sort`, `is_active`, `created_at`, `updated_at`) VALUES
('Welcome to Youth Network Bansgadhi (YNB)', 'युवा सञ्जाल बाँसगढी (YNB) मा स्वागत छ', NULL, 1, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Our Members', 'हाम्रा सदस्यहरू', '/ourmembers', 2, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Join us as a member', 'सदस्य बनेर जोडिनुहोस्', '/becomemember', 3, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Blood donation camp — next Saturday, Bansgadhi Community Hall', 'रक्तदान शिविर — आउँदो शनिबार, बाँसगढी सामुदायिक भवन', '/programs#blood-donation', 4, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `mission_points` (`lead`, `lead_ne`, `text`, `text_ne`, `sort`, `created_at`, `updated_at`) VALUES
('Youth Empowerment:', 'युवा सशक्तीकरण:', 'Growing leadership, innovation, entrepreneurship and volunteering among young people.', 'युवामा नेतृत्व, नवप्रवर्तन, उद्यमशीलता र स्वयंसेवाको विकास गर्ने।', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Education & Skills:', 'शिक्षा तथा सीप:', 'Opening access to quality education and job-oriented skills training.', 'गुणस्तरीय शिक्षा र रोजगारमुखी सीप तालिममा पहुँच विस्तार गर्ने।', 2, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Social Welfare:', 'सामाजिक कल्याण:', 'Supporting health, food security, shelter and sustainable livelihoods.', 'स्वास्थ्य, खाद्य सुरक्षा, आवास र दिगो जीविकोपार्जनमा सहयोग गर्ने।', 3, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Culture & Sustainability:', 'संस्कृति तथा दिगोपना:', 'Protecting local culture and heritage while promoting eco-friendly living.', 'स्थानीय संस्कृति र सम्पदाको संरक्षण गर्दै वातावरणमैत्री जीवनशैली प्रवर्द्धन गर्ने।', 4, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Collaboration & Advocacy:', 'सहकार्य तथा पैरवी:', 'Creating dialogue and partnerships on local social and environmental issues.', 'स्थानीय सामाजिक तथा वातावरणीय विषयमा संवाद र साझेदारी निर्माण गर्ने।', 5, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `key_values` (`letter`, `title`, `title_ne`, `bullets`, `bullets_ne`, `sort`, `created_at`, `updated_at`) VALUES
('Y', 'Youthful Innovation', 'युवा नवप्रवर्तन', '["Welcoming fresh ideas and new technology", "Encouraging creativity and practical problem-solving"]', '["नयाँ विचार र प्रविधिलाई स्वागत गर्ने", "सिर्जनशीलता र व्यावहारिक समस्या समाधानलाई प्रोत्साहन गर्ने"]', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('N', 'Neighbourly Responsibility', 'छिमेकी उत्तरदायित्व', '["Taking an active part in building a stronger, caring community", "Respecting democracy, justice and the rule of law"]', '["सबल र संवेदनशील समुदाय निर्माणमा सक्रिय सहभागी हुने", "लोकतन्त्र, न्याय र कानुनी शासनको सम्मान गर्ने"]', 2, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('B', 'Belonging for All', 'सबैका लागि अपनत्व', '["Standing for equal opportunity whatever a young person\'s background", "Working so everyone can reach their full potential"]', '["युवाको पृष्ठभूमि जेसुकै भए पनि समान अवसरका पक्षमा उभिने", "सबैले आफ्नो पूर्ण क्षमता पुग्न सक्ने वातावरणका लागि काम गर्ने"]', 3, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `programs` (`slug`, `icon`, `title`, `title_ne`, `summary`, `summary_ne`, `details`, `details_ne`, `bullets`, `bullets_ne`, `image`, `on_home`, `sort`, `is_active`, `created_at`, `updated_at`) VALUES
('empowerment', 'users', 'Youth Empowerment', 'युवा सशक्तीकरण', 'Building leadership, creativity and volunteer spirit so young people become confident citizens and future leaders.', 'युवामा नेतृत्व, सिर्जनशीलता र स्वयंसेवी भावना विकास गरी आत्मविश्वासी नागरिक र भावी नेता तयार गर्ने।', 'Through camps, mentoring circles and start-up clinics, YNB helps young people discover their strengths and turn ideas into action. Every year we run a youth leadership camp and a small-grant challenge for community projects.', 'शिविर, मार्गदर्शन समूह र स्टार्टअप क्लिनिक मार्फत YNB ले युवालाई आफ्नो क्षमता पहिचान गर्न र विचारलाई काममा बदल्न सहयोग गर्छ। हरेक वर्ष हामी युवा नेतृत्व शिविर र सामुदायिक परियोजनाका लागि साना अनुदान प्रतियोगिता सञ्चालन गर्छौं।', '["Entrepreneurship Programs", "Youth Leadership Camps", "Volunteer Networks"]', '["उद्यमशीलता कार्यक्रम", "युवा नेतृत्व शिविर", "स्वयंसेवक सञ्जाल"]', NULL, 1, 1, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('skills', 'book-open', 'Education & Skills', 'शिक्षा तथा सीप', 'Making quality learning and job-ready skills reachable for every young person, especially those with fewer resources.', 'विशेषगरी स्रोत कम भएका युवालाई गुणस्तरीय शिक्षा र रोजगारमुखी सीपमा पहुँच दिलाउने।', 'We offer evening digital-literacy classes, vocational workshops and a scholarship fund for students from low-income families. Partnerships with local schools and training providers keep our courses practical.', 'हामी साँझपख डिजिटल साक्षरता कक्षा, व्यावसायिक कार्यशाला र न्यून आय भएका परिवारका विद्यार्थीका लागि छात्रवृत्ति कोष सञ्चालन गर्छौं। स्थानीय विद्यालय र तालिम प्रदायकसँगको साझेदारीले हाम्रा पाठ्यक्रम व्यावहारिक रहन्छन्।', '["Scholarships & Financial Aid", "Skill Development Workshops", "Digital Literacy Programs"]', '["छात्रवृत्ति तथा आर्थिक सहयोग", "सीप विकास कार्यशाला", "डिजिटल साक्षरता कार्यक्रम"]', NULL, 1, 2, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('welfare', 'heart', 'Social Welfare', 'सामाजिक कल्याण', 'Supporting health, food security, shelter and livelihoods for families who need a helping hand.', 'सहयोग चाहिने परिवारलाई स्वास्थ्य, खाद्य सुरक्षा, आवास र जीविकोपार्जनमा साथ दिने।', 'Our volunteers organise free health check-ups, food distribution during emergencies and livelihood training for women and marginalised groups.', 'हाम्रा स्वयंसेवकले निःशुल्क स्वास्थ्य जाँच, आपत्कालमा खाद्यान्न वितरण तथा महिला र सीमान्तकृत समूहका लागि जीविकोपार्जन तालिम सञ्चालन गर्छन्।', '["Health & Blood Donation Camps", "Food Distribution Drives", "Livelihood Support Programs"]', '["स्वास्थ्य तथा रक्तदान शिविर", "खाद्यान्न वितरण अभियान", "जीविकोपार्जन सहयोग कार्यक्रम"]', NULL, 1, 3, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('culture', 'globe', 'Culture & Sustainability', 'संस्कृति तथा दिगोपना', 'Keeping Tharu and local heritage alive while encouraging crafts, local products and eco-friendly habits.', 'थारू तथा स्थानीय सम्पदालाई जीवित राख्दै हस्तकला, स्थानीय उत्पादन र वातावरणमैत्री बानीलाई प्रोत्साहन गर्ने।', 'Festivals, folk-music evenings and artisan markets give young people a way to celebrate their roots and support local makers.', 'चाडपर्व, लोकसंगीत साँझ र शिल्पी बजारले युवालाई आफ्नो जरो मनाउन र स्थानीय उत्पादकलाई सहयोग गर्न अवसर दिन्छन्।', '["Cultural Heritage Events", "Support for Rural Artisans", "Sustainable Living Campaigns"]', '["सांस्कृतिक सम्पदा कार्यक्रम", "ग्रामीण शिल्पीलाई सहयोग", "दिगो जीवनशैली अभियान"]', NULL, 1, 4, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('advocacy', 'handshake', 'Collaboration & Advocacy', 'सहकार्य तथा पैरवी', 'Bringing young voices to local government and partner organisations on social, economic and environmental issues.', 'सामाजिक, आर्थिक र वातावरणीय विषयमा स्थानीय सरकार र साझेदार संस्थासमक्ष युवाको आवाज पुर्‍याउने।', 'We hold youth–ward dialogues, track local budgets and work with other networks on joint campaigns.', 'हामी युवा–वडा संवाद गर्छौं, स्थानीय बजेटको अनुगमन गर्छौं र अन्य सञ्जालसँग मिलेर संयुक्त अभियान चलाउँछौं।', '["Policy Advocacy", "Collaborative Initiatives", "Awareness Campaigns"]', '["नीतिगत पैरवी", "सहकार्य पहल", "जनचेतना अभियान"]', NULL, 1, 5, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('blood-donation', 'droplet', 'Blood Donation Camp', 'रक्तदान शिविर', 'Regular camps and an emergency donor list that help hospitals in Bardiya save lives.', 'बर्दियाका अस्पतालमा जीवन बचाउन सहयोग गर्ने नियमित शिविर र आपतकालीन दाता सूची।', 'In partnership with the local Red Cross, we hold camps every quarter and keep a volunteer donor register by blood group.', 'स्थानीय रेडक्रससँगको साझेदारीमा हामी प्रत्येक त्रैमासमा शिविर आयोजना गर्छौं र रक्तसमूहअनुसार स्वयंसेवक दाता सूची राख्छौं।', '["Quarterly Donation Camps", "Emergency Donor Network", "Safe Donation Awareness"]', '["त्रैमासिक रक्तदान शिविर", "आपतकालीन दाता सञ्जाल", "सुरक्षित रक्तदान चेतना"]', NULL, 0, 6, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('clean-nepal', 'broom', 'Clean Nepal Campaign', 'स्वच्छ नेपाल अभियान', 'Community clean-ups and waste-sorting training for tidier streets, rivers and schools.', 'सफा सडक, खोला र विद्यालयका लागि सामुदायिक सरसफाइ तथा फोहोर वर्गीकरण तालिम।', 'Every month volunteers clean a chosen ward and train households and shops in simple waste segregation.', 'हरेक महिना स्वयंसेवकले एक वडा सरसफाइ गर्छन् र घरपरिवार तथा पसलहरूलाई सरल फोहोर वर्गीकरण तालिम दिन्छन्।', '["Community Clean-up Drives", "Waste Segregation Training", "School Hygiene Programs"]', '["सामुदायिक सरसफाइ अभियान", "फोहोर वर्गीकरण तालिम", "विद्यालय सरसफाइ कार्यक्रम"]', NULL, 0, 7, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('green-nepal', 'leaf', 'Green Nepal Mission', 'हरियो नेपाल मिसन', 'Tree planting, plastic-free drives and awareness work for a greener, cleaner Nepal.', 'हरियो र सफा नेपालका लागि वृक्षरोपण, प्लास्टिकमुक्त अभियान र चेतनामूलक काम।', 'Each monsoon we plant and care for saplings with schools and community forest groups, and we run workshops on climate and biodiversity.', 'हरेक वर्षा याममा हामी विद्यालय र सामुदायिक वन समूहसँग मिलेर बिरुवा रोप्छौं र हेरचाह गर्छौं तथा जलवायु र जैविक विविधतामा कार्यशाला चलाउँछौं।', '["Tree Plantation Drives", "Cleanliness & Plastic-Free Campaigns", "Environmental Awareness Workshops"]', '["वृक्षरोपण अभियान", "सरसफाइ तथा प्लास्टिकमुक्त अभियान", "वातावरणीय चेतना कार्यशाला"]', NULL, 1, 8, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('fit-nepal', 'activity', 'Fit Nepal Movement', 'फिट नेपाल अभियान', 'Encouraging healthy living, fitness and mental well-being through simple community activities.', 'सरल सामुदायिक गतिविधि मार्फत स्वस्थ जीवन, शारीरिक तन्दुरुस्ती र मानसिक कल्याणलाई प्रोत्साहन गर्ने।', 'Morning yoga, fitness challenges and talks on mental health help young people and families build healthy routines.', 'बिहानको योग, फिटनेस च्यालेन्ज र मानसिक स्वास्थ्यसम्बन्धी छलफलले युवा र परिवारलाई स्वस्थ दिनचर्या बनाउन मद्दत गर्छन्।', '["Yoga & Meditation Sessions", "Fitness Awareness Drives", "Healthy Lifestyle Campaigns"]', '["योग तथा ध्यान सत्र", "तन्दुरुस्ती चेतना अभियान", "स्वस्थ जीवनशैली अभियान"]', NULL, 1, 9, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('sports', 'dumbbell', 'Sports Activities', 'खेलकुद गतिविधि', 'Platforms for young people to play, build teamwork and grow future talent.', 'युवालाई खेल्न, टोलीभावना बढाउन र भावी प्रतिभा विकास गर्न मञ्च उपलब्ध गराउने।', 'Football, volleyball and athletics coaching for boys and girls, plus an annual inter-ward tournament.', 'केटाकेटी दुवैका लागि फुटबल, भलिबल र एथलेटिक्स प्रशिक्षण तथा वार्षिक अन्तर–वडा प्रतियोगिता।', '["Sports Training Camps", "Community Sports Tournaments", "Talent Development Programs"]', '["खेलकुद प्रशिक्षण शिविर", "सामुदायिक खेलकुद प्रतियोगिता", "प्रतिभा विकास कार्यक्रम"]', NULL, 1, 10, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `org_blocks` (`slug`, `title`, `title_ne`, `body`, `body_ne`, `image`, `sort`, `created_at`, `updated_at`) VALUES
('about', 'About YNB', 'YNB को बारेमा', 'Youth Network Bansgadhi was founded in 2018 by a group of college students and young professionals who wanted to turn good intentions into steady community work.\n\nToday YNB is a registered, non-political network with wards-level volunteer teams, a growing membership and partnerships with schools, local government and civil-society groups in Bardiya.\n\nOur work is guided by three simple ideas: young people are capable, communities are stronger when everyone takes part, and small, consistent action adds up.', 'युवा सञ्जाल बाँसगढी सन् २०१८ मा केही कलेजका विद्यार्थी र युवा पेशाकर्मीले असल मनसायलाई निरन्तर सामुदायिक कामको रूपमा अघि बढाउने उद्देश्यले स्थापना गरेका हुन्।\n\nआज YNB दर्ता भएको, गैरराजनीतिक सञ्जाल हो, जसका वडास्तरीय स्वयंसेवक टोली, बढ्दो सदस्यता र बर्दियाका विद्यालय, स्थानीय सरकार तथा नागरिक समाजसँग साझेदारी छन्।\n\nहाम्रो कामका तीन सरल मान्यता छन्: युवा सक्षम छन्, सबैको सहभागिताले समुदाय बलियो हुन्छ, र साना तर निरन्तर प्रयासहरू जोडिएर ठूलो परिवर्तन ल्याउँछन्।', 'images/about.svg', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('vision-mission', 'Vision & Mission', 'दूरदृष्टि र ध्येय', 'Vision: a self-reliant, inclusive and green Bansgadhi where every young person has quality education, fair opportunities and a dignified life.\n\nMission: to empower youth with leadership and skills, support families in need, protect culture and nature, and give young people a strong voice in local decisions.', 'दूरदृष्टि: हरेक युवाले गुणस्तरीय शिक्षा, समान अवसर र सम्मानजनक जीवन पाउने आत्मनिर्भर, समावेशी र हरियो बाँसगढी।\n\nध्येय: युवालाई नेतृत्व र सीपले सशक्त बनाउने, आवश्यक परिवारलाई सहयोग गर्ने, संस्कृति र प्रकृतिको संरक्षण गर्ने तथा स्थानीय निर्णयमा युवाको सशक्त आवाज स्थापित गर्ने।', 'images/vision.svg', 2, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('inspiration', 'Our Inspiration', 'हाम्रो प्रेरणा', 'We draw inspiration from the countless Nepali volunteers, teachers and community leaders who built schools, trails and forest groups with their own hands. Their example reminds us that lasting change begins locally and depends on trust, patience and service.\n\nThis section is placeholder text — replace it with the personalities and ideals that inspire your organisation.', 'विद्यालय, बाटो र सामुदायिक वन समूह आफ्नै हातले बनाउने असङ्ख्य नेपाली स्वयंसेवक, शिक्षक र समुदायका नेताबाट हामी प्रेरणा लिन्छौं। उनीहरूको उदाहरणले दिगो परिवर्तन स्थानीय तहबाट सुरु हुन्छ र विश्वास, धैर्य तथा सेवामा आधारित हुन्छ भन्ने सम्झाउँछ।\n\nयो खण्ड नमूना पाठ हो — आफ्नो संस्थालाई प्रेरणा दिने व्यक्तित्व र आदर्शले प्रतिस्थापन गर्नुहोस्।', NULL, 3, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('structure', 'Organisation Structure', 'संगठन संरचना', 'General Assembly — all members; meets once a year and elects the Executive Committee.\nExecutive Committee — 11 members; sets policy, approves budgets and oversees programs.\nProgram Committees — Skills & Education, Health & Welfare, Environment, Sports & Culture.\nWard Volunteer Teams — local teams that carry out camps, drives and campaigns.\nAdvisory Board — respected community members who give guidance.', 'साधारण सभा — सबै सदस्य; वर्षमा एक पटक बस्छ र कार्यसमिति चयन गर्छ।\nकार्यसमिति — ११ सदस्य; नीति तय गर्ने, बजेट स्वीकृत गर्ने र कार्यक्रमको निरीक्षण गर्ने।\nकार्यक्रम समिति — सीप तथा शिक्षा, स्वास्थ्य तथा कल्याण, वातावरण, खेलकुद तथा संस्कृति।\nवडा स्वयंसेवक टोली — शिविर, अभियान र कार्यक्रम सञ्चालन गर्ने स्थानीय टोली।\nसल्लाहकार परिषद् — मार्गदर्शन दिने सम्मानित समुदायका सदस्य।', NULL, 4, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('legal', 'Legal Status', 'कानुनी हैसियत', 'Youth Network Bansgadhi is registered as a non-profit, non-political organisation. (Demo values below — replace with your real details.)\nRegistration No.: DEMO-REG-0000\nPAN No.: 000000000\nSocial Welfare Council affiliation: DEMO-SWC-0000\nRegistered office: Bansgadhi Municipality-4, Bardiya, Lumbini Province', 'युवा सञ्जाल बाँसगढी गैरनाफामूलक र गैरराजनीतिक संस्थाको रूपमा दर्ता भएको छ। (तलका मान नमूना हुन् — आफ्नो वास्तविक विवरणले प्रतिस्थापन गर्नुहोस्।)\nदर्ता नं.: DEMO-REG-0000\nप्यान नं.: ०००००००००\nसमाजकल्याण परिषद् आबद्धता: DEMO-SWC-0000\nदर्ता कार्यालय: बाँसगढी नगरपालिका-४, बर्दिया, लुम्बिनी प्रदेश', NULL, 5, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `leaders` (`name`, `name_ne`, `position`, `position_ne`, `bio`, `photo`, `sort`, `created_at`, `updated_at`) VALUES
('Aarav Chaudhary', 'आराव चौधरी', 'President', 'अध्यक्ष', 'Demo profile. Volunteer leader with a passion for youth development and community service in Bardiya.', 'images/board-1.svg', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Sunita Tharu', 'सुनिता थारू', 'Vice President', 'उपाध्यक्ष', 'Demo profile. Volunteer leader with a passion for youth development and community service in Bardiya.', 'images/board-2.svg', 2, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Bikash Gautam', 'विकास गौतम', 'General Secretary', 'महासचिव', 'Demo profile. Volunteer leader with a passion for youth development and community service in Bardiya.', 'images/board-3.svg', 3, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Anjali Pandey', 'अञ्जली पाण्डे', 'Treasurer', 'कोषाध्यक्ष', 'Demo profile. Volunteer leader with a passion for youth development and community service in Bardiya.', 'images/board-4.svg', 4, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Rohan Karki', 'रोहन कार्की', 'Program Coordinator', 'कार्यक्रम संयोजक', 'Demo profile. Volunteer leader with a passion for youth development and community service in Bardiya.', 'images/board-5.svg', 5, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Mina Budha', 'मीना बुढा', 'Advisor', 'सल्लाहकार', 'Demo profile. Volunteer leader with a passion for youth development and community service in Bardiya.', 'images/board-6.svg', 6, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Ramesh Khatri', 'रमेश खत्री', 'Joint Secretary', 'संयुक्त सचिव', 'Demo profile. Helps coordinate board activities and community outreach across Bansgadhi.', 'images/board-1.svg', 7, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Sushila Bista', 'सुशीला बिष्ट', 'Assistant Treasurer', 'सह-कोषाध्यक्ष', 'Demo profile. Supports transparent planning and local youth programs.', 'images/board-2.svg', 8, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Nabin Thapa', 'नविन थापा', 'Executive Member', 'कार्यसमिति सदस्य', 'Demo profile. Works with volunteers to deliver inclusive community activities.', 'images/board-3.svg', 9, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Gita Oli', 'गीता ओली', 'Executive Member', 'कार्यसमिति सदस्य', 'Demo profile. Advocates for youth participation and community wellbeing.', 'images/board-4.svg', 10, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Rajendra Chaudhary', 'राजेन्द्र चौधरी', 'Executive Member', 'कार्यसमिति सदस्य', 'Demo profile. Contributes to local partnerships and youth-led initiatives.', 'images/board-5.svg', 11, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `reports` (`year`, `title`, `title_ne`, `file_url`, `sort`, `created_at`, `updated_at`) VALUES
('2025/26', 'Annual Report 2025/26', 'वार्षिक प्रतिवेदन २०८२/८३', '#', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('2024/25', 'Annual Report 2024/25', 'वार्षिक प्रतिवेदन २०८१/८२', '#', 2, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('2023/24', 'Annual Report 2023/24', 'वार्षिक प्रतिवेदन २०८०/८१', '#', 3, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('2022/23', 'Annual Report 2022/23', 'वार्षिक प्रतिवेदन २०७९/८०', '#', 4, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `posts` (`type`, `slug`, `title`, `title_ne`, `excerpt`, `excerpt_ne`, `body`, `body_ne`, `image`, `author`, `published_at`, `is_published`, `created_at`, `updated_at`) VALUES
('news', 'blood-donation-camp-bansgadhi', 'Blood Donation Camp Collects 86 Units in Bansgadhi', 'बाँसगढीमा रक्तदान शिविरबाट ८६ यूनिट रक्त सङ्कलन', 'Volunteers and residents gathered at the community hall for the quarterly blood donation camp.', 'सामुदायिक भवनमा त्रैमासिक रक्तदान शिविरमा स्वयंसेवक र स्थानीयवासी जम्मा भए।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-1.svg', 'YNB Media Team', '2026-10-18 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('news', 'tree-plantation-drive-2026', '1,200 Saplings Planted in the Monsoon Plantation Drive', 'वर्षायाम वृक्षरोपण अभियानमा १,२०० बिरुवा रोपियो', 'Students, forest user groups and YNB volunteers planted saplings along the riverbank.', 'विद्यार्थी, वन उपभोक्ता समूह र YNB स्वयंसेवकले नदी किनारमा बिरुवा रोपे।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-2.svg', 'YNB Media Team', '2026-09-12 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('news', 'digital-literacy-batch-3', 'Third Batch of Digital Literacy Classes Begins', 'डिजिटल साक्षरता कक्षाको तेस्रो समूह सुरु', 'Forty young people joined free evening computer classes at the municipal learning centre.', 'नगरपालिका सिकाइ केन्द्रमा चालीस युवा निःशुल्क साँझ कम्प्युटर कक्षामा सहभागी भए।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-3.svg', 'YNB Media Team', '2026-08-30 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('news', 'inter-ward-football-cup', 'Inter-Ward Football Cup Draws Large Crowd', 'अन्तर–वडा फुटबल कप हेर्न ठूलो भीड', 'Eight wards competed in the annual youth football tournament over two weekends.', 'दुई सातामा आठ वडाले वार्षिक युवा फुटबल प्रतियोगितामा प्रतिस्पर्धा गरे।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-4.svg', 'YNB Media Team', '2026-07-21 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('news', 'clean-nepal-river-cleanup', 'River-Bank Clean-Up Removes Over Two Tonnes of Waste', 'खोला किनारको सरसफाइबाट दुई टन भन्दा बढी फोहोर हटाइयो', 'A monthly Clean Nepal drive focused on the riverbank near the main market.', 'मासिक स्वच्छ नेपाल अभियान मुख्य बजार नजिकको खोला किनारमा केन्द्रित रह्यो।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-5.svg', 'YNB Media Team', '2026-06-14 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('news', 'youth-leadership-camp-2026', 'Youth Leadership Camp Brings 60 Participants Together', 'युवा नेतृत्व शिविरमा ६० सहभागी जम्मा', 'A three-day residential camp on leadership, teamwork and community planning.', 'नेतृत्व, टोली कार्य र सामुदायिक योजनाबारे तीन दिने आवासीय शिविर।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-6.svg', 'YNB Media Team', '2026-05-09 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('press', 'press-ynb-annual-assembly', 'Press Release: YNB Holds 8th Annual General Assembly', 'प्रेस विज्ञप्ति: YNB को आठौँ वार्षिक साधारण सभा सम्पन्न', 'The assembly approved the annual report and elected a new executive committee.', 'सभाले वार्षिक प्रतिवेदन पारित गर्‍यो र नयाँ कार्यसमिति चयन गर्‍यो।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-1.svg', 'YNB Media Team', '2026-04-20 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('press', 'press-scholarship-fund', 'Press Release: Scholarship Fund Launched for 25 Students', 'प्रेस विज्ञप्ति: २५ विद्यार्थीका लागि छात्रवृत्ति कोष सुरु', 'YNB announces a new scholarship fund for students from low-income families.', 'YNB ले न्यून आय भएका परिवारका विद्यार्थीका लागि नयाँ छात्रवृत्ति कोषको घोषणा गर्‍यो।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-3.svg', 'YNB Media Team', '2026-03-08 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('press', 'press-green-nepal-partnership', 'Press Release: Partnership Signed for Green Nepal Mission', 'प्रेस विज्ञप्ति: हरियो नेपाल मिसनका लागि साझेदारी सम्झौता', 'A three-year agreement with community forest groups will expand plantation work.', 'सामुदायिक वन समूहसँगको तीन वर्षे सम्झौताले वृक्षरोपण कामलाई विस्तार गर्नेछ।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-2.svg', 'YNB Media Team', '2026-02-02 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('press', 'press-youth-day', 'Press Release: International Youth Day Celebration Announced', 'प्रेस विज्ञप्ति: अन्तर्राष्ट्रिय युवा दिवस कार्यक्रमको घोषणा', 'A week of workshops, sports and cultural events will mark International Youth Day.', 'कार्यशाला, खेलकुद र सांस्कृतिक कार्यक्रमसहित एक सातासम्म अन्तर्राष्ट्रिय युवा दिवस मनाइनेछ।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-6.svg', 'YNB Media Team', '2026-01-15 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('article', 'why-local-youth-networks-matter', 'Why Local Youth Networks Matter', 'स्थानीय युवा सञ्जाल किन महत्त्वपूर्ण छन्', 'How ward-level networks turn individual energy into lasting community change.', 'वडास्तरका सञ्जालले व्यक्तिगत ऊर्जालाई दिगो सामुदायिक परिवर्तनमा कसरी बदल्छन्।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-4.svg', 'Aarav Chaudhary', '2026-10-02 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('article', 'volunteering-first-steps', 'Volunteering: Your First Five Steps', 'स्वयंसेवा: तपाईंका पहिलो पाँच कदम', 'A friendly guide for anyone who has wondered how to start volunteering.', 'स्वयंसेवा कसरी सुरु गर्ने भन्ने सोचिरहेकाका लागि मैत्रीपूर्ण मार्गदर्शन।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-5.svg', 'Sunita Tharu', '2026-08-05 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('article', 'small-habits-green-living', 'Small Habits for Greener Living in Bansgadhi', 'बाँसगढीमा हरित जीवनका साना बानी', 'Simple, low-cost changes that households can make to reduce waste.', 'घरपरिवारले फोहोर घटाउन अपनाउन सक्ने सरल र कम खर्चिला परिवर्तन।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-2.svg', 'Rohan Karki', '2026-06-28 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('article', 'from-student-to-leader', 'From Student to Community Leader', 'विद्यार्थीबाट समुदायको नेतृत्वसम्म', 'A member shares how YNB helped build confidence and practical skills.', 'एक सदस्यले YNB ले आत्मविश्वास र व्यावहारिक सीप कसरी निर्माण गर्‍यो भनी बताए।', 'Volunteers, local leaders and families came together for the event, which was organised by Youth Network Bansgadhi with support from ward offices and partner organisations. Participants shared their experiences and agreed on next steps for the coming months.\n\n“Small steps taken together are how a community changes,” said one organiser. This is dummy article text you can replace from the admin panel.', 'स्वयंसेवक, स्थानीय नेता र परिवारहरू युवा सञ्जाल बाँसगढीले वडा कार्यालय र साझेदार संस्थाको सहयोगमा आयोजना गरेको कार्यक्रममा एकत्रित भए। सहभागीहरूले आफ्ना अनुभव साझा गरे र आगामी महिनाका लागि अर्को कदमबारे सहमति जनाए।\n\n“साना कदम सँगै चाल्दा नै समुदाय बदलिन्छ,” एक आयोजकले भने। यो नमूना लेख हो जसलाई तपाईं एडमिन प्यानलबाट बदल्न सक्नुहुन्छ।', 'images/post-1.svg', 'Anjali Pandey', '2026-04-11 10:00:00', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `gallery_items` (`type`, `title`, `title_ne`, `image`, `video_url`, `sort`, `is_active`, `created_at`, `updated_at`) VALUES
('photo', 'Blood donation camp', 'रक्तदान शिविर', 'images/gallery-1.svg', NULL, 1, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'Tree plantation', 'वृक्षरोपण', 'images/gallery-2.svg', NULL, 2, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'Leadership camp', 'नेतृत्व शिविर', 'images/gallery-3.svg', NULL, 3, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'Football cup', 'फुटबल कप', 'images/gallery-4.svg', NULL, 4, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'River clean-up', 'खोला सरसफाइ', 'images/gallery-5.svg', NULL, 5, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'Digital class', 'डिजिटल कक्षा', 'images/gallery-6.svg', NULL, 6, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'Yoga morning', 'बिहानको योग', 'images/gallery-1.svg', NULL, 7, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'Cultural evening', 'सांस्कृतिक साँझ', 'images/gallery-2.svg', NULL, 8, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'Health check-up', 'स्वास्थ्य जाँच', 'images/gallery-3.svg', NULL, 9, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'Volunteer meeting', 'स्वयंसेवक भेला', 'images/gallery-4.svg', NULL, 10, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'School visit', 'विद्यालय भ्रमण', 'images/gallery-5.svg', NULL, 11, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('photo', 'Annual assembly', 'वार्षिक साधारण सभा', 'images/gallery-6.svg', NULL, 12, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('video', 'YNB Introduction (demo)', 'YNB परिचय (नमूना)', 'images/gallery-1.svg', 'https://www.youtube.com/', 13, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('video', 'Plantation Drive Highlights (demo)', 'वृक्षरोपण झलक (नमूना)', 'images/gallery-2.svg', 'https://www.youtube.com/', 14, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('video', 'Leadership Camp Recap (demo)', 'नेतृत्व शिविर पुनरावलोकन (नमूना)', 'images/gallery-3.svg', 'https://www.youtube.com/', 15, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('video', 'Blood Camp Story (demo)', 'रक्तदान कथा (नमूना)', 'images/gallery-4.svg', 'https://www.youtube.com/', 16, 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `members` (`membership_no`, `name`, `name_ne`, `member_type`, `designation`, `district`, `province`, `photo`, `joined_on`, `is_active`, `created_at`, `updated_at`) VALUES
('YNB-2020-100', 'Aarav Budha', NULL, 'General', 'Member', 'Bardiya', 'Lumbini', NULL, '2019-01-01', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2021-101', 'Sunita Bhandari', NULL, 'General', 'Volunteer', 'Bardiya', 'Lumbini', NULL, '2020-02-02', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2022-102', 'Bikash Oli', NULL, 'General', 'Trainer', 'Bardiya', 'Lumbini', NULL, '2021-03-03', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2023-103', 'Anjali Rana', NULL, 'General', 'Media Volunteer', 'Kailali', 'Sudurpashchim', NULL, '2022-04-04', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2024-104', 'Rohan Pandey', NULL, 'General', 'Volunteer', 'Bardiya', 'Lumbini', NULL, '2023-05-05', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2025-105', 'Mina Sharma', NULL, 'Life', 'Volunteer', 'Bardiya', 'Lumbini', NULL, '2024-06-06', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2026-106', 'Suman Pandey', NULL, 'General', 'Media Volunteer', 'Banke', 'Lumbini', NULL, '2025-07-07', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2020-107', 'Pratima Sharma', NULL, 'General', 'Media Volunteer', 'Bardiya', 'Lumbini', NULL, '2019-08-08', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2021-108', 'Kiran Chaudhary', NULL, 'General', 'Student Member', 'Bardiya', 'Lumbini', NULL, '2020-09-09', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2022-109', 'Sabina Bhandari', NULL, 'Volunteer', 'Volunteer', 'Surkhet', 'Karnali', NULL, '2021-10-10', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2023-110', 'Dipesh Rana', NULL, 'Volunteer', 'Member', 'Bardiya', 'Lumbini', NULL, '2022-11-11', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2024-111', 'Nisha Tharu', NULL, 'General', 'Volunteer', 'Bardiya', 'Lumbini', NULL, '2023-12-12', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2025-112', 'Prakash Oli', NULL, 'Patron', 'Ward Coordinator', 'Dang', 'Lumbini', NULL, '2024-01-13', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2026-113', 'Rekha Karki', NULL, 'Life', 'Ward Coordinator', 'Bardiya', 'Lumbini', NULL, '2025-02-14', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2020-114', 'Santosh Oli', NULL, 'General', 'Media Volunteer', 'Bardiya', 'Lumbini', NULL, '2019-03-15', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2021-115', 'Asmita Karki', NULL, 'Volunteer', 'Student Member', 'Bardiya', 'Lumbini', NULL, '2020-04-16', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2022-116', 'Roshan Gautam', NULL, 'General', 'Media Volunteer', 'Bardiya', 'Lumbini', NULL, '2021-05-17', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2023-117', 'Kabita Rana', NULL, 'Volunteer', 'Ward Coordinator', 'Bardiya', 'Lumbini', NULL, '2022-06-18', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2024-118', 'Manoj Budha', NULL, 'General', 'Media Volunteer', 'Kailali', 'Sudurpashchim', NULL, '2023-07-19', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2025-119', 'Sapana Thapa', NULL, 'General', 'Media Volunteer', 'Bardiya', 'Lumbini', NULL, '2024-08-20', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2026-120', 'Bibek Tharu', NULL, 'Volunteer', 'Ward Coordinator', 'Bardiya', 'Lumbini', NULL, '2025-09-21', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2020-121', 'Laxmi Acharya', NULL, 'Volunteer', 'Media Volunteer', 'Banke', 'Lumbini', NULL, '2019-10-22', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2021-122', 'Umesh Sharma', NULL, 'Patron', 'Trainer', 'Bardiya', 'Lumbini', NULL, '2020-11-23', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('YNB-2022-123', 'Pooja Acharya', NULL, 'Volunteer', 'Member', 'Bardiya', 'Lumbini', NULL, '2021-12-24', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `useful_links` (`label`, `label_ne`, `url`, `sort`, `created_at`, `updated_at`) VALUES
('Ministry of Youth and Sports', NULL, 'https://moys.gov.np/', 1, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('National Sports Council', NULL, 'https://nsc.gov.np/', 2, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Ministry of Education, Science and Technology', NULL, 'https://moest.gov.np/', 3, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('CTEVT', NULL, 'https://ctevt.gov.np/', 4, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('University Grants Commission Nepal', NULL, 'https://ugcnepal.edu.np/', 5, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Public Service Commission', NULL, 'https://psc.gov.np/', 6, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('National Planning Commission', NULL, 'https://npc.gov.np/', 7, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Social Welfare Council', NULL, 'https://swc.org.np/', 8, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Nepal Red Cross Society', NULL, 'https://nrcs.org/', 9, '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('Bansgadhi Municipality (demo link)', NULL, 'https://example.org/', 10, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `pages` (`slug`, `title`, `title_ne`, `body`, `body_ne`, `created_at`, `updated_at`) VALUES
('privacypolicy', 'Privacy Policy', 'गोपनीयता नीति', 'This is a demo privacy policy for Youth Network Bansgadhi.\n\nWhat we collect: details you submit through the membership, contact and donation forms (such as name, email, phone and message).\n\nHow we use it: to respond to you, process membership and keep records of pledges. We do not sell personal data.\n\nYour choices: you may ask us to correct or delete your information by writing to the email address in the footer.\n\nReplace this text with a policy reviewed for your organisation.', 'यो युवा सञ्जाल बाँसगढीको नमूना गोपनीयता नीति हो।\n\nहामीले के सङ्कलन गर्छौं: सदस्यता, सम्पर्क र सहयोग फारम मार्फत तपाईंले पठाउनुभएको विवरण (नाम, इमेल, फोन र सन्देश)।\n\nप्रयोग: तपाईंलाई जवाफ दिन, सदस्यता प्रक्रिया गर्न र सहयोग प्रतिबद्धताको अभिलेख राख्न। हामी व्यक्तिगत विवरण बेच्दैनौं।\n\nतपाईंका अधिकार: फुटरमा दिइएको इमेलमा लेखेर विवरण सच्याउन वा हटाउन अनुरोध गर्न सक्नुहुन्छ।\n\nयो पाठलाई आफ्नो संस्थाका लागि समीक्षा गरिएको नीतिले प्रतिस्थापन गर्नुहोस्।', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('termsconditions', 'Terms & Conditions', 'नियम तथा सर्तहरू', 'These are demo terms for the Youth Network Bansgadhi website.\n\nUse of this site: content is provided for information. Please do not misuse the forms or attempt to disrupt the service.\n\nDonations: pledges recorded on this site are not payments. Our team will contact you to confirm any contribution.\n\nChanges: we may update these terms from time to time.\n\nReplace this text with terms reviewed for your organisation.', 'यी युवा सञ्जाल बाँसगढी वेबसाइटका नमूना सर्तहरू हुन्।\n\nसाइटको प्रयोग: सामग्री जानकारीका लागि हो। कृपया फारमको दुरुपयोग वा सेवामा अवरोध नगर्नुहोस्।\n\nसहयोग: यस साइटमा दर्ता भएका प्रतिबद्धता भुक्तानी होइनन्। कुनै पनि योगदान पुष्टि गर्न हाम्रो टोलीले सम्पर्क गर्नेछ।\n\nपरिवर्तन: हामी समय समयमा यी सर्तहरू अद्यावधिक गर्न सक्छौं।\n\nयो पाठलाई आफ्नो संस्थाका लागि समीक्षा गरिएको सर्तले प्रतिस्थापन गर्नुहोस्।', '2026-11-14 12:00:00', '2026-11-14 12:00:00'),
('members-info', 'Membership', 'सदस्यता', 'General Member — open to anyone aged 16 and above who supports our aims. Annual fee: NPR 200 (demo).\nLife Member — one-time contribution of NPR 5,000 (demo) with lifetime voting rights.\nVolunteer Member — no fee; commit to at least 20 volunteer hours a year.\nPatron — individuals or institutions who support YNB with an annual contribution.', 'साधारण सदस्य — हाम्रा उद्देश्यलाई समर्थन गर्ने १६ वर्ष वा माथिका जोसुकैका लागि खुला। वार्षिक शुल्क: रु. २०० (नमूना)।\nआजीवन सदस्य — एकपटक रु. ५,००० (नमूना) योगदान गरी आजीवन मतदान अधिकार।\nस्वयंसेवक सदस्य — शुल्क छैन; वर्षमा कम्तीमा २० घण्टा स्वयंसेवा गर्ने प्रतिबद्धता।\nसंरक्षक — वार्षिक योगदानमार्फत YNB लाई सहयोग गर्ने व्यक्ति वा संस्था।', '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `membership_applications` (`full_name`, `email`, `phone`, `dob`, `gender`, `address`, `district`, `occupation`, `education`, `member_type`, `interests`, `message`, `status`, `member_id`, `created_at`, `updated_at`) VALUES
('Demo Applicant', 'applicant@example.org', '+977-9811111111', NULL, 'Female', 'Bansgadhi-5', 'Bardiya', 'Student', 'Bachelor', 'Volunteer', 'Environment, Sports', 'I would like to volunteer on weekends.', 'pending', NULL, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `contact_messages` (`name`, `email`, `phone`, `subject`, `message`, `is_read`, `created_at`, `updated_at`) VALUES
('Demo Visitor', 'visitor@example.org', '+977-9822222222', 'Partnership enquiry', 'Hello! Our school would like to host a plantation day with YNB.', 0, '2026-11-14 12:00:00', '2026-11-14 12:00:00');

INSERT INTO `donations` (`name`, `email`, `phone`, `amount`, `purpose`, `method`, `message`, `is_anonymous`, `status`, `created_at`, `updated_at`) VALUES
('Demo Supporter', 'supporter@example.org', '+977-9833333333', 2500, 'Scholarships & Education', 'Bank transfer', 'Happy to support the scholarship fund.', 0, 'pending', '2026-11-14 12:00:00', '2026-11-14 12:00:00');

SET FOREIGN_KEY_CHECKS=1;
