install2.sql

DROP TABLE IF EXISTS `ocp_db_meta`;

CREATE TABLE `ocp_db_meta` (
  `m_table` varchar(80) NOT NULL,
  `m_name` varchar(80) NOT NULL,
  `m_type` varchar(80) NOT NULL,
  PRIMARY KEY (`m_table`,`m_name`),
  KEY `findtransfields` (`m_type`)
) ENGINE=MyISAM CHARACTER SET=latin1;

insert into `ocp_db_meta` values('translate','id','*AUTO'),
 ('translate','language','*LANGUAGE_NAME'),
 ('translate','importance_level','SHORT_INTEGER'),
 ('translate','text_original','LONG_TEXT'),
 ('translate','text_parsed','LONG_TEXT'),
 ('translate','broken','BINARY'),
 ('translate','source_user','USER'),
 ('values','the_name','*ID_TEXT'),
 ('values','the_value','ID_TEXT'),
 ('values','date_and_time','TIME'),
 ('config','the_name','*ID_TEXT'),
 ('config','human_name','ID_TEXT'),
 ('config','c_set','BINARY'),
 ('config','config_value','LONG_TEXT'),
 ('config','the_type','ID_TEXT'),
 ('config','eval','SHORT_TEXT'),
 ('config','the_page','ID_TEXT'),
 ('config','section','ID_TEXT'),
 ('config','explanation','ID_TEXT'),
 ('config','shared_hosting_restricted','BINARY'),
 ('config','c_data','SHORT_TEXT'),
 ('gsp','group_id','*INTEGER'),
 ('gsp','specific_permission','*ID_TEXT'),
 ('gsp','the_page','*ID_TEXT'),
 ('gsp','module_the_name','*ID_TEXT'),
 ('gsp','category_name','*ID_TEXT'),
 ('gsp','the_value','BINARY'),
 ('sp_list','p_section','ID_TEXT'),
 ('sp_list','the_name','*ID_TEXT'),
 ('sp_list','the_default','*BINARY'),
 ('attachments','id','*AUTO'),
 ('attachments','a_member_id','USER'),
 ('attachments','a_file_size','?INTEGER'),
 ('attachments','a_url','SHORT_TEXT'),
 ('attachments','a_description','SHORT_TEXT'),
 ('attachments','a_thumb_url','SHORT_TEXT'),
 ('attachments','a_original_filename','SHORT_TEXT'),
 ('attachments','a_num_downloads','INTEGER'),
 ('attachments','a_last_downloaded_time','?INTEGER'),
 ('attachments','a_add_time','INTEGER'),
 ('attachment_refs','id','*AUTO'),
 ('attachment_refs','r_referer_type','ID_TEXT'),
 ('attachment_refs','r_referer_id','ID_TEXT'),
 ('attachment_refs','a_id','AUTO_LINK'),
 ('zones','zone_name','*ID_TEXT'),
 ('zones','zone_title','SHORT_TRANS'),
 ('zones','zone_default_page','ID_TEXT'),
 ('zones','zone_header_text','SHORT_TRANS'),
 ('zones','zone_theme','ID_TEXT'),
 ('zones','zone_wide','?BINARY'),
 ('zones','zone_require_session','BINARY'),
 ('zones','zone_displayed_in_menu','BINARY'),
 ('modules','module_the_name','*ID_TEXT'),
 ('modules','module_author','ID_TEXT'),
 ('modules','module_organisation','ID_TEXT'),
 ('modules','module_hacked_by','ID_TEXT'),
 ('modules','module_hack_version','?INTEGER'),
 ('modules','module_version','INTEGER'),
 ('blocks','block_name','*ID_TEXT'),
 ('blocks','block_author','ID_TEXT'),
 ('blocks','block_organisation','ID_TEXT'),
 ('blocks','block_hacked_by','ID_TEXT'),
 ('blocks','block_hack_version','?INTEGER'),
 ('blocks','block_version','INTEGER'),
 ('sessions','the_session','*INTEGER'),
 ('sessions','last_activity','TIME'),
 ('sessions','the_user','USER'),
 ('sessions','ip','IP'),
 ('sessions','session_confirmed','BINARY'),
 ('sessions','session_invisible','BINARY'),
 ('sessions','cache_username','SHORT_TEXT'),
 ('sessions','the_zone','ID_TEXT'),
 ('sessions','the_page','ID_TEXT'),
 ('sessions','the_type','ID_TEXT'),
 ('sessions','the_id','ID_TEXT'),
 ('sessions','the_title','SHORT_TEXT'),
 ('https_pages','https_page_name','*ID_TEXT'),
 ('group_category_access','module_the_name','*ID_TEXT'),
 ('group_category_access','category_name','*ID_TEXT'),
 ('group_category_access','group_id','*GROUP'),
 ('seo_meta','id','*AUTO'),
 ('seo_meta','meta_for_type','ID_TEXT'),
 ('seo_meta','meta_for_id','ID_TEXT'),
 ('seo_meta','meta_keywords','LONG_TRANS'),
 ('seo_meta','meta_description','LONG_TRANS'),
 ('f_member_cpf_perms','member_id','*USER'),
 ('f_member_cpf_perms','field_id','*AUTO_LINK'),
 ('f_member_cpf_perms','guest_view','BINARY'),
 ('f_member_cpf_perms','member_view','BINARY'),
 ('f_member_cpf_perms','friend_view','BINARY'),
 ('f_member_cpf_perms','group_view','SHORT_TEXT'),
 ('f_emoticons','e_code','*ID_TEXT'),
 ('f_emoticons','e_theme_img_code','SHORT_TEXT'),
 ('f_emoticons','e_relevance_level','INTEGER'),
 ('f_emoticons','e_use_topics','BINARY'),
 ('f_emoticons','e_is_special','BINARY'),
 ('f_custom_fields','id','*AUTO'),
 ('f_custom_fields','cf_locked','BINARY'),
 ('f_custom_fields','cf_name','SHORT_TRANS'),
 ('f_custom_fields','cf_description','SHORT_TRANS'),
 ('f_custom_fields','cf_default','LONG_TEXT'),
 ('f_custom_fields','cf_public_view','BINARY'),
 ('f_custom_fields','cf_owner_view','BINARY'),
 ('f_custom_fields','cf_owner_set','BINARY'),
 ('f_custom_fields','cf_type','ID_TEXT'),
 ('f_custom_fields','cf_required','BINARY'),
 ('f_custom_fields','cf_show_in_posts','BINARY'),
 ('f_custom_fields','cf_show_in_post_previews','BINARY'),
 ('f_custom_fields','cf_order','INTEGER'),
 ('f_custom_fields','cf_only_group','LONG_TEXT'),
 ('f_custom_fields','cf_encrypted','BINARY'),
 ('f_custom_fields','cf_show_on_join_form','BINARY'),
 ('f_member_custom_fields','mf_member_id','*USER'),
 ('f_member_custom_fields','field_1','LONG_TRANS'),
 ('f_member_custom_fields','field_2','SHORT_TEXT'),
 ('f_member_custom_fields','field_3','LONG_TRANS'),
 ('f_member_custom_fields','field_4','LONG_TRANS'),
 ('f_member_custom_fields','field_5','LONG_TRANS'),
 ('f_member_custom_fields','field_6','LONG_TRANS'),
 ('f_member_custom_fields','field_7','SHORT_TEXT'),
 ('f_member_custom_fields','field_8','SHORT_TEXT'),
 ('f_member_custom_fields','field_9','LONG_TRANS'),
 ('f_invites','id','*AUTO'),
 ('f_invites','i_inviter','USER'),
 ('f_invites','i_email_address','SHORT_TEXT'),
 ('f_invites','i_time','TIME'),
 ('f_invites','i_taken','BINARY'),
 ('f_group_members','gm_group_id','*GROUP'),
 ('f_group_members','gm_member_id','*USER'),
 ('f_group_members','gm_validated','BINARY'),
 ('f_members','id','*AUTO'),
 ('f_members','m_username','ID_TEXT'),
 ('f_members','m_pass_hash_salted','SHORT_TEXT'),
 ('f_members','m_pass_salt','SHORT_TEXT'),
 ('f_members','m_theme','ID_TEXT'),
 ('f_members','m_avatar_url','URLPATH'),
 ('f_members','m_validated','BINARY'),
 ('f_members','m_validated_email_confirm_code','SHORT_TEXT'),
 ('f_members','m_cache_num_posts','INTEGER'),
 ('f_members','m_cache_warnings','INTEGER'),
 ('f_members','m_join_time','TIME'),
 ('f_members','m_timezone_offset','SHORT_TEXT'),
 ('f_members','m_primary_group','GROUP'),
 ('f_members','m_last_visit_time','TIME'),
 ('f_members','m_last_submit_time','TIME'),
 ('f_members','m_signature','LONG_TRANS'),
 ('f_members','m_is_perm_banned','BINARY'),
 ('f_members','m_preview_posts','BINARY'),
 ('f_members','m_dob_day','?INTEGER'),
 ('f_members','m_dob_month','?INTEGER'),
 ('f_members','m_dob_year','?INTEGER'),
 ('f_members','m_reveal_age','BINARY'),
 ('f_members','m_email_address','SHORT_TEXT'),
 ('f_members','m_title','SHORT_TEXT'),
 ('f_members','m_photo_url','URLPATH'),
 ('f_members','m_photo_thumb_url','URLPATH'),
 ('f_members','m_views_signatures','BINARY'),
 ('f_members','m_auto_monitor_contrib_content','BINARY'),
 ('f_members','m_language','ID_TEXT'),
 ('f_members','m_ip_address','IP'),
 ('f_members','m_allow_emails','BINARY'),
 ('f_members','m_allow_emails_from_staff','BINARY'),
 ('f_members','m_notes','LONG_TEXT'),
 ('f_members','m_zone_wide','BINARY'),
 ('f_members','m_highlighted_name','BINARY'),
 ('f_members','m_pt_allow','SHORT_TEXT'),
 ('f_members','m_pt_rules_text','LONG_TRANS'),
 ('f_members','m_max_email_attach_size_mb','INTEGER'),
 ('f_members','m_password_change_code','SHORT_TEXT'),
 ('f_members','m_password_compat_scheme','ID_TEXT'),
 ('f_members','m_on_probation_until','?TIME'),
 ('f_groups','id','*AUTO'),
 ('f_groups','g_name','SHORT_TRANS'),
 ('f_groups','g_is_default','BINARY'),
 ('f_groups','g_is_presented_at_install','BINARY'),
 ('f_groups','g_is_super_admin','BINARY'),
 ('f_groups','g_is_super_moderator','BINARY'),
 ('f_groups','g_group_leader','?USER'),
 ('f_groups','g_title','SHORT_TRANS'),
 ('f_groups','g_promotion_target','?GROUP'),
 ('f_groups','g_promotion_threshold','?INTEGER'),
 ('f_groups','g_flood_control_submit_secs','INTEGER'),
 ('f_groups','g_flood_control_access_secs','INTEGER'),
 ('f_groups','g_gift_points_base','INTEGER'),
 ('f_groups','g_gift_points_per_day','INTEGER'),
 ('f_groups','g_max_daily_upload_mb','INTEGER'),
 ('f_groups','g_max_attachments_per_post','INTEGER'),
 ('f_groups','g_max_avatar_width','INTEGER'),
 ('f_groups','g_max_avatar_height','INTEGER'),
 ('f_groups','g_max_post_length_comcode','INTEGER'),
 ('f_groups','g_max_sig_length_comcode','INTEGER'),
 ('f_groups','g_enquire_on_new_ips','BINARY'),
 ('f_groups','g_rank_image','ID_TEXT'),
 ('f_groups','g_hidden','BINARY'),
 ('f_groups','g_order','INTEGER'),
 ('f_groups','g_rank_image_pri_only','BINARY'),
 ('f_groups','g_open_membership','BINARY'),
 ('f_groups','g_is_private_club','BINARY'),
 ('group_page_access','page_name','*ID_TEXT'),
 ('match_key_messages','id','*AUTO'),
 ('match_key_messages','k_message','LONG_TRANS'),
 ('match_key_messages','k_match_key','SHORT_TEXT'),
 ('group_zone_access','zone_name','*ID_TEXT'),
 ('group_zone_access','group_id','*GROUP'),
 ('f_categories','id','*AUTO'),
 ('f_categories','c_title','SHORT_TEXT'),
 ('f_categories','c_description','LONG_TEXT'),
 ('f_categories','c_expanded_by_default','BINARY'),
 ('f_forums','id','*AUTO'),
 ('f_forums','f_name','SHORT_TEXT'),
 ('f_forums','f_description','LONG_TRANS'),
 ('f_forums','f_category_id','?AUTO_LINK'),
 ('f_forums','f_parent_forum','?AUTO_LINK'),
 ('f_forums','f_position','INTEGER'),
 ('f_forums','f_order_sub_alpha','BINARY'),
 ('f_forums','f_post_count_increment','BINARY'),
 ('f_forums','f_intro_question','LONG_TRANS'),
 ('f_forums','f_intro_answer','SHORT_TEXT'),
 ('f_forums','f_cache_num_topics','INTEGER'),
 ('f_forums','f_cache_num_posts','INTEGER'),
 ('f_forums','f_cache_last_topic_id','?AUTO_LINK'),
 ('f_forums','f_cache_last_title','SHORT_TEXT'),
 ('f_forums','f_cache_last_time','?TIME'),
 ('f_forums','f_cache_last_username','SHORT_TEXT'),
 ('f_forums','f_cache_last_member_id','?USER'),
 ('f_forums','f_cache_last_forum_id','?AUTO_LINK'),
 ('f_forums','f_redirection','SHORT_TEXT'),
 ('f_forums','f_order','ID_TEXT'),
 ('f_forums','f_is_threaded','BINARY'),
 ('f_topics','id','*AUTO'),
 ('f_topics','t_pinned','BINARY'),
 ('f_topics','t_sunk','BINARY'),
 ('f_topics','t_cascading','BINARY'),
 ('f_topics','t_forum_id','?AUTO_LINK'),
 ('f_topics','t_pt_from','?USER'),
 ('f_topics','t_pt_to','?USER'),
 ('f_topics','t_pt_from_category','SHORT_TEXT'),
 ('f_topics','t_pt_to_category','SHORT_TEXT'),
 ('f_topics','t_description','SHORT_TEXT'),
 ('f_topics','t_description_link','SHORT_TEXT'),
 ('f_topics','t_emoticon','SHORT_TEXT'),
 ('f_topics','t_num_views','INTEGER'),
 ('f_topics','t_validated','BINARY'),
 ('f_topics','t_is_open','BINARY'),
 ('f_topics','t_poll_id','?AUTO_LINK'),
 ('f_topics','t_cache_first_post_id','?AUTO_LINK'),
 ('f_topics','t_cache_first_time','?TIME'),
 ('f_topics','t_cache_first_title','SHORT_TEXT'),
 ('f_topics','t_cache_first_post','?LONG_TRANS'),
 ('f_topics','t_cache_first_username','ID_TEXT'),
 ('f_topics','t_cache_first_member_id','?USER'),
 ('f_topics','t_cache_last_post_id','?AUTO_LINK'),
 ('f_topics','t_cache_last_time','?TIME'),
 ('f_topics','t_cache_last_title','SHORT_TEXT'),
 ('f_topics','t_cache_last_username','ID_TEXT'),
 ('f_topics','t_cache_last_member_id','?USER'),
 ('f_topics','t_cache_num_posts','INTEGER'),
 ('f_posts','id','*AUTO'),
 ('f_posts','p_title','SHORT_TEXT'),
 ('f_posts','p_post','LONG_TRANS'),
 ('f_posts','p_ip_address','IP'),
 ('f_posts','p_time','TIME'),
 ('f_posts','p_poster','USER'),
 ('f_posts','p_intended_solely_for','?USER'),
 ('f_posts','p_poster_name_if_guest','ID_TEXT'),
 ('f_posts','p_validated','BINARY'),
 ('f_posts','p_topic_id','AUTO_LINK'),
 ('f_posts','p_cache_forum_id','?AUTO_LINK'),
 ('f_posts','p_last_edit_time','?TIME'),
 ('f_posts','p_last_edit_by','?USER'),
 ('f_posts','p_is_emphasised','BINARY'),
 ('f_posts','p_skip_sig','BINARY'),
 ('f_posts','p_parent_id','?AUTO_LINK'),
 ('f_special_pt_access','s_member_id','*USER'),
 ('f_special_pt_access','s_topic_id','*AUTO_LINK'),
 ('f_saved_warnings','s_title','*SHORT_TEXT'),
 ('f_saved_warnings','s_explanation','LONG_TEXT'),
 ('f_saved_warnings','s_message','LONG_TEXT'),
 ('f_post_history','id','*AUTO'),
 ('f_post_history','h_create_date_and_time','TIME'),
 ('f_post_history','h_action_date_and_time','TIME'),
 ('f_post_history','h_owner_member_id','USER'),
 ('f_post_history','h_alterer_member_id','USER'),
 ('f_post_history','h_post_id','AUTO_LINK'),
 ('f_post_history','h_topic_id','AUTO_LINK'),
 ('f_post_history','h_before','LONG_TEXT'),
 ('f_post_history','h_action','ID_TEXT'),
 ('f_forum_intro_ip','i_forum_id','*AUTO_LINK'),
 ('f_forum_intro_ip','i_ip','*IP'),
 ('f_forum_intro_member','i_forum_id','*AUTO_LINK'),
 ('f_forum_intro_member','i_member_id','*USER'),
 ('f_post_templates','id','*AUTO'),
 ('f_post_templates','t_title','SHORT_TEXT'),
 ('f_post_templates','t_text','LONG_TEXT'),
 ('f_post_templates','t_forum_multi_code','SHORT_TEXT'),
 ('f_post_templates','t_use_default_forums','BINARY'),
 ('f_polls','id','*AUTO'),
 ('f_polls','po_question','SHORT_TEXT'),
 ('f_polls','po_cache_total_votes','INTEGER'),
 ('f_polls','po_is_private','BINARY'),
 ('f_polls','po_is_open','BINARY'),
 ('f_polls','po_minimum_selections','INTEGER'),
 ('f_polls','po_maximum_selections','INTEGER'),
 ('f_polls','po_requires_reply','BINARY'),
 ('f_poll_answers','id','*AUTO'),
 ('f_poll_answers','pa_poll_id','AUTO_LINK'),
 ('f_poll_answers','pa_answer','SHORT_TEXT'),
 ('f_poll_answers','pa_cache_num_votes','INTEGER'),
 ('f_poll_votes','pv_poll_id','*AUTO_LINK'),
 ('f_poll_votes','pv_member_id','*USER'),
 ('f_poll_votes','pv_answer_id','*AUTO_LINK'),
 ('f_multi_moderations','id','*AUTO'),
 ('f_multi_moderations','mm_name','*SHORT_TRANS'),
 ('f_multi_moderations','mm_post_text','LONG_TEXT'),
 ('f_multi_moderations','mm_move_to','?INTEGER'),
 ('f_multi_moderations','mm_pin_state','?BINARY'),
 ('f_multi_moderations','mm_sink_state','?BINARY'),
 ('f_multi_moderations','mm_open_state','?BINARY'),
 ('f_multi_moderations','mm_forum_multi_code','SHORT_TEXT'),
 ('f_multi_moderations','mm_title_suffix','SHORT_TEXT'),
 ('f_warnings','id','*AUTO'),
 ('f_warnings','w_member_id','USER'),
 ('f_warnings','w_time','TIME'),
 ('f_warnings','w_explanation','LONG_TEXT'),
 ('f_warnings','w_by','USER'),
 ('f_warnings','w_is_warning','BINARY'),
 ('f_warnings','p_silence_from_topic','?AUTO_LINK'),
 ('f_warnings','p_silence_from_forum','?AUTO_LINK'),
 ('f_warnings','p_probation','INTEGER'),
 ('f_warnings','p_banned_ip','IP'),
 ('f_warnings','p_charged_points','INTEGER'),
 ('f_warnings','p_banned_member','BINARY'),
 ('f_warnings','p_changed_usergroup_from','?GROUP'),
 ('f_moderator_logs','id','*AUTO'),
 ('f_moderator_logs','l_the_type','ID_TEXT'),
 ('f_moderator_logs','l_param_a','SHORT_TEXT'),
 ('f_moderator_logs','l_param_b','SHORT_TEXT'),
 ('f_moderator_logs','l_date_and_time','TIME'),
 ('f_moderator_logs','l_reason','LONG_TEXT'),
 ('f_moderator_logs','l_by','USER'),
 ('f_member_known_login_ips','i_member_id','*USER'),
 ('f_member_known_login_ips','i_ip','*IP'),
 ('f_member_known_login_ips','i_val_code','SHORT_TEXT'),
 ('f_read_logs','l_member_id','*USER'),
 ('f_read_logs','l_topic_id','*AUTO_LINK'),
 ('f_read_logs','l_time','TIME'),
 ('menu_items','id','*AUTO'),
 ('menu_items','i_menu','ID_TEXT'),
 ('menu_items','i_order','INTEGER'),
 ('menu_items','i_parent','?AUTO_LINK'),
 ('menu_items','i_caption','SHORT_TRANS'),
 ('menu_items','i_caption_long','SHORT_TRANS'),
 ('menu_items','i_url','SHORT_TEXT'),
 ('menu_items','i_check_permissions','BINARY'),
 ('menu_items','i_expanded','BINARY'),
 ('menu_items','i_new_window','BINARY'),
 ('menu_items','i_page_only','ID_TEXT'),
 ('menu_items','i_theme_img_code','ID_TEXT'),
 ('trackbacks','id','*AUTO'),
 ('trackbacks','trackback_for_type','ID_TEXT'),
 ('trackbacks','trackback_for_id','ID_TEXT'),
 ('trackbacks','trackback_ip','IP'),
 ('trackbacks','trackback_time','TIME'),
 ('trackbacks','trackback_url','SHORT_TEXT'),
 ('trackbacks','trackback_title','SHORT_TEXT'),
 ('trackbacks','trackback_excerpt','LONG_TEXT'),
 ('trackbacks','trackback_name','SHORT_TEXT'),
 ('security_images','si_session_id','*INTEGER'),
 ('security_images','si_time','TIME'),
 ('security_images','si_code','INTEGER'),
 ('member_tracking','mt_member_id','*USER'),
 ('member_tracking','mt_cache_username','ID_TEXT'),
 ('member_tracking','mt_time','*TIME'),
 ('member_tracking','mt_page','*ID_TEXT'),
 ('member_tracking','mt_type','*ID_TEXT'),
 ('member_tracking','mt_id','*ID_TEXT'),
 ('cache_on','cached_for','*ID_TEXT'),
 ('cache_on','cache_on','LONG_TEXT'),
 ('cache_on','cache_ttl','INTEGER'),
 ('validated_once','hash','*MD5'),
 ('edit_pings','id','*AUTO'),
 ('edit_pings','the_page','ID_TEXT'),
 ('edit_pings','the_type','ID_TEXT'),
 ('edit_pings','the_id','ID_TEXT'),
 ('edit_pings','the_time','TIME'),
 ('edit_pings','the_member','USER'),
 ('translate_history','id','*AUTO'),
 ('translate_history','lang_id','AUTO_LINK'),
 ('translate_history','language','*LANGUAGE_NAME'),
 ('translate_history','text_original','LONG_TEXT'),
 ('translate_history','broken','BINARY'),
 ('translate_history','action_member','USER'),
 ('translate_history','action_time','TIME'),
 ('long_values','the_name','*ID_TEXT'),
 ('long_values','the_value','LONG_TEXT'),
 ('long_values','date_and_time','TIME'),
 ('tutorial_links','the_name','*ID_TEXT'),
 ('tutorial_links','the_value','LONG_TEXT'),
 ('msp','active_until','*TIME'),
 ('msp','member_id','*INTEGER'),
 ('msp','specific_permission','*ID_TEXT'),
 ('msp','the_page','*ID_TEXT'),
 ('msp','module_the_name','*ID_TEXT'),
 ('msp','category_name','*ID_TEXT'),
 ('msp','the_value','BINARY'),
 ('member_zone_access','active_until','*TIME'),
 ('member_zone_access','zone_name','*ID_TEXT'),
 ('member_zone_access','member_id','*USER'),
 ('member_page_access','active_until','*TIME'),
 ('member_page_access','page_name','*ID_TEXT'),
 ('member_page_access','zone_name','*ID_TEXT'),
 ('member_page_access','member_id','*USER'),
 ('member_category_access','active_until','*TIME'),
 ('member_category_access','module_the_name','*ID_TEXT'),
 ('member_category_access','category_name','*ID_TEXT'),
 ('member_category_access','member_id','*USER'),
 ('autosave','id','*AUTO'),
 ('autosave','a_member_id','USER'),
 ('autosave','a_key','LONG_TEXT'),
 ('autosave','a_value','LONG_TEXT'),
 ('autosave','a_time','TIME'),
 ('messages_to_render','id','*AUTO'),
 ('messages_to_render','r_session_id','AUTO_LINK'),
 ('messages_to_render','r_message','LONG_TEXT'),
 ('messages_to_render','r_type','ID_TEXT'),
 ('messages_to_render','r_time','TIME'),
 ('url_title_cache','id','*AUTO'),
 ('url_title_cache','t_url','URLPATH'),
 ('url_title_cache','t_title','SHORT_TEXT'),
 ('url_id_monikers','id','*AUTO'),
 ('url_id_monikers','m_resource_page','ID_TEXT'),
 ('url_id_monikers','m_resource_type','ID_TEXT'),
 ('url_id_monikers','m_resource_id','ID_TEXT'),
 ('url_id_monikers','m_moniker','SHORT_TEXT'),
 ('url_id_monikers','m_deprecated','BINARY'),
 ('review_supplement','r_post_id','*AUTO_LINK'),
 ('review_supplement','r_rating_type','*ID_TEXT'),
 ('review_supplement','r_rating','SHORT_INTEGER'),
 ('review_supplement','r_topic_id','AUTO_LINK'),
 ('review_supplement','r_rating_for_id','ID_TEXT'),
 ('review_supplement','r_rating_for_type','ID_TEXT'),
 ('sms_log','id','*AUTO'),
 ('sms_log','s_member_id','USER'),
 ('sms_log','s_time','TIME'),
 ('sms_log','s_trigger_ip','IP'),
 ('f_member_custom_fields','field_10','SHORT_TEXT'),
 ('logged_mail_messages','id','*AUTO'),
 ('logged_mail_messages','m_subject','LONG_TEXT'),
 ('logged_mail_messages','m_message','LONG_TEXT'),
 ('logged_mail_messages','m_to_email','LONG_TEXT'),
 ('logged_mail_messages','m_to_name','LONG_TEXT'),
 ('logged_mail_messages','m_from_email','SHORT_TEXT'),
 ('logged_mail_messages','m_from_name','SHORT_TEXT'),
 ('logged_mail_messages','m_priority','SHORT_INTEGER'),
 ('logged_mail_messages','m_attachments','LONG_TEXT'),
 ('logged_mail_messages','m_no_cc','BINARY'),
 ('logged_mail_messages','m_as','USER'),
 ('logged_mail_messages','m_as_admin','BINARY'),
 ('logged_mail_messages','m_in_html','BINARY'),
 ('logged_mail_messages','m_date_and_time','TIME'),
 ('logged_mail_messages','m_member_id','USER'),
 ('logged_mail_messages','m_url','LONG_TEXT'),
 ('logged_mail_messages','m_queued','BINARY'),
 ('logged_mail_messages','m_template','ID_TEXT'),
 ('link_tracker','id','*AUTO'),
 ('link_tracker','c_date_and_time','TIME'),
 ('link_tracker','c_member_id','USER'),
 ('link_tracker','c_ip_address','IP'),
 ('link_tracker','c_url','URLPATH'),
 ('incoming_uploads','id','*AUTO'),
 ('incoming_uploads','i_submitter','USER'),
 ('incoming_uploads','i_date_and_time','TIME'),
 ('incoming_uploads','i_orig_filename','URLPATH'),
 ('incoming_uploads','i_save_url','URLPATH'),
 ('cache','cached_for','*ID_TEXT'),
 ('cache','identifier','*MINIID_TEXT'),
 ('cache','the_value','LONG_TEXT'),
 ('cache','date_and_time','TIME'),
 ('cache','the_theme','*ID_TEXT'),
 ('cache','lang','*LANGUAGE_NAME'),
 ('cache','langs_required','LONG_TEXT'),
 ('f_group_member_timeouts','member_id','*USER'),
 ('f_group_member_timeouts','group_id','*GROUP'),
 ('f_group_member_timeouts','timeout','TIME'),
 ('temp_block_permissions','id','*AUTO'),
 ('temp_block_permissions','p_session_id','AUTO_LINK'),
 ('temp_block_permissions','p_block_constraints','LONG_TEXT'),
 ('temp_block_permissions','p_time','TIME'),
 ('cron_caching_requests','id','*AUTO'),
 ('cron_caching_requests','c_codename','ID_TEXT'),
 ('cron_caching_requests','c_map','LONG_TEXT'),
 ('cron_caching_requests','c_timezone','ID_TEXT'),
 ('cron_caching_requests','c_is_bot','BINARY'),
 ('cron_caching_requests','c_in_panel','BINARY'),
 ('cron_caching_requests','c_interlock','BINARY'),
 ('cron_caching_requests','c_store_as_tempcode','BINARY'),
 ('cron_caching_requests','c_lang','LANGUAGE_NAME'),
 ('cron_caching_requests','c_theme','ID_TEXT'),
 ('notifications_enabled','id','*AUTO'),
 ('notifications_enabled','l_member_id','USER'),
 ('notifications_enabled','l_notification_code','ID_TEXT'),
 ('notifications_enabled','l_code_category','SHORT_TEXT'),
 ('notifications_enabled','l_setting','INTEGER'),
 ('digestives_tin','id','*AUTO'),
 ('digestives_tin','d_subject','LONG_TEXT'),
 ('digestives_tin','d_message','LONG_TEXT'),
 ('digestives_tin','d_from_member_id','?USER'),
 ('digestives_tin','d_to_member_id','USER'),
 ('digestives_tin','d_priority','SHORT_INTEGER'),
 ('digestives_tin','d_no_cc','BINARY'),
 ('digestives_tin','d_date_and_time','TIME'),
 ('digestives_tin','d_notification_code','ID_TEXT'),
 ('digestives_tin','d_code_category','SHORT_TEXT'),
 ('digestives_tin','d_frequency','INTEGER'),
 ('digestives_consumed','c_member_id','*USER'),
 ('digestives_consumed','c_frequency','*INTEGER'),
 ('digestives_consumed','c_time','TIME'),
 ('rating','id','*AUTO'),
 ('rating','rating_for_type','ID_TEXT'),
 ('rating','rating_for_id','ID_TEXT'),
 ('rating','rating_member','USER'),
 ('rating','rating_ip','IP'),
 ('rating','rating_time','TIME'),
 ('rating','rating','SHORT_INTEGER'),
 ('group_page_access','zone_name','*ID_TEXT'),
 ('group_page_access','group_id','*GROUP'),
 ('addons','addon_name','*SHORT_TEXT'),
 ('addons','addon_author','SHORT_TEXT'),
 ('addons','addon_organisation','SHORT_TEXT'),
 ('addons','addon_version','SHORT_TEXT'),
 ('addons','addon_description','LONG_TEXT'),
 ('addons','addon_install_time','TIME'),
 ('addons_files','id','*AUTO'),
 ('addons_files','addon_name','SHORT_TEXT'),
 ('addons_files','filename','SHORT_TEXT'),
 ('addons_dependencies','id','*AUTO'),
 ('addons_dependencies','addon_name','SHORT_TEXT'),
 ('addons_dependencies','addon_name_dependant_upon','SHORT_TEXT'),
 ('addons_dependencies','addon_name_incompatibility','BINARY'),
 ('award_archive','a_type_id','*AUTO_LINK'),
 ('award_archive','date_and_time','*TIME'),
 ('award_archive','content_id','ID_TEXT'),
 ('award_archive','member_id','USER'),
 ('award_types','id','*AUTO'),
 ('award_types','a_title','SHORT_TRANS'),
 ('award_types','a_description','LONG_TRANS'),
 ('award_types','a_points','INTEGER'),
 ('award_types','a_content_type','ID_TEXT'),
 ('award_types','a_hide_awardee','BINARY'),
 ('award_types','a_update_time_hours','INTEGER'),
 ('custom_comcode','tag_tag','*ID_TEXT'),
 ('custom_comcode','tag_title','SHORT_TRANS'),
 ('custom_comcode','tag_description','SHORT_TRANS'),
 ('custom_comcode','tag_replace','LONG_TEXT'),
 ('custom_comcode','tag_example','LONG_TEXT'),
 ('custom_comcode','tag_parameters','SHORT_TEXT'),
 ('custom_comcode','tag_enabled','BINARY'),
 ('custom_comcode','tag_dangerous_tag','BINARY'),
 ('custom_comcode','tag_block_tag','BINARY'),
 ('custom_comcode','tag_textual_tag','BINARY'),
 ('text','id','*AUTO'),
 ('text','user_id','USER'),
 ('text','the_message','SHORT_TRANS'),
 ('text','days','INTEGER'),
 ('text','order_time','TIME'),
 ('text','activation_time','?TIME'),
 ('text','active_now','BINARY'),
 ('text','notes','LONG_TEXT'),
 ('import_parts_done','imp_id','*SHORT_TEXT'),
 ('import_parts_done','imp_session','*INTEGER'),
 ('import_session','imp_old_base_dir','SHORT_TEXT'),
 ('import_session','imp_db_name','ID_TEXT'),
 ('import_session','imp_db_user','ID_TEXT'),
 ('import_session','imp_hook','ID_TEXT'),
 ('import_session','imp_db_table_prefix','ID_TEXT'),
 ('import_session','imp_refresh_time','INTEGER'),
 ('import_session','imp_session','*INTEGER'),
 ('import_id_remap','id_old','*ID_TEXT'),
 ('import_id_remap','id_new','AUTO_LINK'),
 ('import_id_remap','id_type','*ID_TEXT'),
 ('import_id_remap','id_session','*INTEGER'),
 ('usersubmitban_ip','ip','*IP'),
 ('usersubmitban_ip','i_descrip','LONG_TEXT'),
 ('usersubmitban_member','the_member','*USER'),
 ('notification_lockdown','l_notification_code','*ID_TEXT'),
 ('notification_lockdown','l_setting','INTEGER'),
 ('occlechat','id','*AUTO'),
 ('occlechat','c_message','LONG_TEXT'),
 ('occlechat','c_url','URLPATH'),
 ('occlechat','c_incoming','BINARY'),
 ('occlechat','c_timestamp','TIME'),
 ('f_welcome_emails','id','*AUTO'),
 ('f_welcome_emails','w_name','SHORT_TEXT'),
 ('f_welcome_emails','w_subject','SHORT_TRANS'),
 ('f_welcome_emails','w_text','LONG_TRANS'),
 ('f_welcome_emails','w_send_time','INTEGER'),
 ('f_welcome_emails','w_newsletter','BINARY'),
 ('redirects','r_from_page','*ID_TEXT'),
 ('redirects','r_from_zone','*ID_TEXT'),
 ('redirects','r_to_page','ID_TEXT'),
 ('redirects','r_to_zone','ID_TEXT'),
 ('redirects','r_is_transparent','BINARY'),
 ('hackattack','id','*AUTO'),
 ('hackattack','url','URLPATH'),
 ('hackattack','data_post','LONG_TEXT'),
 ('hackattack','user_agent','SHORT_TEXT'),
 ('hackattack','referer','SHORT_TEXT'),
 ('hackattack','user_os','SHORT_TEXT'),
 ('hackattack','the_user','USER'),
 ('hackattack','date_and_time','TIME'),
 ('hackattack','ip','IP'),
 ('hackattack','reason','ID_TEXT'),
 ('hackattack','reason_param_a','SHORT_TEXT'),
 ('hackattack','reason_param_b','SHORT_TEXT'),
 ('stats','id','*AUTO'),
 ('stats','the_page','SHORT_TEXT'),
 ('stats','ip','IP'),
 ('stats','the_user','USER'),
 ('stats','date_and_time','TIME'),
 ('stats','referer','URLPATH'),
 ('stats','get','URLPATH'),
 ('stats','post','LONG_TEXT'),
 ('stats','browser','SHORT_TEXT'),
 ('stats','milliseconds','INTEGER'),
 ('stats','operating_system','SHORT_TEXT'),
 ('stats','access_denied_counter','INTEGER'),
 ('usersonline_track','date_and_time','*TIME'),
 ('usersonline_track','peak','INTEGER'),
 ('ip_country','id','*AUTO'),
 ('ip_country','begin_num','UINTEGER'),
 ('ip_country','end_num','UINTEGER'),
 ('ip_country','country','SHORT_TEXT'),
 ('theme_images','id','*SHORT_TEXT'),
 ('theme_images','theme','*MINIID_TEXT'),
 ('theme_images','path','URLPATH'),
 ('theme_images','lang','*LANGUAGE_NAME'),
 ('wordfilter','word','*SHORT_TEXT'),
 ('wordfilter','w_replacement','SHORT_TEXT'),
 ('wordfilter','w_substr','*BINARY'),
 ('authors','author','*ID_TEXT'),
 ('authors','url','URLPATH'),
 ('authors','forum_handle','?USER'),
 ('authors','description','LONG_TRANS'),
 ('authors','skills','LONG_TRANS'),
 ('banners','name','*ID_TEXT'),
 ('banners','expiry_date','?TIME'),
 ('banners','submitter','USER'),
 ('banners','img_url','URLPATH'),
 ('banners','b_title_text','SHORT_TEXT'),
 ('banners','the_type','SHORT_INTEGER'),
 ('banners','caption','SHORT_TRANS'),
 ('banners','campaign_remaining','INTEGER'),
 ('banners','site_url','URLPATH'),
 ('banners','hits_from','INTEGER'),
 ('banners','views_from','INTEGER'),
 ('banners','hits_to','INTEGER'),
 ('banners','views_to','INTEGER'),
 ('banners','importance_modulus','INTEGER'),
 ('banners','notes','LONG_TEXT'),
 ('banners','validated','BINARY'),
 ('banners','add_date','TIME'),
 ('banners','edit_date','?TIME'),
 ('banners','b_type','ID_TEXT'),
 ('banner_types','id','*ID_TEXT'),
 ('banner_types','t_is_textual','BINARY'),
 ('banner_types','t_image_width','INTEGER'),
 ('banner_types','t_image_height','INTEGER'),
 ('banner_types','t_max_file_size','INTEGER'),
 ('banner_types','t_comcode_inline','BINARY'),
 ('banner_clicks','id','*AUTO'),
 ('banner_clicks','c_date_and_time','TIME'),
 ('banner_clicks','c_member_id','USER'),
 ('banner_clicks','c_ip_address','IP'),
 ('banner_clicks','c_source','ID_TEXT'),
 ('banner_clicks','c_banner_id','ID_TEXT'),
 ('bookmarks','id','*AUTO'),
 ('bookmarks','b_owner','USER'),
 ('bookmarks','b_folder','SHORT_TEXT'),
 ('bookmarks','b_title','SHORT_TEXT'),
 ('bookmarks','b_page_link','SHORT_TEXT'),
 ('calendar_events','id','*AUTO'),
 ('calendar_events','e_submitter','USER'),
 ('calendar_events','e_views','INTEGER'),
 ('calendar_events','e_title','SHORT_TRANS'),
 ('calendar_events','e_content','LONG_TRANS'),
 ('calendar_events','e_add_date','TIME'),
 ('calendar_events','e_edit_date','?TIME'),
 ('calendar_events','e_recurrence','ID_TEXT'),
 ('calendar_events','e_recurrences','?INTEGER'),
 ('calendar_events','e_seg_recurrences','BINARY'),
 ('calendar_events','e_start_year','INTEGER'),
 ('calendar_events','e_start_month','INTEGER'),
 ('calendar_events','e_start_day','INTEGER'),
 ('calendar_events','e_start_hour','?INTEGER'),
 ('calendar_events','e_start_minute','?INTEGER'),
 ('calendar_events','e_end_year','?INTEGER'),
 ('calendar_events','e_end_month','?INTEGER'),
 ('calendar_events','e_end_day','?INTEGER'),
 ('calendar_events','e_end_hour','?INTEGER'),
 ('calendar_events','e_end_minute','?INTEGER'),
 ('calendar_events','e_timezone','ID_TEXT'),
 ('calendar_events','e_do_timezone_conv','BINARY'),
 ('calendar_events','e_is_public','BINARY'),
 ('calendar_events','e_priority','INTEGER'),
 ('calendar_events','allow_rating','BINARY'),
 ('calendar_events','allow_comments','SHORT_INTEGER'),
 ('calendar_events','allow_trackbacks','BINARY'),
 ('calendar_events','notes','LONG_TEXT'),
 ('calendar_events','e_type','AUTO_LINK'),
 ('calendar_events','validated','BINARY'),
 ('calendar_types','id','*AUTO'),
 ('calendar_types','t_title','SHORT_TRANS'),
 ('calendar_types','t_logo','SHORT_TEXT'),
 ('calendar_types','t_external_feed','URLPATH'),
 ('calendar_reminders','id','*AUTO'),
 ('calendar_reminders','e_id','AUTO_LINK'),
 ('calendar_reminders','n_member_id','USER'),
 ('calendar_reminders','n_seconds_before','INTEGER'),
 ('calendar_interests','i_member_id','*USER'),
 ('calendar_interests','t_type','*AUTO_LINK'),
 ('calendar_jobs','id','*AUTO'),
 ('calendar_jobs','j_time','TIME'),
 ('calendar_jobs','j_reminder_id','?AUTO_LINK'),
 ('calendar_jobs','j_member_id','?USER'),
 ('calendar_jobs','j_event_id','AUTO_LINK'),
 ('catalogues','c_name','*ID_TEXT'),
 ('catalogues','c_title','SHORT_TRANS'),
 ('catalogues','c_description','LONG_TRANS'),
 ('catalogues','c_display_type','SHORT_INTEGER'),
 ('catalogues','c_is_tree','BINARY'),
 ('catalogues','c_notes','LONG_TEXT'),
 ('catalogues','c_add_date','TIME'),
 ('catalogues','c_submit_points','INTEGER'),
 ('catalogues','c_ecommerce','BINARY'),
 ('catalogues','c_send_view_reports','ID_TEXT'),
 ('catalogue_categories','id','*AUTO'),
 ('catalogue_categories','c_name','ID_TEXT'),
 ('catalogue_categories','cc_title','SHORT_TRANS'),
 ('catalogue_categories','cc_description','LONG_TRANS'),
 ('catalogue_categories','rep_image','URLPATH'),
 ('catalogue_categories','cc_notes','LONG_TEXT'),
 ('catalogue_categories','cc_add_date','TIME'),
 ('catalogue_categories','cc_parent_id','?AUTO_LINK'),
 ('catalogue_categories','cc_move_target','?AUTO_LINK'),
 ('catalogue_categories','cc_move_days_lower','INTEGER'),
 ('catalogue_categories','cc_move_days_higher','INTEGER'),
 ('catalogue_fields','id','*AUTO'),
 ('catalogue_fields','c_name','ID_TEXT'),
 ('catalogue_fields','cf_name','SHORT_TRANS'),
 ('catalogue_fields','cf_description','LONG_TRANS'),
 ('catalogue_fields','cf_type','ID_TEXT'),
 ('catalogue_fields','cf_order','INTEGER'),
 ('catalogue_fields','cf_defines_order','SHORT_INTEGER'),
 ('catalogue_fields','cf_visible','BINARY'),
 ('catalogue_fields','cf_searchable','BINARY'),
 ('catalogue_fields','cf_default','LONG_TEXT'),
 ('catalogue_fields','cf_required','BINARY'),
 ('catalogue_fields','cf_put_in_category','BINARY'),
 ('catalogue_fields','cf_put_in_search','BINARY'),
 ('catalogue_entries','id','*AUTO'),
 ('catalogue_entries','c_name','ID_TEXT'),
 ('catalogue_entries','cc_id','AUTO_LINK'),
 ('catalogue_entries','ce_submitter','USER'),
 ('catalogue_entries','ce_add_date','TIME'),
 ('catalogue_entries','ce_edit_date','?TIME'),
 ('catalogue_entries','ce_views','INTEGER'),
 ('catalogue_entries','ce_views_prior','INTEGER'),
 ('catalogue_entries','ce_validated','BINARY'),
 ('catalogue_entries','notes','LONG_TEXT'),
 ('catalogue_entries','allow_rating','BINARY'),
 ('catalogue_entries','allow_comments','SHORT_INTEGER'),
 ('catalogue_entries','allow_trackbacks','BINARY'),
 ('catalogue_entries','ce_last_moved','INTEGER'),
 ('catalogue_efv_long_trans','id','*AUTO'),
 ('catalogue_efv_long_trans','cf_id','AUTO_LINK'),
 ('catalogue_efv_long_trans','ce_id','AUTO_LINK'),
 ('catalogue_efv_long_trans','cv_value','LONG_TRANS'),
 ('catalogue_efv_long','id','*AUTO'),
 ('catalogue_efv_long','cf_id','AUTO_LINK'),
 ('catalogue_efv_long','ce_id','AUTO_LINK'),
 ('catalogue_efv_long','cv_value','LONG_TEXT'),
 ('catalogue_efv_short_trans','id','*AUTO'),
 ('catalogue_efv_short_trans','cf_id','AUTO_LINK'),
 ('catalogue_efv_short_trans','ce_id','AUTO_LINK'),
 ('catalogue_efv_short_trans','cv_value','SHORT_TRANS'),
 ('catalogue_efv_short','id','*AUTO'),
 ('catalogue_efv_short','cf_id','AUTO_LINK'),
 ('catalogue_efv_short','ce_id','AUTO_LINK'),
 ('catalogue_efv_short','cv_value','SHORT_TEXT'),
 ('catalogue_entry_linkage','catalogue_entry_id','*AUTO_LINK'),
 ('catalogue_entry_linkage','content_type','ID_TEXT'),
 ('catalogue_entry_linkage','content_id','ID_TEXT'),
 ('catalogue_cat_treecache','cc_id','*AUTO_LINK'),
 ('catalogue_cat_treecache','cc_ancestor_id','*AUTO_LINK'),
 ('catalogue_childcountcache','cc_id','*AUTO_LINK'),
 ('catalogue_childcountcache','c_num_rec_children','INTEGER'),
 ('catalogue_childcountcache','c_num_rec_entries','INTEGER'),
 ('catalogue_efv_float','id','*AUTO'),
 ('catalogue_efv_float','cf_id','AUTO_LINK'),
 ('catalogue_efv_float','ce_id','AUTO_LINK'),
 ('catalogue_efv_float','cv_value','?REAL'),
 ('catalogue_efv_integer','id','*AUTO'),
 ('catalogue_efv_integer','cf_id','AUTO_LINK'),
 ('catalogue_efv_integer','ce_id','AUTO_LINK'),
 ('catalogue_efv_integer','cv_value','?INTEGER'),
 ('seedy_changes','id','*AUTO'),
 ('seedy_changes','the_action','ID_TEXT'),
 ('seedy_changes','the_page','AUTO_LINK'),
 ('seedy_changes','date_and_time','TIME'),
 ('seedy_changes','ip','IP'),
 ('seedy_changes','the_user','USER'),
 ('seedy_children','parent_id','*AUTO_LINK'),
 ('seedy_children','child_id','*AUTO_LINK'),
 ('seedy_children','the_order','INTEGER'),
 ('seedy_children','title','SHORT_TEXT'),
 ('seedy_pages','id','*AUTO'),
 ('seedy_pages','title','SHORT_TRANS'),
 ('seedy_pages','notes','LONG_TEXT'),
 ('seedy_pages','description','LONG_TRANS'),
 ('seedy_pages','add_date','TIME'),
 ('seedy_pages','seedy_views','INTEGER'),
 ('seedy_pages','hide_posts','BINARY'),
 ('seedy_pages','submitter','USER'),
 ('seedy_posts','id','*AUTO'),
 ('seedy_posts','page_id','AUTO_LINK'),
 ('seedy_posts','the_message','LONG_TRANS'),
 ('seedy_posts','date_and_time','TIME'),
 ('seedy_posts','validated','BINARY'),
 ('seedy_posts','seedy_views','INTEGER'),
 ('seedy_posts','the_user','USER'),
 ('seedy_posts','edit_date','?TIME'),
 ('f_member_custom_fields','field_11','SHORT_TEXT'),
 ('chat_rooms','id','*AUTO'),
 ('chat_rooms','room_name','SHORT_TEXT'),
 ('chat_rooms','room_owner','?INTEGER'),
 ('chat_rooms','allow_list','LONG_TEXT'),
 ('chat_rooms','allow_list_groups','LONG_TEXT'),
 ('chat_rooms','disallow_list','LONG_TEXT'),
 ('chat_rooms','disallow_list_groups','LONG_TEXT'),
 ('chat_rooms','room_language','LANGUAGE_NAME'),
 ('chat_rooms','c_welcome','LONG_TRANS'),
 ('chat_rooms','is_im','BINARY'),
 ('chat_messages','id','*AUTO'),
 ('chat_messages','system_message','BINARY'),
 ('chat_messages','ip_address','IP'),
 ('chat_messages','room_id','AUTO_LINK'),
 ('chat_messages','user_id','USER'),
 ('chat_messages','date_and_time','TIME'),
 ('chat_messages','the_message','LONG_TRANS'),
 ('chat_messages','text_colour','SHORT_TEXT'),
 ('chat_messages','font_name','SHORT_TEXT'),
 ('f_member_custom_fields','field_12','SHORT_TEXT'),
 ('chat_blocking','member_blocker','*USER'),
 ('chat_blocking','member_blocked','*USER'),
 ('chat_blocking','date_and_time','TIME'),
 ('chat_buddies','member_likes','*USER'),
 ('chat_buddies','member_liked','*USER'),
 ('chat_buddies','date_and_time','TIME'),
 ('chat_events','id','*AUTO'),
 ('chat_events','e_type_code','ID_TEXT'),
 ('chat_events','e_member_id','USER'),
 ('chat_events','e_room_id','?AUTO_LINK'),
 ('chat_events','e_date_and_time','TIME'),
 ('chat_active','id','*AUTO'),
 ('chat_active','member_id','USER'),
 ('chat_active','room_id','?AUTO_LINK'),
 ('chat_active','date_and_time','TIME'),
 ('chat_sound_effects','s_member','*USER'),
 ('chat_sound_effects','s_effect_id','*ID_TEXT'),
 ('chat_sound_effects','s_url','URLPATH'),
 ('download_categories','id','*AUTO'),
 ('download_categories','category','SHORT_TRANS'),
 ('download_categories','parent_id','?AUTO_LINK'),
 ('download_categories','add_date','TIME'),
 ('download_categories','notes','LONG_TEXT'),
 ('download_categories','description','LONG_TRANS'),
 ('download_categories','rep_image','URLPATH'),
 ('download_downloads','id','*AUTO'),
 ('download_downloads','category_id','AUTO_LINK'),
 ('download_downloads','name','SHORT_TRANS'),
 ('download_downloads','url','URLPATH'),
 ('download_downloads','description','LONG_TRANS'),
 ('download_downloads','author','ID_TEXT'),
 ('download_downloads','comments','LONG_TRANS'),
 ('download_downloads','num_downloads','INTEGER'),
 ('download_downloads','out_mode_id','?AUTO_LINK'),
 ('download_downloads','add_date','TIME'),
 ('download_downloads','edit_date','?TIME'),
 ('download_downloads','validated','BINARY'),
 ('download_downloads','default_pic','INTEGER'),
 ('download_downloads','file_size','?INTEGER'),
 ('download_downloads','allow_rating','BINARY'),
 ('download_downloads','allow_comments','SHORT_INTEGER'),
 ('download_downloads','allow_trackbacks','BINARY'),
 ('download_downloads','notes','LONG_TEXT'),
 ('download_downloads','download_views','INTEGER'),
 ('download_downloads','download_cost','INTEGER'),
 ('download_downloads','download_submitter_gets_points','BINARY'),
 ('download_downloads','submitter','USER'),
 ('download_downloads','original_filename','SHORT_TEXT'),
 ('download_downloads','rep_image','URLPATH'),
 ('download_downloads','download_licence','?AUTO_LINK'),
 ('download_downloads','download_data_mash','LONG_TEXT'),
 ('download_logging','id','*AUTO_LINK'),
 ('download_logging','the_user','*USER'),
 ('download_logging','ip','IP'),
 ('download_logging','date_and_time','TIME'),
 ('download_licences','id','*AUTO'),
 ('download_licences','l_title','SHORT_TEXT'),
 ('download_licences','l_text','LONG_TEXT'),
 ('galleries','name','*ID_TEXT'),
 ('galleries','description','LONG_TRANS'),
 ('galleries','teaser','SHORT_TRANS'),
 ('galleries','fullname','SHORT_TRANS'),
 ('galleries','add_date','TIME'),
 ('galleries','rep_image','URLPATH'),
 ('galleries','parent_id','ID_TEXT'),
 ('galleries','watermark_top_left','URLPATH'),
 ('galleries','watermark_top_right','URLPATH'),
 ('galleries','watermark_bottom_left','URLPATH'),
 ('galleries','watermark_bottom_right','URLPATH'),
 ('galleries','accept_images','BINARY'),
 ('galleries','accept_videos','BINARY'),
 ('galleries','allow_rating','BINARY'),
 ('galleries','allow_comments','SHORT_INTEGER'),
 ('galleries','notes','LONG_TEXT'),
 ('galleries','is_member_synched','BINARY'),
 ('galleries','flow_mode_interface','BINARY'),
 ('galleries','gallery_views','INTEGER'),
 ('galleries','g_owner','?AUTO_LINK'),
 ('images','id','*AUTO'),
 ('images','cat','ID_TEXT'),
 ('images','url','URLPATH'),
 ('images','thumb_url','URLPATH'),
 ('images','comments','LONG_TRANS'),
 ('images','allow_rating','BINARY'),
 ('images','allow_comments','SHORT_INTEGER'),
 ('images','allow_trackbacks','BINARY'),
 ('images','notes','LONG_TEXT'),
 ('images','submitter','USER'),
 ('images','validated','BINARY'),
 ('images','add_date','TIME'),
 ('images','edit_date','?TIME'),
 ('images','image_views','INTEGER'),
 ('images','title','SHORT_TRANS'),
 ('videos','id','*AUTO'),
 ('videos','cat','ID_TEXT'),
 ('videos','url','URLPATH'),
 ('videos','thumb_url','URLPATH'),
 ('videos','comments','LONG_TRANS'),
 ('videos','allow_rating','BINARY'),
 ('videos','allow_comments','SHORT_INTEGER'),
 ('videos','allow_trackbacks','BINARY'),
 ('videos','notes','LONG_TEXT'),
 ('videos','submitter','USER'),
 ('videos','validated','BINARY'),
 ('videos','add_date','TIME'),
 ('videos','edit_date','?TIME'),
 ('videos','video_views','INTEGER'),
 ('videos','video_width','INTEGER'),
 ('videos','video_height','INTEGER'),
 ('videos','video_length','INTEGER'),
 ('videos','title','SHORT_TRANS'),
 ('video_transcoding','t_id','*ID_TEXT'),
 ('video_transcoding','t_error','LONG_TEXT'),
 ('video_transcoding','t_url','URLPATH'),
 ('video_transcoding','t_table','ID_TEXT'),
 ('video_transcoding','t_url_field','ID_TEXT'),
 ('video_transcoding','t_orig_filename_field','ID_TEXT'),
 ('video_transcoding','t_width_field','ID_TEXT'),
 ('video_transcoding','t_height_field','ID_TEXT'),
 ('video_transcoding','t_output_filename','ID_TEXT'),
 ('invoices','id','*AUTO'),
 ('invoices','i_type_code','ID_TEXT'),
 ('invoices','i_member_id','USER'),
 ('invoices','i_state','ID_TEXT'),
 ('invoices','i_amount','SHORT_TEXT'),
 ('invoices','i_special','SHORT_TEXT'),
 ('invoices','i_time','TIME'),
 ('invoices','i_note','LONG_TEXT'),
 ('iotd','id','*AUTO'),
 ('iotd','url','URLPATH'),
 ('iotd','i_title','SHORT_TRANS'),
 ('iotd','caption','LONG_TRANS'),
 ('iotd','thumb_url','URLPATH'),
 ('iotd','is_current','BINARY'),
 ('iotd','allow_rating','BINARY'),
 ('iotd','allow_comments','SHORT_INTEGER'),
 ('iotd','allow_trackbacks','BINARY'),
 ('iotd','notes','LONG_TEXT'),
 ('iotd','used','BINARY'),
 ('iotd','date_and_time','?TIME'),
 ('iotd','iotd_views','INTEGER'),
 ('iotd','submitter','USER'),
 ('iotd','add_date','TIME'),
 ('iotd','edit_date','?TIME'),
 ('news','id','*AUTO'),
 ('news','date_and_time','TIME'),
 ('news','title','SHORT_TRANS'),
 ('news','news','LONG_TRANS'),
 ('news','news_article','LONG_TRANS'),
 ('news','allow_rating','BINARY'),
 ('news','allow_comments','SHORT_INTEGER'),
 ('news','allow_trackbacks','BINARY'),
 ('news','notes','LONG_TEXT'),
 ('news','author','ID_TEXT'),
 ('news','submitter','USER'),
 ('news','validated','BINARY'),
 ('news','edit_date','?TIME'),
 ('news','news_category','AUTO_LINK'),
 ('news','news_views','INTEGER'),
 ('news','news_image','URLPATH'),
 ('news_categories','id','*AUTO'),
 ('news_categories','nc_title','SHORT_TRANS'),
 ('news_categories','nc_owner','?USER'),
 ('news_categories','nc_img','ID_TEXT'),
 ('news_categories','notes','LONG_TEXT'),
 ('news_rss_cloud','id','*AUTO'),
 ('news_rss_cloud','rem_procedure','ID_TEXT'),
 ('news_rss_cloud','rem_port','SHORT_INTEGER'),
 ('news_rss_cloud','rem_path','SHORT_TEXT'),
 ('news_rss_cloud','rem_protocol','ID_TEXT'),
 ('news_rss_cloud','rem_ip','IP'),
 ('news_rss_cloud','watching_channel','URLPATH'),
 ('news_rss_cloud','register_time','TIME'),
 ('news_category_entries','news_entry','*AUTO_LINK'),
 ('news_category_entries','news_entry_category','*AUTO_LINK'),
 ('newsletter','id','*AUTO'),
 ('newsletter','email','SHORT_TEXT'),
 ('newsletter','join_time','TIME'),
 ('newsletter','code_confirm','INTEGER'),
 ('newsletter','the_password','MD5'),
 ('newsletter','pass_salt','ID_TEXT'),
 ('newsletter','language','ID_TEXT'),
 ('newsletter','n_forename','SHORT_TEXT'),
 ('newsletter','n_surname','SHORT_TEXT'),
 ('newsletter_archive','id','*AUTO'),
 ('newsletter_archive','date_and_time','INTEGER'),
 ('newsletter_archive','subject','SHORT_TEXT'),
 ('newsletter_archive','newsletter','LONG_TEXT'),
 ('newsletter_archive','language','ID_TEXT'),
 ('newsletter_archive','importance_level','INTEGER'),
 ('newsletters','id','*AUTO'),
 ('newsletters','title','SHORT_TRANS'),
 ('newsletters','description','LONG_TRANS'),
 ('newsletter_subscribe','newsletter_id','*AUTO_LINK'),
 ('newsletter_subscribe','the_level','SHORT_INTEGER'),
 ('newsletter_subscribe','email','*SHORT_TEXT'),
 ('newsletter_drip_send','id','*AUTO'),
 ('newsletter_drip_send','d_inject_time','TIME'),
 ('newsletter_drip_send','d_subject','SHORT_TEXT'),
 ('newsletter_drip_send','d_message','LONG_TEXT'),
 ('newsletter_drip_send','d_html_only','BINARY'),
 ('newsletter_drip_send','d_to_email','SHORT_TEXT'),
 ('newsletter_drip_send','d_to_name','SHORT_TEXT'),
 ('newsletter_drip_send','d_from_email','SHORT_TEXT'),
 ('newsletter_drip_send','d_from_name','SHORT_TEXT'),
 ('newsletter_drip_send','d_priority','SHORT_INTEGER'),
 ('newsletter_drip_send','d_template','ID_TEXT'),
 ('newsletter_periodic','id','*AUTO'),
 ('newsletter_periodic','np_message','LONG_TEXT'),
 ('newsletter_periodic','np_subject','LONG_TEXT'),
 ('newsletter_periodic','np_lang','LANGUAGE_NAME'),
 ('newsletter_periodic','np_send_details','LONG_TEXT'),
 ('newsletter_periodic','np_html_only','BINARY'),
 ('newsletter_periodic','np_from_email','SHORT_TEXT'),
 ('newsletter_periodic','np_from_name','SHORT_TEXT'),
 ('newsletter_periodic','np_priority','SHORT_INTEGER'),
 ('newsletter_periodic','np_csv_data','LONG_TEXT'),
 ('newsletter_periodic','np_frequency','SHORT_TEXT'),
 ('newsletter_periodic','np_day','SHORT_INTEGER'),
 ('newsletter_periodic','np_in_full','BINARY'),
 ('newsletter_periodic','np_template','ID_TEXT'),
 ('newsletter_periodic','np_last_sent','TIME'),
 ('chargelog','id','*AUTO'),
 ('chargelog','user_id','USER'),
 ('chargelog','amount','INTEGER'),
 ('chargelog','reason','SHORT_TRANS'),
 ('chargelog','date_and_time','TIME'),
 ('gifts','id','*AUTO'),
 ('gifts','date_and_time','TIME'),
 ('gifts','amount','INTEGER'),
 ('gifts','gift_from','USER'),
 ('gifts','gift_to','USER'),
 ('gifts','reason','SHORT_TRANS'),
 ('gifts','anonymous','BINARY'),
 ('pstore_customs','id','*AUTO'),
 ('pstore_customs','c_title','SHORT_TRANS'),
 ('pstore_customs','c_description','LONG_TRANS'),
 ('pstore_customs','c_enabled','BINARY'),
 ('pstore_customs','c_cost','INTEGER'),
 ('pstore_customs','c_one_per_member','BINARY'),
 ('pstore_permissions','id','*AUTO'),
 ('pstore_permissions','p_title','SHORT_TRANS'),
 ('pstore_permissions','p_description','LONG_TRANS'),
 ('pstore_permissions','p_enabled','BINARY'),
 ('pstore_permissions','p_cost','INTEGER'),
 ('pstore_permissions','p_hours','INTEGER'),
 ('pstore_permissions','p_type','ID_TEXT'),
 ('pstore_permissions','p_specific_permission','ID_TEXT'),
 ('pstore_permissions','p_zone','ID_TEXT'),
 ('pstore_permissions','p_page','ID_TEXT'),
 ('pstore_permissions','p_module','ID_TEXT'),
 ('pstore_permissions','p_category','ID_TEXT'),
 ('prices','name','*ID_TEXT'),
 ('prices','price','INTEGER'),
 ('sales','id','*AUTO'),
 ('sales','date_and_time','TIME'),
 ('sales','memberid','USER'),
 ('sales','purchasetype','ID_TEXT'),
 ('sales','details','SHORT_TEXT'),
 ('sales','details2','SHORT_TEXT'),
 ('poll','id','*AUTO'),
 ('poll','question','SHORT_TRANS'),
 ('poll','option1','SHORT_TRANS'),
 ('poll','option2','SHORT_TRANS'),
 ('poll','option3','?SHORT_TRANS'),
 ('poll','option4','?SHORT_TRANS'),
 ('poll','option5','?SHORT_TRANS'),
 ('poll','option6','SHORT_TRANS'),
 ('poll','option7','SHORT_TRANS'),
 ('poll','option8','?SHORT_TRANS'),
 ('poll','option9','?SHORT_TRANS'),
 ('poll','option10','?SHORT_TRANS'),
 ('poll','votes1','INTEGER'),
 ('poll','votes2','INTEGER'),
 ('poll','votes3','INTEGER'),
 ('poll','votes4','INTEGER'),
 ('poll','votes5','INTEGER'),
 ('poll','votes6','INTEGER'),
 ('poll','votes7','INTEGER'),
 ('poll','votes8','INTEGER'),
 ('poll','votes9','INTEGER'),
 ('poll','votes10','INTEGER'),
 ('poll','allow_rating','BINARY'),
 ('poll','allow_comments','SHORT_INTEGER'),
 ('poll','allow_trackbacks','BINARY'),
 ('poll','notes','LONG_TEXT'),
 ('poll','num_options','SHORT_INTEGER'),
 ('poll','is_current','BINARY'),
 ('poll','date_and_time','?TIME'),
 ('poll','submitter','USER'),
 ('poll','add_time','INTEGER'),
 ('poll','poll_views','INTEGER'),
 ('poll','edit_date','?TIME'),
 ('poll_votes','id','*AUTO'),
 ('poll_votes','v_poll_id','AUTO_LINK'),
 ('poll_votes','v_voter_id','?USER'),
 ('poll_votes','v_voter_ip','IP'),
 ('poll_votes','v_vote_for','?SHORT_INTEGER'),
 ('trans_expecting','id','*ID_TEXT'),
 ('trans_expecting','e_purchase_id','ID_TEXT'),
 ('trans_expecting','e_item_name','SHORT_TEXT'),
 ('trans_expecting','e_member_id','USER'),
 ('trans_expecting','e_amount','SHORT_TEXT'),
 ('trans_expecting','e_ip_address','IP'),
 ('trans_expecting','e_session_id','INTEGER'),
 ('trans_expecting','e_time','TIME'),
 ('trans_expecting','e_length','?INTEGER'),
 ('trans_expecting','e_length_units','ID_TEXT'),
 ('f_member_custom_fields','field_13','LONG_TEXT'),
 ('f_member_custom_fields','field_14','SHORT_TEXT'),
 ('f_member_custom_fields','field_15','LONG_TEXT'),
 ('f_member_custom_fields','field_16','SHORT_TEXT'),
 ('f_member_custom_fields','field_17','SHORT_TEXT'),
 ('f_member_custom_fields','field_18','SHORT_TEXT'),
 ('f_member_custom_fields','field_19','SHORT_TEXT'),
 ('f_member_custom_fields','field_20','SHORT_TEXT'),
 ('transactions','id','*ID_TEXT'),
 ('transactions','purchase_id','ID_TEXT'),
 ('transactions','status','SHORT_TEXT'),
 ('transactions','reason','SHORT_TEXT'),
 ('transactions','amount','SHORT_TEXT'),
 ('transactions','t_currency','ID_TEXT'),
 ('transactions','linked','ID_TEXT'),
 ('transactions','t_time','*TIME'),
 ('transactions','item','SHORT_TEXT'),
 ('transactions','pending_reason','SHORT_TEXT'),
 ('transactions','t_memo','LONG_TEXT'),
 ('transactions','t_via','ID_TEXT'),
 ('quiz_member_last_visit','id','*AUTO'),
 ('quiz_member_last_visit','v_time','TIME'),
 ('quiz_member_last_visit','v_member_id','USER'),
 ('quiz_member_last_visit','v_quiz_id','AUTO_LINK'),
 ('quizzes','id','*AUTO'),
 ('quizzes','q_timeout','?INTEGER'),
 ('quizzes','q_name','SHORT_TRANS'),
 ('quizzes','q_start_text','LONG_TRANS'),
 ('quizzes','q_end_text','LONG_TRANS'),
 ('quizzes','q_notes','LONG_TEXT'),
 ('quizzes','q_percentage','INTEGER'),
 ('quizzes','q_open_time','TIME'),
 ('quizzes','q_close_time','?TIME'),
 ('quizzes','q_num_winners','INTEGER'),
 ('quizzes','q_redo_time','?INTEGER'),
 ('quizzes','q_type','ID_TEXT'),
 ('quizzes','q_add_date','TIME'),
 ('quizzes','q_validated','BINARY'),
 ('quizzes','q_submitter','USER'),
 ('quizzes','q_points_for_passing','INTEGER'),
 ('quizzes','q_tied_newsletter','?AUTO_LINK'),
 ('quizzes','q_end_text_fail','LONG_TRANS'),
 ('quiz_questions','id','*AUTO'),
 ('quiz_questions','q_long_input_field','BINARY'),
 ('quiz_questions','q_num_choosable_answers','INTEGER'),
 ('quiz_questions','q_quiz','AUTO_LINK'),
 ('quiz_questions','q_question_text','LONG_TRANS'),
 ('quiz_questions','q_order','INTEGER'),
 ('quiz_questions','q_required','BINARY'),
 ('quiz_question_answers','id','*AUTO'),
 ('quiz_question_answers','q_question','AUTO_LINK'),
 ('quiz_question_answers','q_answer_text','SHORT_TRANS'),
 ('quiz_question_answers','q_is_correct','BINARY'),
 ('quiz_question_answers','q_order','INTEGER'),
 ('quiz_question_answers','q_explanation','LONG_TRANS'),
 ('quiz_winner','q_quiz','*AUTO_LINK'),
 ('quiz_winner','q_entry','*AUTO_LINK'),
 ('quiz_winner','q_winner_level','INTEGER'),
 ('quiz_entries','id','*AUTO'),
 ('quiz_entries','q_time','TIME'),
 ('quiz_entries','q_member','USER'),
 ('quiz_entries','q_quiz','AUTO_LINK'),
 ('quiz_entries','q_results','INTEGER'),
 ('quiz_entry_answer','id','*AUTO'),
 ('quiz_entry_answer','q_entry','AUTO_LINK'),
 ('quiz_entry_answer','q_question','AUTO_LINK'),
 ('quiz_entry_answer','q_answer','LONG_TEXT'),
 ('searches_saved','id','*AUTO'),
 ('searches_saved','s_title','SHORT_TEXT'),
 ('searches_saved','s_member_id','USER'),
 ('searches_saved','s_time','TIME'),
 ('searches_saved','s_primary','SHORT_TEXT'),
 ('searches_saved','s_auxillary','LONG_TEXT'),
 ('searches_logged','id','*AUTO'),
 ('searches_logged','s_member_id','USER'),
 ('searches_logged','s_time','TIME'),
 ('searches_logged','s_primary','SHORT_TEXT'),
 ('searches_logged','s_auxillary','LONG_TEXT'),
 ('searches_logged','s_num_results','INTEGER'),
 ('shopping_order','id','*AUTO'),
 ('shopping_order','c_member','INTEGER'),
 ('shopping_order','session_id','INTEGER'),
 ('shopping_order','add_date','TIME'),
 ('shopping_order','tot_price','REAL'),
 ('shopping_order','order_status','ID_TEXT'),
 ('shopping_order','notes','LONG_TEXT'),
 ('shopping_order','transaction_id','SHORT_TEXT'),
 ('shopping_order','purchase_through','SHORT_TEXT'),
 ('shopping_order','tax_opted_out','BINARY'),
 ('shopping_cart','id','*AUTO'),
 ('shopping_cart','session_id','INTEGER'),
 ('shopping_cart','ordered_by','*USER'),
 ('shopping_cart','product_id','*AUTO_LINK'),
 ('shopping_cart','product_name','SHORT_TEXT'),
 ('shopping_cart','product_code','SHORT_TEXT'),
 ('shopping_cart','quantity','INTEGER'),
 ('shopping_cart','price_pre_tax','REAL'),
 ('shopping_cart','price','REAL'),
 ('shopping_cart','product_description','LONG_TEXT'),
 ('shopping_cart','product_type','SHORT_TEXT'),
 ('shopping_cart','product_weight','REAL'),
 ('shopping_cart','is_deleted','BINARY'),
 ('shopping_order_details','id','*AUTO'),
 ('shopping_order_details','order_id','?AUTO_LINK'),
 ('shopping_order_details','p_id','?AUTO_LINK'),
 ('shopping_order_details','p_name','SHORT_TEXT'),
 ('shopping_order_details','p_code','SHORT_TEXT'),
 ('shopping_order_details','p_type','SHORT_TEXT'),
 ('shopping_order_details','p_quantity','INTEGER'),
 ('shopping_order_details','p_price','REAL'),
 ('shopping_order_details','included_tax','REAL'),
 ('shopping_order_details','dispatch_status','SHORT_TEXT'),
 ('shopping_logging','id','*AUTO'),
 ('shopping_logging','e_member_id','*USER'),
 ('shopping_logging','session_id','INTEGER'),
 ('shopping_logging','ip','IP'),
 ('shopping_logging','last_action','SHORT_TEXT'),
 ('shopping_logging','date_and_time','TIME'),
 ('shopping_order_addresses','id','*AUTO'),
 ('shopping_order_addresses','order_id','?AUTO_LINK'),
 ('shopping_order_addresses','address_name','SHORT_TEXT'),
 ('shopping_order_addresses','address_street','LONG_TEXT'),
 ('shopping_order_addresses','address_city','SHORT_TEXT'),
 ('shopping_order_addresses','address_zip','SHORT_TEXT'),
 ('shopping_order_addresses','address_country','SHORT_TEXT'),
 ('shopping_order_addresses','receiver_email','SHORT_TEXT'),
 ('f_member_custom_fields','field_21','SHORT_TEXT'),
 ('f_member_custom_fields','field_22','SHORT_TEXT'),
 ('f_member_custom_fields','field_23','LONG_TEXT'),
 ('f_member_custom_fields','field_24','SHORT_TEXT'),
 ('f_member_custom_fields','field_25','SHORT_TEXT'),
 ('f_member_custom_fields','field_26','SHORT_TEXT'),
 ('f_member_custom_fields','field_27','LONG_TEXT'),
 ('subscriptions','id','*AUTO'),
 ('subscriptions','s_type_code','ID_TEXT'),
 ('subscriptions','s_member_id','USER'),
 ('subscriptions','s_state','ID_TEXT'),
 ('subscriptions','s_amount','SHORT_TEXT'),
 ('subscriptions','s_special','SHORT_TEXT'),
 ('subscriptions','s_time','TIME'),
 ('subscriptions','s_auto_fund_source','ID_TEXT'),
 ('subscriptions','s_auto_fund_key','SHORT_TEXT'),
 ('subscriptions','s_via','ID_TEXT'),
 ('f_usergroup_subs','id','*AUTO'),
 ('f_usergroup_subs','s_title','SHORT_TRANS'),
 ('f_usergroup_subs','s_description','LONG_TRANS'),
 ('f_usergroup_subs','s_cost','SHORT_TEXT'),
 ('f_usergroup_subs','s_length','INTEGER'),
 ('f_usergroup_subs','s_length_units','SHORT_TEXT'),
 ('f_usergroup_subs','s_group_id','GROUP'),
 ('f_usergroup_subs','s_enabled','BINARY'),
 ('f_usergroup_subs','s_mail_start','LONG_TRANS'),
 ('f_usergroup_subs','s_mail_end','LONG_TRANS'),
 ('f_usergroup_subs','s_mail_uhoh','LONG_TRANS'),
 ('f_usergroup_subs','s_uses_primary','BINARY'),
 ('test_sections','id','*AUTO'),
 ('test_sections','s_section','SHORT_TEXT'),
 ('test_sections','s_notes','LONG_TEXT'),
 ('test_sections','s_inheritable','BINARY'),
 ('test_sections','s_assigned_to','?USER'),
 ('tests','id','*AUTO'),
 ('tests','t_section','AUTO_LINK'),
 ('tests','t_test','LONG_TEXT'),
 ('tests','t_assigned_to','?USER'),
 ('tests','t_enabled','BINARY'),
 ('tests','t_status','INTEGER'),
 ('tests','t_inherit_section','?AUTO_LINK'),
 ('tickets','ticket_id','*SHORT_TEXT'),
 ('tickets','topic_id','AUTO_LINK'),
 ('tickets','forum_id','AUTO_LINK'),
 ('tickets','ticket_type','SHORT_TRANS'),
 ('ticket_types','ticket_type','*SHORT_TRANS'),
 ('ticket_types','guest_emails_mandatory','BINARY'),
 ('ticket_types','search_faq','BINARY'),
 ('ticket_types','cache_lead_time','?TIME'),
 ('comcode_pages','the_zone','*ID_TEXT'),
 ('comcode_pages','the_page','*ID_TEXT'),
 ('comcode_pages','p_parent_page','ID_TEXT'),
 ('comcode_pages','p_validated','BINARY'),
 ('comcode_pages','p_edit_date','?TIME'),
 ('comcode_pages','p_add_date','TIME'),
 ('comcode_pages','p_submitter','USER'),
 ('comcode_pages','p_show_as_edit','BINARY'),
 ('cached_comcode_pages','the_zone','*ID_TEXT'),
 ('cached_comcode_pages','the_page','*ID_TEXT'),
 ('cached_comcode_pages','string_index','LONG_TRANS'),
 ('cached_comcode_pages','the_theme','*ID_TEXT'),
 ('cached_comcode_pages','cc_page_title','?SHORT_TRANS'),
 ('filedump','id','*AUTO'),
 ('filedump','name','ID_TEXT'),
 ('filedump','path','URLPATH'),
 ('filedump','description','SHORT_TRANS'),
 ('filedump','the_member','USER'),
 ('leader_board','lb_member','*USER'),
 ('leader_board','lb_points','INTEGER'),
 ('leader_board','date_and_time','*TIME'),
 ('feature_lifetime_monitor','content_id','*ID_TEXT'),
 ('feature_lifetime_monitor','block_cache_id','*ID_TEXT'),
 ('feature_lifetime_monitor','run_period','INTEGER'),
 ('feature_lifetime_monitor','running_now','BINARY'),
 ('feature_lifetime_monitor','last_update','TIME'),
 ('adminlogs','id','*AUTO'),
 ('adminlogs','the_type','ID_TEXT'),
 ('adminlogs','param_a','ID_TEXT'),
 ('adminlogs','param_b','SHORT_TEXT'),
 ('adminlogs','the_user','USER'),
 ('adminlogs','ip','IP'),
 ('adminlogs','date_and_time','TIME'),
 ('customtasks','id','*AUTO'),
 ('customtasks','tasktitle','SHORT_TEXT'),
 ('customtasks','datetimeadded','TIME'),
 ('customtasks','recurinterval','INTEGER'),
 ('customtasks','recurevery','ID_TEXT'),
 ('customtasks','taskisdone','?TIME'),
 ('stafflinks','id','*AUTO'),
 ('stafflinks','link','URLPATH'),
 ('stafflinks','link_title','SHORT_TEXT'),
 ('stafflinks','link_desc','LONG_TEXT'),
 ('staff_tips_dismissed','t_member','*USER'),
 ('staff_tips_dismissed','t_tip','*ID_TEXT'),
 ('sitewatchlist','id','*AUTO'),
 ('sitewatchlist','siteurl','URLPATH'),
 ('sitewatchlist','site_name','SHORT_TEXT'),
 ('cached_weather_codes','id','*AUTO'),
 ('cached_weather_codes','w_string','SHORT_TEXT'),
 ('cached_weather_codes','w_code','INTEGER'),
 ('failedlogins','id','*AUTO'),
 ('failedlogins','failed_account','ID_TEXT'),
 ('failedlogins','date_and_time','TIME'),
 ('failedlogins','ip','IP'),
 ('f_member_custom_fields','field_28','SHORT_TEXT'),
 ('f_member_custom_fields','field_29','SHORT_TEXT'),
 ('f_member_custom_fields','field_30','SHORT_TEXT'),
 ('f_member_custom_fields','field_31','SHORT_TEXT'),
 ('f_member_custom_fields','field_32','SHORT_TEXT'),
 ('f_member_custom_fields','field_33','SHORT_TEXT'),
 ('f_member_custom_fields','field_34','SHORT_TEXT'),
 ('f_member_custom_fields','field_35','SHORT_TEXT');

