// updated in app & demo -- ALTER TABLE blood_groups DROP FOREIGN KEY blood_groups_business_id_foreign; ALTER TABLE blood_groups DROP FOREIGN KEY blood_groups_created_by_foreign; ALTER TABLE blood_groups DROP FOREIGN KEY blood_groups_updated_by_foreign; ALTER TABLE blood_groups DROP INDEX blood_groups_business_id_foreign; ALTER TABLE blood_groups DROP INDEX blood_groups_created_by_foreign; ALTER TABLE blood_groups DROP INDEX blood_groups_updated_by_foreign; ALTER TABLE blood_groups DROP COLUMN business_id; ALTER TABLE blood_groups DROP COLUMN is_default; ALTER TABLE blood_groups DROP COLUMN block_business_lists; ALTER TABLE blood_groups DROP COLUMN created_by; ALTER TABLE blood_groups DROP COLUMN updated_by; ALTER TABLE marital_statuses DROP FOREIGN KEY marital_statuses_business_id_foreign; ALTER TABLE marital_statuses DROP FOREIGN KEY marital_statuses_created_by_foreign; ALTER TABLE marital_statuses DROP FOREIGN KEY marital_statuses_updated_by_foreign; ALTER TABLE marital_statuses DROP INDEX marital_statuses_business_id_foreign; ALTER TABLE marital_statuses DROP INDEX marital_statuses_created_by_foreign; ALTER TABLE marital_statuses DROP INDEX marital_statuses_updated_by_foreign; ALTER TABLE marital_statuses DROP COLUMN business_id; ALTER TABLE marital_statuses DROP COLUMN is_default; ALTER TABLE marital_statuses DROP COLUMN block_business_lists; ALTER TABLE marital_statuses DROP COLUMN created_by; ALTER TABLE marital_statuses DROP COLUMN updated_by; ALTER TABLE `guardians` MODIFY guardian_profession varchar(100) NULL; ALTER TABLE `guardians` MODIFY guardian_profession_details text NULL; ALTER TABLE `subjects` MODIFY subject_code int(11) NULL; ALTER TABLE users DROP INDEX users_username_unique; ALTER TABLE users DROP INDEX users_email_unique; ALTER TABLE users DROP INDEX users_mobile_unique; ALTER TABLE users DROP INDEX users_national_id_unique; ALTER TABLE users DROP INDEX users_passport_no_unique; ALTER TABLE users DROP INDEX users_birth_certificate_no_unique; ALTER TABLE users DROP INDEX users_driving_license_no_unique; INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'hrm.user_attendances.create', 'web', '2025-01-05 00:40:00', '2025-01-05 00:40:00'); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'hrm.user_attendances.update', 'web', '2025-01-05 00:40:00', '2025-01-05 00:40:00'); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'hrm.user_attendances.delete', 'web', '2025-01-05 00:40:00', '2025-01-05 00:40:00'); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.routine_types.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.routine_setup.trash_delete', 'web', NOW(), NOW()); // accounting ALTER TABLE `employee_informations` ADD COLUMN `joining_date` DATE NULL COMMENT 'default date is form submitted date.' AFTER `out_time`; ALTER TABLE `employee_informations` ADD COLUMN `payment_account_id` BIGINT UNSIGNED NULL AFTER `salary_type`; ALTER TABLE `employee_informations` ADD CONSTRAINT `employee_informations_payment_account_id_foreign` FOREIGN KEY (`payment_account_id`) REFERENCES `payment_accounts`(`id`) ON DELETE CASCADE; // 08/01/2024 ALTER TABLE `academic_classes` CHANGE `numeric_name` `numeric_name` INT(11) NULL COMMENT 'will be unique for a specific business.'; 10/01/2024 (UPDATE FEE_INVOICE) ALTER TABLE payment_fee_schedules ADD COLUMN fee_type ENUM('1', '2', '3', '4') COMMENT '1-annual, 2-monthly, 3-one_time, 4-custom' AFTER fee_category_id; ALTER TABLE payment_fee_schedules MODIFY COLUMN payment_account_id BIGINT UNSIGNED NULL; php artisan migrate --path=Modules/Accounting/Database/migrations/2024_12_17_000336_create_late_fines_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2024_12_17_031707_create_bonuses_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2024_12_17_031719_create_salary_invoices_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2024_12_17_031809_create_salary_transactions_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2024_12_17_031832_create_salary_invoice_details_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_01_10_022403_add_late_fine_id_to_payment_fee_schedules_table.php ALTER TABLE fee_invoices MODIFY COLUMN section_id BIGINT UNSIGNED NULL; ALTER TABLE fee_invoices MODIFY COLUMN total_discount DECIMAL(15, 2) DEFAULT 0; ALTER TABLE fee_invoices ADD COLUMN total_fine DECIMAL(15, 2) DEFAULT 0 AFTER total_discount; ALTER TABLE fee_invoice_details MODIFY COLUMN extra_discount DECIMAL(15, 2) DEFAULT 0; ALTER TABLE fee_invoice_details ADD COLUMN fine_amount DECIMAL(15, 2) DEFAULT 0 AFTER amount; php artisan migrate --path=Modules/Accounting/Database/migrations/2025_01_10_023348_add_payment_account_id_to_transactions_table.php ALTER TABLE transactions DROP COLUMN discount_type; INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.late_fines.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.late_fines.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.late_fines.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.late_fines.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.late_fines.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.late_fines.trash_view', 'web', NOW(), NOW()); DELETE FROM `permissions` WHERE name LIKE 'accounting.payment_fee_schedule.%'; INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_fee_schedules.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_fee_schedules.create', 'web', NOW(), NOW()); DELETE FROM `permissions` WHERE name LIKE 'accounting.payment_account_type.%'; INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_account_types.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_account_types.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_account_types.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_account_types.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_account_types.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_account_types.trash_delete', 'web', NOW(), NOW()); ALTER TABLE payment_fee_schedules MODIFY COLUMN payment_type ENUM('1', '2') NULL; 14/01/2025 INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_fee_schedules.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_fee_schedules.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_fee_schedules.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_fee_schedules.trash_delete', 'web', NOW(), NOW()); DELETE FROM permissions WHERE name LIKE 'student_status.%'; INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'student_statuses.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'student_statuses.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'student_statuses.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'student_statuses.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'student_statuses.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'student_statuses.trash_delete', 'web', NOW(), NOW()); ALTER TABLE fee_invoices MODIFY COLUMN total_amount DECIMAL(15, 2) DEFAULT 0; ALTER TABLE fee_invoices MODIFY COLUMN total_recieve DECIMAL(15, 2) DEFAULT 0; ALTER TABLE fee_invoice_details MODIFY COLUMN amount DECIMAL(15, 2) DEFAULT 0; ALTER TABLE fee_invoice_details MODIFY COLUMN recieve DECIMAL(15, 2) DEFAULT 0; php artisan migrate --path=Modules/Accounting/Database/migrations/2024_12_17_031809_create_salary_transactions_table.php ALTER TABLE salary_invoices CHANGE total_amount amount DECIMAL(15,2) DEFAULT 0; ALTER TABLE salary_invoices MODIFY COLUMN total_paid DECIMAL(15, 2) DEFAULT 0; ALTER TABLE salary_invoice_details MODIFY COLUMN paid DECIMAL(15, 2) DEFAULT 0; ALTER TABLE salary_transactions MODIFY COLUMN amount DECIMAL(15, 2) DEFAULT 0; php artisan migrate --path=Modules/Accounting/Database/migrations/2025_01_19_033815_create_expense_categories_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_01_19_034029_add_columns_to_expense_categories_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_01_19_033831_create_expense_transactions_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_01_19_035114_create_expense_transaction_details_table.php INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_transaction.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_transaction.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_transaction.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_transaction.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_transaction.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_transaction.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.salary_invoice.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.salary_invoice.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.salary_invoice.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.salary_invoice.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.salary_invoice.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.salary_invoice.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.trash_delete', 'web', NOW(), NOW()); php artisan migrate --path=Modules/Academic/Database/migrations/2025_01_04_043820_create_academic_off_days_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_03_12_011213_create_payment_account_transactions_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_03_13_012828_add_payment_account_id_to_salary_transactions_table.php INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.bonus.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_category.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_account.fund_transfer', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_account.deposite', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.payment_account.account_book', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.reports.balance_sheet', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.trash_delete', 'web', NOW(), NOW()); php artisan migrate --path=Modules/Academic/Database/migrations/2025_03_20_015322_add_columns_to_academic_basic_settings_table.php ALTER TABLE `student_promotions` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `from_roll_no` `from_roll_no` INT(11) NULL COMMENT 'auto fill from running record', CHANGE `to_roll_no` `to_roll_no` INT(11) NULL COMMENT '1. automatic generate + editable + unique in every section of every business.', CHANGE `through_exam_id` `through_exam_id` INT(11) NULL COMMENT 'temporary'; // update student_promotions table INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'user_portal.index', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'backup.full_backup', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'backup.database_backup', 'web', NOW(), NOW()); ALTER TABLE `students` CHANGE `admission_status` `admission_status` ENUM('1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2' COMMENT '1-pending, 2-admitted'; // update admission_status -> 2 UPDATE students SET admission_status='2' ALTER TABLE `students` CHANGE `admission_no` `admission_no` BIGINT UNSIGNED NULL COMMENT '1. For Business. 2. will be unique for a specific business. 3. automatic generate + editable', CHANGE `admission_date` `admission_date` DATE NULL COMMENT 'default date is form submitted date', CHANGE `joining_date` `joining_date` DATE NULL COMMENT 'default date is admission_date', CHANGE `academic_year_id` `academic_year_id` BIGINT UNSIGNED NULL; INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.reports.balance_sheet', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.academic_off_days.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'academic.routine_setup.trash_delete', 'web', NOW(), NOW()); ****** add some packages (google drive backup) ****** UPDATE `users` SET `present_address_id` = NULL WHERE `present_address_id` IS NOT NULL; UPDATE `users` SET `permanent_address_id` = NULL WHERE `permanent_address_id` IS NOT NULL; // countries ALTER TABLE countries DROP FOREIGN KEY countries_business_id_foreign; ALTER TABLE countries DROP INDEX countries_business_id_foreign; ALTER TABLE countries DROP COLUMN business_id; ALTER TABLE countries DROP FOREIGN KEY countries_created_by_foreign; ALTER TABLE countries DROP INDEX countries_created_by_foreign; ALTER TABLE countries DROP COLUMN created_by; ALTER TABLE countries DROP FOREIGN KEY countries_updated_by_foreign; ALTER TABLE countries DROP INDEX countries_updated_by_foreign; ALTER TABLE countries DROP COLUMN updated_by; ALTER TABLE countries DROP COLUMN is_default; ALTER TABLE countries DROP COLUMN block_business_lists; // divisions ALTER TABLE divisions DROP FOREIGN KEY divisions_business_id_foreign; ALTER TABLE divisions DROP INDEX divisions_business_id_foreign; ALTER TABLE divisions DROP COLUMN business_id; ALTER TABLE divisions DROP FOREIGN KEY divisions_created_by_foreign; ALTER TABLE divisions DROP INDEX divisions_created_by_foreign; ALTER TABLE divisions DROP COLUMN created_by; ALTER TABLE divisions DROP FOREIGN KEY divisions_updated_by_foreign; ALTER TABLE divisions DROP INDEX divisions_updated_by_foreign; ALTER TABLE divisions DROP COLUMN updated_by; ALTER TABLE divisions DROP COLUMN is_default; ALTER TABLE divisions DROP COLUMN block_business_lists; // districts ALTER TABLE districts DROP FOREIGN KEY districts_business_id_foreign; ALTER TABLE districts DROP INDEX districts_business_id_foreign; ALTER TABLE districts DROP COLUMN business_id; ALTER TABLE districts DROP FOREIGN KEY districts_created_by_foreign; ALTER TABLE districts DROP INDEX districts_created_by_foreign; ALTER TABLE districts DROP COLUMN created_by; ALTER TABLE districts DROP FOREIGN KEY districts_updated_by_foreign; ALTER TABLE districts DROP INDEX districts_updated_by_foreign; ALTER TABLE districts DROP COLUMN updated_by; ALTER TABLE districts DROP COLUMN is_default; ALTER TABLE districts DROP COLUMN block_business_lists; // upazila_thanas ALTER TABLE upazila_thanas DROP FOREIGN KEY upazila_thanas_business_id_foreign; ALTER TABLE upazila_thanas DROP INDEX upazila_thanas_business_id_foreign; ALTER TABLE upazila_thanas DROP COLUMN business_id; ALTER TABLE upazila_thanas DROP FOREIGN KEY upazila_thanas_created_by_foreign; ALTER TABLE upazila_thanas DROP INDEX upazila_thanas_created_by_foreign; ALTER TABLE upazila_thanas DROP COLUMN created_by; ALTER TABLE upazila_thanas DROP FOREIGN KEY upazila_thanas_updated_by_foreign; ALTER TABLE upazila_thanas DROP INDEX upazila_thanas_updated_by_foreign; ALTER TABLE upazila_thanas DROP COLUMN updated_by; ALTER TABLE upazila_thanas DROP COLUMN is_default; ALTER TABLE upazila_thanas DROP COLUMN block_business_lists; php artisan migrate --path=database/migrations/2025_01_16_151604_add_column_to_businesses_table.php ALTER TABLE `students` CHANGE `status_id` `status_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL; ALTER TABLE `academic_classes` CHANGE `numeric_name` `numeric_name` INT(11) NULL DEFAULT NULL COMMENT 'will be unique for a specific business.'; ALTER TABLE `users` CHANGE `religion_id` `religion_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `nationality_id` `nationality_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL; ALTER TABLE `health_informations` CHANGE `blood_group_id` `blood_group_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL; ALTER TABLE `addresses` CHANGE `country_id` `country_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `division_id` `division_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `district_id` `district_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `upazila_thana_id` `upazila_thana_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL; php artisan migrate --path=database/migrations/2025_01_20_155454_modify_guardians_table.php php artisan migrate --path=database/migrations/2025_01_20_162948_modify_user_guardian_relations_table.php php artisan migrate --path=database/migrations/2025_01_21_021813_add_column_tostudents_table.php ALTER TABLE `users` CHANGE `first_name` `first_name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `users` CHANGE `dob` `dob` DATE NULL DEFAULT NULL; ALTER TABLE `users` CHANGE `gender` `gender` ENUM('1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '1-male, 2-female, 3-other'; ALTER TABLE `users` CHANGE `username` `username` VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `users` CHANGE `first_name` `first_name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `dob` `dob` DATE NULL DEFAULT NULL, CHANGE `gender` `gender` ENUM('1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '1-male, 2-female, 3-other', CHANGE `religion_id` `religion_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `nationality_id` `nationality_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL; // reltaion_types table ALTER TABLE relation_types DROP FOREIGN KEY relation_types_business_id_foreign; ALTER TABLE relation_types DROP INDEX relation_types_business_id_foreign; ALTER TABLE relation_types DROP COLUMN business_id; ALTER TABLE relation_types DROP COLUMN is_default; ALTER TABLE relation_types DROP COLUMN block_business_lists; ALTER TABLE relation_types DROP FOREIGN KEY relation_types_created_by_foreign; ALTER TABLE relation_types DROP INDEX relation_types_created_by_foreign; ALTER TABLE relation_types DROP COLUMN created_by; ALTER TABLE relation_types DROP FOREIGN KEY relation_types_updated_by_foreign; ALTER TABLE relation_types DROP INDEX relation_types_updated_by_foreign; ALTER TABLE relation_types DROP COLUMN updated_by; ALTER TABLE `user_guardian_relations` CHANGE `relation_type_id` `relation_type_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL; ALTER TABLE `employee_informations` ADD `joining_date` DATE NULL DEFAULT NULL COMMENT 'default date is form submitted date.' AFTER `out_time`; INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'backups.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'backups.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'backups.download', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'backups.destroy', 'web', NOW(), NOW()); php artisan migrate --path=database/backup_migrations/0001_01_01_000002_create_jobs_table.php php artisan migrate --path=database/migrations/2025_03_30_184810_add_column_to_employee_infomations_table.php php artisan migrate --path=Modules/Academic/Database/migrations/2025_03_25_230503_add_column_to_routine_set_ups_table.php php artisan migrate --path=database/migrations/2025_06_15_003049_add_columns_to_plans_table.php php artisan migrate --path=database/migrations/2025_06_15_013308_add_columns_to_notification_packages_table.php php artisan migrate --path=database/migrations/2025_06_15_114813_add_columns_to_businesses_table.php php artisan migrate --path=database/migrations/2025_06_15_125827_add_columns_to_roles_table.php php artisan migrate --path=database/migrations/2025_06_15_160752_add_columns_to_subscriptions_table.php INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.icons.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.icons.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.icons.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.icons.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.icons.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.icons.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'settings.notifications.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'settings.notifications.modify', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.home_sliders.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.home_sliders.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.home_sliders.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.home_sliders.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.home_sliders.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.home_sliders.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.services.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.services.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.services.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.services.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.services.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.services.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.why_choices.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.why_choices.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.why_choices.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.why_choices.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.why_choices.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.why_choices.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.notices.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.notices.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.notices.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.notices.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.notices.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.notices.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.news.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.news.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.news.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.news.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.news.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.news.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.events.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.events.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.events.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.events.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.events.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.events.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.blogs.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.blogs.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.blogs.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.blogs.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.blogs.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.blogs.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.guardian_feedbacks.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.guardian_feedbacks.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.guardian_feedbacks.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.guardian_feedbacks.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.guardian_feedbacks.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.guardian_feedbacks.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.galleries.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.galleries.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.galleries.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.galleries.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.galleries.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.galleries.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.sayings.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.sayings.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.sayings.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.sayings.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.sayings.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.sayings.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.counters.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.counters.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.counters.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.counters.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.counters.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'frontend.counters.trash_delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_invoice.view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_invoice.trash_view', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_invoice.create', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_invoice.update', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_invoice.delete', 'web', NOW(), NOW()); INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'accounting.expense_invoice.trash_delete', 'web', NOW(), NOW()); (delete) accounting.expense_transaction.create accounting.expense_transaction.delete accounting.expense_transaction.trash_delete accounting.expense_transaction.trash_view accounting.expense_transaction.update accounting.expense_transaction.view (delete) php artisan migrate --path=database/migrations/2025_05_31_031136_create_table_column_visibilities_table.php (later) php artisan migrate --path=database/migrations/2025_05_08_181440_create_notifications_table.php php artisan migrate --path=database/migrations/2025_05_31_140635_add_columns_to_businesses_table.php php artisan migrate --path=database/migrations/2025_06_06_223408_create_super_admin_notification_settings_table.php php artisan migrate --path=database/migrations/2025_06_06_224200_create_business_notification_settings_table.php php artisan migrate --path=database/migrations/2025_06_07_125455_create_notification_packages_table.php php artisan migrate --path=database/migrations/2025_06_07_152006_create_business_notification_subscriptions_table.php php artisan migrate --path=database/migrations/2025_06_08_022648_create_business_invoices_table.php php artisan migrate --path=database/migrations/2025_06_08_044028_create_business_transactions_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_06_13_021724_create_expense_invoices_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_06_13_022101_create_transaction_payments_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_06_13_025246_add_columns_to_expense_transactions_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_06_13_031858_add_columns_to_transactions_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_06_13_133828_add_columns_to_salary_transactions_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_06_13_154754_add_columns_to_expense_transactions_table.php php artisan migrate --path=Modules/Accounting/Database/migrations/2025_03_12_011213_create_payment_account_transactions_table.php // updated in app & demo --