• Mahmoud Aglan's avatar
    fix: writes that named columns the database does not have · 952e2ce6
    Mahmoud Aglan authored
    Every one of these was rejected by PostgREST and reported as success
    (found by checking each insert/update/select against the live schema):
    
    - workflows: approval_requests has reviewed_by/review_notes, not
      reviewer_id/review_note; reviewers and requesters are staff uuids, so the
      pages now show their names, "my requests" filters by the account id, and
      search no longer runs ilike on a uuid. workflow_rules has event_type, not
      event; created_by is a uuid; conditions/actions go in as jsonb lists.
    - RuleEngine: event_type, and its notify action writes a real notifications
      row (user_id, title_ar/body_ar) only when addressed to a player.
    - moderation: cheat_reports.reviewed_by references profiles, so a staff
      reviewer is stored in the new reviewed_by_admin column.
    - users: admin_users has no created_by.
    - org-transfers, org-frames, org-chat: org_members has player_id (not
      user_id) and no status column. Membership logic is unchanged.
    - org-achievements: an org achievement cannot be stored in
      player_achievements (its achievement_id references the game's
      achievements); granting now says so instead of failing the insert and
      still paying the reward. Progress reads completed/completed_at.
    - org-loyalty, org-partnerships: those tables have no updated_at.
    - live pages: phases are in tournament_phases ordered by phase_number; the
      arena tables never existed.
    Co-Authored-By: 's avatarClaude Opus 5.5 <noreply@anthropic.com>
    952e2ce6
Name
Last commit
Last update
Connections and docs Loading commit data...
api Loading commit data...
config Loading commit data...
core Loading commit data...
layouts Loading commit data...
migrations Loading commit data...
modules Loading commit data...
public Loading commit data...
storage Loading commit data...
tools Loading commit data...
.gitignore Loading commit data...
.htaccess Loading commit data...
Dockerfile Loading commit data...
EL3AB_MANAGEMENT_SYSTEM.md Loading commit data...
EL3AB_PLAYER_APP_DATA.md Loading commit data...
TOURNAMENT_PLAYBOOK.md Loading commit data...
captain-definition Loading commit data...
index.php Loading commit data...