DROP TABLE IF EXISTS `ocp_db_meta_indices`;

CREATE TABLE `ocp_db_meta_indices` (
  `i_table` varchar(80) NOT NULL,
  `i_name` varchar(80) NOT NULL,
  `i_fields` varchar(80) NOT NULL,
  PRIMARY KEY (`i_table`,`i_name`,`i_fields`)
) ENGINE=MyISAM CHARACTER SET=latin1;

insert into `ocp_db_meta_indices` values('adminlogs','aip','ip'),
 ('adminlogs','athe_type','the_type'),
 ('adminlogs','ts','date_and_time'),
 ('adminlogs','xas','the_user'),
 ('attachments','attachmentlimitcheck','a_add_time'),
 ('attachments','ownedattachments','a_member_id'),
 ('authors','findmemberlink','forum_handle'),
 ('autosave','myautosaves','a_member_id'),
 ('award_archive','awardquicksearch','content_id'),
 ('banners','badd_date','add_date'),
 ('banners','banner_child_find','b_type'),
 ('banners','bvalidated','validated'),
 ('banners','campaign_remaining','campaign_remaining'),
 ('banners','expiry_date','expiry_date'),
 ('banners','the_type','the_type'),
 ('banners','topsites','hits_from,hits_to'),
 ('banner_clicks','clicker_ip','c_ip_address'),
 ('banner_types','hottext','t_comcode_inline'),
 ('cache','cached_ford','date_and_time'),
 ('cache','cached_fore','cached_for'),
 ('cache','cached_forf','lang'),
 ('cache','cached_forg','identifier'),
 ('cache','cached_forh','the_theme'),
 ('cached_comcode_pages','ccp_join','the_page,the_zone'),
 ('cached_comcode_pages','ftjoin_ccpt','cc_page_title'),
 ('cached_comcode_pages','ftjoin_ccsi','string_index'),
 ('calendar_events','ces','e_submitter'),
 ('calendar_events','eventat','e_start_year,e_start_month,e_start_day,e_start_hour,e_start_minute'),
 ('calendar_events','e_add_date','e_add_date'),
 ('calendar_events','e_type','e_type'),
 ('calendar_events','e_views','e_views'),
 ('calendar_events','ftjoin_econtent','e_content'),
 ('calendar_events','ftjoin_etitle','e_title'),
 ('calendar_events','publicevents','e_is_public'),
 ('calendar_events','validated','validated'),
 ('calendar_jobs','applicablejobs','j_time'),
 ('catalogue_categories','cataloguefind','c_name'),
 ('catalogue_categories','catstoclean','cc_move_target'),
 ('catalogue_categories','cc_parent_id','cc_parent_id'),
 ('catalogue_categories','ftjoin_ccdescrip','cc_description'),
 ('catalogue_categories','ftjoin_cctitle','cc_title'),
 ('catalogue_cat_treecache','cc_ancestor_id','cc_ancestor_id'),
 ('catalogue_efv_float','cefv_f_combo','ce_id,cf_id'),
 ('catalogue_efv_float','fce_id','ce_id'),
 ('catalogue_efv_float','fcf_id','cf_id'),
 ('catalogue_efv_float','fcv_value','cv_value'),
 ('catalogue_efv_integer','cefv_i_combo','ce_id,cf_id'),
 ('catalogue_efv_integer','ice_id','ce_id'),
 ('catalogue_efv_integer','icf_id','cf_id'),
 ('catalogue_efv_integer','itv_value','cv_value'),
 ('catalogue_efv_long','#lcv_value','cv_value'),
 ('catalogue_efv_long','cefv_l_combo','ce_id,cf_id'),
 ('catalogue_efv_long','lce_id','ce_id'),
 ('catalogue_efv_long','lcf_id','cf_id'),
 ('catalogue_efv_long_trans','cefv_lt_combo','ce_id,cf_id'),
 ('catalogue_efv_long_trans','ltce_id','ce_id'),
 ('catalogue_efv_long_trans','ltcf_id','cf_id'),
 ('catalogue_efv_long_trans','ltcv_value','cv_value'),
 ('catalogue_efv_short','#scv_value','cv_value'),
 ('catalogue_efv_short','cefv_s_combo','ce_id,cf_id'),
 ('catalogue_efv_short','iscv_value','cv_value'),
 ('catalogue_efv_short','sce_id','ce_id'),
 ('catalogue_efv_short','scf_id','cf_id'),
 ('catalogue_efv_short_trans','cefv_st_combo','ce_id,cf_id'),
 ('catalogue_efv_short_trans','stce_id','ce_id'),
 ('catalogue_efv_short_trans','stcf_id','cf_id'),
 ('catalogue_efv_short_trans','stcv_value','cv_value'),
 ('catalogue_entries','ces','ce_submitter'),
 ('catalogue_entries','ce_add_date','ce_add_date'),
 ('catalogue_entries','ce_cc_id','cc_id'),
 ('catalogue_entries','ce_c_name','c_name'),
 ('catalogue_entries','ce_validated','ce_validated'),
 ('catalogue_entries','ce_views','ce_views'),
 ('catalogue_entry_linkage','custom_fields','content_type,content_id'),
 ('chat_active','active_ordering','date_and_time'),
 ('chat_active','member_select','member_id'),
 ('chat_active','room_select','room_id'),
 ('chat_events','event_ordering','e_date_and_time'),
 ('chat_messages','ordering','date_and_time'),
 ('chat_messages','room_id','room_id'),
 ('chat_rooms','allow_list','allow_list(30)'),
 ('chat_rooms','first_public','is_im,id'),
 ('chat_rooms','is_im','is_im,room_name'),
 ('chat_rooms','room_name','room_name'),
 ('comcode_pages','p_add_date','p_add_date'),
 ('comcode_pages','p_submitter','p_submitter'),
 ('comcode_pages','p_validated','p_validated'),
 ('cron_caching_requests','c_compound','c_codename,c_theme,c_lang,c_timezone'),
 ('cron_caching_requests','c_interlock','c_interlock'),
 ('cron_caching_requests','c_in_panel','c_in_panel'),
 ('cron_caching_requests','c_is_bot','c_is_bot'),
 ('cron_caching_requests','c_store_as_tempcode','c_store_as_tempcode'),
 ('digestives_tin','d_date_and_time','d_date_and_time'),
 ('digestives_tin','d_frequency','d_frequency'),
 ('digestives_tin','d_to_member_id','d_to_member_id'),
 ('download_categories','child_find','parent_id'),
 ('download_categories','ftjoin_dccat','category'),
 ('download_categories','ftjoin_dcdescrip','description'),
 ('download_downloads','#download_data_mash','download_data_mash'),
 ('download_downloads','#original_filename','original_filename'),
 ('download_downloads','category_list','category_id'),
 ('download_downloads','ddl','download_licence'),
 ('download_downloads','dds','submitter'),
 ('download_downloads','downloadauthor','author'),
 ('download_downloads','download_views','download_views'),
 ('download_downloads','dvalidated','validated'),
 ('download_downloads','ftjoin_dcomments','comments'),
 ('download_downloads','ftjoin_ddescrip','description'),
 ('download_downloads','ftjoin_dname','name'),
 ('download_downloads','recent_downloads','add_date'),
 ('download_downloads','top_downloads','num_downloads'),
 ('download_logging','calculate_bandwidth','date_and_time'),
 ('f_emoticons','relevantemoticons','e_relevance_level'),
 ('f_emoticons','topicemos','e_use_topics'),
 ('f_forums','cache_num_posts','f_cache_num_posts'),
 ('f_forums','findnamedforum','f_name'),
 ('f_forums','f_position','f_position'),
 ('f_forums','subforum_parenting','f_parent_forum'),
 ('f_groups','ftjoin_gname','g_name'),
 ('f_groups','ftjoin_gtitle','g_title'),
 ('f_groups','gorder','g_order,id'),
 ('f_groups','hidden','g_hidden'),
 ('f_groups','is_default','g_is_default'),
 ('f_groups','is_presented_at_install','g_is_presented_at_install'),
 ('f_groups','is_private_club','g_is_private_club'),
 ('f_groups','is_super_admin','g_is_super_admin'),
 ('f_groups','is_super_moderator','g_is_super_moderator'),
 ('f_group_members','gm_group_id','gm_group_id'),
 ('f_group_members','gm_member_id','gm_member_id'),
 ('f_group_members','gm_validated','gm_validated'),
 ('f_members','#search_user','m_username'),
 ('f_members','avatar_url','m_avatar_url'),
 ('f_members','birthdays','m_dob_day,m_dob_month'),
 ('f_members','external_auth_lookup','m_pass_hash_salted'),
 ('f_members','ftjoin_msig','m_signature'),
 ('f_members','menail','m_email_address'),
 ('f_members','m_join_time','m_join_time'),
 ('f_members','primary_group','m_primary_group'),
 ('f_members','sort_post_count','m_cache_num_posts'),
 ('f_members','user_list','m_username'),
 ('f_members','whos_validated','m_validated'),
 ('f_member_custom_fields','#mcf10','field_10'),
 ('f_member_custom_fields','#mcf13','field_13'),
 ('f_member_custom_fields','#mcf14','field_14'),
 ('f_member_custom_fields','#mcf15','field_15'),
 ('f_member_custom_fields','#mcf17','field_17'),
 ('f_member_custom_fields','#mcf18','field_18'),
 ('f_member_custom_fields','#mcf19','field_19'),
 ('f_member_custom_fields','#mcf2','field_2'),
 ('f_member_custom_fields','#mcf20','field_20'),
 ('f_member_custom_fields','#mcf21','field_21'),
 ('f_member_custom_fields','#mcf22','field_22'),
 ('f_member_custom_fields','#mcf23','field_23'),
 ('f_member_custom_fields','#mcf24','field_24'),
 ('f_member_custom_fields','#mcf25','field_25'),
 ('f_member_custom_fields','#mcf26','field_26'),
 ('f_member_custom_fields','#mcf27','field_27'),
 ('f_member_custom_fields','#mcf33','field_33'),
 ('f_member_custom_fields','#mcf34','field_34'),
 ('f_member_custom_fields','#mcf35','field_35'),
 ('f_member_custom_fields','#mcf7','field_7'),
 ('f_member_custom_fields','#mcf8','field_8'),
 ('f_posts','#p_title','p_title'),
 ('f_posts','deletebyip','p_ip_address'),
 ('f_posts','find_pp','p_intended_solely_for'),
 ('f_posts','in_topic','p_topic_id,p_time,id'),
 ('f_posts','postsinforum','p_cache_forum_id'),
 ('f_posts','posts_by','p_poster'),
 ('f_posts','post_order_time','p_time,id'),
 ('f_posts','p_last_edit_time','p_last_edit_time'),
 ('f_posts','p_validated','p_validated'),
 ('f_posts','search_join','p_post'),
 ('f_post_history','phistorylookup','h_post_id'),
 ('f_read_logs','erase_old_read_logs','l_time'),
 ('f_topics','#t_description','t_description'),
 ('f_topics','descriptionsearch','t_description'),
 ('f_topics','forumlayer','t_cache_first_title'),
 ('f_topics','in_forum','t_forum_id'),
 ('f_topics','ownedtopics','t_cache_first_member_id'),
 ('f_topics','topic_order','t_cascading,t_pinned,t_cache_last_time'),
 ('f_topics','topic_order_2','t_forum_id,t_cascading,t_pinned,t_sunk,t_cache_last_time'),
 ('f_topics','topic_order_3','t_forum_id,t_cascading,t_pinned,t_cache_last_time'),
 ('f_topics','topic_order_time','t_cache_last_time'),
 ('f_topics','topic_order_time_2','t_cache_first_time'),
 ('f_topics','t_cascading','t_cascading'),
 ('f_topics','t_cascading_or_forum','t_cascading,t_forum_id'),
 ('f_topics','t_num_views','t_num_views'),
 ('f_topics','t_pt_from','t_pt_from'),
 ('f_topics','t_pt_to','t_pt_to'),
 ('f_topics','t_validated','t_validated'),
 ('f_warnings','warningsmemberid','w_member_id'),
 ('galleries','ftjoin_gdescrip','description'),
 ('galleries','ftjoin_gfullname','fullname'),
 ('galleries','gadd_date','add_date'),
 ('galleries','parent_id','parent_id'),
 ('galleries','watermark_bottom_left','watermark_bottom_left'),
 ('galleries','watermark_bottom_right','watermark_bottom_right'),
 ('galleries','watermark_top_left','watermark_top_left'),
 ('galleries','watermark_top_right','watermark_top_right'),
 ('gifts','giftsgiven','gift_from'),
 ('gifts','giftsreceived','gift_to'),
 ('group_zone_access','group_id','group_id'),
 ('hackattack','h_date_and_time','date_and_time'),
 ('hackattack','otherhacksby','ip'),
 ('images','category_list','cat'),
 ('images','ftjoin_icomments','comments'),
 ('images','iadd_date','add_date'),
 ('images','image_views','image_views'),
 ('images','i_validated','validated'),
 ('images','xis','submitter'),
 ('iotd','date_and_time','date_and_time'),
 ('iotd','ftjoin_icap','caption'),
 ('iotd','get_current','is_current'),
 ('iotd','iadd_date','add_date'),
 ('iotd','ios','submitter'),
 ('iotd','iotd_views','iotd_views'),
 ('logged_mail_messages','queued','m_queued'),
 ('logged_mail_messages','recentmessages','m_date_and_time'),
 ('member_category_access','mcamember_id','member_id'),
 ('member_category_access','mcaname','module_the_name,category_name'),
 ('member_page_access','mzamember_id','member_id'),
 ('member_page_access','mzaname','page_name,zone_name'),
 ('member_tracking','mt_id','mt_page,mt_id,mt_type'),
 ('member_tracking','mt_page','mt_page'),
 ('member_zone_access','mzamember_id','member_id'),
 ('member_zone_access','mzazone_name','zone_name'),
 ('menu_items','menu_extraction','i_menu'),
 ('messages_to_render','forsession','r_session_id'),
 ('msp','mspmember_id','member_id'),
 ('msp','mspname','specific_permission,the_page,module_the_name,category_name'),
 ('news','findnewscat','news_category'),
 ('news','ftjoin_ititle','title'),
 ('news','ftjoin_nnews','news'),
 ('news','ftjoin_nnewsa','news_article'),
 ('news','headlines','date_and_time,id'),
 ('news','nes','submitter'),
 ('news','newsauthor','author'),
 ('news','news_views','news_views'),
 ('news','nvalidated','validated'),
 ('newsletter','code_confirm','code_confirm'),
 ('newsletter','welcomemails','join_time'),
 ('newsletter_drip_send','d_inject_time','d_inject_time'),
 ('newsletter_subscribe','peopletosendto','the_level'),
 ('news_categories','ncs','nc_owner'),
 ('news_category_entries','news_entry_category','news_entry_category'),
 ('notifications_enabled','l_code_category','l_code_category'),
 ('notifications_enabled','l_member_id','l_member_id,l_notification_code'),
 ('poll','date_and_time','date_and_time'),
 ('poll','ftjoin_po1','option1'),
 ('poll','ftjoin_po2','option2'),
 ('poll','ftjoin_po3','option3'),
 ('poll','ftjoin_po4','option4'),
 ('poll','ftjoin_po5','option5'),
 ('poll','ftjoin_pq','question'),
 ('poll','get_current','is_current'),
 ('poll','padd_time','add_time'),
 ('poll','poll_views','poll_views'),
 ('poll','ps','submitter'),
 ('poll_votes','v_voter_id','v_voter_id'),
 ('poll_votes','v_voter_ip','v_voter_ip'),
 ('poll_votes','v_vote_for','v_vote_for'),
 ('quizzes','ftjoin_qstarttext','q_start_text'),
 ('quizzes','q_validated','q_validated'),
 ('rating','alt_key','rating_for_type,rating_for_id'),
 ('review_supplement','rating_for_id','r_rating_for_id'),
 ('searches_logged','#past_search_ft','s_primary'),
 ('searches_logged','past_search','s_primary'),
 ('security_images','si_time','si_time'),
 ('seedy_pages','ftjoin_spd','description'),
 ('seedy_pages','ftjoin_spt','title'),
 ('seedy_pages','sadd_date','add_date'),
 ('seedy_pages','seedy_views','seedy_views'),
 ('seedy_pages','sps','submitter'),
 ('seedy_posts','cdate_and_time','date_and_time'),
 ('seedy_posts','ftjoin_spm','the_message'),
 ('seedy_posts','posts_on_page','page_id'),
 ('seedy_posts','seedy_views','seedy_views'),
 ('seedy_posts','spos','the_user'),
 ('seedy_posts','svalidated','validated'),
 ('seo_meta','alt_key','meta_for_type,meta_for_id'),
 ('sessions','delete_old','last_activity'),
 ('sessions','the_user','the_user'),
 ('sessions','userat','the_zone,the_page,the_type,the_id'),
 ('shopping_cart','ordered_by','ordered_by'),
 ('shopping_cart','product_id','product_id'),
 ('shopping_cart','session_id','session_id'),
 ('shopping_logging','calculate_bandwidth','date_and_time'),
 ('shopping_order','finddispatchable','order_status'),
 ('shopping_order','recent_shopped','add_date'),
 ('shopping_order','soadd_date','add_date'),
 ('shopping_order','soc_member','c_member'),
 ('shopping_order','sosession_id','session_id'),
 ('shopping_order_addresses','order_id','order_id'),
 ('shopping_order_details','order_id','order_id'),
 ('shopping_order_details','p_id','p_id'),
 ('sms_log','sms_log_for','s_member_id,s_time'),
 ('sms_log','sms_trigger_ip','s_trigger_ip'),
 ('stats','browser','browser'),
 ('stats','date_and_time','date_and_time'),
 ('stats','member_track_1','the_user'),
 ('stats','member_track_2','ip'),
 ('stats','milliseconds','milliseconds'),
 ('stats','operating_system','operating_system'),
 ('stats','pages','the_page'),
 ('stats','referer','referer'),
 ('text','findflagrant','active_now'),
 ('theme_images','theme','theme,lang'),
 ('trackbacks','trackback_for_id','trackback_for_id'),
 ('trackbacks','trackback_for_type','trackback_for_type'),
 ('trackbacks','trackback_time','trackback_time'),
 ('translate','#search','text_original'),
 ('translate','decache','text_parsed(2)'),
 ('translate','equiv_lang','text_original(4)'),
 ('translate','importance_level','importance_level'),
 ('url_id_monikers','uim_moniker','m_moniker'),
 ('url_id_monikers','uim_pagelink','m_resource_page,m_resource_type,m_resource_id'),
 ('usersonline_track','peak_track','peak'),
 ('values','date_and_time','date_and_time'),
 ('videos','category_list','cat'),
 ('videos','ftjoin_vcomments','comments'),
 ('videos','vadd_date','add_date'),
 ('videos','video_views','video_views'),
 ('videos','vs','submitter'),
 ('videos','v_validated','validated');