LEDbelly Caliper Schema Update

led-caliper-mssql-update.sql

ALTER TABLE ims_asset_accessed ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_asset_accessed ADD client_ip VARCHAR(39);
ALTER TABLE ims_asset_accessed ADD object_asset_name VARCHAR(1000);
ALTER TABLE ims_asset_accessed ADD object_context_account_id VARCHAR(39);
ALTER TABLE ims_asset_accessed ADD object_developer_key_id BIGINT;
ALTER TABLE ims_asset_accessed ADD object_display_name VARCHAR(MAX);
ALTER TABLE ims_asset_accessed ADD object_domain VARCHAR(255);
ALTER TABLE ims_asset_accessed ADD object_filename VARCHAR(MAX);
ALTER TABLE ims_asset_accessed ADD object_http_method VARCHAR(4);
ALTER TABLE ims_asset_accessed ADD object_url VARCHAR(MAX);
ALTER TABLE ims_asset_accessed ADD referrer VARCHAR(MAX);
ALTER TABLE ims_asset_accessed ADD request_url VARCHAR(MAX);
ALTER TABLE ims_assignment_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_assignment_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_assignment_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_assignment_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_assignment_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_assignment_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_assignment_updated ADD object_maxscore float(53);
ALTER TABLE ims_assignment_updated ADD referrer VARCHAR(MAX);
ALTER TABLE ims_assignment_updated ADD request_url VARCHAR(MAX);
ALTER TABLE ims_attachment_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_attachment_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_attachment_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_attachment_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_attachment_deleted ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_attachment_deleted ADD client_ip VARCHAR(39);
ALTER TABLE ims_attachment_deleted ADD referrer VARCHAR(MAX);
ALTER TABLE ims_attachment_deleted ADD request_url VARCHAR(MAX);
ALTER TABLE ims_attachment_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_attachment_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_attachment_updated ADD referrer VARCHAR(MAX);
ALTER TABLE ims_attachment_updated ADD request_url VARCHAR(MAX);
ALTER TABLE ims_course_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_course_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_course_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_course_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_discussion_entry_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_discussion_entry_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_discussion_entry_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_discussion_entry_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_discussion_topic_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_discussion_topic_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_discussion_topic_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_discussion_topic_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_enrollment_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_enrollment_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_enrollment_state_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_state_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_state_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_enrollment_state_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_enrollment_state_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_state_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_state_updated ADD referrer VARCHAR(MAX);
ALTER TABLE ims_enrollment_state_updated ADD request_url VARCHAR(MAX);
ALTER TABLE ims_enrollment_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_updated ADD referrer VARCHAR(MAX);
ALTER TABLE ims_enrollment_updated ADD request_url VARCHAR(MAX);
ALTER TABLE ims_grade_change ADD client_ip VARCHAR(39);
ALTER TABLE ims_grade_change ADD referrer VARCHAR(MAX);
ALTER TABLE ims_grade_change ADD request_url VARCHAR(MAX);
ALTER TABLE ims_group_category_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_group_category_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_group_category_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_group_category_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_group_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_group_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_group_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_group_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_group_membership_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_group_membership_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_group_membership_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_group_membership_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_logged_in ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_logged_in ADD client_ip VARCHAR(39);
ALTER TABLE ims_logged_in ADD referrer VARCHAR(MAX);
ALTER TABLE ims_logged_in ADD request_url VARCHAR(MAX);
ALTER TABLE ims_logged_out ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_logged_out ADD client_ip VARCHAR(39);
ALTER TABLE ims_logged_out ADD referrer VARCHAR(MAX);
ALTER TABLE ims_logged_out ADD request_url VARCHAR(MAX);
ALTER TABLE ims_quiz_submitted ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_quiz_submitted ADD client_ip VARCHAR(39);
ALTER TABLE ims_quiz_submitted ADD referrer VARCHAR(MAX);
ALTER TABLE ims_quiz_submitted ADD request_url VARCHAR(MAX);
ALTER TABLE ims_submission_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_submission_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_submission_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_submission_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_submission_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_submission_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_submission_updated ADD referrer VARCHAR(MAX);
ALTER TABLE ims_submission_updated ADD request_url VARCHAR(MAX);
ALTER TABLE ims_syllabus_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_syllabus_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_syllabus_updated ADD referrer VARCHAR(MAX);
ALTER TABLE ims_syllabus_updated ADD request_url VARCHAR(MAX);
ALTER TABLE ims_user_account_association_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_user_account_association_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_user_account_association_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_user_account_association_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_wiki_page_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_wiki_page_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_wiki_page_created ADD referrer VARCHAR(MAX);
ALTER TABLE ims_wiki_page_created ADD request_url VARCHAR(MAX);
ALTER TABLE ims_wiki_page_deleted ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_wiki_page_deleted ADD client_ip VARCHAR(39);
ALTER TABLE ims_wiki_page_deleted ADD referrer VARCHAR(MAX);
ALTER TABLE ims_wiki_page_deleted ADD request_url VARCHAR(MAX);
ALTER TABLE ims_wiki_page_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_wiki_page_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_wiki_page_updated ADD referrer VARCHAR(MAX);
ALTER TABLE ims_wiki_page_updated ADD request_url VARCHAR(MAX);

