Iron March

CREATE TABLE core_members (
  "member_id" BIGINT,
  "name" VARCHAR,
  "member_group_id" BIGINT,
  "email" VARCHAR,
  "joined" BIGINT,
  "ip_address" VARCHAR,
  "allow_admin_mails" VARCHAR,
  "skin" DOUBLE,
  "warn_level" DOUBLE,
  "warn_lastwarn" BIGINT,
  "language" DOUBLE,
  "restrict_post" BIGINT,
  "bday_day" DOUBLE,
  "bday_month" DOUBLE,
  "bday_year" DOUBLE,
  "msg_count_new" BIGINT,
  "msg_count_total" BIGINT,
  "msg_count_reset" BIGINT,
  "msg_show_notification" BIGINT,
  "misc" VARCHAR,
  "last_visit" BIGINT,
  "last_activity" BIGINT,
  "mod_posts" BIGINT,
  "auto_track" VARCHAR,
  "temp_ban" BIGINT,
  "mgroup_others" DOUBLE,
  "member_login_key_expire" BIGINT,
  "has_blog" VARCHAR,
  "has_gallery" BIGINT,
  "members_seo_name" VARCHAR,
  "members_cache" VARCHAR,
  "members_disable_pm" BIGINT,
  "failed_logins" VARCHAR,
  "failed_login_count" BIGINT,
  "members_profile_views" BIGINT,
  "members_pass_hash" VARCHAR,
  "members_pass_salt" VARCHAR,
  "members_bitoptions" BIGINT,
  "fb_uid" BIGINT,
  "members_day_posts" BIGINT,
  "live_id" VARCHAR,
  "twitter_id" VARCHAR,
  "twitter_token" VARCHAR,
  "twitter_secret" VARCHAR,
  "notification_cnt" BIGINT,
  "fb_token" VARCHAR,
  "blogs_recache" VARCHAR,
  "ipsconnect_id" BIGINT,
  "ipsconnect_revalidate_url" VARCHAR,
  "google_id" VARCHAR,
  "linkedin_id" VARCHAR,
  "pp_last_visitors" VARCHAR,
  "pp_main_photo" VARCHAR,
  "pp_main_width" DOUBLE,
  "pp_main_height" DOUBLE,
  "pp_thumb_photo" VARCHAR,
  "pp_thumb_width" DOUBLE,
  "pp_thumb_height" DOUBLE,
  "pp_setting_count_comments" DOUBLE,
  "pp_reputation_points" BIGINT,
  "pp_gravatar" VARCHAR,
  "pp_photo_type" VARCHAR,
  "signature" VARCHAR,
  "pconversation_filters" VARCHAR,
  "fb_photo" VARCHAR,
  "fb_photo_thumb" VARCHAR,
  "fb_bwoptions" DOUBLE,
  "tc_last_sid_import" DOUBLE,
  "tc_photo" VARCHAR,
  "tc_bwoptions" DOUBLE,
  "pp_customization" VARCHAR,
  "timezone" VARCHAR,
  "pp_cover_photo" VARCHAR,
  "profilesync" VARCHAR,
  "profilesync_lastsync" BIGINT,
  "google_token" VARCHAR,
  "linkedin_token" VARCHAR,
  "live_token" VARCHAR,
  "members_bitoptions2" BIGINT,
  "create_menu" VARCHAR,
  "marked_site_read" BIGINT,
  "pp_cover_offset" BIGINT,
  "acp_skin" DOUBLE,
  "acp_language" DOUBLE,
  "member_title" VARCHAR,
  "member_posts" BIGINT,
  "member_last_post" DOUBLE,
  "member_streams" VARCHAR,
  "photo_last_update" DOUBLE,
  "pp_setting_count_visitors" BIGINT,
  "pp_xbox" VARCHAR,
  "failed_mfa_attempts" BIGINT,
  "mfa_details" VARCHAR,
  "permission_array" VARCHAR
);

CREATE TABLE core_message_topics (
  "mt_id" BIGINT,
  "mt_date" BIGINT,
  "mt_title" VARCHAR,
  "mt_hasattach" BIGINT,
  "mt_starter_id" BIGINT,
  "mt_start_time" BIGINT,
  "mt_last_post_time" BIGINT,
  "mt_to_count" BIGINT,
  "mt_to_member_id" BIGINT,
  "mt_replies" BIGINT,
  "mt_first_msg_id" BIGINT,
  "mt_is_draft" BIGINT,
  "mt_is_deleted" BIGINT,
  "mt_is_system" BIGINT
);

CREATE TABLE forums_posts_edited (
  "pid" BIGINT,
  "append_edit" BIGINT,
  "edit_time" DOUBLE,
  "author_id" BIGINT,
  "author_name" VARCHAR,
  "ip_address" VARCHAR,
  "post_date" BIGINT,
  "icon_id" VARCHAR,
  "post" VARCHAR,
  "queued" BIGINT,
  "topic_id" BIGINT,
  "post_title" VARCHAR,
  "new_topic" BIGINT,
  "edit_name" VARCHAR,
  "post_key" VARCHAR,
  "post_htmlstate" BIGINT,
  "post_edit_reason" VARCHAR,
  "post_bwoptions" BIGINT,
  "pdelete_time" BIGINT,
  "post_field_int" BIGINT,
  "post_field_t1" VARCHAR,
  "post_field_t2" VARCHAR
);

