12 lines
611 B
MySQL
12 lines
611 B
MySQL
|
-- Migration 065: Wiki-spezifische Felder fuer Fähigkeiten (KarateRelevanz, RelevanzLevel)
|
|||
|
|
-- SMW karatetrainer.net; Import mappt in strukturierte Spalten statt nur Freitext in description
|
|||
|
|
|
|||
|
|
ALTER TABLE skills
|
|||
|
|
ADD COLUMN IF NOT EXISTS karate_relevance TEXT;
|
|||
|
|
|
|||
|
|
ALTER TABLE skills
|
|||
|
|
ADD COLUMN IF NOT EXISTS relevance_level SMALLINT CHECK (relevance_level IS NULL OR relevance_level BETWEEN 1 AND 3);
|
|||
|
|
|
|||
|
|
COMMENT ON COLUMN skills.karate_relevance IS 'Wiki Karate-Relevanz (Plaintext aus SMW Property KarateRelevanz)';
|
|||
|
|
COMMENT ON COLUMN skills.relevance_level IS 'Wiki-RelevanzLevel 1–3 (Semantic MediaWiki)';
|