ALTER TABLE library_items ADD COLUMN role TEXT NOT NULL DEFAULT 'program';