gistfile1.sql

rename table wp_posts to articles;
 
alter database wwwinfringerru_hungryshark character set utf8;
alter database wwwinfringerru_hungryshark character set utf8 collate utf8_general_ci;
 
 
alter table articles change ID id bigint(20);
alter table articles change post_content content text;
alter table articles change post_title title text;
alter table articles change title title varchar(255);
alter table articles change post_author author bigint(20);
alter table articles change post_date created_at datetime;
alter table articles change post_modified updated_at datetime;
alter table articles change post_status status varchar(20);
alter table articles change post_name slug varchar(200);
alter table articles change guid wp_url varchar(255);
alter table articles drop post_date_gmt;
alter table articles drop post_modified_gmt;
alter table articles drop post_excerpt, drop ping_status;
alter table articles drop post_password, drop post_content_filtered, drop post_parent;
alter table articles drop menu_order, drop post_mime_type, drop comment_count;
 
 
 
rename table wp_comments to comments;
 
alter table comments change comment_ID id bigint(20);
alter table comments change comment_post_ID article_id bigint(20);
alter table comments change comment_date created_at datetime;
alter table comments change comment_content content text;
alter table comments change comment_author author tinytext;
 
 
alter table wp_term_relationships change object_id post_id bigint(20);
 
 
alter table articles modify column id INT NOT NULL AUTO_INCREMENT;
alter table comments modify column id INT NOT NULL AUTO_INCREMENT;