Changeset cdcff72 for backend/src/main/resources/db

Timestamp:

09/04/26 19:36:17 (2 weeks ago)

Author:

MBK <marija.karapandzova@…>

Branches:

master

Children:

99ab276

Parents:

9af201e

Message:

Fix frontend appearance and fix bugs

Location:

backend/src/main/resources/db

Files:

• migration/R__allergy_prescription_safety_enforcement.sql (moved) (moved from backend/src/main/resources/db.migration/R__allergy_prescription_safety_enforcement.sql )
• migration/R__billing_integrity.sql (moved) (moved from backend/src/main/resources/db.migration/R__billing_integrity.sql )
• migration/R__create_scoped_app_role.sql (added)
• migration/R__custom_domains.sql (moved) (moved from backend/src/main/resources/db.migration/R__custom_domains.sql )
• migration/R__medical_record_integrity.sql (moved) (moved from backend/src/main/resources/db.migration/R__medical_record_integrity.sql )
• migration/V1.1__Create_Daily_Billing_View.sql (moved) (moved from backend/src/main/resources/db.migration/V1.1__Create_Daily_Billing_View.sql ) (1 diff)
• migration/V1.2__Create_Users_Table.sql (moved) (moved from backend/src/main/resources/db.migration/V1.2__Create_Users_Table.sql ) (2 diffs)
• migration/V2__Add_appointment_fields_to_referrals.sql (moved) (moved from backend/src/main/resources/db.migration/V2__Add_appointment_fields_to_referrals.sql )
• migration/V3__Fix_LabTechnician_Admin_Structure.sql (added)
• migration/V6__Insert_Billing_Admin_Users.sql (moved) (moved from backend/src/main/resources/db.migration/V6__Insert_Billing_Admin_Users.sql )
• migration/V7__Update_Billing_Admin_Names.sql (moved) (moved from backend/src/main/resources/db.migration/V7__Update_Billing_Admin_Names.sql )
• migration/V8__appointment_scheduling_integrity.sql (moved) (moved from backend/src/main/resources/db.migration/V8__appointment_scheduling_integrity.sql )
• migration/V9__mv_revenue_reporting.sql (moved) (moved from backend/src/main/resources/db.migration/V9__mv_revenue_reporting.sql )
• phase7/verify_section2_deployment.sql (added)

backend/src/main/resources/db/migration/V1.1__Create_Daily_Billing_View.sql

@@ -1 @@
--- Create materialized view for daily patient billing totals
+ -- Create materialized view for daily patient billing totals
 CREATE MATERIALIZED VIEW IF NOT EXISTS daily_patient_billing_totals AS
 SELECT

backend/src/main/resources/db/migration/V1.2__Create_Users_Table.sql

@@ -1 @@
-user
 -- Create users table
 CREATE TABLE IF NOT EXISTS users (
@@ -32 +31 @@
 )
 LIMIT 39;
+
+-- Insert doctor users (password: doctor123 for all)
+-- These will be linked to existing doctors by email
+INSERT INTO users (username, password, role, first_name, last_name, doctor_id, is_active)
+SELECT d.email_address, 'doctor123', 'DOCTOR', d.first_name, d.last_name, d.doctor_id, true
+FROM doctors d
+WHERE NOT EXISTS (
+    SELECT 1 FROM users u WHERE u.username = d.email_address
+);