I’ve been interested in using my MTOS powered blogs from Ruby for quite a while now. The MTOS data model is nice, but every column is prefixed with the table name suffix, which is a pain in the world of RoR.
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `entries` AS select `mtosblogs`.`mt_entry`.`entry_id` AS `id`,`mtosblogs`.`mt_entry`.`entry_allow_comments` AS `allow_comments`,`mtosblogs`.`mt_entry`.`entry_allow_pings` AS `allow_pings`,`mtosblogs`.`mt_entry`.`entry_atom_id` AS `atom_id`,`mtosblogs`.`mt_entry`.`entry_author_id` AS `author_id`,`mtosblogs`.`mt_entry`.`entry_authored_on` AS `authored_on`,`mtosblogs`.`mt_entry`.`entry_basename` AS `basename`,`mtosblogs`.`mt_entry`.`entry_blog_id` AS `blog_id`,`mtosblogs`.`mt_entry`.`entry_category_id` AS `category_id`,`mtosblogs`.`mt_entry`.`entry_class` AS `class`,`mtosblogs`.`mt_entry`.`entry_comment_count` AS `comment_count`,`mtosblogs`.`mt_entry`.`entry_convert_breaks` AS `convert_breaks`,`mtosblogs`.`mt_entry`.`entry_created_by` AS `created_by`,`mtosblogs`.`mt_entry`.`entry_created_on` AS `created_on`,`mtosblogs`.`mt_entry`.`entry_excerpt` AS `excerpt`,`mtosblogs`.`mt_entry`.`entry_keywords` AS `keywords`,`mtosblogs`.`mt_entry`.`entry_modified_by` AS `modified_by`,`mtosblogs`.`mt_entry`.`entry_modified_on` AS `modified_on`,`mtosblogs`.`mt_entry`.`entry_ping_count` AS `ping_count`,`mtosblogs`.`mt_entry`.`entry_pinged_urls` AS `pinged_urls`,`mtosblogs`.`mt_entry`.`entry_status` AS `status`,`mtosblogs`.`mt_entry`.`entry_tangent_cache` AS `tangent_cache`,`mtosblogs`.`mt_entry`.`entry_template_id` AS `template_id`,`mtosblogs`.`mt_entry`.`entry_text` AS `text`,`mtosblogs`.`mt_entry`.`entry_text_more` AS `text_more`,`mtosblogs`.`mt_entry`.`entry_title` AS `title`,`mtosblogs`.`mt_entry`.`entry_to_ping_urls` AS `to_ping_urls`,`mtosblogs`.`mt_entry`.`entry_week_number` AS `week_number`,`mtosblogs`.`mt_entry`.`entry_visit_count` AS `visit_count` from `mtosblogs`.`mt_entry`;
I’m hoping this will work.
id:integer allow_comments:boolean allow_pings:boolean atom_id:string author_id:integer authored_on:date basename:string blog_id:integer category_id:integer class:string comment_count:integer convert_breaks:string created_by:integer created_on:date excerpt:text keywords:string modified_by:integer modified_on:date ping_count:integer pinged_urls:integer status:integer tangent_cache:boolean template_id:integer text:text text_more:text title:string to_ping_urls:boolean week_number:integer visit_count:integer id:integer allow_anon_comments:boolean allow_comment_html:boolean allow_commenter_regist:boolean allow_comments_default:boolean allow_pings:boolean allow_pings_default:boolean allow_reg_comments:boolean allow_unreg_comments:boolean archive_path:string archive_tmpl_category:string archive_tmpl_daily:string archive_tmpl_individual:string archive_tmpl_monthly:string archive_tmpl_weekly:string archive_type:string archive_type_preferred:string archive_url:string autodiscover_links:boolean autolink_urls:boolean basename_limit:integer cc_license:string children_modified_on:date convert_paras:string convert_paras_comments:string created_by:string created_on:date custom_dynamic_templates:string days_on_index:index description:text email_new_comments:boolean email_new_pings:boolean entries_on_index:integer file_extension:strgin google_api_key:string internal_autodiscovery:boolean is_dynamic:boolean junk_folder_expiry:integer junk_score_threshold:float language:string manual_approve_commenters:boolean moderate_pings:boolean moderate_unreg_comments:boolean modified_by:date modified_on:date mt_update_key:string name:string old_style_archive_links:boolean ping_blogs:boolean ping_google:boolean ping_others:boolean ping_technorati:boolean ping_weblogs:boolean remote_auth_token:string require_comment_emails:boolean sanitize_spec:string server_offset:float site_path:string site_url:string sort_order_comments:string sort_order_posts:string status_default:string use_comment_confirmation:boolean welcome_msg:text words_in_excerpt:integer
