320 lines
34 KiB
SQL
320 lines
34 KiB
SQL
UPDATE classes SET display_teacher2 = 'N' WHERE display_teacher2 IS NULL OR display_teacher2 = '';
|
|
UPDATE classes SET display_teacher3 = 'N' WHERE display_teacher3 IS NULL OR display_teacher3 = '';
|
|
UPDATE classes SET display_teacher4 = 'N' WHERE display_teacher4 IS NULL OR display_teacher4 = '';
|
|
UPDATE classes SET display_teacher5 = 'N' WHERE display_teacher5 IS NULL OR display_teacher5 = '';
|
|
UPDATE custom_form_field SET field_required = 'N' WHERE field_required IS NULL OR field_required = '';
|
|
UPDATE custom_form_field SET field_readonly = 'N' WHERE field_readonly IS NULL OR field_readonly = '';
|
|
UPDATE email_send_log SET read_email = 'Y' WHERE read_email IS NULL OR read_email = '';
|
|
UPDATE event_types SET display_on_order_form = 'Y' WHERE display_on_order_form IS NULL OR display_on_order_form = '';
|
|
UPDATE formatted_content SET public_page = 'Y' WHERE public_page IS NULL OR public_page = '';
|
|
UPDATE hotlunch_menu_dates SET menu_type = 'Regular' WHERE menu_type IS NULL OR menu_type = '';
|
|
UPDATE hotlunch_menu_dates SET order_format = 'Quantity' WHERE order_format IS NULL OR order_format = '';
|
|
UPDATE hotlunch_menu_dates SET display_supplier_code = 'N' WHERE display_supplier_code IS NULL OR display_supplier_code = '';
|
|
UPDATE hotlunch_menu_dates SET num_volunteer_override = 'D' WHERE num_volunteer_override IS NULL OR num_volunteer_override = '';
|
|
UPDATE hotlunch_menu_dates SET current_menu_link = 'No' WHERE current_menu_link IS NULL OR current_menu_link = '';
|
|
UPDATE hotlunch_menu_dates SET group_b_a_required = 'N' WHERE group_b_a_required IS NULL OR group_b_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_b_mandatory = 'N' WHERE group_b_mandatory IS NULL OR group_b_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_c_a_required = 'N' WHERE group_c_a_required IS NULL OR group_c_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_c_mandatory = 'N' WHERE group_c_mandatory IS NULL OR group_c_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_d_a_required = 'N' WHERE group_d_a_required IS NULL OR group_d_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_d_mandatory = 'N' WHERE group_d_mandatory IS NULL OR group_d_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_e_a_required = 'N' WHERE group_e_a_required IS NULL OR group_e_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_e_mandatory = 'N' WHERE group_e_mandatory IS NULL OR group_e_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_f_a_required = 'N' WHERE group_f_a_required IS NULL OR group_f_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_f_mandatory = 'N' WHERE group_f_mandatory IS NULL OR group_f_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_g_a_required = 'N' WHERE group_g_a_required IS NULL OR group_g_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_g_mandatory = 'N' WHERE group_g_mandatory IS NULL OR group_g_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_h_a_required = 'N' WHERE group_h_a_required IS NULL OR group_h_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_h_mandatory = 'N' WHERE group_h_mandatory IS NULL OR group_h_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_i_a_required = 'N' WHERE group_i_a_required IS NULL OR group_i_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_i_mandatory = 'N' WHERE group_i_mandatory IS NULL OR group_i_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_j_a_required = 'N' WHERE group_j_a_required IS NULL OR group_j_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_j_mandatory = 'N' WHERE group_j_mandatory IS NULL OR group_j_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_k_a_required = 'N' WHERE group_k_a_required IS NULL OR group_k_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_k_mandatory = 'N' WHERE group_k_mandatory IS NULL OR group_k_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_l_a_required = 'N' WHERE group_l_a_required IS NULL OR group_l_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_l_mandatory = 'N' WHERE group_l_mandatory IS NULL OR group_l_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET group_m_a_required = 'N' WHERE group_m_a_required IS NULL OR group_m_a_required = '';
|
|
UPDATE hotlunch_menu_dates SET group_m_mandatory = 'N' WHERE group_m_mandatory IS NULL OR group_m_mandatory = '';
|
|
UPDATE hotlunch_menu_dates SET display_group_colors = 'D' WHERE display_group_colors IS NULL OR display_group_colors = '';
|
|
UPDATE hotlunch_menu_dates SET display_group_letters = 'D' WHERE display_group_letters IS NULL OR display_group_letters = '';
|
|
UPDATE hotlunch_menu_dates SET active = 'Y' WHERE active IS NULL OR active = '';
|
|
UPDATE hotlunch_menu_dates SET available = 'Y' WHERE available IS NULL OR available = '';
|
|
UPDATE hotlunch_menu_items SET menu_item_format = 'D' WHERE menu_item_format IS NULL OR menu_item_format = '';
|
|
UPDATE hotlunch_menu_items SET active = 'Y' WHERE active IS NULL OR active = '';
|
|
UPDATE hotlunch_menu_items SET display_price = 'Y' WHERE display_price IS NULL OR display_price = '';
|
|
UPDATE hotlunch_menu_items SET taxable_item = 'N' WHERE taxable_item IS NULL OR taxable_item = '';
|
|
UPDATE hotlunch_menu_items SET bc_guideline_rating = 'N/A' WHERE bc_guideline_rating IS NULL OR bc_guideline_rating = '';
|
|
UPDATE hotlunch_menu_items SET max_quantity_by = 'Order' WHERE max_quantity_by IS NULL OR max_quantity_by = '';
|
|
UPDATE hotlunch_menu_items SET menu_group = '' WHERE menu_group IS NULL;
|
|
UPDATE hotlunch_menu_items SET hot_cold_food = 'Hot' WHERE hot_cold_food IS NULL OR hot_cold_food = '';
|
|
UPDATE hotlunch_menu_items SET heading_visibility = 'visible' WHERE heading_visibility IS NULL OR heading_visibility = '';
|
|
UPDATE hotlunch_menu_items SET heading_page_break = 'N' WHERE heading_page_break IS NULL OR heading_page_break = '';
|
|
UPDATE hotlunch_menu_transactions SET type = 'Expense' WHERE type IS NULL OR type = '';
|
|
UPDATE hotlunch_order_change_log SET status = 'Unpaid' WHERE status IS NULL OR status = '';
|
|
UPDATE hotlunch_order_change_log SET price_category = 'Regular' WHERE price_category IS NULL OR price_category = '';
|
|
UPDATE hotlunch_order_header SET ordered_by_type = 'Student' WHERE ordered_by_type IS NULL OR ordered_by_type = '';
|
|
UPDATE hotlunch_order_header SET status = 'Unpaid' WHERE status IS NULL OR status = '';
|
|
UPDATE hotlunch_order_header SET source = 'On-Line' WHERE source IS NULL OR source = '';
|
|
UPDATE hotlunch_order_header SET price_category = 'Regular' WHERE price_category IS NULL OR price_category = '';
|
|
UPDATE hotlunch_order_header SET delivered = 'Y' WHERE delivered IS NULL OR delivered = '';
|
|
UPDATE hotlunch_order_items SET ordered_by_type = 'Student' WHERE ordered_by_type IS NULL OR ordered_by_type = '';
|
|
UPDATE hotlunch_order_items SET taxable_item = 'N' WHERE taxable_item IS NULL OR taxable_item = '';
|
|
UPDATE hotlunch_order_items_save SET taxable_item = 'N' WHERE taxable_item IS NULL OR taxable_item = '';
|
|
UPDATE hotlunch_order_log SET ordered_by_type = 'Student' WHERE ordered_by_type IS NULL OR ordered_by_type = '';
|
|
UPDATE hotlunch_order_log SET payment_method = 'Unpaid' WHERE payment_method IS NULL OR payment_method = '';
|
|
UPDATE hotlunch_order_log SET status = 'Unpaid' WHERE status IS NULL OR status = '';
|
|
UPDATE hotlunch_order_log SET source = 'On-Line' WHERE source IS NULL OR source = '';
|
|
UPDATE hotlunch_order_log SET price_category = 'Regular' WHERE price_category IS NULL OR price_category = '';
|
|
UPDATE hotlunch_schedules SET custom_menu_end_dates = 'N' WHERE custom_menu_end_dates IS NULL OR custom_menu_end_dates = '';
|
|
UPDATE hotlunch_schedules SET display_on_calendar = 'Y' WHERE display_on_calendar IS NULL OR display_on_calendar = '';
|
|
UPDATE hotlunch_schedules SET schedule_print_format = 'All Menus' WHERE schedule_print_format IS NULL OR schedule_print_format = '';
|
|
UPDATE hotlunch_schedules SET hide_unavailable_dates = 'N' WHERE hide_unavailable_dates IS NULL OR hide_unavailable_dates = '';
|
|
UPDATE hotlunch_schedules SET display_instructions = 'Y' WHERE display_instructions IS NULL OR display_instructions = '';
|
|
UPDATE hotlunch_schedules SET volunteer_signup = 'D' WHERE volunteer_signup IS NULL OR volunteer_signup = '';
|
|
UPDATE invoice_payments SET group_with_next = 'N' WHERE group_with_next IS NULL OR group_with_next = '';
|
|
UPDATE people SET sex = 'Male' WHERE sex IS NULL OR sex = '';
|
|
UPDATE people SET additional_permission = 'N' WHERE additional_permission IS NULL OR additional_permission = '';
|
|
UPDATE people SET people_type = 'Student' WHERE people_type IS NULL OR people_type = '';
|
|
UPDATE people SET status = 'Unverified' WHERE status IS NULL OR status = '';
|
|
UPDATE people SET display = 'Y' WHERE display IS NULL OR display = '';
|
|
UPDATE people SET menu_price_category = 'Regular' WHERE menu_price_category IS NULL OR menu_price_category = '';
|
|
UPDATE resellers SET country = 'Canada' WHERE country IS NULL OR country = '';
|
|
UPDATE resellers SET registrants_are = 'Parents' WHERE registrants_are IS NULL OR registrants_are = '';
|
|
UPDATE resellers SET participants_are = 'Students' WHERE participants_are IS NULL OR participants_are = '';
|
|
UPDATE resellers SET participant_grouping = 'Class' WHERE participant_grouping IS NULL OR participant_grouping = '';
|
|
UPDATE resellers SET group_leaders = 'Teachers' WHERE group_leaders IS NULL OR group_leaders = '';
|
|
UPDATE resellers SET system_configuration = 'Full' WHERE system_configuration IS NULL OR system_configuration = '';
|
|
UPDATE resellers SET email_system = 'N' WHERE email_system IS NULL OR email_system = '';
|
|
UPDATE resellers SET other_modules = 'N' WHERE other_modules IS NULL OR other_modules = '';
|
|
UPDATE resellers SET event_calendar = 'N' WHERE event_calendar IS NULL OR event_calendar = '';
|
|
UPDATE resellers SET classified_ads = 'N' WHERE classified_ads IS NULL OR classified_ads = '';
|
|
UPDATE resellers SET photo_gallery = 'N' WHERE photo_gallery IS NULL OR photo_gallery = '';
|
|
UPDATE resellers SET exact_enabled = 'N' WHERE exact_enabled IS NULL OR exact_enabled = '';
|
|
UPDATE resellers SET display_remittance_button = 'Y' WHERE display_remittance_button IS NULL OR display_remittance_button = '';
|
|
UPDATE sales_contacts SET active = 'N' WHERE active IS NULL OR active = '';
|
|
UPDATE school_contact_list SET active = 'Y' WHERE active IS NULL OR active = '';
|
|
UPDATE schools SET starting_grade = 'K' WHERE starting_grade IS NULL OR starting_grade = '';
|
|
UPDATE schools SET ending_grade = '7' WHERE ending_grade IS NULL OR ending_grade = '';
|
|
UPDATE schools SET default_language = 'English' WHERE default_language IS NULL OR default_language = '';
|
|
UPDATE schools SET orders_for = 'Participants' WHERE orders_for IS NULL OR orders_for = '';
|
|
UPDATE schools SET registrants_are = 'Parents' WHERE registrants_are IS NULL OR registrants_are = '';
|
|
UPDATE schools SET participants_are = 'Students' WHERE participants_are IS NULL OR participants_are = '';
|
|
UPDATE schools SET group_leaders = 'Teachers' WHERE group_leaders IS NULL OR group_leaders = '';
|
|
UPDATE schools SET secure_certificate = 'N' WHERE secure_certificate IS NULL OR secure_certificate = '';
|
|
UPDATE schools SET site_active = 'Y' WHERE site_active IS NULL OR site_active = '';
|
|
UPDATE schools SET welcome_email_sent = 'Y' WHERE welcome_email_sent IS NULL OR welcome_email_sent = '';
|
|
UPDATE schools SET followup_email_sent = 'N' WHERE followup_email_sent IS NULL OR followup_email_sent = '';
|
|
UPDATE schools SET demos_scheduled = 'N' WHERE demos_scheduled IS NULL OR demos_scheduled = '';
|
|
UPDATE schools SET testimonial = 'N' WHERE testimonial IS NULL OR testimonial = '';
|
|
UPDATE schools SET renewal_contact = 'N' WHERE renewal_contact IS NULL OR renewal_contact = '';
|
|
UPDATE schools SET data_current_application_contacts = 'N' WHERE data_current_application_contacts IS NULL OR data_current_application_contacts = '';
|
|
UPDATE schools SET data_current_school_contacts = 'N' WHERE data_current_school_contacts IS NULL OR data_current_school_contacts = '';
|
|
UPDATE schools SET display = 'Y' WHERE display IS NULL OR display = '';
|
|
UPDATE schools SET payment_status = 'TBI' WHERE payment_status IS NULL OR payment_status = '';
|
|
UPDATE schools SET data_odd_text = 'Black' WHERE data_odd_text IS NULL OR data_odd_text = '';
|
|
UPDATE schools SET data_even_text = 'Black' WHERE data_even_text IS NULL OR data_even_text = '';
|
|
UPDATE schools SET system_configuration = 'Basic' WHERE system_configuration IS NULL OR system_configuration = '';
|
|
UPDATE schools SET small_school_discount = 'N' WHERE small_school_discount IS NULL OR small_school_discount = '';
|
|
UPDATE schools SET additional_invoice_fee_type = 'Amount' WHERE additional_invoice_fee_type IS NULL OR additional_invoice_fee_type = '';
|
|
UPDATE schools SET display_facebook = 'N' WHERE display_facebook IS NULL OR display_facebook = '';
|
|
UPDATE schools SET email_system = 'N' WHERE email_system IS NULL OR email_system = '';
|
|
UPDATE schools SET email_system_expires = 'Y' WHERE email_system_expires IS NULL OR email_system_expires = '';
|
|
UPDATE schools SET other_modules = 'N' WHERE other_modules IS NULL OR other_modules = '';
|
|
UPDATE schools SET event_calendar = 'N' WHERE event_calendar IS NULL OR event_calendar = '';
|
|
UPDATE schools SET classified_ads = 'N' WHERE classified_ads IS NULL OR classified_ads = '';
|
|
UPDATE schools SET photo_gallery = 'N' WHERE photo_gallery IS NULL OR photo_gallery = '';
|
|
UPDATE schools SET math_worksheets = 'N' WHERE math_worksheets IS NULL OR math_worksheets = '';
|
|
UPDATE schools SET document_admin = 'N' WHERE document_admin IS NULL OR document_admin = '';
|
|
UPDATE schools SET email_processing = 'N' WHERE email_processing IS NULL OR email_processing = '';
|
|
UPDATE schools SET email_broadcast_addresses = 'N' WHERE email_broadcast_addresses IS NULL OR email_broadcast_addresses = '';
|
|
UPDATE schools SET use_access_code = 'N' WHERE use_access_code IS NULL OR use_access_code = '';
|
|
UPDATE schools SET login_form_location = 'Default' WHERE login_form_location IS NULL OR login_form_location = '';
|
|
UPDATE schools SET enable_parent_registration = 'Y' WHERE enable_parent_registration IS NULL OR enable_parent_registration = '';
|
|
UPDATE schools SET registrations_permitted = 'Parent' WHERE registrations_permitted IS NULL OR registrations_permitted = '';
|
|
UPDATE schools SET allow_duplicate_accounts = 'N' WHERE allow_duplicate_accounts IS NULL OR allow_duplicate_accounts = '';
|
|
UPDATE schools SET enable_customers = 'N' WHERE enable_customers IS NULL OR enable_customers = '';
|
|
UPDATE schools SET customer_address = 'Y' WHERE customer_address IS NULL OR customer_address = '';
|
|
UPDATE schools SET customer_phone = 'Y' WHERE customer_phone IS NULL OR customer_phone = '';
|
|
UPDATE schools SET customer_email = 'Y' WHERE customer_email IS NULL OR customer_email = '';
|
|
UPDATE schools SET allow_parent_login = 'Y' WHERE allow_parent_login IS NULL OR allow_parent_login = '';
|
|
UPDATE schools SET allow_guest_login = 'N' WHERE allow_guest_login IS NULL OR allow_guest_login = '';
|
|
UPDATE schools SET enable_participant_registration = 'Y' WHERE enable_participant_registration IS NULL OR enable_participant_registration = '';
|
|
UPDATE schools SET enable_customer_registration = 'N' WHERE enable_customer_registration IS NULL OR enable_customer_registration = '';
|
|
UPDATE schools SET registration_userid = 'Email' WHERE registration_userid IS NULL OR registration_userid = '';
|
|
UPDATE schools SET registration_second_parent = 'Optional' WHERE registration_second_parent IS NULL OR registration_second_parent = '';
|
|
UPDATE schools SET parent_field_titles = 'First and Second Parent' WHERE parent_field_titles IS NULL OR parent_field_titles = '';
|
|
UPDATE schools SET registration_phone = 'Required' WHERE registration_phone IS NULL OR registration_phone = '';
|
|
UPDATE schools SET registration_daytime_phone = 'Optional' WHERE registration_daytime_phone IS NULL OR registration_daytime_phone = '';
|
|
UPDATE schools SET registration_cell_phone = 'Optional' WHERE registration_cell_phone IS NULL OR registration_cell_phone = '';
|
|
UPDATE schools SET registration_email = 'Required' WHERE registration_email IS NULL OR registration_email = '';
|
|
UPDATE schools SET registration_address = 'No' WHERE registration_address IS NULL OR registration_address = '';
|
|
UPDATE schools SET registration_language_selection = 'Y' WHERE registration_language_selection IS NULL OR registration_language_selection = '';
|
|
UPDATE schools SET registration_volunteer_list = 'N' WHERE registration_volunteer_list IS NULL OR registration_volunteer_list = '';
|
|
UPDATE schools SET registration_guest_student_info = 'Y' WHERE registration_guest_student_info IS NULL OR registration_guest_student_info = '';
|
|
UPDATE schools SET send_registation_email_with_paper_orders = 'Y' WHERE send_registation_email_with_paper_orders IS NULL OR send_registation_email_with_paper_orders = '';
|
|
UPDATE schools SET school_directory_permission = 'N' WHERE school_directory_permission IS NULL OR school_directory_permission = '';
|
|
UPDATE schools SET email_list_permission = 'N' WHERE email_list_permission IS NULL OR email_list_permission = '';
|
|
UPDATE schools SET enable_class_parents = 'N' WHERE enable_class_parents IS NULL OR enable_class_parents = '';
|
|
UPDATE schools SET allow_parents_to_edit_students = 'Y' WHERE allow_parents_to_edit_students IS NULL OR allow_parents_to_edit_students = '';
|
|
UPDATE schools SET allow_duplicate_students = 'Y' WHERE allow_duplicate_students IS NULL OR allow_duplicate_students = '';
|
|
UPDATE schools SET collect_student_birthdate = 'N' WHERE collect_student_birthdate IS NULL OR collect_student_birthdate = '';
|
|
UPDATE schools SET collect_student_age = 'N' WHERE collect_student_age IS NULL OR collect_student_age = '';
|
|
UPDATE schools SET collect_student_sex = 'N' WHERE collect_student_sex IS NULL OR collect_student_sex = '';
|
|
UPDATE schools SET collect_student_grade = 'N' WHERE collect_student_grade IS NULL OR collect_student_grade = '';
|
|
UPDATE schools SET collect_student_number = 'N' WHERE collect_student_number IS NULL OR collect_student_number = '';
|
|
UPDATE schools SET collect_permission = 'N' WHERE collect_permission IS NULL OR collect_permission = '';
|
|
UPDATE schools SET p_display_teachers = 'Y' WHERE p_display_teachers IS NULL OR p_display_teachers = '';
|
|
UPDATE schools SET p_display_program = 'N' WHERE p_display_program IS NULL OR p_display_program = '';
|
|
UPDATE schools SET p_display_grade = 'Y' WHERE p_display_grade IS NULL OR p_display_grade = '';
|
|
UPDATE schools SET p_display_division = 'Y' WHERE p_display_division IS NULL OR p_display_division = '';
|
|
UPDATE schools SET p_display_description = 'Y' WHERE p_display_description IS NULL OR p_display_description = '';
|
|
UPDATE schools SET i_display_teachers = 'Y' WHERE i_display_teachers IS NULL OR i_display_teachers = '';
|
|
UPDATE schools SET i_display_program = 'N' WHERE i_display_program IS NULL OR i_display_program = '';
|
|
UPDATE schools SET i_display_grade = 'Y' WHERE i_display_grade IS NULL OR i_display_grade = '';
|
|
UPDATE schools SET i_display_division = 'Y' WHERE i_display_division IS NULL OR i_display_division = '';
|
|
UPDATE schools SET i_display_description = 'Y' WHERE i_display_description IS NULL OR i_display_description = '';
|
|
UPDATE schools SET c_display_name = 'Y' WHERE c_display_name IS NULL OR c_display_name = '';
|
|
UPDATE schools SET c_display_home_phone = 'Y' WHERE c_display_home_phone IS NULL OR c_display_home_phone = '';
|
|
UPDATE schools SET c_display_work_phone = 'Y' WHERE c_display_work_phone IS NULL OR c_display_work_phone = '';
|
|
UPDATE schools SET c_display_cell_phone = 'Y' WHERE c_display_cell_phone IS NULL OR c_display_cell_phone = '';
|
|
UPDATE schools SET c_display_home_email = 'Y' WHERE c_display_home_email IS NULL OR c_display_home_email = '';
|
|
UPDATE schools SET c_display_home_address = 'Y' WHERE c_display_home_address IS NULL OR c_display_home_address = '';
|
|
UPDATE schools SET user_defined_values = 'N' WHERE user_defined_values IS NULL OR user_defined_values = '';
|
|
UPDATE schools SET user_defined_values_required = 'N' WHERE user_defined_values_required IS NULL OR user_defined_values_required = '';
|
|
UPDATE schools SET user_defined_values2 = 'N' WHERE user_defined_values2 IS NULL OR user_defined_values2 = '';
|
|
UPDATE schools SET user_defined_values2_required = 'N' WHERE user_defined_values2_required IS NULL OR user_defined_values2_required = '';
|
|
UPDATE schools SET user_defined_values3 = 'N' WHERE user_defined_values3 IS NULL OR user_defined_values3 = '';
|
|
UPDATE schools SET user_defined_values3_required = 'N' WHERE user_defined_values3_required IS NULL OR user_defined_values3_required = '';
|
|
UPDATE schools SET send_no_order_reminders = 'N' WHERE send_no_order_reminders IS NULL OR send_no_order_reminders = '';
|
|
UPDATE schools SET implement_diet_requests = 'N' WHERE implement_diet_requests IS NULL OR implement_diet_requests = '';
|
|
UPDATE schools SET class_sort = 'asc' WHERE class_sort IS NULL OR class_sort = '';
|
|
UPDATE schools SET menu_dates_on_holidays = 'N' WHERE menu_dates_on_holidays IS NULL OR menu_dates_on_holidays = '';
|
|
UPDATE schools SET staff_userid = 'names' WHERE staff_userid IS NULL OR staff_userid = '';
|
|
UPDATE schools SET staff_titles = 'N' WHERE staff_titles IS NULL OR staff_titles = '';
|
|
UPDATE schools SET default_staff_language = 'English' WHERE default_staff_language IS NULL OR default_staff_language = '';
|
|
UPDATE schools SET staff_meals_to_classroom = 'Y' WHERE staff_meals_to_classroom IS NULL OR staff_meals_to_classroom = '';
|
|
UPDATE schools SET staff_can_have_children = 'Y' WHERE staff_can_have_children IS NULL OR staff_can_have_children = '';
|
|
UPDATE schools SET display_staff_list = 'Y' WHERE display_staff_list IS NULL OR display_staff_list = '';
|
|
UPDATE schools SET display_class_lists = 'N' WHERE display_class_lists IS NULL OR display_class_lists = '';
|
|
UPDATE schools SET display_pac_info = 'N' WHERE display_pac_info IS NULL OR display_pac_info = '';
|
|
UPDATE schools SET display_parent_instructions = 'Y' WHERE display_parent_instructions IS NULL OR display_parent_instructions = '';
|
|
UPDATE schools SET allow_userid_change = 'N' WHERE allow_userid_change IS NULL OR allow_userid_change = '';
|
|
UPDATE schools SET display_students_button = 'Bottom' WHERE display_students_button IS NULL OR display_students_button = '';
|
|
UPDATE schools SET display_user_account_balance = 'Y' WHERE display_user_account_balance IS NULL OR display_user_account_balance = '';
|
|
UPDATE schools SET balance_calculation_for = 'All' WHERE balance_calculation_for IS NULL OR balance_calculation_for = '';
|
|
UPDATE schools SET allow_ordering_with_balance_owing = 'Y' WHERE allow_ordering_with_balance_owing IS NULL OR allow_ordering_with_balance_owing = '';
|
|
UPDATE schools SET previous_balances_post = 'Post Automatically' WHERE previous_balances_post IS NULL OR previous_balances_post = '';
|
|
UPDATE schools SET implement_generated_charge = 'N' WHERE implement_generated_charge IS NULL OR implement_generated_charge = '';
|
|
UPDATE schools SET generated_charge_occurrence = 'Once' WHERE generated_charge_occurrence IS NULL OR generated_charge_occurrence = '';
|
|
UPDATE schools SET implement_generated_credit = 'N' WHERE implement_generated_credit IS NULL OR implement_generated_credit = '';
|
|
UPDATE schools SET generated_credit_occurrence = 'Once' WHERE generated_credit_occurrence IS NULL OR generated_credit_occurrence = '';
|
|
UPDATE schools SET verified_only_class_list = 'Y' WHERE verified_only_class_list IS NULL OR verified_only_class_list = '';
|
|
UPDATE schools SET allow_edit_of_paid_orders = 'N' WHERE allow_edit_of_paid_orders IS NULL OR allow_edit_of_paid_orders = '';
|
|
UPDATE schools SET allow_edit_of_complimentary_orders = 'N' WHERE allow_edit_of_complimentary_orders IS NULL OR allow_edit_of_complimentary_orders = '';
|
|
UPDATE schools SET enable_substution_requests = 'N' WHERE enable_substution_requests IS NULL OR enable_substution_requests = '';
|
|
UPDATE schools SET schedule_sort = 'asc' WHERE schedule_sort IS NULL OR schedule_sort = '';
|
|
UPDATE schools SET special_item_prices = 'Y' WHERE special_item_prices IS NULL OR special_item_prices = '';
|
|
UPDATE schools SET complimentary_item_processing = 'Y' WHERE complimentary_item_processing IS NULL OR complimentary_item_processing = '';
|
|
UPDATE schools SET taxable_items = 'None' WHERE taxable_items IS NULL OR taxable_items = '';
|
|
UPDATE schools SET display_bc_food_guidelines = 'N' WHERE display_bc_food_guidelines IS NULL OR display_bc_food_guidelines = '';
|
|
UPDATE schools SET label_print_school_name = 'Y' WHERE label_print_school_name IS NULL OR label_print_school_name = '';
|
|
UPDATE schools SET label_separate_options = 'Y' WHERE label_separate_options IS NULL OR label_separate_options = '';
|
|
UPDATE schools SET enable_volunteer_management = 'N' WHERE enable_volunteer_management IS NULL OR enable_volunteer_management = '';
|
|
UPDATE schools SET send_volunteer_reminders = 'N' WHERE send_volunteer_reminders IS NULL OR send_volunteer_reminders = '';
|
|
UPDATE schools SET volunteer_sorting = 'Last Name' WHERE volunteer_sorting IS NULL OR volunteer_sorting = '';
|
|
UPDATE schools SET include_volunteer_details = 'Y' WHERE include_volunteer_details IS NULL OR include_volunteer_details = '';
|
|
UPDATE schools SET display_group_colors = 'Y' WHERE display_group_colors IS NULL OR display_group_colors = '';
|
|
UPDATE schools SET display_group_letters = 'Y' WHERE display_group_letters IS NULL OR display_group_letters = '';
|
|
UPDATE schools SET cafeteria_ordering = 'N' WHERE cafeteria_ordering IS NULL OR cafeteria_ordering = '';
|
|
UPDATE schools SET implement_meal_locations = 'N' WHERE implement_meal_locations IS NULL OR implement_meal_locations = '';
|
|
UPDATE schools SET delivery_report_students = 'With Orders' WHERE delivery_report_students IS NULL OR delivery_report_students = '';
|
|
UPDATE schools SET delivery_report_staff = 'Y' WHERE delivery_report_staff IS NULL OR delivery_report_staff = '';
|
|
UPDATE schools SET delivery_report_row_height = 'Normal' WHERE delivery_report_row_height IS NULL OR delivery_report_row_height = '';
|
|
UPDATE schools SET paper_order_form_size = 'Letter' WHERE paper_order_form_size IS NULL OR paper_order_form_size = '';
|
|
UPDATE schools SET paper_order_form_name_fields = 'First' WHERE paper_order_form_name_fields IS NULL OR paper_order_form_name_fields = '';
|
|
UPDATE schools SET directory_sort = 'Class' WHERE directory_sort IS NULL OR directory_sort = '';
|
|
UPDATE schools SET implement_delivery_groups = 'N' WHERE implement_delivery_groups IS NULL OR implement_delivery_groups = '';
|
|
UPDATE schools SET meal_ticket_headers = 'Once per Page' WHERE meal_ticket_headers IS NULL OR meal_ticket_headers = '';
|
|
UPDATE schools SET include_revenue_in_details_csv = 'Y' WHERE include_revenue_in_details_csv IS NULL OR include_revenue_in_details_csv = '';
|
|
UPDATE schools SET schedule_team_access_reports = 'Y' WHERE schedule_team_access_reports IS NULL OR schedule_team_access_reports = '';
|
|
UPDATE schools SET allow_staff_to_post_payments = 'Y' WHERE allow_staff_to_post_payments IS NULL OR allow_staff_to_post_payments = '';
|
|
UPDATE schools SET schedule_required_on_post = 'Y' WHERE schedule_required_on_post IS NULL OR schedule_required_on_post = '';
|
|
UPDATE schools SET post_with_recent_schedule = 'Y' WHERE post_with_recent_schedule IS NULL OR post_with_recent_schedule = '';
|
|
UPDATE schools SET select_orders_on_post = 'Y' WHERE select_orders_on_post IS NULL OR select_orders_on_post = '';
|
|
UPDATE schools SET select_transactions_on_post = 'Y' WHERE select_transactions_on_post IS NULL OR select_transactions_on_post = '';
|
|
UPDATE schools SET send_payment_notification = 'Y' WHERE send_payment_notification IS NULL OR send_payment_notification = '';
|
|
UPDATE schools SET send_order_email = 'No' WHERE send_order_email IS NULL OR send_order_email = '';
|
|
UPDATE schools SET allow_account_deposits = 'N' WHERE allow_account_deposits IS NULL OR allow_account_deposits = '';
|
|
UPDATE schools SET paypal_enabled = 'N' WHERE paypal_enabled IS NULL OR paypal_enabled = '';
|
|
UPDATE schools SET paypal_verified = 'N' WHERE paypal_verified IS NULL OR paypal_verified = '';
|
|
UPDATE schools SET paypal_mode = 'Live' WHERE paypal_mode IS NULL OR paypal_mode = '';
|
|
UPDATE schools SET paypal_donation = 'N' WHERE paypal_donation IS NULL OR paypal_donation = '';
|
|
UPDATE schools SET bambora_enabled = 'N' WHERE bambora_enabled IS NULL OR bambora_enabled = '';
|
|
UPDATE schools SET display_bambora_form = 'Immediately' WHERE display_bambora_form IS NULL OR display_bambora_form = '';
|
|
UPDATE schools SET exact_enabled = 'N' WHERE exact_enabled IS NULL OR exact_enabled = '';
|
|
UPDATE schools SET school_account_enabled = 'N' WHERE school_account_enabled IS NULL OR school_account_enabled = '';
|
|
UPDATE schools SET check_register_sort = 'Date' WHERE check_register_sort IS NULL OR check_register_sort = '';
|
|
UPDATE schools SET display_remittance_button = 'Y' WHERE display_remittance_button IS NULL OR display_remittance_button = '';
|
|
UPDATE schools SET accept_check = 'Y' WHERE accept_check IS NULL OR accept_check = '';
|
|
UPDATE schools SET accept_cash = 'Y' WHERE accept_cash IS NULL OR accept_cash = '';
|
|
UPDATE schools SET display_remittance_msg_with_button = 'Y' WHERE display_remittance_msg_with_button IS NULL OR display_remittance_msg_with_button = '';
|
|
UPDATE schools SET display_print_order_button = 'Y' WHERE display_print_order_button IS NULL OR display_print_order_button = '';
|
|
UPDATE schools SET calculate_supplier_costs = 'Y' WHERE calculate_supplier_costs IS NULL OR calculate_supplier_costs = '';
|
|
UPDATE schools SET supplier_costs_decimals = '2' WHERE supplier_costs_decimals IS NULL OR supplier_costs_decimals = '';
|
|
UPDATE schools SET default_student_status = 'Unverified' WHERE default_student_status IS NULL OR default_student_status = '';
|
|
UPDATE schools SET default_order_status = 'Unpaid' WHERE default_order_status IS NULL OR default_order_status = '';
|
|
UPDATE schools SET default_order_status_special1 = 'Unpaid' WHERE default_order_status_special1 IS NULL OR default_order_status_special1 = '';
|
|
UPDATE schools SET default_order_status_special2 = 'Unpaid' WHERE default_order_status_special2 IS NULL OR default_order_status_special2 = '';
|
|
UPDATE schools SET default_order_status_special3 = 'Unpaid' WHERE default_order_status_special3 IS NULL OR default_order_status_special3 = '';
|
|
UPDATE schools SET default_event_status = 'Entered' WHERE default_event_status IS NULL OR default_event_status = '';
|
|
UPDATE schools SET can_parents_post_events = 'Y' WHERE can_parents_post_events IS NULL OR can_parents_post_events = '';
|
|
UPDATE schools SET public_event_calendar = 'Y' WHERE public_event_calendar IS NULL OR public_event_calendar = '';
|
|
UPDATE schools SET default_classified_status = 'Approved' WHERE default_classified_status IS NULL OR default_classified_status = '';
|
|
UPDATE schools SET implement_page_tabs = 'N' WHERE implement_page_tabs IS NULL OR implement_page_tabs = '';
|
|
UPDATE schools SET email_broadcast_optional = 'N' WHERE email_broadcast_optional IS NULL OR email_broadcast_optional = '';
|
|
UPDATE schools SET email_reminder_optional = 'N' WHERE email_reminder_optional IS NULL OR email_reminder_optional = '';
|
|
UPDATE schools SET email_reminder_description = 'N' WHERE email_reminder_description IS NULL OR email_reminder_description = '';
|
|
UPDATE schools SET email_reminders_to = 'Everyone' WHERE email_reminders_to IS NULL OR email_reminders_to = '';
|
|
UPDATE schools SET payment_detail = 'Y' WHERE payment_detail IS NULL OR payment_detail = '';
|
|
UPDATE schools SET renewal_invoice_issued = 'N' WHERE renewal_invoice_issued IS NULL OR renewal_invoice_issued = '';
|
|
UPDATE schools SET renewal_invoice_paid = 'N' WHERE renewal_invoice_paid IS NULL OR renewal_invoice_paid = '';
|
|
UPDATE staff_categories SET has_home_room = 'Y' WHERE has_home_room IS NULL OR has_home_room = '';
|
|
UPDATE staff_categories SET display_on_staff_list = 'Y' WHERE display_on_staff_list IS NULL OR display_on_staff_list = '';
|
|
UPDATE supplier_products SET product_type = 'Product' WHERE product_type IS NULL OR product_type = '';
|
|
UPDATE supplier_products SET status = 'Active' WHERE status IS NULL OR status = '';
|
|
UPDATE supplier_products SET taxable_product = 'N' WHERE taxable_product IS NULL OR taxable_product = '';
|
|
UPDATE supplier_products SET bc_guideline_rating = 'N/A' WHERE bc_guideline_rating IS NULL OR bc_guideline_rating = '';
|
|
UPDATE supplier_products SET hot_cold_food = 'Hot' WHERE hot_cold_food IS NULL OR hot_cold_food = '';
|
|
UPDATE suppliers SET calculate_supplier_costs = 'Y' WHERE calculate_supplier_costs IS NULL OR calculate_supplier_costs = '';
|
|
UPDATE suppliers SET generate_delivery_sheet = 'Y' WHERE generate_delivery_sheet IS NULL OR generate_delivery_sheet = '';
|
|
UPDATE suppliers SET generate_options_report = 'Y' WHERE generate_options_report IS NULL OR generate_options_report = '';
|
|
UPDATE suppliers SET class_info_print = 'Class Information' WHERE class_info_print IS NULL OR class_info_print = '';
|
|
UPDATE suppliers SET taxable_order = 'N' WHERE taxable_order IS NULL OR taxable_order = '';
|
|
UPDATE suppliers SET copy_flag = 'N' WHERE copy_flag IS NULL OR copy_flag = '';
|
|
UPDATE user_account SET transaction_status = 'Open' WHERE transaction_status IS NULL OR transaction_status = '';
|
|
UPDATE user_account SET deleted = 'N' WHERE deleted IS NULL OR deleted = '';
|
|
UPDATE user_account_detail SET receipt_status = 'Open' WHERE receipt_status IS NULL OR receipt_status = '';
|
|
UPDATE user_account_trx_codes SET editable = 'N' WHERE editable IS NULL OR editable = '';
|
|
UPDATE user_exact_transactions SET posting_result = 'Posted' WHERE posting_result IS NULL OR posting_result = '';
|
|
UPDATE user_paypal_transactions SET current_year = 'Y' WHERE current_year IS NULL OR current_year = '';
|
|
UPDATE users SET include_email1_on_list = 'N' WHERE include_email1_on_list IS NULL OR include_email1_on_list = '';
|
|
UPDATE users SET include_email2_on_list = 'N' WHERE include_email2_on_list IS NULL OR include_email2_on_list = '';
|
|
UPDATE users SET include_email3_on_list = 'N' WHERE include_email3_on_list IS NULL OR include_email3_on_list = '';
|
|
UPDATE users SET email1_verified = 'Y' WHERE email1_verified IS NULL OR email1_verified = '';
|
|
UPDATE users SET email2_verified = 'Y' WHERE email2_verified IS NULL OR email2_verified = '';
|
|
UPDATE users SET email3_verified = 'Y' WHERE email3_verified IS NULL OR email3_verified = '';
|
|
UPDATE users SET status = 'Active' WHERE status IS NULL OR status = '';
|
|
UPDATE users SET can_order = 'B' WHERE can_order IS NULL OR can_order = '';
|
|
UPDATE users SET has_order = 'Y' WHERE has_order IS NULL OR has_order = '';
|
|
UPDATE users SET source = 'On-Line' WHERE source IS NULL OR source = '';
|
|
UPDATE users SET receive_emails = 'Y' WHERE receive_emails IS NULL OR receive_emails = '';
|
|
UPDATE users SET email_reminders = 'Y' WHERE email_reminders IS NULL OR email_reminders = '';
|
|
UPDATE users SET email_flag = 'Y' WHERE email_flag IS NULL OR email_flag = '';
|
|
UPDATE users SET available_to_volunteer = 'N' WHERE available_to_volunteer IS NULL OR available_to_volunteer = '';
|
|
UPDATE users SET class_parent = 'N' WHERE class_parent IS NULL OR class_parent = '';
|
|
UPDATE users SET school_directory = 'N' WHERE school_directory IS NULL OR school_directory = '';
|
|
UPDATE users SET email_list = 'N' WHERE email_list IS NULL OR email_list = '';
|
|
UPDATE users SET enable_translation = 'Y' WHERE enable_translation IS NULL OR enable_translation = '';
|
|
UPDATE users SET linked_to_type = 'Student' WHERE linked_to_type IS NULL OR linked_to_type = '';
|