-- ========================================================
-- Association for Intelligent Computing and Data Science (AICDS)
-- Complete MySQL / phpMyAdmin Compatible Database Dump
-- Generated at: 2026-10-29 14:23:49
-- ========================================================
SET FOREIGN_KEY_CHECKS = 0;
SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';
SET time_zone = '+00:00';
-- --------------------------------------------------------
-- Table structure for `users`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
`id` bigint(20) 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,
`role` varchar(50) NOT NULL DEFAULT 'user',
`phone` varchar(50) DEFAULT NULL,
`organization` varchar(255) DEFAULT NULL,
`designation` varchar(255) DEFAULT NULL,
`status` varchar(50) NOT NULL DEFAULT 'active',
`avatar` varchar(255) DEFAULT NULL,
`remember_token` varchar(100) 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;
-- Dumping data for table `users`
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `role`, `phone`, `organization`, `designation`, `status`, `avatar`) VALUES (1, 'AICDS Administrator', 'admin@aicds.org', NULL, '$2y$12$15lz1Zf7Q97U1f0ZGep.hOvs4w5W8MQl6GXwDEZKhnI1TpZWEIoLy', NULL, '2026-10-29 07:44:20', '2026-10-29 07:44:20', 'admin', '+91 98765 43210', 'Association for Intelligent Computing and Data Science', 'Director of Operations', 'active', NULL);
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `role`, `phone`, `organization`, `designation`, `status`, `avatar`) VALUES (2, 'Dr. Ramesh Kumar', 'member@aicds.org', NULL, '$2y$12$QKY17IHrnzYE/VhlzYMzT.hQOGG44aPRk1baHhPDMZuG0ye507MLW', NULL, '2026-10-29 07:44:20', '2026-10-29 07:44:20', 'member', '+91 98765 12345', 'Apex Institute of Technology', 'Associate Professor, AI & DS', 'active', NULL);
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `role`, `phone`, `organization`, `designation`, `status`, `avatar`) VALUES (3, 'Priya Sharma', 'student@aicds.org', NULL, '$2y$12$Lwx7vCAMx0jLZPCYudZb9u/E6JHnxGvGhnKSZT2mGE.ygwS52DmtK', NULL, '2026-10-29 07:44:20', '2026-10-29 07:44:20', 'member', '+91 98123 45678', 'Madras Institute of Science', 'B.Tech AI & Data Science (Final Year)', 'active', NULL);
-- --------------------------------------------------------
-- Table structure for `membership_plans`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `membership_plans`;
CREATE TABLE IF NOT EXISTS `membership_plans` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`category` varchar(50) NOT NULL,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`duration_years` int(11) DEFAULT NULL,
`fee` decimal(10,2) NOT NULL,
`gst_rate` decimal(5,2) NOT NULL DEFAULT '18.00',
`total_fee` decimal(10,2) NOT NULL,
`description` text DEFAULT NULL,
`benefits` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`eligibility_criteria` text DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT '1',
`sort_order` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `membership_plans_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `membership_plans`
INSERT INTO `membership_plans` (`id`, `category`, `name`, `slug`, `duration_years`, `fee`, `gst_rate`, `total_fee`, `description`, `benefits`, `eligibility_criteria`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (1, 'student', 'Student Membership', 'student-membership', 4, 500, 18, 590, 'Valid from admission until completion of undergraduate or postgraduate programme.', '[\"Access to student chapter activities and hackathons\",\"Discounts on certified technical workshops and webinars\",\"Eligibility for AICDS Student Project Grants\",\"Access to peer mentorship and AI study resources\",\"Official digital membership ID card and certificate\"]', 'Bonafide full-time undergraduate or postgraduate students in Computing, AI, Data Science or related disciplines.', 1, 1, '2026-10-29 07:44:21', '2026-10-29 07:44:21');
INSERT INTO `membership_plans` (`id`, `category`, `name`, `slug`, `duration_years`, `fee`, `gst_rate`, `total_fee`, `description`, `benefits`, `eligibility_criteria`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (2, 'professional', 'Professional (1 Year)', 'professional-1-year', 1, 750, 18, 885, 'Annual professional membership for faculty, researchers, and software engineers.', '[\"Invitations to speak and chair conference sessions\",\"Complimentary access to select FDPs and technical webinars\",\"Voting rights in chapter committee elections\",\"Professional networking directory and forum access\"]', 'Faculty members, industry researchers, data engineers, software architects and tech professionals.', 1, 2, '2026-10-29 07:44:21', '2026-10-29 07:44:21');
INSERT INTO `membership_plans` (`id`, `category`, `name`, `slug`, `duration_years`, `fee`, `gst_rate`, `total_fee`, `description`, `benefits`, `eligibility_criteria`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (3, 'professional', 'Professional (5 Years)', 'professional-5-years', 5, 3000, 18, 3540, 'Five-year professional membership plan with locked-in discount rates.', '[\"All 1-Year Professional benefits included\",\"Special consideration for National Advisory committees\",\"Free participation in 2 major annual AICDS summits\",\"Priority co-authorship and research review invitations\"]', 'Experienced academics and professionals with 2+ years of industry or teaching background.', 1, 3, '2026-10-29 07:44:21', '2026-10-29 07:44:21');
INSERT INTO `membership_plans` (`id`, `category`, `name`, `slug`, `duration_years`, `fee`, `gst_rate`, `total_fee`, `description`, `benefits`, `eligibility_criteria`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (4, 'professional', 'Professional (Lifetime)', 'professional-lifetime', NULL, 10000, 18, 11800, 'Prestigious lifetime membership granting continuous institutional recognition.', '[\"Permanent Senior Member status in AICDS\",\"Access to executive networking panels\",\"Free access to all AICDS proceedings and online repositories\",\"Lifetime digital badge and plaque of honor\"]', 'Professors, Head of Departments, Industry Directors, and Senior AI Architects.', 1, 4, '2026-10-29 07:44:21', '2026-10-29 07:44:21');
INSERT INTO `membership_plans` (`id`, `category`, `name`, `slug`, `duration_years`, `fee`, `gst_rate`, `total_fee`, `description`, `benefits`, `eligibility_criteria`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (5, 'institutional', 'Institutional (1 Year)', 'institutional-1-year', 1, 4000, 18, 4720, 'One-year institutional affiliation for colleges and polytechnics.', '[\"Right to establish an official AICDS Student Chapter\",\"Co-branding privileges for department technical symposiums\",\"Faculty development programme hosting support\",\"Institutional profile featured on the AICDS directory\"]', 'Accredited universities, autonomous colleges, and affiliated engineering colleges.', 1, 5, '2026-10-29 07:44:21', '2026-10-29 07:44:21');
INSERT INTO `membership_plans` (`id`, `category`, `name`, `slug`, `duration_years`, `fee`, `gst_rate`, `total_fee`, `description`, `benefits`, `eligibility_criteria`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (6, 'institutional', 'Institutional (5 Years)', 'institutional-5-years', 5, 19000, 18, 22420, 'Five-year institutional affiliation with extensive academic development benefits.', '[\"Host state-level hackathons with AICDS technical patronage\",\"Faculty training grants and student project evaluation panels\",\"Curriculum alignment review by leading industry experts\",\"Bulk student membership concessions\"]', 'Colleges and research institutions seeking sustainable academic accreditation enhancement.', 1, 6, '2026-10-29 07:44:21', '2026-10-29 07:44:21');
INSERT INTO `membership_plans` (`id`, `category`, `name`, `slug`, `duration_years`, `fee`, `gst_rate`, `total_fee`, `description`, `benefits`, `eligibility_criteria`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (7, 'corporate', 'Corporate Partner Plan', 'corporate-partner', 1, 50000, 18, 59000, 'Direct access to verified AI/DS talent pipeline, joint innovation labs, and corporate hackathon sponsorships.', '[\"Campus placement talent drives across AICDS student chapters\",\"Brand exposure at national conferences and summits\",\"Joint industry-academia whitepaper publications\",\"Advisory board representation\"]', 'Technology companies, AI startups, corporate R&D divisions and enterprise data practices.', 1, 7, '2026-10-29 07:44:21', '2026-10-29 07:44:21');
-- --------------------------------------------------------
-- Table structure for `membership_applications`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `membership_applications`;
CREATE TABLE IF NOT EXISTS `membership_applications` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`application_number` varchar(100) NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`membership_plan_id` bigint(20) unsigned NOT NULL,
`category` varchar(50) NOT NULL,
`full_name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(50) NOT NULL,
`institution_or_company` varchar(255) NOT NULL,
`department_or_branch` varchar(255) DEFAULT NULL,
`designation_or_degree` varchar(255) DEFAULT NULL,
`id_proof_number` varchar(100) DEFAULT NULL,
`id_proof_file` varchar(255) DEFAULT NULL,
`address` text DEFAULT NULL,
`city` varchar(100) DEFAULT NULL,
`state` varchar(100) DEFAULT NULL,
`pincode` varchar(20) DEFAULT NULL,
`status` varchar(50) NOT NULL DEFAULT 'submitted',
`rejection_reason` text DEFAULT NULL,
`admin_notes` text DEFAULT NULL,
`reviewed_by` bigint(20) unsigned DEFAULT NULL,
`reviewed_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `membership_applications_number_unique` (`application_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `membership_applications`
INSERT INTO `membership_applications` (`id`, `application_number`, `user_id`, `membership_plan_id`, `category`, `full_name`, `email`, `phone`, `institution_or_company`, `department_or_branch`, `designation_or_degree`, `id_proof_number`, `id_proof_file`, `address`, `city`, `state`, `pincode`, `status`, `rejection_reason`, `admin_notes`, `reviewed_by`, `reviewed_at`, `created_at`, `updated_at`) VALUES (1, 'AICDS-APP-2026-0001', 2, 2, 'professional', 'Dr. Ramesh Kumar', 'member@aicds.org', '+91 98765 12345', 'Apex Institute of Technology', 'Artificial Intelligence & Data Science', 'Associate Professor', 'FAC-2024-998', NULL, '32 Silicon Enclave, Tech Park Road', 'Bengaluru', 'Karnataka', '560100', 'active', NULL, NULL, 1, '2026-08-29 07:44:21', '2026-10-29 07:44:21', '2026-10-29 07:44:21');
INSERT INTO `membership_applications` (`id`, `application_number`, `user_id`, `membership_plan_id`, `category`, `full_name`, `email`, `phone`, `institution_or_company`, `department_or_branch`, `designation_or_degree`, `id_proof_number`, `id_proof_file`, `address`, `city`, `state`, `pincode`, `status`, `rejection_reason`, `admin_notes`, `reviewed_by`, `reviewed_at`, `created_at`, `updated_at`) VALUES (2, 'AICDS-APP-2026-0002', 3, 1, 'student', 'Priya Sharma', 'student@aicds.org', '+91 98123 45678', 'Madras Institute of Science', 'Computer Science & Engineering', 'B.Tech AI & Data Science', 'STU-MIS-2023-45', NULL, 'Hostel 4, MIS Campus', 'Chennai', 'Tamil Nadu', '600025', 'active', NULL, NULL, 1, '2026-09-29 07:44:22', '2026-10-29 07:44:22', '2026-10-29 07:44:22');
-- --------------------------------------------------------
-- Table structure for `memberships`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `memberships`;
CREATE TABLE IF NOT EXISTS `memberships` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`membership_number` varchar(100) NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`membership_application_id` bigint(20) unsigned DEFAULT NULL,
`membership_plan_id` bigint(20) unsigned NOT NULL,
`category` varchar(50) NOT NULL,
`status` varchar(50) NOT NULL DEFAULT 'active',
`start_date` date NOT NULL,
`expiry_date` date DEFAULT NULL,
`verified_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `memberships_number_unique` (`membership_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `memberships`
INSERT INTO `memberships` (`id`, `membership_number`, `user_id`, `membership_application_id`, `membership_plan_id`, `category`, `status`, `start_date`, `expiry_date`, `verified_at`, `created_at`, `updated_at`) VALUES (1, 'AICDS-PRO-2026-0001', 2, 1, 2, 'professional', 'active', '2026-08-29 00:00:00', '2027-08-29 00:00:00', '2026-08-29 07:44:21', '2026-10-29 07:44:21', '2026-10-29 07:44:21');
INSERT INTO `memberships` (`id`, `membership_number`, `user_id`, `membership_application_id`, `membership_plan_id`, `category`, `status`, `start_date`, `expiry_date`, `verified_at`, `created_at`, `updated_at`) VALUES (2, 'AICDS-STU-2026-0002', 3, 2, 1, 'student', 'active', '2026-09-29 00:00:00', '2028-10-29 00:00:00', '2026-09-29 07:44:22', '2026-10-29 07:44:22', '2026-10-29 07:44:22');
-- --------------------------------------------------------
-- Table structure for `student_chapters`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `student_chapters`;
CREATE TABLE IF NOT EXISTS `student_chapters` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`chapter_code` varchar(50) NOT NULL,
`institution_name` varchar(255) NOT NULL,
`institution_type` varchar(100) NOT NULL,
`website` varchar(255) DEFAULT NULL,
`address` text NOT NULL,
`city` varchar(100) NOT NULL,
`state` varchar(100) NOT NULL,
`pincode` varchar(20) DEFAULT NULL,
`faculty_coordinator_name` varchar(255) NOT NULL,
`faculty_coordinator_email` varchar(255) NOT NULL,
`faculty_coordinator_phone` varchar(50) NOT NULL,
`student_chairperson_name` varchar(255) NOT NULL,
`proposed_student_count` int(11) NOT NULL,
`min_required_members` int(11) NOT NULL,
`status` varchar(50) NOT NULL DEFAULT 'submitted',
`rejection_reason` text DEFAULT NULL,
`approved_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `student_chapters_code_unique` (`chapter_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `student_chapters`
INSERT INTO `student_chapters` (`id`, `chapter_code`, `institution_name`, `institution_type`, `website`, `address`, `city`, `state`, `pincode`, `faculty_coordinator_name`, `faculty_coordinator_email`, `faculty_coordinator_phone`, `student_chairperson_name`, `proposed_student_count`, `min_required_members`, `status`, `rejection_reason`, `approved_at`, `created_at`, `updated_at`) VALUES (1, 'AICDS-CH-001', 'Apex Institute of Technology', 'Autonomous Institution', 'https://apextech.edu', 'Campus Road, Electronic City', 'Bengaluru', 'Karnataka', '560100', 'Dr. Ramesh Kumar', 'ramesh.kumar@apextech.edu', '+91 98765 12345', 'Kiran Varma', 112, 100, 'approved', NULL, '2026-07-29 08:06:19', '2026-10-29 07:44:22', '2026-10-29 08:06:19');
INSERT INTO `student_chapters` (`id`, `chapter_code`, `institution_name`, `institution_type`, `website`, `address`, `city`, `state`, `pincode`, `faculty_coordinator_name`, `faculty_coordinator_email`, `faculty_coordinator_phone`, `student_chairperson_name`, `proposed_student_count`, `min_required_members`, `status`, `rejection_reason`, `approved_at`, `created_at`, `updated_at`) VALUES (2, 'AICDS-CH-002', 'Madras Institute of Science & Engineering', 'Affiliated Engineering College', 'https://misengineering.org', 'Anna Salai Extension', 'Chennai', 'Tamil Nadu', '600025', 'Prof. S. Soundarrajan', 'coordinator@misengineering.org', '+91 94440 98765', 'Priya Sharma', 75, 50, 'approved', NULL, '2026-08-29 08:06:19', '2026-10-29 07:44:22', '2026-10-29 08:06:19');
INSERT INTO `student_chapters` (`id`, `chapter_code`, `institution_name`, `institution_type`, `website`, `address`, `city`, `state`, `pincode`, `faculty_coordinator_name`, `faculty_coordinator_email`, `faculty_coordinator_phone`, `student_chairperson_name`, `proposed_student_count`, `min_required_members`, `status`, `rejection_reason`, `approved_at`, `created_at`, `updated_at`) VALUES (3, 'AICDS-CH-003', 'Govt. Central Polytechnic College', 'Polytechnic', 'https://gcpoly.edu.in', 'Industrial Area, Phase 2', 'Coimbatore', 'Tamil Nadu', '641014', 'Er. M. Natarajan', 'natarajan.m@gcpoly.edu.in', '+91 97890 12345', 'Aravind Swaminathan', 58, 50, 'approved', NULL, '2026-09-29 08:06:19', '2026-10-29 07:44:22', '2026-10-29 08:06:19');
-- --------------------------------------------------------
-- Table structure for `event_categories`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `event_categories`;
CREATE TABLE IF NOT EXISTS `event_categories` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`description` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `event_categories_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `event_categories`
INSERT INTO `event_categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES (1, 'Workshops', 'workshops', 'Hands-on practical workshops on cutting-edge AI and Data Science tools.', '2026-10-29 07:44:22', '2026-10-29 07:44:22');
INSERT INTO `event_categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES (2, 'Webinars', 'webinars', 'Online masterclasses with top global researchers and practitioners.', '2026-10-29 07:44:22', '2026-10-29 07:44:22');
INSERT INTO `event_categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES (3, 'Conferences', 'conferences', 'Peer-reviewed international research symposiums and plenary meetings.', '2026-10-29 07:44:22', '2026-10-29 07:44:22');
INSERT INTO `event_categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES (4, 'Hackathons', 'hackathons', 'Competitive multi-day coding challenges solving real-world AI problems.', '2026-10-29 07:44:22', '2026-10-29 07:44:22');
INSERT INTO `event_categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES (5, 'Faculty Development Programmes', 'fdp', 'Upskilling university faculty with state-of-the-art curricula in Deep Learning & LLMs.', '2026-10-29 07:44:22', '2026-10-29 07:44:22');
INSERT INTO `event_categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES (6, 'Student Projects', 'projects', 'Industry-mentored capstone project showcases and grant exhibitions.', '2026-10-29 07:44:23', '2026-10-29 07:44:23');
-- --------------------------------------------------------
-- Table structure for `events`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `events`;
CREATE TABLE IF NOT EXISTS `events` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`event_category_id` bigint(20) unsigned NOT NULL,
`title` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`event_type` varchar(50) NOT NULL,
`short_description` text DEFAULT NULL,
`description` longtext DEFAULT NULL,
`featured_image` varchar(255) DEFAULT NULL,
`mode` varchar(50) NOT NULL DEFAULT 'online',
`venue` varchar(255) DEFAULT NULL,
`meeting_url` varchar(255) DEFAULT NULL,
`start_date` datetime NOT NULL,
`end_date` datetime NOT NULL,
`registration_deadline` datetime DEFAULT NULL,
`capacity` int(11) NOT NULL DEFAULT '100',
`registered_count` int(11) NOT NULL DEFAULT '0',
`registration_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
`speaker_name` varchar(255) DEFAULT NULL,
`speaker_designation` varchar(255) DEFAULT NULL,
`speaker_bio` text DEFAULT NULL,
`certificate_available` tinyint(1) NOT NULL DEFAULT '1',
`status` varchar(50) NOT NULL DEFAULT 'upcoming',
`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 `events_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `events`
INSERT INTO `events` (`id`, `event_category_id`, `title`, `slug`, `event_type`, `short_description`, `description`, `featured_image`, `mode`, `venue`, `meeting_url`, `start_date`, `end_date`, `registration_deadline`, `capacity`, `registered_count`, `registration_fee`, `speaker_name`, `speaker_designation`, `speaker_bio`, `certificate_available`, `status`, `is_published`, `created_at`, `updated_at`) VALUES (1, 1, 'Hands-on Generative AI & LLM Fine-Tuning Bootcamp', 'generative-ai-llm-bootcamp', 'workshops', 'Learn LoRA fine-tuning, retrieval-augmented generation (RAG), and open-weight model deployment.', 'This intensive 2-day technical workshop immerses participants in advanced Transformer architectures, prompt orchestration using LangChain and LlamaIndex, parameter-efficient fine-tuning (PEFT), and enterprise deployment pipelines with ONNX and vLLM.', 'img/program/ai_1.jpg', 'hybrid', 'AICDS Research Lab & Zoom Online', 'https://zoom.us/j/aicds-workshop-genai', '2026-11-10 10:00:00', '2026-11-11 17:00:00', '2026-11-08 23:59:00', 150, 42, 0, 'Dr. Vikram Sethi', 'Principal AI Researcher, DeepMind Alum', 'Dr. Vikram has over 14 years of research experience in neural NLP, attention mechanisms, and multi-modal generative agents.', 1, 'upcoming', 1, '2026-10-29 07:44:23', '2026-10-29 07:44:23');
INSERT INTO `events` (`id`, `event_category_id`, `title`, `slug`, `event_type`, `short_description`, `description`, `featured_image`, `mode`, `venue`, `meeting_url`, `start_date`, `end_date`, `registration_deadline`, `capacity`, `registered_count`, `registration_fee`, `speaker_name`, `speaker_designation`, `speaker_bio`, `certificate_available`, `status`, `is_published`, `created_at`, `updated_at`) VALUES (2, 3, 'Annual International Conference on Intelligent Computing & Data Science (ICICDS 2026)', 'icicds-2026-conference', 'conferences', 'The flagship annual gathering of AI researchers, industry fellows, and doctoral scholars.', 'Featuring keynote addresses from world-renowned scientists, 6 parallel tracks of peer-reviewed paper presentations, industrial AI exhibitions, and best paper awards across Machine Learning, Computer Vision, Big Data Engineering, and Responsible AI.', 'img/program/ai_2.jpg', 'offline', 'Grand Convention Centre, Science City, Bengaluru', NULL, '2026-12-13 09:00:00', '2026-12-15 18:00:00', '2026-12-03 23:59:00', 500, 180, 1500, 'Prof. Ananya Roy & Global Panel', 'Conference General Chair & Keynote Speakers', 'Distinguished scholars representing leading university faculties and corporate research organizations worldwide.', 1, 'upcoming', 1, '2026-10-29 07:44:23', '2026-10-29 07:44:23');
INSERT INTO `events` (`id`, `event_category_id`, `title`, `slug`, `event_type`, `short_description`, `description`, `featured_image`, `mode`, `venue`, `meeting_url`, `start_date`, `end_date`, `registration_deadline`, `capacity`, `registered_count`, `registration_fee`, `speaker_name`, `speaker_designation`, `speaker_bio`, `certificate_available`, `status`, `is_published`, `created_at`, `updated_at`) VALUES (3, 4, 'AICDS National Smart Healthcare AI Hackathon', 'smart-healthcare-ai-hackathon', 'hackathons', '36-hour non-stop hackathon building clinical AI diagnostic aids and federated patient data models.', 'Teams of up to 4 students will tackle curated challenges in medical imaging analysis, early sepsis detection, privacy-preserving federated clinical trials, and multi-lingual medical triage assistants. Cash prizes pool worth ₹2,50,000.', 'img/program/ai_3.jpg', 'online', 'Virtual Devpost & Discord Server', 'https://hackathon.aicds.org', '2026-11-18 18:00:00', '2026-11-20 18:00:00', '2026-11-16 12:00:00', 200, 96, 0, 'AICDS Technical Hackathon Committee', 'Jury & Mentors', 'Senior practitioners from Apollo Health, Philips Healthcare, and Google Cloud Health AI.', 1, 'upcoming', 1, '2026-10-29 07:44:23', '2026-10-29 07:44:23');
INSERT INTO `events` (`id`, `event_category_id`, `title`, `slug`, `event_type`, `short_description`, `description`, `featured_image`, `mode`, `venue`, `meeting_url`, `start_date`, `end_date`, `registration_deadline`, `capacity`, `registered_count`, `registration_fee`, `speaker_name`, `speaker_designation`, `speaker_bio`, `certificate_available`, `status`, `is_published`, `created_at`, `updated_at`) VALUES (4, 5, 'National FDP on Deep Learning Architectures & Curriculum Delivery', 'national-fdp-deep-learning', 'fdp', '5-day faculty development programme tailored for engineering and university professors.', 'Accredited training for collegiate professors to align undergraduate and postgraduate syllabi with modern PyTorch, Distributed Training, MLOps tooling, and ethical AI auditing methodologies.', 'img/program/ai_4.jpg', 'online', 'Zoom Interactive Classroom', 'https://zoom.us/j/aicds-fdp-dl', '2026-11-23 14:00:00', '2026-11-28 17:30:00', '2026-11-20 23:59:00', 120, 64, 500, 'Prof. S. R. Venkatraman', 'Chair of AI Pedagogy, AICDS Council', 'Pioneer in computer science engineering education with 25+ published textbooks and monographs.', 1, 'upcoming', 1, '2026-10-29 07:44:23', '2026-10-29 07:44:23');
INSERT INTO `events` (`id`, `event_category_id`, `title`, `slug`, `event_type`, `short_description`, `description`, `featured_image`, `mode`, `venue`, `meeting_url`, `start_date`, `end_date`, `registration_deadline`, `capacity`, `registered_count`, `registration_fee`, `speaker_name`, `speaker_designation`, `speaker_bio`, `certificate_available`, `status`, `is_published`, `created_at`, `updated_at`) VALUES (5, 2, 'Webinar: Quantum Machine Learning - Bridging Qubits and Neural Networks', 'webinar-quantum-machine-learning', 'webinars', 'An introduction to variational quantum circuits and parameterized quantum algorithms.', 'Explore how quantum computing principles intersect with modern statistical learning, parameterized quantum eigensolvers (VQE), and quantum kernels using PennyLane and Qiskit.', 'img/zoom/1.jpg', 'online', 'Webinar Live Stream', 'https://youtube.com/live/aicds-qml', '2026-11-05 19:00:00', '2026-11-05 20:30:00', '2026-11-04 23:59:00', 300, 110, 0, 'Dr. Eleanor Foster', 'Quantum Algorithm Scientist', 'Specializes in hybrid quantum-classical optimization algorithms and quantum error mitigation.', 1, 'upcoming', 1, '2026-10-29 07:44:23', '2026-10-29 07:44:23');
INSERT INTO `events` (`id`, `event_category_id`, `title`, `slug`, `event_type`, `short_description`, `description`, `featured_image`, `mode`, `venue`, `meeting_url`, `start_date`, `end_date`, `registration_deadline`, `capacity`, `registered_count`, `registration_fee`, `speaker_name`, `speaker_designation`, `speaker_bio`, `certificate_available`, `status`, `is_published`, `created_at`, `updated_at`) VALUES (6, 6, 'AICDS Capstone Student Project Exhibition & Funding Pitch', 'student-project-exhibition-pitch', 'projects', 'Showcasing the top 30 student chapter innovations before venture angels and research grant evaluators.', 'Final year undergraduate and master students present working prototypes spanning edge IoT AI, automated agricultural drones, speech processing for regional dialects, and sustainable urban mobility.', 'img/zoom/2.jpg', 'offline', 'Tech Innovation Hub, IIT Madras Research Park', NULL, '2026-12-18 09:30:00', '2026-12-18 17:30:00', '2026-12-08 23:59:00', 100, 30, 0, 'AICDS Venture & Industry Council', 'Adjudication Panel', 'Comprising venture partners, R&D heads, and academic deans.', 1, 'upcoming', 1, '2026-10-29 07:44:23', '2026-10-29 07:44:23');
-- --------------------------------------------------------
-- Table structure for `event_registrations`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `event_registrations`;
CREATE TABLE IF NOT EXISTS `event_registrations` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`registration_number` varchar(100) NOT NULL,
`event_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`full_name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(50) NOT NULL,
`institution_or_company` varchar(255) NOT NULL,
`status` varchar(50) NOT NULL DEFAULT 'confirmed',
`payment_status` varchar(50) NOT NULL DEFAULT 'free',
`attended_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `event_registrations_number_unique` (`registration_number`),
UNIQUE KEY `event_registrations_event_email_unique` (`event_id`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
-- Table structure for `certificates`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `certificates`;
CREATE TABLE IF NOT EXISTS `certificates` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`certificate_number` varchar(100) NOT NULL,
`recipient_name` varchar(255) NOT NULL,
`recipient_email` varchar(255) NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`event_id` bigint(20) unsigned DEFAULT NULL,
`membership_id` bigint(20) unsigned DEFAULT NULL,
`certificate_type` varchar(100) NOT NULL,
`title` varchar(255) NOT NULL,
`issue_date` date NOT NULL,
`verification_code` varchar(100) NOT NULL,
`status` varchar(50) NOT NULL DEFAULT 'valid',
`revocation_reason` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `certificates_number_unique` (`certificate_number`),
UNIQUE KEY `certificates_code_unique` (`verification_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `certificates`
INSERT INTO `certificates` (`id`, `certificate_number`, `recipient_name`, `recipient_email`, `user_id`, `event_id`, `membership_id`, `certificate_type`, `title`, `issue_date`, `verification_code`, `status`, `revocation_reason`, `created_at`, `updated_at`) VALUES (1, 'AICDS-CERT-2026-0001', 'Dr. Ramesh Kumar', 'member@aicds.org', 2, NULL, 1, 'membership', 'Certificate of Professional Membership', '2026-08-29 00:00:00', 'VERIF-AICDS-PRO-8892', 'valid', NULL, '2026-10-29 07:44:24', '2026-10-29 07:44:24');
INSERT INTO `certificates` (`id`, `certificate_number`, `recipient_name`, `recipient_email`, `user_id`, `event_id`, `membership_id`, `certificate_type`, `title`, `issue_date`, `verification_code`, `status`, `revocation_reason`, `created_at`, `updated_at`) VALUES (2, 'AICDS-CERT-2026-0002', 'Priya Sharma', 'student@aicds.org', 3, NULL, 2, 'membership', 'Certificate of Student Membership', '2026-09-29 00:00:00', 'VERIF-AICDS-STU-4501', 'valid', NULL, '2026-10-29 07:44:24', '2026-10-29 07:44:24');
-- --------------------------------------------------------
-- Table structure for `blog_categories`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `blog_categories`;
CREATE TABLE IF NOT EXISTS `blog_categories` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `blog_categories_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `blog_categories`
INSERT INTO `blog_categories` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES (1, 'Artificial Intelligence', 'artificial-intelligence', '2026-10-29 07:44:23', '2026-10-29 07:44:23');
INSERT INTO `blog_categories` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES (2, 'Data Science & Analytics', 'data-science-analytics', '2026-10-29 07:44:24', '2026-10-29 07:44:24');
INSERT INTO `blog_categories` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES (3, 'Research & Ethics', 'research-ethics', '2026-10-29 07:44:24', '2026-10-29 07:44:24');
INSERT INTO `blog_categories` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES (4, 'Student Innovations', 'student-innovations', '2026-10-29 07:44:24', '2026-10-29 07:44:24');
-- --------------------------------------------------------
-- Table structure for `blog_posts`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `blog_posts`;
CREATE TABLE IF NOT EXISTS `blog_posts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`blog_category_id` bigint(20) unsigned NOT NULL,
`author_id` bigint(20) unsigned DEFAULT NULL,
`title` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`excerpt` text DEFAULT NULL,
`content` longtext NOT NULL,
`featured_image` varchar(255) DEFAULT NULL,
`status` varchar(50) NOT NULL DEFAULT 'published',
`published_at` timestamp NULL DEFAULT NULL,
`seo_title` varchar(255) DEFAULT NULL,
`seo_description` text DEFAULT NULL,
`view_count` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `blog_posts_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `blog_posts`
INSERT INTO `blog_posts` (`id`, `blog_category_id`, `author_id`, `title`, `slug`, `excerpt`, `content`, `featured_image`, `status`, `published_at`, `seo_title`, `seo_description`, `view_count`, `created_at`, `updated_at`) VALUES (1, 1, 1, 'The Paradigm Shift to Agentic Workflows: Beyond Standard Chatbots', 'paradigm-shift-agentic-workflows', 'Exploring how autonomous multi-agent loops with tool use are revolutionizing software engineering and enterprise decision intelligence.', 'Large Language Models have fundamentally shifted from passive sequence completion tools into active reasoning engines. As autonomous agentic patterns mature—leveraging iterative self-reflection, planning graphs, and runtime tool integration—we witness systems capable of solving complex multi-step programming and research challenges without human babysitting.
Key Pillars of Modern Agent Architecture
Modern agent frameworks rely on four distinct operational pillars: persistent context memory, structured tool declarations, dynamic orchestration heuristics, and closed-loop verification. When an autonomous agent encounters an unexpected exception, its internal execution loop re-examines the trace, refines its strategy, and safely drives tasks to completion.
At AICDS, our focus research labs are building benchmark frameworks to evaluate agent robustness and determinism in mission-critical applications.
', 'img/blog/blog_1.png', 'published', '2026-10-24 08:06:19', 'The Paradigm Shift to Agentic Workflows | AICDS Knowledge Hub', 'Explore autonomous AI agents, tool invocation, and recursive reasoning loops in enterprise data engineering.', 342, '2026-10-29 07:44:24', '2026-10-29 08:06:19');
INSERT INTO `blog_posts` (`id`, `blog_category_id`, `author_id`, `title`, `slug`, `excerpt`, `content`, `featured_image`, `status`, `published_at`, `seo_title`, `seo_description`, `view_count`, `created_at`, `updated_at`) VALUES (2, 2, 1, 'High-Performance Vector Indexing at Scale: HNSW vs IVF-PQ', 'vector-indexing-hnsw-vs-ivfpq', 'A technical comparative analysis of approximate nearest neighbor algorithms powering contemporary semantic retrieval pipelines.', 'As enterprise knowledge bases scale into billions of high-dimensional embeddings, naive brute-force cosine distance calculations become computationally untenable. Production Retrieval-Augmented Generation (RAG) engines demand sub-50ms latency with high recall guarantees.
Hierarchical Navigable Small World (HNSW)
HNSW constructs multi-layer proximity graphs providing logarithmic search scaling. While memory footprint is higher than quantized representations, HNSW delivers unparalleled recall accuracy for dense scientific corpora.
Inverted File Product Quantization (IVF-PQ)
IVF-PQ strikes a balance between compressed RAM consumption and query throughput by clustering vector partitions into Voronoi cells and quantizing vector sub-spaces. Choosing between them requires profiling indexing latency versus memory constraints.
', 'img/blog/blog_2.png', 'published', '2026-10-17 08:06:19', 'Vector Indexing at Scale: HNSW vs IVF-PQ | AICDS', 'Deep dive into vector search indexes, HNSW graphs, and IVF-PQ compression for scalable retrieval pipelines.', 518, '2026-10-29 07:44:24', '2026-10-29 08:06:19');
INSERT INTO `blog_posts` (`id`, `blog_category_id`, `author_id`, `title`, `slug`, `excerpt`, `content`, `featured_image`, `status`, `published_at`, `seo_title`, `seo_description`, `view_count`, `created_at`, `updated_at`) VALUES (3, 3, 1, 'Responsible AI & Algorithmic Accountability in Indian Higher Education', 'responsible-ai-algorithmic-accountability', 'Framing policy guidelines for academic integrity, data sovereignty, and inclusive AI curricula in technological universities.', 'The rapid democratization of generative models presents unprecedented pedagogical opportunities alongside real challenges concerning intellectual attribution, demographic dataset biases, and student evaluation integrity.
AICDS is collaborating with state councils and affiliated institutions to establish open governance matrices that cultivate ethical computing literacy from the first year of undergraduate education.
', 'img/blog/blog_3.png', 'published', '2026-10-09 08:06:19', 'Responsible AI & Algorithmic Accountability | AICDS', 'Educational governance guidelines and ethics matrices for intelligent computing in academia.', 289, '2026-10-29 07:44:24', '2026-10-29 08:06:19');
INSERT INTO `blog_posts` (`id`, `blog_category_id`, `author_id`, `title`, `slug`, `excerpt`, `content`, `featured_image`, `status`, `published_at`, `seo_title`, `seo_description`, `view_count`, `created_at`, `updated_at`) VALUES (4, 4, 2, 'Apex Student Chapter Spotlights: Automated Crop Pathology Detection on Edge Microcontrollers', 'apex-chapter-crop-pathology-edge-ai', 'How student members compressed MobileNetV3 to run inference under 30mW on low-cost agricultural sensors.', 'Student innovators from the Apex Institute of Technology AICDS Chapter deployed a solar-powered field station identifying early leaf blight in tomato crops. Using post-training INT8 quantization and hardware-accelerated DSP routines, the system operates completely offline without needing cellular broadband connectivity.
', 'img/blog/blog_4.png', 'published', '2026-10-01 08:06:19', 'Edge AI for Agricultural Crop Pathology | AICDS Student Chapter', 'Student innovation spotlight on TinyML and offline computer vision for Indian agriculture.', 415, '2026-10-29 07:44:24', '2026-10-29 08:06:19');
-- --------------------------------------------------------
-- Table structure for `contact_enquiries`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `contact_enquiries`;
CREATE TABLE IF NOT EXISTS `contact_enquiries` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`full_name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(50) DEFAULT NULL,
`category` varchar(100) NOT NULL,
`subject` varchar(255) NOT NULL,
`message` text NOT NULL,
`status` varchar(50) NOT NULL DEFAULT 'new',
`admin_response` text DEFAULT NULL,
`resolved_at` timestamp NULL DEFAULT NULL,
`ip_address` varchar(50) 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;
-- --------------------------------------------------------
-- Table structure for `payments`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `payments`;
CREATE TABLE IF NOT EXISTS `payments` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`payment_reference` varchar(100) NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`membership_application_id` bigint(20) unsigned DEFAULT NULL,
`event_registration_id` bigint(20) unsigned DEFAULT NULL,
`amount` decimal(10,2) NOT NULL,
`currency` varchar(10) NOT NULL DEFAULT 'INR',
`gateway` varchar(50) NOT NULL DEFAULT 'manual_bank_transfer',
`transaction_id` varchar(255) DEFAULT NULL,
`status` varchar(50) NOT NULL DEFAULT 'pending',
`payment_proof` varchar(255) DEFAULT NULL,
`admin_verified_by` bigint(20) unsigned DEFAULT NULL,
`verified_at` timestamp NULL DEFAULT NULL,
`notes` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `payments_reference_unique` (`payment_reference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
-- Table structure for `audit_logs`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `audit_logs`;
CREATE TABLE IF NOT EXISTS `audit_logs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`action` varchar(100) NOT NULL,
`module` varchar(100) NOT NULL,
`description` text NOT NULL,
`ip_address` varchar(50) DEFAULT NULL,
`payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin 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;
-- Dumping data for table `audit_logs`
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `module`, `description`, `ip_address`, `payload`, `created_at`, `updated_at`) VALUES (1, 1, 'user_login', 'auth', 'User admin@aicds.org logged in successfully.', '127.0.0.1', NULL, '2026-10-29 14:20:14', '2026-10-29 14:20:14');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `module`, `description`, `ip_address`, `payload`, `created_at`, `updated_at`) VALUES (2, NULL, 'user_logout', 'auth', 'User admin@aicds.org logged out.', '127.0.0.1', NULL, '2026-10-29 14:22:36', '2026-10-29 14:22:36');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `module`, `description`, `ip_address`, `payload`, `created_at`, `updated_at`) VALUES (3, 2, 'user_login', 'auth', 'User member@aicds.org logged in successfully.', '127.0.0.1', NULL, '2026-10-29 14:22:57', '2026-10-29 14:22:57');
-- --------------------------------------------------------
-- Table structure for `website_settings`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `website_settings`;
CREATE TABLE IF NOT EXISTS `website_settings` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(100) NOT NULL,
`value` text DEFAULT NULL,
`group` varchar(50) NOT NULL DEFAULT 'general',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `website_settings_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `website_settings`
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (1, 'site_name', 'Association for Intelligent Computing and Data Science (AICDS)', 'general', '2026-10-29 07:44:25', '2026-10-29 07:44:25');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (2, 'site_tagline', 'Connect Intelligence & Transform Future.', 'general', '2026-10-29 07:44:25', '2026-10-29 07:44:25');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (3, 'contact_email', 'contact@aicds.org', 'general', '2026-10-29 07:44:25', '2026-10-29 07:44:25');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (4, 'support_email', 'support@aicds.org', 'general', '2026-10-29 07:44:25', '2026-10-29 07:44:25');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (5, 'contact_phone', '+91 80 2345 6789', 'general', '2026-10-29 07:44:26', '2026-10-29 07:44:26');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (6, 'contact_address', 'AICDS Technology Headquarters, 42 Innovation Corridor, Electronic City, Bengaluru - 560100, India', 'general', '2026-10-29 07:44:27', '2026-10-29 07:44:27');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (7, 'gst_number', '29AAACA0000A1Z5', 'general', '2026-10-29 07:44:27', '2026-10-29 07:44:27');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (8, 'bank_name', 'State Bank of India', 'general', '2026-10-29 07:44:27', '2026-10-29 07:44:27');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (9, 'bank_account_name', 'Association for Intelligent Computing and Data Science', 'general', '2026-10-29 07:44:27', '2026-10-29 07:44:27');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (10, 'bank_account_number', '409123456789', 'general', '2026-10-29 07:44:27', '2026-10-29 07:44:27');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (11, 'bank_ifsc', 'SBIN0009999', 'general', '2026-10-29 07:44:28', '2026-10-29 07:44:28');
INSERT INTO `website_settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES (12, 'bank_branch', 'Electronic City, Bengaluru', 'general', '2026-10-29 07:44:28', '2026-10-29 07:44:28');
SET FOREIGN_KEY_CHECKS = 1;
-- End of MySQL dump