Adminator
1e51ef7def
- Konzept/, didaktik_geografie/, didaktik_simulation/, v2-modules/, v2-platform/ - 12 code-workspace-Files - STATUS-*.md - viele M/D/R-Änderungen an bereits getrackten Files - .gitignore verstärkt: **/.humaninput/, **/secret_keys.txt Co-Authored-By: Claude Opus 4.7 <noreply@anthropic.com>
11 lines
508 B
SQL
11 lines
508 B
SQL
-- Klartext-PIN-Spalte für students (Lehrer-vergebene Passwörter sichtbar)
|
|
-- IF NOT EXISTS-äquivalent über Information_Schema-Check
|
|
SET @col_exists = (
|
|
SELECT COUNT(*) FROM information_schema.COLUMNS
|
|
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'students' AND COLUMN_NAME = 'password_plaintext'
|
|
);
|
|
SET @sql = IF(@col_exists = 0,
|
|
'ALTER TABLE students ADD COLUMN password_plaintext VARCHAR(64) NULL AFTER password',
|
|
'SELECT 1');
|
|
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
|