✓ Conexión exitosa
| Campo | Tipo | Null | Default |
|---|---|---|---|
| id | int(10) unsigned | NO | NULL |
| uuid | varchar(36) | NO | NULL |
| user_id | int(10) unsigned | YES | NULL |
| type | enum('word_search','crossword','double_puzzle','fallen_phrase','cryptogram') | NO | NULL |
| title | varchar(200) | NO | NULL |
| lang | char(2) | NO | es |
| data | longtext | NO | NULL |
| difficulty | enum('easy','medium','hard') | YES | medium |
| views | int(10) unsigned | YES | 0 |
| plays | int(10) unsigned | YES | 0 |
| is_public | tinyint(1) | YES | 1 |
| created_at | timestamp | YES | current_timestamp() |
| downloads | int(10) unsigned | YES | 0 |
| updated_at | timestamp | YES | current_timestamp() |
✓ id - existe
✓ uuid - existe
✓ user_id - existe
✓ type - existe
✓ title - existe
✓ lang - existe
✓ data - existe
✓ difficulty - existe
✓ views - existe
✓ plays - existe
✓ downloads - existe
✓ is_public - existe
✓ created_at - existe
✓ updated_at - existe
| Nombre | Columna | Único |
|---|---|---|
| PRIMARY | id | Sí |
| uuid | uuid | Sí |
| idx_uuid | uuid | No |
| idx_type | type | No |
| idx_lang | lang | No |
| user_id | user_id | No |
| idx_difficulty | difficulty | No |
| idx_public | is_public | No |
| idx_created | created_at | No |
| idx_type_lang | type | No |
| idx_type_lang | lang | No |
| idx_views | views | No |
| idx_plays | plays | No |
✓ idx_type existe
✓ idx_lang existe
✓ idx_difficulty existe
✓ idx_public existe
✓ idx_created existe
✓ idx_type_lang existe