ALTER TABLE `tw_setting` ADD `zoom_api_key` TEXT NULL DEFAULT NULL AFTER `rtl`;
ALTER TABLE `tw_setting` ADD `zoom_api_secret` TEXT NULL DEFAULT NULL AFTER `zoom_api_key`;

CREATE TABLE `tw_meeting_invitation` (
  `meeting_invitation_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `meeting_id` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `tw_meeting_invitation`
  ADD PRIMARY KEY (`meeting_invitation_id`),
  ADD UNIQUE KEY `uk_staff_meeting` (`staff_id`,`meeting_id`) USING BTREE;
  
ALTER TABLE `tw_meeting_invitation`
  MODIFY `meeting_invitation_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
  

INSERT INTO `tw_labels` (`label_index`, `label`, `usesite`) VALUES
('Live Meeting', 'Live Meeting', 'both'),
('New Meeting', 'New Meeting', 'both'),
('Meeting Topic', 'Meeting Topic', 'both'),
('Start Time', 'Start Time', 'both'),
('Duration', 'Duration', 'both'),
('Video Settings', 'Video Settings', 'both'),
('Host Video On/Off', 'Host Video On/Off', 'both'),
('Participant Video On/Off', 'Participant Video On/Off', 'both'),
('Upcoming Meeting', 'Upcoming Meeting', 'both'),
('Previous Meeting', 'Previous Meeting', 'both'),
('Zoom Settings', 'Zoom Settings', 'both'),
('Meeting Options', 'Meeting Options', 'both'),
('Enable join before host', 'Enable join before host', 'both'),
('Mute participants upon entry', 'Mute participants upon entry', 'both'),
('Meeting ID', 'Meeting ID', 'both'),
('Start', 'Start', 'both'),
('Start Live', 'Start Live', 'both'),
('Invitation', 'Invitation', 'both'),
('Join', 'Join', 'both'),
('Meeting Invitation', 'Meeting Invitation', 'both'),
('Select staff/client', 'Select staff/client', 'both'),
('uk_staff_meeting', 'Duplicate meeting invitation not allowed.', 'uk'),
('Staff/Client', 'Staff/Client', 'both'),
('Staff/Client List', 'Staff/Client List', 'both'),
('Start Meeting', 'Start Meeting', 'both'),
('Meeting Date', 'Meeting Date', 'both'),
('Zoom API Key', 'Zoom API Key', 'both'),
('Zoom API Secret', 'Zoom API Secret', 'both');