PRAGMA foreign_keys = ON;

ALTER TABLE newsletter_lists ADD COLUMN description TEXT;
ALTER TABLE newsletter_lists ADD COLUMN visibility TEXT NOT NULL DEFAULT 'public';

CREATE INDEX IF NOT EXISTS idx_newsletter_lists_visibility ON newsletter_lists(visibility);