CREATE TABLE message_posts_edited (
  "msg_id" BIGINT,
  "msg_topic_id" BIGINT,
  "msg_date" BIGINT,
  "msg_post" VARCHAR,
  "msg_post_key" VARCHAR,
  "msg_author_id" BIGINT,
  "user_name" VARCHAR,
  "msg_ip_address" VARCHAR,
  "msg_is_first_post" BIGINT
);

CREATE TABLE orig_members (
  "member_id" BIGINT,
  "name" VARCHAR,
  "member_group_id" BIGINT,
  "email" VARCHAR,
  "joined" BIGINT,
  "ip_address" VARCHAR,
  "posts" BIGINT,
  "title" VARCHAR,
  "allow_admin_mails" BIGINT,
  "time_offset" DOUBLE,
  "skin" DOUBLE,
  "warn_level" DOUBLE,
  "warn_lastwarn" BIGINT,
  "language" BIGINT,
  "last_post" DOUBLE,
  "restrict_post" DOUBLE,
  "view_sigs" BIGINT,
  "view_img" BIGINT,
  "bday_day" BIGINT,
  "bday_month" BIGINT,
  "bday_year" BIGINT,
  "msg_count_new" BIGINT,
  "msg_count_total" BIGINT,
  "msg_count_reset" BIGINT,
  "msg_show_notification" BIGINT,
  "misc" VARCHAR,
  "last_visit" BIGINT,
  "last_activity" BIGINT,
  "dst_in_use" BIGINT,
  "coppa_user" BIGINT,
  "mod_posts" DOUBLE,
  "auto_track" VARCHAR,
  "temp_ban" DOUBLE,
  "login_anonymous" VARCHAR,
  "ignored_users" VARCHAR,
  "mgroup_others" DOUBLE,
  "org_perm_id" DOUBLE,
  "member_login_key" VARCHAR,
  "member_login_key_expire" BIGINT,
  "has_blog" VARCHAR,
  "has_gallery" BIGINT,
  "members_auto_dst" BIGINT,
  "members_display_name" VARCHAR,
  "members_seo_name" VARCHAR,
  "members_created_remote" BIGINT,
  "members_cache" VARCHAR,
  "members_disable_pm" BIGINT,
  "members_l_display_name" VARCHAR,
  "members_l_username" VARCHAR,
  "failed_logins" VARCHAR,
  "failed_login_count" BIGINT,
  "members_profile_views" BIGINT,
  "members_pass_hash" VARCHAR,
  "members_pass_salt" VARCHAR,
  "member_banned" BIGINT,
  "member_uploader" VARCHAR,
  "members_bitoptions" BIGINT,
  "fb_uid" BIGINT,
  "fb_emailhash" VARCHAR,
  "fb_lastsync" BIGINT,
  "members_day_posts" BIGINT,
  "live_id" VARCHAR,
  "twitter_id" VARCHAR,
  "twitter_token" VARCHAR,
  "twitter_secret" VARCHAR,
  "notification_cnt" BIGINT,
  "tc_lastsync" BIGINT,
  "fb_session" VARCHAR,
  "fb_token" VARCHAR,
  "ips_mobile_token" VARCHAR,
  "unacknowledged_warnings" VARCHAR,
  "blogs_recache" VARCHAR,
  "ipsconnect_id" BIGINT,
  "ipsconnect_revalidate_url" VARCHAR
);

CREATE TABLE orig_message_topics (
  "mt_id" BIGINT,
  "mt_date" BIGINT,
  "mt_title" VARCHAR,
  "mt_hasattach" BIGINT,
  "mt_starter_id" BIGINT,
  "mt_start_time" BIGINT,
  "mt_last_post_time" BIGINT,
  "mt_invited_members" VARCHAR,
  "mt_to_count" BIGINT,
  "mt_to_member_id" BIGINT,
  "mt_replies" BIGINT,
  "mt_last_msg_id" BIGINT,
  "mt_first_msg_id" BIGINT,
  "mt_is_draft" BIGINT,
  "mt_is_deleted" BIGINT,
  "mt_is_system" BIGINT
);

CREATE TABLE orig_topics (
  "tid" BIGINT,
  "title" VARCHAR,
  "description" VARCHAR,
  "state" VARCHAR,
  "posts" BIGINT,
  "starter_id" BIGINT,
  "start_date" BIGINT,
  "last_poster_id" BIGINT,
  "last_post" BIGINT,
  "icon_id" DOUBLE,
  "starter_name" VARCHAR,
  "last_poster_name" VARCHAR,
  "poll_state" BIGINT,
  "last_vote" BIGINT,
  "views" BIGINT,
  "forum_id" BIGINT,
  "approved" BIGINT,
  "author_mode" BIGINT,
  "pinned" BIGINT,
  "moved_to" VARCHAR,
  "topic_hasattach" BIGINT,
  "topic_firstpost" BIGINT,
  "topic_queuedposts" BIGINT,
  "topic_open_time" BIGINT,
  "topic_close_time" BIGINT,
  "topic_rating_total" BIGINT,
  "topic_rating_hits" BIGINT,
  "title_seo" VARCHAR,
  "seo_last_name" VARCHAR,
  "seo_first_name" VARCHAR,
  "topic_deleted_posts" BIGINT,
  "tdelete_time" BIGINT,
  "moved_on" BIGINT,
  "last_real_post" BIGINT,
  "topic_archive_status" BIGINT,
  "topic_answered_pid" BIGINT
);