-- EnglishSpeak - Word Library: Add missing fields
-- Run this once in phpMyAdmin on database: englishspeak

-- Add notes field to words table
ALTER TABLE `words` ADD COLUMN `notes` TEXT NULL AFTER `status`;

-- Add slug index if not exists
ALTER TABLE `words` ADD UNIQUE KEY `uq_words_slug` (`slug`);