AOSSIE-Org / AOSSIE-Org/NeuroTrack

BUG: SQL Syntax Error

Ouverte
#144 1 commentaire 0 réactions 0 personnes assignées Voir sur GitHub
Langage dominant
Dart
Étoiles
29
Forks
50
Métriques de merge des PR
Aucune PR mergée en 30 j

Description

### Is there an existing issue for this?

- [x] I have searched the existing issues

### What happened?

## 📌 Issue Overview
SQL schema has syntax errors preventing database setup

## 🔍 Steps to Reproduce
1. Go to Supabase Dashboard
2. Navigate to SQL Editor
3. Copy `supabase/schemas/schema.sql` file contents
4. Paste into Supabase SQL Editor
5. Click "Run"
6. See SQL syntax error

## 🎯 Expected Behavior
- All database tables should be created successfully
- No SQL errors should appear
- All 14 tables should be visible in Table Editor

## 🚨 Actual Behavior
- SQL syntax error appears
- Database tables are not created
- Error message: "syntax error at or near ')'"

## 📋 Error Details
The schema file contains 4 syntax errors (missing/extra commas):

1. **therapist table** (line ~23): Extra trailing comma before closing bracket
2. **daily_activity_logs table** (line ~142): Missing comma between `activity_items` and `patient_id` columns
3. **observation_master table** (line ~112): Extra trailing comma before closing bracket
4. **activity_master table** (line ~127): Extra trailing comma before closing bracket

## 📷 Error Message
Error: Failed to run sql query: ERROR: 42601: syntax error at or near ")" LINE 37: ); ^
## 📷 Screenshot

Image

## 💡 Suggested Improvements

## 💡 Suggested Fix
Fix comma placement in the following tables:

**therapist table:**
- Remove comma after `license_number TEXT,` → `license_number TEXT`

**daily_activity_logs table:**
- Add comma after `activity_items JSONB NOT NULL,` (currently missing)

**observation_master table:**
- Remove comma after `applicable_therapies UUID[] NOT NULL,` → `applicable_therapies UUID[] NOT NULL`

**activity_master table:**
- Remove comma after `applicable_therapies UUID[] NOT NULL,` → `applicable_therapies UUID[] NOT NULL`

### Record

- [x] I agree to follow this project's Code of Conduct
- [x] I want to work on this issue

Guide de contribution

Aucun guide de contribution indexé pour ce dépôt

Évaluation

Cette issue n'a pas encore été évaluée.

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.