led-caliper-mysql-postgres-update.sql

ALTER TABLE ims_asset_accessed ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_asset_accessed ADD client_ip VARCHAR(39);
ALTER TABLE ims_asset_accessed ADD object_asset_name VARCHAR(1000);
ALTER TABLE ims_asset_accessed ADD object_context_account_id VARCHAR(39);
ALTER TABLE ims_asset_accessed ADD object_developer_key_id BIGINT;
ALTER TABLE ims_asset_accessed ADD object_display_name TEXT;
ALTER TABLE ims_asset_accessed ADD object_domain VARCHAR(255);
ALTER TABLE ims_asset_accessed ADD object_filename TEXT;
ALTER TABLE ims_asset_accessed ADD object_http_method VARCHAR(4);
ALTER TABLE ims_asset_accessed ADD object_url TEXT;
ALTER TABLE ims_asset_accessed ADD referrer TEXT;
ALTER TABLE ims_asset_accessed ADD request_url TEXT;
ALTER TABLE ims_assignment_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_assignment_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_assignment_created ADD referrer TEXT;
ALTER TABLE ims_assignment_created ADD request_url TEXT;
ALTER TABLE ims_assignment_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_assignment_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_assignment_updated ADD object_maxscore FLOAT(53);
ALTER TABLE ims_assignment_updated ADD referrer TEXT;
ALTER TABLE ims_assignment_updated ADD request_url TEXT;
ALTER TABLE ims_attachment_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_attachment_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_attachment_created ADD referrer TEXT;
ALTER TABLE ims_attachment_created ADD request_url TEXT;
ALTER TABLE ims_attachment_deleted ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_attachment_deleted ADD client_ip VARCHAR(39);
ALTER TABLE ims_attachment_deleted ADD referrer TEXT;
ALTER TABLE ims_attachment_deleted ADD request_url TEXT;
ALTER TABLE ims_attachment_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_attachment_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_attachment_updated ADD referrer TEXT;
ALTER TABLE ims_attachment_updated ADD request_url TEXT;
ALTER TABLE ims_course_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_course_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_course_created ADD referrer TEXT;
ALTER TABLE ims_course_created ADD request_url TEXT;
ALTER TABLE ims_discussion_entry_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_discussion_entry_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_discussion_entry_created ADD referrer TEXT;
ALTER TABLE ims_discussion_entry_created ADD request_url TEXT;
ALTER TABLE ims_discussion_topic_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_discussion_topic_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_discussion_topic_created ADD referrer TEXT;
ALTER TABLE ims_discussion_topic_created ADD request_url TEXT;
ALTER TABLE ims_enrollment_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_created ADD referrer TEXT;
ALTER TABLE ims_enrollment_created ADD request_url TEXT;
ALTER TABLE ims_enrollment_state_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_state_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_state_created ADD referrer TEXT;
ALTER TABLE ims_enrollment_state_created ADD request_url TEXT;
ALTER TABLE ims_enrollment_state_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_state_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_state_updated ADD referrer TEXT;
ALTER TABLE ims_enrollment_state_updated ADD request_url TEXT;
ALTER TABLE ims_enrollment_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_updated ADD referrer TEXT;
ALTER TABLE ims_enrollment_updated ADD request_url TEXT;
ALTER TABLE ims_grade_change ADD client_ip VARCHAR(39);
ALTER TABLE ims_grade_change ADD referrer TEXT;
ALTER TABLE ims_grade_change ADD request_url TEXT;
ALTER TABLE ims_group_category_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_group_category_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_group_category_created ADD referrer TEXT;
ALTER TABLE ims_group_category_created ADD request_url TEXT;
ALTER TABLE ims_group_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_group_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_group_created ADD referrer TEXT;
ALTER TABLE ims_group_created ADD request_url TEXT;
ALTER TABLE ims_group_membership_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_group_membership_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_group_membership_created ADD referrer TEXT;
ALTER TABLE ims_group_membership_created ADD request_url TEXT;
ALTER TABLE ims_logged_in ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_logged_in ADD client_ip VARCHAR(39);
ALTER TABLE ims_logged_in ADD referrer TEXT;
ALTER TABLE ims_logged_in ADD request_url TEXT;
ALTER TABLE ims_logged_out ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_logged_out ADD client_ip VARCHAR(39);
ALTER TABLE ims_logged_out ADD referrer TEXT;
ALTER TABLE ims_logged_out ADD request_url TEXT;
ALTER TABLE ims_quiz_submitted ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_quiz_submitted ADD client_ip VARCHAR(39);
ALTER TABLE ims_quiz_submitted ADD referrer TEXT;
ALTER TABLE ims_quiz_submitted ADD request_url TEXT;
ALTER TABLE ims_submission_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_submission_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_submission_created ADD referrer TEXT;
ALTER TABLE ims_submission_created ADD request_url TEXT;
ALTER TABLE ims_submission_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_submission_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_submission_updated ADD referrer TEXT;
ALTER TABLE ims_submission_updated ADD request_url TEXT;
ALTER TABLE ims_syllabus_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_syllabus_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_syllabus_updated ADD referrer TEXT;
ALTER TABLE ims_syllabus_updated ADD request_url TEXT;
ALTER TABLE ims_user_account_association_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_user_account_association_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_user_account_association_created ADD referrer TEXT;
ALTER TABLE ims_user_account_association_created ADD request_url TEXT;
ALTER TABLE ims_wiki_page_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_wiki_page_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_wiki_page_created ADD referrer TEXT;
ALTER TABLE ims_wiki_page_created ADD request_url TEXT;
ALTER TABLE ims_wiki_page_deleted ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_wiki_page_deleted ADD client_ip VARCHAR(39);
ALTER TABLE ims_wiki_page_deleted ADD referrer TEXT;
ALTER TABLE ims_wiki_page_deleted ADD request_url TEXT;
ALTER TABLE ims_wiki_page_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_wiki_page_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_wiki_page_updated ADD referrer TEXT;
ALTER TABLE ims_wiki_page_updated ADD request_url TEXT;

