Spaces:
Runtime error
Runtime error
Download database/schema.sql from simhaa-hat/flux-ide-backend: direct link, hf CLI and curl.
- Browser
- Download file 869 Bytes
-
https://huggingface.co/spaces/simhaa-hat/flux-ide-backend/resolve/main/database/schema.sql
- Command line
-
hf download hf://spaces/simhaa-hat/flux-ide-backend/database/schema.sql
-
curl -L -o schema.sql https://huggingface.co/spaces/simhaa-hat/flux-ide-backend/resolve/main/database/schema.sql
869 Bytes
| CREATE TABLE IF NOT EXISTS users ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| username TEXT UNIQUE NOT NULL, | |
| email TEXT UNIQUE NOT NULL, | |
| password_hash TEXT NOT NULL, | |
| created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, | |
| updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP | |
| ); | |
| CREATE TABLE IF NOT EXISTS sessions ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| user_id INTEGER NOT NULL, | |
| token_hash TEXT NOT NULL, | |
| expires_at TIMESTAMP NOT NULL, | |
| created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, | |
| FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE | |
| ); | |
| CREATE INDEX IF NOT EXISTS idx_users_email ON users(email); | |
| CREATE INDEX IF NOT EXISTS idx_users_username ON users(username); | |
| CREATE INDEX IF NOT EXISTS idx_sessions_token ON sessions(token_hash); | |
| CREATE INDEX IF NOT EXISTS idx_sessions_user_id ON sessions(user_id); | |