Fix Missing Tables

Creating tables in correct dependency order

ObjectStatus
supplier OK
supplier_user_assignment ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "user_master" does not exist
blanket_penawaran_header OK
blanket_penawaran_item OK
blanket_site_assignment ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "site_master" does not exist
penawaran_header ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "site_master" does not exist
penawaran_item ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "penawaran_header" does not exist
penawaran_item_unique_fix ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "penawaran_item" does not exist
booking_header ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "site_master" does not exist
booking_item ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "booking_header" does not exist
booking_status_history ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "booking_header" does not exist
delivery_tracking ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "booking_header" does not exist
penawaran_view_log ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "penawaran_header" does not exist
supplier_payment ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "penawaran_header" does not exist
Index: idx_supplier_status OK
Index: idx_penawaran_header_site_status ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "penawaran_header" does not exist
Index: idx_penawaran_header_status_close ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "penawaran_header" does not exist
Index: idx_penawaran_item_penawaran_id ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "penawaran_item" does not exist
Index: idx_booking_header_member_status ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "booking_header" does not exist
Index: idx_booking_header_penawaran_status ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "booking_header" does not exist
Index: idx_booking_header_site_status ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "booking_header" does not exist
Index: idx_booking_item_booking_id ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "booking_item" does not exist
Index: idx_booking_item_penawaran_item ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "booking_item" does not exist
Index: idx_booking_status_history_booking ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "booking_status_history" does not exist
Index: idx_delivery_tracking_booking ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "delivery_tracking" does not exist
Index: idx_penawaran_view_log_penawaran ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "penawaran_view_log" does not exist
Index: idx_penawaran_view_log_site ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "penawaran_view_log" does not exist
Index: idx_supplier_payment_penawaran ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "supplier_payment" does not exist
Index: idx_supplier_payment_supplier ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "supplier_payment" does not exist
Index: idx_blanket_site_assignment_blanket ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "blanket_site_assignment" does not exist
Index: idx_blanket_site_assignment_site ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "blanket_site_assignment" does not exist

Next Steps

  1. Try booking again
  2. View My Bookings