Download migrations/010_project_feedback.sql from Basel0/qshub: direct link, hf CLI and curl.
- Browser
- Download file 923 Bytes
-
https://huggingface.co/spaces/Basel0/qshub/resolve/main/migrations/010_project_feedback.sql
- Command line
-
hf download hf://spaces/Basel0/qshub/migrations/010_project_feedback.sql
-
curl -L -o 010_project_feedback.sql https://huggingface.co/spaces/Basel0/qshub/resolve/main/migrations/010_project_feedback.sql
923 Bytes
| -- Migration: 010_project_feedback | |
| -- Description: Creates the tables backing the in-app "Rate Your Experience" | |
| -- ratings and the customer complaints box. These were only defined in the | |
| -- local SQLite bootstrap, so on MySQL the inserts (and the admin panel that | |
| -- reads them) had no table to hit. IF NOT EXISTS keeps this safe if a table | |
| -- was already created manually in production. | |
| CREATE TABLE IF NOT EXISTS qto_project_feedback ( | |
| id INT AUTO_INCREMENT PRIMARY KEY, | |
| user_id INT NOT NULL, | |
| tool_name VARCHAR(100) NOT NULL, | |
| project_name VARCHAR(255) NOT NULL, | |
| rating INT NOT NULL, | |
| reason TEXT, | |
| created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP | |
| ); | |
| CREATE TABLE IF NOT EXISTS qto_customer_complaints ( | |
| id INT AUTO_INCREMENT PRIMARY KEY, | |
| user_id INT NOT NULL, | |
| complaint_text TEXT NOT NULL, | |
| status VARCHAR(50) DEFAULT 'open', | |
| created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP | |
| ); | |