Something went wrong. Try again.
Something went wrong. Try again.
363 B · 8 lines
SQL
at main
123456789CREATE TABLE IF NOT EXISTS character_mail_labels ( character_id INTEGER NOT NULL REFERENCES characters(id) ON DELETE CASCADE, label_id INTEGER NOT NULL, name TEXT NOT NULL, color TEXT, PRIMARY KEY (character_id, label_id));CREATE INDEX IF NOT EXISTS idx_character_mail_labels_character_id ON character_mail_labels(character_id);