devsofttech_hms_ci4/app/Database/Migrations
2026-10-22 10:44:27 +05:30
..
.gitkeep Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-06-000001_CreatePatientDuplicateLog.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-08-000001_CreateDocIpdFeeType.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-08-000002_AddGstAgreementToInsurance.php Make GST insurance migration idempotent for existing columns 2026-03-21 15:57:15 +05:30
2026-02-14-000002_CreateCheckItemRequestFunction.php Fix item request SQL function migration for binlog-safe settings 2026-03-21 15:59:22 +05:30
2026-02-17-000001_BackfillMedicalInvoiceCodes.php Harden medical invoice backfill migration for zero-date strict mode 2026-03-21 16:00:41 +05:30
2026-02-18-000001_CreateMedicalBankTables.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-18-000002_AddPharmacyStockReportIndexes.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-18-000003_CreateMedicalProductCategoryTable.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-18-000004_AlignMedicalProductCategoryTableSchema.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-21-000001_CreateClinicalAuditTrailTable.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-21-000002_CreateOpdFhirDocumentTable.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-21-000003_CreateComplaintsMasterTable.php Make complaints master migration idempotent for existing codes 2026-03-21 16:03:12 +05:30
2026-02-21-000004_CreateBridgeSyncQueueTable.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-21-000005_CreateLabAiExtractionTables.php feat: migrate OPD template flow to DB and apply related updates 2026-03-20 18:11:17 +05:30
2026-02-24-000001_AddDoctorRegistrationNoToDoctorMaster.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-24-000002_CreateOpdMedicineUserPreferenceTables.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-24-000003_AddDosageRestrictionToOpdMedMaster.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-02-24-000004_AddAiScanColumnsToFileUploadData.php Implement OPD template builder, doctor template selection, and OPD print integration fixes 2026-02-27 19:44:36 +05:30
2026-03-01-000001_AddOpdPerformanceIndexes.php Add OPD performance indexes for appointment dashboard and list queries 2026-03-01 01:57:39 +05:30
2026-03-05-000003_CreateIpdNursingEntriesTable.php Add nursing scan-to-structured workflow and discharge UI polish 2026-03-09 00:12:04 +05:30
2026-03-06-000001_CreateNursingBedsideItemsInsuranceTable.php Add nursing scan-to-structured workflow and discharge UI polish 2026-03-09 00:12:04 +05:30
2026-03-07-000010_CreateIpdDischargeTemplatesTable.php Add page settings and header footer support to discharge templates 2026-06-05 06:22:13 +05:30
2026-03-10-000011_CreateFinancePhase1Tables.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-10-000012_AddFinanceInvoiceMatchColumns.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-10-000013_CreateFinanceCashTables.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-10-000014_CreateFinanceDoctorPayoutTables.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-10-000015_CreateFinanceDepositAndPolicyTables.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-13-000016_AddDiagnosisHeadPrintSettings.php feat(diagnosis): add print templates with image upload and optimize PDF rendering 2026-03-15 06:50:44 +05:30
2026-03-14-000017_AddDiagnosisHeadMpdfBlocks.php feat(diagnosis): add print templates with image upload and optimize PDF rendering 2026-03-15 06:50:44 +05:30
2026-03-14-000018_AddDiagnosisPatientInfoHtml.php feat(diagnosis): add print templates with image upload and optimize PDF rendering 2026-03-15 06:50:44 +05:30
2026-03-14-000019_CreateDiagnosisPrintTemplates.php feat(diagnosis): add print templates with image upload and optimize PDF rendering 2026-03-15 06:50:44 +05:30
2026-03-15-000020_AddDiagnosisTemplateMarginsCm.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-15-000021_CreateDoctorDocumentTables.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-15-000022_AddDefaultPrintTypeToDocFormatMaster.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-15-000023_AddPrintMarginsToDocFormatMaster.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-15-000024_CreateDoctorDocumentPrintTemplates.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-17-000025_AddFinancePoDocumentColumns.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-17-000026_CreateFinancePoDocumentsTable.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-17-000027_CreateFinancePharmacyBillsTable.php Implement finance phase 2 pharmacy workflow and admin hospital/pharmacy profile settings 2026-03-17 04:05:02 +05:30
2026-03-25-000029_CreateAyushmanPackageMasterTable.php Add Ayushman package import, billing claim sheet, and reporting dashboards 2026-03-26 15:42:40 +05:30
2026-04-01-000030_CreateInvoiceItemUpdateTable.php Fix billing invoice balance/payment flow and deduction UI 2026-04-01 07:23:29 +05:30
2026-04-01-000031_AddInvestigationMasterFields.php Investigation Master: CRUD, favourites, specialization filter 2026-04-01 18:26:33 +05:30
2026-04-01-000032_CreateInvestigationProfileTables.php Investigation Profile Master: CRUD and consult integration 2026-04-01 18:44:52 +05:30
2026-04-02-000033_EnsureEchoChargeGroup.php Add Echo modality to diagnosis navigation and charge group setup 2026-04-02 05:12:08 +05:30
2026-04-02-000034_CreateHospitalStockModule.php feat(stock): add modular hospital stock management with dashboard, masters, indents, purchase and reports 2026-04-02 10:28:38 +05:30
2026-04-02-000035_EnhanceHospitalStockItems.php feat(stock): add modular hospital stock management with dashboard, masters, indents, purchase and reports 2026-04-02 10:28:38 +05:30
2026-04-04-000036_AddAbdmIdentityFields.php Implement ABDM identity storage and align OPD consult/medicine dose masters 2026-04-04 17:26:40 +05:30
2026-04-04-000037_SyncOpdDoseShedMaster.php Implement ABDM identity storage and align OPD consult/medicine dose masters 2026-04-04 17:26:40 +05:30
2026-04-04-000038_SyncOpdDoseWhenMaster.php Implement ABDM identity storage and align OPD consult/medicine dose masters 2026-04-04 17:26:40 +05:30
2026-04-05-000039_CreateAbdmCoreTables.php feat: Add ABDM Task Board module with ABHA workflow 2026-04-05 23:42:24 +05:30
2026-04-05-000040_AddAbdmWorkTasksTable.php feat: Add ABDM Task Board module with ABHA workflow 2026-04-05 23:42:24 +05:30
2026-04-08-000041_AddMedicineSearchIndexes.php Add medicine search DB indexes and prefix query optimization 2026-04-08 19:49:51 +05:30
2026-04-10-000042_AddOpdContPaperPrintToDoctorMaster.php db: Add opd_cont_paper_print column to doctor_master table 2026-04-10 13:28:03 +05:30
2026-04-18-000043_AddSortOrderToIpdItemType.php feat(ipd-charges): group delete, sort order, Up/Down buttons, foldable billing panels 2026-04-18 06:56:38 +05:30
2026-04-21-000044_AddCashSubmissionPeriodFields.php finance/storestock: implement cash submission audits, bank settlements, and opd payout tracking 2026-04-22 10:53:20 +05:30
2026-04-21-000045_CreateCashSubmissionItemsTable.php finance/storestock: implement cash submission audits, bank settlements, and opd payout tracking 2026-04-22 10:53:20 +05:30
2026-04-21-000046_AddCashSubmissionFieldsToPaymentHistory.php finance/storestock: implement cash submission audits, bank settlements, and opd payout tracking 2026-04-22 10:53:20 +05:30
2026-04-21-000047_CreateBankAuditTables.php finance/storestock: implement cash submission audits, bank settlements, and opd payout tracking 2026-04-22 10:53:20 +05:30
2026-04-21-000048_CreateBankReconciliationAuditTable.php finance/storestock: implement cash submission audits, bank settlements, and opd payout tracking 2026-04-22 10:53:20 +05:30
2026-04-21-000049_CreateBankSettlementEntriesTable.php finance/storestock: implement cash submission audits, bank settlements, and opd payout tracking 2026-04-22 10:53:20 +05:30
2026-04-21-000050_AddBankSettlementStatementMatchFields.php fix: use db->getFieldNames() instead of hasField() in migration for reliable column existence check 2026-04-25 09:11:15 +05:30
2026-04-22-000051_AddOpdPayoutTrackingFields.php finance/storestock: implement cash submission audits, bank settlements, and opd payout tracking 2026-04-22 10:53:20 +05:30
2026-04-27-000101_AddHealthplixDoctorIdentifierToDoctorMaster.php feat: add HealthPlix OPD sync flow with settings, diagnostics, and sync ID persistence 2026-04-27 08:32:51 +05:30
2026-04-27-000102_AddHealthplixSyncIdFields.php feat: add HealthPlix OPD sync flow with settings, diagnostics, and sync ID persistence 2026-04-27 08:32:51 +05:30
2026-04-28-000103_ChangeOpdAppointmentDateToDATETIME.php Add OPD appointment time capture and storage with date+time display 2026-04-28 07:59:47 +05:30
2026-04-28-000104_CreateUserSettingsTable.php Add user-based sidebar auto-hide setting, movable from hospital default 2026-04-28 13:47:46 +05:30
2026-04-30-000105_CreateFinanceMedicalPayoutWorkflowTables.php Implement medical store credit payout workflow and optimize payout pool DataTable grouping 2026-04-30 01:42:03 +05:30
2026-05-01-000201_AddInvoiceItemPayoutTrackingFields.php Finance: separate OPD Consult and Doctor Charges payout screens; compact dashboard cards; add IPD payout tracking migration 2026-05-01 21:02:57 +05:30
2026-05-12-000202_CreateSnomedCoreTables.php feat: ABDM OPD Queue + ABHA Register flow + patient ABHA search fix 2026-05-16 04:21:31 +05:30
2026-05-15-000203_AddAbdmPushFieldsToOpdAndPatient.php feat: ABDM OPD Queue + ABHA Register flow + patient ABHA search fix 2026-05-16 04:21:31 +05:30
2026-05-16-000204_CreateAbdmOpdTokensTable.php feat: ABDM OPD Queue + ABHA Register flow + patient ABHA search fix 2026-05-16 04:21:31 +05:30
2026-05-17-000205_CreateHealthRecordsAndAuditTables.php feat: SNOMED background coding pipeline + ABDM Coding Panel 2026-05-19 20:40:27 +05:30
2026-05-19-000001_AddSnomedFulltextIndex.php feat: SNOMED background coding pipeline + ABDM Coding Panel 2026-05-19 20:40:27 +05:30
2026-05-19-000002_CreateOpdCodingTables.php feat: SNOMED background coding pipeline + ABDM Coding Panel 2026-05-19 20:40:27 +05:30
2026-05-19-000210_AddComplaintSnomedJsonToOpdPrescription.php feat: SNOMED background coding pipeline + ABDM Coding Panel 2026-05-19 20:40:27 +05:30
2026-05-19-000300_AddDiagnosisJsonToOpdPrescription.php feat: SNOMED background coding pipeline + ABDM Coding Panel 2026-05-19 20:40:27 +05:30
2026-05-20-000001_AddSnomedColumnsToClinicalMasters.php feat: Clinical Master workspace — Complaints + Diagnosis edit with SNOMED CT search 2026-05-20 01:25:01 +05:30
2026-05-20-000401_AddSnomedToInvestigation.php feat: SNOMED background coding pipeline + ABDM Coding Panel 2026-05-19 20:40:27 +05:30
2026-05-20-000501_AddBridgeRecordIdToHealthRecords.php feat(abdm): proper FHIR bundles for lab reports and IPD discharge 2026-05-23 04:41:59 +05:30
2026-05-25-000602_AddAbdmDrugTerminologyFieldsToMedProductMaster.php Pharmacy: add ABDM drug terminology autocomplete + canonical mapping 2026-05-25 13:57:56 +05:30
2026-05-26-000603_CreateHmsGatewayCompanyMasterTable.php feat: commit all pending page and ABDM gateway updates 2026-05-26 06:04:34 +05:30
2026-05-26-000604_CreateMedShortFormulationTable.php feat: commit all pending page and ABDM gateway updates 2026-05-26 06:04:34 +05:30
2026-05-27-000605_AddConsentIdsToAbdmConsentRecords.php Checkpoint: pathology panel modal workflow, gateway component search, and ABDM-style component/print editors 2026-05-30 06:32:30 +05:30
2026-05-28-000606_AddLoincToPathologyTables.php Checkpoint: pathology panel modal workflow, gateway component search, and ABDM-style component/print editors 2026-05-30 06:32:30 +05:30
2026-06-02-000607_AddPatientAbhaAddressField.php Store ABHA ID and ABHA address separately 2026-06-02 06:00:35 +05:30
2026-06-02-000608_AddRecordDataToHealthRecords.php Store ABDM bundles in health records 2026-06-03 11:05:40 +05:30
2026-06-18-000609_AddAbhaProfileMetaToPatientMaster.php chore: checkpoint before discharge history panel refactor 2026-06-22 02:05:24 +05:30
2026-06-24-000610_CreateAbdmLocationMasters.php ABDM: finalize ABHA verify persistence, M2 routes/workflows, and location masters seeding 2026-06-24 03:15:22 +05:30
2026-06-24-000611_DropAbdmStateMaster.php ABDM: finalize ABHA verify persistence, M2 routes/workflows, and location masters seeding 2026-06-24 03:15:22 +05:30
2026-06-24-000612_CreateM2HmsAbdmTables.php feat(abdm): implement M2 gateway contract endpoints and live test tooling 2026-06-24 04:50:03 +05:30
2026-06-27-000613_CreateAbdmPushSyncTables.php Fix ABDM M3 HIU ID mapping, polling guards, and migration compatibility 2026-07-02 00:55:05 +05:30
2026-07-01-000701_CreateAbdmM3HiuWorkflows.php Add ABDM M3 HIU workflows, routes, UI, and runbook docs 2026-07-01 17:37:53 +05:30
2026-07-01-000702_AddConsentMappingColumnsToAbdmHiuWorkflows.php Fix ABDM M3 HIU ID mapping, polling guards, and migration compatibility 2026-07-02 00:55:05 +05:30
2026-07-09-000714_AdjustAbdmHiuWorkflowRequestOperationIndex.php ABDM HIU callback hardening, OPD ABHA optional confirm, and AJAX memory cleanup 2026-07-10 00:09:35 +05:30
2026-07-16-000715_CreateAbdmHiuDocuments.php Add ABDM documents and patient profile sync UI 2026-07-16 18:23:40 +05:30
2026-07-18-000001_CreateImmunizationModuleTables.php Add patient immunization module 2026-07-19 00:41:12 +05:30
2026-07-19-000002_AddBridgeMetadataToImmunizationMaster.php Add E-Atria immunization master sync 2026-07-19 01:00:43 +05:30
2026-07-28-002500_CreateAbdmHiuConsentArtifacts.php Fix ABDM M3 HIU multi-facility consent session grouping and document display 2026-07-30 05:08:44 +05:30
2026-08-07-000801_AddAddressFieldsToReferMaster.php Add migration for refer master address fields 2026-08-07 12:36:02 +05:30
2026-08-09-000001_CreateUserActiveSessionsTable.php feat: add role and session access controls 2026-08-09 23:21:16 +05:30
2026-08-09-000002_UseInnoDbForUserActiveSessions.php feat: add role and session access controls 2026-08-09 23:21:16 +05:30
2026-08-09-000003_CreateAuthRoleMasterTables.php feat: add role and session access controls 2026-08-09 23:21:16 +05:30
2026-08-09-000004_AddDevelopedModulePermissions.php feat: add role and session access controls 2026-08-09 23:21:16 +05:30
2026-08-10-000005_AddIpdNursingAndDischargePermissions.php feat: add IPD nursing and discharge permissions 2026-08-10 00:55:18 +05:30
2026-08-10-000006_AddFinancePaymentEditPermission.php feat: add payment editing and fix discharge templates 2026-08-10 14:48:33 +05:30
2026-08-10-000007_BackfillFinancePaymentEditUserPermission.php feat: add payment editing and fix discharge templates 2026-08-10 14:48:33 +05:30
2026-08-10-000008_CreateIpdPreopExaminations.php feat: add OT workflow and allow zero payments 2026-08-12 13:38:25 +05:30
2026-08-10-000009_CreateIpdOtWorkflow.php feat: add OT workflow and allow zero payments 2026-08-12 13:38:25 +05:30
2026-08-13-000001_AddAbhaCardToPatientMaster.php Store ABHA card and improve patient comparison 2026-08-13 11:30:02 +05:30
2026-08-14-000001_AddCreatedAtIndexToAbdmHiuWorkflows.php Add 2-day retention pruning for abdm_hiu_workflows 2026-08-14 11:52:49 +05:30
2026-08-14-000002_AddCreatedAtIndexToAbdmApiLogs.php Add combined ABDM log prune command and api log index 2026-08-14 13:14:13 +05:30
2026-08-15-000001_AddAadhaarVaultToPatientMaster.php Store Aadhaar encrypted with masked display and hash-based search 2026-08-15 03:16:40 +05:30
2026-08-23-000001_AddIpdCensusReportPermission.php feat(report): add searchable permissioned IPD census hub 2026-08-23 20:36:09 +05:30
2026-08-23-000002_AddIpdSurgeryReportPermission.php feat(report): add IPD surgery export report 2026-08-24 00:01:58 +05:30
2026-08-24-000003_AddIpdGeneralExamFieldControls.php feat(ipd): manage admission examination fields 2026-08-24 00:53:01 +05:30
2026-08-27-000001_SyncOpdDoseWhereRoutes.php feat(ipd): align IPD Discharge prescribed medicine form design and autotext with OPD Consult 2026-08-27 04:33:10 +05:30
2026-08-27-000002_SyncOpdDoseFrequency.php feat(ipd): align IPD Discharge prescribed medicine form design and autotext with OPD Consult 2026-08-27 04:33:10 +05:30
2026-09-08-000001_CreateMedicalStoreReturnsAndExchanges.php feat(medical-store): add B2C sales returns, same-invoice exchanges, and DB migrations 2026-09-08 05:07:45 +05:30
2026-09-08-000002_CreateMedicalStoreBaseSchema.php fix(medical-store): add complete base schema migration and devices table for remote server 2026-09-08 05:19:19 +05:30
2026-09-09-000003_CreateAbdmLinkTransactions.php feat(abdm): implement M1 find ABHA by mobile flow & M2 user-initiated linking 2026-09-09 17:52:20 +05:30
2026-09-10-000001_LinkMedicalStoreToPharmacyProductMaster.php feat(medical-store): inward purchase medicine auto-search and shared pharmacy master integration 2026-09-10 04:23:09 +05:30
2026-09-10-000002_CreateSupplierLedgersAndPurchaseOrders.php feat(medical-store): add supplier ledger, payment tracking, short items book, and purchase orders 2026-09-10 04:49:00 +05:30
2026-09-10-000003_AddPharmaFieldsAndChallanToMedicalStore.php feat(medical-store): pharma stock entry with progressive disclosure, challan import, and history 2026-09-10 06:35:05 +05:30
2026-09-10-000004_UpdateGstSlabsAcrossMasters.php feat(tax): standardize current GST slabs (0%, 5%, 18%, 40%, legacy 12%, 28%) across HMS and Medical Store 2026-09-10 07:13:04 +05:30
2026-09-18-000001_CreateCreditAccountsAndMobileDraftSchema.php feat(medical-store): auto-convert draft bills to invoice on checkout and reduce pending draft list 2026-09-18 05:49:20 +05:30
2026-09-22-000001_CreateDaycareEmergencyModule.php feat: add Day Care & Emergency admission module with IPD conversion and clean patient names 2026-09-21 23:41:24 +05:30
2026-09-23-000001_AddOpdDayCareTemplateToDoctorMaster.php Fix IPD patient admit search error, add admission type filters to IPD patient list, remove redundant sidebar links, and add OPD Day Care template support 2026-09-23 10:12:42 +05:30
2026-09-24-000001_AddCompositeIndexesToAbdmHiuWorkflows.php fix(abdm): add concurrency lock, optimize hiu-poll query, and add composite indexes 2026-09-24 08:03:57 +05:30
2026-10-14-000001_CreateUserProfilesTable.php feat(user-management): enhance user management, permission handling, and charges invoice workflows 2026-10-14 20:08:10 +05:30
2026-10-19-000001_CreatePharmacyGrnAndEnhancePoTables.php feat(pharmacy): implement Purchase Orders (PO) and Inward Goods Received Notes (GRN) workflow 2026-10-19 15:48:53 +05:30
2026-10-21-000001_RemoveHealthplixColumns.php feat: completely remove HealthPlix integration, controllers, views, and database columns 2026-10-21 01:33:13 +05:30
2026-10-22-000001_AddGrnEnhancementsColumns.php Fix HTTP 500 on GRN view/edit: add self-healing schema migration and null-safe view rendering 2026-10-22 10:44:27 +05:30