
-- Add new column for access level
ALTER TABLE `wa_wabinar_broadcaster`
ADD `level` ENUM('ADMIN','EXPERT','SUPER_AFFILIATE') NOT NULL DEFAULT 'ADMIN' COMMENT 'Access level for Classes'  AFTER `user_id`;

-- Update level to EXPERT of users other than Kyle/Carson
UPDATE `wa_wabinar_broadcaster` SET `level` = 'EXPERT' WHERE user_id NOT IN (1,37);

-- Insert Experts
INSERT INTO wa_wabinar_broadcaster (user_id, level)
VALUES (13411, 'EXPERT')
, (10550, 'EXPERT')
, (97090, 'EXPERT')
, (18502, 'EXPERT')
, (568584, 'EXPERT')
, (1013831, 'EXPERT')
, (819232, 'EXPERT')
, (915572, 'EXPERT');

-- Insert Super Affiliates
INSERT INTO wa_wabinar_broadcaster (user_id, level)
VALUES (503713, 'SUPER_AFFILIATE')
, (719576, 'SUPER_AFFILIATE')
, (755988, 'SUPER_AFFILIATE')
, (572444, 'SUPER_AFFILIATE')
, (939910, 'SUPER_AFFILIATE')
, (261532, 'SUPER_AFFILIATE')
, (841016, 'SUPER_AFFILIATE')
, (530468, 'SUPER_AFFILIATE');
