| Server IP : 3.111.61.48 / Your IP : 216.73.216.67 Web Server : Apache System : Linux ip-10-0-5-176 6.8.0-1057-aws #60~22.04.1-Ubuntu SMP Wed May 27 08:16:59 UTC 2026 x86_64 User : ubuntu ( 1000) PHP Version : 8.2.31 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/vhost/lhvpraktani.in/phire-dekha-2026/scripts/ |
Upload File : |
-- MySQL 8+ schema for LHV Reunion Registration
-- Create DB (edit name if needed)
-- CREATE DATABASE lhv_reunion CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- USE lhv_reunion;
CREATE TABLE IF NOT EXISTS alumni_phone_discount (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
phone VARCHAR(10) NOT NULL,
created_at TIMESTAMP NULL DEFAULT NULL,
updated_at TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY alumni_phone_discount_phone_unique (phone)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS registrations (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
full_name VARCHAR(150) NOT NULL,
phone VARCHAR(10) NOT NULL,
passing_year SMALLINT UNSIGNED NOT NULL,
participation_type ENUM('full_time','till_noon') NOT NULL,
food_type ENUM('non_veg','veg') NOT NULL,
guests TINYINT UNSIGNED NOT NULL DEFAULT 0,
base_fee INT UNSIGNED NOT NULL,
discount INT UNSIGNED NOT NULL DEFAULT 0,
guest_fee INT UNSIGNED NOT NULL DEFAULT 0,
grand_total INT UNSIGNED NOT NULL,
payment_screenshot_path VARCHAR(255) NOT NULL,
created_at TIMESTAMP NULL DEFAULT NULL,
updated_at TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (id),
KEY registrations_phone_index (phone)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Sample data (phones eligible for discount)
INSERT IGNORE INTO alumni_phone_discount (phone, created_at, updated_at) VALUES
('9990001111', NOW(), NOW()),
('8880002222', NOW(), NOW()),
('7770003333', NOW(), NOW());