---Delete extra users (only users)---
DELETE FROM users WHERE NOT EXISTS (SELECT 1 FROM employees e WHERE e.user_id = users.id) AND NOT EXISTS (SELECT 1 FROM students s WHERE s.user_id = users.id) AND NOT EXISTS (SELECT 1 FROM students s WHERE s.guardian_login_user_id = users.id);



ALTER TABLE `students` CHANGE `created_by` `created_by` BIGINT(20) UNSIGNED NULL;


php artisan migrate --path=database/migrations/2025_07_19_012307_create_user_theme_configs_table.php








// Start Mahi
    //exam

    INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.admit_card.view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.admit_card.trash_view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.admit_card.create', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.admit_card.update', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.admit_card.delete', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.admit_card.trash_delete', 'web', NOW(), NOW());

    INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_exams.view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_exams.trash_view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_exams.create', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_exams.update', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_exams.delete', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_exams.trash_delete', 'web', NOW(), NOW());

    INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_sub_exams.view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_sub_exams.trash_view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_sub_exams.create', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_sub_exams.update', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_sub_exams.delete', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'exam.academic_sub_exams.trash_delete', 'web', NOW(), NOW());

    // academic
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_years.view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_years.trash_view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_years.create', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_years.update', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_years.delete', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_years.trash_delete', 'web', NOW(), NOW());


INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_shifts.view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_shifts.trash_view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_shifts.create', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_shifts.update', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_shifts.delete', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_shifts.trash_delete', 'web', NOW(), NOW());

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_classes.view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_classes.trash_view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_classes.create', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_classes.update', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_classes.delete', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_classes.trash_delete', 'web', NOW(), NOW());

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_groups.view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_groups.trash_view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_groups.create', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_groups.update', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_groups.delete', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_groups.trash_delete', 'web', NOW(), NOW());

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_sections.view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_sections.trash_view', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_sections.create', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_sections.update', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_sections.delete', 'web', NOW(), NOW());
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_sections.trash_delete', 'web', NOW(), NOW());



// End Mahi





// done till demo2 - start





// frontend (start)
INSERT INTO `website_sections` (`id`, `section_name`, `section_title`, `section_subtitle`, `status`, `created_by`, `updated_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'why_choice_us', 'why_choice_us', 'why_choice_us', '1', 1, 1, NULL, NULL, '2025-05-13 11:24:25'),
(2, 'home_slider', 'asdfasdfadsf', 'fadsafsdfasdffffff', '1', 1, 1, NULL, '2025-04-29 09:12:55', '2025-05-07 10:43:47'),
(3, 'services', 'services', 'services', '1', 1, NULL, NULL, '2025-05-13 11:24:39', '2025-05-13 11:24:39'),
(4, 'counter', 'counter', 'counter', '1', 1, NULL, NULL, '2025-05-13 11:24:59', '2025-05-13 11:24:59'),
(5, 'news', 'news', 'news', '1', 1, NULL, NULL, '2025-05-13 11:25:37', '2025-05-13 11:25:37'),
(6, 'event', 'event', 'event', '1', 1, NULL, NULL, '2025-05-13 11:25:46', '2025-05-13 11:25:46'),
(7, 'guardian_feedback', 'guardian_feedback', 'guardian_feedback', '1', 1, NULL, NULL, '2025-05-13 11:26:10', '2025-05-13 11:26:10'),
(8, 'notice', 'notice', 'notice', '1', 1, NULL, NULL, '2025-05-13 11:26:32', '2025-05-13 11:26:32'),
(9, 'sayings', 'sayings', 'sayings', '1', 1, NULL, NULL, '2025-05-13 11:26:52', '2025-05-13 11:26:52'),
(10, 'employee_designation', 'employee-designation', 'employee-designation', '1', 1, 1, NULL, '2025-05-19 05:26:36', '2025-06-01 11:54:49'),
(11, 'gallery', 'gallery', 'gallery', '1', 1, NULL, NULL, '2025-05-29 02:09:25', '2025-05-29 02:09:25');


php artisan migrate --path=database/migrations/2025_06_11_013900_add_columns_to_businesses_table.php
// frontend (end)




// done till demo2 - end



xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx // attendance (later xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx)
ALTER TABLE user_attendances
DROP COLUMN intime,
DROP COLUMN outime;

ADD COLUMN attendance_time TIME NULL AFTER attendance_type_id,
ADD COLUMN attendance_type TINYINT NULL COMMENT '1-In, 2-Out' AFTER attendance_time;