led-caliper-oracle-update.sql

ALTER TABLE ims_asset_accessed ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_asset_accessed ADD client_ip VARCHAR(39);
ALTER TABLE ims_asset_accessed ADD object_asset_name VARCHAR(1000);
ALTER TABLE ims_asset_accessed ADD object_context_account_id VARCHAR(39);
ALTER TABLE ims_asset_accessed ADD object_developer_key_id NUMBER;
ALTER TABLE ims_asset_accessed ADD object_display_name TEXT;
ALTER TABLE ims_asset_accessed ADD object_domain VARCHAR(255);
ALTER TABLE ims_asset_accessed ADD object_filename TEXT;
ALTER TABLE ims_asset_accessed ADD object_http_method VARCHAR(4);
ALTER TABLE ims_asset_accessed ADD object_url TEXT;
ALTER TABLE ims_asset_accessed ADD referrer TEXT;
ALTER TABLE ims_asset_accessed ADD request_url TEXT;
ALTER TABLE ims_assignment_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_assignment_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_assignment_created ADD referrer TEXT;
ALTER TABLE ims_assignment_created ADD request_url TEXT;
ALTER TABLE ims_assignment_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_assignment_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_assignment_updated ADD object_maxscore NUMBER(53);
ALTER TABLE ims_assignment_updated ADD referrer TEXT;
ALTER TABLE ims_assignment_updated ADD request_url TEXT;
ALTER TABLE ims_attachment_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_attachment_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_attachment_created ADD referrer TEXT;
ALTER TABLE ims_attachment_created ADD request_url TEXT;
ALTER TABLE ims_attachment_deleted ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_attachment_deleted ADD client_ip VARCHAR(39);
ALTER TABLE ims_attachment_deleted ADD referrer TEXT;
ALTER TABLE ims_attachment_deleted ADD request_url TEXT;
ALTER TABLE ims_attachment_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_attachment_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_attachment_updated ADD referrer TEXT;
ALTER TABLE ims_attachment_updated ADD request_url TEXT;
ALTER TABLE ims_course_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_course_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_course_created ADD referrer TEXT;
ALTER TABLE ims_course_created ADD request_url TEXT;
ALTER TABLE ims_discussion_entry_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_discussion_entry_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_discussion_entry_created ADD referrer TEXT;
ALTER TABLE ims_discussion_entry_created ADD request_url TEXT;
ALTER TABLE ims_discussion_topic_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_discussion_topic_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_discussion_topic_created ADD referrer TEXT;
ALTER TABLE ims_discussion_topic_created ADD request_url TEXT;
ALTER TABLE ims_enrollment_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_created ADD referrer TEXT;
ALTER TABLE ims_enrollment_created ADD request_url TEXT;
ALTER TABLE ims_enrollment_state_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_state_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_state_created ADD referrer TEXT;
ALTER TABLE ims_enrollment_state_created ADD request_url TEXT;
ALTER TABLE ims_enrollment_state_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_state_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_state_updated ADD referrer TEXT;
ALTER TABLE ims_enrollment_state_updated ADD request_url TEXT;
ALTER TABLE ims_enrollment_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_enrollment_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_enrollment_updated ADD referrer TEXT;
ALTER TABLE ims_enrollment_updated ADD request_url TEXT;
ALTER TABLE ims_grade_change ADD client_ip VARCHAR(39);
ALTER TABLE ims_grade_change ADD referrer TEXT;
ALTER TABLE ims_grade_change ADD request_url TEXT;
ALTER TABLE ims_group_category_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_group_category_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_group_category_created ADD referrer TEXT;
ALTER TABLE ims_group_category_created ADD request_url TEXT;
ALTER TABLE ims_group_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_group_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_group_created ADD referrer TEXT;
ALTER TABLE ims_group_created ADD request_url TEXT;
ALTER TABLE ims_group_membership_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_group_membership_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_group_membership_created ADD referrer TEXT;
ALTER TABLE ims_group_membership_created ADD request_url TEXT;
ALTER TABLE ims_logged_in ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_logged_in ADD client_ip VARCHAR(39);
ALTER TABLE ims_logged_in ADD referrer TEXT;
ALTER TABLE ims_logged_in ADD request_url TEXT;
ALTER TABLE ims_logged_out ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_logged_out ADD client_ip VARCHAR(39);
ALTER TABLE ims_logged_out ADD referrer TEXT;
ALTER TABLE ims_logged_out ADD request_url TEXT;
ALTER TABLE ims_quiz_submitted ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_quiz_submitted ADD client_ip VARCHAR(39);
ALTER TABLE ims_quiz_submitted ADD referrer TEXT;
ALTER TABLE ims_quiz_submitted ADD request_url TEXT;
ALTER TABLE ims_submission_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_submission_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_submission_created ADD referrer TEXT;
ALTER TABLE ims_submission_created ADD request_url TEXT;
ALTER TABLE ims_submission_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_submission_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_submission_updated ADD referrer TEXT;
ALTER TABLE ims_submission_updated ADD request_url TEXT;
ALTER TABLE ims_syllabus_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_syllabus_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_syllabus_updated ADD referrer TEXT;
ALTER TABLE ims_syllabus_updated ADD request_url TEXT;
ALTER TABLE ims_user_account_association_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_user_account_association_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_user_account_association_created ADD referrer TEXT;
ALTER TABLE ims_user_account_association_created ADD request_url TEXT;
ALTER TABLE ims_wiki_page_created ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_wiki_page_created ADD client_ip VARCHAR(39);
ALTER TABLE ims_wiki_page_created ADD referrer TEXT;
ALTER TABLE ims_wiki_page_created ADD request_url TEXT;
ALTER TABLE ims_wiki_page_deleted ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_wiki_page_deleted ADD client_ip VARCHAR(39);
ALTER TABLE ims_wiki_page_deleted ADD referrer TEXT;
ALTER TABLE ims_wiki_page_deleted ADD request_url TEXT;
ALTER TABLE ims_wiki_page_updated ADD actor_user_sis_id VARCHAR(32);
ALTER TABLE ims_wiki_page_updated ADD client_ip VARCHAR(39);
ALTER TABLE ims_wiki_page_updated ADD referrer TEXT;
ALTER TABLE ims_wiki_page_updated ADD request_url TEXT;

schema update for ccsd/ledbelly@54d04d2